Nothing Special   »   [go: up one dir, main page]

Project Cost Estimate Excel Sheet

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

ESTIMATE OF PROJECT COST

SUMMARY OF INCOME Vs EXPENDITURE

DESCRIPTION AMOUNT / RS. AMOUNT / RS.


Total Expected Income
from Civil physical works only 528,973,119
(Bill Nu: 2 to 7)

Total Direct Construction Cost


Materials 422,160,529
Machinery 78,306,356
Manpower 35,258,217

Total Overhead Cost 55,378,250

Total Expenture 591,103,352


PROFIT / (LOSS) (62,130,234)
ESTIMATE OF PROJECT COST
DIRECT EXPENDITURE
COST OF MATERIALS
MAJOR MATERIALS (Based on HSR Norms, including transport cost)
Prevailing
No. Material Unit Qty Amount / Rs.
Unit Rate
1 Earth m3 85,844 706.71 60,667,217
2 ABC m3 20,040 3,621.91 72,583,039
3 Cement bag 19,563 870.74 17,034,295
4 Sand m3 2,334 3,268.55 7,629,532
5 Metal - 3/4" m3 2,524 3,975.27 10,034,783
6 Metal - 1 1/2" m3 547 3,268.55 1,787,505
7 Steel kg 53,314 117.17 6,247,010
8 Bitumen 80/100 ltr 93,547 86.86 8,125,648
9 Asphalt Cu.m 4,270 26,880 114,787,008
10 Diesel ltr 443,182 121 53,802,348
11 kerosene ltr 36,605 106 3,894,799
12 Boulders for rock fill Cu.m 4,000 2,000 8,000,000
Sub Total 364,593,184

MINOR MATERIALS
No. Material Unit Qty Rate Amount / Rs.

Variour other minor items


- Basis: 95% of the Total Cost
by Major Materials & Balance
5% by Miror Materials Sum 19,189,115

COST FOR MATERIALS 383,782,299


Add 5% for Price Escalation & another 5% for wastages 38,378,230
TOTAL COST FOR MATERIALS 422,160,529
COST OF MACHINERY
MAJOR MACHINERY - DRY COST BASIS (including the Cost of Operator)
No. Machine Unit Qty Rate / day Amount / Rs.

1 Motor Grader - 2 Nos Mon 20 625,000 12,500,000


2 10 Ton Roller - 2 Nos Mon 20 375,000 7,500,000
3 Excavator - 1 Nos Mon 10 375,000 3,750,000
4 Backhoe Loader - 2 Nos Mon 20 300,000 6,000,000
5 Wheel Loader - 2 Nos Mon 20 300,000 6,000,000
6 Water Bowser - 3 Nos Mon 20 150,000 3,000,000
7 Asphalt Laying Cost Ton 10,249 1,200 12,298,608

Internal Transportation
10 3 Cube Tippers - 5 Nos Day 1800 6,500 11,700,000
11 Farm Tractors - 3 Nos Day 1800 2,500 4,500,000
12 Small Lorries - 3 Nos Day 1800 2,000 3,600,000

Total mon 10,539 70,848,608

TOOLS & EQUIPMENT


No. Material Unit Qty Rate Amount / Rs.

Variour Tools & Equipment


- Basis: 95% of the Total Cost
by Major Machinery & Balance
5% by Miror Machinery &
Equipment Sum 3,728,874

BASIC COST OF MACHINERY 74,577,482


ADD: 5% TO ALLOW FOR PRICE ESCALATION 3,728,874
TOTAL COST OF MACHINERY 78,306,356

SALARIES & WEDGES


LABOUR (Calculated from the BOQ Quantities based on HSR Norms)

No. Labour Category Unit Qty Rate / day Amount / Rs.

1 Unskilled Days 13,538.19 750 10,153,639


2 Semi Skilled Days 20,609 800 16,487,538
3 Skilled Days 5,412 1,000 5,411,748
Sub Total 32,052,925
Add 10 % for escalation, Wastages & Idling 3,205,292
Total Cost 35,258,217
ESTIMATE OF PROJECT COST
OVERHEAD EXPENDITURE

Staff Salaries (Management & Supervisory )


Duration
No Item / months Rate Amount
1 Project Manager 12 500,000.00 6,000,000.00
2 Construction MAnager 10 200,000.00 2,000,000.00
3 Design Engineer 6 200,000.00 1,200,000.00
4 QA Manager 12 125,000.00 1,500,000.00
5 Site Engineers - 3 Nos 30 5,000.00 150,000.00
6 Technical Officers - 4 Nos 40 100,000.00 4,000,000.00
7 Works Supervisors - 8 Nos 80 50,000.00 4,000,000.00
8 Quantity Surveyor 12 150,000.00 1,800,000.00
9 Accountant -2 Nos 24 25,000.00 600,000.00
10 Store Keepers - 3 Nos 36 20,000.00 720,000.00
11 Materials Engineer 12 100,000.00 1,200,000.00
12 Materials Technician - 3 Nos 36 45,000.00 1,620,000.00
13 Draftsmen - 2 Nos 24 45,000.00 1,080,000.00
14 Surveyor 9 120,000.00 1,080,000.00
15 Levellers - 3 Nos 36 45,000.00 1,620,000.00
16 Social/ Environmental Officer 12 50,000.00 600,000.00
Total Staff Salaries 29,170,000
DDT : Income from BOQ - Preliminaries-Item 1.61 (11,643,750)
Net Salaries 17,526,250

Contractors Office
No Item Duration Rate Amount
1 Office - Rent 12 40,000.00 480,000.00
2 Telephone 12 20,000.00 240,000.00
3 Water 12 5,000.00 60,000.00
4 Electricity 12 12,000.00 144,000.00
5 Furniture 1 400,000.00 400,000.00
6 Computer with Printer 5 75,000.00 375,000.00
7 Fax Machine 1 25,000.00 25,000.00
8 Cammara. 1 20,000.00 20,000.00 1,744,000

Site Laboratory
1 Building - Rent 12 25,000.00 300,000.00
3 Water 12 5,000.00 60,000.00
4 Electricity 12 15,000.00 180,000.00
5 Lab Equipment - rental 1 year 1 500,000.00 500,000.00
6 Computer with Printer 1 75,000.00 75,000.00 1,115,000

Transportation Facilities to Contractor's Staff


No Item Duration Rate/ Month Amount
1 PM's Cab 12 160,000.00 1,920,000.00
2 Pool Light Vehicles - 5 Nos 60 120,000.00 7,200,000.00
3 Motor Bikes for Tos - 5 Nos 60 15,000.00 900,000.00 10,020,000
Staff Accomadation - 3 Nos
1 House 36.00 30,000.00 1,080,000.00
2 Telephone 36.00 3,000.00 108,000.00
3 Water 36.00 5,000.00 180,000.00
4 Electricity 36.00 9,000.00 324,000.00 1,692,000

Labour Accomadation - 5 NOS


1 House 60.00 25,000.00 1,500,000.00
2 Water 60.00 7,000.00 420,000.00
3 Electricity 60.00 4,000.00 240,000.00 2,160,000

Work Shop, Yards (3 NOS)


Land 48.00 30,000.00 1,440,000.00
Telephone 48.00 3,000.00 144,000.00
Water 48.00 4,000.00 192,000.00
Electricity 48.00 3,000.00 144,000.00
Security Service 96.00 20,000.00 1,920,000.00 3,840,000

Staitionary 12.00 10,000.00 120,000.00 120,000

Non-Productive Labour Salaries Qty Rate / Month Amount


Pion for Office - 1 Nos 360 750.00 270,000.00
Care Takers for Accomodations - 1080 750.00 810,000.00
Stores Helpers - 3 Nos 1080 800.00 864,000.00
Lab Helpers - 6 Nos 2160 800.00 1,728,000.00
Sureyor Helpers - 3 Nos 1080 800.00 864,000.00 4,536,000

Food for Workers @ 125 Rs/Day -Average 125 45,000 125.00 5,625,000.00 5,625,000

Cost of Mobilization & Demobilization of the Contratcor's Resources 2,000,000

Welfare of Staff & other Donations/ commitments 5,000,000

TOTAL OVERHEAD COST 55,378,250

You might also like