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 1 Microsoft Excel 11.0 Answer Report 2 Worksheet: [Book2] Sheet1 3 Report Created: 9/29/2004 11:34:26 AM 4 5 6 Target Cell (Max) 7 Cell Name Original Value Final Value 8 SF$5 Profit 490 73200 9 10 11 Adjustable Cells 12 Cell Name Original Value Final Value 13 $B$4 Decision D 1 570 14 $C$4 Decision SP 300 15 SD$4 Decision LP 90 16 SE$4 Decision H 0 17 18 19 Constraints 20 Cell Name Cell Value Formula Status Slack 21 $F$7 Cutting LHS 7200 SF$7