Sales Forecast Year 1
Prepared By: Company Name:
Sam Miller Aviation Flight Academy
Complete This Chart First:  
Product Lines Units[1] Sales Price Per Unit COGS Per Unit[2] Margin Per Unit
Student 1  $         9,390.00  $               8,550.00  $                        840.00
Aircraft Rental 1  $       26,444.00  $             21,102.55  $                    5,341.45
Training PIC 1  $       30,000.00  $               3,200.00  $                  26,800.00
Training SIC 1  $       20,000.00  $               3,200.00  $                  16,800.00
ATP 1  $       75,500.00  $             36,500.00  $                  39,000.00
VA & Military Training 1  $       58,000.00  $             36,500.00  $                  21,500.00
Product Lines Sept  Oct Nov Dec Jan Feb Mar Apr May June July Aug Annual Totals Category Breakdown Category / Total
Student                              
1 Sold 72 144 216 288 360 432 468 468 468 468 468 468 4,320   40.9%
Total Sales                          676,080           1,352,160                  2,028,240                         2,704,320            3,380,400            4,056,480            4,394,520            4,394,520            4,394,520            4,394,520            4,394,520            4,394,520  $           40,564,800 100.0% 16.9%
Total COGS                          615,600           1,231,200                  1,846,800                         2,462,400            3,078,000            3,693,600            4,001,400            4,001,400            4,001,400            4,001,400            4,001,400            4,001,400  $           36,936,000 91.1% 22.2%
Total Margin                            60,480              120,960                     181,440                            241,920               302,400               362,880               393,120               393,120               393,120               393,120               393,120               393,120  $             3,628,800 8.9% 4.9%
                               
Aircraft Rental                              
1 Sold 72 144 216 288 360 432 468 468 468 468 468 468 4,320   40.9%
Total Sales                       1,903,968           3,807,936                  5,711,904                         7,615,872            9,519,840          11,423,808          12,375,792          12,375,792          12,375,792          12,375,792          12,375,792          12,375,792  $         114,238,080 100.0% 47.7%
Total COGS                       1,519,384           3,038,767                  4,558,151                         6,077,534            7,596,918            9,116,302            9,875,993            9,875,993            9,875,993            9,875,993            9,875,993            9,875,993  $           91,163,016 79.8% 54.8%
Margin                          384,584              769,169                  1,153,753                         1,538,338            1,922,922            2,307,506            2,499,799            2,499,799            2,499,799            2,499,799            2,499,799            2,499,799  $           23,075,064 20.2% 31.4%
                               
Training PIC                              
1 Sold 30 30 30 30 30 30 30 30 30 30 30 30 360   3.4%
Total Sales                          900,000              900,000                     900,000                            900,000               900,000               900,000               900,000               900,000               900,000               900,000               900,000               900,000  $           10,800,000 100.0% 4.5%
Total COGS                            96,000                96,000                       96,000                              96,000                 96,000                 96,000                 96,000                 96,000                 96,000                 96,000                 96,000                 96,000  $             1,152,000 10.7% 0.7%
Margin                          804,000              804,000                     804,000                            804,000               804,000               804,000               804,000               804,000               804,000               804,000               804,000               804,000  $             9,648,000 89.3% 13.1%
                               
Training SIC                              
1 Sold 50 50 50 50 50 50 50 50 50 50 50 50 600   5.7%
Total Sales                       1,000,000           1,000,000                  1,000,000                         1,000,000            1,000,000            1,000,000            1,000,000            1,000,000            1,000,000            1,000,000            1,000,000            1,000,000  $           12,000,000 100.0% 5.0%
Total COGS                          160,000              160,000                     160,000                            160,000               160,000               160,000               160,000               160,000               160,000               160,000               160,000               160,000  $             1,920,000 16.0% 1.2%
Margin                          840,000              840,000                     840,000                            840,000               840,000               840,000               840,000               840,000               840,000               840,000               840,000               840,000  $           10,080,000 84.0% 13.7%
                               
ATP                              
1 Sold 30 30 30 30 30 30 30 30 30 30 30 30 360   3.4%
Total Sales                       2,265,000           2,265,000                  2,265,000                         2,265,000            2,265,000            2,265,000            2,265,000            2,265,000            2,265,000            2,265,000            2,265,000            2,265,000  $           27,180,000 100.0% 11.3%
Total COGS                       1,095,000           1,095,000                  1,095,000                         1,095,000            1,095,000            1,095,000            1,095,000            1,095,000            1,095,000            1,095,000            1,095,000            1,095,000  $           13,140,000 48.3% 7.9%
Margin                       1,170,000           1,170,000                  1,170,000                         1,170,000            1,170,000            1,170,000            1,170,000            1,170,000            1,170,000            1,170,000            1,170,000            1,170,000  $           14,040,000 51.7% 19.1%
                               
VA & Military Training                              
1 Sold 50 50 50 50 50 50 50 50 50 50 50 50 600   5.7%
Total Sales                       2,900,000           2,900,000                  2,900,000                         2,900,000            2,900,000            2,900,000            2,900,000            2,900,000            2,900,000            2,900,000            2,900,000            2,900,000  $           34,800,000 100.0% 14.5%
Total COGS                       1,825,000           1,825,000                  1,825,000                         1,825,000            1,825,000            1,825,000            1,825,000            1,825,000            1,825,000            1,825,000            1,825,000            1,825,000  $           21,900,000 62.9% 13.2%
Margin                       1,075,000           1,075,000                  1,075,000                         1,075,000            1,075,000            1,075,000            1,075,000            1,075,000            1,075,000            1,075,000            1,075,000            1,075,000  $           12,900,000 37.1% 17.6%
Total Units Sold 304 448 592 736 880 1,024 1,096 1,096 1,096 1,096 1,096 1,096 10,560    
Total Sales  $                9,645,048  $  12,225,096  $         14,805,144  $                17,385,192  $   19,965,240  $   22,545,288  $   23,835,312  $   23,835,312  $   23,835,312  $   23,835,312  $   23,835,312  $   23,835,312  $         239,582,880    
Total Cost of Goods Sold  $                5,310,984  $    7,445,967  $           9,580,951  $                11,715,934  $   13,850,918  $   15,985,902  $   17,053,393  $   17,053,393  $   17,053,393  $   17,053,393  $   17,053,393  $   17,053,393  $         166,211,016    
Total Margin  $                4,334,064  $    4,779,129  $           5,224,193  $                  5,669,258  $     6,114,322  $     6,559,386  $     6,781,919  $     6,781,919  $     6,781,919  $     6,781,919  $     6,781,919  $     6,781,919  $           73,371,864    
[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.