The reports and the views that matter
You will be able to: Choose the report that answers a given management question; Read the Home and portfolio tiles; Know which report reads postings and which reads snapshots.
- Read not done yet
- Self-check: not taken not done yet
- Lesson complete not done yet
Zeyto Construction & Contracting has eleven project reports, in three groups. They read postings and records; they do not change anything. Choose the report by the question, not by the title.
| Question | Report | What it shows |
|---|---|---|
| Which project is losing money? | Project Profitability | Contract value, budget, committed, actual, forecast and margin per project |
| Which nature will overrun? | Cost to Complete | Budget, committed, actual and ETC per nature; negative variance is an overrun |
| Are we over- or under-billed? | Work in Progress (WIP) | The latest snapshot of each project: billed against earned |
| Who holds our money? | Retention | Retention held from the client and held back from subcontractors, releases, next due |
| What must we buy? | Material Status | Per material: BOQ, requested, ordered, received, reserved, consumed and short |
| Are we paying above the BOQ rate? | Purchase Price Variance | Each purchase against the BOQ rate, last price and average; negative extra cost is a saving |
| Is this supplier reliable? | Delivery and Inspection | Days late, pass percent, rejected quantities and NCRs per delivery |
| Which subcontract needs chasing? | Subcontract Status | Value, certified, retention held, to certify, expired papers |
| How many hours did we use? | Manpower | Timesheet hours and gate check-in hours by project and month |
| Is plant idle? | Equipment Utilisation | Worked, standby and breakdown hours, and charge-out |
| How safe are we? | Health and Safety | Incidents, lost time, man-hours, frequency rate, permits, toolbox talks |
Two of these read snapshots. The WIP report shows the latest snapshot of each project, written when the monthly revenue run is posted, so run the revenue first. The others read the ledger and the registers as of the date you set.
Home and the portfolio
The Home screen has tiles for the numbers a director asks first. Clients owe us adds the unpaid progress bills of all projects and shows what is more than 30 days late. The portfolio board shows every project as a colour tile with its earned value table and a button to open the tab you need. Press the red chip to keep only red projects.
Schedule views are inside each project: the Gantt, the task board, the look-ahead of the next weeks and progress entry. The S-curve and the map are inside the schedule. They help the project manager, but the accountant should read the cost and billing views in this module.
Walk it through
- Match three management questions of your own to reports.
- Run the profitability, cost to complete and WIP reports for the same date and list any contradictions.
- In the demo, open the Reports list and find the project reports.
Public demo company, sign in as admin / demoAdmin123. Data refreshes nightly.
- Choose the report by the question.
- WIP reads snapshots; run the revenue first.
- Read profitability, cost to complete and WIP as a set.
Check yourself
4 questions on this lesson. Not timed, not the exam, and you can try again. Score 60% or more, and read the lesson, to complete it.