Inventory and Reorder Formulas
Calculate stock, reorder points, and order quantities.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Write formulas for inventory control. App: [SPREADSHEET_APP]. Layout: item list, transactions, supplier lead times: [LAYOUT]. Reorder policy preferences: [POLICY]. Sample data (fake): [SAMPLE_DATA]. Return a table: Metric | Formula | Explanation | Worked example from the sample. Include: stock on hand from transactions (received minus issued, using SUMIFS); average daily usage over the last 30 days (SUMIFS with date bounds divided by the number of days); days of cover (on hand / daily usage); reorder point (daily usage x lead time + safety stock); safety stock choice (a simple method using a buffer of extra days, with the limits of simple methods); order quantity to reach a target stock level or a maximum; economic order quantity formula with inputs and the warning that its assumptions are strict; stockout flag; overstock flag; ABC classification by value share; inventory value (quantity x unit cost) and weighted average cost; and shrinkage (system vs counted). Add data validation, protection of formulas, and conditional formatting for reorder alerts. Test with five items showing different statuses and give expected results. Note that formulas are only as good as the data, and recommend regular counts.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.