By Connie D at September 26 2019 13:54:54
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.
So here is how you would do it: Projected sales = fixed exp (足ꯠ) divided by 1_ƖǑ% + 27ǔ% + 12ǔ% + 25% (your new profit margin) = 造같 (new sales). You can do this for as many years out as you want. Obviously this is based on your first year's fixed expenses remaining constant and no consideration of depreciation, inflation, or taxes.