Question

he following information relates to overhead costlat chocolates by Jacki for the current year 1 2 otal costs and distributionWhen completing the table, copy tormulas as appropriate. 23 24 Activity Cost Pools 25 Total 26 Production Department 27 28 29

he following information relates to overhead costlat chocolates by Jacki for the current year 1 2 otal costs and distribution of resource consumption across activity cost pools: 3 Activity Cost Pools 5 Product Customer Customer Total Orders Development Relations Total Cost Other 6 roduction Department: Indirect factory wages 7 400,000 50% 30% 159% 59% 100% 8 55% 30% 100% Factory equipment depreciation 0% 15% 150.000 Factory utilities 599% 34% 09% 79% 100 % 120,000 10 10% 100 % 75,000 57% 33 % 0% Factory property taxes and insurance 11 12 eneral Administrative Department 13 Administrative wages and salaries 30% 100 % 20% 10% 40% 275,000 14 Office equipment depreciation 16 % 32% 15% 379% 100% 40,000 15 Administrative property taxes and insurance 0 % 0% 1009 100 % 60,000 16 17 Marketing Department: 18 Marketing wages and salaries 20% 10% 40 % 30% 100% 150,000 19 Selling expenses 16% 100% 100,000 32% 15% 379% 20 21 Jse the data to complete a First-Stage Allocation to Activity Cost Pools. 22 hen completing the table, copy formulas as appropriate. 23 mdt
When completing the table, copy tormulas as appropriate. 23 24 Activity Cost Pools 25 Total 26 Production Department 27 28 29 30 31 32 General Administration Department: 33 34 35 36 37 Marketing Department: 38 39 40 41 Total 42 43 44 45
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Activityy Cost pools Poialuct Custornc Fartliculers peolarctoneap actory ingess Custemer osder develepmien Relatfion 0the 600

Add a comment
Know the answer?
Add Answer to:
he following information relates to overhead costlat chocolates by Jacki for the current year 1 2...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • ork 1 The following information relates to overhead cost at Chocolates by lacki for the current year. 2 Total cost...

    ork 1 The following information relates to overhead cost at Chocolates by lacki for the current year. 2 Total costs and distribution of resource consumption across activity cost pools: Activity Cost Pools ProductCustomer Customer Other Total Total Cost Orders Development Relations 6 Production Department 7 Indirect factory wages 8 Factory equipment depreciation 9 Factory utilities 10 Factory property taxes and insurance 30% 15% 5% 100% $400,000 50% 15% 100% 30% 150,000 55% 796 100% 120,000 75,000 59% 34% 100% 10%...

  • I need help with any formulas. 1. Assign Overhead Costs to Activity Cost Pools 3 ?...

    I need help with any formulas. 1. Assign Overhead Costs to Activity Cost Pools 3 ? - X XD FILE . HOME First-Stage Allocation to Activity Cost Pools - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW INSERT Sign In Calibri B I U - 10 AA . A G Cells Paste Clipboard Editing Alignment Number Conditional Format as Cell Formatting Table Styles Styles Font A27 А 1 The following information relates to overhead cost at Chocolates by Jacki for the...

  • PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS...

    PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 PLEASE DETAIL ALL FINAL ANSWERS AS EXCEL FORMULAS - EXAMPLE =B14*B16 Chocolates by Jacki has provided information relating to its current year. The Controller has asked you to complete a First-Stage Allocation to Activity Cost Pools....

  • Excel SIM: First-Stage Allocation to Activity Cost Pools Help 1. Assign Overhead Costs to Activity Cost...

    Excel SIM: First-Stage Allocation to Activity Cost Pools Help 1. Assign Overhead Costs to Activity Cost Pools OBS FILE HOME DESERT Festtage Allocation to Activity Cost Pools Excel PAGE LAYOUT FORMULAS DATA REVIEW 7 - X VIEW Alignment Number Conditional Formatas C oord B27 The following information care dintr est verhead Chocolates by lock for the current year e Activity Cost Pools Product Development Indirect factory w Other en de Factory 12 General Administrate Department 13 Admistrative was and series...

  • Bennette Corporation has provided the following data concerning its overhead costs for the coming year: Wages...

    Bennette Corporation has provided the following data concerning its overhead costs for the coming year: Wages and salaries Depreciation Rent Total $510,000 205,000 225,000 $940,000 The company has an activity-based costing system with the following three activity cost pools and estimated activity for the coming year: Activity Cost Pool Total Activity labor- Assembly 45,000 hours Order processing 450 orders Other Not applicable The Other activity cost pool does not have a measure of activity, it is used to accumulate costs...

  • Tomasini Corporation has provided the following data from its activity-based costing accounting system: Supervisory wages $...

    Tomasini Corporation has provided the following data from its activity-based costing accounting system: Supervisory wages $ 630,000 Factory supplies $ 230,000 Distribution of Resource Consumption across Activity Cost Pools: Activity Cost Pools Batch Processing Unit Processing Other Total Supervisory wages 30% 65% 5% 100% Factory supplies 40% 30% 30% 100% The "Other" activity cost pool consists of the costs of idle capacity and organization-sustaining costs that are not assigned to products. How much supervisory wages and factory supplies cost would...

  • Bennette Corporation has provided the following data concerning its overhead costs for the coming year: Wages and salar...

    Bennette Corporation has provided the following data concerning its overhead costs for the coming year: Wages and salaries Depreciation Rent $420,000 160,000 180,000 $760,000 Total The company has an activity-based costing system with the following three activity cost pools and estimated activity for the coming year: Activity Cost Pool Assembly Order processing Other Total Activity labor- 40,000 hours 700 orders Not applicable The Other activity cost pool does not have a measure of activity, it is used to accumulate costs...

  • omasini Corporation has provided the following data from its activity-based costing accounting system: Supervisory wages $...

    omasini Corporation has provided the following data from its activity-based costing accounting system: Supervisory wages $ 760,000 Factory supplies $ 360,000 Distribution of Resource Consumption across Activity Cost Pools: Activity Cost Pools Batch Processing Unit Processing Other Total Supervisory wages 20% 65% 15% 100% Factory supplies 45% 35% 20% 100% The "Other" activity cost pool consists of the costs of idle capacity and organization-sustaining costs that are not assigned to products. How much supervisory wages and factory supplies cost would...

  • Tomasini Corporation has provided the following data from its activity-based costing accounting system: Supervisory wages $...

    Tomasini Corporation has provided the following data from its activity-based costing accounting system: Supervisory wages $ 780,000 Factory supplies $ 380,000 Distribution of Resource Consumption across Activity Cost Pools: Activity Cost Pools Batch Processing Unit Processing Other Total Supervisory wages 30% 60% 10% 100% Factory supplies 40% 30% 30% 100% The "Other" activity cost pool consists of the costs of idle capacity and organization-sustaining costs that are not assigned to products. How much supervisory wages and factory supplies cost would...

  • Bennette Corporation has provided the following data concerning its overhead costs for the coming year: Wages...

    Bennette Corporation has provided the following data concerning its overhead costs for the coming year: Wages and salaries $ 460,000 Depreciation 180,000 Rent 200,000 Total $ 840,000 The company has an activity-based costing system with the following three activity cost pools and estimated activity for the coming year: Activity Cost Pool Total Activity Assembly 40,000 labor-hours Order processing 400 orders Other Not applicable The Other activity cost pool does not have a measure of activity; it is used to accumulate...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT