Add FIFO and other formulae to google sheet -- 2

Job ID: 30663895

Budget: $30 – $250 AUD

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. Price column will be deleted. https://docs.google.com/spreadsheets/d/1DpxFYtUoqNb7hu1rR_1UGFRCITZMxYmb4muyU5KSjlg/edit
Please bid fixed price.
Related categories: Google Sheets