Amendment Question 5.xlsx
XLSX spreadsheet 32 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 related to a state and local contract opportunity for Actuarial Services in Nevada. The spreadsheet contains information on various project activities and expenses related to this contract opportunity, including items such as Health Insurer Fee Settlement Calculations, Capitation Component Trainings, Dental Managed Care Rate Development, Medical Capitation Rate Setting, and Pharmacy Risk Corridor analyses. The spreadsheet covers activities and expenses from 2017 through 2019. No specific response dates, due dates, award dates, or contract term details are provided.
The spreadsheet includes pricing information for the various project activities, which appear to total over $2.3 million. The document does not indicate any set-asides, incumbents, or specific funding sources. The overall purpose seems to be tracking expenses and project activities related to the Actuarial Services contract in Nevada.
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
Monthly inv
| Sum of Total | Column Labels | |||||||||||||||||||||||||||
| 2017 | 2017 Total | 2018 | 2018 Total | 2019 | 2019 Total | Grand Total | ||||||||||||||||||||||
| Row Labels | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||||
| 2018 Health Insurer Fee Settlement Calculation - 01 | $ 2,027.50 | $ 2,027.50 | $ 2,027.50 | |||||||||||||||||||||||||
| 2018 Health Insurer Fee Settlement Calculation - 16 | $ 4,380.00 | $ 5,408.75 | $ 9,788.75 | $ 147.50 | $ 147.50 | $ 9,936.25 | ||||||||||||||||||||||
| Ad-Hoc Requests - 98 | $ 5,608.75 | $ 952.50 | $ 765.00 | $ 487.50 | $ 292.50 | $ 8,106.25 | $ 487.50 | $ 2,047.50 | $ 2,841.25 | $ 5,376.25 | $ 13,482.50 | |||||||||||||||||
| Capitation Compnents Training - 22 | $ 2,542.50 | $ 622.50 | $ 3,165.00 | $ 3,165.00 | ||||||||||||||||||||||||
| Capitation Splits - Family Planning Services - 22 | $ 6,750.00 | $ 6,750.00 | $ 10,152.50 | $ 10,152.50 | $ 16,902.50 | |||||||||||||||||||||||
| Claims Overpayment Review for Program Integrity - 24 | $ 302.50 | $ 302.50 | $ 302.50 | |||||||||||||||||||||||||
| CY 2018 Specialty Pharmacy Risk Corridor - 30 | $ 14,202.50 | $ 1,191.25 | $ 118.75 | $ 15,512.50 | $ 15,512.50 | |||||||||||||||||||||||
| CY 2019 Dental Managed Care Rate Development - 20 | $ 23,177.50 | $ 1,350.00 | $ 1,650.00 | $ 26,177.50 | $ 11,368.75 | $ 11,368.75 | $ 37,546.25 | |||||||||||||||||||||
| CY 2019 Family Planning Rate Impact - 22 | $ 6,018.75 | $ 6,065.00 | $ 12,083.75 | $ 12,083.75 | ||||||||||||||||||||||||
| CY 2019 Medical Capitation Rate Setting - 25 | $ 11,956.25 | $ 11,956.25 | $ 11,956.25 | |||||||||||||||||||||||||
| CY 2020 Dental Capitation Rate Development - 20 | $ 6,015.00 | $ 1,640.00 | $ 7,655.00 | $ 7,655.00 | ||||||||||||||||||||||||
| CY 2020 Medical Capitation Rate Development - 25 | $ 19,816.25 | $ 33,832.50 | $ 53,648.75 | $ 53,648.75 | ||||||||||||||||||||||||
| Data Processing for 2018 Rates - 24 | $ 9,243.75 | $ 14,197.50 | $ 3,360.00 | $ 1,473.75 | $ 7,021.25 | $ 8,106.25 | $ 7,927.50 | $ 51,330.00 | $ 12,177.50 | $ 16,150.00 | $ 24,386.25 | $ 13,896.25 | $ 20,456.25 | $ 34,028.75 | $ 9,310.00 | $ 4,873.75 | $ 3,931.25 | $ 4,613.75 | $ 3,120.00 | $ 146,943.75 | $ 3,481.25 | $ 3,778.75 | $ 7,260.00 | $ 205,533.75 | ||||
| Dental Managed Care Rates - 20 | $ 5,707.50 | $ 783.75 | $ 6,491.25 | $ 3,360.00 | $ 5,766.25 | $ 697.50 | $ 990.00 | $ 5,718.75 | $ 72,766.25 | $ 57,782.50 | $ 3,748.75 | $ 150,830.00 | $ 157,321.25 | |||||||||||||||
| Eligibility Claims Processing in Support of Rate Development Activity - 24 | $ 13,756.25 | $ 13,756.25 | $ 13,756.25 | |||||||||||||||||||||||||
| Expansion Risk Corridor - 29 | $ 10,638.75 | $ 16,020.00 | $ 26,658.75 | $ 5,352.50 | $ 611.25 | $ 5,963.75 | $ 32,622.50 | |||||||||||||||||||||
| Expenses | $ 83.80 | $ (2,072.87) | $ (1,989.07) | $ (1,989.07) | ||||||||||||||||||||||||
| HCGP - Program Evaluation Support with UNR - 18 | $ 1,485.00 | $ 440.00 | $ 735.00 | $ 390.00 | $ 3,050.00 | $ 3,050.00 | ||||||||||||||||||||||
| HCGP - Re-run on PY 2 - 18 | $ 3,387.50 | $ 3,387.50 | $ 2,180.00 | $ 2,180.00 | $ 5,567.50 | |||||||||||||||||||||||
| HCGP - Standard Work for Current Year - 18 | $ 307.50 | $ 307.50 | $ 307.50 | |||||||||||||||||||||||||
| Health Care Guidance Program - 18 | $ 10,865.00 | $ 31,370.00 | $ 17,288.75 | $ 7,223.75 | $ 8,945.00 | $ 4,456.25 | $ 80,148.75 | $ 4,331.25 | $ 7,100.00 | $ 11,431.25 | $ 91,580.00 | |||||||||||||||||
| Jul-Dec 2017 Risk Adjustment - 06 | $ 3,997.50 | $ 337.50 | $ 7,170.00 | $ 9,802.50 | $ 26,332.50 | $ 14,538.75 | $ 62,178.75 | $ 8,315.00 | $ 3,915.00 | $ 3,080.00 | $ 292.50 | $ 15,602.50 | $ 77,781.25 | |||||||||||||||
| Managed Care Expansion Fiscal Analyses and Rate Development - 39 | $ 5,290.00 | $ 5,290.00 | $ 3,365.00 | $ 19,326.25 | $ 3,975.00 | $ 26,666.25 | $ 31,956.25 | |||||||||||||||||||||
| MLR Reporting Template - 14 | $ 5,856.25 | $ 6,617.50 | $ 1,541.25 | $ 2,987.50 | $ 292.50 | $ 17,295.00 | $ 17,295.00 | |||||||||||||||||||||
| Non-Emergency Transportation Experience Review - 98 | $ 2,437.50 | $ 2,437.50 | $ 2,437.50 | |||||||||||||||||||||||||
| One-on-one Training Sessions - 04 | $ 3,193.75 | $ 1,267.50 | $ 4,461.25 | $ 1,657.50 | $ 1,170.00 | $ 2,827.50 | $ 7,288.75 | |||||||||||||||||||||
| Pharmacy Carve - Out Fiscal Impact - 31 | $ 28,275.00 | $ 14,355.00 | $ 42,630.00 | $ 42,630.00 | ||||||||||||||||||||||||
| Pharmacy Risk Corridor - 30 | $ 732.50 | $ 732.50 | $ 732.50 | |||||||||||||||||||||||||
| Project Management - 01 | $ 1,312.50 | $ 3,997.50 | $ 1,170.00 | $ 2,082.50 | $ 1,477.50 | $ 4,915.00 | $ 2,950.00 | $ 4,707.50 | $ 22,612.50 | $ 5,268.30 | $ 1,560.00 | $ 2,925.00 | $ 2,925.00 | $ 3,902.50 | $ 3,315.00 | $ 585.00 | $ 20,480.80 | $ 43,093.30 | ||||||||||
| Safety Net - 26 | $ 570.00 | $ 2,070.00 | $ 4,522.50 | $ 2,430.00 | $ 697.50 | $ 450.00 | $ 1,275.00 | $ 12,015.00 | $ 442.50 | $ 8,662.50 | $ 9,105.00 | $ 21,120.00 | ||||||||||||||||
| SFY 2019 Eligibility & Claims Data Processing -24 | $ 4,192.50 | $ 5,400.00 | $ 9,592.50 | $ 9,592.50 | ||||||||||||||||||||||||
| SFY 2019 Project Management - 01 | $ 836.25 | $ 5,913.75 | $ 6,035.00 | $ 7,240.00 | $ 6,447.50 | $ 3,237.50 | $ 29,710.00 | $ 4,332.50 | $ 12,201.25 | $ 7,650.00 | $ 11,501.25 | $ 35,685.00 | $ 65,395.00 | |||||||||||||||
| TANF/Check Up Rating - 25 | $ 11,345.00 | $ 69,657.50 | $ 119,281.25 | $ 229,141.25 | $ 136,038.75 | $ 64,927.50 | $ 35,858.75 | $ 22,916.25 | $ 689,166.25 | $ 38,841.25 | $ 22,237.50 | $ 10,461.25 | $ 11,050.00 | $ 20,303.75 | $ 67,387.50 | $ 174,358.75 | $ 111,347.50 | $ 23,930.00 | $ 479,917.50 | $ 1,169,083.75 | ||||||||
| Health Care Reform - 15 | $ 487.50 | $ 487.50 | $ 487.50 | |||||||||||||||||||||||||
| CY 2019 Non Disabled Medical Capitation Rate Development - 25 | $ 108,695.00 | $ 10,775.00 | $ 5,920.00 | $ 125,390.00 | $ 603.75 | $ 12,045.00 | $ 12,648.75 | $ 138,038.75 | ||||||||||||||||||||
| Grand Total | $ 28,080.00 | $ 103,225.00 | $ 166,453.75 | $ 250,942.50 | $ 148,351.25 | $ 86,573.75 | $ 68,738.80 | $ 51,849.63 | $ 904,214.68 | $ 69,818.30 | $ 52,147.50 | $ 50,638.75 | $ 32,021.25 | $ 51,508.75 | $ 117,510.00 | $ 152,588.75 | $ 280,248.75 | $ 189,751.25 | $ 68,297.50 | $ 66,066.25 | $ 41,890.00 | $ 1,172,487.05 | $ 21,902.50 | $ 65,985.00 | $ 84,960.00 | $ 69,351.25 | $ 242,198.75 | $ 2,318,900.48 |
File details come from the government source that posted it. Updated .