3 Activity Cost Pools Customer Product Customer Total Cost Orders Development Relations Other Total 6 Production Department 7 Indirect factory wages 8 Factory equipment depreciation 9 Factory utilities $ 400,000 50% 30% 15% 5% 100% 150,000 55% 30% 0% 15% 100% 120,000 59% 34% 0% 7% 100% 10 Factory property taxes and insurance 75,000 57% 33% 0% 10% 100% 11 12 General Administrative Department 13 Administrative wages and salaries |14 Office equipment depreciation 275,000 20% 10% 40% 30% 100% 40,000 32% 16% 15% 37% 100% 15 Administrative property taxes and insurance 60,000 0% 0% 0% 100% 100% 16 17 Marketing Department 18 Marketing wages and salaries 19 Selling expenses 150,000 20% 10% 40% 30% 100% 100,000 32% 16% 15% 37% 100% 20 21 Use the data to complete a First-Stage Allocation to Activity Cost Pools. 22 When completing the table, copy formulas as appropriate.
3 Activity Cost Pools Customer Product Customer Total Cost Orders Development Relations Other Total 6 Production Department 7 Indirect factory wages 8 Factory equipment depreciation 9 Factory utilities $ 400,000 50% 30% 15% 5% 100% 150,000 55% 30% 0% 15% 100% 120,000 59% 34% 0% 7% 100% 10 Factory property taxes and insurance 75,000 57% 33% 0% 10% 100% 11 12 General Administrative Department 13 Administrative wages and salaries |14 Office equipment depreciation 275,000 20% 10% 40% 30% 100% 40,000 32% 16% 15% 37% 100% 15 Administrative property taxes and insurance 60,000 0% 0% 0% 100% 100% 16 17 Marketing Department 18 Marketing wages and salaries 19 Selling expenses 150,000 20% 10% 40% 30% 100% 100,000 32% 16% 15% 37% 100% 20 21 Use the data to complete a First-Stage Allocation to Activity Cost Pools. 22 When completing the table, copy formulas as appropriate.
Pkg Acc Infor Systems MS VISIO CD
10th Edition
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:Ulric J. Gelinas
Chapter4: Documenting Information System
Section: Chapter Questions
Problem 3SP
Related questions
Question
can you get me the formula to excel
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning