Question

NARRBEGIN: SA_105_106
A company faces the following demands during the next 3 weeks: week 1, 20 units; week 2, 10 units; week 3, 15 units. The unit production cost during each week is as follows: week 1, $13; week 2, $14; week 3, $15. A holding cost of $2 per unit is assessed against each week's ending inventory. At the beginning of week 1, the company has 5 units on hand. Since not all goods produced during a month can be used to meet the current month's demand, assume that half of the goods produced during a week can be used to meet the current week's demands.
NARREND
(A) Determine how to minimize the cost of meeting the demand for the next three weeks.
(B) Revise the model in Question 106 so that the demands are of the form, where is the original demand in month t, k is a factor, and is an amount of change in month t. Formulate the model in such away that you can use the SolverTable add-in to analyze changes in the amounts produced and the total cost when k varies from 0 to 10 in 1-unit increments, for any fixed values of the 's. For example, try this when = 2, = 5, and = 3. Describe the behavior you observe in the table. Can you find any "reasonable" 's that induce positive production levels in week 3?

Answer

This answer is hidden. It contains 447 characters.