COMPUTE BILLING VALUE OF COST INCURRED

Use this screen to compute the billing value of cost incurred for selected projects. Some industries refer to the billing value calculation as "Goal" or "Effort."

The following occur during this process for the selected projects:

  1. The application applies goal multipliers and multiplier overrides to labor and non-labor costs. The goal multipliers that this application uses are from the Goal Multiplier group box on the Manage Revenue Information screen. The multiplier overrides are from the Manage Multiplier Overrides screen .

  2. The application retrieves labor data from the LAB_HS and PY_GOAL tables.

  3. The process applies labor multipliers to rate types of A (Actual), S (Standard), and C (Ceiling), rather than B (Billing).

  4. The process retrieves units and non-labor data from the PSR_PY_SUM, PROJ_SUM, and PY_GOAL tables.

  5. Costpoint applies non-labor multipliers to non-labor costs.

  6. No multipliers are applied to units.

  7. Since billable value is computed only on allowable costs, any unallowable labor or unallowable non-labor is NOT included in the computation, but the overall multiplier rate stored in the header includes both allowable and unallowable costs.

  8. No burdens or fees are applied during the computation.

  9. The application calculates billable value amounts at the transaction level of the project and stores them in the report table at the employee/vendor/vendor employee level for labor, and at the account level for non-labor and units.

  10. Since billable value computations are on a YTD calculation, Costpoint stores all prior year billable value amounts on the Manage Prior Year Billable Value screen to arrive at the ITD calculations.

Run this process for each fiscal period for this project. Even if there are no costs incurred, the YTD goal amount does not compute correctly unless you complete all steps for Billing Value (Goal) calculation including Load Labor Rates, Compute Burden Costs, and Compute Revenue.

Run this screen as frequently as needed and at any time during the fiscal period; however, do not run this screen when other users are updating the LAB_HS, PROJ_SUM, PROJ_REV_SETUP, OVRIDE_MLT_ON_DIR, or PY_GOAL tables.

Steps to initialize billing value

Steps to compute billing value

Calculation for the Overall Effective Multiplier in the Project Goal Header Table (PROJ_GOAL_HDR)

Location

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID. A parameter ID represents a set of screen selection parameters. After you have saved a parameter ID and its related parameters, you can retrieve them using Query.

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency. The saved parameters are also useful and necessary when you want to run the process as part of a batch job. Many users save a unique set of parameters for each different way they run a report or process. When you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters automatically display as selection defaults. The page setup and print options are also included in the saved parameter ID if there are any. You can change any of the associated selection defaults as necessary.

Parameter ID

Enter, or click to select, a parameter ID of up to 15 alphanumeric characters. Choose characters for your parameter ID that help identify the type of selections you made in the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to run the process more efficiently because you can select the parameter ID with its previously defined screen selections. After the default selections display in the screen, you can override the defaults.

Description

Enter, or click to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Projects

Use this group box to limit the projects that have billable value calculated.

Option

Use this drop-down list to select the range of projects to be included in the billable value computation. Valid options are:

The default for this field is All.

Start

Enter, or click to select, the beginning project of the range you want to compute. If you select All or From Beginning in the Option field, this field is inactive.

End

Enter, or click to select, the ending project of the range you want to compute. If you select All or To End in the Option field, this field is inactive.

Accounting Period

Use this group box to select the last subperiod to be calculated for the selected projects. Costpoint calculates all selected projects up to and including the selected subperiod.

Option

This field always displays One.

Fiscal Year

Enter, or click to select, the last fiscal year to be included in the billable value computation for the selected projects. All existing years are available for selection.

Period

Enter, or click to select, the last fiscal period to be included in the billable value computation for the selected projects. All existing periods are available for selection.

Subpd

Enter, or click to select, the last subperiod to be included in the billable value computation for the selected projects. All existing subperiods are available for selection.

Ending Date

This non-editable field displays the final date of the subperiod selected.

Options

Project Classifications

Select items in this group box to specify which types of projects to include in the computation of billable value. You can select as many classifications as you want, and there is no default value for this group box.

Include

All

If you select this option, all the check boxes in the Project Classifications group box become selected.

Specific

Select this option to select the check boxes individually.

Include Projects with No Costs

Select this check box to include projects that do not have any costs incurred. Select this check box if you know that you have no costs but have already recognized some revenue, or if you want to insert a header record into the goal header table for all projects in the PROJ table.