The "black and white" art of forecasting...
It wasn't too long ago that I was working with someone who was interested in becoming a distributor, which in itself is a very workable idea, but the strategic reasons were reflective of someone who was losing their way and trying to solve a problem with the wrong solution.
There came a point in our conversations where it was time to get very "black and white" with all of it... we needed to literally put pen to paper (or the modern version we affectionately call excel) and build out "the numbers for this idea". We needed to forecast the revenue this idea would generate, how much it would cost to run, and understand what the operating income would look like*.We needed a financial picture of what we would be getting into.
Forecasting, in this context, is defined as a planning tool that helps management in its attempts to cope with the uncertainty of the future, relying mainly on data from the past and present and analysis of trends.
Forecasting starts with certain assumptions based on the management's experience, knowledge, and judgment. These estimates are projected into the coming months or years using one or more techniques such as Box-Jenkins models, Delphi method, exponential smoothing, moving averages, regression analysis, and trend projection. Since any error in the assumptions will result in a similar or magnified error in forecasting, the technique of sensitivity analysis is used which assigns a range of values to the uncertain factors (variables). Source: http://www.businessdictionary.com
After creating a simple spreadsheet that had twelve months across the top and rows assigned for Units Sold, Revenue, COGS (Cost Of Goods Sold), and the various expenses down the left hand column (with all the formulas in place to make addition and division easy), we began to fill in the blanks with numbers that would represent the first year of the new business.
When you are looking at this for the first time, the numbers that find there way onto the spreadsheet are based on experience, working knowledge, guts, glory and wishful thinking.
Initially this is your best educated guess and something you have to challenge as you work through the process; as the numbers begin to take shape, the discussion that comes with the process will shed light on the considerations to make the idea (or in this case "distributorship") viable... it will also uncover the risk(s) associated with it, and for that matter, the tolerance for that risk.
Units sold:
- Looking at units sold offers consideration regarding your product, what it looks like, how it is stored, the space needed, how it is shipped, handling considerations and the process flow from order to cash. (Distribution)
Revenue:
- Revenue is a big one because you can walk back from it and begin looking at the customer, where the opportunity will come from, the process used to engage the customer, manage the customer, and influence them to buy your product; as well as considerations to the price you set. (Customer Service, Sales and Marketing)
COGS:
- COGS gives you insight into the cost of your product (or service) and more importantly allows you to give thought as to how to reduce it; it is here you can increase your Gross Margin by reducing costs.
- With regards to being a distributor, COGS is something that is negotiated, which more often than not means it will be what the manufacturer says it is; unless that is, you happen to have established customers and unit sales to use as leverage. (Manufacturing)
Expenses:
- This highlights all the money you will need to spend to make the business viable. Some are obvious, but some are identified when you work through the considerations of Units sold, Revenue and COGS. Don't underestimate how important this is and over estimation is always prudent.
This is by no means a definitive process for identifying the financial viability of a business or encompasses the other complicated financial considerations that come with trying to get someone to buy your product. What it can do though is offer a "black and white forecast" for the direction of the business over the next twelve months, and more importantly, give you a financial reference point to work from as you identify areas of opportunity and concern.
In the end, the distributor idea was put aside because it simply was not going to generate enough money for the effort. All in, this process (including spreadsheet development) took about four hours, and in my opinion was time well spent because it ensured we were looking at the situation with eyes wide open, and without rose coloured glasses.
Over the years I've found getting it down on paper, in black and white, is a very good process for making better decisions... and that day we looked at the viability of a distributorship, was no exception.
iamgpe www.gpestratagem.com
* Let's not get into EBITA (and the like) for a number of reasons, which include the most obvious one, I'm not a finance guy. I do know a couple of good ones though.
"
Articles from Graham🐝 Edwards
View blogIn my part of the world the COVID-19 pandemic has become manageable and the normality of working alo ...
I was a talking to a local businessman and as part of our conversation he said something to me in It ...
It probably doesn’t really matter about the circumstances that find me training for a big gravel bik ...
Related professionals
You may be interested in these jobs
-
DevOps Technical Coach
1 day ago
CGI Toronto, Canada ContractPosition Description: · Role Description: · As a DevOps Agile Coach, you will closely work with DevOps teams and help improve their DevOps skills and Practices by transitioning from a traditional way of delivering software to a DevOps / Agile approach. Your responsibility is to ...
-
Equest Bolton, CanadaJob Description: · On-site - Monday- Friday · The purpose of this job is to drive operational excellence and to enable the site to optimize resource utilization (assets / associates / expenses) by identifying opportunities for further improvement and management of data sets. The ...
-
Floor Clerk
2 hours ago
Direct apply
The Jean Coutu Group (PJC) Inc. Saint-Georges, CanadaDo you have that "Coutu" touch? · Are you the type of person who enjoys interacting with people? Who wants to work with a dynamic and respectful team where no two days are alike? Are you looking for a stimulating environment where collaboration is at the heart of operations? The ...
Comments
Graham🐝 Edwards
7 years ago #2
Thanks for the note Don Kerr. In my opinion anyone in business need to get friendly with their finance person... and then their HR person. Money and People... is there anything more important?
don kerr
7 years ago #1