+ Reply to Thread
Results 1 to 3 of 3

Count How Many Assemblies I Can Make From Current Components In stock?

  1. #1
    Registered User
    Join Date
    12-07-2020
    Location
    Birmingham, England
    MS-Off Ver
    2016
    Posts
    2

    Count How Many Assemblies I Can Make From Current Components In stock?

    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

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Count How Many Assemblies I Can Make From Current Components In stock?

    Wouldn't it be:
    1) Add a column to compute =INT(stock qty/required qty)
    2) The final result is =MIN(helper column).

    If I've understood correctly, that's how I would do it.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    12-07-2020
    Location
    Birmingham, England
    MS-Off Ver
    2016
    Posts
    2

    Re: Count How Many Assemblies I Can Make From Current Components In stock?

    Quote Originally Posted by MrShorty View Post
    Wouldn't it be:
    1) Add a column to compute =INT(stock qty/required qty)
    2) The final result is =MIN(helper column).

    If I've understood correctly, that's how I would do it.
    Thank you so much!

    Excel isn't my strongest skill.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 02-21-2019, 11:19 AM
  2. Replies: 4
    Last Post: 11-19-2018, 10:48 PM
  3. Creating an Indented BoM from Two Columns of Assemblies/Sub-Assemblies
    By Deyeski in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-11-2017, 12:15 PM
  4. [SOLVED] numbering components within assemblies
    By taylorcharley in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-26-2015, 10:01 AM
  5. Identify the earliest expiry date on stock based on current stock levels
    By julie86xx in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-10-2013, 01:08 AM
  6. Replies: 4
    Last Post: 01-29-2013, 02:26 AM
  7. Replies: 0
    Last Post: 10-28-2012, 07:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1