Grace Design Studios · Module 9 of 12

Quick Reference · Managing Execution 2: Leading with Data

Job aid. The 8 steps of the monthly review, the numbers and how to get them, the 3 states, the 4 recovery levers, billing and collections, the weekly check, and a BST Dashboard Explainer. Keep it open at the prebill.

What to doWhat to watch out forWhat to avoidThe numbersThe 3 statesThe 4 leversThe weekly checkBST Dashboard Explainer

Module Home  ›  Quick Reference

What you need to know

Run the monthly review on every phase before the prebill. Steps 1 to 5 find where the phase is and how it will finish. Steps 6 to 8 bill, collect, judge the phase, and plan the next month.

Update the Estimated Hours before you read any other number. Percent complete, Revenue, the invoice and the forecast all come from them. Effort to date divided by the Budget Effort measures only money spent.

Name the state, then do its response this month. Off track goes to the PIC as a recommendation. At risk goes on next week’s PM Plan as a Priority.

Effort is cost. Your target effort is the Budget Effort less your profit goal. A $280,000 phase at a 20 percent goal has a target effort of $224,000.

Print the Monthly Review Field Resource (PDF) for the whole review on one sheet, front and back.

THE MONTHLY REVIEW, BEFORE EVERY PREBILLVIDEO 9A · POSITION AND FORECAST1CompareEffort to date2AssessThe work done3Estimated HoursWith the team4Estimated EffortThe total5Percent completeThen forecastVIDEO 9B · BILL, COLLECT, ACT6BillTo percent complete7Check the ARDay 45 ask, day 60 callJudge the stateThen pick the lever8Plan the monthSchedule it in BSTEvery week. Compare the hours, check the work, read Hours Remaining.
8 steps, every month, before the prebill. The first 5 give you the position and the forecast. The last 3 turn them into action. The weekly check finds problems between reviews.
What to do

Seven actions. Do them in this order at each monthly review.

What to do

  1. Update the Estimated Hours with the team, person by person. You make sure the hours are updated by working with the Project Accountant.
  2. Calculate percent complete as Effort to date ÷ Estimated Effort. Use that number for Revenue, the invoice and the forecast.
  3. Compare Estimated Effort with the target effort and the Budget Effort. That comparison is the forecast.
  4. Ask the Project Accountant to update EAC when it differs from Estimated Effort by a large amount. Do it before the prebill.
  5. Bill every month to percent complete. Subtract the total billed to date.
  6. Make the specific ask at day 45 and the call at day 60, with the PIC aware.
  7. Schedule next month’s hours in BST with the Project Accountant, then tell the team the plan.
What to watch out for

Seven warning signs. You can find each one on the PM dashboard or in the weekly check.

What to watch out for

What to avoid

Seven habits that seem helpful but cause problems.

What to avoid

The numbers

Each number, how you get it, and the Oakhaven DD value from the videos.

NumberHow you get itOakhaven DD
Budget EffortThe contract fee for the Task. Grace says fee. BST records it as Budget Effort.$280,000
Target effortThe Budget Effort less your profit goal. It has no column on the dashboard.$224,000
EffortThe burdened dollar value of the hours charged. The average direct labor rate times a uniform overhead ratio, so Effort is cost.$112,000 to date
Estimated HoursHours to date plus hours to finish, person by person, from the team.From the team
Estimated EffortEstimated Hours × rate. The total effort the phase will use. Your working forecast.$280,000
EACThe accounting value BST uses to recognize revenue. The Project Accountant updates it from Estimated Effort.$224,000, 25 percent low
Percent completeEffort to date ÷ Estimated Effort.40 percent
RevenuePercent complete × Budget Effort. The Budget Effort earned to date.$112,000
Effort RemainingBudget Effort minus Effort to date. The Budget Effort that is left.$168,000
Effort Performance IndexRevenue ÷ Effort. 1.0 is break even. The plan is 1.25 at a 20 percent goal. Add it as a column.1.00
InvoicePercent complete × Budget Effort, minus the total billed to date.$28,000
Percent complete = Effort to date ÷ Estimated Effort
The 3 states

Judge the phase before step 8. Each state has a test and a response.

StateTestResponse
On trackEstimated Effort is at or below the target effort, and the work due is done.Continue with the plan.
At riskThe forecast profit is below the plan, and at or above the margin floor in your Module 5 plan. Or the weekly check shows an early warning.Work the recovery levers. A gap you can close goes on next week’s PM Plan as a Priority.
Off trackThe forecast profit is below the margin floor, a milestone was missed, or Estimated Effort is above the Budget Effort.Update the forecast and size the gap. Take a recommendation to the PIC with the situation, the options, your recommendation and the first action.
The 4 recovery levers

Use them in this order. Each lever applies to a different cause.

LeverUse it whenExample from the module
1 · Close the open decisionA client or internal decision holds up the work or causes redraws.Pinewood DD. The board has not approved the finish palette.
2 · Rework the resource planSenior staff do work that a lower cost role can do well.Oakhaven DD elevations. Magnolia CD wall sections.
3 · Re scope the remaining workThe remaining work does not fit the remaining Budget Effort after levers 1 and 2.Agree the new scope with the PIC first.
4 · Price the changes to the scopeScope changes cause the problem.Module 10
Bill and collect

You control the time from earned work to invoice. Grace’s collections protocol is in the Module 3 AR Guide.

WhenActionWho
Every monthBill to percent complete.Project Manager
Unbilled Days above 30Earned work waited more than one billing cycle. Bill it now.Project Manager
Day 45Make the specific ask to the client.Project Manager
Day 60Call the client, with the PIC aware.Project Manager
After the invoiceFollow up with the client’s accounts payable team.Accounting
Days to cash = Unbilled Days + Receivable Days
The weekly check

Run it yourself first, then take the gaps to the weekly project team meeting.

HoursWorkWhat it means
On planDoneThe week went to plan.
On planBehindLess progress per hour than the plan assumed. An early warning, so the phase is at risk.
Under planBehindThe staffing is short, or the work started late.
Hours Remaining = Estimated Hours minus hours to date minus hours scheduled to finish

Hours Remaining stays at zero when the team works to the schedule. Below zero, decide if the work needs more Estimated Hours or if future scheduled hours can come out. Make the change with the Project Accountant.

BST Dashboard Explainer

A recreation of the BST PM dashboard with Oakhaven DD selected. Choose a field, or click a column name or a panel title, to see what it shows, how to read it, and the step that uses it.

Before the prebill
If you cannot name the state of the phase, the review is not complete. Update the Estimated Hours, read the forecast, and name the state before the invoice goes out.