HomeMy WebLinkAboutCAG1993-0577 - Other - Franchise Fee Report - 07/30/2007 I
Ccomcast Comcast Cable
P.O.Box 3042
Suite 200
Bothell,WA 98041-3042
July 30, 2007
SENT VIA OVERNIGHT UPS
Brenda Jacober
City of Kent
220 Second Ave S
Kent, WA 98032
RE: Franchise Fee Report - Second Quarter 2007
Dear Ms. Jacober:
In accordance with our franchise agreement with the City of Kent, please find enclosed
the franchise fee report for Second Quarter 2007. 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,
Ann Svensson
Franchising Contracts Administrator
Comcast—WA Market
Encls.
cc: Janet L. Turpen, Comcast
Ken Rhoades, Comcast
Terry
/Davis, Comcast
cvt.X--"�-,.►
OPERATOR: City of Kent
Comcast Period From 4/1/07-6/30/07
19909 120th Ave NE,Suite 200
Bothell,WA 98011 FRANCHISE FEE PAYMENT WORKSHEET
UNITS UNIT PRICE MONTHSIN GROSS FEE% FRANCHISE YTD
REVENUE SOURCE (AVE OF PER) (EACH MO) PERIOD REVENUE FEE
Installation-(Including Digital) 1,364 $16.02 3 65,533.74 5 3,276.69 6,711.10
Rate Card Price
$14.14 Limited Cable Service 24,096 $11.06 3 799,509.57 5 39,975.48 80,804.61
$35.11 Expanded Cable Service* 19,885 $32.82 3 1,957,991.90 5 97,899.60 195,750.28
$11.99 Special Interest(Digital) 13,502 $16.41 3 664,740.01 5 33,237.00 65,478.10
$15.99 HBO Customers 4,403
$15.99 Showtime Customers 1,285
$15.99 Cinemax Customers 1,014
$15.99 TMC Customers 875
$15.99 Starz!Customers 2,565
$15.99 Encore Customers 1,174
Total Premium 11,315 $9.01 3 305,787.18 5 15,289.36 30,431.74
$3.99•$44.95 Pay-Per-View 9,339 $10.21 3 286,008.64 5 14,300.43 26,945.45
$1.10 Standard Converters 50
$3.80 Addressable Converters 221
$3.80•$6.50 Digital Converters 20,784
$0.15 Remote Units 20,699
Total Equipment 41,753 $0.02 3 2,625.31 5 131.27 256.78
TOTAL SERVICE/INSTALL INCOME 4,082,196.35 5 204,109.82 406,378.06
Advertising Revenue 277,010.39 5 13,850.52 24,511.71
Shopping Services 45,083.13 5 2,254.16 3,805.44
$3.45 Guides 695 $3.47 3 7,227.93 5 361.40 737.41
Late Fees 36,440.60 1,822.03 3,680.78
Miscellaneous 13,759.52 5 687.98 998.21
TOTAL NON-SUBSCRIBER INCOME 379,521.57 5 18,976.08 33,733.56
Less Refunds/Bad Debts (116,543.44) 5 (5,827.17) (10,993.32)
Plus Bad Debt Recovery 0.00 5 0.00 0.00
NET BAD DEBTS(-) (116,543.44) 5 (5,827.17) (10,993.32)
TOTAL REVENUES 4,345,174.48 5 217,258.72 429,118.29
Franchise Fee Revenue 243,557.19 5 12,177.86 24,332.90
Adjustments*
TOTAL DUE CITY 4,588,731.67 5 229,436.58 453,451.19
EXPLANATORY NOTES:
*All Limited Cable Bulk/Comm'I revenues are recorded in the Expanded Basic revenue category.
**This includes revenue for Digital Additional Outlets as well as Bulk/Commercial Additional Outlets
The customer information is for Digital Additional Outlets only.
Send to: Prepared by: Ann Svensson
City of Kent Authorized by: au"
Title: Franchise Contracts Administrator
Date: Hwy 30,2007
N O� O N O N•-m 0 0 Q CO CD N N Of O n m N t0
O Q O N m O n CO m O N O N N N Q n
NIm of cO�N m O1 ' O J Ofm ' n NO Of cOQ �+1 O y�j QM
FAO N�ON�DrN O WO NOQ� �D Nc nm16 O16 O m a OQ
Q��p N N C7 16 Q Q m of c+0 oNo Q m m '-O tD m l O O� N Nyy N N
O m �n
0 of X m of
r W
r o m rn m Q o rn m Q r rn m m N o n a m N N u�i
O m N rn n tD N u) O O Q N N m
JmO OO�Q nn m0 Nn CO 8
aD Q n m2 Q OSON
pp Q N T N N N m Q m l+D O m J N N n 0 00 (") N E n 4)N Q Q
Q N n 1p O N N N N N n 0 IG a m 0 Of 0 m O�"O Ld CO
~10 01 N n Q m n N O 0 O�VJ'd tp H N n N N N
0`m . N o m: N N N O m Q N O N N IA f9
~ w ~O
� Nmoo+n no v� o r v�� aoow oQnn � e on ,`�
o�n nom�ov{p mn
Nf� ' NOf ADO tO NN NONmO� ' O OO ONn NO-N O N n N O
n m tp�TN tom O W C) m n Q cOQO m O CO O�
W N n e-O N N m O Q" O W Ori O N N Q n
_ O N Q GO N O 01 O j e- lD N W n y9
X �
W
N
m0 NQnOO�u)O mON m ON OCOO V Nzw o
n NOQmm tD� Qn CO m� QQ OCO NN O .9
O V7 ' m O)Ol ON OO N m�� ' On ' m-0 NON if11n M
m0 Ott On N902 T� N OQO CO ON N O u1 NO n
Nm u7 c0ONnQ Q m W NOS � O '-n OI m--� � �
}n l0 N N-7 0 N N
U w
X
W
CDO nQ n�O(D�.-O CO cp V) NN COI Yf N W i o < o Q O
wO� ONUl tO f�Q n 0 N TCO t't o?� mQT �O
O<G ' N16IS O CV 060'i6 Oi N n O O,1 n 00� V
O a0 N a0 O O N VI tD W y p O) b ow� :O m O n 0p N N O N
'� JtOm Q NQNNQ n O0�O l`�N b J N Qn 0 Q O O m
c n �Lri N ND N N N W. m m v N IN
QN N O EO N U O Ol d a.
X r fA
W
N N Of O N N O tD O N O� Of CO W O W♦ O n C m � N O� �p�p p
OO Q>c7nNOm�0 Qtp Yi n c0 OOn <O>N OD Q
mN ' OmtOOOCON a0n 0 ' N mtON OOP
J N cV N Q O N a0 n 0 N QQ O O J m O n 01 N (4 Q N N N N l0 0 0
QmN mV700 N Iq W CDm O Otn Napo �N mt0 Q Q
F mtD QQNA Q mn On 0 N NN IG H OO '"mom N- 1'f 0 60 N N
0 0 Q N Q t0 m O In m O N m lD U) Q N N
r CO t0 O N U m N N N V3 IA
F W (�
Q
D7 O m Q N n CO O O pQ OI O N N n M mw m 0 N o N
m N O O m
NCO ' m (D O mO0 n N ' tp n rn Nt0 O1N w N O O N m
NO> Qn i(1 tnN�mn W NQQ m Yf Q Q mOl Y1 n Om cc n N m
=NO NCO COQ mQ m00 N mm m U NO n0 e0r ^ ON N
U c0< O 07�O(V NCO N mm N Nr�O O (M n
XH
W
n Q}�jQmmmnOrn ' O�QQ1 0�N0m0 monm 00 oO n.O-m
00mmm 10 N 6NMN, m CONK
I-L wON hWm cl -
t0 ) n "I" It
< tcmnc
W W 'm H
LL
tpn Omtp Qinm Of O m00 O OQ NNN ap 1� mCO-R a mQ
O� N N m CO N m m 0 D7(O m CO N Q N l0 01 O CO O t0 N
vi cc r��N ri�n vi of o n vi vi ri of o ad ri ao n a � o �ri Sri rn
m n In N N(n m m N` tD m n N Qf CO N n 0 m Ol N O m N n p
I CONnN N Q n 01 CO 01 Ot0 N O""r'1 Q O C
} m N N (QO COO N N w } CO— N Q1 n O m f9 F
q
o j j u9 LL
Z O W Z J
Wok Q X
YY o Q W 00
LL pyg 7(D O
0190} N 00}
mN {Tp{O0 y r'1
n Q U c0 N m C a yqy
m W m m m
w � a�
U 0 N
O
J tC`V IC`p ?Q 0
W F N Q H N 0
O n N W
W O W Z O m y
Z U W U
Z ~ W < W O a W
W C Z z W = T Q N
W O D W > O Z W W ud
ZU. 00 m QW ZWO U W K ) W W _LLN
' C y O WQ 7
J O W
LL
LJ
VaD > > W NQ F- Z -W Vl J U JLL W a 2 ix
U W >Q O Ix QSQ WW Z 2 ) m W > ZWwo'WWO = U � 0 OO a Q Q> OWWWOWwQ OmWWJW m y OZ>o W��<W a W mpO mFW >XH 0 <UO W JQ
ZQ ¢ U0 � QaZZ � W Q
W LL WUW= M Z aO Q XX ZW 0 07 0 w oaivw Oa �= 0 iWM ON 0 U OHUZ } U�OV } WgU U 0 ? 1-QQ W SQF- 0 < W W
Z Z�J 700
v) WWL,mr0LL N mm0 W W ?0aa m C4 u0
J m (A (A Vl