Question: Given the following demand data for five consecutive months: January: 120 units February: 130 units March: 140 units April: 150 units May: 160 units

Given the following demand data for five consecutive months: January: 120 units

 February: 130 units March: 140 units April: 150 units May: 160 units What is the forecast for June using a 3-month moving average? Given the following demand data for three consecutive months: January (Actual): 300 units

Given the following demand data for five consecutive months: January: 120 units February: 130 units March: 140 units April: 150 units May: 160 units What is the forecast for June using a 3-month moving average? Given the following demand data for three consecutive months: January (Actual): 300 units February (Actual): 310 units March (Actual): 320 units The forecasted demand was 305 units for February and 310 units for March. The smoothing constant (alpha) is 0.1. What is the forecast for April using Simple Exponential Smoothing? iven the following demand data for six consecutive months: January: 120 units February: 130 units March: 150 units April: 140 units May: 160 units June: 150 units The weights for the 3-month moving average are 0.1, 0.3, and 0.6 for the first, second, and third month respectively. What is the forecast for July using a 3-month weighted moving average? Given the following actual demand and forecasts for the last five months: Month 1 2 3 4 5 Actual Demand 257 240 251 228 228 Forecast What is the Mean Absolute Deviation? 274 258 255 209 217

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 Calculate the forecast for June using a 3month moving average youll average the demand data for the three most recent months March April and May Add ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!