Complete the following problems from Chapter 4 in your text. The Homework Problems Rubric is in Doc Sharing.
• Problem 4.2 a, b and c
• Problem 4.6 a, b and c
• Problem 4.9 a, b, c and d
Submit your assignment to the Dropbox located on the silver tab at the top of this page.
b) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average. Plot your forecast on the same graph as the original data.
c) Starting in year 4 and going to year 12, forecast demand using a 3-year moving average with weights of .1, .3, and .6, using .6 for the most recent year. Plot this forecast on the same graph.
The monthly sales for Telco Batteries, Inc., were as follows:
a) Plot the monthly sales data.
b) Forecast January sales using each of the following:
ii) A 3-month moving average.
iii) A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months.
iv) Exponential smoothing using an α = .3 and a September forecast of 18.
v)A trend projection.
c) With the data given, which method would allow you to forecast next March’s sales?
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 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
a) Use a 2-month moving average on all the data and plot the averages and the prices.
b) Use a 3-month moving average and add the 3-month plot to the graph created in part (a).
c) Which is better (using the mean absolute deviation): the 2-month average or the 3-month average?
d) Compute the forecasts for each month using exponential smoothing, with an initial forecast for January of $1.80. Use α = .1, then α = .3, and finally α = .5. Using MAD, which α is the best?
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more