Question: please just post an excel shhet PROBLEM 3. (10 POINTS) Uncle Ulysses operates a small business: he produces three types of houses to sell to

please just post an excel shhet
please just post an excel shhet PROBLEM 3. (10
PROBLEM 3. (10 POINTS) 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 his weekly availability of labor. Item Profit/Unit Fabrication Crating Painting Assembly 2.5 1 1 Birdhouse 0.25 $19 $39 1.25 1.5 0.5 0.5 $51 Doghouse Outhouse Capacity 1.75 4 2 0.75 20 hours 30 hours 50 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. Solve using the simplex algorithm

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!