Homework answers / question archive / Benjamin Travis and Brady Austin own B&B Travel Consultants, a medium-size business in Seattle with several branch offices

Benjamin Travis and Brady Austin own B&B Travel Consultants, a medium-size business in Seattle with several branch offices

Business

Share With

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

Definitions

Location #: Identifies each office recording a sale

Travel Agent #: Identifies each travel consultant recorded the sale

Cruise Line: Identifies each cruise line sold as a package

Total Package Price: Price charged to the customer

Commission: Amount of money B&B made from the sale.

• 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”.