...
So for this example we have the following items with cost:
| Item ID | Amount |
|---|---|
| ROGGVIN-SAMPLER | 24.85 |
| ROGGN-2.1OZ-EA | 6.95 |
| ROGGNP-2.2OZ-EAU | 4.95 |
The subtotal for the order was 36.75 and there were subtotal discounts of 7.95. So if we look at the % allocations it would be:
| Item ID | Math | Percentage |
|---|---|---|
| ROGGVIN-SAMPLER | 24.85 / 36.75 | 67.62% |
| ROGGN-2.1OZ-EA | 6.95 / 36.75 | 18.91% |
| ROGGNP-2.2OZ-EAU | 4.95 / 36.75 | 13.47% |
Taking those allocation percentages we have the following subtotal discount portions:
| Item ID | Math | Portion of Subtotal Discount |
|---|---|---|
| ROGGVIN-SAMPLER | 7.95 * 67.62% | 5.37 |
| ROGGN-2.1OZ-EA | 7.95 * 18.91% | 1.50 |
| ROGGNP-2.2OZ-EAU | 7.95 * 13.47% | 1.07 |
Subtracting the portion of the subtotal discount from the original item unit prices we get
| Item ID | Math | Effective Unit Price |
|---|---|---|
| ROGGVIN-SAMPLER | 24.85 - 5.37 | 19.48 |
| ROGGN-2.1OZ-EA | 6.95 - 1.50 | 5.45 |
| ROGGNP-2.2OZ-EAU | 4.95 - 1.07 | 3.88 |