Question

In: Accounting

XYZ Manufacturing makes two models of office chairs: regular and deluxe. Summary data for the two...

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.

Solutions

Expert Solution

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 Solutions

XYZ 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
ADVERTISEMENT