来自加拿大代写的顾客授权发布的Management Information Systems，CMIS351作业要求片段，我们不会发布CMIS351的answer在网站，我们曾经写过CMIS351及相关的Management Information Systems写过很多作业，考试，如果你也需要代写这个课程的作业请联系客服WX:QQ 5757940 ，代写人的代写服务覆盖全球华人留学生，可以为CA的学生提供非常准时精湛的服务，小作业assignment代写、essay代写享适时优惠，project、paper代写、论文代写支持分期付款，网课、exam代考预约时刻爆单中赶紧来撩。
这项作业让你有机会练习使用透视表来分析数据和做出决策。这些表格对管理人员来说特别重要，因为它们提供了容易获得的商业智能工具，就在管理人员的办公桌上。如果你需要关于数据透视表的帮助，请参阅"（知识扩展）KE4-9。什么是数据透视表，我如何使用它们 "的课本。Microsoft Office也提供数据透视表支持。
Task
This assignment gives you an opportunity to practice the use of pivot tables for analyzing data and making decisions. These tables are particularly important for managers because they provide easily accessible business intelligence tools, right at the manager’s desk. If you need help with pivot tables, refer to “(Knowledge Extension) KE4-9: What are Pivot Tables and How Do I Use Them” in the textbook. Microsoft Office also provides Pivot Table support.
Instructions:
1. Download the Excel file: xlmd_travel.xls. 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 |
2.
3. Add one additional column to calculate the revenue after commission is deducted from total package price.
4. Create pivot tables to help you answer the following questions:
a. Design a table that shows total revenue generated by each destination. Which destination brings in the most revenue?
b. Design a table that shows the total revenue generated by each travel agent. Who is the best employee (travel agent)?
c. Design a table that shows which cruise line is the most valuable for the travel agency.
d. 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?
e. Provide a table that shows which agent earns the highest average commission for Bahama lines.
5. 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 formatting guidelines, see Writing An Analytical Report.
For this assignment, you must submit:
- An Excel spreadsheet
- A Word document
If you are a student from an English-speaking country, please feel free to contact us at [email protected] and we will provide you with an excellent writing service.
为什么选择代写人 代写
作为现存十年的代写服务机构，我们没有任何学术丑闻，我们保护顾客隐私、多元化辅导、写作、越来越多的小伙伴选择代写人为他们解决棘手的各类作业难题，保障GPA，为留学梦助力！ 我们的客服团队及写手老师总是能第一时间响应顾客的各类作业需求，有些人即使有重要的事甚至带伤上场协助考试。Final季，忙的时候一天十几场考试还在继续坚持着，我知道，他们明明可以不用这么辛苦的…但是他们为了坚守承诺，为了另一端屏幕外的那一份期望，他们没有选择退缩、时刻为同学们提供最好的！这么有温度的代写还不添加备用一下？WX/QQ： 5757940
