Can i use linear programming on time series data?
I have a reservoir which has a certain capacity of water. I have a consumer of that water. The reservoir can be filled via 2 methods, rainfall or water pumped into it from mains water. The rainfall is free, the mains water costs me.

If i pump in mains water overnight it is cheaper than pumping it into the reservoir during the daytime.

I have forecasted data for water consumption and rainfall for each half hour of the day. My problem is, based on these forecasts what is the most cost effective method for meeting the needs of the user.