Question: 1-(15 Points) Using the data in the following table,, a) Compute 2-month moving average forecastsfor all the months. b) Compute MAD for your forecasts in

1-(15 Points) Using the data in the following table,, a) Compute 2-month moving average forecastsfor all the months. b) Compute MAD for your forecasts in part a. c) Compute 3-month moving average forecasts for all the months. d) Compute MAD for your forecast in part c. e) Is 2-month moving average better than 3-month moving average forecasts for this data? Explain and provide support for your decision. Month Demand January 80 February 113 March 70 April 91 May 105 June 100 July 85

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!

Data Table (Click on the following icon in order to copy its contents into a spreadsheet.) Year 2011 2013 Stock A Stock B 2010 -8% 23% 18% 26% 2012 3% 4% -3% - 1% 2014 2% - 15% 2015 5% 17% Print Done...

yes excel is fine Using the data in the following table, consider a portfolio that maintains a 50% weight on stock A and a 50% weight on stock B. Year Stock A Stock B 2009 - 19 14% 2010 10% 29% 2011...

1. (15 points) The following data are the sales data for an air filter at an auto parts store on East Avenue, which were collected each month from January to June this year. Month January February...

Dell uses the CRS chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows. (a) Use a 2-month moving average on all the data and plot the averages and...

Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows: MONTH PRICE PER CHIP ($) MONTH PRICE PER CHIP ($) January 1.80 July 1.80...

4.9 Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows: a) Use a 2-month moving average on all the data and plot the...

Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows: a) Use a 2-month moving average on all the data and plot the averages...

Dell uses the CR5 chip in some of its laptop computers. The prices for the chip during the past 12 months were as follows: Month Price per Chip Month Price per Chip January $1.80 July 1.80 February...

This problem contains 6 questions. Please answer each question in a different work sheet of the same Excel file. For example, you can answer question 1 in sheet 1, question 2 in sheet 2, etc. The...

Problem 4-2 The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The...

What would the circular flow diagram look like in an economy with no government? Draw one for yourself.

Anya Clark opened Anyas Cleaning Service on July 1, 2017. During July, the following transactions were completed. July 1 Anya invested $20,000 cash in the business. 1 Purchased used truck for...

During an audit of your client's financial statements, you discover that your client left the cash receipts journal open after year - end for an extra day. As a result, the accounting records...

What is an example of constructive feedback? provide reference