Based on the Excel output below, what happens when the profit contribution for both products $x$ and $Y$ are changed to $$4\mathrm{.}75$ each.

Time left $2$:$10$:$04$

This question is independent of the previous question so the assumption is that you've 'reset' the problem to its original output values shown and are now applying the change indicated in this current question only.

Max$4x+5Y$

Solution

$\backslash$table$[[$Decision Variables$],[,x,Y,],[$items Produced,$2,4,],[$Maximize Total Profit,$28,,],[$Constraints$,$Am$,,\backslash$table$[[$Amount Available$],[($RHS$)]]],[$labour in hours,$10,,10],[$material avail in $kg,36,,36],[$storage avail in sq $m,32,5=,40]]$

Sensitivity report

$\backslash$table$[[$Variable Cells$],[$Cell Name,Value Cost,,entl,,ease$],[$$B$$18$items Produced X$,2,0,4,1,1\mathrm{.}5],[$$C$$18$items Produced Y$,4,0,5,3,1]]$

Constraints

$\backslash$table$[[,$Final Shad,$w,$aint,Illowablet,Allowabl$],[$Cell Name,Value Price,,,ncrease $1,$Decrease$],[$$B$$23$labour in hours Amount Used $($LHS$),10,1,10,2,1],[\{$f$48$a$9$bccf$-7$b$8$f$-4$cb$7-$a$505-$a$5$fca$056$da$7$e$\}$

$\backslash$table$[[$material avail in $kg$ Amount Used$],[($LHS$)]],36,0\mathrm{.}5,36,4,],[\backslash$table$[[$$$B$$$25$