Closed Thread
Results 1 to 5 of 5

Inventory Days Supply

  1. #1
    Registered User
    Join Date
    01-24-2009
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    13

    Inventory Days Supply

    Hi Guys,

    I am looking the formula, how to calculate days’ supply.
    In SAP APO is calculating the days' supply but how, i dont know.
    Here is an example :


    inventory days supply.JPG


    Ending Inventory 100 205 436
    Formula : Open Inventory +Total Dist Receipts-Total Demand-Aged Loss
    Days´ Supply
    Formula : ??????? ? ? ?


    I would like to know how to calculate days’ supply (using formula)

    This is little bit urgent. Your quick response would be really appreciated.

    Thank you in advance.

    Misbah

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Inventory Days Supply

    Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    01-24-2009
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Inventory Days Supply

    Thanks for your advise.

    The files has been just uploaded as per your request.

    Misbah

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Inventory Days Supply

    Hi, sheikhmisbah,

    please do not start a new thread on the very same topic.

    http://www.excelforum.com/excel-gene...y-sap-snp.html

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  5. #5
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Inventory Days Supply

    Thanks Holger.

    Thread closed.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Inventory Supply Sheet
    By Fish10800 in forum Excel General
    Replies: 14
    Last Post: 08-17-2011, 05:48 PM
  2. I need a template for my supply inventory
    By kmatthews in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-07-2005, 03:05 PM
  3. [SOLVED] I need a template for my supply inventory
    By kmatthews in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 11:05 PM
  4. I need a template for my supply inventory
    By kmatthews in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 PM
  5. [SOLVED] I need a template for my supply inventory
    By kmatthews in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 09:05 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