PLEASE USE EXCEL AND SHOW YOUR WORK :)

Note the following information concerning the direct costs of each of the following four departments: Supplied by: Based on the above information, prepare the following A) Allocate costs by the direct method. B) Allocate costs by the step-down method (Human Resources first) C) Allocate costs by the step-down method (Plant Maintenance first)