Mastitis Cost Calculator for Dairy Farms (Excel)
From $2.00 Pay what you want. Suggested $249.00
What does mastitis really cost your herd every month? Enter your own numbers to see the milk lost, treatment and culling cost, the hidden loss from subclinical mastitis, and what prevention could save.
Instant download. Price in Indian rupees; international buyers pay about $7 USD at the current rate.
- Instant download right after payment
- Secure checkout by Razorpay. UPI, net banking and cards work in rupees
- Pay what you want: from $2 (or ₹199). Pay more if you would like to support the work
- All sales are final. Please read the delivery, refund and licence policy
Description
See the cost you cannot see. Visible mastitis is only part of the loss. This Excel calculator adds up everything on your numbers: milk discarded and lost, treatment, culling, and the quiet loss from subclinical mastitis, month by month and year by year.
What it works out
- Clinical mastitis: milk discarded, milk lost to lower yield, treatment cost, and culling or death cost.
- Subclinical mastitis: the milk lost in animals with no visible signs.
- Total cost per month and per year, per milking animal and per litre, and as a share of your milk income.
- How much of the cost is hidden (subclinical).
- A what-if: enter how much a prevention programme might cut cases and what it costs, and see the monthly saving, the net benefit and the return.
- A chart of where the money goes.
What is inside (one Excel file, four sheets)
Start Here, Inputs, Results and What-if. The example numbers are placeholders: replace every one with your own. Use any currency.
Good to know
- Arithmetic on your numbers only. It gives no treatment advice, and it does not say what your rate of mastitis, milk loss or withholding should be. Take withholding days from the drug label and follow your vet.
- The calculations were checked against a hand calculation. It uses standard Excel formulas and was checked in LibreOffice. It has not been tested in Microsoft Excel itself or in Google Sheets.
- Pay what you want, from $2 (or ₹199). The suggested price is $7. Pay the minimum, or more if you would like to support this work.
- Instant download after payment: up to 5 downloads within 12 months.
- All sales are final. Please read this page and our delivery, refund and licence policy before you buy. If the file is damaged or does not arrive, we will fix or replace it.
- Licensed for use on your own farm. Please do not copy, share or resell the file.
By Dr. Rameez Bloch, BVSc & AH, MVSc (Gujarat Veterinary Council Reg. 3570).



