Microsoft Office Tutorials and References
In Depth Information
EXTENDING THE EXAMPLE
Answer Report 3 displays a more cost-effective solution
Seven tractor-trailers and 11 trucks are the optimal mix
You have a solution for the expansion to seven stores. Save your workbook, and then create a new
workbook using the Save As command. Name the new workbook CV Fitness Trucking Problem 3.xlsx.
Next, evaluate the potential cost savings if the company redesigns its treadmill product and packaging to
reduce the shipping volume from 22 cubic feet to 17 cubic feet. Your engineers report that the redesign will
cost approximately $10,000. If you can save at least $500 per shipment, the project will pay for itself in less
than six months (20 weekly shipments).