ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Month and YearOctNovDecJan--18Feb--18Mar--18Apr--18May--18Jun--18Jul--18Aug--18Sep--18Oct--18Nov--18Dec--18
2
3
Collections$224,982.01$210,262.55$204,384.93$293,834.78$235,781.74$255,758.00$292,782.57$301,672.79$242,858.39$258,268.46$281,334.12$234,733$313,315.00$263,374.00
4
5
Dental Supplies: (Best out there 2.9%, Amazing 3.5%, Great 4%, Good 4.5%)
6
Vendor$6,748.6$10,184.9$5,000.6$8,997.2$10,832.2$8,293.6$6,738.2$6,935.1$7,194.9$6,233.9
7
Vendor$295.8$1,747.2$2,516.6$1,857.5$958.2$1,227.1$1,553.7$774.5$1,266.6
8
Vendor$0.0$615.0$0.0$0.0
9
Vendor$249.2$538.8$798.8$886.4$0.0$0.0$0.0
10
Vendor$24.9$267.0$0.0
11
Vendor$200.0$382.3$382.3$541.9$371.2
12
Vendor$176.2$202.2$0.0$0.0
13
Vendor$248.5$641.1$210.0$1,013.1
14
Vendor$274.0$596.0$388.3$669.8
15
Vendor$264.0
16
Vendor$248.4$205.4$393.4$386.8$338.3$377.6$121.0
17
Vendor$80.6$106.4$73.8$120.1$99.6$64.2
18
Vendor$21.4$42.0$32.4
19
Vendor$436.0$436.0$879.0
20
Vendor$0.0
21
Vendor$473.1
22
Vendor-$157.5
23
Vendor$351.9
24
Vendor$70.6
25
Total$7,552.5$11,835.1$8,523.2$13,292.8$13,798.9$11,046.3$14,348.0$9,755.4$11,122.9$8,884.7$11,438.6$12,355.0$0.0$0.0$0.0
26
% of Collections3.4%5.6%4.2%4.5%5.9%4.3%4.9%3.2%4.6%3.4%4.1%5.3%0.0%0.0%#DIV/0!
27
Target4.5%4.5%4.5%4.5%4.5%4.5%4.5%4.5%4.5%4.5%4.5%4.5%4.5%4.5%4.5%
28
Beat Benchmark?1.1%-1.1%0.3%0.0%-1.4%0.2%-0.4%1.3%-0.1%1.1%0.4%-0.8%4.5%4.5%#DIV/0!
29
30
3mo Rolling Average4.4%4.7%4.9%4.9%5.0%4.1%4.2%3.7%4.0%4.2%2.9%1.5%0.0%
31
Beat Benchmark?0.1%-0.2%-0.4%-0.4%-0.5%0.4%0.3%0.8%0.5%0.3%1.6%3.0%4.5%
32
Bonus$71.14$204.70$135.35$65.68$511.07
33
34
35
36
37
Lab Fees: (Best out there 2.9%, Amazing 3%, Great 3.5%, Good 4%)
38
Vendor$3,000.00$2,273.00$2,079.00$3,500.00$2,108.00$2,527.00$2,989.00$4,105.00
39
Vendor$2,000.00$4,452.60$6,332.25$3,413.00$4,134.00$2,614.00$2,517.00$6,088.00$3,024.00$4,153.00
40
Vendor$500.00$3,251.33$377.65$1,412.25$177.00$1,410.00$642.50$467.95$2,246.30$1,713.00
41
Vendor$110.00$528.00$444.00$264.00$264.00$1,426.00
42
Vendor$327.96$0.00$0.00
43
Vendor$2,450.00$2,450.00$0.00$0.001100$2,360.00
44
Vendor$254.00$0.00
45
Vendor
46
Vendor$82.00
47
Vendor$3,756.00$2,945.00
48
Total$5,500.00$9,976.93$9,226.86$11,303.25$8,869.00$6,995.00$6,412.50$6,819.95$15,739.30$11,171.00$0.00$0.00$0.00$0.00$0.00
49
% of Collections2.4%4.7%4.5%3.8%3.8%2.7%2.2%2.3%6.5%4.3%0.0%0.0%0.0%0.0%#DIV/0!
50
Target4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%4.0%
51
Over/Under Budget1.6%-0.7%-0.5%0.2%0.2%1.3%1.8%1.7%-2.5%-0.3%4.0%4.0%4.0%4.0%#DIV/0!
52
3mo Average3.9%4.3%4.0%3.5%2.8%2.4%3.5%4.2%3.4%1.4%0.0%0.0%0.0%
53
6mo Average3.6%3.5%3.1%3.5%3.5%2.9%2.5%2.1%1.7%0.8%
54
55
56
Implants/Ortho
57
Vendor$1,778$12,070$2,695$1,048$1,048$1,048$1,048$1,048$1,048
58
Vendor$480$100$0$0$0$0$0$0
59
Vendor$0$0$0$0$0$0$0
60
Vendor$6$6$6$6$6$6
61
Vendor$0$0$0$0$0$0
62
Vendor$297$0$0$0$0$0$0
63
Vendor$0$243$243$243$243$243$243
64
Vendor$136$136$136$136$136$136
65
Total$0.00$0.00$1,778.00$0.00$0.00$777.32$0.00$12,170.45$2,695.00$1,432.94$1,432.94$1,432.94$1,432.94$1,432.94$1,432.94
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100