Attachment Y - ER and Hospital Statistics.xlsx

XLSX spreadsheet 17 KB Posted Sep 29, 2022

Attached to: Comprehensive Medical Services
Solicitation number: S000000125
Issued by: Arkansas

About this file

Written by GovTribe AI · Jul 31, 2024

The document provided is an attachment to a state and local contract opportunity for Comprehensive Medical Services in the state of Arkansas. The attachment contains historical inpatient, emergency room, and hospital statistics for the past 12 months for two different client populations, ADC and ACC. The data includes details such as admissions, hospital days, average length of stay, and emergency room visits on a monthly basis. This information appears to be provided to give potential bidders insight into the service utilization and volume that may be expected under this contract.

The contract opportunity covers the provision of comprehensive medical services, though the specific scope of work is not detailed in the materials provided. The contract term and any renewal options are also not specified. The document does not contain information about pricing terms, set asides, incumbent contractors, funding requirements, or other salient commercial details.

View the file

Other files

File	Type	Posted
Attachment A Mandatory Site Visit Schedule.pdf	PDF	Sep 29, 2022
Attachment CC - MH Intakes.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment H Average Staffing Rates Jan-April 2022.pdf	PDF	Sep 29, 2022
S000000125 Solicitation Document as Amended 4.pdf	PDF	Sep 29, 2022
Attachment AA - MH Restrictive Housing Rounds.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment B Mandatory Site Visit Verification Form .pdf	PDF	Sep 29, 2022
Attachment DD - MH Sick Call Requests.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment J Mental Health Monthly Report.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment L Performance Standards.pdf	PDF	Sep 29, 2022
Attachment Q - Projected Average Daily Population by Age.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment R - Formulary Lab Tests.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment U - SD 20-04 Dress Code for NonUniformed Personnel 1.pdf	PDF	Sep 29, 2022
Attachment V - ACA Audit Scheudle.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment W - Dental Equipment.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment Z - Suicide-Treatment Precaution suicide watch Data.xlsx	XLSX spreadsheet	Sep 29, 2022
Contract and Grant Disclosure~23.pdf	PDF	Sep 29, 2022
Attachment C Manhour Deficiency Withholding Schedule.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment F Inpatient and ER Utilization 2021.pdf	PDF	Sep 29, 2022
Attachment G Daily BackLog Report.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment I - Pharmacy Utilization 2019-2022 YTD Updated 11.17.2022~1.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment K Consult Tracking Log.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment N - ADC Owned Medical Equipment.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment T- SD 2020-09 Employee Conduct Standards and Discipline.pdf	PDF	Sep 29, 2022
S000000125 Official Solicitation Price Sheet Final.xlsx	XLSX spreadsheet	Sep 29, 2022
S000000125 Pre Bid Conference.pdf	PDF	Sep 29, 2022
S000000125 Questions and Answers~2.xlsx	XLSX spreadsheet	Sep 29, 2022
S000000125 Technical Response Packet Amended 2.docx	DOCX document	Sep 29, 2022
Attachment BB - MH Caseload case management follow-ups.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment D Staffing Control Matrix.pdf	PDF	Sep 29, 2022
Attachment E - Health Services Report Updated 11.16.2022.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment EE VPAT_Fillable.pdf	PDF	Sep 29, 2022
Attachment M - Community Hospitals.pdf	PDF	Sep 29, 2022
Attachment O - Population Projection.pdf	PDF	Sep 29, 2022
Attachment S - Formulary Medications.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment X - Additional Statistics.xlsx	XLSX spreadsheet	Sep 29, 2022
Attachment P - Three Year Historical Data - Poulation by Unit.xlsx	XLSX spreadsheet	Sep 29, 2022

Show all 36

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.

Sheet1

ADC Inpatient Statistics Past 12 Months															ACC Inpatient Statistics Past 12 Months
	2019															2019
	Jan	Feb	Mar	Apr	May	June	July	Aug	Sept	Oct	Nov	Dec		Average		Jan	Feb	Mar	Apr	May	June	july	Aug	Sep	Oct	Nov	Dec		Average
Admissions	74	53	46	67	68	47	45	44	37	60	52	52	645	53.8	Admissions	1	3	4	3	3	4	1	4	4	4	4	5	40	3.3
Hospital Days	360	212	256	377	353	254	179	160	174	318	213	250	3106	258.8	Hospital Days	2	11	11	7	6	15	0	13	13	11	9	18	116	9.7
Average Length of Stay	5.37	4.76	4.91	6.56	5.22	5.48	5.10	6.21	7.07	6.70	7.65	4.81		4.82	Average Length of Stay	2.00	3.67	2.75	2.33	2.00	3.75	0.00	3.25	3.25	2.75	2.25	3.60		2.90

ADC ER Visits Past 12 Months														ACC ER Visits Past 12 Months
	2019														2019
	Jan	Feb	Mar	Apr	May	June	July	Aug	Sept	Oct	Nov	Dec	Average		Jan	Feb	Mar	Apr	May	June	july	Aug	Sept	Oct	Nov	Nov	Average
Emergency Room Visits	100	76	88	116	117	86	102	115	87	115	100	79	98.4	Emergency Room Visits	9	10	21	10	11	18	22	17	11	23	25	20	16.4

ADC Inpatient Statistics Past 12 Months														ACC Inpatient Statistics Past 12 Months
	2020														2020
	Jan	Feb	Mar	Apr	May	June	July	Aug	Sep	Oct	Nov	Dec	Average		Jan	Feb	Mar	Apr	May	June	july	Aug	Sep	Oct	Nov	Dec	Average
Admissions	62	72	65	61	75	71	123	76	74	77	60	63	73.3	Admissions	4	2	3	4	3	2	8	6	3	2	1	5	3.6
Hospital Days	342	372	345	310	347	503	943	450	423	498	294	354	431.8	Hospital Days	11	6	17	22	14	4	21	17	7	4	2	23	12.3
Average Length of Stay	5.37	4.76	4.91	6.56	5.22	5.48	5.10	6.21	7.07	6.70	7.65	5.62	5.89	Average Length of Stay	2.75	3.00	5.67	5.50	4.67	2.00	2.63	2.83	2.33	2.00	2.00	4.60	3.44

ADC ER Visits Past 12 Months														ACC ER Visits Past 12 Months
	2020														2020
	Jan	Feb	Mar	Apr	May	June	July	Aug	Sep	Oct	Nov	Dec	Average		Dec	Jan	Feb	Mar	Apr	May	June	July	Aug	Sep	Oct	Nov	Average
Emergency Room Visits	92	131	98	87	99	105	146	110	131	138	120	103	113.3	Emergency Room Visits	20	10	10	15	16	13	12	12	10	5	10	16	12.4

ADC Inpatient Statistics Past 12 Months														ACC Inpatient Statistics Past 12 Months
	2021														2021
	Jan	Feb	Mar	April	May	June	July	Aug	Sept	Oct	Nov	Dec	Average		Jan	Feb	Mar	April	May	June	july	Aug	Sept	Oct	Nov	Dec	Average
Admissions	60	43	51	63	65	37	58	43	39	52	48	48	50.6	Admissions	3	2	5	2	8	5	4	1	2	2	5	5	3.7
Hospital Days	328	245	277	310	328	209	302	181	266	297	226	199	264.0	Hospital Days	12	4	10	8	26	16	27	3	10	7	15	28	13.8
Average Length of Stay	5.37	4.76	4.91	6.56	5.22	5.48	5.10	6.21	7.07	6.70	7.65	4.15	5.22	Average Length of Stay	4.00	2.00	2.00	4.00	3.25	3.20	6.75	3.00	5.00	3.50	3.00	5.60	3.77

ADC ER Visits Past 12 Months														ACC ER Visits Past 12 Months
	2021														2021
	Jan	Feb	Mar	April	May	June	July	Aug	Sept	Oct	Nov	Dec	Average		Jan	Feb	Mar	April	May	June	july	Aug	Sept	Oct	Nov	Dec	Average
Emergency Room Visits	112	68	96	105	117	70	95	78	103	99	78	94	92.9	Emergency Room Visits	9	10	10	6	13	8	15	10	12	15	9	21	11.5

ADC Inpatient Statistics Past 12 Months											ACC Inpatient Statistics Past 12 Months
	2022											2022
	Jan	Feb	Mar	Apr	May	June	July	Aug	Sept	Average		Jan	Feb	Mar	Apr	MAY	June	July	Aug	Sept	Average
Admissions	50	25	53	53	49	41	34	47	49	44.6	Admissions	4	3	8	4	5	6	8	4	4	5.1
Hospital Days	219	177	273	223	229	198	152	222	294	220.8	Hospital Days	8	16	21	20	2	22	31	14	21	17.2
Average Length of Stay	6.56	5.22	5.48	5.10	6.21	7.07	6.70	7.65	6.00	4.96	Average Length of Stay	2.00	5.33	2.63	5.00	0.40	3.67	3.88	3.50	5.25	3.37

ADC ER Visits Past 12 Months											ACC ER Visits Past 12 Months
	2022											2022
	Jan	Feb	Mar	Apr	May	June	July	Aug	Sept	Average		Jan	Feb	Mar	Apr	May	June	July	Aug	Sept	Average
Emergency Room Visits	90	91	100	87	92	89	105	88	79	91.2	Emergency Room Visits	27	26	22	22	13	24	19	16	16	20.6

File details come from the government source that posted it. Updated Jul 31, 2024.