farm Performance Calculator Input Form

Measuring Feedlot Performance Feedlot Performance Calculator This program, which includes an input and output page, is designed to calculate average days on feed, average daily gain and dollars received per pound of gain for an entire group of cattle. All you enter on the input page is date, number of cattle, weight and price of cattle. The program includes sample data which can be overwritten. It's easy to use -just overwrite the blue numbers on the input page, and you will have a summary of valuable information pertaining to the performance of your cattle. Dennis Martin Beef Feedlot Specialist Phone: (519) 482-5976 Fax: (519) 482-5031 Email: dennis.martin@omafra.gov.on.caCattle Information (mark with an "X") Polled Steers x Dehorned Heifers Castrated Continental Implanted x British Vaccinated x Crossbred x -dates must be entered as mm/dd/yy or dd/mm/yy -Weaned depending on the Windows default date setting of your -Bunk Adjusted computer. # of Total Wt. Total Value # of Total Wt. Total Value Date Head (pounds) ($) Cattle Days Date Head (pounds) ($) Cattle Days 9/6/2005 32 34,754 $35,777 10/25/2005 47 60,479 $53,417 2,303 $1.0294 7/21/2005 46 50,115 $51,215 2,162 11/22/2005 47 66,302 $61,602 3,619 $1.0219 7/26/2005 12 12,345 $12,744 504 12/6/2005 37 56,911 $52,369 3,367 $1.0323 7/27/2005 42 47,200 $47,675 1,722 12/12/2005 44 69,217 $64,007 4,268 $1.0101 7/28/2005 14 14,290 $14,309 560 12/12/2005 43 63,616 $56,958 4,171 $1.0013 8/9/2005 31 31,130 $31,164 868 10/20/2005 45 66,647 $58,890 1,980 $1.0011 8/23/2005 69 70,110 $69,201 966 1/3/2006 47 67,916 $60,433 5,593 $0.9870 8/25/2005 37 39,345 $38,958 444 1/8/2006 34 49,961 $44,844 4,216 $0.9902 9/1/2005 42 44,475 $44,018 210 9/18/2005 1 1,100 $734 12 $0.9897 7/13/2005 23 23,530 $23,830 1,265 0 0 0 0 0 0 0 0 0 0 0 Totals 348 367,294 $368,891 8,701 Totals 345 502,149 $453,254 29,529 $1.0043 Numbers in blue can be edited and changed. Feedlot Performance Calculator Input Form Calves areCattle Purchases Cattle Sales Reminder: -When entering Cattle Purchases, the last group purchased must be entered in the first row!Feedlot Performance Calculator Report Performance Information Average Sale Weight per Head (lbs.) 1,456 Cattle Information Average Purchase Weight per Head (lbs.) 1,055 Polled Steers x Average Pounds of Gain per Head (lbs.) 400 Dehorned Heifers Average Number of Days on Feed 111 Castrated Exotic Average Daily Gain (lbs. per day) 3.61 Implanted x British Death Loss (# of head) -3 Vaccinated x x bred x Death Loss (% of purchases) 0.9% Calves Average Sale Price ($ per lb.) $0.90 -Weaned Average Purchase Price ($ per lb.) $1.00 -Bunk Adjusted Dollars Received per Pound of Gain $0.63 # of Total Avg. Wt. Total Price # of Total Avg. Wt. Total Price Date Head Wt. (lbs) (pounds) Value ($) ($/lb.) Date Head Wt. (lbs) (pounds) Value ($) ($/lb.) 9/6/2005 32 34,754 1,086 $35,777 $1.03 10/25/2005 47 60,479 1,287 $53,417 $0.88 7/21/2005 46 50,115 1,089 $51,215 $1.02 11/22/2005 47 66,302 1,411 $61,602 $0.93 7/26/2005 12 12,345 1,029 $12,744 $1.03 12/6/2005 37 56,911 1,538 $52,369 $0.92 7/27/2005 42 47,200 1,124 $47,675 $1.01 12/12/2005 44 69,217 1,573 $64,007 $0.92 7/28/2005 14 14,290 1,021 14,309 $1.00 12/12/2005 43 63,616 1,479 $56,958 $0.90 8/9/2005 31 31,130 1,004 31,164 $1.00 10/20/2005 45 66,647 1,481 $58,890 $0.88 8/23/2005 69 70,110 1,016 69,201 $0.99 1/3/2006 47 67,916 1,445 $60,433 $0.89 8/25/2005 37 39,345 1,063 38,958 $0.99 1/8/2006 34 49,961 1,469 $44,844 $0.90 9/1/2005 42 44,475 1,059 44,018 $0.99 9/18/2005 1 1,100 1,100 $734 $0.67 7/13/2005 23 23,530 1,023 23,830 $1.01 Totals 348 367,294 1,055 368,891 $1.00 Totals 345 502,149 1,456 $453,254 $0.90 Numbers in blue can be edited and changed. Cattle Sales Cattle Purchases