This assignment will give you an opportunity to discover

This assignment will give you an
opportunity to discover the power of simple analytic tools built into the
Microsoft Excel program. You will create a number of tables responding to
questions pertaining to the data in the tables in Part 1. In Part 2 you will
analyze the data and respond to questions.

General Information:

Use the following information to
ensure successful completion of the assignment:

• Use
“MGT-820-R-WorkingwithPivotTablesT5.xlsx” to complete this assignment.

• APA style for their writing
assignment

Directions:

Part 1

Using the data in the

MGT-820-RS-WorkingwithPivotTablesT5.xlsx
file, create Pivot Tables to be able to respond to the questions in Part 2.

Part 2

Using the data tables you created
in the previous section or by creating new tables, write a report (750-1,000
words) that addresses the following questions:

• Are all sales persons operating
at the same efficiency?

• Are all cities producing the
same results?

• Is one product performing better
in one city as compared to another city?

• Based on the results, what
trends have you identified? What action(s) would you recommend to senior
management?

• Based on your use of the Pivot
Table:

o Was it easy to use?

o Would you use it again to
analyze data?

o Looking at month/year, revenue,
and returns, what can be said about the results of the sales force?