The manager of a LaMode company has developed a forecast shown in the table for boxes of cloth. The table also shows the production cost per box, the holding cost per box, the production capacity, the inventory capacity. The company now has 30 boxes of cloth as a beginning inventory of the first period. Formulate a linear programming model to minimize the cost. Calculate inventory cost based on amounts of inventory at the end of each period.
Expert Answer
Formulation in Excel
Don't use plagiarized sources. Get Your Custom Essay on
Solved: The manager of a LaMode company has developed a forecast shown in the table for boxes
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Final Result
Period | 1 | 2 | 3 | 4 | 5 | 6 |
Forecast | 250 | 300 | 230 | 300 | 280 | 290 |
Beginning Inv | 30 | 50 | 35 | 60 | 30 | 25 |
Production | 270 | 285 | 255 | 270 | 275 | 265 |
Ending Inv | 50 | 35 | 60 | 30 | 25 | 0 |
Total cost = 28,504.75