ATTACHMENT 7 - FY 2023 WORKLOAD.pdf
PDF 209 KB Posted
- Attached to
- Accounts Receivable Services
- Solicitation number
- 75H71324Q00040
About this file
This document is a Request for Quotation (RFQ) for Accounts Receivable Services. The Department of Health and Human Services Indian Health Service is seeking a contractor to provide accounts receivable services including billing, adjustments, and collections. The performance period is one year with four one-year options.
The evaluation criteria are price and demonstrated prior experience. Offerors must submit a price quotation using the provided attachment and demonstrate experience with ICD-10 coding, reviewing explanation of benefits, posting payments, and accounts receivable work. Quotes are due by April 8, 2024 at 9:00 AM PDT. The solicitation is set aside for Indian Small Business Economic Enterprises. The NAICS code is 561440 with a $19,500,000 size standard.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| ATTACHMENT 6 - Q-A 75H71324Q00040 REVISED 04042024.docx | DOCX document | |
| ATTACHMENT 6 - Q-A 75H71324Q00040.docx | DOCX document | |
| Exhibit 2 - Financial Spread Sheet.xlsx | XLSX spreadsheet | |
| ATTACHMENT 2 - STATEMENT OF WORK.docx | DOCX document | |
| ATTACHMENT 3 - BUSINESS ASSOCIATE AGREEMENT.pdf | ||
| ATTACHMENT 1 - SCHEDULE OF ITEMS.xlsx | XLSX spreadsheet | |
| Exhibit 4 - Batch document example (PI-02032021-3)_Redacted.pdf | ||
| Exhibit 3 - File for low pmt.docx | DOCX document | |
| ATTACHMENT 4 - WAGE DETERMINATION.pdf | ||
| Exhibit 1 - Insurance Websites.xlsx | XLSX spreadsheet | |
| ATTACHMENT 5 - IHS IEE REPRESENTATION FORM.pdf |
Show all 11
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
Oct‐22 Nov‐22 Dec‐22 Jan‐23 Feb‐23 Mar‐23 Apr‐23 May‐23 Jun‐23 Jul‐23 Aug‐23 Sep‐23 Billed 791,251.94$ 911,294.85$ 999,934.53$ 1,119,946.97$ 1,079,270.61$ 1,003,274.04$ 905,327.18$ 887,293.34$ 647,144.15$ 569,574.91$ 685,591.48$ 713,049.41$ Adjustments (80,433.20)$ (84,608.98)$ 132,798.87$ (84,169.13)$ (88,738.61)$ (90,705.85)$ (97,488.70)$ (145,852.99)$ (97,319.16)$ (107,295.07)$ (50,315.44)$ (257,320.51)$ Collection 860,182.65$ 989,234.38$ 856,678.26$ 1,191,041.24$ 1,156,670.77$ 1,071,002.02$ 975,198.24$ 990,079.07$ 670,487.75$ 614,970.31$ 611,888.96$ 459,494.83$
FY 2023 Billed ‐ Adjustments ‐ Collections Trending
$1,000,000.00
$2,000,000.00
Oct‐22 Nov‐22 Dec‐22 Jan‐23 Feb‐23 Mar‐23 Apr‐23 May‐23 Jun‐23 Jul‐23 Aug‐23 Sep‐23 Billed $791,251.94 $911,294.85 $999,934.53 $1,119,946. $1,079,270. $1,003,274. $905,327.18 $887,293.34 $647,144.15 $569,574.91 $685,591.48 $713,049.41
Billed
$(300,000.00)
$(200,000.00)
$(100,000.00)
$100,000.00
$200,000.00
Oct‐22 Nov‐22 Dec‐22 Jan‐23 Feb‐23 Mar‐23 Apr‐23 May‐23 Jun‐23 Jul‐23 Aug‐23 Sep‐23 Adjustments $(80,433.20 $(84,608.98 $132,798.87 $(84,169.13 $(88,738.61 $(90,705.85 $(97,488.70 $(145,852.9 $(97,319.16 $(107,295.0 $(50,315.44 $(257,320.5
Adjustments
$500,000.00
$1,000,000.00
$1,500,000.00
Oct‐22 Nov‐22 Dec‐22 Jan‐23 Feb‐23 Mar‐23 Apr‐23 May‐23 Jun‐23 Jul‐23 Aug‐23 Sep‐23 Collection $860,182.65 $989,234.38 $856,678.26 $1,191,041. $1,156,670. $1,071,002. $975,198.24 $990,079.07 $670,487.75 $614,970.31 $611,888.96 $459,494.83
Collection
FY 2023 Total Visits: 47,854
FY 2023 Visits by Clinic
General: 4,054 Immunization: 254 Optometry: 711 Pharmacy: 36,226 Dental: 1,429 Employee Health: 103 PHN Clinic: 88 Laboratory: 212 Telemedicine: 2 Tobacco Cessation: 1 Behavioral Health: 3,144 Nurse Clinic: 1,611 Anticoagulation: 19
File details come from the government source that posted it. Updated .