Chat with us, powered by LiveChat week 7 redo | Abc Paper
+1(978)310-4246 credencewriters@gmail.com
  

Running Head: WK7 MARKETING BUDGET 1

Wk7 MARKETING BUDGET 14

WK 7 Marketing Budget

Student
Professor
Institution
Date

WK7 Marketing Budget

Introduction

Jadeddreams is a company that focuses on Customized cereal bar treats. These bars are created for the people that love cereal products or entities that are always on the run and have no time to prepare or take the traditional breakfast. These bars are substitute products that are fit for the people working under pressure such that they have no time to settle as they are already occupied.

Company Overview

. It will serve all people, but to be more specific, it will be for women and children because there are different preferences and tastes. All those people who are always busy as they are undertaking their work and, in most case,, they do not have time sometimes to cook for their families, and they are forced to take these cereals in the bars.
The best location for this kind of company is at urban centres, whereby the majority of the people are busy with their work, and they do not have time to cook. In urban areas, it is where many people almost everybody is very busy with work, (Bchir, et al, 2018)
Most people see this kind of company as the people who have a high lifestyle and a good paying salary. I think it is just a myth because all people can buy this kind of cereal. After all, it has different tastes for each one of them. However, most people will be those with a high lifestyle and have some income since this food most of them sees it as a leisure food that is not to be eaten all the time, (Carvalho, et al, 2018).
For this, I can say that my esteemed customers will be those who are fun-seeking. This type of food is mostly eaten when people are going to have fun and not when they are going to work. For sensitive description, the commodity will be at a price that will be pocket friendly

The pre-operation Cost

These are the expenses that are incurred for the business stock

The item

The amount

License for trading

4000

The permit for trading

2500

Deposit for water

3000

Deposit for telephone

3000

Cost for Installation like the shelves

29000

The paint

4000

The long front table

6000

The furniture

18000

The transport

8000

Total pre-operation cost

77500

Working Capital

The working capital would be the funds that shall be used in day-to-day operations which will be estimated working capital

Item

2019

2020

2021

The food stock and others

70000

90000

100000

The debtors

120000

10000

8000

Cash at hand

40000

60000

50000

Cash at bank

120000

100000

150000

Total

242000

260000

308000

The projected profit and loss as at 31st Dec 2019

Item

January

Feb

March

April

May

June

July

August

September

October

November

December

Flow in cash

Cash sales
Collection from debtors
Total cash in flow

350,000
16,000
366,000

420,000
10,000
430,000

570,000
5,000
575,00

6,000
4,000
604,000

620,000
11,000
631,000

650,000
8,000
658,000

680,000
7,000
687,000

710,000
8,000
718,000

805,000
5,000
810,000

851,000
6,000
857,00

890,000
4,000
894,000

922,000
6,000
928,000

Cash outflow

Cash purchase
Payment of creditors
Insurance
Postage
Telephone
Electricity
Water
Advertisement
Tax
Total cash outflow
Total cash for the month

10,000
1,000
1,200
700
600
800
500
240,000
5,000
133,800
216,200

150,000
3,000
1,500
800
700
400
600
26,000
7000
190,500
229,500

170,000
4,000
1,800
700
700
800
500
24,000
6,000
228,500
341,500

250,000
10,000
1,200
700
700
800
500
20,000
5,000
288,900
311,100

270,000
20,000
1,200
700
700
800
500
22,000
7,000
322,900
297,100

290,000
15,000
1,200
700
700
400
420
24,000
5,000
337,920
312,080

305,000
25,000
1,200
700
700
400
470
22,000
6,000
361,970
318,030

350,000
26,000
4,000
700
400
1,200
480
20,000
5,000
408,280
301,720

370,000
16,000
4,000
700
700
800
500
15,000
6,000
413,700
391,300

400,000
15,000
1,500
700
500
1,500
520
10,000
5,000
434,720
416,280

470,000
14,000
3,000
800
700
900
600
5,000
7000
502,000
388,000

500,000
13,000
3,000
800
700
900
600
0
3,000
522,000
400,000

The Proforma Income Statement

The Jadeddreams inputs Income Statement

Item

Year One (2019)

Year Two (2020)

Year Three (2021)

Sales

1,383,800

1,764,900

1,974,750

Cost of goods

583,800

934,400

1,074,500

Gross profit

800,000

830,500

900,250

Expenses

Expenses wages & salaries

292,000

294,000

303,000

Rent

12,000

12,000

12,000

Water

5,000

7,500

38,506,850

Telephone

3,600

3,200

12,525

Electricity

15,800

4,200

3,755

Advertisement

3,900

8,650

10,335

Stationery

121,000

5,350

4,360

Postage

8,700

9,000

9,245

Depreciation

10,300

16,275

16,000

Interest

18,000

9,225

18,000

Repairs

9,700

382,500

389,620

Total expenses

391,000

448,000

510,320

Net profit before tax

40,900

44,800

510,320

Tax 10%

40,900

403,200

459,297

Net profit after tax

368,100

The Proforma balance sheet
The proforma balance sheet for the first three years

“ITEM

YEAR 1(2019)
31/12/2019

YEAR 2 (2020)
31/12/2020

YEAR 3 (2021)
31/12/2021

CURRENT ASSETS

Debtors

85,000

90,000

70,000

Stock of unfinished goods

280,000

385,000

400,000

Total current assets

365,000

475,000

470,000

FIXED ASSETS

Machinery equipment

80,000

45,000

50,500

Accumulated depression

10,000

9,000

3,500

Vehicle(cost of transport)

20,000

15,000

8,000

Furniture and fittings

50,000

12,000

5,000

Depreciation

10,500

1,000

1,000

TOTAL FIXED ASSETS

170,500

84,000

68,000

TOTAL ASSETS

207,000

559,000

538,000

CURRENT LIABILITIES

Creditors

70,000

65,000

60,000

Tax

40,900

44,800

51,033

TOTAL CURRENT LIABILITIES

110,900

109,800

111,033

LONG-TERM LIABILITIES

Bank loan

50,000

149,000

168,000

Owners’ equity

46,100

400,000

258,967

TOTAL LONG TERM LIABILITIES

96,000

549,200

426,967

TOTAL LIABILITIES

207,000

559,000

538,000

“Gross profit=sales – total direct costs
Gross profit=1,383,800-583,800=800,000
:gross profit = 800,000
Gross profit margin = gross profit *100

Sales
Gross profit margin = 800,000*100%

1,383,800
= 57.81 %
Total expenses for one year = 291,000
Break-even – level = expenses * 100%

Gross profit margin
= 291,000 *100%

57.80%
= 503,379.20”

The desired financing

ITEM

AMOUNT

Pre-operation cost

79,000

Workng capital

242,000

Total desired financing

321,000

The proposed capitalizations

Owners contribution

300,000

Loan from bank

300,000

Total investment

600,000

The expected profitability ratio
“Gross profit margin = gross profit * 100

Sales
Year 2007 = 800,000 * 100%

1,383,800
= 47.06%
Year 2008 = 830,500 * 100%

1,764,900
= 45.95%

The return on equity

“Return on equity = net profit(after tax) * 100%

Owners equity
For year 2007 = 368,100 * 100%

300,000
For year 2008 = 403,200 * 100%

300,000
For year 2009 = 459,297 * 100 %

300,000
= 153.10%”

The return on investment

“Net profit (after tax)+ interest * 100%

Total investment
Year 2009 = 368,100 + 18,000 * 100 %

600,000

Year 2010= 403,200 + 16,275 * 100%

600,000
= 69.91%
Year 2011 = 459,297 + 16,000 * 100%

600,000
= 79.22%”

References
Bchir, B., Jean-François, T., Rabetafika, H. N., & Blecker, C. (2018). Effect of pear apple and date fibres incorporation on the physico-chemical, sensory, nutritional characteristics and the acceptability of cereal bars. Food Science and technology international, 24(3), 198-208.
Carvalho, V. S., & Conti‐Silva, A. C. (2018). Cereal bars produced with banana peel flour: evaluation of acceptability and sensory profile. Journal of the Science of Food and Agriculture, 98(1), 134-139.

Running Head: WK7 MARKETING
BUDGET

1

WK 7 Marketing Budget

Student

Professor

Institution

Date

Running Head: WK7 MARKETING
BUDGET 1

WK 7 Marketing Budget

Student
Professor
Institution
Date

Warning

W A R N I N G !

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.

Excel 2013 and 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

Your Company Name

Welcome

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

Setup and Assumptions

COMPANY INFORMATION

What is your company’s name?

Jadeddreams

What month will you officially start your company? January

What year will you officially start your company? 2021

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? Five
Sure Product Consulting: Many businesses sell hundreds or thousands of products. It would be overwhelming to create projections for every product you sell. So if you sell many products, think about how you can consolidate them into up to ten product “lines,” and then base your projections on these groups of products instead of each individual product.

Ten

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? 25%
Author: NOTE: for our purposes, this line should NOT include credit card sales, which are, effectively, cash sales because you receive payment in a matter days, not weeks.

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? 30
Author: If, for instance, your terms will be “Net 30,” put 30 here. You may enter Net 10, Net 15, Net 30, Net 60, Net 90, or Net 120.

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
Author: This number should reflect the amount you will spend on ONE FULL-TIME employee–the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).

Approximately how much do you expect to spend per year on benefits for each HOURLY/PART-TIME employee (medical insurance, etc.)? $1,200
Author: This number should reflect the amount you will spend on ONE PART-TIME employee–the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).

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? 15.00%
Author: If you’re not sure what percentage to enter here, leave it at the default (15%).

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. $5,000
Author: In general, this number will include money you plan to personally invest in the business. If you will be receiving loans or investment income from others, you can account for those on the upcoming Capital Investments worksheet instead of here.

At approximately what rate do you expect to be taxed on your net income? 25.00%
Author: If you’re not sure what percentage to enter here, leave it at the default (25%).

Sure Product Consulting: Many businesses sell hundreds or thousands of products. It would be overwhelming to create projections for every product you sell. So if you sell many products, think about how you can consolidate them into up to ten product “lines,” and then base your projections on these groups of products instead of each individual product. If you will use an interest-bearing account for your banking, at what rate will you accrue interest? 1.00%
Author: If you’re not sure what percentage to enter here, leave it at the default (1.00%).

Author: NOTE: for our purposes, this line should NOT include credit card sales, which are, effectively, cash sales because you receive payment in a matter days, not weeks.

Author: If, for instance, your terms will be “Net 30,” put 30 here. You may enter Net 10, Net 15, Net 30, Net 60, Net 90, or Net 120.

Author: If you’re not sure what percentage to enter here, leave it at the default (15%).

Author: This number should reflect the amount you will spend on ONE FULL-TIME employee–the worksheets will automatically multiply this amount by the total number of employees you expect to hire, as shown in the Staffing Budget worksheet (automatically adusting the numbers for full- and part-time employees accordingly).

Author: In general, this number will include money you plan to personally invest in the business. If you will be receiving loans or investment income from others, you can account for those on the upcoming Capital Investments worksheet instead of here.

Setup & Assumptions

SalesProj

Sales Projections
Author: For information about this worksheet, see the chapter “Marketing Plan & Sales Strategy” in Successful Business Plan: Secrets & Strategies. 2021 2022 2023 2024 2025

Assumptions January February March April May June July August September October November December TOTAL January February March April May June July August September October November December TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter TOTAL

Product Line 1
Author: Change the text in this cell to reflect the name of a major product, product line or service your firm will offer.

Unit Volume 2.00%
Author: MONTHLY VOLUME GROWTH RATE
The Worksheets automatically increase the volume in each month on this line using the rate you enter here.

You can also enter each cell’s value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc. 0
Author: Enter the number of units you expect to sell during this month. If you are running a service-based company charging on an hourly basis, enter the number of billable hours you expect you and your employees to work during this month. If you will be selling your service on a per-project basis, enter the number of projects you expect to sell during this period. 0
Sure Product Consulting: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business. 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly! 0 0 0 0 0 0 0 0 0 0

Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE

This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don’t stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates).

As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here.

You can also enter each cell’s value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc.

Sure Product Consulting: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business. $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate. $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Commissions) 50.00%
Author: COMMISSIONED SALES
What percentage of this product line’s sales will be made on commission? In other words, what percentage of your sales will be made by a salesperson who is paid commission?

Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business. 15.00%
Author: SALES COMMISSION RATE
What will be the commission rate paid to your salesperson for each sale? $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Returns and Allowances) 3.00%
Author: RETURNS AND ALLOWANCES
A percentage of your products will be returned due to defects, etc. What do you estimate will be the rate of return? This is, of course, just an estimate–but it is important to anticipate losses. Refunds, breakage, spoilage, theft, and unsaleable excess inventory can all put a significant dent in your net sales. $0.00 $0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0 $0.00 $0.00 $0.00 $0.00 $0 $0.00 $0.00 $0.00 $0.00 $0 $0.00

Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Cost of Goods Sold) 50.00%
Author: COST OF GOODS
Approximately what percentage of your product’s sale price will be spent on manufacturing? If you are a reseller or retailer, what percentage of your product’s sale price will be spent on buying the product from your distributor? A service business may not need to track cost of goods, in which case you can set this number to zero. $0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

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

Product Line 2
Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.

On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide

On Excel 2007 & 2010 for Windows
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Unit Volume 5.00% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly! 0 0 0 0 0 0 0 0 0 0

Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE

This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don’t stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates).

As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here.

You can also enter each cell’s value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc. $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate. $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

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

Product Line 3
Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.

On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide

On Excel 2007 & 2010 for Windows
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly! 0 0 0 0 0 0 0 0 0 0

Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE

This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don’t stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates).

As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here.

You can also enter each cell’s value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc. $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate. $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

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

Product Line 4
Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.

On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide

On Excel 2007 & 2010 for Windows
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly! Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly! 0 0 0 0 0 0 0 0 0 0

Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE

This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don’t stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates).

As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here.

You can also enter each cell’s value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc. $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate. $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

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

Product Line 5
Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.

On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide

On Excel 2007 & 2010 for Windows
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly! Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly! 0 0 0 0 0 0 0 0 0 0

Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE

This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don’t stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates).

As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here.

You can also enter each cell’s value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc. $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate. $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Cost of Goods Sold) 50.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

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

Product Line 6
Author: If you only have less than 10 product lines, you can’t delete the rows for excess product lines, but you can them hide them. If the cells are hidden, they won’t be included in the subtotals at the bottom of this worksheet.

On Excel 2011 for Mac:
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Format->Rows->Hide

On Excel 2007 & 2010 for Windows
1) Select the rows to hide by click on the row headers along left edge of Excel window
2) Right click to pop up a context menu
3) From the menu, select “Hide”

Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly! Unit Volume 2.00% 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly! 0 0 0 0 0 0 0 0 0 0

Unit Price 2.50%
Sure Product Consulting: YEARLY PRICE GROWTH RATE

This cell shows how much you plan to increase prices each year. It is not per month because consumers typically don’t stand for frequent price changes. After one full year, we increase the unit price by X%, then again after 2 years, etc. The default is 2.5% per year, close to inflation rates).

As a convenience, the Worksheets can automatically increase the unit price for each month using the rate you enter here.

You can also enter each cell’s value by hand, if you prefer, which makes sense if you need to show ups and downs in sales due to seasonal fluctuations, etc. $0.00
Author: Enter your sales price for each unit here. If you are running a service-based company, enter your hourly rate or approximate per-project rate. $0.00
Author: As a convenience, the Worksheets will automatically copy the number you put in the prior cell into this cell. However, you should feel free to overwrite the copied number with whatever makes more sense for your business. $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gross Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Commissions) 50.00% 15.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Returns and Allowances) 3.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Net Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

(Cost of Goods Sold) 50.00% $0

error: Content is protected !!