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!
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!