Cost sheet forecasting allows you to manage the forecast process by detail line items. It utilizes cost-type base commits, change commits, or generic business processes that were included in the Forecasts (Unaccepted) formula.
Here is a high level overview of the Cost sheet forecasting process.
- When a forecast-enabled commitment routes to a terminal status it attains "Unaccepted" status, for example, Base Commits (Unaccepted). Note: this is different from Base Commits (Approved) or any other routing status.
- In this example Base Commits (Unaccepted) line items become available for inclusion in the cost sheet forecast.
- When you click the Forecasting button, the Forecast Adjustment log opens, where you can see all unaccepted line items, based upon the formula used in the Forecasts (Unaccepted) column.
- As these line items are accepted into the forecast, the unaccepted status changes to accepted, for example, Base Commits (Accepted).
- Depending upon cost sheet configuration, for the amount accepted into the forecast:
- Yet To Buy automatically decreases
- Forecast (Unaccepted) decreases
- Forecast increases
To accept line items into the forecast
- In the cost sheet, click the Forecast button. The Forecast Adjustment log opens.
- Select the line items that you want to include in the forecast and click the Include in Forecast button. Select either All Line Items or Selected Line Items. The Select Adjustment Option window opens.
- In the Select Adjustment Option window you have three options. Your selection of an option controls how your cost sheet uses the Yet To Buy (YTB) and Allowance For Change data sources to construct the forecast. Option behavior is as follows:
Automatically adjust YTB
- The system automatically changes the line item to Accepted status, subtracts the amount from the YTB (or adds it if designed to do so), and includes the line item amount in the forecast, if configured to do so.
- Cell Details displays a line item for System Auto Adjustment that shows the transaction in the YTB column
- Because the value of the YTB cannot become negative, each transaction will be processed individually. This may result in only certain transactions being processed, and others staying at Unaccepted status. If the transaction was not processed because doing so would have yielded a negative YTB, the system will cause an alert. The unaccepted line items will be available to view in the Forecast Adjustment window.
Manually adjust YTB and AFC
- This option becomes available in the Cell Detail window when you click the Include in Forecast button
- You can add, delete, or modify line items before including commits into the forecast
- The system does not validate the entry or automatically update the YTB in the cost sheet
No adjustment
- The system will automatically add the commitment into the forecast, if configured, and change the status to Accepted. It will not update the Yet To Buy or Allowance For Change columns.