Additional Problem 03-01 (Algo) Compute a three-period moving average forecast given demand for shopping carts for the last five periods. (Round all your answers to two decimal points) Demani 001.43 Period 1 50 2 48 3 53 4 47 S 54 T 50 33 Forecast Period 4 Forecast Period 5 40 33 Forecast Penod 5 51.33 If actual demand in period 6 turns out to be 51, the moving average forecast for pedod 7 would be Foscast Perige T 00:00 Pray Next > 200134 f Additional Problem 03-02 (Algo) Given the following demand data, Persed 1 50 2 48 53 4 47 54 a. Compute a weighted average forecast using a weight of 0.5 for the most recent period, 0.2 for the next most recent 0.2 for the next, and 01 for the next. (Round all your answers to two decimal points.) Forecast Period 5 Forecast Period 6 b. If the actual demand for period 6 is 51, forecast demand for period 7 using the same weights as in porta Forstant Pecind T 4 hp H a Problem 3-3 (Algo) A dry cleaner uses exponential smoothing to forecast equipment usage at its main plant. August usage was forecasted to be 54 percent of capacity, actual usage was 52 percent of capacity. A smoothing constant of 10 is used a. Prepare a forecast for September (Round your final answer to 2 decimal places) percent of capacity b. Assuming actual September usage of 61 percent, prepare a forecast for October usage. (Round your answer to 2 decimal places) percent of capacity H dx D Problem 3-4 (Algo) Anectinical contractors records during the last five weeks indicate the number of job request 13145 2012121 Cack here for the Excel Data Fe Predict the number of requests for week 6 using each of these methods a. Naive bA tour pertod moving average (Round your answer to 2 decimal places

Save & Eat Sabt 1137 PM Additional Problem 03-07 (Algo) Geven the following demand data, compute a simple exponential smoothing forecast for alpha values of 01 and 04 Use the actual value in Period 1 as your starting forecast in Pentod 2. (Round all your calculations to two decimal points.) 31 11 11 Prey se Next > 11 A . 4 11 34 33 11 10 20 22 199 Q Help Save & Ext Check my 1157 PM 4/14/2022 Problem 3-21 (Algo) Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bomed water. Actual demand and the two sets of forecasts are as follows PRESSTED DOWN PE PA 44 62 2 25 66 1 73 67 5 73 72 67 30 28 77 Click here for the Excet Doth Ele 8. omipute MAD for each set of forecasts. Given your results, which forecast appears to be more accurete? (Round your answers to 2 decimal places) MAD FT 30.71 MAD FL 20.14