Question: Please answer the problem analytically and in excel. Thank you! PROBLEM 3. (10 POINTS) Uncle Ulysses operates a small business: he produces three types of

Please answer the problem analytically and in excel. Thank you!
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 of his weekly availability of labor. n $19 Fabricatio Item Profit/Unit Assembly Painting Crating Birdhouse 1 2.5 0.25 Doghouse $39 1.25 1.5 0.51 0.5 Outhouse $S1 1.75 4 0.75 Capacity 30hours 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. Solve using the simplex algorithmStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
