HomeMy WebLinkAboutComcast Franchise Fee Report - 1st Qtr 2010
Comcast® Comcast Cable
15815 25th Ave West
Lynnwood, WA 98087
April 28, 2010
SENT VIA OVERNIGHT MAIL
Ms. Lorrie Rempher
City of Auburn
25 West Main St
Auburn, WA 98001
RE: Franchise Fee Report - First Quarter 2010
Dear Ms. Rempher:
In accordance with our franchise agreement with the City of Auburn, please find enclosed
the franchise fee report for First Quarter 2010. The figures reported herein should be
consistent with the franchise fee check you received from our corporate office in Denver,
Colorado.
If you have any questions about your franchise fee check or the attached report, please
feel free to contact me at (425) 741-5752.
Sincerely,
4x 'e/ -
Ann Svensson
Franchise Contracts Administrator
Comcast - WA Market
Encls.
cc: Danielle Daskam, City of Auburn
Janet L. Turpen, Comcast
Ken Rhoades, Comcast
Terry Davis, Comcast
Bradley & Guzzetta, LLC
OPERATOR: City of Auburn
Comcast Period From 1/1/2010 - 3/31/2010
15815 251th Avenue W
Lynnwood, WA 98087 FRANCHISE FEE PAYMENT WORKSHEET
UNITS UNIT PRICE MONTHS IN GROSS FEE % FRANCHISE YTD
REVENUE SOURCE (AVE OF PER) (EACH MO) PERIOD REVENUE FEE
Installation-(Including Digital) 1,036 $16.06 3 49,914.22 5 2,495.71 2,495.71
Rate Card Price
$14.52 Limited Cable Service* 17,075 $11.82 3 605,379.74 5 30,268.99 30,268.99
$42.93 Expanded Cable Service* 14,902 $36.17 3 1,616,984.52 5 80,849.23 80,849.23
$16.99 Special Interest (Digital)** 14,952 $17.50 3 784,838.36 5 39,241.92 39,241.92
$17.99 HBO Customers 2,962
$17.99 Showtime Customers 1,553
$17.99 Cinemax Customers 727
$17.99 TMC Customers 343
$17.99 Starz! Customers 1,987
$16.99 Encore Customers 117
Total Premium 7,689 $9.72 3 224,156.29 5 11,207.81 11,207.81
$4.99344.95 Pay-Per-View 11,117 $5.90 3 196,919.87 5 9,845.99 9,845.99
$1.00 Standard Converters 0
69.20 Addressable Converters 18
$3.20to$8.00 Digital Converters 23,545
$0.15 Remote Units 23,027
Total Equipment 46,589 $0.07 3 9,251.84 5 462.59 462.59
TOTAL SERVICE/INSTALL INCOME 3,487,444.85 5 174,372.24 174,372.24
Advertising Revenue 171,084.77 5 8,554.24 8,554.24
Shopping Services 33,481.83 5 1,674.09 1,674.09
$3.50 Guides 286 $3.54 3 3,036.22 5 151.81 151.81
Late Fees 37,980.68 1,899.03 1,899.03
Miscellaneous 20,385.02 5 1,019.25 1,019.25
TOTAL NON-SUBSCRIBER INCOME 265,968.52 5 13,298.43 13,298.43
Less Refunds/Bad Debts (66,657.16) 5 (3,332.86) (3,332.86)
Plus Bad Debt Recovery 0.00 5 0.00 0.00
NET BAD DEBTS (66,657.16) 5 (3,332.86) (3,332.86)
TOTAL REVENUES 3,686,756.21 5 184,337.81 184,337.81
Franchise Fee Revenue 193,893.33 5 9,694.67 9,694.67
Adjustments*
TOTAL DUE CITY 3,880,649.54 5 194,032.48 194,032.48
EXPLANATORY NOTES:
* All Limited and Expanded Basic Service revenues are recorded as Standard Cable, Bulk/Comm'I revenue category.
This includes revenue for Digital Additional Outlets as well as Bulk/Commercial Additional Outlets
Send to: Prepared by: Ann Svensson
City of Auburn
Title: Franchise Contracts Administrator
Date: 28-Apr-10
p€^ F vn'n~nm-€~€~'~~ff o 2E222> 2F2? > 22 >
~4 - 4W4~ w4 eMH eke. s g
W a4 4x4 44444 .:4$ 44 s
o W w
e 4Ws w4 444444 4444 44 4
4 s4 W~ 444444 4444 4 44 1
~O se 4W. W~ see444 4444 4.
Z
Him c €€€ff €€€ff ff €
c
a 4~4 x4 44444 444 $ 44
L_L o
r _
D~ d4 ' 444
V ~4 4w4 ~ 44444 ~ 4e ~
4„4 ~4 a 44444 4444 $ 44 e
~4 4~4 x~ ~ s44s44 4444 ~ 44 4
€ff > €€€e€ff €€€@ e
=4 4~4 x4 ~ 444444 444a ~ 44 ~
Z 1 €€€€€ff € €
€ € ff
4;s „g 44444 44
E~ ~.Fxrppn ^~m a. K5 spa 6€ a xz °
Y 6. Vi m. ° .m°9 k.3 1H 'M S U
c W w
6 S! P, 4 PP;; ^a a:. ~ff~. s: x
8; R R ~ N5'n8~~ 2 H: d
S; W 2
s~
? BS R £XA~S:RR R6e R, Fk 6 8658 5 s p
~8 W" $ W W
5 g~ ~8
W x a a°Wi u o
rZw X~Y Su~S~rz~ aS~i° O
LL ~ ~~LLm~~a ~ ~a`sa~xLL~=sz>oas " ~~sae ~~s ~
min
V ( o€ €g€ €€€€€0 'e € e€€€ €
W E ^z z a mill z22 zzzZZ z z
z°. Ke x~ 4~4~4 eeE ~ ~e °
w w o
U
O w
rO 's4 ~„s w~ ~ E€Q~~g se~~ ~ PQ Q
Z
Q ~e w@ 15 a Y 2 i H i 4
`o
Z o ~
O
Z IN V I IN P 15 HIM flu
o o ~
sxe ~6 MM H11 ~ H Q ~
w w o
HHU
z x,~ z ~zz> i
z z z
~z>
=s sx.
seg set s e e
0 0 ~
HIM 11! 11 1
8m 8_8SF ^°3~ 88S F!S a8~ 586 ~ RS
o w w o
Si A'Km"8i6° ~pS :8 ~0 ry86S 6. "S 8
3 # ry
3 w w
z ~ ~ ~ger ~ ~ ~ffi~Y~gm¢~a~~Q`~~`w gg~oa¢~ o<$o .
u w ~~LLdSwo Y' ~~F~~C~w zz"'~`oaa5 ~o d w
i n -"ggax~ E
t L$ ~u,e `„_"'<^+£5~~~~g o FFEQQF F~f~ E f2 E
~ t essee~ e~~e ~ s ~ ~
~ w w
U oe eta `o 111111 1111 a ee e e
W =1 91 a 991111 1111 9 e1 1
~ o w w
V o
J iz IIe eeeae; eQee a ee
911191 ~~~i ~ 9e 9
~ w ~
e ewe 0e 111991 eele e 11 1
0 w
LZ „ zZ..off @~ff➢~e
0 ~8 QxQ 99eee1 1 ee e
z
J oe e~~ 5e c
e ~
Q 111111911 1 111 111! 1 a1 1 ~1 € 1
_Q : 99 Ke 11 e
L o w w o
r
Z ~
W 111111 €eee ~ N ee
0 ~9 e~9 ~ 119999 1199 ~ 11 9
LJ. ~
Z fig........ Q~2 ~L€ > eee@ff ¢'e ee€e e
O ~e e~9 #1 ~ 199191 9911 1 N 19 e
/ 1 w
it g'~eg i eeeel9 111111 11 11111 It g
1K9 511 1 1 ee 9
~ o a y
a9 1x1 ie = 111111 fill it 9 £1 1 e
w w ,
E. g~g.y°ye ~ gggeeg eerie e ^ @e
1 1x1 911111 1111 e ee 1
se gee gggegg~ eeeg e " ee e
•1 Qoe 01 = 911111 1111 9 e9 e
e a~~ ~g ~ eegggg eegt a ee g
~9 Q~9 ~1 ~ 191111 1111 9 e9 1
RC 'g°fl~„ARC Y $RR R~§6 A
E w o
g==
: ~ °d a R
E$ 3'Y p~x$sRw8^mw' ~R. RS °RF °
w w
R
Y
2 t ~ ~ w o ~ ~ ~Wyy
g a o o v ug 4
W
s zw ~t ~
m~~ m&ow4¢u~z.sa~s`oo.
F x asxa~vp~ 8
~2 "°"'h"2~2~~~e ~ 2 22> 222 F 22 ~ 2
U oQ z2 e o z 22> ~zz> tYt =2 z Z
W a W4 a 4 P4$8B$ k 4 4
u `o a
V
LL o
Fir F e~@ff @ ~C e
Z
Q a ~ ilLIll liL$ I 14
c w o
Z o €
LU IF F 2 s aaa~a6 saa~ ~a e
u- ~
Z aIa€ a as a
e
IN F~ti ~'e a~~E~e111 1~~pF ~ " ge
e 59111111
0
$LQ ess
w o
a w
wee 9gt w ~ff~~z~22F ff2@2~' ~ " ei~
0y~
e ~~fft 5EL s HIM Q11~ tQ 2ff
.~H HUM g @~~ 5> B~@~ge e4tiet i ~4 B
w w o
y R 8 a
■ a~. a
-a. msa"s ~ ~ ms °
w w
:s.,•~aema:~ cma R s: a ~c8x ~ ~ ~a
~ t
~gg~o ~ w w
f ~E~gRa $ a & ~
4 i s3
zl,
_ .Q ~Offi rL gO `~W•G Q6 ¢F H w
W2~'~(a'„6~~k'~"
~zm m
1¢i. [ musS"c a ¢o wgw`u".u ^3ai0i~$ 1-M
