Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started