Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


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

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

Option 1

Low Cost Option
Download this past answer in few clicks

20.89 USD

PURCHASE SOLUTION

Already member?


Option 2

Custom new solution created by our subject matter experts

GET A QUOTE