USA LIFO average cost formula question

Sep 12, 2022
Reaction score
United States
hello, newbie here, hopefully this is an easy question. I am trying to calculate an average price of products for my company. These are essentially drop ship products, not products we have in inventory. So I have the unit price, quantity, and order date. I'm trying to calculate an average price for the month, where the orders that were more recently purchased are weighted more heavily than the orders from the beginning of the month.

I've looked at other LIFO and average cost formulas but they don't seem appropriate to use because they're using inventory counts that I don't have.

Any help to point me in the right direction is appreciated, thanks!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question