ZuoTi.Pro
Question

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 September, using the average of January through March as initial forecast for April.

C. Use MAD to decide which method produced the better forecast over the six-month period.

business   accounting   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

eephe wwing OT) Forecast three -Actual values previous NO Month -Average Metbcal. For eca ct value - Fsum Janti0 Feb 130 Mah ISo 130 ISD 160 130 10 30 30 30 1 c June go -30 30 -LD g190 LLO sep | 140 ぐ! 150 3 2 MAD 3.33-4冫-actual value bb demand-foh PreVious Mordb h: est percd-focus Palue alpha =0.3 Jar Feb 130 Ap 10 ay60 1 ID 40 12 130 une So 32-6 17.18 2a 03 Jul 120 152.09 22 03 5 52 14-Average pefheds 43.33 mehed Hence Simple exponential vtefhthe best one to prodluce a betle, sesecast valueAnswer

1 0
Add a comment
Know the answer?
Add Answer to:
Here are the actual tabulated demands for an item for a nine-month period (January through September)....
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

  • 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...

  • 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...

  • Month Price per Chip Month Price per Chip January $1.80 July 1.80 February 1.67 August 1.83...

    Month Price per Chip Month Price per Chip January $1.80 July 1.80 February 1.67 August 1.83 March 1.70 September 1.70 April 1.85 October 1.65 May 1.90 November 1.70 June 1.87 December 1.75 Use a 3-month moving average and add the 3-month plot to the graph created in part (a). Which is better (using the mean absolute deviation): the 2-month average or the 3-month average? Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of...

  • 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...

  • 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

  • You are an operation manager at Gambas Berhad. You plan to use several forecasting methods for...

    You are an operation manager at Gambas Berhad. You plan to use several forecasting methods for the purpose. The following data represent the actual monthly company sales for 2018. Month Value (RM000 32 41 53 59 46 31 27 24 10 35 54 105 Ja March ril un August ber November December (a) Calculate the Mean Absolute Deviation (MAD) and make a forecast for January 2019 sales based on the following methods: i. 4-month moving average. (5 marks) i. Weighted...

  • Use the following sales data to answer the questions. Month                              Sales January&nbsp

    Use the following sales data to answer the questions. Month                              Sales January                              $250,000 February                            $200,000 March                               $300,000 April                                  $350,000 May                                   $450,000 Using a two month moving average, what are the expected sales for June? Using a three month moving average, what are the expected sales for June? Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six months are shown below, along with the results of two different...

  • Please complete the analysis for "Bill's Brew Threw" case on page 470. (edited question: spreadsheet modeling...

    Please complete the analysis for "Bill's Brew Threw" case on page 470. (edited question: spreadsheet modeling for business decisions by john f. kros. Edition: 5) 448 CHAPTER7 Introduction to Forecasting Forecasting Using Exponential Smoothing for Bill's Brew Threw Background Bill Fredericks runs a minimart that sells basic convenience goods like soda, bee snacks. Bill's business is good and relatively stable over time (i.e., no large trend downward over time). However, he has noticed changes in the amount of soda h...

  • The Actual demands in the last 4 periods are given. Which of the following statement is...

    The Actual demands in the last 4 periods are given. Which of the following statement is not true? Period Ai Weight 1 10 2 20 0.3 3 30 0.3 4 20 0.4 A. F5=23.33 using Moving Average and n=3 B. F5=20 using Naive Approach C. When the business environment is more dynamic, we tend to choose smaller smoothing constant value. D. F5=23 using Weighted Moving Average when n=3 and the weight is 0.4, 0.3, and 0.3 for period 4, 3,...

  • FC.62 Mitchell's Mills is a startup looking to break into the preparedness market with a revolutionary...

    FC.62 Mitchell's Mills is a startup looking to break into the preparedness market with a revolutionary new wheat grinder called the WG1. Since Mitchell's is a new company they do not have any historical data for sales of its flagship product, but they estimate they will be able to sell 505 in the month of April. The table below contains actual sales data for April and each of the succeeding five months (through September): Month Forecast WG1s Sold 467 1...

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