HPMPL EPO
Pricing playground
Volume-adjusted commission and engineering rebate. Change the equation constants and compare twenty order values at once. All rows recalculate from the live formulas, not from rounded display values.
| # | Manufacturing order | Eligible prior engineering | Commission rate | HPMPL commission | Rebate rate | Max engineering rebate | Applied rebate | Net commission after rebate | Total before rebate | Effective total after eligible rebate |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 5.50% | $275.00 | 0.00% | $0.00 | $0.00 | $275.00 | $5,275.00 | $5,275.00 | ||
| 2 | 4.80% | $359.67 | 5.08% | $18.26 | $18.26 | $341.42 | $7,859.67 | $7,841.42 | ||
| 3 | 4.35% | $435.13 | 8.68% | $37.75 | $37.75 | $397.37 | $10,435.13 | $10,397.37 | ||
| 4 | 3.79% | $569.10 | 13.75% | $78.26 | $78.26 | $490.83 | $15,569.10 | $15,490.83 | ||
| 5 | 3.44% | $688.49 | 17.35% | $119.48 | $119.48 | $569.01 | $20,688.49 | $20,569.01 | ||
| 6 | 3.00% | $900.47 | 22.43% | $201.97 | $201.97 | $698.50 | $30,900.47 | $30,698.50 | ||
| 7 | 2.72% | $1,089.38 | 26.03% | $283.57 | $283.57 | $805.81 | $41,089.38 | $40,805.81 | ||
| 8 | 2.53% | $1,262.79 | 28.82% | $363.98 | $363.98 | $898.82 | $51,262.79 | $50,898.82 | ||
| 9 | 2.37% | $1,424.79 | 31.11% | $443.19 | $443.19 | $981.60 | $61,424.79 | $60,981.60 | ||
| 10 | 2.20% | $1,651.60 | 33.90% | $559.87 | $559.87 | $1,091.73 | $76,651.60 | $76,091.73 | ||
| 11 | 2.07% | $1,863.47 | 36.18% | $674.23 | $674.23 | $1,189.25 | $91,863.47 | $91,189.25 | ||
| 12 | 2.00% | $1,998.09 | 37.50% | $749.28 | $749.28 | $1,248.80 | $101,998.09 | $101,248.80 | ||
| 13 | 1.92% | $2,880.79 | 37.50% | $1,080.30 | $1,080.30 | $1,800.50 | $152,880.79 | $151,800.50 | ||
| 14 | 1.87% | $3,732.13 | 37.50% | $1,399.55 | $1,399.55 | $2,332.58 | $203,732.13 | $202,332.58 | ||
| 15 | 1.82% | $4,562.22 | 37.50% | $1,710.83 | $1,710.83 | $2,851.39 | $254,562.22 | $252,851.39 | ||
| 16 | 1.76% | $6,175.77 | 37.50% | $2,315.91 | $2,315.91 | $3,859.86 | $356,175.77 | $353,859.86 | ||
| 17 | 1.70% | $8,513.40 | 37.50% | $3,192.52 | $3,192.52 | $5,320.87 | $508,513.40 | $505,320.87 | ||
| 18 | 1.64% | $12,262.67 | 37.50% | $4,598.50 | $4,598.50 | $7,664.17 | $762,262.67 | $757,664.17 | ||
| 19 | 1.59% | $15,886.56 | 37.50% | $5,957.46 | $5,957.46 | $9,929.10 | $1,015,886.56 | $1,009,929.10 | ||
| 20 | 1.48% | $29,645.38 | 37.50% | $11,117.02 | $11,117.02 | $18,528.36 | $2,029,645.38 | $2,018,528.36 |