Download the Excel file: travel.xlsx. It contains information about locations, travel agents, cruise lines, pricing, and commission paid to agents. Descriptions of the fields are as follows:
Column Name Description
A Location ID unique number assigned to each location
B Travel Agent ID unique number assigned to each travel agent
C Cruise line name of cruise line
D Total package price total price charged for travel
E Commission commission charged
Add one additional column to calculate the revenue after commission is deducted from total package price.
Create pivot tables to help you answer the following questions:
Design a table that shows total revenue generated by each destination. Which destination brings in the most revenue?
Design a table that shows the total revenue generated by each travel agent. Who is the best employee (travel agent)?
Design a table that shows which cruise line is the most valuable for the travel agency.
Design a table that calculates the total revenue by travel agent, location, and cruise line. Which location on which line bring in the most revenue, and which agent is involved in that business?
Provide a table that shows which agent earns the highest average commission for Bahama lines.
Create a 3- to 5-page report to management that provides answers to each of the questions in Question 3 above. The report should include, for each question, an explanation of how your analysis of the pivot table you created enabled you to answer the question, along with implications for running the business (what would the report mean? for example, how would management use each result to make decisions? what types of decisions could be made with the information?). Use tables, graphs, etc., to represent your observations and recommendations based on these analyses. Make sure your report has an introduction and a conclusion.
For this assignment, you must submit:
an Excel spreadsheet
AND
a Word document
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|