Hello,

I want to make a workbook to help reducing the amount of primary ressource needed, and I am a bit lost on where to start...

Let's say I have three types of Ores, A, B, and C, than can each be reprocessed into different materials k, l, and m; with different amount as follow:
A = 200k + 100l + 150m
B = 500k + 200l + 500m
C = 300k + 110l + 300m

Now, what I want to do is to input a goal as the amount of materials I need, and the worksheet to display the least amount of Ore needed.
Let's say I need 3 000k, 4 000l, and 5 000m:

xA + yB +zC > 3000k + 4000l + 5000m

And I want to minimize x+y+z, which will indicate the least amount of Ore I need to gather to reprocess into the materials I need.

Any help will be appreciated! I'm sure there's a way to do this on excel, but I've never done similar task before.
Many thanks!