The following questions is analyzed in this report:
1. Sales team performance by comparing Sales Forecast to Production Forecast.
2. Inefficiencies in forecast by comparing Actual Production to Production Forecast.
3. Identify products with high inaccuracies in forecasts based on historical data
(2019 till date)
4. How many shortages of orders?
5. Sell-through rate:
6. Accuracy of Forecast
7. Identify items in Finished Goods Inventory for which we have no or low sales
(consumed means sold).
8. Fill rate
9. Predict the remaining 2022 forecast using Actual Production vs Production
Forecast
10. Predict the 2022 sales team performance using Sales Forecast vs Production
Forecast
Comments