Question
CLO1- Demonstrate advanced knowledge of operations and supply chain management and its contribution to organization's performance. Chapter 4: Forecasting [Page 137 of test book] Problem:
CLO1- Demonstrate advanced knowledge of operations and supply chain management and its contribution to organization's performance. | |||||||||
Chapter 4: Forecasting [Page 137 of test book] | |||||||||
Problem: Determining Forecast based on methods given below | |||||||||
('000) | |||||||||
Month | Actual Sales | ||||||||
Jan | 55 | ||||||||
Feb | 60 | ||||||||
Mar | 70 | ||||||||
Apr | 68 | ||||||||
May | 78 | ||||||||
June | 85 | ||||||||
July | 80 | ||||||||
Aug | 90 | ||||||||
Sept | 86 | ||||||||
Oct | 95 | ||||||||
Nov | 100 | ||||||||
Dec | 98 |
Required: 1. Calculate the forecast using 4-months moving average (MA) 2. Calculate the forecast using 4-month weighted moving average (WMA) 3. Calculate the mean absolute diviation based on MA and WMA. Which one give you closest forecast using MAD. 4. Show the graph compare actual and forecast based on MA and WMA. 5. Calculate the Exponentially Smoothed Forecast for each month. Assume an an initial forecast of 50,000 units in Jan. Use smoothing constand a = 0.2, a = 0.5, and a = 0.80. 6. Which smoothing constant give you closest forecast. Using MAD and graph. 7. Calculate the trend projection
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started