| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||||||
2 | Users Edit Here | |||||||||||||||||||||||||||
3 | Units (Min) | 1 | Units | Sales | Variable Cost | Fixed Cost | Total Cost | Profit | Break Even Point | |||||||||||||||||||
4 | Units (Incremental Use Smaller Values Narrow Range) | 100 | 1 | $47.00 | $20.00 | $2,000.00 | $2,020.00 | -$1,973.00 | ||||||||||||||||||||
5 | Number of Data Points (Graph Based on 10, Max 500) | 10 | 101 | $4,747.00 | $2,020.00 | $2,000.00 | $4,020.00 | $727.00 | ||||||||||||||||||||
6 | Unit Price | 47 | 201 | $9,447.00 | $4,020.00 | $2,000.00 | $6,020.00 | $3,427.00 | ||||||||||||||||||||
7 | Unit Variable Cost | 20 | 301 | $14,147.00 | $6,020.00 | $2,000.00 | $8,020.00 | $6,127.00 | ||||||||||||||||||||
8 | Contribution Margin Per Unit | 27 | 401 | $18,847.00 | $8,020.00 | $2,000.00 | $10,020.00 | $8,827.00 | ||||||||||||||||||||
9 | Total Fixed Cost | 2,000 | 501 | $23,547.00 | $10,020.00 | $2,000.00 | $12,020.00 | $11,527.00 | ||||||||||||||||||||
10 | 601 | $28,247.00 | $12,020.00 | $2,000.00 | $14,020.00 | $14,227.00 | ||||||||||||||||||||||
11 | Break Even Units | 74.07407407 | 701 | $32,947.00 | $14,020.00 | $2,000.00 | $16,020.00 | $16,927.00 | ||||||||||||||||||||
12 | Break Even Sales | 3481.481481 | 801 | $37,647.00 | $16,020.00 | $2,000.00 | $18,020.00 | $19,627.00 | ||||||||||||||||||||
13 | 901 | $42,347.00 | $18,020.00 | $2,000.00 | $20,020.00 | $22,327.00 | ||||||||||||||||||||||
14 | Break Even Units:74 Break Even Sales:$3,481 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | ||||||||||||||||||||||
15 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
16 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
17 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
18 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
19 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
20 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
21 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
22 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
23 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
24 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
25 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
26 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
27 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
28 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
29 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
30 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
31 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
32 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
33 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
34 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
35 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
36 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
37 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
38 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
39 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
40 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
41 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
42 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
43 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
44 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
45 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
46 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
47 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
48 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
49 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
50 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
51 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
52 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
53 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
54 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
55 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
56 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
57 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
58 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
59 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
60 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
61 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
62 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
63 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
64 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
65 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
66 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
67 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
68 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
69 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
70 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
71 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
72 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
73 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
74 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
75 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
76 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
77 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
78 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
79 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
80 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
81 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
82 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
83 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
84 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
85 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
86 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
87 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
88 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
89 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
90 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
91 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
92 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
93 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
94 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
95 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
96 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
97 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
98 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
99 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 | |||||||||||||||||||||||
100 | $0.00 | $0.00 | $2,000.00 | $2,000.00 | -$2,000.00 |