The general manager has asked that Scout display at least one Yukon, one Suburban, and one Sonoma. None of the trucks that Scout needs for this event are in stock, so she decides to use GMC's Web site to get the pricing information she needs for each truck. Scout created a worksheet to find the right mix of trucks to include in the promotion. She has asked you to help her use Solver to find the best solution. Click the link to GMC , and then find the pricing information for the Sonoma, Yukon, and Suburban trucks.
Pricing is included on the pages that specify packages.
Print the package information for each model truck. You will use the lowest price for each model truck in your computations. Log off of the Internet, and then close your Web browser. If necessary, start Excel and make sure that your Internet Assignments Disk is in the appropriate drive. Open the Trucks workbook from the disk and save it as Truck Order.