Calculate Inventory Reorder Points From Sales Data
Use this prompt when you have 8 weeks of sales data by SKU and want AI to calculate average daily sales, safety stock, and reorder points for each item. Paste your actual sales data at the bottom before submitting.
The Prompt
I run a small product business. Here is my sales data by SKU for the past 8 weeks. For each SKU, please calculate: (1) average daily sales, (2) maximum daily sales, (3) recommended safety stock using the formula (Max Daily Sales − Avg Daily Sales) × Lead Time, and (4) the reorder point using (Avg Daily Sales × Lead Time) + Safety Stock. My lead times are [X days for domestic suppliers / Y days for overseas suppliers]. Return the results as a table I can paste into a spreadsheet. [Paste your sales data here]
From the guide
Using AI to build a simple inventory reorder alert system from your spreadsheet so you stop running out of stock at the worst time →Related Prompts
Turn Your Rate Card Into a Client Proposal
Use this as your master reusable proposal prompt after every sales call. Paste your rate card and five post-call notes into the bracketed fields to generate a complete, client-ready proposal draft in under two minutes.
Fix Unclear Task Names in AI Digest Output
Add this line to your weekly digest prompt when your task data includes internal shorthand, ticket IDs, or abbreviations that the AI may misread or misrepresent in the output.
Generate a Weekly Team Task Digest Email
Use this prompt after exporting your task list from a project tool like Asana, ClickUp, Trello, or a Google Sheet. Paste the task data above this prompt, then run it in ChatGPT, Claude, or Gemini to generate a formatted weekly team digest email ready to send before Monday morning.
Format Rough Shift Notes Into a Clean Handover Message
Use this prompt at the end of every shift to convert a manager's rough, unstructured end-of-shift notes into a clean, categorised handover note that matches your template. Takes under 90 seconds and produces an auditable, readable note ready to send to the incoming team.