Which is better the 2 month average or the 3 month average

Reference no: EM13838704

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 %u03B1 = .1, then %u03B1 = .3, and finally %u03B1 = .5. Using MAD, which %u03B1 is the best?

Reference no: EM13838704

Questions Cloud

Refrigerated trucks-monitoring temperatures during transit : Atlas Transportation is considering installing temperature logger in all its refrigerated trucks for monitoring temperatures during transit. If the systems will reduce insurance claims by $40,000 per year for 5 years how much should the company be wi..

semi annually through company-sponsored saving plan : Ryan expects to deposit $1,000 now, $3,000 four years from now, and $1,500 six years from now in an account that is earning 12% per year compounded semi annually through a company-sponsored saving plan. What amount can he withdraw ten years from now?

What is your annual effective interest rate : If you have a credit card with 14.4% APR. What is your monthly interest rate and what is your annual effective interest rate? If you have an outstanding balance of $1,800 on that card what would be the balance if you skipped 4 months payments (ignore..

Change in the importance of residential loans : What is the difference between lending to individual borrowers via a residential home mortgage compared to other types of consumer lending - Explain the difference between bank credit risk and bank capital risk?

Which is better the 2 month average or the 3 month average : Use a 2-month moving average on all the data and plot the averages and the prices. 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 th..

Non-union workers who command lower wage : A firm can hire unionized workers, who have received additional training and are therefore more productive than non-unionized workers, or non-union workers who command a lower wage. If the firm hires unionized workers, how many workers and how much c..

U-shaped average total cost curve implies what : A U-shaped average total cost curve implies what?

When the average total cost curve is rising : When the average total cost curve is rising, then the marginal cost curve will be?

Optimal consumption bundles for the consumer : An individual has an income of $1000 per month with which they buy the composite good with a price of $1 and food with a price of $2/unit of food. Would the consumer prefer to get $100 in food stamps or $100 in cash? You need to justify your answer t..

User Account

All Pages