Loading...
HomeMy WebLinkAboutComcast 1st Quarter franchise fee report Ccomcasto 1Comcast Cable 5815 25th Ave West Lynnwood, WA 98087 April 28, 2011 SENT VIA OVERNIGHT MAIL Ms. Lorrie Rempher City of Auburn 25 West Main St Auburn, WA 98001 RE: Franchise Fee Report - First Quarter 2011 Dear Ms. Rempher: In accordance with our franchise agreement with the City of Auburn, 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, 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, LI.C OPERATOR: City of Auburn Comcast Period From 1/1/2011 - 3/31/2011 t 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) 910 3 43,856.61 5 2,192.83 2,192.83 Raft Cud Price Limited Cable Service* 16,589 $12.15 3 604,412.63 5 30,220.63 30,220.63 Expanded Cable Service* 14,575 $35.42 3 1,548,689.65 5 77,434.48 77,434.48 $1e99-W.2e Spedal Interest (Digital)** 14,606 $19.48 3 853,595.17 5 42,679.76 42,679.76 $1&99 HBO Customers 4,043 stave Showtime Customers 1,747 Rosa Cinemax Customers 739 ir8.29 TMC Customers 242 $ra29 Starz! Customers 3,093 $It" Encore Customers 79 Total Premium 9,944 $9.74 3 290,624.36 5 14,531.22 14,531.22 $Cw-$µ.9S Pay-Per-View 6,811 $9.23 3 188,490.96 5 9,424.55 9,424.55 $aN Standard Converters 0 Wo Addressable Converters 17 am Digital Converters 23,695 $020 Remote Units 22,879 Total Equipment 46,591 $0.14 3 20,139.88 5 1,006.99 1,006.99 TOTAL SERVICE/INSTALL INCOME 3,549,809.26 5 177,490.46 177,490.46 Advertising Revenue 152,747.56 5 7,637.38 7,637.38 Shopping Services 26,216.75 5 1,310.84 1,310.84 WO Guides 230 $3.51 3 2,424.24 5 121.21 121.21 Late Fees 48,314.98 2,415.75 2,415.75 Miscellaneous 39,667.18 5 1,983.36 1,983.36 TOTAL NON-SUBSCRIBER INCOME 269,370.71 5 13,468.54 13,468.54 Less Refunds/Bad Debts (65,569.01) 5 (3,278.45) (3,278.45) Plus Bad Debt Recovery 0.00 5 0.00 0.00 NET BAD DEBTS (65,569.01) 5 (3,278.45) (3,278.45) TOTAL REVENUES 3,753,610.96 5 187,680.55 187,680.55 Franchise Fee Revenue 225,364.38 5 11,268.22 11,268.22 Adjustments* TOTAL DUE CITY 3,978,975.34 5 198,948.77 198,948.77 EXPLANATORY NOTES: Send to: Prepared by: Ann ensson City of Auburn 6kA Titre: Franchise Contrails Administrator Date: 27-Apr-11 CONFIDENTIAL NOT FOR PUBLIC RECORD FRAIVCHI9E FED = REV~NIlE SECTION 1 - GENERAL INFORMATION ENTITY NAME: AUBURN ENTITY NUMBER: 776 FRANCHISE NAME: CITY OF AUBURN BILLING AREA: 8498 3400 0010 VENDOR #1 SITE CODE 149057 25 W MAIN ST 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 (3,221.10) (3,638.04) (873.56) (7,732.69) BASIC CABLE 46,307.58 48,500.62 49,000.15 145,808.35 BOTTOM OF THE BILL DISCOUNT - - DIGITAL CABLE 75,363.99 76,647.21 78,141.00 230,152.19 EQUIPMENT REVENUE 2,938.57 990.62 1,247.05 5,176.24 EXPANDED BASIC 122,444.81 120,559.36 121,699.90 364,704.09 FCC FEE REVENUE 281.38 281.52 260.48 843.38 FRANCHISE FEE REVENUE 18,53712 18,447.46 18,542.84 55,527.42 GUIDE REVENUE 199.73 196.37 192.78 590.88 INSTALLATION REVENUE 3,222.19 3,182.06 2,655.90 9,060.15 LATE FEE REVENUE 3,343.48 3,357.03 3,128.14 9,828.65 INTERNET REVENUE EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE 2,606.24 3,545.56 2,295.33 6,447.14 PAY REVENUE 25,475.26 25,765.69 26,791.03 76,051.98 PAY PER VIEW REVENUE 14,083.51 15,203.15 13,285.12 42,571.78 UTILITY TAX EXCLUDED EXCLUDED EXCLUDED EXCLUDED SUBSCRIBER REVENUE TOTAL 313,582.77 313,060.62 316,386.17 943,029.56 SECTION 3 - ALLOCATED REVENUE JANUARY FEBRUARY MARCH OTR TOTAL SHOPPING COMMISSIONS 1,612.06 1,693.05 2,173.17 5,478.28 LEASED ACCESS 110.82 78.26 126.90 315.98 OTHER COMMERCIAL LEASED ACCESS - - - - OTHER REVENUE 11.16 33.80 - 44.96 TOWER & RENTAL INCOME 117.50 117.12 141.31 375.94 ALLOCATED REVENUE TOTAL 1,851.54 1,922.23 2,441.38 6,215.15 LOCAL ADVERTISING 8,308.76 6,921.67 7,479.76 22,710.39 NATIONAL ADVERTISING 5,905.26 4,073.17 3,654.16 13,632.60 BAD DEBT ON ADVERTISING 17.38 5.08 (58.73) (36.27) ADVERTISING REVENUE TOTAL 14,231.40 11,000.12 11,075.19 36,306.71 SECTION 4 - TOTAL REVENUE $329,665.71 $325,982.97 $329,902.75 $965,551.43 SECTION 5 - FRANCHISE TAX % 5.00% 5.00% 5.00% Cable franchise fee 15,771.72 15,749.14 15,941.36 47,462.24 Ad sales franchise fee 711.57 550.01 553.76 1,815.34 SECTION 6 - TOTAL FRANCHISE FEE DUE $16,483.29 $16,299.15 $16,495.14 $49,277.57 Amount Paid Over/Under $49,277.57 CONFIDENTIAL NOT FOR PUBLIC RECORD FRANCHISE FEE - REVENUE SECTION 1 - GENERAL INFORMATION ENTITY NAME: AUBURN ENTITY NUMBER: 776 FRANCHISE NAME: CITY OF AUBURN BILLING AREA: 8498 3400 0210 VENDOR S/ SITE CODE 149057 25 W MAIN ST YEARITERM: 2011/QUARTERLY DAYS DUE: 30 DAYS FRANCHISE EXCLUSIONS: Internet, Leased Access SECTION 2 - SUBSCRIBER REVENUE Description JANUARY FEBRUARY MARCH QTR TOTAL BAD DEBT/WRITE-OFFS (22,593.33) (17,106.85) (17,823.42) (57,523.59) BASIC CABLE 126,901.11 128,160.13 129,409.01 384,478.25 BOTTOM OF THE BILL DISCOUNT DIGITAL CABLE 164,440.06 167,854.43 171,181.40 503,475.89 EQUIPMENT REVENUE 5,609.79 2,595.77 4,159.36 12,364.92 EXPANDED BASIC 331,878.23 329,960.20 333,991.21 995,829.64 FCC FEE REVENUE 761.79 764.74 770.83 2,297.36 FRANCHISE FEE REVENUE 46,494.68 47,055.00 47,401.17 140,950.85 GUIDE REVENUE 574.92 559.30 546.55 1,682.77 INSTALLATION REVENUE 6,705.66 13,295.50 10,437.40 30,438.56 LATE FEE REVENUE 11,582.04 11,509.13 10,431.95 33,523.92 INTERNET REVENUE EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE 8,332.27 9,959.59 7,151.68 25,443.54 PAY REVENUE 56,558.69 56,892.69 59,173.47 172,624.85 PAY PER VIEW REVENUE 38,779.60 39,463.82 39,510.64 117,754.06 UTILITY TAX EXCLUDED EXCLUDED EXCLUDED EXCLUDED SUBSCRIBER REVENUE TOTAL 776,026.32 790,971.45 796,343.25 2,363,341.03 SECTION 3 - ALLOCATED REVENUE JANUARY FEBRUARY MARCH OTR TOTAL SHOPPING COMMISSIONS 4,316.49 4,569.08 5,902.86 14,788.43 LEASED ACCESS 296.72 211.21 344.69 852.62 OTHER COMMERCIAL LEASED ACCESS - - OTHER REVENUE 29.88 91.21 - 121.09 TOWER & RENTAL INCOME 314.63 316.07 383.85 1,014.55 ALLOCATED REVENUE TOTAL 4,957.73 5,187.57 6,631.39 16,776.69 LOCAL ADVERTISING 22,247.73 10,595.42 20,140.94 60,984.09 NATIONAL ADVERTISING 15,812.07 10,992.40 9,925.61 36,730.07 BAD DEBT ON ADVERTISING 46.53 13.72 (159.52) (99.27) ADVERTISING REVENUE TOTAL 38,106.33 29,601.53 29,907.03 97,614.89 SECTION 4 - TOTAL REVENUE $819,090.38 $825,760.55 $832,881.60 $2,477,732.61 SECTION 5 - FRANCHISE TAX % 5.00% 5.00% 5.00% Cable franchise fee 39,049.20 39,807.95 40,148.73 119,005.89 Ad sales franchise fee 1,905.32 1,480.08 1,495.35 4,680.74 SECTION 6 - TOTAL FRANCHISE FEE DUE $40,954.52 $41,208.03 $41,644.08 $123,086.63 Amount Paid Over/Under $123,886.63 CONFIDENTIAL NOT. FOR PUBLIC RECORD F _.A I~SE F~ ` R0.: WE SECTION 1 - GENERAL INFORMATION ENTITY NAME: AUBURN ENTITY NUMBER: 776 FRANCHISE NAME: CITY OF AUBURN BILLING AREA: 8498 3400 0390 VENDOR SITE CODE 149057 25 W MAIN ST YEAR/TERM: 2011/QUARTERLY DAYS DUE: 30 DAYS FRANCHISE EXCLUSIONS: Internet, UT SECTION 2 - SUBSCRIBER REVENUE Description JANUARY FEBRUARY MARCH QTR TOTAL BAD DEBT/WRITE-OFFS 240.27 (353.45) (799.55) (312.73) BASIC CABLE 24,262.05 24,660.34 25,203.64 74,126.03 BOTTOM OF THE BILL DISCOUNT - - - - DIGITAL CABLE 39,354.73 39,887.50 40,724.85 119,967.08 EQUIPMENT REVENUE 1,465.44 489.40 643.88 2,598.72 EXPANDED BASIC 62,997.45 61,878.38 63,280.09 188,155.92 FCC FEE REVENUE 146.32 145.90 145.48 437.70 FRANCHISE FEE REVENUE 9,581.56 9,586.71 9,717.62 28,886.11 GUIDE REVENUE 52.47 48.84 49.28 150.59 INSTALLATION REVENUE 1,313.73 1,544.46 1,499.71 4,357.90 LATE FEE REVENUE 1,705.07 1,695.30 1,562.03 4,962.40 INTERNET REVENUE EXCLUDED EXCLUDED EXCLUDED EXCLUDED OTHER REVENUE 1,192.50 735.05 270.51 I 2,198.061 PAY REVENUE 13,143.50 13,118.41 13,685.65 39,947.56 PAY PER VIEW REVENUE 9,161.58 9,551.15 9,452.39 28,165.12 UTILITY TAX EXCLUDED EXCLUDED EXCLUDED EXCLUDED SUBSCRIBER REVENUE TOTAL 164,616.69 162,987.99 166,035.78 493,640.46 SECTION 3 - ALLOCATED REVENUE JANUARY FEBRUARY MARCH OTR TOTAL SHOPPING COMMISSIONS 833.14 877.69 1,131.62 2,842.64 LEASED ACCESS 57.27 40.58 66.08 163.93 OTHER COMMERCIAL LEASED ACCESS - - OTHER REVENUE 5.77 17.53 - 23.29 TOWER & RENTAL INCOME 60.73 60.73 73.59 195.04 ALLOCATED REVENUE TOTAL 956.90 996.73 1,271.28 3,224.91 LOCAL ADVERTISING 4,294.08 3,589.18 3,894.88 11,778.14 NATIONAL ADVERTISING 3,051.92 2,112.05 1,902.80 7,066.78 BAD DEBT ON ADVERTISING 8.96 2.64 (30.58) (18.96) ADVERTISING REVENUE TOTAL 7,354.99 5,703.87 5,767.10 18,825.96 SECTION 4-TOTAL REVENUE $172,928.59 $169,688.59 $173,074.16 $515,691.33 SECTION 5 - FRANCHISE TAX % 5.00% 5.00% 5.00% Cable franchise fee 8,278.68 8,199.24 8,365.35 24,843.27 Ad sales franchise fee 367.75 285.19 288.35 941.30 SECTION 6 - TOTAL FRANCHISE FEE DUE $8,646.43 $8,484.43 $8,65171 $25,784.57 Amount Paid Over/Under $25,784.57