Moving Average Unit Cost (MAUC)
The Moving Average Unit Cost (MAUC) is an inventory valuation method that is used for accounting purposes.
The MAUC is the average value for each unit of the current inventory. Inventory is valued against the average receipt price. For each new receipt, the MAUC is updated.
To calculate the inventory value for an item, the MAUC inventory valuation method uses all types of transactions, such as the following:
When goods are received resulting from a transaction, the receipt price is used to update the MAUC value.
The MAUC is calculated as follows:
(Existing inventory on hand * Existing MAUC) + (receipt quantity * transaction price)/(Existing inventory on hand + receipt quantity)
If the following transactions are carried out, the MAUC value is calculated as follows:
MAUC values require correction if they are based on incorrect transaction prices. For example, if an incorrect purchase price is used for a receipt of goods, the MAUC is updated against this incorrect purchase price. You can correct the transaction price by correcting the receipt price of the purchase order. The MAUC value will be adjusted as long as the goods received are still financially present in the warehouse. In addition to purchase transactions, other types of transactions can have an impact on inventory levels and therefore influence MAUC values. For these transactions too, wrong transaction prices can be entered, which result in wrong MAUC values.
If the MAUC value has become incorrect as a result of a few wrong transaction prices, MAUC correction is probably only required for a limited number of items. In the MAUC Correction by Item (whina1231m000) session, you can correct the MAUC value of an individual item. If a large number of items have wrong MAUC values due to, for example, system implementation failures, you can correct MAUC values for ranges of items in the MAUC Correction (whina1230m000) session.
When the corrected MAUC value is updated for an item, LN performs the following process: