Tools · Excel template

Cost Control Dashboard

An Excel workbook that turns your WBS budget, monthly progress, actuals, commitments, changes and risks into earned value KPIs, a cost report, a cash flow forecast and a contingency view, ready for the monthly cost report.

Get the templateSee the preview

Microsoft Excel 2010 or later. No macros. Includes a blank template and a demo file with sample data.

Cash Flow and Commitments dashboard from the demo file, with monthly spend columns and cumulative curves
What's inside

Four dashboards, six input sheets.

Paste your data into the yellow input cells. The calculation sheet does the rest, and every dashboard fits one landscape A3 or A4 page for printing.

01

Overview

Headline KPIs, S-curve with forecast to EAC, budget by cost type, budget vs EAC by cost area, and CPI and SPI trend.

02

Cost Report

Cost-area summary and a full WBS cost report: BAC, PV, EV, AC, committed, invoiced, CPI, SPI, ETC, EAC and VAC.

03

Cash Flow & Commitments

Monthly actual and forecast spend with cumulative curves, committed vs invoiced by cost area, and the top commitments.

04

Changes & Risks

Approved and pending changes, contingency drawdown, contingency cover against open risk exposure, and the top open risks.

05

Input sheets

Settings, WBS, Monthly Data, Commitments, Change Log and Risk Register. Dropdowns keep cost areas, types and statuses consistent.

06

Works with your ERP

Export from SAP, Oracle, Primavera or similar to Excel and paste the rows into the input sheets.

Preview

Screens from the demo file.

The demo file uses a fictitious gas processing project. All project, client and vendor names and figures are illustrative.

Cost Report summary by cost area with budget, earned value, actual cost, CPI, SPI, ETC, EAC and VAC
Cost ReportSummary by cost area, with CPI and SPI colour-coded against your thresholds.
Cash Flow and Commitments dashboard
Cash Flow & CommitmentsActual spend to the data date, forecast spread to completion, and the commitment position.
Changes and Risks dashboard with contingency versus risk exposure
Changes & RisksContingency remaining against open risk exposure, changes by status, and the top open risks.
Earned value built in

Standard formulas, clearly documented.

Every formula is explained on the Instructions sheet. Choose the ETC method in Settings, or override ETC per WBS line with a bottom-up re-estimate.

CPI · SPIEV ÷ AC and EV ÷ PV, with green, amber and red thresholds.
ETC · EACCPI, CPI × SPI or budget-rate method. EAC = AC + ETC.
VAC · TCPIVariance at completion and the CPI needed on the remaining work.
Contingency coverRemaining contingency ÷ open risk exposure.
Details

What you get.

One download with two workbooks.

Included

  • Blank template, ready for your project
  • Demo file with a complete sample project
  • Instructions sheet with a quick start and monthly update routine

Capacity & requirements

  • 60 WBS lines, 10 cost areas, 5 cost types
  • 36-month calendar
  • Microsoft Excel 2010 or later, no macros

Get the Cost Control Dashboard.

Send an email to order the template, or to ask a question before you buy.

Email to order
Built by Rahmat Ilham Zazzali, PMP®, CCP®, a senior cost engineer and project controls professional.