Milk Rate Chart Maker & FAT/SNF Price Calculator

About the Milk Rate Chart Maker & FAT/SNF Price Calculator

A rate chart for a milk collection centre, a village dairy society or a small dairy, made in your browser. Choose how your union or buyer pays — a price per kg of fat, two-axis prices per kg of fat and per kg of SNF (or worked out from a standard milk’s price and a fat : SNF split such as 60 : 40), a price per kg of total solids, a base rate at a standard FAT and SNF with steps per 0.1, a fixed rate, or a table of rates by FAT and SNF or by FAT and CLR — and the page builds the whole chart, ready to print on A4 or A3, with blank cells wherever no price is paid. Without a pass the chart is a free preview: its pages show marked “not for use” and the page shows the first rows of the table; a Premium pass gives the clean PDF, the print and the CSV and Excel files.

Price one sample as you go: type the quantity, FAT and SNF (or the CLR from the lactometer, with the milk’s temperature if you read it by hand) and see the rate per litre or kg, the amount, and the kilograms of fat and SNF. A chart saves and opens as a chart file, also without a pass — the Milk Collection Register prices pours from it and the Milk Passbook checks farmers’ slips against it. The prices are always yours to type: the example chart uses made-up figures.

Common uses

• A village collection centre printing the chart it pays farmers by, for the wall and for every farmer who asks.
• A society secretary checking the rate of a sample against the union’s rate list before paying.
• A small private dairy setting its own buying chart, with lower limits for FAT and SNF.
• Anyone moving a chart into milk-collection software that imports CSV or Excel.

How milk is paid for

At a dairy cooperative society each member’s milk is tested and paid for by its fat and SNF, as the National Dairy Development Board describes the Anand pattern; the union usually gives its societies a price chart or ready reckoner, and members are paid daily, weekly or every ten days, as the Dairy Knowledge Portal’s guide to societies and unions explains. The chart is how a centre turns a sample’s FAT and SNF into a rate.

• Price per kg fat: a kg of milk with 4.5% FAT holds 0.045 kg of fat, so it is paid 0.045 × the fat price.
• Two-axis: fat and SNF are paid separately, each at its own price per kg. A standard milk’s price with a split (for example 60 : 40) gives the two prices: the standard milk is paid exactly its standard price, and richer or thinner milk more or less.
• Total solids: one price per kg of fat + SNF.
• Base rate with steps: a rate at a standard FAT and SNF, plus or minus a fixed amount for every 0.1 above or below.
• Table: the rates themselves, as a union prints them — FAT down the side and SNF or CLR across the top.

A chart quoted per litre needs the weight of a litre: the page uses 1.03 kg unless you type your union’s figure.

SNF from the CLR (lactometer reading)

A lactometer shows the milk’s density in degrees: a corrected reading (CLR) of 28 is a specific gravity of 1.028. SNF follows from the CLR and the FAT by a formula of the form SNF = CLR ÷ a + b × FAT + c. The page starts with Richmond’s formula, total solids = 0.25 × CLR + 1.2 × FAT + 0.14 (H. D. Richmond, Dairy Chemistry), which gives SNF = CLR ÷ 4 + 0.2 × FAT + 0.14. Richmond gives it for milk with a specific gravity from 1.020 to 1.036, a CLR of 20 to 36. Unions use their own constants and print them on their charts, so choose My union’s own constants and type them.

A lactometer is right only at the temperature it is made for. If you read it by hand at another temperature, type the correction per °C from its card under More options and the milk’s temperature in the calculator.

Blank cells, steps and rounding

• No-price rules leave cells blank: for example no price below 3.0% FAT, or below 7.5% SNF, or below 8.1% SNF when the FAT is under 3.5%. A sample in a blank cell gets no rate.
• Readings between two steps count as the lower step (a part step is never paid) or as the nearest one.
• Rounding applies to worked-out rates: to the paisa, or to 5, 10, 25 or 50 paise or a whole rupee, to the nearest, down or up.
• A typed table keeps its rates exactly as typed.

Files for other software

With a Premium pass, the table downloads as CSV and Excel files with FAT down the first column and the SNF or CLR values along the first row, the rate in each cell and a blank where there is no price. CSV list writes one line per priced cell (FAT, SNF or CLR, and rate) for software that wants a list. The chart file (.json) keeps everything, options included, and opens here again. Importing works the other way round: a grid or a list with FAT, SNF or CLR, and RATE columns, from CSV, Excel or text pasted from a spreadsheet.

Limitations

• The page makes and prices charts; it does not know any union’s current rates. Type the rates your union or buyer pays, and check the printed chart against their rate list.
• Tables are at most 200 FAT rows by 120 SNF or CLR columns.
• The temperature correction is one factor per degree; for exact work, use the correction table that comes with your lactometer.
• Charts kept in this browser stay on this device only: save a chart file to move one to another device.
• In the free preview the page shows the first rows and columns of a table the formula works out, and the whole chart only as marked page images; a table you import or paste shows in full.

Privacy

Your chart, its prices and the samples you price stay in this browser on this device. Nothing is uploaded.