Catalogue

Inventory Kit for small workshops

Spreadsheet (.xlsx), no macros · workbook and manual in French and German only · available soon

For each item, from 12 months of consumption, the workbook calculates:

• the safety stock, accounting for variability in both demand and supplier lead times;
• the reorder point, compared with the inventory position (on hand plus on order), with a clear status: ORDER, OK or REVIEW;
• the order quantity (EOQ), rounded up to the minimum order quantity and pack size;
• the ABC and XYZ classes, with a suggested policy for each cell;
• stock value and days of coverage.

What it does not do: no trend or seasonal forecast; only an approximation for very slow movers; no day-to-day recording of stock movements; it does not replace your judgement.

Tested in LibreOffice: all formulas recalculated, all 100 checks on the control sheet pass.

Interested? Write to us: contact@pivotis.ch