Artemis Natural Homes |
|
|
|
|
|
|
|
|
|
BreakEven Analysis |
|
|
|
Years 1 to 5 |
|
|
|
($) |
|
|
|
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
|
|
PRODUCT COMPANY |
|
|
|
Units
Sold |
|
1 |
3 |
5 |
7 |
8 |
|
Price per Unit |
|
102,000.00 |
119,000.00 |
119,000.00 |
136,000.00 |
136,000.00 |
|
Revenue |
|
102,000 |
357,000 |
595,000 |
952,000 |
1,088,000 |
|
Operating Expenses |
|
|
|
Variable |
|
4,500 |
5,500 |
6,500 |
7,000 |
7,500 |
|
Fixed |
|
24,200
|
64,500 |
106,700
|
158,200
|
193,400
|
|
Total |
|
28,700
|
70,000 |
113,200
|
165,200
|
200,900
|
|
|
|
|
|
|
|
|
|
Variable
Costs |
|
|
|
Cost
of Goods Sold: |
|
|
Direct Costs per Unit |
|
61,200.00 |
71,400.00 |
71,400.00 |
81,600.00 |
81,600.00 |
|
Total Direct Costs |
|
61,200 |
214,200 |
357,000 |
571,200 |
652,800 |
|
Operating Expenses: Variable
Expenses |
|
4,500 |
5,500 |
6,500 |
7,000 |
7,500 |
|
Total Variable Costs |
|
65,700 |
219,700 |
363,500 |
578,200 |
660,300 |
|
|
|
|
|
Fixed Costs |
|
|
|
Indirect Costs from COGS |
|
12,714
|
43,143
|
81,071
|
121,857
|
150,643
|
|
Operating Expenses: Fixed Cots |
|
24,200 |
64,500 |
106,700 |
158,200 |
193,400 |
|
Total Fixed Costs |
|
36,914
|
107,643
|
187,771
|
280,057
|
344,043
|
|
|
Break-Even Quantity |
|
1.02 |
2.35 |
4.06 |
5.24 |
6.44 |
|
Break-Even Revenue |
|
102,614
|
327,343
|
551,271
|
858,257
|
1,004,343
|
|
Revenue |
|
102,000 |
357,000 |
595,000 |
952,000 |
1,088,000 |
|
|
|
SERVICE COMPANY |
|
|
|
Revenue |
|
102,000 |
357,000 |
595,000 |
952,000 |
1,088,000 |
|
|
|
|
|
Variable Costs |
|
|
|
Direct Costs from COGS |
|
61,200 |
214,200 |
357,000 |
571,200 |
652,800 |
|
Operating Expenses: Variable
Expenses |
|
4,500 |
5,500 |
6,500 |
7,000 |
7,500 |
|
Total Variable Costs |
|
65,700 |
219,700 |
363,500 |
578,200 |
660,300 |
|
|
Fixed Costs |
|
|
Indirect Costs from COGS |
|
12,714
|
43,143
|
81,071
|
121,857
|
150,643
|
|
Operating Expenses: Fixed Cots |
|
24,200 |
64,500 |
106,700 |
158,200 |
193,400 |
|
Total Fixed Costs |
|
36,914
|
107,643
|
187,771
|
280,057
|
344,043
|
|
|
Break-Even Point Revenues |
|
103,727 |
279,887 |
482,609 |
713,254 |
875,190 |
|
|
|
|
|
|
|
|
|
|
|