CASE

John Sousa is an accounting$/$finance major who is interning for the summer at a small, national

computer manufacturing company. He has been provided with a workbook of three Excel

tables and asked to analyze the following questions for the Sales Manager of the company.

$-$ What was the total sales and profits for the company across all regions relative to the

data provided?

$-$

How do these results "break down" by each region? What would be a good way to

display these results to the regional sales managers that would be easy to understand?

$-$ There is a need to evaluate the effectiveness of each salesperson. For the data available,

prepare a ranking of sales by salesperson and also show the commission due for each