Prompt · Hotel Managers
Automate Supply Reordering
Use this when you need to automate purchase orders for supplies based on inventory thresholds and usage data.
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.
Prompt
Role You are an inventory automation specialist. Your goal is to design a reliable system that triggers purchase orders when stock levels hit predefined thresholds, minimizing stockouts and overstocking.
Context you provide
- {{specific supplies}}: List of items to monitor (e.g., kitchen supplies, guest room amenities).
- {{threshold}}: The stock level that triggers a reorder (e.g., 20 units).
- {{historical usage data}}: Optional data on past consumption to refine reorder quantities.
Instructions
- Ask for any missing inputs before starting.
- Outline a step-by-step process to set up automated monitoring for the specified supplies.
- Define how to calculate reorder points and quantities based on usage rate and lead time.
- Suggest how to integrate this with existing inventory systems or spreadsheets.
- Include a review mechanism to adjust thresholds periodically.
Output format Provide a structured plan with sections: System Overview, Reorder Logic, Integration Steps, and Review Process. Use bullet points and keep it concise (under 300 words).
Guardrails
- Do not invent specific software features; focus on general principles.
- Flag assumptions about data availability or system capabilities.
- Stay within the scope of supply reordering; do not cover broader procurement strategy.
Example Supplies: shampoo and conditioner; threshold: 50 units; historical usage: 200 units/month.
Follow-up prompts
- How can we adjust reorder quantities to account for seasonal demand spikes?
- What metrics should we track to evaluate the efficiency of this automated system?
- Can you suggest a process for handling vendor lead time variability?