Question: Problem 3-7 The following table contains the demand from the last 10 months MONTH ACTUAL DEMAND 32 30 41 30 41 44 40 10 a.

Problem 3-7 The following table contains the
Problem 3-7 The following table contains the
Problem 3-7 The following table contains the demand from the last 10 months MONTH ACTUAL DEMAND 32 30 41 30 41 44 40 10 a. Calculate the single exponential smoothing forecast for these data using an a of 0.30 and an initial forecast (F) of 32. (Round your intermediate calculations and answers to 2 decimal plac Month Exponenting 3 D 10 b. Calculate the exponential smoothing with frend forecast for these data using an of 0.30 a 6 of 0 20, an initial trend forecast (1) of 100, and an initial exponentially smoothed forecast (s) of Mon FIT 2 3 10 6.1. Calculate the mean absolute deviation (MAD) for the lastnine months of forecasts (Round your intermediate calculations and answers to 2 decimal places.) MAD Single exponential smoothing forecast Exponential smoothing with trand forecast c-2. Which is best? O single exponential smoothing forecast Problem 3-7 The following table contains the demand from the last 10 months MONTH 1 3 5 ACTUAL DEMAND 32 35 30 38 41 30 39 41 44 40 10 a. Calculate the single exponential smoothing forecast for these data using an o of 0.30 and an intial forecast (Ft) of 32 (Round your intermediate calculations and answers to 2 decimal places Exponential Smoothing Month 1 2 3 4 10 b. Calculate the exponential smoothing with trend forecast for these data using an a of 0.30, a 6 of 0 20 an initial trend forecast (T) of 100, and an initial exponentially smoothed forecast (Ft) of 31. FIT Month 1 2 3 4 5 7 8 10 c-1. Calculate the mean absolute deviation (MAD) for the last nine months of forecasts (Round your intermediate calculations and answers to 2 decimal places.) MAD Single exponential smoothing forecast Exponenta smoothing with trand forecast c-2. Which is best? Exponential smoothing with trend forecast O Single exponential smoothing forecast

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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!