Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Medicaid Contract
SDDC Medica, untract 2008-2071 ADT -F July I Aug I Sept I _ Oct I Nov I Dec Jan I Feb Mar Apr I May June- I 'ro,rAL 3 Yrs. June 1..,7.4.6. 3 Yrs. Potentia 9,303 6. 8,303 8,.303 8,.3.03. 81,303 8,303 8,303 9,303 I.....I ........... ...I... I............ ... ..P....o...t...e...n.....t...i.a.....l. ..........4 ... ..1...,.7.. .4..6. . ...4 .. .1 .,..7...4.6. . ... . ...M�...... ........... .4 . . .........i. . ..4.1.,.7.4..6. ......4...1.,.7.4. ... ..... ........... ..I ..4..1.,.7.4.6. ._4.1.,7..4.6. ...................... . ............. ......4..1..,.7...4..6... ... ........4...1.,...7 ..I4.....6... ... ........... . .......4....1..3...4....6.............4.....1...,.7....4....6.... . .......... ............ . ..............4....1...,..7....4.....6... ..... .g.m......... .. . ............5...0...0.,..9..4...7 ....... 3 Yrs. Projected 36,210 12,070 12,070 12,070 12,070 12,070 12,070 12,070 12,070 121.070 12,070 12,070 168,980 .................. ........... .......... 34,871 .......... ...... ... ........... ... ...... .. ..... ... ADT Tranwortation I July-. I Aug Sept Oct I Nov I Dec Jan Feb Mar 1) r May June TOTAL 3 Yrs. Potentia 9,303 8,303 8,303 8,.303 8,.3.03. 81,303 8,303 8,303 9,303 8,303 8,303 99,634 ........... . .......... .... .. ........ . ....... .... .8,30.3. � ..... ..................... ........ . ..... .. ... .. +.,. . , - : ........ . ..... ......... ....... . ........ .. 3 Yrs. Projecte 7,474 2-491 2,491 2,491.491 2,491 2,491 34,871 Combined Income I July I Aug I Sept I Oct I Nov I Dec I Jan _ I Feb I Mar I Apr I May I June I TOTAL �3 Yrs. Potentia 50,048 1 50,048 1 50,048 1 50,048 1 50,048 1 50,048 1 50,048 1 50,048 1 50,048 1 50,049 1 _50,048 1 CAMy Documents\Marta FariakFinance\SDDC 08-11 Projected Revenues SDDC Medicaid Contract 2008-2009 ADT J -,I I- _ •,• - .11 k / I <<.a,-rLI) I kLY,71L11 \L/,4U-i (19,894)1 (29,894) July '08 Aug 108 Sept '08 Oct '08 Nov '08 Dee '08 Jan '09 Feb'09 Mar'09 Apr '09 Ma '09 June '09 I TOTAL Potential Mo. Potential YTD 13,915 13,915 13,915 27,830 13,915 41,746 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 166,982 ........, ..... 66 731 55,661 69,576 83,491 97,406 111,322 125,237 139,152 153,067 166,982 166,982 Projected Mo Actual 12,070 12' 070 l2' 070 12,070 12,070 ...•..•.•.•. 12,070 12,070 12,070 12,070 12,070 12,070 12,070 144,840 +/- Proj Mo :•:: •:: (12,070 :•::•:: •:: • .•..;..• 12,070) ...:...:.:.. 12,070) .:...•.................:.- (12,070) .:: (12,070) .: . :•::•:.:::::::::::• (12,070) . (12,070 •:.:... • ..•.•.� ..� 12,070) ...12,070) . (.l_?'070) (12,070) (12,070) 0 (144,840) Projected YTD Actual YTD 12,070 0 24,140 0 36,210 48,280 60,350 72,420 84,490 96,560 108,630 120,700 132,770 .............7777777777 144,840 ........... 144,840 I+/- YTD (12,070) (24,140 (36,210) (48,280) (60,350) (72,420) (84,490) (96,560) 0 (108,630) 0 0 (120,700)1(132,1-7-0)1 0 (144,840)L$--(14 0 4,840) ADT Transportation Potential Mo July '08 2,768 Au '08 2,768____2,768 Se t '08 Oct '08 Nov '08 Dec '08 Jan '09 Feb '09 Mar -'09 Apr '09 May '09 June'09 TOTAL Potential YTD 2,768 5,535 8,303 2,768 11,070 2,768 13,838 2,768 16,606 2,768 19,373 2,768 2,768 2,768 2,768 2,768 33,211 22,141 24,908 ... 27,676 .................................................. 30,444 33,21 l 33,211 Projected Mo Actual Mo 2,491 2,491 2,491 :::: 2,491 ::::::::::: 2,491 ::::::::::: 2,491 :::::••::•:•:•:.:.:-:::.:.::.:-:::•::::::::: 2,491 2,491 2,491 2,491 2,491 :............. 2,491 ...i 2),894 +/- Pro' Mo ............. .. ....(.2.,.4.9..1.). ....(.2..,4..9.1.) 2491 , , (2,491) (2,491) (2,491) (291 ,4 (2,491) 2,49l) (29,894. ro'ected YTD 2,491 . 4,982 7,474 9,965 12,456 .__L2,49 14,947 ::: ::__(2,49 17,438 19,930 :::::::: :•::••.......•.......).......;..;..:.:.:........... 22,421 24,912 27 403 .... .... :: : ..:: 29 .. . ............ ......0 .) ::::::: 29 894 YTD 0 - _ LACtual YTD (2,491) (4.982) (7.474) (9 9651 r t) A,;Z (t d on7N t, '7 n -19 fin 91- - -,I I- _ •,• - .11 k / I <<.a,-rLI) I kLY,71L11 \L/,4U-i (19,894)1 (29,894) C:\My Do( Marta Faria\Finance\SDDC 08-09 Projected Revenues Jul '08 Au '08 Sept '08 Oct '08 Nov 'OS •a x1111V4 Ll1GV1llG Dec '08 Jan '09 Feb '09 Mar 'U9 A r '09 May '09 June 'U9 TOTAL Potential Mo. Potential YTD 16,683 16,683 16,683 33,366 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 200,194 ............. ........, 50 048 66 731 83 414 100 097 116 780 1 g33,..4d62 150,145 166,828 183 511 200 194 200 194 Mo Actual Mo ................................... 14,561 - 14561 14,561 14,561 14,561 14,561 .... 14,561 ............. ........... . ....•..... 14,561 .............:.:..:..:.:.:...:.:.::...:.:. ...... 14,561 14,561 ' ' 14,561 'Projected 174,734 +/- Proi Mo .................. (14,561) ........................ 14, . 561 ... • (,,, ..... 14561 ...... .... 14 .. .. 561... 14 ........ 561) ........... (14,561... ).. (.14,561 (14,561) Q4,561) ..!14,561) (14,561) (14,561) (174,734) Projected YTD Actual YTD 14,561 - 29,122 _ 43,684 58,245 72,806 87,367 101,928 116,490 131,051 145,612 160,173 174,734 174,734 +/- YTD (14,561)(43,684)1 (58,245)t(72,806) (87,367) (101,928 i 16,490) F(131,051) (145,612) (160,173) (174,734) (174,734) C:\My Do( Marta Faria\Finance\SDDC 08-09 Projected Revenues SDDC MedicaiL intract 2009-2090 ADT tier i i rans n P orratio Combined lnenme. July '09 Aug'09 Sept '09 Oct'09 Nov '09 Dec '09 Jan 110 Feb '10 Mar 110 APr'10 Ma '10 June'10 TOTAL Potential Mo. Potential YTD Potential Mo 2,768 2,768 2,768 2,768 2,768 2,768 2,768 2,768 1 2,768 2,768 2,768 2,768 33,211 Potential YTD 2,768 5,535 8,303 11,070 13,838 16,606 .. 19,373 22,141 24 908 27 676 30,444 33,211 33,211 14,561 .................................................................. 14,561 14,561 14,561 ......... 14,561E(14,561) ................................ 14,561 14,561 ............................. 14,561 ........... Actual Mo Projected Mo 2,491 2,491 2,491 2,491 2,491 2,491 2,491 2,491 2,491 2,491 2,491 2,491 21 Actual Mo (14,561 (14,561) 14,561 (14,561) (14,561 14,561 (14,561) (14,561) (14,561) (14,561) (174,734) ,894 ... Proj Mo (2,491) (2,491) (2,491) (2,491) (2,491) (2,491) (2,491) ................. (2,491) ............. (2,491) (2,491) ........... (2,491) (2,491) ......... . 0 (29,894) Projected YTD 2,491 4,982 7,474 9,965 12,456 14,947 17,438 19,930 22,421 24 912 27 403 29 894 29 894 Actual YTD 0 _ _ _ _ _ (116,490) (131,051) (145,612) (160,173) - (174,734) 0 +/-YTD (2,491) (4,982) (7,474) (9,965) (12,456) (14,947) (17,438) (19,930) (22,421) (24,912) (27,403) (29,894) (29,894) Combined lnenme. C:\My Documents\Marta Faria\Finance\SDDC 09-10 Projected Revenues July '09 Aug'09 -Sept 109 ct'09 Nov '09 Dec '09 Jan'l0 Feb'10 Mar'10 Apr '10 may '10 I June'10 TOTAL Potential Mo. Potential YTD 16,683 16,683 16,683 33,366 16,683 50,048 16,683 66,731 16,683 83,414 16,683 100,097 16,683 116,780 16,683 133,462 161683 150,145 16,683 166,828 16,683 183,511 16,683 200,194 206,194 200,194 . ...... ........... .......... .........:..:.:.:...:.:.:.:.:..:.:.:..:.:.:...:.:.:.:.: Projected Mo 14,561 14,561 14,561 14,561 14,561 14,561 14,561E(14,561) 14,561 14,561 14,561 14,561 (74,734 Actual Mo - _ _Pro'Mo (14,561) (14,561 (14,561) 14,561 (14,561) (14,561 14,561 (14,561) (14,561) (14,561) (14,561) (174,734) ........... ........................ ........... ........... ........... ...................... ................:...........:.:.::::.:.:..::::::::•:••••..Projected YTD Actual YTD 14,561 - 29,122 _ 43,684 _ 58,245 _ 72,806 _ 87,367 _ 101 928 _ _ 1131,051 145,612 160,173 174,734 174,734 +/- YTD (14,561) (29,122) (43,684) 58,245) (72,806) (87,367) 101,928) (116,490) (131,051) (145,612) (160,173) (174,734) (174,734) C:\My Documents\Marta Faria\Finance\SDDC 09-10 Projected Revenues SDDC Medicaid Contract 2010-2011 TT - July '10 Aug'10 1 Sept'10 Oct'10 Nov 110 AL 1 Dec' -10 Jan'll Feb'11 Mar'll A r'll Ma 'll June'll TOTAL Potential Mo. Potential YTD 13,9:175-T-13,915 13,915 27,830 13,915 41,746 13,915 13,915g13,915 2,768 5,535 13,915 13,915 13,915 13,915 13,915 13,915 166,982 2,•768 ,lune'll 66,731 55,661 69,576 33,211 97,406 111,322 125,237 139,152 153,067 166,982 166,982 Projected Mo Actual 12,070 12,070) 12,070 12,070) 12,070 (12,070) 12,070 12,070) ................... 12,070 (12,070) 12,070 12,070 12, 070) 12,070 (12,070) 12,070 (12,070 12,070 (12,070) 12,070 (12,070) 12,070 (12,070) 144,840 0 (144) 840 144,8 0 , +/- Pro' Mo Projected YTD Actual YTD 12,070 0 24,140 36,210 48,280 60,350 72,420 84,490 96,560 108,630 120,700 132,770 144,840 144,84(1 +/- YTD 12,070) 0 24,140) 0 (36,210) 0 48,280 0 0 60,350 (72,420) AT�____ TT 0 (84,490) _ _-1. 0 96,560) 0 (108,630) 0 0 (120,700 132 ( 770 ) 0 (144,840) 0 $ (144,840) - Jul '10 Au '10 Sept 10 Oct'10 �.��+ Nov'10 iaa.aaau�lVl a. a.allV ll Dec'10 Jan 'It Feb III Mar'll Apr '11 May'll June '11 TOTAL Mar'llMay'll 16,683 16,683 16,683 33,366 16,683 TOTALPotential Mo Potential YTD 2,768 2,768 2,768 5,535 2,768 8,303 2,768 11,070 2,768 13,838 2,768 2,768 2,768 2,768 2,•768 ,lune'll 66,731 2,768 2,768 33,211 ........... ........ 166,828 ...... ... 183,511 .. . •...... 200,194 . . 200,194 16,606 19,373 22,141 24,908 27,676 30,444 33,211 .. 33,211 Projected Mo Actual Mo 2,491 2,491 2,491 :.:.:...:.:...:.:.:.:.:.:.:.... 2,491 2,491 ......:....•. 2,491 ......................................... 2,491 2,491 2,491 ...................... 2,491 2,491 .. .. ......., .. . 2,491 29,894 +/- Pro' Mo . :`.•.` ..'..:.:....:':. ............ (2,491) '. ':.:.:.:..:.:...:• (2,491) ..:<...:. • ..:•:.•.•.,, (2,491) :•..•.•:: 2,491 >:• : • • .............. (2,491) ;.... 2,491) ............ ................................:.:... (2,491 .... (2,491) 43,684 _ 58,245 72,806 ....... .. 87,367 0 (2,491) (2,191) .. (2,491) .......... (2,491) (29,894) Projected YTD 21491 4,982 7,474 9,965 12,456 14,947 17,438 19,930 ..............................•.......... ...........................:........... 22,421 :....... . •..........•.•.. (174,734) 24,912 27,403 29,894. 29,894 Actual YTD 0 - +/- YTD (2,491) (4,982) (7,474) 9,965) (12,456 14,947) 17,438) (19,930) (22,421) - (24,012) - 0 - (27,403) (29,894) (29,894) C:\My Doci Aarta Faria\Finance\SDDC 10-11 Projected Revenues July'10 Au '10 Sept '10 Oct'10 Nov'10 a vY lal�.V lll�. Dec'10 Jan III Feb'11 Mar'll Apr '11 May'll June '11 TOTAL Potential Mo. Potential YTD 16,683 16,683 16,683 33,366 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 200,194 50,048 66,731 83,414 100,097 116,780 133 462 150,145 166,828 ...... ... 183,511 .. . •...... 200,194 . . 200,194 Projected Mo Actual Mo 14,561 - 14,561 _ 14,561 14,561 14,561 _ 14,561 14,561 14,561 14,561 14561 , ....:.:..:...............::: 14,561 14,561 174,734 +/- Pro' Mo ..... .... 14,561) 4,56 •.-........,561_. 14,561) (14,561) .. (14,...._1 ._.•.14,.., .......•.... ::::::::::: 14,561 1) ..14,561 .:.:.:.:.:.:..........•.:.•.•.............:.,............................_....... _ 14,561) (14,561) (14,561)... ........... (14,561. ) ........................................ (14,_161) .. 14,5. . .......,.... (14,561) ..... (14,561) .... .::•: (174,734) .........: ro'ected YTD Actual YTD 14,561 - 29,122 _ 43,684 _ 58,245 72,806 ....... .. 87,367 .. 101,928 116,490 .... 131,051 145,612 160,173 174,734 174,734 , +/-YTD {]4,561) (29,122) 43,684 (58,245 (72,806) 87,367) 101,928) (116,490)(131,051) (145,612) (160,173) (174,734) (174,734) C:\My Doci Aarta Faria\Finance\SDDC 10-11 Projected Revenues