Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribedimage text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting And Analysis

Authors: Lawrence Revsine, Daniel Collins

5th Edition

0078110866, 978-0078110863

More Books

Students also viewed these Economics questions

Question

Behaviour: What am I doing?

Answered: 1 week ago