Please show working out on excel + formula

n1 Question 5 ed out of Illawarra Consultant (IC) has two support departments: Information Technology (IT) and Administration (Admin). In addition, IC also has two operation departments that deal with two distinct clients, namely, Individual and Corporate department. For the next quarter, the budget of all departments is available below: Support Department Operation Department IT Admin Individual Corporate Total n Budgeted costs $ 11,500,000 2,500,000 7,500,000 8,000,000 19,500,000 Support work supplied by IT 25% 40% 35% 100% Support work supplied by Admin 30% 30% 40% 100% Required (show your calculation): (a) Allocate the support departments' costs to operation departments using the (5 marks) direct method. (b) Allocate the support departments' costs to operation departments using the (5 marks) step-down method. Use the highest rank of services provided to another support department to be allocated first. (10 marks) (c) Allocate the support departments' costs to operation departments using the reciprocal method