7. Keep-or-Drop: Traditional Versus Activity-Based Analysis Nutterco, Inc., produces two types of nut butter: peanut butter and cashew butter. Of the two, peanut butter is the more popular. Cashew butter is a specialty line using smaller jars and fewer jars per case. Data concerning the two products follow: Peanut Butter Cashew Butter Unused Capacitya units of Purchaseb Expected sales (in cases) 50,000 10,000 - - Selling price per case $100 $80 - - Direct labor hours 40,000 10,000 - As needed Receiving orders 500 250 250 500 Packing orders 1,000 500 500 250 Material cost per case $55 $49 - - Direct labor cost per case $10 $9 - - Advertising costs $300,000 $60,000 - - aPractical capacity less expected usage (all unused capacity is permanent). bIn some cases, activity capacity must be purchased in steps (whole units). These steps are provided as necessary. The cost per step is the fixed activity rate multiplied by the step units. The fixed activity rate is the expected fixed activity costs divided by practical activity capacity. Annual overhead costs are listed below. These costs are classified as fixed or variable with respect to the appropriate activity driver. Activity Fixeda Variableb Direct labor benefits $0 $200,000 Machine 200,000 250,000 Receiving 200,000 22,500 Packing 100,000 45,000 Total costs $500,000 $517,500 aCosts associated with practical activity capacity. The machine fixed costs are all depreciation with direct labor hours as the driver. bThese costs are for the actual levels of the cost driver. Required: Question Content Area 1. Prepare a traditional segmented income statement, using a unit-level overhead rate based on direct labor hours. Peanut Butter Cashew Butter Total $- Select - $- Select - $- Select - Less variable expenses: - Select - - Select - - Select - - Select - - Select - - Select - - Select - - Select - - Select - Contribution margin $fill in the blank 764693ff9fbbf82_17 $fill in the blank 764693ff9fbbf82_18 $fill in the blank 764693ff9fbbf82_19 - Select - - Select - - Select - Product margin $fill in the blank 764693ff9fbbf82_24 $fill in the blank 764693ff9fbbf82_25 $fill in the blank 764693ff9fbbf82_26 - Select - Operating income $fill in the blank 764693ff9fbbf82_29 Question Content Area Using this approach, determine whether the cashew butter product line should be kept or dropped. Question Content Area 2. Prepare an activity-based segmented income statement. Use a minus sign to indicate a negative product margin. Peanut Butter Cashew Butter Total $- Select - $- Select - $- Select - - Select - - Select - - Select - Contribution margin $fill in the blank 991dc6053fa6f9d_9 $fill in the blank 991dc6053fa6f9d_10 $fill in the blank 991dc6053fa6f9d_11 Less traceable expenses: - Select - - Select - - Select - - Select - - Select - - Select - - Select - - Select - - Select - Product margin $fill in the blank 991dc6053fa6f9d_24 $fill in the blank 991dc6053fa6f9d_25 $fill in the blank 991dc6053fa6f9d_26 Less unused activity expenses: - Select - - Select - - Select - Operating income $fill in the blank 991dc6053fa6f9d_33 Using ABC approach, determine whether the cashew butter product line should be kept or dropped.
7. Keep-or-Drop: Traditional Versus Activity-Based Analysis
Nutterco, Inc., produces two types of nut butter: peanut butter and cashew butter. Of the two, peanut butter is the more popular. Cashew butter is a specialty line using smaller jars and fewer jars per case. Data concerning the two products follow:
Peanut Butter |
Cashew Butter |
Unused Capacitya |
units of Purchaseb |
|
Expected sales (in cases) | 50,000 | 10,000 | - | - |
Selling price per case | $100 | $80 | - | - |
Direct labor hours | 40,000 | 10,000 | - | As needed |
Receiving orders | 500 | 250 | 250 | 500 |
Packing orders | 1,000 | 500 | 500 | 250 |
Material cost per case | $55 | $49 | - | - |
Direct labor cost per case | $10 | $9 | - | - |
Advertising costs | $300,000 | $60,000 | - | - |
aPractical capacity less expected usage (all unused capacity is permanent). | ||||
bIn some cases, activity capacity must be purchased in steps (whole units). These steps are provided as necessary. The cost per step is the fixed activity rate multiplied by the step units. The fixed activity rate is the expected fixed activity costs divided by practical activity capacity. |
Annual
Activity | Fixeda | Variableb |
Direct labor benefits | $0 | $200,000 |
Machine | 200,000 | 250,000 |
Receiving | 200,000 | 22,500 |
Packing | 100,000 | 45,000 |
Total costs | $500,000 | $517,500 |
aCosts associated with practical activity capacity. The machine fixed costs are all |
bThese costs are for the actual levels of the cost driver. |
Required:
Question Content Area
1. Prepare a traditional segmented income statement, using a unit-level overhead rate based on direct labor hours.
Peanut Butter | Cashew Butter | Total | |
|
$- Select - | $- Select - | $- Select - |
Less variable expenses: | |||
|
- Select - | - Select - | - Select - |
|
- Select - | - Select - | - Select - |
|
- Select - | - Select - | - Select - |
Contribution margin | $fill in the blank 764693ff9fbbf82_17 | $fill in the blank 764693ff9fbbf82_18 | $fill in the blank 764693ff9fbbf82_19 |
|
- Select - | - Select - | - Select - |
Product margin | $fill in the blank 764693ff9fbbf82_24 | $fill in the blank 764693ff9fbbf82_25 | $fill in the blank 764693ff9fbbf82_26 |
|
- Select - | ||
Operating income | $fill in the blank 764693ff9fbbf82_29 |
Question Content Area
Using this approach, determine whether the cashew butter product line should be kept or dropped.
Question Content Area
2. Prepare an activity-based segmented income statement. Use a minus sign to indicate a negative product margin.
Peanut Butter | Cashew Butter | Total | |
|
$- Select - | $- Select - | $- Select - |
|
- Select - | - Select - | - Select - |
Contribution margin | $fill in the blank 991dc6053fa6f9d_9 | $fill in the blank 991dc6053fa6f9d_10 | $fill in the blank 991dc6053fa6f9d_11 |
Less traceable expenses: | |||
|
- Select - | - Select - | - Select - |
|
- Select - | - Select - | - Select - |
|
- Select - | - Select - | - Select - |
Product margin | $fill in the blank 991dc6053fa6f9d_24 | $fill in the blank 991dc6053fa6f9d_25 | $fill in the blank 991dc6053fa6f9d_26 |
Less unused activity expenses: | |||
|
- Select - | ||
|
- Select - | ||
|
- Select - | ||
Operating income | $fill in the blank 991dc6053fa6f9d_33 |
Using ABC approach, determine whether the cashew butter product line should be kept or dropped.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps