Wow, that seems like an awful lot. But okay;
100 (gallons) * 4 (people) * (2 weeks = 14 days) * 0.0314913957935 (tons/gal) =
176.4 tons of fuel.
How much fuel does a type S hold? I don't think a purification plant can fit on a type S, so how is waste water recycled?
Much of that USGS isn't actually used by the person directly, but in various societal uses.
Keep in mind that a person consumes between 1/4 and 2 gal. per day in fluids, and about the same within their food; inversely related, for an aggregate of about 1-1.5 gal per day; more in hot, less in cool.
If they take a 5m shower with a standard modern shower head, that's 10 gal.
Flush the toilet 3 times a day - another 7.5-10 gal (depending upon toilet and efficiency of flush. Each handwash is 1-5 gallons. Run a load of laundry or dishes - 5 to 25 gal, depending on hardware and settings.
Water your 1/8 acre lawn to 0.1" of water: about 200 gal.
Wash the car: 10+ gal if careful; 100+ if not.
One can get humans by on 3-4 gal/day with careful rationing and no dishwashing... in zero G.
A 1m diameter 1m tall cylinder tank is about tank is 750L (or some 180+ gal)... if rationed well (dry urinal, waterless flush toilets, laser "washing" of plates), that's plenty for a week. But it will contribute to the "interesting smells."
Personal reasonable use, including water-flush toilets at 8L/flush, limited rinse water for handwashing, etc, one can get 15 days on 750L... 12 gal a day, for comparison.
comfortable is going to be twice that. Still, small enough to fit in the drop-ceiling of the stateroom... Another 2 such tanks for wastewater. You havent even gotten to 1/2 Td....