• No results found

Project Cost Estimate - excel sheet

N/A
N/A
Protected

Academic year: 2021

Share "Project Cost Estimate - excel sheet"

Copied!
6
0
0

Loading.... (view fulltext now)

Full text

(1)

ESTIMATE OF PROJECT COST

SUMMARY OF INCOME Vs EXPENDITURE

DESCRIPTION

AMOUNT / RS.

AMOUNT / RS.

Total Expected Income

from Civil physical works only

(Bill Nu: 2 to 7)

528,973,119

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

(2)

ESTIMATE OF PROJECT COST

DIRECT EXPENDITURE

COST OF MATERIALS

MAJOR MATERIALS (Based on HSR Norms, including transport cost)

No. Material Unit Qty Prevailing Unit Rate Amount / Rs. 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

(3)

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

(4)

Add 10 % for escalation, Wastages & Idling 3,205,292

(5)

ESTIMATE OF PROJECT COST

OVERHEAD EXPENDITURE

Staff Salaries (Management & Supervisory )

No Item

Duration

/ 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

(6)

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 - 3 Nos 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 Nos / day 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

References

Related documents