+ Reply to Thread
Results 1 to 3 of 3

Aged Inventory Calculation

  1. #1
    Registered User
    Join Date
    07-16-2014
    Location
    Auckland
    MS-Off Ver
    2013
    Posts
    2

    Aged Inventory Calculation

    I am trying to break current stock on hand into ageing buckets based on transactional data. The monthly ageing buckets I am after are 0-3, 4-6, 7-9,10-12, 12+.

    As an example I may have 10000 units on hand with 5000 in the 0-3Month bracket, 3000 in the 4-6Month bracket and 2000 in the 7-9Month Bracket.

    Unfortunatly our system doesnt tag inventory with an age so I need to be able to count back in incoming/outgoing transactions to place into correct buckets. Thoughts are to put a tranasactional age against each date and then use some form of IF formula withen each of the aged bucket cells to placed the inventory value.

    I have attached a basic sheet showing the type of data I have, along with what what I am trying to achieve.

    Stephen
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Excel 2016 (work) and 2013 (home)
    Posts
    1,164

    Re: Aged Inventory Calculation

    Would something like this work?
    Aged Stock Workings.xlsx
    Please add reputation by clicking on the * if I have helped.
    Please mark the thread SOLVED if your issue has been resolved.
    Thanks, Glenn.

  3. #3
    Registered User
    Join Date
    07-16-2014
    Location
    Auckland
    MS-Off Ver
    2013
    Posts
    2

    Re: Aged Inventory Calculation

    Issue Solved, Thanks Gak

+ 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. HELP - Inventory Calculation Formula
    By cbuxtonasks in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2014, 05:08 PM
  2. Inventory Profit Calculation
    By 1337 Ninja in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-04-2013, 01:10 AM
  3. [SOLVED] FIFO Method Inventory Calculation
    By pakhare.kiran in forum Excel Programming / VBA / Macros
    Replies: 31
    Last Post: 10-10-2012, 01:13 PM
  4. [SOLVED] Inventory calculation with partial matches
    By G-Force in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-13-2012, 02:43 PM
  5. Excel 2007 : Inventory calculation
    By lifeisboost in forum Excel General
    Replies: 5
    Last Post: 09-06-2010, 02:58 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