Project Costing in Unanet Version 9.3

Instructional Guide

Version 1.7

Table of Contents

Overview of this document

Why is project costing important?

Direct and Indirect Costs and Calculation of Pool Rates

Unanet support for direct and indirect cost reporting

Project Costing Setup

Setup Cost Structure

Setup Cost Report

Project and Person Setup

Project Cost Reporting

Glossary for Project Costing

Frequently Asked Questions

Alternate Cost Structure Examples:

Overview of this document

Project Costing in Unanet Version 9.3 enables users to report on the fully burdened costs associated with their projects. These burdened costs are calculated in real-time within Unanet using the indirect pool rates provided by an external accounting system or other outside application. This document first describes why organizations need to trackand report on direct and indirect project costs, and how Unanet supports these concepts. A detailed Glossary is included at the end of this document as well as different examples of cost structures.

Why is project costing important?

Many services organizations need to see the true project costs, taking into account allocation of costs from overhead activities and other costs not specifically identifiable with a single project. This is especially true for government organizations working on cost plus type projects, but time & materials and firm fixed price projects sometime require separate reporting of these costs too.

Key customers have identified the following benefits of project costing in Unanet:

  • Provide project managers with the tools they need to report on fully burdened costs (direct and indirect) in real time, so that actuals can be compared with budget and funded amounts.
  • The ability to generate reports in real-time will drive more timely data capture and thus improve DCAA compliance. Without this functionality, project managers have to wait for reports from their accounting system which may be weeks or even months late.
  • It provides additional leverage for training the project/program managers and pushing accountability to them.
  • Report formats and usage are familiar and easier to use for project staff than accounting system
  • Forward visibility of under or over performance is particularly key for fixed price contracts to see costs versus billings as funded amount, and contract end, is approached.
  • A real-time future view of project spend as resource loading and project plans change will be valuable.
  • This functionality allowsUnanet to be used for project estimating and pricing on government contracts, avoiding the need for third party tools.
  • Plans and budgets are integrated with detailed actual costs in one system.
  • Deliver project costing information outside the finance department
  • By providing improved information to program management, faster resolution of potential problems will be achieved. As with other Unanet reports all information is presented based on real-time data.
  • Accounting will not have the burden of producing Job Summary Reports (JSR) and other project costing information for managers, saving time or avoiding the need for project managers to have access to the accounting system
  • System specific:
  • Accounting systems typically used by smaller government contractors do not provide Project Costing Reports. Using Unanet to provide this capability removes a driver for them to go through a complex and costly migration from their existing accounting system.
  • Three sets of indirect cost rates are supported; Target, Provisional and Actual, providing additional reporting options and planning flexibility compared with many accounting systems which only offer two rates.Note:Unanet does not calculate the rates but uses calculated rates from other systems.
  • There is no limit on the number of cost structures or indirect cost elements. Some systems have limitations such as only seven pools, and the inability to accurately calculate rates from multiple cost structures.
  • Unanet allows a descriptive label to be specified as well as an account number for a cost element. This improves ease of use over systems that assume that the user understands that 39 means Direct Labor, 51 means Subcontractor etc.

Direct and Indirect Costs and Calculation of Pool Rates

Any cost that can be specifically identified with a project is known as a direct cost, for example hourly salary cost, or Other Direct Costs such as travel or materials. However the performing organization incurs other costs which cannot be tied directly to a single project and these costs need to be grouped so that they can be distributed appropriately across each project. These are known as indirect costs. Examples of indirect costs are:

  • fringe benefits,
  • overhead, and
  • general and administrative (G&A)

These indirect costs for the whole organization will be grouped in similar cost pools, and their total calculated. A base is needed for distributing indirect costs to their final cost objectives and this is known as an allocation base. Dependent on the type of indirect cost, different allocation bases might be used. Fringe would typically be allocated based on total labor cost (including direct project and all other non-project work), for example.

For example, ifthe total fringe pool costs were $1,100,000, and the allocation base of total labor costs for the organization was $3,200,000, then the Fringe Rate would be 34% (Fringe/Base). This percentage would be multiplied by the project’s labor casts to calculate the fringe burden for that project.

Fringe benefits typically include:

  • Employer federal, state and local payroll taxes
  • Workers compensation
  • Holidays, vacations and sick or lost time
  • Jury duty, military or bereavement
  • Medical, dental and vision
  • Life insurance
  • Short and long-term disability
  • Stock incentive options
  • Company contributions to 401(k)
  • Bonuses (if applicable to all employees)

Expenses, known as Overhead, associated with assisting direct labor employees in doing their jobs, typically include the following items:

  • Communications/telephone
  • Training
  • Recruiting
  • Travel expenses (unless allocated to the project as ODC)
  • Utilities
  • Depreciation of buildings and equipment
  • Licenses and fees
  • Computer equipment and maintenance
  • Office supplies
  • Postage and shipping

Note: The allocation base for Overheard will typically be the total labor and fringe costs.

General & Administrative expenses (G&A) typically include:

  • Executive management
  • Finance and Administration
  • Sales and marketing
  • Human resources
  • Information technology
  • Professional fees
  • Bid & proposal efforts

Note: the commonly accepted base for allocating G&A expenses is total costs, including direct costs (labor and ODC), fringe, and overhead.

Other indirect pools may be established dependent on the organization’s accounting system. However, the organization should already fully understand these concepts and their desired cost structures before attempting to configure Unanet. If not, they should work with their auditors or other financial consultant to establish their policies and procedures.

For reference, a typical indirect cost structure and associated rates for government contractors are shown below.

35% Fringe – calculated as Rate x Labor

60% Overhead – calculated as Rate x (Labor + Fringe)

14% General & Administrative – calculated as Rate x (Labor + Fringe + Overhead + ODC)

Organizations that have many staff working on client site would typically have lower overhead.

Unanet support for direct and indirect cost reporting

In order to enable total cost reporting:

  • Fiscal Years, Cost Elements (Labor and Other Direct Costs (ODC)) and Cost Structures must be established. This will be entered by a Unanet Administrator
  • Projects must be associated with cost structures. Project’s cost structure defines the ODC tracked for the project. Other information entered against the Project include Billing Type, Feeand various budgeted amounts for comparison with actuals.
  • Define which labor charges should be tracked for the project. Default Labor Cost elements can be entered for each person and/or overridden on the assignments that govern the person’s work on the project.

The completion of these steps ensures that all incurred and projected direct project costs can be tracked correctly. Detail reports included with the Project Costing module will show the project’s direct cost distribution by cost elements.Note:Unanet does not calculate the rates but uses calculated rates from other systems.

Project Costing Setup

  1. First, a Unanet Administrator defines Cost Elements. Three types are specified; Labor, Other Direct Costs and Indirect Costs

  1. Fiscal Year definitions must be established. They will be used to set up Indirect Cost rates. Rates apply for a whole Fiscal Year and so these are used on the reports where Indirect Costs are calculated. Accounting calendars can additionally be specified to reflect ‘accounting months’ or other periods rather than calendar months, and these accounting periods can be used in reporting throughout the system.

Setup Cost Structure

  1. Cost Structures must have a unique name and optionally may have a description.

  1. You canassign Labor Cost Elements to your Cost Structure.

  1. You can associate Expense Types with ODC Cost Elements in your Cost Structure.Note: Expenses entered before this association was created will not automatically appear on Project Costing reports. If there are historic actual expenses you wish to include in project costing reports, contact Unanet Support for a script which will update your historic expense actuals with the ODC-Expense Type mapping.

  1. You can establish the rules (or formulas) for calculating Indirect Costs for you structure. A typical, simple example is shown below for Fringe, Overhead and G&A.

  1. You can enter Indirect Cost rates for your structure and specify when the Actual Rates were last calculated. This date is shown on report headers when Actual Rates are used so that it is clear if the rates are current, as Actual Rates may change significantly over the Financial Year.

Setup Cost Report

  1. You can now define a Project Cost Summary report layout. Note the Actual and Budget Formulas which can be created.The Budget Formulae uses the fields on the Project Profile tab.
    Note also that labels for each report item can be specified. Certain reports use these labels as column headers and to ensure the report is not too wide to fit on the screen it may help 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’.
  1. You can optionally, create one or more Fee Calculation methods. This allows fee to be added to cost on the report format to give total project revenue. Fee can be defined based on different approaches such as: Total Labor and ODC Cost, or another method could just use Total Labor cost.One of these fee calculation methods can be specified for each project on the Project Profile tab along with the associated fee. It is also possible to calculate a Budget fee for comparison based on fields held on the Project Profile tab, as in the example below. An appropriate example fee to use on Cost Plus contracts is 5 or 7%. Revenue can then be calculated as the sum of total cost plus fee.
  2. With Unanet Version 9.3, calculations can be performed based on cost, bill or hour values for labor cost elements, cost or bill values for ODC elements, and cost values for pools. This allows T&M revenue to also be calculated. As a single report format is used for both Cost Plus and T&M projects (as it allows projects to be compared on a number of Project Costing reports), a T&M “fee method” should be defined as the sum of billable labor and ODCs minus the burdened project costs. T&M projects can select this method on the project profile. Then the same revenue formula can be employed, fee computed plus total costs, for both Cost Plus and Time & Materials projects.
  3. The availability of labor hours in report calculations means an actuals fee method based on hours worked, for example $6 for every hour, can be defined and used to calculate fee. Hours could also be included in the report as a line item if desired.

Project and Person Setup

Each person now has a default Cost Structure and Labor Cost Element which is entered on their Rates tab. This can be overwritten on Assignment.

On the Project Profile tab new fields Billing Type (with preset values of TM, CP and FP), Cost Structure can also be specified. On the Budget tab there are values for Total Value, Funded Value, Fee, Fee Calculation Method, Burdened Labor Cost and Burdened Expense Cost can be entered. These fields would hold budgeted values over the life of the project, and are used in various reports. They can also be selected in the Cost Report setup for comparison with actuals. The intended usage of the fields is as follows:

  • Total Value: Anticipated maximum value of contract, may equal Funded Value.
  • Funded Value: Authorized expenditure; may equal to project budgeted revenue (calculated as sum of Labor and Expense Bill Budget values).
  • Fee Calculation Method: Selected from the items defined on the Cost Report Fee Calculation Method tab.
  • Fee: Percentage to be added to project cost to calculate revenue.
  • Burdened Labor Cost: total labor costs including burdens (e.g. Fringe, Overhead and G&A)
  • Burdened Expense Cost: total ODC costs including burdens (e.g. G&A)

Project Cost Reporting

Eight new reports are provided on the reports menu.

The Labor Cost Details and ODC details reports are available via the Reports menu and also via drilldown from the Project Cost Summary (JSR). Note JSR is an acronym for Job Summary Report, a commonly used name for that report format in popular accounting systems.

The purpose of each report is as follows:

  1. Labor Cost Details – show actual hours, direct labor costs, labor category and person by labor cost element for the same time periods as the Project Cost Report. Average labor rate per cost element is also shown. If the Unanet Project Portfolio product is used, Labor Detail actuals can be compared with Assignments or Plans.
  1. ODC Details – show actual costs for each expense type by ODC element for the same time periods as the Project Cost Report.If the Unanet Project Portfolio product is used, ODC Detail actuals can be compared with Budgets or Plans.
  1. Indirect Cost Rates - a report view of the data entered in the Cost Structure > Indirect Cost Rates tab.
  1. Cost Summary – a periodic report (user can select week, month or quarter periods) showing costs for a project by cost element. Plans or budgets can be included for labor, and expense. The vertical ordering of the report output will match the layout defined in Admin > Setup > Cost Report, with those elements not used in the cost structures of interest not displayed.
  1. Cost Summary and Status – extending the Cost Summary report to include actuals and plans or budgets for prior and future periods. Totals are calculated with budgets for the project. Backlog is shown on the report calculated as the difference between the project budget amounts and the actuals. The Unallocated Budget is calculated as the difference between the project budget amounts and sum of the actuals and people and expense plans or budgets.
  1. Project Cost Summary by element – providing one line per project, showing cost element details for a project. The horizontal ordering of the Project Summary by Cost Element report output will also match the layout defined in Admin > Setup > Cost Report. Cost Element details can be hidden via the selection screen, providing a report that displays only totals. Additionally, users can choose to Sort by Project or Sort by Billing Type (within Owning Org).
  1. Project Revenue and Funding Summary – providing one line per project, shows date range, billing type and actuals for the user-specified current period, fiscal-year-to-date, and prior years. This total is compared with:
  • Budgeted Revenue (as specified in the Cost Report definition)
  • Backlog (calculated as Budget – Actuals),
  • Funded Value (from Project Profile tab), and
  • Remaining Funded (calculated as Funded minus Actuals to Date)

Additionally, users can choose to Sort by Project or Sort by Billing Type (within Owning Org).

  1. Project Cost Summary (JSR) - the vertical ordering of the Project Cost Summary (JSR) report output will match the layout defined in Admin > Setup > Cost Report, with those elements not used in the cost structures of interest not displayed. As with the Labor Cost Details, ODC Details and the other Summary reports, four periods are shown with actuals;
  • Current Period as specified by the user.
  • Fiscal Year to Date
  • Prior Fiscal Years
  • Total (BoT to ToDate)

Budgeted, % of Budget Incurred and Backlog (Budgeted minus total Actuals ToDate) are also shown.

The users may click on the detail links on the Project Cost Summary (JSR) report output (shown below) to see the related labor and ODC details. If the Unanet Project Portfolio product is used, Labor Detail and ODC actuals can be compared with Budgets or Plans.