Question

NARRBEGIN: SA_107_108
A company must meet (on time) the following demands: quarter 1, 3000 units; quarter 2, 2000 units; quarter 3, 4000 units. Each quarter, up to 2700 units can be produced with regular-time labor, at a cost of $40 per unit. During each quarter, an unlimited number of units can be produced with overtime labor, at a cost of $60 per unit. Of all units produced, 20% are unsuitable and cannot be used to meet demand. Also, at the end of each quarter, 10% of all units on hand spoil and cannot be use used to meet any future demands. After each quarter's demand is satisfied and spoilage is accounted for, a cost of $15 per unit is assessed against the quarter's ending inventory.
NARREND
(A) Determine how to minimize the total cost of meeting the next 3 quarters' demand. Assume that 1000 usable units are available at the beginning of quarter 1.
(B) Referring to (A), the company wants to know how much money it would be worth to decrease the percentage of unsuitable items and/or the percentage of items that spoil. Write a short report that provides relevant information. Base your report on two uses of the SolverTable add-in: one where the percentage of unsuitable items decreases and the percentage of items that spoil stays at 10%; and one where the percentage of unsuitable items stays at 20% and the percentage of items that spoil decreases.

Answer

This answer is hidden. It contains 6 characters.