Cost of Quality Worksheet

Purpose: To evaluate the true costs of a defect or error. This is the foundation of making a business case for the change.

QI Macros Cost of Quality Worksheet Template for Excel

To Complete the Cost of Quality Worksheet

  1. Identify each step in the Fix-it process.
  2. Assign a time in minutes to each task and a loaded rate.
  3. Identify any material costs associated with each step.
  4. Identify any external costs of this failure.
  5. Identify any lost opportunity, asset, or business costs.
  6. Set a target for reducing the error (e.g., 50%).
  7. Estimate the total cost of achieving this level of prevention.
  8. Evaluate ROI and payback period.
Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!