Lead time measures elapsed time across the chosen boundary. Processing time records the work inside it. Waiting can dominate the elapsed result even when every activity is fast. Add compatible time units before calculating flow efficiency. The ratio shows the share spent processing; it does not prove that every processing activity adds customer value. Preserve the original boundary when comparing cases.
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.
Reconcile processing and waiting in a flow worksheet.