0% found this document useful (0 votes)
64 views6 pages

03 - 3 Math Functions

The document contains sales data from different regions showing the representative, model, units sold, unit cost and total sales. It provides totals for various categories like sales by region and representative, average units and sales, as well as breakdowns of sales and units by model type. In total it analyzes sales data for 10 representatives across 3 regions and 17 different models.

Uploaded by

Jen Del Rosario
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
64 views6 pages

03 - 3 Math Functions

The document contains sales data from different regions showing the representative, model, units sold, unit cost and total sales. It provides totals for various categories like sales by region and representative, average units and sales, as well as breakdowns of sales and units by model type. In total it analyzes sales data for 10 representatives across 3 regions and 17 different models.

Uploaded by

Jen Del Rosario
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Year Start -

Employee
First Name Last Name Supervisor Name Team Number Items Sold
John Smith Dollente, Benilda Team A 09-676754 567
George McKinley Dollente, Benilda Team B 08-543521 789
Michael Andrews de Sagun, Arnel Team B 09-432100 345

Sheldon Jones Dollente, Benilda Team A 07-345632 654


Leonard Howard de Sagun, Arnel Team A 07-689543 321
Mark Jardine Dollente, Benilda Team B 08-320987 167
Abigail Thompson de Sagun, Arnel Team B 09-875674 890
Pauline Kivell de Sagun, Arnel Team A 08-104338 344
Micah Wayne Dollente, Benilda Team A 09-906764 478
Bernadette Gill de Sagun, Arnel Team A 09-430989 535
Sum of Items Sold 5090
Total Employees 10

Count of Members per Sum of Items Sold per


Team Team
Team A 6 2899
Team B 4 2191
Region Rep Item Status Units Unit Cost Total Sales
Luzon Juan Package A Pending 95 ₱ 1.99 ₱ 189.05
Visayas Karlo Package B Pending 50 ₱ 19.99 ₱ 999.50
Visayas Jardine Package A Completed 36 ₱ 4.99 ₱ 179.64
Luzon Gill Package C Completed 27 ₱ 19.99 ₱ 539.73
Luzon Sorvino Package A On Hold 100 ₱ 19.99 ₱ 1,999.00
Mindanao Juan Package B Pending 60 ₱ 4.99 ₱ 299.40
Visayas Andrea Package A Completed 12 ₱ 1.99 ₱ 23.88
Visayas Jardine Package A Completed 90 ₱ 4.99 ₱ 449.10
Luzon Tomas Package A Pending 32 ₱ 1.99 ₱ 63.68
Luzon Juan Package B Pending 60 ₱ 8.99 ₱ 539.40
Mindanao Howard Package B Completed 29 ₱ 1.00 ₱ 29.00
Luzon Juan Package A Completed 35 ₱ 4.99 ₱ 174.65
Mindanao Juan Package C On Hold 16 ₱ 1.29 ₱ 20.64
Mindanao Juan Package C Pending 64 ₱ 8.99 ₱ 575.36
Visayas Karlo Package C Completed 96 ₱ 4.99 ₱ 479.04
Mindanao Juan Package C Pending 74 ₱ 1.29 ₱ 95.46
Visayas Gill Package B Pending 46 ₱ 8.99 ₱ 413.54
Visayas Smith Package B Pending 87 ₱ 15.00 ₱ 1,305.00
Mindanao Juan Package B Completed 4 ₱ 4.99 ₱ 19.96
Luzon Sorvino Package B Completed 7 ₱ 19.99 ₱ 139.93
Visayas Jardine Package C On Hold 50 ₱ 4.99 ₱ 249.50
Visayas Andrea Package A Pending 66 ₱ 1.99 ₱ 131.34
Mindanao Howard Package C Completed 96 ₱ 4.99 ₱ 479.04
Visayas Gill Package A Pending 53 ₱ 1.29 ₱ 68.37
Visayas Gill Package B Pending 80 ₱ 8.99 ₱ 719.20
Visayas Karlo Package D Pending 19 ₱ 50.00 ₱ 950.00
Luzon Juan Package C Completed 62 ₱ 4.99 ₱ 309.38
Visayas Morgan Package C Completed 55 ₱ 1.99 ₱ 109.45
Visayas Karlo Package C On Hold 42 ₱ 5.00 ₱ 210.00
Luzon Sorvino Package D Pending 57 ₱ 19.99 ₱ 1,139.43
Visayas Gill Package A Completed 7 ₱ 1.29 ₱ 9.03
Luzon Sorvino Package C Pending 76 ₱ 1.99 ₱ 151.24
Luzon Tomas Package B Pending 57 ₱ 19.99 ₱ 1,139.43
Visayas Andrea Package A Pending 14 ₱ 1.29 ₱ 18.06
Visayas Jardine Package B Completed 11 ₱ 4.99 ₱ 54.89
Visayas Jardine Package B Completed 94 ₱ 19.99 ₱ 1,879.06
Visayas Andrea Package B On Hold 28 ₱ 4.99 ₱ 139.72

Developed by Contextures Inc. www.contextures.com


Total Entries per Status
Pending 17
Completed 15
On Hold 5

Total Sales per Rep


Juan 2223.3
Andrea 313
Jardine 2812.19
Sorvino 3429.6
Gill 1749.87

Average Sales per Region


Luzon 580.447272727273
Visayas 441.490526315789
Mindanao 216.98

Total Sales
Mindanao Package B 348.36
Mindanao Package C 1170.5

Average Units Sold


Visayas Andrea Package B 28
Luzon Sorvino Package B 7
Luzon Gill Package C 27

Developed by Contextures Inc. www.contextures.com


Region Rep Model Units Unit Cost Total Sales
Luzon Juan PH-1276 95 ₱ 1.99 ₱ 189.05
Visayas Karlo PH-1249 50 ₱ 19.99 ₱ 999.50
Visayas Jardine PH-994 36 ₱ 4.99 ₱ 179.64
Luzon Gill UK-3344 27 ₱ 19.99 ₱ 539.73
Luzon Sorvino 3-AUS-7585 100 ₱ 19.99 ₱ 1,999.00
Mindanao Juan US-573 60 ₱ 4.99 ₱ 299.40
Visayas Andrea PH-769 12 ₱ 1.99 ₱ 23.88
Visayas Jardine PH-7350 90 ₱ 4.99 ₱ 449.10
Luzon Tomas PH-8052 32 ₱ 1.99 ₱ 63.68
Luzon Juan UK-534 60 ₱ 8.99 ₱ 539.40
Mindanao Howard PH-8807 29 ₱ 1.00 ₱ 29.00
Luzon Gabby PH-5507 35 ₱ 4.99 ₱ 174.65
Mindanao Juan 3-AUS-1935 16 ₱ 1.29 ₱ 20.64
Mindanao Juan PH-8613 64 ₱ 8.99 ₱ 575.36
Visayas Karlo US-902 96 ₱ 4.99 ₱ 479.04
Mindanao Juan US-8113 74 ₱ 1.29 ₱ 95.46
Visayas Gill PH-499 46 ₱ 8.99 ₱ 413.54
Visayas Smith UK-544 87 ₱ 15.00 ₱ 1,305.00
Mindanao Juan PH-1681 4 ₱ 4.99 ₱ 19.96
Luzon Sorvino PH-8514 7 ₱ 19.99 ₱ 139.93
Visayas Jardine 41-AUS-6749 50 ₱ 4.99 ₱ 249.50
Visayas Andrea PH-1559 66 ₱ 1.99 ₱ 131.34
Mindanao Howard UK-6177 96 ₱ 4.99 ₱ 479.04
Visayas Gill PH-773 53 ₱ 1.29 ₱ 68.37
Sales
All PH models 3457 * -- anything
All AUS Models 2269.14

Units
US 230 0
PH 619
UK 270

You might also like