HomeMy WebLinkAboutComcast Cable LLC 2007 Annual FCC FilingCOMCAST CABLE COMMUNICATIONS, LLC
COMCAST CABLE COMMUNICATIONS HOLDINGS, INC.
2007 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 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 10K
for the year ended December 31, 2007.
Line G4b Represents total net assets of Comcast Corporation taken from the company's 10K 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 COMI1UNICATIONS, LLC / COMCAST CABLE COMMUNICATIONS I I01-DINGS, 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 O 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 ITDTV-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. flours
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, HDTV-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 INSTALLA'T'ION
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 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.
COMCAST CABLE COMMUNICATIONS, LLC / COMCAST CABLE' COMMUNICATIONS HOLDINGS, INC.
Fndad COml.l.llaaw t C?
Wsshing+m, b C. 20554
Fopm 1205
DETERMINING REGU"TP.D EQUIPMENT AND INSTALLATION COSTS
-EQUIPMENT FORM'
G?mcast
('ommo..ry Una 14,t F (CUID) of cabk om. U.oe.( Form Sb.-
SEE FCC FORM 1144 FILING G"Im
Name of Cabk Op-q
COMCAST CABLE COMMUNICATIONS, I.LC ..d COMCAST CABLE COMMUNICATIONS HOLDINGS, INC.
M.f.g Address of Cabk Operates
Ctry Sta¢ L? Code
Name .rd Tnlc o(prrson crpkbng dsu f
Iekpho.e numb. I- N..b.
Name of l.oeal Fran A.-g Ad.-y
PLEASE SEE FRANCHISE AUTHORITY LISTING PROVIDED NTTH FCC FORM 1249 FTWNG
Mailing Add- of Local F'ranchisarg Autb.rty
City Sale LIP Cade
I. Ilk Form k bei.g fihd: 1E.ter .. -a' I. rbr pjw pris b.a1
In wryuncaoo wab FCC Fan 1200. FCC Form 1220.. FCC Form 1225.
At b Ne -Wkted K;C Fero 1200, FCC 1- 1220.. FCC 1- 1225 n the bow of d- fan
OR
ales .d.., fulfill FCC r.kt regoiri.g an anowl 1' 'bog of dris fmn
I- the due on wb.,b you b y filed d,. foem 03AIs0T (mmld.Vyy1
N.e llus sl.wd be the date on wbicA du: rates lav p.sotud, by osi^g .tb. K'C Forty )93. the prior filing of tbts forrq were io elFect
2- F.Ier the d.te .. whkb y.. el.rad y..r boob I.r We Dxal yr.r rta"" 1."J- 12l3IN7 (-Wddlyy)
N- Ib.s r dl ird... dre and of due 12 n..dh r -W r. f. wW.b yo. - filing this (._
3. I.dxaae for eorpor.t< rtw.s f Iota c.bk sy- 1Ewer a. "a^ L. the -, b..1
X C-Cwpur....
SubehapHr 5 <orryxstwn
P--rsbip
Sole Propr.-bp
(Aber (Plea. -pt- ".I
Approved by OMB 3(" 070)
page I E-d 4 0 f. Windows FCC F1 1205
luoc 199r.
wl
Soi ? mro! ,,,
MO-09of Iwo -(C P...ddv
°.^^P^'.H 10 0 r -A
I?4xl ypwl
-t rnpo .yvadS
?ssoz :?awmsy?em
1 4.4
x%61 -w
[or1 -:1 J: t
I a,4
10400M ®70 -AV p-oiddy
KSW J0l-'?%q-At
uassimmyj .3 R+»%d
Fedml Cmmt.npms Commission
wasbingtoq O.C. 2M54
m, rCS i MV L IIPM"4rr AND INSTAUATSON CHARGES
ST EP A. -roy s-ke cxa e
/. 7oW C Coos dlnsta0atian and Main-- Scbedok A. Box I
2.
ToW Anssual ntw for [.saltation and Mainz _ Scbcduk K Boa 2 $207, 98,619 9872
99.659 9
3-
Total - I Costs and n ' E p-- for Imtatlauws ad Maunwncs
Kline 2 . SS]3
92
A
-
Cus r F and InuJluim Penenu (arucb as e L SS,N2,159,17a.9W2
S
Amual Conontn F Maintcrnnce nd Irwin m Cosa. F.ac C u d Lased I.oe ] a Lint 41 .
001670
'701
5
/
16
6.
Taal Lbw Flours for Maiarnrs" asd lmall Mm of Customo E and Servim a0acb ex laarim ,
1
1
, 70
x97
26
88.
70
7- Hwul Service Qar (HSCt(Line Srl.iue 6) ,
.
.
93..8057
Apw-M by OMB 306M1703
Page x Excel x of. W..1- FCC F.. ;201
June I9%
METHOD OF BIIIIANG FOR INSTALLATIONS (pbnee u -a- y lbe'-"P.Uft b..)
htwlWsans billed by sbe Your based as fAc HSC aknlncd u 1- 7.
X Inssalla;suns NOW a a sardrd clatge.
?
$ p a
a e ? ? a
c
21 F
R n ? ?
P r
R x ?
n
m
ZS$
8 8 ms?
0 S
_
0
o P v
v
- sso s? s° ,
sa s ? r„
o ?l ? ? YL - g N? ? Q
g Y y
? T
Yo
r
r and camwoiuriar. corams.ion
wnhWV*Xk O C. 205S4
WORI(SNEFT FOR CAI.CVLATWC TOTALS UIPMFM ANDWSTAI.LATFONC0M
1. 7oW C iW Cons o(IasoBariar and M+inrewrcc Schedule A. Haa 1
2. iaal Aruwal r F
nvs !a Irrsrafla,ino arrd Mainenance Sa-hnArle p, Fba I $I07,M8,659.9892
3.
ToW Amual C dl Ccm o(tnaallanon ar.f Ma,nr?rw,ce lave 1 a line 2 $$,244,660,51 x.92
? f sramerF
W?rnc+N arM Insutlanm Paceou anacY ea lanunnl. $3,442,159,1719042
S. A." Cuaana r Alamrr - and I-flatioo Cott,. Fac Cons o(Leaaed F
l - 3. L- < $000
6. iaal C W Cons o1 Loxd Cun wne, F ui -IS, dUkC. Boa ]
7
Arvwd Carona F and Irarallarron Coos Lnx 3 , I.inc 6 51.31,315,678.3313
8
Paca.a Albcation b Franchise Aru I+ee rM4U[tian) 51.31 2,313.638.3313
9 A16led Am.a1 EAn? a.d 1Mmpation Con lanc 7 a Lice 8
10
and Insralla,ien Coar lint 9 / 1111
M-,biy $000
11 Nmrha of Bavc Sud-t
u F
h So-00
s
rsnc
-
12-
13 F - and buollarw. Cos, Su6unber lane 10rlme 11
Inll.- Ad u,m
nr F
I
$0.00
. re
_W See
nw,rhont
11. Ad"unod MM.dr1 and Imnllq- Con Sub,crA- Line 12 a lint I l
SO 00
Approved by OMB 3066-0-01
Page 6 F -I 4 01a Wrodurs FCC Form I20 $
J- 1996
Fcdml Caassnunt-Co Luion
K'adnng.k D.C 20551
C .rreAt 1 .ad Inssatlasa. RaW
P Acmd
1. Cb W Cabk S-- La tj.aona
a Houc1 R.ac S A. 1- 7
b Avna linWlatioo Car
I- hrstalluµm of UowirW Hones B, Lsnr 9.3
517.12
2. 1-144.1 of Prewecd Hones S B. Liao 9b3
S1246
7 Inmllnroa of Addilsonal Cornnsion u 7wne of Inisial InslalWion B. Line 4c) 117.75
1 Insullanoa of Addnipul Comtcanons Rc u c 1-111 SW B
Line 9d3
p . f27.72
5. Osher h w0x.uns 1 S P. L.nes 9e1.9c6, Y<9
a R<k,csse (AnM
52!.19
b U ode N-A4&-.bk
$17.73
c. D.- a k Non-Adds-uabk
S I I W
1 Maahly ('AU 1« Lease of R<rsac Consols Sa C, Line 17, colwatu a<
Renaac Ca of type 1 All Ua
50.11
Reosoac Coma! Typ, 2-
SO 00
R-c (;-..I Typ, !: CabWARD
52.05
7. Munthl CTsar (nc I-- -fConve ne Bo.es J. S" Lnc 25, -1- a<
Gn- Boa Type 1 fi- Onl Uaunl
$1 14
C.-• Bo. T 2' AM Ochs Units [.thuds HD aad DVR)
S)41
C'9averacr Boa T ) (Ifi Dcfi.-.and Di " Video R--dn)
f9.fl
1 M(.ah C fo lust of ()rhn E M F. Lrc 77
Od- Fa)u s (S i ) 10 Ohl
5 (7u? (nr (lunging Tint U1 .nvl SK E Line 31, 35 ?r )6C-
$17 7)
LABOR COST AND POLICY (-H&SGES
bdicase )swr ant. u 10 dr following thrt yucnnan by pt-g aa'i m the appcopuK boa
1 Havc yw ncbad<d doe Tabor cons aasouscd u ads subwaba Cable daopa is ysnn Charges for niual iasaallwams
NO
NO
B
2 Have )--p.NJva10e bb- cons assoculed .,m sub-. b- cabk drops"
my"
NO
1. If you h- OW th.s fon be . , havc you cl-pa aay pobey, e.g., toss accaawng ar coal albcanur tlw Causes a aocac.se n tIK Costs
Mtu&d ?. d< ,n4-.- of caprrpnsa. and insultawas <bargcas
YES (Ya. nwa .oath a fuR e.ptanatwnl
eNU
CERTI/1CA7 ION STATEMENT
9.71 IFUL FALSE STATEMF N7S RUDE ON THIS FORM ARE MMLSHADIE SY IMF ANIVOR D"RISONMENT
(U S- CODE 771 LE 19. SECTION 1001). ANWOR FORFTfnw N S. CODE, TITI F 1), SECTION 5031.
App -d by OMB 3060-0703
Page J FLC porn 1205
1" 1.0 for Wrsdows
loot 1996
'Scc 2608 bil"pntcnl and IOSU14llon RAtes Shccl.
FCC FORM 1205
SCHEDULE D: AVERAGE. HOURS PER INSTALLATION
C orwast
Item 4. Upgrade/Downgradc Addressable
Avcra a flours per Installation (Attach an Explanation)
Item 5- Connect VCR - Connect Initial
Average Hours per Installation (Attach an Explanation) 0.2365
Item 6. Connect VCR - Comwet Seperatc
Average Hour per tnstallalion (Attach an Explanation) 0.4315
Item 7. Customer Trouble Call
Average Hours per Installation (Attach an Explanation) 0-8786
Item 8. Activate Pre-Existin Outlet
Average Hours per Installation (Attach an Explanation) 0.3195
Item 9. (Specify)
Average Hours per Installation (Attach an Ex anion)
Item i0 (Specify)
Average flours per Installation (Attach an I:x lanation)
Page 9 1205 Attachments
Page 9
1205 Attachments
FCC FORM 1205
Comrast STEP B. INSTALLATION CHARGE
FCC FORM 1205
SIIMINARY S('l1FDIl I.F:
Comcast
Carreat Fqulpmenl and Installation Rates -
Acnul
d. U rade/Do-n de Addressable
$1.99
e. Connect VCR - Connect Initial SR.00
f. Connect VCR - Connect Separate
14.59
8. Customer Trouble Call 7
S29.70
Activate Pre-Ezistin Oulla
10.80
1
See 2008 Installation and Equipment Rates Shea
Page 10 1205 Attachments
Page 11 1205 Attachments
FCC FORM 1205
SCIIF.UULF_ C
Cumcau
FCC FORM 1205 CAPITAL ASSETSIGENERAL LEDGER AUDIT REPORT 2007
Comcnst Cahle Communications, LLC and Comast Cable Communlcr.tlons Holdings, Inc.
SCHEDULE A INFORbiwTION ACCGMGLATED DEFERRED CURRENT
GROSS ROOK DEPRECIATION' TAXES NET ROOK PROVISION
VEHICLES
TOOLS 91.1,29v,OR7 688,244,133 13,212,574 271.872,275 99
723
305
'
MAINTENANCE FACILITIES ,
,
_
84,239,31(1 421,273,306 22,065,410 140,900,594 40,932,798
OTHER I
OTHER 2
SCHEDULE A • TOTAL CAPITAL COSTS 1.557,538,392 1
109
517
539 35
287
9R4
,
,
,
,
,
412,732,869
140,278,521
SCHEDULE B INFORMATION TOTAL AMOLTT
SALARIES & BENEFITS 4,572,888,664
SUPPLIES
13,626,051
UTILITIES
OTHER TAXES
OTHER 1 334,952,565
OTHER 2 313,193 229
SCHEDULE B • ANNUAL OPERATING EXPENSE 3.234.660.515
SCHEDULE C INFORMATION
UNITS
GROSS ACCUMULATED DEFERRED CURRENT
REMOTE BOOK DEPRECIATION TAXES NET BOOK PROVISION
1
CABLE CARD 25,229,930
7
77 296,679.999 236,439,590 (23.559,162) 83,799,5?1 2
62
530
CONVERTER I (BASIC ONLY UNITS) ,
16
2
84
995 14,261,711 4,,7W 1.245.207 8,991,805 ,188.
2,188
646
CONVERTER 2 (ALL OTHER) ,
1
-
4 212,161
7 211,163 (377) I373 ,
947
CONVERTER 3 (HD & HDDVR) 1
7,645
.5
'
- 3,
16,559,253 2573,919,100 150,142,975 732,497,1?8 362
670
908
SCHEDULE C • TOTAL CAPITAL COST ,49
.290
S 2 996 673 905 91 R 34 t 886 261,932,796 1.816 499 223 ,
,
483 650 026
0,62',632 7,024,381,029 3,992,936.439 789
661
439
64
7
2
,
. ,
1,
89„ 51 910,802,057
PAGE I
SCHEDULE A BREAKDOWN
SCHEDL'LF .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 AMOLNTS
GRAND TOTAL SCHEDULE A
FCC F0"1 1205 CAPITAL ASSF,TSIGENERAL LEDGER AUDIT REPORT 2007
Comcasf Cable Communicatlom, LLC and Comc.st Cable Communications Holdings, Inc,
ACCUS1ULATEU UEFERRED CURRENT
GROSS BOOK DEPRECIATION TA,YES NET BOOK PROVISION
ACCUMULATED DEFERRED CURRENT
GROSS BOOK DEPRECIATION TAXES NET BOOK FROVISION
973,299,082 688.244.233 13,222,514 271,832.75 99,305
723
584,239,310 421,271,306 22,065410 140,90,594 ,
40,932,'98
1,537,538,792 1,109,517,539 35,28?,984 412,732,869 140,238,521
1,551,538,39200 I,I09,517.539.00 35,287,984 A0 412,'32,869.00 14238,52; 00
PACE2
SCHEDULE A - COMCAST SYSTEM ASSETS BOOK COST BOOK ACCUM NET BOOK BOOK PROV
TOOLS ISION TAX COS' TAX ACCL'M NET TAX DEF TAXES
VEHICLES 584,239,310
973 421,273,306 162,966,004 40,972,798
584,279,310
477,276,883
106
962
423
065410
22
CAPITALIZED VEHICLE LEASES .299,082 688.2x4,233 285,054,849 99,305,723 973,299,082 721,804,066 ,
,
251,495,016 ,
17,222,514
TOTAL SYSTEM ASSETS 1.557.538,392 1,109131",539 448,020,853 140
238
521 1
55
538
392
,
, ,
,
, 1. 199.08C.951 358,457,441 35,287,984
I DEFERRED TAX CALCULATION NET BOOK NET TAX BOOK LESS TAX NET TAX RATE DEF T
XE
TOOLS
VEHICLES
162.966.004
106,962.425
56,003,519
23940 A
S
2
'
()65
4 10
CAPITALIZED VEHICLE LEASES 285,054,849 251,495,016 33,559,813 0.3940 .
.
,
13,222,574
TOTALS 448,020,853 353,457,441 89,563.412 0.3940 35,287,984
NET TAX RATE CALCULATION • (FEDERAL TAX • STATE TAX) - (FEDERAL TAX • STATE TAX)] FEDERAL TAX 0
35x0
. . STATE TAX: 00671 NET TAX RATE: n.3940
1 SCHEDULE B BREAKDOWN
I_ SCHED',111 B - COMMON EXPENSES
SALARIES & BENEFITS
SUPPLIES
UTILITIES
OTHER TAXES
OTHER
OTHER
SCHEDULE B - COMCAST SYSTEM EXPENSES 1
SALARIES & BENEFITS
SUPPLIES
UTILITIES
OTHER TAXES
OTHER I
OTHER 2
SCHEDULE B TOTALS • COMCAST SYSTEM EXPENSES
FCC FORM 1205 CAPITAL ASSETS/GENERAL LEDGER AUDIT REPORT 2007
COmeMI Cable Com-le-tinm, LLC and Comore Cable Communloilam Holdings, Inc.
TOTAL AMOITT
TOTAL AMOUNT
4,572,888,664
13,626,057
334.952.365
_ 313,191,^29
5.234,660,515
GRAND TOTAL SCHEDULE B -OPERATING EXPENSE 5,234,660,515
SCHEDULE B•COM'.+.STS1'STFM EXPENSES
SALARIES-REGULAR
SALARIES-OVERTIME
SALARIES-BONUSES
SALARIES-VACATION
COMMISSIONS
UTILITIES
CONTRACT LABOR
BUILDING MAINTENANCE
M & R•CON'VERTE,R
RENTALS'LEASE EXPENSE
VEHICLES-GAS & OIL
VEHICLES-REPAIRS & MAINTENANCE
EMPLOYEE BENEFITS
PAYROLLTAXES
M & R•EQUIPMENT
PARTS SUPPLIES SMALL TOOLS
PROPERTY TAXES
INSURANCE
TOTAL COMCAST CABLE. S5 STEMS
TOTAL AMOUNT Schedule B, Line A Desen0liona
•,777.610,925 SALARIES AND BENEFITS
248,202,358 SALARIES AND BENEFITS
107,943,081 SALARIES AND BENEFITS
181,544,593 SALARIES AND BENEFPI'S
358,739,201 SALARIES AND BENEFITS
UTILITIES
279 491,292 OTHER I
• SUPPLIES
55,461,173 OTHERI
117 919.374 OT14ER2
121,513.388 OTHER2
73,760.468 OTHER2
593,677,967 SALARIES AND BENEFITS
303,170,539 SALARIES AND BENEFITS
SUPPLIES
13,626,057 SUPPLIES
OTHER TAXES
OTHER2
5,234,660,515
PAGE 3
SCHEDULE, C BREAKDOWN
SCHFOL:L= C • Co?iMC? ASSETS
REMOTE I
REMOTE 2
REMOTE 3
CON-VERTER I (BASIC ONLY UNITS)
CONVERTER 2 (ALL OTHER EXCLUDING HD)
CONVERTER3(HD)
CONVERTER 4 (DVRI
SCHEDULE C- TOTAL AMOUNTS
FCC FORM 1205 CAPITAL ASSETSIGENERAL LEDGER AUDIT REPORT 2007
Comeast Cable Commoniracions. LLC and Contrast Cable C.cmm.nicallons Holdings, Inc.
ACCUMULATED DFFERRED CL•RRENT
GROSS BOOK DEf'RfrC1,4T10N 7.4.XE5 NET BOOK PROVISION
SCHEDULE C • C'0'.1CAST SYSTEM ASSETS
1!N1TS
GROSS BOOK ACCUMULATED
DEPRECIATION DEFERRED CURRENT
TAXES NET BOOK PROVISION
REMOTE 1
CABLECARD 25,229,930 296,679,999 236.439.390 (23.339,162) 83,799.571 62,291,830
CONVERTER I (BASIC ONLY WITS) 167,772
184
995 14,261.711
2
2 4,024,700 1,245,207 8.991,804 2,188,646
CONVERTER 2 (ALL OTHER EXCLUDINO HD) ,
7
5
7
4 ,161
1 211,163 (377) 1,375 907
CONVERTER 3 (HD,HDDVR) 4
,6
1
,
5
7
97
2 3,716,559,253 2.833,919,100 150,142,975 732,497,178 341,481,369
4
,
90 2,996,673,905 918,341,886 261,832,796 1,816,499,223 431,213
392
SCHEDULE C • TOTAL AMOUNTS 50,627,632 7
024
38'
029 992
3
936
439 ' ,
,
,
, ,
,
, 389,661,439 2.64 1,
99.151 837,175,844
GRAND TOTAL SCHEDULE C - TOTAL AMOUNTS 50,627,632 7,024,347,029 3.992,936,439 389,661,439 2,641,789,t51 8371'5844
SCHEDULE C - COMCAST SYSTEM ASSETS BOOK COST BOOK ACCUM
REMOTES 296,679,999 236,439,590
HD'DVRCONVERTERS 2,034,006,170 563,117,082
CABLE CARD 14,261,711 4,024,700
NON-ADDRESSABLE CONVERTERS 20,400,061 20,304,100
CONVERTER 1 1.04% 212.161 211,163
CONVERTER' . 99.96% 20,187,900 20,092,937
ADDRESSABLE CONVERTERS 145,933,995 145,287,047
HD CONVERTERS 821,025'51 295,103,959
DIGRALCONVERTERS 3.550,437,358 .1.668.539.116
DSR 141,641,994 69,120,845
TOTAL CO:MCAST CABLE SYSTEMS 7.024.387,029 3,992,936,439
SCHEDULE C - DEFERRED TAX CALCULATION NET BOOK NET TAX
REMOTES 60.240,409 120,035,237
HD'DVR CONVERTERS 1,470,889,088 1,0; 9,425,374
CABLE CARD 10,237,011 7,076,586
NON-ADDRESSABLE CONVERTERS 95,961 188,009
ADDRESSABLE COWERTERS 646,948 (9,-17,452)
HD CONVERTERS 525,921,792 340,876,982
DIGITAL CON': ERTFRS 881,898,242 511,098,01;
DVR 81,521,139 54,419,419
TOTALS 3,011.450.590 2,042462,166
NET TAX RATE CALCULATION- ((FEDERAL TAX - STATE TAX) • (FEDERAL TAX - STATE TAX)]
60,240,409 62,291,530
70,889,088 291.297.813
10,237.011 2.188,646
95,961 47,167
998 907
94,963 86,260
646.948 1.401,271,
3,031,450,590
(59,794,828) 0.3940
452 463,714 0.3940
3,160,425 0.3940
(92,048) 0,3940
10,364400 0,3940
185,044,4!.2 03940
370,800,23: 03940
27.041,720 0.1940
988,9R8 424 0.3940
FEDERALTAX 03500
176,644,762
1,015,580,796
7,185.125
20,212,052
210.205
7,024,787,029 4,981,924,863
(23,559,162)
178,270,703
1,245,207
(36,267)
4,083,574
72,907,655
146,095,291
10.6$4434
PACE4
120,035.237 (23,559,162)
1.018,425, 3 74 178.270.703
7,076,586 1,245,207
188,009 (36,267)
1,956 (377)
146,053 (35,490)
(9,717,452) 4,083,574
340,876.982 72,907,655
511,098.011 146,095.291
54479 419 10,654,438
2,042.462.166 389,661,439
389,661,439
STATE TAX. 0,0677 NET TAX RATE, 0 394•]
SAMPLING PLAN & ANALYSIS FOR CONICAST CABLE SYSTEM RATES
- Year 2007 Data -
Prepared for:
COMCAST CABLE COMMUNICATIONS
Prepared by:
Robert C. Itannum, Ph.D.
Department of Statistics and Operations Tecluiology
Daniels College of Business
University of Denver
Denver, Colorado 80208
February 10, 2008
Comcast Cable Communications Report - 2007 Data, p. 1
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 flours)
Installation Time Variables (Other Secondaty)
4. Unwired Home
5. Pre-Wired i Ionic
6. Activate Pre-Existing Outlet
7. AO Same
8. AO Separate
9. Move Outlet
10. Upgrade
11. 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 (HSC).
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.' 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-Acrial and Unwired-Underground installations (with each of these latter variables incorporating
both hi-House and Contractor installs).
a The Trouble Call 'lime is based on the average of inside wire sen ice calls, customer-owned equipment calls
and customer education calls, assuming equal activity levels for each.
Comcast Citbte 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 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.
Available Prim- 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) Itours, 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 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
flours. 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, for 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 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 straturn
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:
Stratum Number of Subscribers Stratum Size Sample Size
1 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 Time variable is a weighted average of Unwired-Aerial and
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 (tie 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 IISC are:
END AMOUNT: Estimated Total = $908,814,582
TOTAL HOURS: 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 F.rror for Hourly Semite Charge
Hourly Service Charge (I ISC) is the ratio of End Amount divided by Labor hours. The estimate
of the company-wide IISC derived in the Comcast 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 Co? f deuce 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 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-
Comearl Cable Communications Report - 2007 Data, p. 5
Installation Type Estimated Permitted Ratet 95% Margin of Error'
Unwired $47.12 ±$4.58
Pre-wired $32.46 ± $4.24
Activate Pre-Existing
Outlet $10.80
-
±$2.76
AO Same $17.75 ± $1.58
AO Separate $27.72 ± $2.20
Move Outlet $23.49 ± $3.88
Upgrade $17.73 ±$2.57
Downgrade $11.94 f $2.44
VCR Same $7.99_ ± $1.15
VCR Separate $14.59 +$1.92
Combine Trouble Calls $29.70 ± $2.18
Computed as (Combined Ratio Estimate of HSC x Estimated mean time per install).
z 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,l.L. (1988). Statistical Reasoning in Law and Public Policy, Vol. 11. San Diego, CA:
Academic Press.
Govindarajulu, Z. (1999). Elements 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, R.L. (2006). Elementary Survey Sampling, 6th ed.
Belmont, CA: Duxbury (Thomson, Brooks/Cole).
Conicast (.able Communications Report - 2007 Data, p. 6
Formulas for Estimates and Standard Errors
Ni = size of stratum i (# of areas in stratum i)
ni = sample size for stratum i
N = Z N, = population size (here N = 123)
n = Zn, == overall sample size (here n = 20)
y, = sample mean for stratum i
s, = sample standard deviation for stratum i
Si = sample variance for stratum i
Estimated Population Total: Y = ZN,y,
Standard Error of Intimated Total:
n.
r
Z Ni
Estimated Population Mean: Y =
N
1 j N; (N, - n; )s;
Standard Error of Estimated Mean:
N2 n,
Allocation: 11, = n N'S' where Si = true standard deviation for stratum 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
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
px - population mean Labor hours
Ni = size of stratum i (# of areas in stratum i)
Ili = sample size for stratum i
N = Z N, = population size (here N = 123)
n = Zn; = overall sample size (here n = 20)
y; = sample mean End Amount for stratum i
xi = sample mean Labor Hours for stratum i
Y = I]N; y, _ estimated population total End Amount
X = jNix; = estimated population total Labor Hours
ZN%Vi
y = = N estimated population mean End Amount
N.x
x = N` = estimated population mean Labor I lours
R = 11 - population ratio of mean End Amount to mean labor hours
P,
Then the combined ratio estimator of R and its estimated variance are given, respectively, by:
rc = -
.i
and
Ni )2 ( N, - n, s
12
,
Comcast Cable Communications Report - 2007 Data, p. 8
where s? = I (Y - rcx)2 =sample variance of the (y - rcz) terms within stratum i.
i1 -- 1
To see the contribution from each stratum to the overall variance of the estimator r,. , write the
within-stratum variance component for stratum i as:
z
Ni -11i 1 Z
n, N'
xi r.
)( )S
The estimated variance of the combined ratio estimator can then be written as:
(N; lz
v(rc) N I V(rc)
The following table summarizes the within-stratum components for the 2007 Comcast data:
Stratum n; Ni y; z; s,; 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 I -_ _
- -
a -
The combined ratio estimator is:
r - 908,814,582
= 33.81 .
26,883,497
The estimated variance of this estimator is:
_ 60 ? 28 25 2 8 )2(0.00) 2 2
V(r`)-(123) (098)-1- (123) 28 (123 0.82)+(123 +(123 (13.80)=0.44.
The estimated standard deviation of the combined ratio estimator is 0.44 = 0.67 providing a
95% confidence level margin of error of 196(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, vielding
a 95% confidence interval of ($32.50, $35.11).'
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
U 36
C
30
U
24
18
12
6
0
100,000 200,000 300,000 400,000 500,000 600,000 700,000 800,000
Number of Basic Subscribers
Comcast Cable Communications Repot - 2007 Data, Appendix page A?
5. 2007 SAM PLE SYSTEM VARIABLE S B Y STRATA
GL NUMBER SYSTEM NAME STRATA SUBS End Amount Total Hours Converter 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,028 $ 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
E000485 CHARLESTON 1 121 466 S 3 3-in 71fi Inn All ),I Al I
E000762 WILLIAMETTE VALLEY 2 165,732 $ 7,345,291 215,188 94,121
E000420 KNOXVILLE 2 168,833 $ 4,002,705 132,842 67,387
E000150 EASTERN SHORE 2 169,245 $ 6,133,860 193,664 96,568
E000742 DENVER METRO SOUTH 2 252,775 $ 9,299,523 247,658 53,164
NNA000 ATLANTA NORTH 2 282.714 S 7.734 RSA ?An MCI Rn 5Rd
PHI-000 PHILADELPHIA 3 301,199 $ 15,980,690 432,752 236,043
HAR001 HARTFORD/SPRINGFIELD 3 344,352 $ 11,230,682 328,162 81,183
E000205 SE MICHIGAN
454,149 $ 16,430,244
GRAND TOTAL 123 4,292,866 $ 908,814,582 $ 26,883,497 $ 10, 801,099
Estimated HSC $ 33.81
Comcast Cable Coamiunecations Report - 2007 Dala, Appendu page A2
GL NUMBER
SYSTEM NAME
STRATA
SUBS
um..rea' _-a....
I prewewa' rw:nvra r
Ace..te ar..
EsM+p 0-'I vr,m+wuK
AO Seme' aen.aplnoloe• Ylla 1
AO 5".-' Albve Ou4e1'
vognoe' ?`' `nN.
Oo mpnoe'
? 1CR Sane vCa Sepo•w
NWe W n
Sen CM
TC Cwbrnw TC Cueromer
Own. Eau. Eeuu6om
Combnep
TrpwleCM'
E000385
E000120
E003105
E000278
E000615
E000550
E003193
EOO.25C
E00,1485
OTAL
ESTIMATED TOTAL SANTABARBARA
KEY WEST
ORLANDO
SANTA FE
TUCSON
LITTLE ROCK
SCRANTON
FORT WAYNE
CHARLESTON
NUMBER OF SVSTE MSi NI 1
1
1
1
1
1
1
1
1
80 32397
34.680
36.028
49.266
77.370
79.076
829'7
94 152
121466
MEANIM
SO
M•N ',5000
'.2018
•.3333
'1750
'1500
1.2687
',0822
.3167
1.0833
1,2679
0.1347
76.0734 1AOOC
0.6949
0,6667
0.8333
0.6667
0.6781
0,9206
1,0667
6.6667
07993
0 1605
47.9570
0.2677
0,1667
0.3333
015500
0.4643
0.4200
0.1667
02632
0.1967
15.7915 0.5000
O.AA06
0,5000
0.6667
0.3333
0.4432
0.5565
0.5000
0.5000
0.4934
0,0902
79.8019 0.7500
0.5219
0.8333
0.8333
0.7500
0.7422
0,7828
0.8833
0.6667
0.7515
0.107`
45.0902 0.7500
.
0.5000
0.8667
0.5500
0.6663
0.7654
0.5000
-
0.4889
0,2938
29.3352 0.5000
0.6538
0.3333
0.6667
0.5833
0.2400
0.7228
0.5833
0.5C00
C, 5315
0.'587
31.6663 0.3333
C 4687
0.3333
0.2500
02500
01733
0.5990
0.5833
0.500C
0,3879
C !549
27.2733 0.2500
0.2833
0.1667
0.2500
0.2500
O.C833
0.2500
0.2500
0.2229
O 0654
13.3750 0.5000
0.5500
0.3333
0,4167
0.4167
0.2500
0.5000
04'67
04229
?. 0972
25.7750 1.0000
1,3333
0.7500
1.0000
1.0000
0.7500
0.8000
1.0000
0.6333
0,9407
0.1845
58.444.1 0.7500
0.8833
0.7500
1.0000
0.8333
O.M0
0.8333
1.0000
0-8333
0.8481
0.0981
50.eee9 1.0000
0.5833
0.7500
1.0000
0.4167
0.7500
0.6667
1.0000
0.8333
0.7778
0.2041
48.6667 0.9167
0.9333
0.7500
1.0000
0.7500
0.7500
0.7667
10000
08333
0.8556
01080
51.1371
ECO^7E2
E C0C420
EOOC"_C
E000742
NNAC03
O AL
ESTIMATED TOTAL WILLIAME'TE VALLEY
KNOXVILLE
EASTERN SHORE
DENVER METRO SOUTH
ATLANTA NORTH
NUMBER OF SYSTEMS (N)) 2
2
2
2
2
28 165,732
!68,833
169.245
252,775
282,714
MEAN(M)
SD
M'N 1 50:0
14500
1432E
1 2500
1 3333
1.3932
0,!003
39.0091 1 C33'
.9833
1239E
C 900,
1.250C
10812
01568
30.2716 01530
0.3975
0.2500
0.2500
0.3333
0.2962
0.0672
6.2928 0.6667
0.6000
0.3819
0.4167
0.4167
04964
0.128C
13.6984 0 750C
0.950C
0.7104
0.7500
017500
0.7821
OA954
21.8986 0.7500
0.4000
0,7580
-
0.3800
1.3752
10.6400 0.3333
0.45C'C
0,702o
0.6010
0.6333
0.5437
0,1494
15.2245 C,3332
0.3833
04341
0.3333
C 1667
0.3302
0.1005
9.2M7 0,'667
0.'333
0.2500
0,2667
0.2500
0.2133
C.0114
5.9737 C 3333
0.3333
0,4167
0,3333
0.3333
C.3510
0.1373
9.8000 11167
0.8500
1.5000
1,0000
01333
1,0800
0.2720
29.6800 0.9000
0.6500
0.7500
1.0000
0.8333
0.8267
0.1347
23.1467 0.3500
0.7833
0.5000
1.0000
0.2500
0.5167
0.3106
16.1467 0,7869
0.7611
0,9167
1.0000
0.6389
0.821'.
0.1405
22.9911
PHL000
H.AR000
E0007CC
TOTAL
ESTIMATED TOTAL PHILADELPHIA
HARTFORDISPRINGFIELD
CHERRY HILL
NUMBER OF 9YSTEMSIN) 3
3
3
25 301 199
344,352
347 519
MEAN W
SD
M•M 1.1.667
13333
2.2167
1.5722
O.S613
39.3056 0.4667
'.0000
•,50;:0
0, .9669
0.5186
24.7222 04667
03090
0.255E
02365
6.3668 0.6000
0,5000
0,5500
0,5500
0.0500
/1.7500 0.9333
9.6833
1.0333
.8833
0.1803
22.0633 0.7667
0,6000
0.7000
0.6889
0.0839
17.2222 0.7000
0,5000
0,6000
0.8000
0.1000
15,0000 0.3500
0.50.0
0.3333
C 3544
0.0918
9.8611 0,3667
0.3333
0.2167
0.3056
0.0768
71169 C 7000
0 5000
0 4167
0.5389
0.1456
13.4722 1.0500
1.001:
1,5833
1.2111
0.3233
30.2776 0.7000
1.0000
0.8667
0.8556
0,1503
21.3889 0.7000
1 0000
1.0333
0.911.1
01836
22.7776 0,8167
1.0000
1.1611
0,9926
0.1723
24.6146
E000205
BNI0000
TOTAL
ESTIMATED TOTAL SE MICHIGAN
BALTIMORE METRO
NUMBER OF SYSTEMS(N; a
A
6 454,149
467,383
MEAN(M)
SD
M•N 1.0833
1 3724
1.2279
0.2044
9.8229 C 8333
1 0318
0.9325
01403
7.4604 0.5000
C 5039
0.5020
0.0028
4.0156 0,9167
0.7500
0,8334
01178
8.6866 0 7CE3
0 7411
0.7247
0.0232
5.7977 0.9!67
C 2503
0.5835
0.x)12
4.6660 0.666>
0.3313
04714
2.6667
0.2000
O 2000
1.6000
1 4500
1.4500
.6000 '.0000
'.0833
1.0417
0.0589
8.1131
0.8333
6 8333
6.6667
0.7633
0-7633
6.2667 1,0000
C.9000
0.9500
0.0707
7.6000
EOC37'5
17CTA,- HOUSTON 5 73',613
MEAN(M)
SO 1.4009
1,4900 1.360,
1.3090 0.5000
05000 08333
0.8313 0,5000
0,5000 0.5000
0.5000 0.2500
0,2500 0.4167
4167 06667
C 6667 0.6667
0.6667 0.6667
0. 887 0,6667
0.6867
ESTIMATED TOTAL NUMBER OF SYSTEMS N 2 M•N 2.8000 2.6000 1.0000 1.6667 1.0000 1.0000 0.5000 0.6]33 1.]1]7 1,3333 1.1111 1.3]]3
GRAND TOTAL 123 4,292 866
1 W"AI. -Ke Of M•Nouee m0 CwtWIor nltol Tm"''m% *04Alu e0uel to 6moty r.elr M eeeYtype. 1.3578 0.91688
_ 0.2477 0.6062 0.7919
. 0.5122
. 0.5511 0,1744 0.2365 0.4315 1.0250 0.6408 0.7577
' . 0.8786
2 AwNepe 0' Jmwk. Aemel ena Umwe. U16er9m,.mo lequel -VA's)
3 A-pe 0' n We W re Ser..ce CaY, Cuuom *--d E4upnm1 Ce m o aelomm Ea vf n Cab, wm eouN wegAU to, MCA We.
C-1- Ce4' Comrum,<-' peppn - 2007 0.4e A? .mV,. pep. A3
2007 SAMPLE SYST EM INSTAL LATION AC TIVITY BY S TRATA
tt cr pawn•ec tt ci Prew?red tt of Ac"vale Pre• a of AO Same N cf A.0 Separate a of ..Vo e a of Upgrade a of Ocwngracs
GL NUMBER SYSTEM NAME STRATA SUBS nsads" nstaua' ExlaCmg0utie: ' nstalls' nate,ls' Out etlnstells' mails' nstalls'
ECOC385 SANTA BARBARA 1 32,397 31.17 861,00 - 537,58 68.50 3.00 171.00 29.58
E000126 KEY WEST 1 34,680 98.58 446.00 127.50 718.50 14.25 105.67 39
17
E003106 ORLANDO 1 36,028 86.08 627.33 771.50 329.08 8.17 2.67 203,17 .
52.67
EOO0278 SANTA FE 49,266 390.92 583.00 839.42 367.67 204.50 5.08 153.58 84.33
E000615 TUCSON 77,370 461.17 728.00 1,402.67 592.67 96.08 0.67 250.75 148.92
E000550 LITTLE ROCK 1 79,076 105.33 2,033.58 1.696.75 541.00 178.75 28.00 793.67 522.92
E003193 SCRANTON 1 82,917 75.75 1,272.00 902.92 543.08 74,92 44.75 347.58 25
25
E000250
CM/1ADA FORT WAYNE
r`-ml cCTnu 1 94,152
..-. .__ 125.58 2,973.50 186.50 1,360.83 226.33 1.92 568.75 .
88.75
E000762 WILLIAMETTE VALLEY 2 165,732 263.75 4,098,50 2,824.50 2,571.67 285.33 41.67 395.83 160.75
EOO0420 KNOXVILLE 2 168,833 435.75 3,343.67 1,816.17 737.58 216.42 58.00 682.75 172.17
E000150 EASTERN SHORE 2 169,245 494.50 3,145.92 1,059.33 507.00 75.67 4.75 914.42 186.75
E000742 DENVER METRO SOUTH 2 252,775 469.08 6,569,67 12,307.83 1.026.08 43.08 3.225.50 649.00
PHL000 PHILADELPHIA 3 301,199 717.83 11,215.83 1,081,50 8,968.17 904,08 131.67 1,171.67 743.33
HAR001 HAR7FORD/SPRINGFIELD 3 344,352 677,25 8,673.67 5.391.33 4,C85.75 111,42 777,33 352.08
GRAND TOTAL 123 4,292,866 403.11 4,521.10 1,931.49 3,712.24 833.39 113.00 888.20 427.22
t S" o' I-QO Se and Convacfor .nstaas.
2 Sin. c' L.'^wred Ae• a'. Irstal s and Jnvnred Underground Installs
Comcasf Cao;e Communlcel-ons Pooor. • 2007 Date, Appe^dix page A4
GL NUMBER
SYSTEM NAME
STRATA,
SUBS
unwired"
Prewired' Activate Pro.
Emstmq Outset'
AO Same'
AO Se
arate'
N4
O
a
t'
'
'
p ove
?
e u
pgrade
Downgratle
E000385
E000
28 SANTA BARBARA 1 32,397 46.75 861.00 268
79 51
38 2
25
1
KEY WEST
1
34,680
104,76
309
90
34
13 .
316
54 . . 85.50 9.86
E003106
ORLANDO
1
36
028
122
85 . . . 7,44 69.08 18.36
E000278
SANTA FE , . 418.22 128.58 164.54 6.81 133 67,72 17
56
E000615
TUCSON 1
1 49.266 530.92 485.83 279.81 245.11 170,42 3.39 102.39 .
21
08
E000550
LITTLE ROCK 77,370 557,29 485.33 771.47 197.56 72.06 0.37 146
27 .
37
23
E003193
SCRANTON 1 79,076 132.63 1,378.98 787.85 239.78 132.66 18.71 .
190.46 .
90
64
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
1')1 naa 165.59
- - 3,171.73
- --- -- 31.08 680.42 199.93 0.96 331.77 .
51.77
E000762
E000420 WILLIAMETTE VALLEY
KNOXVILLE 2
2 165,732 395.63 4,234.02 706.13 1,714.44 214.00 31.25 131.94 53
58
E000150
EASTERN SHORE
2 168,833
169
245 631.84 3,287,94 721.96 442.55
205.60
23.20
307.24 .
66.00
E000742
DENVER METRO SOUTH
2 ,
252
775 694.73
586 3,899.79 264,83 193.60 53.76 3.56 641.91 81.07
NNA000
ATLANTA
NORTH
2 ,
282
714 .35
496
33 5,912.70
8
381
46 3,076.96 427.53
32.31
1.935.30
216.33
TOTAL , . ,
, 4,384.08 1,574.93 487.19 658.83 55.39
MEAN(M) 560.98 5,143,18 1,830.79 870.61 198.57 11.60 735.04 94.47
ESTIMATED TOTAL
NUMBER OF SYSTEMSIN
28 SD
M•N 117.34
5
7 2,055.06 1,804.08 715.19 181.80 14.62 707.43 68.99
1
07.30
, 144,009.09 51,262.18 24,377.16 5,559.98 324.87 20,581.21 2,845.28
P H L 0 0 0
HAR001 PHILADEL?HIA
HARTFORD'SPRINGFIELD 3
3 301,199 990,85 5.234.06 504.70 5,380.90 843.81 100.94 820.17 260.17
E000700
CHERRY HILL
3 344,352
347
519 903.00
1
150
03 8.673 67 2,695.67 2,791 93 66.85 388.67 176.04
TOTAL , ,
. 8,699.25 52378 5.492.35 3,203.42 841.87 667.95 922.06
MEAN(M) 1,014.63 7,535.66 342.83
-
- 4,522.97 2,279.72 336.55 625.59 45215
ESTIMATED TOTAL
NUMBER OF SYSTEMS(N
25 D
M N 125.22
25
36 1,993.29 2W
.
05 1,583.47 1,260.44 437.95 218.85 08
0
,
5.63 188,391.44 8,570.63 113,074.27 56,993.00 8,413.84 15,639.86 11 38.8
EOG0205
8M0000 SE MICHIGAN
BALTIMOR
M 4 454,149 826.40 7,608.06 5.948.96
48 724.55 15
35 753
35 173
94
E
ETRO 4 4fi7 3A1 1 nail 7z 7 ocn c1 . . . .
Comces; Coble Communications Report - 2007 Cata Appendix page AS
11GRAND TOTAL 123 4 292 866 561.91 4,341.68 617.19 1,949.65 683.36 78.52 465.75 150.00 1 We ghted avorage of In Mouse and Contractor Instal Times
2 Based on the weighled average of Aena, and Lndergrounc Instal limes, %ah weights equal :o Act,i:y ?eveis for each irstair time :ype
Stratum N nj Mean N'Mean S N(N-n)s'!h
1 60 9 1,913,44622 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,717,741,090,750
Estimated Mean = $ 7,388,736.44
Std. Error= $ 442,676.60
COEFFICIENT OF VARIATION = 5.99°
Variance for stratum 5 imputed by regression methods.
Stratum N II I Mean N'Mean s N(N-n)s`/r
1 60 9 56,130.63 3,367,838 26,961 24 7,14 1,9b6,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.24:
Std. Error = 1,590,539.36
Esti mated Mean = 218,565.01
Std. Error = 12,93121
COEF FICIENT OF VARIATION = 5.92%
' Variance f or stratum 5 imp uted by regression methods.
SECONDARY VARIABLE: CONVERTER HOURS
Stratum N n Mean N'Mean s N(N-n)s2lr
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 Mean = 81,813.81
Std. Error = 9,230.27
Variance for stratum 5 imputed by regression methods.
Comcast Cable CA)mmunications Report - 2007 Data, Appendix page A6
2007 Estimates and St
nd
d Err
r
a
ar o
s
AVG. INSTALL TIME • UNWIRED INSTALL ACTIVITY - UNWIRED' INSTALL TOTA L HOU RS - UNWIRED'
$UAIdnJ N n Mean N'Vean q N(N-n)s°!n Stratum N n Mean N'Mean s N(N-n)s'/n Stratum N n bean N'M N(N-njs?n
6C san s
2 28
3 25
4 e
5' 2 5
5
3
2
'. 1.2579
1.3932
1,5722
'.2279
1.4c0^ 76.07
35.01
3931
9.82
2.80 0.13x7
0 1003
05643
01044
0.31'6 6.17
1.30
58.38
1,00
0.15
2
3
4 60
28
25
e 9
5
3
2 202.71
407.07
645.19
751.33
1,940.67 12.162.76
11,397 87
?6,129,86
6,010.67
3.881,33 176.32
92.28
92.91
13.32
110.02 1C,570,276.00
1,096,901,23
1,582.615.24
4,256.33
24
207
59 -
2
3
4
5' 60
28
25
8
2 9
5
3
2
1 246.30
560.98
1,01463
553.57
81757
2 14,777,95
15.707.30
25,365.63
7,628.54
5
635
13 207.57
117.34
125.22
179,84
161 '.4,648,317.99
1,773,377.20
2,874,533.86
'16.2C8.38
123
2C
1 ,
. . ,
. .92 52,436 52
67 01 67.04 123 20 49,682.51 13278256 39I 1» 9r an 1-. ce --- ,..
Estimated Total - 167.01
Std. Error a 8.19
Estimated Mean a 1.3578
Std. Error a C.0666
Estimated Toia% • 49,582.51
Sid. Error • 3,643.93
Estimated Mean a 403.1098
Sid. Error a 29,6255
Estimated Total a 69,114.56
Sid. Error= 4,486,OB
Estimated Mean - 561.9070
Std. Error a 36.4722
' Variance for stratum 5 imputed by averaging variances for strata 1.4.
a Aeriat and Underground Combined.
Variance for stratum 5 imputed by averaging variances for strata 1-4
i
2
3
L 4
5' ou
28
26
8
2 b,
5
3
2
1 u.r994
1,0812
0,9e89
0.9325
11000 47,96 0.1805
30.27 01568
24 72 0.5166
7.45 01403
2.60 02903 8.76
3,17
48.96
0,47
0.17 1
2
3
4
5' 60
28
25
8
2 9
5
3
2 1,512,19
4,772.58
8.563.00
8,131,88
28,300.58 90,731.67 1,270.24
133,632.33 1,739.73
214,075.OC 2,709.86
65,055.00 1,411.09
52.601.17 1.969.14 548.596,997.16
389,833.243.61
1.346.281,205.09
47,788.234.08
6,987,352.32
123 20 113 C1 61.52 '23 20 556,095.17 2339487032.2E
Estimated Total - 113.01 Estimated Total a 556.095.17
Std. Error a 7.54 Std. Error a 48,368.24
Estimated Mean a 0.9188 Estimated Mean • 4.621 0989
Std. Error a 0.0638 Std. Error a 393.2378
COEFFICIENT OF VARIATION - 6.94 j, COEF FICIENT OF VARIATION • 70%
6
' Variance for stratum 6 imputed by average^g vara,cai for st rata 1.4. ' Variance for sir aiurn 5 Imputed by averaging variances fcr strata .
1.a,
UNWIRED
15"ntsud Po utytion Mean Time per Install a 1.3939
Weighted average of Aerial and Underground (weights • act:vny Ieves;
Variance for stratum 5 imputed by averaging variances for sira;a 14
2 28 51 5,143.16 144,009.09 2,055.06 543,958,210.03
3 25 3 7,535.68 188,391.44 1,993.29 728,418.522.35
4 8 2 7,484 . 34 59,874,73 174.96 734,648.08
Estimated Total a 534,027.19
Sid. Error - 40,629.61
Estimated Mean • 4,341 8844
Std. Error: 330,3221
PREWIRED
Estltttated Population Mean Tlfn4 per Intuit
x 0,9603
' VaiA7Cn far scatum 5 IMbuiad by averaging variances for st raia 1.4.
COm685f Cable Communrcauons Report - 2007 Gate. Appendix page A7
2 28 5 01962 8.29 0.0672 0.58 2 28 5 6,232.C2 174,496.47 5,972.28 4,594,061,953.58
3 25 3 0.2556 6.39 0.2365 10.25 3 25 3 942.47 23,561.81 881.22 142.368,012.23
4• 8 2 01818 0.79 4' 8 2
?• a _ ._._ _ 3,503.97 294,865,861 16
Estimated Total . 30.47
Std Error . 4.98
Estimated Mean . 0,2477
Std. Error . 00405
COEFFICIENT OF VARIATION . 16.36%
Variances for strata 4 d 5 imputed by averaging variances for strata 1.3
AVG. INSTALL TIME - AO SAME
Stratum N n Mean N'61ean s NIN-n j9',
n
60 9 ,.4934 29.6C 0.0902 2.7
2 28 5 0.4964 13.90 0.1280 211
3 25 3 0,5500 13.75 0.0500 0.46
4 8 2 0.5020 4.02 0,0028 0.00
2 1 0.5000 1.00 0.0822 0.01
123 201 62.27 5.35
Estimated Total • 62.27
Std. Error. 2.31
Estimated Mean . 0.5062
Std. Erro•. 0.0188
Eat-mated Total . 237,573.27
Std. Error. 72,028.27
Estimated mean . 1,931.4900
Std. Error . 585.5794
COEFFICIENT OF VARIATION . 30.32/
' Vanances for strata 4 b 5 Imputed by averaging variances tar strata 1.3.
INSTALL ACTIVITY -AO SAME
Stratum N bean N-Mean s N(N-nis'!n
1 60 9 1,034.17 62.050.00 1.26744 548.174,155,97
2 28 5, 1,724.43 48,264.13 1,404,12 253,935,094.12
3 25 3 8,115.!9 202.879.86 2.413.21 1.067.660.568 25
4 8 2 '1,312.50 90,500.00 827.90 16,450,208.33
5' 1 26,445.83 52,891.67 1,588 co S,aa3,484,39
123 20 456.605.66 I.A".1411 rr
Variance for stratum 5 rmpuled by averaging varanbes for strata 1-4. ' Variance for stratum
2 28 S 1,830,79 51,262.18 1.804.08 419,206.503.42
3 25 I
3 342,83 8.570.63 297.05 16.176.911.55
4' 8 21 - 1,071,48 27.553.71E 84
51 2 1.077,48 2,296,143 0'
123 20 75,913.92 4ooza4.lr.e m
Estimated Total . 75,913.92
Std. Error• 22,353.17
Estimated Mean • 617,1863
Std. Error . 181.7331
by averaging
ou 9 508.17 30,490.09 636.95 137,939,013.71
2 28 5 870.61 24,377.78 715.18 65.861, 585.70
3 25 3 4,522.97 113,074,27 1,583.47 459,887,329.72
4 6 2 5,677.41 45,419.25 394.03 3,539,545,63
Estimated Total . 456,605.66 Estimated Total • 239,806.60
Std. Error. 43.485.66 Sid. Error. 25,861.82
Estimated Mean . 3,712.2411 Estimated Mean . 1,949.6472
Std. Error. 353.3793 Std. Error• 210.2587
OF VARIATION . 9-S2% COEFFICIENT OF VARIATION . 10.78%
variances for strata 1.4, AO SAME
Estlmated Pciutatlon Moen Time par Inetall r 0.8252
' Variance for stratum 5 -ouled by averaging variances for strata 11,
Cnnlcast C&We Communlcalions Report - 2007 pole, Appendix Page A8
2007 Estimates and Standard Errors
2 28 5 0,7821 21,90 0.0964 1.17
3 25 3 0.8833 22.08 0 '803 5.96
4 8 2 0.8334 6.67 0.''78 0.33
2 1 0.8333 1.61 0.1294 0.03
'23 20 97.41 11,4(
Estimated Total c 97.41
Std. Error. 3.38
Estimated Mean - 0.7919
Std. Error• 0.0274
COEFFICIENT OF VARIATION a 3.471,,
' Variance for str atum 5 im paned dy averaging variances for strata 1-4.
2 28 5 254.02 7.112.47 242.47 7,572,444.22
3 25 3 2.696.64 67,415.97 1,628.75 486,351,480.86
4 8 2 ',111.17 8,889.33 453.61 4,938,267.00
5' 2 2,372,25 4,744,50 876.93 1,536,016.33
123 20 102,506.72 554342232.22
Estimated Total - 102,506.72
Std. Error • 23,544.47
Estimated Mean • 833,3879
Ste. Error • 191.4185
Variance for stratum
-4.
2 28 5 198.57 5,559.98 18160 4,256.836.33
3 25 3 2. 279.72 56,993.00 1,260.44 291.262.879.53
4 8 2 899.27 7,194.17 247.09 1.465,337,04
5' 2 1 1, 976.88 3,953.75 661.93 876.309.39
123 20 64,052.72 321595564,72
Estimated Total = 84,052,72
Std. Error • 17,933.09
Estimated Moan a 683.3555
Std. Error. 145.7974
COEFFICIENT OF VARIATION c 2 1.34°,e
AO SEPARATE
Estim ated Po pWetion Moan Time per Inertall 0.8200
Variance for stratum 5 Imputed by averaging variances for strata 1.4
2 28 5 0.3800 '164 0.3752 18.13
3 25 3 0.6889 17.22 0.0839 1.29
4 8 2 0.7247 5.80 0.0232 0.01
5• 2 1 0.2422 0.12
123 20 63.00 48.85
Estimated Tota. ¦ 63.00
Site. Error. 6.99
Estimated Mean • 0.5122
Std. Error: 0.0568
' Variance for stratum 5 imputed by
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
2 1 315.89 199,569.40
123 20 13.899.64 72029610.7,
E56mated Total • 13,899.64
Std. Error. 8.487.03
Estimated Mean ¦ 113.0044
Std. Error: 69.0002
COEFFICIENT CF VARIATION= 61.00
' Va-lan ce for st ratum 5 imputed by averaging variances for strata 1.4.
2 28 5 11.60 324.87 14,62 27,51.80
3 25 3 336.55 8413.84 437.95 35,162,69',79
4 8 2 83.84 51014 68.58 112,885.37
5' 2 1 221.84 98,427.1.8
123 20 9,657,84 35449353.81
Estimated Total . 9,657,84
Std. Error • 6.953.94
Estimated Mean a 78.5190
Std. Emor¦ 48.4060
COEFFICIENT OF VARIATION ¦ 61.65%
MOVE OUTLET
_ EsUmatod Po ouletlon Moon Time par Intl b.661Q
Variance for stratum 5 Imputed by averaging variances for strata 1.4
Comcast Cable Ccmmunicetlons Report • 2007 Data, Appendix page A9
1 2007 Estimates and Standard Errors
2 28 5 0.5437 15.22 0.'494 2.88 2 28 5 1,251.75 35.049,00 1,130.33 164,560,335.66 2 28 5 735.04 20,587.2! 707.43 64.459,417,71
3 25 3 0.8000 15.00 0.1000 1.83 3 25 3 1,020.75 25,518.75 212.82 8,303,511.69 3 25 3 625.59 15,639.86 218.85 8,780485.51
4 8 2 0.5835 4.67 G.4712 5.33 4 8 2 2,560,29 20.482.33 2,458,55 145,067,394,08 4 8 2 914.75 7,317.97 228.25 1,250,387.32
5' 2 1 0.5000 1,00 0.2643 0.14 5' 2 1 4.035.33 8,070.67 1.361.86 3,709.339.83 5' 2 1 2,017.67 4,035.33 390.15 304,434,98
123 20 67,78 18.74 123 20 109,249,08 339072610.30 123 20 57,287,54 77656038.64
Estimated Total a 67.78 Estimated Total - 109,249.08 Estimated Total a 57,287,54
Std. Error. 4.33 Std. Error 18,413.92 Std, Error= 8,812.27
Estimated Mean . 0,5511 Estimated mean ¦ 8882039 Estimated Mean • 485.7523
Std. Error: 0.0352 Std. Error • 149.7087 Std. Error • 71.6444
COEFFICIENT OF VARATICN • 6,39 % COEFFICIENT OF VARIATION • 16,85%1 COEFFICIENT OF VARIATION • 15.38%
Variance for str atum 5 Imputed by averaging variances for strata 1.4. Valance for st ratum 5 Imputed by averaging variances for strata 1.4. UPGRADE
Essirmad Population Msan Time per InsW l 0:6247
• Variance for stratum 5 imputed by averaging variances for strata 1.4,
AVG. INSTALL TIME - DOWNGRADE INSTALL ACTIVITY - DOWNGRADE INSTALL TOTAL HOURS - DOWNGRADE
Stratum N n Mean N'Mean s N(N-n)s'/n Stratum N n Mean N'Mean N(N-n)slin =
6 Stratum N n Mean N'Mean s 1n
N(N-n)s
1 60 9 0.3879 23.27 0.1549 8.15 1 60 9 130.32 7,819.44 158.70 8,349,113,46 60 9 39.14 2,348.58 31,88 345455.44
2 28 5 0.3302 9.24 0.1005 1.30 2 28 5 30020 8,405.60 207.00 5,519,200.12 2 28 5 94.47 2,645.28 68.99 613.087.96
3 25 3 0.39x4 9.86 0.0918 1.54 3 25 3 1,287.19 32,179.86 1,295.68 307,777,848.80 3 25 3 452.75 11,318.87 408.60 30,607,825,09
4 8 2 0.3333 2.67 0.4714 5,33 4 8 2 130,46 1,043.67 164.60 816,930.08 4 8 2 66.97 895.78 123.00 363,080.04
6• 2 1 0,5000 !.DO 0.2573 0,13 5' 2 1 1,549,50 3.099.00 667,13 890,117.08 5' 2 1 774.75 1,549.50 216.71 93.928.08
123 20 46.05 16.47 123 20 52,547.57 323353209.55 123 20 18,558.01 32023376.60
Estimated Total - 46.05 Estimated Total • 52.547.57 Estimated Total - 18.558.01
Sid.E"or - 4.06 Sid. Error* 17,982.02 Sid. Error- 5,668.92
Estimated Mean - 0.3744 Estimated Mean : 427.2160 Estimated Mean v 150.8781
Std. Error - 0.0330 Std. Error • 146.1953 Std. Error • 46,0075
COEFFICIENT Cr VARIATION . 6L! COEFFICIENT OF VARIATION • 34.22% COEFFICIENT OF VARIATION - 30.49%
Vanance for str atum 5 Imputed by averaging vanancea for strata 1-4. Variance for str atum 5 Imputed by ayeregmg variances for strata 1.4. DOWNGRADE
j Estimated Poputattan.Mean Tifw psf lrlsUIi d.514
8-aece !or stratum 5 imputed by averaging variances for strata 1.4.
Comcast Cable Communicarlons Repoef - 2007 Data, Appendix page A 10
1 60 B 0.2229 13.38 0.0654 1,67
2 28 5 0.2133 5.97 0.0594 0.45
3 25 3 0.3056 7,64 0,0788 14
4- 8 0.2000 1.60 0.0683 0.26
5' 2 1 0.2500 0.50 0.0683 0.01
123 18 29.09 3.53
Estimated Total • 29,09
Std. Errors 1,88
Variance for strata 4 6 5 Imputed by averaging variances for stns-
" One missing vaiue In atratuT is one missing value in stratum 4.
- n oc rrw 1 c AVG. INSTALL TIME • TROUBLE CALLS'
Stratum N n" Mean N'Mean s WN-n)s'ln Stratum N n Mean N'M
°
1 60 8
0
4229 ean s WN-n)s
!
2 28 5
3 25 3
4- 8 1
2 1 .
25.38 0,0972 3.68
0.3500 9.80 0.0373 0,18
0.5389 13.47 0 1458
3.89
71.4500 3.60 0.1033 0.60
0.4167 0.83 0.1033 0.02 60 9
2 28 6
3 25 3
4 8 2
5.
2 0,8556 51.33 0.1080 3.97
0.8211
22,89 0.1405 2,54
0.9926 24,81 0.1723 5,45
0.9500
1.60 0.0707 0,72
8667
0
3
23 18
3 .
3
0,1286
0.03
5
.08 8.37 123 20 108.07 12,1
'
Estimated Total • 53.08
Sic. Error. 2.89 Estimated Total • 109.07
Sttl. Error • 348
Estimated Mesn+ 014317
Sic!. Error. 0.0235 FadmatadMean a 0.8TAa
Std. Error. 0.0283
COEFFICIENT OF VARIATICN • 5,45% COEFFICIENT OF
' Variance for strata 4
" One missing value i
8 5 Imputed by avsraging variances for strata 13,
n stratum 1: one missing value in stratum 4.
' Average of Inside Wi
and Customer Educ VARIATION • 122%
re Sence Calls, Customer-Owned Equipment Cans,
ation Calls, assuming equal activity weights.
' Variance for stratum 5 Imputed by averaging variances for strata 1.4.
Comcast Cable Communications Report - 2007 Data, Appendix page A 11
FsTRATUM
END AMOUNT
TOTAL HOURS CONVERTER
HOURS
(Total n = 20)
1
(n=9) MEAN
SD $
$ 1,913,446.22
807,000.65 56,130.63
26,961.19 18,005.10
6,021.76
2
(n=5) MEAN
SD $
$ 6,903,247.40
1,977,006.49 213,890.30
55,909.27 78,364.95
18,304.11
3
(n=3) MEAN
SD $
$ 14,991,071.67
3,376,170.07 427,926.14
97,440.47 168,734.06
79,389.63
4
(n=2) MEAN
SD $
$ 17,434,090.50
1,419,653.33 500,329.96
41,810.66 272,857.27
54,364.19
5
(n=1) MEAN
SD $
$ 43,233,683.00
_ 1,412,968.54 562,682.53
Overall Estimate $ 908,814,582.20 26,883,496.63 10,801,098.98
HSC?? 33.81
Comcast Cable Communications Report - 2007 Data, Appendix page A 12
2007 SAMPLE DATA SUMMARY STATISTICS - Installation Times` ,
s7RATUM urea"
(Tow n = 201 AcO-eae Pre.
P---4' E-"0OW
AD Sartr'
AD Scpaale' ttne (),feet'
llpgrade
[Wwgrwe'
V(:R same
VCA sq,.vav
Try Ai Calad'
1 MEAN 1.2679
n=9 SD 01347 04993 0.2632
0.1605 01967 04934
0.0902 0.7515
01071 04889
02938 05315
01587 0.3879 _
01549 02229
00654 04229
0.0972 0b556
0.1080
2 MEAN_ 13932
(n=5) SD 0.1003 1 0612 02962
0.1568 0.0672 0.4964
01280 0 782_1
0.0951 0.3800
03752 05-437
0.1494 03302
0-1005 02133
0.0594 0.3500
00373 0 8211
0.1405
3 MEAN 1.5722
m31 SD 0.5643 _ 09889 0 2556
05168 0,2365 0 5500
0.0500 0-8833
0.1803 0.6889
0.0839 0.6000
0.1000 0 39"
0-0918 03056
0.0788 0.5389
01456 0.9926
0.1723
4 MEAN _ 1 2279
n-2 SD 0.2044 0.9325
0 1403 0 5020
0 0028 0.8334
0 1178 0-7217
0.0232 0 54 35
04712 O
04714 02000 045D0 09500
0.0707
5 MEAN 14000
1) SD 1_3000 0-5000 08333 - 0.5000 0.5000 02500 04167 0.6667
Overall E tb-tea 1.3578 0.9188 02477 0.5062 0.7919 0.5122 0.5511 9.3744 02365 0,4315 0.9786
J W
nwlNed nrvape o! Ir.4buce aN CwRrciw baui Tanta. watt rletgnrs eqW b
2 A.eragc of Ilrrred Aaa4 and lAnsved Weagrwy, saw equl r"a?4s Iw eaN /
Riry Icveh
lpe.
1w eadl IMa-
--
- _-
3 Average or hole W e SerAce Cah. ! fi?nK
4 Ihse wits ea not ue vAS accouY a asty k yl?vrd EQupnwt Cab. yip Cvs}wrrcA EOucaRn Gals. wA caul wylo Iw eaN lypr
v Js-
SIRATTRI
Ibawe4a•
ae.eed• . A6rare L're-
E-& N QAq•
AO S.-*
AO Se4.raY• m- Ou4eP
It+grade•
Onwgr?fe'
(TrAal n =201
1
(n=9 MOAN
SD _ 202 71
176.32 1512.19
1,270.24 658.58
623.40 1,034 17
126744 23907
398.31 9 56
1585 335 4 7
22643 13_0 32
1%70
2
n=5) MCAN
SD _4.07 07
92.28 4,772.58
1,73973 6232.02
5,972.28 11724 43
1404.12 _ 254 02
24247 2088
27.12 1,251 _75
1,13033 300_20
20700
3
n=31 M1JW
SO _ 645 19
92.91 L50 00
2.70986 942 47
881.22 8,115 19
2,41321 2.69664
1628-75 _ 481 92
624.27 1 020 75
212.82 1.287 19
1295.68
4 MEAN 751.33 813188 _ 11.312.5_0 1,111_17 86b3 2,56029 13(116
n=2) SD 13.32 141109 82190 453.61 _
91-86 2.458.55 18450
5
n=1 MEAN
SD 1,940-67 26 300.58
---- 26445-83 2 372 25
- 4,03533 1,S49 50
Overall Ebilm to 403.11 4,521.10 1.931 A9 3,71224 83.3-39 113.00 888 20 42722
5 COmbnd Ivan or) bsabuse &A CaMxna bataK -
6 A-, of e W Unwed And "Left and a or B-,d j",,-V "taes. wN. ?n ?eyrh fw eaityre. -
STRATUM
lbrNM'•
Revved' Actiaae L're•
E.bvy (11.4cr
All Same'
AO Sef-'
Lore ONet'
Up9rrde'
Ornayrede'
(Total n = 20)
1 _ MLAN 246 30_ 1,22284 26802 508 17 _ 172 53 6.81
--- 161.89 39.14
n=9) SD 207 57 1,047.39 31823 636 95 264.21 11.86 91 74 31 88
2
6=5) MLAN
SD 560.98
117 34 5,14318
2,055-06 1,83079
1,804.08 87061
715.19 198.57
101 80 11.60
14 62 73504
7674.1 9447
68 99
3 _MEAN_ 1014.63 _7,535.66 34283 4,522.97 2.279.72 33655_ 62559 45275
n=31 SO 12522 199329 297.05 1,SR,347 1,26041 43795 21885 40860
4 KLAN _ 953 5 77,464.34 5,67741 8992 7 63 84 914 75 6 97
8
n=2)
SO
179 84
174 96
38403
247.09
68.58
228 25 _
_
123.00
5 __ MEAN
_ 2 817_- .57
- 34,190 76
- - 13,221.92 197688 2.01767 774 75
n=1) SO
Overall Estlntate 561 91 4,341.68 617.19 1949.65 68316 78.52 465.75 150.88
W,,gm" aseaage of b 44-e and Cm or Fatal T-
8 Based on he - d r+enge d Aad alt tktleryrouM Imi.i Trxa. rqrnbyrds e.„:al b A:-'M'r l crNz r,r eas rwd der typo
C., -v Cetera C.imimun.rwxons Rapo4. 2001 Dare, Appandla page A13
2008 Equipment and Installation Rates
Comcast
TYPE OF SERVICE MAXIMUM
PERMITTED
RATE OPERATOR
SELECTED
RATE
Hourly Service Charge $ 33.81 $ 30.99
Installation-Unwired Dome (within 125 feet) 47.12 33.99
Installation-Prewi red Horne (within 125 feet) 32.46 2399
Installation Additional Outlet-Connect Initial 17.75 12.99
Installation Additional Outlet-Connect Separate 27.72 20.99
Other Installation-Relocate Outlet 23.49 16.99
Other Installation-Upgrade (non-addressable) 17.73 14.99
Other Installation-Downgrade (non-addressable) 11.94 10.99
Other Installation-Upgrade/Downgrade (addressable) 1.99 1.99
Connect VCR-Connect Initial 8.00 5.99
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 HD) 3.43 3.20
Converter Box (HD & HDDVR) 9.81 8.00
CableCARD 2.05 N/C
2nd CableCARD-TiVo Series 3/CPE requiring 2nd CableCARD 2.05 1.79
Customer Trouble Call 29.70 19.99
* Non-standard installations are based on the hourly service charge times actual time spent
on the activity