A pizza shop has a short list of things to count, and three of them decide whether the week made money. Cheese is the largest food cost on a pizza and the easiest to over-portion, so the sheet's first job is comparing the cheese that was used with the cheese the pizzas sold should have taken. Dough is made in the shop and lives about three days, so each day's dough is counted separately and the oldest is stretched first. And boxes, by size, are the item a shop runs out of on a Friday night. Around them are flour, tomatoes, meats and vegetables, each with a reorder level and, for what's fresh, a use-by date. Below is a sheet for a made-up shop on a Friday afternoon, the cheese sum, and the file.
The short version
- Count on the same day each week, before the rush.
- Cheese: used should match pizzas sold × the portion. Check it weekly.
- Dough by the day it was made. Oldest first.
- A row for each box size.
- Fresh toppings get a use-by date.
- TaroStack takes ingredients off stock from what you made and flags dates. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Pizza flour, 50 lb bags | lb | 350 | 300 | $0.52 | $182.00 | OK |
| Mozzarella, shredded, 5 lb bags | lb | 85 | 100 | $3.10 | $263.50 | REORDER |
| Crushed tomatoes, #10 can | can | 22 | 18 | $6.50 | $143.00 | OK |
| Pepperoni, sliced, 5 lb bags | lb | 30 | 25 | $4.90 | $147.00 | OK |
| Italian sausage, bulk | lb | 14 | 15 | $4.20 | $58.80 | REORDER |
| Mushrooms, sliced | lb | 8 | 10 | $2.80 | $22.40 | REORDER |
Eleven rows in all, $1,074.06 of stock, with four to reorder: mozzarella, sausage, mushrooms and 14 inch boxes.
The cheese sum
Every pizza has a cheese portion. Multiply the portion by the pizzas sold and you have what the week should have used. The counts say what it did use.
| Mozzarella, last week | |
|---|---|
| Opening count | 95 lb |
| Delivered | 320 lb |
| Closing count | 85 lb |
| Used | 330 lb |
| 14 inch pizzas sold: 610 at 7 oz | 266.9 lb |
| 10 inch pizzas sold: 180 at 4 oz | 45.0 lb |
| Should have used | 311.9 lb |
| Over | 18.1 lb |
Eighteen pounds over is about $56 of cheese in a week, nearly 6% more than the recipes call for. On 610 large pizzas that's less than half an ounce each: a hand that's a little heavy, every time. It adds up to about $2,900 a year.
The fix is cheap: a portion cup or a scale on the make line, and this sum done every Monday. Extra-cheese orders and cheese used on other items (garlic bread, salads) go into the "should have used" side, or they'll look like waste. The same sum works for pepperoni. What a pizza costs to make is in how to price pizza and pizza profit margin.
Dough by the day
| Made | Dough balls | Left | Use by | Note |
|---|---|---|---|---|
| Thursday | 120 | 24 | Sunday | Use before Friday's |
| Friday | 72 so far | 72 | Monday |
Dough gets better for a day or two in the cooler and then worse. This shop gives it three days. Tray each day's dough together and mark the tray with the day, so the make line pulls Thursday's before Friday's. At close, count what's left of each day. Dough past its day is waste, and the count of it tells you whether you're making too much on slow days.
The sheet values a dough ball at what's in it: flour, yeast, salt, oil. Ninety-six on hand at 46 cents is $44.16.
Boxes
A shop that runs out of 14 inch boxes at eight on a Friday is putting large pizzas in two small boxes or sending someone to a competitor to borrow a bundle. Boxes are cheap, bulky and ordered in bundles with a lead time. Give each size its own row and a level that covers a busy weekend and the wait for the delivery. The 14 inch row is at 180 against a level of 200.
Fresh toppings
Mushrooms, peppers, onions and opened bags of meat and cheese have dates. The second tab lists each delivery with a use-by date and flags what's within three days: today, 8 pounds of mushrooms delivered Tuesday. Use the oldest first, and keep opened bags dated. Food safety for a pizza line is in HACCP plan for pizza, and how much stock a kitchen should hold in how much inventory should a restaurant carry.
Get the spreadsheet
Download the pizza shop inventory sheet. Four sheets: inventory with value and REORDER, dated items with days left, a count sheet that works out each difference and what it's worth, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The cheese sum needs last week's closing count, this week's invoices, the register's pizza counts by size and this week's count, all in one place on a Monday morning. In a busy shop one of the four is missing most weeks. So the sum doesn't get done, and the first sign of a heavy hand on the cheese is the order creeping up a case a week.
How TaroStack does it
TaroStack keeps the counts and the deliveries, and works out what the recipes should have used.
Each pizza is a recipe: dough, sauce, 7 ounces of cheese, a box. Record what you made and the ingredients come off stock.
Count on a phone, in the walk-in, with no signal. A count shows what each difference is worth, so cheese used beyond the recipes is a number.
Each delivery and each day's dough is a lot with its date. The oldest goes out first by default, and an alert comes before a date arrives.
A reorder list in days of cover, so boxes are ordered before the weekend that needs them.
A price-creep report by supplier, for the cheese.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Cheese that should have been used | A sum from four sources | From the recipes and what was made |
| What the difference is worth | Multiply by hand | On the count |
| Which dough to pull | The marked tray | Oldest lot first |
| Boxes before Friday | Noticed on Friday | The reorder list |
TaroStack doesn't weigh portions or run the register. It connects to Square. Stock, recipes and counts 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.
