Load Data:The spreadsheet can record up to 10 separate loads of cattle received and managedover the same general time period. The Load data sheet summarizes the expenses of eachload of cattle during the receiving or preconditioning phase (7 to 50 days). These expensesare recorded and summarized to calculate total cost per head including the receiving cost atyour ranch. Determining stocker cattle cost per head post-receiving is vital to budgeting andevaluating the profitability of each load. Good production records can also be utilized toevaluate the stocker operation for increased efficiency, improving cattle performance andlong-term financial stability.The base data sheets titled “Load” (1 thru 10) each have five input sections: receivinginformation, initial processing cost, receiving feed cost, death loss and budget summary.1)Receiving Information. Head count, load weight, cattle price, and date received2)Initial Processing Cost. Processing charges are recorded in this section, separatefrom sick treatment charges. However, the processing charge does utilize the list ofVeterinary products found on the Health Treatment Page (column AT, Line 7). To fill inprocessing cost accurately, the pharmaceutical product you use should be included in theVeterinary product code list with the current price updates. Data needed for theprocessing cost includes product code number (AT 7-107), amount given (dose), andnumber of head. A section is also available for revaccination trips for the load.
3)Receiving feed cost. The feed cost table is designed to record only receivingperiod pounds of feed and cost, not pasture supplementation cost. The spreadsheet liststhe 50 days following the cattle receiving date (column C, row 8) automatically. Theproducer records the pounds of each feedstuff fed to the load on each day. These poundsare totaled and reported in the Receiving Cost, feed summary section. The price for eachfeed commodity should be entered in the Receiving Cost summary section. The units forfeed/hay can be changed, if desired, just as long as the entry in the “daily feed amounts”section is in the same units as the cost (Price $/unit) entered in the Receiving Feedsummary section. The pounds of feed consumed and feed cost are totaled formanagement evaluation.4)Death Loss. Record the date, number and description of the dead stockers duringthe receiving period for the load.5)Budget Summary. The Budget summary section summarizes all the receivingexpenses from the load page. It was designed for producers that wanted to price a load ofcattle after the receiving period. It starts with the cattle purchase cost and adds all thereceiving period costs (processing, feed, sick treatment). To estimate the price producerswould need to be bid ($/cwt) on the cattle to breakeven, producers would estimate thepost-receiving average cattle weight per head and input the current head count. Thisbreakeven price would assist cattlemen preconditioning calves for resale or ownerswanting to value pasture calves for budget purposes.
You've reached the end of your free preview.
Want to read all 4 pages?
- Spring '18
- Dr. Moez