Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesTravel & HospitalityHospitality OperationsRestaurant Supplier Order Guide

SpreadsheetHospitality OperationsFree

Restaurant Supplier Order Guide

Par levels minus what is on hand gives the order quantity and cost for every item, totalled by supplier against their order minimums.

Shown with sample data

Colour

Restaurant Supplier Order Guide

Par levels minus what is on hand gives the order quantity and cost for every item, totalled by supplier against their order minimums.

Order total
$1,446
Lines to order
14
Items out of stock
1
Suppliers below minimum
1
Order value by supplier
  • Prairie Meats$560
  • Coastal Seafood Co.$332
  • Harbor Foodservice$230
  • Green Valley Produce$221
  • Metro Dairy$103.40

How to use it

  1. 1List each item with its supplier, pack size and case price from your latest invoice.
  2. 2Set par levels in cases for the period between deliveries.
  3. 3Before each order, count what is on hand (in cases, decimals allowed) and enter it.
  4. 4Place each supplier’s order from the Order qty column before their cut-off, and check the Suppliers sheet for minimums.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Ordering by gut feel leads to 86’d dishes on Saturday and spoiled produce on Monday. Set a par level for every item: how much you need on the shelf to get to the next delivery. Count what is on hand, and the guide calculates what to order, rounded up to whole cases, and what it costs, flags items that are low or out, and totals each supplier’s order with a check against their minimum order and cut-off times.

Who it’s for

  • Twice-weekly produce and protein orders
  • Training a new kitchen manager to order
  • Controlling food cost by ordering to par

What’s included

  • Order guide sheet: Every item with par, on hand, order quantity and cost.
  • Suppliers sheet: Contacts, ordering windows and this order’s total for each supplier.

How to use it

  1. 1List each item with its supplier, pack size and case price from your latest invoice.
  2. 2Set par levels in cases for the period between deliveries.
  3. 3Before each order, count what is on hand (in cases, decimals allowed) and enter it.
  4. 4Place each supplier’s order from the Order qty column before their cut-off, and check the Suppliers sheet for minimums.

Tips

  • Par = average use per day × days until the next delivery + a safety buffer (often 10–20%). Raise pars before holidays and big events.
  • Review pars monthly against sales; items always over par are tying up cash and shelf life.
  • Check deliveries against the order and the invoice at the door, including temperatures for chilled and frozen goods.

Questions

What is a par level?

The amount of an item you want on hand after a delivery so you will not run out before the next one.

How is the order quantity calculated?

Par level minus on hand, rounded up to the next whole case, and never below zero.

What does Below minimum mean?

The total for that supplier is under their minimum order value, so you may pay a delivery fee or need to add items.

Related searchesrestaurant order guidepar level sheetrestaurant inventory order formfood order sheetkitchen ordering templatesupplier order list

Details

Format
Spreadsheet
Category
Hospitality Operations
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetHospitality OperationsFree

Restaurant Supplier Order Guide

Par levels minus what is on hand gives the order quantity and cost for every item, totalled by supplier against their order minimums.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Hospitality Operations
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More hospitality operations templates

View all
Recipe & Menu Costing Calculator2 sheets

Dishes costed

4

Average food cost

23%

Dishes above 35%

1

ABCD
1DishCategoryPortions per batchMenu price
2Tomato & basil soupStarter10$7.50
3Grilled chicken saladMain4$16.00
4Beef burger with friesMain4$13.00
5Chocolate brownieDessert12$6.50
Menu
SpreadsheetHospitality Operations

Recipe & Menu Costing Calculator

Cost every dish from its ingredients, see food cost percentage and margin, and get a price that hits your target.

10 min setupPreview
Vacation Rental Booking & Income Tracker2 sheets

Nights booked

30

Net income

$5,262

Average nightly rate

$169

Fees by platform
$309
$45.20
$38.40
Booking.comVrboAirbnb
SpreadsheetHospitality Operations

Vacation Rental Booking & Income Tracker

Bookings from every platform with nights, fees and net payout, plus occupancy and income for the season.

10 min setupPreview
Hotel Housekeeping Schedule2 sheets

Rooms to clean

6

Done

3

Early arrivals

2

ABCD
1RoomRoom statusPriorityHousekeeper
2101Check-outEarly arrivalRosa
3102Stay-overNormalRosa
4103Check-outNormalAhmed
5104Vacant cleanNormalN/A
Today
SpreadsheetHospitality Operations

Hotel Housekeeping Schedule

Assign rooms to housekeepers with room status, priority and inspection results.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ