Part 6 – Activity Based Cost (10 marks) A company reports the following information about its...

Part 6 – Activity Based Cost

A company reports the following information about its indirect costs:

1.   Total indirect costs of $3,000,000 for the next year.
2.   There two products: Product A and Product B.
3.   Direct labour hours for Product A is 40,000 and Product B is 60,000
4.   The company’s accountant has suggested an alternative to the traditional allocation of indirect overhead based on direct labour hours. The accountant suggested the following:
a.   Indirect costs can be broken down into supervisory wages $500,000, machine set up $250,000, machinery operating costs including depreciation $1,250,000, engineering changes $500,000, quality inspection costs $250,000, shipping costs $250,0000.
b.   Activity drivers are supervisory wages (direct labour hours), machine set up (2,500 set up hours), machinery operating (12,500 machine hours), engineering changes (2,500 engineering hours), inspection (2,500 inspection hours), shipping (5,000 shipments)

Driver   Product A   Product B
DLH   40,000   60,000
Machine set up   750   1,750
Machine operating   3,500   9.000
Engineering changes   1,000   1,500
Inspections   500   2,000
Shipping Units   1,500   3,500

Questions:

A.   Under the traditional allocation method, what is the amount of indirect cost allocated to Product A and Product B?
____________________________________________________________
B.   Under the Activity Based Accounting (ACB) method, what is the amount of indirect cost allocated to Product A and Product B?
____________________________________________________________
C.   Would the ABC method add value to the company, Yes or No and Why or Why Not?
____________________________________________________________
D.   The accountant alternatively suggested a “standard costing system” for indirect costs. This would be a set / fixed amount for the year for each unit of Product A or Product B shipped. What is the standard cost per unit for Product A and Product B assuming a traditional cost allocation approach?
____________________________________________________________

Expert Solution

A. Indirect Cost Allocation Using Traditional Costing Method:-

Particulars	Allocation	Product A	Product B	Total
Supervisory Costs($)	A= $500000/100000 40000 B=$500000/10000060000	200000	300000	500000
Machine Set up($)	A=$250000/10000040000 B=$250000/10000060000	100000	150000	250000
Machinery operating Costs-Depreciation($)	A=$1250000/10000040000 B=$1250000/10000060000	500000	750000	1250000
Engineering Costs ($)	A=$500000/10000040000 B=$500000/10000060000	200000	300000	500000
Quality Inspection Costs($)	A=$250000/10000040000 B=$250000/10000060000	100000	150000	250000
Shipping Costs($)	A=$250000/10000040000 B=$250000/10000060000	100000	150000	250000
Total Indirect Costs($)		1200000	1800000	3000000

B. Indirect Cost Allocation Using Activity Based Costing:-

Particulars	Cost Driver	Costs	Product A	Product B
Supervisory Costs($)	Labour Hours 40000:60000	500000	500000/100000 *40000 =200000	500000/100000 *60000 =300000
Machine Set up($)	Machine Set up 750:1750	250000	250000/2500*750 =75000	250000/2500*1750 =175000
Machinery operating Costs-Depreciation($)	Machine Operating 3500:9000	1250000	1250000/12500 *3500 =350000	1250000/12500 *9000 =900000
Engineering Costs ($)	Engineering Changes 1000:1500	500000	500000/2500 *1000 200000	500000/2500 *1500 =300000
Quality Inspection Costs($)	Inspections 500:2000	250000	250000/2500*500 =50000	250000/2500*2000 =200000
Shipping Costs($)	Shipping Units 1500:3500	250000	250000/5000*1500 =75000	250000/5000*3500 175000
Total Indirect Costs		3000000	950000	2050000

C.

Yes,

ABC Costing provides a more accurate method of product/service costing, leading to more accurate pricing decisions. It increases understanding of overheads, activity drivers and makes costly and non-value added activities more visible, allowing managers to reduce or eliminate them. ABC analysis enables effective challenge of operating costs to find better way of allocating & eliminating overheads.

It also enables improved product and customer profitability analysis. It supporst performance management techniques such as continuous improvements and scorecards.

D

Since there is no information about the units produced during the year in the question, we will calculate standard cost per labour hour because whole calculations are based upon the labour hours. The total indirect costs for the year is $3000000 and as per Traditional Costing Method, all expenses are to be charged at direct labour hours. Thus. the indirect costs of $3000000 will be allocated based on direct labour hours of 100000

Standard Rate for Allocation will be :- $3000000/100000 hours = $30 per hour

ekkarill92 answered 1 year ago

Felix & Co. reports the following information about its unit sales and cost of sales. Period...

Felix & Co. reports the following information about its unit sales and cost of sales. Period Units Sold Cost of Sales Period Units Sold Cost of Sales 1 0 $ 2,640 6 2,140 $ 6,492 2 540 3,612 7 2,540 7,212 3 940 4,332 8 2,940 7,932 4 1,340 5,052 9 3,340 8,652 5 1,740 5,772 10 3,740 9,372 Hint: (Draw an estimated line of cost behavior using a scatter diagram offline.) Complete the below table to calculate the fixed...

Compute the ABC rates based on the following information: Activity Cost Pool (a) Estimated Overhead Cost...

Compute the ABC rates based on the following information: Activity Cost Pool (a) Estimated Overhead Cost (b) Expected Activity Labor related........................... $ 5,200 800 DLHs Machine related....................... 1,500 2,000 MHs Machine setups........................ 4,200 100 setups Production orders..................... 1,800 50 orders Product testing........................ 4,800 200 tests Packaging............................... 7,000 500 packages General factory........................ 108,800 800 DLHs Compute the single overall predetermined overhead rate based entirely on direct labor-hours: Compute the cost for completing 100,000 widgets if the direct materials cost was $45,000...

Ruby Company follows activity-based budgeting. From the information given below, calculate the total activity cost of...

Ruby Company follows activity-based budgeting. From the information given below, calculate the total activity cost of the company. Activity description Activity driver Cost per unit of driver Amount of driver Processing mail Number of clients $120 $75 Paying bills Number of bills $ 2.5 $10,000 Investigating Number of new hires $110 $75 Writing reports Number of clients $150 $75 a. $52,500 b. $52,800 c. $53,500 d. $53,200

The following items (partial list) are associated with a functional-based cost accounting information system, an activity-based...

The following items (partial list) are associated with a functional-based cost accounting information system, an activity-based cost accounting information system, or both: ? a. materials purchasing cost incurrence b. assignment of purchasing cost to products using direct labor hours c. assignment of purchasing cost using number of purchase orders d. usage of direct materials e. direct materials cost assigned to products using direct tracing f. materials handling cost incurrence g. materials handling cost assigned using direct labor hours h. materials...

Define Activity Based Cost and its impact on profitbility.

Exercise 6-9 Part 1a Cool Sky reports the following costing data on its product for its...

Exercise 6-9 Part 1a Cool Sky reports the following costing data on its product for its first year of operations. During this first year, the company produced 40,000 units and sold 32,000 units at a price of $140 per unit. Manufacturing costs Direct materials per unit $ 60 Direct labor per unit $ 22 Variable overhead per unit $ 8 Fixed overhead for the year $ 480,000 Selling and administrative costs Variable selling and administrative cost per unit $ 9...

Kam Company has the following cost pools, drivers, and pool rates for its activity-based costing system:...

Kam Company has the following cost pools, drivers, and pool rates for its activity-based costing system: Pool Driver Rate Design design hours $2,200 per design hour Creation machine hours $80 per MH Ordering of Parts number of orders $300 per order Al Company placed and order with Kam Company for 2,000 units of a custom product. The order required 15 design hours, 900 machine hours, and one parts order. How much overhead cost is assigned to Al's order using activity-based...

Hampton Company reports the following information for its recent calendar year.

Hampton Company reports the following information for its recent calendar year. Income Statement Data Selected Year-End Balance Sheet Data Sales $ 78,000 Accounts receivable increase $ 8,000 Expenses: Inventory decrease 2,000 Cost of goods sold 38,000 Salaries payable increase 700 Salaries expense 14,000 Depreciation expense 8,000 Net income $ 18,000 Required:Prepare...

Activity-Based Environmental Cost Assignments Pinter Company had the following environmental activities and product information: 1. Environmental...

Activity-Based Environmental Cost Assignments Pinter Company had the following environmental activities and product information: 1. Environmental activity costs Activity Costs Design products (to reduce pollution) $ 129,600 Test for contamination 230,400 Treat toxic waste 720,000 Operate pollution control equipment 576,000 2. Driver data Solvent X Solvent Y Design hours 2,900 2,500 Testing hours 5,100 9,300 Pounds of waste 600 17,400 Machine hours 2,900 69,100 3. Other production data Solvent X Solvent Y Nonenvironmental production costs $1,692,000 $4,068,000 Units produced 360,000 ...

The following budgeted information is available for Zeta Company: Activity Budgeted Cost Activity Driver Consumption of...

The following budgeted information is available for Zeta Company: Activity Budgeted Cost Activity Driver Consumption of Drivers for Zeta’s Product Lines Total Activity Driver Product A Product B Processing & Testing Developing test programs $400,000 Engineering hours 10,000 2,500 7,500 Making probe cards 58,750 Development hours 4,000 400 3,600 Testing products 300,000 Test hours 20,000 2,000 18,000 Setups 40,000 Number of batches 100 55 45 Engineering design 80,000 Number of change orders 60 9 51 Handling lots 90,000 Number of...

Question