Question Two: $q,(15$ marks$)$

Jordanian Phone Company assembles and sells three types of phones $($one line phone $-$ H$1$; two line phone $-$H $2$ ; and wireless phone$-$W$1).$ The following data represents a quarterly comparative income statement for the year ended on December $31,2016.$

$\backslash$table$[[$Student Name$],[$Student ID$],[$EXII$],[$Jordanian Phone Company$],[$Quarterly Comparative Income Statement$],[$For the Year Ended December $31,2016],[,$First Quarter,Second Quarter,Third Quarter,Fourth Quarter,Total$],[$Sales:$],[$One Line Phone$-$H$1,100000,120000,80000,150000,???],[$Two Line Phone$-$H$2,50000,60000,40000,80000,???],[$Wireless Phone$-$W$1,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,???,???,???,???,???$]]$

Required:

Create a new work sheet $($Quarterly comprehensive Income statement$),$ and enter previous data in it$.$

Insert necessary equations or functions in related cells to calculate the unknown figures $(???).$

Represent net sales and net profit after tax for each quarter of $2016$ by graph $($bar chart$)$