Spreading Costs and Revenues—Exercises

Required Data

Enter Version Lines

Purpose: The purpose of this exercise is to show you the required data that is used in the exercises below.

  1. Enter 3 budget/forecast lines on a project budget/forecast.

General exercise for Enter Forecast Lines

Main Exercise

Purpose: The purpose of these exercises is to spread the costs and revenues in a project in three different ways and confirm the version lines.

Windows:
Project Forecast Info

Spreading Cost and Revenue Manually

  1. Open the Project Forecast Info window and query for the project budget/forecast for which you created budget/forecast lines.
  2. Make sure that the Spread Type field in the first budget/forecast line on the Cost or on the Revenue tab has the value Manual selected.
  3. Select the first budget/forecast line, right-click and click Forecast Spread Details.
  4. Select 4 in the Number of Periods field and observe that four columns with months appear in the table.
  5. Enter values in the four months so that the total would be the value in the Un-spread Amount field.
  6. Save the record (F12).

Spreading Cost and Revenue using Straight Line Method

  1. Open the Project Forecast Info window and query for the project budget/forecast for which you created budget/forecast lines.
  2. On the Cost or on the Revenue tab, select the value Straight Line in the Spread Type field for the second version line.
  3. Save the record (F12).
  4. Select the second budget/forecast line, right-click and click Spread Forecast Amount.
  5. Make sure Use Spread Type from Line is selected and click OK.
  6. Select the second budget/forecast line, right-click and click Forecast Spread Details and observe how the amount has been spread through the months.

Spreading Cost and Revenue using S-Curve

  1. Open the Project Forecast Info window and query for the project budget/forecast for which you created version lines.
  2. On the Cost or on the Revenue tab, select the value S-Curve in the Spread Type field for the third budget/forecast line.
  3. Enter 4 in the Gradient field and 0.4 in the Mid Point field for the third budget/forecast line.
  4. Save the record (F12).
  5. Select the third budget/forecast line, right-click and click Spread Forecast Amount.
  6. Make sure Use Spread Type from Line is selected and click OK.
  7. Select the third budget/forecast line, right-click and click Forecast Spread Details and observe how the amount has been spread through the months.

Confirming Budget/Forecast Lines

  1. Open the Project Forecast Info window and query for the project budget/forecast.
  2. Select the rows in the Cost or on the Revenue tab and click Confirm.