Something like this. There are other parts calculating the requirements.
| -1 | req. | 100 | 100 | 50 |
| 3 | milk | 2.92| 4.37| 3.5|
| # | |-91.2|-86.8|-39.5|
#+TBLFM: @>$3..$5=(@<$1..@>>$1)*(@<..@>>)