Operations template
Inventory Tracker Template
Know what to reorder before you run out. Stock value and reorder flags update as quantities change.
Starts with 25 free credits. No card needed.
What's inside
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Product | In stock | Reorder at | Unit cost | Value | Reorder? |
| 2 | Item A | 40 | 25 | 80 | =B2*D2 | =IF(B2<=C2,"Yes","No") |
| 3 | Total | =SUM(E2:E50) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
E2 =B2*D2
Value of stock on hand.
F2 =IF(B2<=C2,"Yes","No")
Flags products at or below the reorder point.
Make it yours by asking
Try a request like this in Tabstra:
"Create an inventory tracker with product, stock on hand, reorder point, unit cost, stock value and a reorder flag"