+ Reply to Thread
Results 1 to 3 of 3

Trying to create a calculation for days in inventory

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    Atl, Ga
    MS-Off Ver
    2013
    Posts
    6

    Trying to create a calculation for days in inventory

    I have multiple products with days until next shipment, inventory, and the start of a formula but I'm stuck. I don't know what to do to subtract the outbound inventory from a FIFO standpoint and keep my days in inventory calculation correct. Any advice is appreciated!
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    02-09-2015
    Location
    Atl, Ga
    MS-Off Ver
    2013
    Posts
    6

    Re: Trying to create a calculation for days in inventory

    To best summarize where I'm at I have written some nested IF functions

    The first one is if I have more inventory since the last load (meaning that my inventory today is greater than the last date of inventory) Then I add the last number of days in inventory to the new number of days.

    The next portion is if inventory remains the same. Then I add the number of days since the last shipment and the cumulative days in inventory so far.

    The next portion is if inventory drops to zero. Then we no longer have any days in inventory so it is 0 automatically.

    The last portion is what I am struggling with. I need the new portion of inbound inventory to subtract from the oldest amount of inventory and then subtract the number of days the oldest was in inventory from my number of days in inventory.

    best example is below

    Widget 1 10 days 25 widgets 10 total days in inventory
    Widget 1 5 days 30 widgets 15 total days in inventory
    Widget 1 20 days 10 widgets 35 total days in inventory
    Widget 1 5 days -15 widgets 40 days in inventory
    Widget 1 5 days -40 widgets 30 days in inventory

    The italics part are what my formula cannot return correctly.

  3. #3
    Registered User
    Join Date
    02-09-2015
    Location
    Atl, Ga
    MS-Off Ver
    2013
    Posts
    6

    Re: Trying to create a calculation for days in inventory

    Accidental Double Post.

+ 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 Days Supply
    By sheikhmisbah in forum Excel General
    Replies: 4
    Last Post: 12-05-2013, 01:37 AM
  2. Inventory Days supply - SAP SNP
    By sheikhmisbah in forum Excel General
    Replies: 1
    Last Post: 12-05-2013, 12:20 AM
  3. [SOLVED] Inventory expires, Now, 30, 60, 90, 90+ days
    By Aeneren in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2012, 10:06 AM
  4. [SOLVED] Please Help With Days Elapsed And Days Remaining Calculation
    By Scoooter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-14-2006, 12:15 PM

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