Job Measure Reporting

Documentation HomeDownload as PDF

This module looks at the use of Job Measure Reporting within Workbench.

For further information regarding a specific module or aspect within Workbench, you could also refer to the Individual Module User Guides, for a more comprehensive description of available User features and functions.

OVERVIEW:

For contracts with rapid rates of expenditure, it is essential that Workbench provide an accurate weekly view of costs and measured work to assist the Project Manager in assessing how the project is performing overall.

Based on this historical data reporting can then provide an extrapolated Costs to Complete value which can be compared with the latest monthly Contract Forecast Costs to Complete.

All reporting is by Contract / Job / Subjob (if used) / Work Centre. It is important to realise this when working out the Work Breakdown Structure when setting up the Job and Contract in the first place. All of the measures are at the Work Centre level.

This approach assumes:

COSTS:

  • A weekly snapshot of Costs to Date, based on cut-off rules for the week. This data will be held in a separate WeeklyForecast table, based on Sunday week ending dates. (Note it is always Sunday. It is not looking at the Week Ending date from the Control File.)
  • The Cost Budget figures used in the Weekly Progress reporting include the 6 budget types 'above the line' in the Client Contract. This is the Current Contract Value.
  • It is expected that a full Forecast Cost to Complete process will be undertaken monthly, and will provide the Baseline for the subsequent Weekly Progress Reports as any budget changes will flow through to the Weekly Progress reporting. Forecast Adjustment do not flow through to the Weekly Progress reporting.
  • Given the basis of the rules proposed, multiple updates can be made to the weekly snapshot, each one overriding the previous one
  • In some cases it may not be possible to complete a weekly progress. This will be OK as the reporting is all based on 'To Date' figures.

MEASURED PROGRESS:

  • An Output Budget based on a Unit of Measure per Work Centre will be entered. This would normally be entered at the start of the contract but can be changed as the monthly forecasting is completed and budget variations entered.
  • A Weekly update of the achieved Measure to Date will be entered.

COSTS TO COMPLETE:

Two calculations will be available

  • To Complete at Budget Rate (Budget only 'above the line')
  • To Complete at Achieved Rate to Date

ACCRUALS:

  • Outstanding PO's and WO's are NOT taken into account in the Weekly Progress reporting.
  • To ensure accuracy of Costs to Cut Off, Workbench has brought in a special Job Cost Accrual that relates only to the Weekly Progress reporting.