Premium Essay

Hallstead Jewelers Case Study

In:

Submitted By sidneycastro
Words 2103
Pages 9
Hallstead Jewelers

How has the breakeven point in number of sales tickets (number of customer orders written) and breakeven in sales dollars changed from 2003 to 2004, and to 2006? How has the margin of safety changed? What caused the changes?

The break-even point in the number of sales tickets for 2003, 2004, and 2006 are 4,535, 5,000, and 7,505 respectively. The break-even point in sales dollars for 2003, 2004, and 2006 are $7,287,043, $7,620,696, and $11,655,277 within these years. The margin of safety is the difference between the expected level of sales and break-even sales. Since there is no expectation of sales mentioned in the case report, a constant level of expected sales is assumed. If the expected level of sales remains constant, the break-even sales point will increase as the margin of safety decreases. Within these years, the margin of safety changed from 15%, 6%, to -9%. As shown in Table 1, fixed costs increased along with the break-even sales point and sales did not meet expectations, therefore the company reported a loss in 2006. This was caused by an increase in salaries (larger storage room), administrative expenses, miscellaneous expenses, depreciation (increase in assets from the larger store), and rent expenses (new store); which all caused an increase in fixed costs and break-even sales.

Table 1: Break-even Sales Calculations (thousands of dollars) 2003 2004 2006
Sales $8,583 $8,102 $10,711
Less variable costs:
Cost of goods sold 4,326 4,132 5,570
Commissions 429 405 536
Total variable costs 4,755 4,537 6,106
Contribution margin $3,828 $3,565 $4,605
Contribution margin ratio 0.4460 0.4400 0.4299
Less fixed costs
Salaries 2,021 2,081 3,215
Advertising 254 250 257
Administrative expenses 418 425 435
Rent 420 420 840
Depreciation 84 84 142
Miscellaneous expenses 53 93 122
Total fixed costs $3,250

Similar Documents

Premium Essay

Hallstead Jewelers Case Study

...Hallstead Jewelers Case Study Amanda Dutcher October 6, 2011 1) Fixed Costs=Salaries+Advertising+Administrative Expenses+Rent+Depreciation+Miscellaneous expenses Breakeven=Fixed Costs/Contribution Margin 2003-3230000/377.03=8,566.96 units 2004-3333000/357.68=9,318.39 units 2006-4921000/352.52=13,959.49 units Breakeven$=Breakeven Units*Unit Price 2003-8566.96*845=$7,239,079.12 2004-9318.39*812=$7,566,532.68 2006-13959.49*819=$11,432,822.31 Margin of Safety=Sales-Breakeven Sales 2003=8583000-7239079.12=1343920.88=15.66% 2004=8102000-7566532.68=535467.32=6.61% 2006=10711000-11432822.31=-721822.31=6.74% The breakeven point increases from year to year because of the increases in fixed costs. Because these costs are increasing, the company needs to produce and sell more units in order to cover them. The margin of safety decreases from year to year for the same reason. The change from 2003 to 2004 for breakeven units and the margin of safety were not nearly as significant as the change in 2006. This change in fixed costs is because they moved to a new, larger location causing them to increase dramatically. This caused for not only an increase in rent, but also most likely an increase in the amount of employees. This major increase in fixed costs is what caused the major change in both the breakeven point and the margin of safety. 2) New Price=$737.10 New Sales Volume=14,0000 Sales=$10,319,400 $10,319,400-10,711,000=$-391,600 The decrease in price also causes...

Words: 634 - Pages: 3

Premium Essay

Hallstead Jewllers Case Final Draft

...Due Date: 24th May 24, 2016 Hallstead Jewelers Professor James Reagan Carly Cugine Fernando Morey Perez Olivia Hajas Uday Saha Yineng Zhang Part 1 **In Thousands** Variable Costs | 2003 | 2004 | 2006 | Sales Ticket Units | 5341 | 5316 | 6897 | Average Sales Ticket | 1607 | 1524 | 1556 | Sales | 8583 | 8102 | 10711 | Variable costs | | | | COGS | (4326) | (4132) | (5570) | Commission | (429) | (405) | (536) | Total Variable Cost | (4755) | (4537) | (6106) | Total Contribution Margin | 3828 | 3565 | 4605 | Contribution Margin Per Unit | .7167 | .6706 | .6677 | Fixed Cost | 2003 | 2004 | 2006 | Salaries | 2021 | 2081 | 3215 | Advertising | 254 | 250 | 257 | Administrative Exp | 418 | 425 | 435 | Rent | 420 | 420 | 840 | Depreciation | 84 | 84 | 142 | Misc. | 53 | 93 | 122 | Total | 3250 | 3353 | 5011 | Breakeven analysis: For this part of the case study we used the following formulas to get Breakeven in units and Breakeven sales. The calculations can be found below and are in thousands of dollars. * Breakeven # of tickets = total FC / (selling price per ticket - VC per ticket) * Breakeven in sales dollars = [total FC / (selling price per ticket - VC per ticket)] * (selling price per ticket) or total FC/ CM ratio * Margin of Safety = Expected Sales - Breakeven in Sales Dollars Results | 2003 | 2004 | 2006 | Break even # units | 4,535 | 5,000 | 7473 | Break even sales dollars | 7,323...

Words: 1507 - Pages: 7

Premium Essay

Accounting

...Aussie pies Anna Amphlett and Andrew Ferris has decided to startup a new business in Seattle, U.S.A under the name of Aussie Pies Inc. after their visit to Australia; where they discovered the meat pies, the national snack food of Australia and interested in starting up a business in U.S to produce and sell similar meat pies, The couple has decided to apply for a loan through a contact to establish a new business. Even though bank has tentatively agreed to provide the loan up to one million with 6% interest per year, still loan committee of the bank require business plan including complete set of projected financial statements for the first year of operations, including income statement, statement of cash flow and balance sheet. Please see the detail of the company from below report, The company Anna Amphlett and Andrew Ferris have discovered the meat pies, the national snack food of Australia, during their visit to Sydney. They found Australian consumed vas number of meat pies during sporting events and other occasions and pies are served with ice-cold beer. They decided to explore the possibility of establishing a business in USA. They have decided to locate the first outlet in Pike Place Market, a popular destination for tourist to Seattle in USA, particularly International travelers who curious about other cuisines and willing to try new foods. They have decided to make the pies with high-quality, low fat due to most international travelers belong to...

Words: 8670 - Pages: 35