90.2K

Verified Solution

Link Copied!

Problem 7A-4 (Algo) Time-Driven Activity-Based Costing [LO7-6, L07-7) Stahl Company is conducting a time-driven activity based costing study in its Shipping Department. To aid the study, the company provided the following data regarding its Shipping Department and the customers served by the department Number of employees Average salary per esployee weeks of employment per year Hours worked per week Practical capacity percentage 27 $33,000 52 40 sex Line-Item Picking Loading Deliveries 3e Packaging 15 Minutes per unit of the activity Number of line itens picked Number of boxes packaged Number of deliveries loaded Customer 235 37 6 Customer M 135 17 2 Customer N 85 19 10 All Customers 305,000 31,200 12,100 Required: 1. Using the customer cost analysis as demonstrated in Exhibit 7A-2.compute the following: a The cost per minute of the resource supplied in the Shipping Department The time-driven activity rate for each of Stahl's three activities cThe total labor costs consumed by Customer L. Customer M. and Customer 2. Using the capacity analysis as demonstrated in Exhibit 7A3, compute the following: a The used capacity in minutes D. The unused capacity in minutes The unused capacity in number of employees d. The impact on expenses of matching capacity with demand, Complete this question by entering your answers in the tabs below. Complete this question by entering your answers in the tabs below. Required 1 Required 2 1. Compute the following: a. The cost per minute of the resource supplied in the Shipping Department. b. The time-driven activity rate for each of Stahl's three activities. c. The total labor costs consumed by Customer L. Customer M, and Customer N. (For all requirements, round your intermediate calculations and final answers to 2 decimal places.) a. Cost per minute of the resource supplied b. Time-driven activity rate: Line-item picking Packaging Loading Deliveries c. Total shipping labor costs assigned to: Customer Customer M Customer N Real Required 2 > c.The total labor costs consumed by Customer L. Customer M. and Customer N. 2. Using the capacity analysis as demonstrated in Exhibit 7A-3. compute the following a. The used capacity in minutes. b. The unused capacity in minutes. c. The unused capacity in number of employees. d. The impact on expenses of matching capacity with demand. Complete this question by entering your answers in the tabs below. Required 1 Required 2 2. Compute the following: a. The used capacity in minutes. b. The unused capacity in minutes. c. The unused capacity in number of employees. (Round your answer to 2 decimal places.) d. The impact on expenses of matching capacity with demand. (Round down your potential adjustment in the number of employees to a whole number) Show less 2. Shipping minutes used to meet demand b. Unused capacity in minutes Unused capacity in number of employees Impact on expenses of matching capacity with demand

Answer & Explanation Solved by verified expert

See Answer