Please help with Excel Solver formulations.

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 Fixed Cost Variable Cost Capacity 1 $1000 $21 500 2 $ 950 $23 600 3 $ 875 $25 750 4 $ 850 $24 400 01 $ 800 $20 600 $ 700 $26 800 A B D E F G H 1 Radford Castings 1 2 3 4 5 Binary Variable 0 0 Linking Constraint 0 0 Machine 1 2 3 4 5 6 Fixed Cost $1000 $950 $875 $850 $800 $700 Variable Cost $21 $23 $25 $24 $20 $26 0 6 7 8 9 10 11 12 13 14 15 16 0 Capacity Quantity 500 0 600 0 750 0 400 0 600 0 800 0 Available Required 1800 0 0 0 0 0 0 Total Variable Cost Total Fixed Cost Total Cost $0 $0 $0 17 18 19 20 21 22