Question: The local Apple store performs screen repairs at its store. The store has seen a steady growth in the the number of repairs each month.
The local Apple store performs screen repairs at its store. The store has seen a steady growth in the the number of repairs each month. The store needs a good forecast so that they know how many spare screens should be ordered from Apples distribution center so that they readily have the screens in stock in their backroom. The store has accumulated the demand data shown in the table below for the first six months of the year:
| Period | Month | Demand |
| 1 | January | 35 |
| 2 | February | 38 |
| 3 | March | 39 |
| 4 | April | 35 |
| 5 | May | 43 |
| 6 | June | 53 |
1. Given the above information, what is the forecast July if the store decided to use a 2 month moving average? Provide your answer up to 2 decimal points. Do not use commas or units. For example, if the answer is 44.32 units then input 44.32.
2. What is the forecast for July using weighted moving average if the weights are distributed as t = 60% and t-1 = 40%? Provide your answer up to 2 decimal points. Do not use commas or units. For example, if the answer is 44.32 units then input 44.32.
3. What is the forecast for July using weighted moving average if the weights are distributed as t = 50% and t-1 = 50%? Provide your answer up to 2 decimal points. Do not use commas or units. For example, if the answer is 44.32 units then input 44.32.
4. What is the forecast for March if the store decided to use exponential smoothing forecast model? Use alpha value as 0.6. Also, assume the forecast for January is 35 units. Provide your answer up to 2 decimal points. Do not use commas or units. For example, if the answer is 44.32 units then input 44.32.
5. What is the forecast for May if the store decided to use exponential smoothing forecast model? Use alpha value as 0.6. Also, assume the forecast for January is 35 units. Provide your answer up to 2 decimal points. Do not use commas or units. For example, if the answer is 44.32 units then input 44.32.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
