A) Formulate an ILP Model

B) What is the Optimal solution?

XI - Prb6_14_empty - Microsoft Excel File Home Insert Page Layout Formulas Data Review View * Cut E Copy - Arial 10 - A A AA Wrap Text General Normal Bad Good Neutral Calculation Paste BIU T => A Merge & Center - $ % 4.0 .00 .00.0 Conditional Format Formatting as Table Check Cell Explanatory... Input Linked Cell Note Format Painter Clipboard Font Alignment Number Styles F20 A B C D E F F G H 1 J K 1 M N 0 P Q R S T U V Radford Castings Variable Binary Linking Machine Fixed Cost Cost Capacity Quantity Variable Constraint 1 $1,000 $21 500 2 $950 $23 $ 600 3 $875 $25 $ 750 4 4 $850 $24 5 $800 $20 600 6 $700 $26 800 Available Required 1800 400 Total Variable Cost Total Fixed Cost Total Cost $0 $0 O 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45