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.
With this information you can actually predict not only what your sales will be, but you can see how much your fixed and variable expenses will be, what your labor cost will be, your material cost, and your profit. So let's first look at what exactly are fixed expenses? They are exactly what they say they are; they are fixed. This simply means these are expenses that are ongoing whether you have a lot of sales or Ŕ" sales. They are expenses like utilities, taxes, rent, salaries other than the wages used in the making of the actual product or doing a service, business fees, telephone, etc. See how these expenses would continue on even if you have 0 sales? Any expenses that fall into this category are fixed expenses. Far too many small business owners never divide their expenses into fixed and variable. As a matter of fact, if you could have a business that had Ŕ" fixed expenses; this would be the best of all worlds, why? If you had Ŕ" sales, you would have Ŕ" expenses. So the closer you could get to this the better you would be.