ABC-Comprehensive Question - Template
docx
keyboard_arrow_up
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
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,
Related Documents
Related Questions
Please answer quick in 30 minutes.
Prepare a comprehensive report to management highlighting three-year make-or-buy unit cost analysis and recommend appropriate action.
What are the other non-cost variables that would be helpful in this analysis?
As a manufacturing analyst, you are a member of a make-or-buy review team for electric components and work for a multinational company, TransAll Ltd. Your marketing group estimates the following volumes for a component required for motor assembly: Year 1; 300,000 units, Year 2: 500,000 units, Year 3: 200,000 units. A Chinese supplier has quoted the price as Mu(monetary unit) 0.10 per unit with 10 % price decrease per year for year 2 and 3 for the same component. . Shipping and handling costs are expected to be Mu 0.01 per unit for years 1 through 3. Additional inventory handling charges are Mu 0.005 per unit. In addition, purchasing costs are estimated at Mu 20 per purchase order with a purchase order being released every month for the…
arrow_forward
Vaibhav
arrow_forward
Q.Identify the cost hierarchy level for each cost category
arrow_forward
The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is Increasing, and
management requests assistance from you in determining an economical sales and production mix for the coming year. The company
has provided the following data:
Selling
Next year Price
(units) per Unit
$ 26.00
$ 7.50
$ 41.50
$ 11.00
$ 8.80
Demand
Direct
Direct
Product
Materials
Labor
$ 2.10
$ 8.78
$ 3.90
$ 2.70
$ 8.48
Debbie
58,000
5e, 000
43,000
$5.10
Trish
$1.90
Sarah
$7.64
Mike
48, 000
$2.80
Sewing kit
333,000
$4.00
The following additional Informatlon is avallable:
a. The company's plant has a capacity of 92,190 direct labor-hours per year on a single-shift basis. The company's present employees
and equipment can produce all five products.
b. The direct labor rate of $6 per hour is expected to remaln unchanged during the coming year.
C. FIxed manufacturing costs total $600,000 per year. Varlable overhead costs are $3 per direct labor-hour.
d. All of the…
arrow_forward
Denger
arrow_forward
Please help solve all questions show relevant working
arrow_forward
Display Design Incorporated (DDI) is a new company that creates display cases for various types of collectibles. DDI has hired you as an accountant to help measure and evaluate costs. Your first day on the job, they provide you with the following interactive dashboard concerning the prior month's costs.
arrow_forward
Colby Company makes cases for cell phones of all sizes and types for sale through specialty retailers. The company makes a standard
model for the most recent iPhone as well as a deluxe model. Management has designed an ABC system with the following activity cost
pools and activity rates for these models:
Activity Cost Pool
Supporting manufacturing
Order processing
Customer service
Management would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over
the last 12 months:
Number of cases
Number of orders
Direct labour-hours per case
Selling price per case
Direct materials cost per case.
Sales
Costs:
Activity Rates
$2 per direct labour-hour
$19 per order
$60 per customer
Direct materials
Direct labour
Supporting manufacturing
Order processing
Customer service
The company's direct labour rate is $20 per hour.
Required:
Using the company's ABC system, compute the customer margin of Cell City.
Customer margin
Standard
Model…
arrow_forward
Colby Company makes cases for cell phones of all sizes and types for sale through specialty retailers. The company makes a standard
model for the most recent iPhone as well as a deluxe model. Management has designed an ABC system with the following activity cost
pools and activity rates for these models:
Activity Cost Pool
Supporting manufacturing
Order processing
Customer service
Management would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over
the last 12 months:
Number of cases
Number of orders
Direct labour-hours per case
Selling price per case
Direct materials cost per case
The company's direct labour rate is $19 per hour.
Sales
Costs:
Activity Rates
$3 per direct labour-hour
$15 per order
$50 per customer
Direct materials
Direct labour
Supporting manufacturing
Order processing
Customer service
Customer margin
Standard Deluxe
Model
Model
120
35
23
ta ta
OSOF
0.20
$
$
5
35
10
64 $9
$
Required:
Using the…
arrow_forward
not use ai please
arrow_forward
hello, help please
arrow_forward
ABC Pumps is a division of ABC Controls. The division manufactures and sells a pump in a variety of applications.
During the coming year, it projects the following sales:
25,000 units
$17 per unit
The manager is considering producing either this level or 10,000 units more.
The following information is available to help in the decision:
0 Beginning Inventory
25,000 Expected Sales in Units
$17.00 Expected Sales Price per Unit
$6.00 Variable Manufacturing Cost per Unit
$140,000 Total Fixed Manufacturing Overhead
$5.60 Fixed Manufacturing Costs
$4.00 Fixed Manufacturing Costs (Plus 10,000 Units)
$11.60 Total Manufacturing Costs Including Fixed
$10.00 Total Manufacturing Costs Including Fixed (Plus 10,000 Units)
$37,000 Selling and Admin Costs (All Fixed)
Instructions
A. Prepare an absorption costing income statement showing results for both levels of production.
B. Why is income different for the two production levels when the sales levels are the same, either way?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning

Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Related Questions
- Please answer quick in 30 minutes. Prepare a comprehensive report to management highlighting three-year make-or-buy unit cost analysis and recommend appropriate action. What are the other non-cost variables that would be helpful in this analysis? As a manufacturing analyst, you are a member of a make-or-buy review team for electric components and work for a multinational company, TransAll Ltd. Your marketing group estimates the following volumes for a component required for motor assembly: Year 1; 300,000 units, Year 2: 500,000 units, Year 3: 200,000 units. A Chinese supplier has quoted the price as Mu(monetary unit) 0.10 per unit with 10 % price decrease per year for year 2 and 3 for the same component. . Shipping and handling costs are expected to be Mu 0.01 per unit for years 1 through 3. Additional inventory handling charges are Mu 0.005 per unit. In addition, purchasing costs are estimated at Mu 20 per purchase order with a purchase order being released every month for the…arrow_forwardVaibhavarrow_forwardQ.Identify the cost hierarchy level for each cost categoryarrow_forward
- The Walton Toy Company manufactures a line of dolls and a sewing kit. Demand for the company's products is Increasing, and management requests assistance from you in determining an economical sales and production mix for the coming year. The company has provided the following data: Selling Next year Price (units) per Unit $ 26.00 $ 7.50 $ 41.50 $ 11.00 $ 8.80 Demand Direct Direct Product Materials Labor $ 2.10 $ 8.78 $ 3.90 $ 2.70 $ 8.48 Debbie 58,000 5e, 000 43,000 $5.10 Trish $1.90 Sarah $7.64 Mike 48, 000 $2.80 Sewing kit 333,000 $4.00 The following additional Informatlon is avallable: a. The company's plant has a capacity of 92,190 direct labor-hours per year on a single-shift basis. The company's present employees and equipment can produce all five products. b. The direct labor rate of $6 per hour is expected to remaln unchanged during the coming year. C. FIxed manufacturing costs total $600,000 per year. Varlable overhead costs are $3 per direct labor-hour. d. All of the…arrow_forwardDengerarrow_forwardPlease help solve all questions show relevant workingarrow_forward
- Display Design Incorporated (DDI) is a new company that creates display cases for various types of collectibles. DDI has hired you as an accountant to help measure and evaluate costs. Your first day on the job, they provide you with the following interactive dashboard concerning the prior month's costs.arrow_forwardColby Company makes cases for cell phones of all sizes and types for sale through specialty retailers. The company makes a standard model for the most recent iPhone as well as a deluxe model. Management has designed an ABC system with the following activity cost pools and activity rates for these models: Activity Cost Pool Supporting manufacturing Order processing Customer service Management would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over the last 12 months: Number of cases Number of orders Direct labour-hours per case Selling price per case Direct materials cost per case. Sales Costs: Activity Rates $2 per direct labour-hour $19 per order $60 per customer Direct materials Direct labour Supporting manufacturing Order processing Customer service The company's direct labour rate is $20 per hour. Required: Using the company's ABC system, compute the customer margin of Cell City. Customer margin Standard Model…arrow_forwardColby Company makes cases for cell phones of all sizes and types for sale through specialty retailers. The company makes a standard model for the most recent iPhone as well as a deluxe model. Management has designed an ABC system with the following activity cost pools and activity rates for these models: Activity Cost Pool Supporting manufacturing Order processing Customer service Management would like an analysis of the profitability of a particular customer, Cell City, which has ordered the following products over the last 12 months: Number of cases Number of orders Direct labour-hours per case Selling price per case Direct materials cost per case The company's direct labour rate is $19 per hour. Sales Costs: Activity Rates $3 per direct labour-hour $15 per order $50 per customer Direct materials Direct labour Supporting manufacturing Order processing Customer service Customer margin Standard Deluxe Model Model 120 35 23 ta ta OSOF 0.20 $ $ 5 35 10 64 $9 $ Required: Using the…arrow_forward
- not use ai pleasearrow_forwardhello, help pleasearrow_forwardABC Pumps is a division of ABC Controls. The division manufactures and sells a pump in a variety of applications. During the coming year, it projects the following sales: 25,000 units $17 per unit The manager is considering producing either this level or 10,000 units more. The following information is available to help in the decision: 0 Beginning Inventory 25,000 Expected Sales in Units $17.00 Expected Sales Price per Unit $6.00 Variable Manufacturing Cost per Unit $140,000 Total Fixed Manufacturing Overhead $5.60 Fixed Manufacturing Costs $4.00 Fixed Manufacturing Costs (Plus 10,000 Units) $11.60 Total Manufacturing Costs Including Fixed $10.00 Total Manufacturing Costs Including Fixed (Plus 10,000 Units) $37,000 Selling and Admin Costs (All Fixed) Instructions A. Prepare an absorption costing income statement showing results for both levels of production. B. Why is income different for the two production levels when the sales levels are the same, either way?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning

Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,

Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College