Anbuselvam K
Member
Dear All
Find the attached workbook having the sheets of RM Consumption and RM Purchase. RM's are RM1 to RM51
In RM Consumption sheet I have RM Price and RM quantity, Whenever the RM Price changes I have highlighted by yellow colour.
I need the price in RM Purchase sheet, next to the purchase qty.
Example
RM Consumption Sheet
RM 1 consumed of 337687.93kg(Cell C6) with the price of 1.55 (Cell B2: B6) then up to 2203144.55kg(Cell C21) consumed with the price of 1.47(Cell B7: B21)
Expected Results
RM Purchase Sheet
Cell C11 value to be 1.55
Cell C16 value to be 1.55
Cell C17 value to be 1.55
Cell C18 value to be 1.55
....
....
....
up to the purchased quantity reaches 337687.93kg's the price should fill with 1.55 then it should be 1.47 up to 2203144.55kg's...
Up to Cell B11 to B41 the quantity reach 344510, So in the cell B41 must take average of 1.55 and 1.47 (FIFO method price)
Likewise RM1 to RM51 prices I need in the RM Purchase sheet price columns.
Hope someone will help here.
Thanks in advance.
Find the attached workbook having the sheets of RM Consumption and RM Purchase. RM's are RM1 to RM51
In RM Consumption sheet I have RM Price and RM quantity, Whenever the RM Price changes I have highlighted by yellow colour.
I need the price in RM Purchase sheet, next to the purchase qty.
Example
RM Consumption Sheet
RM 1 consumed of 337687.93kg(Cell C6) with the price of 1.55 (Cell B2: B6) then up to 2203144.55kg(Cell C21) consumed with the price of 1.47(Cell B7: B21)
Expected Results
RM Purchase Sheet
Cell C11 value to be 1.55
Cell C16 value to be 1.55
Cell C17 value to be 1.55
Cell C18 value to be 1.55
....
....
....
up to the purchased quantity reaches 337687.93kg's the price should fill with 1.55 then it should be 1.47 up to 2203144.55kg's...
Up to Cell B11 to B41 the quantity reach 344510, So in the cell B41 must take average of 1.55 and 1.47 (FIFO method price)
Likewise RM1 to RM51 prices I need in the RM Purchase sheet price columns.
Hope someone will help here.
Thanks in advance.