This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Your herd
Your herd
Net Return Breakdown
Settings
Number of cows per 100 cows that died or got euthanized in the herd during the last 12 months
?
Input dead cows %
Output dead cows %
Herd data
SimHerd has simulated the reduction targets. The simulated output of SimHerd in terms of replacement rate etc., is presented below. Click on "About this output" for more information.
?
Output: KPI changes
About this output
Average number of lactating and dry cows in the herd during one year. The number of cow-years is calculated as the total number of feeding days of lactaing and dry cows in one year divided by 365
?
Herd size
Change in the annual replacement rate. Covers fewer dead or euthanized cows and also changes in number of culled cows (cows slaughtered for production, health or fertility reasons)
?
Replacement rate
Milk yield level in the herd = The amount of energy corrected milk produced on the farm divided by number of cow-years
?
Milk yield, kg ECM/cow-year
Change in number of heifers per year that can be sold because they are not needed for replacement due to changes in cow mortality and culling
?
Sold surplus heifers per year
The chance of a succesfull heat observation followed by a insemination of a cow during each cycle (21 days). Calculated as the product of 'Heat Observation Rate' (HOR) and 'Conception Rate' (CR)
?
21-day pregnancy rate
Change in milk production (kg energy corrected milk) per cow-year
?
Milk yield, kg ECM/cow-year
Change in lifetime milk production (kg energy corrected milk) due to cows with higher milk production and longer lives
?
Lifetime production, kg ECM
Dead cows due to, %
Here, you can set the target for a future level of mortality of the different diseases. Reducing the proportion of cows dying from a given disease, will mean a one-to-one reduction of the estimated true disease incidence in the algorithm. See 'Estimated true incidence' info box for a detailed description.
?
Reduction target, %
Output: changes
Number of cows per 100 cows where injuries were the primary reason for death or euthanization. Injuries are defined as sudden events resulting in death or severe, peracute traumas resulting in euthanization.
?
Injuries
Change in enteric methane emission: Total amount of methane produced on farm (by cows and youngstock) divided by kg ECM produced on farm. The total amount of methane is calculated based on feed requirements of the cows and youngstock.
?
Methane emission per kg ECM
Number of cows per 100 cows where metabolic disease were the primary reason for death or euthanization. Metabolic disease is defined as cases of milk fever, ketosis or displaced abomasum
?
Metabolic
Change in labour needs due to reduction of disease treatments, heifer raising and handling of dead cows
?
Labour need, hours per week
Number of cows per 100 cows where severe, chronic lameness were the primary reason for death or euthanization. Peracute lameness due to sudden injuries should be registered as an injury (e.g. a fractured leg)
?
Lameness
Change in Net Return, calculated as revenues from milk and livestock minus variable costs of feed, vet and breeding.
?
Net Return per cow per year
Number of cows per 100 cows dying or being euthanized from reasons not specified above. The value is calculated by subtracting the percentage of cows dead from known reasons from the percentage of dead cows in total.
?
Unspecified cause
Net Return per herd per year
More info
The true incidence of the disease is a lot higher than the number of cows that died due to the disease (as specified above). It is assumed that the number of cows that died because of the disease is a subset (tip of the iceberg) of the total number of cows with this disease. For more information on how this total number is calculated, please click on "Read more"
?
Estimated true incidence
Read more
The estimated true incidence of metabolic diseases in the herd given an average mortality of metabolic disease of 13%. Click on "Read more" for a detailed description.
?
Metabolic diseases, %
The estimated true incidence of lameness in the herd given an average mortality of lameness of 4.2%. Click on "Read more" for a detailed description.
?
Lameness, %
info
The pie-chart shows how the change in Net Return is broken down in increased milk sales, reduced treatment costs and increased livestock sales
?
Net Return per cow per year
Net Return per herd per year
Milk, feed and livestock
Milk price, ppl
Feeding costs, £ per kg DM
Disposal costs per dead cow, £
Price of a heifer, £
Treatment costs, £ per case
Lameness
Metabolic disease
Mastitis
Print