An egg production log is one row a day for each flock: how many hens, how many eggs you collected, how many were cracked or dirty, how much feed went out, how many dozens you packed, and the lot code on that day's cartons. From those the sheet works out the good eggs and the lay rate, eggs collected divided by hens. The lay rate is the number that tells you something's wrong, usually a day or two before you'd see it in the nest boxes. Here's a template with a week filled in.
The short version
- One row a day for each flock or house.
- Count eggs collected and, separately, the cracked and dirty ones.
- Lay rate is eggs over hens. Watch the trend, not one day.
- Write the pack lot, so a carton leads back to the day it was packed.
- TaroStack takes cartons off stock as you pack and keeps each day's eggs as a lot with a date. More below.
An example week
Clover Hollow Farm is a made-up pastured egg farm in Franklin, Tennessee, with 400 hens:
| Date | Eggs | Cracked or dirty | Good eggs | Lay rate | Feed | Dozens packed | Pack lot |
|---|---|---|---|---|---|---|---|
| Nov 9 | 304 | 9 | 295 | 76.0% | 100 lb | 24 | P-1109 |
| Nov 10 | 298 | 7 | 291 | 74.5% | 100 lb | 24 | P-1110 |
| Nov 11 | 291 | 12 | 279 | 72.8% | 100 lb | 23 | P-1111 |
| Nov 12 | 262 | 8 | 254 | 65.5% | 100 lb | 21 | P-1112 |
| Nov 13 | 296 | 6 | 290 | 74.0% | 100 lb | 24 | P-1113 |
Reading the week
November 12 stands out. The lay rate fell from the mid-70s to 65.5% in a day. The note on the row says why: one drinker nipple was stuck. Hens short of water lay less, fast. It was found that afternoon, and the next day is back to 74.0%. Without the log, a drop of 30-odd eggs is easy to miss in the baskets. On paper, in a column, it isn't.
Cracked and dirty. Usually 6 to 9 a day here, about 2 to 3%. November 11 had 12, with rain. A week of high numbers points at something you can fix: muddy runs, thin bedding in the boxes, collecting too late in the day.
Feed per dozen. Five days, 500 lb of feed, 1,409 good eggs, which is 117 dozen. That's about 4.3 lb of feed for each dozen sold. If feed is 32 cents a pound, that's $160 of feed, or $1.36 a dozen. When that number climbs, either the hens are aging or something is eating your feed that isn't a hen.
Packed versus laid. 295 good eggs make 24 dozen with 7 left over. Leftovers roll into tomorrow, and over the week the dozens packed should track the good eggs. If they don't, eggs are leaving without being counted.
The pack lot
Write a code on every carton for the day it was packed. P-1109 is November 9. That, with the row in this log, is your traceability: which flock, which day, how many dozen. If a customer or an inspector ever asks about a carton, you can say when it was packed and how many others went out with it.
What has to be on a carton, and when a licence is needed, depends on your state and the size of your flock. Start with egg business license and egg grading.
Get the template
Download the egg production log template. The log, with good eggs and lay rate worked out, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. What a dozen costs you is in how to price eggs.
Where this stops working
The log counts eggs coming in. It doesn't count cartons going out to the market, the egg share and the store, or the stack of empty cartons shrinking in the shed. Which pack dates are still in the cooler on Friday is a walk to the cooler.
How TaroStack does it
TaroStack follows the eggs past the packing table.
Each day's pack is a lot. Set a dozen up as a recipe: twelve eggs and a carton. Record the day's packing and the cartons come off stock, and the 24 dozen become a lot with a pack date and a sell-by.
Oldest out first. Orders for the store and the egg share take the earliest pack date by default, and lots close to their date are flagged.
Who got which day. Each delivery records the lots it took, so one report shows where November 12's cartons went.
Cartons on the reorder list. With a reorder point set, the list shows cartons and labels before they run out.
No signal in the barn. Count and record on a phone offline; it sends itself later.
| The job | Log sheet | In TaroStack |
|---|---|---|
| Dozens in the cooler, by pack date | Walk and look | Lots with dates |
| Which cartons go to the store | Whatever's in front | Earliest pack date first |
| Where a day's eggs went | Memory | One report |
| Cartons left | Count the stack | Come off as you pack |
Lots, dates and recalls 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.
