7-2 in excel doc please

EXERCISE 7-2 First Stage Allocation L07-2 SecuriCorp operates a fleet of armored cars that make scheduled pickups and deliveries in the Los Angeles area. The company is implementing an activity-based costing system that has four activ- ity cost pools: Travel. Pickup and Delivery, Customer Service, and Other. The activity measures are miles for the Travel cost pool, number of pickups and deliveries for the Pickup and Delivery Chapter 7 cost pool, and number of customers for the Customer Service cost pool. The Other cost pool no activity measure because it is an organization-sustaining activity. The following costs will be assigned using the activity-based costing system: $ 720,000 Driver and guard wages 280,000 Vehicle operating expense 120,000 Vehicle depreciation 160.000 Customer representative salaries and expenses 30,000 Office expenses. 320.000 Administrative expenses $1.630,000 Total cost The distribution of resource consumption across the activity cost pools is as follows: Pickup and Travel Delivery Customer Service Other Total 50% 70% 60% 35% 5% 15% 10% 0% 0% 5% 25% 25% 100% 100% 100% Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses 0% 0% 0% 0% 20% 5% 90% 30% 60% 10% 50% 35% 100% 100% 100% Required: Complete the first stage allocations of costs to activity cost pools as illustrated in Exhibit 7-6