View Full Document

Instructions for Using Stocker/Feeder Cattle Spreadsheet Tools



View the full content.
View Full Document
View Full Document

21 views

Unformatted text preview:

Instructions for Using Stocker Feeder Cattle Spreadsheet Tools University of Missouri Extension Commercial Agriculture Beef Focus Team Evaluation of Buying Stockers This spreadsheet was written in Microsoft Excel1 Conversion to other spreadsheet programs is not guaranteed You will be asked if you want to enable macros in the spreadsheet Click on the Enable Macros button The file has been scanned for viruses and is considered safe as it leaves my office The starting point for this spreadsheet is the upper left corner A1 of the Stocker Calculations Page If you are not at this location as the file is brought up press Control Home or use the scroll bars to go to that location Many of the calculations for this spreadsheet are done on the Sheet 1 page This page is available for you to look at and to examine the equations used however you don t need to enter any information on the page and it is locked If the page is too small or too large for your screen you can change the magnification by going to the View menu and selecting Zoom and then changing the setting Depending on what you want to calculate select left click one of the three buttons Return to Ownership and Management Purchase Price to Attain Given Return or Sale Price to Attain Given Return The spreadsheet allows you to have a period of confinement where the cattle are receiving a majority of their nutrient needs in the form of harvested feedstuffs silage feed grain hay etc followed by a period of time where the cattle are in a grazing situation with or without additional supplement The spreadsheet does not allow you to have the cattle in the grazing situation first followed by a confinement period If you are not utilizing a confinement period you must still enter values in several of the lines in the confinement period section Cost for processing products Cost of treatment Cost of re pull treatment Weight at end of confinement period will be same as purchase weight in this situation As with any spreadsheet tool the answers generated are only as accurate as the accuracy of the inputs Although the mathematical calculations were evaluated by a number of specialists and were tested on thousands of test examples no warrantee is expressed or implied about the accuracy of the spreadsheet PLEASE USE THE SPREADSHEET AT YOUR OWN RISK To Calculate Return to Ownership and Management You will be asked to fill in several variables concerning the stockering situation you are evaluating all variables are on a per head basis not the entire group 1 Microsoft Corporation Seattle Washington Variable Price paid per pound Description The incoming cattle s price per pound Four decimal places are available so that cattle that are purchased at 82 75 cwt are entered as 0 8275 Purchase weight Lbs Average purchase weight in pounds For a group of 40 calves that weigh an average of 550 pounds enter 550 not 22 000 Trucking fee arrival If you are paying trucking fees as the cattle arrive enter the per head charge There will be another entry for trucking fees to ship the cattle out Hired labor cost per head This is not where you pay yourself This line is for any hired labor used to care for the cattle or facilities One way to calculate the entry is to take the entire payroll and divide by the number of cattle fed per year Another option is to charge the labor in the feedmill to the feed charge the processing crew labor to the processing charge the hospital crew labor to the treatment cost etc in which case the hired labor cost per head is decreased or zero Annual interest rate i e 10 The entry should be a number greater than 1 if the interest rate is 10 enter the number as 10 not 0 10 The entry is the interest rate of borrowed money or if no borrowed money is used the entry is the interest rate or return of an alternate investment Confinement Period Price paid per pound of diet as fed Price is reported on an as fed rather than dry matter basis Since more than one diet are fed and the costs of different diet vary the entry should be the prorated cost of the diets Feed storage and mixing loss should be included in the diet price Confinement Period Pounds of diet fed daily as fed This entry should be the average over the feeding period pounds of feed delivered on an as fed basis to the bunk This will account for wastage at the bunk Confinement Period Number of days in confinement The number of days the cattle are confined in the situation being evaluated If the cattle are not confined enter zero Confinement Period Yardage per day Yardage being charged per day If confined on your own land either enter an appropriate yardage fee or if zero is entered return to management should be evaluated with that in mind Confinement Period Cost for processing products Your cost for the products used at processing including the cost of administration equipment syringes needles implant guns etc Processing labor may or may not be included in this value see Hired Labor Cost per Head for vaccines implants dewormers tags Confinement Period Morbidity Rate during confinement period The number of cattle treated for any reason or that died without being treated during the confinement period divided by the number of cattle originally in the group If the morbidity rate is 20 enter the number as 20 not 0 20 Confinement Period Cost of treatment The average cost of antimicrobial or other drugs given to treat sick cattle plus the cost of administration equipment syringes needles etc and any chute charges or other applicable fees Repeat treatment rate and charges are included in this entry Hospital labor may or may not be included in this value see Hired Labor Cost per Head Note It is assumed that the same treatment is used for cattle in the confinement period and the grazing period entire cost of multiple day treatment Confinement Period Re pull rate The number of cattle that are treated more than once after they are considered cured during the confinement period divided by the number of all cattle treated during the confinement period i e if 20 calves in a pen of 100 are treated for disease and then 4 of those calves are treated for the same disease 2 weeks later the re pull rate is 4 20 20 enter as 20 not 0 20 Confinement Period Cost of re pull treatment Many times the drugs used to treat calves pulled from the pen a second or more time are different than the initial treatment therefore the cost is likely to be different The same guidelines are followed as with Cost of Treatment


Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Instructions for Using Stocker/Feeder Cattle Spreadsheet Tools and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Instructions for Using Stocker/Feeder Cattle Spreadsheet Tools and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?