Exercise 7-2 First-Stage Allocation [LO2] VaultOnWheels Corporation operates a fleet of armored cars that make scheduled...

 

Transcribed Image Text:

Exercise 7-2 First-Stage Allocation [LO2] VaultOnWheels Corporation operates a fleet of armored cars that make scheduled pickups and deliveries for its customers in the Phoenix area. The company is implementing an activity-based costing system that has four activity 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 cost pool, and number of customers for the Customer Service cost pool. The Other cost pool has no activity measure because it is an organization-sustaining activity. The following costs will be assigned using the activity-based costing system: Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses Total cost Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses S The distribution of resource consumption across the activity cost pools is as follows: Pickup and Delivery 45% 5% 10% Total cost S 1,000,000 Travel 430,000 310,000 340,000 200,000 500,000 2,780,000 Travel 40% 75% 70% 0% 0% 0% 0% 25% 5% Required: Complete the first-stage allocations of costs to activity cost pools. (Leave no cells blank be certain to enter "0" wherever required. Omit the "$" sign in your response.) S Customer Service 10% 0% 0% 85% 35% 55% S Other 5% 20% 20% 15% 40% 100% 40% 100% Pickup and Delivery S Totals 100% 100% 100% 100% S Customer Service S Other S $ Totals Exercise 7-2 First-Stage Allocation [LO2] VaultOnWheels Corporation operates a fleet of armored cars that make scheduled pickups and deliveries for its customers in the Phoenix area. The company is implementing an activity-based costing system that has four activity 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 cost pool, and number of customers for the Customer Service cost pool. The Other cost pool has no activity measure because it is an organization-sustaining activity. The following costs will be assigned using the activity-based costing system: Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses Total cost Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses S The distribution of resource consumption across the activity cost pools is as follows: Pickup and Delivery 45% 5% 10% Total cost S 1,000,000 Travel 430,000 310,000 340,000 200,000 500,000 2,780,000 Travel 40% 75% 70% 0% 0% 0% 0% 25% 5% Required: Complete the first-stage allocations of costs to activity cost pools. (Leave no cells blank be certain to enter "0" wherever required. Omit the "$" sign in your response.) S Customer Service 10% 0% 0% 85% 35% 55% S Other 5% 20% 20% 15% 40% 100% 40% 100% Pickup and Delivery S Totals 100% 100% 100% 100% S Customer Service S Other S $ Totals

Answer rating: 100% (QA)

Driver and Guard Wages Vehicle Operatin Expense Vehicle Depreciation Customer Representative Salarie... View the full answer