Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is Q1 and Q4 profit year 2015 Q is Quarter 6593 Region Country Item Type Sales ChantOrder Prior Order Date Order ID Ship Date

What is Q1 and Q4 profit image text in transcribed
image text in transcribed
image text in transcribed
year 2015
Q is Quarter
6593 Region Country Item Type Sales ChantOrder Prior Order Date Order ID Ship Date Units Sold Unit Price Unit Cost Total Rever. Total Cost Total Profit Australia a Tuvalu Baby Food Offline H 5/28/2010 6.69E+08 6/27/2010 9925 255.28 159.42 2533654 1582244 951410.5 Central Ame Grenada Cereal Online C 8/22/2012 9.64E+08 9/15/2012 2804 205.7 117.11 576782.8 328376.4 248406.4 Europe Russia Office Supg Offline L 5/2/2014 3.41E+08 5/8/2014 1779 651.21 524.96 1158503 933903.8 224598.8 Sub-SaharaSao Tome & Fruits Online 6/20/2014 5.14E+08 7/5/2014 8102 9.33 6.92 75591.66 56065.84 19525.82 Sub-Sahara Rwanda Office SuppOffline L 2/1/2013 1.15E+08 2/6/2013 5062 651.21 524.96 3296425 2657348 639077.5 Australia Solomon Is Baby Food Online 2/4/2015 5.48E+08 2/21/2015 2974 255.28 159.42 759202.7 474115.1 285087.6 Sub-Sahara Angola Household Offline M M 4/23/2011 1.35E+08 4/27/2011 4187 668.27 502.54 2798046 2104135 693911.5 Sub-Sahara Burkina Fas Vegetables Online H 7/17/2012 8.72E+08 7/27/2012 8082 154.06 90.93 1245113 734896.3 510216.7 Sub-Sahara Republic of Personal C Offline 7/14/2015 7.7E+08 8/25/2015 6070 81.73 56.67 496101.1 343986.9 152114.2 Sub-Sahara Senegal Cereal Online H 4/18/2014 6.17E+08 5/30/2014 205.7 117.11 1356180 772106.2 584073.9 Asia Kyrgyzstan Vegetables Online H 6/24/2011 8.15E-08 7/12/2011 124 154.06 90.93 19103.44 11275.32 7828.12 Sub-SaharaCape Verde Clothes Offline H 8/2/2014 9.4E+08 8/19/2014 4168 109.28 35.84 455479 149381.1 306097.9 Asia BangladeshClothes Online L 1/13/2017 1.87E+08 3/1/2017 8263 109.28 35.84 902980.6 296145.9 606834.7 Central Am Honduras Household Offline H 2/8/2017 5.23E+08 2/13/2017 8974 668.27 502.54 5997055 4509794 1487261 Asia Mongolia Personal Coffline 2/19/2014 8.32E+08 2/23/2014 4901 81.73 56.671 400558.7 277739.7 122819.1 Europe Bulgaria Clothes Online M M 4/23/2012 9.72E+08 6/3/2012 1673 109.28 35.84 182825.4 59960.32 122865.1 Asia Sri Lanka Cosmetics Offline M M 11/19/2014,19E+08 12/18/2016 6952 437.2 263.33 3039414 18306701208744 Sub-Sahara Cameroon Beverages Offline C 4/1/2015 5.2E+08 4/18/2015 5430 47.45 31.79 257653.5 172619.7 85033,8 Asia Turkmenist Household Offline L 12/30/2016 4.42E08 1/20/2011 3830 668.27 502.54 2559474 1924728 634745.9 Australia ar East Timor Meat Online L 7/31/2012 3.22E+08 9/11/2012 5908 421.89 364.69 2492526 2154589 337937.6 Europe Norway Baby Food Online L 5/14/2014 8.19E-08 6/28/2014 7450 255.28 159.42 1901836 1187679 714157 Europe Portugal Baby Food Online 7/31/2015 8.61E+08 9/3/2015 1273 255.28 159.42 324971.4 202941.7 122029.8 Central Am Honduras Snacks Online L 6/30/2016 7.95E+08 7/26/2016 2225 152.58 97.44 339490.5 216804 122686.5 Australia a New Zealar Fruits Online 9/8/2014 1.42E+08 10/4/2014 2187 9.33 6.92 20404.71 15134.04 5270.67 Europe Moldova Personal COnline L 5/7/2016 7.4E+08 5/10/2016 5070 81.73 56.67 414371.1 287316.9 127054.2 Europe France Cosmetics Online IH 5/22/2017 8.99E+08 6/5/2017 1815 437.2 263.33 793518 477944 315574.1 Australia a Kiribati Fruits Online M M 10/13/2014 3.47E+08 11/10/2014 5398 9.33 6.92 50363 34 37354,16 13009.18 Sub-Sahara Mall Fruits Online L 5/7/2010 6.86E+08 5/10/2010 5822 9.33 6.92 54319.26 40288.24 14031.02 Europe Norway Beverages Offline 7/18/2014 4.36E+08 7/30/2014 5124 47.45 31.79 243133.8 162892 80241.84 Sub-SaharaThe Gambil Household Offline L 5/26/2012 8.86E+08 6/9/2012 2370 668.27 502.54 1583800 1191020 392780.1 Europe Switzerland Cosmetics Offline M M 9/17/2012 2.5E+08 10/20/2012 8661 437.2 263.33 3786589 2280701 1505888 Sub-SaharaSouth Suda Personal CaOffline C 12/29/201 4.07E+08 1/28/2014 2125 81.73 56.67 173676,3 120423.8 53252.5 Australia ar Australia Office Supp Online c 10/27/201 1.59E+08 11/25/2015 2924 651.21 524.96 1904138 1534983 369155 Asia Myanmar Household Offline H 1/16/2015 1.78E+08 3/1/2015 8250 668.27 502.54 5513228 4145955 1367273 Sub-Sahara Djibouti Snacks Online Central Am. Costa Rica Personal C Offline Middle Eas Syria Fruits Online Sub-Sahara The Gambie Meat Online Asia Brunei Office Supp Online Europe Bulgaria Office Supp Online Sub-Sahara Niger Personal C.Online Middle East Azerbaijan Cosmetics Online Sub-Sahara The Gambl Cereal Offline Europe Slovakia Vegetables Online Asia Myanmar Clothes Online Sub-Sahara Comoros Cereal Offline Europe Iceland Cosmetics Online Europe SwitzerlandPersonal C&Online Europe Macedonia Clothes Offline Sub-Sahara Mauritania office Supg Offline Europe Albania Clothes Online Sub-Sahara Lesotho Fruits Online Middle EasSaudi Arab Cereal Online Sub-Sahara Sierra Leon Office Sups Offline Sub-Sahara Sao Tome a Fruits Offline Sub-Sahara Cote d'Ivoi Clothes Online Australia ad Full Clothes Offline Europe Austria Cosmetics Offline Europe United King Household Online Sub-Sahara Djibouti Cosmetics Offline Australia af Australia Cereal Offline Europe San Marino Baby Food Online Sub-Sahara Cameroon Office Supp Online Middle Eas Libya Clothes Offline Central Ami Haiti Cosmetics Offline Sub-Sahara Rwanda Cosmetics Offline Sub-Sahara Gabon Personal CsOffline Central Am Belize Clothes Offline Europe Lithuania Office Sup Offline M M L L M L M M H M TH H H C M M L M M M H H L H H L M M H H L M M H 2/25/2017 7.56E+08 2/25/2017 5/8/2017 4.57E+08 5/21/2017 11/22/2011 1.62E+08 12/3/2011 1/14/2017 8.25E+08 1/23/2017 4/1/2012 3.2E+08 5/8/2012 2/16/2012 1.9E+08 2/28/2012 3/11/2017 6.99E+08 3/28/2017 2/6/2010 3.82E+082/25/2010 6/7/2012 9.94E+08 6/8/2012 10/6/2012 7.59E+08 11/10/2013 11/14/2015 2.23E+08 11/18/2015 |3/29/2016 9.02E+08 4/29/2016 12/31/2014 3.31E+08 12/31/2010 12/23/2010 6.18E+08 1/31/2011 10/14/2014 7.87E+08 11/14/2014 1/11/2012 8.38E+08 1/13/2012 2/2/2010 3.85E+08 3/18/2010 8/18/2013 9.18E+08 9/18/2013 3/25/2013 8.45E+08 3/28/2013 11/26/2011 4,42E+08 1/7/2012 9/17/2013 5.09E+08 10/24/2013 6/8/2012 1.15E+08 6/27/2012 6/30/2010 6.48E08 8/1/2010 2/23/2015 8.68E+08 3/2/2015 1/5/2012 9.55E+08 2/14/2012 4/7/2014 2.59E+08 4/19/2014 6/9/2013 4,51E+08 7/2/2013 6/26/2013 5.7E+08 7/1/2013 11/7/2011 1.78E+08 11/15/2011 10/30/2016 7.06E+08 11/17/2016 10/13/2011 5.06E+08 11/16/2017 10/11/2011 6.99E+08 11/25/2013 7/8/2012 2.29E+0817/9/2012 7/25/2016 8.07E+08 9/7/2016 10/24/2016 1.66E+08 11/17/2016 7327 6409 3784 4767 6708 3987 3015 7234 2117 171 5930 962 8867 273 7842 1266 2269 9606 4063 3457 7637 3482 9905 2847 282 7215 682 4750 5518 6116 1705 4477 8656 5498 8287 152.58 81.73 9.33 421.89 651.21 651.21 81.73 437.2 205.7 154.06 109.28 205.7 4372 81.73 109.28 651.21 109.28 9.33 205.7 651.21 9.33 109.28 109.28 4372 668.27 4372 205.7 255.28 651.21 109.28 437.2 437.2 81.73 109.28 651.21 97.44 1117954713942.9 404010.8 56.67 523807.6 363198 160609.5 6.92 35304.721 26185.28 9119.44 364.69 2011150 17384771 272672.4 524.96 43683171 3521432 846885 524.96 2596374 2093016 503358.8 56.67 2464161 170860.1 75555.9 263.33 3162705 1904929 1257776 117.11 435466.9 247921.9 187545 90.93 26344.26 15549.03 10795.23 35.84 648030.4 212531.2 435499.2 117.11. 197883.4 112659.8 85223.58 263.33 3876652 2334947 1541705 56.67 22312.29 15470.91 6841.38 35.84 856973.8 281057.3 575916.5 524.96 824431.9 664599.41 159832.5 35.84 247956.3 81320.96 166635.4 6.92 89623.98 66473.52 23150,46 117.11 835759.1 475817.9 3599412 524.96 2251233 1814787 436446.31 6.92 71253.21 52848.04 18405.17 35.84 380513 124794.9 255718.1 35,84 1082418 354995.2 727423.2 263.33 1244708 749700.5 495007.9 502.54 188452.1 141716.3 46735.86 263.33 3154398 1899926 1254472 117.11 140287.4 79869.02 60418.38 159.42 1212580 757245 455335 524.96 3593377 2896729 696647.5 35,84 668356.51 219197.4 4491591 263.33 745426 448977.7 296448.4 263.33 1957344 1178928 778416 56,67 707454.91 490535.5 216919.4 35.84 600821.4197048.3 403773.1 524.96 5396577 4350344 1046234 Sub-Sahara Madagasca Clothes Offline Asia TurkmenistOffice Supg Online Middle East Libya Fruits Online Sub-Sahara Democratic Beverages Online Sub-Sahara Djibouti Cereal Online Middle East Pakistan Cosmetics Offline North Ame Mexico Household Offline Australia arFederated Beverages Online Asia Laos Vegetables Offline Europe Monaco Baby Food Offline Australia at Samoa Cosmetics Online Europe Spain Household Offline Middle EastLebanon Clothes Online Middle Easiran Cosmetics Online Sub-Sahara Zambia Snacks Online Sub-Sahara Kenya Vegetables Online North Ame Mexico Personal ClOffline Sub-Sahara Sao Tome & Beverages Offline Sub-Sahara The Gambi, Baby Food Offline Middle East Kuwait Fruits Online Europe Slovenia Beverages Offline Sub-Sahara Sierra Leon Office Supp Offline Australia at Australia Beverages Offline Middle East Azerbaijan Office Supe Online Europe Romania Cosmetics Online Central Am Nicaragua Beverages Offline Sub-Sahara Mali Clothes Online Asia Malaysia Fruits Offline Sub-Sahara Sierra Leon Vegetables Offline North Amel Mexico Personal CaOffline Sub-Sahara Mozambiqe Household Offline L M L C H L ic H H L L H L L L C M M M H H M H C M L M M L 4/25/2015 6.1E+08 5/28/2015 4/23/2013 4.62E+08 5/20/2013 8/14/2015 8.16E+08 9/30/2015 5/26/2011 5.86E+08 7/15/2011 5/20/2017 5.56E+08 6/17/2017 7/5/2013 2.31E+08 8/16/2013 11/6/2014 9.86E+08 12/12/2014 10/28/2014 2.17E+08 11/15/2014 9/15/2011 7.89E+08 10/23/2011 5/29/2012 6.88E+08 6/2/2012 7/20/2013 6.71E+08 8/7/2013 10/21/2011 2.13E+08 11/30/2012 9/18/2012 6.63E+08 10/8/2012 11/15/2016 2.87E+08 12/8/2016 1/4/2011 1.23E+08 1/5/2011 3/18/2012 8.28E+08 4/7/2012 2/17/2012 4.31E+08 3/20/2012 1/16/2011 1.8E408 1/21/2011 2/3/2014 4.95E+08 3/20/2014 4/30/2012 5.13E+08 5/18/2012 10/23/201 3.46E+08 11/25/2014 12/6/2016 6.21E+08 12/14/2016 7/7/2014 2.4E+08 7/11/2014 6/13/2012 4.23E+08 7/24/2012 11/26/2010 6.61E+08 12/25/2016 2/8/2011 9.63E+08 3/21/2011 7/26/2011 5.13E+08 9/3/2011 11/11/2011 8.11E+08 12/28/2011 6/1/2016 7.29E+08 6/29/2016 7/30/2015 5.59E+08 8/8/2015 2/10/2012 6.65E+08 2/15/2012 7342 5010 673 5741 8656 9892 6954 9379 3732 8614 9654 4513 7884 6489 4085 6457 6422 8829 5559 522 4660 948 9389 2021 7910 8156 888 6267 1485 5767 5367 109.28 651.21 9.33 47.45 205.7 4372 668.27 47.45 154.06 255.28 437.2 668.27 109.28 437.2 152.58 154,06 81.73 47.45 255.28 9.33 47.45 651.21 47.45 651.21 4372 47.45 109.28 9.33 154.06 81.73 668.27 35.84 802333.8 263137.3 539196.5 524.96 3262562 2630050 632512.5 6.92 6279.09 4657.16 1621.93 31.79 272410.51 182506.4 89904.06 117.11 1780539 1013704 766835 263.33 4324782 2604860 1719922 502.54 4647150 3494663 1152486 31.79 445033.6 298158.4 146875.1 90.93 574951.9 339350.8 235601.2 159.42 2198982 1373244 825738 263.33 4220729 2542188 1678541 502.54 3015903 2267963 747939.5 35.84 861563.51 282562,6 579001 263.33 2836991 1708748 1128242 97.44 623289.3 398042,4 225246.9 90.93 994765.4 587135 407630.4 56.67 524870.1 363934.7 160935.3 31.79 418936.1 280673.9 138262.1 159.42 1419102 886215.8 532885.7 6.92 4870.26 3612.24 1258.02 31.79 221117 148141.4 72975,6 524.96 617347.1 497662.1 119685 31.79 445508.1 298476.31 147031.7 524.96 1316095 1060944 255151.3 263.33 3458252 2082940 1375312 31.79 387002.2) 259279.2 127723 35.84 97040.64 31825.92 65214.72 6.92 58471.11 43367.64 15103.47 90.93 228779.1 135031.1 93748.05 56.67 471336.9 326815.9 144521 502.54 3586605 2697132 889472.9

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics Of Finance

Authors: Petr Zima

2nd Edition

0070082030, 9780070082038

More Books

Students also viewed these Accounting questions

Question

2. What role should job descriptions play in training at Apex?

Answered: 1 week ago