# 008 Business Plan Xls Template 20project Schedule Timeline20eadsheet Free Sample Excel Example

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.

Don't Make Assumptions About Customers _ To be an entrepreneur does require plenty of self_confidence, sometimes almost a bloody_minded determination to make your business work. But this confidence spilling over into thinking that you know what 'the market' wants can be dangerous, without checking that it's true. You need to do your research that the market does ultimately want what you will be offering, whatever products or services you will be selling.

556 Shares
94 Pins
576 Tweet
436 Shares
189 Shares
130 Shares