Answered step by step
Verified Expert Solution
Question
1 Approved Answer
right answers please Uncle Ulysses operates a small business: he produces three types of houses to sell to people wanting to get back to nature.
right answers please
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. 4 Item Profit/Unit Fabrication Assembly Painting Crating Birdhouse $15 1 2.5 1 0.25 Doghouse $35 1.25 1.5 0.5 0.5 Outhouse $58 1.75 2 0.75 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 Reduced Allowable Cell Name $C$4 Birdhouse $D$4 Doghouse $E$4 Outhouse Final Value 0.00 15.38 6.15 Cost -17.15 0.00 0.00 Objective Coefficient 15.00 35.00 58.00 Increase 17.15 6.43 82.00 Allowable Decrease 1E+30 20.50 9.00 Constraints Shadow Price Constraint R.H. Side 30 Allowable Increase 3.75 25.23 Cell Name $F$5 Fabricate $F$6 Assemble $F$7 Paint $F$8 Crate Final Value 30.00 47.69 20.00 12.31 Allowable Decrease 12.50 2.31 8.00 50 0.00 6.92 1E+30 1.58 20 0.00 20 1E+30 7.69 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? If we refer to the four constraints as "Fabricate", "Assemble", "Paint" and "Crate". Which constraints are NOT binding? 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 whyStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started