School Cafeteria Inventory Template
For K-12 cafeteria managers tracking commodity foods, purchased items and paper goods across breakfast and lunch programs. Plan menus around what's actually in the freezer.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| Item | Category | Storage | Unit | Par Level | On Hand | To Orderƒ | Unit Cost | Valueƒ | Supplier | Expiry |
|---|---|---|---|---|---|---|---|---|---|---|
| Whole-Grain Chicken Nuggets, 30 lb | Frozen Entrees | Walk-in Freezer | case | 12 | 8 | auto | 64 | auto | USDA Commodity | 2026-06-30 |
| 1% Milk, 8 oz Cartons | Dairy | Milk Cooler | crate of 50 | 20 | 14 | auto | 15.5 | auto | Valley Dairy Distributors | 2025-12-10 |
| Compartment Trays, 500-ct | Paper Goods | Dry Storage | case | 6 | 4 | auto | 38 | auto | Campus Foodservice Supply |
ƒ = calculated automatically by formula.
What's included
- Item
- Category
- Storage
- Unit
- Par Level
- On Hand
- To Order — calculated automatically
- Unit Cost
- Value — calculated automatically
- Supplier
- Expiry
Tips for using this template
- Track commodity foods separately from purchased items in the supplier column; reporting often requires it.
- Plan menu cycles around the oldest frozen stock to keep FIFO without extra effort.
- Count milk daily against attendance and adjust orders for early-release days and holidays.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateBakery Inventory TemplateCoffee Shop Inventory SpreadsheetFood Truck Inventory TemplateCatering Inventory TemplateBrewery Inventory SpreadsheetFood Pantry Inventory TemplatePizza Shop Inventory TemplateWinery Inventory Spreadsheet