The operations lead needs an evidence-based handoff. Use the supplied fictional records to define the problem, reconcile the baseline, test the explanation and complete the final action. Keep each checked result in the carried worksheet. Done means the measurements reconcile and the final recommendation follows the stated evidence, including its limits.
A Pareto analysis orders categories by frequency or another declared measure. Cumulative shares show how much of the total the leading categories contain. Use every category in the denominator and state a tie rule. The familiar 80/20 phrase is not a guaranteed property of your data. Frequency can direct investigation, but it cannot establish a root cause or replace a severity review.
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.
Calculate cumulative defect shares and preserve the full denominator.