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 on the screen, such as PERIOD or QUARTERLY.

When you save your record, all the selections made on 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 on the screen, you can override the defaults.

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

Use the drop-down list to select the range of projects to print. This range must be consistent with the projects you have updated in the report table. Valid options are:

• All
• One
• Range
• From Beginning
• To End

Enter, or click to select, the starting project for the range of projects to be printed.

Enter, or click to select, the ending project for the range of projects to be printed.

Select this check box to enable the Project Non-Contiguous Ranges subtask. Use this subtask to create a customized list of projects to print on the report.

Enter, or click to select, the ending fiscal year to print on the report.

Enter, or click to select, the ending fiscal period to print on the report. Amounts incurred in periods up to and including this period are included on the report.

Enter, or click to select, the ending subperiod you to print on the report. Amounts incurred in subperiods up to and including this subperiod are included on the report.

This non-editable field displays the selected subperiod end date.

Select this check box to print the T&M Analysis Report only for projects that have alternate revenue profiles (that is, the project, its parent project, or any of its children is in the ALT_PROJ table).

Identify the highest project level that you want printed on the report. Balances are rolled up to this project level.

Select this check box to print revenue and profit information on the report. Use this option to print four additional columns: T&M Revenue, Total Loaded Cost, Gross Profit, and Gross Profit %.

Select this option to summarize data by Project Labor Category (PLC). If you select this option, the base labor rate used in calculations is the average labor rate by project of employees who charged using this PLC.

Select this option to see labor rate detail by employee. If an employee has charged using multiple labor categories, hours are segregated by labor category.

Select this option to burden costs with indirect rates and to use a user-specified fee percent in the calculation of fee per labor hour. You determine the user-specified fee percent when you run the Create Project Report Tables screen.

Select this option to mark up costs by a percentage. No indirect burdens are applied. Use this option if you want to see base labor per hour marked up by a flat percent to estimate indirect costs. This option is especially useful for commercial companies where no cost pools are used. No fee is applied. You determine the user-specified markup percent when you run the Create Project Report Tables screen.

Select this option to burden project labor on this report with target rates. These rates are from the Pool Rates subtask of the Manage Cost Pools screen. When you execute the Compute Burden Costs screen, the program computes both actual and target rates. This amount is stored in the report table.

Select this option to burden project labor on this report with actual rates. These rates are from the Pool Rates subtask of the Manage Cost Pools screen. When you execute the Compute Burden Costs screen, the program computes both actual and target rates. This amount is stored in the report table.

The following columns appear on the report if you selected the Desired Fee Percent option in the Use group box.

The source of information for this column is the ACT_HRS column of the LAB_HS table. This information can also be found on the Project Labor Summary Report.

Costpoint calculates the value in this column by subtracting the Allowable Hours column from the Total Hours column.

The source for this column is the ALLOW_REV_HRS column of LAB_HS. Allowable Hours are different from Total Hours if you have exceeded a ceiling.

This information comes from the REV_RT_AMT column of LAB_HS. If you have modified the billing rate during the report period, you must multiply the REV_RT_AMT by the ALLOW_REV_HRS in LAB_HS to arrive at the T&M revenue. Then divide T&M revenue by the ALLOW_REV_HRS to arrive at the average billing rate.

Costpoint calculates the value in this column by dividing the AMT column by the ACT_HRS column from LAB_HS. This is the unburdened cost of the labor. You can also perform this calculation using the Project Labor Summary Report.

Costpoint calculates the value in this column by using the appropriate BDM column in PROJ_BURD_SUM. The specific column used depends on the period and rate type selections. The labor is subject to this composite burden percentage.

Example:

Labor is subject to the following burdens:

This results in a burden markup of 242%. This is calculated as follows:

Costpoint calculates the value in this column by multiplying the Average Base Labor Rate column by the Burden Markup % column. This is the labor amount after it has been fully burdened.

Costpoint calculates the value in this column by subtracting the Burden Labor Rate from the Billing Rate and dividing the result by the Burden Labor Rate. This is the profit percentage that you are currently realizing for this labor category or employee.

This column is the desired profit percentage that you entered when you executed the Create Project Report Tables screen.

Costpoint calculates the value in this column by multiplying the Burden Markup % column by the Desired Fee % column. It represents what the total markup percentage would be using your incurred rates and the desired fee percentage.

Costpoint calculates the value in this column by multiplying the Average Base Labor Rate column by the Burden Plus Desired Fee % column. It represents the minimum billing rate that you must charge for the labor category or employee to achieve your desired fee percentage with your existing burden rates.

Costpoint calculates the value in this column by multiplying the Allowable Hours column by the Billing Rate column.

Costpoint calculates the value in this column by multiplying the Total Hours column by the Burden Labor Rate column.

Costpoint calculates the value in this column by subtracting the Total Loaded Cost column from the T&M Revenue column.

Costpoint calculates the value in this column by dividing the Gross Profit column by the Total Loaded Cost column and multiplying the result by 100.

The Markup Report contains some of the same columns as the Desired Fee Report. Print the Desired Fee Report if you want to see how some columns of information are derived on the Markup Report.

The source of information for this column is the ACT_HRS column of the LAB_HS table. This information can also be found on the Project Labor Summary Report.

Costpoint calculates the value in this column by subtracting the Allowable Hours column from the Total Hours column.

The source for this column is the ALLOW_REV_HRS column of LAB_HS. Allowable Hours are different from Total Hours if you have exceeded a ceiling.

This information comes from the REV_RT_AMT column of LAB_HS. If you have modified d the billing rate during the report period, you must multiply the REV_RT_AMT by the ALLOW_REV_HRS in LAB_HS to arrive at the T&M revenue. Then divide T&M revenue by the ALLOW_REV_HRS to arrive at the average billing rate.

Costpoint calculates the value in this column by dividing the AMT column by the ACT_HRS column from LAB_HS. This is the unburdened cost of the labor. You can also perform this calculation using the Project Labor Summary Report.

This is column is the desired markup percentage that you entered when you executed the Update Other Project Report Tables process.

Costpoint calculates the value in this column by multiplying the Average Base Labor Rate column by the Desired Markup % column. This is the labor amount after it has been marked up.

Costpoint calculates the value in this column by subtracting the Burden Labor Rate, on the Desired Fee Report, from the Markup Labor Rate and dividing the result by the Burden Labor Rate. This is the profit percentage that you realize for the fully burdened labor category or employee using the Desired Markup %.

This information is available on the Desired Fee Report. Costpoint calculates the value in this column by subtracting the Burden Labor Rate from the Billing Rate and dividing the result by the Burden Labor Rate. This is the profit percentage that you are currently realizing for this labor category or employee.

Costpoint calculates the value in this column by multiplying the Allowable Hours column by the Billing Rate column.

This information is available on the Desired Fee Report. Costpoint calculates the value in this column by multiplying the Total Hours column by the Burden Labor Rate column.

Costpoint calculates the value in this column by subtracting the Total Loaded Cost column from the T&M Revenue column.

Costpoint calculates the value in this column by dividing the Gross Profit column by the Total Loaded Cost column and multiplying the result by 100.