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 Apple’s 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 | 56 |
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.
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.
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.
What is the forecast for March if the store decided to use exponential smoothing forecast model? Use alpha value as 0.3. 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.
What is the forecast for May if the store decided to use exponential smoothing forecast model? Use alpha value as 0.3. 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
3.51 Rating (178 Votes )
There are 3 Steps involved in it
Answer To calculate the forecasts using different methods lets go step by step 1 TwoMonth Moving Average To calculate the forecast for July using a 2month moving average we need the average of the dem... View full answer
Get step-by-step solutions from verified subject matter experts
