Exercise 5-15 (Static) Comprehensive Activity-Based Costing Exercise (LO5-2, LO5-3, LO5-4, LO5-5] Advanced Products Corporation has supplied the following data from its activity based costing system. Overhead Coats Mages and salaries Other overhead coats Total overhead costo $300,000 100.000 $400,000 Activity Cost Pool Supporting direct labor Order processing Customer support Other Activity Measure Number of direct labor-hours Number of customer orders Number of customers This is an organization- nuntaising activity Total hetivity for the Year 20,000 DLNA 400 orders 200 customers Not applicable Distribution of Resource Consumption Across Activities Supporting Order Direct Labor Processing Wages and salaries 405 308 other overhead coats 104 Customer Support 200 2015 Other 100 405 Total 1008 1001 JO 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. Dato concerning that order follow. Data Concerning the Shenzhen Interprise Order Units ordered 10 units Direct labor-hours 2 Lite per unit Selling price $ 300 per unit Direct materials $ 180 per unit Direct labor $ 50 per unit Blende Data concerning the anenanen enterprises uraer Units ordered 10 unita Direct labor-hours 2 DLHR per unit Selling price $ 300 per unit Direct materials $ 180 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. 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. Order Direct Labor Support Customer Support Other Totals Processing Wages and salarios Other overhead costs Total cost Required 2 > Data Concerning the Shenzhen Enterprises Order Units ordered 10 units Direct labor-hours 2 DL per unit Selling price $ 300 per unit Direct materials $ 180 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, Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Compute the activity rates for the activity cost pools, (Round the Direct labor support" to 2 decimal places.) Activity Cost Pool Activity Rate Supporting direct labor Order processing por order Customer support per customer per DLH Data concerning the Shenzhen Enterprises Order Units ordered 10 units Direct labor-hours 2 DLHO per unit Selling price $ 300 per unit Direct materials $ 180 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. 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. ABC Cost Activity Cost Pool Supporting direct labor Order processing Customer support Total 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 customer margin for Shenzhen Enterprises. Shenzhen Enterprises Customer Margin-ABC Analysis + Costs: Customer margin
