At no time in recent memory have livestock producers needed to crunch the numbers as hard as they have this year. Skyrocketing feed costs, combined with scarcity, have made figuring costs one of your toughest farm chores. That's why we dug into the Farm Futures Spreadsheet of the Month archive to bring you a classic.
The Feed Cost Calculator from University of Illinois is an oldy but a goody and one we felt worth a second look. This spreadsheet, which we originally featured in December 2009, allows you to calculate costs per pound of energy and crude protein on a dry matter basis minus storage loss and transportation costs. The farm-focused spreadsheet will even calculate the relative value of different feed ingredients.
FIGURE COSTS: The spreadsheet you can download from this page offers a framework for determining feed costs.
We’re featuring the spreadsheet as our Farm Futures Spreadsheet of the Month. The 380 kilobyte spreadsheet should work with Excel 2000, 2002, 2007, 2010 or Excel XP. You can download it by clicking on the link below.
Do you have a spreadsheet that’s made a difference on your operation that you’d be willing to share with other readers? Drop us a line at FarmFutures@farmprogress.com with a description of the spreadsheet. We’ll pay $75 if we feature your farmer-written non-commercial program as our Spreadsheet of the Month.
Download file: FeedCalculator.xls
Size: 1009.152 KB (Kilobytes)
Created: 12/10/2012 09:41 AM
Last Modified: 12/10/2012 09:41 AMClick here
to download this file.