A smoothie shop has two kinds of stock, and they fail in opposite ways. Frozen fruit keeps for a year or more, so the risk is running out. Fresh produce and dairy keep for days, so the risk is throwing them away. A smoothie shop inventory sheet handles both: frozen fruit by the case with a reorder point tied to delivery days, and fresh items with a use-by date and a plan for what's left. It also covers add-ins, cups and straws. Below is a sheet filled in for a made-up shop, the sums behind its reorder points, and the file.
The short version
- Frozen fruit by the case. Reorder point = cases used a day × days until the next delivery, plus a day.
- Fresh produce and dairy on the Lots sheet with use-by dates.
- Decide in advance what happens to fresh stock on its last good day.
- Protein powders and nut butters carry allergens: note them.
- Count before each order, not once a month.
- TaroStack takes fruit off stock when you record the day's smoothies, and flags what's about to expire. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Strawberries, frozen, 30 lb case | case | 6 | 4 | $54.00 | $324.00 | OK |
| Mango chunks, frozen, 30 lb case | case | 3 | 4 | $61.50 | $184.50 | REORDER |
| Blueberries, frozen, 30 lb case | case | 4 | 3 | $72.00 | $288.00 | OK |
| Bananas, 40 lb case | case | 2 | 2 | $24.00 | $48.00 | REORDER |
| Spinach, 2.5 lb bag | bag | 5 | 4 | $7.25 | $36.25 | OK |
| Greek yogurt, 32 lb pail | pail | 2 | 2 | $49.00 | $98.00 | REORDER |
Eleven rows in all, $1,610.45 of stock, with mango, bananas and yogurt to reorder.
Reorder points from delivery days
The distributor delivers Monday and Thursday. The longest gap is Thursday to Monday, four days.
| Item | Used a day | × 5 days (4 and a spare) | Reorder at |
|---|---|---|---|
| Strawberries, frozen | 0.8 case | 4.0 | 4 |
| Mango, frozen | 0.8 case | 4.0 | 4 |
| Blueberries, frozen | 0.6 case | 3.0 | 3 |
A 30 lb case at 5 oz a smoothie is 96 smoothies. This shop goes through about 77 strawberry smoothies' worth a day, 0.8 of a case. Mango is at 3 cases with a 4-case reorder point: on Thursday's order it goes, or Sunday afternoon is mango-free.
For frozen fruit, err high. A spare case costs freezer space and nothing else.
Fresh stock: dates and a plan
| Received | Item | Use by | The plan for what's left |
|---|---|---|---|
| Nov 16 | Bananas, 3 cases | Nov 21 | Day 5: peel, portion and freeze |
| Nov 16 | Spinach, 6 bags | Nov 24 | Day 7: into the green smoothie special |
| Nov 12 | Greek yogurt, 3 pails | Dec 10 | Dated by the dairy |
For fresh stock, err low, and have an exit. Bananas are the classic: they arrive green, are perfect for two days, and are brown by day six. This shop peels and freezes whatever's left on day five. Frozen banana makes a thicker smoothie anyway, and a case that would have been $24 in the bin becomes next week's stock.
The sheet flags anything inside five days of its date USE FIRST. For this shop that's most of the fresh rows, most of the time, which is the point: the flag is a daily to-do list.
Write the waste down. When something is thrown away, note what, how much and why. A month of notes shows whether the answer is ordering less, or a better day-five plan.
Allergens
| Item | Contains |
|---|---|
| Whey protein, vanilla | Milk |
| Greek yogurt | Milk |
| Peanut butter | Peanuts |
| Almond milk | Tree nuts |
A smoothie shop has four of the major allergens within arm's reach of one blender. Keep what each item contains on the sheet, where the person at the counter can check it. Blender cleaning between allergen drinks is a procedure, not an inventory matter, and it matters more.
A walk-in freezer has its own sheet in freezer inventory sheet, and the count itself is in inventory count sheet example. Cups and lids are compared in how to package smoothies for sale.
Get the sheet
Download the smoothie shop inventory sheet. Four sheets: inventory with value and REORDER, lots with days left to their use-by, a count sheet, 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 count is right on Monday and Thursday mornings. In between, 200 smoothies a day each took five ounces of this and a banana of that. Nobody subtracts them, so the reorder points only work on count days, and the waste notes depend on someone writing on a clipboard with wet hands.
How TaroStack does it
TaroStack keeps the count moving between counts.
Each smoothie is a recipe. Five ounces of strawberries, half a banana, a scoop of yogurt, a cup, a lid. Units convert: fruit bought by the case and used by the ounce is one item.
A day's smoothies come off in one step. Record what you made and each recipe takes its ingredients off stock, from the oldest lots. TaroStack connects to Square.
Use-by on every lot. Fresh deliveries go in with their dates. The soonest to expire is used first, and an alert flags what's close, with its value.
Waste has a reason. Throwing something away is an adjustment with a reason, so the month's waste is a report in dollars, not a clipboard.
A reorder list in days of cover, ready before Thursday's order.
| The job | Count sheet | In TaroStack |
|---|---|---|
| Cases left between counts | Unknown | Stock on hand, after each day's record |
| Bananas on day 5 | Remember | An alert |
| What waste cost this month | Add up notes | Waste by reason |
| Thursday's order | Count, then work it out | The reorder list |
Stock, recipes, expiry and the reorder list 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.
