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
Hello !
Thanks for the file. Can you please kindly tell me the password as I want to view the columns, which have been hidden to view the formula.
Thanks, keep up the great work.