help me with this ASAP please SIR/MAAM. love and respect from Zainab 07308341304

Oakwood Ltd. is a furniture-making business that manufactures quality furniture to customers' orders. It has three production departments and two service departments. Budgeted overhead costs for the coming year are as follows: Total () Rent and rates 12,100 Machine insurance 25,500 Telephone charges 8,250 Depreciation - machinery 34,000 Production Supervisor's salaries 2,800 Heating and lighting 3,850 Canteen Cost 1,400 Total 87,900 The three production departments A, B, & C, and the two service departments X and Y, are housed in new premises, the details of which, together with other information is given below: The three production departments A, B, & C, and the two service departments X and Y, are housed in new premises, the details of which, together with other information is given below: Departments X Floor area occupied (sq. meters) 500 3,000 1,200 Machine value (000) 13 Value of goods produced (000) 19 Number of employees Direct labour hours budgeted 4,200 1,750 2,300 Labour rates per hour 2.50 3.25 2.75 3.00 Allocated overheads: specific to 1, 700 1,500 1,100 800 each department Service department X's costs 10% 30% 60% apportioned Service department Y's costs 25% 35% 40% apportioned 1. Prepare a statement showing the overhead cost budgeted for each department, showing the basis of apportionment used (Please use the overhead analysis sheet below). Also calculate departmental overhead absorption rates based on direct labour hours. (9 marks) OVERHEAD ANALYSIS SHEET Item of expenditure Basis of allocation/ apportionment Production centres Service centres Total A B C X Y