MDBGpraestimate_COB_2-2010

---

Overview

Estimates Table
2010 Contracts&Pharmacies
Beneficiary Information
ATBT separate calc.

---

Sheet 1: Estimates Table

Subpart	Original # Respondents	Approved 2006 Estimate - Burden Hours	# Respondents (CY 2010 - 196 sponsors, 39 states, 56,000 pharmacies)	# of Responses	Time per response (in hours)	2010 Revised Estimate - Burden hours	Exempt/Separate PRA
J—Coordination of Part D Plans with Other Prescription Drug Coverage
423.464 Coordination of Benefits
Part D sponsors
Revise payer systems to receive N transactions from Troop Facilitator	370	22,200	10	1	60.0000	600
Processing claims through TrOOP facilitator (Receiving Ns)	370	592,000	196	191,377	0.000139	5,210
Entering OHI into PDP sponsor systems	370	246,790	196	1	0.0166	3
Submission of Lump Sum	370	22,200	196	1	60.0000	11,760
Programming for Automatic Troop Balance Transfer (ATBT) (New CY 2009)			196	1	40.0000	7,840
ATBT exchanges and updates transactions (New CY 2009)			196	55,855	0.0001	1,520
ATBT additional programming.			196	1	17.8500	3,499
Pharmacies
Eligibility Queries	55,413	132,753	56,000	779	0.0166	724,158
States/Secondary Payers
Submission of VDSAs	636	318	n/a	n/a	n/a		Already collected for MSP purposes - Separate PRA 0938-0214
Submission of Enrollment Files	636	382	n/a	n/a	n/a		Already collected for MSP purposes - Separate PRA 0938-0214
State Attestations	21	11	39	1	2.0000	78
Lump Sum Negotiations	21	1,260	2	1	60.0000	120
	58,207	1,017,914	57,227	248,018	240	754,788
			# respondents			57227
			Ave time per response			0.328592727654294
			Ave # responses per respondent			4
			Annual # responses			248018
			Annual hour burden			754,788

---

Sheet 2: 2010 Contracts&Pharmacies

Below are the results for 2010 Part D as of today.
# of Parent Organizations**	196
# of PDP Contract IDs	76
# of MAPD Contract IDs*	584
	39,000 chain + 17000 independent

---

Sheet 3: Beneficiary Information

				Total # Responses	# Respondents	Responses per respondent
Total N transactions for all sponsors (9/2007 - 10/2008)				37,510,000	196	191377.551020408
Total  estimated ATBT transactions				35,675,000	28	1274107.14285714
Total Eligibility Queries				43,550,000	55855	779.697430847731
Source:  TrOOP Facilitation Contractor/Deborah Larwood
% enrollees w/ other health insurance OHI	23%
# enrollees w/OHI	0

---

Sheet 4: ATBT separate calc.

Subpart	Original # Respondents	# responses	Time per response	2006 Estimate - Burden Hours	# Respondents (CY 2010 - 196 sponsors, 39 states)	# of Responses	Time per response (in hours)	2010 Revised Estimate - Burden hours	Exempt/Separate PRA
Programming for Automatic Troop Balance Transfer (ATBT) (New CY 2009)	n/a			0	196	1	40	7840
ATBT exchanges and updates transactions (New CY 2009)	n/a			0	196	55855	0.000138889	1520.49843862
					392	55856	40.000138889	9360.49843862