The below table columns are separated by ' | '.

﻿﻿Component | Required | UOM | Cost | Amount
124532 | 4 | PCS | .24 | .48
3324532 | 2 | PCS | 1.4 | 2.8
424532 | 1 | PCS | 2 | 2

substitute the value of amount in column 'Amount' with format [amt:value of required x value of cost].
example ,  22222 | 1 | PCS | .24 | [amt: 1 x 0.24]