Glassware and Bar Tools Inventory and Reorder Sheet
Stop guessing how many glasses and bar tools you really need, when to reorder, and how much breakage and loss is quietly costing you.
This is a Glassware and Bar Tools Par Level Inventory and Ordering System that turns your on-hand counts, weekly demand, station needs, lead times, and pack costs into clear Par Levels, Reorder Points, and a supplier-ready order list, including minimum order quantity and pack multiple rounding.
WHAT IT FIXES
Stockouts of key glassware during service
Late reorders because breakage and loss are not planned
Over-ordering and cash tied up in back-of-house stock
Messy purchasing because packs, MOQs, and order multiples are not standardized
No repeatable weekly ordering workflow for glassware and smallwares
IDEAL FOR
Cocktail bars, hotel bars, restaurants, rooftops, and multi-station venues that want a repeatable system for smallwares purchasing (glassware + bar tools), not manual guessing.
PACKAGES AND TURNAROUND
STARTER (1 day) | USD 29
You receive the template with a worked example you can overwrite. You input your items and the highlighted input fields, and the file automatically calculates Par Level, Reorder Point, Suggested Order, and a vendor-ready order list with pack rounding.
STANDARD (2 days) | USD 69
Template setup for your venue plus validation. Categories, locations, suppliers, units, review period, and thresholds are aligned. Inputs are checked to prevent common errors, and the dashboard and print summary are confirmed to match your structure.
ADVANCED (4 days) | USD 109
Done-for-you build. You send your inventory list, pack units, pack costs, on-hand, on-order, weekly demand or per-station quantities, lead times, safety stock, and optional MOQ and order multiples. You receive a clean ready-to-use file plus a short action summary covering: items to order, total order cost, and key QA flags.
WHAT’S INSIDE
Up to 300 items (glassware + tools) with Par Level, Reorder Point, Suggested Order (units and packs)
Pack units and pack costs with MOQ and order-multiple rounding, plus Final Order Packs output
Two planning methods: glassware by service turnover, tools by stations × quantity per station
Order Planner purchasing list (filter Final Order Packs > 0) plus print-friendly vendor totals
Dashboard: on-hand value, items to order, total order cost, yearly replacement budget
QA checks for missing critical inputs plus starter item library and sample dataset
DELIVERY FORMAT
Excel (.xlsx) / Google Sheet
HOW IT WORKS
Set your basics (service days, turns per day, number of stations, safety stock, lead time, review period).
Add items (vendor, pack units, pack cost, on hand, on order).
Choose the planning method:
Glassware: enter average weekly orders (or override if needed)
Tools: enter quantity per station
Open Order Planner, filter Final Order Packs > 0, and order by vendor.
Use the dashboard for a weekly snapshot and the QA sheet to catch missing data.
AFTER CHECKOUT
Starter: delivery of the template file
Standard and Advanced: send your data for one consistent period (items, pack units, pack costs, on-hand, on-order, lead times, weekly orders or per-station quantities, optional MOQ and order multiples)
