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 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 $1,080,000 Vehicle operating 510,000 expense Vehicle depreciation 390,000 Customer representative 420,000 salaries and expenses Office expenses 280,000 Administrative 580,000 expenses Total cost $3,260,000 The distribution of resource consumption across the activity cost pools is as follows: Pickup and Customer Travel Delivery Service Other Totals 50% 35% 10% 5% 100% 70% 5% 25% 100% 60% 15% 0% 25% 100% 0% 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. Pickup and Customer Customer Travel Delivery Service Other Totals Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses Total cost Green Thumb Gardening is a small gardening service that uses activity-based costing to estimate costs for pricing and other purposes. The proprietor of the company believes that costs are driven primarily by the size of customer lawns, the size of customer garden beds, the distance to travel to customers, and the number of customers. In addition, the costs of maintaining garden beds depends on whether the beds are low maintenance beds (mainly ordinary trees and shrubs) or high maintenance beds (mainly flowers and exotic plants). Accordingly, the company uses the five activity cost pools listed below: Activity Cost Pool Caring for lawn Caring for garden beds-low maintenance Caring for garden beds-high maintenance Travel to jobs Customer billing and service Activity Measure Square feet of lawn Square feet of low maintenance beds Square feet of high maintenance beds Miles Number of customers The company already has completed its first stage allocations of costs and has summarized its annual costs and activity as follows: Estimated Overhead Activity Cost Pool Cost Expected Activity Caring for lawn $76,200 185,000 square feet of lawn Caring for garden beds-low square feet of low maintenance $28,800 24,000 maintenance beds Caring for garden beds-high $50,040 18,000 square feet of high maintenance maintenance beds Travel to jobs $ 4,400 15,000 miles Customer billing and service $ 9, 100 38 customers Required: Compute the activity rate for each of the activity cost pools. (Round your answers to 2 decimal places.) Activity Rate Activity Cost Pool Caring for lawn Caring for garden beds-low maintenance Caring for garden beds-high maintenance Travel to jobs Customer billing and service per square ft of lawn per square ft of low maintenance beds per square ft of high maintenance beds per mile per customer
