Please show detail calculation on how to get each value using excel and answer all the parts. Thank oyu.

The following is company information for the current year' s operations ended 30 November 2018. Invento of raw materials, 1/12/2017 Invento of raw materials 30/11/2018 Purchase of raw materials Direct Indirect De reciation ex enses - office e De reciation ex ense - facto Utili ex enses 70% are facto i ment ui ment related Rental ex ense 80% is for the facto Ex enditure on administrative staff salaries S end sales commissions Advertisin s endin Expenses for maintenance and repair of facto facilities Work in Work in Invento Invento ro ss 1/12/2017 ro ess, 30/11/2018 of r of r oods, 1/12/2017 oods, 30/11/2018 25,500 31 ooo 190,000 144,000 38,610 5,300 17,000 11 300 30,000 65,000 38,000 47 ,000 34,500 6 120 9,200 43,370 47 ,250 a) Prime cost, factory overhead cost, period cost b) Statement of Cost of Manufactured Goods for the year ended 30 November 2018. c) Company has produced 17,000 units of goods in the current year. Company accounting records show that there were I , 220 units of finished goods at the beginning of the current period. At the end of the year there were 2,075 units unsold. Income Statement for company for the year ended 30 November 2018 assuming the selling price is S 45 per unit