Can u help me solve this question, please use EXCEL & Step down method.Required : a) As the operating department manager, you have been asked to allocate the support-department costs using the step-down method. You are required to determine the overhead rates per direct manufacturing labor-hours for Machining and Assembly. (select the most appropriate allocation base for each support department & round the values to two decimal). Show all workings.b) explain 2 feature of direct method

QUESTION 3 STB Sdu Bhd is a manufacturing company that produces machine parts for washing machines. STB has three support departments and two operating departments. Those support departments include General Administration, Cafeteria, and Storeroom. While the operating departments consist of Machining and Assembly. Moreover, the company has prepared the department overhead budgets for the budgeted volume levels before allocations as follows: Support Departments: General plant administration RM65,310 Cafeteria; 1,697.5 Storeroom 17,482.5 RM84,490 Operating Departments: Machining RM64,050 Assembly 80,500 144,550 Total for support and operating departments RM229,040 The top management of STB has decided that the most appropriate inventory costs are achieved by using individual department overhead rates. These rates are developed after the support department costs are allocated to operating departments. Bases for allocation are to be selected from the following: Direct Manufacturing Number of Indirect Department Labor-Hours Employees Manuf. Number of Labor-Hours Requisitions Administration 0 0 0 0 Cafeteria O 0 3,000 0 Storeroom 0 15 2,000 0 Machining 8,000 55 13,000 6,000 Assembly 32,000 140 26,000 4,000 Total 40,000 210 44,000 10,000