BASIC REVENUE INFO
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 in
the Project Settings screen (Projects
» Project Setup » Controls).) You can also use this screen to identify
the multipliers to be used in the Compute Billing Value of Cost Incurred
(Projects » Cost and Revenue Processing
» Revenue Processing). In 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 in the Basic Info screen (Projects
» Project Setup » Project Master) is not selected.
If you select any hours-based revenue formulas in the Revenue
Formula drop-down list, you should 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 Define Rate Sequence screen (Projects
» Project Setup » Revenue Setup) at the charging level of the project
because this screen determines the order in which billing rates are found.
If you change the revenue formula of a project, Costpoint will reset
all revenue amounts in the PROJ_BURD_SUM, PROJ_SUM, and the 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 will be 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 in the Basic Info screen (Projects
» Project Setup » Project Master) or the Maintain Project Master
screen (Projects » Project Setup » Project
Master). Before completing this screen, you must identify the revenue
formulas that you would like to use by selecting each revenue formula
in the Select Revenue Formulas subtask of the Project Settings screen
(Projects » Project Setup » Controls).
Only formulas that have been selected in this subtask will be 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.
Once you have established 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.
Project
Enter, or use 
to select, a valid project for which
to enter data. The level of the project that you enter in this field will
determine 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, you should
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 should be given some thought before the project is set up. For
more information on project levels, see Projects
Special Topic PJ-14, "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 Formula
Use this drop-down list to select the revenue formula. You must select
revenue formulas in the Select Revenue Formula subtask of the Project
Settings screen (Projects » Project Setup
» Controls) before you can select them here. You can use this subtask
to restrict which formulas are available in this screen. Each formula
listed will produce a separate calculation and all formulas are independent
from the type of project specified in the Basic Info screen.
For example, the project type could be fixed price, and since all revenue
formulas are available for selection, the revenue formula could be Loaded Labor Hours. This is a required
field. Refer to Projects
Special Topic PJ-12, "Revenue Computations," for more information
on the revenue calculations performed for the individual revenue methods.
The following options are included in this drop-down list:
Contract
Value Less Backlog - This formula calculates revenue by subtracting
the backlog amount entered in the screen from the total contract value.
Once you have selected this revenue formula, the Backlog
Amount field will display. You must estimate the total backlog for
this project and enter it in this field. The system will then subtract
this amount from the total contract value in the Modifications screen
(Projects » Project Setup » Controls).
Backlog in this context is generally defined as the amount of the contract
value that has not yet been earned.
Contract
Value Times % Complete Vs. Rate Schedule - This formula compares the
revenue calculated by the Contract Value
Times Percent Complete formula and the revenue calculated by the
Rate Schedule and then uses the
lower of the two amounts. Once you have selected this formula, you must
enter the percent complete and the labor and non-labor multipliers in
the appropriate fields. Refer to the documentation on the Contract
Value Times Percent Complete and the Rate
Schedule formulas to obtain further details concerning these calculations.
Contract
Value Times Percent Complete - This formula multiplies the percent
complete amount entered in this screen by the total contract value entered
in the Modifications screen. This value is then compared to the revenue
previously recognized. The system computes the previously recognized revenue
by adding the revenue in the Prior Year Cost and Revenue screen (Projects » Project Setup » Project History)
and the revenue that has been recorded on a year-to-date basis in the
general ledger. The difference between these two amounts is posted in
the current period.
Cost
Incurred Using Estimate To Complete - Use this formula if you are
recording revenue using a percent completion method. In order to
use this formula, you must be able to estimate your projects' cost to
complete and any inception-to-date losses. The system first calculates
the cost percent complete. The system calculates the inception-to-date
allowable costs by adding the prior year costs from the Prior Year Cost
and Revenue screen (Projects » Project
Setup » Project History) and the year-to-date costs in the general
ledger. This amount is divided by the estimated costs to complete entered
in the screen less any inception-to-date losses. The system multiplies
the resulting percentage by the contract value less inception-to-date
losses. The result of this calculation is the inception-to-date revenue
for the project. The system then compares this number to the sum
of the revenue in the Prior Year Cost and Revenue screen and the amount
that has been posted to the general ledger. The difference between these
two numbers is the current period revenue.
Cost
Incurred using Estimate At Completion - Use this formula if you are
recording revenue using a percent completion method. In order to
use this formula, you must be able to estimate your projects' costs at
completion and any inception-to-date losses. The system first calculates
the cost percent complete. The program calculates the inception-to-date
allowable costs by adding all prior year allowable costs in the Prior
Year Cost and Revenue screen (Projects
» Project Setup » Project History) and adding this number to the
year-to-date allowable costs in the general ledger. The result of this
calculation is divided by the estimate at completion amount that has been
entered in the screen less any inception-to-date loss. The system multiplies
this percentage by the contract value less any inception-to-date loss.
It then compares the resulting amount to the inception-to-date revenue
already recognized. It calculates the inception-to-date revenue already
recognized by adding the revenue in the Prior Year Cost and Revenue screen
to the revenue recorded in the general ledger for the current fiscal year.
The difference between the revenue already recognized and the revenue
calculated by the system will be the current period revenue.
Cost
Plus Fee On Cost - This formula uses year-to-date direct and indirect
costs plus a fee on those costs to compute revenue. The direct costs are
derived from information posted to the general ledger. The system calculates
the indirect costs by multiplying actual or target rates in the Cost Pools
screen (Projects » Cost and Revenue Processing
» Cost Pool Setup) by the year-to-date direct costs. It calculates
the fee by multiplying total year-to-date costs by the fee percent. The
direct, indirect, and fee amounts are combined to determine year-to-date
revenue. Any adjustments to the fee are handled on a year-to-date basis.
Cost
Plus Fee on Cost Current Month Fee - This formula uses year-to-date
direct and indirect costs but applies fee based only on current period
costs. The direct costs are derived from information posted to the general
ledger. The system calculates the indirect costs by multiplying actual
or target rates in the Cost Pools screen (Projects
» Cost and Revenue Processing » Cost Pool Setup) by the year-to-date
direct costs. It calculates the fee by multiplying total costs on a period
basis by the fee percent. The direct, indirect, and fee amounts will be
combined to determine year to date revenue. Any adjustments to fee are
only applied to the current period.
Do
Not Compute - Use this formula if you do not want revenue computed
on your project. Using this formula after your project has been
completed will prevent changes in the revenue as a result of indirect
or labor rates changes.
Equal
To Billings After Retainage - Use this formula to make inception-to-date
revenue equal to billings after retainage. The Amount
Billed column in the Maintain Project Bill Summary screen (Projects » Billing » Billing History)
is summarized up to and including the ending subperiod being calculated
to determine the inception-to-date billed after retainage. The system
compares this amount to the inception-to-date revenue. The system calculates
inception-to-date revenue by adding the total revenue from the Prior Year
Cost and Revenue screen and the year-to-date revenue in the general ledger.
The difference between these two amounts will be posted to the general
ledger in the current period.
Equal
To Billings Before Retainage - Use this formula to make inception-to-date
revenue equal to billing before retainage. The Amount
Billed and the Amount
Retained columns in the Maintain Project Bill Summary screen
(Projects » Billing » Billing History)
are combined and summarized up to and including the ending subperiod being
calculated to determine the inception-to-date billed amount. The system
compares this amount to the inception-to-date revenue amount. The system
calculates inception-to-date revenue by adding the total revenue in the
Prior Year Cost and Revenue screen (Projects
» Project Setup » Project History) to the year to date revenue
in the general ledger. The difference between these two amounts is posted
to the general ledger in the current period.
Equal
To Deliveries - Use this formula to make inception-to-date revenue
equal to deliveries. The system calculates deliveries by summarizing the
Delivery Amount
column in the Maintain Project Bill Summary screen (Projects
» Billing » Billing History) up to and including the subperiod
entered in the screen. It compares this amount to the inception-to-date
revenue. The system calculates inception-to-date revenue by adding the
total revenue in the Prior Year Cost and Revenue screen (Projects
» Project Setup » Project History) to the year-to-date revenue
in the general ledger. The difference between these two amounts is posted
to the general ledger in the current period.
Equal
To Project Ledger Sales - Use this revenue formula if you want the
revenue on your project reports to be equal to the amount in the general
ledger. When you use this formula, the system usually posts revenue to
the general ledger with a monthly journal entry. When revenue is calculated,
the project tables are updated with the year-to-date revenue from the
general ledger.
When you use
the Equal to Project Ledger Sales
formula, the Compute Revenue process (Projects
» Cost and Revenue Processing » Revenue Processing) 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.
Fee
on Hours Plus Cost Incurred - This formula calculates revenue by adding
direct and indirect costs and a fee based on hours incurred. The direct
costs are derived from information posted to the general ledger. The system
calculates the indirect costs by multiplying actual or target rates in
the Cost Pools screen (Projects » Cost
and Revenue Processing » Cost Pool Setup) by the year-to-date direct
costs. The program calculates the fee by multiplying fee per hour that
was entered in this screen by the number of hours incurred. This is a
year-to-date formula.
Fixed
Amount Contract To Date - Use this formula to determine your contract-to-date
revenue manually. The system uses the amount entered in the screen as
contract-to-date revenue and compares it to inception-to-date revenue
already in the system. The system calculates inception-to-date revenue
by adding the total revenue in the Prior Year Cost and Revenue screen
(Projects » Project Setup » Project History)
and the year-to-date revenue in the general ledger. The difference between
these two amounts is posted as revenue in the current period.
Fixed
Amount Month To Date - Use this formula if you would like a standard
amount per month to be recognized as revenue. This formula compares the
fixed monthly amount that is entered in the screen to the revenue in the
general ledger for the period being computed. The difference between these
two numbers is recognized as revenue.
Fixed
Amount Year To Date - Use this formula to record a standard amount
of revenue each year. This formula compares the year-to-date revenue amount
that is entered in the screen to the year-to-date revenue that has been
recorded in the general ledger. The difference between these two amounts
is recognized as revenue in the current period.
Labor
Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost) - Use
this revenue formula to calculate revenue by applying a multiplier to
labor and non-labor costs. You enter the multipliers in the Basic Revenue
Info screen (Projects » Project Setup
» Revenue Setup) or the Maintain Multiplier Overrides screen (Projects » Project Setup » Revenue Setup).
The system multiplies the multipliers entered in these screens by the
labor and non-labor costs that are posted to the general ledger. You should
enter a Project Labor Category (PLC) for all labor costs. This is a transaction-based
revenue formula.
Labor
Cost times Multiplier Plus Non-labor times Multiplier (Hours) - Use
this formula to have multiplier-based revenue using actual labor rates.
The system computes the labor amount by dividing labor cost by actual
hours incurred. You should enter a PLC for all labor amounts. Labor amounts
that do not have associated hours are ignored during this calculation.
A rate type of A is used with
this formula. It is different from the Labor
Cost Times Multiplier Plus Non-Labor Times Multiplier formula because
it computes revenue using actual rates. This is a transaction-based formula.
Loaded
Labor Plus Non-Labor W/Burden W/Fee - Use this formula to compute
revenue using labor rates times hours incurred plus non-labor costs with
burden and a fixed fee. The system multiplies the labor hours in the Maintain
Labor Summary screen by the assigned labor rate to obtain the loaded labor
portion. The non-labor amounts that have been posted to the general ledger
are combined with the burden at provisional rates stored in the Pool Rates
subtask of the Cost Pools screen (Projects
» Cost and Revenue Processing » Cost Pool Setup). The system applies
the fixed fee entered in this screen to the non-labor costs. This is a
transaction-based formula.
Loaded
Labor Plus Non-labor Plus Burden on Non-labor - Use this formula
to compute revenue using loaded labor rates plus non-labor amounts and
related burden. The system computes the loaded labor amount by multiplying
labor hours in the Maintain Labor Summary screen by the assigned labor
rate. The non-labor amounts are taken from amounts posted to the general
ledger. The burden is computed on non-labor using the provisional rates
in the Pool Rates subtask of the Cost Pools screen (Projects
» Cost and Revenue Processing » Cost Pool Setup). This is a transaction-based
formula.
Loaded
Labor Rate - Use this revenue formula to compute revenue using loaded
labor rates only. All non-labor costs are ignored when you use this formula.
The system will compute the labor portion of this formula by multiplying
the assigned labor rate by the hours incurred by PLC in the Maintain Labor
Summary screen (Projects » Project Setup
» Project History). This is a transaction-based formula.
Loaded
Labor Rate Plus Cost Incurred On Non-labor (T&M) - Use this formula
to compute revenue using loaded labor plus non-labor costs. This formula
does not compute fee or burden. The system multiplies labor hours incurred
in the Maintain Labor Summary screen (Projects
» Project Setup » Project History) by the assigned labor rate to
obtain the loaded labor amount. The non-labor amounts that have been posted
to the general ledger are computed as pass-through amounts. This is a
transaction-based formula.
Loaded
Labor Rate W/Burden W/Fee Plus Non-Labor W/Burden W/Fee - Use this
formula to apply burden and fee to loaded labor rates and non-labor with
burden and fee rates. The system multiplies the hours incurred in the
Maintain Labor Summary screen by the assigned labor rate to obtain the
loaded labor amount. The provisional rate in the Pool Rates subtask of
the Cost Pools screen (Projects » Cost
and Revenue Processing » Cost Pool Setup) is used to calculate
the burden on both the labor and non-labor. The non-labor amounts are
subtracted from non-labor amounts that were posted to the general ledger.
The system applies the fee amount entered in this screen to both the labor
and non-labor amounts. This is a transaction-based revenue formula.
Loaded
Labor Rate W/Fee Plus Non-Labor W/Burden W/Fee - Use this formula
to compute revenue using loaded labor rates with fee applied and non-labor
with burden and fee rates. The system multiplies the hours incurred in
the Maintain Labor Summary screen by the assigned labor rate to obtain
the loaded labor amount. The value that you enter in the Labor
Fee Pct. field is applied to the labor amount. The non-labor amounts
that have been posted to the general ledger plus fee computed using the
Non-Labor Fee percent
are used to compute the non-labor portion of the revenue formula. The
system applies the burden to the non-labor using the provisional rates
in the Pool Rates subtask of the Cost Pools screen (Projects
» Cost and Revenue Processing » Cost Pool Setup). This is a transaction-based
formula.
Rate
Schedule times Multiplier Plus Non-labor times Multiplier - Use this
formula to calculate revenue using a variety of different labor rates.
You must always use a PLC for labor transactions when using this formula.
You can set up the rate schedule to use A,
B, or C
rate types. This allows you to calculate revenue according to who or what
group of employees is charging. The system computes the non-labor using
the multiplier entered in this screen. This is a transaction-based formula.
Unit
Revenue Only - Use this formula to calculate revenue by using units.
The system will multiply units posted to the Unit Usage History table
in Costpoint Billing by the unit price in the Set Up Product Price Catalogs
screen (Materials » Product Definition
» Product Billing) or the Project Unit Pricing screen (Projects
» Project Setup » Unit Pricing). This is a transaction-based formula.
Revenue Calculation Value
Revenue Calculation Value is displayed as a series of up to three grayed-out
fields. The descriptions of these fields will change based on the Revenue
Formula selected. Some formulas will use only one field; other formulas
will use two or three fields. If a formula does not use the Revenue
Calculation Value, this field will be grayed out.
For example: If you choose Cost Plus
Fee On Cost as your Revenue
Formula, the field will be titled Labor
Fee Percent and Non-labor
Fee Percent. You then enter the fee percentages that apply
to this project.
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 should have already specified
in the Project Settings screen (Projects
» Project Setup » Controls) 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.
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:
Contract
Value Times % Complete vs. Rate Schedule
Cost Plus
Fee On Cost
Cost Plus
Fee On Cost Current Month Fee
Fee on
Hours Plus Cost Incurred
Labor
Cost Times Multiplier Plus Non-Labor Times Multiplier (Cost)
Labor
Cost Times Multiplier Plus Non-Labor Times Multiplier (Hours)
Loaded
Labor Rate
Loaded
Labor Rate Plus Cost Incurred on Non-Labor (T&M)
Loaded
Labor Plus Non-labor Plus Burden On Non-labor
Loaded
Labor Plus Non-Labor W/Burden W/Fee
Loaded
Labor Rate W/Burden W/Fee plus Non-Labor W/Burden W/Fee
Loaded
Labor Rate W/Fee Plus Non-Labor W/Burden W/Fee
Rate Schedule
times Multiplier Plus Non-labor times Multiplier
If you try to use revenue formulas other than the ones listed with unit-based
revenue, the system will display 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,
the system applies the following rules when computing revenue or calculating
bills:
Burdens apply to the amount BEFORE discount.
Discounts apply to the direct cost amounts (this
includes burdens for the w/Burden
discount methods).
Fee applies to total AFTER discount.
Sales tax applies to the amount AFTER discount.
Retainage applies AFTER discount.
For
ceilings:
Account Ceilings are enforced before discounts
are applied.
Project Total Ceilings are enforced after discounts
are applied.
If you change the revenue formula
for a project, the system clears out the discount amount fields (DISC_ACT_AMT
and DISC_TGT_AMT) in the PROJ_SUM and PROJ_BURD_SUM tables.
If you change the Discount
Method for a project in this screen, you must also change the discount
method for that project in the Other Info subtask of the Project Billing
Info screen (Projects » Billing » Billing
Master or Projects » Project Setup
» Revenue Setup) screen.
The selections are:
None
– Select this option if you do not want to apply discounts on this project.
This is the default for new records.
PLC
Discounts – Select this option to apply discounts on labor rates by
labor category. The discount percentage applies against the billing rates
stored in the labor category rate tables. All of the billing rates still
reside in the PLC rate tables, but a column exists to store the discount
percentage. The Load Labor Rates process (Projects
» Cost and Revenue Processing » Revenue Processing or Projects
» Billing » Prepare Billings) calculates the discounted billing
rate and loads the original and discounted billing rates into the labor
history and open billing detail tables. This is available only for standard
bills.
Note: If
you change the Discount
Method from PLC Discounts
to another method, the system resets the discount percentages to zero
in the Project PLC Rates screen (Projects
» Project Setup » Project Labor) and the Project PLC Rates by Employee/Vendor
screen (Projects » Project Setup » Project
Labor).
Account
Discounts – Select this option to apply a discount on labor and/or
ODCs at the subtotal level. You can use accounts discounts only for standard
bills. If you select this option, the system retrieves the discount percentage
from the Maintain Account Discounts screen (Projects
» Billing » Billing Master) and applies it to specific accounts
for each project. This is available only for standard bills.
Aggregate
Volume by Customer – Select this option to apply a discount on fees
or labor that is tied to the aggregate volume of business with a particular
customer. For example, if the aggregate volume of orders is equal
to $500,000.00 but less than $1,000,000.00, you could apply a discount
amount of 1%. If the aggregate volume of orders goes up to $1,000,000.00
but is less than $2,000,000.00, you could then apply a discount amount
of 2%. For a project to be included in the aggregate volume funded value
computations for a customer, the Include
in Aggregate Volume check box must be selected in the Government Contract
Info screen (Projects » Project Setup
» Project Master).
If you select this option, the Calculate Billings
screen (Projects » Billing » Calculate
Billings) and the Compute Revenue screen (Projects
» Cost and Revenue Processing » Revenue Processing) compute discounts
based on aggregate volume using the discount percentage from the Maintain
Customer Volume Discounts screen (Projects
» Billing » Billing Master) and apply the discount to the accounts
specified. This is available only for standard bills.
Aggregate
Volume by Project - Select this option to apply a discount on fees
or labor that is tied to the aggregate volume of business for a particular
project. This method is similar to the Aggregate
Volume by Customer discount method but is considered a project
override. For example, if the aggregate volume of orders is equal
to $500,000.00 but less than $1,000,000.00, you could apply a discount
amount of 1%. If the aggregate volume of orders goes up to $ 1,000,000.00
but is less than $2,000,000.00, you could then apply a discount amount
of 2%. For a project to be included in the aggregate volume funded value
computation, the Include
in Aggregate Volume check box must be selected in the Government Contract
Info screen (Projects » Project Setup
» Project Master).
If you select this option, the Calculate Billings
screen (Projects » Billing » Calculate
Billings) and the Compute Revenue screen (Projects
» Cost and Revenue Processing » Revenue Processing) compute discounts
using the discount percentage from the Maintain Project Volume Discount
screen in Costpoint Billing and apply the discount to the accounts specified.
This is available only for standard bills.
Account
Discounts w/Burden – Select this option to apply a discount on labor
and/or ODCs at the subtotal level including the burden amounts associated
with the direct costs. You can use accounts discounts only for standard
bills. If you select this option, the system retrieves the discount percentage
from the Maintain Account Discounts screen (Projects
» Billing » Billing Master) and applies it to specific accounts
for each project.
The discount applies to the direct cost amount
with burden included. This is available only for standard bills.
Aggregate
Volume by Customer w/Burden – Select this option to apply a discount
on fees or labor that is tied to the aggregate volume of business with
a particular customer. For example, if the aggregate volume of orders
is equal to $500,000.00 but less than $1,000,000.00, you could apply a
discount amount of 1%. If the aggregate volume of orders goes up to $
1,000,000.00 but is less than $ 2,000,000.00, you could then apply a discount
amount of 2%. For a project to be included in the aggregate volume funded
value computation for a customer, the Include
in Aggregate Volume check box must be selected in the Government Contract
Info screen (Projects » Project Setup
» Project Master).
If you select this option, the Calculate Billings
screen (Projects » Billing » Calculate
Billings) and the Compute Revenue screen (Projects
» Cost and Revenue Processing » Revenue Processing) compute discounts
based on aggregate volume using the discount percentage from the Maintain
Customer Volume Discounts screen (Projects
» Billing » Billing Master).
The discount applies to the direct cost amount
with burden included. This is available only for standard bills.
Aggregate
Volume by Project w/Burden - Select this option to apply a discount
on fees or labor that is tied to the aggregate volume of business for
a particular project. For example, if the aggregate volume of orders
is equal to $500,000.00 but less than $1,000,000.00, you could apply a
discount amount of 1%. If the aggregate volume of orders goes up to $
1,000,000.00 but is less than $2,000,000.00, you could then apply a discount
amount of 2%. For a project to be included in the aggregate volume funded
value computation, the Include
in Aggregate Volume check box must be selected in the Government Contract
Info screen (Projects » Project Setup
» Project Master).
If you select this option, the Calculate Billings
screen (Projects » Billing » Calculate
Billings) and the Compute Revenue screen (Projects
» Cost and Revenue Processing » Revenue Processing) compute discounts
using the discount percentage from the Maintain Project Volume Discounts
screen (Projects » Billing » Billing
Master).
The discount applies to the direct cost amount
with burden included. This is available
only for standard bills.
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 was selected in the Project Settings screen
(Projects » Project Setup » Controls).
You can change 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 will roll up to the higher level.
When selecting this method, you should be aware that the costs related
to the project will be posted to the performing org. If you use
this method, you may want to consider selecting the Default
to Owning Org check box in the Maintain Project Master screen (Projects » Project Setup » Project Master).
This will default the owning org in all transaction screens. You can also
use the Create Cost Transfer Journal Entry screen (Projects
» Cost and Revenue Processing » Revenue Processing) to reclassify
the costs to the owning org 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 org or performing org, all revenue will post 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 org or performing, all revenue will post 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 will roll 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 in the
Project Settings screen (Projects » Project
Setup » Controls).
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 will be 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 will be 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 will be equal to costs with
no additional markup.
Table Window
Use this table to record and maintain an audit trail of revenue adjustments
by fiscal year, period, and subperiod. All revenue amounts in this table
window, up to and including the subperiod for which revenue is being calculated,
will be summed to arrive at the year-to-date revenue adjustment amount.
Fiscal Year
Enter, or use to select, a valid fiscal year to record
your revenue adjustment amount.
Period
Enter, or use to select, a valid period to record your
revenue adjustment amount.
Subperiod
Enter, or use to select, a valid subperiod to record
your revenue adjustment amount.
Rev Adj Amt
Enter the revenue adjustment amount for the selected subperiod. All
amounts up to and including the subperiod for which revenue is being computed
will be summed to arrive at the year-to-date revenue adjustment.
A positive amount will increase the calculated revenue amount, and a negative
amount will decrease the calculated revenue amount.
Award Fee Adj Amt
Use this field to enter an award fee adjustment. You can
enter a positive amount to increase the award fee or a negative amount
to decrease the award fee that has been recognized. The award fee
adjustment amount is an inception-to-date adjustment. You must use this
column to adjust any award fees that were recognized in a prior year but
you can also use it to make adjustments to the current year award fee
amount. Amounts entered in this field are not subject to ceilings.
Award fee adjustments have been designed to work the same way as revenue
adjustments entered in the Rev
Adj Amt field.
You can adjust award fees recognized in the current year by entering
the final award fee amount in the Funded
Award Fee column or by adjusting the amount in the Contract
Award Fee column. These columns are found in the Award Fee subtask
of the Modifications screen (Projects
» Project Setup » Controls). The total amount entered in the
Contract Award Fee
and/or Funded Award
Fee columns is used as a ceiling for award fee calculations.
You can use the Award
Fee Adj Amt field in this screen if you do not want your award
fee to be limited by these ceilings.
Description
Enter up to a 254-character description of the revenue adjustment amount.
This field is required if you have entered an amount in the Rev
Adj Amt or Award
Fee Adj Amt fields.
Award Fee
Select this button 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
in the Award Fee subtask of the Modifications screen (Projects
» Project Setup » Controls).
Table Information
Changes to this screen update the following tables:
PROJ_REV_SETUP
REV_ADJ_HIST
PROJ_REV_PROJ