Radford Castings can produce brake shoes on six different machines

Radford Castings can produce brake shoes on six different machines. The following summarizes the manufacturing costs associated with producing he brake shoes on each machine along with the available capacity on each machine. If the company has received an order for 1800 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

Formulate an ILP model for this problem
Create a spreadsheet model and solve it
What is the optimal solution