Question: Table below show the answer report and sensitivity report for the Company ABC. Objective Cell (Max) Cell Name Original Value Final Value $G$9 Obj level
Table below show the answer report and sensitivity report for the Company ABC.


Objective Cell (Max) Cell Name Original Value Final Value $G$9 Obj level of activity 0 1381 Variable Cells Cell Name Original Value Final Value $D$4 Product A $F$4 Product C o o IN $E$4 Product B 3 13 Constraints Cell Name Cell Value Slack $G$5 Sugar level of activity 300 O $G$6 Salt level of activity 600 O $G$7 Eggs level of activity 921 79.2934783 $G$8 Flour level of activity 800 0 (b) (Continued) Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease SD$4 Product A 2.2011 O 100 108.6667 66.5714 SE$4 Product B 2.6630 O 85 225 32.6 $F$4 Product C 13.3478 0 70 97.0833 56.2500 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $G$5 Sugar level of activity 300 0.6332 300 2046.6667 231.4286 $G$6 Salt level of activity 600 0.3543 600 282.7519 245 $G$7 Eggs level of activity 920.707 0 1000 16+30 79.2935 $G$8 Flour level of activity 800 1.223 800 74.8205 614(i) State the maximum prot of Company ABC. (1 mark) (ii) Determiae the productions that maximized the prot of Company ABC. (3 marks) {3313 Comment on the status of all the constraints. (2 mantis) (iv) Would increase in the egg level of activity increase the prot of the company? Justify your answer. (3- marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
