CHICKEN RECORDS SPREADSHEET HOW TO

You can address specific costs to see if they can be lowered, which will improve your bottom line. Having these numbers helps with a lot of decision making! Knowing your true costs helps you determine what you need to charge.

CHICKEN RECORDS SPREADSHEET HOW TO

I wonвЂ™t get into the specifics of how to allocate those expenses between each class, but you get the idea. For us, that would be beef, pork, and chickens. If you have other sources of income, then you have to split those overhead costs over each of your income classes. If youвЂ™re only raising chickens, then you can just include all of these as part of your Total Costs. ThatвЂ™s Overhead Costs вЂ“ things like Insurance, Rent, Bank Fees, etc. ThereвЂ™s one other cost that should be included, but I donвЂ™t quite have it here yet. Total Profit per Head = Total Profit / Chickens Processed If you donвЂ™t include these, you wonвЂ™t get a true picture of your profit. I also list the chickens we kept, but I list those at cost. That will get you close enough for the purposes of a decision making tool. You can either enter your actual sales (from QuickBooks or whatever accounting record keeping you use), or you can just use the average processed weight per chicken multiplied by the number of chickens sold. Total Cost per Pound = Total Cost / average processed weight per chicken (in this example I used 4.5 pounds) Total Cost per Head = Total Cost / Chickens Processed Total Cost = Total Variable Costs + Total Fixed Costs The rest of the calculations go like this: Pull that total directly over into the Total Fixed Costs cell, and then divide that total by Chickens Processed to get Total Cost/head. (I noticed that I have вЂњpoultry nettingвЂќ in both Supplies and Fixed Costs. I just made a best guess as to how many years to depreciate these costs for each asset, and I keep track of what year IвЂ™m on in the spreadsheet. Furthermore I divide each yearвЂ™s cost for that asset between the number of batches IвЂ™m doing that year. Then there are fixed costs that are spread out over the вЂњlifeвЂќ of the asset. Divide Total Variable Costs by Chickens Processed to get Variable Cost/head. I usually break out the miscellaneous costs off to the side like this:ДЄnd then pull that total directly into the вЂњBedding & Misc SuppliesвЂќ line item in the first picture. These include the costs of purchasing the chicks the cost of the feed (which can be pulled directly from the Total Feed Cost cell) round-trip mileage to the hatchery and processor, calculated at the IRS mileage rate for the current year processing costs and the cost of other miscellaneous supplies. These numbers are useful because improving them improves your profit per bird. So feed consumption per head is the Total Pounds divided by Chickens Processed, and feed cost per head is the Total Feed Cost divided by Chickens Processed. The feed consumption and cost per head are calculated using specifics from another area of the spreadsheet: The death loss is calculated as (B3 вЂ“ B4)/B3 What you canвЂ™t see are the formulas behind some of the cells. HereвЂ™s an example of what I use with some made up numbers: Some of the numbers in the spreadsheet (like feed costs) come from QuickBooks. We use QuickBooks for the record keeping we actually base our tax returns on. This is just a tool we use for decision making. If youвЂ™re not, itвЂ™s like our accountant likes to tell usвЂ¦ вЂњYou know youвЂ™re just supplementing other peopleвЂ™s grocery bills, right?вЂќ Tyrants, I tell you!Д«ut if youвЂ™re going to keep chickens for profit, then youвЂ™ll eventually need to figure out whether or not youвЂ™re actually making a profit. Not only do I have to keep their schedules, there are also records to keep. I told you in my last chicken post that chicken are tyrants to work for.

Chicken records spreadsheet