14. Radford Castings can produce brake shoes on six different machines. The follow- ing 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 Fixed Cost Variable Cost Capacity 1 $1000 $21 500 2 $ 950 $23 600 3 $ 875 $25 750 4 $ 850 $24 400 5 $ 800 $20 600 6 $ 700 $26 800 a. Formulate an ILP model for this problem. b. Create a spreadsheet model for this problem and solve it. c. What is the optimal solution? 14. Radford Castings can produce brake shoes on six different machines. The follow- ing 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 Fixed Cost Variable Cost Capacity 1 $1000 $21 500 2 $ 950 $23 600 3 $ 875 $25 750 4 $ 850 $24 400 5 $ 800 $20 600 6 $ 700 $26 800 a. Formulate an ILP model for this problem. b. Create a spreadsheet model for this problem and solve it. c. What is the optimal solution?