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.

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)

Total 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 Sales: One Line Phone-HI 100000 120000 80000 150000 Two Line Phone-H2 50000 60000 40000 80000 Wireless Phone-wi 80000 90000 100000 75000 Total Sales ??? ??? ??? ??? Sales Discounts (5% of total sales) ??? ??? ??? ??? Net Sales ??? ??? ??? ??? Cost of Goods Sold 152950 179550 146300 202825 Gross Profit / Loss ??? ??? ??? Other Expenses 45885 53865 43890 60847 Profit / Loss Befor Taxies ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? Taxies (17% of profit/loss before taxies) ??? ??? ??? ??? ??? ??? ??? Profit / Loss Profit/Loss to Net Sales Ratio