Work with a product that loses about 10-15% of it’s original weight after being processed (the 10-15% is an unusable part of the product and is discarded). Anything above that percentage means that there’s a chance that actual useable product is being thrown out due to human error.
Would like to create a formula that calculates the amount (as weight) that is being mistakenly discarded, but only if the amount discarded is more than the expected 10-15%.