Multiple linear regression modelling of on-farm direct water and electricity consumption on pasture based dairy farms

Abstract

An analysis into the impact of milk production, stock numbers, infrastructural equipment, managerial procedures and environmental conditions on dairy farm electricity and water consumption using multiple linear regression (MLR) modelling was carried out. Electricity and water consumption data were attained through the utilisation of a remote monitoring system installed on a study sample of 58 pasture-based, Irish commercial dairy farms between 2014 and 2016. In total, 15 and 20 dairy farm variables were analysed on their ability to predict monthly electricity and water consumption, respectively. The subsets of variables that had the greatest prediction accuracy on unseen electricity and water consumption data were selected by applying a univariate variable selection technique, all subsets regression and 10-fold cross validation. Overall, electricity consumption was more accurately predicted than water consumption with relative prediction error values of 26% and 49% for electricity and water, respectively. Milk production and the total number of dairy cows had the largest impact on electricity consumption while milk production, automatic parlour washing and whether winter building troughs were reported to be leaking had the largest impact on water consumption. A standardised regression analysis found that utilising ground water for pre-cooling milk increased electricity consumption by 0.11 standard deviations, while increasing water consumption by 0.06 standard deviations when recycled in an open loop system. Milk production had a large influence on model overprediction with large negative correlations of −0.90 and −0.82 between milk production and mean percentage error for electricity and water prediction, respectively. This suggested that overprediction was inflated when milk production was low and vice versa. Governing bodies, farmers and/or policy makers may use the developed MLR models to calculate the impact of Irish dairy farming on natural resources or as decision support tools to calculate potential impacts of on-farm mitigation practises.