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.

Table below show the answer report and sensitivity report for the CompanyABC. Objective Cell (Max) Cell Name Original Value Final Value $G$9 Obj

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!