260125_10312025_COT_Monthly_Experience_2022-2025.xls
XLS spreadsheet 92 KB Posted
- Solicitation number
- 260125
- Issued by
- Pima County, Tucson City, Arizona
About this file
The document is a monthly healthcare detail experience report for the City of Tucson, covering fiscal years 2022-2025, detailing healthcare claims, premiums, and membership data for a Dental PPO and Dental Choice plan. The report provides a comprehensive breakdown of in-network and out-of-network claims, total claims, billed premiums, loss ratios, and subscriber/member counts across multiple fiscal years, with the most recent data extending through July-September 2025. The report indicates a consistent enrollment of approximately 4,500-4,600 subscribers and 9,900-10,300 total members, with monthly claims ranging between $230,000 and $365,000 and billed premiums consistently around $300,000-$325,000.
The healthcare experience report supports the City of Tucson's concurrent Request for Proposal (RFP #260125) for comprehensive healthcare and benefits administration services, which seeks vendors to provide medical, telehealth, pharmacy, wellness, HSA/HRA administration, dental, and Employee Assistance Program (EAP) coverage. The RFP targets services for approximately 4,498 employees and 2,306 retirees, with a July 1, 2026 effective date, and allows vendors to bid on one or more service lines. Minimum bidder requirements include five years of business experience, 10,000 full-service covered members, and three clients with at least 2,000 total members. The current incumbent is Cigna, and the City pays 100% of employee and dependent costs, with an annual wellness incentive of $100 per subscriber. The contract will have an initial one-year term with options to renew for six additional one-year periods.
View the file
Other files
Show 40 more
Latest 50 of 58 listed here. See the rest on GovTribe.
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
2022-2023
| CITY OF TUCSON | |||||||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | |||||||||||
| July 2022 thru June 2023 | |||||||||||
| Funding Type : TRADITIONAL | |||||||||||
| Rating Type : PROSPECTIVE GUARANTEED COST | |||||||||||
| Reported Premium: Billed Premium without fees | |||||||||||
| Reported Claims: All Claims, Debit, Clms Fwrd, Check, ATM | |||||||||||
| Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services. | |||||||||||
| YTD/MONTH | ACCOUNT | PRODUCT TYPE | IN NETWORK | OUT OF NETWORK | TOTAL CLAIMS | TOTAL HSA | Total HSA & CLAIMS | BILLED PREMIUM | TOTAL LOSS RATIO | TOTAL SUBS | TOTAL MBRS |
| Jul-22 | 3342685-CITY OF TUCSON | DPPO | $191,413 | $57,986 | $249,399 | $0 | $249,399 | $315,653 | 79.0% | 4,534 | 10,304 |
| ACCOUNT Total | $191,413 | $57,986 | $249,399 | $0 | $249,399 | $315,653 | 79.0% | 4,534 | 10,304 | ||
| Aug-22 | 3342685-CITY OF TUCSON | DPPO | $258,466 | $85,210 | $343,677 | $0 | $343,677 | $314,512 | 109.3% | 4,525 | 10,281 |
| ACCOUNT Total | $258,466 | $85,210 | $343,677 | $0 | $343,677 | $314,512 | 109.3% | 4,525 | 10,281 | ||
| Sep-22 | 3342685-CITY OF TUCSON | DPPO | $238,158 | $79,326 | $317,483 | $0 | $317,483 | $314,546 | 100.9% | 4,531 | 10,277 |
| ACCOUNT Total | $238,158 | $79,326 | $317,483 | $0 | $317,483 | $314,546 | 100.9% | 4,531 | 10,277 | ||
| Oct-22 | 3342685-CITY OF TUCSON | DPPO | $219,553 | $64,543 | $284,096 | $0 | $284,096 | $313,935 | 90.5% | 4,528 | 10,257 |
| ACCOUNT Total | $219,553 | $64,543 | $284,096 | $0 | $284,096 | $313,935 | 90.5% | 4,528 | 10,257 | ||
| Nov-22 | 3342685-CITY OF TUCSON | DPPO | $201,281 | $61,140 | $262,420 | $0 | $262,420 | $311,556 | 84.2% | 4,539 | 10,261 |
| ACCOUNT Total | $201,281 | $61,140 | $262,420 | $0 | $262,420 | $311,556 | 84.2% | 4,539 | 10,261 | ||
| Dec-22 | 3342685-CITY OF TUCSON | DPPO | $231,592 | $76,817 | $308,409 | $0 | $308,409 | $314,197 | 98.2% | 4,544 | 10,270 |
| ACCOUNT Total | $231,592 | $76,817 | $308,409 | $0 | $308,409 | $314,197 | 98.2% | 4,544 | 10,270 | ||
| Jan-23 | 3342685-CITY OF TUCSON | DPPO | $212,927 | $53,999 | $266,926 | $0 | $266,926 | $313,080 | 85.3% | 4,544 | 10,254 |
| ACCOUNT Total | $212,927 | $53,999 | $266,926 | $0 | $266,926 | $313,080 | 85.3% | 4,544 | 10,254 | ||
| Feb-23 | 3342685-CITY OF TUCSON | DPPO | $191,922 | $50,859 | $242,781 | $0 | $242,781 | $311,118 | 78.0% | 4,527 | 10,197 |
| ACCOUNT Total | $191,922 | $50,859 | $242,781 | $0 | $242,781 | $311,118 | 78.0% | 4,527 | 10,197 | ||
| Mar-23 | 3342685-CITY OF TUCSON | DPPO | $191,357 | $53,845 | $245,202 | $0 | $245,202 | $343,459 | 71.4% | 4,543 | 10,217 |
| ACCOUNT Total | $191,357 | $53,845 | $245,202 | $0 | $245,202 | $343,459 | 71.4% | 4,543 | 10,217 | ||
| Apr-23 | 3342685-CITY OF TUCSON | DPPO | $233,730 | $53,037 | $286,767 | $0 | $286,767 | $314,264 | 91.3% | 4,553 | 10,216 |
| ACCOUNT Total | $233,730 | $53,037 | $286,767 | $0 | $286,767 | $314,264 | 91.3% | 4,553 | 10,216 | ||
| May-23 | 3342685-CITY OF TUCSON | DPPO | $190,233 | $48,669 | $238,902 | $0 | $238,902 | $314,378 | 76.0% | 4,558 | 10,223 |
| ACCOUNT Total | $190,233 | $48,669 | $238,902 | $0 | $238,902 | $314,378 | 76.0% | 4,558 | 10,223 | ||
| Jun-23 | 3342685-CITY OF TUCSON | DPPO | $203,774 | $52,203 | $255,978 | $0 | $255,978 | $314,068 | 81.5% | 4,563 | 10,201 |
| ACCOUNT Total | $203,774 | $52,203 | $255,978 | $0 | $255,978 | $314,068 | 81.5% | 4,563 | 10,201 | ||
| Grand Total | $2,564,406 | $737,633 | $3,302,039 | $0 | $3,302,039 | $3,794,766 | 87.0% | 54,489 | 122,958 |
&R &8Page &P of &N Date: 7/7/2023&CADVICE Reporting System&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.
2023-2024
| CITY OF TUCSON | |||||||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | |||||||||||
| July 2023 thru June 2024 | |||||||||||
| Funding Type : TRADITIONAL | |||||||||||
| Rating Type : PROSPECTIVE GUARANTEED COST | |||||||||||
| Reported Premium: Billed Premium without fees | |||||||||||
| Reported Claims: All Claims, Debit, Clms Fwrd, Check, ATM | |||||||||||
| Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services. | |||||||||||
| YTD/MONTH | ACCOUNT | PRODUCT TYPE | IN NETWORK | OUT OF NETWORK | TOTAL CLAIMS | TOTAL HSA | Total HSA & CLAIMS | BILLED PREMIUM | TOTAL LOSS RATIO | TOTAL SUBS | TOTAL MBRS |
| Jul-23 | 3342685-CITY OF TUCSON | DPPO | $222,553 | $60,328 | $282,882 | $0 | $282,882 | $312,265 | 90.6% | 4,463 | 9,972 |
| ACCOUNT Total | $222,553 | $60,328 | $282,882 | $0 | $282,882 | $312,265 | 90.6% | 4,463 | 9,972 | ||
| Aug-23 | 3342685-CITY OF TUCSON | DPPO | $283,795 | $81,344 | $365,138 | $0 | $365,138 | $307,488 | 118.7% | 4,461 | 9,948 |
| ACCOUNT Total | $283,795 | $81,344 | $365,138 | $0 | $365,138 | $307,488 | 118.7% | 4,461 | 9,948 | ||
| Sep-23 | 3342685-CITY OF TUCSON | DPPO | $199,448 | $46,138 | $245,586 | $0 | $245,586 | $307,249 | 79.9% | 4,459 | 9,930 |
| ACCOUNT Total | $199,448 | $46,138 | $245,586 | $0 | $245,586 | $307,249 | 79.9% | 4,459 | 9,930 | ||
| Oct-23 | 3342685-CITY OF TUCSON | DPPO | $225,365 | $61,952 | $287,316 | $0 | $287,316 | $306,784 | 93.7% | 4,462 | 9,931 |
| ACCOUNT Total | $225,365 | $61,952 | $287,316 | $0 | $287,316 | $306,784 | 93.7% | 4,462 | 9,931 | ||
| Nov-23 | 3342685-CITY OF TUCSON | DPPO | $217,687 | $50,306 | $267,993 | $0 | $267,993 | $305,677 | 87.7% | 4,459 | 9,931 |
| ACCOUNT Total | $217,687 | $50,306 | $267,993 | $0 | $267,993 | $305,677 | 87.7% | 4,459 | 9,931 | ||
| Dec-23 | 3342685-CITY OF TUCSON | DPPO | $212,022 | $53,877 | $265,898 | $0 | $265,898 | $306,765 | 86.7% | 4,458 | 9,922 |
| ACCOUNT Total | $212,022 | $53,877 | $265,898 | $0 | $265,898 | $306,765 | 86.7% | 4,458 | 9,922 | ||
| Jan-24 | 3342685-CITY OF TUCSON | DPPO | $227,632 | $47,259 | $274,892 | $0 | $274,892 | $305,295 | 90.0% | 4,461 | 9,873 |
| ACCOUNT Total | $227,632 | $47,259 | $274,892 | $0 | $274,892 | $305,295 | 90.0% | 4,461 | 9,873 | ||
| Feb-24 | 3342685-CITY OF TUCSON | DPPO | $209,352 | $50,077 | $259,429 | $0 | $259,429 | $306,306 | 84.7% | 4,478 | 9,911 |
| ACCOUNT Total | $209,352 | $50,077 | $259,429 | $0 | $259,429 | $306,306 | 84.7% | 4,478 | 9,911 | ||
| Mar-24 | 3342685-CITY OF TUCSON | DPPO | $229,802 | $49,054 | $278,856 | $0 | $278,856 | $306,504 | 91.0% | 4,492 | 9,906 |
| ACCOUNT Total | $229,802 | $49,054 | $278,856 | $0 | $278,856 | $306,504 | 91.0% | 4,492 | 9,906 | ||
| Apr-24 | 3342685-CITY OF TUCSON | DPPO | $215,278 | $37,638 | $252,916 | $0 | $252,916 | $305,679 | 82.7% | 4,483 | 9,873 |
| ACCOUNT Total | $215,278 | $37,638 | $252,916 | $0 | $252,916 | $305,679 | 82.7% | 4,483 | 9,873 | ||
| May-24 | 3342685-CITY OF TUCSON | DPPO | $228,852 | $42,842 | $271,694 | $0 | $271,694 | $305,140 | 89.0% | 4,476 | 9,850 |
| ACCOUNT Total | $228,852 | $42,842 | $271,694 | $0 | $271,694 | $305,140 | 89.0% | 4,476 | 9,850 | ||
| Jun-24 | 3342685-CITY OF TUCSON | DPPO | $217,154 | $40,874 | $258,028 | $0 | $258,028 | $304,595 | 84.7% | 4,466 | 9,831 |
| ACCOUNT Total | $217,154 | $40,874 | $258,028 | $0 | $258,028 | $304,595 | 84.7% | 4,466 | 9,831 | ||
| Grand Total | $2,688,939 | $621,688 | $3,310,627 | $0 | $3,310,627 | $3,679,748 | 90.0% | 53,618 | 118,878 |
&R &8Page &P of &N Date: 7/8/2024&CADVICE Reporting System&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.
2024-2025
| CITY OF TUCSON | |||||||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | |||||||||||
| July 2024 thru June 2025 | |||||||||||
| Funding Type : TRADITIONAL | |||||||||||
| Rating Type : PROSPECTIVE GUARANTEED COST | |||||||||||
| Reported Premium: Billed Premium without fees | |||||||||||
| Reported Claims: All Claims, Debit, Clms Fwrd, Check, ATM | |||||||||||
| Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services. | |||||||||||
| YTD/MONTH | ACCOUNT | PRODUCT TYPE | IN NETWORK | OUT OF NETWORK | TOTAL CLAIMS | TOTAL HSA | Total HSA & CLAIMS | BILLED PREMIUM | TOTAL LOSS RATIO | TOTAL SUBS | TOTAL MBRS |
| Jul-24 | 3342685-CITY OF TUCSON | DPPO | $243,479 | $41,610 | $285,089 | $0 | $285,089 | $325,819 | 87.5% | 4,575 | 10,099 |
| ACCOUNT Total | $243,479 | $41,610 | $285,089 | $0 | $285,089 | $325,819 | 87.5% | 4,575 | 10,099 | ||
| Aug-24 | 3342685-CITY OF TUCSON | DPPO | $231,194 | $62,816 | $294,010 | $0 | $294,010 | $324,585 | 90.6% | 4,563 | 10,051 |
| ACCOUNT Total | $231,194 | $62,816 | $294,010 | $0 | $294,010 | $324,585 | 90.6% | 4,563 | 10,051 | ||
| Sep-24 | 3342685-CITY OF TUCSON | DPPO | $242,767 | $48,872 | $291,640 | $0 | $291,640 | $323,807 | 90.1% | 4,557 | 10,020 |
| ACCOUNT Total | $242,767 | $48,872 | $291,640 | $0 | $291,640 | $323,807 | 90.1% | 4,557 | 10,020 | ||
| Oct-24 | 3342685-CITY OF TUCSON | DPPO | $276,023 | $66,092 | $342,115 | $0 | $342,115 | $323,432 | 105.8% | 4,552 | 9,999 |
| ACCOUNT Total | $276,023 | $66,092 | $342,115 | $0 | $342,115 | $323,432 | 105.8% | 4,552 | 9,999 | ||
| Nov-24 | 3342685-CITY OF TUCSON | DPPO | $252,198 | $73,454 | $325,652 | $0 | $325,652 | $323,871 | 100.5% | 4,549 | 10,014 |
| ACCOUNT Total | $252,198 | $73,454 | $325,652 | $0 | $325,652 | $323,871 | 100.5% | 4,549 | 10,014 | ||
| Dec-24 | 3342685-CITY OF TUCSON | DPPO | $185,465 | $39,248 | $224,712 | $0 | $224,712 | $323,240 | 69.5% | 4,543 | 9,983 |
| ACCOUNT Total | $185,465 | $39,248 | $224,712 | $0 | $224,712 | $323,240 | 69.5% | 4,543 | 9,983 | ||
| Jan-25 | 3342685-CITY OF TUCSON | DPPO | $216,407 | $44,215 | $260,622 | $0 | $260,622 | $323,239 | 80.6% | 4,544 | 9,993 |
| ACCOUNT Total | $216,407 | $44,215 | $260,622 | $0 | $260,622 | $323,239 | 80.6% | 4,544 | 9,993 | ||
| Feb-25 | 3342685-CITY OF TUCSON | DPPO | $205,200 | $51,188 | $256,389 | $0 | $256,389 | $322,392 | 79.5% | 4,539 | 9,960 |
| ACCOUNT Total | $205,200 | $51,188 | $256,389 | $0 | $256,389 | $322,392 | 79.5% | 4,539 | 9,960 | ||
| Mar-25 | 3342685-CITY OF TUCSON | DPPO | $209,384 | $56,077 | $265,461 | $0 | $265,461 | $321,309 | 82.6% | 4,531 | 9,929 |
| ACCOUNT Total | $209,384 | $56,077 | $265,461 | $0 | $265,461 | $321,309 | 82.6% | 4,531 | 9,929 | ||
| Apr-25 | 3342685-CITY OF TUCSON | DPPO | $189,291 | $60,952 | $250,243 | $0 | $250,243 | $322,305 | 77.6% | 4,550 | 9,943 |
| ACCOUNT Total | $189,291 | $60,952 | $250,243 | $0 | $250,243 | $322,305 | 77.6% | 4,550 | 9,943 | ||
| May-25 | 3342685-CITY OF TUCSON | DPPO | $233,348 | $40,791 | $274,139 | $0 | $274,139 | $322,843 | 84.9% | 4,563 | 9,954 |
| ACCOUNT Total | $233,348 | $40,791 | $274,139 | $0 | $274,139 | $322,843 | 84.9% | 4,563 | 9,954 | ||
| Jun-25 | 3342685-CITY OF TUCSON | DPPO | $182,104 | $49,468 | $231,573 | $0 | $231,573 | $321,804 | 72.0% | 4,556 | 9,913 |
| ACCOUNT Total | $182,104 | $49,468 | $231,573 | $0 | $231,573 | $321,804 | 72.0% | 4,556 | 9,913 | ||
| Grand Total | $2,666,861 | $634,783 | $3,301,644 | $0 | $3,301,644 | $3,878,646 | 85.1% | 54,622 | 119,858 |
&R &8Page &P of &N Date: 7/5/2025&CADVICE Reporting System&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.
Jul-Sept 2025
| CITY OF TUCSON | ||||||||||||||||||||||
| MONTHLY HEALTHCARE DETAIL EXPERIENCE REPORT | ||||||||||||||||||||||
| July 2025 thru September 2025 | ||||||||||||||||||||||
| Rating Type : RETROSPECTIVE EXPERIENCE RATED | ||||||||||||||||||||||
| Account : 3342685-CITY OF TUCSON | ||||||||||||||||||||||
| Reported Premium: Billed Pooled Premium, ASO Fees | ||||||||||||||||||||||
| Reported Claims: All Claims, All HRA, Debit, Clms Fwrd, Check, ATM | ||||||||||||||||||||||
| Note: Paid claim dollars include amounts deducted from your account and paid to vendors for cost containment services. | ||||||||||||||||||||||
| YTD/MONTH | BENEFIT OPTION | FIXED CHARGES | IN NETWORK | OUT OF NETWORK | COST CONTAIN | CLA | SURCHARGE | DRUG | GROSS CLAIMS | STOP LOSS | PPACA FEES | STATE ASSESSMENTS | INCENTIVES | NET CLAIMS | HRA FUND | TOTAL HRA & CLAIMS | HSA FUND | TOTAL HSA & CLAIMS | POOLED PREMIUM | TOTAL ASO FEES | TOTAL SUBS | TOTAL MBRS |
| Jul-25 | DENT1-CIGNA DENTAL CHOICE TEXAS | $0 | $750 | $1,582 | $21 | $0 | $0 | $0 | $2,353 | $0 | $0 | $0 | $0 | $2,353 | $0 | $2,353 | $0 | $2,353 | $0 | $0 | 0 | 0 |
| DPP1-DENTAL PPO FOR AZ | $0 | $164,998 | $40,483 | $4,090 | $0 | $0 | $0 | $209,571 | $0 | $0 | $0 | $0 | $209,571 | $0 | $209,571 | $0 | $209,571 | $0 | $12,224 | 4,446 | 9,730 | |
| DPP5-DENTAL PPO ALL OTHER STATES | $0 | $3,762 | $3,099 | $215 | $0 | $0 | $0 | $7,076 | $0 | $0 | $0 | $0 | $7,076 | $0 | $7,076 | $0 | $7,076 | $0 | $534 | 194 | 326 | |
| $0 | $169,510 | $45,164 | $4,326 | $0 | $0 | $0 | $219,001 | $0 | $0 | $0 | $0 | $219,001 | $0 | $219,001 | $0 | $219,001 | $0 | $12,757 | 4640 | 10056 | ||
| Aug-25 | DENT1-CIGNA DENTAL CHOICE TEXAS | $0 | $292 | $0 | $36 | $0 | $0 | $0 | $328 | $0 | $0 | $0 | $0 | $328 | $0 | $328 | $0 | $328 | $0 | $0 | 0 | 0 |
| DPP1-DENTAL PPO FOR AZ | $0 | $265,190 | $54,847 | $7,849 | $0 | $0 | $0 | $327,886 | $0 | $0 | $0 | $0 | $327,886 | $0 | $327,886 | $0 | $327,886 | $0 | $12,194 | 4,435 | 9,684 | |
| DPP5-DENTAL PPO ALL OTHER STATES | $0 | $3,554 | $6,607 | $256 | $0 | $0 | $0 | $10,417 | $0 | $0 | $0 | $0 | $10,417 | $0 | $10,417 | $0 | $10,417 | $0 | $550 | 200 | 337 | |
| $0 | $269,037 | $61,454 | $8,141 | $0 | $0 | $0 | $338,631 | $0 | $0 | $0 | $0 | $338,631 | $0 | $338,631 | $0 | $338,631 | $0 | $12,744 | 4,635 | 10,021 | ||
| Sep-25 | DPP1-DENTAL PPO FOR AZ | $0 | $208,167 | $48,522 | $8,821 | $0 | $0 | $0 | $265,510 | $0 | $0 | $0 | $0 | $265,510 | $0 | $265,510 | $0 | $265,510 | $0 | $12,199 | 4,437 | 9,676 |
| DPP5-DENTAL PPO ALL OTHER STATES | $0 | $4,534 | $4,424 | $181 | $0 | $0 | $0 | $9,139 | $0 | $0 | $0 | $0 | $9,139 | $0 | $9,139 | $0 | $9,139 | $0 | $553 | 201 | 336 | |
| $0 | $212,701 | $52,946 | $9,001 | $0 | $0 | $0 | $274,649 | $0 | $0 | $0 | $0 | $274,649 | $0 | $274,649 | $0 | $274,649 | $0 | $12,752 | 4,638 | 10,012 | ||
| BENEFIT OPTION Totals | DENT1-CIGNA DENTAL CHOICE TEXAS | $0 | $1,042 | $1,582 | $57 | $0 | $0 | $0 | $2,681 | $0 | $0 | $0 | $0 | $2,681 | $0 | $2,681 | $0 | $2,681 | $0 | $0 | 0 | 0 |
| DPP1-DENTAL PPO FOR AZ | $0 | $638,356 | $143,852 | $20,760 | $0 | $0 | $0 | $802,967 | $0 | $0 | $0 | $0 | $802,967 | $0 | $802,967 | $0 | $802,967 | $0 | $36,616 | 13318 | 29090 | |
| DPP5-DENTAL PPO ALL OTHER STATES | $0 | $11,850 | $14,130 | $651 | $0 | $0 | $0 | $26,632 | $0 | $0 | $0 | $0 | $26,632 | $0 | $26,632 | $0 | $26,632 | $0 | $1,636 | 595 | 999 | |
| Grand Total | $0 | $651,248 | $159,564 | $21,468 | $0 | $0 | $0 | $832,281 | $0 | $0 | $0 | $0 | $832,281 | $0 | $832,281 | $0 | $832,281 | $0 | $38,253 | 13913 | 30089 |
&R &8Page &P of &N Date: 10/5/2025&CADVICE Reporting System&L&G &7This report contains proprietary and/or confidential information. Disclosure is strictly prohibited except to the extent required by law.
File details come from the government source that posted it. Updated .