Results 1 to 2 of 2

Product vs. demand analysis

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2016
    Location
    SLovakia
    MS-Off Ver
    2010
    Posts
    17

    Product vs. demand analysis

    Hello,

    Hope you're well.

    I have a long list of products which expire in a certain month in the future. These products might repeat themselves as the expiration date of the same product might be in different months in the future. If the same product has several expiration months it has it's own row in excel. I also have a list of product demand which inform of the quantities to be consumed in each month in the future. When I do a vlookup of demand to the product list I have, the same demand quantity for the same products appear even if the product expires in a different month. This is not true as the demand volumes are duplicated for the same products and does not take into consideration the already consumed quantity in prior months. How to make a formula or a pivot table in excel which would inform of any leftovers of products as there will not be enough demand to consume it up to the product’s expiration month while taking into consideration the already covered demand by product quantity in prior expiration months of the same products listed in a different row?

    Please find attached an example.


    Thank you for your time and consideration.

    Michal
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Volume and Mix Analysis by Customer and Product
    By Pratikm05 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-28-2023, 09:20 AM
  2. [SOLVED] How do I calculate my clothes dryer demand based on if my electric range has a demand
    By HaloMike in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-23-2021, 07:31 PM
  3. Product Mix Analysis
    By pookyman in forum Excel General
    Replies: 1
    Last Post: 03-14-2015, 07:47 PM
  4. Formula For Labor Supply/Demand Analysis
    By jlamot5 in forum Excel General
    Replies: 0
    Last Post: 08-18-2014, 02:54 PM
  5. 2-column key for supply and demand analysis
    By K8tb in forum Excel General
    Replies: 2
    Last Post: 11-12-2013, 10:30 AM
  6. Excel Projections - Demand Analysis
    By karlcr9911 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-04-2013, 01:32 PM
  7. Replies: 1
    Last Post: 10-18-2005, 01:05 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