# Breakeven and Profit Volume Cost Analysis - Excel

Document Sample

```					Breakeven Analysis

Data
Fixed cost                               1000                                   Breakeven points
Variable cost                              10                                                  Units            50
Revenue                                    30                                                Dollars \$   1,500.00
Volume(optional)                           65
Volume Analysis @               65 units
Costs               \$    1,650.00
Revenue             \$    1,950.00
Profit (Loss)       \$      300.00

Graph
Units 3500                       Costs          Revenue
0             1000          0
100             2000       3000
3000
50             1500                                                                      100, 3000

2500

2000                                                                                                   100, 2000
Dollars

Costs
Revenues

1500                                                50, 1500

1000       0, 1000

500

0       0, 0
0                      20               40              60                  80            100               120
Units
Cost-Volume Analysis

DATA                             Option 1            Option 2          Option 3            Option 4         Option 5
Fixed cost                              0                  50               100
Variable cost                        0.75                0.25              0.05

Volume(optional)                      200

Breakeven points                    Units            Dollars                         Volume analysis @200 units
Option 1 vs. Option 2                 100                 75                         Options            Total Cost
Option 1 vs. Option 3         142.8571429       107.1428571                          Option 1        \$      150.00
Option 2 vs. Option 3                 250              112.5                         Option 2        \$      100.00
Option 1 vs. Option 4                           #VALUE!                              Option 3        \$      110.00
Option 2 vs. Option 4                           #VALUE!                              Option 4        \$          -
Option 3 vs. Option 4                           #VALUE!                              Option 5        \$          -
Option 1 vs. Option 5                           #VALUE!
Option 2 vs. Option 5                           #VALUE!
Option 3 vs. Option 5                           #VALUE!
Option 4 vs. Option 5                           #VALUE!

Graph
300
Units                    Option 1            Option 2            Option 3            Option 4         Option 5
375
0                   0                  50                 100                0
375              281.25              143.75              118.75                0
250                100                  75                  75
142.8571429        107.1428571                          107.1428571
250                                   112.5            112.5
200                  0                  0                                                         0
0                                     50                                     0
0                                                        100                 0
0                  0                                                                          0
150
0                                     50                                                      0         375
0                                                        100                                  0
375
0                                                                            0 250            0
142.8571429
100        0
Option 1
100
Option 2
50       0                                                                                                                             Option 3
Option 4
Option 5
0       0                                                                                                                 375
0                 50              100                150                 200             250              300   350         400
UNITS

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 66 posted: 1/8/2011 language: English pages: 3
Description: Breakeven and Profit Volume Cost Analysis document sample
How are you planning on using Docstoc?