breakeven analysis

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