Inventory + Reorder Tracker

Description

Know what is on the shelf, what is running low, and what to order—before housekeeping or the kitchen runs dry.

Features

• Items master: SKU, location, reorder point, supplier, unit cost, Stock flag
• Movements log: In / Out / Adjust with reason and reference
• Low Stock sheet driven by formulas (qty ≤ reorder point)
• Reorder List with default order qty and estimated cost (order qty × unit cost)
• Dashboard: active SKUs, low-stock count, inventory value (SUMPRODUCT), reorder total
• Conditional formatting: low-stock rows red; near-reorder qty yellow
• Frozen panes and named ranges for key columns
• CSV folder for Google Sheets users

What’s calculated for you

• Items Stock flag — Low when Qty on hand ≤ Reorder point, else OK
• Low Stock sheet — IF helpers list only items that need reorder
• Reorder Unit cost — VLOOKUP from Items
• Reorder Est. cost — Order qty × Unit cost (Order qty defaults from Reorder qty)
• Reorder Total — SUM of Est. cost
• Dashboard Active SKUs — COUNTIF Active=Yes
• Dashboard Low stock count — COUNTIF Stock flag=Low
• Dashboard Inventory value — SUMPRODUCT (active × qty × unit cost)
• Dashboard Reorder total cost — linked from Reorder List total

Who it’s for

Property managers and ops leads at small hotels, guesthouses, and multi-room rentals who stock linen, amenities, cleaning supplies, and kitchen goods.

What’s included

• Outzone-Inventory-Reorder.xlsx
• csv/ exports (Items, Movements, Reorder List, Low Stock snapshot)
• README.txt with import guidance

License

One-time digital download for your organization. Use on unlimited devices within your team. Do not resell or redistribute.