Please show clearly your calculations and answer

Please use EXCEL (if possible) for your answers

QUESTION 15 The following information relates to the Trogle manufacturing company for the year ended 30 June 20*9. Inventories at 1 July 2018 Raw materials 17,480 8,977 Work in progress Finished goods 12,548 Inventories at 30 June 209 Raw materials 18,597 10,431 Work in progress Finished goods 13,547 Purchases of raw materials. 234,772 Purchases of office equipment 17,400 Wages-direct labour 419,828 indirect labour 21,720 Rent-factory 9,500 offices 12,500 Insurances-factory 8,490 offices 3,510 Factory power 17,460 Depreciation-factory machinery 45,000 office equipment 11,200 Additional information at 30 June 20*9 Factory insurance paid in advance amounted to 360. An outstanding amount for factory power remained unpaid: 940. Required Select the appropriate information and prepare a manufacturing account for the year ended 30 June 20.9