Sales Forecast Year 1
Prepared By: Company Name:
Sam Miller Aviator Inc
Complete This Chart First:  
Product Lines Units[1] Sales Price Per Unit COGS Per Unit[2] Margin Per Unit
T1 45  $          259,000.00  $          168,181.82  $          90,818.18
T2 45  $          329,000.00  $          213,636.36  $       115,363.64
X 30  $          359,000.00  $          233,116.88  $       125,883.12
XR 50  $          425,000.00  $          275,974.03  $       149,025.97
XL 60  $          550,000.00  $          357,142.86  $       192,857.14
XLR 30  $          625,000.00  $          405,844.16  $       219,155.84
Product Lines Sept  Oct Nov Dec Jan Feb Mar Apr May June July Aug Annual Totals Category Breakdown Category / Total
T1                              
45 Sold 45 45 45 45 45 45 45 45 45 45 45 45 540   17.3%
Total Sales              11,655,000              11,655,000              11,655,000              11,655,000              11,655,000              11,655,000              11,655,000              11,655,000              11,655,000              11,655,000              11,655,000              11,655,000  $     139,860,000 100.0% 10.6%
Total COGS                7,568,182                7,568,182                7,568,182                7,568,182                7,568,182                7,568,182                7,568,182                7,568,182                7,568,182                7,568,182                7,568,182                7,568,182  $       90,818,182 64.9% 10.6%
Total Margin                4,086,818                4,086,818                4,086,818                4,086,818                4,086,818                4,086,818                4,086,818                4,086,818                4,086,818                4,086,818                4,086,818                4,086,818  $       49,041,818 35.1% 10.6%
                               
T2                              
45 Sold 45 45 45 45 45 45 45 45 45 45 45 45 540   17.3%
Total Sales              14,805,000              14,805,000              14,805,000              14,805,000              14,805,000              14,805,000              14,805,000              14,805,000              14,805,000              14,805,000              14,805,000              14,805,000  $     177,660,000 100.0% 13.4%
Total COGS                9,613,636                9,613,636                9,613,636                9,613,636                9,613,636                9,613,636                9,613,636                9,613,636                9,613,636                9,613,636                9,613,636                9,613,636  $     115,363,636 64.9% 13.4%
Margin                5,191,364                5,191,364                5,191,364                5,191,364                5,191,364                5,191,364                5,191,364                5,191,364                5,191,364                5,191,364                5,191,364                5,191,364  $       62,296,364 35.1% 13.4%
                               
X                              
30 Sold 30 30 30 30 30 30 30 30 30 30 30 30 360   11.5%
Total Sales              10,770,000              10,770,000              10,770,000              10,770,000              10,770,000              10,770,000              10,770,000              10,770,000              10,770,000              10,770,000              10,770,000              10,770,000  $     129,240,000 100.0% 9.8%
Total COGS                6,993,506                6,993,506                6,993,506                6,993,506                6,993,506                6,993,506                6,993,506                6,993,506                6,993,506                6,993,506                6,993,506                6,993,506  $       83,922,078 64.9% 9.8%
Margin                3,776,494                3,776,494                3,776,494                3,776,494                3,776,494                3,776,494                3,776,494                3,776,494                3,776,494                3,776,494                3,776,494                3,776,494  $       45,317,922 35.1% 9.8%
                               
XR                              
50 Sold 50 50 50 50 50 50 50 50 50 50 50 50 600   19.2%
Total Sales              21,250,000              21,250,000              21,250,000              21,250,000              21,250,000              21,250,000              21,250,000              21,250,000              21,250,000              21,250,000              21,250,000              21,250,000  $     255,000,000 100.0% 19.3%
Total COGS              13,798,701              13,798,701              13,798,701              13,798,701              13,798,701              13,798,701              13,798,701              13,798,701              13,798,701              13,798,701              13,798,701              13,798,701  $     165,584,416 64.9% 19.3%
Margin                7,451,299                7,451,299                7,451,299                7,451,299                7,451,299                7,451,299                7,451,299                7,451,299                7,451,299                7,451,299                7,451,299                7,451,299  $       89,415,584 35.1% 19.3%
                               
XL                              
60 Sold 60 60 60 60 60 60 60 60 60 60 60 60 720   23.1%
Total Sales              33,000,000              33,000,000              33,000,000              33,000,000              33,000,000              33,000,000              33,000,000              33,000,000              33,000,000              33,000,000              33,000,000              33,000,000  $     396,000,000 100.0% 29.9%
Total COGS              21,428,571              21,428,571              21,428,571              21,428,571              21,428,571              21,428,571              21,428,571              21,428,571              21,428,571              21,428,571              21,428,571              21,428,571  $     257,142,857 64.9% 29.9%
Margin              11,571,429              11,571,429              11,571,429              11,571,429              11,571,429              11,571,429              11,571,429              11,571,429              11,571,429              11,571,429              11,571,429              11,571,429  $     138,857,143 35.1% 29.9%
                               
XLR                              
30 Sold 30 30 30 30 30 30 30 30 30 30 30 30 360   11.5%
Total Sales              18,750,000              18,750,000              18,750,000              18,750,000              18,750,000              18,750,000              18,750,000              18,750,000              18,750,000              18,750,000              18,750,000              18,750,000  $     225,000,000 100.0% 17.0%
Total COGS              12,175,325              12,175,325              12,175,325              12,175,325              12,175,325              12,175,325              12,175,325              12,175,325              12,175,325              12,175,325              12,175,325              12,175,325  $     146,103,896 64.9% 17.0%
Margin                6,574,675                6,574,675                6,574,675                6,574,675                6,574,675                6,574,675                6,574,675                6,574,675                6,574,675                6,574,675                6,574,675                6,574,675  $       78,896,104 35.1% 17.0%
Total Units Sold 260 260 260 260 260 260 260 260 260 260 260 260 3,120    
Total Sales  $     110,230,000  $     110,230,000  $     110,230,000  $     110,230,000  $     110,230,000  $     110,230,000  $     110,230,000  $     110,230,000  $     110,230,000  $     110,230,000  $     110,230,000  $     110,230,000  $  1,322,760,000    
Total Cost of Goods Sold  $       71,577,922  $       71,577,922  $       71,577,922  $       71,577,922  $       71,577,922  $       71,577,922  $       71,577,922  $       71,577,922  $       71,577,922  $       71,577,922  $       71,577,922  $       71,577,922  $     858,935,065    
Total Margin  $       38,652,078  $       38,652,078  $       38,652,078  $       38,652,078  $       38,652,078  $       38,652,078  $       38,652,078  $       38,652,078  $       38,652,078  $       38,652,078  $       38,652,078  $       38,652,078  $     463,824,935    
[1]
TIP: Enter these in the plural form! Ex. projects, dresses, bikes, etc.
[2]
TIP: Click here to access a calculator that can help you determine your COGS per unit.