Loading...
HomeMy WebLinkAboutCAG1993-0577 - Other - Franchise Fee Report - 07/27/2011 Comcast Cable Ccomcasto 15815 25th Ave West Lynnwood,WA 98087 July 27, 2011 SENT VIA OVERNIGHT MAIL Brenda Jacober City Clerk City of Kent 220 4th Ave S Kent, WA 98032 RE: Franchise Fee Report— Second Quarter 2011 Dear Ms. Jacober: In accordance with our franchise agreement with the City of Kent, please find enclosed the franchise fee report for Second 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, a�� 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 OPERATOR: City of Kent Comcast Period From 4/1/11-6/30/11 15815-25th Ave W Lynnwood,WA98087 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,736 $16.02 3 83,434.10 5 4,171.71 7,831.99 Rate Card Price $1523 Limited Cable Service 27,389 $12.09 3 993,557.36 5 49,677.87 99,012.23 $45.76 Expanded Cable Service* 22,993 $36.15 3 2,493,586.77 5 124,679.34 250,601.87 $16.99-$67.99 Special Interest(Digital) 24,186 $19.65 3 1,425,629.50 5 71,281.48 141,141.58 $18.99 HBO Customers 6,820 $18.99 Showtime Customers 2,516 $18.99 Cinemax Customers 1,250 $18.99 TMC Customers 348 $18.99 Starz!Customers 5,367 $16.99 Encore Customers 138 Total Premium 16,440 $10.65 3 525,076.66 5 26,253.83 51,752.19 $4.99-$44.95 Pay-Per-View 13,562 $7.31 3 297,441.98 5 14,872.10 29,277.95 $0.95 Standard Converters 1 $2S0 Addressable Converters 8 $2.50 Digital Converters 37,023 $020 Remote Units 38,780 Total Equipment 75,812 $0.11 3 24,106.52 5 1,205.33 2,875.16 TOTAL SERVICE/INSTALL INCOME 5,842,832.89 5 292,141.64 582,492.97 Advertising Revenue 261,756.10 5 13,087.81 25,681.41 Shopping Services 45,699.22 5 2,284.96 4,443.28 $3.50 Guides 370 $3.51 3 3,888.96 5 194.45 396.86 Late Fees 83,187.12 4,159.36 8,265.82 Miscellaneous 66,503.33 5 3,325.17 6,400.34 TOTAL NON-SUBSCRIBER INCOME 461,034.73 5 23,051.74 45,187.71 Less Refunds/Bad Debts (130,643.16) 5 (6,532.16) (12,654.65) Plus Bad Debt Recovery 0.00 5 0.00 0.00 NET BAD DEBTS(-) (130,643.16) 5 (6,532.16) (12,654.65) TOTAL REVENUES 6,173,224.46 5 308,661.22 615,026.03 Franchise Fee Revenue 340,817.33 5 17,040.87 34,009.97 Adjustments* TOTAL DUE CITY 6,514,041.79 5 325,702.09 649,036.00 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: An ensson City of Kent Title: Franchise Contracts Administrator Date: July 27,2011 CONFIDENTIAL NOT FOR PUBLIC RECORD FRANCHISE FEE-REVENUE SECTION 1-GENERAL INFORMATION ENTITY NAME: AUBURN ENTITY NUMBER: 776 FRANCHISE NAME: CITY OF KENT BILLING AREA: 8498 3400 0000 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 QTR TOTAL APRIL MAY JUNE QTR TOTAL BAD DEBT/WRITE-OFFS 1 (54,069.27) (36,988.63) (31,391.68) (122,449.78) (28,674.94) (48,869.87) (53,098.35) (130,643.16) BASIC CABLE 324,888.42 328,440.72 333,358.07 986,687.21 335,522.11 331,013.64 327,021.61 993,557.36 BOTTOM OF THE BILL DISCOUNT - - - - - - - - DIGITAL CABLE 455,747.64 465,520.63 475,933.77 1,397,202.04 474,873.21 476,454.95 474,301.34 1,425,629.50 EQUIPMENT REVENUE 16,127.04 7,206.09 10,063.58 33,396.71 10,203.32 7,357.20 6,546.00 24,106.52 EXPANDED BASIC 838.126.39 835,098.05 845,226.24 2,518,450.68 834,867.62 833,287.60 825,431.55 2,493,586.77 FCC FEE REVENUE 1,949.00 1,963.27 1,963.95 5,876.22 1,965.48 2,169.14 2,234.21 6,368.83 FRANCHISE FEE REVENUE 111,684.56 113,608.96 114,088.51 339,382.03 113,319.99 114,495.68 113,001.66 340,817.33 GUIDE REVENUE 1,376.18 1,354.56 1,317.54 4,048.28 1,296.21 1,300.74 1,292.01 3,888.96 INSTALLATION REVENUE 16,879.57 30,376.50 25,949.59 73,205.66 26,892.30 28,522.69 28,019.11 83,434.10 LATE FEE REVENUE 1 28,303.96 27,662.98 26,162.42 82,129.36 27,259.04 27,549.96 28,378.12 83,187.13 INTERNET REVENUE EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE I 21,796.92 16,194.83 17,635.40 55,627.15 20,537.90 17,655.45 21,941.15 60,134.51 PAY REVENUE 168,121.35 168,081.86 173,763.94 509,967.14 172,897.12 175,375.22 176,804.32 525,076.66 PAY PER VIEW REVENUE 95,078.65 100,061.88 92,976.57 288,117.10 93,961.26 110,436.37 93,044.35 297,441.98 UTILITY TAX - - - - - - SUBSCRIBER REVENUE TOTAL 2,026,010.40 2,058,581.69 2,087,047.70 6,171,639.80 2,084,920.62 2,076,748.77 2,044,917.08 6,206,586.48 SECTION 3-ALLOCATED REVENUE JANUARY FEBRUARY MARCH QTR TOTAL APRIL MAY JUNE OTR TOTAL SHOPPING COMMISSIONS 11,112.02 11,769.26 15,169.06 38,050.35 14,817.91 12,190.50 13,803.09 40,811.50 LEASED ACCESS 763.86 544.04 885.78 2,193.68 726.37 768.34 (220.59) 1,274.13 OTHER COMMERCIAL LEASED ACCESS - - - - - - - - OTHER REVENUE 76.93 234.95 - 311.87 327.87 198.63 - 526.50 TOWER&RENTAL INCOME 809.96 814.14 986.40 2,610.51 814.17 817.17 1,455.76 3,087.10 ALLOCATED REVENUE TOTAL 1 12,762.77 13,362.39 17,041.25 43,166.40 16,686.32 13,974.63 15,038.27 45,699.22 LOCAL ADVERTISING 57,272.67 48,117.50 52,209.98 157,600.16 54,280.58 66,417.61 50,500.50 171,198.69 NATIONAL ADVERTISING 40,705.25 28,314.75 25,506.67 94,526.67 28,307.66 31,368.97 37,020.30 96,696.93 BAD DEBT ON ADVERTISING 119.79 35.33 (409.94) (254.82) (311.04) (8,474.41) 2,645.93 (6,139.52) ADVERTISING REVENUE TOTAL I 98,097.71 76,467.59 77,306.71 251,872.01 82,277.19 $9,312.17 90,166.74 261,756.10 SECTION 4-TOTAL REVENUE $2.136,870.88 $2,148,411.67 $2,181,395.66 $6,466,678.21 $2,183,884.14 $2,180,035.58 $2,150,122.08 $6,514,041.80, SECTION 5-FRANCHISE TAX% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% Cable franchise fee 101,938.66 103,597.20 105,204.45 310,740.31 105,080.35 104,536.17 102,997.77 312,614.28 Ad sales franchise fee 4,904.89 3,823.38 3,865.34 12,593.60 4,113.86 4,465.61 4,508.34 13,087.80 SECTION 6-TOTAL FRANCHISE FEE DUE I $106,843.54 $107.420.58 $109,069.78 $323,333.91 $109,194.21 $109,001.78 $107,506.10 $325,702.09 Amount Paid 849834000080 FFPMT $323,333.91 Over/Under $0.00 $325,702.09