Difference between Moving Average & Weighted Average

One of the customers i used to work with asked me about how Microsoft Dynamics NAV calculate the cost of the item “Average” Method, as he is working currently on another software that use the Moving average method.

As i know that Dynamics NAV using “Weighted Average” cost method to calculate the item cost. So i came across illustrating the difference between both the 2 methods, and how Microsoft Dynamics NAV calculate the Weighted Average costing method.

So i created this Whitepaper in Excel format using one sample data sample for the different 2 methods.

Hope you enjoy.