Benjamin Travis and Brady Austin own B&B Travel Consultants, a medium-size business in Seattle with several branch offices.B&B specializes in selling cruise packages.Ben and Brady maintain a workbook called Travel.xlsx that contains information for each cruise package. They have some decisions to make about how to best allocate their funds. In order to earn full credit for your answers in this section, I need to see the use of the decision support features of Excel, and you need to make a specific recommendation (with exact name or location) in two to three sentences. You can use whatever you think appropriate.
undefined
Definitions
undefined
Location #: Identifies each office recording a sale
undefined
Travel Agent #: Identifies each travel consultant recorded the sale
undefined
Cruise Line: Identifies each cruise line sold as a package
undefined
Total Package Price: Price charged to the customer
undefined
Commission: Amount of money B&B made from the sale.
undefined
- Analyze the location data and make recommendations as to which location(s) should be closed. Call this worksheet “Location”.
- Analyze the travel consultant data and make recommendations as to which travel consultant(s) should be downsized. Call this worksheet “Consultant”.
- Analyze the cruise line data and make recommendations as to which cruise line(s) should be focused on. Call this worksheet “Cruise”.
0 comments