Reviewing the Forecast

The forecast in cell C26 represents total cycle time. To view its formula in the Microsoft Excel formula bar, select cell C26. The formula is =SUM(C14:C24) — the sum of the assumptions for Steps 1 through 6.

  To view and edit the forecast definition:

  1. Choose Define, then Define Forecast or click the toolbar button. Define Forecast button

    The Define Forecast dialog opens.

    Figure 165, Cycle Time Forecast with LSL and Target Entered, following, shows that the forecast has a name, a units entry, and a USL, the upper specification limit of 96 hours. These were entered when the example model was first defined.

    Figure 165. Cycle Time Forecast with LSL and Target Entered

    Cycle Time Forecast showing LSL and Target entered.

    As established in the Define phase of this project, 96 hours is the loan processing target as well as the USL.

  2. Enter 96 in the Target edit box and click OK.