A pizzeria's inventory is short, and three rows on it decide the week: cheese, which is the biggest cost on the shelf; dough balls, which you make yourself and which are only good for a few days; and boxes, which cost 48 cents and can end a Friday night. A pizzeria inventory template needs each item with its count, a par to reorder at and a cost, and a second sheet where every batch of dough has the day it was made. Here's one, filled in for a made-up neighborhood shop on a Tuesday before the truck.
The short version
- Cheese and toppings in pounds, sauce by the can, boxes and dough in eaches.
- A par for each: what you use until the next delivery lands, and a day spare.
- Dough balls by batch, with a use-by.
- Know what a case makes: pizzas per bag of cheese is the check on waste.
- TaroStack takes cheese, sauce and a box off stock for every batch of pizzas recorded. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Mozzarella, shredded | lb | 60 | 80 | $3.45 | $207.00 | REORDER |
| Flour, high gluten | lb | 300 | 200 | $0.52 | $156.00 | OK |
| Dough balls, 14 oz | each | 140 | 120 | $0.41 | $57.40 | OK |
| Pizza sauce | #10 can | 18 | 12 | $6.90 | $124.20 | OK |
| Pepperoni, sliced | lb | 22 | 25 | $5.80 | $127.60 | REORDER |
| Italian sausage | lb | 15 | 10 | $4.60 | $69.00 | OK |
With mushrooms, boxes and olive oil, nine rows hold $1,044.40. Mozzarella, pepperoni and boxes are under par.
Pars from pizzas
The shop sells about 500 pizzas a week, half of them Friday and Saturday. A 14-inch pie takes 7 oz of cheese.
| Cheese a week: 500 × 7 oz | 219 lb |
| Truck comes | Tuesday and Friday |
| Used Friday to Tuesday (about 60% of the week) | 131 lb |
| Used Tuesday to Friday | 88 lb |
The par of 80 lb is roughly the lighter half-week. Sixty pounds on a Tuesday morning means the order going in today has to cover the weekend: 131 lb plus a cushion, less what's left.
Boxes use the same sum without the ounces. If 70% of pies go out the door, that's 350 boxes a week, and 350 on hand with a par of 400 is a week's supply and no more.
The cheese check
A 7 oz portion means a pound of cheese makes 2.3 pizzas, and the week's 219 lb should make 500. If the count says 250 lb went and the till says 500 pizzas, 31 lb of mozzarella is unaccounted for. At $3.45 that's $107 a week, or $5,560 a year, from heavy hands on the line. A scale or a portion cup fixes it. You only find it by counting.
Dough by the day
| Made | Lot | Balls | Use by |
|---|---|---|---|
| Mon, Nov 16 | DB-1116 | 96 | Thu, Nov 19 |
| Tue, Nov 17 | DB-1117 | 96 | Fri, Nov 20 |
This shop gives its dough three days in the walk-in. Yours may be longer or shorter; the point is that every tray carries its day, and the oldest tray is used first. The sheet says USE FIRST when a batch is inside three days. Dough past its day goes to garlic knots or the bin, and gets written down either way.
Open containers of cheese, sauce and meats follow your health code's date marking: see date marking under the Food Code.
Get the template
Download the pizzeria inventory template. Four sheets: inventory with value and REORDER, lots with days left, a count sheet that fills itself, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. What a pie costs is in how to price pizza.
Where this stops working
Counting 60 lb of cheese is quick. Knowing whether 60 is right, given what was sold since the last count, takes the recipe math for every size and topping, and nobody does that by hand on a Tuesday.
How TaroStack does it
TaroStack does the recipe math and keeps the dough dated.
Each pizza is a recipe. A 14-inch pepperoni is a dough ball, 5 oz of sauce, 7 oz of cheese, 2 oz of pepperoni and a box. Dough is its own recipe: flour, water, yeast, salt in, 96 balls out, with a lot and a use-by.
What the week should have used. Record what was made and each ingredient comes off stock. Count the walk-in on a phone, and the difference between what the recipes say and what's there shows in dollars, before you post it.
Oldest dough first. Lots are used first-expired-first-out, and an alert flags a tray about to pass its day.
The order writes itself. The reorder list shows what's under its reorder point, in days of cover.
At the till. TaroStack connects to Square.
| The job | Template | In TaroStack |
|---|---|---|
| Cheese that should be left | Portion math by hand | From recipes |
| Count versus expected | Not seen | A variance in dollars |
| Dough by day | A marker on the tray | Lots with use-by dates |
| Tuesday's order | Compare to pars | A reorder list |
Recipes, batches, lots and counting are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
