ork 1 The following information relates to overhead cost at Chocolates by lacki for the current year. 2 Total cost...
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%...
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 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 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...
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...
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...
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...
PROBLEM 2: Some Corporation has provided the following data on overhead costs from its activity-based cost accounting system: Supervisory wages $ 660,000 Factory supplies $ 280,000 Distribution of Resource Consumption across Activity Cost Pools: Activity Cost Pools Batch Processing Unit Processing Other Total Supervisory wages 20% 70% 10% 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...
Exercise 7-2 First-Stage Allocation in a Service Company (LO2] Help se MobileCash Corporation operates a fleet of armoured cars that make scheduled pickups and deliveries for its customers. The company is implementing an ABC system that has four activity cost pools: Travel, Pickup and Delivery, Customer Service, and Othe The activity measures are kilometres for the Travel cost pool, number of pickups and deliveries for the Pickup and Delivery cost po and number of customers for the Customer Service cost...
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...