Quarry in excel

MD GULFAM (SR. ACCOUNTANT) (34 Points)

14 August 2019  

Pls. suggest me any formula in excel that can auto calculate the average Rate as per FIFO method from Purchase Rate, as sale Qty mentioned for reference I attached a excel sheet 

Pls  reply as soon as possible

Thanking you.