Continuing with the company selected in Unit 2, think about the types of financial data that would be included and excluded in differential analysis. Propose which specific revenues and costs should be considered in an evaluation to drop or keep a:
In addition, explain sunk and opportunity costs as they relate to your selected company. Should these costs be considered in differential analysis? Why or why not?
1. The Cement Manufacturing Company sells cements to specialist industries. It sold $20,000 worth of cements in its most recent period with variable costs of $8,000. The Cement Manufacturing Company has fixed expenses of $13,000, resulting in a loss of $1000.
Revenue $20,000
Variable expenses $8,000
Contribution margin = Sales – Variable Costs =
$12000
Fixed expenses $13,000
Net loss $1000
CM ratio/ Percentage = (Sales - Variable expenses)/Sales
= (20000 – 8000)/ 20000 x 100
= 60%
Cement Manufacturing Company Details (Hypothetical Values as required in the question) |
|
Assumptions |
|
Particular |
Amount ($) |
Sales |
20000 |
Less variable Costs |
|
Direct Material |
5000 |
Direct Labor |
3000 |
Contribution Margin (CM) |
12000 |
Part 1 of the question :
Analyzing the differences between the current cost and revenues and the relevant/incremental costs and revenues due to various alternatives is what we call a "differential analysis".
The following costs and revenues are relevant in a decisions to keep a product line or customer :
1. Incremental revenue from alternative/order : Extra sales arising from taking the order
2. Variable Costs : Variable costs are always relevant as they vary with the level of production.
3. Avoidable Fixed Costs : If certain fixed costs exist which although do not vary with the level of production but could be avoided altogether if a particular product line or customer is discontinued or could be avoided by not taking a special order is relevant for our decision making.
4. Semi-Fixed Costs : These are also relevant as orders from new customers may increase the production above a certain level due to which additional cost might have to be incurred.
Part 2 of the question : Whether sunk and opportunity cost should be considered :
1. Sunk Cost : It refers to a cost which has already been incurred and can now no longer be reversed. It is not relevant for decision making and hence it should not form part of the differential analysis because it is a cost incurred in the past and acceptance of a new order or product line will have no effect on it.
2. Opportunity cost : It refers to the cost of choosing from alternatives. It is very much relevant for our decision making and is included in the differential analysis because it represents the profit/money that could have been earned with the resources available had they been invested in another alternative. That means we are letting go of that profit by choosing this particular alternative and hence it is relevant for us.
Example using the data available in the question :
Let's say Cement manufacturing company is considering accepting a new customer who plans on ordering 200 units @ 500$ each. However it requires expansion of space in the factory costing around 5,000$.
Hence we can make the following observations :
1. This expansion cost becomes an avoidable fixed cost as if we do not accept the order, we will not be incurring this cost. It becomes relevant for our differential analysis.
2. The incremental revenue arising from the above order = 200 units*500$ each = 10,000$
3. Incremental profit arising from special order = 10,000$ * 60% (Contribution margin ratio) = 6,000$
4. Actual profit from the new order = Incremental profit - Avoidable fixed costs = 6,000$ - 5,000$ = 1,000$
5. Hence Cement manufacturing company should accept this order as it provides the company a profit of 1,000$.
Note : Since fixed expenses being incurred by the company of 13,000$ are sunk cost, they have not been considered in the differential analysis.
Continuing with the company selected in Unit 2, think about the types of financial data that...
The following annual per unit cost data at an activity level of 10,000 units has been provided below. the company produces and sells only one product. ($ per unit) sales 150.00 direct labor 15.00 direct material 18.00 variable manufacturing overhead 7.50 fixed manufacturing overhead 50.00 variable selling expense 1.50 fixed selling expenses 40.00 fixed administrative expenses 15.00 the relevant range is 8,000-13,000 at the current level of activity, calculate the following: total sales revenue: total contribution margin: total fixed expenses:...
The following annual per unit cost data at an activity level of 10,000 units has been provided below. The company produces and sells only one product. $ Per Unit Sales 150.00 Direct labor Direct material Variable manufacturing overhead 15.00 18.00 7.50 50.00 1.50 Fixed manufacturing overhead Variable selling expenses Fixed selling expenses 40.00 Fixed administrative expenses 15.00 The relevant range is 8,000 - 13,000 units. You must enter your answer in the following format: $x,xxx The company is considering a...
The following annual per unit cost data at an activity level of 10,000 units has been provided below. The company produces and sells only one product 5 Per Unit 150.00 15.00 18.00 7.50 Sales Direct labor Direct material Variable manufacturing overhead Fixed manufacturing overhead Variable selling expenses Fixed selling expenses Fixed administrative expenses 50.00 1.50 40.00 15.00 The relevant range is 8,000 - 13,000 units. You must enter your answer in the following format: $x.xxx The company is considering a...
The following annual per unit cost data at an activity level of 10,000 units has been provided below. The company produces and sells only one product.: $ Per Unit Sales 150.00 Direct labor Direct material 15.00 18.00 7.50 Variable manufacturing overhead Fixed manufacturing overhead Variable selling expenses Fixed selling expenses Fixed administrative expenses 50.00 1.50 40.00 ... 15.00 The relevant range is 8,000 - 13,000 units. You must enter your answer in the following format: $x.xxx At the current level...
CONTINUING A PRODUCT LINE Aquilino Inc. produces two types of rowing machines, the Deluxe and the Regular models. A recent segmented income statement is shown below. Regular Deluxe Total__ Sales $ 160,000 $ 240,000 $ 400,000 Less: Variable costs 120,000 160,000 280,000 Contribution margin 40,000 80,000 120,000 Less: Direct fixed costs 32,000 20,000 52,000 Segment Margin 8,000 60,000 68,000 Common fixed costs (allocated) 10,000 50,000 ...
The following annual per unit cost data at an activity level of 10,000 units has been provided below. The company produces and sells only one product. $ Per Unit 150.00 15.00 18.00 Sales Direct labor Direct material Variable manufacturing overhead Fixed manufacturing overhead Variable selling expenses Fixed selling expenses Fixed administrative expenses 7.50 50.00 1.50 40.00 15.00 The relevant range is 8,000 - 13,000 units. You must enter your answer in the following format: Sx.xxx The company is considering an...
IHG Company produces widgets. The widgets are sold for $2.00 per unit to wholesalers Unit variable cost are 60 % . For the year 2019, management estimates the following revenues and costs Selling expenses Selling expenses SGA expenses V SGA expenses- fix Sales Direct materials 70,000 75,000 30,000 1.100.000 530,000 460,000 Direct labor Manufacturing overhead- variable Manufacturing overhead -fixed 400,000 80,000 380,000 Instructions: (a) Compute the contribution margin ratio. (Round to the nearest full percent.) Compute the break-even point in...
Special Urder Total cost data follow for Glendale Manufacturing Company, which has a normal capacity per period of 8,000 units of product that sell for $60 each. For the foreseeable future, regular sales volume should continue to equal normal capacity. Direct material $100,800 Direct labor 62,400 Variable manufacturing overhead 46,800 Fixed manufacturing overhead (Note 1) 38,400 Selling expense (Note 2) 35,200 Administrative expense (fixed) 15,000 $298,600 Notes: 1. Beyond normal capacity, fixed overhead costs increase $1,800 for each 500 units...
Packer Company, which has only one product, has provided the following data concerning its most recent month of operations: Selling price $ 95 Units in beginning inventory 350 Units produced 2,100 Units sold 1,720 Units in ending inventory 730 Variable cost per unit: Direct materials $ 24 Direct labor $ 21 Variable manufacturing overhead $ 1 Variable selling and administrative $ 13 Fixed costs: Fixed manufacturing overhead $ 52,500 Fixed selling and administrative $ 5,160 The company produces the same...
Lambert, Inc. manufactures several types of accessories. For the year, the knit hats and scarves line had sales of $400,000, variable expenses of $310,000, and fixed expenses of $120,000. Therefore, the knit hats and scarves line had a net loss of $30,000. If Lambert eliminates the knit hats and scarves line, $20,000 of fixed costs will remain. Prepare an analysis showing whether the company should eliminate the knit hats and scarves line. Eliminate Sales Variable costs Contribution margin Fixed costs...