Purchase Solution

Linear Progamming / Production Schedule

Not what you're looking for?

Ask Custom Question

I'm having a hard time setting up an Excel solver model for the problem below:
Owens-Wheat uses two production lines to produce three types of fiberglass mats. The demand requirements for each type of mat (in tons) for the next four months are as follows:

Month Mat Type
1 2 3
1 200 300 400
2 300 100 300
3 200 400 200
4 300 200 100

If it were dedicated to simply producing a mat of a single type, a single line 1 machine could produce either 20 tons of a type 1 mat or 30 tons of a type 2 mat. Similarly, a single line 2 machine could produce either 25 tons of type 2 mat or 28 tons of type 3 mat. Note that mat type 1 cannot be produced on line2, while mat type 3 cannot be produced on line 1. If costs $ 5,000 per month to operate a single machine on line 1, and $ 5,500 to operate a single machine on line 2. A cost of $ 2,000 is incurred each time a new machine is purchased for either line, while a cost of $ 1,000 is incurred when a machine is retired from service. At the end of each month, Owens would like a minimum inventory of 50 tons of each mat type and the cost of holding one ton on inventory for a month of any mat type is $ 5. At the beginning of month 1, the company has 5 line 1 machines, and 8 line 2 machines. Determine a minimum cost production schedule for each mat type of each production line.

Purchase this Solution

Solution Summary

Linear programming and production schedules are analyzed. Three types of fiberglass mats are given for the demand requirements.

Purchase this Solution

Free BrainMass Quizzes
Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.