THIS IS ONE QUESTION in different parts

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.

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. The Excel sensitivity report is shown below.

The optimal production quantities for each product are (round to two decimals):

Birdhouses:

Doghouses:

Outhouses:

The maximum weekly profit that Uncle Ulysses can make is $

Which additional resources would you recommend that Uncle Ulysses try to obtain? (Mark all that correspond)

a.fabrication

b.crate

c.assembly

d.paint

Suppose Uncle Ulysses is required by contract with the American Birding Association to make one birdhouse each week. How would this affect his profits?

a.Profits would decrease by $17.15.

b.Profits would increase by $0.00.

c.Profits would increase by $15.

d.Profits would decrease by $1E + 30.

Uncle Ulysses feels that his prices are too low, particularly for his birdhouses. How much would he have to charge for his birdhouses before it is profitable for him to make and sell them?

a.$17.15

b.$32.15

c.$47.15

d.$15.00

Some kiddos in the neighborhood have started to make and sell their own doghouses. To stay competitive Uncle Ulysses is considering lowering the price of his doghouse, which would reduce the profit per doghouse from $35 to $25. If he does, what would be the effect on this bottom line (total profit)?

a.His total profit will decrease by $153.80.

b.It is not possible to say with the information provided.

c.His total profit will stay the same.

d.His total profit will decrease by $10.

Item Profit 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 4 2 0.75 Capacity 30 hours 50 hours 20 hours 20 hours Variable Cells Final Value Reduced Cost 0.00 Allowable Decrease 1E+30 -17.15 Objective Coefficient 15.00 35.00 58.00 Cell Name $C$4 Birdhouse $D$4 Doghouse $E$4 Outhouse Allowable Increase 17.15 6.43 82.00 0.00 15.38 6.15 20.50 9.00 0.00 Constraints Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease 30.00 25.23 30 3.75 Cell Name $F$5 Fabricate $F$6 Assemble $F$7 Paint $F$8 Crate 47.69 50 1E+30 0.00 6.92 12.50 2.31 8.00 20.00 20 1.58 12.31 0.00 20 1E+30 7.69 Item Profit 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 4 2 0.75 Capacity 30 hours 50 hours 20 hours 20 hours Variable Cells Final Value Reduced Cost 0.00 Allowable Decrease 1E+30 -17.15 Objective Coefficient 15.00 35.00 58.00 Cell Name $C$4 Birdhouse $D$4 Doghouse $E$4 Outhouse Allowable Increase 17.15 6.43 82.00 0.00 15.38 6.15 20.50 9.00 0.00 Constraints Final Value Shadow Price Constraint R.H. Side Allowable Increase Allowable Decrease 30.00 25.23 30 3.75 Cell Name $F$5 Fabricate $F$6 Assemble $F$7 Paint $F$8 Crate 47.69 50 1E+30 0.00 6.92 12.50 2.31 8.00 20.00 20 1.58 12.31 0.00 20 1E+30 7.69