Description
This assignment consists of two (2) sections: a marketing plan and sales strategy, and a marketing budget. Note: You must submit both sections as separate files for the completion of this assignment.
For the first six (6) months your company is in business—to give you time to perfect your product and to learn from actual customers—you will start marketing and selling in your own community, a radius of twenty-five (25) miles from where you live.
For most non-alcoholic beverages, marketing (as opposed to the actual product itself) is key to success. Cola drinks, for example, are fairly undifferentiated, as are many energy drinks, juices, bottled water, and the like. Companies producing these types of beverages differentiate themselves and attract market share through marketing and brand awareness—both of which are critical to success.
Section 1: Marketing Plan & Sales Strategy (MS Word or equivalent)
Write the three to five (3-5) page Marketing Plan & Sales Strategy section of your business plan, in which you:
Define your company’s target market.
Analyze the types of consumers who will be drinking your beverage in demographic terms (i.e., age, education level, income, gender, ethnic group, etc.). Support your analysis with actual data on the size of the demographic groups in your local community (nearby zip codes).
Outline the demographic information for your company specified on the worksheet in the course text (p. 107 | Demographic Description).Click here for help accessing a specific page number in your eBook.
Hints: At American FactFinder (http://census.gov), you will find demographic information on potential consumers in your area. If you are selling through other businesses (such as grocery stores), indicate the number of those businesses in your local area. You will find information about such businesses in your local area at County Business Patterns (https://www.census.gov/programs-surveys/cbp.html). Check Chapter 2 of Successful Business Plan for more research sources.
Explanation & Answer
Attached please review. kindly let me know if you have any question, thanks
Your Company Name
WARNING!
IT APPEARS THAT YOU DO NOT HAVE EXCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT
FUNCTION WITHOUT MACROS ENABLED.
Excel 2007 for Windows:
To enable macros:
1. Click the "Options" button in the Security Warning that appears at the top of this page.
2. A "Security Alert - Macros & Active X" window should appear.
3. Select the "Enable this content" radio button
4. Click the "OK" button.
Your workbook should be ready to use now.
If you do not see the "Security Warning" along the top of
this page, scroll down for more detailed instructions, under
"Excel 2007 on Windows - Enabling Macros"
Excel 2010 for Windows:
To enable macros:
1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under
"Excel 2010 and Excel 2013 on Windows - Enabling Macros"
Excel 2013 for Windows:
To enable macros:
1. Click the "Enable Content" button in the Security Warning that appears at the top of this page.
If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under
"Excel 2010 & Excel 2013 on Windows - Enabling Macros"
Excel 2010 for Mac:
1. A pop-up window appears. Select "Enable Macros".
2. Your workbook should now be ready to use.
Excel 2008 for Mac:
Excel 2008 for Mac does not support Macros or Visual Basic, so there is no way to enable the macros. Please obtain a Mac 2008-only version
of Business Plan Financials from PlanningShop.
Your Company Name
Excel 2007 on Windows - Enabling Macros
Your Company Name
Excel 2010 and Excel 2013 on Windows - Enabling Macros
Your Company Name
WARNING!
XCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT
FUNCTION WITHOUT MACROS ENABLED.
ning that appears at the top of this page.
rity Warning that appears at the top of this page.
ng the top of this page, scroll down for more detailed instructions, under
nabling Macros"
rity Warning that appears at the top of this page.
ng the top of this page, scroll down for more detailed instructions, under
bling Macros"
Visual Basic, so there is no way to enable the macros. Please obtain a Mac 2008-only version
Your Company Name
07 on Windows - Enabling Macros
1. From the Windows Ribbon, Select the circular "Windows" button in the
upper left.
2. From the drop-down menu that appears, press the Excel Options
button in the lower right.
3. From the "Excel Options" pop-up, select
Trust Center on the left side.
4. Select Trust Center Settings…. In the lower
right.
5. In the "Trust Center" popup, select "Macro Settings"
on the left side.
6. Then, select the Disable all
macros except digitally
signed macros. (This works
because the Planning Shop
signs all its workbooks with
digital certificates.)
7. Press OK twice.
Your Company Name
Excel 2013 on Windows - Enabling Macros
Note: The procedure is exactly the same for Excel 2010 and
Excel 2013, even though the Excel 2013 has a slightly different
look than these screenshots.
1. In the upper left corner of the Excel Ribbon, press the "File" tab.
2. Select Options, in the lower left
corner.
3. Select Trust Center from
the Lower Left.
4. Click the "Trust Center
Settings…" button in the
lower right
5. Select "Macros Settings"
from the left side menu
6. Select the "Disable all
macros except digitally
signed macros" radio button.
7. Click "OK" twice
Welcome to Business Plan Financials!
Thank you for purchasing Business Plan Financials from PlanningShop. These worksheets will help you develop clear, compelling financial projections for your
business. If you are unfamiliar with the business planning process, we encourage you to refer to our book, Successful Business Plan: Secrets & Strategies , by
Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com.
First, a few tips to get you started:
SAVING A BLANK WORKBOOK, TO ALLOW FOR RECOVERY FROM MISTAKES
You may start directly editing this file. If you later decide to start over and need a fresh copy of this file, find the blank "ORIG_PlanningShop_BizPlanFin(2.8)" file in
your PlanningShop directory. Make a copy of this file (just in case you might need to start over yet again), and then start editing the copy.
NAVIGATING THE WORKSHEETS
You installed the Windows version of Business Plan Financials. The Excel Ribbon now contains a "PlanningShop" tab, that contains controls to let you navigate
between worksheets. The PlanningShop Ribbon looks slightly different in Excel 2007, Excel 2010, Excel 2013, but the functionality is the same.
Excel 2007 for Windows:
Excel 2010 for Windows:
Excel 2013 for Windows:
In Excel 2011 for Mac, there is no PlanningShop tab on the Excel Ribbon (Microsoft does not allow it).
Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window.
HOW TO FILL IN THE WORKSHEETS
Each worksheet is composed of "cells" containing either black text or blue text. All you need to do is enter data in the blue cells--the black cells are automatically
calculated for you.
While you work, keep an eye out for red triangles that appear with some cells on the worksheets. These triangles indicate the presence of a "help balloon" that will
popup when you roll over the triangle, presenting you with additional information and tips about the section you are working on.
FOR MORE HELP
For more in-depth help and assistance, click on the "Business Plan Financials Help" menu in the toolbar. The help files contain extensive information about each
worksheet, along with a "Frequently Asked Questions" (FAQ).
To get started, click on the right-pointing arrow in the PlanningShop toolbar to reach the "Setup and Assumptions" worksheet, where you'll enter some basic
information about your business.
Version 2.8
Copyright © 2003-2014 PlanningShop
Setup Assumptions
Setup and Assumptions
COMPANY INFORMATION
What is your company's name?
Your Company Name
What month will you officially start your company?
January
What year will you officially start your company?
2019
SALES ASSUMPTIONS
The Worksheets can accommodate sales projections for up to 10 major
product/service lines. How many major product/service lines do you plan
to have for your business?
Most businesses sell at least some of their products/services on credit
(e.g., "net 30" as opposed to cash). What percentage of your sales will
be made on credit?
For sales you make on credit, what terms will you extend? In other
words, how many days will pass from the date of sale to when you
expect to be paid?
T
e
n
Five
25%
30
PERSONNEL ASSUMPTIONS
Approximately how much do you expect to spend per year on benefits
for each SALARIED/FULL TIME employee (medical insurance, etc.)?
$5,000
Approximately how much do you expect to spend per year on benefits
for each HOURLY/PART-TIME employee (medical insurance, etc.)?
$36
With health insurance and other benefits costing more each year, your
plan should account for annual increases. How much do you estimate
your benefit costs will increase each year?
5.00%
If you plan to increase wages (both salaried & hourly) on an annual
basis, how much to you plan to increase them by?
3.50%
Approximately what percentage of each employee's salary or wages do
you plan to set aside for payroll taxes?
FINANCIAL ASSUMPTIONS
What will be the opening balance in your bank account on the first day of
business? This will be the opening balance in your Cash Flow
Statements.
At approximately what rate do you expect to be taxed on your net
income?
If you will use an interest-bearing account for your banking, at what rate
will you accrue interest?
Page 10 of 69
15.00%
$5,000
25.00%
1.00%
Setup Assumptions
Page 11 of 69
Sales Projections
Sales Projections
2019
Assumptions
Product Line 1
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 2
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 3
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 4
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 5
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
2.20%
3.00%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
40.00% 18.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.80%
50.00% 15.00%
3.00%
50.00%
2.00%
4.50%
50.00% 15.00%
3.00%
50.00%
January
2020
February
March
April
May
June
July
August
September
October
November
December
300
$50
$15,000
$1,125
$450.00
$13,425
$7,500.00
$5,925
307
$50
$15,330
$1,150
$460
$13,720
$7,665
$6,055
313
$50
$15,667
$1,175
$470.02
$14,022
$7,834
$6,189
320
$50
$16,012
$1,201
$480.36
$14,331
$8,006
$6,325
327
$50
$16,364
$1,227
$490.93
$14,646
$8,182
$6,464
334
$50
$16,724
$1,254
$501.73
$14,968
$8,362
$6,606
342
$50
$17,092
$1,282
$512.76
$15,297
$8,546
$6,751
349
$50
$17,468
$1,310
$524.05
$15,634
$8,734
$6,900
357
$50
$17,852
$1,339
$535.57
$15,978
$8,926
$7,052
365
$50
$18,245
$1,368
$547.36
$16,329
$9,123
$7,207
373
$50
$18,647
$1,398
$559.40
$16,689
$9,323
$7,365
381
$50
$19,057
$1,429
$571.71
$17,056
$9,528
$7,527
800
$100
$80,000
$5,760
$2,400
$71,840
$40,000
$31,840
816
$100
$81,600
$5,875
$2,448
$73,277
$40,800
$32,477
832
$100
$83,232
$5,993
$2,497
$74,742
$41,616
$33,126
849
$100
$84,897
$6,113
$2,547
$76,237
$42,448
$33,789
866
$100
$86,595
$6,235
$2,598
$77,762
$43,297
$34,465
883
$100
$88,326
$6,360
$2,650
$79,317
$44,163
$35,154
901
$100
$90,093
$6,487
$2,703
$80,904
$45,046
$35,857
919
$100
$91,895
$6,616
$2,757
$82,522
$45,947
$36,574
937
$100
$93,733
$6,749
$2,812
$84,172
$46,866
$37,306
956
$100
$95,607
$6,884
$2,868
$85,855
$47,804
$38,052
975
$100
$97,520
$7,021
$2,926
$87,573
$48,760
$38,813
995
$100
$99,470
$7,162
$2,984
$89,324
$49,735
$39,589
250
$55
$13,750
$1,031
$413
$12,306
$6,875
$5,431
255
$55
$14,025
$1,052
$421
$12,552
$7,013
$5,540
260
$55
$14,306
$1,073
$429
$12,803
$7,153
$5,651
265
$55
$14,592
$1,094
$438
$13,059
$7,296
$5,764
271
$55
$14,883
$1,116
$447
$13,321
$7,442
$5,879
276
$55
$15,181
$1,139
$455
$13,587
$7,591
$5,997
282
$55
$15,485
$1,161
$465
$13,859
$7,742
$6,116
287
$55
$15,794
$1,185
$474
$14,136
$7,897
$6,239
293
$55
$16,110
$1,208
$483
$14,419
$8,055
$6,364
299
$55
$16,433
$1,232
$493
$14,707
$8,216
$6,491
305
$55
$16,761
$1,257
$503
$15,001
$8,381
$6,621
311
$55
$17,096
$1,282
$513
$15,301
$8,548
$6,753
200
$30
$6,000
$450
$180
$5,370
$3,000
$2,370
204
$30
$6,120
$459
$184
$5,477
$3,060
$2,417
208
$30
$6,242
$468
$187
$5,587
$3,121
$2,466
212
$30
$6,367
$478
$191
$5,699
$3,184
$2,515
216
$30
$6,495
$487
$195
$5,813
$3,247
$2,565
221
$30
$6,624
$497
$199
$5,929
$3,312
$2,617
225
$30
$6,757
$507
$203
$6,047
$3,378
$2,669
230
$30
$6,892
$517
$207
$6,168
$3,446
$2,722
234
$30
$7,030
$527
$211
$6,292
$3,515
$2,777
239
$30
$7,171
$538
$215
$6,418
$3,585
$2,832
244
$30
$7,314
$549
$219
$6,546
$3,657
$2,889
249
$30
$7,460
$560
$224
$6,677
$3,730
$2,947
450
$65
$29,250
$2,194
$878
$26,179
$14,625
$11,554
459
$65
$29,835
$2,238
$895
$26,702
$14,918
$11,785
468
$65
$30,432
$2,282
$913
$27,236
$15,216
$12,021
478
$65
$31,040
$2,328
$931
$27,781
$15,520
$12,261
487
$65
$31,661
$2,375
$950
$28,337
$15,831
$12,506
497
$65
$32,294
$2,422
$969
$28,903
$16,147
$12,756
507
$65
$32,940
$2,471
$988
$29,482
$16,470
$13,011
517
$65
$33,599
$2,520
$1,008
$30,071
$16,800
$13,272
527
$65
$34,271
$2,570
$1,028
$30,673
$17,136
$13,537
538
$65
$34,956
$2,622
$1,049
$31,286
$17,478
$13,808
549
$65
$35,656
$2,674
$1,070
$31,912
$17,828
$14,084
560
$65
$36,369
$2,728
$1,091
$32,550
$18,184
$14,366
Product Line 6
Page 12 of 69
TOTAL
4069
$203,459
$15,259
$6,104
$182,096
$101,730
$80,366
10730
$1,072,967
$77,254
$32,189
$963,525
$536,484
$427,041
3353
$184,416
$13,831
$5,532
$165,053
$92,208
$72,844
2682
$80,473
$6,035
$2,414
$72,023
$40,236
$31,787
6035
$392,304
$29,423
$11,769
$351,112
$196,152
$154,960
January
390
$52
$20,060
$1,505
$601.81
$17,954
$10,030
$7,924
1014.6
$103
$103,996
$7,488
$3,120
$93,388
$51,998
$41,390
317
$56
$17,874
$1,341
$536
$15,997
$8,937
$7,060
254
$31
$7,823
$587
$235
$7,001
$3,911
$3,090
571
$68
$38,765
$2,907
$1,163
$34,695
$19,383
$15,312
Sales Projections
Sales Projections
2019
Assumptions
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 7
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 8
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 9
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Product Line 10
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
Totals for All Product Lines
Total Unit Volume
Total Gross Sales
8.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2.00%
2.50%
50.00% 15.00%
3.00%
50.00%
2020
January
February
March
April
May
June
July
August
September
October
November
December
TOTAL
January
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
2000
$144,000
2041
$146,910
2082
$149,879
2124
$152,908
2167
$155,998
2211
$159,151
2256
$162,367
2302
$165,649
2349
$168,997
2397
$172,412
2445
$175,897
2495
$179,452
26870
$1,933,619
2546
$188,518
Page 13 of 69
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
Sales Projections
Sales Projections
2019
Assumptions
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT
January
$10,560
$4,320
$129,120
$72,000
$57,120
2020
February
$10,773
$4,407
$131,729
$73,455
$58,274
March
$10,991
$4,496
$134,391
$74,939
$59,452
April
$11,213
$4,587
$137,107
$76,454
$60,653
May
$11,440
$4,680
$139,878
$77,999
$61,879
June
$11,671
$4,775
$142,705
$79,575
$63,129
Page 14 of 69
July
$11,907
$4,871
$145,589
$81,184
$64,405
August
$12,148
$4,969
$148,531
$82,824
$65,707
September
$12,394
$5,070
$151,533
$84,498
$67,035
October
$12,644
$5,172
$154,596
$86,206
$68,390
November
$12,900
$5,277
$157,720
$87,948
$69,772
December
$13,161
$5,384
$160,908
$89,726
$71,182
TOTAL
January
$141,803
$58,009
$1,733,808
$966,809
$766,998
$13,827
$5,656
$169,036
$94,259
$74,777
Sales Projections
Sales Projections
2021
February
March
April
May
June
July
August
September
October
November
December
Product Line 1
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
398
$52
$20,502
$1,538
$615.05
$18,349
$10,251
$8,098
407
$52
$20,953
$1,571
$628.58
$18,753
$10,476
$8,276
416
$52
$21,414
$1,606
$642.41
$19,165
$10,707
$8,458
425
$52
$21,885
$1,641
$656.54
$19,587
$10,942
$8,645
434
$52
$22,366
$1,677
$670.99
$20,018
$11,183
$8,835
444
$52
$22,858
$1,714
$685.75
$20,458
$11,429
$9,029
454
$52
$23,361
$1,752
$700.84
$20,908
$11,681
$9,228
464
$52
$23,875
$1,791
$716.25
$21,368
$11,938
$9,431
474
$52
$24,400
$1,830
$732.01
$21,838
$12,200
$9,638
484
$52
$24,937
$1,870
$748.12
$22,319
$12,469
$9,850
495
$52
$25,486
$1,911
$764.58
$22,810
$12,743
$10,067
Product Line 2
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
1035
$103
$106,076
$7,637
$3,182
$95,256
$53,038
$42,218
1056
$103
$108,197
$7,790
$3,246
$97,161
$54,099
$43,063
1077
$103
$110,361
$7,946
$3,311
$99,104
$55,181
$43,924
1098
$103
$112,568
$8,105
$3,377
$101,086
$56,284
$44,802
1120
$103
$114,820
$8,267
$3,445
$103,108
$57,410
$45,698
1143
$103
$117,116
$8,432
$3,513
$105,170
$58,558
$46,612
1165
$103
$119,459
$8,601
$3,584
$107,274
$59,729
$47,544
1189
$103
$121,848
$8,773
$3,655
$109,419
$60,924
$48,495
1213
$103
$124,285
$8,948
$3,729
$111,608
$62,142
$49,465
1237
$103
$126,770
$9,127
$3,803
$113,840
$63,385
$50,455
1262
$103
$129,306
$9,310
$3,879
$116,117
$64,653
$51,464
Product Line 3
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
323
$56
$18,232
$1,367
$547
$16,317
$9,116
$7,202
330
$56
$18,596
$1,395
$558
$16,644
$9,298
$7,346
336
$56
$18,968
$1,423
$569
$16,977
$9,484
$7,492
343
$56
$19,348
$1,451
$580
$17,316
$9,674
$7,642
350
$56
$19,735
$1,480
$592
$17,663
$9,867
$7,795
357
$56
$20,129
$1,510
$604
$18,016
$10,065
$7,951
364
$56
$20,532
$1,540
$616
$18,376
$10,266
$8,110
371
$56
$20,943
$1,571
$628
$18,744
$10,471
$8,272
379
$56
$21,361
$1,602
$641
$19,118
$10,681
$8,438
386
$56
$21,789
$1,634
$654
$19,501
$10,894
$8,607
394
$56
$22,224
$1,667
$667
$19,891
$11,112
$8,779
Product Line 4
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
259
$31
$7,979
$598
$239
$7,141
$3,989
$3,152
264
$31
$8,139
$610
$244
$7,284
$4,069
$3,215
269
$31
$8,301
$623
$249
$7,430
$4,151
$3,279
275
$31
$8,467
$635
$254
$7,578
$4,234
$3,345
280
$31
$8,637
$648
$259
$7,730
$4,318
$3,411
286
$31
$8,809
$661
$264
$7,884
$4,405
$3,480
291
$31
$8,986
$674
$270
$8,042
$4,493
$3,549
297
$31
$9,165
$687
$275
$8,203
$4,583
$3,620
303
$31
$9,349
$701
$280
$8,367
$4,674
$3,693
309
$31
$9,536
$715
$286
$8,534
$4,768
$3,767
315
$31
$9,726
$729
$292
$8,705
$4,863
$3,842
Product Line 5
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
582
$68
$39,541
$2,966
$1,186
$35,389
$19,770
$15,619
594
$68
$40,332
$3,025
$1,210
$36,097
$20,166
$15,931
606
$68
$41,138
$3,085
$1,234
$36,819
$20,569
$16,250
618
$68
$41,961
$3,147
$1,259
$37,555
$20,980
$16,575
630
$68
$42,800
$3,210
$1,284
$38,306
$21,400
$16,906
643
$68
$43,656
$3,274
$1,310
$39,072
$21,828
$17,244
656
$68
$44,529
$3,340
$1,336
$39,854
$22,265
$17,589
669
$68
$45,420
$3,406
$1,363
$40,651
$22,710
$17,941
682
$68
$46,328
$3,475
$1,390
$41,464
$23,164
$18,300
696
$68
$47,255
$3,544
$1,418
$42,293
$23,627
$18,666
710
$68
$48,200
$3,615
$1,446
$43,139
$24,100
$19,039
Product Line 6
Page 15 of 69
TOTAL
5283
$272,098
$20,407
$8,163
$243,528
$136,049
$107,479
13608
$1,394,801
$100,426
$41,844
$1,252,532
$697,401
$555,131
4252
$239,731
$17,980
$7,192
$214,560
$119,866
$94,694
3402
$104,916
$7,869
$3,147
$93,900
$52,458
$41,442
7654
$519,925
$38,994
$15,598
$465,333
$259,962
$205,370
1st Quarter 2nd Quarter 3rd Quarter 4th Quarter
1551
$53
$82,267
$6,170
$2,468.02
$73,629
$41,134
$32,496
1656
$53
$87,817
$6,586
$2,634.52
$78,597
$43,909
$34,688
1767
$53
$93,742
$7,031
$2,812.25
$83,899
$46,871
$37,028
1886
$53
$100,066
$7,505
$3,001.98
$89,559
$50,033
$39,526
3938
$105
$413,733
$29,789
$12,412
$371,532
$206,866
$164,666
4179
$105
$439,057
$31,612
$13,172
$394,273
$219,528
$174,745
4435
$105
$465,930
$33,547
$13,978
$418,406
$232,965
$185,440
4706
$105
$494,449
$35,600
$14,833
$444,015
$247,225
$196,791
1231
$58
$71,110
$5,333
$2,133
$63,644
$35,555
$28,089
1306
$58
$75,463
$5,660
$2,264
$67,539
$37,731
$29,808
1386
$58
$80,082
$6,006
$2,402
$71,673
$40,041
$31,632
1471
$58
$84,983
$6,374
$2,550
$76,060
$42,492
$33,568
984
$32
$31,212
$2,341
$936
$27,935
$15,606
$12,329
1045
$32
$33,122
$2,484
$994
$29,644
$16,561
$13,083
1109
$32
$35,150
$2,636
$1,054
$31,459
$17,575
$13,884
1177
$32
$37,301
$2,798
$1,119
$33,384
$18,651
$14,734
2215
$71
$157,232
$11,792
$4,717
$140,723
$78,616
$62,107
2351
$71
$166,856
$12,514
$5,006
$149,336
$83,428
$65,908
2495
$71
$177,069
$13,280
$5,312
$158,476
$88,534
$69,942
2647
$71
$187,907
$14,093
$5,637
$168,177
$93,953
$74,223
Sales Projections
Sales Projections
2021
February
March
April
May
June
July
August
September
October
November
December
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
Product Line 7
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
Product Line 8
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
Product Line 9
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0
$0
0
$0
$0
$0
$0
$0
$0...