Project Financial Analytics - APIs - V1 - Work-In-Progress (WIP)
API Name: CoreconAPI_WIP
Important Things To Know
- The WIP Analysis dashboard is normally used for Fixed Lump Sum and Unit Price Contracts not Cost Plus.
- Original Cost and Contract Budgets are entered within the Prime Contract form.
- Approved Change Order (CO) Budgets are added to the Original Prime Contract Budgets (aka Revised Budgets).
- Cost Budgets are extremely important for WIP otherwise all calculations will be off.
- Procurement and Time Tracking transactions marked as 'Pending' or 'Not Approved' are not included in this dashboard.
- Start and End Date should be blank when viewing WIP for inactive or completed projects. However, a cutoff or end date (e.g. 31-Mar-2022) can be used for active projects.
API Fields
- ProjectId
- ProjectNumber
- ProjectTitle
- ProjectBidContactName
- ProjectSalesContactName
- ProjectPMContactName
- ProjectEstStartDateUtc
- ProjectEstStartDateOrgLocal
- ProjectEstFinishDateUtc
- ProjectEstFinishDateOrgLocal
- PrimeContractId
- PrimeContractNumber
- PrimeContractSubject
- PrimeContractIssueDateUtc
- PrimeContractIssueDateOrgLocal
- PrimeContractStatus
- PrimeContractApprovalDateUtc
- PrimeContractApprovalDateOrgLocal
- PrimeContractBillingType
- PrimeContractBillingTypeValue
- OwnerCompanyName
- OwnerContactName
- ContractorCompanyName
- ContractorContactName
- PrimeContractEstStartDateUtc
- PrimeContractEstFinishDateUtc
- PrimeContractEstStartDateOrgLocal
- PrimeContractEstFinishDateOrgLocal
- RevenueBudget_Revised_Subtotal
- RevenueBudget_Revised_Total
- PrimeInvoice_Approved_GrossTotal
- PrimeInvoice_Approved_Total
- CostBudget_Revised
- CommittedCost_Approved_Subtotal
- CommittedCost_Approved_Total
- CostToDate_Approved_GrossTotal
- CostToDate_Approved_Subtotal
- CostToDate_Approved_Total
- CashFlow_Approved_Total
- Percent_Invoiced_Gross = ([PrimeInvoice_Approved_GrossTotal] / [RevenueBudget_Revised_Subtotal]) * 100
- Percent_CostToDateCostBudget_Gross = ([CostToDate_Approved_GrossTotal] / [CostBudget_Revised]) * 100
- Percent_CostToDateCommittedCost_Gross = ([CostToDate_Approved_GrossTotal] / [CommittedCost_Approved_Subtotal]) * 100
- Percent_Profit_Margin_Total = ([CashFlow_Approved_Total] / [RevenueBudget_Revised_Total]) * 100
Fixed Lump Sum and Unit Price Contracts
- EarnedRevenue_CostBudget_Gross = [RevenueBudget_Revised_Subtotal] * [Percent_CostToDateCostBudget_Gross]
- EarnedRevenue_CommittedCost_Gross = [RevenueBudget_Revised_Subtotal] * [Percent_CostToDateCommittedCost_Gross]
- Billing_Over_CostToDateCostBudget = IF [PrimeInvoice_Approved_GrossTotal] > [EarnedRevenue_CostBudget_Gross] THEN ([PrimeInvoice_Approved_GrossTotal] - [EarnedRevenue_CostBudget_Gross]) ELSE 0
- Billing_Under_CostToDateCostBudget = IF [PrimeInvoice_Approved_GrossTotal] < [EarnedRevenue_CostBudget_Gross] THEN ([EarnedRevenue_CostBudget_Gross] - [PrimeInvoice_Approved_GrossTotal]) ELSE 0
- Billing_Over_CostToDateCommittedCost = IF [PrimeInvoice_Approved_GrossTotal] > [EarnedRevenue_CommittedCost_Gross] THEN ([PrimeInvoice_Approved_GrossTotal] - [EarnedRevenue_CommittedCost_Gross]) ELSE 0
- Billing_Under_CostToDateCommittedCost = IF [PrimeInvoice_Approved_GrossTotal] < [EarnedRevenue_CommittedCost_Gross] THEN ([EarnedRevenue_CommittedCost_Gross] - [PrimeInvoice_Approved_GrossTotal]) ELSE 0
Cost Plus with or without GMP Contracts
- EarnedRevenue_CostBudget_Gross = PrimeInvoice_Approved_GrossTotal
- EarnedRevenue_CommittedCost_Gross = PrimeInvoice_Approved_GrossTotal
- Billing_Over_CostToDateCostBudget = 0
- Billing_Under_CostToDateCostBudget = 0
- Billing_Over_CostToDateCommittedCost = 0
- Billing_Under_CostToDateCommittedCost = 0