Advanced Products Corporation has supplied the following data from its activity-based costing system: Overhead Costs Wages and salaries $ 300,000 Other overhead costs 100,000 Total overhead costs $ 400,000 Total Activity for the Activity Cost Pool Activity Measure Year Supporting direct labor Number of direct labor-hours 20,000 DLHS Order processing Number of customer orders 400 orders Customer support Number of customers 200 customers Other This is an organization- Not applicable sustaining activity Distribution of Resource consumption Across Activities Supporting Order Customer Direct Labor Processing Support Other Total Wages and salaries 409 304 204 104 100% other overhead costs 104 20% 404 100% During the year, Advanced Products completed one order for a new customer, Shenzhen Enterprises. This customer did not order any other products during the year. Data concerning that order follow: Data Concerning the Shenzhen Enterprises Order Units ordered 10 units Direct labor-hours 2 DLHS per unit Selling price $ 300 per unit Direct materials $ 189 per unit Direct labor $ 50 per unit Required: 1. Prepare a report showing the first stage allocations of overhead costs to the activity cost pools. 2. Compute the activity rates for the activity cost pools. 3. Calculate the total overhead costs for the order from Shenzhen Enterprises including customer support costs. 4. Calculate the customer margin for Shenzhen Enterprises, 304 Required: 1. Prepare a report showing the first-stage allocations of overhead costs to the activity cost pools 2. Compute the activity rates for the activity cost pools. 3. Calculate the total overhead costs for the order from Shenzhen Enterprises including customer support costs. 4. Calculate the customer margin for Shenzhen Enterprises. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Prepare a report showing the first stage allocations of overhead costs to the activity cost pools. Direct Labor Order Customer Other Totals Support Processing Support Wages and salaries $ 120,000 $ 90,000 $ 210,000 Other overhead costs 30,000 10,000 $ 40,000 Total cost $ 150,000 $ 100,000 $ 0 $ 0 $ 250,000 Required 2 > Required: 1. Prepare a report showing the first stage allocations of overhead costs to the activity cost pools. 2. Compute the activity rates for the activity cost pools. 3. Calculate the total overhead costs for the order from Shenzhen Enterprises including customer support costs. 4. Calculate the customer margin for Shenzhen Enterprises. Complete this question by entering your answers in the tabs below. 05 Required 1 Required 2 Required 3 Required Compute the activity rates for the activity cost pools. (Round the "Direct labor support to 2 decimal places.) Activity Cost Pool Supporting direct labor Order processing Customer support $ $ Activity Rate 7.50 per DH 250 per order per customer Required: 1. Prepare a report showing the first stage allocations of overhead costs to the activity cost pools. 2. Compute the activity rates for the activity cost pools. 3. Calculate the total overhead costs for the order from Shenzhen Enterprises including customer support costs. 4. Calculate the customer margin for Shenzhen Enterprises. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Calculate the total overhead costs for the order from Shenzhen Enterprises including customer support costs. Activity Cost Pool ABC Cost Supporting direct labor $ 1501 Order processing 250 Customer support Total $ 400 Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Calculate the customer margin for Shenzhen Enterprises. Shenzhen Enterprises Customer Margin-ABC Analysis Costs Customer margin 0 $
