For Dr. Clover Only

profilewaytwomuchfou
StrategicPlanAssignment3Financials.xlsx
Home>Business & Finance homework help>Management homework help>For Dr. Clover Only

Income Projection

Sales Projections
Author: For information about this worksheet, see the chapter "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies.		 2019 2020 2021 2022 2023
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 First Qaurter
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 50.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.		 1000
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.		 3000
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.		 9000 27000 81000 243000 729000 2187000 6561000 19683000 59049000 177147000 265720000 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 0.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.		 $2
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.		 $2
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.		 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $18 $18 $18 $18 $54 $54 $54 $54 $162
Gross Sales $2,000 $6,000 $18,000 $54,000 $162,000 $486,000 $1,458,000 $4,374,000 $13,122,000 $39,366,000 $118,098,000 $354,294,000 $531,440,000 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $72 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Commissions) 30.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?		 10.00%
Author: SALES COMMISSION RATE What will be the commission rate paid to your salesperson for each sale?		 $60 $90 $135 $203 $304 $456 $683 $1,025 $1,538 $2,307 $3,460 $5,190 $15,450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Returns and Allowances) 2.50%
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.		 $50.00 $0 $112.50 $168.75 $253.13 $379.69 $569.53 $854.30 $1,281.45 $1,922.17 $2,883.25 $4,324.88 $12,875 $0.05 $0.05 $0.05 $0.05 $0.05 $0.05 $0.05 $0.05 $0.05 $0.05 $0.05 $0.05 $1 $0.00 $0.00 $0.00 $0.00 $0 $0.00 $0.00 $0.00 $0.00 $0 $0.00
Net Sales $1,890 $2,835 $4,253 $6,379 $9,568 $14,352 $21,528 $32,292 $48,439 $72,658 $108,987 $163,480 $486,661 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $23 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Cost of Goods Sold) 28.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.		 $560.00 $840 $1,260 $1,890 $2,835 $4,253 $6,379 $9,568 $14,352 $21,528 $32,292 $48,439 $144,196 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $7 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GROSS PROFIT $1,330 $1,995 $2,993 $4,489 $6,733 $10,100 $15,150 $22,724 $34,086 $51,130 $76,695 $115,042 $342,465 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $16 $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 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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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"
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!
Author: Change the text in this cell to reflect the name of a major product, product line or service your firm will offer.
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.
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.
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.
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.
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.
Author: SALES COMMISSION RATE What will be the commission rate paid to your salesperson for each sale?
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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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"
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!
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.
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"
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.
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 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
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
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 $0 $0 $0 $0 $0 $0 $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 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"
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!
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"
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.
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.
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!
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.
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.
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!
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.
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.
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!		 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
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 $0 $0 $0 $0 $0 $0 $0 $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 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 7
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 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 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 8
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 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 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 9
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 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 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 10
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 0 0 0 0 0 0 0 0 0 0
Unit Price 2.50% $0 $0 $0 $0 $0 $0 $0 $0 $0 $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 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
Totals for All Product Lines
Total Unit Volume 1000 3000 9000 27000 81000 243000 729000 2187000 6561000 19683000 59049000 177147000 265720000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Gross Sales $2,000 $6,000 $18,000 $54,000 $162,000 $486,000 $1,458,000 $4,374,000 $13,122,000 $39,366,000 $118,098,000 $354,294,000 $531,440,000 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $6 $72 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Total Commissions) $60 $90 $135 $203 $304 $456 $683 $1,025 $1,538 $2,307 $3,460 $5,190 $15,450 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Total Returns and Allowances) $50 $75 $113 $169 $253 $380 $570 $854 $1,281 $1,922 $2,883 $4,325 $12,875 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Net Sales $1,890 $2,835 $4,253 $6,379 $9,568 $14,352 $21,528 $32,292 $48,439 $72,658 $108,987 $163,480 $486,661 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $23 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
(Total Cost of Goods Sold) $560 $840 $1,260 $1,890 $2,835 $4,253 $6,379 $9,568 $14,352 $21,528 $32,292 $48,439 $144,196 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $7 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
TOTAL GROSS PROFIT $1,330 $1,995 $2,993 $4,489 $6,733 $10,100 $15,150 $22,724 $34,086 $51,130 $76,695 $115,042 $342,465 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $1 $16 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Inventory

Sales Projections
Author: For information about this worksheet, see the chapter "Marketing Plan & Sales Strategy" in Successful Business Plan: Secrets & Strategies.		 2019 2020 2021 2022 2023
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 First Qaurter
$0.00
Cost of Goods Sold $0
Author: This Cost of Goods number is pulled over from your Sales Projections and shows how much product you plan to sell each month. It's here simply to aid you in determining how much inventory you need to purchase.		 $1,890 $2,835 $4,253 $6,379 $9,568 $14,352 $21,528 $32,292 $48,439 $72,658 $108,987 $323,181 $0 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $2 $21 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Ingredients $600
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $600 $600 $600 $600 $1,200 $1,200 $1,800 $1,800 $2,700 $2,700 $3,250 $17,650 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Bottles $3,000 $3,000 $3,000 $3,000 $3,000 $6,000 $6,000 $10,000 $10,000 $15,000 $15,000 $25,000 $102,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Caps $300 $300 $300 $300 $300 $600 $600 $1,200 $1,200 $1,800 $1,800 $2,500 $11,200 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cartons $500 $500 $500 $500 $500 $1,000 $1,000 $2,000 $2,000 $3,000 $3,000 $6,000 $20,500 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $4,400
Author: Are these cells showing red? As an aid to you, these cells will show in red until you indicate the purchase of enough inventory to cover your Cost of Goods for the period. In other words, your Total Inventory Expense should equal your Cost of Goods Sold from the SalesProj worksheet. If it isn't, you might need to adjust your % for COGS on the SalesProj worksheet (D12, D22, etc.) 		$4,400 $4,400 $4,400 $4,400 $8,800 $8,800 $15,000 $15,000 $22,500 $22,500 $36,750 $151,350 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0.00
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 and 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"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0.00
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 and 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"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0.00
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 and 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"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0.00
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 and 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"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0.00
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 and 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"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0.00
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 and 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"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0.00
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 and 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"
Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0.00
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 and 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: This Cost of Goods number is pulled over from your Sales Projections and shows how much product you plan to sell each month. It's here simply to aid you in determining how much inventory you need to purchase.
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Author: Are these cells showing red? As an aid to you, these cells will show in red until you indicate the purchase of enough inventory to cover your Cost of Goods for the period. In other words, your Total Inventory Expense should equal your Cost of Goods Sold from the SalesProj worksheet. If it isn't, you might need to adjust your % for COGS on the SalesProj worksheet (D12, D22, etc.)
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 and 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: 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 and 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"		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0.00
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 and 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"

Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 Cost of Goods Sold $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 1 $0
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
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 and 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: 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 and 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"
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
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 and 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: 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 and 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"
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.
Sure Product Consulting: We automatically increase the amount of inventory needed for each part at the same rate as COGS grows on the SalesProj sheet. You can override the automatically entered values by entering in actuals in the blue cells.		 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 2 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 3 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Items/Parts 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Inventory Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
GRAND TOTAL INVENTORY $4,400 $4,400 $4,400 $4,400 $4,400 $8,800 $8,800 $15,000 $15,000 $22,500 $22,500 $36,750 $151,350 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Sheet3