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.

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
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
\$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

#### You've reached the end of your free preview.

Want to read all 21 pages?

• Fall '05
• EL