Homework Help is Here – Start Your Trial Now!
Business
Accounting
Use the data to complete a First-Stage Allocation to Activity Cost Pools. When completing the table, copy formulas as approriate. (Use cells A5 to G20, as well as the "Chart of Accounts" tab r cell referencing and/or formulas needed to complete this question.) Production Department: Indirect factory wages Factory equipment depreciation Factory utilities Factory property taxes and insurance General Administration Department: Administrative wages and salaries Office equipment depreciation Adminstrative property taxes and insurance Marketing Department: Marketing wages and salaries Selling expenses Activity Cost Pools Product Customer Orders Development Customer Relations Other Total

Use the data to complete a First-Stage Allocation to Activity Cost Pools. When completing the table, copy formulas as approriate. (Use cells A5 to G20, as well as the "Chart of Accounts" tab r cell referencing and/or formulas needed to complete this question.) Production Department: Indirect factory wages Factory equipment depreciation Factory utilities Factory property taxes and insurance General Administration Department: Administrative wages and salaries Office equipment depreciation Adminstrative property taxes and insurance Marketing Department: Marketing wages and salaries Selling expenses Activity Cost Pools Product Customer Orders Development Customer Relations Other Total

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

Please help me with the formulas for excel to get the answers in the highlighed areas. Thank you!

B 23 Use the data to complete a First-Stage Allocation to Activity Cost Pools. 24 When completing the table, copy formulas as approriate. 25 26 (Use cells A5 to G20, as well as the "Chart of Accounts" tab for cell referencing and/or formulas needed to complete this question.) 27 28 29 30 Production Department: 31 Indirect factory wages 32 33 34 35 36 General Administration Department: Factory equipment depreciation Factory utilities Factory property taxes and insurance 37 Administrative wages and salaries 38 Office equipment depreciation 39 Adminstrative property taxes and insurance 40 41 Marketing Department: 42 Marketing wages and salaries 43 Selling expenses 44 Total C D Activity Cost Pools Product Customer Orders Development Customer Relations E Other F Total G
Transcribed Image Text:B 23 Use the data to complete a First-Stage Allocation to Activity Cost Pools. 24 When completing the table, copy formulas as approriate. 25 26 (Use cells A5 to G20, as well as the "Chart of Accounts" tab for cell referencing and/or formulas needed to complete this question.) 27 28 29 30 Production Department: 31 Indirect factory wages 32 33 34 35 36 General Administration Department: Factory equipment depreciation Factory utilities Factory property taxes and insurance 37 Administrative wages and salaries 38 Office equipment depreciation 39 Adminstrative property taxes and insurance 40 41 Marketing Department: 42 Marketing wages and salaries 43 Selling expenses 44 Total C D Activity Cost Pools Product Customer Orders Development Customer Relations E Other F Total G
A1 6 1 2 The following information relates to overhead cost at Chocolates by Jacki for the current year. 3 Total costs and distribution of resource consumption across activity cost pools: 4 5 X ✓ fx Accessibility tab summary: The table for total costs and distribution of resource consumption across activity cost pools of Chocola B 7 Production Department: 8 Indirect factory wages 9 Factory equipment depreciation Factory utilities Factory property taxes and insurance 19 A 10 11 12 13 General Administrative Department: 14 Administrative wages and salaries 15 Office equipment depreciation 16 Adminstrative property taxes and insurance 17 18 20 21 Marketing Department: Marketing wages and salaries Selling expenses Total Cost $400,000 150,000 120,000 75,000 275,000 40,000 60,000 с 150,000 100,000 Customer Orders 50% 55% 59% 57% 20% 32% 0% 20% 32% D Activity Cost Pools Product Development 30% 30% 34% 33% 10% 16% 0% 10% 16% E Customer Relations 15% 0% 0% 0% 40% 15% 0% 40% 15% F Other 5% 15% 7% 10% 30% 37% 100% 30% 37% G Total 100% 100% 100% 100% 100% 100% 100% 100% 100% H
Transcribed Image Text:A1 6 1 2 The following information relates to overhead cost at Chocolates by Jacki for the current year. 3 Total costs and distribution of resource consumption across activity cost pools: 4 5 X ✓ fx Accessibility tab summary: The table for total costs and distribution of resource consumption across activity cost pools of Chocola B 7 Production Department: 8 Indirect factory wages 9 Factory equipment depreciation Factory utilities Factory property taxes and insurance 19 A 10 11 12 13 General Administrative Department: 14 Administrative wages and salaries 15 Office equipment depreciation 16 Adminstrative property taxes and insurance 17 18 20 21 Marketing Department: Marketing wages and salaries Selling expenses Total Cost $400,000 150,000 120,000 75,000 275,000 40,000 60,000 с 150,000 100,000 Customer Orders 50% 55% 59% 57% 20% 32% 0% 20% 32% D Activity Cost Pools Product Development 30% 30% 34% 33% 10% 16% 0% 10% 16% E Customer Relations 15% 0% 0% 0% 40% 15% 0% 40% 15% F Other 5% 15% 7% 10% 30% 37% 100% 30% 37% G Total 100% 100% 100% 100% 100% 100% 100% 100% 100% H
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Cost classification
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
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
SEE MORE TEXTBOOKS