Question
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
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 | $50 | $49 | - | - |
Direct labor cost per case | $10 | $8 | - | - |
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:
1. Prepare a traditional segmented income statement, using a unit-level overhead rate based on direct labor hours.
Peanut Butter | Cashew Butter | Total | |
Direct laborDirect materialsCommon fixed expensesDirect fixed expensesRevenuesVariable overhead | $- Select - | $- Select - | $- Select - |
Less variable expenses: | |||
Common fixed expensesDirect fixed expensesDirect materialsRevenuesSetups | - Select - | - Select - | - Select - |
Common fixed expensesDirect fixed expensesDirect laborSetupsRevenues | - Select - | - Select - | - Select - |
Common fixed expensesDirect fixed expensesRevenuesVariable overhead | - Select - | - Select - | - Select - |
Contribution margin | $fill in the blank 4959df06b008fee_17 | $fill in the blank 4959df06b008fee_18 | $fill in the blank 4959df06b008fee_19 |
Less direct laborLess direct materialsLess common fixed expensesLess direct fixed expensesLess revenuesLess variable overhead | - Select - | - Select - | - Select - |
Product margin | $fill in the blank 4959df06b008fee_24 | $fill in the blank 4959df06b008fee_25 | $fill in the blank 4959df06b008fee_26 |
Less direct laborLess direct materialsLess common fixed expensesLess direct fixed expensesLess revenuesLess variable overhead | - Select - | ||
Operating income | $fill in the blank 4959df06b008fee_29 |
Using this approach, determine whether the cashew butter product line should be kept or dropped.
KeptDropped
2. Prepare an activity-based segmented income statement. Use a minus sign to indicate a negative product margin.
Peanut Butter | Cashew Butter | Total | |
AdvertisingLess common fixed expenses (machine depreciation)Less variable costsPackingReceivingRevenuesRevenues | $Revenues | $Revenues | $Revenues |
AdvertisingLess common fixed expenses (machine depreciation)Less variable costsPackingReceivingRevenues | - Select - | - Select - | - Select - |
Contribution margin | $fill in the blank 754440058f8306c_9 | $fill in the blank 754440058f8306c_10 | $fill in the blank 754440058f8306c_11 |
Less traceable expenses: | |||
AdvertisingCommon fixed expensesRevenuesVariable costs | - Select - | - Select - | - Select - |
Common fixed expensesReceivingRevenuesVariable costs | - Select - | - Select - | - Select - |
Common fixed expensesPackingRevenuesVariable costs | - Select - | - Select - | - Select - |
Product margin | $fill in the blank 754440058f8306c_24 | $fill in the blank 754440058f8306c_25 | $fill in the blank 754440058f8306c_26 |
Less unused activity expenses: | |||
AdvertisingReceivingRevenuesVariable costs | - Select - | ||
AdvertisingPackingRevenuesVariable costs | - Select - | ||
AdvertisingCommon fixed expenses (machine depreciation)RevenuesVariable costs | - Select - | ||
Operating income | $fill in the blank 754440058f8306c_33 |
Using ABC approach, determine whether the cashew butter product line should be kept or dropped.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started