Many of you have suffered through this and hopefully many of you can avoid this. I was working on a project optimizing cost and service level of this product (a transactional process). While I was digging into the model and analysing the data there was something I couldn’t reconcile. As I looked at the data there was another, somewhat related process, that was negatively impacting what I was looking at. Ultimately this related process was driving both a shift in mean and variability in my process.
I began working to prove the impact of the related process but in order to get buy-in from those that oversaw that process I needed to be able to explain what part was driving these differences. The related process had numerous drivers and to identify the one (or more) responsible for the variability to justify a change meant lots and lots of analysis. I spent days and days looking at numbers doing statistical analysis, working from a variety of hypotheses and proving them right or wrong. The result: Even after proving certain hypotheses wrong I still didn’t have my answer.
Every time I’d meet with the necessary people the end result of my meetings would be “what if you looked at it this way? Maybe that will tell us someting.” I’ve discovered that any time this is result of a meeting you are stuck in…..analysis paralysis.
To this day, while I know the answer, I still can’t prove it to a satisfactory level despite the insane number of hours I’ve spent looking at it. As this relates to my last blog post, you need to follow your gut as well and before you start analyzing and pulling in different people you MUST BRAINSTORM what the likely problem is and develop an initial hypothesis. If you begin with the analysis hoping it will drive you to the answer you are running the risk of paralyzing yourself and end up getting no where. Learn from those of us that have fallen into this trap…it will save you time and frustration.
Sometime ago I was working with an “on-again off-again” client looking at an inventory management system (which I’ll call IMS from here on). A friend of mine who works in their industry has been working with them for some time as they were fairly new business owners in a volatile service industry where inventory probably only makes up 20% of their total revenue. They had reached a point where they felt they needed some form of an IMS. Keep in mind this is a very small business, setting up simple triggers in MS Excel could easily suffice.
I had actually helped my friend with this very issue in the past where we cut their inventory while improving service in a matter of eight months, – so he came back to me and explained what these two partners wanted and to see if I could help. We all sat down at a Starbucks and starting discussing their issues. Their presumed solution of leveraging an IMS was derived from volatile spending. Some months they would spend $1,000 in their inventory and other months they would spend $5,000. They felt this was due to a lack of inventory management on their part. They were busy with the service side (more lucrative side) of their business and thought this was an easy solution to a big problem and could build in some consistency to their outgoing cash.
However, after walking through the problem and solution with them, they were operating under a false premise. They assumed that the volatility was driven from two things: Their inability to effectively demand plan and that sales were just an “off and on” thing.
While both of these statements were true, these were not why they had a problem. They had a problem for three different reasons.
After I walked through this with them I explained that while an IMS could be simultaneously implemented and could solve the second issue I noted above, they needed to make other changes. Setting triggers so they are flagged can help and was encouraged, but even with triggers, their spend may have been better managed but I guarantee their service level would have decined because the true issues were not addressed around sales training and understanding each product in their mix.
Don’t work under the presumption that a business owner or manager you are working with knows the true problem. Instead, work with their ideas as hypotheses and do the analysis necessary to either prove or disprove the hypothesis. While they may not know the real problem that doesn’t mean what they are saying won’t get you there. Be intuitive, do your due diligence and stay engaged.
Welcome to my blog. I'm obsessed with marketing, strategy and money. The opinions on this site are just that, opinions. It's your responsibility to do your due diligence and not necessarily listen exclusively to a pontificating six sigma black belt.