A 1 Problem 5-17 Data 2 3 4 Year 5 1 6 2 7 3 8 4 9 5 10 6 11 7 12 8 13 9 14 10 15 11 B C Demand for fertilizer (1,000s of bags) 4 6 4 5 10 8 7 9 12 14 15 Develop a trend line for the demmand for fertilizer Problem 5-21 Data year 1 2 3 4 5 6 sales 450 495 518 563 584 ? sales of cool man air conditioners have grown steadily for the past 5 years The sales manager had predicted before the business started that year 1's sale would be 410 air conditioners ****Using exponential smoothing with a weight of a=.30 develop forecats for years 2 thru 6 Please review below and add additional info to complete problem a)MAPE0.3=15.37% b)MAPE3-MA 11.71%. c)Y=421.20 +33.60X if years are coded 1 to 5. MAPE = 1.08%. d)Linear trend analysis Problem 5-29 Data Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Calls 50 35 25 40 45 35 20 30 35 20 15 40 55 35 25 55 55 40 35 60 75 50 40 65 Emergency calls to winter park, Florida's 911 system for the past 24 weeks as follows: A. Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week B. Reforecast each period using a=0.6 C. Actual calls during the 25th week were 85. Which smoothing constant provides a superior forecast? week and use a=0.1. What is the forecast for the 25th week? In the past, Julie Holme's tire dealership sold an average of 1,000 radials each year. In the past 2 years, 200 and 250, respectively were sold in fall, 350 and 300 in winter With a major expansion planned, Judy projects sales next year to increase to 1,200 radials. What will the demmand be each season? ter, 150 and 165 in spring and 300 and 285 in summer A 1 Problem 5-17 Data 2 3 4 Year 5 1 6 2 7 3 8 4 9 5 10 6 11 7 12 8 13 9 14 10 15 11 B C Demand for fertilizer (1,000s of bags) 4 6 4 5 10 8 7 9 12 14 15 Develop a trend line for the demmand for fertilizer Problem 5-21 Data year 1 2 3 4 5 6 sales 450 495 518 563 584 ? sales of cool man air conditioners have grown steadily for the past 5 years The sales manager had predicted before the business started that year 1's sale would be 410 air conditioners ****Using exponential smoothing with a weight of a=.30 develop forecats for years 2 thru 6 Please review below and add additional info to complete problem a)MAPE0.3=15.37% b)MAPE3-MA 11.71%. c)Y=421.20 +33.60X if years are coded 1 to 5. MAPE = 1.08%. d)Linear trend analysis Problem 5-29 Data Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Calls 50 35 25 40 45 35 20 30 35 20 15 40 55 35 25 55 55 40 35 60 75 50 40 65 Emergency calls to winter park, Florida's 911 system for the past 24 weeks as follows: A. Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week B. Reforecast each period using a=0.6 C. Actual calls during the 25th week were 85. Which smoothing constant provides a superior forecast? week and use a=0.1. What is the forecast for the 25th week? In the past, Julie Holme's tire dealership sold an average of 1,000 radials each year. In the past 2 years, 200 and 250, respectively were sold in fall, 350 and 300 in winter With a major expansion planned, Judy projects sales next year to increase to 1,200 radials. What will the demmand be each season? ter, 150 and 165 in spring and 300 and 285 in summer A 1 Problem 5-17 Data 2 3 4 Year 5 1 6 2 7 3 8 4 9 5 10 6 11 7 12 8 13 9 14 10 15 11 B C Demand for fertilizer (1,000s of bags) 4 6 4 5 10 8 7 9 12 14 15 Develop a trend line for the demmand for fertilizer Problem 5-21 Data year 1 2 3 4 5 6 sales 450 495 518 563 584 ? sales of cool man air conditioners have grown steadily for the past 5 years The sales manager had predicted before the business started that year 1's sale would be 410 air conditioners ****Using exponential smoothing with a weight of a=.30 develop forecats for years 2 thru 6 Please review below and add additional info to complete problem a)MAPE0.3=15.37% b)MAPE3-MA 11.71%. c)Y=421.20 +33.60X if years are coded 1 to 5. MAPE = 1.08%. d)Linear trend analysis Problem 5-29 Data Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 Calls 50 35 25 40 45 35 20 30 35 20 15 40 55 35 25 55 55 40 35 60 75 50 40 65 Emergency calls to winter park, Florida's 911 system for the past 24 weeks as follows: A. Compute the exponentially smoothed forecast of calls for each week. Assume an initial forecast of 50 calls in the first week B. Reforecast each period using a=0.6 C. Actual calls during the 25th week were 85. Which smoothing constant provides a superior forecast? week and use a=0.1. What is the forecast for the 25th week? In the past, Julie Holme's tire dealership sold an average of 1,000 radials each year. In the past 2 years, 200 and 250, respectively were sold in fall, 350 and 300 in winter With a major expansion planned, Judy projects sales next year to increase to 1,200 radials. What will the demmand be each season? ter, 150 and 165 in spring and 300 and 285 in summer