Components Inventory Sheet

[auroraivy]

Hello,

I am trying to make an Excel sheet that will calculate how many items I can make from my components inventory. For instance, say I need 1 of each: Part A, B & C to make Item 1. I have the below inventory. I want to know what formula or setup I can use to have excel calculate how many Items I can create from the components I have on hand.

Inventory Example:

Part A - 5000
Part B - 2000
Part C - 1000

 

[sheetspread]

Just min(range) = 1000 in this example

 

[auroraivy]

Thank you. I was obviously over thinking this.