Time Series Analysis to Estimate the Volume of Drinking Water Consumption in the City of Meoqui, Chihuahua, Mexico

Abstract

Water is a vital resource for sustaining life and for numerous processes within the transformation industry. It is a finite resource, albeit one that can be renewed, and thus sustainable management is imperative. To achieve this objective, it is necessary to have the appropriate tools to assist with the planning policies for its management. This paper presents a time series analysis approach to measure and predict the pattern of water consumption by humans throughout subsectors (domestic, commercial, public sector, education, industry, and raw water) and total water consumption in Meoqui, Chihuahua, Mexico with data from 2011 to 2023, applying calibration model techniques to measure uncertainty in the forecasting. The municipality of Meoqui encompasses an area of 342 km2. The climate is semi-arid, with an average annual rainfall of 272 mm and average temperatures of 26.4 °C in summer and 9.7 °C in winter. The municipal seat, which has a population of 23,140, is supplied with water from ten wells, with an average consumption of 20 ± 579 m3 per user. The consumption of the general population indicates the existence of a seasonal autoregressive integrated moving average (SARIMA) (0,1,2)(0,0,2)12 model. (Sen’s Slope = 682.7, p < 0.001). The domestic sector exhibited the highest overall consumption, with a total volume of 17,169,009 m3 (13 ± 93). A SARIMA (2,1,0)(2,0,0)12 model was estimated, with a Sen’s slope of 221.65 and a p-value of less than 0.001. The second-largest consumer of total water was the “raw water” sector, which consumed 5,124,795 (30,146 ± 35,841) m3 and exhibited an SARIMA (0,1,1)(2,0,0)12 model with no statistically significant trend. The resulting models will facilitate the company’s ability to define water resource management strategies in a sustainable manner, in alignment with projected consumption trends.