Field Descriptions

Table Information

 

Revenue Formulas

What can I do in this screen?

Use this screen to maintain the revenue calculation amount that is associated with the project's revenue formula.  The revenue calculation amount is displayed below the Revenue Formula field in the Revenue Information screen (Projects\Maintain\Revenue). These amounts are used in the Compute Revenue process (Projects\Process\Revenue) to help determine the revenue for the projects. Using this screen will expedite the changing of a fee amount, a multiplier amount, or a fixed amount. Once you have selected your project using Lookup or Query, you can change the revenue calculation amounts for all tasks or projects without having to access each record in the Revenue Information screen individually. You can optionally enter the revenue amount on a project-by-project basis in the Revenue Information screen. You can use this screen to enter the amounts for any range of projects for a given revenue formula.

Not all projects use revenue calculation amounts. You need to enter an amount only for those projects with formulas that use an amount or rate in the revenue calculation. Once you have entered an amount for a project, how often it needs to be changed depends on the revenue formula type.

You cannot add projects in this screen. You can enter amounts only for projects that have been entered in the Revenue Information screen.

Amounts and rates entered in this screen are stored in the Rev_Calc_Amt columns of the PROJ_REV_SETUP table.

The revenue formulas and their respective amounts are as follows:

Formula

Formula Description

Calculation Amount

BACKLOG

Contract Value Less Backlog

Backlog Amount

CPFC

Cost plus Fee On Cost

Labor Fee Percent/Non-Labor Fee Percent

CPFH

Fee on Hours Plus Cost Incurred

Fee Amount Per Hour

CVPC

Contract Value times Percent Complete

Percentage Complete

CVPCVSE

Contract Value times % Complete vs. Rate Schedule

Percentage Complete/Labor Multiplier/Non-Labor Multiplier

EAC

Cost Incurred Using Estimate At Completion

Estimate-at-Completion Amount

ETC

Cost Incurred Using Estimate To Complete

Estimate-to-Complete Amount

FACTD

Fixed Amount Contract To Date

Fixed Amount Contract-to-Date

FAMTD

Fixed Amount Month To Date

Fixed Amount Per Period

FAYTD

Fixed Amount Year To Date

Fixed Amount Per Year

CIMR

Labor Cost times Multiplier plus Non-Labor times Multiplier (Hours)

Labor Multiplier/Non-Labor Multiplier

COSTIMR

Labor Cost times Multiplier plus Non-Labor times Multiplier (Cost)

Labor Multiplier/Non-Labor Multiplier

CPFCCMF

Cost plus Fee on Cost Current Month Fee

Labor Fee Percent/Non-Labor Fee Percent

LLRBFNBF

Loaded Labor Rate with Burden with Fee plus Non-Labor with Burden with Fee

Labor Fee Percent/Non-Labor Fee Percent

LLRFNLBF

Loaded Labor Rate with Fee plus Non-Labor with Burden with Fee

Labor Fee Percent/Non-Labor Fee Percent

RSMNLM

Rate Schedule times Multiplier plus Non-Labor times Multiplier

Labor Fee Percent/Non-Labor Fee Percent

LLRCINBF

Loaded Labor plus Non-Labor w/Burden w/Fee

Fee Percent

 

 When should I use this screen?

Complete this screen, if necessary, after you enter the project in the Revenue Information screen (Projects\Maintain\Revenue). Maintenance is required only when the amount or rate changes. You must make changes before executing the Compute Revenue screen (Projects\Process\Revenue).

Field Descriptions

Identification

Use the fields in this block to select the revenue formulas that you want to update.

Revenue Formula *

This non-editable field displays the revenue formula code of the projects for which you are entering amounts. Use Query to select a valid revenue formula.

Description

This non-editable field displays the description of the selected revenue formula.

Table Window

Use this table window to edit the revenue calculation amounts of various projects.

Project

This non-editable field displays all the projects that contain the selected revenue formula.

Revenue Amt/Rate *

Enter the amount or rate for the desired projects.

Revenue 1 Amt/Rate *

Enter the amount or rate for the desired projects.

Revenue 2 Amt/Rate *

Enter the amount or rate for the desired projects.

* A red asterisk denotes a required field.

Table Information

Changes to this screen update the PROJ_REV_SETUP (Project Revenue Setup) table.

Top of Page