I confess, last post I slid a little quickly over “You quantify the risks”. ‘Fraid I had to, because it is a significant subject in itself. Entrepreneurs rely on their instinct and experience to appraise risk - but this is qualitative, and sometimes a number estimate can be very helpful.
The financial markets cheat a bit – as discussed earlier, they simply use historical volatility, This may have some benefits, but also serious drawbacks from buried assumptions. In any event, it is neither available, nor useful to an independent business.
So how does an entrepreneur establish risk?
By Guess and by [your deity here]
There is the time honoured method – guess. This has some advantages – its quick, simple, and inexpensive. At least, it is inexpensive if you guess right, otherwise it may be very expensive. The problem is that there is usually little attempt to test the guess properly, by questioning the assumptions you operate under. There is also the reality that you have limited information, and have no analysis to figure out what information might be helpful, let alone where to get it.
Get Other People’s Guesses
Well, this might be an improvement, in that it might get you a different view. Of course, other people have handicaps similar to yours, and so on you have no certainty that their opinions are better than yours. On top of that, they don’t now your business as well as you, and so their opinion may not accommodate the features you bring to the table. Lastly, who are you gonna ask? Your brother, your banker, your spouse, a friend? What is the pool of expertise available to you
Ask a Consultant
I’ m probably biased, but frankly (having been one) they suffer most of the handicaps of “Other People”, and you get to pay for the pleasure. If you are at all like me, I work too hard for my profits to buy advice that doesn’t really help me.
Risk Analysis – Applied Guesswork
Here’s how I do it. Get an envelope – all right a piece of paper. Start with your revenue side, and list what product you will be selling, how much of it, and to whom. List the price point for the product. Identify your competition. Identify the date you expect to start selling. For each of these points, put down three columns. The first is very negative, what you might consider a failure. The middle column is what you consider to be your best guess. The last is the level at which you would feel things were going reasonably well – not ecstatic, just pleased.
Next take a red pen, and note for the negative column what things might cause results to be in that column. These will be your typical sources of revenue risk. Some examples are;
- one of my top three distributors won’t carry the product because of a competitor
- I have to discount my product to buy floor space, since the items are bulky
- I might be late hitting the seasonal market by two weeks, reducing the stocking demand
- 3 of ten items might not fit the market channels I have
Tackle materials in a similar way. What are you buying, from whom, at what price. Your three columns in this case are fiasco, damaging, and acceptable. The base assumption here is that supply is at least acceptable, if not better in some ways, such as cost reductions, feature enhancements, reduced inventory stress and so on. Using the red pen, make notes of what might cause things to enter your three columns. Examples might be;
- my supplier goes bankrupt
- my supplier fails to deliver on time
- my supplier sells more cheaply to my competitor
- the quality of the supplier’s product is sub-standard
- the supplier cannot or will not hold the price
Next we turn to investment in assets. What new assets do you need, where are they coming from, how much will the cost, and what is their productive rate. Once again, make three columns. This time the columns need to be fiasco, fix cost, and adequate. Odd choice, you say. Well, the middle column, “fix cost”, reflects the fact that a piece of equipment may not perform as expected, but is salvageable. Usually you will need to move it to the adequate column, and doing that typically costs money.
Once again, write down in the columns what things might cause this placement. Some examples here are;
- my new NC fabricator needs re-programming frequently, at a cost of $2,000
- I can’t get replacement parts for my chain manufacturing machine
- my pizza oven won’t hold temperature properly, ruins product
- my delivery truck is a lemon
- the ceramic kiln is using 20% more energy than manufacturer spec’d
- my overhead bridge crane continually blows fuses on the winch motor
For each of these pieces of paper, take a pencil, and give each source of risk a likelihood factor – yup, right out of your head. Next for the middle column, make another guess about how much it will cost you to fix the problem, or alternatively, how much it decreases profits in dollar terms.
Ready for the last step in part I? Add up all of the percentages in the fiasco columns – these are risks that cannot be mitigated or reduced. The catastrophic risk is the sum of this column. Next you can tackle column two – for each item multiply the likelihood of the problem and the associated cost or loss. Add them up.
You now have two numbers. The first is a percentage, the second is dollars. Multiply the fiasco risk times the total amount you expect to invest – the weighted risk loss. Add to it the risk mitigation costs/losses. The number you now have is the total weighted risk loss. Compare this to how much you expect to make from the project – the percentage is your first pass at establishing a risk level.
Application Case
I roughed out some of the items above based on the following scenario. An existing distributor of consumer items through chain stores is bringing in a seasonal line of ten items. Expected sales levels are 1,000 units at $50 each, on a cost of $20 per unit. Total revenue expected to be $50,000, gross profit of $30,000, and the investment is $4,000 for marketing collateral.
I have estimated that the risks are
Revenue
- 3 bad items : 20% with an impact of $15,000 revenue reduction – $3,000
- 1 chain store drops out: 5% with an impact of 20% loss of profit - $ 300
- late hitting the market: 10% likelihood loss of 20% of profit - $ 600
- floor Space discount of10% : 10% likely 10% profit fall - $ 500
Materials
- supplier bankrupt : 3% likely, wipes out investment, plus $10,000 cost - $14,000
- late delivery : 10% chance loss of 20% of volume - $ 600
- supplier can’t hold price : 10% likely $5 per unit increase - $ 500
Delivery truck
- truck unreliable : 15% likely rental costs of $5,000 - $ 750
This would give us a 3% catastrophic risk costing us $14,000, plus a weighted risk-cost of $6,250 in losses or mitigation. Relative to the potential profit, the combined risk-cost is some $7,000 or about 23% of the project gross return. This is the risk benchmark.
Refining Your Risk
Ahhh, but we are not finished. We now have a list of potential risks and their impact. Our job as entrepreneurs is to work that list, find ways to reduce the likelihoods, develop contingency plans to deal with those we cannot reduce directly, and so improve our picture.
Now take this list to someone who can provide insight into the specific source of risk, and you have a way to obtain valuable assistance. Note that each sector has its own unique risks, and experience with them. The hospitality sector has shrinkage, and lawsuits from over-serving clientele. The retail sector has inventory writedowns from changing fashions. Manufacturing operations have risks from multiple materials. Construction has the risks of strikes. Service companies have the risks of unreasonable and dissatisfied patrons. No one shoe fits all.
Elaborations
There are more advanced methods of doing these analyses, nor are they conceptually harder than this approach. The next step up is building a spreadsheet model of the proposal, using variables for things like price per unit, cost per unit, and sales levels. Adjusting the variables can demonstrate the impacts more clearly, including variables that work against each other. Further up the scale, simulations can provide more insight, but they are fairly complicated.
At the end of the day, it is the judgement of the entrepreneur in considering the likelihoods, and their creativeness that helps risks go away, that define success.
10 Comments
Ahuh, I see. Well this is a different approach, but there are commonalities. You seem to be treating things more as a driving structure than a decision analysis, but it will handle many of the same issues. Where one of my branches will question for instance, the stability of a supplier, you are itemizing mutiple issues that can effect one driver - source of things for re-sale. It seems a little more in tune with an accountiong structure, or maybe a value chain approach. Worth looking at. Not completely comfortable with the arithmetic of weighting risks by applying outcomes. Seems to me it might tend to minimize certain more volatile risks. But its not bad.
I do this stuff in my head. I evaluate the outcome based on the number of antacids I need to take after thinking about it. I draw a picture in my head - its almost an anime movie. If after viewing the movie in my head I need three rolaids, its not too bad. If I need a prescription, theres a big problem. If I head for the liquor cabinet, its time to plan the exit strategy.
Worsel, remember I use it as a kind of sanity check - a first pass. It gets refined more and more, and for serious work, I turn to a dynamic spreadsheet problem. If it is really serious, I start in with a simulation on core issues in the analysis to test them. But you have to start somewhere, and this is a decent and often useful first tool, especially for those who don’t have anything in their pouch.
Drinkwater - yup, most of us use that approach as well. More tools is better.
Hey, this might have a place in the library - planning to do this one up for us? Maybe add an example of exactly how to proceed, mini-case or something? I’ll talk to Erasmus about how this might fit in. What about some kind of form for members to use as a starting point - sort of a tool for thinking.
Second Dewey on this - frankly I find that having some sort of form helps me get started. If I have to work from scratch, most of the time I don’t do it at all. Let me know if you come up with something.
Dewey - it’ll take a while before I can do it, but I will if you want - patience. I’m still transposing some of these conversations onto the new blog, and I only have so much time to invest. I am maybe a month away from getting it up to date and ready to roll, but I’ll get there. Remember, I still have some learning curve on the blogging thing overall. There are a lot of tricks and details that have developed over the past few years since I first tried this. A lot has changed.
kennym - I’ll try to find some time over the next week to throw together a tool, probably some form of spreadsheet. It won’t be that powerful, but it might get you started. You good with a spreadsheet for a start? When I get you something, I’ll e-mail it to you to try out. Usual rules - feedback to me for improvement, huh?
Pilot - hey, no pressure, just interested and thought no harm in asking. Spreadsheet would be OK - not my strength, but kid can donate some assistance!
new here, this could be a helpful approach for me too, I am confronting the need for either re-locating my outlet, or possibly opening a satellite site, so I could use a tool like this. Where can I get follow-up on this? NotDewey mentioned something about an update in the library? That at the Harbour site you link to? I get that most of you are members there?
Hi billmc! Yes, a lot of us are harbourites ( a few are termites right Drinkwater!). Umm Pilot writes stuff for our library, so that members have access to decent resources there. Thing is, a lot of our library content was sort of business sensitive, since it was case studies of real businesses that we worked on as a group, mostly before the new site started. Problem was, we didn’t want sensitive stuff available to everybody, so we didn’t include a lot of it as was. Pilot is going through the material and re-writing it to abstract it so that personal details are not revealed, and also to generalize and abstract specific cases to more general cases. Heh, Pilot, remember you volunteered!
Sooner or later he’ll get it into the library. If I put too much pressure on him he’ll just down tools, so I try to be encouraging . . .
Welcome billmc. Dewey sort of has it right. I am a couple of weeks away from getting this one into the library. It needs a decent tool, and a how-to instruction, a case study, as well as a more elaborate explanation - do for the moment it is in my in-box.
As for the conversion of the material, you know I said I’d have a run at it, but that doesn’t mean that you guys can’t contribute as well you know. I mean, you have access to the source stuff too, and I know darned well that all of you can type. You can do it up in Word or Open Office, and Dewey and I can take care of the conversion and upload, getting it into the ref database so that it is available and so on. It isn’t just me here guys. Feel free to step up the plate!
Post a Comment