3-18 (Inventory management) NB Campers Inc. manufac- tures small camper trailers. John Dunphy, president of NB...

 

Transcribed Image Text:

3-18 (Inventory management) NB Campers Inc. manufac- tures small camper trailers. John Dunphy, president of NB Campers, has forecast demand for the four quarters of 2009 as follows: QUARTER 1234 DELLAND 35 50 75 30 Quarter 1= January, February, March; Quarter 2-April, May, June; and so on. At the beginning of the first quarter, NB Campers has an inventory of 10 campers. Dunphy has to decide how many campers to manufacture during each quarter, It costs $4500 to manufacture a camper, and NB Campers can produce a maximum of 60 campers per quarter. The company's production capabilities are such that any camper manufac- tured during a quarter can be used to meet demand for that quarter. Any campers manufactured but not sold during a quarter will incur a one time inventory cost of $200. Assume that the inventory holding cost for the 10 campers in inventory at the begining of the first quarter has already been accounted for in the previous year. NB Campers Inc. has to decide how many campers to produce during each quarter and how many to hold in inven- tory at the end of each quarter in order to minimize the com- bined annual cost of manufacturing and holding inventory. (a) Formulate the problem as a linear program (b) Solve using Excel 3-18 (Inventory management) NB Campers Inc. manufac- tures small camper trailers. John Dunphy, president of NB Campers, has forecast demand for the four quarters of 2009 as follows: QUARTER 1234 DELLAND 35 50 75 30 Quarter 1= January, February, March; Quarter 2-April, May, June; and so on. At the beginning of the first quarter, NB Campers has an inventory of 10 campers. Dunphy has to decide how many campers to manufacture during each quarter, It costs $4500 to manufacture a camper, and NB Campers can produce a maximum of 60 campers per quarter. The company's production capabilities are such that any camper manufac- tured during a quarter can be used to meet demand for that quarter. Any campers manufactured but not sold during a quarter will incur a one time inventory cost of $200. Assume that the inventory holding cost for the 10 campers in inventory at the begining of the first quarter has already been accounted for in the previous year. NB Campers Inc. has to decide how many campers to produce during each quarter and how many to hold in inven- tory at the end of each quarter in order to minimize the com- bined annual cost of manufacturing and holding inventory. (a) Formulate the problem as a linear program (b) Solve using Excel

Answer rating: 100% (QA)

Question Optimal Solution Production Quarter 1 30 Quarter 2 60 Quarter 3 60 Quarter 4 30 ... View the full answer