Income Statement Bal Sheet by coryelJudie

VIEWS: 37 PAGES: 3

									Department of Administrative Services
Information Technology Enterprise
IOWAccess Fund
Statement of Changes in Net Assets (Income Statement)
June 30, 2007

                                                                                                                                                                                                                                                                       YTD
                                                                                                                July           August         September       October   November December       January      February   March      April      May          June       FY 2007
Resources:
  Appropriation                                                                                                 83,333          83,333              83,333    750,000          0           0            0          0          0                                        1,000,000
  Interest Income                                                                                                8,333           8,333               8,333      8,333      7,955       6,567       11,596     13,668     13,974     9,651       9,571       4,852        111,167
  Fees-DMVR                                                                                                    186,867         203,178             169,992    184,275    165,333     202,875      259,422    211,275    228,297   222,405     221,562     209,079      2,464,560
Total Revenues                                                                                                 278,534         294,845             261,659    942,608    173,288     209,442      271,018    224,943    242,271   232,056     231,133     213,931      3,575,727

Expenditures:
  Technology Governance Board (TGB)
     Personal Services / benefits & EA Research                                                                       0          60,246             46,858          0          0           0          0.00         0          0         0         0.00            0      107,104
  Travel, IOWAccess Advisory Council                                                                                141              90                141          0          0           0        234.84         0         94         0       440.66                     1,141
  Travel, Other                                                                                                     860              75                  0          0          0           0          0.00         0          0         0         0.00                       935
  Professional Services for eGovernment Maintenance                                                              90,319          98,203             82,164     89,068     79,911      98,056    125,387.30   102,116    110,331   107,496   101,337.60    101,079      1,185,467
  ITE Support Costs
     Internet Connections/Communication Costs                                                                     2,122           2,122              2,122      2,122      1,987       4,304        166.13       700      2,600     2,017     2,016.74      2,017        24,294
     Application Support                                                                                         60,586          60,586             60,112     60,428     60,428      60,428     60,428.03    60,428     60,428    60,428    60,428.03     60,428       725,136
  Data processing - sw & hw / license fees & maintenance                                                            985               0                  0        480        625           0          0.00         0          0         0         0.00          0         2,090
  Other Expenses                                                                                                      0               0                  0          0          0           0          0.00       125      1,027        19        19.35        (19)        1,171
  IAAC Projects: Application Development & Support
     Remaining balance on projects approved prior to 7/1/2005                                                    (5,183)         72,966            (44,363)    14,861     16,024      12,791     11,079.49    16,818     10,712    10,292    13,385.02     45,052       174,435
     Remaining balance on projects approved during FY2006                                                        21,791          35,690              6,006     13,749      5,759      17,926     20,378.60     6,727     28,529    13,894    13,766.91      4,970       189,187
     New project costs                                                                                           44,416           6,997            112,751     73,996     51,029      49,706     40,313.35    21,557     23,532    35,167    44,320.44     95,055       598,840

Total Expenditures:                                                                                            216,036         336,974             265,792    254,703    215,763     243,211      257,988    208,472    237,254   229,313   235,714.75    308,581      3,009,800



Increase (decrease) in Net Assets                                                                                62,497         (42,129)            (4,134)   687,905     (42,475)   (33,769)      13,030     16,471      5,017     2,743    (4,581.70)   (94,650)    565,927.00

Net Assets beginning of Year                                                                                                                                                                                                                                           1,821,532

Net Assets, current                                                                                                                                                                                                                                                    2,387,459



Department of Administrative Services
Information Technology Enterprise
IOWAccess Fund
Statement of Net Assets (Balance Sheet)
June 30, 2007

ASSETS:                                                                                                           AMOUNTS
                                                                                                                   ........
  Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,617,905 . . . . . . . . . .
                                                                                                                           .
  Accrued Appropriation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 0 . . . . . . . . . . . .
                                                                                                                      28,106
  Accrued Receivables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
                                                                                                                   2,646,011

LIABILITIES:
                                                                                                              ......
   Accrued Payables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 258,553. . . . . . . .

                                                                                                              ........
NET ASSETS: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2,387,459 . . . . . . . . . .




                                                                                                                                                                                                                                                                         Page 1 of 3
9d6a3182-df78-4e03-afc6-1b20ae0cf03c.xls Income Statement & Bal Sheet                                                                                                                                                                                                     8/18/2009
                                                                                                              Original    Current
     Sub-                                                                                    FY      %        Amount      Amount     Amount        Remaining
PACE Org Project Short Name                                                                Funded Complete   Approved    Approved    Spent *        Balance      Jun-2007
072L     03   DIA - Social Gambling Online - 2 - Execution                                  FY04    99.86%      55,000      87,000     86,876            124
072P     10   DHS - Food Stamps Web Intake - 2 - Execution                                  FY04    54.62%     100,000     100,000     54,617          45,383     34,035
073D     13   ITE - Full-time position to support IOWAccess                                 FY05    99.88%     100,000      97,500     97,382            118      10,171
072T     14   DPS - Criminal History Online - 2 - Execution                                 FY04    47.33%      47,375      69,375     32,837          36,538        846
072V     16   ITE - Enterprise Lyris List Manager - 2 - Execution                           FY05    88.84%     150,040     150,040    133,295          16,745
073G     25   ITE - Small Project Reserve                                                   FY05    45.25%     150,000     175,000     79,187          95,813
073I     27   JB - Attorney Licensing - 2 - Execution                                       FY05    97.18%      38,875     234,830    228,200           6,630
073O     33   DPH - BoME Physician Credentialing Data Migration - 2 - Execution             FY06     0.00%       5,000       5,000             0        5,000
073R     36   Comm - ABD Order Entry & Liquor Inventory - 1 - Planning                      FY06     0.90%      90,000      90,000        806          89,194
073S     37   Comm - ABD Licensing & Regulatory Documents Online - 1 - Planning             FY06     1.79%      45,000      45,000        806          44,194
072C     40   DIA - Targeted Small Business Online - 3 - Hosting                            FY04     0.00%      12,000      12,000             0       12,000
072J     41   DIA - Social Gambling Online - 3 - Hosting                                    FY04     0.00%      12,000      12,000             0       12,000
              LOC - County Real Estate Electronic Government Advisory Committee Web
073F     47
              Application                                                                   FY06   100.00%      25,000      25,000     25,000               0
073W     49   ITE - Schools Out Notification System - 2 - Implementation                    FY06   100.00%      50,000      57,659     57,659              (0)
              DNR - Electronic Access to Iowa's Water Pollution Control Permits - 2 -
071A     53
              Implementation                                                                FY06    47.67%      60,000     197,900     94,339         103,561      4,970
              DNR - Electronic Access to Iowa's Water Pollution Control Permits - 3 -
071B     54
              Hosting and Authentication/Authorization                                      FY06     0.00%       6,000       6,000             0        6,000
              LOC - City of Dubuque existing Incident Tracking System improvements - 3 -
071C     55
              Execution                                                                     FY06    29.40%      15,000      15,000      4,410          10,590
077L     56   DIA – Food Inspections Website Enhancements - 1 – Planning                    FY07    99.99%      10,500      10,500     10,499               1
077P     57   DALS – FARMS Project - 2 - Implementation                                     FY07   104.66%     295,000     295,000    308,739         (13,739)    13,989
077B     58   DIA - Map Locator & Food/Lodging Licensing - 3 - Hosting                      FY07   100.00%      76,000      76,000     76,000               0
077D     59   IGOV - Admin Rules - 3 - Hosting                                              FY07     0.00%       3,000       3,000             0        3,000
248E     60   DNR - Onsite Wastewater Construction Permits - 2 - Execution                  FY07     0.00%     150,000     197,000             0      197,000
248G     61   DNR - Environmental compliance and Enforcement Tracking - 1 - Planning        FY07    99.69%      20,000      55,000     54,829            171       7,804
248L     62   DNR - Hunter Safety Education - 1 - Planning                                  FY07    37.07%      20,000      70,000     25,950          44,050      1,354
269K     63   ITE - Schools Out Notification System - 3 - Hosting                           FY07     0.00%       8,900       8,900             0        8,900
269L     64   ICAB - Child Advocacy Online - 1 - Planning                                   FY07    73.39%      20,000      20,000     14,678           5,322        275
269M     65   ICRC - Civil Rights Public Interface - 2 - Execution                          FY07    10.40%      90,000      90,000      9,358          80,642      3,595
269N     66   ICRC - Civil Rights Public Interface - 3 - Hosting                            FY07     0.00%       7,140       7,140             0        7,140


                                                                                                                                                                      Page 2 of 3
9d6a3182-df78-4e03-afc6-1b20ae0cf03c.xls Requests                                                                                                                      8/18/2009
                                                                                                                 Original        Current
     Sub-                                                                                  FY      %             Amount          Amount          Amount         Remaining
PACE Org Project Short Name                                                              Funded Complete        Approved        Approved         Spent *         Balance         Jun-2007
269O     67   ABD - E-Licensing Application Enhancements - 2 - Execution                  FY07     100.00%          49,999          49,999          49,999                  0     49,999
              DNR -Hazardous Substance Incident Database Conversion – 1 - Scope
2738     68
              Analysis                                                                    FY07      16.71%          20,000          20,000            3,341           16,659         846
273F     69   IDED - One-Stop Business Shop Project – 1 - Scope Analysis                  FY07      31.83%          20,000          20,000            6,366           13,634       2,200
273I     70   DNR - Boat Dock Registration System – 1 - Scope Analysis                    FY07      55.94%          20,000          20,000          11,188             8,812       2,326
              LOC - County Real Estate Electronic Government Advisory Committee Web
2410     71
              Application - 2 - Implementation                                            FY07      24.24%         146,000         146,000          35,396          110,604        9,813
282U     72   ICAB - Iowa Child Advocacy Board (ICAB) Online                              FY07        0.00%         45,000          45,000                 0          45,000
2839     73   LOC - County MIS (CoMIS) Project                                            FY07        0.00%         20,000          20,000                 0          20,000
283L     74   DOM - Web-Based Property Valuation Submission                               FY07      18.72%          20,000          20,000            3,743           16,257       2,855
283O     75   DHS - DHS Single Online Application Process                                 FY07        0.00%        100,000         100,000                 0        100,000
                                                                                                    56.75%       2,102,829       2,652,843       1,505,500        1,147,343      145,077
              * monthly totals rolled into Amount Spent
              Note: Thirty-seven projects have been closed. The amount spent was $2,712,277                                                                           ..
                                                                                                 Remaining unobligated cash . . . . . . . . . . . . . . . . . . . . .1,240,115




                                                                                                                                                                                      Page 3 of 3
9d6a3182-df78-4e03-afc6-1b20ae0cf03c.xls Requests                                                                                                                                      8/18/2009

								
To top