Water resources projects are very complex in nature, requires huge financial investment and requires to consider socioeconomic, political, environmental aspects apart from technical aspects. There are many techniques evolved over the years to solve complex water resource problems. Pimpalgaon Dhale medium irrigation project system is considered in this project is located in Barshi taluka of Solapur district. It is planned to irrigate an ICA of 2400 ha of 6 villages namely Pimpalgaon, Pangaon, Yawali, Sakat, Undegaon and Irle. Dam is completed in 2008 however distribution system is still incomplete. The system is optimized to calculate maximize net benefit from the crops subjected to various constraints (viz. water availability, land availability, male and female labour availability, capital availability etc,). Single objective linear programming model is formulated and constraints are written and solver program of MS excel is used to derive maximum net benefit from the irrigation system under consideration. Benefit Cost ratio is calculated and compared it with that calculated adopting conventional methodology. The data required for model formulation is adopted from various sources such as Government reports/ documents, reports available on websites, research papers etc. The constraints such as capital availability within irrigation system during kharif and rabi season, female labour hours availability during kharif and rabi season limits the area under crops as well as net benefits however there is substantial increase in area under irrigation and net benefits from the irrigation system. The Solver program of MS Excel is very useful and convenient to use for solving linear programming. Keywords: Water Resource Projects, Maximize net benefit, Benefit Cost Ratio, Linear programming.,