A sampling plan states the population, sampling frame and selection method. Stratification keeps groups such as shifts visible. Proportional allocation follows each group volume; equal allocation answers a different design goal and needs weights for population estimates. Sampling only convenient records can miss the troublesome shift. Record identifiers and selection rules so another analyst can reproduce the audit.
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.
Allocate an audit without losing a shift or distorting its volume.