I NEED A TUTOR TO COMPLETE EXCELL PORTION FOR THIS ASSIGNMENT ASAP. PLEASE SEE ATTACHMENT FOR THE WORD PORTION This assignment consists of two sectio -

I NEED A TUTOR TO COMPLETE EXCELL PORTION FOR THIS ASSIGNMENT ASAP. PLEASE SEE ATTACHMENT FOR THE WORD PORTION
This assignment consists of two sections:

Marketing plan and sales strategy (an MS Word document).
Marketing budget (using the Business Plan Financials Excel Template).

Don't use plagiarized sources. Get Your Custom Assignment on

I NEED A TUTOR TO COMPLETE EXCELL PORTION FOR THIS ASSIGNMENT ASAP. PLEASE SEE ATTACHMENT FOR THE WORD PORTION This assignment consists of two sectio

From as Little as $13/Page

To successfully complete this assignment, you must attach both documents to the submission area as separate files and then click Submit.
Reminders

Your company, whether it’s a startup you created or one based on the snack food company scenario, will operate in a 100-mile radius from your home address. Your goal is to reach $1 million in sales by the end of the second year.
Be sure to follow the guidelines, whether you chose the snack food company or your own startup company.

Snack Food Company Guidelines [DOCX].
Company of Your Choice Guidelines [DOCX].

Section 1: Marketing Plan and Sales Strategy
In MS Word, write the 35 page marketing plan and sales strategy section of your business plan, in which you:

Revise the companys target market based on the feedback received in the Week 3 discussion thread.

Be sure to include demographic, geographic, lifestyle, psychographic, purchasing patterns, and buying sensitivities in the target market description.

Assess your chosen companys market competition.

Use the factors listed in the graphic in your textbook labeled Assess the Competition (page 125), to assess the companys market competition.

When assessing the competition, specify the exact company and particular product or service you are competing against. For example, Coca Cola offers a portfolio of products, such as water, fruit juice, and cola. Are you competing against Coca Colas fruit juice product? Or its cola product?

Be sure to detail your plan to differentiate yourself from the competition.

Outline the company’s value proposition and create a marketing slogan/tagline for the product.

The value proposition tells your customers why they want to do business with you.
You need to know what message you want to convey in your marketing slogan before selecting the marketing vehicles in the next step.

Specify the marketing vehicles you will use to build your chosen companys brand and justify the key reasons they will be effective.

Marketing vehicles are ways to promote your product. Examples include social media, sponsored events, trade shows, and sampling. You will use a combination of these tactics.
Planning to use online marketing tactics? Consult the Online Marketing Tactics worksheet on page 177 of your textbook to guide your response.

Formatting
Format your assignment according to these requirements:

This course requires the use of Strayer Writing Standards (SWS). For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course.
Typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
You must include headings in your paper for each major topic.
Include a cover page containing the assignment title, your name, the professors name, the course title, and the date. The cover page is not included in the required page length.
Include a source list page. All sources used must be listed in the source list page and have a corresponding in-text citation. Citations and references must follow SWS format. The source list page is not included in the required page length.

Note: There is no minimum requirement for the number of resources used in this assignment.

Section 2: Marketing Budget
In this portion of your assignment, you will develop a marketing budget. This budget is critical to helping you determine how much it will cost you to reach your market and achieve your sales goals. To create your marketing budget, you will use the Business Plan Financials Excel Template. This is the document you downloaded using the access code you purchased from the Strayer Bookstore.
Reminders

You will complete only the Setup and Marketing Budget worksheets for this assignment; be sure to submit the entire Excel Template, however.
You have already worked on your marketing budget in the Week 5 discussion. Incorporate information from your post and the feedback you received into this section of your assignment.

Instructions
Develop a marketing budget, supporting your marketing plan and sales goals, in which you:

Prepare the Setup worksheet for your selected company based on the appropriate guidelines instructions.
Prepare the Marketing Budget worksheet for your selected company based on the appropriate guidelines instructions. When filling out the Marketing Budget worksheet in the Business Plan Financials Excel Template, do the following:

Begin with the current year and complete a marketing budget for the businesss first two years.
Leave at zero any marketing vehicles you do not plan to use.
Reminder: All marketing activities involve costs. If social media represents a significant portion of your marketing plan, assume you will incur advertising costs; reflect these in your marketing budget. Even if a social media site charges nothing to use it, you will need to use company resources to manage the site, execute your social media marketing campaigns, and most likely pay for ads on that site.
Do not leave the Marketing Budget worksheet blank assuming you will not have any marketing costs.
Do not complete all the rows; only fill in the costs for the marketing vehicles you will actually use. These must match the content you described in Item 4 of Section 1 of this assignment.

Learning Outcomes
The specific course learning outcome associated with this assignment is:

Create a marketing plan for a company that identifies a target market, market competition, a company message, marketing vehicles, and a budget.

SNACK FOOD COMPANY MARKETING PLAN AND SALES STRATEGY 1

Snack Food Company Marketing Plan and Sales Strategy

Veronique Duperval

Andrea Banto

BUS 599: Strategic Management

10/08/2020

SNACK FOOD COMPANY MARKETING PLAN AND SALES STRATEGY 2

The companys Target Market

The considerations of many people around the company as low- and middle-income, who

are the immediate consumers of the snacks-popcorns, have a vibrant but price-sensitive

consumption pattern. Income levels are rising due to the rapid urbanization and change in the

consumers’ buying habits. Presently, snacking is considered a pastime that alleviates boredom

that has been adopted socially among many people when they are away from friends. Moreover,

they are used to satisfy hunger pangs on a busy day. The market’s realized trends include: youths

consume more snacks in a day since most of them are not committed to meals, exchange of

snacks among the society as a way of showing friendship and during time pressures majorly for

those schooling (Aghazadeh, 2016)

Due to the somewhat impulse nature of the consumption habits, traditional sales outlets

are considered the best due to their convenience and immediate proximity, unlike the shopping

done form large outlets. Increased demand is indicated by the rapid population increase and the

changing lifestyles in the region. Village settlements that are out of reach of the recent trends in

trade channels are taken into consideration, plus the highly populated urban areas easily

accessible. There is frequent purchasing from the families living on the street, and the presence

of the infrastructure networks that are undeveloped limits the customers’ mass shopping

potential.

Market Competition

In the competitive analysis of the company, opportunities and threats are identified and

will define the company’s functionality regarding its competitors. Snack food and bakery

products are highly competitive in the market. The soft pretzel produced by the J&J Corporation

will stimulate competition in the market. The product quality, services offered to customers,

SNACK FOOD COMPANY MARKETING PLAN AND SALES STRATEGY 3

awareness of brand names, allocated prices to the products, the consumers’ tastes, methods

employed in distribution, and the promotions to promote sales are the factors to be dug upon in

the market set up. The company to come up with a lot of chains that will aggressively expand

hence bringing stiff competition in the market. (Farris et al., 2015)

For the snack food company to achieve its goals in this rivalry among the competitors in

the market, the customers’ requirements are made a priority by being in touch with the needs and

the trends regarding the customers’ choice. Proper identification of the culture and assets of the

company competitors enhances the proper implementation of the required skills. The companys

goal metrics are then connected to the business targets, which, after that, impact the output

products and its readiness. Through innovations that disrupt the status quo, growth will acquire

the consumers who should be retained. There will be a maximized output and pausing where

necessary to manage the current situation and exit the market when necessary. The potential risks

are afterward outlined and will foster the companys adoption of the possible shortcomings in the

business stimulus. Despite the budget being the most substantial dependency, acknowledging

other risks in the planning section is vital for the success of Snack Food Company in this

competitive environment. (Campbell-Hunt, 2015)

Value Proposition and the Tagline

If the customers choose to buy products from the Snack Food Company, they promise to

deliver valuable commodities to them. How the company operates, what it stands for and reasons

for deserving their business is provided by an intent stipulated in the value proposition. The

statement Manufactured from natural products is compellingly worded and will convince the

consumers on the value that is added if they buy the product. The filling of the customers’ needs

by the products, the added benefits in the products and why the products are similar in the market

SNACK FOOD COMPANY MARKETING PLAN AND SALES STRATEGY 4

are explained hence appealing to the customers decision-making drivers. The economic moat of

the company will be maintained, and therefore, the more the moat, the bigger and more resilient

the company becomes the competition. The structure of the proposition is made memorable

hence the tag line, Manufactured from natural products. $10,000 is used in the practice of trading

skills before entering into the real market.

Promotion of the Product

The marketing on our vehicles will aid the implementation of our marketing plans and

strategies for our company. A few channels will also be utilized to promote the organization’s

items. Online networking is a priority to the organization, and therefore Facebook page can be

created by the promoting group to put a few adverts that will foster sales. For sharing photos, an

Instagram record is opened; hence the clients can see most of our food snacks. Regarding the

publicizing organizations and companies like Pepsi utilize the channel. Composing a blog is also

considered shared online through networking that highlights vital components of our products.

Moreover, our products can be advertised through print media channels to provide the customers’

necessary information. (Haleblian et al.,2019). The group occasions that showcase our products

will be supported by the company, which fosters the company’s picture; hence its products are

made famous since their visibility is increased.

In summary, the company should consider fixing cost and time efficiencies, which are

very helpful in depicting constructive responses from the customers of the Food Snacks

company. There will be operational development that is more valuable, and therefore, the

company should strive to keep its stock up in an unchallenged way. The competitive advantages

if taken into account, it will help in being the game-changer.

SNACK FOOD COMPANY MARKETING PLAN AND SALES STRATEGY 5

Reference

Aghazadeh, Hashem (2016). “Business, Market, and Competitive Analysis (BMCA) Tools and

Techniques.” Principles of Marketology, Volume 1. pp. 187247

Farris, P., Bendle, N., Pfeifer, P. and Reibstein, D., Marketing Metrics: The Manager’s Guide to

Measuring Marketing Performance, [E-book edition], FT Press, 2015, Chapter 1

Campbell-Hunt, Colin (2015). “What have we learned about generic competitive strategy? A

meta-analysis”. Strategic Management Journal. 21 (2): 127154.

Haleblian, J.; Mcnamara, G.; Kolev, K.; Dykes, B. (2019). “Exploring Firm Characteristics That

Differentiate Leaders from Followers in Industry Merger Waves: A Competitive Dynamics

Perspective.” Strategic Management Journal. 33 (9): 10371052. Strayer BUS599/ORIGINAL_PlanningShop_BizPlanFin(3.1) BUS599.xlsm

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

Setup

Setup and Assumptions

COMPANY INFORMATION

What is your company’s name?

Your Company Name

What month will you officially start your company? January

What year will you officially start your company? 2017

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? Ten

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

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

Setup & Assumptions

SalesProj

Sales Projections

Author: For information about this worksheet, see the chapter “Marketing Plan & Sales Strategy” in Successful Business Plan: Secrets & Strategies. 2017 2018 2019 2020 2021

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.

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

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

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

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

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, et

Related Questions:

Related questions