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.

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 $4$X $+5$Y

s$.$t$.1$ X $+2$ Y $<=10$ labour in hours

$6$ X $+6$ Y $<=36$ material available in kg

$8$ X $+4$ Y $<=40$ storage available in sq m

Solution

Decision Variables

X Y

items Produced $24$

Maximize Total Profit $28$

Constraints Amount Used $($LHS$)$ Amount Available $($RHS$)$

labour in hours $10<=10$

material avail in kg $36<=36$

storage avail in sq m $32<=40$

Sensitivity report

Variable Cells

Final Reduced Objective Allowable Allowable

Cell Name Value Cost Coefficient Increase Decrease

$B$$18$ items Produced X $20411\mathrm{.}5$

$C$$18$ items Produced Y $40531$

Constraints

Final Shadow Constraint Allowable Allowable

Cell Name Value Price R$.$H$.$ Side Increase Decrease

$B$$23$ labour in hours Amount Used $($LHS$)1011022$

$B$$24$ material avail in kg Amount Used $($LHS$)360\mathrm{.}53646$

$B$$25$ storage avail in sq m Amount Used $($LHS$)320401$E$+308$

Question $10$Select one:

a$.$

Can not be determined

b$.$

$100\%$ rule satisfied, profits increase by $$0\mathrm{.}50$

c$.$

$100\%$ rule not satisfied, need to resolve problem

d$.$

$100\%$ rule satisfied, profits decrease by $$0\mathrm{.}25$

e$.$

$100\%$ rule satisfied, profits increase by $$0\mathrm{.}25$

f$.$

$100\%$ rule satisfied, profits decrease by $$0\mathrm{.}50$