Custom (Funding) Cost Worksheet Section Overview

Contents

Use this feature to be able to cost to a third, customizable cost category in the Cost Worksheet. When you enable Show Funding Cost Worksheet on the Cost Options tab of the Project Settings Dialog Box, a new module called Contracts <Custom> (Funding) appears in the Contract Information folder of the project in the Project View. Several new <Custom> columns also appear in the Cost Worksheet. You can then create new custom contracts as a third cost category customized for your business, and then create any change documents and trends against the custom contract. The custom documents are costed to the Custom columns in the Cost Worksheet.

On the Details tab of a custom Contract Document Window, the Cost Category field indicates that this contract is being costed to the custom columns of the Cost Worksheet. You can change the term <Custom> to any term that applies to your situation. Use the Folders Dialog Box to change the name of the Custom Contracts (Funding) module, and the Customize Text Dialog Box to change "Custom" to an appropriate term.

Notes:

• If a change order is linked to a <Custom> contract, the change order's Cost Category is set to <custom>. <Custom> change orders added outside of Change Management collect changes costed to that cost category.
• For trends, the <Custom> option is added below Commitment in the Cost Category drop-down.

Cost Worksheet Columns

When this feature is activated, the following columns are added to the Cost Worksheet log window after the Commitment Percent column:

• Actuals Expended

  Calculation: Total amount of requisitions and invoices distributed to <Custom> Estimated.

• Original <Custom>

  Calculation: Total amount of contracts, Purchase Orders, and trends distributed to <Custom> Original.

• Approved <Custom> Revisions

  Calculation: Total amount of approved <Custom> Change Orders and trends.

• Revised <Custom>

  Calculation: Original <Custom> plus Approved <Custom> Revisions.

• Pending <Custom> Revisions

  Calculation: Total amount of Change Orders, Proposals, and trends distributed to <Custom> Pending.

• Estimated <Custom> Revisions

  Calculation: Total amount of trends distributed to <Custom> Estimated.

• <Custom> Adjustments

  Calculation: Total amount of trends distributed to <Custom> Adjustment.

• Projected <Custom>

  Calculation: Original <Custom> plus Approved <Custom> Revisions plus Pending <Custom> Revisions plus Estimated <Custom> Revisions plus <Custom> Adjustments.

• <Custom> Percent

  Calculation: Actuals Expended multiplied by 100 divided by (Original <Custom> plus Approved <Custom> Revisions).