Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help with the 3 following questions please: Questions Search Insert Draw Design Layout References Mailings Review View Help 1) A company can decide how many

help with the 3 following questions please:

image text in transcribed
Questions Search Insert Draw Design Layout References Mailings Review View Help 1) A company can decide how many additional labor hours to acquire for a given week. Subcontractor workers will only work a maximum of 20 hours a week. The company must produce at least 200 units of product A, 300 units of product B, and 400 units of product C. In 1 hour of work, worker 1 can produce 15 units of product A, 10 units of product B, and 30 units of product C. Worker 2 can produce 5 units of product A, 20 units of product B, and 35 units of product C. Worker 3 can produce 20 units of product A, 15 units of product B, and 25 units of product C. Worker 1 demands a salary of $50/hr, worker 2 demands a salary of $40/hr, and worker 3 demands a salary of $45/hr. The company must choose how many hours they should contract with each worker to meet their production requirements and minimize labor cost. (a) Formulate this as a linear programming problem. (b) Find the optimal solution. 2) Consider the sensitivity report below: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 R 15 8 10 $D$4 W 12.5 0 12 4 6.667 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease SE$6 Corn 40 40 3.6 16.667 SE$7 Sugar 70 70 18 30 SE$8 Jugs 27.5 0 50 1E+30 22.5 $E$9 Hours 67.5 72 1E+30 4.5 (a) Which constraints are binding? (b) Which constraints are non-binding? (c) What is the increase in the objective value if 3 Com are added? 3) Consider the sensitivity report below: Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$4 Cabinet X 8 0 1 $D$4 Cabinet Y 3 0 12 4 1.333333333 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$6 Floor 72 72 9.333333333 16 SE$7 Budget 140 0.2 140 40 20 SE$8 Coffee 3 40 1E+30 (a) Which constraints are binding? (b) Which constraints are non-binding? c) What is the increase in the objective value if 3 Coffee are added

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Early Transcendentals

Authors: James Stewart

7th edition

538497904, 978-0538497909

More Books

Students also viewed these Mathematics questions