Percentage Fees are charged monthly on gross sales within an annual tiered system. If annual gross eceeds $2.5m the fee paid drops from 3% to 2.75% and so on to $7m. The fees are paid monthly. We want to track this on a cumulative approach. How do I set the formula up?

Your annual cumulative makes the monthly calculation more difficult. I assume there is also a fixed monthly rent plus cam. You will have to carry the gross sale monthly to avoid charging the higher rate,

Ask Your Question

Weekly Poll