Dairy Milk Cost and Profit Planner for Farmers (Excel)
From $2.00 Pay what you want. Suggested $299.00
What does a litre of milk really cost you? Enter your herd, feed and costs to see cost per litre, profit per litre, break-even price and yield, profit per animal, and what-if changes in feed or milk price.
Instant download. Price in Indian rupees; international buyers pay about $9 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
Know your real cost of a litre of milk. Many dairy farmers sell milk without knowing what each litre costs to produce. This Excel planner does the arithmetic on your numbers, so you can see where the money goes and what a change would do to your profit.
It pairs well with DrblochVet’s free Milk Cost per Litre and Least-Cost Ration Planner, which finds the cheapest feed mix and your feed cost per litre. This planner then shows the whole-farm picture: feed plus labour, health, loans and everything else, down to your profit and break-even price.
What it works out
- Cost of producing one litre, and your profit on each litre.
- Break-even milk price and the break-even yield per animal per day.
- Profit per month, per milking animal, and per animal including dry animals.
- Feed cost per litre and as a share of total cost, with feed entered by kilograms per animal per day and price per kilogram, for milking and dry animals separately.
- A chart of where the money goes, by cost group.
- A what-if sheet: feed price up or down, milk price up or down, and one litre more or less per animal per day.
What is inside (one Excel file, four sheets)
Start Here, Inputs, Results and What-if. The example numbers are placeholders only: replace every one with your own. Use any currency.
Good to know
- Every figure comes from you. The planner does arithmetic: it does not give feeding, breeding or veterinary advice, and it does not claim what a good cost or margin is, because these differ by farm, breed, season and region.
- 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.
- Instant download after payment: up to 5 downloads within 12 months.
- All sales are final. Digital products are not refundable once delivered, so 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).




