Excel spreadsheet for tracking expenses and income from chickens

Discussion in 'Managing Your Flock' started by raizin, Jan 21, 2009.

  1. raizin

    raizin Chillin' With My Peeps

    184
    14
    131
    Apr 15, 2008
    Eastern Oregon
    My Coop
    My wife, the wonderful woman that she is, created a nifty and handy Excel spreadsheet for me to track income and expenses for my chickens. It includes columns for tracking egg production and sales, feed expenses, and tracks hatch rates, (it does way more, but I can't list it all). It has multiple reports, and tracks by month and year total. If anyone would like a copy let me know and I will send it to you. If you have any ideas for improving it, let me know those too and I will see if I can get her to update the spreadsheet in a little while. I had her add in a lot of features we won't use yet, but I wanted to be able to use them in the future.


    ETA: It is a new year 2011. My wife changed the year on the tracker and fixed a bug we had. Enjoy the tool.

    ETA: It is now 2012. I am going to paste some instructions that were buried in one of the later posts and I will add the link below for the 2012 dated version. I have not gotten my wife to add the "how died" section for chicken losses. Hoping to sweet talk her this year into doing that for me. enjoy and feel free to pass this around and let people know it exists.

    The form does everything for you so data entry is the key to making it work correctly. Just open the current month tab you are working on. I will go through each section.
    The first section is the date, be sure and use the number under the date column. In Excel it numbers the lines and these are the first numbers you see. Don't use those, use the "date" column numbers (all these hints are from mistakes I have made, lol).
    The next column is "laying hens, quantity" just enter the number of hens you have that are of laying age. This will automatically be carried down for the whole month so if you lose some hens in the middle of the month just enter the new number of hens on that day. The program adjusts you numbers accordingly (I had raccoons killing hens all month one month last year.)
    The next column is"production", this is easy just put the eggs collected under each column. I had my wife make different sections for different colored eggs, just so I could see how my chickens were laying. The production calculator doesn't care where you put them just so you enter the number of eggs collected on that day in one of the three columns.
    the next column grouping is "Income" further broken down into "eggs sold" I just add up the amount I sold so 2 doz eggs go for $5. I enter a 2 in the "dozen" column and 5 in the "$" column. This will also take decimal points so if you are selling 18 packs you can enter 4.5 in the "dozen" column and 11.25 in the "$" column.
    the "chickens sold" works the same way. You could even use this for meat chickens if you are just selling carcasses.
    Under "Expenses" the important one is "feed purchased" you have a "pounds" and "$"" column. I put these in as I open a new bag of food. This way I can credit the charge to that month. So I am using around 300# of food every month during the Winter so I have five separate line items with 50 under "pounds" and 8.89 under "$" column (this also lets me account for the feed price change. mine changes with the price of corn so I paid $8.89 to $11 last month.) The other expenses just put in the number of the total cost of the items.

    Now results, the computer and program automatically compile this information every time you make a new entry into the spreadsheet. At the bottom of the page you have some averages specific to that month.
    the "Average productivity" section:
    "laying hens per day" average number of laying hens for the day.
    "Eggs collected per day" total number of eggs collected every day divided by the number of days in the month
    "percent productivity" is the number of eggs collected per day divided by the number of hens laying. So if every chicken laid an egg every day of the month it would be 100%.
    "pounds feed per egg" is the number of eggs collected divided by the amount of feed in pounds that you fed the chickens. If you free range this number varies drastically by the season.
    "feed cost per egg" is the amount you paid for feed only that month divided by the number of eggs collected. I then multiply this by 12 to see what my feed costs are per dozen eggs.

    the "Monthly Financial Summary" section:
    "income" takes all the money collected from the eggs sold column and chickens sold column and adds them up.
    "Expenses" adds all your expenses together except you flock purchases.
    "Flock purchases" adds the amount you spent on live chicks and/or hatching eggs.
    "Net" takes you Income and subtracts the Expenses and Flock purchases from it.

    The "Hatching eggs" section:
    "hatch rate" takes the number of live chicks that survived to hatch and divides it by the number of eggs you started with in the incubator. If you are over 70% here you are doing great.
    "cost per live chick" takes the amount you paid for the eggs (you placed in the incubator) and divides it by the number of live chicks that hatched.

    There is also a summary tab that gives you this information for the entire year. As you go through more months your annual summary will change accordingly. It works pretty slick. Any more questions let me know,
    Raisin

    .https://docs.google.com/open?id=0B7DYHxGoNHhrNzcyYjdiYWMtNTk5NS00Y2I3LWI4YzAtMjE3MDBjODVmYzBm
     
    Last edited: Jan 31, 2012
  2. #1California Chick

    #1California Chick Chillin' With My Peeps

    Dec 5, 2008
    SF Bay Area
    [​IMG] LUCKY YOU!!!!! [​IMG]

    Can you share???

    Cindy
     
  3. wookiee

    wookiee Out Of The Brooder

    54
    0
    29
    Dec 31, 2008
    I am also interested. My spreadsheet is a bit sad. Two columns, 1 for date and 1 for number of eggs.
     
  4. chicks for better health

    chicks for better health Chillin' With My Peeps

    452
    0
    139
    May 4, 2008
    West Glenville, NY
    I am interested please e-mail it to me.

    Thanks
     
  5. Reinbeau

    Reinbeau The Teapot Underground Premium Member

    Quote:I am very interested, please e-mail it to me, and I'll be happy to share any thoughts, I've got one but it isn't anything fancy. Thank you so much!
     
  6. EmptyNest

    EmptyNest Chillin' With My Peeps

    356
    0
    139
    Jan 7, 2008
    SW Iowa
    I would LOVE to have a copy of this. Thanks so much [​IMG]
     
  7. Mahonri

    Mahonri Urban Desert Chicken Enthusiast Premium Member

    30,361
    151
    446
    May 14, 2008
    North Phoenix
    My Coop
    Can I have a copy too?
     
  8. CarolMinnesota

    CarolMinnesota Out Of The Brooder

    40
    0
    22
    Jul 26, 2008
    Yes, please send.

    But is there a way you can post it on this BYC somewhere so as to save you a lot of time sending?

    Thanks!

    Carol in Minnesota
     
  9. Jolly_Rancher

    Jolly_Rancher Out Of The Brooder

    Please add me to your list.. [​IMG]
     
  10. Pumpkinpup

    Pumpkinpup Poultry Princess

    Jul 16, 2008
    North-West Georgia
    I, too, would love a copy of this! Wow, thanks for sharing! [​IMG]
     
    1 person likes this.

BackYard Chickens is proudly sponsored by