Question

NARRBEGIN: SA_103_104
A customer requires 50, 65, 100, and 70 units of a commodity during the next 4 months, respectively, and no backlogging is allowed; that is, the customer's requirements must be met on time. Production costs $5, $8, $4, and $7 per unit during these months. The storage cost from one month to the next is $2 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 could be sold for $6.
NARREND
(A) Determine how to minimize the net cost incurred in meeting the demands for the next four months.
(B) Starting with the optimal solution to (A), use SolverTable add-in to see what happens to the decision variables and the total cost when the initial inventory varies from 0 (the implied value in (A)) to 100 in 10-units increments. How much lower would the total cost be if the company started with 10 units in inventory, rather than none? Would the same cost decrease occur for every 10-init increase in initial inventory?

Answer

This answer is hidden. It contains 6 characters.