During the next four months, a customer requires, respectively, 500 (month 1), 6
ID: 409163 • Letter: D
Question
During the next four months, a customer requires, respectively, 500 (month 1), 650 (month 2), 1000 (month 3), and 700 (month4) units of a commodity, and no backlogging is allowed (that is, the customer's requirements must be met on time). Production costs are $50 (month 1), $80 (month 2), $40 (month 3), and $70 (month 4) per unit during these months. The storage cost from one month to the next is $20 per unit (assessed on ending inventory). It is estimated that each unit on hand at the end of month 4 can be sold for $60. Assume there is no beginning inventory.
1. Determine how to minimize the net cost incurred in meeting the demands for the next four months.
2. How do you calculate ending inventory for month 1, 2, 3, and 4? What is the equation to do so?
Explanation / Answer
Answer: To get the solver in function you need to link the ending inventory to the constraints by knowing the fact that ending inventory will always come after what is required by the customer at every period. So use the formula:
Demand-issue = ending inventory
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.