An egg farm's inventory turns over in days, and the mistake it makes is always the same one: this morning's cartons go in the front of the cooler and get sold first, while last week's sit behind them. An egg inventory template is built to stop that. It counts cartons in the cooler by pack date, eggs still waiting to be washed and packed, empty cartons and flats, and feed. Then it tells you which pack date to sell first and when you'll run out of cartons. Here's one with a made-up 400-hen farm's numbers.
The short version
- Cartons in dozens, by the date they were packed.
- Loose eggs waiting to be packed, in eaches.
- Empty cartons, flats and labels, with reorder amounts.
- Feed in pounds, with the mill date.
- TaroStack keeps each day's pack as a lot and sends the oldest out first. More below.
An example sheet
Clover Hollow Farm is a made-up pastured egg farm in Franklin, Tennessee:
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Eggs, large, cartons of 12 | dozen | 96 | 60 | $4.63 | $444.48 | OK |
| Eggs, mixed sizes, flats of 30 | flat | 9 | 6 | $9.80 | $88.20 | OK |
| Eggs, unwashed, to pack | each | 310 | 0 | $0.30 | $93.00 | OK |
| Cartons, pulp, printed | each | 420 | 500 | $0.35 | $147.00 | REORDER |
| Flats, 30 count | each | 150 | 100 | $0.22 | $33.00 | OK |
| Carton labels | each | 900 | 500 | $0.03 | $27.00 | OK |
Layer feed and oyster shell complete it at $1,297.48. Printed cartons are under their reorder amount.
The $4.63 is what a dozen costs this farm to produce, feed, carton and labor together; how it's worked out is in how to price eggs.
Cartons run out before eggs do
The farm packs about 175 dozen a week. Printed cartons take three weeks from the supplier.
| Cartons used while waiting (3 weeks × 175) | 525 |
| On hand | 420 |
| Short by | 105 |
So the order is already late, and the reorder amount of 500 was a little low. Raising it to 700 (four weeks) costs nothing but shelf space. An egg farm with eggs and no cartons has nothing to sell on Saturday.
Pack dates in the cooler
Three of the lots in the cooler:
| Packed | Lot | Dozens packed | Sell by | Left |
|---|---|---|---|---|
| Nov 9 | P-1109 | 24 | Dec 9 | 6 |
| Nov 12 | P-1112 | 21 | Dec 12 | 21 |
| Nov 13 | P-1113 | 24 | Dec 13 | 24 |
P-1109 has six dozen left, and they go first: to the front of the cooler, onto the market table, into today's store order. The sheet flags a lot USE FIRST when it's within a week of its sell-by.
The 30 days here is this farm's own rule. States set their own dating and labeling rules for eggs, and some are shorter. Check yours in egg business license. The pack lot on the carton is your traceability either way: it ties a carton to a day, and the day's row in your egg production log to a flock.
Feed is inventory too
Fourteen hundred pounds is two weeks at 100 lb a day. The mill delivers weekly with a 2,000 lb minimum, so 1,000 lb is the level to call at. Write the mill date and lot from the tag. Feed loses quality as it sits, and if hens go off their lay, a new lot of feed is the first suspect.
Get the template
Download the egg inventory template. Four sheets: inventory with value and REORDER, pack 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.
Where this stops working
Eggs leave in three directions every week: the market, the egg share, the store. Each takes a few dozen from whatever lot is nearest the cooler door, and the "left" column is only right if someone updates it after every one.
How TaroStack does it
TaroStack decides which carton leaves, and remembers where it went.
A day's pack is a lot. A dozen is a recipe: twelve eggs and a carton. Record the day's packing and the cartons come off stock; the dozens go in with a pack lot and a sell-by.
Oldest first, by default. An order for the store takes P-1109 before P-1112 without anyone reading dates. A lot close to its sell-by raises an alert.
Where each lot went. Each delivery records the lots it took. If there's ever a question about one day's eggs, one report lists who got them.
Cartons on the reorder list. With the supplier's lead time on file, the list shows cartons in days of cover.
The market has no signal. Record sales on a phone offline; it sends itself later.
| The job | Template | In TaroStack |
|---|---|---|
| Which cartons to sell first | Read the dates | The oldest lot, by default |
| Dozens left by pack date | Update by hand | Comes off with each sale |
| Who got Nov 9's eggs | Memory | One report |
| When to order cartons | Arithmetic | Days of cover |
Lots, expiry and the reorder list 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.
