7-3 in excel doc please

Rege Hov cost EXERCISE 7-3 Compute Activity Rates LO7-3 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 customers, and the number of customers. In addition, the costs of maintaining garden beds depeno on whether the beds are low maintenance beds (mainly ordinary trees and shrubs) or high main tenance beds (mainly flowers and exotic plants). Accordingly, the company uses the five activity cost pools listed below: Thet pany desi Activity Cost Pool Caring for lown 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 Man The company already has completed its first stage allocations of costs and has summarized i annual costs and activity as follows: ters. Activity Cost Pool Estimated Overhead Cost Expected Activity $72.000 150.000 square feet of lawn $26.400 Caring for lawn Caring for garden beds-low maintenance Caring for garden beds-high maintenance Travel to jobs. Customer billing and service... $41.400 $3,250 $8,750 20,000 square feet of low maintenance bed 15,000 square feet of high maintenance beds "The 12,500 miles 25 customers Activity-Based Costing: A Tool to Aid Decision Making cost pool has costs will be Compute the activity rate for each of the activity cost pools. Aequired