Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Answer Report: Objective Cell (MIn) Name Original Value Final Value $C$12 Min Total Cost Standard 50.00 $5.97 Variable Cells Name Original Value Final Value

image text in transcribed
Excel Answer Report: Objective Cell (MIn) Name Original Value Final Value $C$12 Min Total Cost Standard 50.00 $5.97 Variable Cells Name Original Value Final Value Integer SC59 Pounds Standard 0 3.513513514 Contin $ D59 Pounds Enriched Oat 0 0.945945946 Contin SE59 Pounds Additive 0 1.540540541 Contin Constraints Name Cell Value Formula status Slack $C$ 16 Ingredient A LHS 3 5C$ 16=-58516 Binding 0 $C$ 17 Ingredient B LHS 9.554054054 5C$17=-5ES17 Not Binding 3.554054054 5C$ 18 Ingredient CLHS 4 5C$ 18-58518 Binding 0 $C$ 19 Weight LHS 6 5C$19-5ES19 Binding 0 Excel Sensitivity Report: Variable Cells Final Reduce d Objective Allow able Allow a ble Cell Name Value Cost Coe friclent Increase Decrease SC$9 Pounds Standard 3.513513514 0 0.25 18+30 0.642857143 5059 Pounds Enriched Oat 0.945945946 O 0.5 0.425 18+30 SE$9 Pounds Additive 1.540540541 0 3 18+30 1.47826087 Constraints Final $ ha dow Constraint Allowable Allow able Cell Name Value Price RH. Side Increase Decrease SC$16 Ingredient A LHS 3 1.2162 162 16 3 0.36842 1053 1.8571 42857 SC$ 17 Ingredient B LHS 9.554054054 0 6 3.55405 4054 18+30 SC$18 Ingredient CLHS 4 1.959459459 4 0.875 19 SC$19 Weight LHS 6 -0.9189 18919 6 2.47 826087 0.4375

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

Economics of Money, Banking and Financial Markets

Authors: Frederic S. Mishkin

9th Edition

978-0321607751, 9780321599797, 321607759, 0321599799, 978-0321598905

More Books

Students also viewed these Economics questions