This worksheet is for managing product lines (or market areas) and products. The number of products is shown behind each button.
ADDING PRODUCTLINES (or MARKET AREAS)
Include a product line (required)
Add Other Sales (optional)
Add Rebates & Allowances (optional)
Use the 'Add' buttons to add an unlimited number of products to each selected product line.
Estimate sales by Units, Amounts, or Other Sales
Units: you can choose to enter sales for a product by units. The
product will be added with the units row being the entry row.
In the Product details table select a cell in the row of the product you wish to remove, then click the 'Remove a Product' button.
For each product added you'll need to enter the sales price per unit, the
purchase price (or raw material cost), the minimum stock level per month, and
optionally other cost of goods sold.
In the Other sales row (if added), you only need to enter the percentage of the cost of goods items as a % of the total sales amount entered in the 5 year projection.
The sales forecast is generally split into:
Labor cost: If you selected 'Yes' for Manufacturer in the Assumptions worksheet, you can include labor cost as a Cost of Goods Sold. The labor cost will be subtracted from the Personnel cost in the Income Statement as Adjustment COGS Personnel. This is needed to ensure that the costs of production labor is not subtracted twice from your revenues.
Average increase/decrease %
The following 2 years are semi-automated, you only need to enter the Average Increase/Decrease % for Sales price and Cost of goods. You may decide to modify the resulting values. Doing so will of course overwrite existing formulas.