w FPI - BoM.xlsx - Microsoft Excel
"fł |
t W Pa°W0Ut F01BT |
^f- R |
S" ^pWrap Text |
AW“ g |
m | ||||||||
iJ lizJ UU IMi | |||||||||||||
*-r> jT 3 i Pastę y |
_____ _ .-t— |
utoSum * II ” lear * |
i & | ||||||||||
Cambha - 14 * A* a' * |
- - |
Custom |
ii |
1 M ii onal Format |
5* gT :ell Insert |
» OH —i Tl c |
)J £ ort& Fmd | ||||||
B / u - _ * <2»- A’ * |
S 3 Merge & Center *j $ - % ♦ |
oo -;°o 5onditi |
r Delete Format ^ | ||||||||||
Clipboard r* |
Font ___[ |
Alignment |
Number |
r. |
Styles |
Cells |
Editing | ||||||
Cl - C?_Unit Costs | |||||||||||||
A |
B |
c |
D |
E |
F |
G |
H |
1 |
J |
K |
L |
M | |
i |
Unit Costs |
Calculated Cost |
HP/HA | ||||||||||
2 |
Materiał Cost |
Labour Cost |
Total |
Volume |
Total Cost | ||||||||
3 PublicTrenching | |||||||||||||
4 |
Trench: BURIED |
$0.00 |
$40.00 |
$40.00 |
11966.5 |
$478,661.62 |
HP | ||||||
5 |
Trench: BURIED (Crossing) |
$0.00 |
$50.00 |
$50.00 |
808.9 |
$40,443.00 |
HP | ||||||
6 |
Trench: Central Office Private Trench |
$0.00 |
$20.00 |
$20.00 |
17.8 |
$355.13 |
HP | ||||||
7 | |||||||||||||
8 Home | |||||||||||||
9 |
CPE P2P |
$20.00 |
$50.00 |
$70.00 |
78.0 |
$5,460.00 |
HA | ||||||
10 |
CPE_PON |
$70.00 |
$40.00 |
$110.00 |
763.0 |
$83,930.00 |
HA | ||||||
11 |
Extra connection cost per Building (MC |
$0.00 |
$100.00 |
$100.00 |
11.0 |
$1,100.00 |
HA | ||||||
12 |
Extra connection cost per Building (Std |
$0.00 |
$50.00 |
$50.00 |
708.0 |
$35,400.00 |
HA | ||||||
13 |
Extra connection cost per Home (MDU) |
$10.00 |
$50.00 |
$60.00 |
128.0 |
$7,680.00 |
HA | ||||||
14 |
Extra connection cost per Home (Std) |
$30.00 |
$100.00 |
$130.00 |
713.0 |
$92,690.00 |
HA | ||||||
15 |
Splice |
$0.00 |
$5.00 |
$5.00 |
224.0 |
$1,120.00 |
HA | ||||||
16 |
SplitterS |
$80.00 |
$50.00 |
$130.00 |
17.0 |
$2,210.00 |
HA | ||||||
17 | |||||||||||||
18 Drop | |||||||||||||
19 |
Cable 2F |
$0.50 |
$1.00 |
$1.50 |
13503.4 |
$20,255.15 |
HA | ||||||
20 |
DropBox |
$50.00 |
$50.00 |
$100.00 |
385.0 |
$38,500.00 |
HP | ||||||
21 |
Duet: Microduct Bundle (size 2) |
$0.30 |
$1.00 |
$1.30 |
13400.9 |
$17,421.22 |
HA | ||||||
23 |
Splice |
$0.00 |
$5.00 |
$5.00 |
746.0 |
$3,730.00 |
HA | ||||||
24 |
Trench: Customer Private Trench |
$0.00 |
$20.00 |
$20.00 |
13383.3 |
$267,665.84 |
HA | ||||||
25 | |||||||||||||
26 Distribution | |||||||||||||
27 |
Cabinet |
$1,750.00 |
$1,100.00 |
$2,850.00 |
13.0 |
$37,050.00 |
HP | ||||||
28 |
Cable 2F |
$0.50 |
$1.00 |
$1.50 |
54487.3 |
$81,731.00 |
HP | ||||||
29 |
Cable 4F |
$0.60 |
$1.00 |
$1.60 |
2098.5 |
$3,357.63 |
HP | ||||||
30 |
Duet: Microduct Bundle (size 11) |
$1.00 |
$1.25 |
$2.25 |
11211.4 |
$25,225.73 |
HP | ||||||
31 |
Duet: Microduct Bundle (size 24) |
$2.00 |
$1.50 |
$3.50 |
1214.8 |
$4,251.81 |
HP | ||||||
33 |
HandHole |
$100.00 angePrice Sheet |
$100.00 $200.00 BOM per DP (1-13) |
1.0 |
$200.00 |
HP | |||||||
H < ► M |
Overview Sheet Overview ^ BOM 0 |
a m |
< | ||||||||||
. di |
uj) tai i | ||||||||||||
Ready |
jo* yzj _ |