Optimum skip lot sampling plans using spreadsheets

The characteristics of Skip Lot Sampling Plans (SkSP) originally developed by Dodge and Perry are reconsidered in this paper from a computational point of view. The reference plan plays an important role in the performance of SkSP. A Single Sampling Plan (SSP) is normally used as reference plan and a number of procedures are available to determine the SSP. We focus on the algorithm-based procedures instead of methods based on statistical tables to determine the SSP and its effect on the performance indicators of SkSP. Spreadsheet solutions are nowadays more user-friendly than customized programs written in specific languages. We present a case of using Excel worksheet functions to handle statistical distributions required in the determination of the plan.