Assignment: Managerial Decision$$Making$.$

$$Data Analysis with MS EXCEL$$

With this assignment, you demonstrate your capability of managerial decision$-$making while

analyzing some data sets from an actual business occurrence. To get quick answers to typical

business questions, you$$re using MS EXCEL and its pivot functionalities. Furthermore, you use

EXCEL$$s built$-$in functions to produce graphs and charts.

The data sets include sales data from companies selling different types of bottled water to their

customers $($see tab $$Sales$).$ Additionally, there are data sets related to the company valuations

of the different companies $($see tab $$Company$\_$Valuation$)$ along with marketing expense data

$($see tab $$Marketing$\_$Expenses$).$

All data is stored within the Excel $$COMPANY$\_$DATA.xlsx$.$

Here are the business questions you need to answer.

PART I: Looking separately at the Company$\_$Valuation data and the Sales data:

$1.$ Which COMPANY$\_$CODE is valued most?

$2.$ Which SALES$\_$ORGANIZATION sold most products?

$3.$ Which SALES$\_$ORGANIZATION made the biggest profit?

For each question, write your answer and produce a graph that supports your responses.