The URL can be used to link to this page

Home My WebLink AboutComcast LLC Anual Filing for AdjustmentsCcomcasta Via UPS Neat DaN Air April I, 2008 Lorrie Rempher Information Services Director 25 West Main Street Auburn. WA 98001 RE: WA0096 Dear Lorrie Rentpher Comcast Cable 1,83 Inverness Drive West F140,wo(A , CO 80112 On behalf of your local Comcast Cable Communications, LLC-affiliated operator, enclosed are FCC Forms 1240 and 1205_ The forms represent Comcast Cable Communications, LLC's annual filing for adjustments to basic service, equipment and installation prices. Specific assumptions and details regarding the filings are in the enclosed Documentation Memos. The selected basic service price is in Attachment 2 ofthe Form 1240 entitled "Proposed Rate Stricture". 'The calculated FCC Form 1240, Line 19, maximum permitted rate and Line 110, operator selected rate are exclusive of the FCC Regulatorv fees. Equipment and installation prices can be found in a separate attachment entitled "2008 Installation & Equipment Rates". We will implement equipment and installation prices that are lower than the maxinuttm permitted rates calculated on FCC Form 1205. Comcast Cable Communications, I.LC has chosen April 1, 2008 as its filing date and plans to implement the attached basic service, equipment and installation price adjustments on or about July I, 2008. Appropriate notice will be sent to you and cable subscribers prior to any adjustment in the basic service tier, equipment and installation prices. Please call me at (720) 267-2238 or your local Conrcast Cable Communications, LLC-affiliated cable System Government Affairs contact. Janet Turpen at (425) 741-5750, if you have questions about the tiling. Respectfully, On Behalf of Comcast Cable Communications, LLC Robbin Pepper Director. Rates and Re-ulator West Division cc: Janet Turpen Enc. 1148611), H C Form 1240, FCC Form 1205 Attachment 1 FCC FORM 1240 - 2008 Summary of Maximum Permitted Rate I leadend: 114863D Headend Name: KING COUNTY 'SEATTLE (AMLI Br?.crc• A. Maximum Permitted Rate From Form 1240, Line 19. S 13.24 B. Network Upgrade Add-on, Form 1235. Part IIL Line 4 1.16 C. Adjusted Maximum Permitted Rate S 14.40 "A-H4863 _2K8R" B.xls \ Attachment I Attachment 2 FCC FORM 1240 - 2008 Proposed Rate Structure I leadend: H4863 D Headend Name: KING COUNTY " SEATTLE [A)V Service Rates Basic Operator Selected Rate $ 14.40 Less FCC Regulatory Fee - Net Service Rate $ 14.40 Franchise Related Cost $ - On the 2008 Installation and Equipment Rates sheet attached to the FCC Form 120 are the Operator Selected Rates for 2008. NOTE: Rates are exclusive of applicable franchise fees and FCC Regulatory fee. WA-H4863 2K8RWB.xis ' Attachment 2 Federal Communication Commission Washinston. DC 2054 FCC FORM 1240 t PDATING NIAXIVt NI PERMITTED RATES FOR RE:G( LATER CABLE SERVICES Cable Operator: Approved by OMt3 3060-0685 YLS NO 1. Does this filing inxohe a single franchise authority and a single communitc unit? X It }es. complete the franchise authorit}' infomiation below and enter the associated CV ID number here. YFS NO 2. Does this filing in%olce a single franchise authority but multiple community units? X If yes. enter the associated Ct: Ms helots and compl ete the franchise authOrM rntOrmation at the bottom of this page 3. Does this filing inxohe multiple franchise authorities? Itycs. attach a separate sheet for each franchise authority and include the lulltmin, franchise authorm, information with its associated CUID(s). Franchise AuthoritN Information: Name of Local Franchising :luthont\r SEE ATTACHED Vlailine Address of Local Franchising Authority City State ZIP Code Telephone number Fax Number 4. For ss hat purpose is this Form 1240 being filed? Please put an "X" in the appropriate box. a Orieinal Tom 1240 for Basic Tier X b Amended Form 1240 for Basic Tier c OnRinal Form 1240 for CPS Wier d Amended Form 1240 for CPS Tier TO 06/30!2009 5. Indicate the one year time period for which ? ou are setting rates (the Projected Period). 07/01/2008 TO 6. Indicate the time period for which you are performing a true-up. 12/01/2006 11/30/2007 '. Status of Precious Filing of FCC Form 1240 (enter an "x" in the appropriate box) FS NO a_ Is this the first I'CC Form 1240 filed in any jurisdiction" X b. Has an FCC Form 1240 been tiled previously with the FCCX If yes. enter the date of the most recent filing, (min 'dd) yl NT S No c. I las an FC'C' Fomi 1240 been filed previously with the Franchising Authority" X If yes. enter the date of the most recent filing' 04/01/2007 (mmrddlvv l (mnl yV ) (mm+'yy) Paeel FCC Form 1240 WA•H4863 2K8RW13 xls Microsoft Excel 5,0 Version July 1996 Multiple Franchise Authority Listing Headend #: II4863D Headend Name: AUBURN FCC ID Franchise Authority Information WA0096 LORRIE REMPHER INFORMATION SERVICES DIRECTOR B AUBURN 25 W. MAIN STREET AUBURN, WA 98001 WA0829 CITY ENGINEER AUBURN AUBURN, WA 98001 March/April 1, 2008 Page 1 of 1 Federal Communications Commission Washin _toa DC 20554 8. Status of Previous Filing of FCC Form 1211) (enter an "z" in the appropriate box) Approved by OMB 3060-0685 YFS NO a. I las an FCC Form 1210 been previously tiled with the FCC" X If yes- enter the date otthe most recent filing 0 (marl, ddyyl YES NO b. I las an FCC Form 1210 been previously tiled with the Franchising AuthoritN If yes, enter the date of the most recent filing: 04/05/1995 (mnv'd&N ?') 9. Status of FCC Form 1200 Filing (enter an "x" in the appropriate box) YES NO a. Has an FCC Form 1200 been previously filed mth the FCC', x It N es. enter the date tiled- 0 (mmr dd'? } ) YES NO b_ I las an FCC Form 1200 been previously tiled with the Franchising Authority" X It ycs. enter the date filed. 08/15/1994 (m rt'dd'yy) 10. Cable Programming Services Complaint Status (enter all in the appropriate box) YEs NO a. Is this form being tiled in response to an FCC Form 329 complaint" X If yes, enter the date of the complaint: 0 (ninvdd.'n I YES V'O - 11. Is FCC Form 1205 Being Included \1 ith This Filing ? X E 77771 12. Selection of "Going Forward" Channel Addition Methodology (enter an "x" in the appropriate box) Check here if you are using the orieinal rules MARKI IP METI lOD]. t?Check here if you are urine the new, alternative rules [CAPS METHOD]. If using the CAPS MFTHOD, have you elected to revise recovery for 1'1 S No channels added during the period May 15, 1994 to Dec. 31. 1994'' X 13. Headend Upgrade Methodology '.A0770f?eratorv Iniol -111 t,, dic C wwirr. wn their cligihihrt n. hne rht, apid alga, h '111, gwT,mcni il'/ ?uicl ?I?,?r?,rc?A sir ?ch?cltrld Check here if you are a quahf\ ine small system using the streamlined headend upgrade methodoloey. Part I: Preliminary Information Module A: Maximum Permitted Kate From Previous riling a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 AI Current Maximum Permitted Ratc ) 13 3b4 Module R: Subscribership a b c it e Line Line Description Basic 'tier 2 'Tier 3 Tier 4 Tier 5 BI Aycracc Subscribership For I ruc-t!p Period I 13 503 B? Average Subscribership Fur I tuc-( p Pcriod 133 Fsumatcd Aycraec Subscribcrshi For Projected Period 1 3.7t)o Module C: Inflation Information Line Line Description CI Unclaimed Inflation. Operator Sxcitching From 12101o 1240 1.0000 C_' Unclaimed Inflation Unrc gulated Operator Rcspondinv to Rate Complaint I o000 C, _ Inflation Pastor For I ruc-t p Pcriod I IWks I I ]n 1 0227 o :: C4 Inflation Factor I or t rue-tip Period 2 lWks I I 1 0000 C5 Current FCC Inflation Factor L0103 Page' FCC Form 1240 W'A-1-14863 2K8RWB xis Microsoft Excel 5 0 Version July 1996 Federal Communications Commission Washing4on, DC'05?4 Module U: CalculatinE the Base Rate Approsed by OMB 3060-0685 a b c d e Line Line Description Basic I ier 2 1 ier 3 Tier 4 Tier 5 D1 Current Headend Upgrade Segment I )= Current External Costs Seement a S772 I Current Caps Method Segment D4 Current Markup Method Segment 1119(w D5 Current Channel Mos cment and Deletion Seement 1 1262 I D6 Current 'I'rue-Up Segment 11.367= D7 Current Inflation Seement - G5 0_'178 D8 Base Rate [AI-DI-D'-D3-1)4-f)S-Db-D7I 12.9904 Part 11: True-Up Period Module E: Timing Information Line Line Description E1 Ah'hat I\pe of l ruc-C'p Is Bcing Performed' iAnssscr"I"- '2", or See Instructions fixa description of these tspes i It"1 ", go to Module I. If "2", answer L2 and E3. If "Y', answer E2. E3, E4, and E5, E1 Number of Months in the True-1 lp Period I E3 Number of Months between the end or Frue-l;p Period I and the end of the most recen t Projected Period 7 E4 Number of Months in True-tlp Period _ I:1wible for Interest 0 E5 Number of Months True-Up Period 2 Ineligible for Interest 0 Module F: Maximum Permitted Rate For True-Up Period I a b c d e Line Line Description Basic Tier 2 Tier 3 1 ier 4 Tier 5 F I Caps Method Segment For I rur-F p Period I [Wks 11 F' Markup Method Seement For Truc-t'p Period I [Wks 31 U 1,41 F 3 Chan Msmnt Delete Segment For True-Up Period I [Wks' 4, 51 110181 F4 True-Up Period 1 Rate Flietble For Inflation [D8-F1-F2-F31 1'_0786 F5 Inflation Seement for-True-Up Period 11i F t'C31-F4] 0 2 746 F6 Headend l'pgradc Segment For True-Up Period I [Wks 6] F7 External Costs Segment For I ruc-Up Period I 1 Wks 71 0 9854 F8 True-1;p Segment For Prue-Up Period 1 0 3787 F9 Nlax Perm Rate for I rue-Up Period I [F4-1 5- Fh+ F7- F9I I > 7171 Module G: Maximum Permitted Rate For -True-Up Period 2 a b c d e Line Line Description Basic I ier 2 Pier 3 Tier 4 Tier 5 G I Caps Method Segment For Truc-t'p Period _ ?1 'ks'j G' Markup Method Segment For I ruc-1'p Pcriod 2 1Wks 31 G', Chan S4cmnt Delcin Segment For True-lip Period 2 [Wks' 4 51 G4 It Period' Rate Eligible For Inflation [D8+F5-G I -(i2 • G31 G5 Inflation Seement for I ruc-Up Period 2 [IG4'C4'1-G1 G(i I leadend I pgrade Segment For I ruc-Up Period' IWks 61 67 External Costs Segment For Truc-Up Period 2 [Wks 71 G8 True-t;p Segment For I rue-Up Period 1 G9 Max Pemt Rate for true-U Period _' G4-G5-66-G7,G81 Page', FCC Form 1240 ",'A-H4863 2K8RWB-xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washimu,ton. DC 20554 Module H: True-Up Adjustment Calculation Approved by OMB 3060-0685 a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 Adjustment For True-l ) Period I III Revenue From Period 1 18 X500 H3 Revenue Fran) Max Permitted Rate I'm Period 1 1-12-2,707 898, H3 Trtic-I IP Pcriod I Adjustment [112-H I j 142,420 3517 i H4 Interest on Pcriod I Adjustment 1`.326 5711 Adjustment For Truc-t p Period 2 HS Rcsenuc From Period' laivtble for Interest H6 Rcsenuc From Max Pcnn Rate for Period 2 Eligible For Interest H7 Period 2 Adjustment Idwnblc For Interest 1116-H51 HS Interest on Period 2 Adjustment i See instructions for formula) 119 Revenue From Period 2 Ineligible for Interest 1110 Revenue From Max Perni Rate for Period ' Incliviblc for Interest fill Period 2 Adjustment Ineligible For Interest [Hl0-H91 Total Truc Up Adjusunent 1112 Pre) ious Remaining I iue-t jp Ad ustment III', Total Truc-t Ip Adjustment 1113 114 • 117 ? 118. 111 1 111'-(iSJ 07.7469--Si 1114 Amount of 'True-1:p Claimed For This Protected Period 0T746 9228) HIS Remamirw Frue-tlpAdjustment [H13-If 141 Part III: Projected Period Module 1: New Maximum Permitted Rate a b c d e Line Line Description Basic -1 ier 2 Tier 3 bier 4 1 ier 5 11 Caps Method Segment For Projected Period [Wks ,] - I? Markup Method Scvrncnt For Projected Period Wks U I91 _j.i 13 Chan Ms mm Dclcm Segment For Projected Period [Wks 451 11 1341) 14 Proj Period Rate EGvjble For Inflation [D9-FS-G5-11-1'_-131 12 3209 IS Inflation Scgmcnt for Projcctcd Period It14'C51.141 0 1369 16 l leadend Upgrade Segment For Projected Period [Wks 6] 17 F\ternal Costs Segment For Projected Period [Wks 7] 1 0800 19 True-Up Segment For Projcctcd Period i 0 2891-) 19 Max Permitted Rate for Projected Period [14-15-16-17-181 13 2386 110 () •rator Selected Rate For Projected Period S 14 40 \'utr: l h nucvnnnn 1Ionia rd run' Jrgurc.s do nut take Into accuurtt unr'relund lluhilni t'uu mar hare- 11fou lwrr previous r been ordered hr the ('ommicclun or your luca/ Iranclutrrrg uuthorrtt' to nutke refunds', t ou ore nor relieved of ('our obligation !n make such rc'lunds even r1 the Oermined rule a higher than the conre.sted rate or your current rate. Certification Statement \>ILLFI11 _ FALSE SFATFNIFN fS MADE ON THIS FORM ARE PUNISHABLE BY FINE AND+'OR IMPRISONSILN 1 (U S CODF -1 ITI 1 18, sCTION 1001). ANDr'OR FORFFITt'RE (U.S_ CODF. -1 ITLE- 47, SFC IION 503). 1 ccruhv-thatihe state utcnti made in.this flmn are true and correct to the best of mx knotxiedee and belief', and are made in good faith. Senior Page-1 FCC Form 1240 WA-H4863 2K8RWB xis Microsoft Excel 5.0 Version Jule 1996 Federal Communications Commission Washington. DC 20554 Worksheet I - True-Up Period Inflation For instructions, see Appendix ,1 Of Instructions For FCC Form 1 2-lei line Period FCC Inflation Factor 101 Month I 167"11 102 Month 2 4 1740 103 Month 3 4 1746 104 Month 4 4 17"h 105 Month 2 6540 106 %lonth 6 2 6516 107 Month 7 2 651,11 108 Month 8 103^„ 109 Month 9 1.031111 110 Month It! 1.034„ 1 11 Month I I 1 113°0 1 12 Month i 2 1 034.0 3 11 A%Crzw ! Inflation I actor for True-t'p Period I I 0227 114 Month 13 11 Month 14 1 I6 Month I5 I 1 Month 16 1 18 Month 17 1 1 U Month 18 12n Month 19 121 Month 20 1 22 Month 21 123 Month 22 124 Month 23 123 Month 24 126 ANeraae Inflation Factor for True-('p Period 1 ii00t! Approved By OMB 3060-0685 Page I FCC Form 1240 WA-114863 2K8R%VB xls Microsoft Excel 5 0 Version Jule 1996 Federal Communications Commission Washington, DC 20554 Worksheet 3 - Markup Method True-Up Period, Basic Tier For instructions, see Appendix A of Instructions For FCC Form 1241) Question I Indicate the period for which this worksheet is being used (Put an " X' in the appropriate box.) Question 2 Indicate the tier for which this worksheet is being used (Put an "V in the appropriate hox 1 Approved By OMB 3060-0685 Iruc-t'p Pcnod Prmcc!ed Period X Basic Tice 2 Tier 3 1 ter 1 Tier 5 X Question 3 How long is the first period, in months, tier %vhich rates arc hcuag set with this worksheet' 12 Question 4 I low lone is the second period. an months, Im which rates arc hcing set wth this worksheet" O ine Period Presious Month _ Month 1 1 2 3 4 > 6 7 Sum of Pres ious Sum of Current arerage Per Channel Channels Tolal umulativc Regulated Regulated Channels Adjustment Added Adjustment Adjustment Channels Channel 900 U. 1 31 34 76 0.0100 0.191111 Month 2 34 + 76 0.11111(1 0.191111 ?C Month 3 33 >> 75 0.0100 0.191111 - Month 4 33 33 75 0.0100 0.19011 Month 5 33 33 74 0.0101) 0 .1900 Month 6 33 3 3 74 0.0100 0.19(1(1 S Month 7 33 74 0.0100 - 0.1900 Month 8 33 33 74 0.0100 0.1900 I i Month 1) 33 33 74 0.111110 0.1900 11 Month 10 33 33 74 0.0100 11.19110 313 Month 11 33 74 0.01011 11.19011 I i Month 12 3 Average Period 1 Markup Method Adjustment 74 0.011111 11.19011 0.1900 31 Month 13 I6 Month 14 t ? Month 15 I1+ Month 16 '19 v Month 17 Month 18 -1 Month 19 Month 20 Month 21 Month 22 Month 23 26 Month 24 Average Period 2 Gaps Method Adjustment Page I FCC Form 1240 OVA-H4863 2K8R\1'l3 \1s Microsoft Excel 5 0 Version July 1996 Federal Communications Commission Washington. DC 20554 Worksheet 3 - Markup Method Projected Period, Basic Tier For instructions. see Appendix A of Instructions For FCC Form 1240 Question I Indicate the period for %Oich this scorksheet is being used (Put an ' V in the appropriate box ) Qnesuon i Indicate the tier for shish till, ssork,heet ,s heing rued i I'ut an " k' in the appropriate box ) Approved By OMB 3060-0685 Irue-t'p Period Projected Period Bcuic Ilei 2 tier 3 Iler 4 ller 5 Question I Io\\ on_ is the first period. in months, for \shich rates are bein set ssith this sumk,heet' 12 Question 1 I loss long is the second period. in months- for nhieh rate, are helm, ,et tsith this ssurkshect" Ala 1 2 3 4 5 6 Sum of Precious Sum of Current A%erage Per Channel Channels Total Cumulative Line Period Regulated Regulated Channels Adjustment Added Adjustment Adjustment Channels Channel NO]O , 11,1900 M„mil _ ntomn I 33 '3 74 0.0100 o.1900 ;G Month 2 >> 3 : 74 0.0100 0.1900 Month 3 33 3> 74 0.0100 0.1900 ;t!5 Month 4 33 74 0.0100 0.1900 Month 5 33 33 74 0.0100 0.1900 Month 6 33 33 74 0.0100 0.1900 ?i!8 Month ' 33 74 11.011111 0.1900 Month 8 33 33 74 11.011111 11.19011 ;I ; titomh9 33 3> 74 0.0100 0.1900 Month 10 33 74 0.01011 0.1900 ? 12Month 1 1 33 33 74 0.0100 - 0.1900 ! 3 Mond, 13 74 0.0100 0.1900 Average Period I )larkup Method .-adjustment 0.1900 Page I FCC Form 1240 WA-H4863 2K8RWB \Is Microsoll Excel 5 A Version July 1996 Federal Communications Commission Washington. DC 20554 TABLE A. NON-FX-1 ERNAI.C'OSI ADJI'STMENTFOR CfIANGFS IN tl1ANNI I S A%erage Channel, From Fo Adjusunent per channel 7 7 So S2 7 5 7 i So 45 8 8 S040 85 85 5036 9 9 S033 95 95 $029 10 10 50.27 10 > 105 S024 Il 11 S022 11 5 115 $020 12 12 5019 125 125 5017 13 13 So 16 135 SO 15 14 14 S0 14 145 145 5013 15 155 5012 16 16 so I I 16 17 SO 10 ?5 I8 5009 S 5 I') SO.08 1') 5 21 5 S007 22 23 $0 06 24 26 S005 26,5 29S S004 30 35 5 S1! 03 36 46 $? 1 !!2 46 5 yy 50 01 Approved By ONIB 3060-0685 Page 2 FCC Form 1240 W'A-H4863 2K8RWI3 x1s h4icrosott Excel 5.0 Version July 1996 Federal Communications Commission Washington. DC 20554 Worksheet 4 - Residual True-Up Period Approved By OMB 3060-0685 For instructions, see Appendix A of Instructions For FCC Form 1240 Question I Indicate the period for which this worksheet is being used (Pin an °V in the appropriate bos-i lrue-t:p Pe[IOd Projected Period a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 1 icr 5 Period One 401 Avenge Permitted Char,.e 13.9792 4!)'_ Avcraee External Costs 0.9854 4)3 Average Total Per Channel Adjusnnents titter 5 14f94 for Channels Added lasing Caps Method - 404 Average Tier Residual 1401-402-403] 12.9938 405 Average Channels per Regulated Tier 33 5000 406 .Average Craps Method Channels per I ier - 407 Average Remainme Channels 1405-4061 33.5000 VIS Average Period I Per Channel Residual [41144071 0.3879 No 4119 Averaee Permitted Chawc -110 Average Fsternal Costs 111 Average Total Per Channel Adjustments after 5i 14 94 for Channels Added Using Caps Method 412 Average Tier Residual [409-410-4111 413 Average Channels per Regulated Tier 114 Average Caps Method Channels per I ier 415 Average Rcmainutg Channels 141 3-4141 416 Ascrage Period 2 Per Channel Residual [41'_!-315] Page I FCC Form 1240 WA-114863 7K8RWB \Is Microsoft Excel 5.0 Version Jul}' 1996 Federal Communications Commission Washington. DC 20554 Worksheet 4 - Residual Projected Period Question I Indicate the period for which this worksheet is being used iPut an "X' in the appropriate box l Approved By OMB 3060-0685 True-Up Penod Prvieeted Period III b c d e Line Line Description Basic Tier 2 Tier 3 'tier 4 Tier 5 101 Average Permitted Charge 13.5264 4112 Average External Costs 0.8772 4o3 Average Total Per Channel Adjustments after +11!91 lot Channels Added Using Caps Method - 4114 Average Tier Residual 1401-402-4031 12.6192 105 Average Channels per Regulated Tier 34 0000 406 Average Caps Method Channels per'ller - 407 Average Remaining Channels [405-306] 34.0000 1i)8 Average Period 1 Per Channel Residual [404+407] 0.3720 Page 2 FCC Form 1240 \\`A-H4863 2K8RWB xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washington, DC 20554 Worksheet 5 - Channel Movement and Deletion True-Up Period, Basic Tier Approved B} OMB 3060-0685 For instructions, see Appendix A otlnstructions For FCC Fonn 1240 Question 1 Indicate the period for which this worksheet is being used (Put an "X" in the appropriate box.) True-lip 1'enod Projected Period Question 2 Indicate the tier for which this worksheet is beine used 1 Put an "X" in the Question > llo\? long is the first period, in months. for %Onch rates are being set %+ th this %wikshcet') 12 Question 4 13o%s lone ,s the second period. in months. Ior which rates are hcme set with this ?%orksheet" 0 Line Period i 1: Prey IOUs Period 502 Month 1 1 2 3 4 Residual of Channels Deleted Residual of ( hannels MOVed Net Per-Channel Cost Cumulative Net Per- ?djusunrnt 1('oltnnn _ - I r n r, I irr nl,lrtl i iI i, , Channel Cost Adjustment t lunn, I'i (0..162) (0.7162) 5i 33 Month 2 03879 (0.3879) (1.1341) 5o4 Month 3 11.1341) 5;O5 Month 4 (1.1311) 506 Month 5 (1.1341) 507 Month 6 (1.1311) 508 Month 7 (1.1311) 509 Month 8 (1.1311) 510 Month 9 (1.1311) 511 Month Ili - (1.1311) 513 Month I l (1.1341) 513 Month 12 ,514 Average Period I Channel Mosement and Deletion Adjustment (1.1311) (1.1018) 515 Month I 516 Month iJ 517 Month I > 518 Month 16 519 Month 17 _ 520 Month 18 521 Month 19 522 Month 20 523 Month 21 524 Month 22 525 Month 23 5?6 Month 21 - _ Aserage Period 2 Channel Nimement and Deletion Adjustment Page I FCC Form 1240 WA-H4863_2K8R\k'B xls Microsoft Excel 5.0 Version Julv 1996 Federal Communications Commission Washm2ton, DC 20554 Worksheet 5 - Channel Movement and Deletion Projected Period, Basic Tier Approved By OMB 3060-0685 for instructium, x•C Appendix ;A of lnyMIC lons For FCC FOrm 1 _'4(1 Question 1 Indicate the period for xchich this \%orkshect is being used (Put an 'V in the appropriate box ) Frue-Up Period Projected Period X Question 2 Indicate the tier for %shich this ?wrksheet is being, used (Put an "X" in the appropriate box l Basic Fier 2 bier 3 Tier 4 Tier X t icstion 3 How long is the tint period, in months. for which rates are being set with this worksheet' 12 Ouestion 4 Hors long is the second period, in months, for which rates arc being set ssnh this %wrkshect' ??:? 1 2 3 4 Net Per-Channel Cost Cumulatire Net Per-Channel Re.idual nt ('hanncls Deleted Residual of Channels Mmed Line Period \djusuncnl ?C?ilunni 2 l i iiu I ici f ad?lr?l i to I icr Cost Adjustment I nunin I iO1 Prcvrous Period (1.1341) !_' Month 1 - - - (1.1341) i03 Month 2 (1.1341) 50 3 Month 3 (1.1341) s03 Month 4 (1.1341) st?6 Month (1.1341) i07 Month 6 (1.1341) ios Month 7 (1.1341) s(ie Month 8 (1.1341) ii' Month9 (1.1341) I Month 10 (1.1341) si' Month 11 (1.1331) si> Month 1' (1.1331) V14 A%eragge Period I Channel \lo?ement and Deletion Adjustment (1.1341) Page I FCC Form 1240 WA-H4863 2K8RWB x1s Microsoft Excel 5 0 Version July 1996 Federal Communications Commission ?kashin;_ton. DC 20'?54 Worksheet 7 - External Costs True-Up Period For instructions, see Appendix A of Instructions For FCC Form 1240 Question I. For which time period are you tilling out this oorksheet" (Put an "X' in the appropriate box I Question 2. How lone is the first period, in months, for which rates are being set with this worksheet? Question 3 Hoss lone is the second period, in months. for which rates are hemg set \\ith this worksheet' Approved Fay OMB 3060-0685 Truc-Up Pcriod Projected Period 12 0 a b c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 Period 1 External Costs Eligible for Markup Cost of Proirammine For Channels Added Prior 701 to 5. I Sr9.1 or After 5!15-94 Using Markup Method For Period I 11,89,; 7324 ,112 Retransmission Consent Fees For Period - 7i 3 C'opynght Fees For Period 20.757 3210 704 External Costs Hligible For 7 Markup 132.653 05 64 705 Marked Vp I sternal Costs 142.602 03,6 External Costs Not Eligible for Markup 7i?n Cable Specitic faxes Por Period 707 Franchise Related Costs For Period 708 Commission Regulatory Fees For Period 17,069 5300 709 Fotal External Costs For Period 1,9.671 ,656 ?fontlik. Per-Subscriber I\temal Costs For 710 Period I 0.9851 Period 2 External Costs Eligible for Markup Cost of Proramntme For Channels Added Prior 711 to 5 1 5191 or alter 5 i 5 9 3 t: snie Markrip Meth Od For Period 712 Retransmission Consent Fees For Period 713 Copyright Fees For Period 714 External Costs Eligible For 7 5°» Markup 71, Marked UP External Costs External Costs Not Eligible for Markup 716 Cahle Specific'Faxes For Period 717 Franchise Related Costs For Period 718 Commission Regulatory Fees For Period 719 Total Fxternal Costs For Period %lonthh. Per-Subscriber I vernal Costs For Period Page 1 FCC Form 1240 "'A-H4863 2KBRWB xls Microsoft Fxcel 5 0 Version July 1996 Federal Communications Commission Washington, DC 20554 Worksheet 7 - External Costs Projected Period For instructions, see Appendix A of Instructions For FCC Form 1240 Question I For which time period are cou tilling out this worksheet' [Put an "\' in the appropriate box I Question 2 Flow long is the first period, in months. for which rates are being set ?sith this worksheet` Question 3 Hogs lone is the second period. in months. for which rates are being set with this worksheet') Approved B} OMB 3060-0685 True-1. p Period Projected Period 12 a h c d e Line Line Description Basic Tier 2 Tier 3 Tier 4 Tier 5 Period 1 External Costs Eligible for ]Markup Cost of ProarammmL, For Channels Added Prior 7111 to 1594 or After 5!15'94 Using Markup `lelhod For Penod 129.13> 6i94 71)2 Retransmission Consent Fees For Period - 70± Copyright Fees- For Period 21.151 1034 External Costs Flieible For 7 Markup 150.286.7628 Marked I. p F%tcrnal Cosis 161.558.2700 External Costs Not Eligible for Markup 71 Cable Specific faxes For Period - Franchise Related Costs For Period 708 Commission Regulatory Fees For Period 16,768 5ii(')ti 709 Total F.xtemal Costs For Period 178,326.7700 710 Monthh. Pcr-Subscriber I'xlernal Costs For Period I 1,0800 Pace 2 FCC Form 1240 NN A-11486.1 2KSRW B xls Microsoft Excel 5.0 Version July 1996 Federal Communications Commission Washington. DC 20554 Worksheet 8 - True-Up Rate Charged Foi histnictians. see Appendix A of Instructions For FCC Form 1240 Question I How long is the True-Up Period 1, in months" Quesuor. I km lone is the True-Up Period 2. in months" Approved 13% OM13 3060-0685 12 0 a h c d e Line Line Description Basic Tier 2 Tier 3 'tier 4 Tier 5 801 Month 1 $ 14 3000 802 Month 2 14. 3000 803 Month 3 $ 14 3000 804 Month 4 $ 11.3000 805 Month $ 14 3000 806 Month 6 $ 14 3000 807 Month 7 $ 14 3000 SOS Month 8 $ 13.5300 8111) Month ; 13 5300 S!' Month P 5 13 5;3oO I Month I I S 13 5300 kit Month 1' S 13 5300 81 3 Period I :??Ciase Rate $ 13 9792 814 Month I i $ - S ! s Month 14 8:6 Month I5 $ S. _ Month 16 $ 818 Month 17 $ 81,) Month 18 e'ii Month 19 $ S21 Month 20 $ S22 Month 21 A e'3 Month 22 $ S'4 Month 23 $ S25 Month 24 $ - S'b Period 2 A%ewe Rate $ Patel FCC Form 1240 WA-H4863 2K8RW13 xls Microsoft Excel 5 0 Version 1uk 1996 ?n a l l N a __. N?.+N?? ? r OD ll?. ?.O?Ip... ?.?? IONVI NINYN O • ..N PSI T N A L.i+j,.LNNNL?Y• Z v 0 0 z N I Q? pW?Ol O1?000O1 E~oJJ01.OW{I?V1 10tlNiN MOO;.W yW AuUuu,, t.uu:, h, IV Lukiliiy, tejual Yday, Covington, Maple Vaney.._.-------- S 14.30 Sea Tac, Black Diamond, Enumclaw, Normandy Parl? Algona, Pacific _ . 5 14.b0 Buried 14.01 Carnation, Fall City 15.27 Des Moines 12.60 isssquah, islands 1110 Kent, Tukwia..»._....._.....,.....,. 14.64 Renton 12.48 Renton (Sammamish)_. _ . s 13.15 Snoqualmie, North Bend» 15.49 Unincorporated Kmg County • Lee Hits 14.05 Newcastle," County (Issaquah) 12.60 King County, South Cove 13.15 Equipmen t & Options EgeO--W paces p--0. Remote Control (al types) .»..».»__ Umbd Cable Customer Equipment' _ i 1.00 Standard Digital Set Tap ReceW » » _ ... _ » s 3.50 Advanced HD Digital Set Tap ReceW »_»» »»»» i 8.00 2nd CAKARD for Muftgb CableCARD Devke_ S 1.79 Channel Guide Magazine.... 3.45 'QWoren WO stbsabe b Ur ted Cade ixi L 1 In certain czar ba charge vA vW be disaarad or nrabr d. Home Instalation (Wired).».-....w.... ».? _» s 23.99 Hare insta9atm {lJmrired) 33.99 Digital Sd4iStallaibn Kit (Wdb Shipping) s 2.95 0194al S9044ta WM 10A (W'dVA Shipping) » FREE Additional Connection at Time of Initial Instal 12.99 AddNonai Connection Requiring Separate Trip $ 20.99 Move an Outlet » 16.99 Hazy Service Charge 30.99 Upgrade or Downgrade of *o al U vices (Addressable) _ » » _ s 1.99 Upgrade of Optional Services Requiring Separate Trip..... » i 14.99 Downgrade of Optional Services Requiring Separate 12.99 Connect VCR at Tana of Inhial Instal 5.99 Connect VCR Requiring Separate Trip 13.99 Reconnecioo of Seryice » ._ _ » S 27.99 Service CAN 19.99 Reactivate Video 1.99 Miscellaneous Nu,l-Suflidelit f unds Ukuge ..__...._...... _........... _._. ...._ ..- ....__.s 25.00 Field Service Charge 15.00 Late Payment Charge 5.00 Purchase AM Switch ........ 10.00 Utreturned Standard Set-Tap Rettiver....- » s 54.00 Unreturned Digital Set-Top Recehw (Model 700) .. _ _ s 96.00 Unretumed Digital Set-Top Receiver (Model 2000) 167.0 Unrebrmed Digital Set-Top Receiver (Model 2500) _..._..._ »? _s 167.00 Urretumed NO Digital Set-Top Receiver (Model 5100) 336.00 Unn turned HO Digital Set Top Receiver (Model 6200) 320.00 tkreturned HDiDVR Digital Set-Top Receiver (Model 3412) 410.00 Unreturned W/DVR Digital Set-Tap Receiver (Model 3416) 410.00 Unretumed HD 1DVR Digital Set-Top Receiver (Model 6412) 465.00 Unreturned Uldversaf 6.40 Unretumed Digital Video Recorder Remote 6.65 Unreturned DCT Power Cad 1.15 Uhretumed Wireless Phone Jack (Per Piece) 23.00 Unretumed CabIaCARO. »_ » » » _ .m 5 90.00 aRSiL 1q-3o FAm la3 1 l y , 30 A,ti-Y -A)oJ `v7 1q, 3o x.77 } ATTACHMENT 2B Attachment 3A 1.N1-11 PRO.1 LNI-PRO.1 CLS:4863 -%7. FEDERAL WAY Channel Information Dcc-2006 T C11 Jan-2007 I CA I Noy-2007 I CI I Jul-2008 I' CH Jun-2009 I CH N\\ CN B 2 B 2 B 2 B 2 B 2 K\\PX B ? 11 3 B 3 B 11 B 1 KO!v90 B 4 B 4 B 4 B 4 B 4 KING 13 5 B 5 B 5 B 5 B 5 KONG B 6 13 6 B 6 B 6 B 6 KIRO B B B 7 B B DSC-\\ B 8 B 8 13 8 B 8 B 8 KCTS B 9 B 9 B 9 B 9 B 9 KI Wil B 10 13 10 13 10 B 10 B 10 KST W B 1 I B 1 1 B 1 1 B 1 I B 11 KBTC 13 12 B 12 B 12 B 12 B 12 KC-PQ 13 13 B 13 B 13 B 13 B 13 KBCB B 14 B 14 B 14 B 14 B 14 KIICV B 15 B 15 B 15 B 15 13 15 QvC B 16 B 16 B 16 B 16 13 16 I.F.INSFACC BS 17 BS 17 BS 17 BS 17 BS 17 11SN BS 17 BS 17 BS 17 BS 17 13S 17 K\\ DK B 18 B 18 13 18 B 18 B 18 11 \1.IAIARK-W B 19 B 19 13 19 13 19 B 19 K I I3W B 20 B 20 B 20 B 20 B 20 GOVTACC B 21 B 21 B 21 B 21 B 21 GO?'TACC B 22 1; 22 B 22 B 22 B 22 IVW B 2: B 23, B 23 B 23 B 13 CSPAN B 24 13 24 B 24 B 24 B 24 C'SPAN2 B 25 B 25 B 25 13 25 13 25 F,DACC Q 26 B 26 13 2(i 13 26 B 26 U\\'l V l3 27 B 27 13 27 B 27 B 27 FDACC B 28 13 18 13 28 13 28 B 28 KU NS B 29 13 29 B 29 B 29 B 29 KCTS+ B 75 B 75 B 75 B 75 13 75 UWTV2 13 76 B 76 B 76 B 76 B 70 PUBACC 13 77 B 77 B 77 B 77 B 77 T\\ C B 78 B 78 B 78 13 78 B 78 UNIVIS-W B 98 CQ[ ` I B 99 B 99 13 99 13 99 B 99 WA-H4863 2h8RW'B xls Attachment 3A Attachment 3B FCC FORM 1240 - 2008 Hcadend: 114863D I leadend Name KING COLN I Y_ SEAL ILE_L1MU Channel Line-Up Reconciliation Basic Numhcr of Channels. Beginning of True-Up Period ( From Attachment 3 ) 14 Changes During True-Up Period (1) Number of Channels. End of True-Up Period 1 33 Number of Channels. Beginning of'fntc-Up Period 2 (From Attachment 3) 33 Changes During 'frue-Up Period 2 - Number of Channels. End of Truc-Up Period 2 > 3 Number of Channels. Beginning of Projected Period '33 Changes During Projected Period Number of Channels. End of Projected Period 33 Summary of Channel Changes Channel Number Call Sign Channel Name Tier Date Date Added Deleted Period 98 l'NIVfS-?? UNIVIS-W B OL01'2U0? 1U WA-H486. 2K8RWB.xIs Attachment 3B Attachment 4 FCC FORM 1240 - 2008 I leadend: 114863D I Ieadend Name: KING COUNTY,` SEATTLE IAMLI Basic Basic Basic Programming Programming Wonth Period Customers F ffective Rate Cost Dcc-2006 T-up 1 13,399 0.6755 9.051.0245 Jan-2007 F-up 1 13,346 0.6919 9,234.0974 Feb-2007 T-up 1 13,387 0.6919 9.262.4653 Mar-2007 T-up 1 13.510 0.6919 9,347.5690 Apr-2007 T-up 1 13,528 0.6919 9,360.0232 May-2007 T-up I 13,593 0.6919 9,404.9967 Jun-2007 T-up 1 13,570 0.6919 9389.0830 Jul-2007 T-up 1 13,483 0.6919 9,328.8877 Aug-2007 T-up 1 13,472 0.6919 9,321.2768 Sep-2007 T-up 1 13,602 0.6919 9,411.2238 Oct-2007 T-up 1 13,578 0.6919 9,394.6182 Nov-2007 T-up 1 13,572 0.6919 9,390.4668 Jul-2008 Proj 13,677 0.7821 10,696.7817 Aug-2008 Proj 13,692 0.7821 10,708.5132 Sep-2008 Proj 13,707 0.7821 10,720.2447 Oct-2008 Proj 13,722 0.7821 10,731.9762 Nov-2008 Proj 13,737 0.7821 10,743.7077 Dec-2008 Proj 13,752 0.7821 10,755.4392 Jan-2009 Proj 13,767 0.7821 10,767.1707 Feb-2009 Proj 13,782 0.7821 10,778.9022 Mar-2009 Proj 13,797 0.7821 10,790.6337 Apr-2009 Proj 13,812 0.7821 10,802.3652 May-2009 Proj 13,827 0.7821 10,814.0967 Jun-2009 Proj 13,842 0.7821 10,825.8282 Basic Copyright Effective Basic CBRyright FCC User Fee FCC User Fee Rate cost 1: f f ectnve Rate Cost 0.1281 1,716.4119 0.1281 1,709. 6226 0.1281 1,714. 8747 0.1281 1,730. 6310 0.1281 1,732. 9368 0.1281 1,741. 2633 0.1281 1,738. 3170 0.1281 1,727. 1723 0.1281 1,725. 7632 0.1281 1,742. 4162 0.1281 1,739. 3418 0.1281 1,738. 5732 0.1281 1,752. 0237 0.1281 1.753. 9452 0.1281 1,755. 8667 0.1281 1,757. 7882 0.1281 1,759. 7097 0.1281 1,761. 6312 0.1281 1,763. 5527 0.1281 1,765. 4742 0.1281 1,767. 3957 0.1281 1,769. 3172 0.1281 1,771. 2387 0.1281 1,773. 1602 Total Programming Costs (Worksheet 7, Line 701) Basic Programming Cost True Up Period 1: 111.895.7324 True Up Period 2: - Projected Period: 129.135.6594 Basic Copyright 20,757.3240 21,151.1034 I Jser Fees WA-113863 2K8RN'B_sis Attachmcnt4 COMCAST CABLE COMMUNICATIONS, LLC. FCC FORM 1240 PREPARATION DOCUMENTATION 2008 ANNUAL FILING This memo will serve to document, in general terms, the approach and assumptions used in preparing the 2008 annual filing of FCC Form 1240 for systems owned and/or managed by Comeast Cable Communications, LLC. Where an FCC Order or Public Notice applies, it is referenced by number. Questions about the mathematical calculations and formulas used in the Form 1240 and the Worksheets can be referenced in the "Instructions for FCC Form 1240." MODULE A - MAXIMUM PERMITTED RATE FROM PREVIOUS FILING Line A 1 The current maximum permitted rate equals the maximum permitted rate from the prior Form 1240, Line 19. MODULE B: SUBSCRIBERSHIP Line B1/B2 The average subscribership for True-Up Period 1 is calculated by taking the average of the actual subscribers for each month of the True-Up Period indicated in Question 6 of FCC Form 1240. For systems with greater than 12 months of actual subscribers, Line B2 will also be completed using the same approach. Line 133 The estimated average subscribership for the Projected Period is calculated using historical subscriber growth for the most recent 12 months ending as of the last month of the True-Up Period'. The historical growth percentage is then applied to the last month of actual subscribers to project subscribers through the end of the Projected Period indicated in Question 5 of FCC Form 1240. The Projected Period subscriber calculation may be adjusted in areas where seasonal fluctuations in subscribers are prevalent. MODULE C: INFLATION INFORMATION Line C3/C4 The inflation factor for the True-Up Period is calculated using the Gross National Product Price Index. The individual factors used for each month of the True-Up Period reflect the quarterly factors released by the FCC summarized as follows: uarter Months Covered Inflation 3Q06 Jul-06 - Sep-06 1.89% (FCC DA 06-2449) 4Q06 Oct-06 - Dec-06 1.67% (FCC DA 07-1570) 1Q07 Jan-07 - Mar-07 4.17% (FCC DA 07-3250) 2Q07 Apr-07 - Jun-07 2.65% (FCC DA 07-4153) 3Q07 Jul-07 - Sep-07 1.03% (FCC DA 08-65) ' For recently acquired systems, the subscriber growth percentage is calculated using historical subscriber growth for the most recent period of actual data available. 2008-1240 (4/1/2008) MODULE C: INFLATION INFORMATION (continued) The appropriate inflation factor is entered on Worksheet 1 for each month of the True- Up Period and divided by twelve. The number 1.0 is then added to the result and entered on Line 113 of Worksheet 1. For systems with a True-Up Period 2 (greater than 12 months of actual data), Line C4 will also be completed using the same approach. MODULE G: MPR FOR TRUE-UP PERIOD 2 Module G is used to calculate the Maximum Permitted Rate (MPR) for 'T'rue-Up Period 2. True-Up Period 2 will be completed when there are more than 12 months of actual data to be trued-up. Worksheets used to calculate the numbers used in Module G are attached to the Form 1240 as applicable. WORKSHEET 7 - EXTERNAL COSTS Line 707 Franchise related costs included on Line 707 are taken from Attachment 5, "Franchise Related Costs." The attachment provides information on how the franchise-related costs are calculated for each period, e.g., the type of cost being passed through and the number of months of recovery. WORKSHEET 8 - TRUE-UP RATE CHARGED Line 813 The True-Up Rate Charged reflects the actual rate charged included in the FCC Form 1240 calculation of the maximum permitted rate.* Franchises with rate ordered rates on Line A l will have a corresponding reduction in the applicable Module D segment(s). For franchises that have paid refunds pursuant to a rate order, Line A I and Module D will match the rate ordered rates and the Worksheet 8 rate will match the rate ordered rate for the applicable months. Additionally, for franchises with FCC Form 1235, rates on Worksheet 8 will match Line A I per FCC Order DA 99-1779. 2008-1240 (4/1/2008)