|
|||||
 |
|
||||
|
Use the Estimate Sales tables to help you calculate the total sales and the cost of goods sold for each product each year. Enter the units to be sold and the sales price per unit. Enter the cost of goods sold per unit. The actual sales and cost of goods total are automatically calculated. Estimate Sales
The cost of goods per product unit are calculated in a separate table to the right (see below), and are automatically added to the Estimate Sales table in the column 'Cost of goods per units'.
The above information is automatically inserted into the Sales Projection worksheet. Enter the sales per month by taking the total yearly amount from the Estimate Sales and divide it using a weighing percentage for each month. All other data is automatically calculated from the information entered. Sales projection worksheets
|
|||||
|
|||||
