Amendment Question 11.xlsx
XLSX spreadsheet 27 KB Posted
- Attached to
- Actuarial Services
- Solicitation number
- 40DHHS-S697
- Issued by
- Churchill County, Nevada
About this file
This document appears to be a spreadsheet titled "Amendment Question 11.xlsx" that provides a summary of hours worked on various projects related to actuarial services for the state of Nevada. The projects include activities such as health insurer fee settlement calculations, capitation rate setting, risk corridor analysis, and program integrity review. The spreadsheet covers work performed from 2017 through 2019, with the majority of the hours logged in 2018.
The related state and local contract opportunity is for "Actuarial Services" in the state of Nevada. The spreadsheet does not provide details on the scope, quantities, response dates, award dates, or contract term, but it suggests the types of actuarial services required by the state, which include rate setting, risk analysis, and program support activities.
View the file
Other files
Show all 18
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
Hours by proj
| Sum of Hours | Column Labels | |||
| Row Labels | 2017 | 2018 | 2019 | Grand Total |
| 2018 Health Insurer Fee Settlement Calculation - 01 | 5.5 | 5.5 | ||
| 2018 Health Insurer Fee Settlement Calculation - 16 | 33.75 | 0.5 | 34.25 | |
| Ad-Hoc Requests - 98 | 30.75 | 16 | 46.75 | |
| Capitation Compnents Training - 22 | 10 | 10 | ||
| Capitation Splits - Family Planning Services - 22 | 23.75 | 35.25 | 59 | |
| Claims Overpayment Review for Program Integrity - 24 | 1 | 1 | ||
| CY 2018 Specialty Pharmacy Risk Corridor - 30 | 60 | 60 | ||
| CY 2019 Dental Managed Care Rate Development - 20 | 110.25 | 41.5 | 151.75 | |
| CY 2019 Family Planning Rate Impact - 22 | 47.75 | 47.75 | ||
| CY 2019 Medical Capitation Rate Setting - 25 | 35.75 | 35.75 | ||
| CY 2020 Dental Capitation Rate Development - 20 | 25 | 25 | ||
| CY 2020 Medical Capitation Rate Development - 25 | 212.75 | 212.75 | ||
| Data Processing for 2018 Rates - 24 | 222.25 | 570.5 | 30.25 | 823 |
| Dental Managed Care Rates - 20 | 19.5 | 597.75 | 617.25 | |
| Eligibility Claims Processing in Support of Rate Development Activity - 24 | 46 | 46 | ||
| Expansion Risk Corridor - 29 | 100 | 19.5 | 119.5 | |
| Expenses | 2 | 2 | ||
| HCGP - Program Evaluation Support with UNR - 18 | 10 | 10 | ||
| HCGP - Re-run on PY 2 - 18 | 11 | 6.5 | 17.5 | |
| HCGP - Standard Work for Current Year - 18 | 1 | 1 | ||
| Health Care Guidance Program - 18 | 334.5 | 37.5 | 372 | |
| Jul-Dec 2017 Risk Adjustment - 06 | 221.75 | 143.25 | 365 | |
| Managed Care Expansion Fiscal Analyses and Rate Development - 39 | 16.75 | 94.5 | 111.25 | |
| MLR Reporting Template - 14 | 52.75 | 52.75 | ||
| Non-Emergency Transportation Experience Review - 98 | 6.25 | 6.25 | ||
| One-on-one Training Sessions - 04 | 11.5 | 7.25 | 18.75 | |
| Pharmacy Carve - Out Fiscal Impact - 31 | 165.75 | 165.75 | ||
| Pharmacy Risk Corridor - 30 | 2 | 2 | ||
| Project Management - 01 | 61 | 52.72 | 113.72 | |
| Safety Net - 26 | 58 | 36.5 | 94.5 | |
| SFY 2019 Eligibility & Claims Data Processing -24 | 37 | 37 | ||
| SFY 2019 Project Management - 01 | 113.5 | 105.25 | 218.75 | |
| TANF/Check Up Rating - 25 | 2562.5 | 1720.75 | 4283.25 | |
| Health Care Reform - 15 | 1.25 | 1.25 | ||
| CY 2019 Non Disabled Medical Capitation Rate Development - 25 | 450 | 40 | 490 | |
| Grand Total | 3421.75 | 4284.47 | 951.75 | 8657.97 |
File details come from the government source that posted it. Updated .