Discover how to enhance decision-making in your organization by focusing on three crucial areas: solving the right problem, gathering all the available information, and understanding the intent. Learn to empower your team, foster a purpose-driven culture, and improve organizational clarity for better decision-making.
What is the hidden risk in your company?
I was recently talking with a friend who was presenting on “Risks within Your Business” to company directors. This topic made me think of all the companies that I had worked with over the years and what was the most significant unrealized threat they faced within the organization. Upon reflection of all of 2 minutes, I concluded that it was Excel!
Yes, it is Excel! Excel has taken over our corporate environments where it is used by finance, marketing, sales, HR, etc. to do everything from planning, budgeting, forecasting, pricing, reconciliation, and analysis. While Excel is a marvelous tool, which undoubtedly made many of these tasks much more manageable, the problem is that anyone can use it and change a model without anyone else realizing it.
There are three areas of concern:
1. Incorrect models.
Many people within organizations develop Excel models to solve problems that they are currently facing. However, many of these models are built using the improper practices that I’ve highlighted in previous blogs. As a result of these practices, other users of the models are not always aware of the model’s shortcomings but still rely on the output to make significant decisions.
In one case, the model’s author had linked all but two of the assumptions to the assumptions page, thus changing the assumptions all but two of them change within the model. As a result, no one was aware that these two assumptions when “off-line” for the model and were making decisions based on incorrect conclusions. While appearing to be an insignificant problem, the lack of connection of these assumptions led to the approval of some projects because they had positive NPVs and good IRRs, but in reality, were terrible projects with negative returns.
2. Hard-Coded Models.
Many models are built using the corrupt practices I have mentioned before. While I have come across many of these, I cannot meet the example given by my friend Rob Brown in his blog post. To have an organization making decisions with an error in their spreadsheet of the order of magnitude of $200 million that no one was aware of is scary. Do you have one of these in your company? Before you answer “No,” are you sure!
3. “Fixed Models.”
More worrying are those models where there is a good model, but then hard-coded change is made to prevent a #N/A or #DIV/0! result. Unfortunately, no one tells anyone about this change, and it left unnoticed for ages. As a consequence, massive errors can arise.
Recently I was working with a company whose budgeting model had some hardcoded adjustments in formulas to adjust sales, compensation, and other budget items. When reviewing this model with the company’s finance department, there was no explanation of why they made these changes. When asked how good the design was for budgeting, the answer I received was, “Last year was a horrible surprise!” As a result, I wrote CEOs Beware: Problems with Financial Modeling. At last check, the company was still using the model!
Recently I was working with a Fortune 500 company that had a model to drive dashboards for the executive team. Somewhere the data had not all been supplied, and so there was a #DIV/0! result. Rather than fix this, someone had changed some formulae to exclude the offending cells and their related data. However, when entering proper results into the offending cells, the dashboard didn’t update to reflect this. The dashboard continued to exclude these outcomes in the actual and historical averages. Who knows how many ad campaigns and how much marketing spend resulted in improving the results when the results were probably already exceeded expectations.
So what to do?
Companies, departments, etc. should review all their models regularly. This review involves someone checking all the calculations, cell references, and links to ensure that the model is performing as expected. A painful task, but undoubtedly better than to keep walking off the cliff, hoping you can survive the landing.
© 2015 Marc Borrelli All Rights Reserved
Recent Posts
Boosting Common Sense Decision-Making in Your Organization
Do You Understand Your Costs to Ensure Profitability?
You can only determine profitability when you know your costs. I’ve discussed before that you should price according to value, not hours. However, you still need to know your costs to understand the minimum pricing and how it is performing. Do you consider each jobs’ profitability when you price new jobs? Do you know what you should be charging to ensure you hit your profit targets? These discussions about a company’s profitability, and what measure drives profit, are critical for your organization.
Sunk Costs Are Just That, Sunk!
If you were starting your business today, what would you do differently? This thought-provoking question is a valuable exercise, especially when it brings up the idea of “sunk costs” and how they limit us. A sunk cost is a payment or investment that has already been made. Since it is unrecoverable no matter what, a sunk cost shouldn’t be factored into any future decisions. However, we’re all familiar with the sunk cost fallacy: behavior driven by a past expenditure that isn’t recoupable, regardless of future actions.
Do You REALLY Know Your Business Model?
Bringing clarity to your organization is a common theme on The Disruption! blog. Defining your business model is a worthwhile exercise for any leadership team. But how do you even begin to bring clarity into your operations? If you’re looking for a place to start, Josh Kaufman’s “Five Parts of Every Business” offers an excellent framework. Kaufman defines five parts of every business model that all flow into the next, breaking it down into Value Creation, Marketing, Sales, Value Delivery, and Finance.
Ideation! Harder Than It Sounds
Bringing in new ideas, thoughts, understanding, and logic is key as your organization faces the challenges of a changing environment. But when you do an ideation session in your organization… how does it go? For so many organizations, many times, after a few ideas have been thrown out and rejected, the thought process slows down very quickly, and a form of hopelessness takes over. How does your organization have better ideation? I’ve come across a new approach with a few teams lately.
Recruit, Recruit, Recruit!
An uptick in business has begun this quarter, and companies are rushing to hire to meet this surge in demand. What amazes me is how many are so unprepared to hire. Continual recruiting is key to the survival of a company. It isn’t the same thing as hiring—continuous recruiting is building a pipeline of people that you would hire if you needed to fill a position, or “A players” you would hire if they were available.
We All Need Clarity
If your organization is focused on obscurity over clarity, whether intentionally or not, your “A” player employees are vulnerable. There is a looming talent crunch. As we start to emerge from COVID, demand is increasing, and many are scrambling to fill positions to meet that demand. Headhunters and recruiters are soon going to be calling your key “A” employees. Have you been giving them a reason to stay?
Not Another **** Meeting
As Leonard Bernstein put it so well, “To achieve great things, two things are needed: a plan and not quite enough time.” Your meetings can be shorter, more fruitful, and engaging, with better outcomes for the organization, employees, and managers. It’s time to examine your meeting rhythms and how you set meeting agendas. This week, I break down daily, weekly, monthly, quarterly, annual, and individual meeting rhythms, with sample agendas for each.
Is Your Company Scalable?
Let’s start here: Why should your company be scalable at all? If your business is scalable, you have business freedom–freedom with time, money, and options. Many business leaders get stuck in the “owner’s trap”, where you need to do everything yourself. Sound familiar? If you want a scalable business that gives you freedom, you need to be intentional about what you sell, and how.
Are you ready for the Talent Crunch?
Companies are gearing up to hire. Unfortunately, many are competing within the same talent pool. Some experts are currently predicting a strong economic recovery starting in May or June. But as the economy booms, there is going to be fierce competition for talent. How will you fare in the looming talent crisis? Your organization should be creating a plan, now, so you can attract the talent you need in the year ahead.