Herd information     Results        
No. of cows in milking herd
Number of calves produced

Enter the number of maiden heifers served per year
Maiden heifers to serve
Beef calves

Enter the age at first calving of your heifers
Age at 1st calving (months)

Takes into account 90% chance of a heifer from sexed semen
Dairy bull calves

Herd replacement rate = The number of cows leaving the herd (culls, deaths and TB etc) in any 12 month period / herd size x100
Herd replacement rate %

Takes into account 90% chance of a heifer from sexed semen
Dairy heifer calves
Average litres/cow/year
Surplus fresh calved heifers available for sale
AI Semen usage information

£1600 @24months + £2.87 per day over 24months

(Will be at a default value of £1600 if no heifers are being reared but not included in further calculations)
Cost of rearing 1 replacement heifer (£)
     
Cows

Enter the % of your cows you wish to serve to conventional semen
% served to conventional

No. of heifers reared to first calving x heifer rearing cost
Total heifer rearing cost (£)

Enter the % of your cows you wish to serve to sexed semen
% served to sexed

Enter the % of your cows you wish to serve to beef semen
% served to beef

Figure based on the amount of straws needed to get all animals in calf at the stated conception rates.
Semen costs (£)
% served sweeper bull
Conventional semen
Heifers
Sexed semen

Enter the % of your heifers you wish to serve to conventional semen
% served to conventional
Beef semen

Enter the % of your heifers you wish to serve to sexed semen
% served to sexed

Enter the % of your heifers you wish to serve to beef semen
% served to beef
Stock bull cost (£)
% served sweeper bull
:
Current bull worth + maintenance (£500/year)/ total number of calves produced
Cost per calf
Conception rates %
:
No. calves sired this year x cost/calf + £500 maintenance
Total cost of stock bull inc. maintenance this year

Enter the average conception rate achieved across your cows to conventional & beef semen
Cows conventional/beef

Enter the average conception rate achieved across your cows to sexed semen
Cows sexed
Cost of fallen stock removal (£)

Enter the average conception rate achived across your heifers to conventional & beef semen
Heifers conventional/beef

Enter the average conception rate achieved across your heifers to sexed semen
Heifers sexed 

No. of calves sold x market value
Value of sales (£)
Dairy heifer calves
Calf rearing information
Dairy bull calves

Calf mortality rate = heifer and bull calves dying up to 12 months/ calves born in a year x 100
Calf mortality rate (%)
Beef calves

Enter the % of heifers that you sell as calves (before 6 weeks of age)
Dairy heifers sold as calves (%)

Enter the % of heifers that you rear through to first calving
Dairy heifers reared to first calving (%)

Taken from Herd replacement rate and based on your average liveweight
Only the value of O+3 cattle is included in Total Margin.
Cull cows (O+3 grade)
Cull cows (P+2 grade)
Cull cow price information

Enter the price/kg achieved for an O+3 cull cow
Cull cow £/kg/deadweight (O+3)

(Total heifers reared - Herd Replacement Rate & no. of TB culls) x market value of fresh calved heifer
Fresh calved heifers

Enter the price achieved/kg for a P+2 cull cow
Cull cow £/kg/deadweight (P+2)

Insert the average TB reactor value for a cow in your herd if it is routinely forming part of your herd replacement rate. If not, please enter 0.
Average TB reactor value/cow
Total value of TB reactors (£)
Calf and heifer valuations/head (£)
Total value of Pedigree bull sales (£)

Enter the average value achieved for the sale of 1 fresh calved heifer
Market value of fresh calved heifer 

Heifer calves sold before 6 weeks of age
Market value of heifer calves

Calf sales + heifer & cull sales
Total value of sales (£)

Rearing calves (not more than 6 weeks old)
Market value of beef calf

Rearing calves (not more than 6 weeks old)
Market value of dairy bull calves
           
      Total Margin (£)      
Semen costs/straw (£)              

Enter the price paid for a straw of beef semen
Beef semen 
 

Margin - Cost of buying in heifers to meet replacement rate
Total margin (flying herd) (£)
     

Enter the price paid for a straw of sexed semen
Sexed semen
           

Enter the price paid for a straw of conventional semen
Conventional semen
Pence per litre value/cow/year

(Value of calf sales - semen costs)/Ave. litres
Calves
Stock bull details

Value of heifer sales/Ave.litres
(heifer rearing costs already accounted for in sale value)
Fresh calved heifers
Stock bull purchase price (£)

(Value of cull - cost of rearing replacement heifers)/Ave. litres
Cull cows
Ave. number of years kept  

(Value of TB reactors - cost of rearing replacements)/ Ave. litres
TB Reactors
     
Cull value (£)
Slaughter and cull details 

Average mature cow weight of your herd
Averarge mature cow weight (KG)

Enter the % of your herd replacement rate that will result from voluntary culls
% voluntary culls

Enter the % of your herd replacement rate that will result from fallen stock (not TB reactors)
% fallen stock

Enter the cost of fallen stock collection per animal
Cost of fallen stock collection per cow (£)
Number of your herd that will go as TB culls
No. TB culls
Pedigree Bull Sales

Enter the number of bulls that you sell per year for pedigree breeding
Number of pedigree bull sales/year

Enter the average price achieved per bull sold
Average price/bull (£)