“Write your injuries in dust, your benefits in marble.” Benjamin Franklin.
How many times do we go into projects without defining the measure of success? That is what we do when we do not think through the cost and benefits of any investment in an improvement project. How can we measure how we haev achieved our improvement goals, if we do not have these quanitified in terms of the time and expense we put into building the improvements?
Building a business case does not have to be an exact science, and is simpler that many think. However, it does take effort, and requires buy-in from the project sponsor or the person who is signing the check.
Building the Business Case for a project is most commonly done using Excel. You want to estimate the costs & benefits over time with all of the assumptions that you will need to make, so that you can define the key project metrics that will help you decide whether to go on with the project or not. Below I have listed the elements of this business case: the costs and benefits over time, and the metrics.
Types of Costs
- One time costs to implement solution. Eg. project time & expense costs, hardware and software purcahses, etc.
- Recuring costs. Eg. depreciation, training, licensing, etc.
Types of Benefits. Below are examples of typicial quantifiable benefits of an business improvement project
- Increased number of customers
- Improved revenue per customer
- Improved customer retention
- Reduction in sales discounts
- Reduction in penalties, returns & credit notes
- Software portfolio consolidation
- IT maintenance cost reduction
- Reduction in capital costs
- Labor savings (by department)
- Improved cash collections
- Reduced stock holdings
- Faster training
- Other one-time benefits (
- Other monthly benefits
Business Case Metrics
- Payback. Payback period refers to the period of time required for the return on the project investment to "repay" the sum of the original investment. Calculating Payback Period using Excel
- Net Present Value: NPV measures the excesses of shortfalls of cash flows over time in terms of present value of the cash. Calculating NPV using Excel
- Internal Rate of Return: A project is a good investment if its IRR is greater than the rate of return that could be earned by alternative investments (investing in other projects, or even putting the money in the bank). IRR will be expressed as a percentage. Calculating IRR using Excel