FIFO Formula in Excel Sheet for Inventory Valuation

Attached herewith Inventory valuation done in FIFO in excel sheet.

BALANCE
Sl.No. Qty. Rates Rs. QTY Rs.
1 0 6 0 TOTAL Balance 250 1875
2 0 7 0
3 0 8 0
4 250 7.5 1875
5 0 0 0
6 0 0 0
7 0 0 0
8 0 0 0
9 0 0 0
10 0 0 0
11 0 0 0
12 0 0 0
13 0 0 0
14 0 0 0
15 0 0 0
16 0 0 0
17 0 0 0
18 0 0 0
19 0 0 0
20 0 0 0

 

Click Here To Download FIFO in Excel Sheets