Restaurant Inventory and Purchasing System - Count Entry, Order Builder, Price History, Food Cost and Receiving Log
Sheet1: setup overview and navigation guide Items Master: full ingredient and item database with unit costs, par levels, and category assignments Vendors: vendor database with contact information, lead times, and payment terms Units and Categories: unit of measure library and category structure for consistent data entry Locations: location setup for multi-outlet inventory tracking Price History: track vendor price changes over time with active price flagging per item Receiving Log: log every delivery with vendor, item, quantity, and price for invoice verification Transactions Log: full transaction history of all inventory movements Count Entry Restaurant: restaurant inventory count sheet with on-hand quantities and variance vs par Count Entry Banquets: banquet-specific inventory count sheet Cycle Count Schedule: rolling cycle count calendar so not every item gets counted every week Order Builder Restaurant: restaurant purchase order builder that calculates order quantities from current counts and par levels Order Builder Banquets: banquet purchase order builder Valuation and Food Cost: inventory valuation with food cost calculation by period and outlet Dashboard Restaurant: restaurant-specific dashboard with current inventory value, top cost items, and food cost percentage Dashboard Banquets: banquet-specific dashboard Steward View: simplified steward-facing view for count entry and receiving without full system access Chef View: chef-facing view showing par levels, current counts, and items to order Admin Setup: system configuration and admin settings Quick Receiving: streamlined receiving entry sheet for fast delivery processing
20 sheets. Instant download. Excel and Google Sheets compatible. Sample data and setup guide included. Own it forever. No subscription.