Loading...
HomeMy WebLinkAboutCAG1993-0577 - Other - Franchise Fee Report - 04/29/2008 ' CD 1 1 1 CCUSt-w, Comcast Cable r ..1 J` 15815 25th Ave.West Lynnwood,WA 98087 April 29, 2008 SENT VIA OVERNIGHT UPS Brenda Jacober City of Kent 220 First Ave S Kent, WA 98032 RE: Franchise Fee Report -First Quarter 2008 Dear Ms. Jacober: In accordance with our franchise agreement with the City of Kent, please find enclosed the franchise fee report for First Quarter 2008. 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, a'z v_—, Ann Svensson Franchising Contracts Administrator Comcast—WA Market Encls. cc: Janet L. Turpen, Comcast Ken Rhoades, Comcast Terry Davis, Comcast OPERATOR: City of Kent Comcast Period From 1/1/08-3/31/08 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,225 $16.02 3 58,852.03 5 2,942.60 2,942.60 Rate Card Price $14.14 Limited Cable Service 12,026 $21.27 3 767,434.91 5 38,371.75 38,371.75 $38.11 Expanded Cable Service* 9,964 $68.58 3 2,049,859.82 5 102,492.99 102,492.99 $14.99 Special Interest(Digital) 7,665 $35.27 3 811,054.80 5 40,552.74 40,552.74 $17.99 HBO Customers 2,503 $17.99 Showtime Customers 667 $17.99 Cinemax Customers 519 $17.99 TMC Customers 454 $17.99 Starz!Customers 1,357 $15.99 Encore Customers 487 Total Premium 5,986 $17.92 3 321,742.36 5 16,087.12 16,087.12 $4.99444.95 Pay-Per-View 46,946 $2.05 3 288,262.51 5 14,413.13 14,413.13 $3.50 Standard Converters 19 $3.50 Addressable Converters 51 $3.50 to$8.00 Digital Converters 12,151 $0.15 Remote Units 11,969 Total Equipment 24,189 $0.02 3 1,192.59 5 59.63 59.63 TOTAL SERVICE/INSTALL INCOME 4,298,399.02 5 214,919.95 214,919.95 Advertising Revenue 253,493.42 5 12,674.67 12,674.67 Shopping Services 38,017.85 5 1,900.89 1,900.89 $3.45 Guides 657 $3.41 3 6,730.77 5 336.54 336.54 Late Fees 32,577.10 1,628.86 1,628.86 Miscellaneous 18,346.13 5 917.31 917.31 TOTAL NON-SUBSCRIBER INCOME 349,165.27 5 17,458.26 17,458.26 Less Refunds/Bad Debts (98,338.48) 5 (4,916.92) (4,916.92) Plus Bad Debt Recovery 0.00 5 0.00 0.00 NET BAD DEBTS(-) (98,338.48) 5 (4,916.92) (4,916.92) TOTAL REVENUES 4,549,225.81 5 227,461.29 227,461.29 Franchise Fee Revenue 232,003.94 5 11,600.20 11,600.20 Adjustments* TOTAL DUE CITY 4,781,229.75 5 239,061.49 239,061.49 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 Sv son City of Kent `. Title: Franchise Contracts Administrator Date: April 28,2008 FRANCHISE FEE- REVENUE SECTION 1 -GENERAL INFORMATION ENTITY NAME: AUBURN ENTITY NUMBER: 776 FRANCHISE NAME: CITY OF KENT BILLING AREA: 8498 3400 0080 YEAR/TERM: 2008/QUARTERLY DAYS DUE: 30 DAYS FRANCHISE EXCLUSIONS: Internet SECTION 2-SUBSCRIBER REVENUE Description JANUARY FEBRUARY MARCH QTR TOTAL BAD DEBT/WRITE-OFFS (42,973.51) (27,830.98) (27,533.99) (98,338.48) BASIC CABLE 254,246.82 255,232.07 257,956.02 767,434.91 BOTTOM OF THE BILL DISCOUNT - _ _ DIGITAL CABLE 267,361.78 270,719.03 272,973.99 811,054.80 EQUIPMENT REVENUE 362.88 477.25 352.46 1,192.59 EXPANDED BASIC 681,695.72 681,414.16 686,749.94 2,049,859.82 FCC FEE REVENUE 1,289.18 1,291.34 1,298.64 3,879.16 FRANCHISE FEE REVENUE 76,929.76 77,665.92 77,408.26 232,003.94 GUIDE REVENUE 2,201.40 2,253.53 2,275.84 6,730.77 INSTALLATION REVENUE 17,798.59 21,200.55 19,852.89 58,852.03 LATE FEE REVENUE 11,308.57 10,464.63 10,803.90 32,577.11 INTERNET REVENUE EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE 3,430.73 6,915.12 4,121.12 14,466.97 PAY REVENUE 107,422.76 108,061.13 106,258.47 321,742.36 PAY PER VIEW REVENUE 98,136.06 105,719.56 84,406.89 288,262.51 UTILITY TAX _ _ SUBSCRIBER REVENUE TOTAL 1,479,210.74 1,513,583.31 1,496,924.44 4,489,718.50 SECTION 3-ALLOCATED REVENUE JANUARY FEBRUARY MARCH QTR TOTAL SHOPPING COMMISSIONS 8,116.11 9,615.70 11,784.97 29,516.78 LEASED ACCESS 1,189.52 1,156.86 601.58 2,947.96 OTHER COMMERCIAL LEASED ACCESS OTHER REVENUE (417.45) 3,039.84 807.81 3,430.20 TOWER&RENTAL INCOME 707.02 706.85 709.04 2,122.91 ALLOCATED REVENUE TOTAL 9,595.20 14,519.25 13,903.40 38,017.84 LOCAL ADVERTISING 54,962.07 60,657.86 72,335.07 187,955.00 NATIONAL ADVERTISING 16,497.35 21,902.99 27,451.79 65,852.13 BAD DEBT ON ADVERTISING 73.95 (160.80) (226.87) (313.72) ADVERTISING REVENUE TOTAL 71,533.37 82,400.05 99,560.00 253,493.41 SECTION 4-TOTAL REVENUE $1,560,339.31 $1,610,502.61 $1,610,387.84 $4,781,229.76 SECTION 5-FRANCHISE TAX% 5.00% 5.00% 5.00% Cable franchise fee 74,440.30 76,405.13 75,541.39 226,386.82 Ad sales franchise fee 3,576.67 4,120.00 4,978.00 12,674.67 SECTION 6-TOTAL FRANCHISE FEE DUE $78,016.97 $80,525.13 $80,519.391 $239,061.49 Amount Paid 849834000080 FFPMT $239,061.49 Over/Under $0.00