Do you keep track of the egg production?

I currently have an Excel spreadsheet with

- Date
- eggs/day
- cost per egg
- average cost/doz.
- expenses
- quarterly cost and annual cost

I am working on an Access Database so I can keep track of my 5 chickens with criterias such as which one laid an egg for the day, break down "profitability" of each hen and whatever other crazy thing I want.

Sick, I know.

Is there a profitability? I would be scared to keep track of that because I suspect each girl would be in the red for sure!
caf.gif
 
I have in the past but it slows down so much in winter that it isn't worth my time. I'm just happy I get to them before the eggs freeze and split!
 
Yeah, spreadsheet. It charts consumable expenditures, non-consumable expenditures, running tallies for both separate and a tally for those merged, date, number of eggs, flat overall cost per egg, flat overall cost per dozen, amortized cost of non-consumables + consumables running tally, the previous item cost per dozen, and feed cost per dozen.

I added the amortized cost/dozen recently. Interesting column, that is.

I don't keep track of how much any individual is laying because that'd be difficult, though I do have a general idea of how each breed is performing overall. This summer I'll separate the hens or use the food-coloring method to find out who's really laying what to set up and see if anyone needs culled at molt.
 
I used to be an accountant/bookkeeper and now - I am really not all that fond of having to keep records. So I just do a mental tally. Though I think about writing it down all the time!
wink.png
ha ha... guess that thread on here re: how many eggs you get today is about as far as I ever get to actually writing it down. LOL...
 
I have a notebook where I chart the egg production for each day, how many are sold and to whom. That way I can pretty much predict when my regular customers are going to need eggs again.
 
You bet I do! I got Steve's Chicken Tracker when he was offering it. He put a lot of work into the formulas and it is a really well done spreadsheet, keeping track of all expenses, plus all income produced (egg sales, chick sales etc.) as well as number of laying hens per day and number of eggs collected each day. At the bottom it tallies the production expense/profit for the month, and then on a summary tab, keeps track of the same data for the year.

Having got my chicks in August last year, I ended last year with a grand total of four eggs collected so I was in the "red". I hope to end this year in the black....
 
I made a simple Excel sheet for counting the daily eggs, and totalling for the month, and it will carry forward for the yearly. But I seem to have forgotten about the expenses part... lol

But I am slowly upgrading it.
thumbsup.gif


I was really only interested in tracking the eggs laid and sold.

ETA: Record thus far is on 1/12/2010- 32 eggs from 34 hens and 1 Rooster!
Average is 26 eggs per day!
 
Last edited:
I am an accountant, so I keep track of sources and uses of funds. Dates and dollars for egg sales, chick sales, construction costs, supply costs, feed cost. We do count the eggs we collect everyday, but I stopped writing it down after it became a consistant 17, 18 or 19. My average is 18, okay. I did note the day we got 21. We have 23 hens someday I will collect 23 eggs. I will write that down. My background is in auditing, and I perform reasonableness tests. Looking for a 96% accuracy rate. I never worried about pennies, just round it out.
 

New posts New threads Active threads

Back
Top Bottom