In the worked example of a Purdue Extension guide to dairy farm energy audits, one farm paid $39,491 for electricity in a year and $62,679 for diesel. Electricity was 31 percent of the $127,688 the farm spent on energy, and diesel was 49 percent. A farmer who watches only the electric bill watches less than a third of the money and a sixth of the energy the farm buys. The next decision is what to buy: panels, a new motor, a tank. A farmer who decides from the electric bill alone aims at the wrong target.
Put twelve months of every energy bill on one sheet, convert them to one unit, split the electricity by job, and compare what the panels make with what the bill shows. Do that before you buy anything.
Which bills go on the sheet, and for how many months?
Every energy source the farm buys gets its own column: grid electricity, diesel, propane or natural gas, and any wood or gasoline. The Ontario Soil and Crop Improvement Association sets the minimum for a detailed farm energy audit. The auditor must review at least 12 months of utility bills to quantify consumption of electricity, natural gas, diesel, propane and other energy sources.
Twelve months is the unit because each load (each machine that uses energy) follows its own season, and a shorter sheet leaves some of them out. Purdue’s guide asks for the same record before an audit visit: the usage and costs of the prior year’s energy, listed by resource. It adds that checking the results of any change afterwards takes a year of data.
Diesel is the column easiest to forget, because it arrives as delivery tickets and card receipts, not as a monthly statement. Enter each delivery in the month it arrived. If you read the tank, a balance of what it held, what came in and what is left, as in the check of fuel bought against hours worked, turns deliveries into gallons used.
If the farm has panels, add two more columns. One is the kilowatt-hours the panels made, which the inverter app shows (the inverter is the box that turns panel output into grid power and logs it). The other is the kilowatt-hours sent to the grid, which the electric bill shows.
How do I compare a kilowatt-hour with a gallon of diesel?
Convert electricity and diesel to one common unit, a million British thermal units, written MMBtu, a measure of heat. One kilowatt-hour is 3,412 British thermal units, so one MMBtu is about 293 kilowatt-hours. Purdue’s audit procedure follows these steps. The auditor summarizes the bills into an average cost per kilowatt-hour and per gallon, converts each to dollars per MMBtu, and adjusts for the efficiency of the machines each fuel feeds.
The guide’s worked example shows what that does to the picture.
Read these numbers three ways. In money, diesel is the bigger line and electricity the second. In energy bought, diesel is half the farm and electricity a sixth. Per unit of energy, electricity costs twice what diesel does, which is why a third of the money buys a sixth of the energy.
The last reading, useful energy, is for judging what a swap would save, and it rests on efficiencies that the guide assumes for the engines. Start with the first two. They need no assumption, and they decide which column deserves the next hour.
A second sample also puts diesel near half of the energy, with a much larger electric share. Uruguay’s Ministry of Industry, Energy and Mining built a manual on energy audits of 103 dairy farms. On those farms, electricity was 50 percent of consumption and diesel 48 percent, 98 percent together. Both samples are dairy farms. A grain farm with a dryer or center-pivot irrigation may split differently, and the sheet is how it finds out.
Where does the electricity go inside the farm?
The bill gives one number for the whole farm. The Ontario requirements ask for more: a baseline for the farm’s major activities (their use before any change), using measured data wherever possible, which can include sub-metering or spot measurements. A sub-meter is a second meter on one circuit. A spot measurement is a reading of one machine’s power at one moment, taken with a clamp meter, a hand tool that reads the current in a wire.
Few jobs carry most of the bill. On the 103 Uruguayan dairy farms, milk cooling took 40 percent of the electricity and the milking vacuum pump 30 percent. Water pumping took 15 percent, and hot water, lighting and motors took 5 percent each. List the two or three biggest loads on your farm and measure those first.
Without a sub-meter, estimate each load as its power in kilowatts times the hours it runs in the year, then add the loads and compare the total with the 12 months of bills. On a second tab of the sheet, each load gets a row: its power, the hours of each month and the kWh. Count the hours month by month for a load that follows the season, such as grain drying or irrigation. A load that runs all year, such as the milk tank, can use its daily hours times the days. The estimate costs nothing, but it rests on the nameplate power, and a motor can draw less or more than its plate says. A clamp reading on the two biggest loads replaces that guess with a measurement.
Write the leftover as its own line, not explained, and leave it there. Spreading it across the loads makes the sheet look closed and hides the question. A large leftover means a load is missing from the list, usually one that runs when nobody is looking. A house, a shop or a pump for a neighbor on the same meter belongs here too. For the family home on a dairy’s meter, the Uruguayan manual advises estimating its use and taking it out, or keeping the same method before and after any efficiency measure so the comparison holds.
How do I check what the panels make against the bill?
Panels make the bill smaller, and a smaller bill hides how much the farm uses. The farm’s total use is the kilowatt-hours bought from the grid, plus the kilowatt-hours the panels made, minus the kilowatt-hours sent to the grid. Find the first and the last on the electric bill and the middle one in the inverter app. Do the sum for each month, because the array’s output follows the sun and the farm’s load follows the herd and the crop.
The array made 45,000 kilowatt-hours, which is 38 percent of the 120,000 on the bill, the ratio that is easiest to compute. Measured against the 145,000 the farm used, the panels fed the farm directly 17 percent of its use. The other 20,000 went to the utility, and what the utility pays or credits for it depends on the local rule. Ask the utility whether it charges a minimum even to a customer who sends back more than they draw. Read the terms on your own bill before you count that energy as saved.
Whether the panels pay for themselves is a different calculation, with its own method in the article on payback, net present value and your rate. It needs this sheet’s total use as its input, and anyone who starts from a bill that hides the panels’ share ends with the wrong one.
What do I write first, and by when?
This week, download the last 12 monthly electric statements and the diesel invoices, and fill the first columns. Read two numbers from them: the biggest source in dollars and the biggest source in MMBtu. Where the two disagree, you have found the bill you were not watching. The Purdue example agrees on diesel for both, but look at the second place too: electricity is second in dollars and third in MMBtu, behind propane.
Next month, add the loads by kilowatts times hours and the panel columns. Then close each month: write the gap between what you expected and the numbers on the sheet, who looks into it and by when. Pick the date of the first close today, before you open the first statement. A gap that nobody owns and nobody dated stays open from one year to the next.
The same columns serve two other questions. The diesel gallons are the fuel figures that the farm’s carbon count multiplies by published factors. And when a lender or a buyer asks for energy numbers, the sheet has them; the article on whether a farm needs an ESG report covers what a lender checks besides. The sheet is one of the counts of running a farm business, and the sustainability library lists the neighboring ones.