Supply Par Level and Reorder Sheet Design
Keep supplies stocked without overbuying.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Design a par level and reorder sheet for [PRACTICE_TYPE]. Supplies categories: [SUPPLY_CATEGORIES]. Suppliers and lead times: [SUPPLIERS]. Storage limits: [STORAGE]. Items with expiry dates: [EXPIRY_ITEMS]. Produce: 1. A table layout with columns: Item, Category, Unit, Par level (maximum), Reorder point, Typical weekly use, Supplier, Lead time, Expiry check (yes/no), Location, and Notes. 2. A method to set par and reorder points: weekly use times lead time plus safety stock. Work an example with made-up numbers. 3. A weekly counting routine with a time estimate and who does it. 4. Formulas for a spreadsheet to flag items below the reorder point and expiring in 60 days. 5. Rules for controlled or temperature-sensitive items, to be set by the clinical lead. 6. Monthly metrics: stockouts, waste from expiry, and spending versus budget. Add a one-page instruction for the person counting stock. Do not include any clinical decision rules. Give the spreadsheet formulas in a form that works in both Excel and Google Sheets, and state any assumption about units of measure so counts stay consistent. This is administrative and communication support only, not medical, clinical or legal advice. Remove patient identifiers before pasting anything. Have a clinician, compliance officer or practice manager who knows the rules in [JURISDICTION] verify the output before it is used.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.