Scribd
Upload
198 views3 pages

Electrical Wiring Estimate Spreadsheet

The document provides an electrical estimate for a proposed 3-storey building with 12 classrooms. It lists materials, quantities, unit costs, and subtotals for wiring devices/fixtures, wires/cables, conduits/boxes/fittings, and panel boards/breakers. The total cost is PHP 588,420. A summary computes electrical and plumbing percentages, labor cost percentage, and grand total which is PHP 1,986,754.15. A pie chart on the summary is to be created.

Uploaded by

Delia Ruxanna B. Ismael
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
198 views3 pages

Electrical Wiring Estimate Spreadsheet

The document provides an electrical estimate for a proposed 3-storey building with 12 classrooms. It lists materials, quantities, unit costs, and subtotals for wiring devices/fixtures, wires/cables, conduits/boxes/fittings, and panel boards/breakers. The total cost is PHP 588,420. A summary computes electrical and plumbing percentages, labor cost percentage, and grand total which is PHP 1,986,754.15. A pie chart on the summary is to be created.

Uploaded by

Delia Ruxanna B. Ismael
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

CREATE A SPREADSHEET (EXCEL) THAT WILL AUTOMATICALLY COMPUTE THE FOLLOWING:

a. Amount
b. Subtotal
c. Total Cost
d. Summary (A,B,C,D)
e. Grand Total
f. Create a PIE Chart on the Summary

Electrical Estimates for proposed 3-storey Building with 12 classrooms at Maluso, Basilan Province
No. PARTICULAR QNT UNIT UNIT AMOUNT
Y COST

I. WIRING DEVICES/FIXTURES 87 sets 2,5000 217,500.00


1 2x28w T-5 Fluorescent Fixture 19 sets .00 15,200.00
2 1x23w CFL Pinlight 3 sets 800.00 4,500.00
3 1x90w Exhaust Fan 54 sets 1,500.00 43,200.00
4 Duplex Universal Convenience Outlet w/ 21 sets 800.00 6,300.00
5 plate Single-gang-switch w/ plate 15 sets 300.00 6,750.00
6 Two-gang switch w/ plate 5 sets 450.00 3,000.00
7 3-way-switch w/ plate 6 pcs 600.00 4,800.00
8 Fire Alarm Bell 6 pcs 800.00 3,000.00
9 Fire Alarm Pull Switch 500.00

subtotal 304,250.00

II. WIRES/CABLES 20 mtrs 450.00 9,000.00


1 50MM2THHN 5 mtrs 120.00 600.00
2 14MM2THHN(green) 30 mtrs 120.00 3,600.00
3 14MM2THHN 15 mtrs 60.00 900.00
4 5.5MM2THHN(green) 2520 mtrs 35.00 88,200.00
5 3.5MM2THHN 300 mtrs 35.00 10,500.00
6 3.5MM2THHN(green)

subtotal 112,800.00

III. CONDUITS/BOXES/FITTINGS 3 pcs 600.00 1,800.00


1 40MM ø x 3M RSC 9 pcs 250.00 2,250.00
2 40MM ø RSC Coupling 2 pcs 350.00 700.00
3 40MM ø RSC Elbow 2 pcs 25.00 50.00
4 40MM ø RSC Straight Connector with 1 pc 500.00 500.00
5 locknut 40MM ø RSC Service Entrance Cap
10 pcs 120.00 1,200.00
6 32MM ø x 3M RPVC Conduit 2 pcs 50.00 100.00
7 32MM ø PVC Coupling 4 pcs 80.00 320.00
8 32MM ø PVC Elbow 7 pcs 40.00 280.00
9 32MM ø PVC Adaptor with locknut
12 pcs 80.00 960.00
10 25MM ø x 3M RPVC Conduit

11 25MM ø PVC Coupling 3 pcs 30.00 90.00


12 25MM ø PVC Elbow 5 pcs 40.00 200.00
13 25MM ø PVC Adaptor with locknut 6 pcs 25.00 150.00

14 15MM ø x 3M RPVC 840 pcs 90.00 76,600.00


15 15MM ø PVC Coupling 20 pcs 90.00 1,800.00
16 15MM ø PVC Elbow 300 pcs 30.00 9,000.00
17 15MM ø PVC Adaptor with locknut 6 pcs 20.00 120.00

18 4” ø PVC Junction Box with Cover 120 pcs 40.00 4,800.00


19 2” x 4” PVC Utility Box 100 pcs 30.00 3,000.00
20 Electrical Tape 20 rolls 60.00 1,200.00
21 Rubber Tape 10 rolls 150.00 1,500.00
22 Solvent Cement 5 cans 150.00 750.00

subtotal 106,370.00

IV. PANEL BOARDS/BREAKERS 3 Assy. 15,000 45,500.00


1 Panel Board 100AF,2P,250V,Copper
Bus, 6 Branches
Main: 60AT, 2P,250V,Bolt-on
Branches: 6x20AT,2P,250V,Circuit
Breaker, Bolt-on
1 Assy. .00 20,000.00
2 Panel Board 225AF,2P,250V,Copper
Bus, 6 Branches
Main: 150AT2P,250V,MCCB
Branches: 6x20AT,2P,250V,Circuit
Breaker, Bolt-on
20,000
.00

subtotal 65,000.00

588,420.00
TOTAL COST:

SUMMARY

A. TOTAL COST OF MATERIALS PHP 588,420.00 B. ELECTRICAL (7% of A) PHP 41,189.40 C.


PLUMBING (5% of A) PHP 29,421.00 D. LABOR COST (45% Of A) PHP 264,789.00 GRAND
TOTAL PHP 923,819.40

GRAND TOTAL PHP 1,986,754.15


Prepared by: Engr. Full name

You might also like