Non-Alcoholic Beverage Business Plan Financials Worksheet

Non Alcoholic Beveragebusiness Plan Financials Worksheetguidancebelow

Non-Alcoholic Beverage Business Plan Financials Worksheet Guidance Below is guidance for data to enter into cells of each of the separate Excel worksheets of the overall Business Plan Financials. Please note: Many of the cells in the Business Plan Financials (BPF) are already pre- populated with suggested/default values. Use the default numbers unless otherwise indicated. Only cells with BLUE text can be entered/changed. The cells in black will be filled in automatically, based on your setup assumptions, or will be carried over from numbers you entered earlier on other worksheets.

We suggest working in order – as every cell you complete will carry over to all other applicable Excel worksheets (for example, if you enter a figure in the Staff Budget, that figure will carry over to your Income Statement and Cash Flow Statement). You are encouraged to work through the guide as early as possible. Review the Course Guide for specific due dates on specified worksheets. Worksheet #1 - Set Up and Assumptions Line 9: the month the academic quarter starts Line 12: enter the year the academic quarter starts Line 15: Two (students can write over this to include up to 10 lines) Line 18: they will sell 100% on credit Line 21: 30 days (that’s the default now in BPFs) Line 43: $0 Line 49 $0 Worksheet #2 - Sales Projections Each student must determine this for their business—speculate on how your company will grow and how much you will sell.

Reflect this in/from your Operations Plan Worksheet #3 – Inventory Line 7: Ingredients Line 8: Bottles/caps Line 9: Labels Line 10: Cartons Repeat these four lines for each product line. Worksheet #4 - Capital Expenditures (Note: This applies only to purchased equipment, not leased equipment.) Facilities section: ( Updated 6/30/2015 ) · Students are not purchasing facilities Equipment section: Capital Purchases should be additional expenses that each student might decide to purchase. Vans and other equipment should be captured in Line 23 as part of “Other Assets†in the Balance Sheet, Worksheet 11. Computer Hardware/Software: Capital Purchases should be additional expenses that each student might decide to purchase.

Computers and software provided should be captured in Line 23 as part of “Other Assets†in the Balance Sheet, Worksheet 11. Worksheet #5 - Staffing Budget Account for every paid employee using the appropriate Lines for the six categories of employees (Management, Administrative/Support, Sales/Marketing, Operations/Production, Other, Part-Time/Hourly) and when their employment will commence in accordance with the Operations Plan and Management Plan. Worksheet #6 - Marketing Budget This is submitted with Assignment 2: Marketing Plan Worksheet #7: Professional Services Line 6: $2,000 Line 7: $1,500 Line 9: $2,000 Worksheet #8 - Cap Investment Equity Capital Investments · Line 6: Melinda Cates $40,000 Loans · Line 24: friends and family $20,000; the loan period is 24; the interest rate is 5% Add projections of other funds they intend to raise Worksheet #8 - Income Statement Line 20: $1,000 *Note the Leased equipment in the NAB Company Portfolio.

The Income Statement is submitted with Assignment 3 Part 2: Business Plan – Draft Worksheet #9 - Cash Flow This will be automatically populated from other completed worksheets. Worksheet #10 - Balance Sheet This will be automatically populated from other completed worksheets. Assignment 2: Marketing Plan Due Week 6 and worth 100 points This assignment consists of two (2) sections: a marketing plan and sales strategy, and a marketing budget. Note: You must submit both sections as separate files for the completion of this assignment. For the first six (6) months your company is in business—to give you time to perfect your product and to learn from actual customers—you will start marketing and selling in your own community, a radius of twenty-five (25) miles from where you live.

For most non-alcoholic beverages, marketing (as opposed to the actual product itself) is key to success. Cola drinks, for example, are fairly undifferentiated, as are many energy drinks, juices, bottled water, and the like. Companies producing these types of beverages differentiate themselves and attract market share through marketing and brand awareness—both of which are critical to success. Section 1: Marketing Plan & Sales Strategy (MS Word or equivalent) Write the three to five (3-5) page Marketing Plan & Sales Strategy section of your business plan, in which you: 1. Define your company’s target market. a.

Analyze the types of consumers who will be drinking your beverage in demographic terms (i.e., age, education level, income, gender, ethnic group, etc.). Support your analysis with actual data on the size of the demographic groups in your local community (nearby zip codes). b. Outline the demographic information for your company specified on the worksheet in the course text (p. 107 | Demographic Description ). · Hints: At American FactFinder ( ), you will find demographic information on potential consumers in your area. If you are selling through other businesses (such as grocery stores), indicate the number of those businesses in your local area.

You will find information about such businesses in your local area at County Business Patterns ( ). Check Chapter 2 of Successful Business Plan for more research sources. 2. Assess your company’s market competition. a. Use the factors listed in the course text graphic (p.

123 | Assess the Competition ) to assess your market competition. b. Defend your strategy to successfully compete against market leaders in your segment. · Hints: For example, in the soft drink market, it is intimidating to try to compete against Coke and Pepsi. Newcomers in mature markets typically must pursue niche markets or even create new market categories, as Red Bull did with energy drinks. c. Defend your plan to differentiate yourself from the competition using the information detailed on the worksheet in the text (p. 131 | Market Share Distribution ). · Hints: Every business faces competition and the non-alcoholic beverage market is an especially crowded market.

3. Clarify your company’s message using the information provided on the worksheet in the text (p. 160 | The Five F’s ). · · Hints: Before you choose your marketing vehicles, you must determine the message you want to convey through those vehicles. 4. Identify the marketing vehicles you plan to use to build your company’s brand.

Justify the key reasons why they will be effective. Provide examples of other non-alcoholic beverage companies that use these tactics effectively. · · Hints: If you plan to use online marketing tactics, refer to the worksheet in the text (p.171 | Online Marketing Tactics ) to aid your response. Remember that even if you’re selling through grocery stores you need to build your brand and social media is a major part of that in regard to beverages. Some of the marketing tactics that beverage companies use include: sampling in grocery stores, building a following on social media, sponsoring events, exhibiting at trade shows attended by retailers, and so on. You will use a combination of these tactics.

For example, if you decide to give out samples in grocery stores, promote your sampling on your social media networks and those of the grocery store. · · Hints: If you are planning to distribute through resellers, describe how you plan to reach them, for example, through industry trade shows or by establishing your own sales force. For information on trade shows, visit the Trade Show News Network ( ). You can exhibit or network at these shows. 5. Format your assignment according to these formatting requirements: a.

Cite the resources you have used to complete the exercise. Note: There is no minimum requirement for the number of resources used in the exercise. b. Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow APA or school-specific format. Check with your professor for any additional instructions. c. Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date.

The cover page and the reference page are not included in the required page length. Section 2: Marketing Budget (MS Excel worksheets template) Section 2 uses the “Business Plan Financials†MS Excel template (see: Course Required Files in Week 1). Use the “Business Plan Financials Guide†(see: Course Required Files in Week 1) to support your development of the Marketing Budget. 6. Complete the Marketing Budget worksheet for your company. · · Hints: The goal of the marketing budget is to help you determine how much it will cost you to reach your market and achieve your sales goals. · Hints : When filling out the “Marketing Budget†worksheet in the Excel spreadsheet: · Begin in the current year and complete a marketing budget for the first year of your business.

The information you enter in the marketing budget spreadsheet will flow through to your “Income Statement†in the Business Plan Financials. · Leave the number at zero (0) for any marketing vehicles you do not intend to use. · Remember that all marketing activities involve costs. If social media represents a significant portion of your marketing, assume you will have cost of advertising and that should be reflected on your budget. Even if a social media site charges nothing to use it, you will need to use company resources to manage the site, pay someone to execute your social media marketing campaigns, and will most likely pay for ads on that site. · Do NOT leave the “Marketing Budget†blank, assuming you will not have any marketing costs.

The specific course learning outcomes associated with this assignment are: · Recommend effective business strategies based on an analysis of domestic and global operating environments, market dynamics, and internal capabilities. · Analyze competitive positions including foreign market entry and the resulting impact on business strategy. · Use technology and information resources to research issues in strategic management. · Write clearly and concisely about strategic management using proper writing mechanics. You are a manager in a fictitious company of your choice. Your director has asked you to explain to the department staff the different types of budgets and techniques in order to provide an overall understanding.

For this assignment, you must develop a 2 to 3-page narrative that you will deliver to the department staff and director explaining the different kinds of budgets. Please select or make up your company and its purpose. You will also recommend which type of budget should be used and which budgeting technique would best fit the company. Using an income of 1 Million per year, you must answer the following questions: · What are the various kinds of budgets? Please explain each. · Which type of budget is best for your selected company? · Which type of calendar year will you choose and why?

Remember to use the library or other credible resources to support your argument. Be sure to cite your sources using the correct standard of APA. MGMT 345 Phase 2 IP Business Memo To: Warehouse Manager From: [Your Name] Date: February 25, 2015 Re: Effective Supply Chain Design Enhancing Profitability and Stakeholder Value with Effective Supply Chain Design Supply Chain Networks Supply Chain Drivers Supply Chains and Distribution of Assets and Resources Supply Chain Visual Figure 1: The Food Production Chain.(n.d.). Retrieved from References Do not forget to put your references in alphabetical order (vertically, NOT horizontally by author’s last name, and use only first initials, not first name .

If one of your references begins with the word "The," put the rest of the name first and insert a comma, followed by the word The (example – Associated Press, The.). Author's Last Name, First Initial. (year). Title of article/Internet page . Retrieved from URL here Do Not end with a period (EXAMPLE OF AN INTERNET SOURCE – IF NO DATE IS GIVEN ON THE INTERNET PAGE USE: (n.d.). IN PLACE OF THE YEAR.) Author's Last Name, First Initial. (year).

Title of book . City, ST: Publisher. (EXAMPLE OF A BOOK) Author's Last Name, First Initial. (year, Season). Title of article. Magazine Name, 12 (8), 27. (EXAMPLE OF A MAGAZINE ARTICLE - Note – only capitalize the proper nouns in the title of the article; capitalize all the words in the magazine name; the 12 is where the volume number goes, the 8 is where the issue number goes, the 27 is where the page number goes.) Berube, M. S., ed. (1989).

The American heritage dictionary . New York: Dell. (EXAMPLE OF A DICTIONARY) Bird, I. (1973). A lady's life in the Rocky Mountains (Reprint ed.). New York: Ballantine Books. (EXAMPLE OF A BOOK) Food Production Chain, The. (n.d.). Retrieved from Grant, A.

M. & Berry, J. W. (2011). The necessity of others is the mother of invention: Intrinsic and prosocial motivations, perspective taking, and creativity. Academy of Management Journal. 54 (1), 73-96.

DOI: 10.5465/AMJ.2011. (EXAMPLE FROM OUR BONUS LIVE CHAT, PLEASE VIEW THE BONUS LIVE CHAT TO SEE HOW TO FORMAT A REFERENCE WHEN RESEARCHING FROM THE CTU LIBRARY, WHICH IS REQUIRED FOR THIS TASK)