Water Usage Costs Optimization in SAS

  • Tech Stack: Time Series Analysis with Arima, SAS: PROC OPTMODEL
  • Github URL: Project Link

Forecast the water usage of the following next 4 weeks using the over a year and a half of historical weekly gallon usage data from a building. Use forecasts results as parameters in an optimization model to find the optimal combination of water to purchase from water company and to use from rainfall precipitation with 3 business constraints.