Microsoft Office Tutorials and References
In Depth Information
EXTENDING THE EXAMPLE
Go to cell C10 on the worksheet, replace 22 with 17, and run Solver again. When Solver finds the
solution, select Answer to create another Answer Report, and then click OK. See Figure D-41.
Solver solution with redesigned treadmill and packaging
Check the Answer Report to see the cost difference between shipping the old treadmills and the
redesigned models (see Figure D-42). The cost savings for one shipment is $2,679, which is more than five times
the minimum savings you needed. You should go ahead with the project.
Answer Report for the treadmill redesign