A concession stand has an inventory problem that most small businesses don't: it's run by a different set of volunteers every time. Nobody working Friday knows what Tuesday's crew used or what's in the cabinet. So the inventory sheet has to do the remembering. It lists every item with what's on hand, the level one busy game uses, and what it costs, and it's updated by one rule: count after every event. That count gives the next shopper a list, shows the treasurer what was sold, and catches the two things that quietly cost a stand its profit: stock bought twice because nobody knew it was there, and candy and drinks that leave without being paid for. Below is a sheet for a made-up booster club, the sum that checks sales against stock, and the file.
The short version
- One row for each item, counted in the unit you buy.
- A level for each: what one busy game uses. Below it, it's on the shopping list.
- Count after every event. Ten minutes, two people.
- What was used times the price should be close to the cash.
- Dates on hot dogs, buns and anything opened.
- TaroStack keeps the count on a phone and the list in days of cover. More below.
An example sheet
Counted after a Friday game.
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Hot dogs, 8 to a pack | pack | 14 | 20 | $4.60 | $64.40 | REORDER |
| Hot dog buns, 8 to a pack | pack | 16 | 20 | $2.10 | $33.60 | REORDER |
| Nacho cheese, #10 can | can | 5 | 4 | $9.80 | $49.00 | OK |
| Tortilla chips, 3 lb bag | bag | 7 | 6 | $5.40 | $37.80 | OK |
| Popcorn kernels, 12.5 lb | bag | 3 | 2 | $13.50 | $40.50 | OK |
| Candy bars, box of 36 | box | 4 | 6 | $27.00 | $108.00 | REORDER |
| Bottled water, case of 40 | case | 9 | 8 | $5.20 | $46.80 | OK |
| Soda, case of 36 cans | case | 6 | 6 | $15.80 | $94.80 | REORDER |
Thirteen rows in all, $640.10 of stock. Six are at or under their level: hot dogs, buns, candy, soda, sports drinks and nacho trays. That's the shopping list, and it goes to whoever shops, not into someone's head.
Setting the level
The level is what one busy game uses, so that the stand can always open. Work it out from two or three games:
| Hot dogs | |
|---|---|
| Packs before the homecoming game | 31 |
| Packs after | 12 |
| Used | 19 packs (152 hot dogs) |
| Level | 20 packs |
A stand that plays two home games a week wants more than one game's worth after shopping. One that plays twice a month wants no more than that, because buns go stale and hot dogs have a date. Buy for the next game or two, not for the season, except for things that keep: cups, napkins, kernels, canned cheese.
Checking sales against stock
This is the sum that answers the treasurer.
| Hot dogs, Friday | |
|---|---|
| Counted before the game | 31 packs (248) |
| Counted after | 14 packs (112) |
| Used | 136 |
| Price | $3.00 |
| Sales the count expects | $408.00 |
| Hot dogs rung up or tallied | 121, $363.00 |
| Difference | 15 hot dogs, $45.00 |
Fifteen hot dogs went somewhere. Some were dropped, some were burnt, some fed the volunteers, and some were handed to friends. All of those are normal in small numbers. The point of the sum is to know the number. If the club's rule is that each volunteer gets one free item, write those down on a tally sheet, and the difference shrinks to what's really unexplained.
Do the sum for the three or four items that carry the money: hot dogs, candy, drinks. Counting every napkin isn't worth it.
Dates and food safety
A concession stand is a food operation, usually on a temporary or seasonal permit, and the same few rules apply.
| Item | Rule of thumb for the sheet |
|---|---|
| Hot dogs | Kept cold; watch the use-by date; freeze what won't be used by the next game |
| Buns | Best-by date; oldest out first |
| Nacho cheese, opened | Refrigerate, write the date opened, use within 7 days |
| Hot-held food at the end of the night | Discard. Don't cool it and bring it back |
| Candy, drinks | Best-by dates, checked at the start of each season |
The sheet's second tab lists dated stock with days left and flags anything inside two weeks. Your health department's permit sets the actual rules for your stand. Ask them what they expect for temperatures and handwashing.
Making it work with volunteers
One owner. One person, usually the concessions chair, owns the sheet. Everyone else fills in a printed count sheet and hands it over.
A map. Tape a list inside the cabinet door: what goes on which shelf. Volunteers put things back where the count expects them.
Count in pairs. One counts, one writes. It's quicker and it's more accurate.
Lock the candy. And the cash box. A key with the chair and one with the athletic director.
Shop from the list. The warehouse club trip is where double-buying happens. Nobody shops without the current sheet.
How to count is in how to count inventory, with a blank sheet in inventory count sheet example. A sheet for selling at a table by the day is in market vendor inventory template, and for a truck in food truck inventory spreadsheet.
Get the spreadsheet
Download the concession stand inventory spreadsheet. Four sheets: inventory with value and a REORDER flag, dated stock with days left, a count sheet to print, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers, so the chair can share one copy with the treasurer.
Where this stops working
The sheet is on the chair's laptop. The count sheets are paper, in a folder, in the stand. After a tournament weekend with five crews, there are five count sheets, two of them missing, and the chair types the rest in on Tuesday. By then someone has already shopped, from memory, and bought three more cases of water.
How TaroStack does it
TaroStack lets whoever is at the stand do the count where the stock is.
Counting on a phone, with no signal. The count works in a concrete block stand with no reception and sends itself later. It can also print a count sheet.
The count shows what a difference is worth before it's posted, so fifteen hot dogs is $45, on the screen, that night.
A reorder list in days of cover. What will run out before the next game, ready to shop from.
Lots and dates. Hot dogs and buns are received with their dates, the soonest is used first, and an alert flags what's about to expire.
Every adjustment carries a reason: damaged, expired, sample, lost. Waste can be reported by reason.
| The job | Laptop and paper | In TaroStack |
|---|---|---|
| The count after a game | Paper, typed in later | On a phone, at the stand |
| What's missing, in dollars | A sum on Tuesday | Shown at the count |
| The shopping list | Whoever remembers | The reorder list |
| Volunteer meals and waste | Unknown | An adjustment with a reason |
TaroStack isn't a cash register. Stock, counting, lots and the reorder list are on Starter at $9.99 a month, for one person and up to 50 items; Growth, at $39 a month, has three people. 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.
