Question: Question 7 Excel Output 1 Micro soft Excel 14.0 An swer Report Worksheet: [Problem 2.23 xls Solution Report Created: 10/31/2014 1:57:14 PM Result: Solver found

 Question 7 Excel Output 1 Micro soft Excel 14.0 An swer

Question 7 Excel Output 1 Micro soft Excel 14.0 An swer Report Worksheet: [Problem 2.23 xls Solution Report Created: 10/31/2014 1:57:14 PM Result: Solver found a solution. All Con straints and optimality condition s are satisfied Solver Engine Engine Simplex LP Solution Time 0.010 Seconds Solver Options Mex Time 100 sec Iter ations 100, Precis ion 0.000001 Max Subproblems 5000. Max integer Sols 5000. Integer Tolerance 5%, Assume NonNegative Cell lame Value Final Value 100 SBS12 Objecthe Function X1 Variable Cells Cell SBs10 SCS10 Final Value 24.00000 8.00000 N ame Value 24.00000 8.00000 Integer X1 (Pumpkin Bars) X2(Carob Bar Constraints Cell Name Formu laS Cell Value 40 Status Slack 0 sestBc:SD$15 BS18-5D $18 Ses15 Binding SBS1 LHS Binding ?crosoft Excel 14.0 Sensitivity Report Worksheet: [Problem 2.23xlsx]Solution Report Created: 10 31/2014 1:57:14 PM Variable Cells Final Reduced Objetive Allowable Allowable Value Cost Coefficient Increase Decrease Cell SB$10 X1 (Pumpkin Bars) SCS10 X2 (Carob Bars) Name 1.25 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease Cell SB$15 Flour Name 40 40 10 60 16 Oatmeal 120 120 The binding constraints (2) is are 0 1 1 and 2 ? None of the above is correct

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 Databases Questions!