Build an Inventory Tracker Spreadsheet with Reorder Points and Low-Stock Alerts
You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.
Prompt
Act as an operations analyst who builds inventory spreadsheets for small businesses.
Before building anything, ask me these questions in one message and wait for my answers:
1. Do you use Excel or Google Sheets, and about how many products (SKUs) do you track?
2. What is your typical supplier lead time in days, and does it vary by supplier?
3. How do you know your sales pace: weekly history, monthly totals or a rough guess?
4. How much safety stock do you want, in days of sales?
Then build the tracker.
Rules:
- Calculate the reorder point as average daily sales × (lead time days + safety stock days). Show the exact cell formula for row 2.
- Mark every column as either typed in by me or calculated by a formula.
- Include a Days of Stock Left column and a Status column that returns REORDER NOW, REORDER THIS WEEK or OK.
- Give the conditional formatting steps with the exact custom formula and fill colour for each status.
- No macros. Formulas must still work when I add rows.
Output format:
1. Column table (Column | Header | Typed or formula | Row 2 formula | Purpose)
2. Conditional formatting steps
3. Three sample rows with numbers filled in
4. Weekly update routine (3-5 steps)
End with one line naming your assumptions and what would make the reorder points inaccurate.Example output
Tips and common edits
Why this works
- Asking about lead times and sales pace first means reorder points match your real suppliers, not generic defaults.
- A three-level status column separates urgent items from ones to order this week, so you can plan purchases.
- Exact row 2 formulas and formatting rules can be pasted straight in with no guesswork.
Use this in ChatGPT, Claude or Gemini when you are moving stock tracking out of your head or a notebook. Have your product count, supplier lead times and a rough idea of recent sales ready.
Common edits
- Ask for Google Sheets versions using ARRAYFORMULA so one formula fills the whole column.
- Add a cost column and ask for the total value of this week's suggested orders.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Build an Employee Shift Schedule and Hours Tracker with Overtime in Excel
You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.
Build an Invoice Template in Excel or Google Sheets with Automatic Totals
You get a cell-by-cell invoice layout with exact formulas for line totals, discount, tax, due date, and a duplicate-proof invoice numbering system.
Build Conditional Formatting Rules with Exact Formulas and Rule Order
You get a table of conditional formatting rules with the exact custom formula, the range to apply each one to, colors, and a rule order that avoids conflicts.
Build a 13-Week Cash Flow Forecast in Excel with Low-Balance Alerts
You get a 13-week cash flow sheet layout with committed and expected cash split apart, exact running-balance formulas, and red flags for weeks below your minimum.
Build a Break-Even and Pricing Calculator Spreadsheet in Excel
You get an Excel layout that separates fixed and variable costs, formulas for break-even and margin at three prices, and a ranking of which inputs move the result most.
Design a One-Page Manager Dashboard in Excel or Google Sheets
Get a buildable one-page dashboard plan with a layout grid, a spec for each tile (metric, chart, filter, source range, formula) and numbered build steps.