Forecasting:

Will upvote, Thank you

Exercises: Forecasting Saved Help Save & Exit Submit Check my work 3 Additional Problem 03-03 (Algo) 2 points A coffee shop owner wants to estimate demand for the next four quarters for hot chocolate. Sales data consist of trend and seasonality. Quarter relatives are 1.04 for the first quarter, 1.20 for the second quarter, 0.61 for the third quarter, and 1.15 for the fourth quarter. Using the appropriate values of quarter relatives and the equation Ft = 128 +6.1t for the trend component, estimate demand for periods 9-12. (Round all calculations to two decimal points.) Skipped Demand Period 9 eBook Demand Period 10 Demand Period 11 Demand Period 12 Print References Check my work 4 Additional Problem 03-04 (Algo) 2 points eBook The table below shows actual and forecasted nubmers of accounts serviced by a company. Compute MAD, MSE, and MAPE for the following data, showing actual and forecasted numbers of accounts serviced. (Enter whole number values in the table below for Error, IErrorl, and Error 2. Round the IErrorl/Actual to three decimals. Enter O where necessary, do not leave any cells blank. Negative values should be indicated with a minus sign, i.e. -2. Round MAD, MSE and MAPE to 3 decimal places.) Period Actual Forecast A-F(Error) Error Error2 (Error|/Actual) x 100 1 614 609 2 611 612 3 612 615 4 616 618 620 621 623 623 7 627 626 8 631 629 Print 5 - References 6 MAD MSE MAPE