Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

what is Q2 and Q3 profit here? show using excel calculation? Sple Sales de Mar te ce Genea Format Painter Clipboard Meigence Font SUM X

image text in transcribedwhat is Q2 and Q3 profit here? show using excel calculation?
Sple Sales de Mar te ce Genea Format Painter Clipboard Meigence Font SUM X TEXTE today 2974 A B 1 Region G Country Item Type Sales ChalOrder PridOrder Dat Order ID Ship Date Units Sold Unit Price Unit Cost Total Revi Total Cost Total Profit 2 Australia Tuvalu Baby Food offline H 3 Central Al Grenada Cereal S/28/2010 6.69E+08 6/27/2010 9925 255.28 Online 159.42 253.16541502241 951419.5 8/22/2012 9.61408 9/15/2012 4 Europe Russia 28041 205.7 117.11 576782.8 38375A 245064 Office SupOffline 5/2/2014 3.41E108 5/8/2014 5 Sub-Sahar Sao Tome Fruits 1779 651.21 524,96 1158503 9322038 224 Online 6/20/2014 5.14E08 7/5/2014 6 Sub-Sahar Rwanda Office Sup Offline 8102 9.33 6.9275591.66 56065.84 1925.82 2/1/2013 115408 2/6/2013 5062 651.21 530 53296425265738 6390775 7 Australia - Solomon Isaby [ NC Online C 2/4/2015 5.48E108 2/21/2015 255.28 759202.7 474115.1 285087.6 8 Sub-Sahar Angola Householi Offline M 4/23/2011 1.35E+08 4/27/2011 4187 668.27 02.54 2798046 2104135 0939115 9 Sub-Sahar Burkina F Vegetable Online H 7/17/2012 8.72E108 7/27/2012 3082 154.06 90.93 1245113 734896.2 510216.7 10 Sub-Sahar Republic Personal Coffline M 7/14/2015 7.7E408 8/25/2015 6070 81.73 56.67 4961011 3439869 1521142 11 Sub-Sahar Senegal Cereal Online H 4/18/2014 6.17E408 5/30/2014 6593 205.7 112.11 1356190 772106,2 5840739 12 Asia Kyrgyzstar Vegetable Online H 6/24/2011 8.15E+08 7/12/2011 124 154.06 90.93 19103.44 11275.32 7828.12 13 Sub-Sahar Cape Verd Clothes Offline H 8/2/2014 9.4E+08 8/19/2014 4168 109.28 35.84 455479 1493811 3060979 14 Asia Banglades Clothes Online L 1/13/2017 1.87E+08 3/1/2017 8263 109.28 35.84 902980.5 296145,9 6068347 15 Central At Honduras Househol. Offline H 2/8/2017 5.23E+08 2/13/2017 8974 668.27 502.5159370554509794 1487261 16. Asia Mongolia Personal Coffline C 2/19/2014 8.32E+08 2/23/2014 4901 81.73 56,67 400558.7 277739.7 122819.1 17 Europe Bulgaria Clothes Online M 4/23/2012 9.72E+08 6/3/2012 1673 109.28 35.84 1828254 59900.32 122865.1 18 Asia Sri Lanka Cosmetics Offline M 11/19/201 4.19E-08 12/18/201 6952 437.2 253.33 3039414 18306701208744 C 4/1/2015 5430 5.2E408 4/18/2015 19 Sub-Sahar Cameroor Beverage: Offline 47.45 31.79 257653.5 172619.7 85033,8 Turkmeni Househol Offline L 12/30/201 4.42E+08 1/20/2011 3830 20 Asia 568.27 S02.54 2559474 1924728 634745.9 Online 5908 7/31/2012 3.22E+08 9/11/2012 L 21 Australia East Timor Meat 421.89 364.69 24925262154589 337937.6 7450 255.28 714157 159.42 1901836 1187679 S/14/2014 8.19E+08 6/28/2014 22 Europe Norway Baby Fooc Online L 1273 159.42 3249714 202941.7 1220298 23 Europe 7/31/2015 8.61E+08 9/3/2015 Portugal Baby Fooc Online H 2225 152.58 6/30/2016 7.95E+08 7/26/2016 216804 1226865 97.44 339490.5 Online 24 Central At Honduras Snacks 6.92 20404.71 15134.04 5270.67 H 2187 9.33 Online 9/8/2014 142E+08 10/4/2014 25 Australia New Zeal Fruits 100 Sales Records Edit 255.28 A Sple Sales de Mar te ce Genea Format Painter Clipboard Meigence Font SUM X TEXTE today 2974 A B 1 Region G Country Item Type Sales ChalOrder PridOrder Dat Order ID Ship Date Units Sold Unit Price Unit Cost Total Revi Total Cost Total Profit 2 Australia Tuvalu Baby Food offline H 3 Central Al Grenada Cereal S/28/2010 6.69E+08 6/27/2010 9925 255.28 Online 159.42 253.16541502241 951419.5 8/22/2012 9.61408 9/15/2012 4 Europe Russia 28041 205.7 117.11 576782.8 38375A 245064 Office SupOffline 5/2/2014 3.41E108 5/8/2014 5 Sub-Sahar Sao Tome Fruits 1779 651.21 524,96 1158503 9322038 224 Online 6/20/2014 5.14E08 7/5/2014 6 Sub-Sahar Rwanda Office Sup Offline 8102 9.33 6.9275591.66 56065.84 1925.82 2/1/2013 115408 2/6/2013 5062 651.21 530 53296425265738 6390775 7 Australia - Solomon Isaby [ NC Online C 2/4/2015 5.48E108 2/21/2015 255.28 759202.7 474115.1 285087.6 8 Sub-Sahar Angola Householi Offline M 4/23/2011 1.35E+08 4/27/2011 4187 668.27 02.54 2798046 2104135 0939115 9 Sub-Sahar Burkina F Vegetable Online H 7/17/2012 8.72E108 7/27/2012 3082 154.06 90.93 1245113 734896.2 510216.7 10 Sub-Sahar Republic Personal Coffline M 7/14/2015 7.7E408 8/25/2015 6070 81.73 56.67 4961011 3439869 1521142 11 Sub-Sahar Senegal Cereal Online H 4/18/2014 6.17E408 5/30/2014 6593 205.7 112.11 1356190 772106,2 5840739 12 Asia Kyrgyzstar Vegetable Online H 6/24/2011 8.15E+08 7/12/2011 124 154.06 90.93 19103.44 11275.32 7828.12 13 Sub-Sahar Cape Verd Clothes Offline H 8/2/2014 9.4E+08 8/19/2014 4168 109.28 35.84 455479 1493811 3060979 14 Asia Banglades Clothes Online L 1/13/2017 1.87E+08 3/1/2017 8263 109.28 35.84 902980.5 296145,9 6068347 15 Central At Honduras Househol. Offline H 2/8/2017 5.23E+08 2/13/2017 8974 668.27 502.5159370554509794 1487261 16. Asia Mongolia Personal Coffline C 2/19/2014 8.32E+08 2/23/2014 4901 81.73 56,67 400558.7 277739.7 122819.1 17 Europe Bulgaria Clothes Online M 4/23/2012 9.72E+08 6/3/2012 1673 109.28 35.84 1828254 59900.32 122865.1 18 Asia Sri Lanka Cosmetics Offline M 11/19/201 4.19E-08 12/18/201 6952 437.2 253.33 3039414 18306701208744 C 4/1/2015 5430 5.2E408 4/18/2015 19 Sub-Sahar Cameroor Beverage: Offline 47.45 31.79 257653.5 172619.7 85033,8 Turkmeni Househol Offline L 12/30/201 4.42E+08 1/20/2011 3830 20 Asia 568.27 S02.54 2559474 1924728 634745.9 Online 5908 7/31/2012 3.22E+08 9/11/2012 L 21 Australia East Timor Meat 421.89 364.69 24925262154589 337937.6 7450 255.28 714157 159.42 1901836 1187679 S/14/2014 8.19E+08 6/28/2014 22 Europe Norway Baby Fooc Online L 1273 159.42 3249714 202941.7 1220298 23 Europe 7/31/2015 8.61E+08 9/3/2015 Portugal Baby Fooc Online H 2225 152.58 6/30/2016 7.95E+08 7/26/2016 216804 1226865 97.44 339490.5 Online 24 Central At Honduras Snacks 6.92 20404.71 15134.04 5270.67 H 2187 9.33 Online 9/8/2014 142E+08 10/4/2014 25 Australia New Zeal Fruits 100 Sales Records Edit 255.28 A

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

Contemporary Human Resource Management Text And Cases

Authors: Tom Redman, Adrian Wilkinson

4th Edition

9780273757825

Students also viewed these Accounting questions