please use excel and show how to do each step! thank you!

Problem 3-24 (Algo) Zeus Computer Chips, Inc., used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the quad-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its product lines. Here is demand over the past 12 quarters: TWO YEARS AGO I II III IV 4,790 3,490 4,290 2,990 LAST YEAR I II III IV 3,490 2,690 3,490 2,390 THIS YEAR I II III IV 3,190 2,096 2,690 1,690 Use the regression and seasonal indexes to forecast demand for the next four quarters. (Round your intermediate calculations and answers to 2 decimal places.) Period Forecast (Units) 1 IV