Dell uses the CR5 chip in some of its laptop computers. The prices for the chip during the last 12 m


Question: Dell uses the CR5 chip in some of its laptop computers. The prices for the chip during the last 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 smoothing constants of .1, .3, and .5 Using MAD) Mean Absolute Deviation, which smoothing constant is the best?

Price: $2.99
Solution: The answer consists of 5 pages
Deliverables: Word Document

log in to your account

Don't have a membership account?
REGISTER

reset password

Back to
log in

sign up

Back to
log in