Question:
Where do the values on the Executive Dashboard come from?
Answer:
The values are a combination of amounts gathered from the Microsoft Dynamics SL tables, the Spitfire tables and on-the-fly calculations, as described in the following table. Note that calculations using previously gathered or calculated numbers are shown in italics.
Executive Summary
| Column | Explanation |
| Current Contract | = Current Contract – Committed PCO |
| Unapproved CO | = sum(xsfDocItem.RevenueAmount) where xsfDocHeader.status = pending% and xsfDocHeader.project = project; and DocType = PCO |
| EAC | = sum(pjptdrol.eac_amount) where acct = Expense Account Category Types |
| Actual + Committed | = sum(pjdtdsum.actual_amount + pjdtdsum.commit) for Expense account categories |
| Original Commitment | = sum(xsfDocItemTask.ExpenseAmount) where xsfDocHeader.status = committed for all of the Project’s Commitments |
| Approved CCO | = sum(xsfDocItemTask.ExpenseAmount) where xsfDocHeader.status = approved for all of the Project‘s Commitment Change Orders |
| Current Commitment | = sum of Original Commitment + Approved CCO |
| Approved Pay Request | = sum(xsfDocItemTask.RevenueAmount) where xsfDocHeader.status = approved for all of the Project‘s subcontract pay requests |
| Pending CCO | = sum (xsfDocItemTask.ExpenseAmount) where xsfDocHeader.status = pending for all the Project‘s Commitment Change Orders |
| Approved Pay Request | = sum(xsfDocItemTask.RevenueAmount) where xsfDocHeader.status = approved for all of the Project‘s subcontract pay requests |
| % Spent | = (Actual + Committed) / EAC |
| FAC | = sum(pjptsum.fac_amounts) for Expense account categories |
| BTD | = sum pjtran.amount when PJTRAN.acct = Billed-to-Date AcctCat from Project Controller Setup |
| Over/Under Billed | = Billed to date – Earned Income |
| Revenue Budget | = sum(pjptdrol.eac_amount) where acct = Revenue Account Category Types |
| Earned Income | = %complete * profit : detail IF Current Contract > Current EAC Budget THEN (CurrentContract * ( ActualExpense / CurrentEACBudget)) OTHERWISE (ActualExpense + (CurrentContract – CurrentEACBudget))) |
| Estimated Profit | = Contract – EAC |
| Backlog | = Current Contract – Earned Income |
| Net Cash Flow | = (Billed to Date + Less Open AR + Less Retention) – ((AP Cost to Date + Less Open AP + Less Retention) + (Actual + Commit to Date – AP Cash Out)) |
| Cash Conversion | = Open AR + AR Retention + Under Billed (if any) |
| Cash Funding | = Open AP + AP Retention + Over Billed (if any) |
| Net Cash Demand | = Cash Conversion – Cash Funding |
Additional Comments:
See KBA-01227 for more information on Execution Dashboard formulas.
KBA-01401; Last updated: November 10, 2016 at 11:41 am;