Almost finished, but the step by step wasnt clear enough
Gallatin Carpet Cleaning is a small, family-owned business operating out of Bozeman, Montana. For its services, the company has always charged a flat fee per hundred square feet of carpet cleaned. The current fee is $23.25 per hundred square feet. However. there is some question about whether the company is actually making any money on jobs for some customers-particularly those located on remote ranches that require considerable travel time. The owner's daughter, home for the summer from college, has suggested investigating this question using activity-based costing. After some discussion, she designed a simple system consisting of four activity cost pools. The activity cost pools and their activity measures appear below: The total cost of operating the company for the year is $363,000 which includes the following costs: Resource consumption is distributed across the activities as follows: Job support consists of receiving calls from potential customers at the home office, scheduling jobs, bulling, resolving issues, and so on. Resource consumption is distributed across the activities as follows: Job support consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on. Required: 1. Prepare the first-stage allocation of costs to the activity cost pools. 2. Compute the activity rates for the activity cost pools. 3. The company recently completed a 200 square foot carpet-cleaning job at the Flying N Ranch-a 60 -mile round-trip journey from the company's offices in Bozeman. Compute the cost of this job using the activity-based costing system. 4. The revenue from the Flying N Ranch was $46.50 (200 square feet $23.25 per hundred square feet). Calculate the customer margin earned on this job. Complete this question by entering your answers in the tabs below. The company recently complehed a 200 square foot carpet-deaning job at the Fiying N Ranch-a 60 -mile round-trip joumey from the company's offices in Bozeman. Compute the cost of this job using the activity-based costing system. (Round your intermediate calculations and final answer to 2 decimal places.) Resource consumption is distributed across the activities as follows: Job support consists of receiving calls from potential customers at the home office, scheduling jobs, billing, resolving issues, and so on. Required: 1. Prepare the first-stage allocation of costs to the activity cost pools. 2. Compute the activity rates for the activity cost pools. 3. The company recently completed a 200 square foot carpet-cleaning job at the Flying N Ranch-a 60 -mile round-trip journey from the company's offices in Bozeman. Compute the cost of this job using the actlvity-based costing system. 4. The revenue from the Flying N Ranch was $46.50 (200 square feet @$23.25 per hundred square feet). Calculate the customer margin earned on this job. Complete this question by entering your answers in the tabs below. The revenue from the Flying N Ranch was $46.50 ( 2 hundred square feet @ $23.25 per hundred square feet). Calculate the customer margin eamed on this job. (Negative customer margins should be indicated with a minus sign. Round your intermediate calculations and final answers to 2 decimal places.)
