The local Apple store performs screen repairs at its store. The store has seen a steady growth

Fantastic news! We've Found the answer you've been seeking!

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 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.