Week 7 Discussion
Anonymous

Question Description

Week 7 Discussion

Top of Form

"The Financials"

This week's discussion is worth 90 points and it is part of your Course Project.

Before you get started on this exercise, you will need the textbook (Chapter 16 - The Financials), the Business Plan Financials Guide and Excel document, and the NAB Company Portfolio.

This Assignment has two sections: The Excel document and the written portion of the financials (sources and use of funds, plan assumption, and break-even analysis) as described below.

Section I: The Business Plan financials (Excel document)

  • Using your NAB Company Portfolio and the first year of your business plan for the company, you will complete all the worksheets in the Excel document in order, so that you can complete the Income Statement, Cash Flow Projections, and Balance Sheet sections from the Business Plan Financials spreadsheet.

Notes:

  • The setup and marketing worksheet should already be completed from Assignment 2.
  • Use the instructions provided in the Business Plan Financials Guide to help you complete this document, as well as the NAB Portfolio (pages 4-8).
  • To submit: Attach the completed Excel worksheet to the discussion thread (click on the Add Content button under the Post button to access the attachment option when you are ready to submit, attach your document and then click submit)

Section II: Financial section of the business plan (compose as a Word document and paste in the discussion window)

You will have 3 headings as outlined below:

1.Sources and use of funds: Outline the funds you have currently (see portfolio pages 4 and 8) and the ones you intend to raise (you need to raise funds per the portfolio page 4). Explain how you plan to use the funds (a clear plan for how you will use the money).

Before addressing this section please review:

  • Sources and Use of Funds section on page 312 of your textbook-Sample plan on page 325 for an idea on how to address this section.

2. Plan assumptions: The Financial plan must be based on decisions and facts. Investors want to know if this plan is realistic. In this section you will outline your plan assumptions.

Before addressing this section please review:

3. Break-even analysis: The break-even point is the point at which you make enough money in revenue to pay your expenses, but no profit (or loss). In this section, clarify what the break-even number is for year one (average). You will extract this information from the Break-even tab in the Excel document.

Before addressing this section please review:

  • Page 314 in the textbook, which covers the break-even analysis.
  • The BrkEvn (Break-Even) worksheet in your Excel document. You would have calculated this there.

Notes:

  • You will use the Excel document in Assignment 3 and 4.
  • You will use the written portion of your Financials in Assignment 4.

To help you get started with Week 7 Discussion

Top of Form

Please follow the instructions in the discussion carefully.

The Excel template, NAB Company Portfolio, and the Business Plan Financials Guide are the 3 documents you downloaded at the beginning of the class using the access code you purchased from the Strayer Bookstore.

1. Use the attached tutorial to help you complete the worksheets in the Excel document. Use the Business Plan Financials Guide document to get you started

2. Check out the video below on how to approach this week's discussion and, specifically, the written section of the discussion.

Unformatted Attachment Preview

Week 7 Discussion "The Financials" This week's discussion is worth 90 points and it is part of your Course Project. Before you get started on this exercise, you will need the textbook (Chapter 16 - The Financials), the Business Plan Financials Guide and Excel document, and the NAB Company Portfolio. This Assignment has two sections: The Excel document and the written portion of the financials (sources and use of funds, plan assumption, and break-even analysis) as described below. 1. • • • Section I: The Business Plan financials (Excel document) Using your NAB Company Portfolio and the first year of your business plan for the company, you will complete all the worksheets in the Excel document in order, so that you can complete the Income Statement, Cash Flow Projections, and Balance Sheet sections from the Business Plan Financials spreadsheet. Notes: The setup and marketing worksheet should already be completed from Assignment 2. Use the instructions provided in the Business Plan Financials Guide to help you complete this document, as well as the NAB Portfolio (pages 4-8). To submit: Attach the completed Excel worksheet to the discussion thread (click on the Add Content button under the Post button to access the attachment option when you are ready to submit, attach your document and then click submit) Section II: Financial section of the business plan (compose as a Word document and paste in the discussion window) You will have 3 headings as outlined below: 1.Sources and use of funds: Outline the funds you have currently (see portfolio pages 4 and 8) and the ones you intend to raise (you need to raise funds per the portfolio page 4). Explain how you plan to use the funds (a clear plan for how you will use the money). • Before addressing this section please review: Sources and Use of Funds section on page 312 of your textbook-Sample plan on page 325 for an idea on how to address this section. 2. Plan assumptions: The Financial plan must be based on decisions and facts. Investors want to know if this plan is realistic. In this section you will outline your plan assumptions. Before addressing this section please review: • • • • The setup and assumptions sheet in your Excel document. Sample plan in your textbook page 326 Assumption sheet in your textbook page 313. Article about the 5 key assumptions of your business plan. https://www.thebalancesmb.com/questionkey-assumptions-in-your-business-plan-1200853 3. Break-even analysis: The break-even point is the point at which you make enough money in revenue to pay your expenses, but no profit (or loss). In this section, clarify what • • • • the break-even number is for year one (average). You will extract this information from the Break-even tab in the Excel document. Before addressing this section please review: Page 314 in the textbook, which covers the break-even analysis. The BrkEvn (Break-Even) worksheet in your Excel document. You would have calculated this there. Notes: You will use the Excel document in Assignment 3 and 4. You will use the written portion of your Financials in Assignment 4. To help you get started with Week 7 Discussion Please follow the instructions in the discussion carefully. The Excel template, NAB Company Portfolio, and the Business Plan Financials Guide are the 3 documents you downloaded at the beginning of the class using the access code you purchased from the Strayer Bookstore. 1. Use the attached tutorial to help you complete the worksheets in the Excel document. Use the Business Plan Financials Guide document to get you started 2. Check out the video below on how to approach this week's discussion and, specifically, the written section of the discussion. https://blackboard.strayer.edu/courses/1/BUS599080VA016-1202-001/db/_82687215_1/BUS599%20Tutorial%20on%20how%20to%20complete%20the%20Financials%20%28Excel%20document%29.p df Running head: MARKETING PLAN Tropical Paradise Jus – Marketing Plan Liliana Pinzon February 9, 2020 MARKETING PLAN 2 Tropical Paradise Jus – Marketing Plan Tropical Paradise Jus is an organic non-alcoholic beverage that will mainly target millennials and also individuals of all ages. Our target customers are individuals that focus on being fit, eating healthy, and stay in shape. Individuals that are taking the initiative to start eating healthy and maintain a healthy lifestyle. Millennials are individuals born between the early 1980s and mid-1990s. As such, their range of ages is between 24 years and 39 years old. A study by rent Café showed that 59% of the people living in Tampa are millennials. Tampa, Florida, is one of the residential areas with the highest number of millennials residing in the state. Below there is an analysis of the demographic information for the target consumers for the beverage as well as the marketing plan for improving the consumption of fresh fruit juice in the area. Target consumers The headquarters of Tropical Paradise Jus is located in Tampa, Florida. The target consumers are, therefore, people living in this state, especially millennials. The ages for the target group will be between 24 years and 39 years old. These individuals are primarily people who visit the gym three to four times a week and prefer organic foods and drinks. In other words, they are keen on healthy eating and fitness. There are approximately 1000 gyms in the city of Tampa. The standard charge for a gym membership in Tampa city is $49 per month, which results in $600 per year. The target consumers are those who can afford to pay a gym membership every month. Therefore, the earnings per year for the target consumers for the product are $45,200 per year. It will be approximately $3,800 per month for the average millennial in Tampa. There are about 385,430 people in the city of Tampa, according to the 2017 US census bureau, with 51% of this population being females. MARKETING PLAN 3 The product will target all genders; the primary focus will be the females who are aged between 24 and 35 as this gender is highly likely to invest in their health and fitness to be in shape and healthy. The education level of the target audience is women who are highly educated and have at least achieved a university degree as the highest level of education. The general target group of consumers is, therefore, middle income earning women who reside in the city of Tampa and have a gym membership for the various gyms in the city of Tampa. Existing Competitors Several competitors have been involved in the sale of organic non-alcoholic beverages in the United States. Some of the most competitive companies include; Nuun & Company, LIFEAID Beverage Company, Nekter Juice Bar, and Natalie’s Orchid Island Juice Company. Nuun & Company is one of the biggest competitors for Tropical Paradise Jus with over 5000 outlets across the United States and 50% market share in the production of organic beverages in the United States (Nuun & Company, 2020). The Company is especially famous for its sugarfree, gluten-free products that are available in a recyclable tube. The Company has increased its global market presence by sponsoring the majority of the athletic events across the United States, which has boosted the Company’s income to $28 billion from revenues in the last year. LifeAid Beverage Company has experienced a growth in the company revenues to $21.4 million in the previous year. The Company sold over 2.5 million cans of organic non-alcoholic beverage drinks in the last year, which was a 50% growth as compared to the previous year. Tropical Paradise Jus is a new company that will be competing against these other brands such as Nuun & Company and LifeAid Beverage Company. Tropical paradise Jus will be able to MARKETING PLAN 4 compete favorably with the other companies as the products will be sold at a relatively lower price as compared to the other products. Organic drinks in the city of Tampa are expensive as compared to other beverages. The average cost of a glass of organic, natural non-alcoholic beverage in Tampa is about $20.00 per can. Costing is the competitive advantage that is offered by Tropical Paradise Jus that will allow the company to compete favorably in Tampa. For instance, the cost of a 24 pack of LifeAid can of juice is $63.00, which is slightly expensive. The price per 500ml bottle of Tropical Paradise Jus in Tampa will be $55.00, which is somewhat cheaper than other brands in the market. The juice will be available in 4 pack containers and eight pack containers for the various customers. This pricing strategy will ensure that Tropical Paradise Jus will develop in Tampa will be affordable. Marketing strategy The product will be distributed through various health food stores and gyms in the city of Tampa. Some of the identified health food stores that will be used in marketing include; lifespring health foods &juice bar, garden gourmet market, and fruit field yield, which are located in Tampa. Some of the selected gyms for marketing include; Quads Gym, Anytime fitness, and Tampa yoga center. As sales will be made through the health food stores and gyms, it is essential to build the brand and increase awareness for the product. Marketing methods will be done through free promotions, sampling, and building a brand through social media. Sampling will be the first promotion method that will be used to promote the brand. There will be a free sampling of the drink at the entrance of these organic stores for a whole month, where the various shoppers will be able to taste the multiple products. The shoppers will be encouraged to purchase the product as well as follow the different social media pages. The next MARKETING PLAN 5 month will involve active online and physical promotion. As the main target customers for the product are millennials, social media will play a huge role. There will be online promotions through Instagram, Twitter, LinkedIn, and Facebook. These promotions will include free giveaways for some regular customers, which will encourage other people to purchase the product. The company will also approach some influential athletes and celebrities in Tampa, who will assist in promoting the product online through their individual social media pages. There will be extensive marketing and advertising in the selected gyms through the use of posters and free gym gear to the various instructors and frequent users of the selected gyms. The beverage will also be sold at a discounted price for the first three months at these locations to increase the brand's awareness. The company will sponsor various athletic events such as the New Year Fitness Reset, which is held by the top trainers held in Tampa to promote fitness. MARKETING PLAN 6 References American Fact Finder (http://factfinder.census.gov) [accessed February 6, 2020] Gao, Z. (2012). Motivated but not active: the dilemmas of incorporating interactive dance into gym class. Journal of Physical Activity and Health, 9(6), 794-800. LifeAid Beverage Company (2020) https://www.lifeaidbevco.com/ [accessed February 6, 2020] Nuun & Company (2020). https://www.inc.com/profile/nuun-company [accessed February 6, 2020] Ottman, J. (2017). The new rules of green marketing: Strategies, tools, and inspiration for sustainable branding. Routledge. Saura, J. R., Palos-Sanchez, P. R., & Correia, M. B. (2019). Digital Marketing Strategies Based on the E-Business Model. United States Census Bureau (2017). https://www.census.gov/glossary/#term_Populationestimates [accessed February 6, 2020] ...
Purchase answer to see full attachment

Final Answer

Hi, here are the completed spreadsheet and word documentLet me know if any changes are needed. Thank you

Running head: NAB FINANCIALS

NAB Financials
Name
Title
Date

NAB FINANCIALS

2

1. Sources and use of funds:
The two major sources of funds that will be used to start this business are my personal savings
and a bank loan I will take to boost the savings for purposes of acquitting capital investments for
the business. My savings are $5,000 and a bank loan of $14,000 making it a total investment of
$19,000.
This money will be used to pay for the initial capital expenditures and marketing before launch
of business:
Storage hardware
Commercial Juicing Machine
Packaging machine
1 year Rent
2 computers (Apple)
Website launch
Server set up
Inventory
Marketing budget
January Professional Services
Total

$400
$950
$450
$1,000
$1,500
$600
$600
$9,969
$865
$2,000
$18,334

2. Plan assumptions:
I.

One key assumption of this financial plan is that the business will be selling all the
products produced daily hence no wastage especially during the first five months because
production will be on small scale.

II.
III.

Secondly, the prices of raw fruits will fall within the budget.
The business will produce 6 juice variants at first before diversifying into other blended
and new variants.

IV.

Up to 90% of sales will be on cash basis as opposed to credit basis given the
socioeconomic status of our target market.

NAB FINANCIALS
V.

3

The company will work with 8 full time employees during the first years to manage
expenses before expanding the workforce.

VI.

The business will turn a profit due to the need for fresh juice in the market as per the
feasibility analysis conducted.

3. Break-even analysis:
The breakeven number for year one is $22,766
Year 1 (2020)
January
February
March
April
May
June
July
August
September
October
November
December
Monthly Average

$20,925
$23,294
$23,189
$23,094
$23,011
$22,940
$22,882
$22,835
$22,797
$22,766
$22,742
$22,723
$22,766


1. OutlineSources and use of funds:
The two major sources of funds that will be used to start this business are my personal savings
and a bank loan I will take to boost the savings for purposes of acquitting capital investments for
the business. My savings are $5,000 and a bank loan of $14,000 making it a total investment of
$19,000.
This money will be used to pay for the initial capital expenditures and marketing before launch
of business:
Storage hardware
Commercial Juicing Machine
Packaging machine
1 year Rent
2 computers (Apple)
Website launch
Server set up
Inventory
Marketing budget
January Professional Services
Total

$400
$950
$450
$1,000
$1,500
$600
$600
$9,969
$865
$2,000
$18,334

2. Plan assumptions:
I.

One key assumption of this financial plan is that the business will be selling all the
products produced daily hence no wastage especially during the first five months because
production will be on small scale.

II.
III.

Secondly, the prices of raw fruits will fall within the budget.
The business will produce 6 juice variants at first before diversifying into other blended
and new variants.

IV.

Up to 90% of sales will be on cash basis as opposed to credit basis given the
socioeconomic status of our target market.

V.

The company will work with 8 full time employees during the first years to manage
expenses before expanding the workforce.

VI.

The business will turn a profit due to the need for fresh juice in the market as per the
feasibility analysis conducted.

3. Break-even analysis:
The breakeven number for year one is $22,766
Year 1 (2020)
January
February
March
April
May
June
July
August
September
October
November
December
Monthly Average

$20,925
$23,294
$23,189
$23,094
$23,011
$22,940
$22,882
$22,835
$22,797
$22,766
$22,742
$22,723
$22,766


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 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& 2016 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 2011 & 2016 for Mac:
1. A pop-up window appears. Select "Enable Macros".
2. Your workbook should now be ready to use.

Your Company Name

Excel 2013 and Excel 2016 on Windows - Enabling Macros

Your Company Name

WARNING!

XCEL'S MACRO CAPABILITY ENABLED. THESE FINANCIAL WORKSHEETS WILL NOT
FUNCTION WITHOUT MACROS ENABLED.

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"

Your Company Name

Excel 2016 on Windows - Enabling Macros

Note: The procedure is exactly the same for Excel 2013 & 2016,
even though the two versions look slightly different.
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 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

55%

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 8 of 65

15.00%

$5,000

25.00%

1.00%

Setup Assumptions

Page 9 of 65

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 10 of 65

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 11 of 65

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

TutorAR (15533)
Rice University

Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service!

Anonymous
Heard about Studypool for a while and finally tried it. Glad I did caus this was really helpful.

Anonymous
Just what I needed… fantastic!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags

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