2 The following costs and relevant data, which represent normal activity levels, have been budgeted for the period ending 31 December 2021. Costs Production Departments Service Dept. Total A B C N$000 N$000 N$000 N$000 N$000 Indirect wages 15 21 8 58 102 84 Depreciation 22 Rates Power 180 Personnel 60 48 Insurance Other data Direct labour hours 7,250 9,000 15,000 31,250 Machine hours 15,500 20,000 2,500 2,000 40,000 Floor area (m2) 800 1,200 1,000 1,400 4,400 Fixed assets in NS 160,000 140,000 30,000 70,000 400,000 Employees 40 56 94 50 240 As accounts assistant, you have been asked to assist with completing the overhead budget for the period ending 31 December 2021. Required: a) Prepare an overhead analysis sheet which demonstrates the cost of the three production departments. (15 marks) b) Calculate appropriate overhead absorption rates for the three production departments. (10 marks)