Spreadsheet: 876152d1722846252-need-formula-for-tier-incentive-calculation-calculation-doing-formula
Sheet: Summary

 | Doctor | Department | Min. Target | Revenue | Consumables | Rent | Staff [NAME] | Other Exp | Lab / Hopsital | OR Charges | Clinics Fee | Clinics Fee | Bonus | Other Benefits | Comm.
1 | Dr. [NAME] | Dermatology |  | 1401980 | 345937.95 | 16350
2 | Dr. [NAME] | Dermatology |  | 223615
3 | Dr. [NAME] | Dermatology | 160000 | 367470
4 | Dr. [NAME] | Plastic Surgery
5 | Dr. [NAME] | Plastic Surgery | 50000
6 | Dr. [NAME] | Dental | 45000 | 58180.5 |  |  |  |  | 950 |  | 0.05
7 | Dr. [NAME] | Dental |  | 117266.2 |  |  |  |  |  |  | 0.05
8 | Dr. [NAME] | Dental |  |  |  |  |  |  |  | 6000 | 0.05
9 | Dr. [NAME] | Dental |  | 73530 |  |  |  |  | 4300 |  | 0.05
10 | Dr. [NAME] | Dental |  |  |  |  |  |  |  |  | 0.05 |  |  | 1200 | 0
11 | [NAME] solh | Nutrition | 27000
12 | Physio - Female | Physio |  |  |  |  |  |  |  |  |  |  |  |  | 0
13 | [NAME] | Wellness
14 | Solarium | Others |  |  |  |  |  |  |  |  |  |  |  |  | 0
15 | Dr. [NAME] | Dental |  |  |  |  |  |  |  |  | 0.05
16 | Laser | Laser | 430000 | 188055.48 |  |  |  |  |  |  |  |  |  |  | 0
17 | Others | OThers |  |  |  |  |  |  |  |  |  |  |  |  | 0
18 | Dr. [NAME] | ENT |  |  |  |  |  |  | 2500
19 | Dr [NAME] | Dermatology | 250000
20 | Dr. [NAME] | Plastic Surgery |  |  |  |  |  |  |  |  |  |  |  |  | 172003
21 | Dr. [NAME] | [NAME] |  |  |  |  |  |  |  |  | 0.05
22 | [NAME] | Physio |  |  |  |  |  |  |  |  |  |  |  |  | 0
23 | Dr. [NAME] | Plastic Surgery
24 | [NAME] | Plastic Surgery
25 | Dr. [NAME] | Plastic Surgery |  |  |  |  |  |  |  |  |  |  |  |  | 0
26 | Dr. [NAME] | OBS/GYN |  |  |  |  |  |  |  | 16500
27 | Dr. [NAME] | [NAME] |  |  |  |  |  |  |  |  | 0.05
28 | [NAME] |  |  | 143068 | 20669.17
29 | Dr. [NAME] | OBS/GYN |  |  |  |  |  |  |  |  |  |  |  |  | 0
30 | The Clinic |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
31 | Dr. [NAME] | Dental
32 | Dr. [NAME] | Dental |  |  |  |  |  |  | 2999
33 | Dr. [NAME] - Pedo Dentist | Dental |  |  |  |  |  |  |  |  |  |  |  |  | 0
34 | Dr. [NAME] | UROLOGY |  |  |  |  |  |  |  |  |  |  |  |  | 3000
35 | Dr. [NAME] | OBS/GYN |  |  |  |  |  |  |  |  |  |  |  |  | 11984.55 | 11484.5
36 | Dr. [NAME] | GB |  |  |  |  |  |  |  |  |  |  |  |  | 0
37 | Dr. [NAME] |  |  |  |  |  |  |  |  |  | 0.05 | 7163
38 | Dr. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
39 | Sp. [NAME]
40 | Dr. [NAME] AbdelKareem
41 | Dr. [NAME] | Plastic Surgery
42 | Dr. [NAME] | Plastic Surgery
43 | Dr. [NAME]
44 | Dr. [NAME] | Plastic Surgery
45 | Dr. [NAME] | Plastic Surgery
46 | Dr. [NAME] | Plastic Surgery |  |  | 8990.63
47 | Dr. [NAME] | Plastic Surgery
48 | Dr. [NAME] | Dental
49 | Dr. Nidhal Ayoub
50 | [NAME] |  | 0 | 96400 | 20974.57
51 | Bador Alzayed | Nutrition
52 | Dr. [NAME]
53 | Dental Xray
54 | Lab Tests
55 | Ultera Machine Services
56 | Garments
57 | Dr. [NAME]
58 | Dr. [NAME]
59 | Dr. [NAME] | Dental |  | 35200 |  |  |  |  | 350 |  | 0
60 | Dr. [NAME]
61 | Dr. [NAME] |  | 18000 | 78202.52 |  |  |  |  | 1750
62 | Dr. [NAME] |  |  | 98152.17 | 44408.37
 | Dr. [NAME]
63 | Dr. [NAME] |  |  | 79159.3 | 27238.09
 | Total
 |  |  |  | 1820877.33
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1188906