Related Posts
BLOG HOME
- Workforce Efficiency Dashboard for SaaS Companies using Dynamics 365 Business Central
- Subscription Billing Auto Forecast for SaaS Companies using Dynamics 365 Business Central
- Pipeline Win Loss Dashboard for SaaS Companies using Dynamics 365 Business Central
- Headcount Dashboard for SaaS Companies using Dynamics 365 Business Central
- Top 50 Opportunities Report for SaaS Companies using Dynamics 365 BC
How to Align Your Business Strategy with Your Reporting, Planning and Analysis: Part 2
This article will continue the discussion of improving these tasks and processes and ensuring that the strategy is aligned with the reporting, planning, and analysis.
Planning consists of creating both an annual budget and forecasts. A forecast can include a rolling-forecast, five-year forecast, monthly forecast, and a quarterly forecast. The process to put together a budget or forecast can be very complex and time-consuming for organizations, but this section will discuss the best practices of the planning process and how it relates to strategy. For budgeting, a good practice is to create a top-down and a bottom-up budget. The top-down budget should be set as part of the strategy session and is an efficient practice to determine if the strategies will be successful. This involves more general increases and decreases, but it would be aligned with the strategy of the company. The bottom-up budget would be determined by the employees after the strategy has been communicated and finalized with the management team and employees involved in the budgeting process. If there is a substantial difference at the end of the two processes, then it must be analyzed to determine the differences. The difficulty is aligning the strategy to the planning process. Many discussions about investments and budget reductions must take place prior to the planning process. For example, it may not be possible to increase revenue by 50% without hiring more employees or cutting departmental costs by 20% without having any loss in production. Therefore, it is imperative that any decisions on investments, hiring, and financing are finalized and documented prior to the start of the planning process. There may be times when a strategy has been set but a manager provides good reasons why the strategy may not work or why the goal is impossible to reach. Meet with the employee and discuss the issues and determine a fair common ground. It is essential that everyone is on board with the strategies and that the goals set are fair and achievable. Below are practices that should be followed to ensure an efficient process:

Image taken from Shutterstock.
- Software: most companies still use native Excel for their planning, but it is difficult to consolidate, prone to errors, contains links that are hard to maintain, and overall can be very time consuming. Purchase planning software that can ensure more efficient tools, fewer errors, less manual work, and better accessibility. Planning software also allows version control, the ability to consolidate, template control, security, and improved reporting and analysis. An Excel add-in product may be the best solution for administrators, as they already have Excel skills and then use a web portal for the end-users to enter their data.
- Standardize: use standardized and secure templates across the organization. Employees should not be able to modify the templates themselves, and the templates should be used across multiple departments rather than each department needing a specific template.
- Workflow: have a practical workflow and timeline that allows management to review status in real-time and reinforce the approval process.
- Timeline: determine the timeline, document it in detail and communicate it to all parties involved. The timeline should include when the budget administrators start the budget, through approval, and finally, consolidation of the budget.
- Lock Down: once the budget is complete, then it should be locked down.
- Process: improve the process to enable more time for decision-making. Use technology to assist in improving the processes and enabling access to data to assist in better decision-making.
- Review Variances: examine variances monthly with department heads and document the reasons for the variances. The comments should be saved and accessible anytime.
- Action Items: determine and document any action items that must be taken to improve negative variances or to enhance positive variances.
- KPIs: create a KPI report for management and separate dashboards for each department head. The dashboard should provide managers with the ability to be observant and prepared for any possible issue that may arise. KPIs should be achievable and clearly visible, and all wins should be celebrated.
- Performance: use KPIs to view the top performers and to ensure that the underperformers are not hiding. The KPIs provide evidence and facts and remove speculation around success and failure.
- All Employees: try to have at least one KPI on every person in the organization. The employee and the manager should have access to the KPI to view at any time.
- Forward Thinking: typically, KPIs are based on what has happened, but include at least a couple of forward-thinking KPIs.
Global Headquarters
Solver, Inc.
Phone: +1 (310) 691-5300