A step adds customer value when it changes the product or service in a way the customer needs and is done correctly. Some steps are necessary for safety, regulation or control even when they do not transform the output. Treat these separately from avoidable waste. Simplify a mandatory verification without removing the protection it supplies.
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.
Distinguish customer value from required non-value work and avoidable waste.