Aggregate demand for a product family is given in the table below for the four q
ID: 402818 • Letter: A
Question
Aggregate demand for a product family is given in the table below for the four quarters of 2008. The inventory cost is $2 per unit per quarter. Demand that cannot be met is a lost sale. The cost of a lost sale is $40 per unit.
Quarter
Demand
Production
Inventory
Lost Sale
1,000
Q1 08
5,000
9,000
?
?
Q2 08
8,000
9,000
?
?
Q3 08
7,000
9,000
?
?
Q4 08
8,000
7,000
?
?
Taking production and initial inventory into account, determine the ending inventory and lost sales for each of the four quarters and then compute thetotal cost of carrying inventory and lost sales for 2008 (i.e. do not include the cost of carrying the initial inventory).
Quarter
Demand
Production
Inventory
Lost Sale
1,000
Q1 08
5,000
9,000
?
?
Q2 08
8,000
9,000
?
?
Q3 08
7,000
9,000
?
?
Q4 08
8,000
7,000
?
?
Explanation / Answer
DEMAND PRODUCTION INVENTORY LOST SALE 1000 5000 9000 8000 0 8000 9000 2000 0 7000 9000 4000 0 8000 7000 0 -40000