The media is produced on three different replication machines. Each replication machine has different specifications. Some media may be run on only some machine while others may be run on all three. Each machine has a different hourly cost to run.

For each order, use solver (in excel) to find which production mix satisfies the customer requirements at the least cost to Reasonable Replications. Remember you cannot produce part of a CD, etc.

Reasonable Replications, Inc. Order Scheduling and Optimization Machine 1 Machine 2 Machine 3 Discs per Hour on Machine 6 7' 8 Cost per Hour of Machine $43.00 $44.10 $54.40 Total Discs for IDIrder Optimal CDs on Machine 0 0 0 0 Optimal CDRs on Machine 0 0 0 Optimal DVDs on Machine 0 0 Optimal SACDS on Machine 0 0 Total Hours for Order 0.00 0.00 0.00 Total Cost for Order 50.00 $0.00 $0.00 50.00 Order Constraints Order 1 Maximum Hours for Order per machine C05 Needed for Order 200 CDRs Needed for Order 255 DVDs Needed for Order 300 SACDs Needed for Order 285