Using regular time production-what is the optimal solution

Assignment Help Operation Management

Reference no: EM131282829

Northwest Pipe (NP) makes water pipe. NP is planning production for the next 7 months, March through September. The forecast demands (in thousands of feet) are, respectively, 40, 60, 70, 80, 90, 100, and 80. NP can make 75,000 feet of pipe per month using regular time production, at a cost of $1.25 per foot. It can make up to an additional 15,000 feet using overtime production at a cost of $1.50 per foot. Any pipe made in one month and sold in a later month incurs an inventory holding cost of $0.15 per foot, per month. NP expects to end February with 5000 feet of pipe, and would like to plan to end September with 10,000 feet in inventory. NP would like to plan their production schedule to minimize total cost during the next 7 months.

(a) Formulate an LP to minimize total costs.

(b) Set up and solve the problem on a spreadsheet.

Reference no: EM131282829

Questions Cloud

What is the process capability? index : Aspen Plastics produces plastic bottles to customer order. The quality inspector randomly selects four bottles from the bottle machine and measures the outside diameter of the bottle? neck, a critical quality dimension that determines whether the bot..

The measure of ones property depends upon : The consumer products industry is one with several large competitors, soaring raw materials prices, and strong demands from powerful retailers for lower prices. As a result, Colgate-Palmolive Co. and Unilever Group, the makers of products such as Col..

Understand the procurement management process : Why is it important for a project manager to understand the procurement management process? Describe a common project risk, and the methods that can be used to monitor and control it.

Affect global marketing initiatives : Analyze two issues or trends that you feel will affect global marketing initiatives in the next 10 years. What is the significance of each issue or trend discussed? How will organizational leaders need to prepare for these issues?

Using regular time production-what is the optimal solution : Northwest Pipe (NP) makes water pipe. NP is planning production for the next 7 months, March through September. The forecast demands (in thousands of feet) are, respectively, 40, 60, 70, 80, 90, 100, and 80. NP can make 75,000 feet of pipe per month ..

Which marketing strategy focuses on single market segment : Which marketing strategy focuses on a single market segment but adds additional product lines? full coverage market specialization product specialization selective specialization market-product concentration.

Identify major diversity issues in air force academy case : Identify the major diversity issues in the U.S. Air Force Academy case. Then evaluate the effectiveness of the changes that the Academy made in response to these issues.

Benefits of developing and writing effective business plan : Why do so many small businesses fail before they reach their tenth year? What are the benefits of developing and writing an effective business plan? Describe how local governments and business incubators help small firms get established and grow.

Difference in absolute advantage and comparative advantage : How does a business decide whether to trade with a foreign country? What are the key factors for participating in the information economy on a global basis? What is the difference between absolute advantage and com- parative advantage? Give an exampl..

User Account

All Pages