Loading...
HomeMy WebLinkAboutCAG1993-0577 - Other - Franchise Fee Report - 04/28/2011 Comcast Cable Ccomcast, 15815 25th Ave West Lynnwood,WA 98087 April 28, 2011 SENT VIA OVERNIGHT MAIL Brenda Jacober City Clerk City of Kent 220 4`h Ave S Kent, WA 98032 RE: Franchise Fee Report—First Quarter 2011 Dear Ms. Jacober: In accordance with our franchise agreement with the City of Kent, please find enclosed the franchise fee report for First Quarter 2011. The figures reported herein should be consistent with the franchise fee check you received from our Division 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, a4,(- Ann Svensson Franchise Contracts Administrator Comcast—WA Market Encls. cc: Dea Drake, City of Kent Janet L. Turpen, Comcast Ken Rhoades, Comcast Terry Davis, Comcast 4 L-4-1� OPERATOR: City of Kent Conrcast Period From 1/1/11-3/31/11 s»0 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,523 '. 3 73,205.66 5 3,660.28 3,660.28 Rate Card Price Limited Cable Service 27,352 $12.02 3 986,687.21 5 49,334.36 49,334.36 ;;. Expanded Cable Service* 23,164 $36.24 3 2,518,450.68 5 125,922.53 125,922.53 $16.99•$67.99 Special Interest(Digital) 24,486 $19.02 3 1,397,202.04 5 69,860.10 69,860.10 $1&99 HBO Customers 7,135 $18.99 Showtime Customers 2,961 $18.99 Cinemax Customers 1,199 $1&99 TMC Customers 374 $18.99 Starz!Customers 5,188 $16.99 Encore Customers 147 Total Premium 17,003 $10.00 3 509,967.15 5 25,498.36 25,498.36 $4.99$"-% Pay-Per-View 14,734 $6.52 3 288,117.10 5 14,405.86 14,405.86 $0.95 Standard Converters 1 $2.50 Addressable Converters 9 $2.59 Digital Converters 38,780 $0.20 Remote Units 31,923 Total Equipment 70,713 $0.16 3 33,396.71 5 1,669.84 1,669.84 TOTAL SERVICE/INSTALL INCOME 5,807,026.55 5 290,351.33 290,351.33 Advertising Revenue 251,872.01 5 12,593.60 12,593.60 Shopping Services 43,166.41 5 2,158.32 2,158.32 $3.50 Guides 380 $3.55 3 4,048.28 5 202.41 202.41 Late Fees 82,129.36 4,106.47 4,106.47 Miscellaneous 61,503.37 5 3,075.17 3,075.17 TOTAL NON-SUBSCRIBER INCOME 442,719.43 5 22,135.97 22,135.97 Less Refunds/Bad Debts (122,449.78) 5 (6,122.49) (6,122.49) Plus Bad Debt Recovery 0.00 5 0.00 0.00 NET BAD DEBTS(-) (122,449.78) 5 (6,122.49) (6,122.49) TOTAL REVENUES 6,127,296.20 5 306,364.81 306,364.81 Franchise Fee Revenue 339,382.03 5 16,969.10 16,969.10 Adjustments* TOTAL DUE CITY 6,466,678.23 5 323,333.91 323,333.91 EXPLANATORY NOTES: Send to: Prepared by: S ensson City of Kent W Title: Franchise Contracts Administrator Date: April 27,2011 CONFIDENTIAL NOT FOR PUBLIC RECORD SECTION 1-GENERAL INFORMATION ENTITY NAME: AUBURN ENTITY NUMBER: 776 FRANCHISE NAME: CITY OF KENT BILLING AREA: 6498 3400 0080 VENDOR#/SITE CODE 149138 220 4TH AVE YEAR/TERM: 2011/QUARTERLY DAYS DUE: 30 DAYS FRANCHISE EXCLUSIONS: Internet SECTION 2-SUBSCRIBER REVENUE Description JANUARY FEBRUARY MARCH OTR TOTAL BAD DEBT/WRITE-OFFS (54,069,27) (36,988.63) (31,391.88) (122,449. 88) BASIC CABLE 324,888.42 328,440.72 333,358.07 986,687.21 BOTTOM OF THE BILL DISCOUNT - - - - DIGITAL CABLE 455,747.64 465,520.63 475,933.77 1,397,202.04 EQUIPMENT REVENUE 16,127.04 7,206.09 10,063.58 33,396.71 EXPANDED BASIC 838,126.39 835,098.05 845,226.24 2,518,450.68 FCC FEE REVENUE 1,949.00 1,963.27 1,963.95 5,876.22 FRANCHISE FEE REVENUE 111,684.56 113,608.96 114,088.51 339,382.03 GUIDE REVENUE 1,376.18 1,354.56 1,317.54 4,048.28 INSTALLATION REVENUE 16,879.57 30,376.50 25,949.59 73,205.66 LATE FEE REVENUE 28,303,96 27,662.98 26,162A2 82,129.36 INTERNET REVENUE EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE 21,796.92 16,194.83 17,635.40 - 55,627.15 PAY REVENUE 168,121.35 168,081.86 173,763.94 509,967.14 PAY PER VIEW REVENUE 95,078.65 100,061.88 92,976.57 288,117.10 UTILITY TAX - - SUBSCRIBER REVENUE TOTAL 2,026,010.40 2,058,581.69 2,087,047.70 6,171,639.80 SECTION 3-ALLOCATED REVENUE JANUARY FEBRUARY MARCH OTR TOTAL SHOPPING COMMISSIONS 11,112.02 11,769.26 15,169.06 38,050.35 LEASED ACCESS 763.86 544.04 885.78 2.193.68 OTHER COMMERCIAL LEASED ACCESS - - - OTHER REVENUE 76.93 234.95 - 311.87 TOWER&RENTAL INCOME 809.96 814.14 986.40 2,610.51 ALLOCATED REVENUE TOTAL 12,762.77 13,362.39 17,041.25 43,166.40 LOCAL ADVERTISING 57,272.67 48,117.50 52,209.98 157,600.16 NATIONAL ADVERTISING 40,705.25 28,314.75 25,506.67 94,526.67 BAD DEBT ON ADVERTISING 119.79 35.33 (409.94) (254.82) ADVERTISING REVENUE TOTAL 98,097.71 76,467.59 77,306.71 251,872.01 SECTION 4-TOTAL REVENUE $2,136,870.88 $2,148,411.67 $2,181,395.66 $6,466,678.21 SECTION 5-FRANCHISE TAX q 5,00% 5,00% 5.00% Cable franchise fee 101,438.66 103,597.20 105,204.45 310,740.31 Ad sales franchise fee 4,904.89 3,823.38 3,865.34 12,593.60 SECTION 6-TOTAL FRANCHISE FEE DUE $106,843.54 $107,420.58 $109,069.78 $323,333.91 Amount Paid Over/Under $323,333.91