Assignment two

User Generated

NnyvlnuN

Business Finance

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.

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Just what I was looking for! Super helpful.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags