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. Save the solution(s) as Scenario Order 1 and Scenario Order 2. Produce an answer report for each solution.

Reasonable Replications, Inc. Order Scheduling and Optimization Machine 1 Machine 2 Machine 3 Discs per Hour on Machine 6 7 3 Cost per Hour of Machine $43.00 $44.10 $54.40 Total Discs for Order Optimal C05 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 $0.00 $0.00 $0.00 $0.00 Order Constraints Order 1 Order 2 Maximum Hours for Order per machine 50 80 C05 Needed for Order 200 1000 CDRs Needed for Order 255 100 DVDs Needed for Order 300 7'5 SACDs Needed for Order 285 480