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: 34

Average salary per employee: $34,000

Weeks of employment per year: 52

Hours worked per week: 40

Practical capacity percentage: 80%

Minutes per Unit of the activity:

Line Item picking: 5

Packaging: 15

Loading deliveries: 30

	Customer L	Customer M	Customer N	All Customers
# of line items picked	280	160	90	335,000
# of boxes packaged	50	20	15	46,800
# of deliveries loaded	6	2	10	12,100

Required:

1. Calculate the cost per minute of the resource supplied (shipping employee) (4 points)

2. Calculate the time-driven activity rate for (6 points)
3. What is the total cost of Shipping for each of the customers: (9 points)
4. Lets assume that we provide shipping for customers for free. Given the costs you calculated in #3, list 2 actions that you can take with customer L to change their behavior. (4 points)

5. Lets assume that we drop customer L, what would be the impact on profits to Stahl? (3 points)

6. What is the cost of used capacity for the Shipping department in minutes? (2 points)

7. What is the cost of excess/unused capacity in minutes? (2 points)

8. List 2 actions that you would take regarding the excess capacity. (4 points)

CAN EACH PART BE ANSWERED IN DETAIL