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:
The application applies goal multipliers and multiplier overrides to labor and non-labor costs. This application uses the goal multipliers from the Goal Multiplier group box in the Revenue Information screen (Projects\Maintain\Revenue). The multiplier overrides are from the Multiplier Overrides screen (Projects\Maintain\Ceilings and Overrides).
The application retrieves labor data from the Maintain Labor Summary (Projects\Configure\Project History) (LAB_HS table) and the Prior Year Billable Value Amounts (PY_GOAL table) screens.
The process applies labor multipliers to rate types of "A" (Actual), "S" (Standard), and "C" (Ceiling), rather than "B" (Billing).
The process retrieves units and non-labor data from the Prior Year Cost and Revenue (PSR_PY_SUM table), the Compute Burden Cost (PROJ_SUM table), and the Prior Year Billable Value Amounts (PY_GOAL table) screens.
The system applies non-labor multipliers to non-labor costs.
No multipliers are applied to units.
Since billable value is computed only on allowable costs, any unallowable labor or unallowable non-labor costs are NOT included in the computation, but the overall multiplier rate stored in the header will include both allowable and unallowable costs.
No burdens or fees are applied during the computation.
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.
Since billable value computations are on a YTD calculation, the system stores all prior year billable value amounts in the Prior Year Billable Value Amounts screen to arrive at the ITD calculations.
|
|
Warning: Run this process for each fiscal period for this project. Even if there are no costs incurred, the YTD goal amount will not be computed correctly unless you complete all steps for billing value (Goal) calculation, including those in the Load Labor Rates (Projects\Process\Billing), Compute Burden Cost (Projects\Process\Project), Compute Revenue (Projects\Process\Revenue) screens, etc. |
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 Maintain Labor Summary (Projects\Configure\Project History) (LAB_HS), Compute Burden Cost (Projects\Process\Project) (PROJ_SUM), Revenue Information (Projects\Maintain\Revenue) (PROJ_REV_SETUP), Multiplier Overrides (Projects\Maintain\Ceilings and Overrides) (OVRIDE_MLT_ON_DIR), or Prior Year Billable Value Amounts (PY_GOAL) screens.
Initialize the screens in the following order:
Prior Year Cost and Revenue (PSR_PY_SUM) for revenue, non-labor amounts, and unit amounts.
Maintain Labor Summary screen (Projects\Configure\Project History) (LAB_HS) for labor amounts and hours.
Prior Year Billable Value Amounts (PY_GOAL) for prior year billable value amounts for labor, non-labor, and units.
Revenue Information screen (Projects\Maintain\Revenue). Enter goal multipliers by project.
Multiplier Overrides (Projects\Maintain\Ceilings and Overrides) (OVRIDE_MLT_ON_DIR). Enter account overrides.
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. Once 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. Many users save a unique set of parameters for each different way they run a report or process. If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults. You can change any of the associated selection defaults as necessary.
Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters. You should 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 produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections. Once the default selections display in the screen, you can override the defaults as necessary.
Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.
Use the fields in this block to select the projects for which you want to compute billable value and the periods that you want to include in the process.
Projects *
Use this drop-down box to select the range of projects that you want to include in the process. The following options are available:
All - Select this option to include all available projects. The Start and End fields are disabled for this option.
One - Select this option to include only one project. You must enter that value in the Start field. The End field is disabled for this option.
Range - Select this option to include a contiguous range of projects. You must enter the beginning value for the range in the Start field and the ending value of the range in the End field.
From Beginning - Select this option to include all the projects from the beginning of the available projects to a specific project in the range. You must enter the last value for the range in the End field. The Start field is disabled for this option.
To End - Select this option to include all the projects from a specific project to the end of all the available projects. You must enter the value from which the range should begin in the Start field. The End field is disabled for this option.
Enter, or use Lookup to select, a starting project number for the range that you want to include in the process.
If you select "One," "Range," or "To End," in the Projects Option field, you must enter a project number in this field.
If you select "All" or "From Beginning" in the Projects Option field, this field will be inactive.
Enter, or use Lookup to select, an ending project number for the range that you want to include in the process.
If you select "All," "Range," or "From Beginning" in the Projects Option field, you must enter a project number in this field.
If you select "One" or "To End" in the Projects Option field, this field will be inactive.
Accounting Period
This non-editable field displays the "One" option. This is the only option available because you can run this process for only one period at a time.
Enter, or use Lookup 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 use Lookup 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 use Lookup to select, the last subperiod to be included in the billable value computation for the selected projects. All existing subperiods are available for selection.
This non-editable displays the ending date for the subperiod entered in the Subpd field.
Use the fields in this block to select the type of projects for which you want to compute billable value. You can also include projects that do not have costs for the period selected.
Use the fields in this group box to select the 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. Project classifications are system-defined and assigned in the Basic Project Information screen.
Use the fields in this group box to include either all project classifications or only specific project classifications.
Select this radio button to include all project classifications.
Select this radio button to include only those project classifications that have been selected in the Project Classifications group box.
Select this checkbox to include all projects with a "Direct Project" classification. Project classifications are assigned in the Basic Info screen in the Project User Flow (Projects\Maintain\Project).
Select this checkbox to include all projects with a "Indirect" classification. Project classifications are assigned in the Basic Info screen in the Project User Flow (Projects\Maintain\Project).
Select this checkbox to include all projects with a "Inter-Company" classification. Project classifications are assigned in the Basic Info screen in the Project User Flow (Projects\Maintain\Project).
Select this checkbox to include all projects with a "IR&D" (Independent Research and Development) classification. Project classifications are assigned in the Basic Info screen in the Project User Flow (Projects\Maintain\Project).
Select this checkbox to include all projects with a "Work in Process" classification. Project classifications are assigned in the Basic Info screen in the Project User Flow (Projects\Maintain\Project).
Select this checkbox to include all projects with a "Bid & Proposal" classification. Project classifications are assigned in the Basic Info screen in the Project User Flow (Projects\Maintain\Project).
Select this checkbox to include all projects with a "Inter-Co Multi" classification. Project classifications are assigned in the Basic Info screen in the Project User Flow (Projects\Maintain\Project).
Select this checkbox to include all projects with a "Common Inv" classification. Project classifications are assigned in the Basic Info screen in the Project User Flow (Projects\Maintain\Project).
Include Projects with No Costs
Select this checkbox to include projects that have no costs for the period entered in Fiscal Year, Period, and Subpd fields.
* A red asterisk denotes a required field.
1. Enter amounts in the Prior Year Cost and Revenue screen (PSR_PY_SUM) for revenue and non-labor amounts.
2. Enter amounts in the Maintain Labor Summary screen (LAB_HS) for labor amounts and hours.
3. Enter amounts in the Prior Year Billable Value Amounts screen (PY_GOAL) for labor, non-labor, and units.
4. Use the Basic Revenue Info screen (PROJ_REV_SETUP) to enter goal multipliers by project.
5. Use the Maintain Multiplier Overrides screen (OVRIDE_MLT_ON_DIR) to enter account overrides.
Steps to compute billing value:
1. Post all costs to the General Ledger.
2. Compute burden cost.
3. Load labor rates (for prior year also).
4. Compute revenue.
5. Compute billing value of cost incurred.
ITD REVENUE - ITD NON-LABOR EXPENSE COSTS / ITD LABOR COST
[ (PSR_PY_SUM. TOT_REV_AMT + PSR_PY_SUM. TOT_AWD_FEE_AMT + PROJ_SUM. TOT_REV_ACT_AMT+ PROJ_SUM.TOT_AWD_ACT_AMT) ] less [ ( PSR_PY_SUM. DIR_AMT where ACCT_FUNC_NO = 3 Non-Labor, 12 Unallow Non-Labor, or 13 Units) + ( PROJ_SUM. SUB_DIR_AMT where ACCT_FUNC_NO = 3 Non-Labor , 12 Unallow Non-Labor, or 13 Units) ] divided by [ ( PSR_PY_SUM. DIR_AMT where ACCT_FUNC_NO = 2 Labor or 11 Unallow Labor ) + ( PROJ_SUM. SUB_DIR_AMT where ACCT_FUNC_NO = 2 Labor or 11 Unallow Labor ) ]
ITD REVENUE - ITD NON-LABOR EXPENSE COSTS / ITD LABOR COST
[ (PSR_PY_SUM. TOT_REV_AMT + PSR_PY_SUM. TOT_AWD_FEE_AMT + PROJ_SUM. TOT_REV_TGT_AMT + PROJ_SUM.TOT_AWD_TGT_AMT) ] less [ ( PSR_PY_SUM. DIR_AMT where ACCT_FUNC_NO = 3 Non-Labor, 12 Unallow Non-Labor, or 13 Units) + ( PROJ_SUM. SUB_DIR_AMT where ACCT_FUNC_NO = 3 Non-Labor ,12 Unallow Non-Labor, or 13 Units) ] divided by [ ( PSR_PY_SUM. DIR_AMT where ACCT_FUNC_NO = 2 Labor or 11 Unallow Labor ) + ( PROJ_SUM. SUB_DIR_AMT where ACCT_FUNC_NO = 2 Labor or 11 Unallow Labor ) ]
Changes to this screen update the following tables:
PROJ_GOAL_HDR (Project Goal Header)
PROJ_GOAL_DETL (Project Goal Detail)
This process uses the following tables during the computation:
AR_HDR_HS (Accounts Receivable Header History)
LAB_HS (Labor History)
OVRIDE_MLT_ON_DIR (Override Multiplier on Directs)
PROJ_BILL_HS (Project Billing History)
PROJ_REV_SETUP (Project Revenue Setup)
PROJ_SUM (Project Summary)
PSR_PY_SUM (Project Status Report Prior Year Summary)
PY_GOAL (Prior Year Goal)
