Assignment 2: Marketing Plan
Anonymous

Question Description

  • Assignment 2: Marketing Plan
    • 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.). Outline the demographic information for your company specified on the worksheet in the course text (p. 107 | Demographic Description).
      • Support your analysis with actual data on the size of the demographic groups in your local community (nearby zip codes).
        • Hints: At American FactFinder (http://factfinder.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 (http://www.census.gov/econ/cbp/). Check Chapter 2 of Successful Business Plan for more research sources.
    • Assess your company’s market competition.
      • Use the factors listed in the course text graphic (p. 123 | Assess the Competition) to assess your company’s market competition.
      • Defend your plan to differentiate yourself from the competition using the information detailed on the worksheet in the text (p. 131 | Market Share Distribution).
    • Hints: Every business faces competition, and the non-alcoholic beverage market is an especially crowded market.
    • Hints: For example, in the soft drink market, it is intimidating to try to compete against Coke and Pepsi. Newcomers in mature markets typically must pursue niche markets or even create new market categories, as Red Bull did with energy drinks.

Due Week 5 and worth 100 points

This assignment consists of two sections: a marketing plan (Word document) and Marketing Budget (Excel document) Note: You must submit both sections as separate files for the completion of this assignment.

For the first 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 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 and Sales Strategy (MS Word or equivalent)

Write the 3–5-page marketing plan and sales strategy section of your business plan in which you do the following:

    • Hints: If you plan to use online marketing tactics, refer to the worksheet in the text (p. 171 | Online Marketing Tactics) to aid your response. Remember that even if you’re selling through grocery stores, you need to build your brand and social media is a major part of that in regard to beverages. Some of the marketing tactics that beverage companies use include sampling in grocery stores, building a following on social media, sponsoring events, and exhibiting at trade shows attended by retailers. You will use a combination of these tactics. For example, if you decide to give out samples in grocery stores, promote your sampling on your social media networks and those of the grocery store.
    • Hints: If you are planning to distribute through resellers, describe how you plan to reach them, for example, through industry trade shows or by establishing your own sales force. For information on trade shows, visit the Trade Show News Network (http://www.tsnn.com). You can exhibit or network at these shows.

Section 2: Marketing Budget (MS Excel worksheets template)

Section 2 uses the “Business Plan Financials” MS Excel template (see: Required Course Files in Week 1). Use the Business Plan Financials Guide (see: Required Course Files in Week 1) to support your development of the marketing budget.

Note: Complete the Setup tab first based on the instructions located in the Business Plan Financials Guide (document you also downloaded from PlanningShop). Only the setup tab and marketing tab should be completed for this assignment.

The specific course learning outcome associated with this assignment is:

  • By submitting this paper, you agree: (1) that you are submitting your paper to be used and stored as part of the SafeAssign™ services in accordance with the Blackboard Privacy Policy; (2) that your institution may use your paper in accordance with your institution's policies; and (3) that your use of SafeAssign will be without recourse against Blackboard Inc. and its affiliates.

Final Answer

Hi, find attached the completed work for your review.Let me know if I should edit or change anything.Thank you.

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 2013 and Excel 2016, but the functionality is the same.
Note that the riboon does not appear in Excel 2011 for Mac, due to limitations of that version of Excel.
Excel 2013 for Windows, Excel 2016 for Windows, Excel 2016 for Mac:

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,please refer to the companion PDF entitled "Business Plan Financials Help". It contains 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.

About Our Support of Mac vs. Windows
PlanningShop supports Business Plan Financials on the following platforms:
Windows
1. Microsoft Windows10 with Microsoft Excel 2016 / Microsoft Office 365
2. Microsoft Windows 8 or later with Microsoft Excel 2013
Mac
4 Mac OS X with Microsoft Excel 2016
5. Mac OS X with Microsoft Excel for Mac 2011

Version 3.1
Copyright © 2003-2017 PlanningShop

Setup Assumptions

Setup and Assumptions

COMPANY INFORMATION
What is your company's name?
Tropical Paradise Jus

What month will you officially start your company?

January

What year will you officially start your company?

2020

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

Six

10%

30

PERSONNEL ASSUMPTIONS
Approximately how much do you expect to spend per year on benefits
for each SALARIED/FULL TIME employee (medical insurance, etc.)?

$2.500

Approximately how much do you expect to spend per year on benefits
for each HOURLY/PART-TIME employee (medical insurance, etc.)?

$100

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?

2,00%

If you plan to increase wages (both salaried & hourly) on an annual
basis, how much to you plan to increase them by?

5,00%

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 4 of 61

15,00%

$5.000

25,00%

1,00%

Setup Assumptions

Page 5 of 61

Sales Projections

Sales Projections

2020
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

5,00%
2,50%
50,00% 10,00%
3,00%
50,00%

5,00%
2,50%
50,00% 15,00%
3,00%
50,00%

10,00%
2,50%
50,00% 10,00%
3,00%
50,00%

20,00%
2,50%
50,00% 10,00%
3,00%
50,00%

50,00%
2,50%
50,00%

5,00%
3,00%
50,00%

January

2021
February

March

April

May

June

July

August

September

October

November

December

50
$55,00
$2.750
$138
$82,50
$2.530
$1.375,00
$1.155

53
$55,00
$2.888
$144
$87
$2.657
$1.444
$1.213

55
$55,00
$3.032
$152
$90,96
$2.789
$1.516
$1.273

58
$55,00
$3.183
$159
$95,50
$2.929
$1.592
$1.337

61
$55,00
$3.343
$167
$100,28
$3.075
$1.671
$1.404

64
$55,00
$3.510
$175
$105,29
$3.229
$1.755
$1.474

67
$55,00
$3.685
$184
$110,56
$3.390
$1.843
$1.548

70
$55,00
$3.870
$193
$116,09
$3.560
$1.935
$1.625

74
$55,00
$4.063
$203
$121,89
$3.738
$2.032
$1.706

78
$55,00
$4.266
$213
$127,98
$3.925
$2.133
$1.792

81
$55,00
$4.479
$224
$134,38
$4.121
$2.240
$1.881

86
$55,00
$4.703,43
$235
$141,10
$4.327
$2.352
$1.975

50
$55,00
$2.750
$206
$83
$2.461
$1.375
$1.086

53
$55,00
$2.888
$217
$87
$2.584
$1.444
$1.141

55
$55,00
$3.032
$227
$91
$2.714
$1.516
$1.198

58
$55,00
$3.183
$239
$96
$2.849
$1.592
$1.257

61
$55,00
$3.343
$251
$100
$2.992
$1.671
$1.320

64
$55,00
$3.510
$263
$105
$3.141
$1.755
$1.386

67
$55,00
$3.685
$276
$111
$3.298
$1.843
$1.456

70
$55,00
$3.870
$290
$116
$3.463
$1.935
$1.528

74
$55,00
$4.063
$305
$122
$3.636
$2.032
$1.605

78
$55,00
$4.266
$320
$128
$3.818
$2.133
$1.685

81
$55,00
$4.479
$336
$134
$4.009
$2.240
$1.769

86
$55,00
$4.703
$353
$141
$4.210
$2.352
$1.858

100
$55,00
$5.500
$275
$165
$5.060
$2.750
$2.310

110
$55,00
$6.050
$303
$182
$5.566
$3.025
$2.541

121
$55,00
$6.655
$333
$200
$6.123
$3.328
$2.795

133
$55,00
$7.321
$366
$220
$6.735
$3.660
$3.075

146
$55,00
$8.053
$403
$242
$7.408
$4.026
$3.382

161
$55,00
$8.858
$443
$266
$8.149
$4.429
$3.720

177
$55,00
$9.744
$487
$292
$8.964
$4.872
$4.092

195
$55,00
$10.718
$536
$322
$9.861
$5.359
$4.502

214
$55,00
$11.790
$589
$354
$10.847
$5.895
$4.952

236
$55,00
$12.969
$648
$389
$11.931
$6.484
$5.447

259
$55,00
$14.266
$713
$428
$13.124
$7.133
$5.992

285
$55,00
$15.692
$785
$471
$14.437
$7.846
$6.591

150
$55,00
$8.250
$413
$248
$7.590
$4.125
$3.465

180
$55,00
$9.900
$495
$297
$9.108
$4.950
$4.158

216
$55,00
$11.880
$594
$356
$10.930
$5.940
$4.990

259
$55,00
$14.256
$713
$428
$13.116
$7.128
$5.988

311
$55,00
$17.107
$855
$513
$15.739
$8.554
$7.185

373
$55,00
$20.529
$1.026
$616
$18.886
$10.264
$8.622

448
$55,00
$24.634
$1.232
$739
$22.664
$12.317
$10.346

537
$55,00
$29.561
$1.478
$887
$27.196
$14.781
$12.416

645
$55,00
$35.473
$1.774
$1.064
$32.636
$17.737
$14.899

774
$55,00
$42.568
$2.128
$1.277
$39.163
$21.284
$17.879

929
$55,00
$51.082
$2.554
$1.532
$46.995
$25.541
$21.454

1115
$55,00
$61.298
$3.065
$1.839
$56.394
$30.649
$25.745

500
$55,00
$27.500
$688
$825
$25.988
$13.750
$12.238

750
$55,00
$41.250
$1.031
$1.238
$38.981
$20.625
$18.356

1125
$55,00
$61.875
$1.547
$1.856
$58.472
$30.938
$27.534

1688
$55,00
$92.813
$2.320
$2.784
$87.708
$46.406
$41.302

2531
$55,00
$139.219
$3.480
$4.177
$131.562
$69.609
$61.952

3797
$55,00
$208.828
$5.221
$6.265
$197.343
$104.414
$92.929

5695
$55,00
$313.242
$7.831
$9.397
$296.014
$156.621
$139.393

8543
$55,00
$469.863
$11.747
$14.096
$444.021
$234.932
$209.089

Product Line 6

Page 6 of 61

12814
19222
28833
43249
$55,00
$55,00
$55,00
$55,00
$704.795 $1.057.192 $1.585.789 $2.378.683
$17.620
$26.430
$39.645
$59.467
$21.144
$31.716
$47.574
$71.360
$666.031
$999.047 $1.498.570 $2.247.855
$352.397
$528.596
$792.894 $1.189.341
$313.634
$470.451
$705.676 $1.058.514

TOTAL

796
$43.772
$2.189
$1.313
$40.270
$21.886
$18.384

796
$43.772
$3.283
$1.313
$39.176
$21.886
$17.290

2138
$117.614
$5.881
$3.528
$108.204
$58.807
$49.398

5937
$326.539
$16.327
$9.796
$300.416
$163.270
$137.146

128746
$7.081.049
$177.026
$212.431
$6.691.591
$3.540.524
$3.151.067

January

90
$56,38
$5.062
$253
$151,86
$4.657
$2.531
$2.126

90
$56,38
$5.062
$380
$152
$4.531
$2.531
$2.000

314
$56,38
$17.693
$885
$531
$16.277
$8.846
$7.431

1337
$56,38
$75.397
$3.770
$2.262
$69.365
$37.698
$31.667

64873
$56,38
$3.657.225
$91.431
$109.717
$3.456.078
$1.828.612
$1.627.465

Sales Projections

Sales Projections

2020
Assumptions

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
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT

10,00%
2,50%
50,00% 10,00%
3,00%
50,00%

January

2021
February

March

April

May

June

July

August

150
$55,00
$8.250
$413
$248
$7.590
$4.125
$3.465

165
$55,00
$9.075
$454
$272
$8.349
$4.538
$3.812

182
$55,00
$9.983
$499
$299
$9.184
$4.991
$4.193

200
$55,00
$10.981
$549
$329
$10.102
$5.490
$4.612

220
$55,00
$12.079
$604
$362
$11.113
$6.039
$5.073

242
$55,00
$13.287
$664
$399
$12.224
$6.643
$5.580

266
$55,00
$14.615
$731
$438
$13.446
$7.308
$6.138

292
$55,00
$16.077
$804
$482
$14.791
$8.038
$6.752

1000
$55.000
$2.131
$1.650
$51.219
$27.500
$23.719

1310
$72.050
$2.643
$2.162
$67.245
$36.025
$31.220

1754
$96.456
$3.352
$2.894
$90.211
$48.228
$41.983

2395
$131.737
$4.346
$3.952
$123.438
$65.868
$57.570

3330
$183.143
$5.760
$5.494
$171.888
$91.571
$80.317

4700
$258.521
$7.793
$7.756
$242.972
$129.260
$113.712

6720
$369.606
$10.741
$11.088
$347.776
$184.803
$162.973

9708
$533.958
$15.048
$16.019
$502.892
$266.979
$235.912

Page 7 of 61

September
322
$55,00
$17.685
$884
$531
$16.270
$8.842
$7.428

October
354
$55,00
$19.453
$973
$584
$17.897
$9.727
$8.170

November
389
$55,00
$21.398
$1.070
$642
$19.687
$10.699
$8.987

December

TOTAL
3208

January

428
$55,00
$23.538
$1.177
$706
$21.655
$11.769
$9.886

$176.420
$8.821
$5.293
$162.307
$88.210
$74.097

471
$56,38
$26.539
$1.327
$796
$24.416
$13.270
$11.147

14143
20740
30573
45248
$777.869 $1.140.715 $1.681.493 $2.488.618
$21.375
$30.713
$44.542
$65.081
$23.336
$34.221
$50.445
$74.659
$733.158 $1.075.781 $1.586.507 $2.348.878
$388.934
$570.357
$840.747 $1.244.309
$344.223
$505.423
$745.760 $1.104.569

141621
$7.789.166
$213.526
$233.675
$7.341.964
$3.894.583
$3.447.382

67175
$3.786.978
$98.045
$113.609
$3.575.324
$1.893.489
$1.681.835

Sales Projections

Sales Projections

2022
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

94
$56,38
$5.315
$266
$159,46
$4.890
$2.658
$2.232

99
$56,38
$5.581
$279
$167,43
$5.134
$2.790
$2.344

104
$56,38
$5.860
$293
$175,80
$5.391
$2.930
$2.461

109
$56,38
$6.153
$308
$184,59
$5.661
$3.076
$2.584

115
$56,38
$6.461
$323
$193,82
$5.944
$3.230
$2.713

120
$56,38
$6.784
$339
$203,51
$6.241
$3.392
$2.849

126
$56,38
$7.123
$356
$213,69
$6.553
$3.561
$2.992

133
$56,38
$7.479
$374
$224,37
$6.881
$3.739
$3.141

139
$56,38
$7.853
$393
$235,59
$7.225
$3.926
$3.298

146
$56,38
$8.246
$412
$247,37
$7.586
$4.123
$3.463

154
$56,38
$8.658
$433
$259,74
$7.965
$4.329
$3.636

Product Line 2
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT

94
$56,38
$5.315
$399
$159
$4.757
$2.658
$2.099

99
$56,38
$5.581
$419
$167
$4.995
$2.790
$2.204

104
$56,38
$5.860
$439
$176
$5.245
$2.930
$2.315

109
$56,38
$6.153
$461
$185
$5.507
$3.076
$2.430

115
$56,38
$6.461
$485
$194
$5.782
$3.230
$2.552

120
$56,38
$6.784
$509
$204
$6.071
$3.392
$2.680

126
$56,38
$7.123
$534
$214
$6.375
$3.561
$2.814

133
$56,38
$7.479
$561
$224
$6.694
$3.739
$2.954

139
$56,38
$7.853
$589
$236
$7.028
$3.926
$3.102

146
$56,38
$8.246
$618
$247
$7.380
$4.123
$3.257

154
$56,38
$8.658
$649
$260
$7.749
$4.329
$3.420

Product Line 3
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT

345
$56,38
$19.462
$973
$584
$17.905
$9.731
$8.174

380
$56,38
$21.408
$1.070
$642
$19.696
$10.704
$8.992

418
$56,38
$23.549
$1.177
$706
$21.665
$11.775
$9.891

459
$56,38
$25.904
$1.295
$777
$23.832
$12.952
$10.880

505
$56,38
$28.495
$1.425
$855
$26.215
$14.247
$11.968

556
$56,38
$31.344
$1.567
$940
$28.837
$15.672
$13.164

612
$56,38
$34.478
$1.724
$1.034
$31.720
$17.239
$14.481

673
$56,38
$37.926
$1.896
$1.138
$34.892
$18.963
$15.929

740
$56,38
$41.719
$2.086
$1.252
$38.381
$20.859
$17.522

814
$56,38
$45.891
$2.295
$1.377
$42.220
$22.945
$19.274

895
$56,38
$50.480
$2.524
$1.514
$46.441
$25.240
$21.202

Product Line 4
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT

1605
$56,38
$90.476
$4.524
$2.714
$83.238
$45.238
$38.000

1926
$56,38
$108.571
$5.429
$3.257
$99.886
$54.286
$45.600

2311
$56,38
$130.286
$6.514
$3.909
$119.863
$65.143
$54.720

2773
$56,38
$156.343
$7.817
$4.690
$143.835
$78.171
$65.664

3328
$56,38
$187.611
$9.381
$5.628
$172.602
$93.806
$78.797

3993
$56,38
$225.134
$11.257
$6.754
$207.123
$112.567
$94.556

4792
$56,38
$270.160
$13.508
$8.105
$248.547
$135.080
$113.467

5751
$56,38
$324.192
$16.210
$9.726
$298.257
$162.096
$136.161

6901
$56,38
$389.031
$19.452
$11.671
$357.908
$194.515
$163.393

8281
$56,38
$466.837
$23.342
$14.005
$429.490
$233.418
$196.072

9937
$56,38
$560.204
$28.010
$16.806
$515.388
$280.102
$235.286

Product Line 5
Unit Volume
Unit Price
Gross Sales
(Commissions)
(Returns and Allowances)
Net Sales
(Cost of Goods Sold)
GROSS PROFIT

97310
$56,38
$5.485.837
$137.146
$164.575
$5.184.116
$2.742.919
$2.441.198

145965
$56,38
$8.228.756
$205.719
$246.863
$7.776.174
$4.114.378
$3.661.796

218947
$56,38
$12.343.134
$308.578
$370.294
$11.664.262
$6.171.567
$5.492.695

328420
$56,38
$18.514.701
$462.868
$555.441
$17.496.392
$9.257.351
$8.239.042

492631
$56,38
$27.772.052
$694.301
$833.162
$26.244.589
$13.886.026
$12.358.563

738946
$56,38
$41.658.077
$1.041.452
$1.249.742
$39.366.883
$20.829.039
$18.537.844

1108419
$56,38
$62.487.116
$1.562.178
$1.874.613
$59.050.325
$31.243.558
$27.806.767

1662628
$56,38
$93.730.674
$2.343.267
$2.811.920
$88.575.487
$46.865.337
$41.710.150

2493943
$56,38
##########
$3.514.900
$4.217.880
##########
$70.298.006
$62.565.225

3740914
$56,38
##########
$5.272.350
$6.326.821
##########
##########
$93.847.837

5611371
$56,38
##########
$7.908.526
$9.490.231
##########
##########
##########

Product Line 6

Page 8 of 61

TOTAL

1429
$80.574
$4.029
$2.417
$74.128
$40.287
$33.841

1429
$80.574
$6.043
$2.417
$72.113
$40.287
$31.827

6711
$378.350
$18.917
$11.350
$348.082
$189.175
$158.907

52936
$2.984.242
$149.212
$89.527
$2.745.503
$1.492.121
$1.253.382

16704366
$941.708.625
$23.542.716
$28.251.259
$889.914.651
$470.854.313
$419.060.338

1st Quarter 2nd Quarter 3rd Quarter 4th Quarter

508
$57,78
$29.375
$1.469
$881,25
$27.025
$14.688
$12.338

588
$57,78
$34.005
$1.700
$1.020,16
$31.285
$17.003
$14.282

681
$57,78
$39.365
$1.968
$1.180,96
$36.216
$19.683
$16.533

789
$57,78
$45.570
$2.279
$1.367,11
$41.925
$22.785
$19.140

508
$57,78
$29.375
$2.203
$881
$26.291
$14.688
$11.603

588
$57,78
$34.005
$2.550
$1.020
$30.435
$17.003
$13.432

681
$57,78
$39.365
$2.952
$1.181
$35.232
$19.683
$15.549

789
$57,78
$45.570
$3.418
$1.367
$40.785
$22.785
$18.000

3260
$57,78
$188.392
$9.420
$5.652
$173.321
$94.196
$79.125

4339
$57,78
$250.750
$12.537
$7.522
$230.690
$125.375
$105.315

5776
$57,78
$333.748
$16.687
$10.012
$307.048
$166.874
$140.174

7688
$57,78
$444.219
$22.211
$13.327
$408.681
$222.109
$186.572

43405
$57,78
$2.508.147
$125.407
$75.244
$2.307.495
$1.254.073
$1.053.422

75004
$57,78
$4.334.078
$216.704
$130.022
$3.987.352
$2.167.039
$1.820.313

129607
$57,78
$7.489.286
$374.464
$224.679
$6.890.144
$3.744.643
$3.145.500

223962
$57,78
$12.941.487
$647.074
$388.245
$11.906.168
$6.470.744
$5.435.425

39981016
$57,78
##########
$57.756.951
$69.308.341
##########
##########
##########

134935931
$57,78
##########
##########
##########
##########
##########
##########

455408766
$57,78
##########
##########
##########
##########
##########
##########

1537004584
$57,78
##########
##########
##########
##########
##########
##########

Sales Projections

Sales Projections

2022
February

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
(Total Commissions)
(Total Returns and Allowances)
Total Net Sales
(Total Cost of Goods Sold)
TOTAL GROSS PROFIT

March

April

May

June

July

August

September

October

November

December

518
$56,38
$29.193
$1.460
$876
$26.858
$14.597
$12.261

570
$56,38
$32.113
$1.606
$963
$29.544
$16.056
$13.487

627
$56,38
$35.324
$1.766
$1.060
$32.498
$17.662
$14.836

689
$56,38
$38.856
$1.943
$1.166
$35.748
$19.428
$16.320

758
$56,38
$42.742
$2.137
$1.282
$39.323
$21.371
$17.952

834
$56,38
$47.016
$2.351
$1.410
$43.255
$23.508
$19.747

917
$56,38
$51.718
$2.586
$1.552
$47.580
$25.859
$21.721

1009
$56,38
$56.889
$2.844
$1.707
$52.338
$28.445
$23.894

1110
$56,38
$62.578
$3.129
$1.877
$57.572
$31.289
$26.283

1221
$56,38
$68.836
$3.442
$2.065
$63.329
$34.418
$28.911

1343
$56,38
$75.720
$3.786
$2.272
$69.662
$37.860
$31.802

99966
$5.635.599
$144.767
$169.068
$5.321.764
$2.817.800
$2.503.965

149038
$8.402.010
$214.521
$252.060
$7.935.429
$4.201.005
$3.734.424

222510
$12.544.013
$318.769
$376.320
$11.848.924
$6.272.006
$5.576.917

332561
$18.748.110
$474.692
$562.443
$17.710.975
$9.374.055
$8.336.920

497451
$28.043.821
$708.051
$841.315
$26.494.455
$14.021.910
$12.472.544

744570
$41.975.138
$1.057.475
$1.259.254
$39.658.410
$20.987.569
$18.670.840

1114993
$62.857.718
$1.580.886
$1.885.732
$59.391.100
$31...

TutorAR (15534)
New York University

Anonymous
The tutor managed to follow the requirements for my assignment and helped me understand the concepts on it.

Anonymous
The tutor was knowledgeable, will be using the service again.

Anonymous
Awesome quality of the tutor. They were helpful and accommodating given my needs.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors