015 57d2b322a90e Screen20shot202018 2320at2010 5720am Month Business Plan Excel

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.

There is no doubt it would take some time and would require a lot of calculations, but when you understand these principles and know how to put it together, you could probably do it. What do you think? Have you ever thought about doing a plan like this? It's actually kind of in reverse. You decide what you want and let your business give you that. Now assuming you did do this and it looked reasonable to you, how would you go about making it happen? What approach would you use? This could be a little harder. Well let me show you something. It might be easier than you think.

544 Shares
389 Pins
488 Tweet
500 Shares
63 Shares
207 Shares