HomeMy WebLinkAboutComcast Preparation of FCC Form 1205COMCAST CABLE COMMUNICATIONS, LLC
COMCAST CABLE COMMUNICATIONS HOLDINGS, INC.
2007 ANNUAI. 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 Co?ncast Cable
Communications, LLC and Comcast Cable Communications Holdings, Inc. ("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 2007 Form 1205 was obtained from the books and records at the
company level of Comcast as of December 31, 2007. 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,
2007.
Line C Accumulated depreciation was taken from the books and records of Comcast at
December 31, 2007.
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.77%) 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 I OK
for the year ended December 31, 2007.
Line G4b Represents total net assets of Comcast Corporation taken from the company's l OK for
the year ended December 31, 2007_ 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, 2007.
COMCAST CABLE COMMUNICATIONS, LLC / COMCAST CABLE COMMUNICATIONS HOLDINGS, INC.
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, 2007. Such expenses were
obtained from the books and records of Comcast at December 31, 2007 and are summarized as
follows:
Schedule B Schedule B Analysis
Salaries & Benefits Salaries, Commissions, Employee Benefits, and
Payroll Taxes
Supplies Operating Supplies
Other I 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 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,
2007. Items such as non-addressable converters, addressable converters, remotes,
digital converters, digital video recorders, IIDTV-capable converters, and
CableCARDs are included on this line.
Line E Accumulated depreciation was taken from the books and records of Comcast at
December 31, 2007.
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.77%) 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.
COMCAST CABLE COMMUNICATIONS, LLC / COMCAST CABLE: COMMUNICATIONS HOLDINGS, INC.
Line J Current provision for depreciation was taken from the books and records of Comcast
at December 31, 2007.
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 2007 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 installation and maintenance of customer equipment.
Line 5 Represents the estimated amount of costs related to installation and maintenance of
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 installation in 2007,
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 Forni 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.
COMCAST CABLE COMMUNICATIONS, LLC / COMCAST CABLE COMMUNICATIONS HOLDINGS, INC.
F'edml Coma micw. ConavwoK
W,Ib..PW D C. 20554
FORM 1215
DfMRMQi1NC REGUTATPD EQMPMFNT AND INSTALLAT70N COSTS
'EQUIPMEf r FORM-
C--.m-My 11" Wamfia (CIHD) of abk qV- Due of Fam Subo-oa
SEE FCC FORM 1246 FIUNC WHIM
N.me o(Cabk Opc-
COAIC AST C ABIE COMMUNICATIONS, LI.C W COMCAST CABLE COMMUNICATIONS HOLDINGS, R4C.
?4uh.g Addreno(C.bk Opcr w
(.ry SMe LD'Code
Name,..d Tirk o(pe amplcting Qa1 fame
T pb- w-bea Fae N-ber
Naar of Lon1 F,-.t.-g A.dl my
PI.FASE SEE FRANCHISE. AUTHORITY LISTING PROVIDED WITH FCC FORM 1246 FILING
M.JM Add- of L-.W Fnnc?.wng ArtYady
Cay Sure 7Y Code
1. Tbis teem 6 bel.g rdet JF.tse n'.' V me,ppnprf,re MtJ
aln .d, FCC Fan 1200. FCC Form 1220. or WC Foa. 1225.
At b dr c-Vk d FCC Fe m 1200, FCC F.rm 1730, or FCC F«n 1225 n d.c fiew o(dre k.m.
OR
Oln «dc, 1o Fulfill FCC W. .9.w-1 a ,...d filing of th6 Ima
Ewa 11r due on .bleb yw Im fikd mia tam 03.Bi M7 (-.la n)
Nwe 76u d.ooM 6e tlr due ...bich tlr ...n l.a N.uFia1, by ?0?.g a1h? FCC Fam ]9I a the pri« fdwg of.De fo..n, .ere n cIT«(
L Filer 16e d,1e N wbkb yw el.vd )..r book. A., the Rant y- reG-ud 1. tb6 I- 17/l IA7 (mddNyy)
Note- Tt- w11 uk+;.. c dr ead of dr 12-moa16 fiud y- fa which )w .n Id.g du. fan
). ladk.le the nrponu eue.. of )our c.bk rystew JE.ter ,. 'a' 1. rbe arreel MsJ
X CCorpw.oo.
Sabchapla S co.p«mo.
Parure>dp
Sok Prow... hp
Odra JPkzr ecplein bekr.J
Appeoeed br OWS 3060-0703
FCC F«n 1205
P.R. I Eue14.0 fa Wndowe lar 19%
Fad-l Caaraniraliolu Ca_i._
Waahmgms, D.C_ 20554
Sp-fy 00- 2
Sponfy thha I.
Page 2
Ex-I 4 01- u-&-
Appm-.d by OMB 3060-0203
FCC F- 1205
J- 111 e
9661 -1
Soil 9„9i J".N
c.1.1-lyl " 0, Pl- I
( mg
C A-4
'
' flfrwrslrlwl2 1-!n-)l +TIM-1 lv1O1 OM'M7 '1
UK 6L6
1L9
6LLS 561:-19L"0.0'ZS.S ?foILl'1f "It 9L6,CT9'ft o00S
LS
f"
'
'
' C
6?[
(?6
SLS If•1)++soJ RPdJ R"wv 71
(19Z0
0f91RI'S 91-906'0091%(S 96W65 009t9'KI'ZS 6FO(V16ri9f
8(19-(S6'I10,%ZS
f( Z fSVL69('61 IT
.LOt2ZS
t
l noun aq oasuoy era°J f
6
f OWSWIS 0O0T
15($61Z"959'Clf
Ila•J *at*l iol
ianor
H
J wuasanolwuwM I
'
M 1-910 H ao9 Y'VoQaS omy w-U p al.y pm"] H
00 CZr6W
9IS"IS 00 HL I'L6t2CL$ 00 SW IS oO VOW 1662$ oo OS
00
'
'
'
' I[S
66L
CK .3 a^RA 7oo81aN 'J
0096(
2(8
19($ oo-SC6'Z?I'oSii (MLL(S) 001 Orstrlf
(
'
'
'
' 00 r91
6fi
fz$ tml q?fa(7 4
00
"TW
216S 00"001'616'(CYZS OD 191'1 IZS 0000L'trOK
"
'
00506'CL9'966'ZS
00-CSr65S'91L'ES
00191Y1if
001 IL'19Z'?IS 00965
6[?
9fZf
'
'
' oa/el %o'p?ooaaY 3
o6r'L6.'L
f19'L.T'LI
S66'?f 00
666
6[9
%ZS -41A 4o^[I noel a
l M191 0C6'62CTZ
tfo*s t
Z16'9L1'(
' aa.avs n qan fo t lml J
Sfl
SL 12611 599'OK
( - '7 0.'?ev smoH aar++aSmoeerunry/ root 0
f nua"°°J Z aa1+a..wJ ! nweeo? (iYV
o
Wb Z agony
J I woolaM 6
i „i
u
.f
' v
1N3WJ 7M7WO131UO38v3'1lOS1SOJ-IVlidv >
.i ili1?11 HJt
CO olm em :44 yasowv KS02 'JO tin13n4?em
.ousemm9? weueansor,uvJ Pa?Pa!
Fedvd C..... Cibm Commissiap
W.16 i0-, D.C. 70511
W(
STE MILSIMET FOR CALCULATING PERMITTFD E IPIAENT AND INSTALLATION CHARGES
P A. Hw S-k, C"t
i Tad Ca - 1 Co d Insulla0oe +nd M>taenan ro Scbednk A. Boa 1 5207,498,659 9802
2- T-1 A-W am F for 1-16 on and Maraenance Sebo$.k R Boa I 15)31,660,511.92
1 1-1 CpFW Coc[s Ind E. p-- fa InsralWiow rW Mw- U- 1 • L- 2 SS,012.159,171.9042
1. Cusuunea rand WWI i ?dccola (aox; ao a U-)- 411670
S A-1 Ciuwioer Egp- Mmvauce and U .Wt.- Cau. E.6dmg Co of bawd Eqp? 1- 3 a Line 1 59011,811,582 W
6
7' ToW labor Flown for Mliarnrre nW L-K... of Cu - Eqp? rd Ser xrs amcb laoarm
Horu1 S-i., C2ur 4USC) Lae SQL 6 26.881 J97 W
SJJ
8057
.
Approved by OMB 3OW,0703
FIX'Forw 1205
Page 4 E-14 0 fn 1Vsd-. June 19%
METHOD OF KILLING FOR INSTALLATIONS(pl C u'a' Y O'rrpnpeble boa)
hu llairs• bdW by the Lour bawd - 0. HSC -1-taled i. Lice 7.
X kg.IU-bdkd ,., stauda d M 8e
Fadr.A Couomaicati -Camuiuiat
Wasbi. p DC 2055;
Approved by- OMB 3060-0703
(Cak.btr f.r sacf wllken ?iRereel 1 b e
10. ToW wintannraservKe Hours (' cvlnrru ( t o re S U d k C. tar B Rcasare I
56
055 Ren.ar 2 Cabk Card
11
HSC Line? 0. 0- 13,981
.
12. T.W ?IaiauuncNScrvirs Con L- 10. Lire 1 I S33.9057 $33.8017 $33.8057
I) %18156,920.1872 $0.00 $172,637.0183
048)
A-WC iW Cau C i _h._ ham &1.&k C. Li.K 917
f75
719
83
11
Tour Ca
(Rnaa
Li
11 •
1 ,
,
,
52 1100 51,653976
.
ma
e
nt
Lrc 1
15 N.rMa of U.iu r Serviu Curet n column fran Scbed.k C Lot C S91.2M,670.0221
Z5
229
930 W.00 $4,126,613,1677
16. U. Cffi hone 144-i- 131 ,
0 0- 167,772
17. Rau W, blonde (l lave 161(12)1 52-7338 50.00 $215966
503112 f0.o0 $2.0197
STEP I Cbargn FM leafad Cuveetp Man
(CJcalare K for clef amuk-th JIRe.rN y
b c
18. Told )Asuneear /Service Howa C n -alarm bon Sebeduk C lice B Canvou. 1
75
13 Coavara 2 Convaxra 3
19
HSC Lin
7 ,
5 7,126,912 1015,017
.
e
20 Taut winuwaacuScrvwe Con Loe IE a 19 $33.8057 $33-W57 $33.8057
2 f2-39,966.8668 $210,930,022.9889 102,918.8316329
f
1. AnoaJ C rW Coos (art n column Fiore Schedule C. Lrc K
22 11,171.031 S M.(140,761395 $779 671 979 7176
Taal Core-(Covina Lne 20•L-21 2
27. NunAer of Uauu m Service (o. eoln? from Scbaf.k C, I.aee ,511,159,9208
$
IN
995 5722970,761-3839 57626f0,811 3W7
24 Uaa C. n (Line 7L1m 231 , 17-/7,615 7,197,290
2 $13.7161 $11.2001 5117.727
5 Rae pea Moab ILi 2416211
31.1417 333)11 598107
STEP L Cls.r ea f.r Orb- Isased 1 -w
26. Taal M w,c .,.S.-wc Houn C cdr.na Fran Schedule C. Lae B 0.
27. HSC Lire 7
MAW
28 Taal M..ouosncHScrvire Con Lioe 16 1 Line 27
29. A-A C.PLU Cous m wa mn bon Scbn)uk C, Iaee K $000
30. T.W Cron of Line 28 v lisle 29 $0.00
31 Numb. of Ueifs a Service C -1- fan Scfedatk C. Line $000
0
32 lJeu Con (Lae 3"- 311 -
SO w
13. Rate per b4nW(Larc IZA 12)1
f<
METHOD OF 3111JNG FOR CHANC8NG SERVICE TIERS OR EQUIPMENT lpl- a (br appr.prir b.,j
ss a N--r J Chuge (Ea Ibr numinJ cbaage in tone N)
as a Uoform Hourly Smxc CTuag.
X as ao Awage Cfrge (Fora We Average Hours hn Changing Service T•cn a Lee lab y
STEP F. Che Ar (1- In Sauk- Tkes a F w .t
31. N..." Cbrt for Chan Smxe T
If vo. use h esnlaue Tale o(cbar •' o ac boa ..h, ip%L
pbc,
OR
33. U..(.-Hinr1 Scrvxs C2ur
der
OR
36. Avm Char fa Cbae - S-1 T-
364 HSC l irr 7 SJJ.W57 -
36b. Averag e Hoar to (Junge Squire Tian 05244
-
36c. Avang e Clurgr, for (3aogrn8 S- T- (Line 36. s Lrc 16bl S 11.7777
FCC 5 Fseel 10 fa 11,ud- C Fain 19%
luxe 19%
FYd.W Compnoicarirns Corrrmnsrorr
Wa N-Vg O.C. 20551
WORKSHEET FOR CALCULATING TOTAL F UIPMFWF AND INSTALLATION COSTS
I- Told C eal Can of tosolLrirr. aW Marnpnaocc SclydrAe A, B- 1
2. Taal Annual rw nsn fa Inpalla- and Munrenarrce Sc?eduk 8. Boa 1 S207.499,659
3.
Toul Amual Stj?W Cosu ol6wathrion and Mainrrnuns line 1 . Lux I $5.234.660314 f1 92
1.
Cupprln and I-Uft rerr Pcrcenu (apaC6 a lanuion) $5.442.159,174 9042
5. .
A..W Cuaanu r M
smerun. nW lKUtlamo Cosu. Cd of tA." Eqq? -
-
L- 3aLme4 M
6- Taal C W Cops of Lased C.upown E ui nl $cMdulc C. Boa 1
7.
A-1 Capann F and IrrsulWroe C.- L- 5 . Line 6 31.341,31 5.634 3313
Y.
P- AlWciuos W FeurhL. Mu (- ins6onrans) 31.141,315.63-0-3313
9 All-k d A
l F
10. nnua
and 1-11.n Cop Line 7 a I- 3
Mon F urrl 6rwlWran Cnn Lure 91(12 1
f0D0
1I
N-9- of Rasie S
6
tb
F 30.00
u
ser
ers u
nrn6ue
12- M-dA FpT? - and b.Wl uon r- Sr b-A- I.ioc 101 L- 11
13 kiWi.w Ad
Fac
S
i
- 31100
. tor
ac
rprrrii
rrons
14 Ad-cored Mawml F u ornr arW 6uullarion Cop Subscnper L- 12 a 1- 111
f0.00
Approved by OMB 3060-0703
PW 6 Face110 fu W`uWorvs FCC form 1205
)-1996
Federal l'mlmimecaliom Conroiskm
Wnburpoa DC 20351
Coa«aq
C-m sad Iu4a0aasa P.S. Paroled Acmal
1 (T for Cabk Service LA R.m
a liwal Rue I Sp A. Line 7
n/a
b Avers Inua0alrm Can
1. l-lJ- of th wired Hww B. Lae 9a3 $47.12
2. Inellaeiw. of Prrwired Hama ISp B. Lin 9b3 W."
]. ksnllal- of Add-f Cmaaeerions u Ting o(laal Iasu%66m 122 B, Lim 90 $17.75
1. InsaalWwa of Additional Cmn«oau R Lull S. Lin 943 $27.72
S. Odu:r bewRamm 1 ci 1 IS" B. tans 9e1, 9e6.90
a. ReJocare Owls
$2119
b_ Nm Adck-ubk $17.7]
e Ibw Non. Addr-bk fll W
2 Marhl L'lur for Lase of Reraae Cmuuls S C, Lme 17, c.hm as
Rrnwe Guard i 1 All lhiiu )l
Rnaok CO w lype 7 1000
Ream Typ, 1 . CabkCARD 1205
3. M-Ibl Clw for L.- of C'oavaaa Beira fSkp D. Lin 2S, enlarraes ac
Canvakr Boa T 1 Brix Chd U-) f 1.11
Cmvakr Tyl, 2 (AR Omci thi E-kdLg HD and DVR $14)
Cmvegn Boa T J. G Oef..b-nd Oft" - Vidro Rerndn) $9.11
1 Monm fir hart of Ohba F E Lice 33
00- Eqip- (S i ) woo
5 C b, fa Chun ee Tae (if an Sec F. Lan 34.15 a 36c f 17.71
I.A BUR COST AND POLICY C'l1ANC;ES
Indieare yw ansr a a die faRoring three yaemons by pi.-S an'i in aw apK pr..k boa
1 w.< yw r«hded me bb. emts asso d rim au6soibn eabk drops is )om d-ges fa -tW -unanm+
M YES
NO
2 liavc you up mlind me labor coos asseci W ruh wb-iba cabk drops,
e1'ES
). 11 you ha.Y 6kd dus lam be/orc, bae yee changed oar policy. e.y, wq «raruewag a coq allautiw dm umes m innease in me <osu
oclufad ea drt conquuam of cgopmcM and arwuwons chnga'
YES (You moo mach • IuR nplnuuon)
RNO
CERTIFICATION STATEMENT
x11.1 FUL FALSE STATEMENTS MADE ON THIS FORM ARE PUNISHABLE BY FINE ANIYOR tMPRISONI.IENT
(U.S. CODE TTTI.E lk SECFION 1001). ANWOR FORFTFTURE (U.S CODE. T n i E 41. SEOTRNJ 503E
AW-W by OMB )0600703
Page 7 FCC Faro 1205
Ex l1.0 fa Wadors lose 19%
aScc 2008 Equipment and Installation Raul Sheet.
FCC FORM 1205
SCHEDULE D: AVERAGE HOURS PER INS IALIXI ION
Item 4. UpgradeMowngrade Addressable
Average Howl per Installation (Attach an Explanation)
Item 5. Connect VCR - Connect Initial
Average flours per lnsWlation (Attach an Explanation) 0.2365
Item 6. Connect VCR - Conneui Scpcratc
Average flours per Installation (Attach an Explanation) 0.4315
Item 7. Customer Trouble Call
Average Flours per hsstallation (Attach an Explanation) 0.8786
Item 8. Activate Pre-Existin Outlet
Average Hours per Installation (Attach an Explanation) 0.3195
Item 9. (Specify)
Average flours per Installation (Attach an Ex lartmion)
Item 10. (Specify)
Average Hours per Installation (Attach an Explanation)
Page 8 1205 Attachments
FCC FORM 1295
STEP B. INS4ALI.ATION CHARGE
Comcast
Page 9 1205 Anachmenis
FCC PORN 1205
SUMMARY SCHEDULE
Current ulpawat and InstalbYtoa Rates
d. Upgtadc/Downpadc Addressable Permitted Actual
S1.99
C. Connect VCR - Connect Initial S8 00
f. Cowwu VCR - Connect Separate, $14.59
g. Customer Trouble Call 529.70
It. Activate Pre-Existing Outlet S M80
i. i
1
Sce 2008 Installation and Equipment Rates Sheet
Page 10 1205 Attactunents
FCC FORM 1205
SCHEDULE C
C omcasl
SCHEDULE C, LINE B - REMOTE I
LINE I- Twat Labor Hours for Maintenance / Service of Remotes and Converters 10,801,()J9 h(.
1-INE 2 Percentage of Line I Allocated to Remotes 0.0500
LINE 3. Total Maintenance / Service Ilours Allocated to Remotes 540,055
LING 4 Schedule C, Line C - Total Units in Smice-Remote 1 25,229,930
LINE 5. Number of Units-Remote I / Total Remote Units (Line 4 /(Line 4 + Line 8)1 1 0000
LINF 6 Total Maintenance / Serv ice Hours Allocated to Remote 1 (Line 3 x line 5) '40,055 h; .
LINF. 7 Total Maintenance / Service Hours Allocated to Remotes (Line 3) 540,055 hrs.
LINE 8. Schedule C, Line C - Total Units in Servix-Remote 2
LINE 9 Number of Units-Remote 2 / Total Remote Units 11-ine 8 / (Line 4 + line 8))
LINE 10. Total Maintenance/ Service Hours Allocated to Remote 2 (Line 7 x Line 9) lu,
SCHEDULE (7, LINE B - CABLE CARD
LINF: 11. Total Maintenance I Service Hours Allocate to Cable Card 13,981 hrs
L1NL I2. Schedule C. Line C - Total Units in Service-Cable Cud 167 772
LINE 13- Allocation Percentage 10000
LINE 14- Total Maintenance / Service Hours Allocated to Cable Card (Line I I x Line 13) 13,981 lut.
SCHEDULE C, LINE B - CONVERTER 1
LINE I5 Line 1 above 10,801,099 hrs.
LINF. 16. Total Labor Hunts Allocated to Conveners (Line 1 - Line 3 - Line 12) 10,247,063 his.
LINE 17- Schedule C. Line C -Total Units in Service-C.nvertu 1 184,995
LINE 18 - Number of Units-Convenct I /'foul Convener Units [Line 171(Lout 17 + I-inc 21+ Line 25)] 0.0073324
LINE 19. Total Maintenance / Service Hours Allocate) to Convener 1 (Litre 16 x 1-ine 18) 75,135 hrs
SCJIF.DCILE C, LINE B - CONVERTER 2
LINE 20. Total Labor Hours Allocated to Converters (Line 16) 10247,063 hrs.
LINE 21- Schedule C, Lire C - Total Units in Service-Convenct 2 17,547,645
LINE 22 Number of Units -Convener 2 /Total Converter Units (Line 21 / (Line 17 + Line 21 + Line 25)( 0.69551
LINE 21 Total Maintenance / Scrvice Hours Allocated to Converter 2 (Line 20 x Line 22) 7,126,912 h, ,
SCHEDULE C', LINE B - CONVERTER 3
LINF. 14 Total Labor flours Allocated to Converters(Line 16) 1O247,Oti3 Ius.
LINF 2S Schedule C, Line(: - Total Units it Servrce-Convener 3 7,497,290
LINF 26. Numbcr of Units-Converter 3 / Total Converter Units ILme 25 / (Line 17 + Litz 21 + line 25)J 0.29716
LINE 27 Total Maintenance / Service Hours Allocated to Convener 3 (Line 24 x Line 26) 3,045,017 tus.
Page 11 1205 Artaclurrants
SCHEDULE A INFORMATION
VEHICLES
TOOLS
MAINTENANCE FACILITIES
OTHER I
OTHER 2
SCHEDULE A - TOTAL CAPITAL COSTS
SCHEDULE BINFORMATION
SALARIES & BENEFITS
SUPPLIES
UTILITIES
OTHER TAXES
OTHER I
OTHER 2
SCHEDULE B - AN'N`UAL OPERATING EXPENSE
FCC FORM 1205 CAPITAL ASSETS/GENERAL LEDGER AUDIT REPORT 2007
Comcut Cable Communlcoll-s, LI.C rand Camnst CAN, Commualatlone Holdings, Inc.
ACCUMULATED DEFERRED CURRENT
GROSS BOOK DEPRECIATION TAXES NET BOOK PROVISION
973,299,082 688,244,233 13,222,574 271,832:75 99,305,723
584,239,310 421,2'•3,306 22,065,410 140,900,594 40,932,798
1,557.538,392 09,51?.579 35,287,984 412,73^,869 140,238,521
TOTAL AMOLT'7
4,572,698,664
13,626,057
334.952,565
313,193,229
5.234,660,515
SCHEDULE C INFORMATION
UNITS
GROSS BOpK ACCUMULATED
DEPRECIATION DEFERRED
T
XES CURRENT
REMOTE 1
CABLE CARL
CONVERTER 1 (BASIC ONLY UNITS)
CONVERTER 2(ALL OTHER)
CONVERTER 3 (HD & HDDVR)
25,229,930
167,772
194,995
17,541.645
7 491290
296,679,999
14 261,711
212,161
3,'16,559:53
2 996 673 905
236,439,590
4,024,700
211,163
2,833,919,100
918 18,34 1,886 A
(23.559,162)
1.245,207
(377)
1%142,975
261.932.796 NET BOOK
9J'99,571
8,991.904
1,3"5
732,497.178
1,91e 499 223 PROVISION
62,291,530
2,188.646
947
362,670,908
483,650,026
SCHEDULE C - TOTAL CAPITAL COST 50,627,632 7,024.397,029 3,992,936,439 389,661,439 2.641,789.151 910,802,057
PAGE I
SCHFDCLEABREAKDO"IN'
SCHEDULE .A - COMMON ASSETS
VEHICLES
TOOLS
MAINTENANCE FACILITIES
OTHER I
OTHER 2
SCHEDULE A • TOTAL AMOUNTS
SCHEDULE A • COMCAST SYSTEM ASSETS
VEHICLES
TOOLS
MAINTENANCE FACILITIES
OTHER I
OTHER 2
SCHEDULE A • TOTAL AMOUNTS
GRAND TOTAL SCHEDULE A
FCC FORA 1205 CAPITAL ASSETS/GENERAL LEDGER AUDIT REPORT 2007
Comcasl Cable Communlcaslom, LLC and Comcasl Cable Communications Holdings, Inc.
ACCUMULATED DEFERRED CURRENT
GROSS BOOK DEPRECIATiO?' TAXES NETSOOK PROVISION
ACCUMULATED
N DEFERRED CURRENT
GROSS BOOK DEPRECUTI0 TAXES NET BOOK PROVISION
973,299,082 688,244,203 13.222,574 271,832 275 99,305,723
584,239.310 421,273.306 22.065 410 140.900,594 40,932,798
1,557,538,392 1,109,5;^,539 35,28",984 412,732,869 140.235,521
1,557,'_38,392.00 1. 101),5 t 7.539.00 35.181,984 00 412,732,869 m, _ _ ran
PAGE2
SCHEDULE A - COMCAST SYSTEM ASSETS BOOK COST BOOK ACCUM NET BOOK BOOK PROVISION TAX COST
TAX ACCUM NET TAX
j DEFT
AXES
TOOLS
VEHICLES $84139,310
299
973 421,273,306
1
' 162,966,004 40,932,798 584,239,310 477,276,885 -
--
106,962,425 --
22,065,410
CAPITALIZED VEHICLE LEASES ,082
, 688-
".-
33 285,054,849 99,305,723 973,299,082 721,804,066 251,495,016 13,222,574
TOTAL SYSTEM ASSETS 1,557.538,392 1,109,517,539 4x8,020,853 14038,521 1,557,538.392 1,199,080,951 338,457,441 35,287,984
DEFERRED TAX CALCULATION NET HOOK NET TAX HOOK LESS TAX NET TAX RATE DEF TAXES
TOOLS 162,966,004 106,962,425 56,003,579
03940
22.065.4:0
VEHICLES 285,054,549 251,495,016 33,559,833 0.3940 17,222
574
CAPITALIZED VEHICLE LEASES ,
TOTALS 448,020,853 359,457,44 89,563,412 0.3940 35.287,984
NET TAX RATE CALCULATION • ((FEDERAL TAX • STATE TAX) - (FEDERAL TAX • STATE TAX)] FEDERAL TAX 0 3 500 STATE T
X '
, A
: "
0.C6 NET TAX RATE. 0.3940
SCHEDLLE B BREAKDOWN
SCHEDULE B - C'On1MON EXP L!,
SALARIES & BENEFITS
SUPPLIES
UTILITIES
OTHER TAXES
OTHER I
OTHER 2
SCHEDULE B - OMC.AST SYSTEM EXPENSES
SALARIES & BENEFITS
SUPPLIES
UTILITIES
OTHER TAXES
OTHER]
OTHER',
SCHEDULE B TOTALS - COMCAST SYSTEM EXPENSES
GRAND TOTAL SCHEDULE B- OPERATING EXPENSE
l SCHEDULE B • COM: AST S1'S7EM EXPENSES
SALARIES-REGULAR
SALA RIES•O V E RTINI E
SALARIES-BONUSES
SALARIES•VACATION
COMMISSIONS
UTO..RIES
CONTRACT LABOR
BUILDING MAINTENANCE
M & R•CONVERTER
RENTALS 'LEASE EXPENSE
VEHICLES-GAS & OIL
VEHICLES-REPAIRS & MAINTENANCE
EMPLOYEE BENEFITS
PAYROLL TAXES
M & R•EQUIPMENT
PARTS SUPPLIES SMALL TOOLS
PROPERTY TAXES
INSURANCE
TOTAL COMCAST CABLE SYSTEMS
FCC FORM 1205 CAPITAL ASSETS/GENERAL LEDGER AUDIT REPORT 2007
Cameos, Cable Communicatlom, LLC and Comcut Cable CommunlceUons Holdin¢s, Inc,
L TOTAL AMOUNT
TOTAL AMOUNT
42,A88,664
13,626,65"
334,952,565
313,193,229
5.234,66QS 15
5,234.660.515
TOTAL AMOUNT Schedule B. Line A Deacnptions
2,777,610,925 SALARIES AND BENEFITS
248,202,350 SALARIES AND BENEFITS
107,941,081 SALARIES AND BENEFITS
181,544,593 SALARIES AND BENEFITS
358,739,201 SALARIES AND BENEFITS
• UTILITIES
279491,292 OTHERI
SUPPLIES
51,461,273 OTHERI
117,919,374 OTHER2
121,513,380 OTHER2
73?60468 OTHER:
595,677,967 SALARIES AND BENEFITS
303.170,539 SALARIES AND BENEFITS
• SUPPLIES
13,626.057 SUPPLIES
• OTHER TAXES
OTHER2
5,234,66;).5i5
PAGE3
FCC FORA 1205 CAPITAL ASSETS/GENERAL LEDGER AUDIT REPORT 2007
Comcast Ca61t Communications, LLC and Comcast Ca61t Communications Holdings, Inc. PAGE 4
SCHEDULE C BREAKDOWN
I ACCU'MU'LATED DEFERRED CURRENT
SCHEDULE C • CC,ISICV ASSETc GROSS BOOK DEPRECIATION TAXES NET BOOK PROVISION
REMOTEI
REMOTE 2
REMOTE 3
CONVERTER I (BASIC ONLY UNITS)
CONVERTER 2 (ALL OTHER EXCLUDING HD)
CONVERTER 3 MD)
CONVERTER4(DVR)
SCHEDULE C- TOT AL AMOUNTS
I ACCUMULATED DEFERRED
CURRENT
SCHEDULE C • COMCAST SYSTEM ASSETS
UNITS
GROSS BOOK
DEPRECIATION I
TAXES
NET BOOK
PROVISION
REMOTE I 25,229,930 296.679,999 236,439,590 (23,559,162) 83,799,571 62,291.530
CABLE CARD 167,772 14.261.7 11 4,024 700 1,245,207, 8,991,804 2,188,646
CON'V'ERTER I (BASIC ONLY UNITS) 184,995 212,161 211.163 0")
' 1
375 907
CONVERTER 2 (ALL OTHER EXCLUDING HD) 17,547,645 3,716,559,253 2.833,919,100 1$0,142,975
50,142.975 ,
732,497,178 341,481,369
CONVERTER 3(HD,9iDDVR) 7,497,290 2,996,673.905 918,341.886 261,832796 1,816.499,223 431,213,392
SCHEDULE C • TOTAL AMOUN?S 50,627,632 7,024,387,029 3,992,936,439 389,661,439 2,641,799,151 837.175,844
GRAND TOTAL SCHEDULE C•TOTAL AMOI,-,TS 50,627,632 7024,387,029 3,992,936,439 399,661439 2,641,789,151 837,(75,844
SCHEDULE C • COMCAST SYSTEM ASSETS BOOK COST BOOK ACCUM NET BOOK BOOK PROVISION TAX COST TAX ACCU'NI NET TAX DEF TAXES
REMOTES 296,679,999 236,439,590 60,240,409 62,291,530 296,679,999 176,644762 120,035.217 (23,559,162)
HD.DVRCONV'ERTERS 2,034,006,170 563.117.082 1,470,889,088 291,297,813 2,034,006.170 1,015.580,796 1.018,425,374 178,270,703
CABLE CARD 14,261,711 4,024,700 10,237,011 2,188,646 14,261,711 7,185,125 7,076,586 1,245,207
NON•ADDRESSABLECONVERTERS 20,400,061 20,304,100 95,961 87,167 20,400.061 20,212,052 188,009 (36,267)
CONVERTER 1 1.04% 212,161 211,163 998 907 212,16! 210.205 1,956 (377)
C014VERTER2 9896% 20,187,900 20,092,937 94,963 86,260 20,187,900 20,001,947 186,053 (35,890)
ADDRESSABLE CONVERTERS 145,933,995 145.287.047 646,948 1407 272 145,933,995 155,651,447 (9,717,452) 4,083,574
HD CONVERTERS A21,025,751 295,103,959 525,921792 118,041,693 821,023751 480,148769 340,876,982 72,907,655
DIGITAL CONVERTERS 3,550,437,358 2.668.539.116 881,898,24: 339,987,837 3,550,437.359 3939,339,347 S11.098,011 146.095,291
DVR 141,641,984 60,120,845 81521139 21,873,886 141641994 97162565 54,479,419 10,654,438
TOTAL COMCAST CABLE SYSTEMS 7,024.397,029 3,992,936439 3.031450,590 937,175,844 7,024,387,029 4,981,924,863 2,0.12462.166 389,661,439
SCHEDULE C - DEFERRED TAX CALCULATION NET BOOK NET TAX BOOK LESS TAX NET TAX RATE DEF TAXES
REMOTES 60,240,409 120,035,237 (59,794,929: 0.3940 (23,559,162)
HD/D),'R CONVERTERS 1,470,889,088 1,018,425,374 452463,714 0.3940 178.270,703
CABLE CARD 10,237,011 7,076,586 3,160,425 0.3940 1,245,207
NON-ADDRESSABLE CON'VEK7 ERS 95,961 188.009 (92,048) 0.3940 (36,267)
ADDRESSABLE CONVERTERS 646,948 (9717,452) 10,364,400 0.3940 4,083.574
HD CONVERTERS 525,921,792 140,876,982 185,044,810 0.3940 72,907,655
DIGITAL CON'V'ERTERS 981,898,242 511,098,011 370,800,231 0.3940 146,095,29!
DVR 81,521,139 54,479,419 27,041,720 0.3940 10,654,439
TOTALS 3,031,450,590 2,042462,166 988,988.424 0.1940 389,661,439
NET TAX RATE CALCULATION - ,(FEDERAL TAX - STAT E TAX) • (FEDERAL TAX ' STATE TAX)] FEDERAL TAX 0 3500 STATE TAX. 0.0677 NET TAX RATE 03940
SAMPLING PLAN & ANALYSIS FOR COMCAST CABLE SYSTEM RATES
- Year 2007 Data -
Prepared for:
COMCAST CABLE COMMUNICATIONS
Prepared by:
Robert C. Hannum, Ph.D.
Department of Statistics and Operations Tecluiology
Daniels College of Business
University of Denver
Denver, Colorado 80208
February 10, 2008
Comeast Cable Communications Report - 2007 Data, p. I
SAMPLING PLAN & ANALYSIS FOR COMCAST CABLE SYSTEM RATES
- Year 2007 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 2007 by Comcast Cable Communications (hereinafter Comcast):
Primary Variables
1. Customer Equipment Maintenance and Installation Costs (End Amount)
2. Labor flours 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 I lome
5. Pre-Wired IIonic
6. Activate Pre-Existing Outlet
7. AO Same
8. AO Separate
9. Move Outlet
10. Upgrade
ll. Downgrade
12. VCR Same
13. VCR Separate
14. 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 (I ISC).
For Installation Time variables 4 through 11, 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. 1 This latter estimate incorporates both the average
time per install for each sampled entity and the installation activity level for each entity. For the
VCR Same, VCR Separate, and Trouble Call TimeZ variables, installation activity levels were
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).
z 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.
Comcast Cable Communications Report - 2007 Data, p. 2
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 below 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 123 management entities managed by Comcast at year-end 2007.
These entities vary widely in size, as evidenced by the variation in the number of subscribers, a
measure of the entity size (Appendix, page A 1). In addition, the principal study variables are
closely related to the size of the entities. It is well known3 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.
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 'T'otal (labor) Hours, for each of'236 regulated systems from the 1995
population.
• Sample data from previous years (1996 - 2006).
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 I lours 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
I lours. Additionally, sample data collected each year from 1996 to present also support this
approach, with the analogous correlations similarly large. Finally, the 20 areas included the 2007
sample yielded Spearman correlation coefficients of .986 and .986 between number of
subscribers and each of the two primary study variables. The analogous Pearson correlations
'See, (Ur example, Cochran (1977),p. 101.
Comcast Cable Communications Report - 2007 Data, p_ 3
were .957 and .945. 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 so?ne 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 2007 population frame of all
areas.`' The sample sizes and final straturn sizes are as follows:
ratum Number of Subscribers Stratum Size Sample Size
I
r Less than 150,000 60 9
2 150,000 to < 300,000 28 5
3 300,000 to < 400,000 25 3
4 400,000 to <600,000 8 2
5 600,000 and more 2 1
TOTAL 123 20
This 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 2007 covered approximately 4.3 million of the 24.1 million
subscribers (17.8%). The complete analysis included calculation of the desired estimates and
their standard errors for each of the fourteen study variables, including three analyses average
time per install, activity levels (number of installs), and total hours of install activity - for each
of the eight Installation Time variables 4 through I I (see page 2). As mentioned previously, both
In-1 louse and Contractor installs were taken into consideration for these Installation Time
variables and the final Unwired 'l'ime variable is a weighted average of Unwired-Aerial and
a Although there were minor changes in the population between the date the sample was selected and the last
day of 2007, 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 sample from the relevant population.
Comcast Cable Communications Report - 2007 Data, p_ 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 6.0% and 5.9% (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, page 494).
The final estimates for the two primary variables and the HSC are:
ENU AMOUNT: Estimated "Total ? $908,814,582
TOTAL IIOURS: Estimated Total = 26,883,497
HOURLY SERVICE CHARGE: $33.81
Given Total Costs of $5,442,159,175, the estimated End Amount equates to a Customer
Equipment and Installation Percentage of 16.7%.
Combined Ratio Estimate and Margin of'Error for Hourly Service Charge
I lourly Service Charge (HSC) is the ratio of End Amount divided by Labor I lours. The estimate
of the company-wide HSC derived in the Corncast sampling study ($33.81) 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 Cotyidence for Estimated Rates
The table below summarizes the 95% confidence level margins of error for the installation and
equipment maximum permitted rates for 2008, based on the estimates from the 2007 Comeast
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 - 2007 Data, p. 5
Installation Type Estimated Permitted Ratet 95% Margin of FrrorZ
Unwired $47.12 ± $4.58
Pre-wired $32.46 ± $4.24
Activate Pre-Existing
Outlet
$10.80
±$2.76
AO Satne $17.75 ±$1.58
AO Separate $27.72 ± $2.20
Move Outlet $23.49 ± $3.88
Upgrade $17.73 ± $2.57
Downgrade $11.94 ± $2.44
VCR Same $7.99 ± $1.15
VCR Separate $14.59 ± $1.92
Combine 't'rouble Calls $29.70 + $2.18
1 Computed as (Combined Ratio Estimate of IiSC x Estimated mean time per install).
2 The 95% represents the confidence level associated wide 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. 11. San Diego, CA:
Academic Press.
Govindarajulu, L. (1999). F,lements of Sampling Theory and Methods. Upper Saddle River, NJ:
Prentice Hall.
Lolir, S. L. (1999). Sampling: Design and Analysis. Pacific Grove, CA: Duxbury (Brooks/Cole).
Scheaffer, R.L., Mendenhall, W., and Ott, K.L. (2006). laementaty Survey Sampling, 6th ed.
Belmont, CA: Duxbury (Thomson, Brooks/Cole).
Comcast Cable Commtmications Report -1007 Data, p. 6
Formulas for Estimates and Standard Errors
N; = size of stratum i (# of areas in stratum i)
n; = sample size for stratum i
N = IN, = population size (here N = 123)
n = I n; _- overal I sample size (here n = 20)
y; = sample mean for stratum i
s, = sample standard deviation for stratum i
s; = sample variance for stratum i
Estimated Population Total: Y = ZN;y;
Standard Error of Estimated Total: ? N; (N; - n; )s,
n.
Estimated Population Mean: y = jN'y`
N
-n;)s
Standard Error of Estimated Mean:
N' n;
Allocation: n =/I(_ N;S; where S = true standard deviation for stratum i
I N, S;
Comcast Cable Communications Report - 2007 Data, p. 7
Formulas and Calculations for the Combined Ratio Estimate of Hourly
Service Charge and Associated Margin of Error
I lourly 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 flours
p, = population mean End Amount
p, = population mean Labor hours
N; = size of stratum i (# of areas in stratum i)
n; = sample size for stratum i
N = Z N; = population size (here N = 123)
n = 1] n, -- overall sample size (here n = 20)
y; = sample mean End Amount for stratum i
x, = sample mean Labor I fours for stratum i
Y = Ni y; - estimated population total End Amount
X = Z N;x, = estimated population total Labor Hours
N,Yr
Y = - = estimated population mean End Amount
N
x - Nr = estimated population mean Labor I lours
R = N,. = population ratio of mean End Amount to mean labor flours
N,
Then the combined ratio estimator of R and its estimated variance are given, respectively, by:
Y
rc = -_
X
and
z
N;
V(rc) - ?( N Xz
Conicast Cable Communications Report - 2007 Data, p. 8
?(y _ rcx)z
where s;. _ ni - = sample variance of the (y - rcx) terms within stratum i.
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 )2S2
-:7- ri •
n; N, .r;
The estimated variance of the combined ratio estimator can then be written as:
V('c)= (N's-) v(rc)
The following table summarizes the witlim-stratum components for the 2007 Comeast data:
Stratum n; Ni Sri V (rc )
1 9 60 $1,913,446 56,131 180,431 0.98
2 5 28 $6,903,247 213,890 967,552 3.36
3 3 25 $14,991,072 427,926 716,192 0.82
4 2 8 $17,434,091 500,330 6,216 0.00
5 1 2 $43,233,683 1,412,969 7,422,896 13.80
20 123
The combined ratio estimator is:
r _ 908, 814, 582 = 33.81.
C 26, 883, 497
The estimated variance of this estimator is: 21 P(rc)=(1203 (098)+(123 ) 3.36)+(1 5 0.82)+(123 0.00) t (13.80)=0.44.
l
l ) l ) l ) ( 2 123
J
The estimated standard deviation of the combined ratio estimator is 0.44 = 0.67 providing a
95% confidence level margin of error of 1.96(0.67) = 1.31. In summary, the combined ratio
estimate for the I ISC is $33.81, with a 95% confidence level margin of error of ± $1.31, yielding
a 95% confidence interval of ($32.50, $35.11). 5
5 Slight differences are due to round-off error,
Comcast Cable Communications Report - 2007 Data, p. 9
Population of Comcast Systems (12/2007)
60
54
48
42
36
c
30
Li 24
18
12
Number of Basic Subscribers
Conrcast Cable Communications Report - 2007 Data, Appendix page A 1
100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000
U, 4 2007 SAM PLE SYST EM VARIABLE S B Y STRATA
GL NUMBER SYSTEM NAME STRAT A SUBS End Amount Total Hours Conv erter Hours
E000385 SANTA BARBARA 1 32,397 $ 1,258,668 32,899 13,049
E000128 KEY WEST 1 34,680 $ 1,012,682 29,964 14,642
E003106 ORLANDO 1 36,026 $ 1,399,565 35,146 16,195
E000278 SANTA FE 1 49,266 $ 1,274,293 35,199 11,870
E000615 TUCSON 1 77,370 $ 1,762,899 53,026 17,651
E000550 LITTLE ROCK 1 79,076 $ 2,235,135 75,941 20,035
E003193 SCRANTON 1 82,917 $ 1,956,271 50,844 14,127
E000250 FORT WAYNE 1 94,152 $ 2,990,787 89,343 30,667
E000762 WILLIAMETTE VALLEY 2
E000420 KNOXVILLE 2
E000150 EASTERN SHORE 2
E000742 DENVER METRO SOUTH 2
$ 7,345,291 215,188 94,121
$ 4,002,705 132,842 67,387
$ 6,133,860 193,664 96,568
$ 9,299,523 247,658 53,164
PHI-000 PHILADELPHIA 3
HAR001 HARTFORD/SPRINGFIELD 3
E000205 SE MICHIGAN 4
BMC000 BALTIMORE METRO 4
301,199 $ 15,980,690 432,752 236,043
344,352 $ 11,230,682 328,162 81,183
470,765 234,416
LUtl371S HOUSTON 5 731,613 $ 43,233,683 1,412,969 562,683
TOTAL MEAN(M) $ 43 233 683 1,412,969 562,683
SD $ - - -
ESTIMATED TOTAL NUMBER OF SYSTEMS (N) 2 (M-N) $ 86,467,366 2,825,937 1,125,365
GRAND TOTAL 123 4,292,866 $ 908,814 ,582 $ 26,883,497 $ 10,801,099
Estimated HSC $ 3 3.81
Comcast Cable Conrnunicabons Report - 2007 Data. Appendix page A2
GL NUMBER SYSTEM NAME STRATA SUBS u?.+rw" p.w.no' Esmp Outlet' AO Sam.' AO S.
na' rno
O
1' ' '
w ..
u.r U?gno. Downpno. VCR Sam. v CR Somme
E000385
/ SANTA BARBARA , 32,397 1.5000 1.0000 0.5000 0.7500 C, 7500 0
5000 0
3333 0
2500 0
50
0
E000
28
£0
1 KEY WEST , 34,680 1 2018 0.6949 0.2677 0.4406 0,$219 .
0.6538 .
0
4687 .
0
2833 .
0
0
5500
03
06
E000278 ORLANDO
SANTA FE 36,028 1.3333 0.6667 C. 1667 0,5000 08333 0,5000 0.333] .
0
]373 .
0
1687 .
0
3333
E000615
T
CSON 49,268 1,3750 0.8333 0.3333 0.6667 0.8333 0,6667 0.6667 .
0.2500 ,
0
2500 ,
4167
0
E000550 U
LITT
E RO
K 77,370 1.2500 0.6667 0.5500 0.3333
0.7500
0.5500
0.5833
0
2500 .
0
2500 .
0
4167
E003!93 L
C
SCRANTON
1 79.076 1.2687 06781 0.4643 0,4432 0.7422 0.6683 02400 .
0 1733 .
C 0833 .
0 2500
EOOC25C
FORT WAYNE 62.917 1,0822 0.9206 04200 0.5565 0.7828 01654 0.7228 0.5990 . 25C0 ; SOCC
FnnrARS
CM4RI Pc-nu 1 94,152 1.3167 1.0667
-- 0.1667 0.5000 0.8833 0.5000 0.5833 O.S833
E000762
E000420
EOCOISO
E000742
2 :65,732 1.5000 1.0331 0.2500 0.6667 0.7500 07500
2 168,833 1.4500 0.9833 0.3975 0.6000 0.950C 0.4000
2 169.245 1,4326 1.2396 0.25DO 0.3819 0.7104 0.7500
2 252.775 1.2500 0.9000 02500 0.4167 0.7500 -
0.3333
1.3333
04167
7
3
Cwmmr Eo.otl Car. ? -... r. for .c W.,
h.a. w..
n
7 Cuuom.r 1C Cuawrn.. Comoh.o
c
, '
! o
Own.a E" EouF?id+ ,
- Car'
1.0000 0,7500 1.0000 0.9167
13333 0.8833 0.5833 0.9333
0.7500 0.7500 0.7500 0.7500
1.0000 1.0000 1.0000 1.0000
1.0000 0.8333 0!167 0.7500
0 7500 O.75C0 0-75,10 C 7500
c eoC^. 8333 C 56f.? 0.7 667
,.0000 t.0^. 1 OCC^ ^000
0.8333 0 8333 0 8333 6.5333
F 14 114 ^7e 0 8556
0.1845 0.098' 0.2041 c 1080
Sfi,Uxx SO.e869 46.6667 51.1373
1.1167 0.9000 0.3500 0.7889
0.8500 0.6500 0,7833 0.7611
1.53CC 0750, 0.5000 19167
1.o;oJ 1.0000 10000 1 00c0
0.9333 0.8333 0.2500 0.6389
' 0600 :; e267 a 5767 0.6211
G 2'20 CtJa7 0,3106 0.1405
29.6800 23.1467 16.1467 22.9911
1,050C 0,7000 0.7000 0.8167
1.0000 1.0000 1 Coco Oc00
1,5933 C.8687 1_0333 1.1611
1.2! t' 0.8555 0.91 1i
C 5926
0.3233 0.1503 01836 723
10.2778 21.3669 22.7776 24.6146
1, 0000 1000o
10833 0.8333 0.7633 0.9000
LGa17 0.8333 0.7633 0.9500
0.0589 C7C7
e.1711 6.6667 6.2667 7.6000
0.6667 0,6667 0.6667 0.6867
0.6667 0,6667 05667 06867
1.3313 1,3333 1.117 3 1.3133
1,0250 0.8408 01577 0.8786 '
Comc..l C844 Cemmumnean. R.pan. 100) Dare Aj{an41. O.q. A0
4 45x,149 1.0833 0.8333 - 0.5000 0.9167 01083 0.9167 0,6667
BMCOan R4i ?n.?nwa uc?wn .^. ,..,. - --' . --
2007 SA MPLE SYST EM INSTAL LATION AC TIVITY BY S TRATA
GL NJMBER
SYSTEM NAME STRATA a cr ?m.,•ad
" r of arevarad
' b c' Actuate Pre• v or q0 Same
' x of A:0 Seoarate n ct ??\aove c (j 9 d
'an
a o' Ccwngrada
SUBS nstals Instars ExlsongOut* nstaos Inatatls' Outletlnste!is' nstells' nstaas'
E000385 SANTA BARBARA 1 32,397 31.17 861.00 537,58 68.50 3.00 171
00 29
58
ECCO128
EOC3106 KEY WEST 1
ORLANDO 1 34,680 98.58 446.00 127.50 718.50 14.25 - .
105.67 .
39.17
E000278
SANTA FE 1 36.028 86.08 627.33 771.50 329.08 8,17 2.67 203.17 52.67
E000615
TUCSON 1 49,266 390.92 583.00 839.42 367.67 204.50 5.08 153.58 84.33
E000550
LITTLE ROCK 1 77,370 461.17 728.00 1,402.67 592.67 96.08 0.67 250.75 148.92
E003193
SCRANTON 79,076 105.33 2,033.58 1,696.75 541,00 178.75 28.00 793.67 522.92
E000250 1
FORT WAYNE 82,917 75.75 1,272.00 902.92 543.08 74.92 44.75 347.58 25.25
E000485 1
rHARI FSTnN , 94,152
- - 125.58
- .... 2,973.50
. ___ __ 186.50 1,360.83 226.33 1.92 568.75 88.75
E000762 WILLAMETTE VALLEY
E000420 KNOXVILLE
E000150 EASTERN SHORE
E000742 DENVER METRO SOUTH
PHL000 PHILADELPHIA
HAR001 HARTFORDISPRINGFIELD
263.75 4,098.50 2.824.50 2,571.67
435.75 3.343.67 1,81617 737.58
494.50 3,145.92 1,059.33 507.00
469.08 6.569.67 12,307,83 1.026.08
717.83 11,215.63 1,081.50 8,968.17
677,25 8.673.67 5.391.33
741.92 9,129.67
285.33 41.67 395.83 160.75
216.42 58.00 682.75 172.17
75.67 4.75 9"4,42 186.75
43.08 3,225.50 649.00
649.58 1,040.25 332.33
254.02 20.88 1,251.75 300.20
242.47 27.12 1,130.33 207.00
112.47 584,73 35,049.00 8,405.60
904.08 131.67 1,171.67 743.33
085.75 111.42 777.33 352.08
790,42 21.67 821.83 260.92
IIGRAND TOTAL 123 4,292,866 403.11 4,521.10 1,931.49 3,712.24 833.39 113.00 888.20 4-27-227
Sum of 1-House and Contractor tnstat s.
2 Sum of Unwnec Aerial Instatis and Lnvared U^derground Installs.
Comcast CaMe Communrceuons Report • 2007 Data, Appendix page A4
L GL NUMBER
SYSTEM NAME
i STRATA
SUBS
Unwired'
Pre",ed' Activate Pre•
Existing O:
AO Sam
'
O S
'
'
'
e A
eparate Niove Ounet Upgrade Downgrade'
E000385 SANTA BARBARA 1 32,397 46.75 861
00 6
E000128
KEY WEST
1
34
680
104
76 .
09
9
. 2
8.79 51.38 2.25 85.50 9.86
E003106
ORLANDO
1 ,
36
028 .
22
8 3
.
0 34
13 316.54 7,44 69-8 18.36
E000278
SANTA FE
1 , 1
.
5 418.22 128.58 164.54 6.81 1.33 67
02 17
56
E000615
TUCSON
1 49,266 530.92 485,83 279.81 245.11
170.42
3.39 .
102
39 .
21
08
E000550
LITTLE ROCK
1 77,370 557.29 485.33 771.47 197.56 72.06 0.37 .
146
27 .
37
23
E003193
SCRANTON 79,076 132.63 1,378.98 787.85 239.78 132.66 18.71 .
190
46 .
64
90
E000250
FORT WAYNE 1
1 82,917 90.32 1,171.00 379.25 302.24 58.64 34.25 .
251
24 .
15
13
E000485
CHARLESTON
1 94,152
11-1ea9Z 165.59
A- <„ 3,171.73 31.08 680.42 199.93 0.96 .
331.77 .
51.77
E000762 WILLIAMETTE VALLEY 2 165,732 395.63 4,234.02 706
13
E000420
E000150 KNOXVILLE
EASTERN SHORE 2 168,833 631.84 3,287.94 .
721.96
E000742
DENVER METRO SOUTH 2
2 169,245
25
7 69473 3,89979 264.83
NNAnnn
ATI AAITA runcTU 2,
75 586.35 5,912.70 3,076.96
PHL000 PHILADELPHIA 3 301,199 990.85 5,234.06 504.70
HAR001 HARTFORD/SPRINGFIELD 3 344,352 903.00 8,673.67
C r1/1r17r1n rurnnv , ,,, , -
1,714.44 214.00 31.25 131.94 53.58
442.55 205.60 23.20 307.24 66.00
193.60 53.76 3.56 641.91 81.07
427.53 32.31 1,935.30 216.33
5,380.90 843.81 100.94 820.17 260.17
2,695.67 2,791.93 66.85 388.67 176.04
E000205 SE MICHIGAN 4 454,149 826.40 7,608.06 5,948.96 724.55 15.35 753.35 '94
BM0000 BALTIMORE METRO A AC7 000 173
Ccmcasf Cadie Communicabons Report • 2007 Data, Appendix page AS
GRAND TOTAL 123 4,292.866 561.91 43 . 168 617.19 1,949.65
663 36 78 52 465 7S 150-.-88-1
Weighted average of Ir Mouse and Contractor Insta I imes
2 Based on the weighted average of Aena+ and Underground Install 7tmea with weights eauai to Act-ly Leveis for each instait time type.
1 60 9 1,913,446.22 114,806,773 807,001 221,425,013,952,136
2 28 5 6,903,247.40 193,290.927 1,977,006 503,421,841,205,079
3 25 3 14,991,071.67 374,776,792 3,376,170 2,089,729,461,642,590
4 8 2 17,434,090.50 139,472,724 1,419,653 48,369,974,186.988
5' 2 1 43,233,683.00 86,467.366 7,133,423 101.771,450,103,954
123 20 908.814, 582 2.964.711,741,090,750
Std. Error = S
Estimated Mean = $
Std_ Error = $
Variance for stratum 5 imputed by regression methods-
7,388,136.44
442.616.60
Stratum N n Mean N'Mean S N(N-n)s`/n
1 60 9 56,130.63 3,367,838 26,961 247,147,956,765
2 28 5 213,890.30 5,988,928 55,909 402.609,005,028
3 25 3 427,926.14 10,698,153 97,440 1.740,685.083,452
4 8 2 500,329.96 4,002,640 41,811 41,955,141,459
5' 2 1 1,412,968.54 2,825,937 220,701 97,418,282,539
123 20 26,883.497 2,529,815,469.242
Estimated Mean
Std. Error
' Variance for stratum 5 imputed by regression methods.
1.590,539.36
218,565.01
12,931.21
1 60 9 18,005.10 1,080,306 6,022 12,328,939,155
2 28 5 78,364.95 2,194,219 18,304 43,153,221,618
3 25 3 168,734.06 4,218,351 79,390 1,155,497,507,295
4 8 2 272,857.27 2,182,858 54,364 70,931,173,289
5' 2 1 562,682.53 1,125,365 59,363 7,047,869.805
123 20, 10,801.099 1,288,958,711,163
Estimated Moan = 87.81181
Std. Error = 9,230.27
Variance for stratum 5 imputed by regression methods.
Comcast Cable Communications Report - 2007 Data. Appendix page A6
AVG. INSTALL TIME • UNWIRED
Stratum N n Mean N'vean N
I 6C 9 1.2679 76.07 0.1347
2 28 5 1.3932 39.01 01003
3 25 3 1,5722 39 31 C_5643
4 It 2 '.2279 9.92 0.2G44
2 1 14r°n 2.80 0.311E
123 2n 167.01
N(N-n)s'!n
6.17
1.30
58.38
100
0.19
67.04 INSTALL ACTIVITY - UNWIRED'
SiraWm N n
Mean
1
60 9 202.71
2 28 5 407.07
3 25 3 645.19
a
4
2 751.33
51
2 t 7,940.E7
'., 20
'Mean a
12.182J8 176.32
11.397.87 92.28
1
6,129.88
92.91
6,010.67 13.32
3.881.33 110.02
49.582.51
(N.n)s'/r,
10,570,276.00
1,096,901,23
1.582.615.24
4.256.33
24,207.59
INSTALL TOTAL HOURS - UNWIRED'
Stratum N n M
can N'Mean s
1 80 9 246.30 14,777.95 2G7.57
2 28 5
560,98 15.707.30 117,34
3 25 3 1,014.63 25.385.63 125.22
q
8 2 953.57 7,628.54 17.0.84
5' 2 1 5.635.13 161.92
69,114.56
(N-r,)s'/n
14,648,317,99
1,773,377.20
2,874,533.86
776.208.38
52,436.52
2C 12487195
Estimated Total .
Std. Error • 167.01
8.19 Estimated Total .
Std. Error • q
8,542.57
3,643.93
Esf?matad Total
SId. Error •
69,114.56
4,486.08
Estimated Mean .
Std. Error .
COEFFICIENT OF VARWTION .
' Average of Aerial and Underground IeRual wegnts).
' Variance for stratum 5 Imputed by averaging variances for 1.3578
0.0666
4,90%
strata 1.4. Estimated Mean
Std. Error •
COEFFICIENT OF VARIATION
` Aerial and Underground combined
' Variance for stratum 5 imputed by averaging variances for strata
403.6098
29.6255
7.35%
1.4,
Estimated Mean .
Std. Error.
COEFFICIENT OF VARIATION
UNWIRED
Estimated Population Mann Time per Install a
'
581.9070
36.4722
6.49
7.3934
Weighted avorage of Aaryi and Jnderg round !wegfds • actw771
awos;
' Var•nce 107 stratua 5 impaled by averaging varances'0r strata 1 -4
AVG. INSTALL TIME • PREWIRED
Stratum N n Mean N'Mean s
1 60 9 0.7993 4796 0 .16C5
2 28 5 10812 30.27 0 .t5E8
3 25 3 0.9889 24.72 e 5168
4 8 2 0.9325 746 0 .14C3
5' 2 1 1.3000 2.60 0.2503
123 20 113 01
N(N-n)s'!n
8.78
3.17
48.98
0,47
0.17
61,52 INSTALL ACTIVITY - PREWIRED
Slratum N n Mean
t
60 9 1,512.19
2 28 5 4,772.58
3 25 3 8,583.00
4 8 2 8,131,88
5' 2 1 26.300 58
123 20
N'Mean
s
90.731.67 1.270.24
133,632.33 t 739.73
274.075.00 2.709.86
65,056.00 1.4-.1 C9
52,801.17 1,969.'6
556,095.!7
(N•n)6'/r1
548,596,997.16
389,833,243.81
7,348,281,205,09
47,788,234.08
6,987,352.32
2339487032.26
INSTALL TOTAL HOURS -PREWIRED
Statum
N n Mean N'Mean s
1 60 9 1'222'84 73,370.41 1,047.39
2 28 5 5,143.18 744,009.09 2,055.06
3
25 3 7,535.66 188.39144 1,993.29
a
8 2 7,464,34 59,874.73 174,96
2 1 34,190.76 68,381.52 1,526.77
123 20
534,027.19
(N-n)a'Jn
372,992,066.95
543,958,210.03
728,418,522.35
734, 646.06
4,662,057.86
1E5C495503.24
Est-mated Total .
Std. Error • 113.01
7.84 Estimated Tola •
510. Error . 558,085.17
48,368.24
Estimated Total •
Std. Error.
534,027.18
40,629.81
Estimated Mean . 0.9188
Sid. Error • 0.0634
COEFFICIENT OF VARIATION . 6.94 %
' Vanarce for stratum 5 Imputed by averaging variances for strata 1.4, Estimated mean . 4,621.0989
Std, Error • 393.2378
COEFFICIENT OF VARIATION .
8,70%
' Variance for stratum 5 Imputed by averaging variances for strata id.
Estimated Mean .
COEFFICIENT OF Std. EVARIATIONrror •
PREWIRED
4,341,8844
330.322
1 >
7 61
Estlntated Pp ulatlnn Mew Tlma r tni l c
. enarr..e for s-atum 5 Imputed by averaging variances for strata 1.4 0.960
Comcast Cable Commumroatrons Report - 2007 Data, ADpendix Page A7
2007 Estimates and Standard Errors
2 28 5 0.2962 8.29 0.0672 0.58
3 25 3 0.2556 6.39 0.2365 10.25
4' 8 2 0.1818 0.79
2 1 0.1816 007
123 20 30.47 24 &
Estimated Total • 30.47
Std. Error a 4.98
Estimated Mean a 0.2477
Std. Error - 0.0405
COEFFICIENT OF VARIATION - 16.3E
Variances for strata 4 6 5 imputed by ii,wag ng variances for strata 1-:
2 28 5 6,232.02 174 496.47 5,972.28 4,594,061,953.58
3 25 3 942.47 23.561.81 881.22 142,368,012.23
4' 8 2 - 3,503.97 254,666,861.18
5' 2 3.503.97 24,555.57177
23 20 237,573.27 5' R 77P.157'17
Estimated Total • 237,573.27
Std, Error. 72.028.27
Estimated mean . 1,931.4900
Std. Error • 585.5794
Variances for strata 4 8 5
4d5
2 28 5 0.4964 13.90 0.1280 2.11
3 25 3 0.5500 13.76 0.0500 0.4E
4 8 2 0.5020 4.02 0.0028 0.00
' Variance for stratum 5
Estimated Total - 82.27
Std. Error - 2.31
Estimated Mean - 0.5062
Std. Error - 0.0188
2 28 5 1,724.43 48,264,13 1.404,12 263,935,094.12
3 25 3 8,115.19 202.879.86 2.413.21 1,067,660.568.25
4 8 2 11,312.50 90,500.00 827.90 16,460.208.33
ou it ZSe.u2 15,081.11 318.23 34,431,129,42
2 28 5 1,830,79 51,262.18 1,804.08 419.206,503 42
3 25 3 342.83 8,570.63 297.05 16,176,911.55
4' 8 2 1,07148 27,553,716.94
5' 2 1 1.071.48 2,296,143.07
'23 2' 75,915.92 499664404.30
Estimated Total • 75,913.92
Std. Error • 22,35117
Estimated Mean - 617.1863
Std. Error. 181.7331
2 28 6 870.61 24,377.16 715.19 65.881,585.70
3 25 3 4,522.97 113,074,27 1,583.47 459,667,329.12
4 8 2 6,677.41 45,419.25 384.03 3,639,545.63
Estimated Total • 456,605.66 Estimated Total - 239,808.80
Std. Error • 43.465.66 Std. Error • 25,861.82
Estimated Mean • 3.712.2411 Estimated Mean - 1,949.6472
Sid Error • 353.3793 Std. Error s 210.2687
COEFFICIENT OF VARIATION . 9.52% COEFFICIENT OF VARIATION s 10.7894
' Variance for stratum 5 imputed oy averaging variances for strata 1.4. AO SAME
EWmatetl ft Mallon Mean Time per Install *+ 0.6252
Variance for stratum 5 ?mouted by averaging variances for strata 1-4.
C0mc8sl Ceoie Communlcahons Report • 2007 Data, Appendix page A8
2007 Estimates and Standard Errors
AVG. INSTALL TIME - AO SEPARATE INSTALL ACTIVITY - AO SEPARATE INSTALL TOTAL HOURS • AO SEPARATE
Stratum n Mea^, N'Mea^, s N(N'n)s''n Stratum N n Mean. N'Mean s N(N-n)s°in Stratum N Mean N'Mean N(N-n)s'in
1 0 7 s
2
3
4
5' 6
28
25
8
2 9
5
3
2
1 0.
515
0.7821
0.8833
0.8334
0.8333 45,09
21.90
22,08
6.67
1.67 0.1071
0.0954
0.1803
0.1178
0.1294 3.90
1,17
5.96
0.33
0.03
2
3
4 60 9
28 5
25 3
8 2
2 1 239,07 14,344,44 398.31
254,02 7,••2.47 242.47
2,696.64 67415.97 1,628.75
1,111,17 8,889.33 453.61
2.372.25 4.741.50 876.93 53.942.023.60
7.572.44412
486,351.480.86
4,938.267.00
1,536.01613 1
2
3
4
5• 80
28
25
6
2 9
5
3
2
1 172.53
198.57
2.279.72
899.27
1
88
976 10.351.83
5.559.98
56,993.00
7,194.17
3
953
75 2642'
181.80
1.260.44
247.09
661
93 23.734.202.43
4,256,536.33
291,262,879.53
1,465,337.04
876
39
30
• ,
. ,
. . ,
9.
123 20 97.4 11.40 123 20 102,506.72 554342232.22 123 20 84,052 72 321595564.72
Estim ated Total =
Std. Error • 97.41
3.38 Estimated Total ¦
Std. Error = 102,506.72
23,544.47 Estim ated Total =
Std. Error . 84,052,72
17,933.09
Estimated Mean =
Std. Error. 0.7919
0.0274 Estimated Mean =
Sta. Error= 833.3879
191.4185 Estimated Mean =
c.,r 17-. 683.3555
1.s 1.1.
Variance for stratum 5 imputed by
Variance for stratum 5 Imputed
AO SEPARATE
Estimated Population Mean Titus per lnatrtl .? 0.8200
' Variance fD' st•atuT 5 imputed by averaging variances for strata 1.4,
2 28 6 0.3800 10.64 03752 18.13
3 25 3 0.6689 17.22 0.0839 1.29
4 8 2 0.7247 5.80 0.0232 0.01
2 28 5 20.88 584.73 27.12 94,735.80
3 25 3 481,92 12.047,92 624.27 71,447,371.88
4 8 2 86.63 693.00 91.86 202.540.08
5' 2 1 atr; Fla loo xao An
2 28 5 11-80 324.87 14.82 27,511.80
3 25 3 336.55 8413.84 437.95 35.162.691.79
4 8 2 63.84 510.74 68.58 112,685.37
Estimated Total a 63.00 Estimated Total • 13,899.64 Estimated Total ¦ 91857.64
Std. Error= 6.99 Std. Error= 8,487.03 Std. Error= 6,953.94
Estimated Mean a 0.5122 Estimated Mean ¦ 1110044
Std. Error: Estimated Mean • 78.5190
0.0568 Std. Error= 69.0002 Std. Error • 48.4080
COEFFICIENT OF VARIATION = 11.10%i COEFFICIENT OF VARIATION • 61.08% COEFFICIENT OF VARIATION ¦ 61.65%
Variance for stratum 6 Imputed by averaging variances for strata 1.4. ' Variance for stratum 5 imputed by averaging variances for strata 1.4. MOVE OUTLET
Estimated Population Mean 'Time par Install w 0.894E
VarlanCe to• stratum 5 impl;ted by aweraging variances for strata 1-4
.
Cl Cable Communications Report - 2007 Data, Appendix page A9
2007 Estimates and Standard Errors
2 28 5 0.5437 15.22 0.1494 2.88
3 25 3 0.6000 15.00 0.1000 1.83
4 8 2 0.5835 4.67 0.4712 5.33
2 1 0.5000 1,00 0.2643 0,14
123 20 67.78 18.74
Estimated Total - 67.76
Std. Error- 4,33
Estimated Mean - 0.5511
Std. Error- 0.0352
2 28 51 1,251.75 35.049.00 1,130.33 164,560.335.66
3 25 3 1,020.75 25.518.75 212.82 8,303,511.69
4 8 2 2,560,29 20,482.33 2.458.55 145,067,394.08
Estimated Total - 109,249,08
Std. Error. 18,413.92
Estimated Mean - 888.2039
Std. Error - 149.7067
2 28 5I 735.04 20,581.21 707.43 64.459,417,71
3 25 3 625.59 15,839.86 218.85 8,780,485.51
4 6 2 91415 7,317,97 228.25 1,250,387.32
Estimated Total - 5?,287.54
Std. Error - 8,812.27
Estimated Mean - 485.7523
Std. Error- 71.6444
Variance for stratum 5
Valiance for
UPGRADE
i Estimated Population Mean Time per haul • 0.8244
' Ve^.ance fcr stratum 5 Imputed by averaging variances for strata 1.4.
2
3
4
5 --
28
25
8
2 -
5
3
2
1 --- - --•-• -••^-
0.3302 9.24 0.1006
0.3944 9.86 0.0918
0.3333 2.67 0.4714
0.5000 1.00 0.2573 -••-
1.30
1.54
5.33
0.13
2
3
4
5' ??
28
25
8
2 -
5
3
2
1 ou,ac ,oie.q IDO.ru
300.20 8406.60 207.00
1,287.19 32,179.86 1.295.88
130.46 1,043.67 184.50
1,549.50 3,099.00 667,13 5,44W, 113.45
5,519,200.12
307,777,848.80
816,930.08
890,117.08 1 80
2 28
3 25
4 8
5• 2 9
5
3
2
1 39.14 2,348,58 31,88
94.47 2.645.28 68.99
452.75 11,318.87 408.60
86.97 895.76 123.00
774.75 1,549.50 216.71 345,455.44
613.087.96
30,607,825.09
363,080.04
93,928.06
123 20 46.05 16.47 123 20 52,547.57 323353209.55 123 20 18.558.01 32023376.80
Estimated Total - 46.05 Estimated Total - 52.547.57 Estimated Total - 18,658.01
Std. Error- 4.06 Sta. Error- 17,982.02 Std. Error. 5,668.92
Estimated Mean - 0.3744 Estimated Mean - 427.2180 Estimated Mean - 160.6781
Std. Error - 0.0330 Std. Error- 148.1953 Std. Error- 46.0075
COEFFICIENT OF VARIATION - 6,61% COEFFICIENT OF VARIATION - 34.22°k COEFFICIENT OF VARIATION - 30Ay°?,
Varian ce fcr st ratum 5 Imputed by averaging variances for strata 1.a, Vena-ca for str atum 5 Imputed by averaging %vances for strata 1.4, DOWNGRADE
Estim ated Population Mean Time, per Instal(- 0,3832
' Variance for stray--n 5 imputed by averaging variances for strata 1-4.
Comcasf Cable Communications Report • 2007 Dsfa, Appendix page A10
1 2007 Estimates and Standard Errors
2 28 5 0.2133 5.97 0.0594 0.45
3 25 3 0.3056 7,64 0.0768 1.14
4- 8 1 0.2000 1.60 0.0683 0.26
5' 2 0.2500 0.50 0.0683 0.01
123 18 29.09 3.5:
Estimated Total • 29.09
Std. Error v 1.88
' Variance for strata 4 8 5 Imputed by averaging variances for stral
' One miss,ng value In stratum 1; one missing vaue in stratum 4.
2 28 5 0.3500 9.80 0.0373 0.18 2 28 6 0.8211 22,99 0.1405 2.54
3 25 3 0.5389 1147 01456 3.89 3 25 3 0.9926 24.81 0.1723 5.45
4- 8 1 0.4500 3.60 0.1033 0.60 4 8 2 0.9500 7.60 0.0707 0.12
5' 2 1 0.4167 0.83 0.1033 0.02 2 1 0.6667 1.33 0.1286 0.03
123 18 53.08 8.37 123 20 108.07 12.1.'
Estimated Total a 53.08 Estimated Total a 108.07
Std. Error • 2.89 Std.Error - 3.48
' VananCs for strata 4 b 5 Imputed by averaging variances for strata 13. Average of Inside Wire Serice Calls, Customer-Owned Equipment C:
One missing value in stratum 1; one missing value in stratum 4, and Customer Education Cells, assuming equal activity weights.
Variance for stratum 6 Imputed by averaging variances for strata 1.4,
Comcast Cable Communications Report - 2007 Data, Appendix page A 11
STRATUM
END AMOUNT
TOTAL HOURS F CONVERTER
HOURS
(Total n = 20)
1 MEAN $ 1,913,446.22 56,130.63 18,005.10
(n=9) SD $ 807,000.65 26,961.19 6,021.76
2 MEAN $ 6,903,247.40 213,890.30 78,364.95
(n=5) SD $ 1,977,006.49 55,909.27 18,304.11
3 MEAN $ 14,991,071.67 427,926.14 168,734.06
(n=3) SD $ 3,376,170.07 97,440.47 79,389.63
4 MEAN $ 17,434,090.50 500,329.96 272,857.27
(n=2) SD $ 1,419,653.33 41,810.66 54,364.19
5 MEAN $ 43,233,683.00 1,412,968.54 562,682.53
(n=1) SD $ _
Overall Estimate $ 908,814,582.20 26,883,496.63 10,801,098.98
HSCI $ 33.81
Comcast Cable Communications Report - 2007 Data, Appendix page A 12
2007 SAMPLE DATA SUMMARY STATISTICS -Installation Times
STRATL%A lkreee'? Aovaw Ae.
11•o?aW' Eating OWet'
AO S.me
AO Scpraw'
Mave ouw'
t*grae•'
Dovgrage'
VCR same
VIM Saparaw CenWircO
Track eah'
(iotai n =201
1 MEAN 12679 0.7993 02832 04934 0.7515 0.4889 05315 03879 0.2229 04229 08556
n=9 SO 0.1347 0.1605 01967 0.0902 0.1071 02938 01587 0.1549 0.0654 00972 0.1080
2 MEAN 1.3932
n=5) SO 0.1003
3 MEAN 1.5722
n=31 s0 0.5643 1.0812 0 2962
0.1568 0.0672
0.9889 0.2556
0.5168 0.2365 04964
0.1280
0.5500
0.0500 0, 7821
0.0951
0.8833
0.1803 0.3800
0.3752
0 6889
00839 05437
01494
0 6000
0.1000 03302
0-1005
0.3944
00918 02133
0059{
0.3056
0.0788 0.3500
0.0373
0.5389
01456 0.8211
0.1405
0._99_26
0 1723
4 MEAN 1.2279 0.9325 0.5020 0.8334 0.7247 05835 03333 0.2000 0.4500 09500
rw2 s0 02044 0 1403 0.0028 0.1178 00232 04712 (14714 00707
5 MEAN 1.4000 1 30_00 0.5000 0 8333 0.5000 05000 0.2500 0.4167 0 6667
In=1 SD -'
Overall Esthmt. 1.3578 0.9188 02477 0.5062 0.7919 03122 0.5511 0.37" 02365 0,4315 0.8786
1 W eyf9W Ner a o/ Y.Jlaae In0 Lortra kitty Imes. ?M • Vft equo b wjf * kveh 1w -h fp¢
2 Are.age of lRawee Aei y rb lllreo tlvergmvrE, w!? yu/•dpfb y eel lype.
3 AinrrJe W 1nssla Wae Ser'ncv Cda, /:vlfatl•r4]wa,e0 Equpwwe Ca4, aid Carslalner Eereaem Cats. arer equal wwg/K rw •adr type.
t T> - va e, ml .ha ebn xcaae actnty levees
na #fit
STRATtA4
Ikawaea' .
Pre•i/eGa Acerate (Ye-
Eakq OsA,,?
AO Srne'
AO Sap-' Ibre QAet•
llpgrrle'
Ors npraee'
(Tatat n = 201
1 MEAN 202.71 1,51219 658.58 103417 239.07 9.56 33547 130.32
(n----S) SO 176.32 1,270.24 62340 1.267L44 398.31 15 85 22643 156.70
2
n=5) MEAN
SD _407.07
9226 4,772.58
1,739.73 6,23202
5,97228 172443
1,404.12 25402
24247 2088 .
27.12 1.25115
1,130.33 30020
20700
3 MEAN 645 19 8.56300 94247 8,115 19 2,696 64 481.92 1 020 75 1,287 19
n=3) SO 92.91 2,709.86 981 22 2 4 13 21 t.628,75 62427 _
212.82 1,295 6e
4 MEAN 751 33 6,131.88 11,31250 1,111.17 86.63 2._%O 29 130 46
?2) SD 1332 14t109 827.90 453.81 9186 2,45855 18450
5 MEAN 1,940 67 26,300.58 - 26,445.93 2,37225 1 035.33 1_549 -A
/rl SO .._ _.--
_ Overall EM"s 403.11 4,521.10 231A9 3,712.24_ 833.39 113.00 88820
_ 42722
5 coanJee taue art k.NOUS• and cwaraL>me Mtah.
s A.erag• or r or u+...a Aenel Mewls tiro a or unree 1Rd. - - - _ _ -
.yaab lruran...e, na,_? ,..,: p •: r . , : r ,, . - -
STRATUM
tk-"'a
Peered Advs. the
Earserag Ou*W
AOSarne
AO Se -'
Mole Oufte
Upgrade'
[Mvegraf e'
(Tatar n = 201
1 MEAN 246_ 30 1,22284 268.02 508.17 172 53 6.81 161.89 39.14
(rr-9) SO ?07.57 1047.39 318.23 6.3695 264.21 1186 9174 31.88
2 MEAN 560 98 5,143.18 T 830 79 870 61 198.57 11 60 735 04 94 47
n=5) s0 11734 2,055.06 1,804.08 715 19 181 80 14v62 707 43 68 99
3 MEAN 101161 7,535.66 34293 4,52297 2,27972 33655 62559 45275
(n=3) SD 12522 1993.29 297.05 1,58347 1-?6044 43795 21885 40860
4 MEAN 953 57 7,464 :14 5,677,41 M21 63_84_ 914 75 86 97
1a=2) SD 179.84 174.96 384 03 247 09 68 58 228 25 123.00
5 MEAN 2 817.57 34,190 76 13222.92 1,976 88 2.01767 774 75
Overall Estimate 561.91 4,341.68 617.19 1.94965 683.36 78-52 4657S 15088
-
7 We.yere raagn of Rrltrusr :rf fay,,,. Mafat Tmes.
BeasesanAe-Vtre average ul Ae r uda)load traLA 1—x. ,wT rwti 1#11 lgTJ•o ALo- yte hto eWC eiarA - iq.n.
2007
M$C tk'MakM1 PitanrM f.,estng AAeI A09a.ae Al]Sepraen Munn TAAW lryrtle r.-V14e VCR Sm VCR 5epxaae T.UA, CJh
$33.81 (47.12 $32A8 (1080 (17.75 f27.72 (2].19 (17.73 311.94 (7.99 $14.59 (29-70
96W Maryrn u}Eerw
(4.68
$424
(2.71
$1.f>8
S2.20
$3.88
$?SI
$244
$115
$1.92 _
$2.18
C-a CeN, Comrnuaiue Ropue. 2007 Paw. AppanrLS pg. A13
2008Equipment and Installation Rates
Comcast
TYPE OF SERVICE MAXIMUM
PERMITTED
RATE OPERATOR
SELECTED
RATE
Hourly Service Charge $ 33.81 $ 30.99
Installation-Unwired Home (within 125 feet) 47.12 33.99
Instal lation-Prewired Home (within 125 feet) 32.46 23.99
Installation Additional Outlet-Connect Initial 17.75 12.99
Installation Additional Outlet-Connect Separate 27.72 2099
Other Installation-Relocate Outlet 23.49 1699
Other Instal lation-U grade (non-addressable) 17.73 14.99
Other Installation-Down rade (non-addressable) 11.94 10.99
Other Instal lation-U grade/Downgrade (addressable) 1.99 1.99
Connect VCR-Connect Initial 8.00 599
Connect VCR-Connect Separate 14.59 13.35
Remote Control (All Units) 0.31 0.15
Converter Box (Basic Service Only) 1.14 1.00
Converter Box (All Others Excluding I11)) 3.43 3.20
Converter Box (HD & HDDVR) 9.81 8.00
CableCARD 2.05 N/C
2nd CableCARD-TiVo Series 3/CPF requiring 2nd Cable CARD 2.05 1.79
?9.70 19.99
* Non-standard installations are based on the hourly service charge times actual time spent
on the activity