Crosswalk for 4th quarter Interim

L. Crosswalk for 4th Quarter Interim Cost Report.doc

Prepaid Health Plan Cost Report

Crosswalk for 4th quarter Interim

OMB: 0938-0165

Document [doc]
Download: doc | pdf

Revisions Crosswalk (Form 276-16)

4th Quarter Interim Cost Report


Note: In Changes to the Application column, the quoted words are what are to be entered.


Issue #

Page #

Section

Action to be performed

Changes to the Application

Reason for the Change

Worksheet S

Certification by Officer of the plan, Row 48

Remove language

Removed “…,except as noted” from the certification sentence.

This it to update the assertion, it should not include exceptions.

Worksheet S

Row 59

Change form number

Changed form number 276-08 to “276-16”.

To reflect the most recent change in the form number/year.

Worksheet S

Disclaimer, Row 63

Change line to read:

Old:

'24 hours to complete the budget forecast, 80 hours to complete the fourth quarter and final cost reports, and 12 hours to complete the first, second, and third quarterly reports;

New:

“'24 hours to complete the budget forecast, 80 hours to complete the 4th quarter and final cost reports, 4 hours to complete the semi-annual Interim, and 0 hours to complete the first,”

To reflect the updated cost report filing requirements.

Worksheet S

Disclaimer, Row 64

Change line to read:

Old:

and (2)for HCPPs, 16 hours to complete the budget forecast, 60 hours to complete the final cost report, and 8 hours to complete the mid-year report. If you have any comments

New:

“second, and third quarterly reports; and (2) for HCPPs, 16 hours to complete the budget forecast, 60 hours to complete the final cost report, and 4 hours to complete the semi-annual”

To reflect the updated cost report filing requirements.

Worksheet S

Disclaimer, Row 65

Change line to read:

Old:

concerning the accuracy of the time estimate(s) or suggestions for improving this form, please write to: CMS, 7500 Security Boulevard, N2-14-26, Baltimore, Maryland

New:

“interim report. If you have any comments concerning the accuracy of the time estimate(s) or suggestions for improving this form, please write to: CMS, 7500 Security Boulevard,”

To reflect the updated cost report filing requirements.

Worksheet S

Disclaimer, Row 66

Change line to read:

Old:

21244-1850 and to the Office of the Information and Regulatory Affairs, Office of Management and Budget, Washington, D.C. 20503.

New:

“Mail Stop C3-14-16, Baltimore, Maryland 21244-1850 and to the Office of the Information and Regulatory Affairs, Office of Management and Budget, Washington, D.C. 20503.”


To reflect the updated cost report filing requirements.

Worksheet D

Row 303

Change form number

Changed form number 276-08 to “276-16”.

To reflect the most recent change in the form number/year.

Worksheet E

Column COST CENTER, Lines 17-18

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet E

Column COST CENTER, Lines 20-23

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet E

Column COST CENTER, Line 16

Change line to read:

Changed the description to: “DED+CO pd by MAC”, reference to Carrier/Intermediaries was removed.


To reflect the correct 3rd party payer, CMS now refers to the Carrier and Intermediaries as MACs. Coinsurance is paid by the MACs.

Worksheet E

Column 5, Row 13

Add language

“See-WKST I Supp”.


To add a reference to a supplemental worksheet.

Worksheet E

Column 5, Header

Formatting

Changed font color from “black” to “red”.

Change font color to highlight the A&G allocation, and make a reference to a supplemental worksheet I.

Worksheet E

Column 7, Line 6

Change line to read:

Changed the reference from ' K | 2-6 to “ ' K | 3-5”.

To reflect the updated reference.

Worksheet E

Column 7, Line 7

Change line to read:

Changed the reference from ' K | 7 to “ ' K | 7-9”.

To reflect the updated reference.

Worksheet E

Column 7, Line 8

Change line to read:

Changed the reference from ' K | 8-10 to “ ' K | 11-13”.

To reflect the updated reference.

Worksheet E

Column 7, Line 9

Change line to read:

Changed the reference from ' K | 11-13 to “ ' K | 15-17”.

To reflect the updated reference.

Worksheet E

Column 7, Line 10

Change line to read:

Changed the reference from ' K | 14-15 to “ ' K | 18”.

To reflect the updated reference.

Worksheet E

Column 7, Line 11

Change line to read:

Changed the reference from ' K | 16 to “ ' K | 20”.

To reflect the updated reference.

Worksheet E

Column 7, Line 12

Change line to read:

Changed the reference from ' K | 17 to “ ' K | 21”.

To reflect the updated reference.

Worksheet E

Column 7, Line 14

Change line to read:

Changed the reference from ' K | 18 to “ ' K | 22”.

To reflect the updated reference.

Worksheet E

Column 7, Line 15

Change line to read:

Changed the reference from ' K | 19&20 to “ ' K | 24”.

To reflect the updated reference.

Worksheet E

Column 7, Line 19

Change line to read:

Changed the reference from ' L | 25 to “ ' L | 21”.

To reflect the updated reference.

Worksheet F

Page 5, Line 16

Change line to read:

“DED+CO pd by MAC”, reference to Carrier/Intermediaries was removed.

To reflect the correct 3rd party payer, Carrier & Intermediaries no longer pay the coinsurance.

Worksheet F

Page 5, Line 16a

Remove

Removed this line entirely

This line was incorrectly included here, will be deleted from other worksheets as well.

Worksheet G

Part I, Page 1, Line 23

Change line to read:

“Part B coinsurance on services paid by CMS's MAC”

To reflect the correct 3rd party payer, Carrier no longer pay the coinsurance.

Worksheet G

Part I, Page 1, Line 24

Remove

Removed this line entirely

This information is already reported on Worksheet G, Part I, Line 23.

Worksheet G

Part II, Page 5, Line 16

Change line to read:

Deleted reference to“DED+CO pd by MAC”,.

To reflect the correct 3rd party payer, Carrier & Intermediaries no longer pay the coinsurance.

Worksheet G

Part II, Page 5, Line 16a

Remove

Removed this line entirely

This line was incorrectly included here, will be deleted from other worksheets as well.

Worksheet H

Section A, Column C, Row 5

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section B, Column called LINE (Wkst E), Lines 1-16

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section B, Column 1, Lines 1-16

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section B, Column 2, Lines 1-16

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section B, Column 3, Lines 1-16

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section B, Column 4, Lines 1-16

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section B, (1), Row 30

Change line to read:

“Transfer the amounts in column 5 to Worksheet G, Part I, Column 2 lines 10”

To clarify what is to be transferred from this worksheet to Worksheet G.

Worksheet H

Section C, Column 1-6, Line 18

Add additional lines

Added lines 18-20

Added extra lines to account for additional related parties t

Worksheet H

Section C, Column 1-6, Lines 18-20

Lines 18-20 should look exactly like Lines 1-17 and perform the same functions in each column:

New Lines 18-20 by column: Columns 1-6 are data entry fields.

Adding extra space for additional related party transactions..

Worksheet H

Section C, Column 1, Lines 1-20

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section C, Column 2, Lines 1-20

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section C, Column 3, Lines 1-20

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section C, Column 4, Lines 1-20

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section C, Column 5, Lines 1-20

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section C, Column 6, Lines 1-20

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section C, Column C, Old Row 63, New Row 66

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet H

Section C, Column D, Old Row 63, New Row 66

Formatting

Changed font size from 8 to “7”.

Change font size to match the rest of the worksheet.

Worksheet H

Section C, Column D, Old Row 67, New Row 70

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet I

Part I, Column 1, Rows 10-13

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet I

Part I, Column 2, Rows 10-13

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet I

Part I, Column 3, Rows 10-13

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet I

Part I, Column 4, Rows 10-13

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet I

Part I, Column COST CENTER, Line 16

Change line to read:

“DED+CO pd by MAC”, reference to Carrier/Intermediaries was removed.

To reflect the correct 3rd party payer,. CMS now refers to the Carrier and Intermediaries as MACs. Coinsurance is paid by the MACs.

Worksheet I

Part II, Column 1, Rows 74-77

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet I

Part II, Column 2, Rows 74-77

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet I

Part II, Column 3, Rows 74-77

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet I

Part II, Column 4, Rows 74-77

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet I

Part II, Column COST CENTER, Line 16

Change line to read:

“DED+CO pd by MAC”, reference to Carrier/Intermediaries was removed.

To reflect the correct 3rd party payer,. CMS now refers to the Carrier and Intermediaries as MACs. Coinsurance is paid by the MACs.

Worksheet J

Page 1, Column 2, Line 1

Change formula

From Old ='Worksheet D'!N291 to

New “'Worksheet D'!N294”

Change the formula to pull the Medicare Primary member months, rather than Total member months.

Worksheet K

Column 1, Lines 1-33

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet K

Column 2, Lines 1-33

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet K

Column COST CENTER, Lines 1-33

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet K

Column 3, Lines 1-33

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet K

Column 4, Lines 1-33

Formatting

Changed font style from Helv to “Helvetica”.

Change font style to match the rest of the worksheet.

Worksheet K

Column COST CENTER, Line 23

Chang line to read:

Deleted the Cost Center name (left it blank as an input field).


Delete the name in the cost center 23 Professional component of Mental Health services as there is no need to link it to WS L as its not applicable.

Worksheet K

Column COST CENTER, Line 23

Formatting

Changed the background fill color to “Yellow”.


This will be an input field now, we want it to show it in yellow for consistency.

Worksheet K

Column COST CENTER, Line 24

Change line to read:

“Mental Health Svcs”


This line is revised to include cost portion for the professional and non-professional compensation paid that is in the total Mental Health.


Please note that the Mental Health limitation no longer exists as of 2014, and Medicare will pay outpatient mental health services at the same level as other standard Part B Services.

Worksheet K

Entire worksheet, Column C

Formatting

Increased Column C width from 35.2 to “40”.

This change will correct word cut off on line 36, the line reference was not showing.

Worksheet K

Column 4, Line 3

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I14”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 4

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I15”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 5

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I16”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 7

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I18”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 8

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I19”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 9

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I20”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 11

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I22”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 12

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I23”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 13

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I24”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 15

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I26”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 16

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I27”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 17

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I28”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 18

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I29”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 19

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I30”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 20

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I31”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 21

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I32”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 22

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I33”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 23

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I34”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 24

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits!I35”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 25

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I36”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 26

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I37”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 27

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I38”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 28

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I39”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 29

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I40”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 30

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I41”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 31

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I42”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 32

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits'!I43”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 33

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I44”


Formula is outdated and needs to be updated.

Worksheet K

Column 4, Line 34

Change formula

Replaced old formula in the field with the new one: “='Subpart E Limits-'!I45”


Formula is outdated and needs to be updated.

Worksheet K

Column 6, Line 18

Add formula

Added formula: “='Worksheet E'!K23”.

To directly link the field with another worksheet within the workbook.

Worksheet K

Column 6, Line 20

Add formula

Added formula: “='Worksheet E'!K24”.

To directly link the field with another worksheet within the workbook.

Worksheet K

Column 6, Line 21

Add formula

Added formula: “='Worksheet E'!K25”.

To directly link the field with another worksheet within the workbook.

Worksheet K

Column 6, Line 22

Add formula

Added formula: “='Worksheet E'!K28”.

To directly link the field with another worksheet within the workbook.

Worksheet K

Column 6, Line 24

Add formula

Added formula: “='Worksheet E'!K29”.

To directly link the field with another worksheet within the workbook.

Worksheet K

Column 6, Lines: 18, 20-22 and 24

Formatting

Locked cells

To protect the integrity of the links.

Worksheet K

Column 7, Lines 3 through 34

Change formula

Updated the formula with a new link

Formula is outdated and needs to be updated.

Worksheet L

Column 4, Line 1

Remove formula

Deleted the formula

Remove the formula to allow prepares to enter the non-medicare member months manually.

Worksheet L

Column 4, Line 1

Formatting

Changed the fill color from no color to “Yellow”.

This is an input field now, for consistency, we want it to show it in yellow.

Worksheet L

Column 4, Header

Change to read:

“NON-MEDICARE”.

Due to item #103, header needs to be modified.

Worksheet L

Column 5, Line 1

Add formula

Added formula to “=I14+M14”.

This change will add the Medicare (Part B) and non-Medicare, and show total member months.

Worksheet L

Column 5, Header

Change to read:

“TOTAL"

Col 2+Col 4”.

Due to item #106, header needs to be modified.

Worksheet L

Column 5, Line 1

Formatting

Changed the fill color from yellow to “No color/Blank”.

Change the fill color from yellow to blank as the field is now formula driven and plans do not need to enter anything here.

Worksheet L

Column DESCRIPTION, Line 3

Change line to read:

“Plan Administration (Wkst E, Col 6, Ln 25”.

Update the line to include the reference of the worksheet it is linked to.

Worksheet L

Column DESCRIPTION, Line 6

Change line to read:

“Special Admin Costs (Wkst E, Col 6, Ln 26)”.

Update the line to include the reference of the worksheet it is linked to.

Worksheet L

Column DESCRIPTION, Line 12

Change line to read:

“Part B Blood Deductible (Wkst E, Col 6, Line 18)”

Update the line to include the reference of the worksheet it is linked to.

Worksheet L

Column 2, Line 12

Add formula

Added formula “='Worksheet E'!K32”.

To directly link the field with another worksheet within the workbook.

Worksheet L

Column 2, Line 12

Formatting

Changed the fill color from yellow to “No color/Blank”.

Change the fill color from yellow to blank as the field is now formula driven and plans do not need to enter anything here.

Worksheet L

Column DESCRIPTION, Line 18

Change line to read:

“'Pt B DED paid by MAC (Wkst E, Col 6, Ln 16)”.

To reflect the correct 3rd party payer, Carrier and Intermediaries no longer pay the coinsurance.

Worksheet L

Line 21

Remove

Removed this line entirely

This is a CMS change in Mental Health Services Coinsurance Percentage. Note that the Mental Health limitation no longer exists as of 2014, and Medicare will pay outpatient mental health services at the same level as other standard Part B Services.

Worksheet L

Line 22

Remove

Removed this line entirely

This is a CMS change in Mental Health Services Coinsurance Percentage. Note that the Mental Health limitation no longer exists as of 2014, and Medicare will pay outpatient mental health services at the same level as other standard Part B Services.

Worksheet L

Line 23

Remove

Removed this line entirely

This is a CMS change in Mental Health Services Coinsurance Percentage. Note that the Mental Health limitation no longer exists as of 2014, and Medicare will pay outpatient mental health services at the same level as other standard Part B Services.

Worksheet L

Line 24

Remove

Removed this line entirely

This is a CMS change in Mental Health Services Coinsurance Percentage. Note that the Mental Health limitation no longer exists as of 2014, and Medicare will pay outpatient mental health services at the same level as other standard Part B Services.

Worksheet L

Old line 25

Move line

Old Line 25 –“Part B Cost Not Subject to Coinsurance)” was moved to Line “21”.

Due to the removal of Lines 21 to 24 on Worksheet L as outlined above, Line 25 needs to be renumbered and moved to a new Line 21.

Worksheet L

New Line 21

Change line to read:

“Part B Cost Not Subject to Coinsurance (Wkst E, Col 6, Ln 19)”.

Adding Worksheet E reference.

Worksheet L

Old line 25

Change formula

Changed formula to“='Worksheet E'!K33”.

Due to the removal of Lines 21 to 24 on Worksheet L as outlined above , Line 25 needs to be relinked.

Worksheet L

Old Line 25, New Line 21

Change numbering to:

“21” This change occurred on the far left side of this line.

Due to the removal of Lines 21 to 24 on Worksheet L as outlined above , Line 25 needs to be renumbered and moved to a new Line 21.

Worksheet L

Old line 26

Move line

Old Line 26 –“Cost PMPM (Line 25 / Line 1)” was moved to Line “22”.

Due to the removal of Lines 21 to 24 on Worksheet L as outlined above , Line 26 needs to be renumbered and moved to a new Line 22.

Worksheet L

Old Line 26, New Line 22

Change numbering to:

“22” This change occurred on the far left side of this line.

Due to the removal of Lines 21 to 24 on Worksheet L as outlined above , Line 26 needs to be renumbered and moved to a new Line 22.

Worksheet L

Old Line 26, New Line 22

Change line to read:

“Cost PMPM (Line 21 / Line 1)”.

Due to the removal of Lines 21 to 24 on Worksheet L as outlined above , line reference within the parentheses needs to be revised to include the correct line#.

Worksheet M

Worksheet M, Line 5a

Change line to read:

“DED paid by MAC“

To reflect the correct 3rd party payer, Carrier & Intermediaries no longer pay the coinsurance.

Worksheet M

Worksheet M, Line 11

Remove

Removed this line entirely

This is a CMS change in Mental Health Services Coinsurance Percentage. Note that the Mental Health limitation no longer exists as of 2014, and Medicare will pay outpatient mental health services at the same level as other standard Part B Services.

Worksheet M

Old line 12, New Line 11

Move line

Old Line 12 – “Line 7 Minus (The Sum of Lines 8 - 11)” was moved to Line 11.

Due to issue pertaining to the removal of, Line 11 on Worksheet M as outlined above, Line 12 needs to be renumbered and moved to a new Line 11.

Worksheet M

Old Line 12, New Line 11

Change numbering to:

“11” This change occurred on the far left side of this line.

Due to issue pertaining to the removal of, Line 11 on Worksheet M as outlined above, Line 12 needs to be renumbered and moved to a new Line 11.

Worksheet M

Old line 12, New Line 11

Change line to read:

“Line 7 Minus (The Sum of Lines 8 - 10)”.

Due to issue pertaining to the removal of, Line 11 on Worksheet M as outlined above, line reference within the parentheses needs to be revised to include the correct line#.

Worksheet M

Old line 12, New Line 11, Column 2

Change formula

Changed formula to: “=H16-SUM(H18:H20)”


Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, formula needs to be updated.

Worksheet M

Old line 12, New Line 11, Column 3

Change formula

Changed formula to: “=J16-SUM(J18:J20)”

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, formula needs to be updated.

Worksheet M

Old line 13, New Line 12

Move line

Old Line 13 – “20% of (Col 3 Line 12 minus Col 3 Line 3)” was moved to Line 12.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, Line 13 needs to be renumbered and moved to a new Line 12.

Worksheet M

Old line 13, New Line 12

Change numbering to:

“12” This change occurred on the far left side of this line.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, Line 13 needs to be renumbered and moved to a new Line 12.

Worksheet M

Old Line 13, New Line 12, Column 3

Change formula

Changed formula to: “=ROUND((J22-J10)*0.2,4)”

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, formula needs to be updated.

Worksheet M

Old Line 13, New Line 12, Column 4

Change formula

Changed formula to: “=J24”.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, formula needs to be updated.

Worksheet M

Old Line 13, New Line 12

Formatting

Locked cells

To protect the integrity of the links.

Worksheet M

Old line 13, New Line 12

Change line to read:

“20% of (Col 3 Line 11 minus Col 3 Line 3)”.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, line reference within the parentheses needs to be revised to include the correct line#.

Worksheet M

Old line 14, New Line 13

Move line

Old Line 14 – “Reimbursable Costs (Line 12 Minus Line 13)” was moved to Line 13.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, Line 14 needs to be renumbered and moved to a new Line 13.

Worksheet M

Old line 14, New Line 13

Change numbering to:

“13” This change occurred on the far left side of this line.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, Line 14 needs to be renumbered and moved to a new Line 13.

Worksheet M

Old Line 14, New Line 13, Column 2

Change formula

Changed formula to: “=H22-H24”.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, formula needs to be updated.

Worksheet M

Old Line 14, New Line 13, Column 3

Change formula

Changed formula to: “=J22-J24”.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, formula needs to be updated.

Worksheet M

Old Line 14, New Line 13, Column 4

Change formula

Changed formula to: “H26+J26”.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, formula needs to be updated.

Worksheet M

Old line 14, New Line 13

Change line to read:

“Reimbursable Costs (Line 11 Minus Line 12)”.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, line reference within the parentheses needs to be revised to include the correct line#.

Worksheet M

Old line 15, New Line 14

Move line

Old Line 15 – “Special Administrative Costs“ was moved to Line 14.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, Line 15 needs to be renumbered and moved to a new Line 14.

Worksheet M

Old line 15, New Line 14

Change numbering to:

“14” This change occurred on the far left side of this line.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, Line 15 needs to be renumbered and moved to a new Line 14.

Worksheet M

Old line 16, New Line 15

Move line

Old Line 16 – “Medicare Bad Debt “moved to Line 15.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, Line 16 needs to be renumbered and moved to a new Line 15.

Worksheet M

Old line 16, New Line 15

Change numbering to:

“15” This change occurred on the far left of this line.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, Line 16 needs to be renumbered and moved to a new Line 15.

Worksheet M

Old line 16a, New Line 16

Change numbering to:

“16” This change occurred on the far left side of this line.

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, Line 16a needs to be renumbered and moved to a new Line 16.

Worksheet M

Old line 16a, New Line 16, Column 3

Change formula

Changed formula to “='Worksheet L'!K35”

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, formula needs to be updated.

Worksheet M

New Line 16, Column 1

Change line to read:

Added “L”.

Add a reference to another worksheet.

Worksheet M

Line 17

Change line to read:

“Total (Sum Lines 13 thru 16)”

Due to issue pertaining to the removal of Line 11 on Worksheet M as outlined above, line reference within the parentheses needs to be revised to include the correct line#.

Worksheet M

Line 22

Change line to read:

“Interim Payments (by) to CMS”

To reflect the correct agency name.

Worksheet M

Line 23

Change line to read:

“Balance (Line 21 plus Line 22)”.

Change the operation from minus to plus, since payments from CMS are entered as a negative number. There is no need to update the formula, since the formula is already adding the numbers.

Worksheet M

Description, Line 23, Old Row 41, New Row 40

Change line to read:

“Adjustments”

Due to issue #127 row number has changed. Also, changed the description to allow the plans to enter various adjustments (not restricting them to prior year only).

Worksheet M

Description, Line 23, Old Row 43-45, New Row 44-46

Add additional lines:

Added lines 27-29 should be added.

Added extra space for additional adjustments.

Worksheet M

Description, Line 23, Rows 44-46

Lines 27-29 should look exactly like Lines 24-26 and perform the same functions in each column

New Lines 27-29 by column: Column 4 is data entry field.

Adding extra space for additional adjustments.

Worksheet M

Old Line 27, New Line 30

Move line

Old Line 27 – “Balance Due Plan (CMS) (Line 23 + or - Lines 24-26)” was moved to Line 30.

Due to issue #156, Line 27 needs to be renumbered and moved to a new Line 30.

Worksheet M

Old Line 27, New Line 30

Change line to read:

“Balance Due Plan (CMS) (Line 23 + or - Lines 24-29)”

Due to issue #156, Line 27 needs to be renumbered and moved to a new Line 30.

Worksheet M

Old Line 27, New Line 30

Change numbering to:

“30” This change occurred on the far left side of this line.

Due to issue #156, Line 27 needs to be renumbered and moved to a new Line 30.

Worksheet M

Old Line 27, New Line 30, Column 4

Change formula

Changed formula to: “=L39+L41+L42+L43+L44+L45+L46”

Formula updated to include additional cells due to line additions (lines 27-29).

Worksheet L

Line 7, Column 6

Change line to read:

“M 14”

Due to changes to worksheet M, references on worksheet L must be updated.

Worksheet L

Line 10, Column 6

Change line to read:

“M 15”

Due to changes to worksheet M, references on worksheet L must be updated.

Worksheet L

Line 22, Column 6

Change line to read:

“M 16”

Due to changes to worksheet M, references on worksheet L must be updated.

Worksheet N

Entire worksheet

Formatting

Changed the print orientation from Landscape to “Portrait”.

Changing print orientation for consistency.

Worksheet N

Line 8a

Change line to read:

“a. Deductible and copayments (Worksheet M, Col 2 + 3 , Sum lines 8 thru 10)”.

Due to changes to worksheet M, references on worksheet N must be updated.

Worksheet N

Line 8a

Change formula:

Changed formula to: “=SUM('Worksheet M'!L18:L20)”.

Due to changes to worksheet M, references on worksheet N must be updated.

Worksheet N

Line 8b

Change line to read:

“b. Part B Coinsurance (Worksheet M, Col 3, Line 12)”.

Due to changes to worksheet M, references on worksheet N must be updated.

Worksheet N

Line 8b

Change formula:

Changed formula to: “='Worksheet M'!J24 “.

Due to changes to worksheet M, references on worksheet N must be updated.

Worksheet N

Line 8c

Change line to read:

“c. CO paid by MAC (Worksheet G, Col 2, Line 23/Col 2, Ln 0)

To reflect the correct 3rd party payer, Carrier & Intermediaries no longer pay the coinsurance.

Worksheet N

Line 9a, Header

Spelling correction

Changed the word Involuntery to”Involuntary”.

To correct a spelling error.

Worksheet N

Line 9c, Column 1

Formatting

Changed decimal spaces from 5 to “4”.

Per instructions, fields are limited to 4 decimal spaces.

Worksheet N

Line 9c, Header

Formatting

Changed the format from Custom to Number, with Negative number and 0 decimal places.

This field represents total $s, not PMPM; therefore, formatting was updated to reflect that.

Worksheet N

Line 11, Column 3

Formatting

Changed the format from General to Number, with Negative number and 4 decimal places.

Per instructions, fields are limited to 4 decimal spaces.

Old Subpart E Limits

Entire worksheet

Delete the Old Subpart E Limits

Removed the Old tab.

Due to changes made to various worksheets, we are adding and re-linking a revised Subpart E worksheet.

New Subpart E Limits

Entire worksheet

Add a New ‘Subpart E Limits”

Added a new tab called “Subpart E Limits” to the workbook, following the Special Administration Costs tab.

Due to changes made to various worksheets, we are adding a revised Subpart E worksheet.

H-Part C, supplemental

Entire worksheet

Add a new worksheet in a separate tab.

Added a new tab called “H-part C, supplemental” and copy the Header (Rows 1-3) and Part/Section C from Worksheet H

This is to allow more space for plans with multiple related party transactions.

H-Part C, supplemental

Entire worksheet

Add new lines:

Added lines “21 to 69”.

This is to allow more space for plans with multiple related party transactions.

I -Supplemental Descriptions

Entire worksheet

Add a new worksheet in a separate tab.

Added a new tab called “I-Supplemental Descriptions”.

This tab will provide justifications for excessive A&G costs.


Page 20 of 20

File Typeapplication/msword
File TitleIssue #
AuthorCMS
Last Modified ByBilal Farrakh
File Modified2015-10-29
File Created2015-10-29

© 2024 OMB.report | Privacy Policy