Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last 12 months were as follows: This exercise contains only parts a, b, and c. Month January Price Per Chip $1.85 Month July Price Per Chip $1.80 February $1.61 August $1.85 March $1.60 September $1.70 April $1.85 October $1.50 May $1.91 November $1.60 June $1.95 December $1.75 a) Using a 2-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places): Month Mar Apr Forecast $1.73 1.61 May Jun Jul 1.73 1.88 1.93 Aug Sep 1.88 Oct Nov Dec 1.83 1.78 1.60 1.55 b) Using a 3-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places): Month Apr May Jun Forecast $1.69 1.69 1.79 Jul Aug 1.90 1.89 Sep Oct Nov Dec 1.87 1.78 1.68 1.60 c) The mean absolute deviation based on a 2-month moving average of March through December is $ (round your response to three decimal places).

Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.1SA
icon
Related questions
Question

I need the answer to requirement C.

Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last 12 months were as follows:
This exercise contains only parts a, b, and c.
Month
January
Price Per Chip
$1.85
Month
July
Price Per Chip
$1.80
February
$1.61
August
$1.85
March
$1.60
September
$1.70
April
$1.85
October
$1.50
May
$1.91
November
$1.60
June
$1.95
December
$1.75
a) Using a 2-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places):
Month
Mar Apr
Forecast $1.73 1.61
May Jun Jul
1.73 1.88 1.93
Aug Sep
1.88
Oct Nov Dec
1.83 1.78 1.60 1.55
b) Using a 3-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places):
Month
Apr May Jun
Forecast $1.69 1.69 1.79
Jul Aug
1.90 1.89
Sep Oct Nov Dec
1.87 1.78 1.68 1.60
c) The mean absolute deviation based on a 2-month moving average of March through December is $
(round your response to three decimal places).
Transcribed Image Text:Lenovo uses the ZX-81 chip in some of its laptop computers. The prices for the chip during the last 12 months were as follows: This exercise contains only parts a, b, and c. Month January Price Per Chip $1.85 Month July Price Per Chip $1.80 February $1.61 August $1.85 March $1.60 September $1.70 April $1.85 October $1.50 May $1.91 November $1.60 June $1.95 December $1.75 a) Using a 2-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places): Month Mar Apr Forecast $1.73 1.61 May Jun Jul 1.73 1.88 1.93 Aug Sep 1.88 Oct Nov Dec 1.83 1.78 1.60 1.55 b) Using a 3-month moving average, the forecast for periods 11 and 12 is (round your responses to two decimal places): Month Apr May Jun Forecast $1.69 1.69 1.79 Jul Aug 1.90 1.89 Sep Oct Nov Dec 1.87 1.78 1.68 1.60 c) The mean absolute deviation based on a 2-month moving average of March through December is $ (round your response to three decimal places).
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
Recommended textbooks for you
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning