508_Compliant_CMS-10142 Attachment C, BPT changes

Attachment C
Paperwork Reduction Act Submission
OMB # 0938 – 0944
CMS-10142
Summary of Changes
The following revisions are in response to Lessons Learned feedback (from industry, bid
reviewers and internal CMS) and contract year 2012 effective provisions of the Medicare
Advantage and Prescription Drug Program. They do not result in a change to the
estimated burden.

1) Updated labels: Annual update of labels/parameters (ex: CY2011 → CY2012).
Locations: PD Worksheet 1 cell N3, F5, C29:C32
PD Worksheet 7 cell B9, C10:C12
MA Worksheet 1 cell Q3, D8
MA Worksheet 4 cell AH20:AH24
MA Worksheet 5 cell L16
MA Worksheet 6 cell E14
MSA Worksheet 1 cell P3, D8
MSA Worksheet 4 cell H48, H53
MA Ratebook sheet (used in MA Workbook 5)
MA Statutory Rates sheet (used in MA Workbook 5)
MSA Ratebook sheet (used in MSA Workbook 3)
Reason: Update BPT to reference Contract Year 2012 information.
2) Change input cells to be non-input (calculated) cells.
Locations: PD Worksheet 1 cell I11
MA Worksheet 1 cell G55, G56, G59
MA Worksheet 6 cell L25, L26
Reason: To improve accuracy/clarity of BPT for CY2012.
3) Remove input cells.
Locations: PD Worksheet 1 cell I15
PD Worksheet 3 cell J26
MA Worksheet 1 cell G58, G60
Reason: To improve accuracy/clarity of BPT for CY2012.
4) Remove non-input (calculated) cells.
Locations: PD Worksheet 3 cell N31
Reason: To improve accuracy/clarity of BPT for CY2012.

Page 1 of 2

5) Revise formula logic in non-input (calculated) cells.
Locations: PD Worksheet 3 cell I33, J33, N33
PD Worksheet 4 cell K33
PD Worksheet 5 cell K36
MA Worksheet 2 cell O20:O36
MA Worksheet 4 cell K20, K21
MA Worksheet 5 cell M16, E24, M36
Reason: To improve accuracy/clarity of BPT for CY2012.
6) Add non-input (calculated) cells.
Locations: PD Worksheet 3 cell L12
PD Worksheet 4 cell E61
PD Worksheet 5 cell G73
PD Worksheet 6A cell F11:K21, F35:K35, F49:K49, E53, E54
PD Worksheet 7 cell F30
MA Worksheet 1 cell Q8, D57:F57, F61:G61, D64:G65, G66:G67
MA Worksheet 5 cell L26
Reason: To improve accuracy/clarity of BPT for CY2012.
7) Add input cells.
Locations: PD Worksheet 6A cell F25:K34, F39:K48
MA Worksheet 1 cell D55:F56, D59:F59, D61:E61
MA Worksheet 3 cell H67, K67, N67
MA Worksheet 5 cell L24, L25
MA Worksheet 5 cell R13, R14
MSA Worksheet 3 cell I12
Reason: To improve accuracy/clarity of BPT for CY2012.
8) Revise labels.
Locations: MA Worksheet 1 cell N24, N25
MA Worksheet 3 cell D36
MA Worksheet 4 cell O124, O125
Reason: To improve accuracy/clarity of BPT for CY2012.

Page 2 of 2