+ Reply to Thread
Results 1 to 3 of 3

Using up inventory codes for production

  1. #1
    Registered User
    Join Date
    04-18-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Using up inventory codes for production

    I have multiple product codes that need to be used up in production, but i need to use them up by batch first.
    So...

    Raw Material X all of same type (substitutable)
    Code QTY
    001 100
    002 300
    003 100
    004 500
    005 700 etc.

    WIP Usage of material X

    W1011 Uses 120 X, therefore needs 100 of Code 001 and 20 of code 002
    W1012 Uses 20 x, therefore needs 20 of code 002 since code 001 has been used
    W1013 Uses 300 X, therefore need balance of 002 (280) and 20 of 003...

    I need something that can compute this usage.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be anywhere in the world
    MS-Off Ver
    power BI
    Posts
    9,059

    Re: Using up inventory codes for production

    Attach a sample workbook. (Not a picture!)
    Make sure there is just enough data to demonstrate your need. Include a BEFORE (original) sheet and an AFTER (required output) sheet in the workbook if needed to show the process you're trying to complete or automate.
    Make sure your desired results are shown, mock them up manually if necessary. Remember, it should reflect original structure of your data.
    Remember to desensitize the data.
    Note:
    • Please do not attach password protected workbooks/worksheets
    • Please do not attach file(s) from exterior servers
    • Please do not attach file(s) with enabled any Workbook Open/Autorun macros!

    20 rows of data is enough (probably)

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If link is not from FORUM server you have to wait until someone will want to watch the file from an external server.

  3. #3
    Registered User
    Join Date
    04-18-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Using up inventory codes for production

    Please see attachment attached
    Attached Files Attached Files

+ 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. Inventory List Running with Bar Codes
    By ReidIT in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-10-2017, 11:17 PM
  2. Replies: 40
    Last Post: 11-30-2016, 01:14 AM
  3. SUMIFS + LOOKUP? Inventory management combined with production schedule
    By VladKyle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-11-2015, 02:16 PM
  4. Replies: 1
    Last Post: 06-01-2014, 09:02 PM
  5. Replies: 1
    Last Post: 10-28-2013, 11:34 AM
  6. Arrange inventory to codes
    By David6 in forum Excel General
    Replies: 5
    Last Post: 04-11-2013, 03:20 AM
  7. Production and Inventory adjustment??
    By zx7r in forum Excel General
    Replies: 4
    Last Post: 01-13-2012, 10:41 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