Answered step by step
Verified Expert Solution
Link Copied!

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 pleaseimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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 why

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

Financial Accounting For MBAs

Authors: Peter Easton, Robert Halsey, Mary Lea McAnally, John Wild

8th Edition

1618533584, 9781618533586

More Books

Students also viewed these Accounting questions

Question

Identify four ways in which labor standards are set.

Answered: 1 week ago

Question

Describe the problems in the administration of disciplinary action.

Answered: 1 week ago

Question

Explain discipline and disciplinary action.

Answered: 1 week ago