Attachment_B4__DPPO_Claims_Experience(6008299.2).pdf

399 KB Posted

Attached to
Employee Benefits-Dental and Vision
Solicitation number
27-010CH-32RFP
Issued by
Maricopa County, Tucson City, Arizona

About this file

Written by GovTribe AI ·

This is a claims experience attachment document for the Tempe Union High School District's Employee Benefits-Dental and Vision procurement opportunity in Arizona. The District is soliciting proposals for voluntary dental and vision plans to serve its employees for the contract period of July 1, 2027 through June 30, 2032. The District currently maintains three voluntary plans: a DHMO dental plan offered by Cigna, a PPO dental plan offered by Delta Dental, and a vision plan offered by Davis Vision. Bidders are required to match the current plan designs as closely as possible, or if plan designs preclude exact matching, quote the plan that best matches existing coverage and document any deviations. Proposals must be submitted through the Procurement Portal at https://procurement.opengov.com/portal/tuhsd no later than 2:00 pm on Wednesday, November 4, 2026.

The attachment document referenced appears to be the claims experience data for the existing Delta Dental DPPO plan, which serves as a benchmark for bidders to understand current utilization and cost patterns. This claims experience information enables prospective carriers to accurately price their proposals based on the District's historical dental claims profile. Bidders should use this data to develop competitive rates while maintaining comparable benefit structures for the voluntary PPO dental, voluntary DHMO dental, and voluntary vision coverage options requested by the District.

View the file

Other files

File Type Posted
Employee_Benefits-Dental_and_Vision.pdf PDF
Vendor_Reference_Listing.xlsx XLSX spreadsheet
2026_Dental-Vision_RFP.xlsx XLSX spreadsheet
Attachment_B6__Vision_Plan_Summary(6008303.1).pdf PDF
Attachment_B5__Vision_Claims_Experience(6008301.1).pdf PDF
Attachment_B3__DPPO_Plan_Summary(6008297.1).pdf PDF
Attachment_B2__DHMO_Enrollment_Experience(6008295.1).xlsx XLSX spreadsheet
Attachment_B1__DHMO_Schedule_of_Benefits(6008293.1).pdf PDF
RFP,_TUHSD_00188,_Dental_and_Vision_RFP_Background_and_SOW_2027(6004342.1).pdf PDF
Vendor_Registration_Form_Fillable_-_6.2.2023.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Subscriber Enrollment by Month BOB

Client Number is 6169 Business Date is in the last 36 complete months Subclient Number is 10001000

Tempe Union High School District #213

Business Month Subscriber Only Count Subscriber and Spouse Count Subscriber and Family Count Subscriber and Child Count Subscriber and Children Count

1 2023-09 487 41 87 38 39

2 2023-10 485 40 86 38 39

3 2023-11 486 42 86 38 39

4 2023-12 487 42 85 37 39

5 2024-01 484 42 83 37 39

6 2024-02 483 43 83 38 38

7 2024-03 482 44 84 37 38

8 2024-04 486 44 84 37 38

9 2024-05 486 45 85 38 37

10 2024-06 487 45 85 38 37

11 2024-07 443 37 87 42 38

12 2024-08 443 39 86 42 39

13 2024-09 454 42 87 42 39

14 2024-10 453 42 86 42 39

15 2024-11 452 41 86 40 39

16 2024-12 454 42 86 40 38

17 2025-01 443 45 85 41 38

18 2025-02 445 45 85 41 38

19 2025-03 442 45 86 41 37

20 2025-04 440 46 82 43 37

21 2025-05 440 46 83 43 37

22 2025-06 442 48 78 41 32

23 2025-07 414 44 80 37 30

24 2025-08 412 45 78 37 30

25 2025-09 428 48 79 38 30

26 2025-10 431 48 78 39 30

27 2025-11 434 47 79 38 30

28 2025-12 440 49 79 38 31

29 2026-01 432 51 78 38 31

30 2026-02 429 52 78 36 32

31 2026-03 432 51 80 35 31

32 2026-04 435 51 80 35 31

33 2026-05 435 49 80 35 31

34 2026-06 423 49 78 35 31

35 2026-07 404 49 82 34 33

36 2026-08 405 49 83 33 34

Delta Dental of Arizona

Generated by Looker on September 2, 2026 at 5:15 PM EDT

Subscriber Enrollment by Month BOB

Client Number is 6169 Business Date is in the last 36 complete months Subclient Number is 19901000

Tempe Union High School District #213

Business Month Subscriber Only Count Subscriber and Spouse Count Subscriber and Family Count Subscriber and Child Count Subscriber and Children Count

1 2023-09 9 5 1 0 1

2 2023-10 8 4 1 0 1

3 2023-11 8 3 1 0 1

4 2023-12 6 1 1 0 1

5 2024-01 8 1 0 0 0

6 2024-02 7 1 0 0 0

7 2024-03 6 1 0 0 0

8 2024-04 5 1 0 0 0

9 2024-05 5 1 0 0 0

10 2024-06 5 1 0 0 0

11 2024-07 6 2 0 0 0

12 2024-08 6 1 0 0 0

13 2024-09 6 1 0 0 0

14 2024-10 6 1 0 0 0

15 2024-11 6 1 0 0 0

16 2024-12 6 1 0 1 0

17 2025-01 6 0 0 1 0

18 2025-02 6 0 0 1 0

19 2025-03 6 0 0 1 0

20 2025-04 6 0 0 1 0

21 2025-05 6 0 0 1 0

22 2025-06 6 0 0 1 0

23 2025-07 9 0 1 0 2

24 2025-08 9 0 1 0 2

25 2025-09 10 0 1 0 2

26 2025-10 10 0 1 0 2

27 2025-11 10 0 1 0 2

28 2025-12 9 0 1 0 2

29 2026-01 7 0 1 1 1

30 2026-02 7 0 1 1 1

31 2026-03 7 0 1 0 1

32 2026-04 7 0 1 0 1

33 2026-05 8 0 1 0 1

34 2026-06 8 0 1 0 1

35 2026-07 13 1 1 0 1

36 2026-08 12 1 1 0 0

Generated by Looker on September 2, 2026 at 5:27 PM EDT

Premium and Claims History

Date Range is in the last 36 complete months Carrier is DDAZ Client Number is 6169 SubClient Number is 10001000

Tempe Union High School District #213

A summary of your earned premium and claims activity

Summary Ym Employee Count Monthly Earned Premium YTD Premium Rolling 12 Premium Claim Count Monthly Paid Claims YTD Paid Claims Rolling 12 Months Rolling 12 Months loss

Ratio

1 2023-09 692 34,479.6 307,276.96 412,149.2 156 $20,697.52 $261,438.35 $341,336.59 82.82%

2 2023-10 688 34,245.88 341,522.84 411,577.6 220 $28,034.96 $289,473.31 $340,107.01 82.63%

3 2023-11 691 34,421.64 375,944.48 411,018.2 149 $18,422.00 $307,895.31 $333,373.01 81.11%

4 2023-12 690 34,258.8 410,203.28 410,203.28 178 $21,461.80 $329,357.11 $329,357.11 80.29%

5 2024-01 685 34,002.56 34,002.56 409,309.32 222 $33,272.40 $33,272.40 $327,240.91 79.95%

6 2024-02 685 34,014.76 68,017.32 408,604.04 135 $21,367.40 $54,639.80 $321,386.81 78.65%

7 2024-03 685 34,072 102,089.32 407,956 208 $30,051.20 $84,691.00 $319,689.98 78.36%

8 2024-04 689 34,213.76 136,303.08 407,392.48 158 $24,600.80 $109,291.80 $314,889.88 77.29%

9 2024-05 691 34,354.08 170,657.16 407,111.04 167 $24,344.80 $133,636.60 $307,898.18 75.63%

10 2024-06 692 34,389.52 205,046.68 407,438.8 227 $38,235.80 $171,872.40 $315,645.08 77.47%

11 2024-07 647 32,827.56 237,874.24 407,581.08 245 $38,313.50 $210,185.90 $324,722.88 79.67%

12 2024-08 648 32,932.44 270,806.68 408,212.6 162 $24,572.70 $234,758.60 $323,374.88 79.22%

13 2024-09 664 33,660.88 304,467.56 407,393.88 118 $17,025.60 $251,784.20 $319,702.96 78.48%

14 2024-10 662 33,532.76 338,000.32 406,680.76 233 $36,992.74 $288,776.94 $328,660.74 80.82%

15 2024-11 658 33,286.84 371,287.16 405,545.96 138 $18,281.80 $307,058.74 $328,520.54 81.01%

16 2024-12 660 33,334.48 404,621.64 404,621.64 148 $20,245.30 $327,304.04 $327,304.04 80.89%

17 2025-01 652 33,204.2 33,204.2 403,823.28 201 $30,741.50 $30,741.50 $324,773.14 80.42%

18 2025-02 654 33,204.2 66,408.4 403,012.72 186 $29,057.40 $59,798.90 $332,463.14 82.49%

19 2025-03 651 33,097.88 99,506.28 402,038.6 176 $29,224.60 $89,023.50 $331,636.54 82.49%

20 2025-04 648 32,866.76 132,373.04 400,691.6 170 $26,352.70 $115,376.20 $333,388.44 83.20%

21 2025-05 648 32,924 165,297.04 399,261.52 161 $23,333.00 $138,709.20 $332,376.64 83.25%

22 2025-06 641 32,103.52 197,400.56 396,975.52 188 $29,382.00 $168,091.20 $323,522.84 81.50%

23 2025-07 604 32,039.1 229,439.66 396,187.06 284 $41,928.70 $210,019.90 $327,138.04 82.57%

24 2025-08 602 31,880.94 261,320.6 395,135.56 174 $27,747.60 $237,767.50 $330,312.94 83.59%

25 2025-09 623 32,831.08 294,151.68 394,305.76 165 $22,146.30 $259,913.80 $335,433.64 85.07%

26 2025-10 626 32,956.28 327,107.96 393,729.28 172 $25,420.00 $285,333.80 $323,860.90 82.25%

27 2025-11 628 33,017.88 360,125.84 393,460.32 157 $24,301.40 $309,635.20 $329,880.50 83.84%

28 2025-12 636 33,448.58 393,574.42 393,574.42 172 $24,449.40 $334,084.60 $334,084.60 84.88%

29 2026-01 630 33,238.14 33,238.14 393,608.36 192 $31,987.10 $31,987.10 $335,330.20 85.19%

30 2026-02 627 33,150.15 66,388.29 393,554.31 149 $26,517.90 $58,505.00 $332,790.70 84.56%

31 2026-03 629 33,211.75 99,600.04 393,668.18 197 $34,298.10 $92,803.10 $337,864.20 85.82%

32 2026-04 632 33,323.38 132,923.42 394,124.8 144 $22,234.50 $115,037.60 $333,746.00 84.68%

33 2026-05 630 33,176.04 166,099.46 394,376.84 130 $24,326.70 $139,364.30 $334,739.70 84.88%

34 2026-06 616 32,534.9 198,634.36 394,808.22 227 $33,009.40 $172,373.70 $338,367.10 85.70%

35 2026-07 602 32,338.1 230,972.46 395,107.22 230 $37,626.00 $209,999.70 $334,064.40 84.55%

36 2026-08 604 32,496.26 263,468.72 395,722.54 146 $26,210.05 $236,209.75 $332,526.85 84.03%

Claims Paid

Rolling 12 Months YTD Paid Claims

Sep Nov Jan Mar May Jul Sep Nov Jan Mar May Jul Sep Nov Jan Mar May Jul

Months

$0.00

$100,000.00

$200,000.00

$300,000.00

Premium Earned

Rolling 12 Premium YTD Premium

Sep Nov Jan Mar May Jul Sep Nov Jan Mar May Jul Sep Nov Jan Mar May Jul

Months

100,000

200,000

300,000

400,000

Generated by Looker on September 2, 2026 at 5:03 PM EDT

Premium and Claims History

Date Range is in the last 36 complete months Carrier is DDAZ Client Number is 6169 SubClient Number is 19901000

Tempe Union High School District #213

A summary of your earned premium and claims activity

Summary Ym Employee Count Monthly Earned Premium YTD Premium Rolling 12 Premium Claim Count Monthly Paid Claims YTD Paid Claims Rolling 12 Months Rolling 12 Months loss

Ratio

1 2023-09 16 855.12 7,056.72 9,443.44 8 $889.50 $4,118.20 $4,269.20 45.21%

2 2023-10 14 749.52 7,806.24 9,374 5 $866.40 $4,984.60 $5,135.60 54.79%

3 2023-11 13 679.36 8,485.6 9,234.4 5 $492.80 $5,477.40 $5,477.40 59.32%

4 2023-12 9 468.16 8,953.76 8,953.76 4 $911.50 $6,388.90 $6,388.90 71.35%

5 2024-01 9 353.68 353.68 8,594.08 2 $219.90 $219.90 $6,226.80 72.45%

6 2024-02 8 318.24 671.92 8,198.96 5 $115.00 $334.90 $5,822.80 71.02%

7 2024-03 7 282.8 954.72 7,732.96 2 $24.40 $359.30 $5,522.00 71.41%

8 2024-04 6 247.36 1,202.08 7,231.52 0 $0.00 $359.30 $4,207.90 58.19%

9 2024-05 6 247.36 1,449.44 6,730.08 4 $400.00 $759.30 $4,325.90 64.28%

10 2024-06 6 247.36 1,696.8 6,228.64 0 $0.00 $759.30 $3,999.90 64.22%

11 2024-07 8 352.96 2,049.76 5,691.76 2 $114.20 $873.50 $4,033.70 70.87%

12 2024-08 7 282.8 2,332.56 5,084.72 2 $92.00 $965.50 $4,125.70 81.14%

13 2024-09 7 282.8 2,615.36 4,512.4 2 $537.00 $1,502.50 $3,773.20 83.62%

14 2024-10 7 282.8 2,898.16 4,045.68 2 $137.00 $1,639.50 $3,043.80 75.24%

15 2024-11 7 282.8 3,180.96 3,649.12 1 $0.00 $1,639.50 $2,551.00 69.91%

16 2024-12 8 352.96 3,533.92 3,533.92 2 $31.00 $1,670.50 $1,670.50 47.27%

17 2025-01 7 282.8 282.8 3,463.04 3 $97.40 $97.40 $1,548.00 44.70%

18 2025-02 7 282.8 565.6 3,427.6 5 $972.00 $1,069.40 $2,405.00 70.17%

19 2025-03 7 282.8 848.4 3,427.6 5 $569.60 $1,639.00 $2,950.20 86.07%

20 2025-04 7 282.8 1,131.2 3,463.04 5 $199.60 $1,838.60 $3,149.80 90.95%

21 2025-05 7 282.8 1,414 3,498.48 2 $598.00 $2,436.60 $3,347.80 95.69%

22 2025-06 7 282.8 1,696.8 3,533.92 0 $0.00 $2,436.60 $3,347.80 94.73%

23 2025-07 12 626.82 2,323.62 3,807.78 2 $330.00 $2,766.60 $3,563.60 93.59%

24 2025-08 12 626.82 2,950.44 4,151.8 9 $692.20 $3,458.80 $4,163.80 100.29%

25 2025-09 13 664.03 3,614.47 4,533.03 3 $220.00 $3,678.80 $3,846.80 84.86%

26 2025-10 13 664.03 4,278.5 4,914.26 7 $604.90 $4,283.70 $4,314.70 87.80%

27 2025-11 13 664.03 4,942.53 5,295.49 3 $820.10 $5,103.80 $5,134.80 96.97%

28 2025-12 12 626.82 5,569.35 5,569.35 3 $309.00 $5,412.80 $5,412.80 97.19%

29 2026-01 10 528.76 528.76 5,815.31 2 $537.70 $537.70 $5,853.10 100.65%

30 2026-02 10 528.76 1,057.52 6,061.27 2 $1,687.00 $2,224.70 $6,568.10 108.36%

31 2026-03 9 455.09 1,512.61 6,233.56 2 $201.00 $2,425.70 $6,199.50 99.45%

32 2026-04 9 455.09 1,967.7 6,405.85 3 $686.00 $3,111.70 $6,685.90 104.37%

33 2026-05 10 492.3 2,460 6,615.35 4 $177.80 $3,289.50 $6,265.70 94.71%

34 2026-06 10 492.3 2,952.3 6,824.85 6 $883.50 $4,173.00 $7,149.20 104.75%

35 2026-07 16 752.02 3,704.32 6,950.05 5 $466.50 $4,639.50 $7,285.70 104.83%

36 2026-08 14 617.5 4,321.82 6,940.73 1 $139.00 $4,778.50 $6,732.50 97.00%

Claims Paid

Rolling 12 Months YTD Paid Claims

Sep Nov Jan Mar May Jul Sep Nov Jan Mar May Jul Sep Nov Jan Mar May Jul

Months

$0.00

$2,000.00

$4,000.00

$6,000.00

Premium Earned

Rolling 12 Premium YTD Premium

Sep Nov Jan Mar May Jul Sep Nov Jan Mar May Jul Sep Nov Jan Mar May Jul

Months

2,500

5,000

7,500

Generated by Looker on September 2, 2026 at 5:30 PM EDT

CMR_6169_36M_Subscriber_Enrollment_by_Month__BOB_2026-09-02T1415
CMR_6169_36M COBRA_Subscriber_Enrollment_by_Month__BOB_2026-09-02T1427
CMR_6169_36M_Premium_and_Claims_History_2026-09-02T1403
CMR_6169_36M COBRA Premium_and_Claims_History_2026-09-02T1430

File details come from the government source that posted it. Updated .