No doubt there would be a lot work to do to do a plan like this. You would need to figure out how to put it all together, do all the calculations, do a lot of what if's, etc.. And I'm sure one of the biggest things would be, would you actually take the time to do something like this or even have the time to do it? You could pay someone to do it but that would probably cost you a lot. Plus if you did that, most likely it would require a lot of back and forth work to get it just like you wanted it which would be even more expensive. But even then, would you spend the money to do it? There is a better way. If you would like to develop a nice plan like this for yourself and give yourself a good shot at making your life better, then find a planning software that does it all for you.
So how would you go about calculating all this? There is quite a bit of calculations and you should know a little about business principles but it isn't that complicated. So first let's look at figuring out your future needed sales with this formula: Projected sales = fixed expenses divided by Ƒ_(var exp % of existing sales + mat cost % of existing sales + lab cost % of existing sales + desired net prof %)) So, let's say you existing sales is 迲ꯠ annually, your fixed expenses are 足ꯠ, variable expenses is ็ꯠ or 6Ǒ% of the 迲ꯠ, material cost is 趌ꯠ or 27ǔ%, labor cost is 贍ꯠ or 12ǔ%, and your existing profit margin is 赏ꯠ or 20ǒ%. Now let's say next year you want to have a profit margin of 25% so what would your sales need to be to give you that profit margin? Now you might think you would simply tack on 4ǐ% more to sales ྐྵ% _ 20ǒ%) and you would have it. Well not quiet. it doesn't work that way because you are going to have the additional variable expenses, material cost, and labor cost too. Remember, the more sales the more each of these expenses and cost will be.