please solve in excell

EXERCISE 7-15 Comprehensive Activity-Based Costing Exercise L07-2. LO7-3, LO7-4, L07-5 Advanced Products Corporation has supplied the following data from its activity-based costing system: Overhead Costs Wages and salaries Other overhead costs Total overhead costs Activity Cost Pool Supporting direct labor Order processing Customer support Other Distribution of Resource Consumption Across Activities Wages and salaries Other overhead costs Supporting Direct Labor 40% 30% Activity Measure Number of direct labor-hours Number of customer orders Number of customers This is an organization- sustaining activity Order Processing 30% 10% Customer Support $300,000 100,000 $400.000 Data concerning the Shenzhen Enterprises Order Units ordered Direct labor-hours Selling price Direct materials. Direct labor 20% 20% 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: $300 per unit $180 per unit $50 per unit Activity-Based Costing: A Tool to Aid Decision Making Total Activity for the Year Required: 1. Using Exhibit 7-6 as a guide, prepare a report showing the first-stage allocations of overhead costs to the activity cost pools. 2. Using Exhibit 7-7 as a guide, 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. Using Exhibit 7-12 as a guide, calculate the customer margin for Shenzhen Enterprises. 20,000 DLHs 400 orders 200 customers Not applicable 10 units 2 DLHS per unit Other Total 10% 100% 40% 100%