The following cost data for the year ending 30 June 2020 relate to Excite Technologies Ltd. Medical Equipment Division $ $480,000 Aero Engines Division $ ? Sales Inventories at 1 July 2019 Raw materials Work in process Finished goods 15,000 ? ? ? 140,000 200,000 Inventories at 30 June 2020 Raw materials Work in process Finished goods 30,000 5,000 25,000 320,000 ? ? Direct material used Purchases of raw materials Direct labour Actual manufacturing overhead Selling and administrative expenses Total manufacturing costs Cost of goods manufactured Cost of goods available for sale Cost of goods sold Gross profit Net profit ? ? 125,000 189,500 ? 367,500 377,500 397,500 ? ? 60,500 380,000 460,000 ? 1,341,000 ? 2,630,000 2,650,000 ? 2,721,000 579,000 159,000 The company uses normal costing and manufacturing overhead is applied at the rate of 150% of direct labour cost. Over or under-applied manufacturing overhead is closed on an annual basis to the cost of goods sold and this has been included in the above data. Required: (a) Interpret the relationship between the cost figures above to determine the missing amounts in each of the divisions shown above. (24 marks) (b) Calculate the amounts to be charged to work in process, finished goods inventory and cost of goods sold for the Aero Engines Division at the end of 30 June 2020 if the proration method is used. Provide your final answer to the nearest dollar. (4 marks) (c) Prepare the necessary journal entries for (b) to describe the flow of costs. (2 marks) Present all workings in a clear and succinct manner