Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE ANSWER Please give a brief analysis of this sensitivity report in the form of a paragraph. Thank you. Variable Cells Final Value Reduced Cost

PLEASE ANSWER

image text in transcribedimage text in transcribedPlease give a brief analysis of this sensitivity report in the form of a paragraph. Thank you.

Variable Cells Final Value Reduced Cost Cell Name 0 $B$21 Regular 0 $C$21 Deluxe 30000 $D$21 Holiday 0 Objective Coefficient 0,609 0,922 1,143 Allowable Allowable Increase Decrease 0,0825 0,148 0,296 0,0076 0,0095 1,0E+30 0 -0,0095 Constraints Final Value Shadow Price Cell Name 2,96 0 $E$23 Almond $E$24 Brazil $E$25 Filbert $E$26 Pecan $E$27 Walnut 6000 6000 6000 6000 6000 Constraint Allowable Allowable R.H. Side Increase Decrease 6000 500 7500 1,0E+30 1500 7500 1,0E+30 1500 6000 0 750 7500 1,0E+30 1500 0 1,65 0 Objective Cell (Max) Cell Name Final Value Original Value 26807 $E$22 Obj. 27660 Variable Cells Cell Name Original Value 10.000 $B$21 Regular $C$21 Deluxe $D$21 Holiday Final Value Integer O Contin 30000 Contin O Contin 18750 3000 Constraints Cell Name Status Slack 0 1500 $E$23 Almond $E$24 Brazil $E$25 Filbert $E$26 Pecan $E$27 Walnut Cell Value Formula 6000 $E$23

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

Step: 3

blur-text-image

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 Planning & Analysis And Performance Management

Authors: Jack Alexander

1st Edition

1119491487, 9781119491484

More Books

Students also viewed these Finance questions

Question

Kilometre run and effective kilometre are the same.

Answered: 1 week ago