Update MAUC values - examples

Initial situation (no inventory present)
ItemWarehouseWarehouse Valuation GroupValuation MethodBy Warehouse Valuation Group
AW1G1MAUCYes
AW2G1MAUCYes
AW3G1MAUCNo

 

Note

In the MAUC (by Warehouse) columns in the following tables, the values marked with an asterisk are shown for information purposes only, because valuation in the related warehouses is by By Warehouse Valuation Group.

Transaction #1

Receipt of 10 items A in W1 at 10 euros each.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11010*
AW200*
AW300
ItemWarehouse Valuation GroupQuantityMAUC
AG11010

 

Transaction #2

Receipt of 10 items A in W2 at 12 euros each.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11010*
AW21012*
AW300
ItemWarehouse Valuation GroupQuantityMAUC
AG12011

 

Transaction #3

Receipt of 10 items A in W3 at 14 euros each. No changes for MAUC by warehouse valuation group appear, because valuation in W3 is not By Warehouse Valuation Group.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11010*
AW21012*
AW31014
ItemWarehouse Valuation GroupQuantityMAUC
AG12011

 

Transaction #4

Issue of five items A from W1. Issue is made at 11 euros each, which is the MAUC for the warehouse valuation group.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW1510*
AW21012*
AW31014
ItemWarehouse Valuation GroupQuantityMAUC
AG11511

 

Transaction #5

Receipt of 10 items A in W1 at 14 euros each.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11512.67*
AW21012*
AW31014
ItemWarehouse Valuation GroupQuantityMAUC
AG12512.2

 

Transaction #6

Issue of five items A from W3. Issue is made at 14 euros each, which is the MAUC for the warehouse.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11512.67*
AW21012*
AW3514
ItemWarehouse Valuation GroupQuantityMAUC
AG12512.2

 

Transaction #7

Change valuation method for W3 from MAUC to By Warehouse Valuation Group. The new inventory value is chosen to be equal to the current inventory value.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11512.67*
AW21012*
AW3514*
ItemWarehouse Valuation GroupQuantityMAUC
AG13012.5**

 

**New MAUC is calculated as follows:
(25 * 12.2 + 5 * 14) / 30 = 12.5 

 

Transaction #8

Change valuation method for W2 from By Warehouse Valuation Group to MAUC. The new inventory value is chosen to be equal to the current inventory value. Therefore, MAUC in W2 becomes 12.5 as well.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11512.67*
AW21012.5
AW3514*
ItemWarehouse Valuation GroupQuantityMAUC
AG12012.5

 

Transaction #9

MAUC correction for all warehouses in warehouse valuation group G1. MAUC must be made equal to, for example, the current standard cost, which is 13 in W1 (no receipt surcharges), 14 in W2 (warehouse receipt surcharge of 1), and 15 in W3 (warehouse receipt surcharge of 2).

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11513.17*
AW21014
AW3516.5*
ItemWarehouse Valuation GroupQuantityMAUC
AG12013.5

 

Transaction #10

Invoice of the receipt of 10 items A in W1 (transaction #5) states 15 euros each, rather than 14 euros each. The total variance of 10 euros is assigned to inventory.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11513.83*
AW21014
AW3516.5*
ItemWarehouse Valuation GroupQuantityMAUC
AG12014

 

Transaction #11

Transfer of two items A from W3 to W1. MAUC by warehouse valuation group remains unchanged.

Results after issue:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11513.83*
AW21014
AW3316.5*
ItemWarehouse Valuation GroupQuantityMAUC
AG11814

 

Results after receipt:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11713.85*
AW21014
AW3316.5*
ItemWarehouse Valuation GroupQuantityMAUC
AG12014

 

Transaction #12

Transfer of two items A from W1 to W3. Upon receipt, MAUC by warehouse valuation group changes, because a receipt surcharge of 2 is defined in W3.

Results after issue:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11513.85*
AW21014
AW3316.5*
ItemWarehouse Valuation GroupQuantityMAUC
AG11814

 

Results after receipt:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11513.85*
AW21014
AW3516.3*
ItemWarehouse Valuation GroupQuantityMAUC
AG12014.2**

 

**New MAUC is calculated as follows:
(18 * 14 + 2 * 16) / 20 = 14.2

 

Transaction #13

Transfer of two items A from W3 to W2. This transaction will not affect MAUC by warehouse valuation group, because valuation in W2 is not By Warehouse Valuation Group.

Results after issue:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11513.85*
AW21014
AW3316.3*
ItemWarehouse Valuation GroupQuantityMAUC
AG11814.2

 

Results after receipt:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11513.85*
AW21214.02
AW3316.3*
ItemWarehouse Valuation GroupQuantityMAUC
AG11814.2**

 

Transaction #14

Issue of 10 items A from W3. Issue is made at 14.2 euros each, which is the MAUC for the warehouse valuation group, and because sufficient inventory is available in this warehouse valuation group, even though insufficient inventory exists in W3. For W3, a line for 7 items will be created in the Negative Inventory Consumptions (whina1520m000) session.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW11513.85*
AW21214.02
AW3-716.3*
ItemWarehouse Valuation GroupQuantityMAUC
AG1814.2

 

Transaction #15

Issue of 10 items A from W1. Issue is made at 14.2 euros (MAUC by warehouse valuation group) for eight items, and at 13 euros (standard cost in W1) for two items, because the inventory in the warehouse valuation group is insufficient, even though sufficient inventory exists in W1. For W1, no line is created in the Negative Inventory Consumptions (whina1520m000) session.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW1513.85*
AW21214.02
AW3-716.3*
ItemWarehouse Valuation GroupQuantityMAUC
AG1-213

 

Transaction #16

Receipt of one item A in W1 for 15 euros each.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW1614.04*
AW21214.02
AW3-716.3*
ItemWarehouse Valuation GroupQuantityMAUC
AG1-113

 

Note

A value correction of -2 is logged to correct the inventory value, because the received item of 15 euros was already issued for 13 euros.

Transaction #17

Receipt of 10 items A in W3 at 16 euros each.

Results:

ItemWarehouseQuantityMAUC (by Warehouse)
AW1614.04*
AW21214.02
AW3316*
ItemWarehouse Valuation GroupQuantityMAUC
AG1916

 

Note

A value correction of -3 is logged to correct the inventory value for the item that was left in negative inventory, because the item was already issued for 13 euros.

Related topics