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