Need help with financial data analysis

profilepurplebed
BUS522Unit3PivotData.xlsx
Home>Business & Finance homework help>Accounting homework help>Need help with financial data analysis

Data

Order Details for December 2016
Order ID Order Date Customer ID Address City State Country Salesperson Region Shipped Date Shipper Name Ship Name Ship Address Ship City Ship State Flavor Unit Price Quantity Revenue Shipping Fee
1389 12/01/16 1 123 1st Street Seattle WA USA Nancy Freehafer North Anna Bedecs 123 1st Street Seattle WA Lemon $5.95 64 $380.80 $118.66
1390 12/02/16 1 123 1st Street Seattle WA USA Nancy Freehafer North Anna Bedecs 123 1st Street Seattle WA Chocolate $5.95 82 $487.90 $392.29
1391 12/03/16 1 123 1st Street Seattle WA USA Nancy Freehafer North Anna Bedecs 123 1st Street Seattle WA Chocolate $5.95 17 $101.15 $5.13
1421 12/04/16 1 123 1st Street Seattle WA USA Nancy Freehafer North Shipping Company C Anna Bedecs 123 1st Street Seattle WA Vanilla $5.95 88 $523.60 $148.14
1378 12/03/16 3 123 3rd Street Los Angelas CA USA Mariya Sergienko West 12/05/16 Shipping Company B Thomas Axerr 123 3rd Street Los Angelas CA Apple $5.95 89 $529.55 $81.59
1412 12/04/16 3 123 3rd Street Los Angelas CA USA Mariya Sergienko West 12/06/16 Shipping Company B Thomas Axerr 123 3rd Street Los Angelas CA Strawberry $5.95 49 $291.55 $90.25
1413 12/05/16 3 123 3rd Street Los Angelas CA USA Mariya Sergienko West 12/07/16 Shipping Company B Thomas Axerr 123 3rd Street Los Angelas CA Red Velvet $5.95 29 $172.55 $239.12
1432 12/06/16 3 123 3rd Street Los Angelas CA USA Mariya Sergienko West Thomas Axerr 123 3rd Street Los Angelas CA Strawberry $5.95 12 $71.40 $17.04
1376 12/07/16 4 123 4th Street New York NY USA Andrew Cencini East 12/09/16 Shipping Company C Christina Lee 123 4th Street New York NY Chocolate Biscuits Mix $5.95 97 $577.15 $93.70
1406 12/04/16 4 123 4th Street New York NY USA Andrew Cencini East 12/06/16 Shipping Company A Christina Lee 123 4th Street New York NY Apple $5.95 62 $368.90 $117.94
1407 12/04/16 4 123 4th Street New York NY USA Andrew Cencini East 12/06/16 Shipping Company A Christina Lee 123 4th Street New York NY Vanilla $5.95 91 $541.45 $13.72
1410 12/04/16 4 123 4th Street New York NY USA Andrew Cencini East 12/06/16 Shipping Company C Christina Lee 123 4th Street New York NY German Chocolate $5.95 25 $148.75 $9.00
1431 12/04/16 4 123 4th Street New York NY USA Andrew Cencini East Christina Lee 123 4th Street New York NY Raspbery $5.95 33 $196.35 $175.03
1379 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI Apple $5.95 25 $148.75 $96.00
1396 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI German Chocolate $5.95 85 $505.75 $115.43
1404 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company C Francisco Pérez-Olaeta 123 6th Street Milwaukee WI Chocolate $5.95 100 $595.00 $122.40
1414 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI German Chocolate $5.95 13 $77.35 $31.00
1424 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI German Chocolate $5.95 41 $243.95 $43.78
1429 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company C Francisco Pérez-Olaeta 123 6th Street Milwaukee WI Strawberry $5.95 12 $71.40 $200.85
1430 12/06/16 6 123 6th Street Milwaukee WI USA Michael Neipper North 12/08/16 Shipping Company C Francisco Pérez-Olaeta 123 6th Street Milwaukee WI Red Velvet $5.95 68 $404.60 $225.62
1383 12/07/16 7 123 7th Street Boise ID USA Nancy Freehafer North Ming-Yang Xie 123 7th Street Boise ID Vanilla $5.95 64 $380.80 $279.68
1418 12/07/16 7 123 7th Street Boise ID USA Nancy Freehafer North Ming-Yang Xie 123 7th Street Boise ID Chocolate $5.95 15 $89.25 $33.00
1375 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR Lemon $5.95 28 $166.60 $24.47
1381 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR Chocolate $5.95 36 $214.20 $45.44
1397 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company B Elizabeth Andersen 123 8th Street Portland OR Raspbery $5.95 82 $487.90 $318.16
1398 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company B Elizabeth Andersen 123 8th Street Portland OR Strawberry $5.95 47 $279.65 $41.51
1409 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR Red Velvet $5.95 29 $172.55 $300.85
1416 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR Coffee $5.95 18 $107.10 $34.00
1425 12/08/16 8 123 8th Street Portland OR USA Nancy Freehafer North 12/10/16 Shipping Company B Elizabeth Andersen 123 8th Street Portland OR Raspbery $5.95 67 $398.65 $82.88
1394 12/09/16 9 123 9th Street Salt Lake City UT USA Robert Zare West 12/11/16 Shipping Company A Sven Mortensen 123 9th Street Salt Lake City UT Strawberry $5.95 85 $505.75 $165.75
1395 12/09/16 9 123 9th Street Salt Lake City UT USA Robert Zare West 12/11/16 Shipping Company A Sven Mortensen 123 9th Street Salt Lake City UT Red Velvet $5.95 18 $107.10 $61.39
1423 12/09/16 9 123 9th Street Salt Lake City UT USA Robert Zare West 12/11/16 Shipping Company A Sven Mortensen 123 9th Street Salt Lake City UT Red Velvet $5.95 34 $202.30 $68.58
1382 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East 12/12/16 Shipping Company B Roland Wacker 123 10th Street Chicago IL Chocolate $5.95 93 $553.35 $26.42
1384 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East 12/12/16 Shipping Company A Roland Wacker 123 10th Street Chicago IL Strawberry $5.95 84 $499.80 $220.50
1385 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East 12/12/16 Shipping Company A Roland Wacker 123 10th Street Chicago IL Red Velvet $5.95 72 $428.40 $150.48
1386 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East 12/12/16 Shipping Company A Roland Wacker 123 10th Street Chicago IL German Chocolate $5.95 60 $357.00 $56.86
1417 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East 12/12/16 Shipping Company B Roland Wacker 123 10th Street Chicago IL Lemon $5.95 81 $481.95 $62.83
1419 12/10/16 10 123 10th Street Chicago IL USA Laura Giussani East Shipping Company A Roland Wacker 123 10th Street Chicago IL Chocolate $5.95 96 $571.20 $21.32
1387 12/11/16 11 123 11th Street Miami FL USA Anne Larsen South Shipping Company C Peter Krschne 123 11th Street Miami FL Raspbery $5.95 67 $398.65 $22.75
1388 12/11/16 11 123 11th Street Miami FL USA Anne Larsen South Shipping Company C Peter Krschne 123 11th Street Miami FL Coffee $5.95 48 $285.60 $13.63
1420 12/11/16 11 123 11th Street Miami FL USA Anne Larsen South Shipping Company C Peter Krschne 123 11th Street Miami FL Apple $5.95 81 $481.95 $378.00
1408 12/12/16 12 123 12th Street Las Vegas NV USA Mariya Sergienko West 12/14/16 Shipping Company B John Edwards 123 12th Street Las Vegas NV Strawberry $5.95 25 $148.75 $8.00
1399 12/25/16 25 789 25th Street Chicago IL USA Laura Giussani East 12/27/16 Shipping Company A John Rodman 789 25th Street Chicago IL Red Velvet $5.95 99 $589.05 $99.00
1426 12/25/16 25 789 25th Street Chicago IL USA Laura Giussani East 12/27/16 Shipping Company A John Rodman 789 25th Street Chicago IL Strawberry $5.95 74 $440.30 $84.48
1400 12/26/16 26 789 26th Street Miami FL USA Anne Larsen South 12/28/16 Shipping Company C Run Liu 789 26th Street Miami FL German Chocolate $5.95 49 $291.55 $106.71
1401 12/26/16 26 789 26th Street Miami FL USA Anne Larsen South 12/28/16 Shipping Company C Run Liu 789 26th Street Miami FL Raspbery $5.95 72 $428.40 $72.95
1402 12/26/16 26 789 26th Street Miami FL USA Anne Larsen South 12/28/16 Shipping Company C Run Liu 789 26th Street Miami FL Coffee $5.95 99 $589.05 $191.27
1427 12/26/16 26 789 26th Street Miami FL USA Anne Larsen South 12/28/16 Shipping Company C Run Liu 789 26th Street Miami FL Red Velvet $5.95 24 $142.80 $164.15
1405 12/27/16 27 789 27th Street Las Vegas NV USA Mariya Sergienko West 12/29/16 Shipping Company B Karen Toh 789 27th Street Las Vegas NV Chocolate $5.95 17 $101.15 $27.00
1380 12/28/16 28 789 28th Street Memphis TN USA Anne Larsen South 12/30/16 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN Coffee $5.95 19 $113.05 $89.15
1392 12/28/16 28 789 28th Street Memphis TN USA Anne Larsen South 12/30/16 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN Apple $5.95 38 $226.10 $36.67
1393 12/28/16 28 789 28th Street Memphis TN USA Anne Larsen South 12/30/16 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN Vanilla $5.95 25 $148.75 $45.54
1415 12/28/16 28 789 28th Street Memphis TN USA Anne Larsen South 12/30/16 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN Raspbery $5.95 25 $148.75 $20.00
1422 12/28/16 28 789 28th Street Memphis TN USA Anne Larsen South 12/30/16 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN Strawberry $5.95 92 $547.40 $365.15
1377 12/29/16 29 789 29th Street Denver CO USA Jan Kotas West 12/31/16 Shipping Company B Soo Jung Lee 789 29th Street Denver CO Chocolate $5.95 23 $136.85 $29.33
1403 12/29/16 29 789 29th Street Denver CO USA Jan Kotas West 12/31/16 Shipping Company B Soo Jung Lee 789 29th Street Denver CO Lemon $5.95 10 $59.50 $13.86
1411 12/29/16 29 789 29th Street Denver CO USA Jan Kotas West 12/31/16 Shipping Company B Soo Jung Lee 789 29th Street Denver CO Raspbery $5.95 48 $285.60 $23.00
1428 12/29/16 29 789 29th Street Denver CO USA Jan Kotas West 12/31/16 Shipping Company B Soo Jung Lee 789 29th Street Denver CO Raspbery $5.95 41 $243.95 $193.01
1370 12/04/16 4 123 4th Street New York NY USA Andrew Cencini East 12/06/16 Shipping Company A Christina Lee 123 4th Street New York NY Strawberry $5.95 81 $481.95 $255.15
1371 12/05/16 4 123 4th Street New York NY USA Andrew Cencini East 12/07/16 Shipping Company A Christina Lee 123 4th Street New York NY Red Velvet $5.95 83 $493.85 $461.90
1372 12/06/16 4 123 4th Street New York NY USA Andrew Cencini East 12/08/16 Shipping Company A Christina Lee 123 4th Street New York NY German Chocolate $5.95 75 $446.25 $26.25
1373 12/07/16 12 123 12th Street Las Vegas NV USA Mariya Sergienko West 12/09/16 Shipping Company B John Edwards 123 12th Street Las Vegas NV Raspbery $5.95 97 $577.15 $183.33
1374 12/08/16 12 123 12th Street Las Vegas NV USA Mariya Sergienko West 12/10/16 Shipping Company B John Edwards 123 12th Street Las Vegas NV Coffee $5.95 61 $362.95 $291.82
1368 12/27/16 27 789 27th Street Las Vegas NV USA Mariya Sergienko West 12/29/16 Shipping Company B Karen Toh 789 27th Street Las Vegas NV Chocolate $5.95 19 $113.05 $25.80
1369 12/28/16 27 789 27th Street Las Vegas NV USA Mariya Sergienko West 12/30/16 Shipping Company B Karen Toh 789 27th Street Las Vegas NV Vanilla $5.95 60 $357.00 $20.16

Sales by Rep - Final

Row Labels Sum of Revenue
Nancy Freehafer $17,137.58
Andrew Cencini $12,368.90
Anne Larsen $12,065.27
Michael Neipper $10,514.50
Laura Giussani $7,421.07
Mariya Sergienko $6,942.86
Robert Zare $2,814.65
Jan Kotas $979.25
Grand Total $70,244.08

Sales by Rep for Dec 2014

Total

Nancy Freehafer Andrew Cencini Anne Larsen Michael Neipper Laura Giussani Mariya Sergienko Robert Zare Jan Kotas 17137.579999999998 12368.9 12065.27 10514.5 7421.07 6942.8600000000006 2814.65 979.25

Pivot Table Diagram

Article: How Do Pivot Tables Work?
Source: http://www.excelcampus.com/pivot-tables/pivot-tables-work/
http://www.excelcampus.com/pivot-tables/pivot-tables-work/

Source

Author: Jon Acampora
Source: http://www.excelcampus.com/charts/pivot-tables-dashboards-part-1
Description: Follow along with the video at the link above and learn how to
create your first pivot table and pivot chart.
http://www.excelcampus.com/charts/pivot-tables-dashboards-part-1