Question: Could someone help me solve this without using an excel file? I'm having trouble with the calculations Forecasting Handout The manager of the Cleaning Solutions

Could someone help me solve this without using an excel file? I'm having trouble with the calculationsCould someone help me solve this without using an

Forecasting Handout The manager of the Cleaning Solutions carpet cleaning company needs a quarterly forecast of the number of customers expected next year. The carpet cleaning business is seasonal, as past 4 years' demand data shown below. Quarter Year 1 Year 2 Year 3 100 70 45 335 520 585 Year 4 100 725 1160 215 2200 370 590 170 1200 Compare the results with those in a 2-year weighted moving average, with weights of 0.8 one period ago, and 0.2 two periods ago. 4. Use exponential smoothing, first with a smoothing constant of 0.2 and then with one of 0.9, to develop forecasts for demand in each quarter through years 2 to 5, assuming Fl=A1. 5. Calculate MAD and TS for exponential smoothing method, with constant 0.9, for each quarter through years 2 to 5, assuming Fl=A1. 6. Use simple linear regression to forecast demand in each quarter of Year 5 (Find a linear regression model for each quarter). 100 830 285 1800 Yearly Total 1000 Demand 1500 1000 End of document I 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 1. Use the Nave forecasting method to forecast demand in each quarter of Year 5. 2. Use a 2-year moving average to forecast demand in each quarter of Year 5. Compare the results with those from a 3- year and 4-year moving average. 3. Using 3-year weighted moving average method, with weights of 0.6 one period ago, 0.3 two periods ago, and 0.1 three periods ago, to forecast demand in each quarter of Year 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!