please answe all parts of question 4 Question 4: Use Data4 Sheet This table repo
ID: 2521662 • Letter: P
Question
please answe all parts of question 4
Question 4: Use Data4 Sheet
This table reports Revenue and Customer of 3 divisions (A, B, C) of a corporation over time
4a. Create a table reporting the average annual revenue for each division.
( Note: So each division, you have only 1 number for average)
Report the SUM of the 3 average numbers for these 3 divisions (do NOT include or use the Grand Total) in that table?
4b. Create a table reporting total revenue for each year for the whole corporation.
So your table should have 16 rows (or columns) associated with 16 years
(Note: Total sales of the corporation equals to the sum of 3 divisions’ sales)
Sort your table on year (Smallest to Largest)
From that table, report the SUM of total sales of the 3 years: 2000, 2001 and 2002.
4c. Create a reporting the total sales for each division in each period (you have a column called period in the original table). See the table below.
Sort Division from A to Z and sort period from Largest to Smallest.
Report the SUM of the Top left and Bottom Right number (highlighted in the table below).
(do not include Grand total in your calculation)
Year Period Division Revenue Number of Customer 2000 1 A 706 333 2000 1 B 151 195 2000 1 C 460 222 2001 1 A 879 252 2001 1 B 619 256 2001 1 C 361 376 2002 1 A 260 519 2002 1 B 302 788 2002 1 C 250 62 2003 1 A 588 67 2003 1 B 862 752 2003 1 C 966 250 2004 2 A 724 638 2004 2 B 933 650 2004 2 C 108 785 2005 2 A 749 640 2005 2 B 148 474 2005 2 C 280 51 2006 2 A 429 68 2006 2 B 719 26 2006 2 C 681 594 2007 3 A 264 295 2007 3 B 442 137 2007 3 C 853 49 2008 3 A 479 638 2008 3 B 374 732 2008 3 C 514 92 2009 3 A 599 668 2009 3 B 35 454 2009 3 C 554 350 2010 4 A 214 122 2010 4 B 455 942 2010 4 C 581 993 2011 4 A 22 624 2011 4 B 738 905 2011 4 C 158 47 2012 4 A 24 696 2012 4 B 540 53 2012 4 C 810 162 2013 5 A 176 930 2013 5 B 385 420 2013 5 C 883 962 2014 5 A 18 374 2014 5 C 200 305 2015 5 A 145 123 2015 5 B 456 432 2015 5 C 234 213
Explanation / Answer
4a Division Average Annual Revenue A 392 B 477 C 493 Sum Of the 3 Average Numbers - 1363 4b Year Total Revenue 2000 1317 2001 1859 2002 812 2003 2416 2004 1765 2005 1177 2006 1829 2007 1559 2008 1367 2009 1188 2010 1250 2011 918 2012 1374 2013 1444 2014 218 2015 835 Total Sum For 2000,2001 & 2002 3988 4c Division Period Total Sales A 1 2433 A 2 1902 A 3 1342 A 4 260 A 5 339 B 1 1934 B 2 1800 B 3 851 B 4 1733 B 5 841 C 1 2037 C 2 1069 C 3 1921 C 4 1549 C 5 1317 Total Sales 21328
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.