1 23 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 A B C D $1,000 $950 $875 $850 $800 $700 E $21 $23 $25 $24 $20 $26 Radford Castings Variable Binary Linking Machine Fixed Cost Cost Capacity Quantity Variable Constraint 1 2 3 4 5 6 500 600 750 400 600 800 F Available Required Total Variable Cost Total Fixed Cost Total Cost 1800 G $0 $0 H I Radford Castings can produce brake shoes on six different machines. The following table summarizes the manufacturing costs associated with producing the brake shoes on each machine along with the available capacity on each machine. If the company has received an order for 1,800 brake shoes, how should it schedule these machines? Machine 123456 1 2 3 4 5 6 Fixed Cost $1000 Homework 7 $950 $875 $850 $800 $700 Variable Cost $21 $23 $25 $24 $20 $26 Formulate an ILP model for this problem. (30 points) b. Implement your model in Excel and solve it. (50 points) c. What is the optimal solution? (20 points) Capacity 500 750 600 400 600 800