ABC-Comprehensive Question - Template

docx

School

Grant MacEwan University *

*We aren’t endorsed by this school

Course

322

Subject

Accounting

Date

Apr 3, 2024

Type

docx

Pages

4

Uploaded by DukePuppy4174

Report
1 Comprehensive Question - Activity Based Costing (ABC) Edmonton Wallet Company (EWC) produces 2 types of wallets for the Alberta market. Their best seller is the standard wallet which they sell for $ 200 per unit. The company has been producing this for many years. Last year, the company decided to expand its product line and produce premium wallet. The selling price of this wallet is $ 250 per unit. You are attending your first management meeting where the following operating results for the most recent year were provided to the management committee by the accounting department: Total Standard wallet Premium Wallet Number of units sold 3,500 units 3,000 Units 500 Units Sales $725,000 $600,000 $125,000 Cost of Goods Sold 450,000 360,000 90,000 Gross Profit 275,000 240,000 35,000 Selling and Admin Expenses 245,000 230,000 15,000 Operating income $30,000 $10,000 $20,000 Operating Income per unit $3.33 $40.00 Operating margin 4.13% 1.67% 16% Based on above results it was suggested by a number of senior executives that the company should drop the standard wallet right away and concentrate on producing and selling premium wallet. The president who is not in favor of making such a hasty decision has asked you to take another look at the operating results. When you asked the manager of the accounting department how overhead was determined you were told that it was based on Direct Labor Hours. You were also told that budgeted overhead was $ 180,000 that standard wallets need 2 labor hours to make 1 unit, and it takes 3 labor hours to make 1 unit of premium wallet. Total budgeted direct labor hours were 7,500 hrs. Information regarding the cost for materials and labor for one unit of each product was as given below: Standard wallets Premium wallets Direct Material per unit $60 $90 Direct Labor cost per unit $12 $18 (b) Using the rate computed in (a) and other data from the problem, determine the cost to manufacture one unit of each model. Standard wallets Premium wallets Direct Material per unit $60 $90 Direct Labor cost per unit $12 $18 Overhead allocated 24*2= 24 24*3 = 72 Cost per unit 96 180 You have decided to use ABC for product costing. (a) Using direct labor hours as the base for assigning overhead costs to products, compute the predetermined overhead rate for last year. Predetermined overhead rate = $180,000 / 7,500DLH = $24/DLH
2 You met with all the managers and supervisors and gathered the following information about the actual activity centers and cost drivers in the company: Number of events (Activity) Activity Center & Cost Driver Traceable O/H Costs ($) Total Standard wallet Premium wallet Machine setups (# of setups) $20,800 160 100 60 Quality inspections (# of inspections) 36,000 900 400 500 Purchase orders (# of orders) 9,000 120 84 36 Moldings (# of moldings) 45,000 200 60 140 Shipments (# of shipments) 13,200 60 40 20 Machine related (machine hours) 56,000 7,000 3,000 4,000 Total $180,000 (c) Using activity based costing; determine the total amount of manufacturing overhead cost assignable to each model. Show all computations. Activity Center & Cost Driver Traceable O/H Costs ($) Total events Rate Machine setups (# of setups) $20,800 160 $20,800 / 160 setups = $130/setup Quality inspections (# of inspections) $36,000 900 $40/inspection Purchase orders (# of orders) 9,000 120 $75/order Moldings (# of moldings) 45,000 200 $225/molding Shipments (# of shipments) 13,200 60 $220/shipment Machine related (machine hours) 56,000 7,000 $8/machine hour Total $180,000 STANDARD WALLET Activity Center & Cost Driver Activity consumed Rate Overhead applied Machine setups (# of setups) 100 $130 $13,000 Quality inspections (# of inspections) 400 $40 $16,000 Purchase orders (# of orders) 84 $75 $$6,300 Moldings (# of moldings) 60 $225 $13,500 Shipments (# of shipments) 40 $220 $8,800 Machine related (machine hours) 3000 $8 $24,000 Total Overhead applied $81,600 Overhead cost per unit $81,600/3000 $27.20
3 PREMIUM WALLET Activity Center & Cost Driver Activity consumed Rate Overhead applied Machine setups (# of setups) 60 $130 $7,800 Quality inspections (# of inspections) 500 $40 $20,000 Purchase orders (# of orders) 36 $75 $2,700 Moldings (# of moldings) 140 $225 $31,500 Shipments (# of shipments) 20 $220 $4,400 Machine related (machine hours) 4,000 $8 $32,000 Total Overhead applied $98,400 Overhead cost per unit $98,400/500 $196.80 (d) Using activity based costing; compute the total cost to manufacture one unit of each model. Standard wallets Premium wallets Direct Material per unit $60 $90 Direct Labor cost per unit $12 $18 Overhead cost per unit $27.20 $296.80 Cost per unit $99.20 $304.80 (e) Prepare the new income statement you plan to present at your meeting with the president (use A B C figures). Selling price, Standard = $200 / unit Selling price, Premium = $250 / unit Selling and Adm. Expenses, Standard = $230,000 Selling and Adm Expenses, Premium = $15,000 Total Standard wallets Premium wallets Sales (units) 3,500 units 3,000 Units 500 Units Sales $725,000 $600,00 $250*500= $125,00 Cost of Goods Sold 450,000 297,600 304.50*500 = 152,400 Gross Profit 275,000 302,400 -27,400 Selling and Admin Expenses 245,000 230,000 15,000 Operating income 30,000 72,400 (42,400) Operating Income per unit 8.57 24.13 (84.80) Operating margin 4.13% 12.07% -33.92%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
4 (f) Calculate the operating profit / operating margin per unit for Standard wallet & Premium wallet under the traditional costing system and ABC Standard Traditional costing ABC Selling price $200 $200 Operating profit / margin $3.33 $24.13 Premium Traditional costing ABC Selling price $250 $250 Operating profit / margin $40 ($84.80) (g) How might EWC find the ABC information helpful in managing its business? Premium: Lower cost Increase price --keep/drop Standard: Produce more More accurate cost information Better pricing decisions (h) What strategy, the company should follow from this point forward. Support your recommendations with the data you have calculated. Produce more standard wallets,