Docstoc

Medicaid Budget Estimates 2011-12

Document Sample
Medicaid Budget Estimates 2011-12 Powered By Docstoc
					         Document



Double Click above for the W ord file
DEPARTMENT OF HEALTH AND HUMAN SERVICES
DIVISION OF MEDICAL ASSISTANCE
BUDGET MANAGEMENT


                        DEPARTMENT OF HEALTH AND HUMAN SERVICES DIVISION OF MEDICAL ASSISTANCE
                     SFY 2012 PROJECTED MEDICAID PROGRAM SERVICES EXPENDITURES (BC 14445, FUND 1310)

                      NCAS                                                                        SFY                                  SFY
         COS        ACCOUNT                                                SFY 2012          2012FEDERAL          SFY 2012         2012COUNTY
       NUMBER       NUMBER                        DESCRIPTION           REQUIREMENTS            SHARE           STATE SHARE           SHARE

           015         536101      HOSPITAL INPATIENT GENERAL           $   1,003,453,898    $   701,905,967    $   301,547,931    $             -
           019         536102      HOSPITAL INPATIENT SPECIALTY         $      11,322,933    $     7,920,278    $     3,402,655    $             -
           017         536103      HOSPITAL INPT MENTAL SO < 21         $      21,141,731    $    14,788,429    $     6,353,302    $             -
           043         536104      HOSPITAL OUTPT MENTAL SO <21         $          38,135    $        26,675    $        11,460    $             -
           041       536105001     HOSPITAL INPT MENTAL NSO < 21        $      70,493,821    $    49,309,723    $    21,184,098    $             -
           058       536105002     HOSP INPT-MTL, NSO > 65              $           3,655    $         2,556    $         1,098    $             -
           018         536106      HOSP INPT-MTL, SO > 65               $       6,891,721    $     4,820,690    $     2,071,031    $             -
           025         536107      HOSP OUTPT-MTL, SO >65               $               -    $             -    $             -    $             -
           044         536108      HOSP OUTPT-MTL, NSO                  $               -    $             -    $             -    $             -
           035         536109      LTC NURSING FACILITY                 $   1,219,064,481    $   852,899,802    $   366,164,678    $             -
           036         536110      NF SNF SWING BEDS                    $         494,333    $       345,781    $       148,552    $             -
           020         536111                                           $      11,884,707    $     8,313,234    $     3,571,473    $             -
           022         536112      NF ICF SWING BEDS                    $          11,828    $         8,273    $         3,554    $             -
           047         536113      LTC ICF MRC NSO                      $     233,318,385    $   163,203,877    $    70,114,508    $             -
           021         536114      LTC ICF MRC SO                       $     253,906,798    $   177,605,266    $    76,301,532    $             -
           027         536115      PHYSICIAN                            $   1,155,617,634    $   808,342,979    $   347,274,655    $             -
           007         536116      DENTAL                               $     407,917,860    $   285,334,464    $   122,583,396    $             -
           029         536117      OPTICAL SUPPLIES                     $      10,748,502    $     7,518,469    $     3,230,032    $             -
           028         536118      CHIROPRACTIC                         $         550,776    $       385,263    $       165,514    $             -
           030         536119      OPTICAL                              $      11,625,712    $     8,132,069    $     3,493,643    $             -
           046         536120      PODIATRY                             $       3,399,285    $     2,377,766    $     1,021,519    $             -
           016         536121      HOSPITAL OUTPATIENT GENERAL          $     477,307,784    $   333,872,022    $   143,435,762    $             -
           045         536122      HOSPITAL OUTPATIENT SPECIALITY       $       2,578,454    $     1,803,603    $       774,851    $             -
           004         536123      CLINICS MENTAL HEALTH                $     139,306,213    $    97,443,303    $    41,862,910    $             -
           003         536124      CLINICS HEALTH DEPT                  $      48,678,997    $    34,050,472    $    14,628,525    $             -
           002         536125      CLINICS FREE STANDING                $      56,070,593    $    39,220,819    $    16,849,774    $             -
           006         536126      CLINICS RURAL HEALTH                 $      15,458,044    $    10,812,747    $     4,645,297    $             -
           080         536127      CAP AIDS                             $           2,188    $         1,530    $           657    $             -
           023         536128      LABORATORY AND RADIOLOGY             $      67,459,507    $    47,187,250    $    20,272,256    $             -
           014         536129      HOME HEALTH                          $     129,992,086    $    90,928,164    $    39,063,922    $             -
           032         536130      PRESCRIBED DRUGS                     $   1,151,572,394    $   805,513,374    $   346,059,020    $             -
           024         536132      FAMILY PLANNING STERILIZATION        $      11,789,014    $    10,610,113    $     1,178,901    $             -
           010         536133      FAMILY PLANNING HOSPITAL INPT        $          22,103    $        19,893    $         2,210    $             -
           011         536134      FAMILY PLANNING HOSPITAL OUTPT       $          29,367    $        26,430    $         2,937    $             -
           012         536135      FAMILY PLANNING PHYSICIAN            $      14,424,002    $    12,981,602    $     1,442,400    $             -
           038         536136      FAMILY PLANNING HEALTH DEPT          $       7,997,791    $     7,198,012    $       799,779    $             -
           008         536137      FAMILY PLANNING FREE STANDING        $               -    $             -    $             -    $             -
           081         536138      HIV CASE MANAGEMENT                  $       3,727,281    $     2,607,196    $     1,120,085    $             -
           033         536139      HEALTH CHECK HEALTH DEPT             $       9,737,980    $     6,811,619    $     2,926,360    $             -
           105         536140      PART B BUY-IN NON CASH               $      27,489,216    $    19,228,432    $     8,260,784    $             -
           106         536141      PART B BUY-IN CAT NEEDY              $               -    $             -    $             -    $             -
           001         536142      AMBULANCE                            $      42,214,833    $    29,528,853    $    12,685,979    $             -
           013         536143      HEARING AIDS                         $       1,185,836    $       829,481    $       356,356    $             -
           053         536144      PERSONAL CARE SERVICES               $     100,971,737    $    70,628,720    $    30,343,017    $             -
           073         536145      HEALTH CHECK-INDIAN HEALTH           $               -    $             -    $             -    $             -
           061         536146      HEALTH CHECK RURAL HEALTH CTR        $       1,050,334    $       734,698    $       315,636    $             -
           034         536147      HEALTH CHECK OTHER PROVIDER          $      68,884,817    $    48,184,240    $    20,700,576    $             -
           037         536148      FAMILY PLANNING RURAL HLTH CTR       $          87,461    $        78,715    $         8,746    $             -
           031         536149      FAMILY PLANNING DRUGS                $      20,077,924    $    18,070,132    $     2,007,792    $             -
           069         536151      CASE MANAGEMENT NFP                  $              (1)   $            (1)   $            (0)   $             -
           049         536152      HOSPITAL INPT LONG TERM CARE         $         (10,529)   $        (7,365)   $        (3,164)   $             -
           084         536153      HIGH RISK INTERVENTION               $     103,100,213    $    72,117,568    $    30,982,645    $             -
           050         536154      HOSPITAL EMERGENCY ROOM              $     304,521,653    $   213,009,851    $    91,511,802    $             -
           071         536155      NF HEAD LEVEL OF CARE                $       1,072,971    $       750,532    $       322,438    $             -
           051         536156      HOSPITAL INPATIENT CROSSOVERS        $      11,985,511    $     8,383,745    $     3,601,766    $             -
           072         536157      NF VENT LEVEL OF CARE                $       8,913,696    $     6,235,041    $     2,678,655    $             -
           052         536158      HOSPITAL OUTPATIENT CROSSOVERS       $       2,731,673    $     1,910,778    $       820,895    $             -
           055       536159001     CAP DISABLED                         $     264,719,369    $   185,168,552    $    79,550,818    $             -
           085       536159002     CAP CHOICE                           $       1,379,672    $       965,066    $       414,605    $             -
           056         536160      CAP MENTALLY RETARDED                $     496,657,834    $   347,407,188    $   149,250,646    $             -
           057         536161      CAP CHILDREN                         $      54,375,819    $    38,035,341    $    16,340,477    $             -
           062         536162      CASE MANAGEMENT FSO                  $       5,390,336    $     3,770,486    $     1,619,850    $             -
           063         536163      LOCAL EDUCATION AGENCIES FSO         $      12,057,575    $     8,434,153    $     3,623,422    $             -


313c19c6-fdbf-4259-aa64-678ad2ed1524.xls SFY 2012 PROJECTED        Page 2 of 11                                                        1/2/2012 3:18 PM rhc
DEPARTMENT OF HEALTH AND HUMAN SERVICES
DIVISION OF MEDICAL ASSISTANCE
BUDGET MANAGEMENT


                        DEPARTMENT OF HEALTH AND HUMAN SERVICES DIVISION OF MEDICAL ASSISTANCE
                     SFY 2012 PROJECTED MEDICAID PROGRAM SERVICES EXPENDITURES (BC 14445, FUND 1310)

                      NCAS                                                                   SFY                                SFY
         COS        ACCOUNT                                             SFY 2012        2012FEDERAL         SFY 2012        2012COUNTY
       NUMBER       NUMBER                        DESCRIPTION        REQUIREMENTS          SHARE          STATE SHARE          SHARE

                      536164  GROUP HEALTH PLANS                     $      3,966,186   $     2,774,307   $     1,191,879   $             -
           054        536165  DURABLE MEDICAL EQUIPMENT              $    118,741,991   $    83,058,835   $ 35,683,156      $             -
           009        536166  NF SNF SWING VENT CARE                 $              -   $             -   $             -   $             -
           005        536167  HOSPITAL INPATIENT VENT CARE           $              -   $             -   $             -   $             -
           064        536168  CLINICS-DHS IMMUNIZATIONS              $              -   $             -   $             -   $             -
           070        536169  PRACTITIONER NOT PHYSICIAN             $    668,588,674   $   467,671,092   $ 200,917,583     $             -
           078        536170  HMO PREMIUMS                           $    175,541,049   $   122,789,208   $ 52,751,841      $             -
           059        536171  HOME INFUSION THERAPY                  $      9,063,257   $     6,339,657   $     2,723,599   $             -
           060        536172  HOSPICE                                $     65,034,145   $    45,490,734   $ 19,543,411      $             -
           101        536173  PART A MEDICARE SUB-TOTAL              $     60,692,507   $    42,453,802   $ 18,238,705      $             -
           107        536174  PART B BUY-IN MQBQ                     $              -   $             -   $             -   $             -
           108        536175  PART B BUY-IN DUAL Q                   $    332,693,686   $   232,715,906   $ 99,977,779      $             -
           110      536176001 PART B BUY-IN MQBB                     $              -   $             -   $             -   $             -
           111      536176002 PART B BUY-IN DUAL B                   $              -   $             -   $             -   $             -
                      536177  CLINICS FQHC CORE & AMBULATORY         $     35,509,998   $    24,838,889   $ 10,671,110      $             -
           065        536178  FAMILY PLANNING FQHC                   $        407,411   $       366,670   $        40,741   $             -
           066        536179  HEALTH CHECK FQHC                      $      3,741,446   $     2,617,104   $     1,124,342   $             -
           067        536180  PARTIAL RATE INCREASES (SFY 2008)      $              -   $             -   $             -   $             -
           068        536181  HOSP INPATIENT INDIAN HEALTH           $        393,392   $       393,392   $             -   $             -
           040        536182  HOSP OUTPATIENT INDIAN HEALTH          $      2,600,927   $     2,600,927   $             -   $             -
           042        536183  NF INDIAN HEALTH                       $      1,925,677   $     1,925,677   $             -   $             -
           039        536184  ACF PCS BASIC                          $    136,621,596   $    95,565,440   $ 41,056,156      $             -
           075        536185  ACF PCS ENHANCED                       $     36,213,120   $    25,330,716   $ 10,882,405      $             -
           083        536186  HOME HEALTH INDIAN HEALTH              $         30,688   $        30,688   $             -   $             -
           026        536187  AMBULATORY SURGERY CENTER              $     15,543,070   $    10,872,222   $     4,670,848   $             -
           048        536188  COUNTY TRANSPORTATION                  $     37,922,115   $    26,526,140   $ 11,395,975      $             -
                      536189  ACF TRANSPORTATION                     $      4,400,096   $     3,077,823   $     1,322,273   $             -
           074        536190  PART D PAYMENTS                        $    253,845,892   $             -   $ 253,845,892     $             -
                      536191  PARTIAL PAYMENTS                       $        100,420                     $       100,420   $             -
                      536195  PART B MQBE BUYIN                      $     23,131,868                     $ 23,131,868      $             -
                      536196  REFUGEES                               $      1,907,474   $     1,907,474   $             -   $             -
                   TOTAL REQUIREMENTS                                $ 10,075,514,624   $ 6,867,140,623   $ 3,208,374,001   $             -




313c19c6-fdbf-4259-aa64-678ad2ed1524.xls SFY 2012 PROJECTED     Page 3 of 11                                                    1/2/2012 3:18 PM rhc
DEPARTMENT OF HEALTH AND HUMAN SERVICES
DIVISION OF MEDICAL ASSISTANCE
BUDGET MANAGEMENT

                                   SFY 2012 FINANCIAL PARTICIPATION RATES

                        (THESE ARE THE RATES THAT RESULT FROM THE BLENDING OF DIFFERENT MATCH RATES FOR
                           NORMAL PROGRAM AID CATEGORIES AND THOSE WITH SPECIAL OR ENHANCED FMAP)
                                                    SFY 2012               ENHANCED
                                                                            SFY 2012           SFY 2012    SFY 2012
  COS           CATEGORY OF SERVICE             REGULAR FEDERAL             FEDERAL                         STATE
NUMBER              DESCRIPTION                     FP RATE                 FP RATE         PROVIDER TAX   FP RATE

   015     HOSP INPT-GENERAL                          0.69949                  0.0000            0.0000    0.3005
   019     HOSP INPT-SPECIALITY                       0.69949                  0.0000            0.0000    0.3005
   017     HOSP INPT-MTL, SO < 21                     0.69949                  0.0000            0.0000    0.3005
   043     HOSP OUTPT-MTL, SO <21                     0.69949                  0.0000            0.0000    0.3005
   041     HOSP INPT-MTL, NSO < 21                    0.69949                  0.0000            0.0000    0.3005
   058     HOSP INPT-MTL, NSO > 65                    0.69949                  0.0000            0.0000    0.3005
   018     HOSP INPT-MTL, SO > 65                     0.69949                  0.0000            0.0000    0.3005
   025     HOSP OUTPT-MTL, SO >65                     0.69949                  0.0000            0.0000    0.3005
   044     HOSP OUTPT-MTL, NSO                        0.69949                  0.0000            0.0000    0.3005
   035     LTC-SNF SO AND NSO                         0.69949                  0.0000            0.0000    0.3005
   036     NF-SNF SWING BEDS                          0.69949                  0.0000            0.0000    0.3005
   020     LTC-ICF SO AND NSO                         0.69949                  0.0000            0.0000    0.3005
   022     NF-ICF SWING BEDS                          0.69949                  0.0000            0.0000    0.3005
   047     LTC-ICF MRC, NSO                           0.69949                  0.0000            0.0000    0.3005
   021     LTC-ICF MRC, SO                            0.69949                  0.0000            0.0000    0.3005
   027     PHYSICIAN                                  0.69949                  0.0000            0.0000    0.3005
   007     DENTAL                                     0.69949                  0.0000            0.0000    0.3005
   029     OPTICAL SUPPLIES                           0.69949                  0.0000            0.0000    0.3005
   028     CHIROPRACTIC                               0.69949                  0.0000            0.0000    0.3005
   030     OPTICAL                                    0.69949                  0.0000            0.0000    0.3005
   046     PODIATRY                                   0.69949                  0.0000            0.0000    0.3005
   016     HOSP OUTPT-GENERAL                         0.69949                  0.0000            0.0000    0.3005
   045     HOSP OUTPT-SPECIALITY                      0.69949                  0.0000            0.0000    0.3005
   004     CLINICS-MENTAL HEALTH                      0.69949                  0.0000            0.0000    0.3005
   003     CLINICS-HEALTH DEPT                        0.69949                  0.0000            0.0000    0.3005
   002     CLINICS-FREE STANDING                      0.69949                  0.0000            0.0000    0.3005
   006     CLINICS-RURAL HEALTH                       0.69949                  0.0000            0.0000    0.3005
   080     CAP AIDS                                   0.69949                  0.0000            0.0000    0.3005
   023     LAB AND X-RAY                              0.69949                  0.0000            0.0000    0.3005
   014     HOME HEALTH                                0.69949                  0.0000            0.0000    0.3005
   032     PRESCRIBED DRUGS                           0.69949                  0.0000            0.0000    0.3005
   024     FAMILY PLAN-STERILIZATION                  0.9000                   0.0000            0.0000    0.1000
   010     FAMILY PLAN-HOSP INPT                      0.9000                   0.0000            0.0000    0.1000
   011     FAMILY PLAN-HOSP OUTPT                     0.9000                   0.0000            0.0000    0.1000
   012     FAMILY PLAN-PHYSICIAN                      0.9000                   0.0000            0.0000    0.1000
   038     FAMILY PLAN-HEALTH DEPT                    0.9000                   0.0000            0.0000    0.1000
   008     FAMILY PLAN-FREE STANDING                  0.9000                   0.0000            0.0000    0.1000
   081     HIV CASE MANAGEMENT                        0.69949                  0.0000            0.0000    0.3005
   033     HEALTH CHECK-HEALTH DEPT                   0.69949                  0.0000            0.0000    0.3005
   105     PART B BUY-IN NON CASH                     0.69949                  0.0000            0.0000    1.0000
   106     PART B BUY-IN CAT NEEDY                    0.69949                  0.0000            0.0000    0.3005
   001     AMBULANCE                                  0.69949                  0.0000            0.0000    0.3005
   013     HEARING AIDS                               0.69949                  0.0000            0.0000    0.3005
   053     PERSONAL CARE                              0.69949                  0.0000            0.0000    0.3005
   073     HEALTH CHECK-INDIAN HEALTH                 1.0000                   0.0000            0.0000    0.0000
   061     HEALTH CHECK-RURAL HLTH CTR                0.69949                  0.0000            0.0000    0.3005
   034     HEALTH CHECK-OTHER PROV                    0.69949                  0.0000            0.0000    0.3005
   037     FAMILY PLAN-RURAL HLTH CTR                 0.9000                   0.0000            0.0000    0.1000
   031     FAMILY PLAN-DRUGS                          0.9000                   0.0000            0.0000    0.1000
   069     CASE MANAGEMENT-NFP                        0.69949                  0.0000            0.0000    0.3005
   049     HOSP INPT-LONG TERM CARE                   0.69949                  0.0000            0.0000    0.3005
   084     HIGH RISK INTERVENTION                     0.69949                  0.0000            0.0000    0.3005
   050     HOSP OUTPT-EMERGENCY ROOM                  0.69949                  0.0000            0.0000    0.3005
   071     NF-HEAD LEVEL OF CARE                      0.69949                  0.0000            0.0000    0.3005
   051     HOSP INPT-GENERAL-XOVERS                   0.69949                  0.0000            0.0000    0.3005
   072     NF-VENT LEVEL OF CARE                      0.69949                  0.0000            0.0000    0.3005
   052     HOSP OUTPT-GENERAL-XOVERS                  0.69949                  0.0000            0.0000    0.3005
   055     CAP-DISABLED                               0.69949                  0.0000            0.0000    0.3005
   085     CAP CHOICE                                 0.69949                  0.0000            0.0000    0.3005
   056     CAP-MENTALLY RETARDED                      0.69949                  0.0000            0.0000    0.3005
   057     CAP-CHILDREN                               0.69949                  0.0000            0.0000    0.3005
   062     CASE MANAGEMENT-FSO                        0.69949                  0.0000            0.0000    0.3005
   063     LOCAL EDUCATION AGENCIES-FSO               0.69949                  0.0000            0.0000    0.3005

313c19c6-fdbf-4259-aa64-678ad2ed1524.xls
SFY 2012 BLENDED SHARES                                         Page 4 of 11                                    1/2/2012 3:18 PM
DEPARTMENT OF HEALTH AND HUMAN SERVICES
DIVISION OF MEDICAL ASSISTANCE
BUDGET MANAGEMENT

                                   SFY 2012 FINANCIAL PARTICIPATION RATES

                        (THESE ARE THE RATES THAT RESULT FROM THE BLENDING OF DIFFERENT MATCH RATES FOR
                           NORMAL PROGRAM AID CATEGORIES AND THOSE WITH SPECIAL OR ENHANCED FMAP)
                                                    SFY 2012               ENHANCED
                                                                            SFY 2012           SFY 2012    SFY 2012
  COS           CATEGORY OF SERVICE             REGULAR FEDERAL             FEDERAL                         STATE
NUMBER              DESCRIPTION                     FP RATE                 FP RATE         PROVIDER TAX   FP RATE

           GROUP HEALTH PLAN                          0.69949                  0.0000            0.0000    0.3005
   054     DURABLE MED EQUIPMENT                      0.69949                  0.0000            0.0000    0.3005
   009     NF-SNF SWING VENT CARE                     0.69949                  0.0000            0.0000    0.3005
   005     HOSP INPT-VENT CARE                        0.69949                  0.0000            0.0000    0.3005
   064     CLINICS-DHS IMMUNIZATIONS                  1.0000                   0.0000            0.0000    0.0000
   070     PHYSICAL MED-NON PHYSICIAN                 0.69949                  0.0000            0.0000    0.3005
   078     HMO PREMIUMS                               0.69949                  0.0000            0.0000    0.3005
   059     HOME INFUSION THERAPY                      0.69949                  0.0000            0.0000    0.3005
   060     HOSPICE                                    0.69949                  0.0000            0.0000    0.3005
   101     PART A MEDICARE SUB-TOTAL                  0.69949                  0.0000            0.0000    0.3005
   107     PART B BUY-IN MQBQ                         0.69949                  0.0000            0.0000    0.3005
   108     PART B BUY-IN DUAL Q                       0.69949                  0.0000            0.0000    0.3005
   110     PART B BUY-IN MQBB                         0.69949                  0.0000            0.0000    0.3005
   111     PART B BUY-IN DUAL B                       0.69949                  0.0000            0.0000    0.3005
   065     CLINICS-FQHC, CORE & AMBULATORY            0.69949                  0.0000            0.0000    0.3005
   066     FAMILY PLANNING-FQHC                       0.9000                   0.0000            0.0000    0.1000
   067     HEALTH CHECK-FQHC                          0.69949                  0.0000            0.0000    0.3005
   040     HOSP INPT-INDIAN HEALTH                    1.0000                   0.0000            0.0000    0.0000
   042     HOSP OUTPT-INDIAN HEALTH                   1.0000                   0.0000            0.0000    0.0000
   039     NF-INDIAN HEALTH                           1.0000                   0.0000            0.0000    0.0000
   075     ACH - PCS BASIC                            0.69949                  0.0000            0.0000    0.3005
   083     ACH - PCS ENHANCED                         0.69949                  0.0000            0.0000    0.3005
   026     HOME HEALTH-INDIAN HEALTH                  1.0000                   0.0000            0.0000    0.0000
   048     AMBULATORY SURG CENTER                     0.69949                  0.0000            0.0000    0.3005
           TRANSPORTATION-CNTY ADMIN                  0.69949                  0.0000            0.0000    0.3005
   074     ACF-TRANSPORTATION                         0.69949                  0.0000            0.0000    0.3005
           PART D PAYMENTS                            0.0000                   0.0000            0.0000    1.0000




313c19c6-fdbf-4259-aa64-678ad2ed1524.xls
SFY 2012 BLENDED SHARES                                         Page 5 of 11                                    1/2/2012 3:18 PM
DEPARTMENT OF HEALTH AND HUMAN SERVICES
DIVISION OF MEDICAL ASSISTANCE
BUDGET MANAGEMENT


                                           SFY 2011 COUNTY ADMINISTERED TRANSPORTATION
                                               MEDICAID ADMINISTRATIVE EXPENDITURES
                                                   YEAR TO DATE DECEMBER 31, 2010                                                          PROJECTE
                                                                                                                                            D COST
                                                                                                                                            FOR SFY FEDERAL         COUNTY
                COUNTY               July-10         August-10 ###########       October-10 November-10 December-10   TOTALS      RATIOS      2011  SHARE           SHARE
              ALAMANCE                         28            72                           32                        $       131   0.0002   $     262   $      131   $      131
              ALEXANDER                                                                                             $         -   0.0000   $       -   $        -   $        -
              ALLEGHANY                                                                                             $         -   0.0000   $       -   $        -   $        -
              ANSON                                                                                                 $         -   0.0000   $       -   $        -   $        -
              ASHE                                                                                                  $         -   0.0000   $       -   $        -   $        -
              AVERY                                                                                                 $         -   0.0000   $       -   $        -   $        -
              BEAUFORT                      9502               9281      15758         7492       4446        5081 $     51,560   0.0638   $ 103,120   $   51,560   $   51,560
              BERTIE                                                                                                $         -   0.0000   $       -   $        -   $        -
              BLADEN                          366              342         778           396       466         460 $      2,808   0.0035   $   5,616   $    2,808   $    2,808
              BRUNSWICK                                      13402        2383         2725       4380        6717 $     29,607   0.0366   $ 59,214    $   29,607   $   29,607
              BUNCOMBE                     11017             17640       18574        15722      13074       13485 $     89,511   0.1108   $ 179,022   $   89,511   $   89,511
              BURKE                           28                                         219                        $       247   0.0003   $     493   $      247   $      247
              CABARRUS                                             230    153                                    39 $       421   0.0005   $     843   $      421   $      421
              CALDWELL                        613                  329    349            638       217         523 $      2,669   0.0033   $   5,338   $    2,669   $    2,669
              CAMDEN                           52                   27    101             19         70           5 $       273   0.0003   $     547   $      273   $      273
              CARTERET                         23                  703     96             23       193         583 $      1,622   0.0020   $   3,244   $    1,622   $    1,622
              CASWELL                                                      12                                       $        12   0.0000   $      24   $       12   $       12
              CATAWBA                         814                                                              347 $      1,161   0.0014   $   2,323   $    1,161   $    1,161
              CHATHAM                                                                                               $         -   0.0000   $       -   $        -   $        -
              CHEROKEE                      2022               1891      2129          1980       1457        1830 $     11,309   0.0140   $ 22,618    $   11,309   $   11,309
              CHOWAN                                                                                                $         -   0.0000   $       -   $        -   $        -
              CLAY                            131               119                      180       810           31 $     1,271   0.0016   $   2,542   $    1,271   $    1,271
              CLEVELAND                       342              1005       394            488       472        3091 $      5,792   0.0072   $ 11,583    $    5,792   $    5,792
              COLUMBUS                                         3126                    4222                   3006 $     10,354   0.0128   $ 20,708    $   10,354   $   10,354
              CRAVEN                        5372               5230      6721          5912       5500        6245 $     34,981   0.0433   $ 69,963    $   34,981   $   34,981
              CUMBERLAND                     756                                                                    $       756   0.0009   $   1,511   $      756   $      756
              CURRITUCK                      748               1056       761          1164       1127         579 $      5,434   0.0067   $ 10,868    $    5,434   $    5,434
              DARE                          1152                         4934                                       $     6,085   0.0075   $ 12,171    $    6,085   $    6,085
              DAVIDSON                      5123               8966      9670          4334       5779        5629 $     39,501   0.0489   $ 79,002    $   39,501   $   39,501
              DAVIE                                                                                                 $         -   0.0000   $       -   $        -   $        -
              DUPLIN                                                       18                                       $        18   0.0000   $      37   $       18   $       18
              DURHAM                                                                                                $         -   0.0000   $       -   $        -   $        -
              EDGECOMBE                       279                  545    883            923       949         958 $      4,537   0.0056   $   9,073   $    4,537   $    4,537
              FORSYTH                                                                                               $         -   0.0000   $       -   $        -   $        -
              FRANKLIN                      2802               1404                    1353       1042        1555 $      8,157   0.0101   $ 16,314    $    8,157   $    8,157
              GASTON                        6162                                       6010                         $    12,172   0.0151   $ 24,344    $   12,172   $   12,172
              GATES                                                                                                 $         -   0.0000   $       -   $        -   $        -
              GRAHAM                          745                        3539          2187                   2871 $      9,342   0.0116   $ 18,684    $    9,342   $    9,342
              GRANVILLE                                                                                             $         -   0.0000   $       -   $        -   $        -
              GREENE                                                                                                $         -   0.0000   $       -   $        -   $        -
              GUILFORD                                                                                              $         -   0.0000   $       -   $        -   $        -


313c19c6-fdbf-4259-aa64-678ad2ed1524.xls TRANSADMIN YTD DEC 2010                                 Page 6 of 11                                                                    1/2/2012 3:18 PM
DEPARTMENT OF HEALTH AND HUMAN SERVICES
DIVISION OF MEDICAL ASSISTANCE
BUDGET MANAGEMENT


                                           SFY 2011 COUNTY ADMINISTERED TRANSPORTATION
                                               MEDICAID ADMINISTRATIVE EXPENDITURES
                                                   YEAR TO DATE DECEMBER 31, 2010                                                                     PROJECTE
                                                                                                                                                       D COST
                                                                                                                                                       FOR SFY FEDERAL        COUNTY
                 COUNTY              July-10         August-10           ###########   October-10   November-10 December-10       TOTALS     RATIOS      2011  SHARE          SHARE
              HALIFAX                      24475                               50992        26236         14959         29328 $    145,991   0.1807   $ 291,981   $ 145,991    #######
              HARNETT                       3538                616             1534                       4559          1558 $     11,803   0.0146   $ 23,606    $ 11,803    $ 11,803
              HAYWOOD                       5078               7312             5124         4752          5189          3466 $     30,921   0.0383   $ 61,842    $ 30,921    $ 30,921
              HENDERSON                                                                                                       $          -   0.0000   $       -   $       -   $      -
              HERTFORD                                                                                                        $          -   0.0000   $       -   $       -   $      -
              HOKE                                                                                                            $          -   0.0000   $       -   $       -   $      -
              HYDE                             90                                              90             90           90 $        360   0.0004   $     720   $     360   $    360
              IREDELL                                                                                                         $          -   0.0000   $       -   $       -   $      -
              JACKSON                        849                   474           922                         804          141 $      3,190   0.0039   $   6,381   $   3,190   $ 3,190
              JOHNSTON                      8223                                8450         7043                        8170 $     31,887   0.0395   $ 63,774    $ 31,887    $ 31,887
              JONES                         3700               3079             2863         3302          2597            18 $     15,558   0.0193   $ 31,117    $ 15,558    $ 15,558
              LEE                                                                                                             $          -   0.0000   $       -   $       -   $      -
              LENOIR                        2830               2600             2470         2300          2570          2695 $     15,465   0.0191   $ 30,930    $ 15,465    $ 15,465
              LINCOLN                        897                210              498          839           507           202 $      3,154   0.0039   $   6,308   $   3,154   $ 3,154
              MACON                         1105               2981             1499         2603          2640          1874 $     12,702   0.0157   $ 25,404    $ 12,702    $ 12,702
              MADISON                       2669               2457             2498         2546          3733          2600 $     16,504   0.0204   $ 33,008    $ 16,504    $ 16,504
              MARTIN                         665               1113             1096         1779           968           555 $      6,176   0.0076   $ 12,352    $   6,176   $ 6,176
              MCDOWELL                                                                                                        $          -   0.0000   $       -   $       -   $      -
              MECKLENBURG                     727                                                                         821 $      1,548   0.0019   $   3,097   $   1,548   $ 1,548
              MITCHELL                                                                                                        $          -   0.0000   $       -   $       -   $      -
              MONTGOMERY                                        348              182           57                             $        586   0.0007   $   1,171   $     586   $    586
              MOORE                         2066               1588             4042         2177                        2780 $     12,652   0.0157   $ 25,303    $ 12,652    $ 12,652
              NASH                                                                                                            $          -   0.0000   $       -   $       -   $      -
              NEW HANOVER                   3576               1581             2212         1482          1734          2315 $     12,900   0.0160   $ 25,800    $ 12,900    $ 12,900
              NORTHAMPTON                                                                     775           403               $      1,178   0.0015   $   2,356   $   1,178   $ 1,178
              ONSLOW                                                                                                          $          -   0.0000   $       -   $       -   $      -
              ORANGE                          391                  605           324          140            166          863 $      2,490   0.0031   $   4,979   $   2,490   $ 2,490
              PAMLICO                                                                                                         $          -   0.0000   $       -   $       -   $      -
              PASQUOTANK                                                                                                      $          -   0.0000   $       -   $       -   $      -
              PENDER                       11978                               11491         6512          7237               $     37,217   0.0461   $ 74,434    $ 37,217    $ 37,217
              PERQUIMANS                                                                                                      $          -   0.0000   $       -   $       -   $      -
              PERSON                                                                                                          $          -   0.0000   $       -   $       -   $      -
              PITT                          2805               2279             1576         1177          2411          2763 $     13,009   0.0161   $ 26,018    $ 13,009    $ 13,009
              POLK                                                                                                            $          -   0.0000   $       -   $       -   $      -
              RANDOLPH                                         3267             1449         1642          2100          2224 $     10,682   0.0132   $ 21,364    $ 10,682    $ 10,682
              RICHMOND                                                                                                        $          -   0.0000   $       -   $       -   $      -
              ROBESON                       3390               4521             3304         3320          3690          4171 $     22,396   0.0277   $ 44,792    $ 22,396    $ 22,396
              ROCKINGHAM                       9                398              203          130                         152 $        892   0.0011   $   1,784   $     892   $    892
              ROWAN                        13252               2041              823           27            21           395 $     16,559   0.0205   $ 33,117    $ 16,559    $ 16,559
              RUTHERFORD                     206                107              148          108           177            49 $        795   0.0010   $   1,590   $     795   $    795
              SAMPSON                       2755               6189                          1428          3600               $     13,971   0.0173   $ 27,942    $ 13,971    $ 13,971

313c19c6-fdbf-4259-aa64-678ad2ed1524.xls TRANSADMIN YTD DEC 2010                                         Page 7 of 11                                                                  1/2/2012 3:18 PM
DEPARTMENT OF HEALTH AND HUMAN SERVICES
DIVISION OF MEDICAL ASSISTANCE
BUDGET MANAGEMENT


                                           SFY 2011 COUNTY ADMINISTERED TRANSPORTATION
                                               MEDICAID ADMINISTRATIVE EXPENDITURES
                                                   YEAR TO DATE DECEMBER 31, 2010                                                                          PROJECTE
                                                                                                                                                            D COST
                                                                                                                                                            FOR SFY FEDERAL          COUNTY
                 COUNTY               July-10        August-10           ###########   October-10    November-10 December-10           TOTALS     RATIOS      2011  SHARE            SHARE
              SCOTLAND                                                                                                           $            -   0.0000   $        -   $        -   $        -
              STANLY                        5410               1473             3178          3437          2843            1931 $       18,272   0.0226   $   36,544   $   18,272   $   18,272
              STOKES                                                                           447                               $          447   0.0006   $      894   $      447   $      447
              SURRY                                                                                                              $            -   0.0000   $        -   $        -   $        -
              SWAIN                                                              138                                             $          138   0.0002   $      276   $      138   $      138
              TRANSYLVANIA                    183                  102                                        109                $          394   0.0005   $      789   $      394   $      394
              TYRRELL                                                                                                            $            -   0.0000   $        -   $        -   $        -
              UNION                                                                                                              $            -   0.0000   $        -   $        -   $        -
              VANCE                                                                                                              $            -   0.0000   $        -   $        -   $        -
              WAKE                                                                                                               $            -   0.0000   $        -   $        -   $        -
              WARREN                                                                                                             $            -   0.0000   $        -   $        -   $        -
              WASHINGTON                                                                                                         $            -   0.0000   $        -   $        -   $        -
              WATAUGA                       3368               1881             1835          2312          2342            1919 $       13,656   0.0169   $   27,312   $   13,656   $   13,656
              WAYNE                          342                357              337           311           588             355 $        2,289   0.0028   $    4,578   $    2,289   $    2,289
              WILKES                                                                                                             $            -   0.0000   $        -   $        -   $        -
              WILSON                                                                                                             $            -   0.0000   $        -   $        -   $        -
              YADKIN                          392                  401           596           392            292            353 $        2,426   0.0030   $    4,852   $    2,426   $    2,426
              YANCEY                                                                                                             $            -   0.0000   $        -   $        -   $        -
              TOTALS              $    153,046      $     113,345        $   177,034   $   133,381   $   106,308    $    124,824   $    807,938   1.0000   ######### $ 807,938       #######




313c19c6-fdbf-4259-aa64-678ad2ed1524.xls TRANSADMIN YTD DEC 2010                                          Page 8 of 11                                                                            1/2/2012 3:18 PM
            DEPARTMENT OF HEALTH AND HUMAN SERVICES DIVISION OF MEDICAL ASSISTANCE
        COUNTIES SFY 2012 PROJECTED PORTION OF MEDICAID PROGRAM SERVICES EXPENDITURES
                                          COUNTY
                         COUNTIES       PROJECTED
                      PERCENTAGE OF EXPENDITURES IN
                      TOTAL SFY 2012 GOVERNOR'S 2012
                        PROJECTED       PROJECTED         FEDERAL                     COUNTY
       COUNTY             BUDGET          BUDGET           SHARE      STATE SHARE      SHARE
 1. Alamance               1.56%     $      157,358,544 $ 106,824,030 $  50,534,514 $        -
 2. Alexander              0.37%     $       36,830,467 $  25,002,639 $  11,827,828 $        -
 3. Alleghany              0.16%     $       16,603,545 $  11,271,441 $   5,332,104 $        -
 4. Anson                  0.48%     $       48,075,443 $  32,636,375 $  15,439,067 $        -
 5. Ashe                   0.38%     $       38,342,004 $  26,028,758 $  12,313,247 $        -
 6. Avery                  0.19%     $       18,884,996 $  12,820,221 $   6,064,775 $        -
 7. Beaufort               0.74%     $       74,485,360 $  50,564,946 $  23,920,414 $        -
 8. Bertie                 0.43%     $       43,072,087 $  29,239,810 $  13,832,277 $        -
 9. Bladen                 0.63%     $       63,090,753 $  42,829,631 $  20,261,121 $        -
10. Brunswick              1.02%     $      102,952,706 $  69,890,218 $  33,062,488 $        -
11. Buncombe               2.79%     $      281,078,934 $ 190,812,546 $  90,266,388 $        -
12. Burke                  1.13%     $      113,753,987 $  77,222,749 $  36,531,238 $        -
13. Cabarrus               1.42%     $      143,105,446 $  97,148,207 $  45,957,239 $        -
14. Caldwell               0.98%     $       98,866,969 $  67,116,585 $  31,750,384 $        -
15. Camden                 0.07%     $        6,624,474 $   4,497,074 $   2,127,400 $        -
16. Carteret               0.63%     $       63,113,071 $  42,844,782 $  20,268,288 $        -
17. Caswell                0.32%     $       32,415,200 $  22,005,302 $  10,409,898 $        -
18. Catawba                1.51%     $      151,757,604 $ 103,021,789 $  48,735,814 $        -
19. Chatham                0.48%     $       48,333,752 $  32,811,731 $  15,522,021 $        -
20. Cherokee               0.40%     $       40,053,032 $  27,190,302 $  12,862,730 $        -
21. Chowan                 0.23%     $       23,004,441 $  15,616,737 $   7,387,703 $        -
22. Clay                   0.12%     $       12,352,539 $   8,385,614 $   3,966,925 $        -
23. Cleveland              1.67%     $      167,805,821 $ 113,916,242 $  53,889,579 $        -
24. Columbus               1.08%     $      108,316,620 $  73,531,551 $  34,785,069 $        -
25. Craven                 1.07%     $      107,313,978 $  72,850,900 $  34,463,078 $        -
26. Cumberland             3.24%     $      326,234,415 $ 221,466,683 $ 104,767,732 $        -
27. Currituck              0.15%     $       15,470,758 $  10,502,440 $   4,968,318 $        -
28. Dare                   0.21%     $       21,217,886 $  14,403,922 $   6,813,965 $        -
29. Davidson               1.75%     $      176,148,407 $ 119,579,670 $  56,568,738 $        -
30. Davie                  0.37%     $       37,214,134 $  25,263,095 $  11,951,040 $        -
31. Duplin                 0.70%     $       70,292,305 $  47,718,460 $  22,573,846 $        -
32. Durham                 2.90%     $      292,470,884 $ 198,546,057 $  93,924,827 $        -
33. Edgecombe              1.03%     $      104,087,151 $  70,660,344 $  33,426,807 $        -
34. Forsyth                3.39%     $      341,178,307 $ 231,611,456 $ 109,566,850 $        -
35. Franklin               0.67%     $       67,785,229 $  46,016,512 $  21,768,717 $        -
36. Gaston                 2.79%     $      281,157,926 $ 190,866,171 $  90,291,756 $        -
37. Gates                  0.11%     $       11,187,046 $   7,594,410 $   3,592,636 $        -
38. Graham                 0.16%     $       16,101,362 $  10,930,530 $   5,170,831 $        -
39. Granville              0.58%     $       58,103,181 $  39,443,781 $  18,659,400 $        -
40. Greene                 0.28%     $       27,747,797 $  18,836,800 $   8,910,997 $        -
41. Guilford               4.66%     $      469,732,233 $ 318,881,255 $ 150,850,978 $        -
42. Halifax                1.02%     $      102,862,949 $  69,829,286 $  33,033,663 $        -
43. Harnett                1.13%     $      114,312,315 $  77,601,774 $  36,710,541 $        -
44. Haywood                0.74%     $       74,724,114 $  50,727,026 $  23,997,088 $        -
45. Henderson              1.06%     $      106,630,614 $  72,386,993 $  34,243,621 $        -
46. Hertford               0.41%     $       41,776,679 $  28,360,413 $  13,416,267 $        -


                                                         313c19c6-fdbf-4259-aa64-678ad2ed1524.xls
  March 31, 2009                          Page 9 of 11                            County Estimates
        DEPARTMENT OF HEALTH AND HUMAN SERVICES DIVISION OF MEDICAL ASSISTANCE
     COUNTIES SFY 2012 PROJECTED PORTION OF MEDICAID PROGRAM SERVICES EXPENDITURES
                                       COUNTY
                      COUNTIES       PROJECTED
                   PERCENTAGE OF EXPENDITURES IN
                   TOTAL SFY 2012 GOVERNOR'S 2012
                     PROJECTED       PROJECTED        FEDERAL                  COUNTY
     COUNTY            BUDGET          BUDGET          SHARE     STATE SHARE    SHARE
47. Hoke              0.49%      $       49,223,489   $     33,415,735   $    15,807,754   $          -
48. Hyde              0.07%      $        7,268,793   $      4,934,475   $     2,334,318   $          -
49. Iredell           1.33%      $      134,298,389   $     91,169,470   $    43,128,919   $          -
50. Jackson           0.37%      $       36,970,340   $     25,097,593   $    11,872,747   $          -
51. Johnston          1.67%      $      167,954,770   $    114,017,357   $    53,937,413   $          -
52. Jones             0.15%      $       15,447,111   $     10,486,388   $     4,960,724   $          -
53. Lee               0.60%      $       60,632,103   $     41,160,559   $    19,471,545   $          -
54. Lenoir            0.99%      $       99,612,525   $     67,622,711   $    31,989,814   $          -
55. Lincoln           0.76%      $       76,149,907   $     51,694,937   $    24,454,971   $          -
56. Macon             0.39%      $       39,590,727   $     26,876,463   $    12,714,265   $          -
57. Madison           0.28%      $       28,384,951   $     19,269,337   $     9,115,614   $          -
58. Martin            0.45%      $       45,745,092   $     31,054,400   $    14,690,693   $          -
59. McDowell          0.60%      $       60,884,534   $     41,331,923   $    19,552,611   $          -
60. Mecklenburg       7.91%      $      797,180,074   $    541,171,682   $   256,008,392   $          -
61. Mitchell          0.23%      $       23,273,603   $     15,799,460   $     7,474,143   $          -
62. Montgomery        0.35%      $       35,253,739   $     23,932,265   $    11,321,473   $          -
63. Moore             0.75%      $       75,235,083   $     51,073,901   $    24,161,182   $          -
64. Nash              1.16%      $      116,453,726   $     79,055,486   $    37,398,239   $          -
65. New Hanover       1.97%      $      198,956,125   $    135,062,860   $    63,893,265   $          -
66. Northampton       0.41%      $       41,648,097   $     28,273,123   $    13,374,973   $          -
67. Onslow            1.13%      $      113,657,306   $     77,157,116   $    36,500,190   $          -
68. Orange            0.94%      $       94,892,990   $     64,418,819   $    30,474,171   $          -
69. Pamlico           0.17%      $       17,504,470   $     11,883,041   $     5,621,429   $          -
70. Pasquotank        0.46%      $       46,113,250   $     31,304,326   $    14,808,924   $          -
71. Pender            0.55%      $       55,220,682   $     37,486,975   $    17,733,707   $          -
72. Perquimans        0.17%      $       16,958,498   $     11,512,404   $     5,446,094   $          -
73. Person            0.51%      $       51,316,713   $     34,836,736   $    16,479,977   $          -
74. Pitt              2.00%      $      201,473,507   $    136,771,804   $    64,701,703   $          -
75. Polk              0.21%      $       21,291,214   $     14,453,700   $     6,837,513   $          -
76. Randolph          1.50%      $      151,457,538   $    102,818,087   $    48,639,451   $          -
77. Richmond          0.78%      $       78,728,579   $     53,445,487   $    25,283,092   $          -
78. Robeson           2.73%      $      275,330,983   $    186,910,506   $    88,420,477   $          -
79. Rockingham        1.22%      $      122,621,697   $     83,242,660   $    39,379,037   $          -
80. Rowan             1.61%      $      162,416,112   $    110,257,398   $    52,158,714   $          -
81. Rutherford        0.90%      $       91,133,520   $     61,866,675   $    29,266,845   $          -
82. Sampson           0.93%      $       93,282,047   $     63,325,218   $    29,956,829   $          -
83. Scotland          0.70%      $       70,283,787   $     47,712,677   $    22,571,110   $          -
84. Stanly            0.72%      $       72,210,360   $     49,020,545   $    23,189,815   $          -
85. Stokes            0.47%      $       47,365,673   $     32,154,543   $    15,211,130   $          -
86. Surry             0.97%      $       97,487,336   $     66,180,010   $    31,307,326   $          -
87. Swain             0.24%      $       24,116,363   $     16,371,574   $     7,744,789   $          -
88. Transylvania      0.35%      $       35,097,491   $     23,826,196   $    11,271,296   $          -
89. Tyrrell           0.06%      $        6,352,099   $      4,312,170   $     2,039,929   $          -
90. Union             1.24%      $      125,317,169   $     85,072,502   $    40,244,667   $          -
91. Vance             0.85%      $       85,200,477   $     57,838,984   $    27,361,493   $          -
92. Wake              5.31%      $      534,645,964   $    362,948,429   $   171,697,535   $          -


                                                          313c19c6-fdbf-4259-aa64-678ad2ed1524.xls
  March 31, 2009                      Page 10 of 11                                County Estimates
         DEPARTMENT OF HEALTH AND HUMAN SERVICES DIVISION OF MEDICAL ASSISTANCE
      COUNTIES SFY 2012 PROJECTED PORTION OF MEDICAID PROGRAM SERVICES EXPENDITURES
                                        COUNTY
                       COUNTIES       PROJECTED
                    PERCENTAGE OF EXPENDITURES IN
                    TOTAL SFY 2012 GOVERNOR'S 2012
                      PROJECTED       PROJECTED        FEDERAL                  COUNTY
      COUNTY            BUDGET          BUDGET          SHARE     STATE SHARE    SHARE
 93. Warren                0.35%   $      35,548,231    $     24,132,184   $   11,416,047    $          -
 94. Washington            0.27%   $      27,297,339    $     18,531,004   $    8,766,335    $          -
 95. Watauga               0.26%   $      26,285,068    $     17,843,816   $    8,441,252    $          -
 96. Wayne                 1.47%   $     148,071,219    $    100,519,259   $   47,551,959    $          -
 97. Wilkes                0.96%   $      96,726,456    $     65,663,481   $   31,062,975    $          -
 98. Wilson                1.17%   $     117,419,222    $     79,710,921   $   37,708,301    $          -
 99. Yadkin                0.43%   $      42,959,559    $     29,163,419   $   13,796,140    $          -
100. Yancey                0.25%   $      25,541,062    $     17,338,742   $    8,202,320    $          -

Governor's 2012 Estimated Budget   $   10,075,514,624   $ 6,839,838,793    $ 3,235,675,831   $      -




                                                            313c19c6-fdbf-4259-aa64-678ad2ed1524.xls
   March 31, 2009                      Page 11 of 11                                 County Estimates

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:1/2/2012
language:English
pages:11