Attachment C Three-Digit Zip Code Analysis REVISED.xlsx

This is a Network Provider Coverage Analysis spreadsheet for the Arkansas Department of Transformation and Shared Services Office of State Procurement's Third Party Administrator RFP. The document consists of two main sections: a Network Provider Counts analysis requiring bidders to indicate the number of providers by type (including Primary Care Physicians, OB/GYNs, Pediatricians, Specialists, Hospitals, and various other healthcare facilities) across approximately 250 three-digit ZIP codes, and a Geographic Access Analysis section that measures employee access to healthcare services against specific distance standards for urban, suburban, and rural areas.

The Geographic Access Analysis portion includes detailed standards requiring hospitals within 10 miles and two providers (PCPs, OB/GYNs, and Pediatricians) within 8 miles for urban areas, facilities within 15 miles for suburban areas, and within 30 miles for rural areas. The spreadsheet reveals significant employee concentrations in ZIP codes 716-729, with the largest populations in ZIP code 720 (14,236 employees), 721 (10,825 employees), and 727 (10,904 employees). Bidders must indicate both the percentage of employees meeting and not meeting these access standards for each ZIP code location where state employees reside.