Question Three: ... (20 marks) Jordanian Phone Company assembles and sells three types of phones (one line phone -H1; two line phone -H2; and wireless phone-W1). The following data represents a quarterly comparative income statement for the year ended on December 31, 2016. Student Name Student ID EXI1 Jordanian Phone Company Quarterly Comparative Income Statement For the Year Ended December 31, 2016 First Quarter Second Quarter Third Quarter Fourth Quarter Total Sales: 100000 120000 150000 ??? 80000 40000 50000 80000 222 60000 90000 100000 75000 999 .. 80000 292 299 727 99 . ??? 999 999 999 One Line Phone-HI Two Line Phone-H2 Wireless Phone-W1 Total Sales Sales Discounts (5% of total sales) Net Sales Cost of Goods Sold Gross Profit/ Loss Other Expenses Profit / Loss Befor Taxies 299 ??? 199 152950 992 179450 299 146300 202825 2?? 222 ??? 22? 43890 53865 60847 45885 ??? 222 922 222 Taxies (17% of profit/loss before taxies) 299 999 299 929 292 49 ??? Profit / Loss Profit/Loss to Net Sales Ratio Required: 1. Create a new work sheet (Quarterly comprehensive Income statement), and enter previous data in it. 2. Insert necessary equations or functions in related cells to calculate the unknown figures (???). 3. Represent net sales and net profit after tax for each quarter of 2016 by graph (bar chart)