Homework Answers
| Formula to allocate cost | ||||||||||||
| Allocated cost=Total cost*Activity cost pools | ||||||||||||
| Activity cost pools | Allocated cost to activity cost pools | |||||||||||
| Total Cost | Customer orders | production development | customer relations | other | Total | Customer orders | production development | customer relations | other | Total | ||
| Production Department: | ||||||||||||
| Indirect factory wages | 400000 | 50.00% | 30.00% | 15.00% | 5.00% | 100.00% | 200000 | 120000 | 60000 | 20000 | 400000 | |
| factory equipment depreciation | 150000 | 55.00% | 30.00% | 0.00% | 15.00% | 100.00% | 82500 | 45000 | 0 | 22500 | 150000 | |
| factory utilities | 120000 | 59.00% | 34.00% | 0.00% | 7.00% | 100.00% | 70800 | 40800 | 0 | 8400 | 120000 | |
| factory property taxes and insurance | 75000 | 57.00% | 33.00% | 0.00% | 10.00% | 100.00% | 42750 | 24750 | 0 | 7500 | 75000 | |
| General administrative department | ||||||||||||
| administrative wages and salaries | 275000 | 20.00% | 10.00% | 40.00% | 30.00% | 100.00% | 55000 | 27500 | 110000 | 82500 | 275000 | |
| office equipement depreciation | 40000 | 32.00% | 16.00% | 15.00% | 37.00% | 100.00% | 12800 | 6400 | 6000 | 14800 | 40000 | |
| administrative property taxes and insurance | 60000 | 0.00% | 0.00% | 0.00% | 100.00% | 100.00% | 0 | 0 | 0 | 60000 | 60000 | |
| Marketing department | ||||||||||||
| marketing wages and salaries | 150000 | 20.00% | 10.00% | 40.00% | 30.00% | 100.00% | 30000 | 15000 | 60000 | 45000 | 150000 | |
| selling expenses | 100000 | 32.00% | 16.00% | 15.00% | 37.00% | 100.00% | 32000 | 16000 | 15000 | 37000 | 100000 | |
Add Answer to:
I need help with any formulas.
1. Assign Overhead Costs to Activity Cost Pools 3 ?...
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%...
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...
he following information relates to overhead costlat chocolates by Jacki for the current year 1 2...
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%...
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....
A manufacturing company uses an activity-based costing system with three activity cost pools. The company has...
A manufacturing company uses an activity-based costing system with three activity cost pools. The company has provided the following data concerning its costs: Costs: Wages and salaries Depreciation 5800,000 120,000 Occupancy 300,000 $1,220,000 Total The distribution of resource consumption across the three activity cost pools is given below: Activity Cost Pools Order Fabricating Processing Other Total Wages and salaries 60% 30% 10% 5% Depreciation 75% 20% 100% 100% 100% Occupancy 80% 10% 10% How much cost, in total, would be...
8. Bossie Corporation uses an activity-based costing system with three activity cost pools. The company has...
8. Bossie Corporation uses an activity-based costing system with
three activity cost pools. The company has provided the following
data concerning its costs and its activity based costing
system:
How much cost, in total, would be allocated in the first-stage
allocation to the Assembly activity cost pool?
A. $229,600
B. $164,000
C. $215,300
D. $202,633
Costs: Wages and salaries Depreciation Utilities $261,000 252,000 143,000 $656,000 Total Total Distribution of resource consumption: Activity Cost Pools Assembly Setting up Other Wages and...
Bossie Corporation uses an activity-based costing system with three activity cost pools. The company has provided...
Bossie Corporation uses an activity-based costing system with three activity cost pools. The company has provided the following data concerning its costs and its activity based costing system: Costs: Wages and salaries $296,000 Depreciation 236,000 Utilities 176,000 Total $708,000 Distribution of resource consumption: Activity Cost Pools Assembly Setting up Other Total Wages and salaries 50% 20% 30% 100% Depreciation 20% 35% 45% 100% Utilities 10% 70% 20% 100% How much cost, in total, would be allocated in the first-stage allocation...
19. Geneva Corporation uses an activity-based costing system with three activity cost pools. The company has...
19. Geneva Corporation uses an activity-based costing system with three activity cost pools. The company has provided the following data concerning its costs: Costs: Wages and salaries ...... Depreciation Occupancy Total $240,000 160,000 140.000 $540,000 The distribution of resource consumption across the three activity cost pools is given below: Activity Cost Pools Order Processing Fabricating 30% 20% Other 25% Total 100% 45% Wages and salaries...... Depreciation.... Occupancy 35% 100% 65% 30% 100% How much cost, in total, would be allocated...
eccles Corporation uses an activity-based costing system with three activity cost pools. The company has provided...
eccles Corporation uses an activity-based costing system with three activity cost pools. The company has provided the following data concerning its costs and its activity based costing system: Costs: Wages and salaries $ 318,000 Depreciation 247,000 Utilities 206,000 Total $ 771,000 Distribution of resource consumption: Activity Cost Pools Assembly Setting Up Other Total Wages and salaries 45% 30% 25% 100% Depreciation 30% 10% 60% 100% Utilities 20% 50% 30% 100% How much cost, in total, would be allocated in the...
Hosley Corporation uses an activity-based costing system with three activity cost pools. The company has provided...
Hosley Corporation uses an activity-based costing system with three activity cost pools. The company has provided the following data concerning its costs: Costs: $360,000 Wages and salaries Depreciation 100,000 120,000 Осcирancy $580,000 Total The distribution of resource consumption across the three activity cost pools is given below: Activity Cost Pools Fabricating Order Processing Other Total 408 10% 100% 50% Wages and salaries 100 Depreciation 45% 10% 45% 35% 100% Осcирancy 5 % 608 How much cost, in total, would be...
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%...
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...
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%...
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....
A manufacturing company uses an activity-based costing system with three activity cost pools. The company has provided the following data concerning its costs: Costs: Wages and salaries Depreciation 5800,000 120,000 Occupancy 300,000 $1,220,000 Total The distribution of resource consumption across the three activity cost pools is given below: Activity Cost Pools Order Fabricating Processing Other Total Wages and salaries 60% 30% 10% 5% Depreciation 75% 20% 100% 100% 100% Occupancy 80% 10% 10% How much cost, in total, would be...
8. Bossie Corporation uses an activity-based costing system with
three activity cost pools. The company has provided the following
data concerning its costs and its activity based costing
system:
How much cost, in total, would be allocated in the first-stage
allocation to the Assembly activity cost pool?
A. $229,600
B. $164,000
C. $215,300
D. $202,633
Costs: Wages and salaries Depreciation Utilities $261,000 252,000 143,000 $656,000 Total Total Distribution of resource consumption: Activity Cost Pools Assembly Setting up Other Wages and...
19. Geneva Corporation uses an activity-based costing system with three activity cost pools. The company has provided the following data concerning its costs: Costs: Wages and salaries ...... Depreciation Occupancy Total $240,000 160,000 140.000 $540,000 The distribution of resource consumption across the three activity cost pools is given below: Activity Cost Pools Order Processing Fabricating 30% 20% Other 25% Total 100% 45% Wages and salaries...... Depreciation.... Occupancy 35% 100% 65% 30% 100% How much cost, in total, would be allocated...
Hosley Corporation uses an activity-based costing system with three activity cost pools. The company has provided the following data concerning its costs: Costs: $360,000 Wages and salaries Depreciation 100,000 120,000 Осcирancy $580,000 Total The distribution of resource consumption across the three activity cost pools is given below: Activity Cost Pools Fabricating Order Processing Other Total 408 10% 100% 50% Wages and salaries 100 Depreciation 45% 10% 45% 35% 100% Осcирancy 5 % 608 How much cost, in total, would be...
Most questions answered within 3 hours.
-
Water can decompose into H2 and O2 via electrolysis. How many
moles of H2 could theoretically...
asked 1 minute ago -
How many moles of oxygen would be consumed during the aerobic
oxidation of one mole of...
asked 17 minutes ago -
Choose an enzyme and tell its function and what substrate it
works on.
asked 15 minutes ago -
You are helping the CFO of a manufacturing company assess
whether the firm should embark on...
asked 11 minutes ago -
a) Given these data for the reaction , write the rate-law
expression.
(Use k for the...
asked 16 minutes ago -
Compare two countries how the culture
of those country enhances or impedes your understanding of the...
asked 17 minutes ago -
Identify the incorrect statement.
A. An increase in mol does not increase the average force of...
asked 19 minutes ago -
In broadcast authentication, a senderaims to send
oneauthentication code for multiple receivers to verify. Explain
why...
asked 19 minutes ago -
A student studying for a vocabulary test knows the meanings of
16 words from a list...
asked 50 minutes ago -
List the most common organic functional groups that function as
acids or bases. Write an equation...
asked 31 minutes ago -
1) A protein is 435 amino acids long, which of the genes below
COULD NOT code...
asked 34 minutes ago -
What do the phenomena of overshadowing, the CS preexposure
effect, and relative validity of cues have...
asked 1 hour ago