Determine the number of data and the parameter fields to be examined.

Based on the given data, determine the number of branches of the company.

Which branches are not in Metro Manila?

How much is total yearly sales of the company?

Which branch has the highest amount of sales? How much?

Which branch has the lowest amount of sales? How much?

Based on the given data, what is your forecast next year? Which branch will yield the highest sales? The branch that will yield the lowest? Why?

Which 3 branches will you recommend to close should the company opt to do a reorganization based on total sales?

Create a chart showing the total sales of each branch per month.

Note: Place your results in a Powerpoint slide for Tasks 2-10 (1 slide per task), and save as Task1(LastnamesOfMembers).ppt and send to justinp@apc.edu.ph

Task 2: Determine the information about your customers

Determine the number of data and the parameter fields to be examined.

Based on the given data, determine how many customers are male and female.

How many customers have an Advantage Card?

How many customers that have an Advantage Card are male and female?

How many customers are from Luzon, Visayas and Mindanao?

How much is the sales for Luzon, Visayas and Mindanao.

Create a chart showing the total sales in Luzon, Visayas and Mindanao with the gender as qualifier.

Note: Place your results in a Powerpoint slide for Tasks 2-8 (1 slide per task), and save as Task2(LastnamesOfMembers).ppt and send to justinp@apc.edu.ph