jagomart
digital resources
picture1_Excel Sample Sheet 33295 | Breakeven Analysis


 148x       Filetype XLS       File size 0.05 MB       Source: launchny.org


File: Excel Sample Sheet 33295 | Breakeven Analysis
sheet 1 breakeven analysis data breakeven analysis amounts shown in us dollars sales sales price per unit 1250 sales volume per period units 1 000 total sales 12 50000 variable ...

icon picture XLS Filetype Excel XLS | Posted on 10 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Breakeven Analysis Data
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 (units)
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

Sheet 2: Lower price
4
600

Sheet 3: Higher price
6
450

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet breakeven analysis data amounts shown in us dollars sales price per unit volume period units total variable costs commission direct material shipping supplies other contribution margin gross fixed administrative insurance property tax rent net profit loss results point lower higher...

no reviews yet
Please Login to review.