Inventory Valuation on Weighted Average Cost

**pakhare.kiran** · 12-23-2013, 06:10 AM

Hello Friends,

Can anyone help me with this macros which can calculated Inventory on weighted Average Cost
Here I have attached an example sheet
I have added macros in which I can Calculate Inventory on FIFO Basis but I want cost at Average Cost
I have Excel Formula too which is calculating Average Cost but I want to add same in macros
Because this is just an example sheet but my actual data will have large lines, with excel formula it will go too heavy.

Thank you

**pakhare.kiran** · 12-23-2013, 07:28 AM

Please Friends Help me on it, this will save my lots of manual work, as well as it will reduce possibility of error

**pakhare.kiran** · 12-27-2013, 01:32 AM

Hey friends I have formula for Weighted average Method, all I want from you is just to Convert it into Macros for faster calculation for Accuracy

Please Friends it will be great help for me

**pakhare.kiran** · 12-30-2013, 04:18 AM

Friends Plz Help me,

I have Excel Formula in Example Sheet3, All I need is just to Convert It into Macros

**bsalv** · 12-30-2013, 09:12 AM

see attachment
i didn't look at your formula, just looking at all the entries in inward and outward for a combination "location+inventory" in chronologic order.