Wednesday, April 13, 2005

Project Spend Plan Reviews
COST+FEE=REVENUE

Cover Page
Check out Contract Value and Current Funding
Check out divisions involved
how much cost allocated to each
how much fee collected by each
sum of all Costs plus all Fees equals Total Revenue

Budget Analysis Page
Check out max fee per vehicle (labor, travel, ODC)
Check out Principal Investigator and POP Start and Stop Dates
Check out Revenue=Cost+Fee on Project to Date and Projected at Completion
Look at Funding-Revenue (or total costs) leaves "available funding to plan"
Look at funded value
Look at actual costs to date
Look at funding remaining
Execution:
Budget shows allocation of funds across labor, odc's, subs and materials
Planned shows what is planned to be spent in labor, odc's, subs and materials
Delta shows "available funding to plan" in labor, odc's, subs, and materials
Actuals shows what's been spent to date for labor, odc's, subs, and materials
Remaining shows what's left to spend for labor, odc's, subs, and materials
Under "Funded" the dollars remain in our bucket until we release funding to the sub
What ODCs are we billing for, and what materials have been purchased?
Labor Category Spendplan:
Actuals Portion = Hours burnt, cost, fee, and total revenue for those hours
Estimate At Completion = Hours estimated, cost, fee, and total revenue for those hours
EAC is driven by data from "Spend Plan - Value" (Staff Plan)
Estimate To Complete = Hours left to burn, cost, fee, and total revenue for those hours
ETC = EAC - Actuals