1. Which additional resources would you recommend that Uncle Ulysses try to obtain?

Fabrication, Assembly, Paint, Crate.

Choose one and Explain

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

3. 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?

4. Uncle Ulysses' available hours for crating have fallen from 20 hours to 15 hours because of a new "one-hour nap time" rule for this five-year-old worker. How will this affect his profits? Explain.

5. Uncle Ulysses can obtain an additional 1 hour and 15 minutes of painting capacity free of charge by asking you and your cousins to paint when they visit. If he did this, how would his profits be affected?

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. Table 3. Uncle Ulysses small business information Item Profit/Unit Fabrication Assembly Painting Crating Birdhouse $15 1 2.5 1 0.25 Doghouse $35 0.5 Outhouse $58 1.75 4 2 0.75 Capacity 30 hours 50 hours 20 hours 20 hours 1.25 1.5 0.5 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 solution and the answer and sensitivity report are shown below. Answer Report: Objective Cell (Max) Cell Name Original Value Final Value $F$2 $895.38 $895.38 Variable Cells Cell Name Original Value Final Value $C$4 Birdhouse 0.00 0.00 $D$4 Doghouse 15.38 15.38 $E$4 Outhouse 6.15 6.15 Integer Contin Contin Contin Constraints Cell Name $F$5 Fabricate $F$6 Assemble $F$7 Paint $F$8 Crate Cell Value 30.00 47.69 20.00 12.31 Formula Status $F$5