• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

FIFO and Residual Amount

RaviSikaria

New Member
I have a simple excel, wherein, the the columns are: (A) item name, (B) quantity bought (positive value) or quantity sold (negative value) and (C) Price of the particular transaction is mentioned. Nearly 200 items are being considered. I want an excel program, which would provide me as output, the quantity of the individual items and price at which the inventory is there. This shall not take into consideration any profits/loss made earlier.

For eg, Let's say, item A was bought 10 times (total qty: 965) and sold for 5 times (total qty: 389). So the program shall give me the inventory available and the average price at which the balance inventory of 576 units was bought, without considering the profits/loss made in 389 quantity sold.

Request your help for the VBA solution.
 

Attachments

  • Book1.xlsm
    16.3 KB · Views: 2

RaviSikaria

Do Your Let's say have some connection with Your given sample data - below?
item A was bought 10 times (total qty: 965) and sold for 5 times (total qty: 389)
Screenshot 2025-02-18 at 14.58.44.png
Could You give expected valid output - based Your used data?
... or is it something like this (file)?
Where this should use FIFO?
You opened Your thread in Ask an Excel Question
... but later You wrote about VBA solution ... which one?
 

Attachments

  • Book1.xlsm
    18.1 KB · Views: 2
Back
Top