For example you can purchase10875 prepackaged dry hog feed you dont need t

For example you can purchase10875 prepackaged dry hog

This preview shows page 14 - 18 out of 21 pages.

Image of page 14
Microsoft Excel 16.0 Sensitivity Report Worksheet: [Excel-prob3.xlsx]Sheet3 (2) Report Created: 6/9/2018 9:47:24 AM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$2 Decisions Hogs Sold 100 0 450 1E+30 261.047619 $C$2 Decisions Corn Purchased 95.23809524 0 -19 1.916666667 1 $D$2 Decisions Food Scraped Purchased 742.8571429 0 -10 0.5 24.69369369 $E$2 Decisions Potatoes Purchased 600 0 -15 1E+30 1.095238095 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$6 Hogs supply limit LHS 100 261.047619 100 5.405405405 21.73913043 $F$7 Food scrapped supply limit LHS 742.8571429 0 800 1E+30 57.14285714 $F$8 Potatoes supply limit LHS 600 1.095238095 600 166.6666667 109.0909091 $F$9 Crude Protein Net Excess Nutrients LHS 1.81899E-12 -1.047619048 0 46800 1500 $F$10 Kilo-Calories Net Excess Nutrients LHS -1.45519E-11 -0.004761905 0 6000 78000 Microsoft Excel 16.0 Answer Report Worksheet: [Excel-prob3.xlsx]Sheet3 (2) Report Created: 6/9/2018 9:47:24 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.312 Seconds. Iterations: 5 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Solve Without Integer Constraints, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $F$2 Decisions Total 26761.90476 26761.90476 Variable Cells Cell Name Original Value Final Value Integer $B$2 Decisions Hogs Sold 100 100 Contin $C$2 Decisions Corn Purchased 95.23809524 95.23809524 Contin $D$2 Decisions Food Scraped Purchased 742.8571429 742.8571429 Contin $E$2 Decisions Potatoes Purchased 600 600 Contin Constraints Cell Name Cell Value Formula Status Slack $F$6 Hogs supply limit LHS 100 $F$6<=$H$6 Binding 0 $F$7 Food scrapped supply limit LHS 742.8571429 $F$7<=$H$7 Not Binding 57.14285714 $F$8 Potatoes supply limit LHS 600 $F$8<=$H$8 Binding 0 $F$9 Crude Protein Net Excess Nutrients LHS 1.81899E-12 $F$9>=$H$9 Binding 0 $F$10 Kilo-Calories Net Excess Nutrients LHS -1.45519E-11 $F$10>=$H$10 Binding 0
Image of page 15
Appendices: Appendix A: Microsoft Excel 16.0 Answer Report Worksheet: [Book1]Sheet1 Report Created: 03-06-2018 17:16:26 Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.031 Seconds. Iterations: 14 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell Name Original Value Final Value $N$4 Cost Total 0 6558000 Variable Cells Cell Name Original Value Final Value Integer
Image of page 16
$B$2 Solution x1 0 3000 Contin $C$2 Solution x2 0 2000 Contin $D$2 Solution x3 0 3000 Contin $E$2 Solution x4 0 3200 Contin $F$2 Solution y1 0 500 Contin $G$2 Solution y2 0 400 Contin $H$2 Solution y3 0 500 Contin $I$2
Image of page 17
Image of page 18

You've reached the end of your free preview.

Want to read all 21 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture