Add FIFO and other formulae to google sheet

Job ID: 30642782

Budget: $30 – $250 USD

Need two formulas added to this spreadsheet on google sheets implementing FIFO cost base in a single formulae. No other columns to be added to help the formulae. Also require a formula to calculate the amount that has been held for over a year if any. https://docs.google.com/spreadsheets/d/1DpxFYtUoqNb7hu1rR_1UGFRCITZMxYmb4muyU5KSjlg/edit
Related categories: Accounting Excel Bookkeeping Google Sheets