Monthly Breakpoint Reached: Example
The monthly breakpoint reached is a cumulative calculation method. As sales amounts are reported, the calculation includes prior periods that are cumulative up to the reporting year. Billing is not created until the annual breakpoint amount is reached during one of the billing periods. If the annual breakpoint amount is reached during one of the billing periods, the amounts will be billed based on that percentage.
Breakpoint Check Example
- Calculation method: Non-natural Breakpoint
- Frequency: Monthly After Breakpoint Reached
- Breakpoint amount = 500,000.00
- Percent Rate = 5%
| January 2020 | 35,001.00 | ||
| February 2020 | 44,158.46 | ||
| March 2020 | 42,892.00 | ||
| April 2020 | 45,110.00 | ||
| May 2020 | 75,381.37 | ||
| June 2020 | 70,431.90 | ||
| July 2020 | 55,007.91 | ||
| August 2020 | 80,091.34 | ||
| September 2020 | 62,000.00 | ||
| January 2020 - September 2020 Sales | 510,073.98 | ||
| Less Breakpoint | 500,000.00 | ||
| Excess Sales | 10,073.98 | ||
| x percent rate | 5% | ||
| Percent Rent Billed Sept | 503.70 | ||
| Oct 2020 | 44,504.44 | ||
| January 2020 - October 2020 Sales | 554,578.42 | ||
| Less Breakpoint | 500,000.00 | ||
| Excess Sales | 54,578.42 | ||
| x percent rate | 5% | ||
| Percent Rent Due | 2,728.92 | ||
| Less Amount Billed | 503.70 | ||
| Percent Rent Billed Oct | 2,225.22 | ||
| November 2020 | 45,077.86 | ||
| January 2020 - November 2020 Sales | 599,656.28 | ||
| Less Breakpoint | 500,000.00 | ||
| Excess Sales | 99,656.28 | ||
| x percent rate | 5% | ||
| Percent Rent Due | 4,982.81 | ||
| Less Amount Billed | 2,728.92 | ||
| Percent Rent Billed Nov | 2,253.89 | ||
| December 2020 | 139,315.70 | ||
| Total 2020 Sales | 738,971.98 | ||
| Less Breakpoint | 500,000.00 | ||
| Excess Sales | 238,971.98 | ||
| x percent rate | 5% | ||
| Percent Rent Due | 11,948.60 | ||
| Less Amount Billed | 4,982.81 | ||
| Additional Percent Rent due | 6,965.79 | ||
