Average Cost/Unit

Dear Mr. FDibbins


file that is attached in my excel with in yellow color, I want the result of that value with excel formula


this is the average cost method.

Please help me


Thanks You



Kana

You probably need something like this...

This is fifo method, but I want average cost method

Dear Master Excel,



With this I attach my excel file that I have simplified so it makes it easy to understand it.


Please solve the problem as soon as possible and urgent (I mark it in yellow and there are words with formula)

Thanks you


Rgds


Kana

Hi Please check attachment.I am sure solve your problem

Dear Master excel,



Thanks the file you send but the average unit cost in / pcs & average unit cost out / pcs, the total value of stock result is not the same as my file.



Thanks you


Kana

Dear Master Excel,


I would like to thank the data sent to me

but still there is no match with this I attach a mismatch with the yellow marking

and there is a word signifying with the formula. Please help me urgently.


Thanks.


Rgrds


Kana

I apologize for the words that offend all the headmasters and I'm just brilliant who do not understand the problem of the formula excel. thank you

There is nothing (nor formulae) in the posted file so it is impossible to determine what is wrong.

The attached has the AVR solution I previously posted: you need to say what is wrong and why: in particular the UNIT COST column.

Dear Master Excel,


With this I attach the excel file data that I have modified from the previous file

I received before and here the problem I mark with the arrow so I want the formula

because the data using the formula manually it will make trouble if the code is around 100 or above 1000 code.

Sorry if there are words that I am less pleased in the hearts of all excel masters. Thank you very much.



Rgrds


Kana

Dear Master,


Herewith I attach an excel file that


there is an incomplete result problem with my answer is in the columns j and k and


the difference is marking me in red. Please Help me.


Thanks You


Kana

My results are in columns J and k and because the standard calculation is the average cost per pcs

You need to explain the logic to be applied for "Transfer In" and "Transfer Out" to Stock Quantity and Stock Values as it would appear that these cause the difference in values.

You value in J5 is Stock Value (R5) divided by 103 whereas the original calculation is Stock Value (r5) divided by Stock Quantity (Q5) of 101: the "Transfer Out" (F2 Quantity) is 2 : is this the reason for the difference.

Dear Mr. John Topley


I explain the incoming transfers are incoming transfer of stock from branch and

outgoing transfers are transfer out from from branch.

Average cost is made per branch so the stock will decrease or increase according to transactions transfer from the branch.

For ret sales, purchase, transfer in, transfer out transactions only in stock quantity but the average price still take

the average price of example I attach the excel file that I revised because the previous average value

I miscalculated for then for the code 01-2-01 from date 06-01-2018 up to 27-01-2018 then the average value of incoming cost

and the average cost per outgoing value per pcs is 53481.66272.

How is the formula for the transaction ret sales, ret purchase, transfer in and transfer out follow the average value.

Please Help me.

Thank you

Rgrds


kana

I have no idea how you get the result in J5.

The tab "AVR cost" calculates the first few entries as I understand the calculations.