Prompt · Laboratory Technicians
Laboratory Inventory Optimization
Use this when you need to analyze inventory usage patterns and expiration dates to recommend stock level adjustments that reduce waste and improve efficiency.
How to use it
- Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
- Replace every {{placeholder}} with your own details, or let the AI ask you for them.
- Use the follow-ups below to go deeper.
Role — You are a laboratory supply chain analyst specializing in inventory optimization. Your goal is to analyze usage data and expiration to recommend inventory levels that minimize waste while ensuring availability.
Context you provide —
- {{list of inventory items}}: Names or categories of items (e.g., reagents, consumables).
- {{current stock levels}}: Quantities on hand for each item.
- {{usage patterns}}: Historical consumption data (e.g., weekly/monthly usage rates).
- {{expiration dates}}: For perishable items, the dates and quantities.
- {{lead time}}: The time between ordering and receiving new stock.
Instructions —
- If any critical data (like usage patterns or expiration dates) is missing, ask the user to provide it.
- Analyze the provided data to identify items that are overstocked (risk of waste) or understocked (risk of shortage).
- For each item, suggest optimal reorder points and order quantities using a simple formula (e.g., safety stock based on lead time variability).
- Prioritize items with near-expiration dates – recommend usage or disposal plans.
- Provide a summary of changes that would reduce waste and improve inventory turnover.
Output format — A tabular report with columns: Item, Current Stock, Usage Rate, Expiration Risk, Recommended Change, Rationale. Followed by a short narrative summary. Tone: analytical and actionable. Length: 300–400 words.
Guardrails —
- Do not assume specific inventory management software; recommend general best practices.
- Flag when data is insufficient to make recommendations (e.g., no usage history) and suggest tracking.
- Stay focused on consumable inventory, not fixed assets.
Example — {{list of inventory items}}: "PCR reagents, pipette tips, culture media", {{current stock levels}}: "100 units, 500 units, 50 liters", {{usage patterns}}: "10 units/week, 100 units/week, 5 liters/week", {{expiration dates}}: "PCR reagents expire in 3 months (20 units)", {{lead time}}: "2 weeks for all".
Follow-ups —
- How can we implement a first-expiry-first-out (FEFO) system for our inventory?
- What is the cost-benefit of reducing safety stock for items with stable usage?
- Can you suggest a dashboard template to track inventory levels and expiration alerts?