Stocker Receiving Records: An Excel®Spreadsheet ProgramGreg HighfillOCES Area Livestock Specialist, EnidIntroductionStocker cattle producers buy calves in semi-trailer load or pickup-trailer load lots froma sale barn or large ranch. When these loads are received at the ranch, they are often managedtogether as a group and budgeted at a common purchase price. Producers often attempt to keep health records, production expenses, and profit databased on these load lots. Load lots of cattle are often managed together during the receivingor preconditioning phase. Producers often would like to have receiving cost information toassist them in improving management decisions. This spreadsheet program summarizes thetotal stocker receiving expenses and purchase price to determine the total calf cost per headafter preconditioning. This total calf cost is a key budget item for determining grazing periodbreakeven price or to price preconditioned calves for resale. After the receiving period, cattle are often commingled with other loads and grazed onpasture. A common question stocker producers ask is “did xyz load of cattle make money”.Given the extensive commingling for grazing and multiple marketing groups from eachpasture, the answer is usually difficult to attain. If producers are able to identify cattle by loadof origin and keep accurate sorting and marketing records, the gross sales of an individualload, commingled into multiple pastures, can be estimated from the average value per head.Spreadsheet Program.The Stocker Receiving Records spreadsheet was written to help producers monitorstocker receiving cost for a specified group of calves, usually a semi-trailer load. The Excel®spreadsheet was designed to assist producers currently keeping written records to record thisdata and allow the computer to make calculations needed for management decisions. Thisprogram enhancesthe written records taken; it does not replace the need for written records. This program was written as an aid to producers wanting to develop their ownspreadsheet that matches their stocker operation. The data needed to operate this spreadsheetincludes pharmaceutical processing products and cost, feed commodities, pounds fed andcost, health treatment products and cost, and cattle purchase cost. Producers can modify theMicrosoft Excel®spreadsheet to match the entry and calculations they desire. To utilize thisbase program, input data in the cells with the blue font color. Knowledge of Microsoft Excel®would make the data input and application easier to follow. This program figures expenses per load but does not monitor individual animal ID.Cattle pulled for health treatment as sick during receiving can be individually identified, ifavailable, but load identity is all that is required by the spreadsheet for allocating treatmentexpenses to the appropriate load.
You've reached the end of your free preview.
Want to read all 4 pages?
- Spring '18
- Dr. Moez