|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sales Forecast Year 1-3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Prepared by: |
Company Name: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sam Miller |
Aviator Inc |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Growth Rate Year 1 to Year 2: |
10.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Growth Rate Year 2 to Year 3: |
10.00% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Product
Lines |
Year 1 Totals |
Sept |
Oct |
Nov |
Dec |
Jan |
Feb |
Mar |
Apr |
May |
June |
July |
Aug |
Year 2 Totals |
Category
Breakdown |
Category / Total |
Sept |
Oct |
Nov |
Dec |
Jan |
Feb |
Mar |
Apr |
May |
June |
July |
Aug |
Year 3 Totals |
Category
Breakdown |
Category / Total |
T1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
45 Sold |
540 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
594 |
|
17.3% |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
653 |
|
0.0% |
Total Sales |
$
139,860,000 |
12,820,500 |
12,820,500 |
12,820,500 |
12,820,500 |
12,820,500 |
12,820,500 |
12,820,500 |
12,820,500 |
12,820,500 |
12,820,500 |
12,820,500 |
12,820,500 |
$
153,846,000 |
100.0% |
10.6% |
14,102,550 |
14,102,550 |
14,102,550 |
14,102,550 |
14,102,550 |
14,102,550 |
14,102,550 |
14,102,550 |
14,102,550 |
14,102,550 |
14,102,550 |
14,102,550 |
$
169,230,600 |
100.0% |
0.0% |
Total COGS |
$
90,818,182 |
8,325,000 |
8,325,000 |
8,325,000 |
8,325,000 |
8,325,000 |
8,325,000 |
8,325,000 |
8,325,000 |
8,325,000 |
8,325,000 |
8,325,000 |
8,325,000 |
$
99,900,000 |
64.9% |
10.6% |
9,157,500 |
9,157,500 |
9,157,500 |
9,157,500 |
9,157,500 |
9,157,500 |
9,157,500 |
9,157,500 |
9,157,500 |
9,157,500 |
9,157,500 |
9,157,500 |
$
109,890,000 |
64.9% |
0.0% |
Total Margin |
$
49,041,818 |
4,495,500 |
4,495,500 |
4,495,500 |
4,495,500 |
4,495,500 |
4,495,500 |
4,495,500 |
4,495,500 |
4,495,500 |
4,495,500 |
4,495,500 |
4,495,500 |
$
53,946,000 |
35.1% |
10.6% |
4,945,050 |
4,945,050 |
4,945,050 |
4,945,050 |
4,945,050 |
4,945,050 |
4,945,050 |
4,945,050 |
4,945,050 |
4,945,050 |
4,945,050 |
4,945,050 |
$
59,340,600 |
35.1% |
0.0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T2 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
45 Sold |
540 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
50 |
594 |
|
17.3% |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
54 |
653 |
|
0.0% |
Total Sales |
$
177,660,000 |
16,285,500 |
16,285,500 |
16,285,500 |
16,285,500 |
16,285,500 |
16,285,500 |
16,285,500 |
16,285,500 |
16,285,500 |
16,285,500 |
16,285,500 |
16,285,500 |
$
195,426,000 |
100.0% |
13.4% |
17,914,050 |
17,914,050 |
17,914,050 |
17,914,050 |
17,914,050 |
17,914,050 |
17,914,050 |
17,914,050 |
17,914,050 |
17,914,050 |
17,914,050 |
17,914,050 |
$
214,968,600 |
100.0% |
0.0% |
Total COGS |
$
115,363,636 |
10,575,000 |
10,575,000 |
10,575,000 |
10,575,000 |
10,575,000 |
10,575,000 |
10,575,000 |
10,575,000 |
10,575,000 |
10,575,000 |
10,575,000 |
10,575,000 |
$
126,900,000 |
64.9% |
13.4% |
11,632,500 |
11,632,500 |
11,632,500 |
11,632,500 |
11,632,500 |
11,632,500 |
11,632,500 |
11,632,500 |
11,632,500 |
11,632,500 |
11,632,500 |
11,632,500 |
$
139,590,000 |
64.9% |
0.0% |
Margin |
$
62,296,364 |
5,710,500 |
5,710,500 |
5,710,500 |
5,710,500 |
5,710,500 |
5,710,500 |
5,710,500 |
5,710,500 |
5,710,500 |
5,710,500 |
5,710,500 |
5,710,500 |
$
68,526,000 |
35.1% |
13.4% |
6,281,550 |
6,281,550 |
6,281,550 |
6,281,550 |
6,281,550 |
6,281,550 |
6,281,550 |
6,281,550 |
6,281,550 |
6,281,550 |
6,281,550 |
6,281,550 |
$
75,378,600 |
35.1% |
0.0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
X |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
30 Sold |
360 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
396 |
|
11.5% |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
436 |
|
0.0% |
Total Sales |
$
129,240,000 |
11,847,000 |
11,847,000 |
11,847,000 |
11,847,000 |
11,847,000 |
11,847,000 |
11,847,000 |
11,847,000 |
11,847,000 |
11,847,000 |
11,847,000 |
11,847,000 |
$
142,164,000 |
100.0% |
9.8% |
13,031,700 |
13,031,700 |
13,031,700 |
13,031,700 |
13,031,700 |
13,031,700 |
13,031,700 |
13,031,700 |
13,031,700 |
13,031,700 |
13,031,700 |
13,031,700 |
$
156,380,400 |
100.0% |
0.0% |
Total COGS |
$
83,922,078 |
7,692,857 |
7,692,857 |
7,692,857 |
7,692,857 |
7,692,857 |
7,692,857 |
7,692,857 |
7,692,857 |
7,692,857 |
7,692,857 |
7,692,857 |
7,692,857 |
$
92,314,286 |
64.9% |
9.8% |
8,462,143 |
8,462,143 |
8,462,143 |
8,462,143 |
8,462,143 |
8,462,143 |
8,462,143 |
8,462,143 |
8,462,143 |
8,462,143 |
8,462,143 |
8,462,143 |
$
101,545,714 |
64.9% |
0.0% |
Margin |
$
45,317,922 |
4,154,143 |
4,154,143 |
4,154,143 |
4,154,143 |
4,154,143 |
4,154,143 |
4,154,143 |
4,154,143 |
4,154,143 |
4,154,143 |
4,154,143 |
4,154,143 |
$
49,849,714 |
35.1% |
9.8% |
4,569,557 |
4,569,557 |
4,569,557 |
4,569,557 |
4,569,557 |
4,569,557 |
4,569,557 |
4,569,557 |
4,569,557 |
4,569,557 |
4,569,557 |
4,569,557 |
$
54,834,686 |
35.1% |
0.0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
XR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
50 Sold |
600 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
55 |
660 |
|
19.2% |
61 |
61 |
61 |
61 |
61 |
61 |
61 |
61 |
61 |
61 |
61 |
61 |
726 |
|
0.0% |
Total Sales |
255000000 |
23,375,000 |
23,375,000 |
23,375,000 |
23,375,000 |
23,375,000 |
23,375,000 |
23,375,000 |
23,375,000 |
23,375,000 |
23,375,000 |
23,375,000 |
23,375,000 |
$
280,500,000 |
100.0% |
19.3% |
25,712,500 |
25,712,500 |
25,712,500 |
25,712,500 |
25,712,500 |
25,712,500 |
25,712,500 |
25,712,500 |
25,712,500 |
25,712,500 |
25,712,500 |
25,712,500 |
$
308,550,000 |
100.0% |
0.0% |
Total COGS |
$
165,584,416 |
15,178,571 |
15,178,571 |
15,178,571 |
15,178,571 |
15,178,571 |
15,178,571 |
15,178,571 |
15,178,571 |
15,178,571 |
15,178,571 |
15,178,571 |
15,178,571 |
$
182,142,857 |
64.9% |
19.3% |
16,696,429 |
16,696,429 |
16,696,429 |
16,696,429 |
16,696,429 |
16,696,429 |
16,696,429 |
16,696,429 |
16,696,429 |
16,696,429 |
16,696,429 |
16,696,429 |
$
200,357,143 |
64.9% |
0.0% |
Margin |
$
89,415,584 |
8,196,429 |
8,196,429 |
8,196,429 |
8,196,429 |
8,196,429 |
8,196,429 |
8,196,429 |
8,196,429 |
8,196,429 |
8,196,429 |
8,196,429 |
8,196,429 |
$
98,357,143 |
35.1% |
19.3% |
9,016,071 |
9,016,071 |
9,016,071 |
9,016,071 |
9,016,071 |
9,016,071 |
9,016,071 |
9,016,071 |
9,016,071 |
9,016,071 |
9,016,071 |
9,016,071 |
$
108,192,857 |
35.1% |
0.0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
XL |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
60 Sold |
720 |
66 |
66 |
66 |
66 |
66 |
66 |
66 |
66 |
66 |
66 |
66 |
66 |
792 |
|
23.1% |
73 |
73 |
73 |
73 |
73 |
73 |
73 |
73 |
73 |
73 |
73 |
73 |
871 |
|
0.0% |
Total Sales |
$
396,000,000 |
36,300,000 |
36,300,000 |
36,300,000 |
36,300,000 |
36,300,000 |
36,300,000 |
36,300,000 |
36,300,000 |
36,300,000 |
36,300,000 |
36,300,000 |
36,300,000 |
$
435,600,000 |
100.0% |
29.9% |
39,930,000 |
39,930,000 |
39,930,000 |
39,930,000 |
39,930,000 |
39,930,000 |
39,930,000 |
39,930,000 |
39,930,000 |
39,930,000 |
39,930,000 |
39,930,000 |
$
479,160,000 |
100.0% |
0.0% |
Total COGS |
$
257,142,857 |
23,571,429 |
23,571,429 |
23,571,429 |
23,571,429 |
23,571,429 |
23,571,429 |
23,571,429 |
23,571,429 |
23,571,429 |
23,571,429 |
23,571,429 |
23,571,429 |
$
282,857,143 |
64.9% |
29.9% |
25,928,571 |
25,928,571 |
25,928,571 |
25,928,571 |
25,928,571 |
25,928,571 |
25,928,571 |
25,928,571 |
25,928,571 |
25,928,571 |
25,928,571 |
25,928,571 |
$
311,142,857 |
64.9% |
0.0% |
Margin |
$
138,857,143 |
12,728,571 |
12,728,571 |
12,728,571 |
12,728,571 |
12,728,571 |
12,728,571 |
12,728,571 |
12,728,571 |
12,728,571 |
12,728,571 |
12,728,571 |
12,728,571 |
$
152,742,857 |
35.1% |
29.9% |
14,001,429 |
14,001,429 |
14,001,429 |
14,001,429 |
14,001,429 |
14,001,429 |
14,001,429 |
14,001,429 |
14,001,429 |
14,001,429 |
14,001,429 |
14,001,429 |
$
168,017,143 |
35.1% |
0.0% |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
XLR |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
30 Sold |
360 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
33 |
396 |
|
11.5% |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
36 |
436 |
|
0.0% |
Total Sales |
$
225,000,000 |
20,625,000 |
20,625,000 |
20,625,000 |
20,625,000 |
20,625,000 |
20,625,000 |
20,625,000 |
20,625,000 |
20,625,000 |
20,625,000 |
20,625,000 |
20,625,000 |
$
247,500,000 |
100.0% |
17.0% |
22,687,500 |
22,687,500 |
22,687,500 |
22,687,500 |
22,687,500 |
22,687,500 |
22,687,500 |
22,687,500 |
22,687,500 |
22,687,500 |
22,687,500 |
22,687,500 |
$
272,250,000 |
100.0% |
0.0% |
Total COGS |
$
146,103,896 |
13,392,857 |
13,392,857 |
13,392,857 |
13,392,857 |
13,392,857 |
13,392,857 |
13,392,857 |
13,392,857 |
13,392,857 |
13,392,857 |
13,392,857 |
13,392,857 |
$
160,714,286 |
64.9% |
17.0% |
14,732,143 |
14,732,143 |
14,732,143 |
14,732,143 |
14,732,143 |
14,732,143 |
14,732,143 |
14,732,143 |
14,732,143 |
14,732,143 |
14,732,143 |
14,732,143 |
$
176,785,714 |
64.9% |
0.0% |
Margin |
$
78,896,104 |
7,232,143 |
7,232,143 |
7,232,143 |
7,232,143 |
7,232,143 |
7,232,143 |
7,232,143 |
7,232,143 |
7,232,143 |
7,232,143 |
7,232,143 |
7,232,143 |
$
86,785,714 |
35.1% |
17.0% |
7,955,357 |
7,955,357 |
7,955,357 |
7,955,357 |
7,955,357 |
7,955,357 |
7,955,357 |
7,955,357 |
7,955,357 |
7,955,357 |
7,955,357 |
7,955,357 |
$
95,464,286 |
35.1% |
0.0% |
Total Units Sold |
3120 |
286 |
286 |
286 |
286 |
286 |
286 |
286 |
286 |
286 |
286 |
286 |
286 |
3,432 |
|
|
315 |
315 |
315 |
315 |
315 |
315 |
315 |
315 |
315 |
315 |
315 |
315 |
3,775 |
|
|
Total Sales |
$
1,322,760,000 |
$
121,253,000 |
$
121,253,000 |
$
121,253,000 |
$
121,253,000 |
$
121,253,000 |
$
121,253,000 |
$
121,253,000 |
$
121,253,000 |
$
121,253,000 |
$
121,253,000 |
$
121,253,000 |
$
121,253,000 |
$
1,455,036,000 |
|
|
$
133,378,300 |
$
133,378,300 |
$
133,378,300 |
$
133,378,300 |
$
133,378,300 |
$
133,378,300 |
$
133,378,300 |
$
133,378,300 |
$
133,378,300 |
$
133,378,300 |
$
133,378,300 |
$
133,378,300 |
$
1,600,539,600 |
|
|
Total Cost of Goods Sold |
$
858,935,065 |
$
78,735,714 |
$
78,735,714 |
$
78,735,714 |
$
78,735,714 |
$
78,735,714 |
$
78,735,714 |
$
78,735,714 |
$
78,735,714 |
$
78,735,714 |
$
78,735,714 |
$
78,735,714 |
$
78,735,714 |
$
944,828,571 |
|
|
$
86,609,286 |
$
86,609,286 |
$
86,609,286 |
$
86,609,286 |
$
86,609,286 |
$
86,609,286 |
$
86,609,286 |
$
86,609,286 |
$
86,609,286 |
$
86,609,286 |
$
86,609,286 |
$
86,609,286 |
$
1,039,311,429 |
|
|
Total Margin |
$
463,824,935 |
$
42,517,286 |
$
42,517,286 |
$
42,517,286 |
$
42,517,286 |
$
42,517,286 |
$
42,517,286 |
$
42,517,286 |
$
42,517,286 |
$
42,517,286 |
$
42,517,286 |
$
42,517,286 |
$
42,517,286 |
$
510,207,429 |
|
|
$
46,769,014 |
$
46,769,014 |
$
46,769,014 |
$
46,769,014 |
$
46,769,014 |
$
46,769,014 |
$
46,769,014 |
$
46,769,014 |
$
46,769,014 |
$
46,769,014 |
$
46,769,014 |
$
46,769,014 |
$
561,228,171 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|