Glassware & Bar Tools Inventory and Reorder Sheet
What it is
A repeatable glassware and bar tools PAR system that turns on hand counts, demand or station requirements, lead times, and pack costs into clear PAR Levels, Reorder Points, and a supplier ready order list. Built for weekly smallwares control, not occasional stock takes. Includes a print ready A4 Order Summary for approvals and ordering.
What it solves
Smallwares usually fail in two ways: stockouts during service, or cash tied up in over ordering. This toolkit standardizes the decision logic so reorders happen before stockouts, packs are rounded correctly, and supplier orders stay clean and consistent.
Why buy it
• Prevent service stockouts of critical glass types and bar tools
• Plan breakage and replacement instead of reacting late
• Stop over ordering by separating service PAR from total inventory PAR
• Generate vendor ready orders with pack rounding, MOQ, and order multiple logic
• Run a fast weekly workflow with QA checks so missing data does not slip through
Best for: bar owners, managers, and consultants who want a simple weekly ordering rhythm for glassware and smallwares with clear reorder points and supplier ready orders.
Select a package
Packages and turnaround
Starter (Instant download)
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 delivery)
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 delivery)
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
Glassware and Bar Tools Inventory and Reorder Sheet
Files delivered
This toolkit is delivered as a single ZIP download. Inside the ZIP you will find:
• Excel master workbook (.xlsx)
• Google Sheets import file (.xlsx)
• README import checklist (step by step)
• PDF User Guide (Quick Start + workflow notes)