OPS - SP009 - Project Reporting
OPS - SP009 - Project Reporting
OPS - SP009 - Project Reporting
PROJECT REPORTING
CONTENTS
2.0 DEFINITIONS
3.0 FLOWCHART
5.0 REFERENCES
6.0 ATTACHMENTS
Copyright. This document is the property of PT Thiess Contractors Indonesia and all rights
are reserved in respect of it. This document may not be reproduced or disclosed in any
manner whatsoever, in whole or in part, without the prior written consent of PT Thiess
Contractors Indonesia. PT Thiess Contractors Indonesia expressly disclaims any
responsibility for or liability arising from the use of this document by any third party. Copies
printed from the Thiess Management Systems are UNCONTROLLED.
Revision Status
Issue /
Date Revision Description By Checked Checked Approved
Rev.
Modification from the
A0 October 99 ES RL BAM
corporate procedure
A1 May 00 TMS Intranet Version ES RW RL BAM
2.0 DEFINITIONS
Project Report is a concise summary of the project’s progress, safety
and financial position.
Final Project Report is a concise summary of the previously prepared
monthly Progress Reports, as well as the means to
record important historical information and detailed
work descriptions.
3.0 FLOWCHART
Not applicable to this procedure.
Because the Forecast Report is a vital document, the monthly Project Report can be
prepared using the forecast for the preceding month. This ensures that Project
Managers have sufficient time to prepare their forecast in accordance with the
timetable required by management. Where the Project Manager is satisfied that the
Forecast Report can be prepared accurately for the current month within the timetable
constraints, it is acceptable to use the current month's forecast to prepare the Project
Report.
4.3 Timetable
The cost accounting system closes off on the last Friday of each month
The Forecast Report will have been prepared approximately two (2) weeks
earlier based on the previous month’s costs
4.4 Report Contents - Summary
The Business Unit Manager shall determine the contents of the Progress Report, as a
guide the report may include the following:
4.4.1 Section 1 - Overview
1.0 Narrative
4.4.2 Section 2 - Financial
2.1 Contract Valuation – refer to TCI-OPS-SP009 and TCI-ACC-SF077
2.2 Forecast Report – refer to TCI-OPS-SP007
2.3 Subcontractors/Supplier Commitments
2.4 Engineering/General Accruals
2.5 Progress Claims/Certificates
2.6 Projected Revenue
4.4.3 Section 3 - Contractual
3.1 Contractual General
3.2 Claims Status Report
3.3 Extension of Time (E.O.T.) log
Variations submitted
Variations approved
The Project Manager should include any information that may be of benefit to
the Company on future projects.
The Project Manager should also include any information that relates to
unresolved matters at completion, i.e. potential/existing defects, unapproved
variations, etc.
4.7 Final Report Guidelines
The Final Report is to be modelled on the Project Report (refer to Section 4.4 “Report
Contents – Summary”) and provide a complete overview of the Project.
The following is a guide to the preparation of the Final Project Report.
4.7.1 Section 1 - Overview
Include a detailed scope of work, project description, project staff, client/
consultant details, construction time. List major work items and quantities of
work performed. The overview should be of sufficient detail to allow a project
description marketing sheet to be prepared.
4.7.2 Section 2 - Financial
Include TCI-ACC-SF077 “Contract Valuation”, and Forecast Report, along
with summary overview of project items which impacted on the profitability or
otherwise of the project.
4.7.3 Section 3 – Contractual
Include the final Claims Status Report and detailed commentary on any matters
that remain unresolved. Sufficient detail should be included such that if the
Project Manager is assigned other duties at the completion of the project, the
remaining issues can be attended to by the Business Unit Manager. Include the
status of all subcontractors and supplies with regards to retention, final
releases, defects, etc.
4.7.4 Section 4 - Construction
Include a summary of project achievements, listing any details which may be of
benefit in preparing estimates, planning or performing similar projects.
The report should include a detailed list of the major subcontractors and
suppliers along with comments on their performance.
Detailed production studies or technical reports should be included on the
performance of plant and equipment, labour production rates, etc.
An "As Built" programme is to be included.
Temporary works design drawings are to be included.
6.0 ATTACHMENTS
At the end of each month, the financial status of a contract is reported by the preparation
of a Contract Valuation. Each valuation is prepared by the Discipline/Operations/
Administration Manager prior to final review by the Business Unit Manager.
The Contract Valuation relates to the Forecast Report for the month or quarter prior to the
month for which the Contract Valuation is being prepared. An explanation is required if
the profit reported on the Contract Valuation differs from the profit on the Forecast
Report. Failure to explain any difference can result in the Company being exposed to
heavy tax penalties.
The Contract Valuation form has been designed to reconcile the differences between
contract revenue and contract costs and is the means by which revenue and profit are
declared for the project and collected for Business Unit and Company discounts.
The Company policy is that no project profits are declared in the Company accounts until a
project is more than 20% complete on the basis of costs (called 20% threshold). The full
profit is then taken up in accounts over the last 80% of the project (measured on the basis
of costs).
If profit was released on a straight line, then the difference between this and declared profit
is referred to as the Deferred Apparent Surplus (DAS) i.e. profit that should be available
but is not taken up.
This Deferred Apparent Surplus is covered in the Overclaims section contained herein.
The Contract Net Profit (CNP) declared on the Contract Valuation form on a cumulative
to date basis is calculated accordingly:-
In summary, on a straight line basis the project when 31% complete should have produced
189 profit (.31 x 611). The Company declared 84 using the 20% threshold, and the
balance, 105, is treated as a Deferred Apparent Surplus in the Overclaims.
If a loss is being forecast, the full loss is brought to account in the Cumulative to Date
column and the DAS is Nil.
Base Tender Date The date on which the contract tender was submitted
Original Contract Completion The date for completion of the contract under the terms and
Date conditions of the contract at the Contract Award Date
Current Contractual The date for completion of the contract under the terms and
Completion Date conditions of the contract excluding the maintenance period,
including all approved extensions of time for variations, wet
weather etc.
Forecast/Actual Completion The assessment of the final completion date for the contract
Date recognising current overrun of time, future expected time
delays/savings. For completed contracts – the actual date of
completion
VALUATION
Revenue Variance On any contract where the difference between revenue and costs
is adequately explained through contract Underclaims or
Overclaims, the Revenue Variance is nil. If the Revenue
Variance is not nil, this indicates that the stated profit margin is
probably incorrect and needs to be reviewed.
UNDERCLAIMS Underclaims are to be detailed on the second page of the
Contract Valuation and are to include, without being limited to:
Materials on Site The value of all materials on site included in contract costs that
have not been invoiced to the client.
Effect of Unbalanced Bid The under recovered components of items within an unbalanced
bid from progress claims submitted to the client e.g.
mobilisation.
Work Completed not Claimed The value of all work in progress at month end and included in
the contract costs that was not invoiced to the client in the
monthly progress claims and will be billed in future claims and
the position of the an approved variations not agreed in principle
you expect to receive from the client
Contractual Claims The portion of the contractual claims upon which you are relying
to maintain your current forecast profit at completion. These
claims are known as valued claims and approval from the
General Manager is required to include them on the valuation.
The valued claims must not exceed the actual costs incurred in
performing the work that is in dispute.
RATION ANALYSIS
% of Time Completed Elapsed time in weeks from contract start date to the current
month as a percentage of the contractual time or completion.
% Claims to Date Total claims to date as a percentage of the revised contract value
total claim figure.
% Cost to Date Total contract costs to date as a percentage of the final contract
cost in the “Revised Contract Value” column.
% Profit to Date Contract net profit to date as a percentage of the final contract
net profit in the revised contract value column.
Gross Claims Total value of progress claims, including retention. This value
must equal “Sub Total Claim – Cumulative to Date” as shown on
the valuation.
Retentions Value of cash retentions retained by the client from progress
claims submitted
Received to Date Value of all cash received from the client to the end of the
calendar month for progress claims
Amount Contractually Due The value of outstanding progress claims which are contractual
due for payment from the client
Non Current Amount Value of progress claims submitted in previous months which are
Not Due not overdue for payment.
Current Claim Value of the current month’s claim less retention
Valuation at June 30 The total forecast revenue expected as at June 30 of the current
year as calculated on the Projected Revenue form.
COST ANALYSIS
Ledger Costs Cost to date as shown on the Selective Job Cost Summary Report
from the accounting system.
Manual Accruals Total costs accrued by the Project Manager. These accruals
represent the difference between the contract costs and the ledger
costs and must be detailed on an Accrual Journal which is to be
forwarded with the Contract Valuation
In addition to the detailing of Underclaims and Overclaims, the second page also requires
details to be provided for valued Contractual Claims as well as Unvalued Claims and
Insurance Claims. The information required is:
Value of claim
This information is to reflect the information provided in Section 3.2, Claims Status Report
of the Monthly Project Report. (Refer Section 370 of the Project Procedures Manual).