Radford Castings

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. Note that the fixed cost should be paid only if the machine is used.

If the company has received an order for $1800$ brake shoes, how should it schedule these machines to

minimize the total cost? Formulate a model that can be used to solve this problem and solve it in Excel.

USE SOLVER AND SHOW EVERY STEP