A defect is a failure of a requirement; a defective unit has at least one defect. A single unit may contain several defects. DPU divides defect count by unit count, while DPMO also includes the declared opportunities per unit. Define meaningful opportunities before comparing processes. Adding arbitrary opportunities makes the ratio look smaller without improving the output.
You work with original records from fictional operations teams. Start by checking what each column means and which cases belong in the denominator. A precise calculation can still answer the wrong business question if the population or time boundary changes. Use the worksheet to leave an audit trail: preserve the inputs, record the intermediate outputs and check the stated exception. The transfer case uses new data so you must apply the method again.
Use units and opportunities as different defect denominators.