Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Exhibit 4
SDDC Medicaid Contract 2008-2011 ADT July Aug Sept Oct Nov Dec Jan Feb Mar Apr May June TOTAL 3 Yrs. Potential 41,746 41,746 41,746 41,746 41,746 41,746 41,746 41,746 41,746 41,746 ' 41,746 41,746 500,947 • : : -::.: : • :•:•::::: :-::: : : :•:•: • .. : :•:: : : :•.: ::... . - • • • • • • • • • • . • • .• : : : : . : : - : : : : : : : : . : : : 3. Yrs. Projected 3.6,210 12,0.70 12,070 12,070 12,070 12,070 12,070 12,070 12,070 12,070 12,070 12,070 168,980 ::::::::::::: ::: : :•:: :•:•:•:-: ::•• :::•:•:::::::•: :•:•:•• :-: : : ::•:::-:•::. : : ::::::::::::::.: ' :: :.: : • : : : : : : : :•: :•: : ADT Trans ortation July Aug Sept Oct Nov _ Dec Jan Feb Mar Apr May June TOTAL 3 Yrs. Potential 8,303 8,303 8,303 8,303 8,303 8,303 8,303 8,303 8,303 8,303 8,303 8,303 99,634 . . . . 3 Yrs. Projectei 7,474 2,491 2,491 2,491 2,491 2,491 2,491 2,491 2,491 2,491 2,491 2,491 34,877 Combined Income July I Aug Sept Oct I Nov I Dec Jan Feb Mar Apr May June TOTAL 3 Yrs. Potential' 50,048 50,048 50,048 50,048 I 50,048 I 50,048 50,048 50,048 50,048 50,048 50,048 50,048 600,58). C:\My Documents\Marta Faria\Finance\SDDC 08-11 Projected Revenues SDDC Medicaid Contract 2008-2009 J July '08 Aug '08 Sept '08 Oct '08 Nov '08 Dec '08 Jan '09 Feb '09 Mar '09 Apr '09 May '09 June '09 TOTAL Potential Mo. 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 166,982 Potential YTD 13,915 27,830 41,746 55,661 69,576 83,491 97,406 111,322 125,237 139,152 153,067 166,982 166,982 •.•.•.•.•.•:•:•:•:•:•:•:•:•:•:•:•:•: .......•.•.•.•:•:•.•:-.• •:•:•:•:•:•:•:•:•:-:•: :•:-:•:•:•:•:•:•:•:•:-. .•.. .•.•.•.•.•.•.•.•.•.•.•..•.•. .•.•.•.......• ••••••.•.•.•.•.•.• •.•.•.•...•.. •.•.•.•.•.•.•. ....... ............ •••• •••••••••• ••••• .......... .......... •• •• •• -•••••••• - .. .. ... . . .......... ••••••••• • - ••• • .. . . . . . „.... . .. Projected Mo 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 Actual 0 +/- Proj Mo (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) :H:H:::::::::H :H:::::i:H:::::H:':::::i:::- :i:::'..:::i:::h :i:::i::i::i::: i:::::i:::::: ::i::::::i::: ::i:H * • ' ' . :i::H:i:::i: ''.. :.:.:H H:::::: ::::H.:H H.E:H.H::::::H H.:H:::.• ::-:: Projected YTD 12,070 24,140 36,210 48,280 60,350 72,420 84,490 96,560 108,630 120,700 132,770 144,840 144,840 Actual YTD 0 0 0 0 0 0 0 0 0 0 0 0 0 +/- YTD (12,070) (24,140) (36,210) (48,280) (60,350) (72,420) (84,490) (96,560) (108,630) (120,700) (132,770) (144,840) $ (144,840) July '08 Aug '08 Sept '08 Oct '08 Nov '08 -- - ----, Dec '08 - - -------- Jan '09 Feb '09 Mar '09 I Apr '09 May '09 June '09 TOTAL Potential Mo 2,768 2,768 2,768 2,768 2,768 2,768 2,768 2,768 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 -:•:•:-:: ..•.•.•.•.•.•.•.•.•.•.•............. -...•..•.•.•.•.•.•.•.•..•.•.•.•.•...•.•.•.•.•. ....•.•....-..• •.•.•.•.-.•.•.•.•.•.•,• .................................. .... ............................... ............................................ . 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 29,894 Actual Mo 0 +/- 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) (29,894) j.:.:.:.:.: I: : . :::::::::. i:::i::i:i::: :::i:i:.:. .::: . :i::i:H::: ::H:i:i:H: ::H.H:H.H:•1. 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 - - - - - - - - - - 0 - +/- YTD (2,491) (4,982) (7,474) (9,965) (12,4561 (14,947)__ (17,438) (19,930) (22,421)_ (24,912) (27,403) (29,894) (29,894) Combined Income I July '08 Aug '08 Sept '08 Oct '08 Nov '08 I Dec '08 Jan '09 I Feb '09 Mar '09 _ Apr '09 May '09 June '09 TOTAL Potential Mo. 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 200,194 Potential YTD 16,683 33,366 50,048 66,731 83,414 100,097 116,780 133,462 150,145 166,828 183,511 200,194 200,194 .................... .... ............................................... ............................................................................................................................................................... .•.• •.•.•.•..•..-.• •:-: :•:•:•:•:•:• •.•. •.•.• •.•. . •:•:::•:•::: :•:::•:.: :• . .•.• . •.•.•.. -:-: :•:•:•:-: : : :•:•:.: • Projected Mo 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 174,734 Actual Mo - - - - - - - - - - - - - +/- Proj Mo (14,561) (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 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 Actual YTD - - - - - - - - - - - - - +/- YTD (14,561) (29,122) (43,684L (58,2451 (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 08-09 Projected Revenues SDDC Medicaid Contract 2009-2010 -I I July '09 Aug '09 Sept '09 Oct '09 Nov '09 Dec'09 Jan '10 Feb '10 Mar '10 Apr '10 May '10 June '10 TOTAL Potential Mo. 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 166,982 Potential YTD 13,915 27,830 41,746 55,661 69,576 83,491 97,406 111,322 125,237 139,152 153,067 166,982 166,982 Projected Mo 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 Actual 0 +/- Proj Mo •• (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) ::::: ::H::::::::: :.:.:.:. ' :::::::::::: ::::::::: ::::::::: ::E::H::i:::::i:::: ::::::.: : • • • :::H::::: H:::: ::H::H::::: Projected YTD 12,070 24,140 36,210 48,280 60,350 72,420 84,490 96,560 108,630 120,700 132,770 144,840 144,840 Actual YTD 0 0 0 0 0 0 0 0 0 0 0 0 0 +/- YTD (12,070) (24,140) (36,210) (48,280) (60,350) (72,420) (84,490) (96,560) (108,630) (120,700) (132,770) (144,840) $ (144,840) . _ J July '09 Aug '09 Sept '09 Oct '09 Nov '09 Dec'09 Jan '10 I Feb '10 Mar '10 Apr '10 May '10 June '10 TOTAL Potential Mo 2,768 2,768 2,768 2,768 2,768 2,768 2,768 2,768 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 • • •. .• . •.•. . . • . •.. • •. • • • . .. • .. .. • • ••• ..• . . . •. .. . ... ... . . 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 29,894 Actual Mo 0 +/- 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) (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 - - - - - - - - - 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) ombined Income I July '09 Aug '09 I Sept '09 Oct '09 Nov '09 Dec '09 Jan '10 I Feb '10 I Mar '10 Apr '10 May '10 June '10 TOTAL Potential Mo. 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 200,194 Potential YTD 16,683 33,366 50,048 66,731 83,414 100,097 116,780 133,462 150,145 166,828 183,511 200,194 200,194 . . . .... . . . . .. . ... . ... . Projected Mo 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 174,734 Actual Mo - - - - - - - - - - - - - (14,561) (14,561) (14,561) (14,561) (14,561) (14,561), (14,561) (14,5611 (14,561) (14,561) (14,561) (14,561) (174,734) ... : .....• ....::•:•:: :. •:•:. :•:•:•:•:•::•::•::•::•..........:•:•:•:-: .: :•::•:•:•:•: .•:•:• :•:•:•:•:-:-:-......:. •:•:•:•:•:•:•:•:.: :.: :•:•:•:•:•:•:-:•:•:•. .. • • • • • • • : .•:•:•:•: :- :•::•:: : :::•:: ::•:: . Projected 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 Actual YTD - - - - - - - - - - - - - +/- 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 I July '10 Aug '10 Sgt '10 Oct '10 Nov '10 Dec '10 Jan '11 Feb '11 Mar '11 Apr '11 May '11 June '11 TOTAL Potential Mo. 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 13,915 166,982 Potential YTD 13,915 27,830 41,746 55,661 69,576 83,491 97,406 111,322 125,237 139,152 153,067 166,982 166,982 ::::::i::::i:::::::: ::::::::: :•:•:-:•:•:•:•:•:-:-:•. :i::::: ::j::::::: :.:.:.:-:.:-:.:.::1:. :::::::::::: :•:•:.... . . :::::.:::: ::::::::'.:::::::: ::::::H1:::H:H:l. Projected Mo 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 Actual 0 +/- Proj Mo (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) :::i::::::::::H:::: ::i::::::::::::i::::i:::i:: :i:::::i::::: :::::::: • • ' ::::::: :::::::: • • • • ' • • :i::::::::::: ••••••• • • • • • ::H:::H:H H::::::H: E::::H:1:H:H::;• ::::H:: H:H::: Projected YTD 12,070 24,140 36,210 48,280 60,350 72,420 84,490 96,560 108,630 120,700 132,770 144,840 144,840 Actual YTD 0 0 0 0 0 0 0 0 0 0 0 0 0 +/- YTD (12,070) (24,140) (36,210) (48,280) (60,350) (72,420) (84,490) (96,560) (108,630) (120,700) (132,770) (144,840) $ (144,840) I July '10 Aug '10 Sept '10 Oct '10 Nov '10 --.. Dec '10 - - --- -- - Jan '11 Feb '11 _ Mar '11 Apr '11 May '11 June '11 ' TOTAL Potential Mo 2,768 2,768 2,768 2,768 2,768 2,768 2,768 2,768 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 :i:i:H::::H::H :H::...-.-....... ::::::::::::::::::::::: :::i: • • • ... .‘..................... -.•.•.-.•.•.•.•.•.•.•.. •.•...•.•.•.•.•.•.•.•.. ... ,....... IH::H::::: .::::::::::::::,:::::: 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 29,894 Actual Mo 0 +/- 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) (29,894) :::::::::i::::i:::::::H::i::i:::::::H:: • ••••••:...• • • • :::h:::.: ::i:::H:::H: i:i...E:H:i:1: :::.:::H:: ::i:H.: " • • • ::H:H :.:.• ' 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 - - - - - - - - - - 0 - +/- YTD (2,491) (4,982) (7,474) (9,965)_ (12,456) (14,947)_ (17,438)_ (19,930) (22,421L (24,912) (27,403) (29,894) (29,894) Combined Income ., July '10 Aug '10 Sept '10 Oct '10 Nov '10 Dec '10 I Jan '11 Feb '11 Mar '11 Apr '11 May '11 June '11 TOTAL Potential Mo. 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 16,683 200,194 Potential YTD 16,683 33,366 50,048 66,731 83,414 100,097 116,780 133,462 150,145 166,828 183,511 200,194 200,194 •.•.•........-. ........... •.•.•.•..... ........ Projected Mo 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 14,561 174,734 Actual Mo - - - - - - - - - - - +/- Proj Mo (14,561) (14,561) (14,561). (14,561) (14,5611 (14,5611_ (14,561) (14,561) (14,561) (14,561) (14,561) (14,561) (174,734) :::::::::::::i::: ti::::1:i::: ::::::i:]:i :::::::i::::::::::i:i::::i::::i::::i:i::::: :::i::i:iri: ::i::::::::: :::::i:::: •:-:::•:•:•: .•..•.•.•. •.•.• •.•.-.•.•......•.•.• ... . .... •.•.•.•.•.•.•. •. •....• . .•..•..•.-. - . . .• . . . Projected 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 Actual YTD - - - - - - - - - - - +/- 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 10-11 Projected Revenues