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