Distribution of Resource Consumption Across Activities Cleaning Carpets 78% Travel Total to Jobs 11% Job Support Other ex 11% 100% Wages Cleaning supplies Cleaning equipment depreciation Vehicle expenses Office expenses President's compensation 100% e% 0% 100% 70% 0% 0% 30% 100% ex 81% 0% 19% 100% 0% e% 64% 36% 100% ex ex 33% 67% 100% Job support consists of recelving calls from potentlal customers at the home office, scheduling Jobs, blling, resolving Issues, and so on. Required: 1. Prepare the first-stage allocation of costs to the activity cost pools.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%

This question is taken in 2 pictures may I please receive help answering this one question

**Gallatin Carpet Cleaning: An Activity-Based Costing Case Study**

**Company Overview:**
Gallatin Carpet Cleaning, a small family-operated business based in Bozeman, Montana, traditionally charges a flat rate for carpet cleaning services. The fee is $22.25 per hundred square feet. However, questions have arisen regarding the profitability of certain jobs, particularly those requiring significant travel time. To address this, the owner's daughter has designed a system utilizing activity-based costing to evaluate their services more accurately. Below is a summary of the activity cost pools and their measurements.

**Activity Cost Pools and Measurements:**

- **Cleaning Carpets**
  - **Activity Measure:** Square feet cleaned (in hundreds)
  - **Activity for the Year:** 13,500 hundred square feet

- **Travel to Jobs**
  - **Activity Measure:** Miles driven
  - **Activity for the Year:** 300,000 miles

- **Job Support**
  - **Activity Measure:** Number of jobs
  - **Activity for the Year:** 1,700 jobs

- **Other (Organizational-sustaining Costs and Idle Capacity Costs)**
  - **Activity Measure:** None
  - **Activity for the Year:** Not applicable

**Financial Overview:**

The total operating cost for the year is $347,000. This includes:

- Wages: $144,000
- Cleaning Supplies: $32,000
- Cleaning Equipment Depreciation: $8,000
- Vehicle Expenses: $26,000
- Office Expenses: $56,000
- President's Compensation: $81,000

**Total Cost:** $347,000

**Resource Consumption Distribution:**

The following table illustrates how resources are distributed across the activities:

| Resource                             | Cleaning Carpets | Travel to Jobs | Job Support | Other | Total |
|--------------------------------------|------------------|----------------|-------------|-------|-------|
| Wages                                | 78%              | 11%            | 11%         | 0%    | 100%  |
| Cleaning Supplies                    | 100%             | 0%             | 0%          | 0%    | 100%  |
| Cleaning Equipment Depreciation      | 100%             | 0%             | 0%          | 0%    | 100%  |
| Vehicle Expenses                     | 0%               | 85%            | 15
Transcribed Image Text:**Gallatin Carpet Cleaning: An Activity-Based Costing Case Study** **Company Overview:** Gallatin Carpet Cleaning, a small family-operated business based in Bozeman, Montana, traditionally charges a flat rate for carpet cleaning services. The fee is $22.25 per hundred square feet. However, questions have arisen regarding the profitability of certain jobs, particularly those requiring significant travel time. To address this, the owner's daughter has designed a system utilizing activity-based costing to evaluate their services more accurately. Below is a summary of the activity cost pools and their measurements. **Activity Cost Pools and Measurements:** - **Cleaning Carpets** - **Activity Measure:** Square feet cleaned (in hundreds) - **Activity for the Year:** 13,500 hundred square feet - **Travel to Jobs** - **Activity Measure:** Miles driven - **Activity for the Year:** 300,000 miles - **Job Support** - **Activity Measure:** Number of jobs - **Activity for the Year:** 1,700 jobs - **Other (Organizational-sustaining Costs and Idle Capacity Costs)** - **Activity Measure:** None - **Activity for the Year:** Not applicable **Financial Overview:** The total operating cost for the year is $347,000. This includes: - Wages: $144,000 - Cleaning Supplies: $32,000 - Cleaning Equipment Depreciation: $8,000 - Vehicle Expenses: $26,000 - Office Expenses: $56,000 - President's Compensation: $81,000 **Total Cost:** $347,000 **Resource Consumption Distribution:** The following table illustrates how resources are distributed across the activities: | Resource | Cleaning Carpets | Travel to Jobs | Job Support | Other | Total | |--------------------------------------|------------------|----------------|-------------|-------|-------| | Wages | 78% | 11% | 11% | 0% | 100% | | Cleaning Supplies | 100% | 0% | 0% | 0% | 100% | | Cleaning Equipment Depreciation | 100% | 0% | 0% | 0% | 100% | | Vehicle Expenses | 0% | 85% | 15
### Distribution of Resource Consumption Across Activities

#### Table Explanation
The table categorizes the distribution of resources across five activities: Cleaning Carpets, Travel to Jobs, Job Support, Other, and Total. Each row represents a different resource category—Wages, Cleaning Supplies, Cleaning Equipment Depreciation, Vehicle Expenses, Office Expenses, and President's Compensation—with corresponding percentages allocated to each activity.

- **Wages**: 78% Cleaning Carpets, 11% Travel to Jobs, 6% Job Support, 11% Other
- **Cleaning Supplies**: 100% Cleaning Carpets
- **Cleaning Equipment Depreciation**: 70% Cleaning Carpets, 0% Travel to Jobs, 0% Job Support, 30% Other
- **Vehicle Expenses**: 0% Cleaning Carpets, 81% Travel to Jobs, 0% Job Support, 19% Other
- **Office Expenses**: 0% Cleaning Carpets, 0% Travel to Jobs, 64% Job Support, 36% Other
- **President’s Compensation**: 0% Cleaning Carpets, 0% Travel to Jobs, 33% Job Support, 67% Other

### Context
Job support involves managing potential customer inquiries, scheduling, billing, and other related tasks.

### Required Tasks
1. **Prepare the first-stage allocation of costs** to the activity cost pools.
2. **Compute the activity rates** for the activity cost pools.
3. **Calculate the job cost** using activity-based costing for a recent 200 square foot carpet-cleaning job at the Flying N Ranch.
4. **Determine the customer margin** on this job, based on the revenue of $44.50 for the 200 square feet of cleaning at a rate of $22.25 per hundred square feet.

### Instructions
- Enter your answers for each step in the provided tabs.
  
#### Required 1: Prepare the First-Stage Allocation of Costs
A table is provided to fill in costs corresponding to each activity (Cleaning Carpets, Travel to Jobs, Job Support, Other, Total) for categories such as Wages, Cleaning Supplies, etc. The goal is to distribute costs based on the provided percentages.

Use the data and process outlined above to input your calculations in the corresponding fields.
Transcribed Image Text:### Distribution of Resource Consumption Across Activities #### Table Explanation The table categorizes the distribution of resources across five activities: Cleaning Carpets, Travel to Jobs, Job Support, Other, and Total. Each row represents a different resource category—Wages, Cleaning Supplies, Cleaning Equipment Depreciation, Vehicle Expenses, Office Expenses, and President's Compensation—with corresponding percentages allocated to each activity. - **Wages**: 78% Cleaning Carpets, 11% Travel to Jobs, 6% Job Support, 11% Other - **Cleaning Supplies**: 100% Cleaning Carpets - **Cleaning Equipment Depreciation**: 70% Cleaning Carpets, 0% Travel to Jobs, 0% Job Support, 30% Other - **Vehicle Expenses**: 0% Cleaning Carpets, 81% Travel to Jobs, 0% Job Support, 19% Other - **Office Expenses**: 0% Cleaning Carpets, 0% Travel to Jobs, 64% Job Support, 36% Other - **President’s Compensation**: 0% Cleaning Carpets, 0% Travel to Jobs, 33% Job Support, 67% Other ### Context Job support involves managing potential customer inquiries, scheduling, billing, and other related tasks. ### Required Tasks 1. **Prepare the first-stage allocation of costs** to the activity cost pools. 2. **Compute the activity rates** for the activity cost pools. 3. **Calculate the job cost** using activity-based costing for a recent 200 square foot carpet-cleaning job at the Flying N Ranch. 4. **Determine the customer margin** on this job, based on the revenue of $44.50 for the 200 square feet of cleaning at a rate of $22.25 per hundred square feet. ### Instructions - Enter your answers for each step in the provided tabs. #### Required 1: Prepare the First-Stage Allocation of Costs A table is provided to fill in costs corresponding to each activity (Cleaning Carpets, Travel to Jobs, Job Support, Other, Total) for categories such as Wages, Cleaning Supplies, etc. The goal is to distribute costs based on the provided percentages. Use the data and process outlined above to input your calculations in the corresponding fields.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Database design
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education