6604590376

3

FPI - BoM.xlsx * Microsoft Excel

* hJ

J

Clipboard ^r*

Pastę

T3* TSP -0°“* -S⁸⁵ ® ^RS^{W v}© ^AHT^ł 0

Cambria	16 "

B / U

Font

^J<WrapText    General

_ - <3* - j\ -    ^ M ^ iW- iW- ^MergeSc Center *

^r*    Aiignment    ^

$ * %

TóS

Number

© -

i fiS Conditional Format Celi Formatting - as Table • Styles *	Insert -Delete * jp Format *	Sort & Find & -2’ Filter- Select-
Styłes	Cells	Editing

BI

-

Calculation Information

	A	B C	D	E	F 6
1		Calculation Information
2		Area Name	Area
3		Design Rules	Rules
4		Number of Homes Activated	829
5		Number of Homes Passed	829
6		Overall Adoption Ratę	100%
7		Expected n PON Customers	751
8		Expected n P2P Customers	78
9		Household Density (hh/sqkm)	1
10
11
12		Results
13		Total Cost of Project	$2,692,956.12
14		Total Cost of Deployment	$1,639,307.22
15		Total cost of Activation	$1,053,648.90
16
17		Cost per Home Passed	$1,977.45
18		Cost per Home Activated	$1,270.99
19
20		Total Expected Revenue (12m]	$253,380.00
21		PON Monthly Revenue	$18,775.00
22		P2P Monthly Revenue	$2,340.00
23
24

Generated by FiberPlanIT

FiberPlanIT - SmallWorld Standard Configuration

Cost Breakdown

H

	Homes Passed Cost	Homes Activated Cost	Total Cost	%
Public Trenching	$993,795.71	$0.00	$993,795.71	37%
Home	$0.00	$403,868.00	$403,868.00	15%
Drop	$245,700.00	$602,805.90	$848,505.90	32%
Distribution	$344,436.57	$5,675.00	$350,111.57	13%
Feeder	$55,374.94	$41,300.00	$96,674.94	4%
Total Cost	$1,639,307.22	$1,053,648.90	$2,692,956.12	100%

■ Public Trenching ■Home □ Drop

■Oistribution

OFeeOer

25

26 27

mm

: Overview_Sheet. Overvoew . BOM_ChanqePrice_Sheet , BOM per DP (1-7) . *3/

<L

a

Ready