Question three: 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. Total ??? ??? 2?? Student Name Student ID EXHI Jordanian Phone Company Quarterly Comparative Income Statement For the Year Ended December 31, 2016 First Quarter Second Quarter Third Quarter Fourth Quarter Sales: One Line Phone-H1 100000 120000 80000 150000 Two Line Phone-H2 50000 60000 40000 80000 Wireless Phone-W1 80000 90000 100000 75000 Total Sales ??? ??? ??? 999 Sales Discounts (5% of total sales) ??? 999 ??? 999 HHH Net Sales ??? ??? ??? ??? Cost of Goods Sold 152950 179550 146300 202825 Gross Profit/Loss 999 222 999 999 Other Expenses 45885 53865 43890 60847 Profit/Loss Befor Taxies 999 999 999 292 Taxies (17% of profit/loss before taxies) ??? ??? ??? ??? Profit / Loss ??? 999 ??? ??? Profit/Loss to Net Sales Ratio ??? 999 292 299 999 12 999 -- 999 9 999 --- 999 ??? 299 999 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)