answers for cost management accounting please

Question Three (B) Matt Limited has two production departments, machine department and assembly department. There are two service. departments, stores and maintenance. The budgeted overheads of each department along with overheads that have yet to be apportioned are listed below, along with details which can be used for appointment. Indirect Caecur !nezrect Materia' Total K'ooo 125 ooc 310 oco Machine hept. K'ooo 400 coo 160 occ ccc 200 oic 400 ooo Sto res Assembly Dept. Inserance and Oegreciatiorm On buildings C'eaning Machinery Depreciation OOO 25 CCC Anc Inserance Supervision cf Productson P o veer Heat and light 1 ooo 70 ooo 250 ooo ooo 3 400 ooo K'OOO 650 ooo 120 ooo 3 ooo 20 sco/e 100 ooo K'OOO 40 ooo ooo dOO Additional information Area occupied {m r j % cf power usage Supervisor hours Value Of machinery K'COO O/c use Of Stores Depatrment % use of Maintenance Direct Hrzurs r..'.achine Required: Maintenance K'OOO 35 ooo 20 ooo 20 (i) Prepare an overhead analysis sheet (ii) Compute overhead absorption rate for the two producing departments