Block 5: Forecasting Instruction : Use the following information to answer questions 23 to 25 Demand data for a product over the last 4 months are given below.

Block 5: Forecasting Instruction: Use the following information to answer questions 23 to 25 Demand data for a product over the last 4 months are given below. 23) Calculate forecast for month 5 using three-month moving averages model. A. 163 B. 153 C. 180 D. 147 E. None of the answers provided is correct. 24) Calculate forecast for month 4 using three-month weighted moving averages model where the weights are 2,1 , and 1 (the highest weight is for the most recent period). A. 152.25 B. 167.25 C. 147 D. 130.20 E. None of the answers provided is conrect. 24) Calculate forecast for month 4 using three-month weighted moving averages model where the weights are 2,1 , and 1 (the highest weight is for the most recent period). A. 152.25 B. 167.25 C. 147 D. 130.20 E. None of the answers provided is correct. 25) If demand forecast for month 3 was 132 , what is the exponential smoothing forecast (with =0.6 ) for month 4 ? A. 142.8 B. 130.2 C. 160.1 D. 132.0 E. None of the answers provided is correct. 26) To predict Sales for the next year, a business analyst collected 4 years of quarterly sales data (in $ millions) and obtained the following regression equation: Y^=282+4t76Q149Q252Q3 where t= time period (1,2,3,,16); Q1=1 if quarter 1;0 otherwise; Q2 =1 if quarter 2;0 otherwise; Q3=1 if quarter 3;0 otherwise. The forecast for quarter 3 of the next year (in \$ millions) is A. 306 B. 274 C. 362 D. 360 E. None of the answers provided is correct