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 Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses Total cost $1,040,000 470,000 350,000 380,000 240,000 540,000 $3,020,000 The distribution of resource consumption across the activity cost pools is as follows: Travel 50% 70% 60% Pickup and Customer Delivery Service 35% 10% 5% 0% 15% Other 5% 25% 25% Totals 100% 100% 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 Delivery Customer Service Travel Other Totals $ 0 0 0 Driver and guard wages Vehicle operating expense Vehicle depreciation Customer representative salaries and expenses Office expenses Administrative expenses Total cost 0 0 0 $ $ $ 0 $ 0 $ 0 $ 0 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: 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 Estimated Overhead Cost Expected Activity $ 78,600 185,000 square feet of lawn $ 31,200 26,000 square feet of low maintenance beds $ 55,000 20,000 square feet of high maintenance beds $ 3,200 17,000 miles $ 6,700 40 customers Required: Compute the activity rate for each of the activity cost pools. (Round your answers to 2 decimal places.) Activity Cost Pool Caring for lawn Caring for garden bedslow maintenance Caring for garden bedshigh maintenance Travel to jobs Customer billing and service Activity Rate per square ft of lawn per square ft of low maintenance beds per square ft of high maintenance beds per mile per customer
