Hallstead Jewelers Case Study Class: Managerial Accounting Instructor: Robert O’Haver 1. The break even point in units and sales have increased form 2003 to 2004 to 2006 due to the greater increase in fixed costs especially from expanding the business as well as insufficient average sales and unit sales to compensate these changes. The margin of safety has decreased over the years due to the increase in expenses and the lack of gross profit to compensate. Calculations: | | 2003 | 2004 |2006 | |Break-even point in number of sales |$3,197 / $.707 = …show more content…
Both the break even point for sales in dollars and the break even point for number of unit sales has reduced. The fact that this number has lowered is a good sign for the company. This simply means that they would have to sell less number of units or earn lower revenue to reach the break even point. The net income at the end of the statement has increased as well, which again is good. Calculations: Break even $4889/ 0.458 point in sales =$10674.67 thousand dollars Break even $4889/ 0.712 point in number =6866 units of sales tickets Contribution Sales $10711 Margin format -VC $5799 CM $ 4912 Net Income $887 Contribution $4912/10711 Margin Ratio =0.458 Contribution $4912/6897 Margin per unit =$0.712 Price per unit $10711/6897 =$1.55 4. Here it is seen that the opposite of answer 3 happens. Both the point of break even for sales dollars and number of unit sales has gone up. Of course this
d) Break even sales change that would change the profits by the same amount as a reduction in price.
Breakeven Analysis for Product Tylenol Approach 1 - Same price as Tylenol Approach 2a - Cheaper than Tylenol Approach 2b - Cheaper w/lowered trade cost $ $ $ $ Unit Cost (Variable Cost) 0.60 0.60 0.60 0.60 Trade Cost (Selling Price to Retailers) $ 1.69 $ 1.69 $ 1.05 $ 0.70 Fixed Cost (Advertising) 2,000,000 6,000,000 6,000,000 6,000,000 Break-Even Quantity [Fixed Cost/(Trade Cost-Unit Cost)] 1,834,862 5,504,587 13,333,333 60,000,000 Contribution Margin (Unit) 64% 64% 43% 14%
Although the company did show an increased gross profit of $8,255,000 with $6,358,000 less Net Sales in 2013 versus 2012, that increase is due to the reduction in product Cost of Goods Sold by $14,613,000. Since increases in product price will negatively affect sales, one of management’s primary goals is to keep prices stable. This objective is achieved through implementation of cost cutting programs, investing in more efficient equipment, and automation of more steps in the production process.
There would still be a net loss in 2006 due to the increase of break-even point, which increased from $7,505 to $8,640.
The income over the last three years has been fluctuating.. This tells us the company has an initial growth period. Sales also drop between years 7 and 8 and the gross profit margin decreased as well. This may be due to operating expenses. This leads to the prospect of stable future sales. The stakeholders are continuing to back the company and the company does predict sales will remain stable. The modest increase in sales does not show enough to recover without making adjustments to free capital.
To find the break-even point for napkins, you use the same formula. The fixed cost is still $420,000.00. The selling price of napkins is $7.00. The variable cost is $4.50. $7.00 minus $4.50 is $2.50. So then you take $420,000.00 and divide it by $2.50 to find the breaking point of $168,000.00. The company will have to sell $168,000.00 to break even in sales. The margin for safety for napkins is -$48,000.00. This is found by subtracting the actual or expected cost of $120,000.00 by the break-even point of $168,000.00. You can cut sales by $48,000.00 and not sustain a loss.
In our second assumption, instead of using the cost of goods per cases in 1986, we try to use the percentage it counts in the total expenses which is 50.4% and to find the sales needed to break-even. The detail of the calculation is shown in the answer for questions d. The result is that 95,635, a little bit higher than the estimated sales of 90,000.
Fixed costs in 2004 are lower that of 2003 and contribution margin ratio is higher in 2004 than that of 2003. Hence, the break even point is lower for 2004.
In addition to affecting profits by adjusting useful life and depreciation; key ratios will also be affected. The net profit margin can be influenced both ways to fit the purpose of business strategy. It could be increased to make it seem more profitable, or it can be influenced in a negative way to write off as much expenses as possible – if the year held disappointing results – in order to show next year more positively in comparison.
Although, break-even is very helpful for a company to see where they are and how much improvement they can make, the company can never say that it is 100% correct as change in costs or selling price can affect this analysis greatly. Also, in the short-run break-even analysis can show an accurate figure where as in a long run, it will be a lot more difficult. So, break-even analysis is not that accurate.
This question gives students an opportunity to exercise their ability to interpret break-even analyses. Key teaching points should include explaining the preparation of a break-even chart, the interpretation of the break-even volume (938,799 hectoliters [HL]), and the comparison of the break-even volume to the current volume (1,173,000 HL). Another key point is that the chart in case Exhibit 5 is relevant only for the current cost structure of the company—if variable costs increase or the plant expansion is approved, the break-even volume will rise. Finally, students should be aided in understanding that “break-even” refers to operating profit, not free cash flow. The typical use of the break-even chart ignores taxes, investments, and the depreciation tax shield.
As, in this case study as the total revenue is $22,500,000 and the total events is 5000 events therefore revenue per event is $4,500 ($22,500,000/5000), therefore, the contribution margin per event is $1,900 ($4,500 - $2,600) and as the contribution margin ratio is contribution margin/revenue; therefore the contribution margin in this case is 42% ($1,900/$4,500).
The internal sales data showed that the business would need $45,000 in monthly revenue to break even. The sales forecast which have been prepared keep in mind a 65% gross margin, however, based on actual figure for 2009, this target has not been reached, and the forecasted sales have fallen.
Operating profit margin figures in the table above show the return from net sales[13]. However profit margin ratios are high enough for the 3 years, there is a fall from 12.86% to 11.26% during 2011-12. Sales revenue increases with a higher rate than gross profit so there is a poor
This equation is solved for the sales volume in units. c. In the graphical approach, sales revenue and total expenses are graphed. The break-even point occurs at the intersection of the total revenue and total expense lines. 8-2 The term unit contribution margin refers to the contribution that