please solve a and b

B. Alphabet Co has three production departments A, B, and C and one service department S. Alphabet Co are preparing their annual budget for the final quarter of 2020. Planned overhead costs for the quarter are as follows: Overheads Absorption basis Supervision 12000 Direct Labour Hours Depreciation 15000 Machine value Insurance 5000 Machine value Rates and Rent 30000 Floor area Other bills 2500 Floor area The following information is available for each department: Absorption basis cs Machine Value (E) 5000 2500 3500 1500 Budgeted Direct Labour hours 1000 500 1500 1000 Floor Area Occupied (Square metres) 1500 400 500 100 Of the total overhead costs allocated to service department S, 20% is charged to A; 40% to B; and the remainder is charged to C. Required: a) Prepare an overhead analysis sheet showing the total overhead cost budgeted for all four departments. You must show all your workings clearly. (18 marks) b) Allocate the services department S costs to all production departments. (2 marks)