Operations, Technology, Management, and Social Responsibility Plan (With Financials) Overview In this assignment, you will focus on these sections of your business plan: Operations. Te
Week 8 Assignment – Operations, Technology, Management, and Social Responsibility Plan (With Financials)
Overview
In this assignment, you will focus on these sections of your business plan:
- Operations.
- Technology.
- Management and Organization.
- Social Responsibility.
- Financials.
You will revise the Operations, Social Responsibility, and Financials sections based on the feedback you received in the discussion threads and any changes you want to make to your business plan.The Technology and Management and Organization sections are new. You have not worked on these sections in your discussion threads.The assignment consists of two parts:
- The business plan (an MS Word document).
- Business plan financials (using the Business Plan Financials Excel Template).
To successfully complete this assignment, you must attach both documents to the submission area as separate files and then click Submit.
Reminders and Notes
- Your chosen company 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 use the snack food company scenario or the company of your choice:
- You are not starting this assignment from scratch. You have already worked on these sections of your business plan in the weekly discussions:
- Operations (Week 5 discussion).
- Social Responsibility (Week 6 discussion).
- Financials (Week 7 discussion).
Part 1: Business Plan
Write a 4–8 page paper, in MS Word, in which you provide the specified information in each section.
Operations Section (1–2 pages)
Notes
- Chapter 11, “Operations,” pages 195–218, of your textbook provides information about developing an operations plan. The chapter also provides a sample operations plan. You've already read this chapter in Week 5. Refer to it on an as needed basis as you work on this section of your business plan.
- Assign a dollar amount to each operational cost you find; you will need these figures for your financials (Business Plan Financials Excel Template).
- If you are working with the snack food company scenario, be sure to use the information and costs provided in the Snack Food Company Guidelines.
- Revise your post and the feedback you received on it in the Week 5 discussion thread to create your operations plan.
Instructions
- Create an operations plan for your selected company expanding on each of these topics:
- Facilities.
- Consider questions such as these regarding facilities:
- Will you rent or buy your facilities, or will you outsource production to an existing company?
- If you are renting or buying your facilities, what utilities will be required to run the operation?
- What will be the costs associated with any necessary utilities?
- Consider questions such as these regarding facilities:
- Production Process or Description of How Your Business Will Operate If Retail or Service Company.
- Include any equipment you plan to use, if applicable.
- Research needed equipment, such as machines, refrigerators, burners, ovens, and so on.
- Will you rent or buy needed equipment?
- How will you maintain and clean the equipment?
- How will you ensure quality control?
- What capacity do you intend to reach?
- If you have a retail or service business, consider any equipment you might need in your process.
- Explain your approach to inventory, as applicable.
- Where do your supplies come from?
- What is your turnaround time to produce your product once you have received an order?
- Include any equipment you plan to use, if applicable.
- Research and Development.
- How will you stay abreast of new developments in the industry?
- What new products or services are in development?
- Personnel Needs in Operations.
- How many operations employees do you plan to have?
- What will their roles be?
- Facilities.
Technology Section (1–2 pages)
Notes
- Chapter 12, “Technology Plan,” pages 225–234, of your textbook provides information about developing a technology plan. The chapter also provides a sample technology plan. You've already read this chapter in Week 5. Refer to it on an as needed basis as you work on this section of your business plan.
- Assign a dollar amount to each technology cost you find; you will need these figures for your financials (Business Plan Financials Excel Template).
- If you are working with the snack food company scenario, be sure to use the information and costs provided in the Snack Food Company Guidelines.
- Consider the type of technology your selected company will use to conduct activities, such as managing personnel; taking, fulfilling, and tracking orders; managing inventory; communicating with customers and providing customer service; and producing your product or providing your service.
Instructions
- Create a technology plan for your selected company expanding on each of these topics:
- Software Needs.
- Examples of software you might need include graphics, customer relationship management, accounting, inventory, and office suite.
- Hardware Needs.
- Examples of hardware you might need include computers, monitors, servers, routers, and tablets.
- Telecommunication Needs.
- Examples of telecommunication equipment you might need include phones, Internet, fax, and mobile phones.
- Personnel Needs in Technology.
- Will your technology personnel be in-house or outsourced?
- Software Needs.
Management and Organization Section (1–2 pages)
Notes
- Chapter 13, “Management & Organization,” pages 235–258, of your textbook provides information about developing a management and organization plan. The chapter also provides a sample management and organization plan. This chapter was part of the assigned reading for this week. Refer to this chapter on an as needed basis as you work on this section of your business plan.
- Be sure to include the salary costs associated with the management personnel; you will need these figures for your financials (Business Plan Financials Excel Template).
Instructions
- Create a management and organization plan for your selected company expanding on each of these topics:
- Key Management Employees.
- List key management team members along with a several sentence description of each person’s relevant business background and responsibilities.
- Advisors.
- List any people you will use as advisors for your business; include a several sentence description of these individuals’ areas of expertise and their expected contribution to the business.
- Management Hierarchy.
- Outline your company’s management hierarchy using the flow charts on page 248 of your textbook as a guide.
- Import/include all charts or diagrams into the MS Word document.
- Key Management Employees.
Social Responsibility Section (1–2 pages)
Notes
- Chapter 14, “Social Responsibility & Sustainability,” pages 259–270, of your textbook provides information about developing your social responsibility plan. The chapter also provides a sample social responsibility and sustainability plan. You've already read this chapter in Week 6. Refer to it on an as needed basis as you work on this section of your business plan.
- Revise your post and the feedback you received on it in the Week 6 discussion thread to create your social responsibility plan.
Instructions
- Create a social responsibility plan for your selected company expanding on each of these topics:
- Impact on Stakeholders.
- Describe the ways your chosen company will impact stakeholders, such as employees, customers, suppliers, and the community. This is the people section of the triple bottom line.
- What types of benefits (such as health care, flexible work hours, and opportunities for advancement and education) will your company offer employees?
- What types of opportunities (such as classes, sponsored events, and assistance to causes and charities) will your company offer the community?
- Describe the ways your chosen company will impact stakeholders, such as employees, customers, suppliers, and the community. This is the people section of the triple bottom line.
- Environmental Impact.
- Explain how your company’s activities will affect the environment.
- Identify the steps you will take to mitigate any negative impacts.
- How will you minimize your ecological footprint in your operations? Consider energy usage, waste disposal, recycling, using recycled materials, et cetera.
- Impact on Stakeholders.
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 professor’s 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.
Part 2: Business Plan Financials
Revise the Business Plan Financials Excel Template based on feedback from the Week 7 discussion thread and changes you make to your business plan.
- Be sure the numbers in the Business Plan Financials Excel Template match any numbers included in the Operations, Technology, and Management and Organization sections of your business plan narrative.
- Remember that the guidelines, whether for your own startup company or for the snack food company scenario, provide helpful information on completing the worksheets within the Business Plan Financials Excel Template.
Learning Outcomes
WelcomeDemo
Welcome! | |
Thank you for trying out Business Plan Financials from Planning Shop. 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, The Successful Business Plan: Secrets & Strategies, by Rhonda Abrams, for comprehensive, step-by-step guidance. It is available through our website, www.PlanningShop.com. Note that this demo copy of Business Plan Financials is deliberately feature-limited. We restrict you to just one product, one capital investment, one loan and 5 capital expenditures. If you purchase the Business Plan Financials, you get access to up to 10 products, 60 capital expenditures, 15 capital investments, and 20 loans. Also, the watermark that appears and prints on each page willbe removed. To use the Business Plan Financials workbook, first go to the Planning Shop tab of the Excel Ribbon. | |
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 in-depth help and assistance, click on the "Business Plan Financials Help" menu in the toolbar. The help files contain extensive information about each worksheet, along with a "Frequently Asked Questions" (FAQ). To get started, click on the right-pointing arrow in the Planning Shop toolbar to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business. | |
Version 2.7 Copyright © 2003-2012 Planning Shop |
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 2007 for Windows: To enable macros: 1. Click the "Options" button in the Security Warning that appears at the top of this page. | |||
2. A "Security Alert – Macros & Active X" window should appear. 3. Select the "Enable this content" radio button 4. Click the "OK" button. Your workbook should be ready to use now. If you do not see the "Security Warning" along the top of this page, scroll down for more detailed instructions, under "Excel 2007 on Windows – Enabling Macros" | |||
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 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 2010 for Mac: 1. A pop-up window appears. Select "Enable Macros". 2. Your workbook should now be ready to use. | |||
Excel 2008 for Mac: Excel 2008 for Mac does not support Macros or Visual Basic, so there is no way to enable the macros. Please obtain a Mac 2008-only version of Business Plan Financials from PlanningShop. | |||
Excel 2007 on Windows – Enabling Macros | |||
1. From the Windows Ribbon, Select the circular "Windows" button in the upper left. 2. From the drop-down menu that appears, press the Excel Options button in the lower right. | |||
3. From the "Excel Options" pop-up, select Trust Center on the left side. 4. Select Trust Center Settings…. In the lower right. | |||
5. In the "Trust Center" pop-up, select "Macro Settings" on the left side. 6. Then, select the Disable all macros except digitally signed macros. (This works because the Planning Shop signs all its workbooks with digital certificates.) 7. Press OK twice. | |||
Excel 2010 and Excel 2013 on Windows – Enabling Macros | |||
Note: The procedure is exactly the same for Excel 2010 and Excel 2013, even though the Excel 2013 has a slightly different look than these screenshots. 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
ERASE ME WelcomeMac
Welcome to the Mac Version of Business Plan Financials | |
Thank you for purchasing Planning Shop's Business Plan Financials. 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, The 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: 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 "ORIGINAL_PlanningShop_BusinessPlanFinancialsMac(2.7)" 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. You installed the Mac version of the Business Plan Financials product, which does not have the Planning Shop tab available in the Excel Ribbon (unlike the Windows version). Instead, to navigate between worksheets and charts, use the Excel worksheet tabs along the bottom edge of the Excel window. | |
Start with the "Setup" worksheet. Enter your data, and then work your way through the workbook, one worksheet at a time, by clicking the next worksheet to the right. There are 23 worksheets/charts in this workbook. The last one (furthest to the right) is "NS5Yr." 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 in-depth help and assistance, refer to the Business Plan Financials Help" PDF file in your PlanningShop folder. The document contains step-by-step instructions and includes a "Frequently Asked Questions" section. To get started, find the Excel worksheet listing (each worksheet is listed on a tab) along the bottom of the Excel window. Click on the "Setup" tab to reach the "Setup and Assumptions" worksheet, where you'll enter some basic information about your business. | |
Version 2.7 Copyright © 2003-2012 Planning Shop |
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 2007, Excel 2010, Excel 2013, but the functionality is the same. | |
Excel 2007 for Windows: | |
Excel 2010 for Windows: | |
Excel 2013 for Windows: | |
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, click on the "Business Plan Financials Help" menu in the toolbar. The help files contain 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. | |
Version 2.8 Copyright © 2003-2014 PlanningShop |
MacVsWindows
About Our Support of Mac vs. Windows | |||||||
PlanningShop supports Business Plan Financials on the following platforms: | |||||||
Windows | |||||||
1. Microsoft Windows 8 with Microsoft Excel 2013 | |||||||
2. Microsoft Windows 7 with Microsoft Excel 2010 | .� | ||||||
3. Microsoft Windows 7 with Microsoft Excel 2007 | |||||||
4. Microsoft Windows Vista with Microsoft Excel 2007 | |||||||
Mac | |||||||
5. Mac OS X Lion (10.7) with Microsoft Excel 2011 | |||||||
If you use Windows (#1 – #3 above), then you need to install PlanningShop_BizPlanFin(2.8).exe. | |||||||
If you use Mac (#4 above), you need to install PlanningShop_BizPlanFinMac(2.8).dmg | |||||||
Differences between Mac and Windows | |||||||
Both the Mac and Windows versions of PlanningShop's Business Plan Financials product will produce high quality, detailed financial information for your business plan. However, there are some slight differences between the functionality in Mac and Windows. These differences don't affect the data in your business plan, but they do affect the user-friendliness of the Business Plan Financials workbook. We did our very best to make the Windows and Mac versions as similar as possible. However, Microsoft does not support customization of the Excel toolbar on Mac. Therefore, while we made every effort to preserve as much functionality as possible on the Mac, there were a few things we were not able to do: | |||||||
1) There is no PlanningShop Toolbar in the Business Plan Financials for Mac. Instead, you will need to navigate between worksheets and charts using the Excel worksheet tabs (along the bottom edge of the workbook). | |||||||
2) Business Plan Financials Help is not available directly from Excel. Instead, you should open the BizPlanFin_Help(2.7).PDF file that was copied to your Mac alongside the PlanningShop_BizPlanFinMac(2.8).XLS or PlanningShop_BizPlanFinMac(2.8).XLSM file. | |||||||
We are as disappointed as you are that we can't provide the same level of functionality in Mac as we do for Windows. We very much hope that Microsoft will remedy the situation in the next release of Excel for Mac, and that we'll then be able to offer identical functionality. | |||||||
Moving your Business Plan Financials workbook between Mac and Windows | |||||||
We advise you to completely edit your Business Plan Financials workbook on either Mac or Windows, and to not switch between the two platforms. If you switch between platforms, you may find that the Planning Shop toolbar, menus, online help, and macros permanently disappear. | |||||||
Setup
Setup and Assumptions | |||||||||
COMPANY INFORMATION | |||||||||
What is your company's name? | |||||||||
KoKoKrispies | |||||||||
What month will you officially start your company? | July | ||||||||
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? | Three 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 any number of days between 0 and 120. |
||||||||
PERSONNEL ASSUMPTIONS | |||||||||
Approximately how much do you expect to spend per year on benefits for each SALARIED/FULL TIME employee (medical insurance, etc.)? | $30,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.)? | $36 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. | $100,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 any number of days between 0 and 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. |
2020 | 2021 | 2022 | 2023 | 2024 | ||||||||||||||||||||||||||||||||||||||||||
Assumptions | July | August | September | October | November | December | January | February | March | April | May | June | TOTAL | July | August | September | October | November | December | January | February | March | April | May | June | TOTAL | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | TOTAL | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | TOTAL | |||||||||||
Rice Krispies – Original 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 | 3.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. |
800 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. |
824 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. |
849 | 874 | 900 | 927 | 955 | 984 | 1013 | 1044 | 1075 | 1107 | 11354 | 1141 | 1175 | 1210 | 1246 | 1284 | 1322 | 1362 | 1403 | 1445 | 1488 | 1533 | 1579 | 16188 | 5027 Author: Note that in year three we use quarterly numbers, not monthly numbers–so make sure you enter your amounts accordingly! |
5493 | 6002 | 6558 | 23080 | 7167 | 7831 | 8557 | 9351 | 32906 | 46916 | |||||||||
Unit Price | 5.00% 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. | $50 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. |
$50 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. |
$50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $53 | $53 | $53 | $53 | $53 | $53 | $53 | $53 | $53 | $53 | $53 | $53 | $55 | $55 | $55 | $55 | $58 | $58 | $58 | $58 | $61 | ||||||||||||
Gross Sales | $40,000 | $41,200 | $42,436 | $43,709 | $45,020 | $46,371 | $47,762 | $49,195 | $50,671 | $52,191 | $53,757 | $55,369 | $567,681 | $59,882 | $61,678 | $63,529 | $65,435 | $67,398 | $69,420 | $71,502 | $73,647 | $75,857 | $78,132 | $80,476 | $82,891 | $849,847 | $277,088 | $302,781 | $330,857 | $361,536 | $1,272,262 | $414,814 | $453,278 | $495,309 | $541,238 | $1,904,638 | $2,851,337 | ||||||||||
(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? |
$3,000 | $3,090 | $3,183 | $3,278 | $3,377 | $3,478 | $3,582 | $3,690 | $3,800 | $3,914 | $4,032 | $4,153 | $42,576 | $4,491 | $4,626 | $4,765 | $4,908 | $5,055 | $5,206 | $5,363 | $5,524 | $5,689 | $5,860 | $6,036 | $6,217 | $63,738 | $20,782 | $22,709 | $24,814 | $27,115 | $95,420 | $31,111 | $33,996 | $37,148 | $40,593 | $142,848 | $213,850 | |||||||
(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. |
$1,200.00 | $1,236 | $1,273.08 | $1,311.27 | $1,350.61 | $1,391.13 | $1,432.86 | $1,475.85 | $1,520.12 | $1,565.73 | $1,612.70 | $1,661.08 | $17,030 | $1,796.46 | $1,850.35 | $1,905.86 | $1,963.04 | $2,021.93 | $2,082.59 | $2,145.07 | $2,209.42 | $2,275.70 | $2,343.97 | $2,414.29 | $2,486.72 | $25,495 | $8,312.63 | $9,083.43 | $9,925.71 | $10,846.09 | $38,168 | $12,444.41 | $13,598.34 | $14,859.27 | $16,237.13 | $57,139 | $85,540.10 | |||||||||
Net Sales | $35,800 | $36,874 | $37,980 | $39,120 | $40,293 | $41,502 | $42,747 | $44,029 | $45,350 | $46,711 | $48,112 | $49,556 | $508,075 | $53,594 | $55,202 | $56,858 | $58,564 | $60,321 | $62,131 | $63,994 | $65,914 | $67,892 | $69,928 | $72,026 | $74,187 | $760,613 | $247,993 | $270,989 | $296,117 | $323,575 | $1,138,674 | $371,258 | $405,684 | $443,302 | $484,408 | $1,704,651 | $2,551,946 | ||||||||||
(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. |
$20,000.00 | $20,600 | $21,218 | $21,855 | $22,510 | $23,185 | $23,881 | $24,597 | $25,335 | $26,095 | $26,878 | $27,685 | $283,841 | $29,941 | $30,839 | $31,764 | $32,717 | $33,699 | $34,710 | $35,751 | $36,824 | $37,928 | $39,066 | $40,238 | $41,445 | $424,923 | $138,544 | $151,390 | $165,428 | $180,768 | $636,131 | $207,407 | $226,639 | $247,65
Collepals.com Plagiarism Free Papers Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers. Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS Why Hire Collepals.com writers to do your paper? Quality- We are experienced and have access to ample research materials. We write plagiarism Free Content Confidential- We never share or sell your personal information to third parties. Support-Chat with us today! We are always waiting to answer all your questions. All Rights Reserved Terms and Conditions |