Hallstead Jewelers Quantitative Analysis Template

Hallstead Jewelers Quantitative Analysis Template -...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Contribution Format Income Statement 2003 2004 2006 Sales $8,583 $8,102 $10,711 Less: Variable Costs COGS 4,326 4,132 5,570 Sales Commissions 429 405 536 Total Variable Costs 4,755 4,537 ## 6,106 Contribution Margin 3,828 3,565 ## 4,605 Less: Fixed Costs Salaries 2,021 2,081 3,215 Advertising 254 250 257 Administrative Expense 418 425 435 Rent 420 420 840 Depreciation 84 84 142 Misc. Expense 53 93 122 Total Fixed Costs 3,250 3,353 ## 5,011 Net Income $578 ## $212 ## $(406) Number of Sales Tickets (given) 5,341 5,316 6,897
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Breakeven in Sales Tickets and in Sales Dollars 2003 2004 2006 Total Units Per Ticket Total Units Per Ticket Total Units Per Ticket Sales $8,583 5,341 $1.61 $8,102 5,316 $1.52 $10,711 6,897 $1.55 Variable Costs $4,755 5,341 $0.89 $4,537 5,316 $0.85 $6,106 6,897 $0.89 Contribution Margin $3,828 5,341 $0.72 $3,565 5,316 $0.67 $4,605 6,897 $0.67 Breakeven In Sales Tickets 2003 2004 2006 Fixed Costs $3,250 $3,353 $5,011 Contribution Margin / Unit $0.72 $0.67 $0.67 Breakeven In Sales Tickets
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 6

Hallstead Jewelers Quantitative Analysis Template -...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online