Page tree
Skip to end of metadata
Go to start of metadata

Multiple cost reports can be created to customize cost reports based on project type, customer segmentation or other specific reporting needs. The cost report is generated based upon the Cost Report Name drop down menu on the Report Criteria. All transactions charged to a project will appear in the cost summary report irrespective of whether it is associated with a cost element.

Summary Tab

Name the cost report with a title that is meaningful to the end user, and give a description that provides further detail as to the purpose of the report.


Examples of cost reports that may be meaningful to an organization could include the following and are illustrated further at the end of this document:

  • Default standard cost report - This would apply to most billable projects
  • Non-billable charges - This would apply to non-billable projects to capture the full value or fully burdened costs of non-billable efforts
  • Project Profit - Summary of overall profitability of billable projects, including indirect costs
  • Revenue Analysis - To run analysis based on actual vs. billable values, or cost plus rate comparisons
  • Unmapped - Find and identify those costs that are unmapped

Report Elements Tab

Labels can also be specified for each report item, and can be used as column headers. To ensure the report is not too wide to fit on the screen, it may helpful to use abbreviated or multiple words in the report item label to allow wrapping rather than a single word, i.e. ‘Sub Contractor’ rather than ‘Subcontractor’.

Note that Actual and Budget Formulas that can be created. The Budget Formula uses the fields on the Project Profile tab.



10.0 Element Name
(red - items new for 10.0)
Based OnMapped
To Cost Element
Billable
Project Type
FormulaExamples for usage
Actuals Fee Calculation MethodTime / Expense YesYesFee Formula
w/ Rate from Search

Bill::[Labor Cost Element]TimeYesBothBill::Billable::[Labor Cost Element]
+ Bill::Non-Billable::[Labor Cost Element]

Bill::[ODC Cost Element]ExpenseYesBothBill::Billable::[ODC Cost Element]
+ Bill::Non-Billable::[ODC Cost Element]

Bill::Billable::[Labor Cost Element]TimeYesYesDiluted Bill Rate * Hours
Bill::Billable::[ODC Cost Element]ExpenseYesYesAmount * Markup
Bill::Billable::Unmapped ExpenseExpenseNoYesAmount * Markup
Bill::Billable::Unmapped LaborTimeNoYesDiluted Bill Rate * Hours
Bill::Non-Billable::[Labor Cost Element]TimeYesNoDiluted Bill Rate * Hours
Bill::Non-Billable::[ODC Cost Element]ExpenseYesNoAmount * Markup
Bill::Non-Billable::Unmapped ExpenseExpenseNoNoAmount * Markup
Bill::Non-Billable::Unmapped LaborTimeNoNoDiluted Bill Rate * Hours
Bill::Unmapped ExpenseExpenseNoBothAmount * Markup
Bill::Unmapped LaborTimeNoBothDiluted Bill Rate * Hours
Cost::[Indirect Cost Element]Time / Expense YesBothIndirect Cost Formula
Cost::[Labor Cost Element]TimeYesBothDiluted Cost Rate * Hours
Cost::[ODC Cost Element]ExpenseYesBothAmount
Cost::Billable::[Indirect Cost Element]Time / Expense YesYesIndirect Cost Formula
Cost::Billable::[Labor Cost Element]TimeYesYesDiluted Cost Rate * Hours
Cost::Billable::[ODC Cost Element]ExpenseYesYesAmount
Cost::Billable::Unmapped ExpenseExpenseNoYesAmount
Cost::Billable::Unmapped LaborTimeNoYesDiluted Cost Rate * Hours
Cost::Non-Billable::[Indirect Cost Element]Time / Expense YesNoIndirect Cost Formula
Cost::Non-Billable::[Labor Cost Element]TimeYesNoDiluted Cost Rate * Hours
Cost::Non-Billable::[ODC Cost Element]ExpenseYesNoAmount
Cost::Non-Billable::Unmapped ExpenseExpenseNoNoAmount
Cost::Non-Billable::Unmapped LaborTimeNoNoDiluted Cost Rate * Hours
Cost::Unmapped ExpenseExpenseNoBothAmount
Cost::Unmapped LaborTimeNoBothDiluted Cost Rate * Hours
Hours::[Labor Cost Element]TimeYesBothHours
Hours::Billable::[Labor Cost Element]TimeYesYesHours
Hours::Billable::Unmapped LaborTimeNoYesHours
Hours::Non-Billable::[Labor Cost Element]TimeYesNoHours
Hours::Non-Billable::Unmapped LaborTimeNoNoHours
Hours::Unmapped LaborTimeNoBothHours
Revenue::Additional ItemsOne time invoice chargesNoYes

Revenue::CPBillable Costs + FeeYesYesCosts + Fee
(w/Rate from Billing Setup)

Revenue::Fee Cap AdjustmentsCalculated Fee + Fee CapYesYes

Revenue::FPFP itemsNoBothFP revenue rules
Revenue::Funding Cap AdjustmentsCalculated Revenue + Funded Value Cap BothYes

Revenue::Gross (before write-offs and adjustments)




Revenue::TM LaborTimeBothYesDiluted Bill Rate * Hours
Revenue::TM ODCExpenseBothYesAmount * Markup
Revenue::Total




Revenue::Write-offs




Total Mapped::CostTime / Expense / Indirect CostsYesBoth

Total Mapped::Indirect CostTime / ExpenseYesBoth

Total Mapped::Labor BillTimeYesYesDiluted Bill Rate * Hours
Total Mapped::Labor CostTimeYesBothDiluted Cost Rate * Hours
Total Mapped::Labor HoursTimeYesBothHours
Total Mapped::Other Direct BillExpenseYesYesAmount * Markup
Total Mapped::Other Direct CostExpenseYesBothAmount

 

The tags available for creating Actuals formulas include the following primary categories (the primary categories are identified by the first segment of the tag name):

  1. Bill – Calculated as hours times bill rate for labor transactions and cost times (1 + markup) for expense transactions for any transactions where the labor rate and/or markup have been specified. This value is calculated for all billing types. For TM billing types, it will equal the amounts used to determine revenues for billable transactions, but is also calculated for non-billable transactions and can be used to highlight the opportunity cost related to non-billable transactions. For FP and CP billing types, the amount can be used as a goal value that can be compared to revenues generated (e.g. compare target bill value to revenue earned on FP projects). 
  2. Cost – Include the direct cost amounts associated with transactions and indirect costs calculated on those costs based on Indirect Cost Rate selected when you run the report.
  3. Hours – Actual hours charged to the project.
  4. Report – Values calculated in other rows in the report.
  5. Total Mapped – Total Bill, Cost, and Hour amounts across all cost elements broken out by cost element type (Labor, Other Direct and Indirect). These are there to make it easier to set up certain reports where you do not need to break out by cost element. They will return the same values as the corresponding “Total” tags in 9.6. They do not include Unmapped amounts (see below for discussion of Unmapped).
  6. Actuals Fee Calculation Method – Fee that would be earned on the project based on the Fee Method(s) set up for the project and the costs calculated in the report using the Indirect Cost Rate selected when you run the report. This does take into account any Fee Caps.  
  7. Revenue – Revenues calculated based on transactions included in the report. Values calculated for these tags include values calculated by the billing post plus revenue values that would be calculated by the billing post for transactions included in the report that have not yet been included in a billing post. The categories include:
    1. CP (Gross) – Revenue earned on CP projects based on the Indirect Cost Rate specified in Admin > Setup > Cost Structure > Indirect Cost Rates without regard to any adjustments or write-offs.
    2. FP (Gross) – Revenue earned on FP projects or tasks without regard to any adjustments or write-offs.
    3. TM Labor (Gross) – Revenue earned on Labor transactions on TM projects or tasks without regard to any adjustments or write-offs.
    4. TM ODC (Gross) – Revenue earned on ODC transactions on TM projects or tasks without regard to any adjustments or write-offs.
    5. Additional Items – Revenue earned based on Additional Items included in invoices.
    6. Gross (before adjustments and write-offs) – The sum of (a) through (e) above.
    7. Fee Cap Adjustments – Adjustments necessary to bring fee amount recognized in the CP (Gross) amount down to the maximum fee specified for the fee method in the project.
    8. Funding Cap Adjustments – Adjustments necessary to reduce revenue recognized at the project or task level down to the funded value specified for those projects or tasks where the Limit Revenue to Funded Value Less Fixed Fee checkbox is checked. Note that Additional Items are not considered in this calculation.
    9. Write-offs – Write-offs taken on invoices.
    10. Total (Net) – The sum of (f) through (i) above.

 

The Bill, Cost and Hours primary categories are broken out into the following sub-categories:

  1. Billable – Represents transactions charged to a billable project type.
  2. Non-Billable – Represents transactions not charged to a billable project type.
  3. Blank – Represents the total of the billable and non-billable amounts.

Note that non-billable direct costs included in the report will also have indirect rates applied as defined in the Cost Structure setup. The setup of a non-billable cost report give an organization visibility into the true total cost of non-billable items and into the theoretical billable value of those efforts.


The Bill, Cost and Hours primary categories are also broken out by cost element as follows:

  1. Bill – Broken out by Labor, Other Direct cost element types.
  2. Cost – Broken out by Labor, Other Direct and Indirect cost element types.
  3. Hours – Broken out by Labor cost element types.

In addition to the breakdown by cost element, the Bill, Cost, and Hours primary categories and subcategories transactions that are not related to a cost element are categorized into Unmapped Labor and Unmapped ODC buckets to assure that all costs charge to a project are reflect in the cost reports. NOTE: since all of the indirect rate calculations are based on cost elements, no indirect cost are associated with the unmapped direct costs.


Cost Report Examples

Default or Standard cost report - This would apply to most billable projects.

Non-billable charges - This would apply to non-billable projects to capture the full value or fully burdened costs of non-billable efforts.

Project Profit - Summary of overall profitability of billable projects, including indirect costs.

Revenue Analysis - To run analysis based on actual vs. billable values, or cost plus rate comparisons.

Unmapped - Find and identify those costs that are unmapped.


Additional Information

Help Docs - Cost Summary and Status Report

Help Docs - Cost Reports


  • No labels