ZuoTi.Pro
Question

Please help. Im stuck on the exponential smoothing part of this problem. Here are the actual...

Please help. Im stuck on the exponential smoothing part of this problem.

Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period.

MONTH ACTUAL
January 110
February 130
March 150
April 170
May 160
June 180
July 140
August 130
September 140

a. Forecast April through September using a three-month moving average. (Round your answers to 1 decimal place.)

  Month Three-Month
Moving Average
April
May
June
July
August
September

b. Use simple exponential smoothing with an alpha of 0.3 to estimate April through September, using the average of January through March as the initial forecast for April. (Do not round intermediate calculations. Round your answers to 2 decimal places.)

Month Exponential
Smoothing
April
May
June
July
August

September
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1


Exponential smoothening seems to be the best option because of less variation from actuals

0 0
Add a comment
Know the answer?
Add Answer to:
Please help. Im stuck on the exponential smoothing part of this problem. Here are the actual...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Here are the actual tabulated demands for an item for a nine-month period (January through September)....

    Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 110 February 130 March 150 April 170 May    160 June      180 July    140 August 130 September 140 A. Forecast April through September using a three-month moving average. B. Use simple exponential smoothing with an alpha of 0.3 to estimate April through...

  • Please help with questions 7 - 10. PART IV Planning and Controling Operations and Supply Chains...

    Please help with questions 7 - 10. PART IV Planning and Controling Operations and Supply Chains 290 period 1 was 250. Plot the results. Which model appears to work better? Why? 10. After graduating from college, you and your friends start selling birdhouses made from recycled plast has caught on, as shown by the following sales figures For problems 4 through 6, use the following time series data: The idea DEMAND MONTH January 2012 February March April May June 119...

  • Using exponential smoothing of the data, forecast the sales for the month of July. actual sale:...

    Using exponential smoothing of the data, forecast the sales for the month of July. actual sale: March 1,210 April 1,280, May 1,260 June 1,275 Forecast April 1,240 Alpha 0.20

  • Actual sales of TV's for the first six month in 2021 were as follows: January      60           ...

    Actual sales of TV's for the first six month in 2021 were as follows: January      60            February     80          March   42 April           68            May             44           June     72 Use this information and determine in whole numbers: 1 The average actual monthly sales for that period          2 Trends: Reduce this average by 6% per month for the next three months    3 Simple Moving Average (SMA): make a forecast for July using a three months simple moving average.        4 Weighted Moving Average (WMA): make...

  • 1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100...

    1. Using and exponential smoothing model, the forecast for next January sales is: Sales January 100 February 200 March 150 April 400 May 300 June 200 July 250 August 350 September 400 October 350 November 400 December 500 a. 150.0 b. 477.3 c. 450.0 d. Not enough information is given to make a forecast 2. Apply regression to the data shown below. The slope of the line estimated using the regression model is: Sales January 100 February 200 March 150...

  • A manager has been using a certain technique to forecast demand for project management software at...

    A manager has been using a certain technique to forecast demand for project management software at her store. Actual demand and her corresponding predictions are shown below: MonthActual Demand Manager's Forecast March4545April4250May3445June4840July3845 a. What was the manager's forecast error for each month?b. What is the mean error (ME), the mean squared error (MSE), the mean absolute deviation (MAD), and the tracking signal for these five months of forecasting?c. If the manager had used a 3-month moving average instead of her technique, what would have...

  • A particular forecasting model was used to forecast a six-month period. Here are the forecasts and...

    A particular forecasting model was used to forecast a six-month period. Here are the forecasts and actual demands that resulted: FORECAST ACTUAL April 258 358 May 332 482 June 407 507 July 357 307 August 382 282 September 457 582 a. Find the tracking signal for each month. (Negative values should be indicated by a minus sign. Round your answers to the 2 decimal places.) b. Is the model being used is giving acceptable answers. No, the model's performance is...

  • Here are the data for the past 21 months for actual sales of a particular product:...

    Here are the data for the past 21 months for actual sales of a particular product: LAST YEAR THIS YEAR January 330 285 February 450 385 March 455 355 April 455 410 May 410 440 June 435 350 July 400 390 August 310 300 September 355 395 October 480 November 555 December 540 Develop a forecast for the fourth quarter using a three-quarter, weighted moving average. Weight the most recent quarter 0.50, the second most recent 0.25, and the third...

  • Problem 8-4 Exponential Moving Averages (LO4, CFA1) The table below shows the closing monthly stock prices...

    Problem 8-4 Exponential Moving Averages (LO4, CFA1) The table below shows the closing monthly stock prices for IBM and Amazon. Calculate the exponential three-month moving average for both stocks where two-thirds of the average weight is placed on the most recent price. (Do not round intermediate calculations. Round your answers to 2 decimal places.) January Februasy Mareh April June July August September October November December IM $174.44 176.49 190.21 206.45 192.85 208.17 233.16 205.39 220.07 214.47 195.89 175.34 AKZN $611.96...

  • Problem 3-23 After using your forecasting model for six months, you decide to test it using...

    Problem 3-23 After using your forecasting model for six months, you decide to test it using MAD and a tracking signal. Here are the forecast and actual demands for the six-month period: PERIOD May June July August September October FORECAST 425 475 520 600 630 690 ACTUAL 495 510 395 505 700 560 a. Find the tracking signal. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Tracking Signal Period May June July...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT