new answer no plagrism pls and typed up not hand written

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 Supervision Depreciation Insurance Rates and Rent Other bills Absorption basis 12000 Direct Labour Hours 15000 Machine value 5000 Machine value 30000 Floor area 2500 Floor area The following information is available for each department 5000 1000 Absorption basis Machine Value () Budgeted Direct Labour hours Floor Area Occupied (Square metres) B 2500 500 3500 1500 1500 1000 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 o 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) (Total 40 marks)