The use of the Lot Size Calculation Spreadsheet is described in detail in the presentation “How to Calculate Lot Sizes”. Coloured-coded cells clearly indicate the data inputs and decision variables. A step-by-step guide walks the user through the process and error messages highlight problem areas to quickly guide the user to an efficient solution (set of lot sizes). The spreadsheet includes examples and supports two alternative solution approaches (as discussed in “How to Calculate Lot Sizes”).