A) Formulate an ILP model to determine how many units of each product to produce on each machine in order to meet demand at a minimum cost.

B) What is the Optimal solution.

XI - Prb6_23_empty_Solver - Microsoft Excel File Home Insert Page Layout Formulas Data Review View LLLL Arial 10 A A Wrap Text General Normal Bad Good Neutral Calcu % Cut E Copy " Paste Format Painter Clipboard $ - % 4.0 .00 .00.0 Conditional Format Formatting as Table Check Cell Explanatory... Followed Hyp... Hyperlink a: Merge & Center & Alignment Input Number Styles R33 BIU. -A Font Xfx D E Manufacturing Plan A B F G H 1 J K L M N 0 Q R S T U V Units Run of Each Machine A B SECO OWN Unit Production Costs B $13 $9 $10 $11 $12 $8 Production Cost: Setup Cost: Total Cost: $0 $0 3 7 4 Setups on Each Machine A B A $55 $65 Setup Costs B $93 $60 $58 $ $75 Run Time per Unit A B C 0.4 1.1 0.5 1.2 1.3 0.9 Used Available 8 6 Linking Constraints A B 5 Machine 1 2 8 Produced Needed 10 11 12 Machine 13 1 44 14 2 15 16 17 Machine 18 1 19 2 20 21 22 Machine 22 23 1 24 2 2 25 26 27 28 29 30 31 32 23 33 34 35 36 37 38 39 40 40 41 42 43 44 45 AG O