The American Car Association (ACA) provides a variety of travel-related services to its members, including information on
Question:
The American Car Association (ACA) provides a variety of travel-related services to its members, including information on vacation destinations, discount hotel reservations, emergency road assistance, and travel route planning. This last service, travel route planning, is one of its most popular services. When members of the ACA are planning to take a driving trip, they call the organization's toll-free 800 number and indicate what cities they will be traveling from and to. The ACA then determines an optimal route for traveling between these cities. The ACA's computer databases of major highways and interstates are kept up-to-date with information on construction delays and detours and estimated travel times along various segments of roadways.
Members of the ACA often have different objectives in planning driving trips. Some are interested in identifying routes that minimize travel times. Others, with more leisure time on their hands, want to identify the most scenic route to their de-sired destination. The ACA wants to develop an automated system for identifying an optimal travel plan for its members.
Build a model that maximizes the most scenic route (Scenic Points) traveled from Birmingham to Virginia Beach. How many more hours does the most scenic route take than the shortest route in terms of time (Travel hours)?
**Pls show formula in excel and using solver.
Intermediate Accounting
ISBN: 978-0077400163
6th edition
Authors: J. David Spiceland, James Sepe, Mark Nelson