Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

If we refer to the four constraints as Fabricate, Assemble, Paint and Crate. Which constraints are NOT binding? Paragraph B I U Add a

image text in transcribedimage text in transcribed

If we refer to the four constraints as "Fabricate", "Assemble", "Paint" and "Crate". Which constraints are NOT binding? Paragraph B I U Add a File Record Audio + Question 16 (3 points) Listen After some market investigation, Uncle Ulysses decided to increase the price of Doghouse from $35 to $40. Will this change the current optimal production plan? Paragraph BI U A Add a File Record Audio Question 17 (3 points) Listen In a week, due to workers' vacation plan, Uncle Ulysses only has 15 painting hours. How would his profit of this week be affected and why? Paragraph B I U A 11. 11. Uncle Ulysses operates a small business: he produces three types of houses to sell to people wanting to get back to nature. Based on your discussion with your uncle you construct the following table based on your understanding of his weekly availability of labor. Item Profit/Unit Fabrication Assembly Painting Crating Birdhouse Doghouse $35 $15 1 2.5 1 0.25 1.25 1.5 0.5 0.5 $58 1.75 4 2 0.75 Outhouse Capacity 30 hours 50 hours 20 hours 20 hours Based on the information in the table, you formulate the problem as a linear program. The labor needed for fabrication, assembly, painting, and crating is all dedicated solely to each function, i.e., none of the workers have been cross-trained. You solved the problem using Excel and generated the following sensitivity report. Variable Cells Final Cell Name Value Reduced Cost Objective Coefficient $C$4 Birdhouse 0.00 -17.15 15.00 Allowable Allowable Increase Decrease 17.15 1E+30 $D$4 Doghouse 15.38 0.00 35.00 6.43 20.50 $E$4 Outhouse 6.15 0.00 58.00 82.00 9.00 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$5 Fabricate 30.00 25.23 30 3.75 12.50 $F$6 Assemble 47.69 0.00 50 1E+30 2.31 $F$7 Paint 20.00 6.92 20 1.58 8.00 $F$8 Crate 12.31 0.00 20 1E+30 7.69

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Microsoft Excel Data Analysis And Business Modeling

Authors: Wayne Winston

7th Edition

9780137613663

Students also viewed these Economics questions