Homework Help is Here – Start Your Trial Now!
Business
Operations Management
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 DEMAND 1234 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 DEMAND 1234 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

Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.2SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...
See similar textbooks
icon
Related questions
Question

Don't use chat gpt 

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 DEMAND 1234 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
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 DEMAND 1234 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
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS