A manufacturer of three models of tote bag must determine the production plan for the next quarter. The specifics for each model are shown in
A manufacturer of three models of tote bag must determine the production plan for the next quarter. The specifics for each model are shown in the following table.
| Model | Revenue ($ per item) | Cutting (hours per item) | Sewing (hours per item) | Packing (hours per item) |
| A | $8.75 | .10 | .15 | .20 |
| B | $10.50 | .15 | .12 | .20 |
| C | $11.50 | .20 | .18 | .20 |
Time available in the three production departments are: Cutting 450 hours, Sewing 550 hours, Packing 450 hours.
Based on market research, the company wants to make at least 300 model A’s, at least 400 model B’s and at least 250 model C’s but no more than 1200 of any one model
Costs in each department are: Cutting $11.00 per hour, Sewing $12.50 per hour, Packing $9.25 per hour
Write the Linear Programming formulation for this problem to help determine the best production mix of the three models that will maximize profit.
For the Linear Programming problem: in addition to writing the formulation, set the problem up and Solve it using Excel Solver. Report your solution and the objective result.
Step by Step Solution
There are 3 Steps involved in it
LP model Let A B C indicate quantity of each the three products o... View full answer
Get step-by-step solutions from verified subject matter experts
100% Satisfaction Guaranteed-or Get a Refund!
Document Format (2 attachments)
608ec0e597b16_20592.pdf
180 KBs PDF File
608ec0e597b16_20592.docx
120 KBs Word File
See step-by-step solutions with expert insights and AI powered tools for academic success
-
Access 30 Million+ textbook solutions.
-
Ask unlimited questions from AI Tutors.
-
Order free textbooks.
-
100% Satisfaction Guaranteed-or Get a Refund!
Claim Your Hoodie Now!
Managerial Decision Modeling With Spreadsheets
Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair
3rd Edition
136115837, 978-0136115830
Study Smart with AI Flashcards
Access a vast library of flashcards, create your own, and experience a game-changing transformation in how you learn and retain knowledge
Explore Flashcards
Study Help
