Spreadsheet: 771761d1646835477-calculate-value-if-certain-conditions-met-stylist-bonuses-2019-working-v2-help-file-2
Sheet: DATA

Stylist Bonus Levels
Bonus Items | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable
New Returns | 0.3 | 0.15 | 0.3 | 0.15 | 0.325 | 0.15 | 0.3 | 0.15 | 0.4 | 0.15 | 0.4 | 0.15 | 0.4 | 0.15 | 0.3 | 0.15 | 0.3 | 0.15 | 0.3 | 0.15 | 0.4 | 0.15 | 0.3 | 0.15 | 0.3 | 0.15 | 0.3 | 0.15 | 0.4 | 0.15 | 0.4 | 0.15 | 0.4 | 0.15 | 0.4 | 0.15 | 0.4 | 0.15 | 0.4 | 0.15
New Returns | 0.34 | 0.3 | 0.34 | 0.3 | 0.375 | 0.3 | 0.34 | 0.3 | 0.45 | 0.3 | 0.45 | 0.3 | 0.45 | 0.3 | 0.34 | 0.3 | 0.34 | 0.3 | 0.34 | 0.3 | 0.45 | 0.3 | 0.34 | 0.3 | 0.34 | 0.3 | 0.34 | 0.3 | 0.45 | 0.3 | 0.45 | 0.3 | 0.45 | 0.3 | 0.45 | 0.3 | 0.45 | 0.3 | 0.45 | 0.3
New Returns | 0.38 | 0.45 | 0.38 | 0.45 | 0.425 | 0.45 | 0.38 | 0.45 | 0.5 | 0.45 | 0.5 | 0.45 | 0.5 | 0.45 | 0.38 | 0.45 | 0.38 | 0.45 | 0.38 | 0.45 | 0.5 | 0.45 | 0.38 | 0.45 | 0.38 | 0.45 | 0.38 | 0.45 | 0.5 | 0.45 | 0.5 | 0.45 | 0.5 | 0.45 | 0.5 | 0.45 | 0.5 | 0.45 | 0.5 | 0.45
New Returns | 0.42 | 0.6 | 0.42 | 0.6 | 0.375 | 0.6 | 0.42 | 0.6 | 0.55 | 0.6 | 0.55 | 0.6 | 0.55 | 0.6 | 0.42 | 0.6 | 0.42 | 0.6 | 0.42 | 0.6 | 0.55 | 0.6 | 0.42 | 0.6 | 0.42 | 0.6 | 0.42 | 0.6 | 0.55 | 0.6 | 0.55 | 0.6 | 0.55 | 0.6 | 0.55 | 0.6 | 0.55 | 0.6 | 0.55 | 0.6
Repeat Returns | 0.78 | 0.075 | 0.78 | 0.075 | 0.77 | 0.075 | 0.78 | 0.075 | 0.75 | 0.075 | 0.75 | 0.075 | 0.75 | 0.075 | 0.78 | 0.075 | 0.78 | 0.075 | 0.78 | 0.075 | 0.75 | 0.075 | 0.78 | 0.075 | 0.78 | 0.075 | 0.78 | 0.075 | 0.75 | 0.075 | 0.75 | 0.075 | 0.75 | 0.075 | 0.75 | 0.075 | 0.75 | 0.075 | 0.75 | 0.075
Repeat Returns | 0.82 | 0.15 | 0.82 | 0.15 | 0.8 | 0.15 | 0.82 | 0.15 | 0.79 | 0.15 | 0.79 | 0.15 | 0.79 | 0.15 | 0.82 | 0.15 | 0.82 | 0.15 | 0.82 | 0.15 | 0.79 | 0.15 | 0.82 | 0.15 | 0.82 | 0.15 | 0.82 | 0.15 | 0.79 | 0.15 | 0.79 | 0.15 | 0.79 | 0.15 | 0.79 | 0.15 | 0.79 | 0.15 | 0.79 | 0.15
Productivity | 33 | 0.15 | 28 | 0.15 | 28 | 0.15 | 24 | 0.15 | 28 | 0.15 | 28 | 0.15 | 28 | 0.15 | 30 | 0.15 | 28 | 0.15 | 30 | 0.15 | 32 | 0.15 | 28 | 0.15 | 32 | 0.15 | 32 | 0.15 | 30 | 0.15 | 32 | 0.15 | 28 | 0.15 | 28 | 0.15 | 28 | 0.15 | 28 | 0.15
Productivity | 38 | 0.3 | 33 | 0.3 | 32 | 0.3 | 28 | 0.3 | 32 | 0.3 | 32 | 0.3 | 32 | 0.3 | 35 | 0.3 | 33 | 0.3 | 35 | 0.3 | 37 | 0.3 | 33 | 0.3 | 37 | 0.3 | 37 | 0.3 | 35 | 0.3 | 37 | 0.3 | 32 | 0.3 | 32 | 0.3 | 32 | 0.3 | 32 | 0.3
Product Sales | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1 | 0.05 | 0.1
Product Sales | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
[NAME] | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0 | 300 | 0
Adjustments
Salon Grade Average | A | 5
Salon Grade Average | B | 0
Salon Grade Average | C | -5
Salon Grade Average | D | -10
Salon Grade Average | F | -20
Call-Ins | 0 | -15
Late 15+ Minutes | 0 | -10
Manager [NAME]
 | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable | Threshold | Payable
New Returns | 0.3 | 30 | 0.3 | 30 | 0.325 | 30 | 0.3 | 30 | 0.4 | 40 | 0.4 | 40 | 0.4 | 40 | 0.3 | 30 | 0.3 | 30 | 0.3 | 30 | 0.4 | 40 | 0.3 | 30 | 0.3 | 30 | 0.3 | 30 | 0.4 | 40 | 0.4 | 40 | 0.4 | 40 | 0.4 | 40 | 0.4 | 40 | 0.4 | 40
New Returns | 0.34 | 60 | 0.34 | 60 | 0.375 | 60 | 0.34 | 60 | 0.45 | 60 | 0.45 | 60 | 0.45 | 60 | 0.34 | 60 | 0.34 | 60 | 0.34 | 60 | 0.45 | 60 | 0.34 | 60 | 0.34 | 60 | 0.34 | 60 | 0.45 | 60 | 0.45 | 60 | 0.45 | 60 | 0.45 | 60 | 0.45 | 60 | 0.45 | 60
Repeat Returns | 0.78 | 20 | 0.77 | 20 | 0.75 | 20 | 0.77 | 20 | 0.75 | 40 | 0.75 | 40 | 0.75 | 40 | 0.77 | 20 | 0.77 | 20 | 0.77 | 20 | 0.75 | 40 | 0.77 | 20 | 0.77 | 20 | 0.77 | 20 | 0.75 | 40 | 0.75 | 40 | 0.75 | 40 | 0.75 | 40 | 0.75 | 40 | 0.75 | 40
Repeat Returns | 0.8 | 40 | 0.8 | 40 | 0.8 | 40 | 0.8 | 40 | 0.8 | 60 | 0.8 | 60 | 0.8 | 60 | 0.8 | 40 | 0.8 | 40 | 0.8 | 40 | 0.8 | 60 | 0.8 | 40 | 0.8 | 40 | 0.8 | 40 | 0.8 | 60 | 0.8 | 60 | 0.8 | 60 | 0.8 | 60 | 0.8 | 60 | 0.8 | 60
Database Capture | 0.9 | 20 | 0.9 | 20 | 0.9 | 20 | 0.9 | 20 | 0.9 | 40 | 0.9 | 40 | 0.9 | 40 | 0.9 | 20 | 0.9 | 20 | 0.9 | 20 | 0.9 | 40 | 0.9 | 20 | 0.9 | 20 | 0.9 | 20 | 0.9 | 40 | 0.9 | 40 | 0.9 | 40 | 0.9 | 40 | 0.9 | 40 | 0.9 | 40
Database Capture | 0.95 | 40 | 0.95 | 40 | 0.95 | 40 | 0.95 | 40 | 0.95 | 60 | 0.95 | 60 | 0.95 | 60 | 0.95 | 40 | 0.95 | 40 | 0.95 | 40 | 0.95 | 60 | 0.95 | 40 | 0.95 | 40 | 0.95 | 40 | 0.95 | 60 | 0.95 | 60 | 0.95 | 60 | 0.95 | 60 | 0.95 | 60 | 0.95 | 60
Payroll (without training) | 0.34 | 50 | 0.36 | 50 | 0.38 | 50 | 0.5 | 50 | 0.36 | 60 | 0.38 | 60 | 0.45 | 60 | 0.34 | 50 | 0.38 | 50 | 0.36 | 50 | 0.5 | 60 | 0.38 | 50 | 0.34 | 50 | 0.34 | 50 | 0.5 | 60 | 0.5 | 60 | 0.5 | 60 | 0.5 | 60 | 0.5 | 60 | 0.5 | 60
Payroll (without training) | 0.38 | 30 | 0.4 | 30 | 0.42 | 30 | 0.55 | 30 | 0.4 | 40 | 0.42 | 40 | 0.5 | 40 | 0.38 | 30 | 0.42 | 30 | 0.4 | 30 | 0.6 | 40 | 0.42 | 30 | 0.38 | 30 | 0.38 | 30 | 0.6 | 40 | 0.6 | 40 | 0.6 | 40 | 0.6 | 40 | 0.6 | 40 | 0.6 | 40
Sales Growth | 0.04 | 25 | 0.04 | 25 | 0.1 | 25 | 0.2 | 25 | 0.25 | 0 | 0.25 | 0 | 0.25 | 0 | 0.04 | 25 | 0.04 | 25 | 0.04 | 25 | 0.25 | 0 | 0.04 | 25 | 0.04 | 25 | 0.04 | 25 | 0.25 | 0 | 0.25 | 0 | 0.25 | 0 | 0.25 | 0 | 0.25 | 0 | 0.25 | 0
Sales Growth | 0.07 | 30 | 0.07 | 30 | 0.15 | 30 | 0.25 | 30 | 0.3 | 0 | 0.3 | 0 | 0.3 | 0 | 0.07 | 30 | 0.07 | 30 | 0.07 | 30 | 0.3 | 0 | 0.07 | 30 | 0.07 | 30 | 0.07 | 30 | 0.3 | 0 | 0.3 | 0 | 0.3 | 0 | 0.3 | 0 | 0.3 | 0 | 0.3 | 0
Sales Growth | 0.1 | 35 | 0.1 | 35 | 0.2 | 35 | 0.3 | 35 | 0.35 | 0 | 0.35 | 0 | 0.35 | 0 | 0.1 | 35 | 0.1 | 35 | 0.1 | 35 | 0.35 | 0 | 0.1 | 35 | 0.1 | 35 | 0.1 | 35 | 0.35 | 0 | 0.35 | 0 | 0.35 | 0 | 0.35 | 0 | 0.35 | 0 | 0.35 | 0
Sales Growth | 0.13 | 40 | 0.13 | 40 | 0.25 | 40 | 0.35 | 40 | 0.4 | 0 | 0.4 | 0 | 0.4 | 0 | 0.13 | 40 | 0.13 | 40 | 0.13 | 40 | 0.4 | 0 | 0.13 | 40 | 0.13 | 40 | 0.13 | 40 | 0.4 | 0 | 0.4 | 0 | 0.4 | 0 | 0.4 | 0 | 0.4 | 0 | 0.4 | 0
Sales Growth | 0.16 | 45 | 0.16 | 45 | 0.3 | 45 | 0.4 | 45 | 0.45 | 0 | 0.45 | 0 | 0.45 | 0 | 0.16 | 45 | 0.16 | 45 | 0.16 | 45 | 0.45 | 0 | 0.16 | 45 | 0.16 | 45 | 0.16 | 45 | 0.45 | 0 | 0.45 | 0 | 0.45 | 0 | 0.45 | 0 | 0.45 | 0 | 0.45 | 0
Sales Growth | 0.19 | 50 | 0.19 | 50 | 0.35 | 50 | 0.45 | 50 | 0.5 | 0 | 0.5 | 0 | 0.5 | 0 | 0.19 | 50 | 0.19 | 50 | 0.19 | 50 | 0.5 | 0 | 0.19 | 50 | 0.19 | 50 | 0.19 | 50 | 0.5 | 0 | 0.5 | 0 | 0.5 | 0 | 0.5 | 0 | 0.5 | 0 | 0.5 | 0
Product Sales (5% minimum) | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01 | 0.05 | 0.01
[NAME] | 1500 | 0 | 1500 | 0.025 | 1500 | 0 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025 | 1500 | 0.025
Adjustments
Salon Grade Average | A | 25
Salon Grade Average | B | 0
Salon Grade Average | C | -25
Salon Grade Average | D | -50
Salon Grade Average | F | -100
Call-Ins | 0 | -15
Late 15+ Minutes | 0 | -10
Product Sales Director Bonus Levels
Product Sales |  |  | 0.05 | 0.025
Product Class
Yes
No