I need to justify my project to management by showing the potential savings. How does a Yellow Belt calculate the Cost of Poor Quality (COPQ) without advanced financial software? I’m looking at high error rates in our data entry department. Should I just count the hours spent fixing mistakes, or are there other hidden costs I should include to make my case stronger?
3 answers
Keep it simple. Management loves seeing "hours saved per year" converted into a dollar amount. It’s the easiest metric for them to digest.
To build a strong case, think of COPQ in four categories: Internal Failure, External Failure, Appraisal, and Prevention. For data entry, Internal Failure is the most obvious—calculate the labor rate of employees multiplied by the hours spent on rework. But don't forget "Opportunity Cost." If your best employees are busy fixing errors, they aren't doing their actual jobs. You should also look at the "External Failure" costs—did an error reach a customer? If so, did it result in a refund, a lost contract, or extra shipping costs? Even a simple spreadsheet tracking these for a week can provide a very compelling "burning platform" for your project.
Have you considered the "intangible" costs, such as the impact on employee morale or the loss of brand reputation, when presenting your findings to the board?
Christopher, morale is a huge factor here; the team is frustrated with the constant rework. Elizabeth, thank you for the categories! I hadn't thought about "External Failure" costs. Last month, a data error led to a $500 shipping overcharge for a client. Adding that to the 40 hours of monthly rework really makes the project seem essential. I’m going to present these "Hard Savings" (labor) and "Soft Savings" (avoided shipping errors) to my manager on Friday
I agree with Thomas. While the other costs are important, the "labor hours saved" is usually the most undeniable figure in a Yellow Belt business case.