breakeven analysis

4
Breakeven Analysis [Name] Amounts shown in U.S. dollars Sales Sales price per unit 12.50 Sales volume per period (units) 1,000 Total Sales 12,500.00 Variable Costs Commission per unit 2.00 Direct material per unit 2.50 Shipping per unit 1.10 Supplies per unit 0.80 Other variable costs per unit 1.20 Variable costs per unit 7.60 Total Variable Costs 7,600.00 Unit contribution margin 4.90 Gross Margin 4,900.00 Fixed Costs Per Period Administrative costs 1,200.00 Insurance 500.00 Property tax 150.00 Rent 800.00 Other fixed costs 750.00 Total Fixed Costs per period 3,400.00 Net Profit (Loss) 1,500.00 Results: Breakeven Point (units): 694 Sales volume analysis: Sales volume per period (u 0 100 200 300 400 500 600 700 800 900 1,000 Sales price per unit 12.50 12.50 12.50 12.50 12.50 12.50 12.50 12.50 12.50 12.50 12.50 Fixed costs per period 3,400.00 3,400.00 3,400.00 3,400.00 3,400.00 3,400.00 3,400.00 3,400.00 3,400.00 3,400.00 3,400.00 Variable costs 0.00 760.00 1,520.00 2,280.00 3,040.00 3,800.00 4,560.00 5,320.00 6,080.00 6,840.00 7,600.00 Total costs 3,400.00 4,160.00 4,920.00 5,680.00 6,440.00 7,200.00 7,960.00 8,720.00 9,480.00 10,240.00 11,000.00 Total sales 0.00 1,250.00 2,500.00 3,750.00 5,000.00 6,250.00 7,500.00 8,750.00 10,000.00 11,250.00 12,500.00 Net profit (loss) (3,400.00) (2,910.00) (2,420.00) (1,930.00) (1,440.00) (950.00) (460.00) 30.00 520.00 1,010.00 1,500.00 7.60 ; 61% 4.90 ; 39% Unit Contribution Margin Variable costs per unit 2.00 ; 26% 2.50 ; 33% 1.10 ; 14% 0.80 ; 11% 1.20 ; 16% Variable Costs Per Unit Commission per unit Direct material per unit Shipping per unit Supplies per unit Other variable costs per unit

Upload: steven-galford

Post on 16-Sep-2015

213 views

Category:

Documents


0 download

DESCRIPTION

BUSINESS APPRAISAL

TRANSCRIPT

Breakeven Analysis DataBreakeven Analysis[Name]Amounts shown in U.S. dollarsSalesSales price per unit12.50Sales volume per period (units)1,000Total Sales12,500.00Variable CostsCommission per unit2.00Direct material per unit2.50Shipping per unit1.10Supplies per unit0.80Other variable costs per unit1.20Variable costs per unit7.60Total Variable Costs7,600.00Unit contribution margin4.90Gross Margin4,900.00Fixed Costs Per PeriodAdministrative costs1,200.00Insurance500.00Property tax150.00Rent800.00Other fixed costs750.00Total Fixed Costs per period3,400.00Net Profit (Loss)1,500.00Results:Breakeven Point (units):694Sales volume analysis:Sales volume per period (units)01002003004005006007008009001,000Sales price per unit12.5012.5012.5012.5012.5012.5012.5012.5012.5012.5012.50Fixed costs per period3,400.003,400.003,400.003,400.003,400.003,400.003,400.003,400.003,400.003,400.003,400.00Variable costs0.00760.001,520.002,280.003,040.003,800.004,560.005,320.006,080.006,840.007,600.00Total costs3,400.004,160.004,920.005,680.006,440.007,200.007,960.008,720.009,480.0010,240.0011,000.00Total sales0.001,250.002,500.003,750.005,000.006,250.007,500.008,750.0010,000.0011,250.0012,500.00Net profit (loss)(3,400.00)(2,910.00)(2,420.00)(1,930.00)(1,440.00)(950.00)(460.00)30.00520.001,010.001,500.00

Breakeven Analysis Data85

Unit Contribution Margin

Breakeven Analysis Chart23111

Variable Costs Per Unit

Variables3,4003,4000(3,400)3,4004,1601,250(2,910)3,4004,9202,500(2,420)3,4005,6803,750(1,930)3,4006,4405,000(1,440)3,4007,2006,250(950)3,4007,9607,500(460)3,4008,7208,750303,4009,48010,0005203,40010,24011,2501,0103,40011,00012,5001,500

Fixed costs per periodTotal costsTotal salesNet profit (loss)Sales Volume (Units)DollarsBreakeven Analysis Chart

_Example_Shading_SeriesOfficeReady 3.0_Look1

&APage &P