Excel spreadsheet for tracking expenses and income from chickens

[Big C]

Is your cost per egg 8.95 the first month and the next months?

 

[sriston]

Yes. In the summary (where it shows the cost per egg) the cost has never changed, despite the fact that we now get 6 eggs a day as opposed to one egg a day. Surely the price should have decreased some? (I would have thought it would have.)

 

[Big C]

So let me try and get this correct.
This month (and any month after your original purchase) you are showing zero cost in feed purchased, with a constant egg collected per day?

Mine shows so far this month:
eggs collected:
241
Feed cost:
9.00
Feed cost per egg:
.03

The feed cost per egg is the result of a carry over of feed from the prior month. Usually it runs from .03 to .10 per month depending on feed carry over from the prior month and feed purchased in any given month.
The $9.00 is the cost of feed so far this month. I just bought 200 lbs of Purina Sunfresh pellets and 200 lbs of whole corn today for a total cost of $81.16.

Now it shows:
eggs collected:
241
Feed cost:
$90.16
Feed cost per egg:
.35

Hope this helps, if not let me know.

 

[sriston]

For July, when I bought the food, the monthly summary shows:
Eggs collected per day: .03
Feed cost per egg: $8.95

Every month after that shows no feed cost, just the number of eggs collected. Last month:
Eggs collected per day: 2.8
Feed cost per egg: blank (zero I assume)

In the year-to-date summary, this is what it shows:
Eggs collected per day: 1.3
Feed cost per egg: $8.95

I was just wondering if this seems correct. I thought that with the increase in eggs, the feed cost would have changed. I also thought that the monthly summary would show the feed cost per egg but I guess it doesn't unless you buy food every month.

All this math makes my head swim, LOL.

Thanks!

 

[Big C]

The summary is for the entire year.
So, your cost ratio would be a summary of 12 months of feed purchases vs egg production. All your costs vs production will average out over the year so the summary should really only be relevant at years end.
By month cost vs production ratio should be your concern so you can see where you can cut costs so your yearly summary can be as low as you can make it to keep your egg production and quality where you want it.
Since you buy for a period of months you could manually calculate your cost vs production ratio if you want, but at the end of the year your summary will reflect correctly.

Hope this helps some.

 

[sriston]

Thank you! I appreciate your help. I think I understand now.

 

[raizin]

i messaged the boss since I keep forgetting to tell her you are having problems. Our water went out over the weekend and I have been distracted. Also, did you make a typographical error? you said your eggs collected was 0.03?

I personally spread out the cost. I buy 3-6 bags at a time. I only count them as an expense for that month when I open a new bag. I actually have them in a feed container now, but I have lines on the outside for a 50# bag equivalent. This keeps my consumption and production for the month consistent with what the chickens are actually using/producing.

Hope that helps,
raisin

 

[sriston]

No, that's no typographical error. That's what the July summary had. I only had one egg laid in July, right at the end of the month when our Hilda started laying. One laying hen, one egg. The .03 was what the summary said.

Maybe I should do what you do- simply spread out the cost of the food over several months time period so it all isn't being lumped into one month's expense. I don't sell my eggs, I really am just curious to know how much each egg is costing us. LOL.

Thanks.

 

[JoAnn_WI_4-H_Mom]

Quote:
No, you really do not want to know!

My long-suffering DH estimates we have $33 in each bird, and they are just starting to lay.

 

[thumbless]

I really like this spread sheet I added pie charts to mine.