Distribute Actual Costs to the Cost Worksheet for Requisitions

Contents

The Cost Worksheet provides a central location for tracking all project costs. You can compare budget and committed costs to actual costs for each work element. Open the Cost Worksheet Log Window from the Contract Information folder. Costs are organized by cost codes, which represent various categories of project work.

Use the Requisition Detail Dialog Box to distribute the amounts recorded for work completed this period (Column E in the Requisition Document Window Schedule of Values tab) to the Actuals tab of the Cost Worksheet. Click Add to open the Select Cost Code Dialog Box to add a V row.

To distribute costs for requisitions:

1. Expand the Contract Information folder in the Project View and click Payment Requisitions to open the Payment Requisitions Log Window.
2. Click Edit document next to the payment requisition document for which you want to distribute costs.
3. Click the Schedule of Values tab and click Edit next to the item for which you want to distribute costs.
4. In the Requisition Detail Dialog Box, distribute the value of work completed this period to one or more cost codes by scrolling down to the Costing section (or by clicking costing at the top of the dialog box) and clicking Add to open the Select Cost Code Dialog Box.

   You should distribute amounts to the same cost code used to distribute the original contract sum.

   If you attempt to close the Requisition Detail dialog box without distributing the entire amount, Contract Management distributes the remaining amount to the Not Costed cost code. Using the Project Settings Dialog Box, you can set Contract Management so that the entire amount must be distributed to defined cost codes.

5. Click Add to select another cost code. Click Save and Close when finished.

Contract Management automatically distributes the amounts in the Requisition Detail Dialog Box to either the Actuals Issued or Actuals Received column in the Cost Worksheet:

• If the contract shown at the top of the Requisition document window was distributed to the Original Budget column, Contract Management automatically distributes the requisition amounts to the Actuals Issued column.
• If the contract amount was distributed to the Original Commitment column, Contract Management automatically distributes the requisition amounts to the Actuals Received column.

  Note: If the line item is costed to only one Cost Code, Contract Management will automatically distribute the amount in This Period (column E) to that cost code.