Home
Home
Insert
Insert
Formulas
Formulas
Data
Data
Review
Review
View
View
Design
Design
Layout
Layout
Format
Format
Format
Format
Design
Design
Undo
Redo
Print
Cut
Copy
Paste
Grow Font
Shrink Font
Bold
Italic
Underline
Strikethrough
Borders
Top Align
Middle Align
Bottom Align
Align Text Left
Center
Align Text Right
Decrease Indent
Increase Indent
Wrap Text
Merge Cells
Accounting Number Format
Percentage
Comma Style
Increase Decimal
Decrease Decimal
Insert
Delete
Format
AutoSum
Fill
Clear
Sort Filter
Find
Format As Table
Table
Picture
Column
Line
Pie
Bar
Area
Scatter
Other Charts
Hyperlink
AutoSum
Financial
Logical
Text
More
Calculation Options
Calculate Now
Calculate Sheet
Sort A to Z
Sort Z to A
Filter
Clear
Reapply
Data Validation
New Comment
Edit Comment
Delete Comment
Show/Hide Comment
Gridlines
Headings
Full Screen
Freeze Panes
Change Chart Type
Switch Row/Column
Select Data
Chart Layouts
Chart Styles
Chart Title
Axis Titles
Legend
Data Labels
Axes
Gridlines
Bring Forward
Send Backward
Bring Forward
Send Backward
Convert to Range
Table Style Options
Modify Style
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
Vader Enterprises
AMOUNTS SHOWN IN U.S. DOLLARS
SALES
SALES PRICE PER UNIT
$150.00
SALES VOLUME PER PERIOD (UNITS)
1,000
TOTAL SALES
$150,000.00
VARIABLE COSTS
COMMISSION PER UNIT
$4.00
DIRECT MATERIAL PER UNIT
$87.00
SHIPPING PER UNIT
$5.00
SUPPLIES PER UNIT
$1.20
OTHER VARIABLE COSTS PER UNIT
$3.40
VARIABLE COSTS PER UNIT
$100.60
BREAKEVEN ANALYSIS
TOTAL VARIABLE COSTS
$100,600.00
UNIT CONTRIBUTION MARGIN
49.40
GROSS MARGIN
$49,400.00
FIXED COSTS PER PERIOD
ADMINISTRATIVE COSTS
$15,000.00
INSURANCE
$12,000.00
PROPERTY TAX
$1,800.00
RENT
$8,000.00
OTHER FIXED COSTS
$750.00
TOTAL FIXED COSTS PER PERIOD
$37,550.00
NET PROFIT (LOSS)
$11,850.00
RESULTS
BREAKEVEN POINT (UNITS):
760.12
SALES VOLUME ANALYSIS:
SALES VOLUME PER PERIOD (UNITS)
0
100
200
300
400
500
600
700
800
900
1,000
SALES PRICE PER UNIT
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
$150.00
FIXED COSTS PER PERIOD
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
$37,550.00
VARIABLE COSTS
$0.00
$10,060.00
$20,120.00
$30,180.00
$40,240.00
$50,300.00
$60,360.00
$70,420.00
$80,480.00
$90,540.00
$100,600.00
TOTAL COSTS
$37,550.00
$47,610.00
$57,670.00
$67,730.00
$77,790.00
$87,850.00
$97,910.00
$107,970.00
$118,030.00
$128,090.00
$138,150.00
TOTAL SALES
$0.00
$15,000.00
$30,000.00
$45,000.00
$60,000.00
$75,000.00
$90,000.00
$105,000.00
$120,000.00
$135,000.00
$150,000.00
NET PROFIT (LOSS)
($37,550.00)
($32,610.00)
($27,670.00)
($22,730.00)
($17,790.00)
($12,850.00)
($7,910.00)
($2,970.00)
$1,970.00
$6,910.00
$11,850.00
BREAKEVEN ANALYSIS
BREAKEVEN ANALYSIS