Skip to Content
avatar image
Former Member

How to calculate moving average price(MAP) when price variance in IV

Hi All,

My current stock for a material is 39 and MAP is 0.8 GBP.

A purchase order is created for the material for a quantity of 1 at price of 0.8 GBP per unit.

Invoice is posted for the above PO at price of 1.74 GBP.

What will be the new MAP for the material now??How to calculate MAP when there is a price variance in Invoice?

Please suggest ASAP.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    May 03, 2010 at 11:38 AM

    Hi

    The MAP is calculated as (Total Value of Stock) divided by (Total Qty of Stock).

    In your case, your toal stk value before PO id 39 x 0.8 = 31.2 GBP.

    If new stock comes at the rate of 1 x 1.74 = 1.74

    So Now the total Qty is 40 and Total Stk value is 32.94 GBP. So, MAP is 32.94 / 40 = .824 GBP.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 03, 2010 at 11:43 AM

    Hi

    Total Value = 39 x 0.8 GBP = 31.2GBP

    At the time of GR =40 qty with total value 32 GBP (MAP 32/40=0.8 GBP)

    Stock Account Debit for 0.8 GBP

    GR/IR account Credit for 0.8 GBP

    At the time of IR ( Considering GI is not done for 40 nos) = Total Value for 40 nos =

    Vendor account credit 1.74 GBP

    GR/IR account Debit 0.8 GBP

    Stock account Debit ( 1.74 -0.8 = 0.94 ) GBP

    Hence total value for 40 nos 32+0.94 =32.94 GBP ( MAP 32.94/40 = 0.8235)

    If GI is done then instead of stock account it goes to price differance account for insufficient stock coverage

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 03, 2010 at 11:45 AM

    Hi,

    The Procedure for calculating MAP is :-

    Case 1 :- PO at different price

    If in Material Master your MAP is 0.8GBP & closing stock of 30Nos, value is 24GBP

    In PO if the price is 0.9GBP & qty is 10nos, then after Goods Receipt Total Value of the GR i.e. Qty * Price + any other delivery cost will be added to the material stock value. Qty is also updated. New Total Value / New Stock Qty will be MAP.

    In this case Qty received 10 & price is 0.9 that means value would be 9GBP.

    Total Value becomes 24GBP (Present Stock) + 9GBP (Goods Receipt) = 33GBP

    Total Qty becomes 30Nos + 10Nos (Goods Receipt) = 40Nos

    MAP becomes = 33GBP / 44Nos = 0.75

    Case 2 : Invoice Posting (MIRO) at different price than PO

    While doing MIRO is we post at different price system will check whether sufficient stock posted in GR is available. In the above case it is 10Nos,

    If it is there, then the above logic as in case 1 will take place

    If not available, to the extent of stock availability system will post the different value & adjust MAP & remaining is posted to Price Difference Account.

    In your case it would be like this :

    1. MAP 0.8 for 30Nos (Value would be 24GBP)

    2. Invoice Posting 1.74GBP for 1No. That means value would be 24GBP + 1.74GBP = 25.74GBP

    Qty would be 30+1 = 40

    MAP = 25.74 / 40 = 0.64GBP

    Hope this clarifies your doubt

    regards,

    JP

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 03, 2010 at 11:47 AM

    I think u are asking about the PRD at the time of LIV

    current status before LIV is 39 qty and MAP 0.8

    and u have all ready done a GR of 1 qty at 0.8

    not u are doing LIV for that PO with qty 1 and price 0.8

    and in LIV u r changing 0.8 to 1.74

    right if this is what u asking than th MAP will be calculated as

    (38 * 0.8) + (1*(1.74-0.8)) / 39

    will be 0.80359 according to calculation but only 2 places can be shown so MAP will be shown as 0.8

    take the bigger values u able to understand better

    hope this helsp

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 04, 2010 at 05:00 AM

    Hi,

    Goods Issue will always take place with the current MAP.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2010 at 11:25 AM

    Hi All.

    My queries with ref. to this Moving Price updation. Suppose One material is getting stock transfer to other plant. At both the plant the same material is with diff. Moving Avg. Price. i,e at Plant X, Stock Qty-Q1 and Stock Price is P1 So Inv. Value is = Q1xP1. And similarly at Plant Y, Stock Qty- Zero, but the moving Price is P2, So at Plant Y Inv. Value is Zero.

    Now when executed STK the Inv. A/c of Plant Y got Debited with (Q1xP1) value and simultaneously Plant X got credited with (Q1xP1) value. Now, in Plant Y, what will be the Price of material.

    Rgds,

    CS

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      My queries with ref. to this Moving Price updation. Suppose One material is getting stock transfer to other plant. At both the plant the same material is with diff. Moving Avg. Price. i,e at Plant X, Stock Qty-Q1 and Stock Price is P1 So Inv. Value is = Q1xP1. And similarly at Plant Y, Stock Qty- Zero, but the moving Price is P2, So at Plant Y Inv. Value is Zero.

      Now when executed STK the Inv. A/c of Plant Y got Debited with (Q1xP1) value and simultaneously Plant X got credited with (Q1xP1) value. Now, in Plant Y, what will be the Price of material.

      When you move the material to Plant Y, the stock value will be

      (Q2 X P2 ) + (Q1 X P1) / (Q1+Q2).

      But, since Q2 = 0, the Value will be P1. So, the MAP for the material in Plant Y will be same as Plant X.