Project Monitoring & S - Curves
Ekalavya, an ideal for modern students, learnt archery without any external help. By self-effort and faith in ones own power, desire for knowledge, and by self-reliance, one can do miracles.
Why Monitoring ?
Resources are limited
Status of progress of project both physical and
financial
Enables to take corrective action in time Utilization of resources Compare productivity of men & machinery w.r.t norms Check consumables consumptions
MONTHLY PROGRESS REPORT
JOB COST REPORT
MONTHLY REPORTS
PERFORMANCE REPORT
ANNEXURE V-A
RECONCILIATION
MONTHLY PROGRESS REPORT
Highlights the progress of works during the month and cumulative. The report includes
Monthly Highlights Physical Progress Financial Progress Progress Photographs Safety & Quality Statistics Constraints
JOB COST REPORT
MPCS
PURPOSE OF JCR
Its a tool to monitor financial performance of the job and highlights the areas of concern. Timely implementation of remedial measures on area of concern. Its a Mid course correction : Initiate necessary proactive steps
It Identifies items which are making loss / profit
Its a Reference document for Tendering / Contracts / Operations
Information's from JCR
Cost incurred till date for various project activities Operating unit rate of various activities Estimated cost for the balance works Revised overall cost estimate for the project Revised Contract Value Revised Profit Margin from the Project Variance of cost w.r.t ACE
JCR FORMAT
NAME OF THE JOB :
SITE CODE JOB NO. MONTH
JOB COST REPORT
Contractual Date of Commencement Actual Date of Commencement Contractual Date of Completion Expected Date of Completion
Original Contract Value Revised Contract Value
RECON CODE
DESCRIPTION
UNIT
JOB STATUS TO DATE
UNITS ACTUAL COST UNIT COST
ESTIMATE TO COMPLETE
UNITS COST UNIT COST
REVISED ESTIMATE
UNITS COST UNIT COST
ORIGINAL ESTIMATE FOR REVISED QTY VARIANCE REVISED REMARKS
COST SALES
UNIT UNIT COST COST
TOTAL COST FOR WORKS OVERHEADS TOTAL COST OF PROJECT
Estimated Site Contribution on Completion (Rev. Cont. Value Rev. Cost. Estimate ) Rs.
Gross Margin
Gross Margin in %
PLANNING MANAGER SITE ACCOUNTANT PROJECT MANAGER
Revised Estimate = Cost Incurred + Estimate Cost for balance qty
Original Estimate = Revised Qty X ACE Unit Rate
Variance ( B-A)
Original Estimate Revised Estimate
Gross Margin RCV Revised Estimate
Performance Report
Information provided by this statement includes
Monthly & Cumulative Invoicing ( Budget Vs. Act) Work in Progress Collection Age wise outstanding Break-up Funds Requirement by Site Working Capital Details Monthly and Cumulative Cost details Staff & workmen Strength Staff Productivity Safe Man Hours Worked Others
Annexure VA- Outstanding Statement
Information provided by this statement includes
Month wise billing details Cumulative Billing Deductions break-up Payment Collected Net Receivables TDS Certificate Age wise outstanding detail
ANNEXURE VA
JOB NO:
PROJECT : Invoice Amount (Rs.)
SL NO Month Invoice No / Date SUB. CER. MOB ADV + Int. RET Recoveries
DATE:
Certificate receipt
IT
WCT
OTH TOT
Net Payment Net Amount Received Receivable Remarks Payable (Rs.) (Rs.) (Rs.)
IT
WCT
TOTAL
Bulk Material Reconciliation
Consumption of materials is checked with respect to Drawings
Ensures that desired quantity of material is consumed into the product to get required quality Control on wastages ,excess consumption and theft Helps in mid-course correction.
Quantity Reconciliation
Reconciles the work done quantity paid to various agencies w.r.t quantities certified by Client or w.r.t approved drawings.
Assists in taking corrective action for any variations.
Performance always comes from Passion & not from Pressure.
Be Passionate..Love what you do & do what you love.
Why Analysis ?
Analysis of labour productivity w.r.t norms Mechanical
Fabrication Erection Pipe Laying
: MD / MT : MD / MT : MD / IM
Welder productivity
: ID/WD
Civil
Bar bending
: MD /MT
Shuttering
Staging Plastering / Painting
: MD/Sqm
: MD /cum : MD/ Sqm
Analysis of consumables consumptions w.r.t norms Mechanical
Electrode Grinding Wheel Welding cables Cutting Gas Oxygen gas Welder productivity
: Kg /MT :Nos /MT : Meter / MT : Kg / MT :cum / MT : ID/WD
Civil
Binding wire Nails Staging
: Kg /MT : kg/Sqm : MD /cum
Utilization of resources
Machinery
Excavator
: Cum / Hr
Crane
Welding M/c Batching Plant
: MT / Machine Mth
: MT / Machine Mth : Cum / Mth
Mixer Machine
: Cum / day
Fuel consumption / hr
Excavators Crane DG sets Mixer Machine Vibrator
S -CURVES
S-Curves
Achieved Vs Budgeted Expected Vs Budgeted
Various S-Curves Progress S Curve Invoicing S- curve Cost S-Curve Sales S-Curve GM S-Curve
SALES CURVE FY 09-10 ( BUD Vs. EXP )
80 70
73.96 74.51
VALUE IN CRS.
60 50 40 30 20 10 0
11.08 7.01 32.42
56.12 42.71
23.31
Budget
Q2 Q3
Exp
Q4
Q1
Invoice Curve FY 08-09
140 120 100
Budget Vs. Actual
119 Cr
VALUE IN CRS.
80
60
40 20 Budgeted
60 Cr
Actual
Apr-08
Jun-08
Dec-08
Aug-08
Oct-08
Feb-08
Feb-09
JCR INPUTS
Recon Code wise activity details
Cost Statement
Quantities paid to Sub-contractors MIB Details ETC Quantity and unit rate ACE Details
ACE : Accepted Cost Estimate
Its a detailed estimate of the expected cost to be spent for successful completion of a project Its a yard stick for measuring the profitability of a project. Consists of two parts: Direct Cost & Indirect Cost It enables site management to monitor the profitability of the project by comparing it with JCR. ACE has to be prepared within 1 month from the date of receipt of LOI / Work Order from the Client
