...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
...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
...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