23 and requires 00007 hours of shelling machine time and 0002 hours of freezing

# 23 and requires 00007 hours of shelling machine time

This preview shows page 7 - 8 out of 8 pages.

\$0.23 and requires 0.0007 hours of shelling machine time and 0.002 hours of freezing line capacity. Each pound of canned regular peas ( Canned P2 ) has a return over variable cost of \$0.15 and requires 0.00065 hours of shelling machine time and 0.001 hours of canning line capacity. Each pound of frozen regular peas ( Frozen P2 ) has a return over variable cost of \$0.20 and requires 0.00065 hours of shelling machine time and 0.002 hours of freezing line capacity. In addition to transfer rows for small and regular peas ( Small Peas and Regular Peas ), the model has physical resource constraints on Shelling machine time (700 hours), Canning line capacity (940 hours), and Freezing line capacity (640 hours). A tableau representation of the model is given below. P1 Acres P2 Acres Canned P1 Frozen P1 Canned P2 Frozen P2 max 150 150 0.16 0.23 0.15 0.20 s.t 1200 0 1 1 0 0 <= 0 Small Peas 0 1350 0 0 1 1 <= 0 Regular Peas 0 0 0.0007 0.0007 0.00065 0.00065 <= 700 Shelling 0 0 0.001 0 0.001 0 <= 940 Canning 0 0 0 0.002 0 0.002 <= 640 Freezing All Activity Levels >= 0
Microsoft Excel 15.0 Answer Report Objective Cell (Max) Cell Name Original Value Final Value \$K\$2 max 0 62078.63248 Variable Cells Cell Name Original Value Final Value Integer \$B\$10 P1 Acres 0 266.6666667 Contin \$C\$10 P2 Acres 0 542.4501425 Contin \$D\$10 Canned P1 0 0 Contin \$E\$10 Frozen P1 0 320000 Contin \$F\$10 Canned P2 0 732307.6923 Contin \$G\$10 Frozen P2 0 0 Contin Constraints Cell Name Cell Value Formula Status Slack \$K\$4 Small Peas 0 \$K\$4<=\$I\$4 Binding 0 \$K\$5 Regular Peas 0 \$K\$5<=\$I\$5 Binding 0 \$K\$6 Shelling 700 \$K\$6<=\$I\$6 Binding 0 \$K\$7 Canning 732.3076923 \$K\$7<=\$I\$7 Not Binding 207.6923077 \$K\$8 Freezing 640 \$K\$8<=\$I\$8 Binding 0 Microsoft Excel 15.0 Sensitivity Report Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease \$B\$10 P1 Acres 266.6666667 0 150 8.256410256 15.74358974 \$C\$10 P2 Acres 542.4501425 0 150 16.44642857 8.625 \$D\$10 Canned P1 0 0.00688034 0.16 0.006880342 1E+30 \$E\$10 Frozen P1 320000 0 0.23 1E+30 0.013119658 \$F\$10 Canned P2 732307.6923 0 0.15 0.058611111 0.006388889 \$G\$10 Frozen P2 0 0.01311966 0.2 0.013119658 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease \$K\$4 Small Peas 0 0.125 0 320000 1E+30 \$K\$5 Regular Peas 0 0.111111111 0 732307.6923 9.57812E+20 \$K\$6 Shelling 700 59.82905983 700 135 476 \$K\$7 Canning 732.3076923 0 940 1E+30 207.6923077 \$K\$8 Freezing 640 31.55982906 640 1360 385.7142857

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

Want to read all 8 pages?

• Spring '18
• tc, linear programming model, small peas, regular peas