Question: 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

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 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

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

vVenus Robotics has two employee training programs Teamwork and Creative Thinking. The training programs are delivered to 2 0 employees at a time. Teamwork training is a 3 day program and costs $ 1 0...

Hi Vjvgoe, Are you able to help me with this problem please? I would need to see it 7/16/17 since it's due that same week but I will put the deadline on 7/29/17. I have attached all of the...

Anne Marie has received $500,000 in inheritance and would like to setup a charity (in perpetuity) to help the disadvantaged families by providing 3 scholarships each year for three deserving high...

Step 1: Sales Budget Instructions: Provided below is the expected selling price and expected unit sales for the four quarter of 2017. Use this information to complete the sales budget. Expected...

This is the sorted data, as asked in question 10. Step Requirement In the Data worksheet: a. Create an Excel table with the recently imported data. b. Pick a style with the styles group to format the...

csv file al Part 3: Forecasting in Australia (40 points) (This question took place in 2017) Looking for a new perspective in life, you travel to Australia for an internship in a service consulting...

Unlike Softdrink sales, you have no data for 2008, Q1 through Q4. You must create those 4 quarters of forecast. MAE MAPE Time 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Quarter 2004 Q1 2004...

Implement a DFA simulator (in C, C++ or Python) in a Linux environment: Read in a specified machine (5-tuple definition) and process input strings against this DFA; output ACCEPT or NOT ACCEPT for...

attachments_17587411b95d6d44bfe708c8f87050cd4003e827 MovieTitle The Hunger Games: Catching Fire Iron Man 3 Frozen Despicable Me 2 Man of Steel Gravity Monsters University The Hobbit: The Desolation...

The purpose of this case is less about the format, organization, and delivery and more about high- quality quantitative analysis and discussion. I need help on questions 5 and 6. ISSUES IN ACCOUNTING...

This is an exercise in predictive analytics. Estimation of the cost function and evaluation of the cost function is an important skill for MBAs. As often happens, you will get a cost function that...

Which of the following is true about the Net Present Value method? The NPV does not utilize time value of money concepts. The NPV assumes that all cash flows are reinvested at the firms discount...

During the current year, Airport Auto Rentals purchased 60 new automobiles at a cost of $14,000 per car. The cars will be sold to a wholesaler at an estimated $5,000 each as soon as they have been...

When not at work, neurons have a slightly positive charge. This is called the resting potential. True False

2.7 Find the displacement from the equilibrium position x of the mass shown in Fig. P2.7 when the input displacement y is a step function at t = 0 and of magnitude 10 cm.

The high cost of implementing changes to infrastructure always raises questions about priorities. Should investments in infrastructure be made to address high-impact, low- probability events (such as...

1. All of the following is one of the four main categories of transactions in QuickBooks except ? MULTIPLE CHOICE A. Customers B. Vendors C. Chart of accounts D. Employees 2. Which of the following...

A steel storage tank 20 meters in diameter will be used to hold a liquid petroleum product. When filled, the tank will apply a bearing pressure of 150 kPa to the ground surface. The soil underlying...

Emmanuel V There is a number cube with faces numbered 1 to 6. There is also a coin with one side marked as heads and the other tails. As a trial of an experiment, the number cube was rolled and the...

1.state the and explain the Benefits of preparing cashflow statements. 2. Define the following operating activities, investing activities, and financing activities as they relate to cashflow...

4. I try to make them feel what I really mean (1 is related to the visionary, 2 to the logical, 3 to action and 4 to the emotional).

4. What is the goal of the others in the network?

2. What we can learn from the past