Revenue Analysis

Sales

Order ID Order Date Customer ID Customer Name Address City State ZIP/Postal Code Country/Region Salesperson Region Shipped Date Shipper Name Ship Name Ship Address Ship City Ship State Ship ZIP/Postal Code Ship Country/Region Payment Type Product Name Category Unit Price Quantity Revenue Shipping Fee
1368 12/27/18 27 Company AA 789 27th Street Las Vegas NV 99999 USA Mariya Sergienko West 43463 Shipping Company B Karen Toh 789 27th Street Las Vegas NV 99999 USA Check Beer Beverages 14 19 266 25.802
1369 12/27/18 27 Company AA 789 27th Street Las Vegas NV 99999 USA Mariya Sergienko West 43463 Shipping Company B Karen Toh 789 27th Street Las Vegas NV 99999 USA Check Dried Plums Dried Fruit & Nuts 3.5 60 210 20.16
1370 12/4/18 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini East 43440 Shipping Company A Christina Lee 123 4th Street New York NY 99999 USA Credit Card Dried Pears Dried Fruit & Nuts 30 81 2430 255.15
1371 12/4/18 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini East 43440 Shipping Company A Christina Lee 123 4th Street New York NY 99999 USA Credit Card Dried Apples Dried Fruit & Nuts 53 83 4399 461.895
1372 12/4/18 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini East 43440 Shipping Company A Christina Lee 123 4th Street New York NY 99999 USA Credit Card Dried Plums Dried Fruit & Nuts 3.5 75 262.5 26.25
1373 12/12/18 12 Company L 123 12th Street Las Vegas NV 99999 USA Mariya Sergienko West 43448 Shipping Company B John Edwards 123 12th Street Las Vegas NV 99999 USA Credit Card Chai Beverages 18 97 1746 183.33
1374 12/12/18 12 Company L 123 12th Street Las Vegas NV 99999 USA Mariya Sergienko West 43448 Shipping Company B John Edwards 123 12th Street Las Vegas NV 99999 USA Credit Card Coffee Beverages 46 61 2806 291.824
1375 12/8/18 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer North 43444 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR 99999 USA Credit Card Chocolate Biscuits Mix Baked Goods & Mixes 9.2 28 257.6 24.472
1376 12/4/18 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini East 43440 Shipping Company C Christina Lee 123 4th Street New York NY 99999 USA Check Chocolate Biscuits Mix Baked Goods & Mixes 9.2 97 892.4 93.702
1377 12/29/18 29 Company CC 789 29th Street Denver CO 99999 USA Jan Kotas West 43465 Shipping Company B Soo Jung Lee 789 29th Street Denver CO 99999 USA Check Chocolate Candy 12.75 23 293.25 29.325
1378 12/3/18 3 Company C 123 3rd Street Los Angelas CA 99999 USA Mariya Sergienko West 43439 Shipping Company B Thomas Axerr 123 3rd Street Los Angelas CA 99999 USA Cash Clam Chowder Soups 9.65 89 858.85 81.59075
1379 12/6/18 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper North 43442 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999 USA Credit Card Curry Sauce Sauces 40 25 1000 96
1380 12/28/18 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen South 43464 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN 99999 USA Check Coffee Beverages 46 19 874 89.148
1381 12/8/18 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer North 43444 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR 99999 USA Check Chocolate Candy 12.75 36 459 45.441
1382 12/10/18 10 Company J 123 10th Street Chicago IL 99999 USA Laura Giussani East 43446 Shipping Company B Roland Wacker 123 10th Street Chicago IL 99999 USA Credit Card Green Tea Beverages 2.99 93 278.07 26.41665
1383 12/7/18 7 Company G 123 7th Street Boise ID 99999 USA Nancy Freehafer North Ming-Yang Xie 123 7th Street Boise ID 99999 USA Coffee Beverages 46 64 2944 279.68
1384 12/10/18 10 Company J 123 10th Street Chicago IL 99999 USA Laura Giussani East 43446 Shipping Company A Roland Wacker 123 10th Street Chicago IL 99999 USA Boysenberry Spread Jams, Preserves 25 84 2100 220.5
1385 12/10/18 10 Company J 123 10th Street Chicago IL 99999 USA Laura Giussani East 43446 Shipping Company A Roland Wacker 123 10th Street Chicago IL 99999 USA Cajun Seasoning Condiments 22 72 1584 150.48
1386 12/10/18 10 Company J 123 10th Street Chicago IL 99999 USA Laura Giussani East 43446 Shipping Company A Roland Wacker 123 10th Street Chicago IL 99999 USA Chocolate Biscuits Mix Baked Goods & Mixes 9.2 60 552 56.856
1387 12/11/18 11 Company K 123 11th Street Miami FL 99999 USA Anne Larsen South Shipping Company C Peter Krschne 123 11th Street Miami FL 99999 USA Dried Plums Dried Fruit & Nuts 3.5 67 234.5 22.7465
1388 12/11/18 11 Company K 123 11th Street Miami FL 99999 USA Anne Larsen South Shipping Company C Peter Krschne 123 11th Street Miami FL 99999 USA Green Tea Beverages 2.99 48 143.52 13.6344
1389 12/1/18 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer North Anna Bedecs 123 1st Street Seattle WA 99999 USA Chai Beverages 18 64 1152 118.656
1390 12/1/18 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer North Anna Bedecs 123 1st Street Seattle WA 99999 USA Coffee Beverages 46 82 3772 392.288
1391 12/1/18 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer North Anna Bedecs 123 1st Street Seattle WA 99999 USA Green Tea Beverages 2.99 17 50.83 5.13383
1392 12/28/18 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen South 43464 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN 99999 USA Credit Card Clam Chowder Soups 9.65 38 366.7 36.67
1393 12/28/18 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen South 43464 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN 99999 USA Credit Card Crab Meat Canned Meat 18.4 25 460 45.54
1394 12/9/18 9 Company I 123 9th Street Salt Lake City UT 99999 USA Robert Zare West 43445 Shipping Company A Sven Mortensen 123 9th Street Salt Lake City UT 99999 USA Check Ravioli Pasta 19.5 85 1657.5 165.75
1395 12/9/18 9 Company I 123 9th Street Salt Lake City UT 99999 USA Robert Zare West 43445 Shipping Company A Sven Mortensen 123 9th Street Salt Lake City UT 99999 USA Check Mozzarella Dairy Products 34.8 18 626.4 61.3872
1396 12/6/18 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper North 43442 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999 USA Credit Card Beer Beverages 14 85 1190 115.43
1397 12/8/18 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer North 43444 Shipping Company B Elizabeth Andersen 123 8th Street Portland OR 99999 USA Check Curry Sauce Sauces 40 82 3280 318.16
1398 12/8/18 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer North 43444 Shipping Company B Elizabeth Andersen 123 8th Street Portland OR 99999 USA Check Chocolate Biscuits Mix Baked Goods & Mixes 9.2 47 432.4 41.5104
1399 12/25/18 25 Company Y 789 25th Street Chicago IL 99999 USA Laura Giussani East 43461 Shipping Company A John Rodman 789 25th Street Chicago IL 99999 USA Cash Scones Baked Goods & Mixes 10 99 990 99
1400 12/26/18 26 Company Z 789 26th Street Miami FL 99999 USA Anne Larsen South 43462 Shipping Company C Run Liu 789 26th Street Miami FL 99999 USA Credit Card Olive Oil Oil 21.35 49 1046.15 106.7073
1401 12/26/18 26 Company Z 789 26th Street Miami FL 99999 USA Anne Larsen South 43462 Shipping Company C Run Liu 789 26th Street Miami FL 99999 USA Credit Card Clam Chowder Soups 9.65 72 694.8 72.954
1402 12/26/18 26 Company Z 789 26th Street Miami FL 99999 USA Anne Larsen South 43462 Shipping Company C Run Liu 789 26th Street Miami FL 99999 USA Credit Card Crab Meat Canned Meat 18.4 99 1821.6 191.268
1403 12/29/18 29 Company CC 789 29th Street Denver CO 99999 USA Jan Kotas West 43465 Shipping Company B Soo Jung Lee 789 29th Street Denver CO 99999 USA Check Beer Beverages 14 10 140 13.86
1404 12/6/18 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper North 43442 Shipping Company C Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999 USA Check Chocolate Candy 12.75 100 1275 122.4
1405 12/27/18 27 Company AA 789 27th Street Las Vegas NV 99999 USA Mariya Sergienko West 43463 Shipping Company B Karen Toh 789 27th Street Las Vegas NV 99999 USA Check 0 27
1406 12/4/18 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini East 43440 Shipping Company A Christina Lee 123 4th Street New York NY 99999 USA Credit Card Marmalade Jams, Preserves 81 62 1377 117.936
1407 12/4/18 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini East 43440 Shipping Company A Christina Lee 123 4th Street New York NY 99999 USA Credit Card Long Grain Rice Grains 7 91 196 13.72
1408 12/12/18 12 Company L 123 12th Street Las Vegas NV 99999 USA Mariya Sergienko West 43448 Shipping Company B John Edwards 123 12th Street Las Vegas NV 99999 USA Credit Card 0 8
1409 12/8/18 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer North 43444 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR 99999 USA Credit Card Mozzarella Dairy Products 34.8 29 2923.2 300.846
1410 12/4/18 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini East 43440 Shipping Company C Christina Lee 123 4th Street New York NY 99999 USA Check 0 9
1411 12/29/18 29 Company CC 789 29th Street Denver CO 99999 USA Jan Kotas West 43465 Shipping Company B Soo Jung Lee 789 29th Street Denver CO 99999 USA Check 0 23
1412 12/3/18 3 Company C 123 3rd Street Los Angelas CA 99999 USA Mariya Sergienko West 43439 Shipping Company B Thomas Axerr 123 3rd Street Los Angelas CA 99999 USA Cash Syrup Condiments 10 49 280 90.25
1413 12/3/18 3 Company C 123 3rd Street Los Angelas CA 99999 USA Mariya Sergienko West 43439 Shipping Company B Thomas Axerr 123 3rd Street Los Angelas CA 99999 USA Cash Curry Sauce Sauces 40 29 480 239.12
1414 12/6/18 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper North 43442 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999 USA Credit Card 0 31
1415 12/28/18 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen South 43464 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN 99999 USA Check 0 20
1416 12/8/18 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer North 43444 Shipping Company C Elizabeth Andersen 123 8th Street Portland OR 99999 USA Check 0 34
1417 12/10/18 10 Company J 123 10th Street Chicago IL 99999 USA Laura Giussani East 43446 Shipping Company B Roland Wacker 123 10th Street Chicago IL 99999 USA Credit Card Almonds Dried Fruit & Nuts 10 81 450 62.83
1418 12/7/18 7 Company G 123 7th Street Boise ID 99999 USA Nancy Freehafer North Ming-Yang Xie 123 7th Street Boise ID 99999 USA 0 33
1419 12/10/18 10 Company J 123 10th Street Chicago IL 99999 USA Laura Giussani East Shipping Company A Roland Wacker 123 10th Street Chicago IL 99999 USA Dried Plums Dried Fruit & Nuts 3.5 96 301 21.315
1420 12/11/18 11 Company K 123 11th Street Miami FL 99999 USA Anne Larsen South Shipping Company C Peter Krschne 123 11th Street Miami FL 99999 USA Curry Sauce Sauces 40 81 3080 378
1421 12/1/18 1 Company A 123 1st Street Seattle WA 99999 USA Nancy Freehafer North Shipping Company C Anna Bedecs 123 1st Street Seattle WA 99999 USA Crab Meat Canned Meat 18.4 88 680.8 148.1384
1422 12/28/18 28 Company BB 789 28th Street Memphis TN 99999 USA Anne Larsen South 43464 Shipping Company C Amritansh Raghav 789 28th Street Memphis TN 99999 USA Credit Card Coffee Beverages 46 92 1794 365.148
1423 12/9/18 9 Company I 123 9th Street Salt Lake City UT 99999 USA Robert Zare West 43445 Shipping Company A Sven Mortensen 123 9th Street Salt Lake City UT 99999 USA Check Clam Chowder Soups 9.65 34 530.75 68.58255
1424 12/6/18 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper North 43442 Shipping Company B Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999 USA Credit Card Chocolate Candy 12.75 41 1096.5 43.7835
1425 12/8/18 8 Company H 123 8th Street Portland OR 99999 USA Nancy Freehafer North 43444 Shipping Company B Elizabeth Andersen 123 8th Street Portland OR 99999 USA Check Chocolate Candy 12.75 67 1185.75 82.875
1426 12/25/18 25 Company Y 789 25th Street Chicago IL 99999 USA Laura Giussani East 43461 Shipping Company A John Rodman 789 25th Street Chicago IL 99999 USA Cash Cajun Seasoning Condiments 22 74 1166 84.48
1427 12/26/18 26 Company Z 789 26th Street Miami FL 99999 USA Anne Larsen South 43462 Shipping Company C Run Liu 789 26th Street Miami FL 99999 USA Credit Card Boysenberry Spread Jams, Preserves 25 24 1550 164.15
1428 12/29/18 29 Company CC 789 29th Street Denver CO 99999 USA Jan Kotas West 43465 Shipping Company B Soo Jung Lee 789 29th Street Denver CO 99999 USA Check Fruit Cocktail Fruit & Veg 39 41 546 193.011
1429 12/6/18 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper North 43442 Shipping Company C Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999 USA Check Dried Pears Dried Fruit & Nuts 30 12 2190 200.85
1430 12/6/18 6 Company F 123 6th Street Milwaukee WI 99999 USA Michael Neipper North 43442 Shipping Company C Francisco Pérez-Olaeta 123 6th Street Milwaukee WI 99999 USA Check Dried Apples Dried Fruit & Nuts 53 68 3763 225.621
1431 12/4/18 4 Company D 123 4th Street New York NY 99999 USA Andrew Cencini East Christina Lee 123 4th Street New York NY 99999 USA Gnocchi Pasta 38 33 2812 175.028
1432 12/3/18 3 Company C 123 3rd Street Los Angelas CA 99999 USA Mariya Sergienko West Thomas Axerr 123 3rd Street Los Angelas CA 99999 USA Green Tea Beverages 2.99 12 296.01 17.043

Name Assignment # Due Date

Revenue

Table 1: IMU%
Stock Units Unit Cost Total Cost Original Unit Retail ($) Total Retail IMU%
Current
New Purchase 1
New Purchase 2
New Purchase 3
Total
Table 2: Current vs. New Stock
Units Total Cost Total Retail
Current
New Purchases
Total

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Math homework help

Do not let math assignments discourage you from trying your best. One of our math experts can help you with math homework online. Our math tutors can help you with any level of algebra, calculus, or geometry. Ask your question to get the support you need 24/7.

Order Over WhatsApp Place an Order Online

Do you have an upcoming essay or assignment due?

All of our assignments are originally produced, unique, and free of plagiarism.

If yes Order Similar Paper