Pricing Project Costs

This chapter provides overviews of the various pricing functions in Project Costing and discusses how to:

Click to jump to parent topicUnderstanding Pricing Project Costs

This section discusses:

Click to jump to top of pageClick to jump to parent topicThe Pricing Process

The Pricing Application Engine process (PC_PRICING) calculates transaction costs, overhead, and revenue amounts from source rows, which are transactions that are brought into Project Costing. Source rows can be directly entered into Project Costing by using the Add Transactions component, or entered into a feeder system, such as Expenses, and integrated into Project Costing.

Application Engine processes that bring cost transactions into Project Costing automatically trigger the Pricing process. Adding transactions on the Add Transactions page also triggers the Pricing process. The process matches the costs with rate sets that specify what target rows to create in the Project Transaction table. Target rows are transactions that are created as a result of pricing the source transaction row. The process uses the rate plan to determine which rate sets to run and in what sequence to run them.

You can create revenue rows from cost transactions if you use the Government Contracting feature of Contracts, and select a Contracts installation option to separate billing and revenue rows. This enables you to run the Pricing process independently for direct and indirect costs, billing, and revenue. If you do not select the Contracts installation option to separate billing and revenue rows, then you cannot create a rate set to price for revenue nor can you price transaction rows for revenue.

If you use tiered pricing, the system generates billing rows based on the specified rate set or rate plan, and applies the tiered pricing adjustment percentage to the amount on the target row. If you use organizational sharing and define sharing options and rates, the Pricing process creates sharing rows based on the established rates and exceptions.

Transactions are eligible to price for billing when the project and activity are linked to a rate set or rate plan through Contracts at the contract line level. For example, assume that a voucher is entered in PeopleSoft Enterprise Payables for 100 USD. When the Payables to Project Costing Application Engine process (PC_AP_TO_PC) runs, it selects the cost row from the Voucher Accounting Line table and calls the Pricing process, which creates a billing row from the cost row. When the process completes there are two rows in the Project Transaction table—a row with an analysis type of ACT (actual cost) and a row with an analysis type of BIL (billable amount), as shown in this table:

Source

Analysis Type

Amount

Description

Payables

ACT

100 USD

Materials

Pricing process

BIL

125 USD

Markup 25 percent

You can also use the Pricing process to cost project transactions that will not be billed. This is made possible by associating a rate set with an activity on the Activity Definitions - Rates page in Project Costing. As project-related costs are incurred and sent to Project Costing, the system can determine transaction costs that are associated with the activity based on the rates in the rate set or rate plan. Instead of linking the project and activity to a contract line and rate set in Contracts for billing purposes, you can link the project and activity to a rate set in Project Costing for costing purposes.

Additionally, you can use the Pricing process to price unpriced transaction rows or reprice transaction rows that are in the Project Transaction table. You cannot, however, reprice transactions that are in the process of being billed or sent to the general ledger (GL), or that were generated from the same source transaction as another billable row that is in the process of being billed or sent to GL.

Process Flow

The high level steps to create cost, billing, and revenue rows by using the Pricing process are:

  1. Determine the elements that contribute to pricing calculations based on your business processes.

    For example, do you use rates by employee, project role, or job code? Do you mark up source transaction amounts to create billing rows, or do you use fixed amounts? Do you associate rate sets with project types, projects, activities, or specific contract lines?

  2. Set up installation and business unit options.

  3. (Optional) Set up tiered pricing.

  4. (Optional) Set up rules and exceptions for organizational sharing.

  5. Create rate sets.

  6. Create rate plans.

  7. Associate projects and activities with rate sets or rate plans and contracts.

  8. Price the transactions to create cost, billing, and revenue rows by using feeder systems to automatically trigger the Pricing process.

  9. Review the transactions, make changes to rates, and manually run the Pricing process to reprice rows as necessary.

See Also

Tracking Activity Billing and Project Costing Rates

Integrating with Contracts and Billing

Defining Accounting Rules

Understanding Accounting Distributions

Click to jump to top of pageClick to jump to parent topicTransactions Eligible for Pricing

The Pricing process uses these system sources, in combination with distribution statuses, to identify transactions that are eligible for processing:

If you select the Separate Billing and Revenue option on the Installation Options - Contracts page, the billing distribution status indicates if a transaction row has been priced for billing, and the revenue distribution status indicates if the row has been priced for revenue. This enables you to separately monitor pricing for billing and revenue.

Repricing

Similar to the Pricing process, the Repricing process considers the pricing options that you select on the Pricing run control page.

You can reprice transactions that:

You can view the distribution statuses of the source transaction row on the Transaction Detail page.

See Also

Maintaining Transaction Information

Click to jump to top of pageClick to jump to parent topicInstallation and Business Unit Pricing Options

During installation determine if you want to enable organizational sharing for rate-based contract lines. Other pricing options at the installation level are used when the Pricing process is triggered for the business unit by Application Engine processes from feeder systems, or through the Add Transactions functionality in Project Costing. For example, because the rates that the Pricing process uses are effective-dated, you can specify the date type (transaction or accounting) that the system uses to determine the rate set or rate plan to use for pricing.

Options that you select at the business unit level are also used when the Pricing process is triggered for the business unit by Application Engine processes from feeder systems, or through the Add Transactions functionality in Project Costing. Select pricing options of Cost, Billing, or both for the system to use to determine which rows to create. If the Separate Billing and Revenue option is enabled on the Installation Options - Contracts page, you can also select a pricing option of Revenue. By using pricing options, you can tell the system to create costs (indirect and direct), billing, and revenue recognition rows separately. The pricing options that you select for the business unit appear by default as the selected pricing options on the Pricing run control page. You can override the business unit default values when you initiate the Pricing process on the Pricing run control page.

Cost and Bill Rate Restrictions in Program Management

If you use Program Management, at the business unit level you can restrict the rate types that users can select for cost and bill rates for activity resources. The rate types that you enable for business unit control the rate options that you can select on the Rate Sets - Target page as follows:

All rate options are available for selection when you set up revenue recognition target rows.

Click to jump to top of pageClick to jump to parent topicTiered Pricing

Tiered pricing enables you to adjust the rate that the system applies to cost transactions during the Pricing process based on quantities that accumulate against a contract line. This type of pricing applies to rate-based, contract-line processing only.

Tiered pricing requires the use of transaction identifiers, which are similar in concept to using analysis groups. Transaction identifiers provide users with the flexibility to identify and group project ChartField values and eliminate the need to identify the ChartField values each time they define tiered pricing for a new contract line.

Note. To implement tiered pricing, you must install Contracts. Contracts with a Government classification are not eligible for tiered pricing.

See Also

Pricing Contracts

Click to jump to top of pageClick to jump to parent topicOrganizational Sharing

Use organizational sharing to share costs and revenue between the organization that owns the transaction and the organization that owns the project or activity.

If sharing rules are defined and activated, the Pricing process calls the Sharing Application Engine process (PSA_SHARING) to search for rows that are designated for sharing. A row is eligible for the Sharing process if the organization that owns the project or activity differs from the organization that owns the transaction, an applicable sharing rule exists, and the row does not qualify as an exception to the sharing rules.

Note. Contracts with a Government classification are not eligible for organizational sharing.

Click to jump to top of pageClick to jump to parent topicRate Sets

Rate sets enable you to create transaction rows for use in costing, billing, revenue recognition, or reporting, from incoming or existing transactions in the Project Transaction table. Rate sets have two parts:

For example, you can use multiple criteria on the source page to create billing rows one way for rows with a source type of MATER (material) and another way for a source type of LABOR. The materials can be billed at cost, while the labor is marked up. The billing rows are defined by the target definition (bill MATER rows at cost, mark up LABOR rows using employee rates) and the project ChartFields.

There is a one-to-many relationship between source criteria and target row definitions. One source row, such as a cost transaction or a billing transaction, can create multiple target rows.

You can attach rate sets or rate plans to:

Rate sets and rate plans are effective-dated, which enables you to maintain a set of current rate sets and rate plans, and set up rate sets and rate plans for anticipated future use. The effective date also enables you to adjust prior transactions, if necessary.

Rate Definition Types

You specify a rate definition type when you create a rate set. By using rate definition types, the Pricing process can create costs (indirect and direct), price transactions for billing, and price transactions for revenue recognition. Rate definition types control the type of rows that the Pricing process creates by restricting the analysis types that you can select on the rate set for target rows. For example, when you create a rate set with a cost rate definition type, the system restricts the target rows to analysis types that belong to the actual cost analysis group. The default actual cost analysis group is PSCST (Accounting Costs), which is specified on the Installation Options - Project Costing page along with the actual revenue and billing analysis groups. During implementation you can override the default analysis groups for actual cost, revenue, and billing.

This table lists the rate definition types and analysis types that you can select for target rows:

Rate Definition Type

Target Row Analysis Types

Cost

For target rows you can select analysis types that belong to the analysis group that is specified in the Actual Cost field on the Installation Options - Project Costing page. The default analysis group is PSCST (Accounting Costs).

Note. You can enable variance pricing on rate sets with a cost rate definition type.

Billing

For target rows you can select analysis types that belong to the PSWKS (Billing Worksheet Grouping) analysis group.

Revenue

The Revenue rate definition type is available if you use Contracts and you select a Contracts installation option to separate billing and revenue rows. For target rows you can select analysis types that belong to the PSRV2 (Government Contracting System Revenue) analysis group, or that belong to the analysis group that is specified in the Revenue field on the Installation Options - Project Costing page. The analysis group default value on the Installation Options - Project Costing page is PSREV (System Revenue).

Rate Options

Rate options specify how the Pricing process calculates the rates for the corresponding target rows. For example, you can select a rate option of ECO on a target row to use the cost rates that are defined for the employee on the Rates by Employee page. For the ECO rate option, the Pricing process calculates the target amount as the source row transaction quantity × the employee-specific cost rate × the rate set rate amount.

Each rate option is associated with a specific formula that the system uses to calculate the target amount. In the previous example, the source row transaction quantity is the quantity available in the Project Transaction table for the specific row that is being priced. The employee-specific cost rate is the rate that is defined for the employee on the Rates by Employee page. The rate amount on the target row functions as a multiplier for any rate option except the FIX rate option. If you select the FIX rate option, the rate amount functions as the actual rate.

These factors affect the list of rate options that are available for selection:

A complete list of rate options that are available for selection on the Rate Sets - Target page is discussed in the business process section of this chapter.

See Defining Rate Sets and Plans.

Contract-Specific and Standard Rate Sets

In Project Costing you can create rate sets and rate plans that are either contract-specific or standard (general). You can link contract lines to contract-specific or standard rate sets or rate plans. A contract-specific rate plan can contain both standard and contract-specific rate sets. A standard rate plan can contain standard rate sets only.

This table lists the valid combinations of standard and contract-specific rate sets and rate plans that you can attach to activities and contract lines:

Attach at the Activity Level

Attach at the Contract Line Level

Standard rate set

Nothing

Standard rate plan

Nothing

Standard rate plan

Contract-specific rate set

Nothing

Standard rate set

Nothing

Standard rate plan

Nothing

Contract-specific rate set

Nothing

Contract-specific rate plan

You can link an activity that has a rate plan defaulted from the project type or project to a contract line. If the contract line is linked to a rate set or contract rates, the system processes the contract line rate set first, followed by the activity rate plan.

Click to jump to top of pageClick to jump to parent topicRate Plans

A rate plan is a collection of rate sets that the system executes in a specified order. Use rate plans to link rate sets so that priced rows from one rate set are used to create additional priced rows from the next rate set. For example, you can add additional expenses, such as administrative costs or overhead, to cost transactions before they are priced for billing or revenue.

The Pricing process uses the rate plan to determine which rate sets to run and in what sequence to run them. When setting up the rate plan, you can assign rate sets in any combination of rate definition types—cost, billing, and revenue. You can assign the same rate set to multiple rate plans.

Rate plans are similar to rate sets in these areas:

This diagram shows the tables that the system uses to process rate plans:

Tables that the system uses to process rate plans

Source rows that enter Project Costing from feeder systems are stored in a Project Transaction subrecord (PROJ_RES_TMP) and copied into the PRT_PRICE temporary table.

Basis

A basis is assigned to each rate set in a rate plan and tells the Pricing process what transactions to use to create the target rows for a rate set.

Basis options are:

Sequence

When transactions come into Project Costing from PeopleSoft feeder systems, the Pricing process uses the pricing options that you select for the business unit to tell the system what kind of rows to create from the source transactions. The pricing options correspond to the rate definition types—Cost, Billing, or Revenue—that are assigned to rate sets. You can process all rate sets on a rate plan even if the rate sets contain different rate definition types, or you can process a subset of rate sets on a rate plan. When the Pricing process runs for a rate plan, the rate sets are processed for the selected pricing options in the sequence that is defined on the rate plan.

For example, assume that you create a rate plan and attach rate sets to the plan in the order of COST1, BILL1, COST2, BILL2, and REV1. When you run the Pricing process for all three pricing options (Cost, Billing, and Revenue), the system first processes the COST1 rate set, followed by BILL1, COST2, BILL2, and REV1. Because of this processing logic, you should add rate sets to rate plans in the order in which you want them to run.

If you run the Pricing process by using the Pricing run control page, you specify the rate sets to process by selecting pricing options (Cost, Billing, and Revenue) on the run control page. The rate sets are processed in the order that is defined on the rate plan, based on the pricing options that you selected on the run control page.

Click to jump to top of pageClick to jump to parent topicExample of Using Rate Sets and Rate Plans to Price Transactions

This diagram shows an example of pricing inbound transactions from Expenses to Project Costing:

Pricing flow between Expenses and Project Costing

As an example of using rate sets on a rate plan to price incoming transactions from time reports in Expenses, assume that you set up two rate sets. Rate Set ABC has a cost rate definition type and uses incoming time report transactions (rows with a TLX analysis type) to create actual cost transactions (rows with an ACT analysis type) by using the ECO rate option. The ECO rate option multiplies the source row transaction quantity × the employee-specific cost rate × the target row rate amount.

Rate Set DEF has a billing rate definition type and uses the same incoming time report transactions as source rows to create billing transactions (rows with a BIL analysis type) by using the EBI rate option. The EBI rate option multiplies the source row transaction quantity × the employee-specific bill rate × the target row rate amount.

Now set up a Rate Plan GHI that contains Rate Set ABC and Rate Set DEF. Both rate sets use the original, incoming time report transactions as source rows. After Rate Plan GHI processes the rate sets, the Project Transaction table will contain cost transaction rows with an analysis type of ACT, and billing transaction rows with an analysis type of BIL. The transaction amounts on these rows are based on the rate option on the rate set that was current at the time that you ran the Pricing process.

Click to jump to top of pageClick to jump to parent topicDistribution Statuses

These distribution status fields in the Project Transaction table support rate set and rate plan processing:

Transaction rows must have a distribution status of N (not distributed or new) to be included in the Pricing process. To process a transaction row for a cost rate definition type, the cost distribution status must be N for the row. To process a row for a billing rate definition type, the billing distribution status must be N. Similarly, to process a row for a revenue rate definition type, the revenue distribution status must be N.

The possible distribution status values are:

Note. The Process Project Accounting Application Engine process (PSA_ACCTGGL) assigns the G status value to the GL Distribution Status field (GL_DISTRIB_STATUS) for rows that are associated with contracts revenue. The Contracts Load Update Application Engine process (CA_LOAD_UPD) updates the GL Distribution Status value to D for these rows in the Project Transaction table.

Click to jump to top of pageClick to jump to parent topicVariance Pricing

If you use the Government Contracting feature of Contracts, you can capture variance pricing for cost rate definition types. Variance pricing, or retroactive rate adjustments, are required when government contractors retroactively apply new rates to previously processed transactions. You can enable variance pricing on a standard or contract-specific rate set. By using this option you can enter, track, and process variance rates on the Rate Variance History page.

The Enable Variance option appears on the Rate Sets page if you select a cost rate definition type. To use variance pricing, you must associate the rate set with a contract that has a classification of government. You cannot inactivate variance pricing on a rate set if a variance rate exists on one or more target rows in an effective-dated rate set.

See Also

Performing Variance Pricing

Click to jump to top of pageClick to jump to parent topicLimits Processing

When the Pricing process runs as a standalone process, and if you use Contracts, the Pricing process calls the Apply Limits Application Engine process (CA_LIMIT) for the contract line that is being priced. Use the Pricing run control page to run Pricing as a standalone process. The Pricing process passes run control parameters to the Apply Limits process to create over-the-limit rows for revenue transactions, billing transactions, or both. The revenue option is available only if you select a Contracts installation option to separate billing and revenue rows.

When the Pricing process is automatically triggered by incoming transactions from feeder systems, the Pricing process also calls the Limits process. The Pricing process uses the selected pricing options (Revenue and Billing) on the Project Costing Options page for the business unit of each row, and passes those parameters to the Limits process to determine the type of transactions to limit check—revenue, billing, or both.

You can also run the Apply Limits process in Contracts independently of the Pricing process. Regardless of how the Apply Limits process is called, it evaluates transaction level limits first and then contract line level limits for all pending transactions for each contract line in its scope. Resulting over-the-limit transactions are excluded from revenue recognition and billing, and are not sent to General Ledger or Billing, respectively, except for over-the-limit transactions that are created from released retainage, which pass from the billing worksheet directly to the Project Transaction Temporary Billing table (PROJ_RES_TMP_BI) to be inserted into the Project Transaction table.

Because you apply limits at the contract line level, you cannot run the Apply Limits process for specific Project Costing business units, projects, or activities.

The system limit checks these analysis types:

The system uses these analysis groups to process limits:

The Variance Pricing Application Engine process (PC_VAR_PRICE) writes new rows to the Project Transaction table for the difference in the new and old rates. The Limits process treats these transactions as new rows.

See Also

Creating and Managing Limits

Creating and Managing Limits

Click to jump to top of pageClick to jump to parent topicPricing Transactions Associated with a Work Order

Project Costing tracks the cost of work that is performed against tasks on a work order if you use Maintenance Management. Transaction costs flow from Maintenance Management into various PeopleSoft applications such as Time and Expense, Inventory, Payables, and Purchasing, and from these systems into Project Costing. The Project Transaction table stores the work order business unit, work order ID, task ID, work order resource type, and work order resource line number for each transaction row for the work order task.

When you designate projects as work order managed, it tells the system that these projects are managed with work orders in Maintenance Management, instead of by a project manager in Project Costing. For work order-managed projects, the Pricing process retrieves cost and billing rates from the work order labor rate to calculate the resource amount.

The high level steps to set up work order pricing are:

When you set up rate sets for use with work orders, select the WBI and WCO rate options on the Rate Sets - Target page to use the work order labor bill and cost rates. Administrators use the Default Rate Set field in the Project Costing group box in the WO Business Unit - Integration Options page (BUS_UNIT_TBL_WM2) in Maintenance Management to specify the rate set that the system uses as a default for chargebacks for work order-managed projects. The default rate set on the work order business unit overrides the default project rate set or plan on the project.

Project Costing Application Engine processes that collect costs from feeder systems assign a value of H (on hold) to the GL distribution status field for transactions on open work order tasks. This prevents the Process Project Accounting process from processing transactions for open work order tasks. When a work order task closes, the system updates the value of the GL distribution field for the transactions to C (costed). The Process Project Accounting process uses the WBI and WCO rates from the Work Task Labor Schedules table (WM_WO_SCHED_LBR) to process the transactions on closed work order tasks that are associated with work order managed projects.

See Also

Integrating with Maintenance Management

Setting Up Rules and Data Related to Project Costing

Click to jump to top of pageClick to jump to parent topicPricing Projects from Proposals

If you use Proposal Management and Program Management, Proposal Management uses the bill and cost role rates and hours that are captured in the proposal to populate the Resources page (PC_PRL) and Resources by Activity page (PC_ARL) in Program Management. Unadjusted role rates are treated as Project Role rate types and have the rate that was in effect when the role was added to the proposal. Adjusted role rates are treated as Custom rate types.

Rate sets for labor from proposals can use rate options ABI (Activity Resource Bill Rate) and ACO (Activity Resource Cost Rate) for labor source transactions. These rate options tell the Pricing process to use the bill and cost rates on the Resources by Activity page in Program Management to calculate billing and costing amounts for labor source transactions. Use the Resources by Activity page to modify role rates for projects from proposals.

The system obtains nonlabor pricing information from the rate set, and rate plans from the contract lines in Contracts.

The Pricing process treats resource classes of Asset, Material, and Other as nonlabor resources. Rate sets for nonlabor from proposals use a rate option of NON (Bill at Cost). After the PM Generate process completes, the Pricing process and the PGM_SPREAD process do not retrieve any information from the PM proposal.

Markups and Markdowns

On the Project Definitions - Rates page for projects that are created from proposals, you can enter a labor or nonlabor adjustment percentage that the system uses to determine a billing markup or markdown row amount. This field appears for projects that are created from proposals in Proposal Management.

The labor adjustment percentage is used in conjunction with the AML (Mark Up/Down Labor) rate option that you select on the Rate Sets - Target page. The AML rate option tells the system to use the signed percentage amount in the Labor % field on the Project Definitions - Rates page to determine the markup or markdown value. The AMN (Mark Up/Down Nonlabor) rate option tells the system to use the signed percentage amount in the Non-Labor % field on the Project Definitions - Rates page to determine the markup or markdown value. The Pricing process creates the target transaction values based on the signed percentage of the source transaction rows

You can create markup and markdown target billing transactions from labor and nonlabor source transactions. You cannot create markup and markdown target costing transactions from labor and nonlabor source transactions.

Click to jump to parent topicImporting Transactions into Project Costing

Various PeopleSoft Application Engine processes that are specific to feeder system applications send cost transactions to Project Costing.

This section lists the pages used to bring cost transactions into Project Costing.

Click to jump to top of pageClick to jump to parent topicPages Used to Bring Process Cost Transactions into Project Costing

Page Name

Object Name

Navigation

Usage

Time and Labor

PC_TL_TO_PC

Project Costing, Cost Collection, Time and Labor, Time and Labor

Run the Time and Labor to Project Costing Application Engine process (PC_TL_TO_PC) to pull data from Time and Labor into Project Costing.

Note. The billing distribution status of the transaction rows that are imported by using the Time and Labor to Project Costing process is based on the billable indicator in the Time and Labor system. These transaction rows are sent to the Pricing process with cost and revenue distribution statuses of N.

Expenses

PC_EX_TO_PC

Project Costing, Cost Collection, Expenses, Expenses

Run the Expenses to Project Costing Application Engine process (PC_EX_TO_PC) to pull approved expenses from Expenses into Project Costing.

Note. In Expenses if you specify a billing action of Nonbillable or Internal on a detail time or expense row, the Expenses to Project Costing process creates a transaction row in the Project Transaction table with a billing distribution status of U (unbillable). The system assigns an analysis type to the transaction based on the analysis type that is specified in the Expenses field (for expense rows) or Mobile Time / Expense field (for time rows) on the Installation Options - Project Costing Integration page. When you price the unbillable row, if the target analysis type on the rate set belongs to the PSWKS analysis group, the system deletes the target row and does not post it to the Project Transaction table.

Payables

PC_AP_TO_PC

Project Costing, Cost Collection, Payables, Payables

Run the Run the Payables to Project Costing Application Engine process (PC_AP_TO_PC) to pull approved vouchers from PeopleSoft Enterprise Payables into Project Costing.

Inventory

PC_IN_TO_PC

Project Costing, Cost Collection, Inventory, Inventory

Run the Inventory to Project Costing Application Engine process (PC_IN_TO_PC) to pull fulfilled demands from PeopleSoft Enterprise Inventory into Project Costing.

Order Management

PC_OM_TO_PC

Project Costing, Cost Collection, Order Management, Order Management

Run the Order Management to Project Costing Application Engine process (PC_OM_TO_PC) to pull project data from open sales orders into Project Costing.

Purchasing

PC_PO_TO_PC

Project Costing, Cost Collection, Purchasing, Purchasing

Run the Purchasing to Project Costing Application Engine process (PC_PO_TO_PC) to pull purchase order transactions into Project Costing.

Services Procurement

PC_SP_TO_PC

Project Costing, Cost Collection, Services Procurement, Services Procurement

Run the Services Procurement to Project Costing Application Engine process (PC_SP_TO_PC) to pull expense transactions into Project Costing.

Click to jump to parent topicDefining Rates for Employees, Job Codes, and Project Roles

To define rates for employees, job codes, and project roles, use these components:

Use the PC_RATE_EMPL_INTFC component interface to load data into the tables for the PC_RATE_EMPL component.

Use the PC_RATE_JOBC_INTFC component interface to load data into the tables for the PC_RATE_JOBC component.

This section discusses how to define rates by employees, job codes, and project roles.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Rates for Employees, Job Codes, and Project Roles

Page Name

Object Name

Navigation

Usage

Rates by Employee

PC_RATE_EMPL

Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rates by Employee, Rates by Employee

Define, view, and modify cost and billing rates for the selected employee.

Note. The Pricing process uses the PC_RATE_EMPL_VW view to apply employee rates to cost transactions. Rates that you access by using this view are visible on the Rates by Employee page.

Rates by Job Code

PC_RATE_JOBC

Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rates by Job Code, Rates by Job Code

Define, view, and modify cost and billing rates for a specific job code.

Note. The Pricing process references the PC_RATE_ROLE_VW view to apply project role rates to cost transactions. Rates that you access by using this view are visible on the Rates by Role page.

Note. The Pricing process references the PC_RATE_JOBC_VW view to apply job code rates to cost transactions. Rates that you access by using this view are visible on the Rates by Job Code page.

Rates by Role

PC_RATE_ROLE

Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rates by Role, Rates by Role

Define, view, and modify cost and billing rates for a specific project role.

Click to jump to top of pageClick to jump to parent topicDefining Rates by Project Role

Access the Rates by Role page.

Enter the necessary data to define cost and billing rates for a project role.

Unit of Measure

Enter the unit of measure for which the rate is defined. If a unit of measure conversion is defined, a conversion takes place during processing for transactions that use a different unit of measure.

Regions

Assign one or more rates to a project role based on different regions by using the Regions grid. The Regions grid appears if you use Program Management and Resource Management. Use this feature if you need to cost or price labor differently for roles that are performed on projects at different locations.

In the Bill and Cost tabs in the Resources page and Resources by Activity page in Program Management, if the rate type is Project Role, the system uses the rate that corresponds to the value in the Region field on that page. You are not required to associate a region with a project role rate. If the role and region combination is not defined on the Rates by Role page, the system uses the default rate.

There is an exception to regions processing when you select a rate option of RBI (Role Bill Rate) or RCO (Role Cost Rate) on the Rate Sets - Target page. To calculate rates by using the role rate options of RBI or RCO, the Pricing process uses only the project role rates that are defined on the Rates by Role page. Regional rates are not considered when you use the RBI or RCO rate option.

Click to jump to parent topicDefining Rate Sets and Plans

To define rate sets and rate plans, use these components:

Use the PC_RATE_INTFC component interface to load data into the tables for the PC_RATE component.

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to Define Rate Sets and Plans

Page Name

Object Name

Navigation

Usage

Rate Sets

PC_RATE_DTL

  • Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Sets

  • Customer Contracts, Contracts Center, Definitions, Rate Sets

Define source criteria that identifies cost transactions from which you want to create target rows.

Enter New Rate Set Keys

PC_RATE_DTL_SUB

Click Copy from Rate Set on the Rate Sets page.

Copy a rate set to create a new rate set in the same business unit or across business units.

Rate Sets - Target

PC_RATE_DTL_LN

  • Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Sets, Target

  • Click the Target link on a row in the Define Criteria for Incoming Transactions grid on the Rate Sets page.

Define rate set target criteria to create cost, billing, or revenue rows.

Rate Plans

PC_RATE_PLAN

Setup Financials/Supply Chain, Product Related, Project Costing, Pricing Structure, Rate Plans, Rate Plans

Combine rate sets so that the target rows from one rate set are used to create additional target rows from the next rate set.

Enter New Rate Plan Keys

PC_RATE_PLAN_SUB

Click Copy from Rate Plan on the Rate Plans page.

Copy a rate plan to create a new rate plan in the same business unit.

Click to jump to top of pageClick to jump to parent topicDefining Standard or Contract-Specific Source Rows

Access the Rate Sets page.

Rate Set

Enter a rate set identifier. Rate set identifiers are used to run the Variance Pricing Application Engine process (PC_VAR_PRICE) and as selection criteria when setting up a rate plan. This is a required field.

Copy from Rate Set

Click to access the Enter New Rate Set Keys page to enter the business unit and rate set ID of an existing rate set that you want to copy. Click OK on the Enter New Rate Set Keys page to return to the Rate Sets page with fields populated with data from the existing rate set.

The Copy from Rate Set button appears only in add mode.

Note. You can copy a standard rate set to another standard rate set. You cannot copy contract-specific rate sets.

Rate Definition Type

Select one of the following options that determines the type of target rows that the Pricing process will create from this rate set:

Cost: Creates target rows to track and calculate contract, project, and indirect costs.

Billing: Creates billable rows that can be passed to Billing for invoice generation.

Revenue: Creates revenue recognition rows that can be passed to General Ledger. This option is available if you select the Separate Billing and Revenue option on the Installation Options - Contracts page.

You cannot modify the rate definition type after you save the page. To modify a rate definition type on a rate set, create a new rate set and assign the appropriate rate definition type.

Enable Variance

Select to indicate that this rate set can contain variance rates. This option enables you to enter a rate variance on the Rate Sets - Target page. You cannot clear this check box if a variance rate exists on one or more target rows.

This option appears only if you select a cost rate definition type for the rate set variance. You can use variance pricing only for contracts with a government classification.

See Performing Variance Pricing.

Defining Criteria for Incoming Transactions

To set up a rate set, you define criteria that the system uses to identify the source transactions from feeder systems that are priced using this rate set. At a minimum, you must select an analysis type. All other fields may be identified with a wildcard character (%) to select all transactions that are associated with the specified analysis type. Otherwise, populate the additional fields to identify specific transactions that you want the system to select and price using this rate set.

If you selected the Enable Variance option on the Rate Sets page, the source rows in the Define Criteria for Incoming Transactions grid must contain at least one different value for analysis type, source type, category, or subcategory than the target rows in the Define Target Rows grid. If this condition does not exist, when you click the History link on the Rate Sets - Target page to access the Rate Variance History page, a message will appear stating that the rate set definition is not eligible for variance pricing.

Target

Click the Target link on a source row to define the target criteria that the Pricing process uses to create priced transaction rows.

Analysis Type

Enter the analysis type that the system uses to identify the source transactions that are priced using this rate set.

Source Type

Enter a source type to limit the transactions selected for pricing to only transactions that are associated with this specific source type. Source types enable you to define a value that identifies a transaction's purpose. You can use source types to track, analyze, and report on transactions.

Category

Enter a category to limit the transactions selected for pricing to only transactions that are associated with this specific category. Categories enable you to further define source types to better track the types of costs that are incurred against the project and activities.

Subcategory

Enter a subcategory to limit the transactions selected for pricing to only transactions that are associated with this specific subcategory. Subcategories enable you to further define categories to better track the types of costs that are incurred against the project and activities.

Project Role

Enter a project role to limit the transactions selected for pricing to only transactions that are associated with this project role.

Job Code

Enter a job code to limit the transactions selected for pricing to only transactions that are associated with this job code.

Time Reporting Code

Enter a time reporting code to limit the transactions selected for pricing to only transactions that are associated with this time reporting code.

Employee ID

Enter an employee ID to limit the transactions selected for pricing to only transactions that are associated with this employee.

Unit of Measure

Enter a unit of measure to limit the transactions selected for pricing to only transactions associated with this unit of measure.

Currency

Enter a currency code to limit the transactions selected for pricing to only transactions in this currency.

General Ledger Business Unit

Enter a GL business unit to limit the transactions selected for pricing to only transactions that are associated with this GL business unit.

Account

Enter an account code to limit the transactions selected for pricing to only transactions that are associated with this account code. Account codes classify the nature of a transaction.

Alternate Account

Enter an alternate account to limit the transactions selected for pricing to only transactions that are associated with this alternate account. Alternate accounts classify the nature of a transaction for regulatory authorities. Use it for statutory accounting.

Operating Unit

Enter an operating unit to limit the transactions selected for pricing to only transactions that are associated with this operating unit. Operating units can indicate a location.

Fund Code

Enter a fund code to limit the transactions selected for pricing to only transactions that are associated with this fund code. Fund codes are the primary structural units of education and government accounting.

Department

Enter a department to limit the transactions selected for pricing to only transactions that are associated with this department. Use departments to track information according to a divisional breakdown of your organization. Departments can indicate who is responsible for, or affected by, a transaction.

Program Code

Enter a program code to limit the transactions selected for pricing to only transactions that are associated with this program code. Program codes track revenue and expenditures for programs within or across your organizations. Program codes can identify groups of related activities, cost centers, revenue centers, responsibility centers and academic programs.

Class Field

Enter a class field to limit the transactions selected for pricing to only transactions that are associated with this class field. Class fields can identify specific appropriations.

Budget Reference

Enter a budget reference value to limit the transactions selected for pricing to only transactions that are associated with this budget reference value. Budget references can identify unique budgets, when individual budgets share budget keys and overlapping budget periods.

Product

Enter a product to limit the transactions selected for pricing to only transactions that are associated with this product. The product ChartField captures additional information that is useful for profitability and cash flow analysis by product sold or manufactured.

Affiliate

Enter an affiliate code to limit the transactions selected for pricing to only transactions that are associated with this affiliate code. Affiliate codes are used to map transactions between business units when you use a single interunit account.

Fund Affiliate

Enter a fund affiliate code to limit the transactions selected for pricing to only transactions that are associated with this fund affiliate code. Use fund affiliate codes to correlate transactions between funds when you use a single intraunit account.

Operating Unit Affiliate

Enter an operating unit affiliate to limit the transactions selected for pricing to only transactions that are associated with this operating unit affiliate. Use operating unit affiliates to correlate transactions between operating units when you use a single intraunit account.

Click to jump to top of pageClick to jump to parent topicDefining Rate Set Target Rows

Access the Rate Sets - Target page.

Note. The system supports the use of wildcards (the percent symbol) but does not support the use of partial wildcards (alphanumeric characters in combination with the percent symbol).

The ChartField values that you define for the source row on the Rate Sets page appears on the Rate Sets - Target page for reference.

You can associate each source row with multiple target rows.

Rate Option

Select an option to specify how the system derives the rates for the corresponding target row. These factors affect the list of rate options that are available for selection:

  • Some rate options are available only if you integrate with other PeopleSoft applications.

    For example, if you use Maintenance Management, you can select the WBI and WCO rate options to use the work order labor bill and cost rates. If you use Program Management, you can select the ABI and ACO rate options to use the activity labor resource rates that appear on the Program Management Resources by Activity page.

  • If you use Program Management, the available rate options are also based on the rate types that are specified for the business unit.

    For example, if the business unit specifies that you can use only rates by employee for cost and bill rates, the rate options that appear for selection are limited to EBI and ECO.

Rate options are:

  • ABI: Activity Resource Bill Rate applies the resource bill rate that appears on the Resources by Activity page, and sets the Target amount equal to:

    Source transaction quantity x Activity resource bill rate x Target rate amount

    Activity resource bill rates are stored in the Bill Rate field (BILL_RATE) in the Project Activity Team Member table (PROJ_ACT_TEAM). If there is no bill rate defined for a resource on the Resources by Activity page, or the bill rate is zero, the Pricing engine uses the resource's bill rate from the Resources page for the project.

    The ABI rate option is available only if you use Program Management, and is not supported for variance pricing.

  • ACO: Activity Resource Cost Rate applies the resource cost rate on the Resources by Activity page and sets the target amount equal to:

    Source transaction quantity x Activity resource cost rate x Target rate amount

    Activity resource cost rates are stored in the Cost Rate field (COST_RATE) in the Project Activity Team Member table (PROJ_ACT_TEAM). If there is no cost rate defined for a resource on the Resources by Activity page, or the cost rate is zero, the Pricing engine uses the resource's cost rate from the Resources page for the project.

    The ACO rate option is available only if you use Program Management, and is not supported for variance pricing.

  • AML: Mark Up/Down Labor uses the signed percentage amount in the Labor % field on the Project Definitions - Rates page to determine the markup or markdown value. This option is available only if you use Proposal Management.

  • AMN: Mark Up/Down Nonlabor uses the signed percentage amount in the Non-Labor % field on the Project Definitions - Rates page to determine the markup or markdown value. This option is available if you use Proposal Management.

  • AMT: Quantity Rate sets the target amount equal to:

    Source row transaction quantity × Rate set-specific rate × Target row rate amount

    You must enter a value in the To Currency field if you select the AMT rate option.

  • EBI: Employee Bill Rate (as defined on the Rates by Employee page) which sets the target amount equal to:

    Source row transaction quantity × Employee-specific bill rate × Target row rate amount

  • ECO: Employee Cost Rate (as defined on the Rates by Employee page) sets the target amount equal to:

    Source row transaction quantity × Employee-specific cost rate × Target row rate amount

  • FIX: Fixed Amount sets the target amount equal to the rate amount defined on the rate set.

  • JBI: Job Code Bill Rate (defined on the Rates by Job Code page) sets the target amount equal to:

    Source row transaction quantity × Job code bill rate × Target row rate amount

  • JCO: Job Code Cost Rate (defined on the Rates by Job Code page) sets the target amount equal to:

    Source row transaction quantity × Job code cost rate × Target row rate amount

  • MUP: Markup Rate marks up the transaction amount by the value in the Rate Amount field.

  • NON: Carries the source amount from the source transaction directly to the target row.

  • RBI: Role Bill Rate (defined on the Rates by Role page) sets the target amount equal to:

    Source row transaction quantity × Role bill rate × Target row rate amount

    For target rows with a rate option of RBI, the role bill rate is based on the role fulfilled by the employee on the activity team. If no role exists for the employee on the activity team, the process uses the employee's role on the assignment schedule if Program Management is installed. Finally, if no role exists for the employee on the assignment schedule, the process uses the employee's role on the project team.

  • RCO: Role Cost Rate (as defined on the Rates by Role page) sets the target amount equal to:

    Source row transaction quantity × Role cost rate × Target row rate amount

    For target rows with a rate option of RCO, the project role cost rate is based on the role fulfilled by the employee on the activity team, assignment schedule (if Program Management is installed), or project team, in that order.

  • WBI: Work Order Labor Bill Rate

    To collect work order labor costs for billing, you can create a rate set that uses this rate option for the analysis type that you specify in the Mobile Time / Expense field on the Installation Options - Project Costing Integration page. This option is available if you use Maintenance Management.

  • WCO: Work Order Labor Cost Rate

    To collect work order labor costs for costing, you can create a rate set that uses this rate option for the analysis type that you specify in the Mobile Time / Expense field on the Installation Options - Project Costing Integration page. This option is available if you use Maintenance Management.

Rate Amount

Enter a multiplier that the system uses in conjunction with the rate option to calculate target rows. For example, if you select a rate option of EBI and enter a rate amount of 1.1, the system multiplies the source row transaction quantity x the employee's bill rate x 1.1 to arrive at the target row amount.

For variance pricing, you cannot enter rate changes directly in this field. Instead you must use the Rate Variance History page.

Description

Enter a description that appears on target rows and is passed to Billing for use on the invoice. Leave the field blank or enter a wildcard (the percent symbol) for the description on the source transaction to appear by default on the target transaction.

Target Analysis Type

Select an analysis type for the system to assign to target rows. Leave the field blank for the analysis type from the source transaction to appear by default on the target rows.

The target analysis types that are available for selection are based on the rate definition type.

Note. If the Separate Billing and Revenue option is cleared on the Installation Options - Contracts page, when you specify the billing rate set-target analysis type you can select analysis types from the PSWKS analysis group. In this situation you cannot define a separate revenue rate set.

Override Source

Select to override the source type, category, or subcategory from the source transaction that appears by default on the target transaction. If you select this option, enter a Target Source Type, Target Category, or Target Subcategory value to use on the target rows.

To Currency

Specify the currency that the system uses to calculate the target rows. This field does not apply to government contracts, as billing and revenue recognition must take place in the contract currency.

This field is required if you select the AMT rate option.

Click to jump to top of pageClick to jump to parent topicDefining Standard or Contract-Specific Rate Plans

Access the Rate Plans page.

Rate Plan Type

Select the rate plan type for this rate plan. Available values are:

Standard: Select to create a rate plan that is generally available for pricing any contract line associated with any contract type.

Note. Selecting the standard rate plan type automatically populates the Rate Set Type field as Standard and cannot be overridden.

Contract: Select to create a rate plan that is used to price a particular contract line. By selecting the contract rate plan type you can select standard or contract rate set types on the rate plan and create a rate plan that meets the specific need of your contract line by combining contract-specific and standard pricing rates.

Copy from Rate Plan

Click to access the Enter New Rate Plan Keys page where you can copy an existing rate plan to create a new rate plan in the same business unit.

Note. You can copy a standard rate plan to another standard rate plan. You cannot copy contract-specific rate plans.

You can copy rate plans only from within the same business unit.

Rate Set Type

Displays the rate set type (Contract or Standard) from the rate set.

For a contract rate plan, enter a rate set type of Contract or Standard for each rate set that you want to add to the rate plan. If you select Contract as the rate set type, you must select a rate set that is associated with the same contract line as the rate plan.

For a standard rate plan, the system automatically populates the Rate Set Type field as Standard and cannot be overridden. You can select only standard rate sets for a standard rate plan.

Rate Set

Select the rate set to include in your rate plan. You can select rate sets that are defined and active as of the effective date of the rate plan. Enter rate sets the in the order that you want the Pricing process to price the rows. Rate sets are processed in the order that you enter on this page, and only if they have a rate definition type that corresponds to the pricing options that you select on the Pricing run control page.

A rate set can appear only once in a rate plan.

Basis

Select the basis that tells the Pricing process what source transactions to use to create the target rows for the rate set. Available options are:

Original: The system uses the original source transactions to create target rows for the specified rate set.

Target: The system uses the target rows that have been created on this rate plan thus far as the basis for creating the target rows for this rate set.

All: The system uses all of the original source rows and all of the previously created target rows on the rate plan to create target rows for this rate set.

Rate Definition Type

Displays the rate definition type (Cost, Billing, or Revenue) from the rate set. The Pricing process can price transactions for costs, billing, revenue, or any combination based on the options that you select on the Pricing run control page.

Review Rate Set

Click the rate set description to access the Rate Sets page and view or modify the rate set.

Click to jump to parent topicDefining Tiered Pricing

This section discusses how to define transaction identifiers.

Click to jump to top of pageClick to jump to parent topicPages Used to Define Tiered Pricing

Page Name

Object Name

Navigation

Usage

Transaction Identifiers

PC_TRANS_IDENTIFY

Set Up Financials/Supply Chain, Product Related, Project Costing, Transaction Options, Transaction Identifiers, Transaction Identifiers

Define transaction identifiers for use in the Tiered Pricing feature.

Tiered Pricing Template

PC_TIER_TEMPLATE

Set Up Financials/Supply Chain, Product Related, Contracts, Templates, Tiered Pricing Templates, Tiered Pricing Template

Define a tiered pricing template that facilitates defining tiered pricing for contract line.

Note. You define tiered pricing templates in the Contracts system.

See Defining Tiered Pricing Templates.

Click to jump to top of pageClick to jump to parent topicDefining Transaction Identifiers

Access the Transaction Identifiers page.

See Transaction Identifiers.

Click to jump to parent topicRunning the Pricing Application Engine Process

This section discusses how to price transaction rows by manually initiating the Pricing process.

Click to jump to top of pageClick to jump to parent topicPage Used to Run the Pricing Application Engine Process

Page Name

Object Name

Navigation

Usage

Pricing

PC_PRICING

Project Costing, Utilities, Pricing, Pricing

Run the Pricing process to price or reprice transactions.

Click to jump to top of pageClick to jump to parent topicPricing Transaction Rows

Access the Pricing page.

Transaction Detail

Click to access the Transaction List page to view the transactions.

Application Options

Reprice Rows

Select to reprice transactions in the Project Transaction table. You can reprice transactions that have not been sent to GL, have not been billed or sent to Asset Management, are not linked to an asset, or have not been used for fee calculations in Contracts.

When you reprice rows the Pricing process calls the Tiered Pricing, Limits, and Sharing processes, in that order.

Note. If a cost row generated one or more billing or revenue rows, and if any of the rows in the process exist on billing or revenue fee worksheets, none of the other rows that are associated with the original cost row are eligible for repricing.

Price Unpriced Rows

Select to price unpriced cost rows in the Project Transaction table that were not previously priced by the Pricing process.

Note. You cannot select this option to run the Pricing process if any source transaction row on the run control has been priced for any combination of cost, billing, or revenue. You can, however, select the Reprice Rows option as these source transaction rows are eligible for repricing.

Recalculate Tiered Pricing

Select to recalculate quantities that are eligible for tiered pricing if the original tiered-pricing agreements change. When you select this option, the system selects the Reprice Rows option because repricing is required in order to recalculate tiered pricing inception to date amounts.

Transactions that are already processed by Billing or General Ledger are not repriced or adjusted using a different tiered pricing adjustment; however, quantities from the source rows will be included in the correct tier so the inception to date reflects these quantities.

Pricing Options

Select Cost (indirect and direct), Billing, Revenue, or any combination, to tell the system what kind of rows to create from the source transactions. The pricing options correspond to the rate definition types that are assigned to rate sets.

The Revenue option is available if you use the Government Contracting feature of Contracts and select the Contracts installation option to separate billing and revenue rows. Otherwise, the Revenue option is not available for selection.

If you choose a run control option of Business Unit, Business Unit/Project, or Business Unit/Project/Activity, the options that appear selected by default in the Pricing Options group box are based on the pricing options that are selected for the business unit. You can override the business unit default pricing options on the run control page.

Contract

Enter a contract ID, if applicable, to provide additional transaction search criteria.

Contracts Business Unit

Enter a contract business unit, if applicable, to provide additional transaction search criteria.

Sold to Customer

Enter a contract sold to customer, if applicable, to provide additional transaction search criteria.

Contract Classification

Enter a contract classification, if applicable, to provide additional transaction search criteria.

When you use the Pricing page to price or reprice transactions for activities that are associated with fixed-fee contract lines, do not enter any contract-related information in the Application Options group box. Activities associated with fixed-fee contract lines are treated as Project Costing-related pricing; therefore, entering contracts-related information prevents the system from picking up fixed-fee data for pricing.

Note. This run control page is used to process transactions from all contract classifications. If you want to initiate the Pricing process for a specific set of contracts, such as government contracts, you must enter search criteria such as project, activity, contract classification, and so on, to identify the transactions to include in this run control.

Click to jump to parent topicViewing Team Rates

The Project Team and Activity Team Rate Sheets provide visibility to the standard rates that are associated with each team member. Project managers can select a view to display standard rates by employee, job code, or role.

Note. When the Pricing process prices cost transactions, the rate set dictates which, if any, of the standard rates are used and whether there is any markup or adjustment to the standard rate.

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPages Used to View Team Rates

Page Name

Object Name

Navigation

Usage

Project Team Standard Rate Sheet

PC_TEAM_RATES

Project Costing, Project Definitions, Team, Team

Click the Team Rates link on the Project Definitions - Team page.

View team roles, job codes, project availability dates, and cost and bill rates by employee, project role, and job code for project team members.

Activity Team Standard Rate Sheet

PC_ACT_TEAM_RATES

Project Costing, Activity Definitions, Team, Team

Click the Activity Team Rates link on the Activity Definitions - Team page.

View the cost and bill rates for activity team members by employee, job code, or role.

See Also

Understanding Pricing Project Costs

Click to jump to top of pageClick to jump to parent topicViewing Project Team Rates

Access the Project Team Standard Rate Sheet page.

Project team members appear on this page if you defined a project team role for the member.

View Rates by

Select Employee, Job Code, or Role to view different project team rates.

Cost Rate and Bill Rate

Displays the cost and bill rates associated with the team member and the option that you select in the View Rates by field. The system converts these rates as necessary to the currency of the business unit.

See Also

Staffing Project and Activity Teams

Click to jump to top of pageClick to jump to parent topicViewing Activity Team Rates

Access the Activity Team Standard Rate Sheet page.

View Rates by

Select Employee, Job Code, or Role to view different activity team rates.

Cost Rate and Bill Rate

Displays the cost and bill rates associated with the activity team member and the option that you select in the View Rates by field. The system converts these rates as necessary to the currency of the business unit.

See Also

Scheduling and Managing Resources