Ed owns a small business called Kingston Anchors, which produces four types of anchor for pleasure craft:

Danforth: a lightweight, temporary anchor;

Small Plow: an all purpose anchor for boats less than 24';

Large Plow: same thing for boats longer than 24';

Hereshoff: a fancy, show-off anchor for larger boats.

Each anchor requires metal to be cut, ground, tumbled and finally welded and assembled.Because of earlier foresight, Ed has stockpiled plenty of raw material in the form of steel bars, sheets, and tubes.The production data for each anchor of each type in the next cycle is as follows:

A B C D E F G H 1 Microsoft Excel 11.0 Sensitivity Report Worksheet: [Book2] Sheet1 3 Report Created: 9/29/2004 11:34:26 AM 4 5 6 Adjustable Cells 7 Final Reduced Objective Allowable Allowable 6 Cell Name Value Cost Coefficient Increase Decrease 9 $8$4 Decision D 570 0 50 6.666666667 6.666666666 10 $C$4 Decision SP 300 110 18+30 20 11 $D$4 Decision LP 90 0 130 20 8.571428572 12 $E$4 Decision H 0 -30 200 30 18+30 13 14 Constraints 15 Final Shadow Constraint Allowable Allowable 16 Cell Name Value Price R.H. Side Increase Decrease 17 SF$7 Cutting LHS 7200 6 7200 550 450 18 $F$8 Grinding LHS 12360 14400 18+30 2040 19 SF$9 Tumbling LHS 3315 0 6000 1E+30 2685 20 SF$10 Weld/Assy LHS 4800 5 4800 306.6666666 440 21 $F$11 Danforths LHS 570 O 800 1E+30 230 22 SF$12 Small Plows LHS 300 20 300 180 220 23 SF$13 Large Plows LHS 90 200 1E+30 110 OO 24 SF$14 Herreshofs LHS 100 18+30 100\f\f\f