Update MAUC values - examples

Initial situation (no inventory present)

Item Warehouse Warehouse Valuation Group Valuation Method By Warehouse Valuation Group
A W1 G1 MAUC Yes
A W2 G1 MAUC Yes
A W3 G1 MAUC No
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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 10 10*
A W2 0 0*
A W3 0 0
A G1 10 10

Transaction #2

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

Results:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 10 10*
A W2 10 12*
A W3 0 0
A G1 20 11

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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 10 10*
A W2 10 12*
A W3 10 14
A G1 20 11

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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 5 10*
A W2 10 12*
A W3 10 14
A G1 15 11

Transaction #5

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

Results:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 12.67*
A W2 10 12*
A W3 10 14
A G1 25 12.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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 12.67*
A W2 10 12*
A W3 5 14
A G1 25 12.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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 12.67*
A W2 10 12*
A W3 5 14*
A G1 30 12.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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 12.67*
A W2 10 12.5
A W3 5 14*
A G1 20 12.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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 13.17*
A W2 10 14
A W3 5 16.5*
A G1 20 13.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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 13.83*
A W2 10 14
A W3 5 16.5*
A G1 20 14

Transaction #11

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

Results after issue:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 13.83*
A W2 10 14
A W3 3 16.5*
A G1 18 14

Results after receipt:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 17 13.85*
A W2 10 14
A W3 3 16.5*
A G1 20 14

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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 13.85*
A W2 10 14
A W3 3 16.5*
A G1 18 14

Results after receipt:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 13.85*
A W2 10 14
A W3 5 16.3*
A G1 20 14.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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 13.85*
A W2 10 14
A W3 3 16.3*
A G1 18 14.2

Results after receipt:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 13.85*
A W2 12 14.02
A W3 3 16.3*
A G1 18 14.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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 15 13.85*
A W2 12 14.02
A W3 -7 16.3*
A G1 8 14.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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 5 13.85*
A W2 12 14.02
A W3 -7 16.3*
A G1 -2 13

Transaction #16

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

Results:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 6 14.04*
A W2 12 14.02
A W3 -7 16.3*
A G1 -1 13
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:

Item Warehouse Quantity MAUC (by Warehouse)
A W1 6 14.04*
A W2 12 14.02
A W3 3 16*
A G1 9 16
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.