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
Image of page 7
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
Image of page 8

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture