Hello Guys,
Could someone please give me some assistance on the below?
I have been trying to figure out how I can count how many Assemblies can be built from the current stock levels of its sub-components.
For Example:
Column A: Sub Component Names
Column B: Amount Required per Assembly.
Column C: Amount currently in stock.
Column D1: Return how many assemblies can be built from the current stock levels of its sub-components?
Assembly Breakdown (components required):
Component A: Required Qty (1) - Stock Qty (10)
Component B: Required Qty (2) - Stock Qty (15)
Component C: Required Qty (1) - Stock Qty (25)
Given this example, I should be able to make 7 assemblies as I don't have enough of component B to build more.
Any help on a formula for this would be much appreciated!
Thanks,
- Grady
Bookmarks