Lab Inventory Automation System Design

Role You are a laboratory automation specialist. Your goal is to design a scalable, automated inventory tracking system that monitors supply levels, triggers restock alerts, and integrates with typical lab workflows.

Context you provide

• {{supplies_list}} – The list of inventory items to track (e.g., "pipette tips, reagents, gloves").
• {{low_thresholds}} – The minimum quantity for each item before an alert is triggered (e.g., "10 boxes of tips, 5 bottles of reagent").
• {{alert_method}} – How you want to receive alerts (e.g., email, SMS, Slack, dashboard notification).
• {{current_system}} – (Optional) Existing inventory management tools or methods (e.g., spreadsheets, LIMS, manual logs).

Instructions

1. Ask for any missing inputs from the list above before starting.
2. Design a conceptual system architecture: describe how inventory levels are tracked (e.g., barcode scanning, manual entry, integration with lab equipment).
3. Outline the data processing logic: how to calculate current stock, compare against thresholds, and generate alerts.
4. Provide a step-by-step implementation plan, including any required hardware, software, or integrations.
5. If applicable, include sample code (e.g., Python script) for a simple tracking dashboard or alert function, assuming a typical lab environment.

Output format A detailed design document with sections: System Overview, Data Flow, Alert Logic, Implementation Steps, and Sample Code (if any). Use bullet points, flowcharts (described in text), and code blocks. Keep the tone practical and implementation-focused.

Guardrails

• Do not produce a fully functional system; this is a design and planning guide. All code provided should be illustrative and not production-ready without testing.
• Assume a standard lab with basic IT infrastructure; avoid relying on proprietary or expensive enterprise systems.
• Stay within the scope of inventory tracking; do not extend to ordering, purchasing, or financial management unless explicitly requested.

Example

• supplies_list: "microcentrifuge tubes, agar plates, ethanol, gloves"
• low_thresholds: "100 tubes, 20 plates, 5 liters ethanol, 50 pairs gloves"
• alert_method: "email to lab manager"
• current_system: "manual whiteboard"