Average Cost/Unit

Good Morning dear all master excel, I am a beginner in using excel application.

Please help to determine the average cost / unit in the data
sales, sales returns and purchase returns with excel formulas. If I analyze the data determine the unit average cost / unit with manual way it will spend time. and also if data consists of several items and also a lot of transactions then it will be difficult for me.

An excel file sample is attached to this message. I'm sorry if I've disturbed the activities of master2 excel in this group. Please solve my problem with urgent.

Date Code Type Qty Out Cost/Unit Out (Average Cost/Unit)
03 Mar 2018 A Sales Invoice 4.00 10,000.00 (WITH FORMULA)
03 Mar 2018 A Sales Invoice 5.00 9,583.33 (WITH FORMULA)
05 Mar 2018 A Sales Invoice 3.00 8,263.89 (WITH FORMULA)
06 Mar 2018 A Sales Return -1.00 8,263.89 (WITH FORMULA)
07 Mar 2018 A Sales Invoice 7.00 8,398.81 (WITH FORMULA)
18.0
Date Code Type Qty In Cost/Unit In
03 Mar 2018 A Purchase Invoice 5.00 10,000.00
03 Mar 2018 A Purchase Invoice 5.00 9,500.00
05 Mar 2018 A Purchase Invoice 5.00 8,000.00
06 Mar 2018 A Purchase Return -1.00 8,263.89 (WITH FORMULA)
06 Mar 2018 A Purchase Invoice 4.00 8,500.00
18.00

Thank you

Kana

Doc3jpg_Page1.jpg

I can not attachment,Please see my screenshot.

Thank you

Dear Mr. Glenn Kennedy



this is my excel file attachment


Thank You

Kana

Originally Posted by Glenn Kennedy

What results do you expect to see (please supply manually calculated results)?

Where do you want the results to be?

The result with marking yellow in file excel my attachments. Thanks

Dear Mr. Glenn kennedy,


Please solve my problem.


Thanks


Kana

Dear Mr. Glenn kennedy,

Sorry if I have made you confused with the excel attachment from me.

Herewith I attach the excel file as per your request.

Once I apologize and please respond as soon as possible. Thank you.


Regards


Kana