The URL can be used to link to this page

Home My WebLink AboutComcast 2010 Annual Filing FCC form 1205 COMCAST CABLE COMMUNICATIONS, LLC 2010 ANNUAL FILING - FCC FORM 1205 PREPARATION DOCUMENTATION This memo will serve to document, in general terms, the steps and methodologies behind the preparation of FCC Form 1205 for systems owned and managed by Comcast Cable Communications, LLC ("Comcast"). Comcast has chosen to aggregate its equipment costs at the company level as provided by the Federal Communication Commission's Report and Order released June 7, 1997 (DA 96-57). The cost data included in the 2010 Form 1205 was obtained from the books and records at the company level of Comcast as of December 31, 2010. The average hours per installation, costs and hours of installation and maintenance of customer equipment were estimated based upon a sample of Comcast's cable systems. Please see the enclosed "Sampling Plan & Analysis for Comcast Cable System Rates" for more details. SCHEDULE A CAPITAL COSTS OF SERVICE INSTALLATION AND MAINTENANCE OF EQUIPMENT AND PLANT Line A Represents the types of equipment necessary for installation and maintenance of cable facilities such as vehicles and tools. Line B Gross book value was taken from the books and records of Comcast at December 31, 2010. Line C Accumulated depreciation was taken from the books and records of Comcast at December 31, 2010. Line D Deferred tax balances were calculated by multiplying the difference between the net book value and the net tax value by the sum of the Federal income tax rate (35%) and the applicable state income tax rate (net of the Federal income tax benefit). Assets identified at the company level use a weighted average state tax rate (6.99%) for this calculation. Net tax value was calculated using gross tax value minus accumulated tax depreciation. The net tax balances for 2001 through 2004 were adjusted to account for tax basis bonus depreciation. Line G4a Represents interest expense for Comcast Corporation taken from the company's l OK for the year ended December 31, 2010. Line Gob Represents total net assets of Comcast Corporation taken from the company's l OK for the year ended December 31, 2010. Total net assets equal total assets less total current assets and goodwill. Line J Represents annual depreciation expense. Depreciation expense was taken from the books and records of Comcast at December 31, 2010. COMCAST CABLE COMMUNICATIONS, LLC SCHEDULE B ANNUAL OPERATING EXPENSES FOR SERVICE INSTALLATION AND MAINTENANCE OF EQUIPMENT AND PLANT Schedule B lists annual operating expenses (excluding depreciation) for installation and maintenance of all cable facilities for the year ended December 31, 2010. Such expenses were obtained from the books and records of Comcast at December 31, 2010 and are summarized as follows: Schedule B Schedule B Analysis Salaries & Benefits Salaries, Commissions, Employee Benefits, and Payroll Taxes Supplies Operating Supplies Other 1 Contract Labor, Converter Maintenance and Repair Other 2 Vehicle Expense Gas and Oil, Vehicle Expense Maintenance and Rentals/Lease Expense SCHEDULE C CAPITAL COSTS OF LEASED CUSTOMER EQUIPMENT Line A Represents customer equipment for which there is a separately calculated charge. The following items of equipment will have a separately calculated charge: converters for "basic-only" customers, converters for customers receiving a level of service above the basic tier (except HDTV-capable and DVR-capable converters), HDTV-capable and DVR-capable converters, CableCARDs, Digital Terminal Adapters (DTA) and remotes. Line B Represents total maintenance and service hours for remotes and converters. Hours were obtained from system personnel based on service call reports and the system management's experience in performing various maintenance/service activities. If the system utilized contract labor, those hours were included. Such hours were then allocated 5% to remotes and 95% to converters. Please refer to Schedule C Attachment for actual calculation. Line D Gross book value was taken from the books and records of Comcast at December 31, 2010. Items such as non-addressable converters, addressable converters, remotes, digital converters, digital video recorders, HDTV-capable converters, Digital Terminal Adapters and CableCARDs are included on this line. Line E Accumulated depreciation was taken from the books and records of Comcast at December 31, 2010. Line F Deferred tax balances were calculated by multiplying the difference between the net book value and the net tax value by the sum of the Federal income tax rate (35%) and the applicable state income tax rate (net of the Federal income tax benefit). Assets identified at the company level use a weighted average state tax rate (6.99%) for this calculation. Net tax value was calculated using gross tax value minus accumulated tax depreciation. The net tax balances for 2001 through 2004 were adjusted to 2 COMCAST CABLE COMMUNICATIONS, LLC account for tax basis bonus depreciation. Line J Current provision for depreciation was taken from the books and records of Comcast at December 31, 2010. SCHEDULE D AVERAGE HOURS PER INSTALLATION Schedule D includes the average hours for installations. The average times were based on the sample systems' experience in actually performing such activities in 2010 and represent a weighted average time that includes both in-house and contractor installation times. WORKSHEET FOR CALCULATING PERMITTED EQUIPMENT AND INSTALLATION CHARGES STEP A HOURLY SERVICE CHARGE Line 4 Represents the estimated percentage of the costs reported on Schedules A and B that relate directly to regulated installations and maintenance of customer equipment. Line 5 Represents the estimated amount of costs related to installation and maintenance of regulated customer equipment. Line 6 Represents an estimate of the total number of person hours that were spent on maintenance of regulated customer equipment and service installations in 2010, including contract labor. STEP F CHARGES FOR CHANGING SERVICE TIERS OR EQUIPMENT Line 36b Represents the average hours for changing service tiers or equipment and equals the same number of hours listed for upgrade of service (requiring service call) at Schedule D, Item 2. WORKSHEET FOR CALCULATING TOTAL EQUIPMENT AND INSTALLATION COSTS This worksheet has not been completed since this is the annual filing of Form 1205, and not a Form 1205 being filed in conjunction with FCC Form 1200, 1220, or 1225 for the purpose of establishing cable service rates. Please refer to the instructions to FCC Form 1205, page 21. 3 COMCAST CABLE COMMUNICATIONS, LLC Federal Communications Con mission Approved by: OMB 3060-0703 Washington D.C. 20554 FORM 1205 DETERMINING REGULATED EQUIPMENT AND INSTALLATION COSTS "EQUIPMENT FORM" Comost Community Unil Identifier (CUID) of cable system Date of Form Submission SEE FCC FORM 1240 FILING 03/01/11 Name of Cable Operator COMCAST CABLE COMMUNICATIONS, LLC Mailing Address of Cable Operator Gty State ZIP Cale Name and Tide ofperson completing this form: Telephone number Faz Number Name I'Local Franchising Authority PLEASE SEE FRANCHISE AUTHORITY LISTING PROVIDED WITH FCC FORM 1240 FILING Mailing Address of I_,, ranchising Authority City State ZIP Code 1. This form is being filed: !Enter an "z" in the appropriate bail F-I In conjunaion with FCC Fonn 1200, FCC Fonn 1220, or FCC Form 1225- . Amach the mmpletel FCC Fonn 1200, FCC Fonn 1220, or FCC Fonn 1225 to the from of this form. OR In order to fulfill FCC rules requinng an annual filing of this loon Enter the date on which you last filed this form O3/01!10 (mm1dd/yy) Note: This should be the date on which the rates last justified, by using either FCC Fonn 393 or the prior filing of this f nvi, were in effas. 2. Enter the date on which you closed your books for the fiscal year reflected in this form: 12/31/10 (.Wdd/yy) Note: This will indicate the end ofthe 12--th fiscal year for which you are filing this form. 3. Indicate the corporate status of your cable system (Enter an "s" in the correct boil X C-Corporation Subchapia S mrpomGon Pan -wisp We Propnetorshtp Other [Please explain below) FCC Form 1205 Page I Ezcel 4.0 for Wind- lux 19% Federal Communications Commission Approved by: OMB 3060-0703 Washington, D.C. 20554 Coutcssl SCHEDULE A: CAPITAL COSTS OF SERVICE INSTALLATION AND MAINTENANCE OF EQUIPMENT AND PLANT Maintenance Other 1. Other 2. A E ui inm and Plant Vehicles Tools Facilities (S ecifv below) (Specify below) B Gmss Book Value 51,031,709,701.00 5688,766,938.00 s0.00 C Aeounulat.1 reciauon $886,982,845.00 5522,071,676.00 50.00 D Ddertrd Taxes S978,096A0 516,363,232.00 S0-00 E Na Book Valuc(B{C+D)] $143,747,760.00 5150.332,030 V0 $0.00 50.00 50.00 F Rate of Raum 0.1125 G Calculnr(on oJGmss-u Rate GI Federal Income Tax Rate 0.35 G2 State I-ne Tax Rate 0.0699 G3 Net Taal Income Tax Rate (GI+G2)-(G) xG2) 03954 G4 Adjustment to Reflect Interest Dorluctibi)ity G4a Anual Interest A--t $2,156,000,00000 Gob Total Net Assas $94,690,000,000.00 G4c Base Return on Inven=t Amount G4b x F) S 10,652,625,000 00 God bac,rest Deduaibilit Factor [G4arG4c 0.2024 G5 Elfeaive Tax Rate G3 x (I-G4d) (C-Co s ski to G7 0.3154 G6 Ad'usunents for Non-C Co rations G6a Base Return on Investment Amount [G4 c] n/a Glib Distributions WOO G6c Conmlbutiona, (tract not -M G6b) G6d Raums Sub w to lnmmc Tax [66a-G6b+G6c) n/a G6c Returns Percentage Subject to Income Tax G6d/G6a] Na G7 Gmss-U Rate C-Co s:I/(I-G5)Olhml/(IIGSxG6e) 1,4607 H Grossed-U Rate of Raum F x (37) 0.1643 1 Raum on lovestmmi Grossed-U for Tum[E x H 523,622,0815481 $24,704,077.2852 5000 50.00 50.00 I Current Provision for Dcpr iation 5102,564,019.94 549,439,816.89 50.00 K Annual Capful Costs [[+1) 5126,186,103.4881 $74,143,894.1752 $0.00 $0.00 $0.00 L GRAND TOTAL ]sum of Line K entries] 5200,329,997.6634 Box 1. specify: Other 1. Specify Other 1 SCHEDULE 8: ANNUAL OPERATING EXPENSES FOR SERVICE INSTALLATION AND MAINTENANCE OF EQUIPMENT salaries Otha 1. Otha 2. &Benefia Su lies Utilities Otha Taxes (S eci below) (S ecifybelow) A Amual Op. Expenses For Svc Install. and Matnt, of Equip. $4,829,054,574.39 S 16,414,461.33 $0.00 $0.00 $375,062,318.51 5365,780,860.23 B GRAND TOTAL [sum of Line A entries] SS,586,312,214.46 Box 2. Specify Otha 1. Contract Labor/ Corr,wa Maintenance Specify. Other 2. Vehicle Expenses / Rentals and Lease Expense FCC Fom 1205 Page 2 Excel 4.0 for Wind- June 19% Faderal Communicatlors Commission Approved by: OMB 3060-0703 Washington, D.C. 20554 Grncast SCHEDULE C: CAPITAL COSTS OF LEASED CUSTOMER EQUIPMENT A E u' meni Rana, I Remote 2 CkleCARD Convena I Converter 2 Convener 3 Converter 4 B Taal Maint,nance(Savicc Hours (Attach Explanation) 586,080 28,480 38,366 4,026,830 3,231,596 3,810,273 C Taal BofU..ts in Service 32,489,156 341,764 170,827 17,929,838 14,388,491 16,965,120 D Gross Book Value 5376,127,493.00 516,982,313 33 5167,237.00 53,384,651,424.00 $4,674,772,982.00 5697,544,283.00 E AuumulatMD Depreciation 5317,198,300.00 59,835,930.71 $167,232.00 52,745,401,637 .00 52,417,600,557.00 5104,375,800.00 F Deferred Taxes (531,082,082.00) 5320,048.00 $62.00 $110,906,673.00 5350,092,109.00 545,069,069.00 G Net Book Value D4E+F) 590,011,275.00 10.OU Sfi.826.I34.62 (557.00) 5528,343,114.00 $1,906,880,316.00 $548,099,414.00 H Grossed-U Rate of Raum From Schad. A, Line H 0.1643 1 Return on Investment Gmssod-U for Taxes GxH) $14,791,561,6795 fUDO $1,121,772.2399 (59.3668) 586,822,675.9219 5313,357,829.999 590,069,230.6453 I Cutreat Provision for Depreciation 552,654,633.34 52,762,716.88 542.00 5244,640,802.72 5738,670,307.53 598,085,987.18 K Annual Gpinl Cons [I+1] 567,446,195.0195 51200 57,884,469.1199 532.6332 5331,467,478.6419 51,052,028,177.529 S188,155,217.8253 L GRAND TOTAL )sum of Llne K entries] $1,642,977,550.7688 Bas 3. SCHEDULE D: AVERAGE HOURS PER INSTALLATION A. Average Houn per Unwired Home Installation (attach an = planation) 1.3013 B. Avers a Houn per PraWimd Home Installation (attach an explanation) 0.9599 C. Avers eHmm AdditonalConn,aionlnstalimionat Timeoflnitiallnstallation(attach ana Ianatmn) 0.4194 D. Aver. a Hours Additional Connection Installation R wiring S .rate Installation (attach an ex Ianation) 0.9339 E. OtherInstallation (by Item Type): Item 1. Relocate Outlet-Initial Avers a Hours per Installation attach an cm planation) 0.4033 Item 2. Upgrade Non-Addressable Avaa a Hours per Installation (anselt an explanation) 0.5955 Item 3. Downgrade Non-Addressable Aver a Hount per Installation (attach an explanation) 0.3575 FCC Form 1205 Page 3 Exul 4,0 for Windows June 1996 Federal Communications Commission Approved by: OMB 3060-0703 Washington, D.C. 20554 Comcast WORKSHEET FOR CALCULATING PERMITTED EQUIPMENT AND INSTALLATION CHARGES STEP A. Hourly Service Charge i. Total Capital Costs of Installation and Maintenance Schedule A, Box 1 j $200,329,997.6634 2. Total Annual satin Expenses for Installation and Maintenance [Schedule B, Box 2] 55,586,312,214.46 3. Total Capital Costs and Operating Ex mm for Installation and Maimenence (Line I + Line 21. 55,786,642,212.1234 4. Customs Equipment and Installation Percents a (attach an explanation). 0.1570 5. Annual Custmna E ui meot Maintenance and Installation Costs, Excludin Costs of Leased Equipment Line 3 x Line 41 S908,5451 054.U0 6. Total Labor Hours for Maintenance and Installation of Customa E ui ment and Servius (attach explanation) 26,911,566.00 7. Hourly S-rce Charge (HSC) (Line 5/Line 6) 533.7604 METHOD OF BILLING FOR INSTALLATIONS (place an "x" in the appropriate box) Installations billed by the hour based on the HSC calculated in Line 7. XInstallations s billed as a standard charge. STEP B. Installation Charge 8. Uniform HSC for all installations (From Step A, line 7) rya OR 9. Average Charge for Installation Types a. Unwired Home Installation a1. HSC Lim 7 S33.7604 a2. Average Hours per Unwired Home Installation (Schedule D. Line A) L3013 a3. Charge pa Unwimd Harm Installation [al x a21 $4349324 b. Pn wimd Horne Installation b1. HSC Line 7 $33.7604 W. Average Hours per Pn-carted Hone Installation (Schedule D, Line B) 0.9599 b3. Charge per Pre-wired Home Installation (bl x 1,21 532.4066 c. Additional Connection Installation At Time of Initial Installation cf. HSC Lt. 71 533.7604 c2. Average Hours per Additional Connection Installation at Time of Init. Install. [Schedule D, Line C] 0.41941 6. Charge pa Additional Connection Installation at Time of Initial Installation (cl x c21 $14.1591 d. Additional Connection Installation Requiring Separate Installation dl. HSC [Line 7] 533.7604 Q. Avg. Hours per Additional Connection Installation Req. Sep. Install. (Schedule D, Line D] 0.9339 d3- Charge per Additional Connection Installation Requiring Separate Installation [d 1 x d2j $3145288 a Other Installations (Asspecified in Schedule D, Line E): el. HSC Line 7) $33.7604 e2. Avenge Hourspa Installation of han I [Relocate Outlet-Initial] 0.4033 e3. Charge per installation of Item I [cl x e2] S 13.6156 d. HSC Line 7) 533.7604 e5. Average Hourspa Installation of Item 2 (Upgrade Non-Addressable] 0.5955 e6. Charge per Installation ofltem 2 [e4 x e5] S20.1043 e7. HSC Line 7) $33.7604 e8. Average Hours pa Installation of Item 3 (Downgrade Non-Addressable] 0.35751 e9. Charge pa Installation of lion 3 (e7 x e8] S120693 FCC Form 1205 Page 4 Excel 4.0 for Windows June 1996 Federal Communications Commission Approved by: OMB 3060-0703 Washington, D.C. 20554 Co-t STEP C. Charges for leased Retool. b (Calculates arately for each significantly different type) Remote I Rermote 2 Cable Card 10. Taal Mainle tance/Smlrt Hours Cortespondin column from Schedule C, Line B] 586,080 0. 28,480 11. HSC [Lim 7 533.7604 533.7604 533.7604 12. Total MartenanWServiu Cost [Line 10 x Line I I ] S 19,786,291.3384 50.00 5961,496.0028 13. Annual Capital Costs [Corns ondin column from Schedule C, Line K $67,446,195.0195 50.00 $3,884,489.1199 14. Total Cost of Ree me [Line 12 + Line 13] 587,232,4863578 $0.00 54,845,985.1227 15. Number of Units in S- Cones Ming wlunn from Schedule C, Line C 32,489, 156 0. 341,764 16. Unit Cost (Line 14/Lint 151 52.685 50.00 S14 1793 17. Rate per Month [Lint 16/(12)] 50.2237 50.00 51.1816 STEP D. Charges for leased Converter Boxes b c (Calculate separately for each si niftcantl different type) Convener I Convener 2 Convena 3 Convener 4 18. Taal Maintenance/Service Hours [Corte Min colum from Schedule C, Line B] 38,366 4,026,830 3,231,596 3,810,273 19. HSC Line? 533.7604 533.7604 533.7604 533.7604 20. Taal Maintenance/Smice Cost [Line 18 x 191 $1,295,251.2515 5135,947,364.7798 5109,099,952.1294 5128,636,315.2757 21. Annual Capital Costs [Corresponding column from Schedule C, Line K 532.6332 5331,463,478.6419 S 1,052,028,137.529 $188,155,217.8253 22. Total Cost of Convener Line 20+ Line 21 $1,295,283.8847 (467,410,843.4218 51,161,128,089.6584 5316,791,533.101 23. Numbs of Units in Service Corte Min column from Schedule C, Line C) 170827 17,929,838 14,388,491 16,%5,120 24. Unit Cost [Lint 22/Eric 23] 57.5824 f2fi.0689 580.6984 518.6731 25. Rate per Month [Line 24/(12)) 506319 52.1724 $6.7249 51.5561 STEP E. Charges for Other Leased E ui mein 26. Total Maimenancd8ervice Hours Cones ondin twlmnn from Schedule C, Line B] 3810273. 27. HSC Line? 533.7604 28. Taal Mainteni ncetSmice Cost Line 26 x Line 27 $128,636,315.2 757 29. Annual Capital Costs [Corns Min column from Schedule C, Line K W8,155,217,8253 30. Taal Can ofE uipment [Line 28+Lim, 29 $316,791,533.101 31. Number of Units in Service Corte Ming column from Schedule C, Line C 16965120. 32. Unit Cost (Line 30/Line 31 ] S18,6731 33. RateperMonth [Linc321(12)] 51.5561 METHOD OF BILLING FOR CHANGING SERVICE TIERS OR EQUIPMENT ]place an "a" In the appropriate box] as a Nominal Charge (Enter the nominal charge in Line 34) as a Uniform Hourly Service Charge as an Average Charge (Enter the Average Hours for Changing Smice Tiers in Line 36b.) X) STEP F. Cha gm for Changing Service Tiers or Equipment 34. Nominal Charge for Changing Smite Ties If you use an escalating scale of es, lace an "x" in the box at the right. OR 35. Uniform Hourly Smite Charge n/a OR 36. Average Char a for Changing Smite Tiers 36a. HSC Line? $33.7604 36b. Average Hours to Change Smite Tiers 0,59551 36a Average Charge for Changing Smite Tian [Line 36a x Line 36b) 520.1043 FCC Form 1205 Page 5 Excel 4.0 for W inelows June 19% Fedaad Communications Co-fission Approved by OMB 3060-0703 Washington, D.C. 20554 con c l WORKSHEET FOR CALCULATING TOTAL EQUIPMENT AND INSTALLATION COSTS 1. Tow[ Capital Costs of Installation and Maintmanot [Schedule A, Box 11 $200,329,997.6634 2. Total Annual Operating Ex eosm for Instillation aM Maintenance [Schedule B, Box 21 $5,586,312,214.46 3. Taal Annual Capital Costs of Insallation and Maintenance [Line 1 + Line 21 $5,786,642,212.1234 4. Customs E ui ment and Installation Percents a (anach ex Ianation)- 5. Annual Customs Equi meat Maint- and Installation Costs, Excluding Costs of Lmsed E ui mrnt 50.00 Line 3 x Line 4) 6. Tool Capital Costs of Leased Cunoms E ui menu Schedule C, Box 3) $1,642,977,550.7688 7. Annual Customs E ui menu ael Installation Costs [Line 5 + Line 6] $1,642,977,550.7688 8. Per mta a Allocation to Franchise Asa (see imimuions) 9. Allocated Annual E ui m t and Installation Cost [Line 7 x Line 8 $0.00 10. Monthly E ui man and Imiallation Cost (Line 9 / (12)J $0,00 11. Numbs of Basic Substaibas in Franchise 12. Monthly E ui ment and Installation Cost a Subsuiba [Line 10 / Line 11 j $0.00 113. Inflation Ad usunent Faaor [See lnstmaions) 14. Ad sled Monthl E ui mmt and Installation Con pa Subscnba [Line 12 x Line 13) $0.00 FCC Form 1205 Page6 Excel 4.0 for Windows lure 191% Federal Communications Cormnission Approved by: OMB 3060-0703 Washington, D.C. 20554 Comcaat SUMMARY SCHEDULE Current Equipment and Installation Rates p-morl Actual 1. Charges for Cable Service Installations a. Hourly Rate St A, Line 71 rya b. Averse Installation Charges: 1. Installation ofUnwimt Homes Step B, Line 9a31 543.93 2. Installation of Prewired Homes St B, Line 9b3 532.41 3. Installation of Additional Connections at Time of Initial Installation [Step B, Line 9x31 514.16 4. Imtallation of Additional ConneetionsReg uirin Separate InmaII IStep B, Line 9d31 S31.53 5. Other Installations (s '(y) [St B, Lines 9e3, 9e6, 9e9 a. Rekaate outlet-Initial 513.62 b.U eNon-Addresabk 520.10 a Downgrade 51207 2- Monthly Charge for Lease of Renate Controls 1St C, Line 17, columns a-c Remote Control Type 1: All Units 50.22 Remote Control Type 2: 50.00 Remote Conrol T 3: CsbleCARD S1.18 3. Month Charge for Lease of Convener Boxes [St D, Line 25, columns a-c1 Convene Box Type 1: (Basic Only Units) $0.63 Convata Box Type 2: (All Other Units Excluding HD and DVR) $2.17 Convener Box Type 3: (High Definition and Digital Video Recorder) $6.72 4. Month) Cha a for Lease of other Equipment St E, Line 331 Other ui mart (DTA) $1.561 5. Charlie for Changing Ti- (if airy) St F. Line 34, 35 or 36,1 S 20. I 0 LABOR COST AND POLICY CHANCES Indicate your answer to the following three questions by placing an "x" in the appropnate box 1. Have you included the labor costs associated with subsmba cable drops in your charges for initial installation? BYES NO 2. Have you capitalized the labor costs associated with subsmba cable drops? BYES NO 3. Ifyou have filed this form before, have you changed any policy, e, g., cost accounting or cost allocation that causes an increase in the costs included in the computation of equipment and installations charges? YES (You most attach a fall explanation) X NO CERTIFICATION STATEMENT WILLFUL FALSE STATEMENTS MADE ON THIS FORM ARE PUNISHABLE BY FINE AND/OR IMPRISONMENT (U.S. CODE TITLE 18, SECTION 1001), AND/OR FORFEITURE (U.S. CODE, TITLE 47, SECTION 503). 1 certify that the steanents made in this form are true and correct to the bat of my knowledge and belief, and are made in good faith. Name of the Cable Operator Signature t~1 Contrast Cable Communications, LLC Date Tide 03/01111 Director of Rate R ,ulation 'See 2011 Equipment and Installation Rates Sheet. FCC Form 1205 Page 7 Excel 4.0 for Windows June 1996 FCC FORM 1205 SCHEDULE D: AVERAGE HOURS PER INSTALLATION Comcast Item 4. Upgrade/Downgrade Addressable Average Hours per Installation (Attach an Explanation) Item 5. Connect VCR - Connect Initial Average Hours per Installation (Attach an Explanation) 0.2541 Item 6. Connect VCR - Connect Seperate Average Hours per Installation (Attach an Explanation) 0.5663 Item 7. Customer Trouble Call Average Hours per Installation (Attach an Explanation) 0.9949 Item 8. Activate Pre-Existing Additional Outlet-Initial Average Hours per Installation (Attach an Explanation) 0.2306 Item 9. Activate Pre-Existing Additional Outlet-Separate Average Hours per Installation (Attach an Explanation) 0.6448 Item 10. Relocate Outlet-Separate Average Hours per Installation (Attach an Explanation) 0.9549 Page 8 1205 Attachments FCC FORM 1205 STEP B. INSTALLATION CHARGE Comcast e10. HSC [Line 7] N/A el I. Average Hours per Installation of Item 4 [Addressable Upgrade/Downgrade] N/A ell Charge per Installation of Item 4 [el0 x el 1) $1.9900 e13. HSC [Line 7] $33.7604 e14. Average Hours per Installation of Item 5 [VCR Connect-Initiall 0.2541 e15. Charge per Installation of Item 5 le 13 x el4] $8.5785 e16. HSC [Line 7] $33.7604 e17. Average Hours per Installation of Item 6 [VCR Connect-Separate] 0.5663 e18. Charge per Installation of Item 6 [el6 x el 71 $19.1185 e19. HSC [Line 71 $33.7604 e20. Average Hours per Installation of Item 7 [Customer Trouble Call] 0.9949 e21. Charge per Installation of ltem 7 [el9 x e201 $33.5882 e22. HSC [Line 7] $33.7604 e23. Average Hours per Installation of Item 8 [Activate Pre-Existing Additional Outlet-Initial] 0.2306 e24. Charge per Installation of Item 8 [e22 x e231 $7.7851 e25. HSC [Line 7] $33.7604 e26. Average Hours per Installation of Item 9 [Activate Pre-Existing Additional Outlet-Separate] 0.6448 e27. Charge per Installation of Item 9 [e25 x e26] $21.7687 e28. HSC [Line 71 $33.7604 e29. Average Hours per Installation of Item 10 [Relocate Outlet-Separate] 0.9549 e30. Charge per Installation of Item 10 [e28 x e29] $32.2378 Page 9 1205 Attachments FCC FORM 1205 SUMMARY SCHEDULE Comcast Current Equipment and Installation Rates Permitted Actual d. Upgrade/DowngradeAddressable $1.99 e. Connect VCR - Connect Initial W58 f. Connect VCR - Connect Separate $19.12 g. Customer Trouble Call $33.59 * h. Activate Pre-Existing Additional Outlet-Initial $7.79 i. Activate Pre-Existing Additional Outlet-Separate $21.77 j. Relocate Outlet-Separate $32 24 * See 2011 Installation and Equipment Rates Sheet Page 10 1205 Attaclmnents FCC FORM 1205 SCHEDULE C Comcast SCHEDULE C, LINE B - REMOTE 1 LINE 1. Total Labor Hours for Maintenance / Service of Remotes and Converters 11,721,609 hrs. LINE 2- Percentage of Line I Allocated to Remotes 0.0500 LINE 3. Total Maintenance / Service Hours Allocated to Remotes 586,080 LINE 4. Schedule C, Line C - Total Units in Service-Remote 1 32,489,156 LINE S. Number of Units-Remote I / Total Remote Units [Line 4 / (Line 4 + Line 8)] 1.0000 LINE 6. Total Maintenance / Service Hours Allocated to Remote I (Line 3 x Line 5) 586,080 hrs. SCHEDULE C, LINE B - REMOTE 2 LINE 7. Total Maintenance / Service Hours Allocated to Remotes (Line 3) 586,080 hrs. LINE 8. Schedule C, Line C - Total Units in Service-Remote 2 LINE 9. Number of Units-Remote 2 / Total Remote Units [Line 8 / (Line 4 + Line 8)] LINE 10. Total Maintenance / Service Hours Allocated to Remote 2 (Line 7 x Line 9) hrs. SCHEDULE C, LIVE B - CABLE CARD LINE 11. Total Maintenance / Service Hours Allocate to Cable Card 28,480 hrs. LINE 12. Schedule C, Lute C -Total Units in Service-Cable Card 341,764 LINE 13. Allocation Percentage 1.0000 LINE 14. Total Maintenance / Service Hours Allocated to Cable Card (Line 1 I x Line 13) 28,480 hrs. SCHEDULE C, LINE B - CONVERTER I LINE I5. Line I above 11,721,609 hrs. LINE 16. Total Labor Hours Allocated to Converters (Line I - Line 3 - Line 12) 11,107,049 hrs. LINE 17. Schedule C, Line C - Total Units in Service-Converter 1 170,827 LINE 18. Number of Units-Converter I / Total Converter Units [Line 17 / (Line 17 + Line 2 I+ Line 25 + Line 29)] 0.0034542 LINE 19. Total Maintenance / Service Hours Allocated to Converter I (Line 16 x Line 18) 38,366 lus. SCHEDULE C, LINE B - CONVERTER 2 LINE 20. Total Labor Hours Allocated to Converters (Line 16) 11,107,049 hrs. LINE 21. Schedule C, Line C - Total Units in Service-Converter 2 17,929,838 LINE 22. Number of Units-Converter 2 / Total Converter Units [Line 21 / (Line 17 + Line 21 + Line 25 + Line 29)] 0.36255 LINE 23. Total Maintenance / Service Hours Allocated to Converter 2 (Line 20 x Line 22) 4,026,830 hrs. SCHEDULE C, LINE B - CONVERTER 3 LINE 24. Total Labor Hours Allocated to Converters (Line 16) 11,107,049 hrs. LINE 25. Schedule C, Line C -Total Units in Service-Converter 3 14,388,491 LINE 26. Number of Units-Converter 3 /Total Converter Units [Line 25 / (Line 17 + Line 21 + line 25 + Line 29)] 0.29095 LINE 27. Total Maintenance/ Service Hours Allocated to Converter 3 (Line 24 x Line 26) 3,231,596 hrs. SCHEDULE C, LINE B - CONVERTER 4 LINE 28. Total Labor Hours Allocated to Converters (Line 16) 11,107,049 hrs. LINE 29. Schedule C, Line C -Total Units in Service-Converter 4 16,965,120 LINE 30. Number of Units-Converter 4 /Total Converter Units [Line 30 / (Line 17 + Line 21 + Line 25 + Line 29)] 0.34305 LINE 31. Total Maintenance/ Service Hours Allocated to Converter 4 (Line 24 x Line 26) 3,810,273 hrs. Page 11 1205 Attachments W U ¢ a 0 Q O O P Q F Z C VO O r Q o z2 4 aQ 7a u y 0 000 rv - v o O a °o 0 N Q O .dn m O - u O Q vii O a 6 O cG > 10 W Va z o o o rv P n M P o oOe° o m a x Q a M o a ° MO w W~ - w W - o o v e z o .a a n P~ ,s h p u M a ^ r o v c A u a ~ eo E G ~`r° rorv E""U z Mrv~00 V m m o 0 0 e o r u o 0~ a _ a o W 0 a o aW V r MQ 0 O U O o~ ° ° °m P -oaoo k" p vO+ 00 or - v .v-, r_rv o0 N W - O r _ fN+ P_ O N N O b ¢ w ml z M U o O 4 O O F z z z z a z 0 0 w 0 F- 0' z a F 0. F u a x w ¢ o o z rao a Jz¢ W O T F- -j W w W ¢ ~j w ro¢xfV [l ~0- S z ¢ u w m v ~Z -~Maa x h H z ¢ ^pu~Fw-Fw-Htw-Fw- a 1-4 U a w-~ a wwu F--~ ED wwuaaaax 5 u x x q a F a z a q F> w w w w w w q `3zww w ¢ t a www w O a > w W8 x ..l L2 X u~ em z > F 500 N (nv 000 rUi~ a =000000 N N V rv m ~ 0. ww' o r F W W o e F F r v r Q F - F ZW rv v Z r o U a P U N ~ rv N ¢ m ~ O X - O F r ° r r ~ P O O m m ° (-V P p n N lc~ N IaZW O.. z 0 V S m N b S O n w n P .Pn F 0.' > 0.' > VN'' XX e g F- GO U y. U a Q - - W W 0. a ~"p H Q o o ° g z, r e o c v v a Mo ^ W .ten CG O p _ rn o ^ j a N r o w' 0 0 41 m0 0 v° a o O vo _ X ° w a ~ ~ ~ a F m zr- Z u O N M ° N' h- X E y q e x a e- h M J rn E ~d~C w7iw~ - o ~ ~3 = W ~ gw F o ~ Q a W W U w W H x Q N v Q O 00 .~i Q ~ m U o-F. u Oz 0Z e r :o v°°i rv = o Q E -o ~ao y e F C O I a U~ m N o u m ° H - w U 0. U 0. ° n N- W Q W Q Ca m x U x x - P ~m W O O o O er .o 0 00 m mvm - o O v' 0 S - wi rn rn o o ~ p x~ °o m 'O e - p - _ F a - m X H W F Q F X w w tQ N y w a z w a a a 3 N w o a Q H a w 0 FvF--' ?W v' ?N '7 i~ m Z w ~ w Z < w U W O taA 0 O F ¢ y 0 w F w Q ¢ a a W 7 W ¢ J O J W F. F. F U ¢ F x O U N tQ~yy U a w a O Q u. O U ¢ T a tK E ¢ x Q W Fi W W a W > K > IUxJ y T Z ¢ z ¢ Q A Q F N N Q W Q N Q W 0 O rn N rn D N N W It'Z ..1 z J h w z ..l vim.] W W W u u J W W W vOi jUO~Q - Q jC.)O~ ¢ 20:-TT T SO'-TT T Q OT a F OT.-. `a F ~,Fu >F- w >0 00 vpi 0 04 w OF>mU mU W n w V a a 0 0 N F a 0 a F x w vu as 0 Z u ~ E F o w u ~ u au yy~~WWWWWWµµ1 y{a~~~~yy ~ ~ Q W W W W W wW U U 9 2999 9 2 2 w aaaaa µa<sw 4,4 j _j u Q Q Q Q Q F O F F F F Q a O a F F O y h N O v 0 0 01 0 m n n v 00 U ~ ~ ^ o,~ a v darn m w fro o - _ vt V M m N N m Oro W O ,n r O T oNO M U , V U V C N6 N N ~ oo h- n p. ' P m N P O O O O Q O r n M r P Q O r m r Q ~ Inn N r W ab0 G a P O G O :2 P h M a Q m' M N IM - Q Q O rl N N _ a 0 0 0 N w z z ~ X w vwN a w 2 i h X x 30 X w V X W vi w ~ tN aw t Vi N z N w m 0 O U y w 0 N 0 r 0 W N W W F N m 00 U U O U U Z .w.] W v, 0 v, Ca a ,z,[[,, w yJ~- m Ca a Fa- 0 Q U x O O ..3 rwiiF w'tuwO~`w u w z~' Zw v, a o a!'-WZrn~xw y u Q~~ w xN O m w U m ~u~iZUrn m w<¢a` ~Q Q U N¢ w 31 X W Q a ~ao0m> 0 z O w_ w w u q w ui a aawwuai O V0.awaw w z v ae~at-~pzua aQauau00 Q < zv/ 'd waa' u wo...xxx x N aa..-.xs~ x QJ~aa '-~rzd,j~Ei vyaOrn ra- a S F F F 0 u a 5 F- U a Q a a 0 0 0 w W W rn fn000 rn Vln 000 rn V vi rnoN U?Cim~rY>> wna.~iaZ O Q W r o - ~r orvP r. C7 mo$N~°° .MOVo hQ rn o.o ~rv rorve o W oM v~o -v M ~ioN Q v o W p O P vii P b M W O W v mPO=rmo~a Mo H 00 0 .o 0o rv - H< Mn a o0 on M z W N o o~n _ moots ^ z Q V b m~ _ O~ Q m m r N Q b N O O O N O h b 0 W~2 b P P O O h LLyJ N M O r U m Q O r r O o0 ~ m op P h N m 0 ¢ rv 0 OQ - O 0 U a - x - N o ~ r Q ~0 M N P - M N O y - Q r O N ;i Cl - M rPj Q O M- - b- m O N O~ O vrj vrvj ~D 0 0 r6} N v i m P~ b F_ M m a ~O N o~0 ~D Q~~ Q N N M N b M P N b O H N O O O m O- --V) Q P b m O -N VX"~ O M b N m v~ O F Oro O~ o e N.16 Qo o O .r~~O^ ro ryoQrn oh 6 -QM =°_r°vo Q w rn a c~ ~ H N M o rv m ^o z ~'r°-r-~Ov r.Nno -2 ~ge Q 0 o~Oe.-. qm ro v-v nom r Q Q QQQQQQ U e W °`rPnnrnrnrnrnM u .6 cz~ O p ° y l+~~j rn 0 M ~ O O~ ~ Q P Q N Q O W A N 4 0 0 0 0 0 0 0 0 0 O W~wI~ V u{ IL W O O Q r O Q N N M r w O V ~Q( I{.L11 ax Q c W ~ m O M Q W H w H - F o W a p q XO F r~ o ~Wz W O M h m r m m M P r h O M b O r 00 N M N Q M p Z p z b~ Q ~ - v~ M ~n b r-~ N N V Q ~O ~n O M Q M H W 7 f.,0 HO rn -m r °r' r X a ~ N M° rPi .o ~ ~ e~Q°~.o0o:r m E ~a << =a Mr r o r _ H < om QQNPO o o P r r °'P^ o O~ oPO"v re rvorn a No-_ o w to) N h N H ~ F Q ¢ Q < Q M N N O .a U N ~ ~ r Q N N ^ ono-oN mP O~n-o r ran "^rn ~oM~o LW a aC X rv v rn _ °MO coo ev -NO-It v e olo oC ~ MO Q' o O O N °Q c Q 7 M°rn .ro '"mM~ m P m e.o mNPOO~ X U O p- - N u- W [D _ U _ r o r a F .rn a ~0 00 0 or. E"' r M Q O - N O h Q N M N - M M a~a e ~ ~rnm rn °h`O°m ~ a4 V - r m m V O M P _ _ O N _ -N M -V N ^ O P w rQn - O- m P- m 0 N vQi 0 P .Q. h N b R p P Q N Q r O O 1~ O O m oQp' r P N ll] b m r~ P Q P ~ O U 4. M N ~ N oho b M - O M N b P ~ i La M H w H Q H o e ti Q e + aP o p w f% z ~ U Q x N Q aQ Q U w a N F in ¢ H y W W u kj oX (n NX ~n O N w W W W W u 0 W N r W ~j U t~il >w~R' } p >w pN4 Q uu w w> a U zUO 8i-- w zF Q W O F., < cn O lx. p Q Q O m O >w rn m y OU w> h j 5 W vuri Oa z¢ V W4 N Oa W U w W Z w ¢ W W W Z w .ul U < vxp U U a <<x H F-, 0 U Ci K m Urn H0.' F U a W -rv MQ ~ a >w -NM o f > 4 N W W> 2 U w vi W W W W C: u a XpC~ a: w au 4 U z' mFZ U W qq~vuy~~a C40 HQQ P4 C N _N,,,rwwww W p Orcw w' W W ww p p C) W. ¢w0 OKwQw d FFHF a W -KUQH F H F~ w vi U'i h a Ou w uU rn .u-1 x 9 S w u z p q`n rn HfW tw-wwww q v tW u w w>w>w w 0.' 000 W rn OQW> Z Q N~mZ ~OF a¢ He W ZOO z rd ~ tH- ~z~z'z~zx m a ao uuuu oooN ~x~u uu v °u° °axooHp° `x<°zpaxo0i SAMPLING PLAN & ANALYSIS FOR COMCAST CABLE SYSTEM RATES - Year 2010 Data - Prepared for: COMCAST CABLE COMMUNICATIONS Prepared by: Robert C. Hannum, Ph.D. Reiman School of Finance Daniels College of Business University of Denver Denver, Colorado 80208 February 17, 2011 Comcast Cable Communications Report - 2010 Data / SAMPLING PLAN & ANALYSIS FOR COMCAST CABLE SYSTEM RATES - Year 2010 Data - Introduction The primary purpose of this project is to provide estimates of the company-wide total and/or average for the following variables in the population of cable management entities owned and/or managed at or near year-end 2010 by Comcast Cable Communications (hereinafter Comcast: Primary Variables 1. Customer Equipment Maintenance and Installation Costs (End Amount) 2. Labor Hours for Maintenance and Installation of Customer Equipment and Services (Total Hours) Secondary Variable 3. Converter Maintenance Hours (Converter Hours) Installation Time Variables (Other Secondary) 4. Unwired Home 5. Pre-Wired Home 6. Activate Pre-Existing Outlet Same 7. Activate Pre-Existing Outlet Separate 8. AO Same 9. AO Separate 10. Move Outlet Same 11. Move Outlet Separate 12. Upgrade 13. Downgrade 14. VCR Same 15. VCR Separate 16. Trouble Calls The estimates derived through the sampling plan described herein are used for regulatory requirements, specifically FCC Form 1205. Values for the two primary variables are used to obtain an estimate of the Hourly Service Charge (HSC). For Installation Time variables 4 through 13, estimates of the population total hours spent on installation and the population number of installations (activity levels) are used to acquire an estimate of the mean time per installation.I This latter estimate incorporates both the average time per install for each sampled entity and the installation activity level for each entity. For the I Installation time data for these variables was obtained for In-House and Contractor installs, with final estimates based on a weighted average of the two types. For the Unwired variable, the estimate is a weighted average of Unwired-Aerial and Unwired-Underground installations (with each of these latter variables incorporating both In-House and Contractor installs). Comcast Cable Communications Report - 2010 Data 2 VCR Same, VCR Separate, and Trouble Call Time2 variables, installation activity levels were not available and estimates for these variables are provided based only on the average time per install for each sampled entity. In addition to the above-mentioned estimates, maximum permitted rates and associated margins of error at 95 percent confidence are derived for each of the installation type variables. A further description of the sampling design and a summary of the statistical analyses conducted are given below. Relevant formulas are provided in a separate section entitled "Formulas for Estimates and Standard Errors." Final estimates of the population mean and total for each variable, the standard errors for these estimates, and the corresponding coefficients of variation are given in the Appendix. Sampling Plan The population consists of 70 management entities managed by Comcast at year-end 2010. These entities vary widely in size, as evidenced by the variation in the number of subscribers, a measure of the entity size (Appendix, page Al). In addition, the principal study variables are closely related to the size of the entities. It is well known that stratified sampling can give large gains in precision when these conditions are satisfied, with stratification resulting in a smaller variance for the estimated mean or total than would result from a comparable simple random sample (see, e.g., Cochran, 1977, p.101). Available Prior Data Several sets of reference data from previous years were available to assist in determining the strata, the sample size, the allocation of the sample to the strata, and the entities to be included in the sample. These data included: • The number of subscribers (basic) for each of 422 systems as of October 1996. • Year-end values for the two primary study variables, End Amount (customer equipment cost) and Total (labor) Hours, for each of 236 regulated systems from the 1995 population. • Sample data from previous years (1996 - 2009). The 1995 data yielded Spearman correlation coefficients of .92 and .92 between number of subscribers and each of the two primary study variables. The Pearson correlation coefficients were .93 between number of subscribers and Total Hours and .94 between number of subscribers and End Amount. These high correlations suggest the use of number of subscribers as an appropriate stratification variable for estimating the company-wide End Amount and Total Hours. Additionally, sample data collected each year from 1996 to present also support this approach, with the analogous correlations similarly large. Finally, the twenty areas included the 2010 sample yielded Spearman correlation coefficients of .947 and .938 between number of subscribers and each of the two primary study variables. The analogous Pearson correlations 2 The Trouble Call Time is based on the average of inside wire service calls, customer-owned equipment calls and customer education calls, assuming equal activity levels for each. Come Y1 Cable Communications Report - 2010 Data 3 were .882 and .827. There is no reason to believe that these correlations would be much different for the entire population. Sample Allocation Strata and sample allocation were determined to minimize the variance of the estimated totals. Optimal allocation was chosen over proportional allocation due to the previously mentioned wide variation in area sizes. When the population consists of large and small institutions stratified by some measure of size, variances are typically much greater for the larger institutions, making proportional allocation inefficient. In this case, optimal allocation will result in a smaller variance for the estimated total than proportional allocation. Generally optimal allocation will require a larger sample size in a given stratum if the stratum is larger, the stratum is more variable internally, or sampling is cheaper in the stratum. An optimal allocation (assuming equal sampling cost per unit for all strata) was determined using customer equipment cost and labor hour variance estimates from prior data. The sampled areas were selected randomly within each stratum from the August 2010 population frame of all areas.3 The sample sizes and final stratum sizes are as follows: Stratum Number of Subscribers Stratum Size Sample Size 1 Less than 150,000 23 4 2 150,000 to < 300,000 15 3 3 300,000 to < 400,000 11 2 4 400,000 to <600,000 11 2 5 600,000 and more 10 9 TOTAL 70 20 The author selected a stratified random sample of twenty areas, data was collected and recorded by Comcast, and the author performed the statistical analysis. Summary of Results The twenty systems sampled in 2010 covered approximately 9.9 million of the 22.8 million subscribers (43.4%). The complete analysis included calculation of the desired estimates and their standard errors for each of the sixteen study variables, including three analyses - average time per install, activity levels (number of installs), and total hours of install activity - for each of the ten Installation Time variables 4 through 13 (see page 2). As mentioned previously, both In-House and Contractor installs were taken into consideration for these Installation Time variables and the final Unwired Time variable is a weighted average of Unwired-Aerial and 3 Although there were minor changes in the population between the date the sample was selected and the last day of 2010, there is no reason to believe the final set of population entities is not representative with respect to the study variables of the set of entities at the time of sample selection. The sample of twenty can be considered a random (stratified) sample from the relevant population. Comcast Cable Communications Report - 2010 Data 4 Unwired-Underground. Also mentioned previously, installation activity levels were not available for the three remaining installation related variables, VCR Same, VCR Separate, and Trouble Call Time, and estimates for these variables are provided based only on the average time per install for each sampled area. For the Trouble Call Time variable, inside wire service calls, customer-owned equipment calls, and customer education calls were averaged, assuming equal activity levels, to obtain an estimate and standard error for the combined average Trouble Call Time (per call). Primary Estimates and Precision The sample data, estimates, associated standard errors, and coefficients of variation are contained in the Appendix. The coefficient of variation (CV) reflects the relative precision of the estimate. For the two primary study variables, the CV values are 2.3% and 3.1 % (Appendix, page A6). These values are quite satisfactory. The U.S. Bureau of the Census typically seeks a CV of 15%, while the Consumer Products Safety Commission requires a CV of 33% or less in its estimates of the number of accidents (Gastwirth, 1988, p. 494). The final estimates for the two primary variables and the HSC are: END AMOUNT: Estimated Total = $908,545,054 TOTAL HOURS: Estimated Total = 26,911,566 HOURLY SERVICE CHARGE: $33.76 Given Total Costs of $5,786,642,212, the estimated End Amount equates to a Customer Equipment and Installation Percentage of 15.7%. Combined Ratio Estimate and Margin of Error for Hourly Service Charge Hourly Service Charge (HSC) is the ratio of End Amount divided by Labor Hours. The estimate of the company-wide HSC derived in the Comcast sampling study ($33.76) is a combined ratio estimator based on a stratified random sample. Formulas and other technical details regarding the calculation of this estimate and the associated margin of error are given in a separate section below entitled "Formulas and Calculations for the Combined Ratio Estimate of Hourly Service Charge and Associated Margin of Error." Margin of Error and Confidence for Estimated Rates The table below summarizes the 95% confidence level margins of error for the installation and equipment maximum permitted rates for 2011, based on the estimates from the 2010 Comcast data and sampling study. Two methods were used to estimate the margin of error for these rates, one based on the hourly service charges for each of the systems in the sample, the second based on the company-wide hourly service charge. The values listed below represent the conservative of the two resulting values from each of these methods. Comcast Cable Communications Report - 2010 Data 5 Installation Type Estimated Permitted Ratet 95% Margin of Error2 Unwired $43.93 ± $2.88 Pre-wired $32.41 __+$2.13 Activate Pre-Existing Outlet Same $7.79 ± $1.61 Activate Pre-Existing Outlet Separate $21.77 +$2.09 AO Same $14.16 ± $0.66 AO Separate $31.53 ± $2.91 Move Outlet Same $13.61 +$0.84 Move Outlet Separate $32.24 ± $3.55 Upgrade $20.10 ± $2.26 Downgrade $12.07 ± $1.21 VCR Same $8.58 ± $1.26 VCR Separate $19.12 ± $3.00 Combine Trouble Calls $33.59 ± $1.99 1 Computed as (Combined Ratio Estimate of HSC x Estimated mean time per install). 2 The 95% represents the confidence level associated with this margin error. The margin of error is equal to (1.96 x standard error). REFERENCES Cochran, W.G. (1977). Sampling Techniques, 3rd ed. New York: Wiley. Gastwirth, J.L. (1988). Statistical Reasoning in Law and Public Policy, Vol. II. San Diego, CA: Academic Press. Govindarajulu, Z. (1999). Elements of Sampling Theory and Methods. Upper Saddle River, NJ: Prentice Hall. Lohr, S.L. (1999). Sampling: Design and Analysis. Pacific Grove, CA: Duxbury (Brooks/Cole). Scheaffer, R.L., Mendenhall, W., and Ott, R.L. (2006). Elementary Survey Sampling, 6th ed. Belmont, CA: Duxbury (Thomson, Brooks/Cole). Comcast Cable Communications Report - 2010 Data 6 FORMULAS FOR PRIMARY ESTIMATES AND STANDARD ERRORS Ni = size of stratum i of areas in stratum i) n; = sample size for stratum i N = I N; = population size (here N= 70) n = n; = overall sample size (here n = 20) y; = sample mean for stratum i Si = sample standard deviation for stratum i s? = sample variance for stratum i Estimated Population Total: Y = ~N; y; yN;(N; -n;)sz Standard Error of Estimated Total: n; ZNtyt Estimated Population Mean: y = N 1 IN, (N, -n;)s, Standard Error of Estimated Mean: N2 n; Allocation: n; = n N;S; where Si = true standard deviation for stratum i Z N; S; Comeast Cable Communications Report - 2010 Data 7 FORMULAS AND CALCULATIONS FOR THE COMBINED RATIO ESTIMATE OF HOURLY SERVICE CHARGE AND ASSOCIATED MARGIN OF ERROR Hourly Service Charge (HSC) is the ratio of End Amount divided by Labor Hours. The estimate of the company-wide HSC derived in the Comcast sampling study is a combined ratio estimator based on a stratified random sample and can be defined as follows. Let Y = End Amount X = Labor Hours p, = population mean End Amount p, = population mean Labor hours N, = size of stratum i of areas in stratum i) ni = sample size for stratum i N = I Ni = population size (here N = 70) n = I ni = overall sample size (here n = 20) yi = sample mean End Amount for stratum i xi = sample mean Labor Hours for stratum i Y = XNiyi = estimated population total End Amount X = JNixi = estimated population total Labor Hours y = Y NJI = estimated population mean End Amount N ~N.xi x = N' = estimated population mean Labor Hours R = Y = population ratio of mean End Amount to mean labor Hours 9x Then the combined ratio estimator of R and its estimated variance are given, respectively, by: rc=Y X and z 2 V (rc) (N,)(A; _n i N niNi x? Comcast Cable Communications Report - 2010 Data 8 where Sz; _ (y - rcx)2 = sample variance of the (y - rcx) terms within stratum i. ni -1 To see the contribution from each stratum to the overall variance of the estimator rc , write the within-stratum variance component for stratum i as: Ni -n. )'S2 (rc) = . V n; N; xi The estimated variance of the combined ratio estimator can then be written as: z V (rc) - N~ V(rc). The following table summarizes the within-stratum components for the 2009 Comcast data: Stratum n; Ni y; xi Sri V r. 1 4 23 $2,873,111 91,734 350,823 3.02 2 3 15 $7,478,706 222,571 830,606 3.71 3 2 11 $10,906,864 346,834 1,548,066 8.15 4 2 11 $22,282,187 660,246 2,176,087 4.44 5 9 10 $36,520,337 1,038,524 2,843,394 0.08 20 70 The combined ratio estimator is: _ 908,545,054 _ 26,911,566 33.76. The estimated variance of this estimator is: 2 7 3 v(rc) = if 3~ (3.02) + 115 (3.71) + flA (8.15) + (1W (4.44) f I AWN (0.08) = 0:81. The estimated standard deviation of the combined ratio estimator is A-181 0-90, providing a 95% confidence level margin of error of 1.96(0.90) = 1.76. In summary, the combined ratio estimate for the HSC is $33.76, with a 95% confidence level margin of error of ± $1.76, yielding a 95% confidence interval of ($32.00, $35.52). Comcast Cable Communications Report - 2010 Data 9 7 , . r s z Population of Comcast Systems (12/2010) 16 14 12 10 C $ ~ F T d, 4 i. 2 0 100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000 More Number of Basic Subscribers Comcast Cable Communications Report - 2010 Data, Appendix page Al rg4 GL NUMBER SYSTEM NAME STRATA SUBS End Amount Total Hours Converter Hours E000615 TUCSON 1 69,569 $ 1,882,213 63,473 25,853 E000333 SOMERSET 1 70,928 $ 2,363,041 65,762 31,090 E000546 SAVANNAH 1 109,175 $ 3,950,644 119,677 49,996 E000425 CHATTANOOGA 1 115,612 $ 3,296,545 118,023 46,213 TOTAL MEAN(M) $ 2,873,111 91,734 38,288 SD $ 927,797 31,332 11,638 ESTIMATED TOTAL NUMBER OF SYSTEMS (N) 23 (M N) $ 66,081,547 2,109,877 880,621 E003706 MEMPHIS 2 191,931 $ 5,981,027 200,206 75,098 E000310 OCEAN/MONMOUTH/CENTRAL 2 262,698 $ 8,541,578 227,486 109,022 E000868 PLEASANTVILLE/VINELAND 2 273,408 $ 7,913,512 240,022 83,390 TOTAL MEAN(M) $ 7,478,706 222,571 89,170 SD $ 1,334,503 20,358 17,685 ESTIMATED TOTAL NUMBER OF SYSTEMS (N) 15 (M N) $ 112,180,585 3,338,568 1,337,553 E000130 TRI-COUNTY 3 319,633 $ 10,313,232 296,826 108,060 E000591 JACKSONVILLE 3 350,956 $ 11,500,495 396,842 131,843 TOTAL MEAN(M) $ 10,906,864 346,834 119,952 SD $ 839,522 70,722 16,817 ESTIMATED TOTAL NUMBER OF SYSTEMS (N) 11 (M*N) $ 119,975,499 3,815,173 1,319,469 E000761 PORTLAND 4 497,084 $ 21,785,638 691,116 320,259 E000741 DENVER METRO 4 535,922 $ 22,778,735 629,376 193,978 TOTAL WAN(M) $ 22,282,187 660,246 257,118 SD $ 702,226 43,657 89,294 ESTIMATED TOTAL NUMBER OF SYSTEMS (N) 11 (M*N) $ 245,104,052 7,262,705 2,828,303 E000854 KEYSTONE EAST 5 636,219 $ 29,522,841 785,207 428,582 E000771 WASHINGTON WEST 5 645,832 $ 26,153,625 733,212 354,658 E000288 SOUTH BAY 5 702,182 $ 38,428,829 1,102,562 606,632 GBN000 GREATER BOSTON NORTH 5 717,425 $ 21,955,426 573,014 284,295 E000159 KEYSTONE WEST 5 740,691 $ 35,147,763 947,546 501,379 E000168 SOUTH FLORIDA REGION 5 754,957 $ 63,397,353 2,038,154 1,199,502 CTW000 WESTERN NEW ENGLAND 5 798,685 $ 31,892,032 913,267 445,464 G13S000 GREATER BOSTON SOUTH 5 990,455 $ 33,468,766 851,657 420,456 MIR000 MICHIGAN REGION 5 1,116,855 $ 48,716,400 1,402,099 579,130 TOTAL MEAN(M) $ 36,520,337 1,038,524 535,566 SD $ 12,629,073 442,792 268,702 ESTIMATED TOTAL NUMBER OF SYSTEMS (N) 10 (M*N) $ 365,203,372 10,385,243 5,355,664 11GRAND TOTAL 70 9,900,217 $ 908,545,054 26,911,566 11,721,609 Estimated HSC 5:n.'k 33:7G Comcast Cable Communications Report - 2010 Data, Appendix page A2 - - - - - - - - - ,k. ^Y On n00 o M W V p M n W n SNrypppp~8~ NaDm p Ui hm ~m mpNO Q~'jol pym~a0 S 00 80<8rQj „mmr gb5 e O O W O m O O O O O V N $g O OON OOG 00 ~-0~ .~oC1 .-0 - - G - - O GO W E: O S O m mn M n O N~ h~ Al p N 1 m m ~ S f O Ki W W 8$$ 8 S M° S ~ O ~ m ~ 33 y O aR `a ~ 'yn° u~ m o u~ n 8 m S °o n o 00 N m N e ~ R ° M < m NOfn'1 0004 N~ N V y NOO 00 OOaO ~ ~ ~On +-00 . . O.- . C 00f0 Fw Y 0 888°8m 888MS 8 S BSo~W~ 88o8a 8888p°p U$ N S m N O O S e N N O m S m O S b N l ~OVf ~O~ ~On - _O - G - - o G 0 vo O O O n n n n n W f n n m.- W 35 OOOm mNn S 08 0 Oo Q~jn .-mm S~ mYm1 O~~ mSpS$ tmp$p y Im (5 N SSO O o h S SO O O 00 00 V N~ GGNON ~Nl$O$ 000000 V 3 t `y: N 8 0 0 0 8 S 0 5 f^ t n o S 8 IO W 8 N~'~~e dog~nm WN° G G O ooooop~ o 0 o O t.: G O O o . m o o o O O o o o o o o w i ti:. n°oo°ro °nrn 88rory o 88nm2 88 ro°e $$n$mno oon Nn~ 3~; i O N O N O f~ N O N O 1Nf N N O R f y VO~ O N o o N N O N~~ O N L~. ; 00 00 0 00 0 0 V o0 GG n Oo 'o OO oO ci e- Sy~' yf/~~ {~y 8 m m N W pp o m N m ny 8 Cl Y O N O T O N N m 0 r m O p N Y ' g O N Y o SoOC S f N O N O ttt+fr fff tn~l t0 IV V S O N O M V O C O O 'v [ C O o 0 0 o O y~ y o o f u o o G O N o C qm G 0O0 O O O G O O o o O 8 O O y O O S2 8 aS ~tp S ym 017N N"N O n Old m~m0~ Y~m Om tN Omd N SH) X<h OanD 0 V S NN On hm m'-b S V YI m O 0 0 0 0 0 0 0 0 0 O G O m o G C O n O o o o 0 0 0 0 o O Q. g g g 0 oom ~n oGn 6d Go coo Go 6 c5 ofd ~ m o0 00 oom 66 oGe oo GOV GG OOGOooood Q; a 8 N -2.3 W A S$g 8 W W' gg 8 8 m° S O mgO O BS nco om 88SSnW ; 81W8 e 8 ~82~r 8m&~8$~~~E7W 88 ° W m m W W o m W 00 GOO ~O CO' CG o0 Co OOOi X000.-0 BOG COOT »~t V a b ~ I"'... s g 5~ Q Q N; ° -g 8 m 8 H ,°h c~ m 8 m°~: 2S 4x E ° 25 25 8 0° ^m 8 S ~ 8 8 m m 8 8 mo do n 0 o 00 03 a °e ma ciom v o°a c e o°a.g°n a 'Wti o 00 o o o C O ' ° o c a o c o o a o 'oc ooo GO ooa u1.: ' e~, nooome S g m metro°1 tSDOro W;j.Q~ N88°n8$n Nn" .1: • 6 p a M S N N d ~ S 8~ O~ S Y A N m ~ A 10 n f0 O° ~ m N r N~ N ~ M b oGo 0 000 0 on o 00fG 00 Gdn o 000 oGoG 00 nw` w O n n n O A N n ~p n O N C N m.N n m P O N t0 m$ 1"1 CO i0 O$ t0 O O r m O m m N, iOy R roONN W n v° DB ON 'N000 NN Y Nm~ oN N mOmh ~L1J 3a 0000 oo0 OOOOfV 00 0 0n C 000000 J t` < W i_Ql.. gg gg gg gg o o. F 88~c~N8 8SS3om 8888m mVs ~o~ 8889"88$8888 a p E . 0 0 0 o e- 6.666 0 0 o O O o 0 0 0 o o O T yy VV V pp ~Oy VpNtO yp O N 8 pOnOOm ~Nn ag m O n N S ofpp nWaV WO 4 N g 8 (m ry m 0o O N N W° h S n S O 8 C od N O YNl N N NON N N N V N N N ] N N N O n 3 f~.... N r ZNiE fi mO Zog t0 Si =N? bN'~f/! c k Nm ~ -V "t -o Om yZ frV F g WZ m - n G^8~ -z f "f? m oovi< -w fz 8 w k,'.: N ~ a8N ~ nvw ~ a b ra- ~ ~ w N N ~ a ~mmm~mm k z z z z z ~ ~ ~ N N m N N x W Q W w W w g g g ~ ~ H H f 3 N iZg W N N ¢ OZD fY/1 pp z O =Z O O O n Z w(7y p S8 w w K Z z z z t~' w w D~ w w w HW OrmwOp rc H _..t N f~ f mz ywawoo m > g 03d'~ow f a3{ fn rxo z O~ z z ❑w z w°>mwOZmtt zNZ z m~Z ~Z Z~ Zl7mwo O W < Z 8 u {s~! Oax wU < Ow wao'w>wo'wwo yv ~fn fnU ~Oa ao Y3fn t7Yfn3c7~ 5 ? r 1 w mn N I oom o M' rov mom W~ O a ^"n o8 w o w oS w o w o°nQo8go~z88 w o! z 888° 888 .1 8mo8Fina a8 ww ww w ww l ww ww w w w(7ww 0 2 r r H < F a O N O W O N O m O N m; . F w H w F w r w r w O a Z Mn 000 V) C) NWnn Otpr~ W N W ON t00 O CO M n Y](OO W MNt00 M 00n tDOO nNn dnf0 Nn NN Nnn n0 M 0 OB ~nOWnO W dnN nom ao .D 0 00 tn (o nn O m WriU) On W w M(on M000U) yy n Wn 0tn(. n * m d N 0 t0 0 ~WO W O W00DN tO CD n N eon a0d WD (pM0 n n 00 W000) tp 8 p d N N M~-M C)OIM CO W d d I WO (0 n 2 U0 c " d tD n (0000 co n ~o n WD IT fi O N N N N n N t0 N N to ai ~ Wn (d M (+i r t, Q l 0 N M a M M N W 0 (p tD M M t0 W N M N M10 W N n N 0 N O n N N n U) N f0 M WO M s W Cl) M ~0 n.0 C4 OO W N.-n MO OOO N'- N t0N N Wn OO ~ n ON Md r O r r d O d WO 0 n n N O O tG O r 6-6 O d O M tD O M N d d o N l") Wf1 0n Wn Ndn NM Wnn CO N~ N ; N NM M IT W170) Cl) Md N0N0 0M N 1 O n n M to N M M n M d N W to W 0 O O n to 0 O N 0 n O d WO N n n 0 W N O a M d N t0 t0 to co L6 Lei --4 d O M N O N 06 N O N 4 Q F a 00(00 n ' 00O 0) 0) W LOO 00" (00 w 0 0 n O ow n O to n co 0 (0W IT `a .m ONMO N(0 O(O.- NnM NM W Otp NO n Wt0 W 0 0M 0 t0-00 yOb 0 C m q O 0 00 Md r OO W nN 0n.) O ONO 00 N no1M ((010 M(OOOtAmn C) O a N N N d d WA n h 00 IT E m° N A W U m 00 0 8 O CO) IT 0(p t0 cO(OM Mt0 n n OO d .--0 O ; O d 00 00 M O O p n U 0tn(DO MD m 00(0 OMr nO d N'W! (00 M do 0 00 W000d; (O Mnn 0D i E 00-00 Mm ui o n oD 'D m ~O (WOD M N N i CD OM 0i 000h d0] W ('7M a (NV ff~~ .-d (0MO d Mpppp N r' W n N n O N IT M O O OW O m I Mn0 0,y M tn0 M(pN Oon MOW NW N W0N to n n W[)ON n NWO 0 (D.0w d c0 W`0 M WO N0 BOOM dO N Nn WO(O~N to 0~0N n(Dr an0 m m n n (D W WO tD WO t0(OO n M^ 000 O NO OD Mm O0 d d n dOMd ON P- m M d ~'-Nnn NM2m O0 O0 dO~ WON 0 0 W d N O O O d 0 O IT O G OON W t0M0 W d 0) M N OO N O O Vi n N n 0 t0 W Q- N m d N NN N M - N ~-N o y3. ~ m o M O M O W M O N 0 n m O O d w m M w N M M N M M n m N N ^ IT O M E O CO f CO N0h n Wpd OOM WO WO M Ma! MCO M It MOO OM M tp OOd i n N n W `a (D O a Wf) w aD a 0 (p (fj t0 CO M N O W0 M M Wn m tt) M Ih w 0 M d aD '.f ~ If1 b o M W nO aO 0cO W00 ~C', 0M tt)(p (D Mw tOn (0001 n d C,"M a~N (O yy (yp d tO N t0 t0 W 00 f %f n N t OO tO M d 0 tO tq WO n N N d _ n d m co O W tf) M N O d m d (O 1~ M 1~ t() t0 tp tp O (O O I~ d - N 0 Q d N o u N O O O n d W N M N I MIT d 0 N O M O d w w O n O M O O O 0 3 op M a 0 Mood dNn wtDO Otoa 00 0tDn Nd co d N O W (0000-0O ON W WD IT Cl) 1M~ .m.. W 0 n CO e{ f~ lV c0 0 O f~ O M O w 0. M tO N N fD . . . . . 0 1h 0 0D r n d (00000 (p NCO (p~0 O o" a0 0 On yy M to a ~.-nd MNM don OM0 co d WOIT On C'! Cl! 000 of Orr aU r Q j# 1n 00 N O CV N N N m c7 N d 01 t, 15 n m Md ddN O' e- MO W Owl Md MN d O0 o M000 MN 00 O d nM O0n N w 0 W M tpd W -q W It 00 M0 OO t0 to IT O W O ^m to 0 tV N M Cp Wn 0 0 (h M 0 O W O d O W M n 0 0 m n 006 a0 1fl g E M Md N 0(pIT ~00 OD(00 N OM NN Mn 0(D 0 M(0 N M W p N N 0 0 0 M n m O n d N n M 10- 1 n O N 10 n N (0 B O N N N N w d N N C6 n N th tfi O O t0 00 Di 0 W d d N N 0; (ti { N IT n N IU CN N 00 NMM N 0 O W O n MW O ON W M 0u ON MWO-0(000 MW W N 0nWD WO 000 dnN WCN O~ .-NM On W W On 0df0N000 0N(4 W (DO n N0N M n V)N (DNn (od tOm N (0 d w 0 U) O d O 8M m N d 0 n W~i N t m d O W n O t n Nnn n O M n O t O N O O M t 0 0 n 0 0 n O W 0 Cyr s tl ya„ M n Cl O000(0 0 ~n Cl N NN OaD N N.-In NN d d ntON NN 00 n t~ 2 N t- N d M f7 M Oi n O 4) 00 n M O d O N d (V n W!) 0 0 WO WO 00 t0 N O n W NN nmM n Wpn OWN nN 0O n0 t0 0N OOMN W 00 m 0 a0 ~n to NOM non rn~ MM V On N W N X00000 OONnoon NMO d w 0000 0pin m M M.-O 0(t'1 0th n 0(iJM O?0(V n d tt) O) t0 Wf1 tC lV q N On OON n 0 Od N COO m O NWO M N MONO t0 W N 0t0 .-M~ NNN N 0~ ~n d d IT dd d W n d NtnOO ntD~ WON 0 0 v M vi v Wri 0 M.0 p 0^ tom Z Z M (p Z dd N ^Z Z O N N W W() n N O 10 0 Z n 00 V)♦ M N m♦ cON Cf1• M o0N 0 NtDON N W0 0 tD 0 (O d W O 0 0 N W d (p .1 -L! Z QY m of o of (i Z z z z M O (ono.- W M W O1 Wr°) a rn n Q (tD n vonv°tdnrn rn r Q ° J N N M M d N v w O n n n n n 0 ° Q M 0 N O O n :t ~ N NN MM d d Nt0 t0 W0NhWD OM Z Z Z Z Z J ui ~ w Lr W a W W W W C) U) En Lli Tn ~i. U) WQZ ! Y ZZj U) Q LL p w LL LL LL O p Z O x Z O O O F- Z 0 N 0 W W F K LL' W Z WQ- ZZZ K a no O=W m m O m~ O~QwOO m m w U) O 7 Z J D } J 7 W Z 0 3 R' W O w 1--xO Z OF>- Z > Z 0w Z w~>- W pZ m~ Z ZI<z (n:5Z ZZ Z~ ZU mKZIJiZWZ T' Ow z< aZ(¢ O( ¢w ~ZxF-~xWF-0 - U j Q W W W U U w Z W 0 W} W x O a x w 0 J ~ a O w Lu Ir W O W W U F(n(n0 20LL F-I (L C) Y~(n C7YU~O2 ~ t J J J J J p Q Q Q Q Q V it m O O O O O J w a o co X0100 F o00 ~ nOi of ~ (ov F- Wdn W~wm o 00 0 W 0 000 HFUJ (n O 00 0000 W W O 0 Z O = Z 0 0 0 0 000 0 0 0 0 0 0 m O O W W W W a W W W W W W W W W W O W W O O N O h O (n O t'n ~n W Moo F-- W W 0F W W 00 W F- e _ ix N M MmN x0) 0 NOd m~ 0 (00 mM Mm0 Od mNdN00>mm n mm n m m O~m N Mm and d (DMN NM mOm Nm OrM Mr and MNm~ d m.-m (D O co to ddM M(D d mn N0)m m~ d MN r m MMM dN00 Mm (V M M mm V q¢q N O(+im 0 (OM MNN to mM and Om M tDM and r MNm V) mMr N mM N C _ N N n d M M d M t0 t0 ui tp r n m O ~O m n m 10 n 11'l t0 N N ¢ M (l1 M m N N ui e p m y', M ~d r m d d r MM M mm wo m tD.- mID O ~ mmom d mmm m n N m O Md0 d mm Mmm Mn N Mm - M n n d MMd r mcb (y) u) dM N 00) o v M W M M r N m r o (D V O O M m 0 01 M v) Cl d W d N m! r O O N 0 m O N r rNM MnN M d M~ m mM Mm N rMr mm m NmM mN M r m (D g M M M M N N m m M d O M C a M m N M m M m m N m q r c N! m c s! m r~ m N ~ O N M N O N m M M E M N N d O m m m O r M m N m N M m ~ ~ r ~ ryry m O O N o m N r O m m M N N(~ M M m d m n 0 d 0 0 r d m co r o n M m r M m d o MNO d0m Om cno MN mM m mo Min m(0mm ~ o m~ N Mm N m O M m 0 N M u7 O M M m ui M O m M u) N O (D M m m m r m 0 0 M W N r M ai m M d N M - N m m N n M N d M n co N m r m ky}~ 6 N M m r N E A.1. ~ N M r tp o o mmo to O.-M Mn MM dd d o r0m o ONmo OD mM v r m d w O Md0 and O.- d MOm Nd mON MO mNM ommnNO Mm d d M r U C) E. O V!O Mu) Or n N r0 mmn Mo N(Om Md-woo mr N N N m E O) N NMI M N O m Md N MN MM mmm m N N m N M m n N m u 9 m N r F6 2 U -m m M M m M O m M M d m d m M m M O m N m M n m O M r m m o m r m m M N MOM M r O d 0 SAO M m m m m m M U1 ~O O tD IO d m r 1~ m co nNm mf`ui Mw l_ Nrw dM V OM M6 O mm MrNmON mn m m M n O m aa M M Cl m M m m m N O V N CO r O m m O N M W M M aF O) F~ m r- V d NCO OO M'-N w t` m MNmm Ci d nN (0Od h N N M d N N m 7 M N - (O p N a O mOn M Od n OmN O M N M m n M OM0 IDN n r n n MMr M rN m o r m0 d mM MN.- mrM d0 NMM mn NdN 0M (q CO It MM N mM m ~m M M O MOi O m co m 1'M M M d N t0 nm Md(0 MmmmNMc~ r n 1, N M NmN N Mm Md M (Om mm mMO r0 d n nmr OMM OOm MOr n N W NW 0MN my d mn N (DN d MM mmM ~mmMMm mdtD Na)M a0 O - M N N M N - r b N N M N N M W N V O d N dN Q mOM mmm (DN m mNM m0 mmm dM mm Om MOm MOOM nmM m -m M mm(0 ~--NN wm c-4 Mm MO m0 .-N u)'- M oh MO M m OOm a) t, n m a rai Mui oid ss~~ V o M6 006 ai cv vM Moo d~006r Mo6M (D V m ai m M m r M m M V) a0 lo m o r r mom an d o W y n N O n m M m n ^m MN .--.-M (Od d M M N d Nm mdt0 rm V) mM O d Mm W mmOr mMm dNN MMO r0 m0M Mr da~ mu)OOmd o OM dMO M mmnm M(0N rMm Mn m O Mm d N N NM n MMOM O O Cl) 0 O d d MmOm O(0 nd a> n mM MO 0 r OO MMn Omr Or000d mc,m ai m W E M m m M d m M M m m M m M (D m M m r N m d M N N O n M QI N m MN N NM and r m.-- M M N m M N r tun d d d mN m dN n a W N M(n m MN ID MM M m w m N mM M O N 0) IDM(D N O M M N m M r m d m (D o r 0 tu r d n M d o N r M m O O r m M m m M M m M m mrm6 (V MF` (0N o m MN w(0m OM wwM om NN~r 66 ~ w ai I M OM dMm mom mrM mM d ' mr NOm NN M Nd OO Nmm (a M r M (O r f: n Cl O m M co m (O m m r n M m N O m d m N r m N It a N N M d M d d r m m m m N m d o o M M m r u) r N u] 1n (O m m m Mn '-rm Nm0 dmM mm r d N mm r Nd mOOm OM Mm Om n n E v h r m M M d M w N M n r r m M m N d M d M m m d r c0 d m N m m m m m m m m m m V W O M N M r m M d M O N N M M M 6 n o N M N t~ F` O M MmN N ~m N n M 00 Nr 0) 04 r N r mr W04 m 0(0 d M r N M - ~MN N N MN M Min Nm mM M mM M N tun Mn mM Om~ n (fir d ul N tG m m a m m M N Z m m O Z M m Z V N O Z m N N M- n M M M Z r J mN n~ V) Mm0 VJ MM N• mN M. Mc2 N. M. MM u) M O f0 Z m U) d Z m M Z O m Z N m d m m m d m Z N ~ r Q (D u) N n od oc, Q O m ED Q N M Q m0 Q M m n0.- w C w u) w mM w Md o IT mm 2 w O Q ANN (hM dM (D(Drr~nr nm^ m p of Q M M O O F.. N n t r' N N N M M d d M M M M M M M M M W £ Z Z 2 Z Z u) IE uj w w w LLI O w 2 x _ a) z z u) vi uu)) ~ z °z ~ w o LL w LL LL W Ow O O O Oz 00u) 0 LL O Z O x z 2 K W W m a W ~ W W W W z z 2 z " 0 m W O m F Ouu)ia w0 W u~ tQ7 ra co ca aZ uu)iwo3~t9 ~a Lij F'x0 Z O Z > Z ❑'U z W~>m W0zm z m z-j ' Zl z u)2QZ 70 Qzx Ozm WO - WwQ U a u) W <r-- d Q Q OY u~jx lx- QU~j H Q= m m U~>Q ~ww O Wz >NOw»Ow ~m ul 0: F-a wOa ~Q ao Y3in C9 Yi F- u) uu) 3C7~ Q Q Q Q Q Z m f- F- F- F- F- m s w O M M V O O O O J co N ~ o° tm0 ~ M rn ~ an d ~ f~ co o (mD o 0 0 F- Q a Ooo~ W Moo O M rn O mr Nom Ooo 0 F" i t :D oooo F- Moo H °o °o F oooo ooooooz°o°o3u) w FO m " - Z oooo ooo oo 00 oo OmooF- m - F" W w wW J Q w w w J Q W W J Q W W J Q wwwC9 Ww00 J Q O m a Q z Q Q Q Q Z Lrn F- H F- F- F- H F- F- F Q _m 0 M 0 N 0 uF 0 u) 0 u) 3 m 1-- W F- W ~ W F- W F- W (7 r PRIMARY VARIABLE 1: END AMOUNT (CUSTOMER EQUIP. & INSTALL COSTS) Stratum N n Mean N'Mean s N(N-n)s2/n 1 23 4 2,873,110.75 66,081,547 927,797 94,043,272,898,350 2 15 3 7,478,705.67 112,180,585 1,334,503 106,853,865,991,820 3 11 2 10,906,863.50 119,975,499 839,522 34,887,437,421,433 4 11 2 22,282,186.50 245,104,052 702,226 24,409,480,872,373 5 10 9 36,520,337.22 365,203,372 12,629,073 177,214,977,222,737 70 20 908,545,054 437,409,034,406,713 ShinTofa:s_1gV.7,_ Std. Error= $ 20,914,326.06 Estimated Mean = $ 12,979,215.06 Std. Error = $ 298,776.09 COEFFICIENT OF VARIATION = 2.30% PRIMARY VARIABLE 2: TOTAL HOURS (RE: CUSTOMER EQUIP. & INSTALL) Stratum N n Mean N'Mean s N(N-n)s2/n 1 23 4 91,733.78 2,109,877 31,332 107,252,779,115 2 15 3 222,571.22 3,338,568 20,358 24,867,536,351 3 11 2 346,833.91 3,815,173 70,722 247,576,219,367 4 11 2 660,245.87 7,262,705 43,657 94,341,668,551 5 10 9 1,038,524.30 10,385,243 442,792 217,849,699,772 70 20 26,911,566 691,887,903,156 ho"Nomwiff" i ~R51 0 6;9, 5$w Std. Error = 831,797.99 Estimated Mean = 384,450.94 Std. Error= 11,882.83 COEFFICIENT OF VARIATION = 3.09% SECONDARY VARIABLE: CONVERTER HOURS Stratum N n Mean N'Mean s N(N-n)SS/n 1 23 4 38,287.89 880,621 11,638 14,796,301,809 2 15 3 89,170.20 1,337,553 17,685 18,765,988,073 3 11 2 119,951.69 1,319,469 16,817 13,999,310,590 4 11 2 257,118.42 2,828,303 89,294 394,685,676,303 5 10 9 535,566.36 5,355,664 268,702 80,223,257,718 70 20 11,721,609 522,470,534,493 Std. Error = 722,821.23 Estimated Mean = 167,451.56 Std. Error = 10,326.02 COEFFICIENT OF VARIATION = 6.17% Comcast Cable Communications Report - 2010 Data, Appendix page A6 n ~ N d 0 t0 d N r N n N e ~ ip tp r a M N d O rn Q a IO a0 d (O N n o, W d ONi y m N N n O M N rn `N 0 !1". ~ O O~ N OOi rn m a N I~ N ~ N IO N d aD N O Oi d rn n Ol o N rn N r Z N o a Ina rn N o d Z n a m o~ Irdi rn a o r X • Z rn m a rn rmi ~ in ° Z m c~i co Iri 16 m N •e Io a s a M rn N M $ !s; r N i~ n v d d cm ~ m N N M W tp N 2 ' b N d fp M N d rn m aD d N (O II II 11 II II N N _ pp 11 II 11 II ~II N - N a N N «0 p c p Z Y N r d M N ~p ~ II Q Z Q I+i rn co N n o y O M co ao g m p - o LL, 1- Lu M IN ip d D V D Q ,G r m ap D D w Q C N 10 N m N Q ~ t d N N ~ u t E E pa E E > lan INn_ INn .d- r Lu W p ~Nmii r v n m Ury M w O c trno N n n N F- 2 arD N N I00 o W ~ Z N I~ N N n N Z > r M a N In Z O ui ui co co n W O Z n o rn O N uNi w m LL O d U U w W c Z N ro m n U w m N O w w w p V '~y . 7 N M N N n a b O w A N D m ` 70 v so of Iri a a ~Vi. Q C d M N N rn N p ~ C d m N N a o p S m ~ N J Y. m J r O Z 'r' o ro ~ Z O J W r'. Q K m E .lw IA N M d N 3 'N H N M d N W €n. Z y = ~ Z N a Z N S N rn M a 0 a0 n e . N IO N N a M .ik:' ap ap O 1p O N m pd n y t7 N d O r M m i0 m i,i - C6 .6 Z d o LO O rn M N N f~1 d M Z - <O aND b - d M I N d ' In Z pi v m r Ono N N M Z O m n ri 10 VJ 10 o rn n Io rn M r M 0; o v m d r nso d d cl; L r N r 0 m N L r . - N OD m rn N n II II II 11 II II 11 11 II II 1$ rn ID c0 N C m O N N N _ '(Q N p `O Z rn N N r N Z O d° N I° w W o rnD rn w w -4 in- rn rn E E > E E > C M N rn N d a LL o0 M IO M - LL b r O IM Oi N M w W F- m th O N O~ 1~ w w p a aN0 N Z N u~i r 0 Z I In Z d M N d IA d W Z N rn N cD w N U d N a ~ N n U $.(Q. LL e- ~ d LL W w O al O c m wM- as°D m p _ N A M N O N ~ ,fn.W ao m rn M rn U n w d d N N U 6' N d d N E aND ONi N m 3 r M aD O N O.' i ° w ~ = a K o C d M N N rn 0 4 T N p C d M N N rn ry > N ~ U Z N I~ ` l O r0 U Z N r 0 0 i a D Q J Q 3 m Q O Yom'.. Z ~ Q y 2 iq E M o N y o o so N E m lu o Io rn N N 7T-.f , ~ (V O n o M a ep N N N O O O N ~ d d ~ O )F)41 ~ O tD O ~ O O N N ~ 0 ~ ~ ~ O O O O N n m ~ rn r Z ~ o Z o o N Z Z I r` M d N N 11 11 11 II II b m n 10 W r II II II II II 3` tM0 N O 0 OMO YO O O Z O 10 O d 10 ~p C Z O M O O O m O N rn O M eD l _ rr o 0 0 0 o F- wD o a 5 0 0 0 0 0 a w w d.- In g N v a D E E j m E N m N c M N aD d d 0 N LL c w O b oD O E > (ri N N t7 N ONi w W p 0 M f0 tD M N O W W p F- N N O O a Z n Z w m Z w O C 19 rn d 0 LL O LL -II,gt' _ w m m r n e w 0 K m m rn rn n o w A, 3 r cl? ry UU m 3 g N mo d N p rn o a -l rn Z W o o 0 0 7 a J a- C d M N N rn 0 U W C ~ d M N N a 0 N ~ ~ N F Z H i.?.. J Z N r O Or Q J Z M N 0 0 Q N n K' ~ p ~ Z E O z E (7 jp N m d N m = ~ N M d N N Q Yn G Q N m m m d d 0 an d M N N M N M m M m c0 Q M O m N m M d d ~ m 01 O d 10 m d 01 m m d ~ O d N ~ ~ O N O m 01 m ~ N m m n d `t m 01 O R. Om N n tell OI m N N OI t") C pp r M O m 10 n n o Z N Oi t7 N ~ O r r w Z N M a n 10 ~ IO O~ O 0 z 0 1°o in v rv In tO ~ z o rn °n1 vi 1ri1 v d U m m N r m and Q m N N d 01 N ~ W uJ ~ M N N OD r ly Q G N Q II 11 II II II O W N N O d m II II II II II J m r m N O To O `O Z J N N N~~~ ~ ~ C 0 Z o vi m M o o m O m 1- y o m o d o O ° 'L' i... N N m N ~ w W < 7 N r d d M ~ w w F- O (7 o m ° K rL U' d ° d a N 1p Vl Vl m fn N Q w 1. rn m N rn a <dn a rmi. E E w Y° N m M rn M M a IL w m r£ X v w w O X ry m o 1n r d w w O H w o ~n rn v rn 1°o F W lip a m °d W Z 1n 1n rn r o Z w e LLI rf m m m m z p fuj. a N Oi OI d U a Z O 1~ c7 r d W a }d` W LL N W IL In U f Q w F 1 N N M m N Odi O Jn N N Orl O J E of ci °i vi ~ O U Q ~ N 1M° W n d U Ora Q o m I°n N 1°°. a 0 0 m z'$ w z=. ci O C d M N N 01 O (n 7 C d M N N O> O fA _ N O N W r = W 0 z aMM 1 o z cMV a U w w J F J F Q > > Q > N } ~ N M d N H N ~ ~ N M d N Z n Q Z 6i Q \ O O M n N O N m d m d n M O m - 01 N Of M N rn m O N N d N 01 m N M r M m N m m IA m d m tT N t7 O rr n t0 (7 m 10 C) I[I pp t7 m d M 01 m M N O M m 01 ` d d O1 M d O d In O m Z m m d N v r M Z N O d N N m N O Z r °I O pp O M ~ ~ t7 O N O O N 01 M r ~ O m m m d N N Z aa11 01 O O N A N O N .N- O t`m') N r m <O d d5 d F eT r 1p m M m w N M m O> N M 11 II II 11 II d M m II 11 11 11 II N n m Ol d m ry Z W N N m ci d I! i N O C O Z M W m p m O N n d O m O :.C. W m o r r N 1- w g w F' W N cmi 1 i m r V- w w J m y 'o a v G J N o o Q > E rn E ¢ O E m w > O= d M T d N N E U' N M an d Of w O O.. a n N w M w O d O N m 0 w p Fi . O M 16 Ili d M 0 w 1-- yl n M o iv v Z M 01 d M r m Z Oi U W Z N d eM- N U Z .6 L6 v N A Q1• W W a 'y d C m M d w R r r N d 1n O w d N 1(1 1(1 111 (.7 w N d 0 111 m m O r: Q ~ O aOD O W N Q~ td0 m O O r ~ O N Of 01 > M O d M 01 F M m 111 F ry r t~~ Q V O~ C d M N N O> O ai C d M N N Of O N ~ N > > U M m f 0 0 V Z N N O O Z Q Q N n J y W ~ N M d~ y m ~ N M d I(1 Z cn Z VI r N d m °1 O m M M O m N p N M M m m M r 0 M r 01 d m w d h 131 0 0 u1 r 01 d m ~ O O O ~ O N m r N O ~ Q C O O O O M O 1[ O w Z 0 0 Q Z O O z D. z v w w u) F- d an d 11 II n n II F m m d d N a II II n 11 z0 N rn v M 3° m° z F N o 0 o m o o m t: o =O 0 0 0 0 0 1 w g w 0 0 0 0 0 w OF ay d a d Q O y o a s Q t Z m ¢ O m in m to G C d N 01 01 m E E w F m N m r m 10 N ~ LL N A m N N M w O In 1p Q n m N m w O X ~f ci ~i ri N N w I F- W r m r °o w F- u1 2 w Iu z w a U a U i w LL LL F C m r M M 10 LL w d r n ry w m rn `r o p Q N m rn rn umi N N N N V - 2 d d m m r O 0 0 0 0 0 h 0 0 0 0 0 a G d M N N O> O C d M N N 0 2 N N F F Q Z N 0 0 a z I m ~ ~ O O r y O N " N M d 1P ~ ~ ~ N M d N Q /n Q (/1 a m ti M in n a N M m rn E m o n N o Q r m w n . N tD t7 o Q m« A tD m M M d A o« m O <O n m m m N m O m N m N l0 « « m (.U O m iff «L' Z O m V M W OI O m m 0 m z' d m anO f V m N n N N z [nD O m m iA d Z A O Am A N N 10 ~ Q m m Q. tp A O Q« O n ~ M N »y O • ~ 0) M M A II 11 II II II II II II Ii II O h m n In d t0 t6 p O z 4.. N o O ci OA O N O z 0' N M n« (O m H W w f. ID m N rt O H w w O « N .6 N 6 N v 9 K N E a n o a y C M N m O N N E E pp N M O M N 0 O ~ LL G N N N 0 O E 1. O 4 m Mm o n n o w w 0 w 0 c o 0 o m m w w O v W N O m Q m Q W E Z m N V M a z w U a E N NN U a a LL C LL U U) W C O N O 10 w `u N C M N m m W N Q OI N N N N M Ot m a N m v O a (6 o m w a C) 10 In (o d OI N N 10 M <IJ U N V a N N .Q `b Ir « U C Q M N N m N m =O C d M N N O) N O J C J U 14 ui z N l' O oA w f z ry 0 O ~ F- E 1 E a a a a w N Ip N M d l0 N N N M d N N Z A Q z A 0 A r OI m m N m N ' m Q N In M N n t~ e 6 7 O r d m N n d H N m N A N m 0 m M N f0 N m w n N N 0 N d co in n 10 Q OI m O M m Z M at Ci Ot cm N M OOi d c0'1 Z d0 OQi CN,t ry t'~ m M N r .6 ~R _ p aa m N O> m N N Q 1 Z N O om m~ N t+1 N Q z ~ N O~ ry~ ~ ~ M m M m N n ~ o N In n 14 N ri In N A y d II 11 II II II N (O O N O II 11 II 11 II o m m M d n p . 0 Z M m m N m o Q C p z m O) i+! Obi a O y O t0 M N Oi ry O C y t O F.;1m m m f0 N ~ w ~ w F n Of T e d F w ~ w F o:, N n °y o 6 O v 9 N r K ry (n r, c M .O N O N E E N > c v° m rmi n is E E > o n M m d N m _ LL ° m . m o w w O n °d o m w O ( Z 10 N N co c0 (0 H m d tD N 1-- N Omi d 0 0 w z N M N N r w U U aa LL F LL N N m N N w R c o m ry A w 2 m m o c6 ^ OU d N N d Omp a ~ Q m N A (n r (G c7 O O N N d a a ~Q. Y C d M N N m N ' C d M N N D7 N j 1- Z M N r 0 0 1- Z M N - 0 0 Q N n U N « « n a J J F j J J E a y ry N M d 10 N I«p N M d N 2 N Z N 10 O y d m cp n Il) N O m O O M e N O N O t0 n N 4 0 0 0 Q O) O r r 0 0 X 0 0 0 N O V OO ~ N O O O M d ~ m O Ot 0 0 Z 0 O O N z Z :Y r r In n u n u u m m n n 0 u It M o v° ° c o z v in o0 I~i o '3 o m Z o 0 0 o m O 0 0 0 0 t- w 2 w 1- O O O O o w w O °y d o d ¢ °y d a o Q .I, m N a to a ~'{y,r m o o u> o Q E E > c rn m .n In o E > 'F~ - m d m M m _ la (v (o fo d~ d pt 0 m o o v N w w 0 o v 0 of of w w LLO N z z w z z z z w a w w c o d 0 0 0 o l0n r0i u a m N m~ m M h O d Q Q w w mm, m rn m m w O 0 0 0 0 0 O N o 0 0 0 o O O a a w d M N N O~ O w C d M N N D7 O f f Z z M In « 0 0 M« O O J Q N ~ ~ ~ n a N ~ r Z N q ~ N M d w ~ j~ ~ N M d N a ui Q (n 0 N Imp j ~YI m M 0 cp N~ n QNl a0 M ~ M Q N r ~ Q Q O c V QOQO O 4 yl Q Q Q M ry N n Z N 8 'q C"31 2 c N M N , C m ~j M m 0 Q d OmI N r k y Z m ~ Q n~ m °rn N C' Z M N m O a N m N w~ Z ~ N N M fN0 O N M IC #r `0 ~ N N d O n II 11 II II I y II • O IA O m O N m O O Z G N O O N M 'I C II C O M N d m m O M N N M M p O O Z N N D W 2 W w F N N m w w SS. N d D Q a D D D D Q V W m R K w v K 4 Q n m ccpp o E E > ,n n m m cNV ° E N E > m K N O N M M O LL I.N W C w w O iE m w O .1. N n of`c w m M rv ri m m° H J w l m °r' rv m W I- 7 Z r w ;gym F Z co w O O > > w LL ;c O pp LL E >O OOi N ado .d- 0 -0 > N d m~i M r W U M N rryn m U 'I ry m co <o r 00 1. ; Ir n ,a N o.. Q 0 C d M N N m O w x ry 0 C d M N N m N d 1~ m J w x W 0 a ~ Q N O 0 Z N .N- O r F Z O N .u-1 ° O J 1: J 7 a w Q E O N M Q IA > jI F ry N M d In w z rn ~ Y~ Z rn p `V ON r M O N N Ids ~O e c N Q ae m d rv m m d M N N t0 O N Q m O Q p H N m N O O p d m m N V J..; O N M O N O N N t0 f~ C (V n N tO N p~ N r Qr r') cU Z O r N r N 0 m M N N N m t0 N N O N Z N m lp m In p N m N Z N M O N N O N~ N O M cD O O r M M d O N Z M M d~~ yO. r y yam' (7 M n u u n u m m o m u u n u N Ifj M N V n ~p p O Z N r 0 oD In II M n m m N w W O d N N tO7 V w m w O `L F- N D D D a a . m m ll Dy D D a Q K m ~i o n n 1°n E E > H N m N o co m E E > w N r N m aMO N W w O K umi o cmi rn n w w O Z N n tp 1~ d m H a N N N Q N f- m N m N W w Z n w 1 U N F O pp LL app CR d (7 m W N N N m rtO O w N O In uoi m cO 0 M tN y UO w 0 O > w > O ~ O Q M N N m O . C Q M N N m 0 Y N ~ N f. ~ 0 Z N O r0 U Z N M 0 0 Q E a N N M d In N N N M d N Z (n Z m e ` M C5 6 N O O 0 0 0 I j cq N^ O m a m O m tD tp '1 ~ 0 0 N O ~ p O ~ N O S O N tT d d M ~ Z O O M ~ N N m O Z O O d Z Z r II II II 11 II r m N m II ut N r r0 N c Z N trD d R O O Z :1^ 00000 Dw w 1= w 00000 h-w ~w m a D V ? ~ D O D U w m `n ~ rn a ~ m m ~ m a n o m M uni. E E > a c N r M d m E 10 N > N 0 ui v d Q N w W 0 vi 2' m I co of of m w E LL w O W Z Z Z h W_ J w c N [ I r O m V w O fm~ d O W O N m n Iw LL > O O O O O ^ m a0 m W 0 0 O O O O O O O W C d M N N m 0 ~ d M N N m 0 Sc N ~ N F F Q Z N r O On J Z N N 0 0 ~ a N c~/1 z E z E 1 N N M Q I(J > 0 N" N M Q I(J a m > N Q ~ ~ IA ~ O d Q~ aD N Ip IA ee v m O f0 n N n N n OI ate. ' w O d IA O Ot ~ IA ~ N ep b IA c'J tD yny O~ O N N 10 N 10 ..i Z O ONi O m h N Q m N Z' N Ompi O My r N m m O m Q d O) IA Z N O~ m ap Q O M N Z m m d O N lp CO'1 ~ m N In v6 6 r d m tDD Q In N O r.: d N r ~ m ~ '2 I I I I I I I I I I n O O O O I I II I I I I I I * N N M n M N O 0 Z N M O n u 0 C Z N d O O r v M crv I w ~ w ~ m rn m A~ ~ m w` g w ~ H N N D O O D a O N O U a C m N lA R ,a W > Gl L a m V N K Q E N _ y A aOD r N d ONi m w E LL m m 0 N N cop O E E LL a Q w W O m t g N OOi Omi ONi aI w O K t~ V N r N n w ; z N O O N m N Q Z ai o o w to z of ui N Iri Lu E N ~ LL :i LL ra U KI d m d M N N O N N O 1p p g N m~~ M U I J O~ M N Q c+) tM ul M m m w to y g m n I°n m N U N N n Ir 4' d M N N T N 0 C Q m N N m o a G r', a O Z m f 0 0 f Z N f O n0 O, 4 f W f Q J R~ r Q E Q E (7 N N N m Q IA f ry N m d N kl iv Z N 7 Z a~ , tD IA r N N m r 0 m I!) a v O r 0 r r m d cD Cl C- C m N O Q O N CO O (O M N m Q r tp a0 N oD O tp ~ IA O N O o O N N 0 6 f(p~ ui c6 Z r qt N N V N m Lq oc~ Z ID fOD d (WTI O Q OI n m m ll~ 'C Z O 'i O r m O COj IA d Z (~O yy m w o m O GMO f tD [D d O N M d O N 10 OD GO M O cp m W O I O N d m N 0 m O N N O c0 t~- l0 N N N M II II 11 11 11 II 11 II 11 II II M I'M O O Q `t9 y N N< u> n o w g w voi m n o 0 o c v O d m to . w g w v ui ui v o 5 m 6 n v N N N a N N (A a c In m N In r E E > M n In m r E E > r N N cO N g° m N d N N w w O g m m N rn m a w w O :4_fn Z M cp c! O O M H M IA 10 M n F i. U d N m N M r w Z N O W (a m U U LL w C C Ot O M W p G r aD IA tD O> W (n Q N N m O O U' g cp N O N O W. Q. c0 d cD n Z M ¢I N d r C) Ur M m r N ; N m a 0 o p F C d M N N O> N Y C d m N N Of O f t, U Z N In O O F- Z N IA O O a a J J E J a a N ry N M d N N N N m d IA { Z_ n Z m nN m. O. O r M N c . N O KJ OI O O O O O N N an d n m N" O rn O) 0I 6 N M N O m 0 ~ 0~ O N N O ~ ~ 0 0 0 0 0 0 N O O M O O O Z O O Z Z I'^+ N r ID n d 11 II 11 II II N O m N II II II 11 11 11 O O O N O O Nyo t0 N A U O O Z ';yrI O O O O O 1- w g w F- 0 0 0 0 0 F- W W O i1`t y D N D < y? U N D ` m m cNV n° °o i E > E > m N cgi cov o ~i E I. P N m n O d0 I11 IL O O O N Q Q N W W O z z w z W W_ Q W 2~1 p t0 N M t0 Q U ~ C n OI O I(] In U t K N O 4• OOi O LL Z d V N O r O LL U g In d co o w g y N M d w a o 0 0 0 o O 0 0 0 0 0 0 O 7 U p U d M N N W N d m N N O J T}.~.. J Z M f X 0 0 J Z M N ~ ~ 0 0 A a N ~ r a N ~ n N ~ ? E u) E > A > jp N M Q N a N a N _N Q m 7 ~ ~ ~ ~ r°~ o o n a m e W ~ <p M O W W err... M 0 6 6 6 of Q N O+j W y O N F,•: Z r] O mCm Z f QQ ~ Q U ip Ea ~ o tD O W W W n u n u uO l0 ~N w co in ~p m C Z U; N O m W > O O O O O ~ N a ti W O m) p > N Ya 0 Q O m 1c M W [O W n V E > b 7 m y K N N [p LL m p C W O m R ' V W U fn Z w U E z 'T W LL m m ggO ys': f0 m uo~ rn n aMO n W U m 3 O z Gi N O N W UU U U m ~ o o ~ o v U N F m O N r F ° W ~j v J Z M 0 0 C E Q N n ~ o N m j ? E m U l7 m N M V rn v ~ Q N f Q m r~ \ O ~ ~ O N rD N uO' c~ ' n op ~~Q t+r01 c7 M rL {O ' y Z O yN Z 3 Tom'. r m c~~ o n u u ,~i u n y{{S'C'. ~ N~ N o c~ 'pf t O > N s N Z n n ro rri W W O H Z k W W Q I U LL 4 a C O N O M n LL IL N O N W 00. U O u'1 n O N N U O O o C O U 3Ol` 0 itl p V M N N W N C H J Z N O ~ ~ 0 0 F Q ~~t rn ? E 7 4 > ry N M O N Q /n ~1• i} i O ci N O n M O O O r . Z '}i O n ,j ~n n W n n n u n ''NN'; n a e~' N o~ o 0 0 o c~ O K O O O O O D W W Q > N N K W, O Z z a W ~ W ~~1 a N N N n O r LL N m n n m O W LL 1 N N N N E W > U SIA ~ C O M N N W N F J Z M 0 n0 Q N ~ r r N ? E I C7 ~ N M a ~ Q in n ~As CONVERTER STRATUM END AMOUNT TOTAL HOURS HOURS (Total n = 20) 1 MEAN $ 2,873,110.75 91,733.78 38,287.89 (n=4) SD $ 927,797.39 31,332.39 11,637.67 2 MEAN $ 7,478,705.67 222,571.22 89,170.20 (n=3) SD $ 1,334,502.82 20,358.26 17,685.20 3 MEAN $ 10,906,863.50 346,833.91 119,951.69 (n=2) SD $ 839,521.72 70,721.57 16,817.09 4 MEAN $ 22,282,186.50 660,245.87 257,118.42 (n=2) SD $ 702,225.62 43,656.53 89,294.17 5 MEAN $ 36,520,337.22 1,038,524.30 535,566.36 (n=9) SD $ 12,629,072.79 442,791.97 268,702.31 Overall Estimate $ 908,545,054.47 26,911,565.87 11,721,609.10 HSC } Comcast Cable Communications Report - 2010 Data, Appendix page A13 Average Installation Times Activate Pre- All-h, Pne- Edsting CuUel Ed..w Outlet Mow Outlet Move Outlet Lombned STRATUM UmAed" Prelred' Same, Separate' AO Same' AO Separate' Same' Separate' U.,ade' OovmgradeVCR Same VCR Separate TrCo b Gare (Total n = 20) 1 MEAN 1.2838 0.9286 0.1976 0.4861 0.4430 0.8820 0.4542 0.7833 0.5596 0.4467 0.2750 0.5000 0.9750 n=4 SO 0.0633 0.1203 0.0398 0.1145 0.0437 0.1498 0.0534 0.1627 0.0842 0.0569 0.0397 0.1868 2 MEAN 1.4279 1.0397 0.2167 0.4944 0.4064 0.9786 0.3833 0.9111 0.5482 0.4229 0.2722 0.5222 0.8796 n=3 SD 0.3224 0.0967 0.1014 0.0918 0.0111 0.0186 0.0441 0.0839 0.2417 0.0416 0.1347 0.1347 0.0424 3 MEAN 1.2344 0.9690 0.2083 0.6167 0.4000 0.9683 0.3667 0.7750 0.4833 0.2000 0.2917 0.7000 1.0417 n=2 SO 0.0002 0.0006 0.0825 0.1414 0.0008 0.0471 0.1768 0.0236 0.0707 0.0589 0.2828 0.0589 4 MEAN 1.3670 0.9434 0.2833 0.6917 0.4500 0.8589 0.4500 0.8583 0.6996 0.3745 0.2000 0.6083 1.2083 n=2 SD 0.1881 0.0349 0.1886 0.0354 0.0707 0.1541 0.0707 0.1532 0.1672 0.0623 0.0707 0.1532 0.0589 5 MEAN 1.2741 0.9502 0.2185 0.7562 0.4300 0.9336 0.4389 0.9539 0.6004 0.4025 0.1972 0.5917 - 0.9272 n=9 SD 0.0832 0.0867 0.0664 0.1332 0.0405 0.1051 0.0464 0.7149 0.1784 0.0592 0.0637 0.1290 - 0.1858 Overall Estimate' 1.3186 0.9642 0.2198 0.5793 0.4276 0.9200 0.4224 0.8456 0.5730 0.3852 0.2541 0.5663 0.9949 1 Weighted -rage at in-House and Contractor Ins1aM Times. with weights equal to actlly bwls for each type 2 Average at UmWed Aerial and Umwed Underground, with equal weights for each type. Average of Inside Wine Service Calls. Customef-Owned Equipment Cars, am Customer Education Calls, with equal weghls for each type. 4 Separate Ratio Estimate = weighted average of strata estimates. Install Activity (Average # of installs per month) A<5wle Pre- Actiwgte Pro- Edstmg Outlet Edslh Oullel Mow Outlet Mow Outlet STRATUM Unwireds' Prewireds Same, Separates AO Samas AO Separates Semen Se tos U des Do pare pgra wsgrades (Total n = 20) 1 MEAN 180.77 1,854.92 1,093.41 364.47 1198.29 125.06 9.80 3.27 624.79 364.77 n=4 SD 89.98 1,021.93 861.73 28714 818.95 76.32 13.53 4.51 245.86 150.23 2 MEAN 263.36 3,951.81 3180.21 1,060.07 6,415.89 207.53 51.88 17.29 3459.25 855.28 n=3 SO 41.58 926.20 1,063.88 354.63 1,691.67 19186 74.36 24.79 4,279.18 483.76 3 MEAN 491.21 8,925.13 1,210.56 403.52 3,660.54 2,649.13 56.41 18.80 5820.63 2,510.25 n=2 SD 430.69 1,879.55 1,711.99 570.66 2,831.31 2,192.80 78.27 26.09 411.95 77.78- 4 MEAN 439.08 10232.88 6,911.53 2,303.84 4,263.58 491.25 65.34 21.78 7,731.21 1,483.38 n=2 SD 16.85 4,188.72 1,729.45 576.48 695.44 51915 92.41 30.80 5,519.62 1,846.08 5 MEAN 591.20 15,875.93 5,921.54 1,973.85 10,164.12 1,769.71 1,948.38 649.46 12,102.31 3,759.79 n=9 SD 266.57 5,904.25 5,218.63 1,739.54 7,249.74 1,042.60 5,533.75 1,844.59 5,791.43 1,609.99 Overall Estimate 346.48 6,734.82 3,163.00 1,054.33 4,465.79 831.87 311.81 103.94 4,805.03 1,467.81 5 Combined (sum o1) ImHoux and Contractor Instate. 0 Average of # of Unwired Aerial Installs and # of Urmved Underground Instal with equal weights for earn type. Total Install Hours (per month) A,,-,, Pre- Activate Pre- En." Outlet E-ting Outlet Mow Outlet Mow Oueel STRATUM Unvmedrs Prew/red' Same' Saparale' AO Same AO Separate' Same' Separate Upgrade' Dowrgrade (Total n = 20) 1 MEAN 229.11 1,642.95 241.58 189.19 520.41 106.33 3.96 2.43 357.47 163.25 n=4 SO 113.17 733.62 230.65 154.28 353.81 67.00 5.42 3.02 172.31 66.58 2 MEAN 380.84 4,090.63 637.33 503.26 2,618.90 202.44 21.51 16.95 1,339.35 362.62 n=3 SD 139.28 871.71 163.75 70.52 761.79 187.09 31.05 25.02 1,414.75 199.30 3 MEAN 597.77 8,648.16 181.58 289.19 1,464.22 2,564.15 18.84 16.88 2,818.16 504.80 n=2 SD 528.94 1,816.41 256.80 408.98 1,132.53 2,120.98 26.04 23.54 336.30 193.06 4 MEAN 570.47 9,726.71 1,795.21 1,603.68 1,943.20 381.96 32.67 16.34 5,870.58 613.05 n=2 SO 62.52 4,308.31 813.24 480.19 614.43 370.32 46.20 23.10 5,154.56 783.78 5 MEAN 772.80 15,126.95 1,419.94 1,486.97 4,237.25 1,649.18 782.14 627.17 7,639.29 1,523.67 n=9 SD 347.26 5.881.54 1,290.05 1,334.78 2,807.67 1,017.70 2,212.47 1,783.35 5,270.07 686.19 Overall Estimate 450.87 6,464.86 729.43 679.88 1,872.96 776.87 125.74 99.24 2,861.16 524.67 7 WegMed average of In-Houu and Contractor Install Tsnes. e eased on the weighted awmge of Aerial and Urdergrourb InstaN Times. with weghts equal to Actily levels for each nstak time type. Estimated Population Average Time per Install" s~r3 1,"x'ti ~;,~ba _ r , au?,.C4t R 5'7: 1 Combined Ratb E..ale = EsUmaled Install Hans par onth Estimated Number of Installs per month). lore acs ' bwts ua awilable ar but VCR Same, VCR Separate , and Combined Traubb Calls 2009 Maximum Permitted Rates HSC f r- $33.76 ^.'Sd s3 n;; 3 at E. 3.1¢S7~'79ua1: 1 6 ComcaM Lade Communicabons Report - 2010 Data, Append} page Al4