Question

In: Accounting

CVP Analysis, Impact of Activity-Based Costing Salem Electronics currently produces two products: a programmable calculator and...

CVP Analysis, Impact of Activity-Based Costing

Salem Electronics currently produces two products: a programmable calculator and a tape recorder. A recent marketing study indicated that consumers would react favorably to a radio with the Salem brand name. Owner Kenneth Booth was interested in the possibility. Before any commitment was made, however, Kenneth wanted to know what the incremental fixed costs would be and how many radios must be sold to cover these costs.

In response, Betty Johnson, the marketing manager, gathered data for the current products to help in projecting overhead costs for the new product. The overhead costs based on 30,000 direct labor hours follow. (The high-low method using direct labor hours as the independent variable was used to determine the fixed and variable costs.)

Fixed Variable
Materials handling $         —       $18,000    
Power —       22,000    
Engineering 100,000       —    
Machine costs 30,000*      80,000    
Inspection 40,000       —    
Setups 60,000       —    
*All depreciation.

The following activity data were also gathered:

Calculators Recorders
Units produced 20,000      20,000    
Direct labor hours 10,000      20,000    
Machine hours 10,000       10,000    
Material moves 120      120    
Kilowatt-hours 1,000      1,000    
Engineering hours 4,000      1,000    
Hours of inspection 700      1,400    
Number of setups 20      40    

Betty was told that a plantwide overhead rate was used to assign overhead costs based on direct labor hours. She was also informed by engineering that if 20,000 radios were produced and sold (her projection based on her marketing study), they would have the same activity data as the recorders (use the same direct labor hours, machine hours, setups, and so on).

Engineering also provided the following additional estimates for the proposed product line:

Prime costs per unit $18
Depreciation on new equipment 18,000

Upon receiving these estimates, Betty did some quick calculations and became quite excited. With a selling price of $26 and just $18,000 of additional fixed costs, only 4,500 units had to be sold to break even. Since Betty was confident that 20,000 units could be sold, she was prepared to strongly recommend the new product line.

Required:

1. Reproduce Betty's break-even calculation using conventional cost assignments.
Variable overhead rate: $_ per direct labor hour
Unit variable cost: $_
Break-even: _units

How much additional profit would be expected under this scenario, assuming that 20,000 radios are sold?
$_

2. Use an activity-based costing approach, and calculate the break-even point and the incremental profit that would be earned on sales of 20,000 units. In your computation for break-even point, round amounts to the nearest cent and round your final answer to the nearest whole unit. In your analysis assume that the expected engineering hours, inspection hours, and setups are realized and that depreciation is a fixed cost.

Break-even point _units
Incremental profit (loss) $_ Loss

Solutions

Expert Solution


Related Solutions

CVP with Activity-Based Costing and Multiple Products Busy-Bee Baking Company produces a variety of breads. The...
CVP with Activity-Based Costing and Multiple Products Busy-Bee Baking Company produces a variety of breads. The plant manager would like to expand production into sweet rolls as well. The average price of a loaf of bread is $1. Anticipated price for a package of sweet rolls is $1.50. Costs for the new level of production are as follows: Cost Driver Unit Variable Cost Level of Cost Driver Loaf of bread $0.65           —           Package of sweet rolls $0.93           —           Setups $300          ...
CVP with Activity-Based Costing and Multiple Products Busy-Bee Baking Company produces a variety of breads. The...
CVP with Activity-Based Costing and Multiple Products Busy-Bee Baking Company produces a variety of breads. The plant manager would like to expand production into sweet rolls as well. The average price of a loaf of bread is $1. Anticipated price for a package of sweet rolls is $1.50. Costs for the new level of production are as follows: Cost Driver Unit Variable Cost Level of Cost Driver Loaf of bread $0.65           —           Package of sweet rolls $0.93           —           Setups $300          ...
4. Explain the additional limiting assumption of using CVP analysis under activity–based costing.
4. Explain the additional limiting assumption of using CVP analysis under activity–based costing.
Alrex company is using an activity-based costing (ABC) system. The company produces and sells two products:...
Alrex company is using an activity-based costing (ABC) system. The company produces and sells two products: Basic and Pro. The company consists of two departments: Production (where all manufacturing activities are taken) and Marketing (which engages in selling and admin activity only). The ABC system includes in unit product costs all costs easily associated with units. In addition, in the ABC system, there are four major indirect activities: Machine Setups, Special Processing, Factory Supervision, and Customer Relation. The prices, direct...
Plaid Manufacturing Co. produces two products: G1 and M1. The company uses an activity based costing...
Plaid Manufacturing Co. produces two products: G1 and M1. The company uses an activity based costing system. The following are the activities, budgeted total cost and cost drivers per activity for the year 20x9: Activity Budgeted Cost Cost Base Cost Base Volume Assembly $861050 # of DL hours 36332 Inspection $669581 # of units 20525 Plaid Manufacturing has budgeted to produce 3,000 units of G1. G1 requires 17790 hours of direct labour. What is the overhead cost per unit for...
Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell...
Handbrain Inc. is considering a change to activity-based product costing. The company produces two products, cell phones and tablet PCs, in a single production department. The production department is estimated to require 4,000 direct labor hours. The total indirect labor is budgeted to be $524,800. Time records from indirect labor employees revealed that they spent 40% of their time setting up production runs and 60% of their time supporting actual production. The following information about cell phones and tablet PCs...
SCS Co. uses activity-based costing in their manufacturing process. The company produces two products, ABC and...
SCS Co. uses activity-based costing in their manufacturing process. The company produces two products, ABC and XYZ. SCS has provided their costing department the following information from this year’s budget relating to the production of these two products: ABC XYZ Units to be produced 4,000 6,000 Machine-hours expected 100 200 Direct labor-hours expected 200 300 Materials handling (number of moves) 60 70 Machine setups (number of setups) 20 15 The following costs are expected to be incurred throughout the year,...
CVP Analysis and Sales Mix (Multiple Products). Sierra Books Incorporated produces two different products with the...
CVP Analysis and Sales Mix (Multiple Products). Sierra Books Incorporated produces two different products with the following monthly data (this is the base case). Text Lecture Notes Total Selling price per unit $100 $12 Variable cost per unit $60 $3 Expected unit sales 21,000 14,000 35,000 Sales mix 60 percent 40 percent 100 percent Fixed costs $750,000 Assume the sales mix remains the same at all levels of sales except for requirement i. Required: Round to the nearest unit of...
Macpherson Limited produces two products: Standard and Deluxe. The company uses an activity-based costing system. Macpherson...
Macpherson Limited produces two products: Standard and Deluxe. The company uses an activity-based costing system. Macpherson produces 8,000 units of Standard and 2,000 units of Deluxe. The company uses two activity cost pools, with estimated total cost and activity as follows: Expected Activity Activity Cost Pool Estimated Cost Standard Deluxe #1 $12,000 500 250 #2 $24,000 400 1,200         What is the cost per unit of Macpherson under activity-based costing? a. $15.00 b. $11.00 c. $16.00 d. $1.75 What is the...
R4 Friends Co. (R4F) uses activity-based costing in their manufacturing process. The company produces two products,...
R4 Friends Co. (R4F) uses activity-based costing in their manufacturing process. The company produces two products, ABC and XYZ. R4F has provided their costing department the following information from this year’s budget relating to the production of these two products: ABC XYZ Units to be produced 40,000 60,000 Machine-hours expected 1,000 2,000 Direct labor-hours expected 2,000 3,000 Materials handling (number of moves) 600 700 Machine setups (number of setups) 200 150 The following costs are expected to be incurred throughout...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT