new answer not plagarised pls

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: Absorption basis B C S 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 O ative Assessment (CW) TTA 2019-20.00CX (340 KB) 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)