How do you calculate annual forecast?
The formula is: sales forecast = estimated amount of customers x average value of customer purchases.
How do you calculate monthly projections?
You can find your projected income by multiplying your total estimated sales by how much you charge for each item you sell: Projected income = estimated sales * price of each product or service.
How do you create a forecast plan?
To calculate Month-over-Month growth, subtract the first month from the second month and then divide that by the last month's total. Multiply the result by 100 and you're left with a percentage. The percentage is your Month-over-Month growth rate.
To forecast by units, you predict how many units you're going to sell each month—using the bottom-up method of course. Then, you figure out what the average price is going to be for each unit. Multiply those two numbers together and you have the total sales you plan on making each month.
To calculate the average sales over your chosen period, you can simply find the total value of all sales orders in the chosen timeframe and divide by the intervals. For example, you can calculate average sales per month by taking the value of sales over a year and dividing by 12 (the number of months in the year).