SEALS Sample Reports (Default Cost Values)

2c. Sample Reports.xlsx

[NCCDPHP] Sealant Efficiency Assessment for Locals and States (SEALS)

SEALS Sample Reports (Default Cost Values)

OMB: 0920-1289

Document [xlsx]
Download: xlsx | pdf

Overview

Cost Summary
Annual Performance Measures
Import SSP
Attack rate
Averted cavities
Retention Rate


Sheet 1: Cost Summary

State SSP Sample Cost Report: 2017-2018
ITEM UNITS AVERAGE COST PER UNIT TOTAL COST PER UNIT
Sealant Stations


Dentlworks 8 $664.96 $5,319.68
Aseptico 0 $664.97 $0.00
Other Manufacturers 0 $664.98 $0.00
TOTAL SEALANT STATIONS
$664.99 $0.00
Reusable Instruments
$664.10 $0.00
Instrument sets 180 $664.10 $119,538.18
Sterilization


Autoclave 1 $107.18 $107.18
Per year (ultrasonic cleaner, tray, utility gloves) 1 $99.86 $99.86
Per school event (spore testing kit) 307 $6.73 $2,066.11
Per day (sterilizer cleaner/ultrasonic cleaner solution) 900 $0.34 $306.00
Per child (instrument bag) 14523 $0.06 $871.38
TOTAL REUSABLE INSTRUMENTS

$122,988.71
Infection Control and Supplies


Per year (eyewash station, Sharps container, kits*) 1 $151.37 $151.37
Per station (waterline testing, protective eyewear and bib clip) 1 $57.75 $57.75
Per operator (protective eyewear) 1 $4.78 $4.78
Per day (trash liners, hand-sanitizer and hand soap) 900 $1.54 $472.78
Per day per station (waterline treatment, evacuation system treatment) 900 $5.10 $4,590.00
Per day per operator (protective clothing) 900 $2.78 $2,502.00
Supplies for screening 14523 $1.15 $16,701.45
Supplies for sealants (in addition to screening costs) 7858 $0.48 $3,771.84
Disposable instruments 0 $0.00 $0.00
Sealant material 35561 $0.00 $0.00
TOTAL INFECTION CONTROL & SUPPLIES

$28,251.97
Labor


Dentist


Travel 65.00 $109.94 $7,146.09
At school 722.30 $109.94 $79,409.66
Dental Hygienist


Travel 1052.20 $52.07 $54,788.40
At school 4926.40 $52.07 $256,517.83
Dental Assistant


Travel 681.20 $25.90 $17,643.08
At school 3306.90 $25.90 $85,648.71
Non-dental


Travel 526.30 $26.05 $13,710.13
At school 102.50 $26.05 $2,670.20
TOTAL LABOR

$517,534.10
TOTAL MILEAGE 78371 $0.54 $42,320.55
TOTAL ADMINISTRATIVE

$4,000
TOTAL PROGRAM COSTS

$715,095.33




Cost per child sealed

$91.00
Cost per tooth sealed

$20.11
Clinical labor time (hours) per child sealed

1.14
Clinical labor cost per child sealed

$53.65




Summary of services delivered


Number of children screened

14523
Number of children sealed

7858
Number of teeth sealed

35561
Number of fluoride varnish applications

14036
Number of prophylaxes

36




Summary of schools served


Number of high need schools

160
Number of rural schools

239




*Kits include blood borne pathogen spill, first aid, and chemical hazard



Sheet 2: Annual Performance Measures

Number of schools served by SSP

















High need, urban 6







High need, rural 2







Rural 2

















Effectiveness in targeting high-risk children that lack access to dental care
Response rate






Value






% with untreated decay (baseline) 35.4 99.8






% with treated or untreated decay (baseline) 54.0 99.8






% with sealants present (baseline) 25.0 99.8






% needing "Restorative Care" (baseline) 22.0 100.0






% needing "Urgent Care" (baseline) 15.0 99.8






One-year 1M attack rate without program/ based on # children 15.77% 784
















Number of services delivered








Children screened 1052







Children sealed 740







By age in years








5 0







6 3







7 298







8 198







9 50







10 116







11 62







12 11







13 2







14 0







15 0







16 0







17 0







18 0







Other/unknown 0







By grade








1st 1







2nd 509







3rd 29







4th 24







5th 176







6th 0







7th 0







Other/unknown 1







1st molars / 2nd molars / other teeth sealed 2332 179 50





Children referred for dental care 388

















Quality of services delivered and program impact








Sealant retention rate / based on # children 0.873 333






Percentage screened children with sealant after event 82.9







Percentage of targeted children subsequently screened 0.5







Percentage screened children subsequently sealed 70.3




Estimated cavaties averted over 9 years undiscounted / discounted 1225.99 1120.56






Estimated averted 9-year Medicaid treatment costs undiscounted / discounted $79,689.23 $72,836.58







Sheet 3: Import SSP

SSP output description Value Description SAS output description Value Description




Number of children screened 1052 Number of children screemed Number SSP, urban>50% FRL 6 urbanFRL




PosUntreat SUM 372 Number of children with untreated decay Number of SSP, rural>50%FRL 2 ruralFRL




UntreatReport SUM 1050 Number of children for whom Untreated Caries was answered validly Number of SSP, rural 2 rural




PosUrgent SUM 157 Number of children with Treatment Urgency = "Urgent Treatment"







PosRestCare SUM 231 Number of children with Treatment Urgency = "Restorative Care"







ReportUrgency SUM 1050 Number of children for whom Treatment Urgency was answered validly







PosTreated SUM
Number of children with treated decay







RepostTreated SUM
Number of children for whom Treated Caries was answered validly







PosCariesExp SUM 568 Number of children with treated or untreated caries







ReportCariesExp SUM 1052 Number of children for whom Caries Experience was answered validly







PosSeal SUM 263 Number of children with sealants present at baseline







ReportSeal SUM 1050 Number of children for whom Sealants Present was answered validly







ARDummy7 SUM 324 Number of children 7 years old with valid amount of 1M decay reported







ARDummy8 SUM 226 Number of children 8 years old with valid amount of 1M decay reported







ARDummy9 SUM 54 Number of children 9 years old with valid amount of 1M decay reported







ARDummy10 SUM 105 Number of children 10 years old with valid amount of 1M decay reported







ARDummy11 SUM 61 Number of children 11 years old with valid amount of 1M decay reported







ARDummy12 SUM 13 Number of children 12 years old with valid amount of 1M decay reported







ARDummy13 SUM 1 Number of children 13 years old with valid amount of 1M decay reported







NewDecay1M7 SUM 261 Decayed or filled 1M among 7 year olds







NewDecay1M8 SUM 225 Decayed or filled 1M among 8 year olds







NewDecay1M9 SUM 73 Decayed or filled 1M among 9 year olds







NewDecay1M10 SUM 176 Decayed or filled 1M among 10 year olds







NewDecay1M11 SUM 107 Decayed or filled 1M among 11 year olds







NewDecay1M12 SUM 24 Decayed or filled 1M among 12 year olds







NewDecay1M13 SUM 0 Decayed or filled 1M among 13 year olds







WereSealed SUM 740 Number of children sealed







SealPost SUM 872 Number of children with at least one sealant after the event







FirstSealed SUM 2332 Number of first molars sealed







SecondSealed SUM 179 Number of second molars sealed







OSealed SUM 50 Number of other teeth sealed







CheckRetained SUM 1600 Sealants retained among children with valid retention check







CheckSealed SUM 1833 Sealants placed among children with a valid retention check







ChildChecked SUM 533 Number of children checked for retention regardless of how long after placement







Consnts 2000








5-year olds sealed 0








6-year olds sealed 3








7-year olds sealed 298








8-year olds sealed 198








9-year olds sealed 50








10-year olds sealed 116








11-year olds sealed 62








12-year olds sealed 11








13-year olds sealed 2








14-year olds sealed 0








15-year olds sealed 0








16-year olds sealed 0








17-year olds sealed 0








18-year olds sealed 0








age unknown sealed 0








Grade 1 sealed 1








Grade 2 sealed 509








Grade 3 sealed 29








Grade 4 sealed 24








Grade 5 sealed 176








Grade 6 sealed 0








Grade 7 sealed 0








Other Grade sealed 1








Medicaid reimbursement for 1 surface posterior filling $65.00









Sheet 4: Attack rate

Reported age Time 1M in mouth on average* Number of children with no sealants at baseline screening Sum of DF1M among children with no sealants at baseline screening AR for years elapsed AR for one year Weighted by proportion of children in age group
7 1 324 261 20.14% 20.14% 8.32%
8 2 226 225 24.89% 13.33% 3.84%
9 3 54 73 33.80% 12.84% 0.88%
10 4 105 176 41.90% 12.70% 1.70%
11 5 61 107 43.85% 10.90% 0.85%
12 6 13 24 46.15% 9.80% 0.16%
13 7 1 1 25.00% 4.03% 0.01%


784
Weighted average one-year AR 15.77%
*Assumes permanent 1M erupt at age 6.






Sheet 5: Averted cavities

Averted cavities Non-discounted Discounted

1st molars 1,139 1,041

2nd molars 87 80

All molars 1,226 1,121






PARAMETERS USED TO ESTIMATE AVERTED 1M CAVITIES



AR 0.16 Conditional retention

R1 0.87

r2 0.79 0.91

r3 0.73 0.92

r4 0.68 0.93

r5 0.64 0.94

r6 0.60 0.95

r7 0.58 0.95

r8 0.55 0.96

r9 0.53 0.97

1st molars sealed 2332


2nd molars 179







1M CAVITIES WITH NO SEALANT PROGRAM



Years since placed Sound Cumulative cavities Cavities per year

0 2332 0 0
1 1964 368 368
2 1655 677 310
3 1394 938 261
4 1174 1158 220
5 989 1343 185
6 833 1499 156
7 702 1630 131
8 591 1741 111
9 498 1834 93



1834
1M CAVITIES WITH SEALANT PROGRAM



Years since placed Sound Sealed Sound Unsealed Cumulative cvities Cavities per year
0 2332 0 0 0
1 2036 250 47 47
2 1848 368 116 69
3 1700 435 197 81
4 1581 466 284 87
5 1485 474 373 89
6 1407 465 460 87
7 1343 446 544 83
8 1289 421 622 79
9 1245 392 696 73





AVERTED 1M CAVITIES



Year Non-discounted Discounted

1 321 312

2 241 227

3 179 164

4 132 118

5 96 83

6 69 58

7 48 39

8 32 25

9 20 15

TOTAL 1139 1041


Sheet 6: Retention Rate

a 0.0100
0.64
b 0.0120







Monthjs
cum Not sealed sealed Cond Sealed
1 0.0099 0.01 0.99
2 0.0098 0.02 0.98
3 0.0096 0.03 0.97
4 0.0095 0.04 0.96
5 0.0094 0.05 0.95
6 0.0093 0.06 0.94
7 0.0092 0.06 0.94
8 0.0091 0.07 0.93
9 0.0090 0.08 0.92
10 0.0089 0.09 0.91
11 0.0088 0.10 0.90
12 0.0087 0.13 0.87 0.87
13 0.0086 0.13 0.87
14 0.0085 0.14 0.86
15 0.0084 0.15 0.85
16 0.0083 0.16 0.84
17 0.0082 0.16 0.84
18 0.0081 0.17 0.83
19 0.0080 0.18 0.82
20 0.0079 0.18 0.82
21 0.0078 0.19 0.81
22 0.0077 0.20 0.80
23 0.0076 0.20 0.80
24 0.0075 0.21 0.79 0.907936704018033
25 0.0074 0.21 0.79
26 0.0073 0.22 0.78
27 0.0072 0.22 0.78
28 0.0071 0.23 0.77
29 0.0071 0.24 0.76
30 0.0070 0.24 0.76
31 0.0069 0.25 0.75
32 0.0068 0.25 0.75
33 0.0067 0.26 0.74
34 0.0066 0.26 0.74
35 0.0066 0.27 0.73
36 0.0065 0.27 0.73 0.919815044248779
37 0.0064 0.28 0.72
38 0.0063 0.28 0.72
39 0.0063 0.28 0.72
40 0.0062 0.29 0.71
41 0.0061 0.29 0.71
42 0.0060 0.30 0.70
43 0.0060 0.30 0.70
44 0.0059 0.31 0.69
45 0.0058 0.31 0.69
46 0.0058 0.31 0.69
47 0.0057 0.32 0.68
48 0.0056 0.32 0.68 0.930215230161719
49 0.0056 0.33 0.67
50 0.0055 0.33 0.67
51 0.0054 0.33 0.67
52 0.0054 0.34 0.66
53 0.0053 0.34 0.66
54 0.0052 0.34 0.66
55 0.0052 0.35 0.65
56 0.0051 0.35 0.65
57 0.0050 0.35 0.65
58 0.0050 0.36 0.64
59 0.0049 0.36 0.64
60 0.0049 0.36 0.64 0.939307569851153
61 0.0048 0.37 0.63
62 0.0048 0.37 0.63
63 0.0047 0.37 0.63
64 0.0046 0.38 0.62
65 0.0046 0.38 0.62
66 0.0045 0.38 0.62
67 0.0045 0.38 0.62
68 0.0044 0.39 0.61
69 0.0044 0.39 0.61
70 0.0043 0.39 0.61
71 0.0043 0.39 0.61
72 0.0042 0.40 0.60 0.947246238260587
73 0.0042 0.40 0.60
74 0.0041 0.40 0.60
75 0.0041 0.40 0.60
76 0.0040 0.41 0.59
77 0.0040 0.41 0.59
78 0.0039 0.41 0.59
79 0.0039 0.41 0.59
80 0.0038 0.42 0.58
81 0.0038 0.42 0.58
82 0.0037 0.42 0.58
83 0.0037 0.42 0.58
84 0.0036 0.42 0.58 0.954169859525905
85 0.0036 0.43 0.57
86 0.0036 0.43 0.57
87 0.0035 0.43 0.57
88 0.0035 0.43 0.57
89 0.0034 0.43 0.57
90 0.0034 0.44 0.56
91 0.0034 0.44 0.56
92 0.0033 0.44 0.56
93 0.0033 0.44 0.56
94 0.0032 0.44 0.56
95 0.0032 0.45 0.55
96 0.0032 0.45 0.55 0.960202373655977
97 0.0031 0.45 0.55
98 0.0031 0.45 0.55
99 0.0030 0.45 0.55
100 0.0030 0.45 0.55
101 0.0030 0.46 0.54
102 0.0029 0.46 0.54
103 0.0029 0.46 0.54
104 0.0029 0.46 0.54
105 0.0028 0.46 0.54
106 0.0028 0.46 0.54
107 0.0028 0.46 0.54
108 0.0027 0.47 0.53 0.965454070048117
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00

© 2024 OMB.report | Privacy Policy