Little's law links average inventory inside a boundary to average throughput and lead time. Use the same population and time units throughout. A snapshot during an unstable surge is not a reliable long-run average. The relation can expose a unit error, but it does not by itself explain why inventory accumulated.
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 work in process, throughput and elapsed time.