In: Accounting
XYZ Manufacturing makes two models of office chairs: regular and deluxe. Summary data for the two products showed the following:
Unit Costs Regular Deluxe
Direct materials $65.00 $105.00
Direct labour ($20 per hour) 10.00 20.00
Manufacturing overhead* 4.80 9.60
* Under the company's current costing, manufacturing overhead is allocated on the basis of direct labour-hours. The overhead for the year follows:
Materials handling $ 300,000
Setups 400,000
General factory overhead 500,000
Total $1,200,000
The following table presents the activity levels that relate to the overhead costs:
Cost Driver Regular Deluxe Total
Number of parts 600,000 900,000 1,500,000
Number of setups 75 50 125
Direct labour-hours 45,000 80,000 125,000
The market price for the regular chairs is $ 104 with expected sales of 40,000 units. The company expects to sell 25,000 deluxe chairs at a selling price of $170 per unit.
Required:
Determine the unit gross profit for the regular chair using both traditional and activity-based costing methods.
Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
XYZ manufacturing | ||||
Calculation of plant wide OH Rate | Regular | Deluxe | Total | Note |
Total Direct Labor Hours | 45,000.00 | 80,000.00 | 125,000.00 | B |
Total overhead | 1,200,000.00 | See A | ||
Plant wide OH Rate | 9.60 | C=B/A | ||
Allocated OH | 432,000.00 | 768,000.00 | 1,200,000.00 | D=C*B |
Workings | Regular | Deluxe | Note | |
Units sold | 40,000.00 | 25,000.00 | E | |
Sell price | 104.00 | 170.00 | F | |
Revenue | 4,160,000.00 | 4,250,000.00 | G=E*F | |
Direct materials per unit | 65.00 | 105.00 | Q | |
Direct materials cost | 2,600,000.00 | 2,625,000.00 | R=E*Q | |
Direct labor per unit | 10.00 | 20.00 | S | |
Direct labor cost | 400,000.00 | 500,000.00 | T=E*S | |
Final Answer | Regular | Deluxe | Note | |
Revenue | 4,160,000.00 | 4,250,000.00 | See G | |
Less: | ||||
Direct Materials | 2,600,000.00 | 2,625,000.00 | See R | |
Direct Labor | 400,000.00 | 500,000.00 | See S | |
Allocated OH | 432,000.00 | 768,000.00 | See D | |
Total costs | 3,432,000.00 | 3,893,000.00 | H | |
Gross Profit | 728,000.00 | 357,000.00 | I=G-H | |
Gross Profit per unit | 18.20 | 14.28 | J=I/E | |
Calculation of ABC rates for overhead | See A | K | L=A/K | |
Activity cost pool | Activity Measure | Cost | Activity usage | ABC rates |
Material Handling | Number of Parts | 300,000.00 | 1,500,000.00 | 0.20 |
Setups | Number of Setups | 400,000.00 | 125.00 | 3,200.00 |
General Factory Overhead | Direct Labor Hours | 500,000.00 | 125,000.00 | 4.00 |
Total Cost assigned | 1,200,000.00 | |||
Regular | See L | M | N=L*N | |
Activity cost pool | Activity Measure | ABC Rates | Activity used | Cost assigned |
Material Handling | Number of Parts | 0.20 | 600,000.00 | 120,000.00 |
Machine Setup | Number of Setups | 3,200.00 | 75.00 | 240,000.00 |
General Factory Overhead | Direct Labor Hours | 4.00 | 45,000.00 | 180,000.00 |
Total Cost assigned | 540,000.00 | |||
Deluxe | See L | O | P=O*L | |
Activity cost pool | Activity Measure | ABC Rates | Activity used | Cost assigned |
Material Handling | Number of Parts | 0.20 | 900,000.00 | 180,000.00 |
Machine Setup | Number of Setups | 3,200.00 | 50.00 | 160,000.00 |
General Factory Overhead | Direct Labor Hours | 4.00 | 80,000.00 | 320,000.00 |
Total Cost assigned | 660,000.00 | |||
Final Answer | Regular | Deluxe | Total | |
Revenue | 4,160,000.00 | 4,250,000.00 | 8,410,000.00 | |
Less: | ||||
Direct Materials |
Related SolutionsXYZ Manufacturing makes two models of beach chairs: regular and deluxe. Summary data for the two...XYZ Manufacturing makes two models of beach chairs: regular and
deluxe. Summary data for the two products showed the following:
Unit Costs
Regular
Deluxe
Direct Materials
$65.00
$105.00
Direct Labor($20/hour)
10.00
20.00
Manufacturing Overhead*
4.80
9.60
* Under the company's current costing, manufacturing overhead is
allocated on the basis of direct labour hours.
The overhead for the year follows:
Materials handling $ 300,000
Setups 400,000
General factory overhead 500,000
Total $1,200,000
The following table presents the activity levels that relate...
Norwegian Furniture Manufacturing makes two models of office chairs: regular and deluxe. Summary data for the...Norwegian Furniture Manufacturing makes two models of office
chairs: regular and deluxe. Summary data for the two products
showed the following:
Unit
Costs
Regular
Deluxe
Direct
materials
$65.00
$105.00
Direct labour ($20 per hour)
10.00
20.00
Manufacturing
overhead*
4.80
9.60
* Under the company's current costing, manufacturing overhead is
allocated on the basis of direct labour-hours. The overhead for the
year follows:
Materials
handling
$ 300,000
Setups
400,000
...
Dartmouth Corporation manufactures two models of office chairs, a standard and a deluxe model. The following...Dartmouth Corporation manufactures two models of office chairs,
a standard and a deluxe model. The following activity and cost
information has been compiled:
Number
of Number
of Number
of
Product Setups Components Direct
Labor Hours
Standard 15 9 300
Deluxe 31 20 235
Overhead
costs $78,200 $89,900
Number of setups and number of components are identified as
activity-cost drivers for overhead. Assuming an activity-based
costing system is used, what is the total amount of overhead costs
assigned to the standard model?
A) $87,500
B) $114,700
C) $80,600
D) $84,050
Comfort Corporation manufactures two models of office chairs, a standard and a deluxe model. The following...Comfort Corporation manufactures two models of office chairs, a
standard and a deluxe model. The following activity and cost
information has been compiled:
Number
of Number
of Number
of
Product Setups Components Direct
Labor Hours
Standard 12 8 255
Deluxe 28 12 245
Overhead
costs $52,000 $78,000
3) Assume a traditional costing system applies the overhead
costs based on direct labor hours. What is the total amount of
overhead costs assigned to the standard model?
A) $65,700
B) $63,600
C) $66,300
D) $66,700
4) Assume a traditional costing system applies the overhead
costs...
Sandy Company manufactures three models of office chairs: economy, basic and deluxe. Product information is provided...Sandy Company manufactures three models of office chairs:
economy, basic and deluxe.
Product information is provided below.
All per unit amounts are based on estimated of 5,000 units of
each item produced and sold.
Economy
Basic
Deluxe
Sales price (per unit)
$150
$210
$320
Variable selling costs (per unit)
$30
$30
$30
Variable manufacturing costs (per unit)
$40
$80
$200
Fixed manufacturing costs** (per unit)
$20
$45
$70
Net income per unit (computed from
amounts above)
$60
$55...
Penty's Fine Furniture manufactures two models of chairs, a standard and a deluxe model. The following...Penty's Fine Furniture manufactures two models of chairs, a
standard and a deluxe model. The following activity and cost
information has been compiled:
Standard
Deluxe
# DL Hours
924
930
# Set Ups
28
62
# Components
5
8
Total estimated manufacturing overhead for the period is
$860,000. Penty's currently uses a volume-based costing system with
direct labor hours as the only cost driver.
a. Calculate the amount of manufacturing overhead allocated to
each product under a traditional volume-based system....
A furniture supplier, Acme Chairs, Inc., manufactures a Basic office chair and a Deluxe office chair....A furniture supplier, Acme Chairs, Inc., manufactures a Basic
office chair and a Deluxe office chair. Each Basic chair costs
$25.00 to manufacture, and each Deluxe office chair costs $40.00 to
manufacture. Acme Chairs wishes to determine the optimal production
quantities per day for each chair model in order to minimize
overall total cost.
The production of each chair requires three types of materials:
Wood, Primer, and Paint. The amount of material available per day
to manufacture the chairs is...
Stein berg company produces commercial printers. Calculate the number of regular models and deluxe models that...
Stein berg company produces commercial printers. Calculate the
number of regular models and deluxe models that must be sold to
break even.
Cindy’s Umbrellas makes two types of patio umbrellas, regular and deluxe. Suppose there is unlimited customer...Cindy’s Umbrellas makes two types of patio umbrellas, regular
and deluxe. Suppose there is unlimited customer demand for each
product. The selling prices and variable costs of each product are
listed below.
Regular Deluxe
Selling price per
unit $40 $110
Variable cost per
unit 20 44
Contribution margin per
unit $20 $66
Required machine
hours/unit 0.4 2.0
Required labor
hours/unit 2.0 6.0
Cindy has only 160,000 machine hours available per year
Cindy has only 600,000 direct labor hours available per year
a. What are Cindy’s objective function and constraint
inequalities?...
Multiple Product Performance Report Case Products manufactures two models of DVD storage cases: regular and deluxe....Multiple Product Performance Report
Case Products manufactures two models of DVD storage cases: regular
and deluxe. Presented is standard cost information for each
model:
Cost Components
Regular
Deluxe
Direct materials
Acrylic sheets
3 sheets x $12 =
$36.00
5 sheets x $12 =
$60.00
Assembly kit
=
5.00
=
5.00
Direct labor
0.5 hour x $20 =
10.00
0.75 hours x $20 =
15.00
Variable overhead
0.5 labor hr. x $5 =
2.50
0.75 labor hrs. x $5 =
3.75...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|