Table 3.4: I am Ulysses Uncle Ulysses operates a small business: he produces three types of houses ...

Table 3.4: I am Ulysses
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	$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

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.

The Answer Report:


The Sensitivity Report:



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

• Profits would increase by $15.

• Profits would decrease by $17.15.

• Profits would increase by $0.00.

• Profits would decrease by $1E + 30.