A farm that sells meat by the cut doesn't stock products. It stocks animals that have been taken apart. A meat inventory spreadsheet has a row for each cut, counted in pounds, with which freezer it's in and what a pound cost you. Behind the rows are the processing dates: each trip to the processor is a lot, named for the animals that went, with a date to sell by. And the sheet has one job that an ordinary inventory doesn't. When a cut runs low you can't order more of it. Ribeyes come back with the next steer, along with seven times their weight in ground beef. So the reorder level here is a warning to change the price or the bundle, not a note to call a supplier. Below is a sheet for a made-up farm in November, the cut arithmetic, and the file.
The short version
- One row for each cut, in pounds, with its freezer.
- Each processing date is a lot. Sell the oldest first.
- A steer is mostly ground beef and roasts. Steaks are a small part and sell first.
- When a cut runs low, raise its price or sell it only in bundles.
- Count each freezer on its own. A chest freezer hides things.
- TaroStack keeps cuts by lot and freezer, with the orders beside them. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Ground beef, 1 lb packs | lb | 142 | 100 | $6.10 | $866.20 | OK |
| Ribeye steaks | lb | 18 | 20 | $14.50 | $261.00 | REORDER |
| Chuck roast | lb | 64 | 30 | $7.20 | $460.80 | OK |
| Stew meat, 1 lb packs | lb | 38 | 20 | $6.80 | $258.40 | OK |
| Short ribs | lb | 12 | 15 | $8.40 | $100.80 | REORDER |
| Soup bones | lb | 55 | 10 | $2.50 | $137.50 | OK |
Ten rows in all, $3,251.90 in three freezers, with three cuts running low: ribeye steaks, short ribs and bacon.
You can't reorder a ribeye
| From two steers, processed Oct 28 | Came back | Left on Nov 20 | Sold |
|---|---|---|---|
| Ground beef | 310 lb | 142 lb | 54% |
| Ribeye steaks | 44 lb | 18 lb | 59% |
Two steers gave 44 pounds of ribeye and 310 pounds of ground beef: seven pounds of ground for every pound of ribeye. Three weeks later both are a little over half sold, which is this farm doing it right. On most farms the ribeyes are gone in ten days and the ground beef is still there when the next animals come back.
The sheet can't make a steer grow more ribeye. It can tell you early that a cut is running ahead of the others, while there's time to act:
- Price by scarcity. If steaks sell out first at your price, the price is too low. Raise it until they last about as long as the ground beef.
- Bundle. A box with two ribeyes, a roast and five pounds of ground beef sells the animal in the proportions it came in.
- Limit. Two packs of steaks an order, or steaks only with a bundle.
- Don't list what you don't have. The online shop's quantity for a cut should be what's in the freezer, less what's already promised.
The reorder level on each row is set with that in mind: it's the point at which you stop selling the cut on its own. The next processing date is the "delivery". Selling by the half or whole avoids all of this: see how to price beef by hanging weight.
Processing dates are lots
| Processed | What | Lot | Came back | Left | Sell by |
|---|---|---|---|---|---|
| Oct 28 | Ground beef | Steers 26-07 and 26-08 | 310 lb | 142 lb | Oct 28 next year |
| Oct 28 | Ribeye steaks | Steers 26-07 and 26-08 | 44 lb | 18 lb | Oct 28 next year |
| Sep 15 | Bacon | Hogs 26-P3 and 26-P4 | 62 lb | 9 lb | Mar 15 |
| Nov 6 | Whole chicken | Chickens, Nov 6 | 160 lb | 120 lb | May 6 |
Every package from the processor carries its date, and the plant's label where the meat was inspected. On the sheet, each processing date is a lot named for the animals that went. That gives you three things. You sell the oldest first. You can tell a customer which animals their beef came from, which is part of what they're paying for. And if a package is ever in question, you know which others came back with it.
The sell-by dates here are this farm's own: a year for frozen beef, six months for cured pork and poultry. Frozen meat stays safe longer than that, but its quality falls, and a customer who opens freezer-burned bacon doesn't reorder.
Freezers
Count each freezer as its own place. Upright freezers with one cut to a shelf can be counted in minutes. Chest freezers need baskets or labeled bags by cut, or the count becomes an excavation. Keep the oldest lot on top or in front.
A freezer is also a risk the sheet should record. If one fails, you want to know by the end of the day exactly what was in it and what it was worth, for the insurer and for your own decisions. Put an alarm thermometer on each.
What a meat label needs is in meat labeling requirements. Whether the year pays is worked through in is pig farming profitable and is goat farming profitable. A shop that cuts and sells fresh meat counts differently: see butcher shop inventory.
Get the spreadsheet
Download the meat inventory spreadsheet. Four sheets: inventory by cut with value and low-stock flags, processing dates 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
Saturday's market sells forty packages from two coolers. Online orders come in all week for Thursday pickup. Every one of those takes pounds off a row, from a particular lot, in a particular freezer. The sheet is right on the morning it's counted. By Wednesday the shop is offering ribeyes that were sold at the market, and a customer orders six that aren't there.
How TaroStack does it
TaroStack keeps the freezer and the orders in the same place.
Each cut is an item, in pounds. Each processing date is a lot with its date, and the animals it came from in its notes.
Stock is held by place, so each freezer has its own count.
Customers and sales orders, with one picking list for pickup day and a delivery note for each order.
Oldest first. Picking takes the first-expired lot by default, and an alert comes before a sell-by date.
Count on a phone, at the freezer, with no signal. A count shows what each difference is worth.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Ribeye left after the market | Friday's number | Stock, less what was sold |
| Which lot a customer got | Unknown | Recorded as it ships |
| What's in freezer 2 | Open it | Stock by place |
| Packages near their date | Read labels | The expiry alert |
TaroStack isn't a herd record and doesn't run an online shop. It connects to Square. Stock, lots, customers and orders are on every plan, from $9.99 a month. 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.
