This study was aimed at developing an optimization approach to rainwater harvesting (RWH) considering three (3) water consumption scenarios (WCS). These scenarios which include basic water need (BWN), pour flush (PF) and full plumbing connection (FPC) corresponding to 50 litres per capita per day (lpcd), 75(lpcd) and 150(lpcd) respectively were simulated for different categories of buildings. Reliability of supply was determined by first obtaining composite surplus/deficit of rainwater followed by optimizing the redistribution of surplus rainwater harvested to deficient buildings. Results showed that when total annual rainfall intercepted by roof exceeded total demand, 100% reliability of water supply was guaranteed. Reliability was found to be a linear function of storage. When reliability of supply is possible, the optimized storage bears an inverse exponential relationship to the roof plan area per capita. The relationship between surplus/deficit and roof plan area per capita follows a one-phase decay pattern. An optimal redistribution of surplus water from self-sufficient buildings to deficient ones gave an improvement in supply reliability from 64 to 87% for basic water need, 47 to 58% for pour flush and 28 to 29% for full plumbing connection.