Step by step solution/excel please

BluStar Company has two service departments, Administration and Accounting, and two operating departments, Domestic and International. Administration costs are allocated on the basis of employees, and Accounting costs are allocated on the basis of number of transactions. A summary of BluStar operations follows. Administration Accounting 23 Employees Transactions Department direct costs 37,000 $357,000 Domestic 40 21,000 $950,000 International 37 8 4,000 $3,510,000 $147,000 Required: a. Allocate the cost of the service departments to the operating departments using the direct method. b. Allocate the cost of the service departments to the operating departments using the step method. Start with Administration. C. Allocate the cost of the service departments to the operating departments using the reciprocal method. Complete this question by entering your answers in the tabs below. Required A Required B Required Allocate the cost of the service departments to the operating departments using the direct method. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign.) TO From Administration Accounting Domestic International Department costs Administration allocation Accounting allocation Total cost 0 $ 0 $ 0 $ Required A Required B Required C Allocate the cost of the service departments to the operating departments using the step method. Start with Administration. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign.) To Administration Accounting Domestic International From Department costs Administration allocation Accounting allocation Total cost $ 0 $ 0 $ 0 $ Required A Required B Required C Allocate the cost of the service departments to the operating departments using the reciprocal method. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Round your final answers to the nearest whole dollar amounts.) Administration Accounting Domestic International From Department costs Administration allocation Accounting allocation Total cost 0 $ 0 $ 0 $ 0