In the GameInfo folder of the Sins directory or whatever expansion you play. Do not change that file directory, just copy it. Then go to your mod folder and make a new folder called "Fleet Supply Mod". In that folder make a folder called "GameInfo" and paste the gameplay.constants file in there and open that one in notepad.
While there are tons of gameplay data stored in that file, what you're looking for is this section.
fleetSupplyData-Small
fleetSupplyScalar 0.75
fleetSupplyData-Normal
fleetSupplyScalar 1.0
fleetSupplyData-Large
fleetSupplyScalar 1.25
Basically those numbers are what the default fleet supply numbers (base max 2000) gets multiplied by depending on your fleet size setting. So if you were to change those numbers to 2.0, 3.0, and 4.0, for small fleet supply setting you'd start at 200 supply and your max fleet supply would be 4000. Normal would have a max of 6000, large 8000 etc. You can of course set the numbers as high as you like, but eventually you'll hit a limit to what your computer will be able to handle.
Further, I advise that the Devs add custom map sharing to Sins of a Solar Empire: Rebellion.