Understanding the AIM Forecast Table
FollowUnder the forecast charts and configuration panels, you will find the Forecast Table with tabs for your forecast details, replenishments, parent assemblies and product analysis.
Let's review the details outlined in the Forecast tab:
Columns are included for each month prior to and after the current month. Use your scroll wheel to scroll horizontally.
Demand
Forecast:
The quantity of demand forecast per month. The current months and future months can be edited, while historic months are read-only, allowing you to compare your actual demand to forecast to measure the accuracy.
You're able to easily type the forecast in by typing a value into the current month and hitting enter to move to the next cell. Repeat this until complete and then click out of the cell. The forecast will be calculated in a single step, allowing easy data entry.
You don't need to enter a forecast value, if you are only using the production demand calculated from assembled products.
Actual (Allocated):
This row actually shows two separate measures. The current month and historic months show the quantity of actual demand. The current month includes the allocated quantity in brackets, so you will see a value similar to this: 120 (10) indicating that you have 120 units sold this month and 10 more allocated to sell this month. The rows of future months will show the allocated quantity set to ship that month. This is useful if you have sales orders, or assemblies entered well in advance.
Production Demand:
If your product is a component with production demand calculated by a related assembled item, then you will see a row for production demand. This is similar to the forecast row. Production Demand is the quantity forecast be to consumed in assemblies starting with that month.
Linear Trend:
The value of the linear trend line per month. Check the Demand chart to see visually how this linear projection of your actual demand is extending through the forecast.
Seasonal Trend:
The value of the Seasonal Trend line per month. Check the Demand chart to see visually how this seasonally adjusted calculation is forecasting for the future.
Supply
Required:
The Required row shows the quantity of replenishment the forecast has calculated needs to be placed per month. If your forecast is configured with demand and a stock holding strategy, you can review this row to see the total replenishment required beyond your open transactions. Use this row to help plan your replenishments with suppliers or in production planning.
If you have forecast demand and have no required stock, then you might be overstocked!
Open (Incoming):
This row will show the quantity of stock coming from open transactions. Review the Supply chart to see how these open transactions are affecting your stock on hand levels.
End of month SOH:
Your end of month Stock on Hand is displayed per month. Review the Supply chart to see how your stock on hand is moving per day.