D
DMGCPA
How do I come up with a formula that looks at multiple in between numbers on
a grid for bonus purposes:
Net Sales to PLAN 94.00 100.00 102.00
104.00 105.00 108.00+
99.00 101.99
103.99 105.99 107.99
PACE to PLAN 96.99 99.99 40 % 50% 60% 70%
80% 90%
100.00 101.99 50 % 100% 110%
120% 130% 140%
102.00 103.99 60 % 110 % 130 %
140 % 150% 160%
104.00 105.99
106.00 107.99
108.00 109.99
110.00+
So that if Net Sales to Plan is 101.5 and PACE to Plan is 100.50 the result
is 100 % as an example
Thanks a million
David M.
a grid for bonus purposes:
Net Sales to PLAN 94.00 100.00 102.00
104.00 105.00 108.00+
99.00 101.99
103.99 105.99 107.99
PACE to PLAN 96.99 99.99 40 % 50% 60% 70%
80% 90%
100.00 101.99 50 % 100% 110%
120% 130% 140%
102.00 103.99 60 % 110 % 130 %
140 % 150% 160%
104.00 105.99
106.00 107.99
108.00 109.99
110.00+
So that if Net Sales to Plan is 101.5 and PACE to Plan is 100.50 the result
is 100 % as an example
Thanks a million
David M.