checklist for cost control dept in contracting company

25
Sr No. What You need: Availability Require ment met? What I have developed as a solution: 1 Format of Project budget which is mapped with the Proposal Y/N Skeleton format of budget is proposed which will be useful for Cost control during project life view 2 Budget Summary format: We must have predefined formats of out budget presentation which should be self explanantory (N/A) Developed Top Summary of Budget which will be repeatedly used in Variance Analysis to be reported to the Management. view 3 Summarized monthly Project Report describing achievement of targets in terms of major cost elements comparising the project (N/A) Project Cost Report which will highlight variations from monthly budget in terms of WBEs and Cost elements( Material, Labor etc) view 4 Detailed monthly Project Report which explains in detail where variations occurred. (N/A) Detailed Cost Report which explains in detail the above Project Cost Report i.e Cost Center wise budget, actual and variations are provided view 5 Consolidated Cost Report of all Projects: A corporate level report describing status of all running projects (N/A) Summary report on all projects which portrays Key Performance Indicators of all running projects. view 6 Daily Progress Report of Project with quantities Report available but without Qty. Developed Daily Progress Report showing quantitative data to measure and evaluate project performance view 7 Need to know which project is over-spending in which type of costs Consolidated Cost Report by elements: shows variances of Material, Lab etc of each project in one report view 8 Need to know which project is over-spending in which areas of Project WBE wise Cost Report: This explains cost spent in diff kind of activities like Excavation, concreting etc. along with variances View 9 Need to know which kind of material was used in which kind of activities Material Cost Variance Analysis: shows WBE wise material consumption with quantities and price view Cost Control Reporting requirements and Solutions

Upload: kashif-khawja

Post on 14-Apr-2017

433 views

Category:

Documents


2 download

TRANSCRIPT

Page 1: Checklist for Cost Control Dept in Contracting Company

Sr No.

What You need: AvailabilityRequire

ment met?

What I have developed as a solution:

1

Format of Project budget which is mapped with the Proposal

Y/NSkeleton format of budget is proposed which will be useful for Cost control during project life

view

2

Budget Summary format: We must have predefined formats of out budget presentation which should be self explanantory

(N/A)

Developed Top Summary of Budget which will be repeatedly used in Variance Analysis to be reported to the Management.

view

3

Summarized monthly Project Report describing achievement of targets in terms of major cost elements comparising the project

(N/A)

Project Cost Report which will highlight variations from monthly budget in terms of WBEs and Cost elements( Material, Labor etc)

view

4

Detailed monthly Project Report which explains in detail where variations occurred.

(N/A)

Detailed Cost Report which explains in detail the above Project Cost Report i.e Cost Center wise budget, actual and variations are provided

view

5

Consolidated Cost Report of all Projects: A corporate level report describing status of all running projects

(N/A)Summary report on all projects

which portrays Key Performance Indicators of all running projects.

view

6Daily Progress Report of Project with quantities

Report available

but without Qty.

Developed Daily Progress Report showing quantitative data to measure and evaluate project performance

view

7

Need to know which project is over-spending in which type of costs

Consolidated Cost Report by elements: shows variances of Material, Lab etc of each project in one report

view

8

Need to know which project is over-spending in which areas of Project

WBE wise Cost Report: This explains cost spent in diff kind of activities like Excavation, concreting etc. along with variances

View

9

Need to know which kind of material was used in which kind of activities

Material Cost Variance Analysis: shows WBE wise material consumption with quantities and price

view

Cost Control Reporting requirements and Solutions

Page 2: Checklist for Cost Control Dept in Contracting Company

Sr No.

What You need: AvailabilityRequire

ment met?

What I have developed as a solution:

Cost Control Reporting requirements and Solutions

10

Need to measure labor utilization on different activities (WBE)

Labor Utilization Report: It calculates manpower employed on each WBE and compares with standard time required as per Proposal

view

11WBE wise Equipment utilization

Equipment Utilization Report: It portrays the usage of Equipment in

diff activities of the projectview

12

Shared Costs of Equipment to be charged to relevant activities

Shared Equipment Costs allocation report is designed alongwith the basis of allocation

view

13

Cost Audit techniques of Project Expenses should be provided to ensure integrity of project data

Simple to use audit techniques are being formulated. To check accuracy of Material cost, attached report is designed

view

14

Subcontractor evaluation forms should be available to control cost and payments to subcontractors.

Subcontractor Evaluation Form is designed

view

15Cost of Production reports of Plants

A Sample of my previous work is attached for reference only. Actual report will be created based on Information systems of IMP

view

16

Weekly Project Performance Report: Showing all critical aspects of a Project

Not designed here, however, a sample is avilable for adoption. Exact report will be created based on Information System of IMP

view

17

Expected At Completion: This is required to be reported as per company policy but format is not available

This report can take any format. For reference, image of one report is attached.

view

18 Knowledge of your existing systems is required to make these reports successfully operational

Page 3: Checklist for Cost Control Dept in Contracting Company

DETAIL FORECAST COST CONTROL

BudgetProject#Project Name:Location:

Material LaborSub-

contract Equip-ment

Over-head Total

1 General Costs1 00 6 10 Insurance

2 00 6 11 CAR

3 00 6 15 CPM cover

4 00 8 90 Mobilization

5 01 3 21 Demobilization

6 01 3 31 Sign Board

7 01 4 51

2 01 5 01 Design Related Costs3 01 5 02

4 01 5 03

5 01 5 04 General Requirements- Site Workshops

6 01 5 11 General Requirements- Temporary Water

7 01 5 12 General Requirements - Temporary Electricity

8 01 5 13 General Requirements- Temporary Telecommunications

3 01 5 14 Architectural4 01 5 22 General Requirements- Site Transportation

5 01 5 23 General Requirements- Site Offices and Equipment for Contractor

4 01 5 24 Structural

4.1 Structural Steel and Re inforced t

Shalow foundations

II. Other Provisional Cost Not Included

- - - - -

Prepared by: Approved by :

S.No Cost code Description

Total Cost (Budget)

T O T A L

Page 4: Checklist for Cost Control Dept in Contracting Company

Budget Summary(format)Project NameProject No.Employer: Expected Start Date

Expected Finish Date

Sr. BOQ Items Material Labor Subcontract Equipment Overhead Total Cost Profit Margin Total Price

1 General Costs2 Design Costs3 Archiectural 4 Structural5 Geotechnical6 Mechanical7 Electrical8 Utilities9 Transportation10 Dewatering11 Jet Fuel Hydrant Network

TOTAL

Page 5: Checklist for Cost Control Dept in Contracting Company

Structural

Description RESP. Unit Total Qty.Planned Qty.

for the Month

Actual Qty. for the Month

Earned %Age This Month

Todate Qty. Balance Qty. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

Culverts

Precast parapets IMP Cum 44,492 11,934 1,756 15% 34,314 10,178 - - - - - 94 - - 510 376 - - 83 - 232 - 461 - -

Slabs IMP Cum 226,208 1,687 1,687 100% ###### 0 - - - - 507 - - - - 484 - - - - - 696 - - -

Subco Cum 198,504 30,756 10,482 34% ###### 20,274 - - - ### - ### 810 200 362 - - - ### - #### ### ###

Subco Cum 572,669 115,202 - #REF! ###### 115,202 - - - - - - - - - - - - - - - - - - -

Cum - - - - - - - - - - - - - - - - - - -

SUB-TOTAL Cum ####### 159,579 13,925 9% ###### 145,654 - - - - - - ### 507 ### 810 200 872 860 - - ### - #### ### ### - - - - -

Geo Technical

Site Clearing KST Cum 65427 - 60,427 5,000 - - - - - - - - - - - - - - - - - - -

IMP Cum 93675 - 81,592 12,083 - - - - - - - - - - - - - - - - - - -

LBCC Cum 71,000 - 73,945 (2,945) - - - - - - - - - - - - - - - - - - -

HMHAS Cum 42,253 - 39,827 2,426 - - - - - - - - - - - - - - - - - - -

SUB-TOTAL Cum 272,355 - - ###### 16,564 - - - - - - - - - - - - - - - - - - - - - - - -

GRAND TOTAL Cum ####### 159,579 13,925 9% ###### 162,218 - - - - - - ### 507 ### 810 200 872 860 - - ### - #### ### ### - - - - -

Plumbing

Domestic water pumping Subco Cum 40,552 21,092 1,338 6% 20,798 19,754 - - - - - 165 345 - - - - 510 147 171 - - - - -

LBCC Cum 59,186 42,606 4,517 19% 11,476 47,710 - - - - - 951 904 597 - - 831 - 536 - - - 435 263 -

DEL Cum 3,545 10,957 - - - - - - 375 587 - - 366 360 349 - 698 - 585 - 225

HMHAS Cum 12,199 10,840 - 1,359 10,840 - - - - - - - - - - - - - - - - - - -

GRAND TOTAL Cum 111,937 74,538 9,400 13% 44,590 78,304 - - - - - - - - ### ### ### - - ### 870 ### 171 698 - ### 263 225 - - -

EQUIPMENT STATUS

Available at Site

Available at Site

Break down

Break down

Available

at Site

Break down

Available

at Site

Break down

Available

at Site

Break down

DUMPER 4+ 23 IDLE 10 - - 5 - - - - -

LOADER 1 2 - - 2 - 2 - - -

DOZER - - - - - - 1 - - - 495 582 320

MOTOR GRADER 2 1 - - 5 - 3 - - -

Highlights: Bottlenecks:

PROJECT # DAILY PROGRESS REPORT

(All data for illustrative purpose only)Month

NAME OF EQUIPMENT

IMP Subcontractor-1 Subcontractor-1 Subcontractor-1

Subcontractor-1

Subcontractor-1

Break down

Available at Site

- -

MANPOWER

- - Impregilo Sub-CO.

- -

I/C PLANNING SITE MANAGER

- - Direct Indirect

Page 6: Checklist for Cost Control Dept in Contracting Company

Project Name :Location :Covered Period Upto the monthSUMMARY BY WBS SUMMARY BY ELEMENTS:

WBS Description Total Budgeted

Budget upto the period

Actual Cost from ERP VARIANCE Expected at

Completion COMMENT Budget upto the period

ACTUAL COST FROM ERP VARIANCE COMMENT

1 General Costs Material

2 Design Costs Labor

3 Archiectural Subcontract

4 Structural Equipment

5 Geotechnical Overhead

6 Mechanical Total

7 Electrical

8 Utilities

9 Transportation

10 Dewatering

11 Jet Fuel Hydrant Network

TOTAL

Prepared by: Approved by : Project In-charge Checked by : Controlled by:

REVENUE

Gross Profit

Gross Profit %

Page 7: Checklist for Cost Control Dept in Contracting Company

DETAIL TO DATE COST COST CONTROL REPORT

Project Name :Location :

Covered Period : UP TO ----

SNOST CODE DESCRIPTION

Material Labor Subcontract Equipment Overhead TOTAL Material Labor Subcontract Equipment Overhead TOTAL Material Labor

1 00 6 10 Bidding & Contracting Requirements- Bonds - -

2 00 6 11 Bidding & Contracting Requirements- Bank Gaurantees - -

3 00 6 15 Bidding & Contracting Requirements- Insurances - -

4 00 8 90 Bidding & Contracting Requirements- Permit Fees - -

5 01 3 21 The Contractor shall Provide photos & reports to the consult. - -

- -

- -

- -

- -

- -

- -

- -

- -

- -

- -

- -

TOTAL BUDGET COST PREVIOUS EXPENSES

Page 8: Checklist for Cost Control Dept in Contracting Company

DETAIL TO DATE COST COST CONTROL REPORT

Subcontract Equipment Overhead TOTAL Material Labor Subcontract Equipment Overhead TOTAL Material Labor Subcontract Equipment Overhead TOTAL

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

- - - - - - -

EXPENSES THIS MONTH TOTAL EXPENSES TO DATE Variance

Page 9: Checklist for Cost Control Dept in Contracting Company

Checklist for Cost Control Dept in Contracting Company Page 1 of 1

Projected Invoice todate

Projected Cost todate

% Amount

1 IMP001 500,000,000 2.00 IMP002

A TOTAL 500,000,000 - - - - -

CONSOLIDATED COST REPORTAS OF 31-JANUARY-2011

No. IMP Project No.

Total Contract Amount

Total Budgetted Cost

Actual Invoice todate (Certified)

Actual Cost todate

Actual Margin - To Date

Page 10: Checklist for Cost Control Dept in Contracting Company

Checklist for Cost Control Dept in Contracting Company Page 1 of 2

COST REPORT BY ELEMENTS

Material Labor Subcontract Equipment Overhead Total Material Labor Subcontract Equipment Overhead

1 IMP001

TOTAL - - - - - - - - - - -

AS OF 31-January-2011

No. IMP Project No. Estimated for the period Actual for the period

Page 11: Checklist for Cost Control Dept in Contracting Company

Checklist for Cost Control Dept in Contracting Company Page 2 of 2

Provision For Works Total Material Labor

- - - - - - - -

- - - -

Page 12: Checklist for Cost Control Dept in Contracting Company

Page: 1Date: 8/3/2015 at 4:49 PM

Date Job Numbe WBE Item Number Item Description Quantity Unit Cost Ext. Cost21210 Total 1,973,959 8,916,390 21220 Total 6,250 43,544 21230 Total 5,400 21,435 21250 Total 9,402 125,358 21320 Total 50 504 21340 Total 18,000 1,044,342 21410 Total 146,888 5,415,707 21710 Total 3 (497,061) 21740 Total 224,331 5,836,061 21753 Total 51,218 239,509 21830 Total 51 231,284 21860 Total 70,813 274,999 21885 Total 1,533 55,612 21895 Total 3 2,458,645

Subtotal for Project 2,507,901 ##########

2,507,901 ##########

Grand Total for All Projects 7,523,702 ##########

WBE Total Cost21210

ADMIXTURE SIKAMENT 520-BA 264,202CEMENT ORDINARY PORTLAND BSS 12 7,798,754CRUSH 3/8" 535,183DIRECT MATERIALS -298SAND FINE 318,551

8,916,390Rs.

21220 TotalSAND FINE 27,211 CEMENT ORDINARY PORTLAND BSS 12 16,333

43,544Rs. 21230

CEMENT ORDINARY PORTLAND BSS 12 21,435 21,435Rs.

21250CALCIUM CARBONATE (LIME POWDER) 647 CEMENT ORDINARY PORTLAND BSS 12 13,094 DISC CUTTING CS: 7"x1/8" 477 ELECTRODE WELDING AWS E6013: 3.25 MM 1,115 GAS OXYGEN 1,236 Others 108,789

125,358Rs. 21320

ANGLE EQ. AL: 1/2"X1/2"X1/8" 504

21340 WIRE PRESTRESSING TENDON M.S 12.7MM 1,044,342

21410 REBAR DEFORMED MS 25 MM GR-60 # 8 5,415,707

21710 DIRECT MATERIALS (497,061)

21740 BITUMEN: GRADE 60/70 5,375,199 KEROSENE 411,603 DIRECT MATERIALS 49,260

5,836,062Rs. 21753

CEMENT ORDINARY PORTLAND BSS 12 188,761 CRUSH 3/4" 13,915 DIRECT MATERIALS 32,735 POWDER MARBLE FOR CHIPS 471 SAND FINE 3,628

239509.4421830

PIPE RCC 48`` X 8` 231,284

21860CRUSH 3/4" 2,272 SAND FINE 6,803 POWDER MARBLE FOR CHIPS 65 CEMENT ORDINARY PORTLAND BSS 12 265,860

274999.0621885 CEMENT ORDINARY PORTLAND BSS 12 212

REBAR DEFORMED MS 12 MM GR-60 # 4 55,399 55612

21895DIRECT MATERIALS 2,458,645

WBE WISE COST REPORT

Page 13: Checklist for Cost Control Dept in Contracting Company

Page: 1Date: 8/3/2015 at 4:49 PM

WBEWork Done

QTY Material Total Cost Quantity Unit Cost Standard

Material Qty Standard

Cost Variance 21210

ADMIXTURE SIKAMENT 520-BA 264,202 10,686 25 CEMENT ORDINARY PORTLAND BSS 12 7,798,754 1,898,818 4 CRUSH 3/8" 535,183 36,440 15 DIRECT MATERIALS (298) (2) 149 SAND FINE 318,551 28,017 11

8,916,390

21220SAND FINE 27,211 2,400 11 CEMENT ORDINARY PORTLAND BSS 12 16,333 3,850 4

43,544 21230

CEMENT ORDINARY PORTLAND BSS 12 21,435 5,400 4 21,435

21250CALCIUM CARBONATE (LIME POWDER 647 100 6 CEMENT ORDINARY PORTLAND BSS 12 13,094 3,150 4 DISC CUTTING CS: 7"x1/8" 477 10 48 ELECTRODE WELDING AWS E6013: 3.2 1,115 18 62 GAS OXYGEN 1,236 4 309 Others 108,789 6,120 18

125,358 21320

ANGLE EQ. AL: 1/2"X1/2"X1/8" 504 50 10

21340 WIRE PRESTRESSING TENDON M.S 12 1,044,342 18,000 58

21410 REBAR DEFORMED MS 25 MM GR-60 # 5,415,707 146,888 37

21710 DIRECT MATERIALS (497,061) (3) 165,687

21740 BITUMEN: GRADE 60/70 5,375,199 212,730 25 KEROSENE 411,603 11,600 35 DIRECT MATERIALS 49,260 1 49,260

5,836,062 21753

CEMENT ORDINARY PORTLAND BSS 12 188,761 49,700 4 CRUSH 3/4" 13,915 960 14 DIRECT MATERIALS 32,735 1 32,735 POWDER MARBLE FOR CHIPS 471 237 2 SAND FINE 3,628 320 11

239,509 21830

PIPE RCC 48`` X 8` 231,284 51 4,535

21860CRUSH 3/4" 2,272 160 14 SAND FINE 6,803 600 11 POWDER MARBLE FOR CHIPS 65 53 1 CEMENT ORDINARY PORTLAND BSS 12 265,860 70,000 4

274,999 21885 CEMENT ORDINARY PORTLAND BSS 12 212 50 4

REBAR DEFORMED MS 12 MM GR-60 # 55,399 1,483 37 55612

21895DIRECT MATERIALS 2,458,645 3 819,548

24,166,330

Material Cost Variance Analysis

Page 14: Checklist for Cost Control Dept in Contracting Company

WBE WISE MAN-HOURS REPORT 21132- SITE CLEARINGPROJECT : Period

Craft Description Normal Time Over time Total

05 AREA INCHARGE(CIVIL) 48.00 12.00 60.0011 SUPERVISOR(CIVIL) 48.00 12.00 60.0049 LABOUR 80.00 20.00 100.0057 HELPER 80.00 20.00 100.00

256.00 64.00 320.00

Labour utilization report

WBE Cost Code

Quantity Claimed in Progress Invoice Craft

Standard Labour hours

required

Actual Labour Hours spent

Page 15: Checklist for Cost Control Dept in Contracting Company

Variance

Page 16: Checklist for Cost Control Dept in Contracting Company

Hours Over Break DIESEL ENGINEEqp. C.C Proj WBE WBE Description Consumed Time Down OIL

71105 CRANE 40 TONN 21110 CLEARING / GRUBBING / STRIPPING / T 10 0 0 0 071105 CRANE 40 TONN 21120 GENERAL OPEN SECTION EXCAVATION BY MACHI 9 0 0 100 071105 CRANE 40 TONN 21130 BACK FILLING GENERAL/OPEN SECTION WITH C 104 28 0 0 071105 CRANE 40 TONN 21135 FILL WITHOUT COMPACTION 130 10 0 0 071105 CRANE 40 TONN 21170 DEWATERING 10 4 0 0 071105 CRANE 40 TONN 21210 CEMENT CONCRETE PRODUCTION AND SUPPLY AT 88 26 10 302 071105 CRANE 40 TONN 21250 CONCRETE PLACING FOR PRECAST ELEMENTS 40 29 0 30 571105 CRANE 40 TONN 21255 ERECTION OF PRE CAST ELEMENTS 24 13 10 0 371105 CRANE 40 TONN 21310 FORMWORK IN STRUCTURE 182 31 60 165 271105 CRANE 40 TONN 21320 FORM WORK SUPER-STRUCTURE 4 0 0 68 071105 CRANE 40 TONN 21340 FORM WORK FOR PRE CAST ELEMENTS 255 86 40 178 071105 CRANE 40 TONN 21885 MISC. CIVIL WORKS 247 63 23 343 5

TOTAL 1103 290 143 1186 15

72156 AIR COMPRESSOR 21210 CEMENT CONCRETE PRODUCTION AND SUPPLY AT 15 0 0 200 072156 AIR COMPRESSOR 21740 PRODUCTION OF ASPHALT CONCR. AND SUPPLY 154 20 54 2751 072156 AIR COMPRESSOR 21748 ASPHALT TACK/PRIME COAT 10 0 0 0 072156 AIR COMPRESSOR 21885 MISC. CIVIL WORKS 78 18 0 680 072156

TOTAL 257 38 54 3631 0

73224 POWER GEN.40 K 21210 CEMENT CONCRETE PRODUCTION AND SUPPLY AT 136 136 0 144 021885 MISC. CIVIL WORKS 1006 314 0 2557 6

TOTAL 1142 450 0 2701 6

73322 POWER GEN.100K 21210 CEMENT CONCRETE PRODUCTION AND SUPPLY AT 50 22 0 421 021310 FORMWORK IN STRUCTURE 20 4 0 195 021320 FORM WORK SUPER-STRUCTURE 20 17 0 260 021410 STEEL REBAR 10 0 0 50 021885 MISC. CIVIL WORKS 1296 1111 2 9825 34

TOTAL 1396 1154 2 10751 34

73323 POWER GEN.100 21110 CLEARING / GRUBBING / STRIPPING / T 20 0 0 0 021140 HAULAGE OF RIP RAP 0 21 0 160 021210 CEMENT CONCRETE PRODUCTION AND SUPPLY AT 20 2 0 109 021280 CONCRETE PLACING FOR PILES 64 24 16 642 021310 FORMWORK IN STRUCTURE 108 45 0 1472 021320 FORM WORK SUPER-STRUCTURE 60 39 0 864 3021410 STEEL REBAR 95 62 0 1279 021885 MISC. CIVIL WORKS 790 719 0 7121 33.5

TOTAL 1157 912 16 11647 63.5

73324 P.GENERATOR 40 21210 CEMENT CONCRETE PRODUCTION AND SUPPLY AT 260 125 0 819 021250 CONCRETE PLACING FOR PRECAST ELEMENTS 40 6 0 184 021310 FORMWORK IN STRUCTURE 82 31 8 406 021320 FORM WORK SUPER-STRUCTURE 70 43 0 512 021340 FORM WORK FOR PRE CAST ELEMENTS 110 60 0 807 021410 STEEL REBAR 0 10 0 57 0

TOTAL 562 275 8 2785 0

73325 POWER GEN.275 21135 FILL WITHOUT COMPACTION 2 12 0 351 021210 CEMENT CONCRETE PRODUCTION AND SUPPLY AT 505 793 2 16262 021885 MISC. CIVIL WORKS 671 405 0 8424 0

TOTAL 1178 1210 2 25037 0

73326 POWER GEN.275 1 BRAKE DOWN 10 0 0 84 2521110 CLEARING / GRUBBING / STRIPPING / T 20 1 0 60 021210 CEMENT CONCRETE PRODUCTION AND SUPPLY AT 158 93 0 2286 021250 CONCRETE PLACING FOR PRECAST ELEMENTS 50 12 0 641 021310 FORMWORK IN STRUCTURE 278 152 10 3915 021320 FORM WORK SUPER-STRUCTURE 582 224.1 21 7587 2521340 FORM WORK FOR PRE CAST ELEMENTS 110 50 0 1153 021410 STEEL REBAR 40 17 0 544 021885 MISC. CIVIL WORKS 180 38 0 938 0

TOTAL 1428 587.1 31 17208 50

73327 POWER GEN.275 1 BRAKE DOWN 10 7 0 350 021210 CEMENT CONCRETE PRODUCTION AND SUPPLY AT 637 266 1 9780 021885 MISC. CIVIL WORKS 680 337 128 12957 165

TOTAL 1327 610 129 23087 165

73328 P.GEN 15 KVA S 21135 FILL WITHOUT COMPACTION 10 0 0 0 021210 CEMENT CONCRETE PRODUCTION AND SUPPLY AT 110 0 0 86 021250 CONCRETE PLACING FOR PRECAST ELEMENTS 0 10 0 0 021255 ERECTION OF PRE CAST ELEMENTS 20 20 0 32 021310 FORMWORK IN STRUCTURE 231 32 80 332 0

Project WBE Wise Equipment Utilization ReportProject Name

Report period------

Page 17: Checklist for Cost Control Dept in Contracting Company

WBE Diesel Engine Oil Rent Charged TotalProduction

Qty UnitCost Per unit of Production

Clearing of site 335,601 - 573,052 908,653 0Compaction 158,321 - 271,766 430,087 0Asphalt 258,413 - 556,726 815,139 0

1,090,676 - 1,455,813 2,546,489 210 Sq M225,792 - 523,181 748,973 215 Sq M182,979 - 85,224 268,203 63 Sq M

Rebar 15,635 1,416 8,843 25,894 12 Ton430,470 - 1,280,129 1,710,598 2963 Cum

2,814,710 - 1,924,984 4,739,693 0 Cum279,272 5,664 758,671 1,043,607 934 Cum496,589 - 699,215 1,195,804 1800 Sq M94,722 - 148,897 243,619

- - - - 1,496,159 - 1,482,135 2,978,294 2,143,142 - 3,757,836 5,900,978 1795 Cum

- - - - 56 Cum

Grand Total 19,709,360 14,160 26,479,890 46,203,410

Rent is allocated to WBEs based on Equipment Utilization Report

ProjectWBE wise Equipment Cost

For the period

Page 18: Checklist for Cost Control Dept in Contracting Company

Store/warehouse RecordFor the month of….Sr Material Item

QTY Value QTY Value QTY

1,000,000

Reconciliaiton with:

Financial RecordTotal Purchases for the month 1,000,000Closing balance in financial ledger

Total Material Issues in financial record

Difference -

Monthly Cost Audit Sheet for Materials

Opening Bal Purchases Iss

Page 19: Checklist for Cost Control Dept in Contracting Company

Value QTY Value

800,000 200,000

200,000

800,000

- -

sue Closing Bal

Page 20: Checklist for Cost Control Dept in Contracting Company

Subcontractor evaluation formProject#Subcontractor: Invoice No.For the period

Quantity Rate Amount Quantity Amount Quantity Amount Quantity Rate AmountThis Period Balance to be done

RemarksWBS WBE Description UOMTotal Contract Invoice Upto last period

Page 21: Checklist for Cost Control Dept in Contracting Company

Subcontracting CostProject #

Subco WBE Bill Inv # Qty(Cum) rate AmountSubco -1 21132 month 3 102,700.00 138.17 14,189,640 Subco -2 21133 month - 3,351,907 Subco -3 21134 month 6 266,793 110.25 29,413,885

46,955,432

Subcontracting Cost of Culverts

Page 22: Checklist for Cost Control Dept in Contracting Company

Remarks

Page 23: Checklist for Cost Control Dept in Contracting Company

Analysis of Culverts costsQuantity of work doneFor the period

QTY Total Cost Per unit Cost QTY Total Cost Per unit Cost

Material

Labour

Equipment

Sub-contractor

Overhead

Total Cost

Cost ElementsBudget Actual

Variance

Page 24: Checklist for Cost Control Dept in Contracting Company

Material Purchase Evaluation formProject#Supplier:

Quantity Rate Amount Quantity Amount Quantity Amount Quantity Rate AmountBudget Balance Suggested Purchase Budget Balance

after Purchase RemarksWBE Item Code Item Description UOMTotal Budget Spent todate

Page 25: Checklist for Cost Control Dept in Contracting Company

Check-List for Material Items mostly likely to be chargeable to certain Cost Codes

WBS(s) WBE(s)

Audit of Project Record for correct Cost Codes(Using Excel tools)

Sr. No Item Code Item Description Issue to WBE Correct/Incorrect

1 123 xyz 88-888-99 Y/N

Sr. No. Item Code Item DescriptionApplicable Cost Codes for: