You plan to start a cow-calf operation with the aspirations of increasing the herd at a steady rate over the next 10 years. You plan to begin your operation with 80 bred cows and 950 acres of grass. Your geographic area is well suited for 1 pair per 10 acres. Assume every animal every year will have an offspring. Every year, you plan to cull older cows and keep as many replacement animals as you can while still turning a profit. You plan to cull at an 8% rate and use a 14% replacement rate. We can expect a death rate of 2%. Create a spreadsheet that analyzes this data. Use formulas in all cells. You can round to whole numbers to make things easier. 

Calculate everything from the beginning of each year and answer the following questions in your spreadsheet. 

1. At approximately what point in time will we exceed our stocking rate? 

2. What will our herd size be at the end of year 10?

3. How do you find the point at which you will exceed the stocking rate??

Answer rating: 100% (QA)

To create a spreadsheet that analyzes the cowcalf operation data and answers the questions we will set up a yearly calculation for each parameter We w... View the full answer