Construction WIP
The Construction WIP dashboard for Acumatica is an executive view of work in progress performance across construction projects. It compares revised contract value, estimated and projected costs, actual costs and billings, earned revenue, and gross profit percentages. Use it to monitor project profitability, identify underbilled projects, and highlight jobs at risk of projected cost overruns. The KPI row summarizes the selected portfolio through the chosen actuals period, while the charts below shift the focus to individual projects.
How to use the construction WIP dashboard
- Review total contract value and projected cost to understand the scale and expected cost of the selected project portfolio.
- Compare actual cost, billing, and earned revenue to evaluate current project progress and revenue recognition.
- Monitor gross profit percentages to see which projects are performing best and whether profitability is tracking as expected.
- Identify underbilled projects and projected cost overruns to find jobs that may require corrective action.
Filters
Use the filtering panel at the top of the Construction WIP dashboard to control which data is shown. The filters apply to all views and ensure the dashboard reflects the selections you choose.
Key performance indicators (KPIs)
The key performance indicators (KPIs) at the top of the dashboard show contract value, cost, billing, and profitability for the selected projects, and update based on the filters you apply.
| KPI | What it measures |
|---|---|
| Revised Contract | Total revised contract value for the selected projects, including approved contract changes. |
| Revised Estimated Cost | Total revised estimated cost for the selected projects. |
| Projected Cost | Total expected cost at completion based on current projections. |
| Actual Cost to Period | Total actual project cost recorded through the selected actuals period. |
| Actual Billing to Period | Total amount billed through the selected actuals period. |
| Earned Revenue | Total revenue recognized based on project progress through the selected period. |
| Projected Gross Profit % | Expected gross profit percentage based on revised contract value and projected cost. |
| Actual Gross Profit % | Gross profit percentage based on earned revenue and actual cost through the selected period. |
Visual components
| View name | Type of view | What it shows |
|---|---|---|
| Earned Revenue vs Billing To Period | Stacked Bar | Compares earned revenue with billed amounts by project to identify billing differences. |
| Top 10 Underbilled Projects | Horizontal Bar | Highlights projects where earned revenue exceeds billing by the greatest amount. |
| Top 10 Projects by Gross Profit % | Horizontal Bar | Ranks projects with the highest gross profit percentage. |
| Top Projected Cost Overruns | Horizontal Bar | Identifies projects expected to exceed cost budgets by the largest amount. |