Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

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

Making Databases Work The Pragmatic Wisdom Of Michael Stonebraker

Authors: Michael L. Brodie

1st Edition

1947487167, 978-1947487161

More Books

Students also viewed these Databases questions

Question

Question How are IRAs treated for state tax law purposes?

Answered: 1 week ago