MANAGE REVENUE INFORMATION

Use this screen to set up revenue calculation for a project. You can control the formula used to compute revenue and alter the default revenue posting method (either to Owning Organization or Performing Organization). (You selected the default revenue posting method on the Configure Project Settings screen.) You can also use this screen to identify the multipliers to be used on the Compute Billing Value of Cost Incurred screen. On this screen's table window, you can enter revenue adjustments by fiscal year/period/subperiod. You cannot enter data in this screen if the Billable Project check box on the Basic Info tab of the Manage Project User Flow screen is not selected.

If you select any hours-based revenue formulas in the Revenue Formula drop-down list, you must also initialize the Project Labor Categories (PLCs) and billing rates for the project. You can set up PLCs and billing rates at any level of the project.

If labor rates are different for each task of the project, you must enter these labor rates at the task level.

You must complete the Manage Rate Sequence Orders screen at the charging level of the project because this screen determines the order in which billing rates are found.

If you modify the revenue formula of a project, Costpoint resets all revenue amounts in the PROJ_BURD_SUM, PROJ_SUM and LAB_HS tables back to zero for the current fiscal year for all projects at or below the revenue level. This ensures that the YTD revenue amounts are correct with the new revenue formula, when revenue is recomputed.

Complete this screen during project setup for all projects for which the Billable Project check box is selected on the Basic Info tab of the Manage Project User Flow. Before completing this screen, you must identify the revenue formulas that you would like to use by selecting each revenue formula on the Revenue Formulas subtask of the Configure Project Settings screen. Only formulas that have been selected in this subtask are available for selection in this screen. Maintain this screen only when the formula or its attributes change, when a revenue adjustment is required, or when the formula is one of the Fixed Amount formulas. 

After you establish a revenue formula for a project, modifying the formula in this screen may require additional steps to ensure proper calculations. Contact Costpoint General Support before modifying any revenue formulas.

For more information about revenue setup, see the "Revenue Setup/Computation" topic.

This screen is also available as a subtask on the Manage Project User Flow (Revenue Details).

Location

Identification

Project

Enter, or click to select, a valid project for which to enter data. The level of the project that you enter in this field determines the level at which the revenue is calculated. If some tasks within the project tree require various revenue formulas or have requirements such as different fee percentages or separate funding ceilings, set up the revenue levels to accommodate these requirements. The selection of the revenue level is an integral part of the project setup process and must be given some thought before the project is set up. For more information on project levels, see "Project Levels and Data." 

This is a required field. The unlabeled field to the right is non-editable and displays the name of the project selected.

Revenue Details

Revenue Formula

Enter, or click to select, the revenue formula. You must select revenue formulas on the Select Revenue Formulas subtask on the Configure Project Settings screen before you can select them here. You can use this subtask to restrict which formulas are available in this screen. Each formula listed produces a separate calculation and all formulas are independent from the type of project specified on the Basic Info tab of the Manage Project User Flow. For more information about revenue setup, see the "Revenue Setup/Computation" topic.

For example, the project type can be fixed price, and because all revenue formulas are available for selection, the revenue formula can be Loaded Labor Hours. This is a required field. Refer to "Revenue Computations" for more information on the revenue calculations performed for the individual revenue methods.

For information about modifying a revenue formula, see the "Modifying Revenue Formulas" topic.

The following options are included in this drop-down list:

When you use the ETPL (Equal to Project Ledger Sales) formula, the Compute Revenue process looks at GL_POST_SUM table for the revenue account. When you use this formula, you either enter an Adjusting Journal Entry (AJE) to credit the revenue account and debit the unbilled account, or you post a sales order that credits the revenue account automatically. When you execute the Compute Revenue process, it sets the revenue amount equal to the costs of the project on the labor and non-labor lines (actual direct cost plus burden) and then plugs the difference into the ACCT_FUNC_NO = 1 line.

Fiscal Year

If you modify the Revenue Formula for this project, use this field to specify what fiscal year the program must use when it sets the revenue amounts back to zero in the PROJ_SUM and PROJ_BURD_SUM tables.

After you establish a revenue formula for a project, changing the formula in this screen may require additional steps to ensure proper calculations. Contact Costpoint General Support before changing any revenue formulas.

Revenue Calculation Value

Revenue Calculation Value is displayed as a series of not more than three fields. The descriptions of these fields change based on the Revenue Formula selected. Some formulas use only one field; other formulas use two or three fields. If a formula does not use the Revenue Calculation Value, these fields do not display.

For example: If you choose Cost Plus Fee On Cost as your Revenue Formula, the field is titled Labor Fee Percent and Non-labor Fee Percent. You then enter the fee percentages that apply to this project.

Calculate Revenue on Units

Select this check box to calculate revenue on units in addition to the revenue that is calculated based on the revenue formula. You must enter one of the following transaction-based revenue formulas in the Revenue Formula drop-down list for unit revenue calculations to be allowed:

If you try to use revenue formulas other than the ones listed with unit-based revenue, Costpoint displays this message: "This fixed amount formula is not allowed to have unit revenue."

To calculate unit-based revenue only and not include any non-unit based revenue, use the Unit Revenue Only revenue formula. Do not select the Calculate Revenue on Units check box if you are using this formula.

Discount Method

Use this drop-down list to select a discount method for this project. If you choose to use a discount method, Costpoint applies the following rules when computing revenue or calculating bills:

  1. Burdens apply to the amount BEFORE discount.

  2. Discounts apply to the direct cost amounts (this includes burdens for the w/Burden discount methods).

  3. Fee applies to total AFTER discount.

  4. Sales tax applies to the amount AFTER discount.

  5. Retainage applies AFTER discount. 

For ceilings:

  1. Account Ceilings are enforced before discounts are applied.

  2. Project Total Ceilings are enforced after discounts are applied.

If you modify the revenue formula for a project, Costpoint clears out the discount amount fields (DISC_ACT_AMT and DISC_TGT_AMT) in the PROJ_SUM and PROJ_BURD_SUM tables.

If you modify the Discount Method for a project in this screen, you must also modify the discount method for that project on the Other Info subtask of the Manage Project Billing Information screen. 

The selections are:

If you modify the Discount Method from PLC Discounts to another method, Costpoint resets the discount percentages to zero on the Link Project Labor Category Rates to Projects screen and the Link PLC Rates to Employee/Vendor screen. 

If you select this option, the Calculate Standard Bills screen and the Compute Revenue screen compute discounts based on aggregate volume using the discount percentage from the Manage Customer Volume Discounts screen and apply the discount to the accounts specified. This is available only for standard bills.

If you select this option, the Calculate Standard Bills screen and the Compute Revenue screen compute discounts using the discount percentage from the Manage Project Volume Discounts screen and apply the discount to the accounts specified. This is available only for standard bills.

The discount applies to the direct cost amount with burden included. This is available only for standard bills.

If you select this option, the Calculate Standard Bills screen and the Compute Revenue screen compute discounts based on aggregate volume using the discount percentage from the Manage Customer Volume Discounts screen.

The discount applies to the direct cost amount with burden included. This is available only for standard bills.

If you select this option, the Calculate Standard Bills screen and the Compute Revenue screen compute discounts using the discount percentage from the Manage Project Volume Discounts screen.

The discount applies to the direct cost amount with burden included. This is available only for standard bills.

Allow Revenue to Exceed Value

Select this check box to allow revenue in excess of the value of the project to be computed and posted.

You must have already specified on the Configure Project Settings screen whether you want excess revenue recognition based on the contract value or the funded value.

By How Much?

Enter the amount by which the signed value ceiling can be exceeded. This field is available only if you selected the Allow Revenue to Exceed Value check box.

Post Revenue to the

Use the options in this group box to select whether you would like to post the project's revenue to the owning organization or performing organization. The default for this group box is selected on the Configure Project Settings screen. You can modify it in this screen.

Owning Organization

Select this option to post all revenue to this project's owning organization. When a parent project exists, the revenue rolls up to the higher level. When selecting this method, be aware that the costs related to the project are posted to the performing organization.  If you use this method, you may want to consider selecting the Default to Owning Organization check box on the Basic Info tab of the Manage Project User Flow screen. This defaults the owning organization in all transaction screens. You can also use the Create Cost Transfer Journal Entry screen to reclassify the costs to the owning organization of the project. See the documentation for the Create Cost Transfer Journal Entry screen for more information on this topic.

For example;

Project 3000 - revenue formula level

3000.01 - costs are charged here

3000.02 - costs are charged here

If you are posting revenue by owning organization or performing organization, all revenue posts to the 3000 project.

Project 4000

4000.01 - revenue level and where costs are charged

4000.02 - revenue level and where costs are charged

If you are posting revenue by owning organization or performing, all revenue posts to 4000.01 and 4000.02 (at the level that the revenue formula exists).

Performing Organization

Select this option to post all revenue to this project's performing organization. When a parent project exists, the revenue rolls up to the higher level.

Goal Multiplier

These multipliers are used to calculate the billing value of project costs incurred. These fields are required if you selected the Use Goal Multipliers for Billable Value Calculations check box on the Configure Project Settings screen.

Labor

Enter the value to be used as the goal multiplier for labor costs. The default for this field is 1.000; if you accept this default, the billing value amount is equal to costs with no additional markup.

Non-Labor

Enter the value to be used as the goal multiplier for non-labor costs. Non-Labor multipliers are applied to non-labor amounts spent (excluding applied overhead amounts). The default for this field is 1.000; if you accept this default, the billing value amount is equal to costs with no additional markup.

Subtasks

Subtask

Description

Award Fee

Click this link to open a subtask where you can select an award fee accrual method, accrual fee percent, and fixed amount accrual, and to view the award fee period, the funded award fee amount, and the contract value award fee amounts that were entered on the Award Fee subtask of the Manage Modifications screen.

Revenue Adjustments

Click this link to open the Revenue Adjustments subtask and record and maintain an audit trail of revenue adjustments by fiscal year, period, and subperiod. All revenue amounts in this subtask, up to and including the subperiod for which revenue is being calculated, are summed to arrive at the year-to-date revenue adjustment amount