tiered

I'm trying to find out if there is a formula to calculate the monthly billing fee based on the below table. I receive monthly reports from a customer. The below table shows the billing rate per product at each threshold level. Below the table is an example of how it is supposed to be...

Hi, I was wondering if someone could help me with this. I have a tiered commissions structure as follows: 0-100% attainment (Total payout of 100% of eligible %) 100-125% (total payout of 1.5% of eligible %) 125%+ (total payout of 2.5% of eligible %) accelerated commission rate not to exceed 15%...

I am trying to set up a formula where it looks at a cell and decides if there is enough funds to transfer ..if not pull more from another place. Only transfer enough of what is needed. See example .. if you look at line #1 there is $874K is available I want to transfer up to the amount I...

I need to compute a table, but I am not sure on how to write the formula. For example, Sales price: 10Mil For first 1mil the tiered rate is 1% The next 1 mil the tiered rate is 0.8% The next 3 mil the tiered rate is 0.7% The next 3 mil the tiered rate is 0.6% Thereafter the tiered rate is...

Hello. I need help with a tiered commission formula that would pay commissions back to dollar one as the rep reached new tiers. For instance, for sales up to $1,000,000 they get a 3.5% commission. Once they hit $1,000,001, the commissions are 6.00%, and they get paid on the first 1,000,000 an...

Hi board members I am trying to create a formula whereby if I enter a user number in a reference cell, 100 for example, Excel uses the below tiered pricing to calculate a monthly fee. 100 users should return a result of £13,340.00 9 @ £150 15 @ £150 50 @ £135 26 @ £115 User Tier 1-9...

Hello, I am attempting to write a formula for distributed/cumulative tiered pricing and am not able to get the formula correctly. 1 - 30 units = $90/unit 31 - 60 units = $75/unit 61 - 100 units = $60/unit More than 100 units = $55/unit Examples of expected calculations are: 55 Units...

Hello, I took a look at the tiered payout problems posted but I could not apply same solution as my problems differs as below: <tbody> Annual New client (no: of clients) Payout in $ per client 0-40 50 41-60 100 61-90 200 91+ 250 </tbody> In my problem, I have something called...

Hi, I am fairly proficient with VBA, but have stumped myself. I have hundreds of columns (transactions/amounts) with hundreds of rows of data (names). I need to get my column data into a loadable format, which I am capable of doing. The part that is stumping me is adding a grouping line with...

Hi I am trying to create a 3-tier dependant dropdown list system Dropdown 1 = Supplier (Many of) Dropdown 2 = Material Type (Approx 20 of, but not all suppliers supply all materials) Dropdown 3 - Material grade (Many of but Unique to supplier/material combo - eg Material grade ABC123 is...

I have found out, thanks to you wonderful people, how to use SumProduct formulas. Now I have a new question. What would be the best way to use the sumproduct formula for tiered pricing, if you have several different sets of tiers. For instance what if you have 5 customers and each of them has...

Hi Everyone, I have what has been a tricky problem for me. I have seen several posts on tiered pricing, which have been very helpful for calculating a basic tiered price system. But here's my situation: Items stored are on a tiered basis. If an item has been at a location for 0-15 days, its...