Capital Projects / Capital Budgeting

Evaluating Scenario Funding

After setting up your funding scenarios using the Plan Scenario Costs task, you can evaluate and edit your scenarios in the Evaluate Scenario Funding task. This task allows you to review and edit all of the yearly funding information for a given scenario.

Note : You can also review all the scenarios that use a funding source in the Review Scenarios by Fund task.

For information on how to set up funding scenarios using the Plan Scenario Costs task, see the Creating Funding Scenarios topic.

After setting up funding scenarios, you can apply a funding scenario to your funding allocations. For more information, see the Allocating Funding topic.

This topic includes the following sections:

Evaluate Scenario Costs Process

The diagram below illustrates the process that you use to evaluate scenario funding. For information on the database tables used in the Evaluate Scenario Costs process, see the Evaluate Scenario Funding Tables topic.

scenario process flowchart
Procedure: Evaluating and Editing Funding Scenarios

To evaluate and edit a funding scenario with existing Scenario Costs data:

  1. Select the Evaluate/Evaluate Scenario Funding task.
  2. In the drill-down selection list, select a project and a scenario.

    A view analysis table displays the Scenario Cost and Baseline Cost information for each fiscal year. The entries that you have already defined for each funding source are displayed.

    Note 1: For each funding source, Baseline Costs are displayed above the Scenario Costs for each fiscal year. Each funding source Baseline Costs value displays the total for all action baseline estimates within a project for a given fiscal year. These baseline cost estimates display useful data for you to refer to while reviewing and editing your Scenario Cost values for each funding source.

    Note 2 : The Baseline Costs row lists the total for all Baseline Cost estimates entered for all action items for a project. This amount is shown in the Total row and in the row for each funding source.

  3. Click on a Scenario Cost value to edit cost information for the given fiscal year for the selected funding source.

    The Add or Edit Scenario Item dialog appears.

  4. Edit Capital and Expense costs for the funding source, and select a Funding Source if needed.
  5. Click Save.
    The revised scenario cost information appears in the table.
  6. Click Close.
  7. Edit Scenario Cost values for the other funding source values in the table.
  8. To add additional funding sources to the table:
    1. Click Add Scenario Item.

      The Add Scenario Item dialog appears,

    2. Select a new funding source and enter Capital and Expense cost values.
    3. Click Save and then Close.
    4. A new row appears for the new funding source data that you have added.

Note : When you select a project to display its funding source data, by default the Scenario Costs initially are allocated to the Not Specified Fund. When you add a funding allocation to another funding source, this does not affect the amount allocated to the Not Specified Fund. You can change the amount allocated to the Not Specified Fund by editing this fund's allocation.

Reviewing Scenarios by Funding Source

To review scenarios by funding source:

  1. Select the Evaluate / Review Scenarios by Fund task.
  2. In the left panel, select a Funding Source.
    All of the project scenarios that include allocations to the selected Funding Source are displayed.
  3. To generate a report, click DOC.
  4. To export the data to Excel, Click XLS.