Description:

Explore information at B&B Travel

Benjamin Travis and Brady Austin are co$-$owners of B&B Travel Consultants, a medium$-$size business in Denver with several branch offices. B&B specializes in selling cruise packages. Ben and Brady maintain a workbook that contains information for each cruise package sale including:

A$.$ Location # $$A unique number that identifies the office location

B$.$ Travel Agent$$A unique number that identifies the travel consultant

C$.$ Cruise Line$$the name of the cruise line for which the package was sold

D$.$ Total package price$$the price charged to the customer for the package

E$.$ Commission$$the amount of money B&B made from the sale of the package

Instructions:

$1.$ Download the workbook $($B and B raw data.xls$)$ from the Blackboard.

$2.$ Use tools provided by Google Sheets or MS Excel, such as basic statistics $($average$,$ min, max, sum, count, etc.$),$ filter, conditional formatting, and pivot tables, to analyze the travel information.

$3.$ Create three new worksheets for location, travel consultants, and cruise line, and name them differently. Answer the following questions and justify your answers with concise yet detailed and thorough documentation $($in narrative, numeric, or graphic forms$).$

A$.$ Which, if any, location should be closed $($location sheet$)?$

B$.$ Which travel consultants should be downsized $($consultant sheet$)?$ and

C$.$ On which cruise lines should B&B focus its sales efforts $($cruise line sheet$)?$