Lineare Programming:
Not what you're looking for?
This is an MBA level problem. Please use Excel to solve (do not use Lindo). Please explain each step in the problem.
Problem:
Greenville Cabinets received a contract to produce speaker cabinets for a major speaker manufacturer. The contract calls for the production of 3300 bookshelf speakers and 4100 floor speakers over the next two months, with the following delivery schedule.
Model Month1 Month2
Bookshelf 2100 1200
Floor 1500 2600
Greenville estimates that the production time for each bookshelf model is 0.7 hour and the production time for each floor model is 1 hour. The raw material costs are $10 for each bookshelf model and $12 for each floor model. Labor costs are $22 per hour using regular production time and $33 using overtime. Greenville has up to 2400 hours of regular production time available each month and up to 1000 additional hours of overtime available each month. If production for either cabinet exceeds demand in month 1, the cabinets can be stored at a cost of $5 per cabinet.
For each product, determine the number of units that should be manufactured each month on regular time and on overtime to minimize total production and storage costs.
Purchase this Solution
Solution Summary
Word file contains formulation with detailed explanations
Excel file contains formulation and solution. You may like to see solver toll dialogs box also.
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
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.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.