Question: Layout is literally this This needs to be done on excel, will upvote! Min 5x + 4y s.t. 18x+10y 2 90 12x + 16y 296

Layout is literally this

This needs to be done on excel, will upvote!
Min 5x + 4y s.t. 18x+10y 2 90 12x + 16y 296 -4x+10y s 40 16x s 96 8x + 8y 2 24 2 12 (3) (4) (5) (6) XX20 In completing your assignment, do not only include your model's solution but also include a 'cleaned up' sensitive report on the same worksheet. All calculated values should be formatted to 2 decimal places, and the layout of your worksheet should be a logical layout (i.e., somewhat similar to the layouts that I have been showing you). When you have completed the model and sensitivity report, highlight the cells using the asked for shades: a) The values of the decision variables cells in yellow b) The value of the objective function cell in green c) The values of the LHS's cells in blue d) The shadow price of constraint (1) cell in orange e) The allowable increase in the RHS of constraint (31's cell in purple f) The allowable decrease in the variable x's objective coefficient's cell in greyStep 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
