Koontz Company manufactures two models of industrial components—a Basic model and an Advanced Model. The company considers...

90.2K

Verified Solution

Question

Accounting

Koontz Company manufactures two models of industrialcomponents—a Basic model and an Advanced Model. The companyconsiders all of its manufacturing overhead costs to be fixed andit uses plantwide manufacturing overhead cost allocation based ondirect labor-hours. Koontz’s controller prepared the segmentedincome statement that is shown below for the most recent year (heallocated selling and administrative expenses to products based onsales dollars):

BasicAdvancedTotal
Number of units produced andsold20,00010,00030,000
Sales$3,000,000$2,000,000$5,000,000
Cost of goods sold2,300,0001,350,0003,650,000
Gross margin700,000650,0001,350,000
Selling and administrativeexpenses720,000480,0001,200,000
Net operating income (loss)$(20,000)$170,000$150,000

Direct laborers are paid $20 per hour. Direct materials cost $40per unit for the Basic model and $60 per unit for the Advancedmodel. Koontz is considering a change from plantwide overheadallocation to a departmental approach. The overhead costs in thecompany’s Molding Department would be allocated based onmachine-hours and the overhead costs in its Assembly and PackDepartment would be allocated based on direct labor-hours. Toenable further analysis, the controller gathered the followinginformation:

MoldingAssemble and PackTotal
Manufacturing overheadcosts$787,500$562,500$1,350,000
Direct labor hours:
Basic10,00020,00030,000
Advanced5,00010,00015,000
Machine hours:
Basic12,000-12,000
Advanced10,000-10,000

Required:

3. Koontz’s production manager has suggested usingactivity-based costing instead of either the plantwide ordepartmental approaches. To facilitate the necessary calculations,she assigned the company’s total manufacturing overhead cost tofive activity cost pools as follows:

Activity Cost PoolActivity MeasureManufacturing Overhead
MachiningMachine-hours inMolding$417,500
Assemble and packDirect labor hours in Assembleand Pack282,500
Order processingNumber of customer orders230,000
SetupsSetup hours340,000
Other (unused capacity)80,000
$1,350,000

She also determined that the average order size for the Basicand Advanced models is 400 units and 50 units, respectively. Themolding machines require a setup for each order. One setup hour isrequired for each customer order of the Basic model and three hoursare required to setup for an order of the Advanced model.

The company pays a sales commissions of 5% for the Basic modeland 10% for the Advanced model. Its traceable fixed advertisingcosts include $150,000 for the Basic model and $200,000 for theAdvanced model. The remainder of the company’s selling andadministrative costs are organization-sustaining in nature.

Using the additional information provided by the productionmanager, calculate:

a. An activity rate for each activity cost pool.

b. The total manufacturing overhead cost allocated to the Basicmodel and the Advanced model using the activity-based approach.

c. The total selling and administrative cost traced to the Basicmodel and the Advanced model using the activity-based approach.

4. Using your activity-based cost assignments from requirement3, prepare a contribution format segmented income statement that isadapted from Exhibit 7-8. (Hint: Organize all of the company’scosts into three categories: variable expenses, traceable fixedexpenses, and common fixed expenses.)

5. Using your contribution format segmented income statementfrom requirement 4, calculate the break-even point in dollar salesfor the Advanced model.

Answer & Explanation Solved by verified expert
3.8 Ratings (657 Votes)
a Activity Cost Pool Manufacturing Overhead Activity Measure Volume of Activity Measure Activity Rate Machining 417500 Machine hours in Molding 22000 1898 per MH Assembly and Pack 282500 Direct labor hours and Assemble and Pack 30000 942 per DLH Order Processing 230000 Number of Customer Orders 250 920 per order Setups 340000 Setup    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Transcribed Image Text

Koontz Company manufactures two models of industrialcomponents—a Basic model and an Advanced Model. The companyconsiders all of its manufacturing overhead costs to be fixed andit uses plantwide manufacturing overhead cost allocation based ondirect labor-hours. Koontz’s controller prepared the segmentedincome statement that is shown below for the most recent year (heallocated selling and administrative expenses to products based onsales dollars):BasicAdvancedTotalNumber of units produced andsold20,00010,00030,000Sales$3,000,000$2,000,000$5,000,000Cost of goods sold2,300,0001,350,0003,650,000Gross margin700,000650,0001,350,000Selling and administrativeexpenses720,000480,0001,200,000Net operating income (loss)$(20,000)$170,000$150,000Direct laborers are paid $20 per hour. Direct materials cost $40per unit for the Basic model and $60 per unit for the Advancedmodel. Koontz is considering a change from plantwide overheadallocation to a departmental approach. The overhead costs in thecompany’s Molding Department would be allocated based onmachine-hours and the overhead costs in its Assembly and PackDepartment would be allocated based on direct labor-hours. Toenable further analysis, the controller gathered the followinginformation:MoldingAssemble and PackTotalManufacturing overheadcosts$787,500$562,500$1,350,000Direct labor hours:Basic10,00020,00030,000Advanced5,00010,00015,000Machine hours:Basic12,000-12,000Advanced10,000-10,000Required:3. Koontz’s production manager has suggested usingactivity-based costing instead of either the plantwide ordepartmental approaches. To facilitate the necessary calculations,she assigned the company’s total manufacturing overhead cost tofive activity cost pools as follows:Activity Cost PoolActivity MeasureManufacturing OverheadMachiningMachine-hours inMolding$417,500Assemble and packDirect labor hours in Assembleand Pack282,500Order processingNumber of customer orders230,000SetupsSetup hours340,000Other (unused capacity)80,000$1,350,000She also determined that the average order size for the Basicand Advanced models is 400 units and 50 units, respectively. Themolding machines require a setup for each order. One setup hour isrequired for each customer order of the Basic model and three hoursare required to setup for an order of the Advanced model.The company pays a sales commissions of 5% for the Basic modeland 10% for the Advanced model. Its traceable fixed advertisingcosts include $150,000 for the Basic model and $200,000 for theAdvanced model. The remainder of the company’s selling andadministrative costs are organization-sustaining in nature.Using the additional information provided by the productionmanager, calculate:a. An activity rate for each activity cost pool.b. The total manufacturing overhead cost allocated to the Basicmodel and the Advanced model using the activity-based approach.c. The total selling and administrative cost traced to the Basicmodel and the Advanced model using the activity-based approach.4. Using your activity-based cost assignments from requirement3, prepare a contribution format segmented income statement that isadapted from Exhibit 7-8. (Hint: Organize all of the company’scosts into three categories: variable expenses, traceable fixedexpenses, and common fixed expenses.)5. Using your contribution format segmented income statementfrom requirement 4, calculate the break-even point in dollar salesfor the Advanced model.

Other questions asked by students