I need help with 3 attached excel spreadsheets. The questions surroundIndirect Cost Allocation: Direct Method,InterdepartmentalServices: Step Method, andReassigning Costs to Cost Objectives.

Stage 2 ABC for Manufacturing: Reassigning Costs to Cost Objectives National Technology,LTD. has developed the following activity cost information for its manufacturing activities: Activity Activity cost Machine setu $65.00 per batch Movement 15 per batch move 0.1 per pound Drilling 4 per hole Welding 4 per inch Shaping 25 per hour Assembly 17 per hour Inspection 2 per unit Filling an order for a batch of 50 fireplace inserts (each insert weighing 150 pounds) required the following: Three batch moves Two sets of inspections Drilling five holes in each unit Completing 80 inches of welds on each unit Thirty minutes of shaping for each unit One hour of assembly per unit Determine the activity cost of converting the raw materials into 50 fireplace inserts. $ Indirect Cost Allocation: Direct Method Sprint Manufacturing Company has two production departments, Melting and Molding. Direct general plant management and plant security costs benefit both prod Melting Department direct overhead Molding Department direct overhead General plant management Plant security $175,000 300,000 90,000 35,000 Melting Number of employees Space occupied (square feet) Machine hours Direct labor hours 25 10,000 10,000 4,000 Molding 45 40,000 2,000 20,000 (a) Prepare a schedule allocating general plant management costs and plant security costs to the Melting and Molding Departments. (Round your answer to the nea Department General Plant Management Plant security Total $ $ Melting $ $ Molding $ $ (b) Determine the total departmental overhead costs for the Melting and Molding Departments. Melting $ $ Molding $ $ (c) Assuming the Melting Department uses machine hours and the Molding Department uses direct labor hours to apply overhead to production, calculate the over answers to two decimal places.) Melting $ $ Molding $ $ both production departments. Sprint allocates general plant management costs on the basis of the number of production employees and plant security costs on the to the nearest whole number. Do not round until your final answer.) e the overhead rate for each production department. (Round your the basis of space occupied by the production departments. In November, the following overhead costs were recorded: Interdepartment Services: Step Method Tucson Manufacturing Company has five operating departments, two of which are producing departments (P1 and P2) and three of which are service departments departments are allocated to the producing departments. The following table shows the distribution of services from the service departments. Services provided from Services Provided to S1 S2 S3 S1 -S2 10% -S3 15 P1 5% P2 25% 5 5 -- 50% 45 20 20% 40 60 The direct operating costs of the service departments are as follows: S1 S2 S3 $49,000 93,500 18,000 Refer to the data above. Using the step method, prepare a schedule for Tucson Manufacturing Company allocating the service department costs to the producing de dollar. Do not round until your final answers.) Service Departments Producing Departments S1 S2 Total costs 0 S3 0 P1 0$ P2 $ nts (S1, S2, and S3). All costs of the service g departments. (Round calculations to the nearest