Objective Cell $($Max$)$ Cell Name Original Value Final Value $C$$22$ Profit T$1057600$ Variable Cells Cell Name Original Value Final Value Integer $C$$16$ T$1022$ Contin $D$$16$ T$2024$ Contin $E$$16$ R $016$ Contin Constraints Cell Name Cell Value Formula Status Slack $C$$20$ Demand T$122$ $C$$20>=$$C$$9$ Not Binding $2$ $D$$20$ Demand T$224$ $D$$20>=$$D$$9$ Binding $0$ $F$$17$ Rubies Utilisation $100$ $F$$17<=$$F$$6$ Binding $0$ $F$$18$ Sapphires Utilisation $114$ $F$$18<=$$F$$7$ Not Binding $6$ $F$$19$ Labour Utilisation $70$ $F$$19<=$$F$$8$ Binding $0$ Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$$16$ T$122012001$E$+30300$ $D$$16$ T$224015006001$E$+30$ $E$$16$ R $160-300300300$ Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R$.$H$.$ Side Increase Decrease $C$$20$ Demand T$12202021$E$+30$ $D$$20$ Demand T$224-6002411,5$ $F$$17$ Rubies Utilisation $100300100161$E$+30$ $F$$18$ Sapphires Utilisation $11401201$E$+306$ $F$$19$ Labour Utilisation $706007022$ PBA$4804$ MAYJUNE $2024$ EXAMINATION $6$ Answer the following questions by using only the printout obtained in $($a$).($This means that you may not change the values of the relevant parameters in the model and do reruns with SOLVER.$)$ Explain how you arrive at your answers. $($b$)$ Suppose that instead of R$300,$ each ruby costs R$750.$ Will Zales still buy extra rubies? If so$,$ will the production plan and profit change? $(5)($c$)$ Suppose that Zales was required to produce at least $23$ type $2$ rings. What would Zales$$ profit now be$?(7)($d$)$ What is the most that Zales will be willing to pay for another hour of jeweller$$s labour time? How many hours may be obtained at this price? $(4)($e$)$ What is the most Zales will be willing to pay for another sapphire? $(3)($f$)$ Zales discovers another $20$ rubies in his safe. How will the availability of these extra rubies change his production plan and profit? $(3)($g$)$ The market demand changes and Zales must now produce at least $22$ type $1$ rings and at least $23$ type $2$ rings. How will this change his production plan and profit? $(3)$