how can I calculate the percentage


I have been trying to search how to calculate the best percentage of wastage that its acceptable, and still get high Sale values by using the old data to calculate
I have attached file.

example of the answer.

at 25% of wastage QTY is acceptable.