Question: Use the data t o complete a First-Stage Allocation to Activity Cost Pools. When completing the table, copy formulas as appropriate Total Cost Customer Orders
| Use the data t o complete a First-Stage Allocation to Activity Cost Pools. When completing the table, copy formulas as appropriate | ||||||
| Total Cost | Customer Orders | Product Development | Customer Relations | Other | Total | |
| Production Dept | ||||||
| indirect factory wages | 400,000 | 50% | 30% | 15% | 5% | 100% |
| Factory equipment depreciation | 150,000 | 55% | 30% | 0% | 15% | 100% |
| Factory Utilities | 120000 | 59% | 34% | 0% | 7% | 100% |
| Factory property taxes and insurance | 75000 | 57% | 33% | 0% | 10% | 100% |
| General Administrative Depart | ||||||
| Admin wages and salaries | 275,000 | 20% | 10% | 40% | 30% | 100% |
| Office equipment depreciation | 40,000 | 32% | 16% | 15% | 37% | 100% |
| Admin property taxes and insurance | 60,000 | 0% | 0% | 0% | 100% | 100% |
| Marketing Dept | ||||||
| Marketing wages and salaries | 150,000 | 20% | 10% | 40% | 30% | 100% |
| Selling expenses | 100,000 | 32% | 16% | 15% | 37% | 100% |
| Total Cost | Customer Orders | Product Development | Customer Relations | Other | Total | |
| Production Dept | ||||||
| indirect factory wages | ||||||
| Factory equipment depreciation | ||||||
| Factory Utilities | ||||||
| Factory property taxes and insurance | ||||||
| General Administrative Depart | ||||||
| Admin wages and salaries | ||||||
| Office equipment depreciation | ||||||
| Admin property taxes and insurance | ||||||
| Marketing Dept | ||||||
| Marketing wages and salaries | ||||||
| Selling expenses | ||||||
| Total | ||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help