Parameter and revenue inputs to CLEC model
	Vintage Groups:																																																														Q1																												Q2																										Q3																					Q4																			Q5																		Q6																		Q7																						Q8																				Q9																	Q10																		Q11												Q12
Large colos opened/Q, per region																																																																																					2																												2																					2																			2																			2																	1																						1																				1																0																					0												0
Small colos opened/Q, per region																																																																																					0																												1																					1																			2																			2																	2																						1																				0																0																					1												0
New regions opened, by quarter																																																																																					1																												0																					0																			0																			1																	0																						0																				0																1																					0												0
Cumulative regions in service																																																																																					1																												1																					1																			1																			2																	2																						2																				2																3																					3												3
																																																																end-state:
Two methods are available for specifying the takeup of loop-based offerings in large and small collocations
Select method 1 or 2:																																																																																				2
Method 1:  Percentages																																																																																											This method computes lines as percentages of given total office sizes
				(inactive)																																																											Per region:
avg loops per large office:																																																																																900											at stasis

avg loops per small office:																																																																																250
Business user % of total loops																																																																															55%												residential:																																						45%
Prices: (inflators applied later)																																																																		Price/MO																																NRC																					TakeRate																			Shared%																			per LgColo																		perSmColo																																																																																			% of res:												% of bus:
Residential POTS only																																																																$                           35																												$                         50																																					30%																						0%															121.5																	33.75																															% of loops with POTS:																																																72.8%												70.0%													75.0%
Residential DSL only																																																																$                           42																												$                         50																																					30%																				90%																	121.5																	33.75																																			% of loops with DSL:																																												59.0%
Residential POTS + DSL																																																																$                           65																												$                         50																																					40%																						0%																		162																			45
							add to 100% of resi loops:																																																																																																																						100%																			27.0%																							405												112.5
Business POTS only																																																																$                           50																												$                      100																																					50%																						0%															247.5																	68.75																																				% of DSL loops bus:																																											46.6%
Business DSL only																																																																$                           65																												$                      100																																					25%																				50%															123.75															34.375																																								% of DSL loops resi:																																											53.4%
Business POTS + DSL																																																																$                        100																												$                      100																																					25%																						0%													123.75															34.375																																											Avg DSL data rate:																																									20.39
																																						add to 100% of business single loops, not T1s:																																																																									100%																			12.5%																							495												137.5																																																	DSL users/DS1																																			75.33
			computed for Method 1:																																																																																										Percent of total loops shared:																																																			19.0%

ARPU for loop services																																																																$                     58.53																												$                   77.50
Residential ARPU																																																																$                     49.10																												$                   50.00
Business loop ARPU																																																																$                     66.25																												$                100.00
Method 2: Absolute quantities																																																																																											This method computes percentages based on given sales of each loop-based offering
		Active																																																																				Per LgColo																					PerSmColo																			Shared %																		LTotMRC																		LTotNRC																						STotMRC																				STotNRC
Residential POTS only																																																																$                           35																												$                         50																																						120																						35																		0%														4200																				6000																					1225																		1750								% of loops with POTS:																																				72.7%
Residential DSL only																																																																$                           42																												$                         50																																						120																						35																90%																5040																				6000																					1470																		1750																												% of res:												% of bus:
Residential POTS + DSL																																																																$                           65																												$                         50																																						160																						45																		0%											10400																							8000																					2925																		2250																															69.9%													74.9%
																																		Res total:																																																																																												400																				115																															19640																					20000																							5620																		5750												% of loops with DSL:																																59.1%
																																																																250																						65																		0%											12500																					25000																							3250																		6500											Total res lines in plan:																																19395
								Costs												Param																																			SmColos																			LgColos																										Wrapup
Business DSL only																																																																$                           65																												$                      100																																						125																						35																50%																8125																		12500																							2275																		3500										Total bus lines in plan:																																	23988

Business POTS + DSL																																																																$                        100																												$                      100																																						125																						36																		0%											12500																					12500																							3600																		3600																		Total lines in plan:																									43383
																																		Bus total:																																																																																												500																				136																															33125																					50000																							9125																13600															% of DSL loops bus:																															47.1%
																																																																Total																							900																				251																															52765																					70000																						14745																	19350															% of DSL loops resi:																															52.9%
																																																																Colos in plan:																																				39																				33																																																																			Avg DSL data rate:																													20.49
																																																																Total lines in colo:																																		35100																								8283																														2057835																					2730000																							486585																		638550																									DSL Users/DS1																								74.98
																																																																% of lines by CO size:																																									80.9%																				19.1%																																																																											Total lines with DSL:																														25653
			computed for Method 2:																																																																																													shared loops:																															6650																				1617																		19.1%																																																																								% of total loops res
ARPU for loop services																																																																$                     58.65																												$                   77.65
Residential ARPU																																																																$                     49.05																												$                   50.00
Business ARPU																																																																$                     66.41																												$                100.00
% of loops with POTS:																																																																											72.7%																																														% of res:																							69.9%																% of bus:																						74.9%
% of loops with DSL:																																																																											59.1%

Average number of data users/DS1																																																																													75.0
Percent of total loops shared:																																																																											19.1%
Loops per large collocation																																																																														900
Loops per small collocation																																																																														251
% of total lines residential																																																																											44.7%
% of total lines business																																																																											55.3%
			Using selected method:
ARPU for loop services																																																																$                     58.65																												$                   77.65
Residential ARPU																																																																$                     49.05																												$                   50.00
Business ARPU																																																																$                     66.41																												$                100.00
Measured business local rate/min																																																																$                         -																											use 0 for flat rate business service
Bus. T1 PBX/PRI/CT1 in region																																																																																			70								initial model: sold as EELs across region, not tied to colos

	SP-shared EELs in region																																																																																		60									initial model: not tied to colos; 50% V 50% data																																																																																												% of T1s shared																																									46%
Business T1 PBX/PRI/CT1 price																																																																$                        700																												$                      500
	SP-shared EEL V+D price																																																															$                        700																												$                      800
																																																															"Average across the quarter"																																																																																																							Stasis
Takeup																																																																				Q1																																Q2																						Q3																				Q4																						Q5																Q6																					Q7																						Q8																	Q9																		Q10														Q11												Q12+
Takeup rate:  Small collocations																																																																																		5%																												15%																			22%																				31%																			40%																	50%																				60%																						70%																	80%																				90%											100%													100%
Takeup rate:  Large collocations																																																																																		5%																												15%																			22%																				31%																			40%																	50%																				60%																						70%																	80%																				90%											100%													100%
Takeup rate:  PRI/T1 PBX, Shared																																																																																		2%																												10%																			20%																				35%																			45%																	55%																				70%																						80%																	90%																				95%												97%												100%
Small colo:  Loops in svc by quarter																																																																																			13																													38																				55																				78																	100																	126																					151																						176																201																				226												251
Lg colo:  Loops in svc by quarter																																																																																			45																												135																			198																				279																			360																	450																					540																						630																720																				810												900
T1 PBX/RAS ckts by quarter																																																																																					1																												7																			14																				25																			32																	39																						49																				56																63																					67												68
	SP-shared V+D T1s by quarter																																																																																				1																												6																			12																				21																			27																	33																						42																				48																54																					57												58

Churn rate/year																																																																												20%
Minutes of use																																																															local out																												local in																										toll out																					toll in																																					Traffic calculations:
Average IXC access MOU rate																																																																																																														0.010																				0.010																														MOU/mo																		MOU/BHr																						BHErlangs																				CCS/DS0
Average residential line MOU/mo																																																																																600																															500																			120																				100																																		1320																								6.6																			0.11																	3.96
Average business line MOU/mo																																																																													1000																															1100																						300																				250																																		2650																			13.25														0.220833																											7.95
Average all V loops MOU/mo																																																																			821.1741927																														831.761289																						219.528387																				182.9403222																																					2055.404																				10.277021																					0.171284																			6.166213
Average PRI/T1 line MOU/mo																																																																								40,000																															50,000																								4000																				3000																																		97000																						533.5														0.370486																				13.3375
Average Shared-T1 MOU/mo																																																																								15,000																															15,000																								2500																				1500																																		34000																										187										0.129861																									4.675
Price/minute of resold toll																																																																$                       0.07																											gross margin:																											$             0.04
% of resi V subs taking resold toll																																																																															75%																																																																									Loops/region:																																14461
% of bus V subs taking resold toll																																																																															50%																																																																									out																								in
% of resi subs in toto taking toll																																																																															52%																																								62.9234339																																		Loop local MOU/region:																																												11875000																			12028100

% of bus subs in toto taking toll																																																																															37%																																								112.293647																																								PRI locMOU/region:																																							2800000																					3000000
% of PRI/T1 subs taking resold toll																																																																															50%																																																																							Shared-T1 locMOU/region																																																		900000																					900000
ARPU (loop) on resold toll																																																																$                       6.32																														Wholesale toll:																								$             3.16																				average loop																																																											15589461																			15928100
ARPU (loop) on access																																																																$                       2.96
ARPU PRI/T1 on resold toll+access																																																																$                  210.00																																																						$          70.00
ARPU Shared-T1 on resold toll+acc																																																																$                  127.50
Percentage of traffic outbound																																																																															49%																						inbound:																												51%
Network Parameters:
Busy hour loop traffic %/month																																																																											0.50%																																										imts/line																						0.009277866
GR303 ratio:																																																																										5.06																																								gr303/line																										0.0090
Busy hour T1 traffic %/month																																																																											0.55%
	MT fill margin (ch/Erlang)																																																																																	1.3

	MTs per T1/PRI trunk																																																																									0.482
	MTs per Voice/data ISP-shared T1																																																																									0.169
	MTs per GR303																																																																												1.03
Avg. Resi DSL kbps																																																																																		12
Avg Business DSL kbps																																																																																			30
Gross Rack Units/colo rack																																																																																			42
Per rack common eq. RU																																																																																					4
Rack units/small DLC																																																																																					5
Rack units/Large DLC																																																																																			12
Core managers per region																																																																																					4
Lines per additional core manager																																																																													2500
PRI/T1s per add'l core manager																																																																																500

Headquarters core managers																																																																																					4
Lines per craft employee																																																																																500
Lines per office employee																																																																													1000
PRI/T1s per craft employee																																																																																100
PRI/T1s per office employee																																																																																200
Trucks per craft employee																																																																																		0.6
Model T1/PRI as EELs not colo?																																																																																					1						not yet turned on; this version assumes yes [1]
Percent of large colos "urban"																																																																															50%
Percent of large colos "suburban"																																																																															50%
Percent of large colos "rural"