Problem 6.19 There are three (3) total worksheets, two (2) for the individual objectives specified in parts (b) and (d) and a final "preemptive optimization" worksheet that uses scrap waste as a tie-breaking objective for the original objective of part (b) that seeks to use the fewest boards possible.

Problem 7.27 In part (c), maximize profit but under the restriction of providing full coverage to all of Ames. In the minimax problem of parts (d) and (e), use the full 25 sectors as the target coverage value and the profit of part (a) as the target profit level. (Careful: both of those targets are maximal targets not minimal targets as in the mining case.) Four worksheets for this problem, the last two being the minimax versions, both unweighted (or weights both the same) and weighted. Also, in part (b), interpret solution on the grid indicated in the attached spreadsheet shell, placing an "X" or a 1 in each cell tower location.

DataStock Length (ft)25Feasible cutting patternsLength (ft)Pattern7911Used (ft)Scrap (ft)Boards Cut130022103201412050116002Order Requirements50001200300Total BoardsTotal Scrap (ft)

Grid LocationIncidence MatrixRowCol12345678910111213141516171819202122232425Times CoveredCovered?Revenue ($1000s)1111100010000000000000000000$341221110001000000000000000000$431330111000100000000000000000$621440011100010000000000000000$421550001100001000000000000000$342161000011000100000000000000$642270100011100010000000000000$432380010001110001000000000000$712490001000111000100000000000$4825100000100011000010000000000$6531110000010000110001000000000$5732120000001000111000100000000$5733130000000100011100010000000$5134140000000010001110001000000$6135150000000001000110000100000$3041160000000000100001100010000$3242170000000000010001110001000$3843180000000000001000111000100$7044190000000000000100011100010$5645200000000000000010001100001$4051210000000000000001000011000$6852220000000000000000100011100$7353230000000000000000010001110$3054240000000000000000001000111$5655250000000000000000000100011$44Build?@$150thousand per tower1234512345

ACME Manufacturing Month 2 3 4 Minimum Beginning Inventory 120 110 50 140 Production 410 520 400 450 400 Production Capacity 500 520 450 550 Demand 420 580 310 540 Ending Inventory 110 50 140 50 50 Average Inventory 115 80 95 95 Costs Per Unit Production $49.00 $45.00 $46.00 $47.00 83040 Inventory $1.50 $1.50 $1.50 $1.50 577.5 83617.5A B C D E G H I J K L M N O P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH Al AJ AK AL KPS Communications Each row indicates the cells (columns) that, if a Grid Location Incidence Matrix tower is placed there, can cover the row's Times Revenue designated grid location Row Col 2 3 4 5 6 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Covered Covered? ($1000s) U U U U U A A A A AWW WW W N N N N N - - - - U A WN - UA WN -UA WN -UA W N -DAWN 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $34 0 0 11 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $43 For model (c), simply adjust model (a) for full coverage (of all 25 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 sites) rather than changing the objective. $62 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $42 For part (e), let coverage be twice as important as profit rather 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $34 than the vice versa. 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $64 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $43 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 $71 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 $48 0 0 0 1 1 0 0 0 $65 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $57 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $57 OOO 0 0 0 0 0 $51 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 $61 15 0 0 0 0 0 0 0 0 0 1 0 0 0 16 0 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0 0 0 0 $30 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 $32 17 0 0 0 0 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 $38 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 0 0 $70 19 0 0 0 0 0 0 0 $56 20 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 1 $40 21 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 $68 22 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $73 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $30 24 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 $56 25 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 1 $44 Build? @$150 thousand per tower 2 3 4 5 b: Indicate the locations of your cell towers by manually typing a "1" in those locations of this depiction of the geographic block. 1 A W N