By Lika Ramlal at May 02 2019 21:16:46
Business Plan Analytics Through Key Performance Indicators (KPI's): Identifying key performance indicators for your business to use as benchmarks throughout the year is perhaps the most critical step you can make with regard to business analytics. Not only will KPI's help identify key shortfalls in the plan, but will help narrow your focus in addressing the shortfalls. For instance, recognizing that you have an issue in labor isn't merely enough when you consider the following possibilities: a) labor rates may be too high; b) overtime has exceeded its budget; c) the issue is regionally_based, not across the board; d) man hours may have exceeded its allocated budget, etc. It could be a myriad of triggers that caused labor to exceed its budget and KPI's enable you to drill down to the cause. KPI management requires a disciplined review process established monthly that fosters a blended analysis throughout the year that compares actual results against both budgets and forecasts.
The main thing to remember in this section is not to provide new data, but to explain in detail data that has already been provided and to provide the support for that data. When you sit down to compile all of the elements of your business plan, make sure you have each section able to stand on its own merits. This means you should not reference other sections sending the reader (your potential investor) back and forth between sections.
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.
As an example, let's say your current average number of transactions per month per customer is 3ǌ. Which says on average each customer does business with you 3 times each month. You could calculate how much more profit you would get if you could increase it to 3Ǒ. And I can tell you that would probably be enough to meet your plan. And if that did generate enough profit, all you would have to do is maintain everything else; sales, expenses, labor, average dollar sale, etc, and then just figure out how you could increase your transactions from 3ǌ to 3Ǒ. Maybe it could be with some type of promotion that would get customers to come in more often.