Model-based workflows for optimal long-term reservoir mangement