Hi All,

I would like some help with this excel document I have created if possible. I have left comments in the attached spreadsheet on columns M, N and column AP. I would like to calculate a percentage of scrap material generated from 2 of the columns, and also calculate how much a price would need to be to hit a certain percentage.

I though this would be best explained in the spreadsheet. If somebody could please open this and let me know if they can help. Please ask if further information is required.

Thanks in advance.

Example.xls