Management accounting please answer the question below fully

QUESTION 4 The following information relates to Zimbos Cc a manufacturing company that has two manufacturing departments and two service departments. The company manufactures tables as well as chairs. Manufacturing Manufacturing Service Service Total Dept. 1 (NS)(N)Dept. 2 N$ NS N$ Allocated Overhead General Overheads; Indirect Labour Heat & Light Repairs Maintenance Canteen Subsidy 32 400 29 200 12 400 12 85086 850 48 600 5 100 10 400 Machine Insurance 223 900 Additional information: The following additional information was extracted from the company's management accounting records: Manufacturing Manufacturing Service Service Dept. 1 Dept. 2 Dept. 1 2 500 30 000 30 000 12 Floor area sq m 4 000 1 000 500 Direct labour hours Indirect labour hours Direct labour rate per 5 000 Number of staff Machine hours Machine value 30 2 500 40 000 25 000 10 000 Service overheads are to be re-apportioned as follows Service Dept. 1 overheads Dept 80% ept. 2 50% 50% overheads Data on producing Tables and Chairs by the company is as follows Chair Job Table Job NS 240 Direct materials cost Machine hours Machine hours Direct labour hours Manufacturing Dept. Manufacturing Dept. 2 N$ 420 20 25 40 MARKS REQUIRED: Prepare a statement showing the overhead cost for each department (include the basis of apportionment, where appropriate Calculate a suitable overhead absorption rate for each department using a basis that you deem suitable Show the total cost of producing Tables and the total cost of producing 13 4.3 25 TOTAL MARKS FOR QUESTION 4