+ Reply to Thread
Results 1 to 1 of 1

Inventory Age Formula Needed for FIFO Inventory

  1. #1
    Registered User
    Join Date
    07-20-2012
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Inventory Age Formula Needed for FIFO Inventory

    I am looking for some insight as to how to go about building a formula that will allow me to age on hand balances. IE: Total on hand = 100 Purchase history by month: 2 in July, 6 in June, 50 in April, 50 in March. If aged the balance in March needs to be 2. Any assistance would be greatly appreciated.

    Sherie
    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)

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