Microsoft Office Tutorials and References
In Depth Information
USING EXCEL SOLVER
FIGURE D-3
Add-Ins pane
FIGURE D-4
Add-Ins dialog box with Solver, Analysis ToolPak, and Analysis ToolPak VBA selected
USING EXCEL SOLVER
A fictional company called CV Fitness builds exercise machines in its plant in Memphis, Tennessee and ships
them to its stores across the country. The company has a small fleet of trucks and tractor-trailers to ship its
products from the factory to its stores. It costs less money per cubic foot of capacity to ship products with
tractor-trailers than with trucks, but the company has a limited number of both types of vehicles, and must
ship a specified amount of each type of product to each destination. You have been asked to determine the
optimal mix of trucks and tractor-trailers to send merchandise to each store. The optimal mix will have the
lowest total shipping cost while ensuring that the required quantity of products is shipped to each store.
Search JabSto ::




Custom Search