Industrial engineering student building Excel & Google Sheets templates for small businesses (Lean Grid Co.)
I build Excel & Google Sheets templates for small businesses: inventory with reorder alerts, event budgets and cash flow. Templates: https://gileson2.gumroad.com
Markdown supported · ⌘↵ to post
Yunus Emre Vurgun
Finding out stock is gone when the line stops is such a familiar story, so a sheet like this pays for itself fast. One tweak that helped me: base the reorder point on lead time instead of a fixed minimum, e.g. average daily usage × supplier lead time in days + a safety buffer, so fast movers alert earlier. If the alert goes out by email from Apps Script, store a 'last alerted' date per item and only send again when stock drops further or a few days pass, otherwise people start ignoring the daily repeat. Also worth protecting the formula columns, since one accidental overwrite of a reorder cell silently disables the alert for that item.