HI there,
1) Make sure you are solving the right case i.e. clarfy upfront. Confirm the real case ask is
a) How much water is needed to produce a cup “worth” of coffee?
b) Confirm if there are any boundaries to this analysis (e.g. process wise)
2) Potential approach
a) Agree with the process split up in 2-3 step maximum: a1) cultivation a2) treatment and fermeting b) brewing c) transporting, …
b) Let us first assess how much coffee is needed for one cup (e.g. 10g)
c) For each step let us imagine / describe the process + try to further narrow down on scope and variable impacting the water consumption (e.g. what type of production method - dry vs. wet, what type of geo we are talking about, is natural rainfall involved - should I count this in my sizing?, what type of soil, is this a concious producer saving water, ….)
d) Probe interviewer for typical benchmark “ratios": e.g. m3 water/ton for each process stage BUT only after having explained the logical variables as per above
e) painful alternative - only if 1 not successful. Let us use the right "scaling" and common sense - If I were to think about my backyard garden 1m x 1m - how much water would I pour in (e.g. litres over time) to make a plant grow there (e.g. along xx days I would water them x times every z days, …) and then try to assess how many coffee grams I can extract from this single m2 of backyard to obtain a m3 water/g ratio out of thinking
Bottom line
1) Segment process - probe for ratios; if not successful painful “common experience” bottom down proxies
Hope this helps