Hallstead Jewelers

Only available on StudyMode
  • Download(s) : 267
  • Published : November 7, 2010
Open Document
Text Preview
Except COGS and Commission which are variable costs, all others are fixed costs. All in thousands of dollars (except sales tickets)
2003 2004 2006
Variable Cost (VC)475545376106
Fixed Cost (FC)325033535011
Average sales ticket price1.607 1.524 1.553
Sales tickets (in nos.)5,341 5,316 6,897
Variable Cost per sales ticket0.9 0.9 0.9
Breakeven Qty4,535 5,001 7,506
Breakeven Sales = Breakeven Qty x average sales ticket price Breakeven Sales7,287 7,621 11,655
Margin of Safety = Sales in excess of the breakeven sales
Sales8,583 8,102 10,711
Margin of Safety (sales dollar)1,296 481 (944)
Margin of Safety (sales tickets)806 315 (609)
The major cause of the increase in breakeven quantities and sales, and the decrease of margin of safety is the sharp increase of fixed cost by nearly 50% in 2006 from 2004, relative to increase of sales tickets (QTY) by 30%. The nominal increase in ticket sales is significant but simply not enough to off set the greater increase in fixed costs. Furthermore, price of goods sold remained stagnant over the same period.

2006 Post price reduction
Average sales ticket price1.553 1.398
Sales tickets (in nos.)6,897 7,500
Net Income(406)(634)
Variable Cost6,106 6,640
Breakeven Qty7,506 9,780
Breakeven Sales11,655 13,669
Sales10,711 10,483
Margin of Safety (sales dollar)(944)(3,186)
The approximate 9% increase in tickets sold will not offset the 10% decrease in price, due to the fact that a reduction in price has far greater impact on contribution per unit than quantity. A far greater percent increase in quantity will be needed to offset the 10% price decrease.

2006 Ex-Commission
Variable Cost6,106 5,570
Variable Cost per sales ticket0.9 0.8
Breakeven Qty7,506 6,723
Breakeven Sales11,655 10,440
Margin of Safety (sales dollar)(944)271
By eliminating commission, the company can lower breakeven volume from 7505 to 6723 (QTY) which is...
tracking img