Agree 100% with the principles Orange has put forth. The only thing I might suggest is that in tblDisposedProduct, the DisposedPrice may not be the current price. It depends on your process. I'd consider the current price to be exactly that, while the price at disposal could be what you initially offered it for, which could be different. In fact, consider that there's an opportunity to capture both the cost to dispose and the lost profit. The lost profit would be the price at time of display times the units disposed. The disposal cost would be what you paid for the item (your cost) times the number of disposed units. From this, you could know the cost to dispose (for which you could include disposal cartage fees if you're paying by the ton) versus the loss of potential profit.
Last edited by Micron; 06-29-2017 at 12:13 PM.
Reason: grammar
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.