The URL can be used to link to this page

Home My WebLink AboutResolutions - 1999.06.10 - 25772MISCELLANEOUS RESOLUTION #99141 June 10, 1999 By: FINANCE COMMITTEE, SUE ANN DOUGLAS, CHAIRPERSON IN RE: DEPARTMENT OF MANAGEMENT & BUDGET - FISCAL YEAR 1999 SECOND QUARTER FINANCIAL FORECAST AND BUDGET AMENDMENTS To the Oakland County Board of Commissioners Chairperson, Ladies and Gentlemen: WHEREAS Public Act 621 of 1978, the Uniform Budgeting and Accounting Act for Local Units of Government, provides for adjustments to the adopted budget; and WHEREAS in accordance with Oakland County General Appropriations Act Section 22, which authorizes budget adjustments for variances between the budgeted revenue and actual revenue, and Section 23, which authorizes budget adjustments for variances between estimated revenue and projected expenditures, adjustments are required; and WHEREAS the Fiscal Year (FY) 1999 Second Quarter Financial Forecast Report has identified several variances and budget amendments are recommended; and WHEREAS the Fiscal Services Division has verified Health Division CRIMP savings in the amount of $228,812 in FY 1998 from the contracting of the dental clinic operations and in accordance with the CRIMP resolution (M.R. #93106) 60% of these funds are allocated to the Health Division and 40% are retained by the General Fund; and WHEREAS in anticipation of FY 1999 Health Division CRIMP savings related to the second year of the contracting of dental clinic operations, an allocation to the CRIMP Fund is required; and WHEREAS to continue the development of the Geographic Information System (GIS) application to meet the needs of County departments and communities, as well as the public through the enhanced access system, an allocation from the Designated Fund Balance for GIS is required to provide additional professional services assistance in the Planning and Development Division as well as Information Technology; and WHEREAS funds are available in the Designated Fund Balance for Imaging Loan Payoff to be allocated to Information Technology to pay off the Imaging loan, and accumulated interest, from the Delinquent Tax Revolving Fund saving the cost of future interest; and WHEREAS once the allocation is made to payoff the imaging loan, sufficient funds will exist in this designated fund balance, along with general operating favorability, to cover the cost of remodeling the basement of the Information Technology building, and other County structures, to accommodate additional training classrooms; and WHEREAS the Clerk's Register of Deeds Division has experience increased overtime due to increased real estate activity and the County Clerk's Division has experienced increased Date Processing cost due to tracking of Family Court Activity; and WHEREAS the Clerk/Register of Deeds continues to generate additional mortgage, land transfer tax and recording fees revenue, to cover the increased costs within the Clerk/Register area as well as cover the various over- expenditures in other departments; and WHEREAS unplanned leave of absence have overextended the Division III (Rochester Hills) overtime budget, and Division II (Clarkston) received a mid- year rent increase which was not budgeted; and WHEREAS additional revenue can be recognized in Division III to cover these unanticipated needs; and WHEREAS the original budget for the Drain Commissioner included funding in a maintenance account which actually is transferred to the General Fund, a correcting amendment is requested; and FINANCE COMMITTEE VOTE: Motion carried unanimously on a roll call vote with Friedman Appel absent. WHEREAS the Medical Examiner's Office continues to face an increase in the number of autopsies requiring expanded use of the contracted services autopsy line-item, the Department of Human Services has favorability in the Children's Village Division due to the renegotiation of the Children's Village School contract which can be used to cover the increased Medical Examiner expense; and WHEREAS due to changes in the operation of the Jail Health Clinic, some procedures have been shifted from the hospital to inside the clinic, this change has caused an increase in the medical supply expense, however this increase can be offset by the reductions in hospitalization of prisoners as well as favorability in out-county prisoner housing; and WHEREAS the Sheriff requires additional capital outlay funds to complete the refurbishing of the training and range areas; and WHEREAS Community Mental Health (CMH) Board per diems are now being paid directly from CMH, this accounting change was not anticipated in the FY 1999 budget ; and WHEREAS the Library Board is experiencing revenue loss due to changes in library patron practices requesting information through CD Rom rather than through photocopying and computer research services; and WHEREAS due to reduced use by CMH and the internal service funds, Corporation Counsel's Reimbursement of Salaries revenue will fall short of budget, however favorable salaries and fringe benefits will offset most of this revenue loss; and WHEREAS the Medical Care Facility has changed the accounting method for Health Division laboratory charges, basing the charge on actual third party payments rather than established charges, the Health Division revenue budget must be reduced to accurately reflect the revenue; and WHEREAS the payment from the State of Michigan for the Convention Facility Development Fund was $351,418 above the amount budgeted, 50% of this amount must, by state law, be allocated to the Health Division to assist in funding substance abuse prevention programs; and WHEREAS due to the recognition of an indirect cost payment from Community Mental Health, the General Fund's indirect cost revenue line item will exceed budget, this favorability can be used to offset additional expenditures; and WHEREAS the County Executive has need for additional appropriation to support the basic office functions of printing, postage, and data processing supplies; and WHEREAS in order to meet the expanding demands on the communications system, the Radio Fund is required to upgrade and repair the 806 MHZ equipment currently being used to support a portion of the system; and WHEREAS use of emergency salaries continues to rise as departments attempt to meet increasing work loads in the face of unexpected short term absences; and WHEREAS due to the success of the Information Technology Leadership Groups, an additional appropriation is required to cover the cost of increased office automation as well as information technology operations in the various General Fund/General Purpose operations; and WHEREAS the FY 1999 non-departmental Contingency Account requires an additional appropriation to last for the end of the year; and WHEREAS Section 24 of the General Appropriations Act requires that a Status Report on Appropriations Carried Forward be incorporated as part of the Second Quarter Financial Forecast for the purposes of determining the continuation of unspent carried forward funds, pursuant to M.R. 93156; and WHEREAS Section 25 of the General Appropriations Act requires that the Board of Commissioners receive a quarterly report regarding adjustments made to Inmate Accounts on transactions billed in excess of ability to pay, as well as approve the write-off of any bad debt in excess of $1,000. NOW THEREFORE BE IT RESOLVED that the Board of Commissioners accepts the Fiscal Year 1999 Second Quarter Financial Forecast. BE IT FURTHER RESOLVED the Board authorizes amendments to the FY 1999 Budget as detailed on attached Schedules A and B. BE IT FURTHER RESOLVED that the Fiscal Services Division has verified Health Division CRIMP saving in the amount of $228,812 in FY 1998 due to the contracting of the dental clinic operations be allocated to the Health Division as specified below: HEALTH FUND Revenue 90-430000-34000-1701 Expenditure 16-201200-10000-2448 Transfer from CRIMP Health - Budgeted Projects $228,812 $228,812 BE IT FURTHER RESOLVED that to continue the development of the GIS application to meet the needs of County departments and communities, $200,000 from the General Fund Designated Fund Balance for GIS be appropriated as specified below: GENERAL FUND Revenue 90-190000-14000-1582 Use of Prior Years' Balance Expenditures 19-224000-14061-3348 Planning & Dev. - Prof. Services 90-210000-21000-8001 Trans. to Info. Tech Fund $200,000 $ 18,000 182,000 $200,000 0 INFORMATION TECHNOLOGY FUND Revenue 18-636113-95000-1701 Trans Expenditures 18-636172-95000-3348 IT - 18-636172-95000-3596 IT - • In from General Fund $182,000 Professional Services $127,000 Software 55,000 $182,000 0 BE IT FURTHER RESOLVED that $3,400,000 from the Designated Fund Balance for Imaging Loan Payoff be allocated, as specified below, to the Department of Information Technology in order to pay the loan and accrued interest, and to the Department of Facilities Management in order to remodel the basement of the Information Technology building, providing Information Technology with additional classrooms for training: GENERAL FUND Revenue 90-190000-14000-1582 Prior Years Balance Expenditure 90-210000-21000-8001 Oper. Trans.- Out to IT 90-210000-21000-8001 Oper. Trans.- Out Work Proj. INFORMATION TECHNOLOGY FUND Revenue 18-636113-10000-1701 Operating Tran. - In Expense 18-636112-15000-3965 18- 63 6113-100 00-8 005 Interest Expense Change in Fund Equity $3,400,000 $2,671,100 728,900 $3,400,000 0 $2.671,100 $ 49,000 $2.622,100 $2,671,100 0 BE IT FURTHER RESOLVED in accordance with Section 24 of the General Appropriations Act, the Board of Commissioners approves the continuation of the unspent carried forward appropriations listed on Schedule C. BE IT FURTHER RESOLVED that the recaptured funds listed on Schedule C, in the amount of $71,000, shall be reappropriated to the non-departmental Office Automation account (490-290000-25000-9066). Chairperson, on behalf of the Finance Committee, I move the adoption of the foregoing resolution. FINAE COMMITTEE II Div. III - Ord., Fines and Costs Div. III - Overtime Div. II - Rent Infrastructure Maintenance Oper. Trans. Out - General Fund $32,30S) $20,000 12,3_00 $32,300 $11 ($53,199) 53.199 $1 Mortgages Overtime Data Processing Supplies $111.000 $60,000 51,100 $111,100 so Department of Human Services - CRIMP Funding Rev_e_n_ue 90-440000-31000-1701 Expenditure 16-259003-80000-8001 Department of Human Services - Inter- Departmental Transfer 16-555200-25050-3684 CV - Teacher Services 16-912000-15000-3156 Medical Examiner - Autopsies $243,917 $234,917 so ($15,000) 15,000 Operating Transfer-In Oper. Trans. Out - Health Schedule A OAKLAND COUNTY, MICHIGAN FISCAL YEAR 1999 SECOND QUARTER BUDGET AMENDMENTS GENERAL FUND/GENERAL PURPOSE (GF/GP) ACTIVITIES ACCOUNT NUMBER ACCOUNT NAME FY 1999 AMENDMENT GF/GP OPERATIONS - SELF BALANCING AMENDMENTS Clerk/Register of Deeds Revenue 21-140100-01000-0705 Expenditures 21-240100-01000-2002 21-221000-01000-4040 District Courts Revenue 32-401100-20001-0753 Expenditures 32-401200-20001-2002 32-301200-20001-3476 Drain Commissioner 61-211001-10000-9163 61-311001-20900-8001 7 Convention Facility Tax Payment $351,418 Indirect Cost Recovery 948,316 Cigarette Tax 100,000 $1,399,734 $3,072.234 Sheriff Department 43-023310-20021-2920 43-023310-20021-3268 43-023310-20021-4240 Hospitalization of Prisoners Outside County Housing Medical Supplies ($250,000) (100,000) 350.000 SO GF/GP OPERATIONS - GENERAL AMENDMENTS Revenue Regisier of Deeds 21-140100-01000-0625 21-140100-01000-0705 21-140100-01000-0841 Board of Commissioners 51-110000-10000-0775 Libra_ly Bo_a_r_d 51-132000-53000-0389 51-132000-53300-0399 Corporation Counsel 11-150100-20000-0907 Health Division 16-212100-60002-0617 Land Transfer Tax Mortgages Recording Fees Per Diem Computer Research Fees Copy Machine Charges Reimbursement of Salaries Laboratory Charges $1,000,000 689,000 200.000 $1,889,000 ($10,000) ($4,500) (9,000) ($13,500) ($107,000) ($86,000) Non-Departmental 90-130000-12000-0211 90-130000-12000-0585 90-130000-12000-0205 Total Revenue Expenditures SheriffDepailment 43-023310-20021-9169 C_QuritExecutive 11-210100-01000-3324 11-210100-01000-4040 11-210100-01000-4284 Capital Outlay Printing Data Processing Supplies Postage $70,000 $4,000 5,000 $12,000 Salaries Fringe Benefits Satellite Centers Trans. Out - Work Projects Trans. Out - Radio Fund Emergency Salaries Office Automation Contingency Schedule B ($54,000) (21,000) ($75,000) $175,709 $69,000 399,400 153,700 700,000 100,000 $1,422,100 $1,467,425 $1012.234 SO Corp_oration Counsel 11-250100-20000-2001 11-250100-20000-2075 Health_Division 16-261200-75000-3544 Non-Departmental 90-210000-21000-8001 90-210000-21000-8001 90-290000-25000-9078 90-290000-25000-9066 90-290000-25000-2564 Information Tecnoloay Total Expenditures TOTAL GF/GP OPERATIONS Prepared by: Fiscal Services 05/18/99 I' r Information Technology 1999 2nd Quarter LT. Operations SCHEDULE B DEPT/OCA/PCAl0b1ect 6636 18-636111-10000-0737 32-201200-20001-6636 32-205200-20006-6636 32-301200-20001-6636 32-305200-20006-6636 32-401200-20001-6636 32-405200-20006-6636 32-501200-20001-6636 32-505200-20006-6636 17-802200-10001-6636 11-220100-10000-6636 51-211000-10000-6636 16-501200-25001-6636 16-555200-25050-6636 31-101200-10001-6636 17-901200-90001-6636 21-220100-1000-6636 21-230100-1000-6636 21-250100-1000-6636 21-221000-1000-6636 21-220500-1000-6636 21-240100-1000-6636 19-698402-60006-6636 11-210500-01000-6636 19-210000-10000-6636 17-502200-50130-6636 17-501200-10001-6636 11-250100-20000-6636 11-210100-01000-6636 19-221000-10000-6636 61-211001-10000-6636 19-240000-40016-6636 14-211000-30000-6636 14-280000-10000-6636 12-601200-10001-6636 12-621200-10001-6636 31-201200-10004-6636 16-201200-10000-6636 12-622222-27001-6636 16-234200-80000-6636 16-232200-80000-6636 16-220200-65000-6636 16-236200-80000-6636 16-215200-80000-6636 31-1200-10002-6636 16-912000-15000-6636 15-402200-10001-6636 17-402220-70111-6636 17-302202-97000-6636 13-667302-10-6636 34-101200-40001-6636 34-401200-40001-6636 41-211000-10000-6636 12-401200-40010-6636 13-660200-10-6636 13-138203-10-6636 12-705212-10001-6636 12-701200-10001-6636 51-233000-53500-6636 43-023310-20021-6636 14-211000-30000-6636 13-138201-10-6636 22-221120-1000-6636 17-302200-30001-6636 Budgeted Depts.-Oper. 52/1 D.C. - Novi 51/1 Probation 5212 D.C. - Clarkston 52/2 Probation 52/3 D.C. - Rochester 53/2 Probation 5214 D.C. - Troy 52/4 Probation Animal Control Auditing Bd of Commissioners Children's Village Children's Village School Circuit Court Circuit Court Probation Clerk - Admin. Clerk - Elections Div. Clerk - Jury Commission Clerk - Legal Records Clerk - Vital Statistics Clerk/Reg of Deeds Admin Comm Dev.-Housing Counselor Comm Min/Cultural Affairs Comm & Economic Dev. Coop Ext - Gypsy Moth Co-op Extension Corporation Counsel County Executive Development & Planning Drain Commissioner Equal Master Appraisal Facilities Management Facility Engineering Fiscal Services-Admin Fiscal Services-General Friend of the Court Health Health- Accounting Health-Clinic Health-Dental Health-Environmental Health-Field Nursing Health-Jail Integrated Drug Mgmt. Medical Examiner Personnel-Human Res. Div. Pre-Trial Services-County Pre-Trial Services Grant Print Shop Probate-Juvenile Probate Court Prosecutors Office Purchasing Radio Communications Record Retention Reimb.-Child Support/FOC/Reimb. Reimbursement Research Library Sheriff-Corrective Services Solid Waste Support Services Treasurer Veterans Services 1.467_42A FY 1999 Customer Number 540 541 550 551 560 561 530 531 630 620 5 665 666 420 450 725 440 410 724 723 720 435 17 785 711 710 430 15 775 730 742 755 752 660 670 470 840 841 645 844 843 847 842 421 872 680 658 654 643 481 480 145 690 790 637 400 650 907 195 753 445 600 910 1999 2nd Qtr. Adopted 1st Qtr. 1999 Amended Budget 1299 Eortcast Budget 312.133 83,482 356,728 44,595 16,749 1,314 5,256 (11,493) 117.927 31,468 135.532 17,605 10,806 2,424 9696 (1,110) 279,538 59,945 268,613 (10,925) 27.335 6,603 26,412 (923) 183,719 49,447 209,035 25,316 16,524 2,736 10,944 (5,580) 37,775 11,861 46,961 9,186 71,297 22,208 92,429 21,132 120.000 37,710 140,901 20,901 414,360 103,266 413,064 (1,296) 53.123 0 0 (53,123) 585,932 163,052 666,857 80,925 87,013 21,619 87,208 195 15,000 5,127 19.752 4,752 32,500 13,236 51,265 18,765 64,363 3,687 15,999 (48,364) 35.272 12,924 49.491 14,219 18,000 4,851 24,954 6,954 411,500 138,015 556,350 144,850 0 1,878 7,512 7,512 24,767 2,673 10,692 (14,075) 6.821 0 0 (6,821) 9.765 1,350 7,968 (1,797) 63,742 12,352 65,870 2,128 76,402 25.051 99,864 23,462 102,836 42,665 170,660 67,824 208,308 80,091 329,388 121,080 49,311 11,849 49,126 (185) 663,653 161,301 645,204 (18,449) 68,491 22,230 88,920 20,429 44,987 12,345 49,880 4,893 316,172 99,363 400,930 84,758 62,000 19,308 80,432 18,432 440,700 84,599 360.462 (80.238) 828.526 236,656 941,900 113,374 5,200 312 1,248 (3.952) 1.492 756 3,024 1,532 3,197 813 3,252 55 141,488 56,677 151,220 9,732 217 5,562 22,248 22,031 20,000 5,631 22,524 2,524 2,910 234 936 (1,974) 108,703 32,568 45,616 (63,087) 283,015 95,913 386,558 103,543 16,716 14,084 56,100 39,384 0 12,780 50,964 50.964 14,000 4,827 19,308 5,308 197,000 103,449 396,000 199,000 464,868 131,635 526.470 61,602 745,025 224,580 903.558 158.533 113,352 18,081 75.390 (37,962) 10,000 8,720 34.540 24,540 10,965 6,940 32,898 21,933 171,095 26,767 107,086 (64,009) 254,074 75,113 302,162 48,088 206,464 4,410 17,640 (188,824) 1,687,419 460,745 1,857,706 170,287 68,491 22,230 88,920 20,429 14.000 6,846 27,384 13,364 200.914 69,286 276,642 75,728 65,087 20,942 83,158 18,071 2ADJ.WK4 1 04/27/99 10 Information Technology 1999 2nd Quarter 13. Operations MAWS FY 1989 Customer DEPT/OCA/PCA/Object Number 6636 900 18-221112-60000-6636 EMS Disaster Control 828 51-231000-53000-6636 Research Library 824 51-232000-53300-6636 Law Library 1999 2nd Qtr. Adopted 1st Qr. 1999 Amended Budget 1999 &mak Budget 27457 29,706 29,706 2,249 82176 36,261 145,044 62.868 0 24,130 96.520 96,520 1,467,425 Information Technology 2nd Quarter Adjusbnents 1-18435121-20000-1701 3-18-635121-20000-0737 Fund US CLEM Operating Transfer In O.C. Debt Oper.-(Sheriff Contracted Services) 2nd Q. Adopted 2nd Ott Amended beam amendment SSW 27.000 (27,000) 0 Redistribute Sheriff Revenues O 27.000 27.000 1-18-836111-10000-0429 1-18-636111-10000-0575 1-18-636111-10000-0735 1-18-636111-10000-0759 1-18-636111-10000-0903 2-18-636112-10000-2304 2-18-638142-15000-2376 2-18-636112-10000-3476 Fund 636 LT. Deferred Land File Tax Bills Imagitg-Operations OC Depts.-Div/Support Outside Agencies Reimb.-Equalizabon Services Accounting Services Auction Expense Rent 330.105 (186.547) 163,558 693,000 (264.060) 428,940 3,433.000 68.392 3,501,392 850,693 (278.009) 572,684 239,363 (44.398) 194,967 O 42.486 194,967 O 4.000 194,967 0 26534 26.534 5,546.161 (611,800) 5,278.009 29,614.10 10,604.50 3,995.01 697.50 25,000.00 54,873.07 8,426.32 OK'd OK'd OK'd 311103HOS -0- $6,483.85 10,604.50 $ 2,870.90 23,614.10 -0- OK'd OK'd 3,995.01 697.50 19,244.24 -0- -0- -0- 5,755.76 54,873.07 Status Report 1998 Carry Forward Appropriation March 31, 1999 General Fund 101 Authorized Amount Amount Utilized Status 03/31/99 Carry Forward Request Recommendation Fiscal Services - Reimbursement 12 701200 10001 4100 Capital Outlay $ 2,870.90 Personnel 15 501200 10001 3348 Prof. Services Human Services 16 121000 10000 2448 Budgeted Proj. Veteran's Services 17 302200 30001 4100 Expend. Equip. 17 302200 30001 9169 Capital Outlay Community Corrections 17 403200 70231 3348 Prof. Services Information Technology 18 101122 95000 3348 Prof. Services Community & Economic Development - Equalization 19 240000 40001 9169 Capital Outlay -0- 8,426.32 OK'd -0- 80,000.00 20,123.76 30,381.15 19,043.20 OK'd OK'd OK'd OK'd 2,407.50 2,350.42 (1,105.69) (153.85) 7,835.27 176.41 11,510.06 OK'd OK'd OK'd OK'd OK'd _OK'd 366.90 -0- OK'd OK'd 9,267.80 -0- -0- Circuit Court 31 101200 10001 2448 Budgeted Pro. 5,129.08 5,129.08 31 101200 10001 3348 Prof. Services 80,000.00 -0- 31101200 10001 4100 Expend. Equip. 25,495.00 5,371.24 31 101200 10001 9169 Capital Outlay 67,869.95 37,488.80 31 105200 10001 4100 Expend. Equip. 32,548.88 13,505.68 Prosecutors - Drug Forfeiture 41 211000 30000 3348 Prof. Services 81,087.60 9,266.73 820.87 Return $ 71,000.00 Prosecuors- Citizens Grand Jury 41 215000 20000 2640 Defense Atty Fees 41 215000 20000 3016 Juror Fees & Mil. 41 215000 20000 3348 Prof. Services 41 215000 20000 3484 Reprt. & Steno 41 215000 20000 3836 Witness Fees 41 215000 20000 4292 Provisions Totals 4,017.50 1,610.00 10,275.92 7,925.50 1,219.31 2,325.00 16,515.15 16,669.00 12,134.26 4,298.99 226.35 49.94 44,388.49 32,878.43 Prosecutors 41 231000 30000 9169 Capital Outlay 366.90 -0- 41 211000 10000 9169 Capital Outlay 12,972.09 12,972.09 Drain Commission 61 211001 01000 9169 Non-Departmental 90 210000 21000 9069 90 210000 21000 2872 Remonumentation 37,614.75 Clemis Grant Mat. 6,382,384.00 Drain Infra. Maint. 9,267.80 -0- 37,614.75 6,382.384.00 12 705212 10001 4100 Expend. Equip. 12 705212 10001 9169 Capital Outlay 2,306.85 1,782.00 2,306.85 1,782.00 -0- -0- OK'd OK'd OK'd OK'd OK'd Friend of the Court 215 Health Fund 221 16 201200 10000 3196 Miscellaneous 16 261200 75000 3544 Satellite Centers 16 234200 80000 4360 Vaccines 16 201200 10000 2448 Budgeted Projects 240,224.00 -0- 240,224.00 760,919.61 647,849.69 113,069.92 45,927.00 49,927.00 -0- 28,335.41 -0- 28,335.41 C.R.I.M.P. 259 43 431001 20002 8001 Sheriff 22,500.00 -0- 22,500.00 OK'd 61 611001 10000 8001 Drain Commission 32,841.00 -0- 32,841.00 OK'd 16,259002 80000 8001 Health - Dental 228,812.00 -0- 228,812.00 OK'd SCHEDULE D . , , IN TE MEMO OF F ICE To: Tim Soave I _ft_ 4/%41% From: Holly Holly Conforti 41 CC: Raleigh Parrott Subject: Request to Write-off Receivable Date: February 19, 1999 In June of 1995 I had set up a receivable for the St. Vincent/Sarah Fisher Center in the amount of $4,123.20. This was regarding payment of board and care for a child by the name of Steven Arsenault that was paid in error out of the Juvenile Maintenance Fund. This child was later discovered to be a ward of the State of Tennessee. The Reimbursement Division has sent numerous letters to the social worker assigned to the case in Tennessee and to the worker of Lansing F.I.A. who works with Interstate Compacts and has had no success in repayment. I am requesting authorization to write off this receivable because Oakland F.I.A. and our Reimbursement Division doubt the bill will ever be paid. /6 FY 1999 SECOND QUARTER FINANCIAL REPORT GENERAL FUND/GENERAL PURPOSE REVENUE AND EXPENDIMRES SUMMARY BY DEPARTMENT FY 1999 BUDGET AMOUNT ADOPTED AS FY 1999 FAVORABLE/ BUDGET AMENDED FORECAST (UNFAVORABLE) PERCENT REVENUE GENERAL FUND Taxes $158,040,000.00 $158,040,000.00 $158,040,000.00 $0.00 0.00% Intergovernmental 32,287,800.00 32,287,600.00 34,362,200.00 2,074800.00 6.43% Charges for Services 84,335,132.00 62,538,549.00 86,479,452.00 3,942,903.00 6.30% Miscellaneous Revenue 20,351,700.00 20,351,700.00 19,851,700.00 (500,000.00) -2.46% SUB-TOTAL GENERAL FUND $275,014,432.00 $273,215,849.00 $278,733,352.00 $5,517,503.00 2.02% GENERAL PURPOSE FUNDS Intergovernmental $7,340,000.00 $8,839,910.50 $9,839,910.50 $1,000,000.00 11.31% Charges for Services 6,923,620.00 8,319,054.73 8,883,454.73 564,400.00 6.78% SUB-TOTAL GP FUNDS $14,263,820.00 $17,158,965.23 $18,723,365.23 $1,564,400.00 9.12% TOTAL GF/GP FUNDS $289,278,052.00 $290,374,814.23 $297,456,717.23 $7,081,903.00 2.44% Resources carried forward $4,433,450.00 $18,729,769.82 $18,729,769.82 $0.00 0.00% TOTAL GOVERNMENTAL RESOURCES $293,711,502.00 $309,104,584.05 $316,186,487.05 $7,081,903.00 2.29% .... ........ wx.......= EXPENDITURES ADMINISTRATION OF JUSTICE Circuit Court 52nd District Court Probate Court TOTAL ADMIN. OF JUSTICE $23,649,573.00 $24,439,386.02 $23,587,286.02 $852,100.00 3.49% 10,667,826.00 10,774,146.49 10,628,546.49 145,600.00 1.35% 21,834,671.00 21.970,825.18 21,439,725.16 531,100.00 2.42% $56,152,070.00 $57,184,357.67 $55,855,557.87 $1,528,800.00 2.87% LAW ENFORCEMENT Prosecuting Attorney $14,380,666.00 $14,866,978.08 $14,521,678.08 $345,300.00 2.32% Sheriff 72,563,097.00 74,217,889.48 73,583,889.48 634,000.00 0.85% TOTAL LAW ENFORCEMENT $86,943,763.00 $89,084,887.56 888,105,567.58 $979,300.00 1.10% GENERAL GOVERNMENT Clerk/Register of Deeds $8,576,971.00 $8,931204.43 $8,854,204.43 $77,000.00 0.88% Treasurer 2,905,811.00 3,049,530.32 - 3,124,530.32 (75,000.00) -2.46% Board of Commissioners 14,279,255.00 14,387,318.78 14,411,316.78 (24,000.00) -0.17% Drain Commissioner 6,822,124.00 2,896,368.94 2,930,533.00 (34,164.06) -1.18% TOTAL GENERAL GOVERNMENT $32,384,161.00 $29,284,420.47 $29,320,584.53 ($56,164.06) -0.19% couNre EXECUTIVE County Executive Admn. $4,322,634.00 $4.556,748.36 $4,583,748.36 ($27,000.00) -0.59% Management and Budget 15,704,533.00 17,231,458.72 18,970,808.72 280,850.00 1.51% Central Services 1,655.206.00 1,698,123.63 1,645,623.63 52,500.00 3.09% Facilities Management 2,760,083.00 2,064,449.35 1,835,584.00 228,885.35 11.09% Personnel 3,746,646.00 3,878,147.03 3,871,442.03 4,705.00 0.12% Human Svs. 51,377,389.00 53,853,397.11 53,548,997.11 304,400.00 0.57% Public Services 7,019,172.00 7,284,347.97 7,055,497.97 228,850.00 3,14% Information Technology 5,006,808.00 8,402,486.24 8,084,725.68 317,740.58 3.78% Community & Economic Dev. 4,022,288.00 4,062,097.43 4,042,097.43 20,000.00 0.49% TOTAL COUNTY EXECUTIVE $95,814,759.00 $103,029,235.84 $101,638,524.93 $1,390,710.91 1.35% TOTAL DEPARTMENTS $271,094,753.00 $278,562,881.54 $274,720,234.69 $3,842,646.85 1.38% NON-DEPARTMENTAL APPROPRIATIONS TOTAL NON-DEPARTMENTALS $22,616,749.00 $30,541,702.51 $30,347,434.88 $194,267.83 4.39% TOTAL GOVERNMENTAL EXPENDITURES $293,711,502.00 $309,104,584.05 $305,067,669.37 $4,036,914.88 1.31% ========== ars= General Fund/GenersIPurpose Favorable/(Unfavorable) $0 ($0) $11,118,817.88 $11,118,817.68 ww...====. ws.www REVENUE PROPERTY TAXES 1997 Tax Levy COUNTY OF OAKLAND FY 1999 SECOND QUARTER REPORT RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL SPECIAL REVENUE AND PROPRIETARY FUNDS FOR YEAR ENDING SEPTEMBER 30, 1999 BUDGET BUDGET AMOUNT AS AS FY 1999 FAVORABLE/ ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT $157345000.00 $15734500000 $15734500000 $0 00 000% NET CURRENT PROPERTY TAX $157,345,000.00 $15734500000 $15734500000 $0 00 000% OTHER TAXES Other Taxes $69500000 $695000 00 $69500000 $000 000% 695,000.00 695,000 00 695,000.00 0.00 000% TOTAL PROPERTY AND OTHER TAXES $158040000 00 $158,040,000 00 $158,040,000 00 $000 000% BUDGETED RECEIPTS OTHER THAN TAXES GENERAL FUND STATE AND FEDERAL Outside Agencies $32,287,600.00 $32,287,600.00 S34,362,200.00 S2,074,600.00 643% Increased Cigarrette Tax and Convention Facility Development fund payment (already TOTAL BUDGETED RECEIPTS received), as well as increased Indeed Cost revenue due to payment from CMH for GENERAL FUND STATE AND FEDERAL S32,287,600.00 $32,287,600 00 $34362200 00 $2,074,600 00 843% FY 1998 , CHARGES FOR SERVICES County Executive Administration $31,700. 00 $31,700 00 $31,700 00 $000 000% Auditing 117,400.00 303,759 00 303,759 00 0.00 000% Corporation Counsel 235,607 00 235,60700 128,60700 (107,000 00) -45 41% -Unfav due to decrease in utilization of services by CMH Authority and the undoubting and delay In hiring staff, offset by lay. Personnel expenses. A budget amendment Is recom. Fiscal Services 418,000.00 418,000.00 418,00000 aoo 0.00% Reimbursement Division 220,000.00 220,000.00 225,100.00 5,100.00 2.32% -Fey. unbudgeted Civil Action Entry Fees $574, Misc. $1,482 and Tax Intercept Fees $3,070. Central Services Administration aoo 0,00 70.00 70.00 G00% -Per Diems Materials Management 13,000.00 13,000.00 13,000.00 0.00 0.00% Support Services 71,800.00 71,800.00 71,800.00 000 0.00% Facilities Mgt. -Admin. 416,010.00 416,010.00 416,010 oo 000 0.00% Faciiies Engineering 16,470.00 16,470.00 16,470.00 0.00 0.00% Personnel 12,257.00- 12,257.00 25,057.00 12,80000 104.43% -Fay. Misc. Rev. $14,300 due to unbudpled funds to pay for Student Intern for Circuit Ct. arid Private pay; partially offset by unfav. Hasp. Admin. Chgs. ($1,500) due to lower costs. Family Independent Agency 500.00 500.00 0.00 (500.00) -100.00% -Historically has declined; no revenue enticpated for FY 1999 based on frst six months. Medical Examiner , 77,800.00 77,800.00 77,800.00 0.00 0.00% Pubic Services 11,300.00 11,30000 11,300.00 0.00 000% MSU Extension- Oaldend County 349,934.00 349,934.00 349,934.00 0.00 0.00% C:1;) 05/18/9909:26 AM 1 05118/99 REVENUE Community Court Services Development & Planning Equalization County Clerk Elections Register of Deeds Treasurer Circuit Court 109,694 00 631,000 00 1,650,041.00 1,774,160 00 10,400 00 8,099.593 00 4,580,865 00 3,070,550.00 122,244 00 631,000 00 1.650.041.00 1,781,760 00 10,40000 9.050,793 00 4,580.865 00 3,202,403 00 139.244 00 631,000 00 1.650,041.00 1,931,760 00 10,40000 11.050,79300 4,580,865 00 3,068,103 00 Friend of the Court 7,094,500 00 7,094.500 00 7,485,400 00 District Court 7,929,097 00 7,929.097 00 8,740,297 00 COUNTY OF OAKLAND FY 1999 SECOND QUARTER REPORT RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL SPECIAL REVENUE AND PROPRIETARY FUNDS FOR YEAR ENDING SEPTEMBER 30, 1999 BUDGET AS ADOPTED BUDGET AMOUNT AS FY 1999 FAVORABLE/ ADJUSTED FORECAST (UNFAVORABLE) PERCENT Probate Court 1391% -Duo to the sucess of WAM & expansion of the Step Forward program 000% 000% 8 42% -Far. Forfeiture of Bonds due to increased activity. 000% 22 10% - Fey Mortgages $800,000, Land Transfer Tax $1,000,000 and Recording Fees $200,000 due to high real estate activity 000 0.00% (134,300.00) -4 19% Unfav. Defense Att. Refunds ($8.600) reflect reduced ability to pay. Unfav. Mediation Fines, ($145,400) and Psychological Testing and Evauluation Fees ($11,600) due to reduced activity which is reflected in decreased expenditure. Fax Costs $31,300 is historically supported and reflects increased activity. 390,900.00 551% - Unfav. Miscellaneous ($47,900) due to change in recording fees, Unfav. Federal Incentive Payments ($121,700) reflects reduced rates and caseload. Fay CRP Contract $500.000 is historically supported, Fay. Alimony Service Fees, $60,500 reflects increased activity. 811,200.00 1023% - Fay. PSI/Alcohol assessments $76,600 and Probation Fees, $286,000; due to increased probation caseload FaV. Ordinance Fines & Costs $278.600; Bond Forfeiture $74,200, Late Penally $57,000. Filing Fees $22,100, end No Proof of Insurance Fee $32,300; reflect increased actively Attorney Fee reimbursement is fav. $6,200 State Lew Costs are unfav. ($21,800) due to fewer tickets being Issued on state laws. Far. Costs $4,600; and Clinic Evaluations $12,000 due to increased activity. Far. Bond Forfeits $5,000 is a new revenue Unfav. Certified Copies, ($33,100); Gross Estate Fees ($3,400); and Win Deposits ($6,400) are due to reduced demand 17,000 00 000 0.00 150.000 00 000 2,000.000 00 1,160,800 00 1,153,20000 1,131,900.00 (21.300.00) -1.85% Prosecutor Sheriffs Office Administrative Services Corrective Services 177,622.00 205,622 00 205,622.00 0.00 000% 10,800 00 185,800.00 222,800.00 37,00000 19.91% 1,500.00 1,50000 1,50000 0.00 0.00% 3,298,700.00 3,438,043.00 4,538,043.00 1,100,00000 31.99% -Fay. $26.000 SS Incentive Payments, Shared Bench Warrants and $11,000 NET Refunds. -Far $100.000 Inmate Board and Care, and $1,000,000 Diverted Felons underestimated. Corrective Services - Satellites Protective Services Technical Services Board of Commissioners Litrary Board Drain Administration Operations & Maintenance 1,375,275.00 1,375,725.00 1,375,725.00 000 16.230.672.00 16,588,533.00 16,588,533.00 0.00 256,600.00 256,60000 271,100.00 14,500.00 20,500.00 20,500.00 10,500.00 (10,000.00) 184,482.03 191,714.00 178,214.00 (13,500.00) 501,784.00 408,322 00 250,000 00 (158,322 00) 770,458.00 0.00 0.00 0.00 0.00% 0.00% 565% -Far. $12,403 reimb. NET salaries underestimated. -48 78% -Unfav. Per Diem revenue due to accounting change. A budgetamendment is recommended. -7.04% -Unfav. Computer Research Fees ($4,500) and Copy Machine Charges ($9,000) due to increased utilization of CD Rom products. A budget amendment is recommended. -38.77% Unfav. duo to reduced admin. set aspen. to other funds, & lower grant rev. realized this yr. 0.03% 2 05/1R/09 05/18/9909:26 AM COUNTY OF OAKLAND FY 1999 SECOND QUARTER REPORT RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL SPECIAL REVENUE AND PROPRIETARY FUNDS FOR YEAR ENDING SEPTEMBER 30, 1999 BUDGET BUDGET AMOUNT AS AS FY 1999 FAVORABLE/ ADOPTED ADJUSTED FORECAST (UNFAVORABLE) PERCENT REVENUE Engineering & Construction TOTAL CHARGES FOR SERVICES GENERAL FUND 3.404,26300 479,750 00 329,005 00 864,335,132.00 $62,536,549.00 866,479,452 00 (150,745 00) -31 42% Unfav due to reduced admin sal expen to other funds $3,942.903 00 630% BUDGETED RECEIPTS - GENERAL PURPOSE GOVT STATE AND FEDERAL Outside Agencies 87,340,00000 $8,839,910 50 $9,839,910 50 $1,000,000 00 11 31% Recognition of 50% Child Care Fund reimbursement already received and requested TOTAL BUDGETED RECEIPTS - GEN. PURPOSE 87,340,000 00 88.839,91050 89,839,910 50 $1,000.00000 1131% GOVT STATE AND FEDERAL CHARGES FOR SERVICES Facilities Management Admin. 2,210.00 2,210.00 1,1110.00 (400.00) -18.10% Health Division 2,173,91000 3,569,344.73 3,483,444.73 (85,900.00) -2.41% Revenue received from lab work is no longer based on established lab rates, but is now based on actual payments received by Medical Cans Facility per 3rd party peyors. There is an offsetting reduction in expense for lab services in MCF. A budget amendment is recommended. Children's Village 2,680.500.00 2,680,500 00 3,047,400.00 366,900 00 1369% -Primarily due to receipt and adjustment of prior years revenue. Animal Control 819,800.00 815,80000 819.800 00 000 0.00% Friend of the Court 437,200.00 437,200.00 404,300 00 (32,900 03) -7 53% -State Incentive unfav. ($19,900) due to formula change and reduced caseload. Unfav. FOC Filing Fees ($13,000) reflects reduced activity and is historically supported. Probate Court 810,000.00 810,00000 1,126,700 00 316,700.00 39.10% -Fav Board and Care, $189,600, and Gov't. Board and Care, $127,100 reflect increased activity and collection efforts. $6,923,620.00 $8,319,054.73 $8,883,454.73 8564,400 00 6.78% MISCELLANEOUS REVENUE Sundry 81050,000.00 81,050,000 00 81.050,00000 Investment Income 19,301,700.00 19.301,70000 *18,801,700.00 $0.00 0.00% (500,000.00) -2.59% Decrease in investment income due to interest credited to other funds. $20,351,700.00 820.351,70000 819,851,700 00 ($500,000 00) -2.46% RESOURCES CARRIED FORWARD 05/18/9909:26 AM 3 05/18/99 TOTAL AVAILABLE RESOURCES GENERAL FUND/GENERAL PURPOSE $346,033,268.00 $355,943,800 27 $363,025,703 27 1 99% $7,081,903 00 COUNTY OF OAKLAND FY 1999 SECOND QUARTER REPORT RECEIPTS AND EXPENDITURES FOR GOVERNMENTAL SPECIAL REVENUE AND PROPRIETARY FUNDS FOR YEAR ENDING SEPTEMBER 30, 1999 BUDGET AS ADOPTED BUDGET AMOUNT AS FY 1999 FAVORABLE/ ADJUSTED FORECAST (UNFAVORABLE) PERCENT REVENUE Prior Yeses Solana. OPERATING TRANSFERS $4,433,450 00 $4,433,450.00 $1872976982 $1872976982 $18,729,769.82 $18,729,769 82 $000 000% -- $0.00 0.00% $0 00 000% $52,321,766.00 $4683921622 $46,839,216 22 Less ()pirating Transfers NET GF/GP RESOURCES ($52,321,766.00) ($46,839,216 22) ($46,839,218 22) $293,711,502.00 $309,104,584.05 $316,186,487.05 $000 000% $708190300 2.29% 05/1819909:26 AM fie 14 0 triff 4 0.55% 6.39% $34,000.00 440,900.00 COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES CIRCUIT COURT ADOPTED BUDGET AMENDED BUDGET AMOUNT 1999 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating Friend of the Court Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $617640300 $6,209,379.00 $8,175.379.00 6,551.488.00 6,897,978.31 6,457,078.31 2,290.374.00 2,426,555.36 2,493,755.36 (67,200.00) -2.77% $15,018,265.00 $15,533,912.67 $15,126,212.67 $407,700.00 2.62% $8,598,798.00 $6,608,126.00 $6,516,526.00 $89,600.00 1.36% 584,513.00 585,083.54 449,983.54 135,100.00 23.09% 1,447,997.00 1,714,263.81 1,494,563.81 219,700.00 12.82% $8,631,308.00 $8,905,473.35 $8,461,073.35 $444,400.00 4.99% $12,775,201.00 $12,815,505.00 $12,691,905.00 $123,600.00 0.96% 7,136.001.00 7,483,081.85 6,907,061.85 576,000.00 7.70% 3,738,371.00 4,140,819.17 3,988,319.17 152,500.00 0.00% $23,649,573.00 $24,439,386.02 $23,587,288.02 $852,100.00 3.49% =mi.= == z======css=== = = == ==- Salary and fringe fay. $34,000 due to turnover. Fay. attorney fees-mediator $240,000 due to reduced activity. Fay. transcripts. and Court reporters, $80,000 reflect reduced demand. Psychological testing fay. $20,000, and Juror fees. $150,000 due to reduced demand and are historically supported. Visiting judges unfav. ($43,500) due to increased use. Guardian fees unfav. ($5,600) due to Increased use. Equipment rental unfav. ($4,000) due to increased billing. Unfav. information technology- operations ($83,200) will be amended at the second quarter forecast. Salary and fringe fay. $98,000 due to turnover. Overtime fay. $9,000. On call overtime unfav. ($17,400). Fay. indirect costs, $89,100 reflects salary fay. Fay. professional services. $35,900 due to changes in billing practices. Rent fay. $3,700 is historically supported and postage fey. $26,400 reflects reduced demand. Information tech. imaging-operations fay. $134,700 and information tech.-operations fay. $80,000 due to reduced billing. Stationary stores fav. $5,000 due to reduced use. Budget amendments at the second quarter will balance information technology - operations accounts across departments. District Court Administration Controllable Personnel Controllable Operating Non-Controllable Operating Division 1. Novi Controllable Personnel Controllable Operating COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES DISTRICT COURT AMOUNT ADOPTED AMENDED 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Non-Controllable Operating $110,881.00 $110,881.00 $82,381.00 $48,500.00 43.74% Fay. due to reduced demand on part time staff. 50,545.00 50,545.00 4,745.00 45,800.00 90.61% Fav. court reporters $9,600, and visiting judges $36,200, due to reduced demand. 0.00 0.00 0.00 0.00 $16142600 $181,426.00 $87,126.00 $94,300.00 58.42% $2,520,468.00 $2,528,011.00 $2,510,411.00 $17,600.00 0.70% Salary and fringe fay. $40,600 due to turnover. Overtime unfav. ($23,000) 878.620.00 888,816.89 879,118.89 9,700.00 1.09% Bank charges unfav. ($7,900) reflects rate increase. Training psyc. & med. exam unfav. ($17,100) reflects Increased usage and is offset by increased revenue. Fair. juror fees & mileage $5,000 Is historically supported. Rent fay. $20,700. Postage fav. $9,000 due to decreased demand. 401,637.00 418,798.43 440,298.43 (23,500.00) -5.64% Equipment rental fay. $2,000 due to decreased use. Information tech. - operations unfav. ($25.500) and will be adjusted with the second quarter forecast. $3,800,725.00 83,833,826.32 $3,829,828.32 83,800.00 0.10% Division 2. Clarkston Controllable Personnel $938,483.00 $941,011.00 $934211.00 $6,800.00 0.72% Salary and fringe fav. $5,600. Overtime fair. $1,200. Controllable Operating 292,798.00 293,936.98 304,738.98 (10,800.00) -3.67% Attorney fees unfav. ($7,000) due to new schedule. Custodial services fair. $2,700 is due to reduced demand. Juror fees and mileage fay. $3.800 and training psyc. and medical exam. fair. $3,000 reflects decreased usage. Bank charges unfav. ($1,100) due to rate Increase. Rent unfav. ($12,200) due to rate increase, budget amendment is requested. Non-Controllable Operating 174,377.00 190,674.75 207,574.75 (16,900.00) -8.86% Information tech.-operations unfav. ($13,200) will be adjusted with second quarter forecast. Radio communications unfav. ($3,700) due to installation of new equipment. $1,403,638.00 $1,425,622.73 $1,448,522.73 ($20,900.00) -1.47% Division 3- Rochester Hills . Controllable Personnel $2,184,883.00 $2,169,411.00 $2,189,411.00 ($20,000.00) -0.92% Overtime unfav. ($20,000) due to leaves of absence. Budget amendment is requested. Controllable Operating 631,164.00 831,184.00 617,264.00 13,900.00 2.20% Unfav, bank charges ($7,400) reflects rate increase. Fav. custodial services $19,000 due to billing change. Attorney fees unfav. ($5,000) due to new schedule; rent unfav. ($5,500) due to a rate increase, office supplies unfav. ($5,000) reflect increased demand. Fair. postage $10,000 reflects reduced usage. Non-Controllable Operating 373,809.00 395,321.98 369,921.98 25,400.00 8.43% Info. tech. - operations fav. $21,400 due to reduced billing. Print shop fav. $4,000 due to reduced use. Information technology charges will be adjusted at the second quarter. $3.169,838.00 $3,195,896.96 $3,176,598.96 $19,300.00 0.80% Division 4 - Troy Controllable Personnel $1,558,902.00 $1,581,840.00 $1,540,440.00 $21,200.00 1.38% Fay. salary and fringes $18,300 due to turnover and unfilled position. Overtime fay. $4,900. Controllable Operating 307,753.00 307,812.20 292,912.20 14,900.00 4.84% Unfav. bank charges ($8,400) reflects rate Increase. Fay. rent $7,000 is historically supported. Fav. attorney fees, $13,800; and professional services $7,000 reflect reduced demand. Unfav, training, psyc. & medical exams ($4,500) due to increased demand. Non-Controllable Operating 265,548.00 288,122.28 275,122.28 13,000.00 4.51% Fav. stationary stores $3,000 reflects reduced usage. Unfav, information tech. - operations ($16,000) will be corrected with the second quarter amendments. $2,132,203.00 $2,157,574.48 $2,108,474.48 $49,100.00 2.28% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $7,291,577.00 $7,310,954.00 $7,238,854.00 $74,100.00 1.01% 2,180,878.00 2,172,275.07 2,098,775.07 73,500.00 3.38% 1,215,371.00 1,290,917.42 1,292,917.42 (2,000.00) -0.15% $10,887,828.00 $10,774,148.49 $10,828,548.49 $145,800.00 1.35% Judlcial/AdmInistradon Controllable Personnel Controllable Operating Non-Controllable Operating Juvenile Maintenance Controllable Personnel Controllable Operating Non-Controllable Operating Judicial Support Controllable Personnel Controllable Operating Non-controllable Operating $58,200.00 63,000.00 0.00 0.84% 18.41% 0.00% COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES PROBATE COURT AMOUNT ADOPTED AMENDED 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES 92,339,401.00 $2,339401.00 $2,312,601.00 $26,800.00 1.15% Salary and fringe fav. $21,300 due to turnover. Overtime fay. $5,500 66,118.00 68,066.76 48.966.78 19,100.00 28.06% Fay. visiting judges, $10,000; and professional services, $6,600 due to reduced demand. Postage fay. $2,500 reflects reduced use. 552,331.00 591,534.52 784,034.52 (192,500.00) -32.54% Information tech.-operations unfav. ($199,000) will be adjusted at the second quarter. Copier fav. $1,500, and stationary stores fay. $5,000 due to reduced demand. $2,957,850.00 $2,999,002.28 $3,145,602.28 ($148,600.00) -4.89% $0.00 $0.03 $0.00 0.00% 4,095,973.00 4,095,973.00 3,942,973.00 153,000.00 3.74% Fay, foster boarding homes, $10,000; and pre adoptive care, $10,000 are historically supported. Fay. Sanctuary, $13,000 and wraparound services, $20,000 are new programs 33.00 33.00 33.00 0.00% not yet fully employed. $4,096,006.00 $4,096,006.00 $3,943,008.00 $153,000.00 3.74% $4,563,908.00 $4,563,908.00 $4,463,908.00 $100,000.00 2.19% Fay. salary and fringe $100,000 due to turnover. Overtime even. 1,754,951.00 1.771.148.71 1,407,348.71 363,800.00 20.54% Fay. court reporters and transcripts, $17,400; witness fees, $8,000; and defense and guardian fees, $261400 reflect the demand. Fay. medical services, $40,900 is historically supported. Fay. guardian reviews, $28,700; and office supplies. $7,000 reflect usage. 799,704.00 871,864.82 932,164.82 (80,300.00) 4.92% Unfav. information tech.-operations ($61,600) will be arnended with this forecast. Unfav. leased vehicles ($4,700) Is historically supported. Fay. stationary stores $6,000 reflects $7,118,563.00 $7,206,921.53 $6,803,421.53 $403,500.00 5.60% reduced demand. Court Servkes Controllable Personnel Controllable Operating Non-Controllable Operating $6,920,642.00 $6,920,642.013 $6,862.442.00 341,819.00 342,182.70 279,182.70 399,791.00 408,070.65 406,070.65 Salary and fringe fav. $52,500 due to turnover. Overtime fay. $5,700. Fey, personal mileage, $13,000 and professional services, $50,000 reflect reduced usage. $7,662,252.00 $7,668,895.35 $7,547,695.35 $121,200.00 1.58% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $13,823,951.00 $13,823,951.00 $13,638,951.00 8,258,861.00 6,277,371.17 5,678,471.17 1,751,859.03 1,869,502.99 2,122,302.99 $185,000.00 598,900.00 (252,800.00) 1.34% 9.54% -13.52% $21,834,671.00 $21,970,825.16 $21,439,725.16 $531,100.00 2.42% flflnflafls OM Mal MMMMMMM COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES PROSECUTING ATTORNEY AMOUNT ADOPTED AMENDED 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating $1,771,646.00 $1,771,646.00 $1,744,146.00 $27,500.00 1.55% Fay. due to underfilled positions and turnover. 1,633,190.00 1,825,001.18 1,710,201.18 114,800.00 6 29% Fay. Wtness Fees, 14,700; Special Prosec. Att'y, 6,800; Filing Fees, 12,000; Court 1,792,416.00 2,088.550.00 2.086,55000 0.00 0.00% Transcripts, 6,800 and various other operating; partially offset by unfav. Travel and Conference,10,000, mainly due to changes in office operations; Prof Svs fay. due „-- to timing of voucher payment and carry-forward, $72,000. $5,197,252.00 $5,683,197.18 $5,540,897.18 $142,300.00 2.50% Litigation Controllable Personnel $5,914,551.00 $5,914,551.00 $5,825,551.00 $89,000.00 1.50% Fay due to underfilled positions and turnover. Controllable Operating 56,492.00 58,492 00 58,492.00 0.00 0 00% Non-Controllable Operating 0.00 0.00 0.00 0.00 000% $5,971,043.00 $5,971,043.00 $5,882,043.00 $89,000.00 1.49% Warrants Controllable Personnel $1,722,901.00 $1,722,901.00 $1,663,901.00 $59,000.00 3.42% Fay. due to underfilled positions and turnover. Controllable Operating 2,758.00 3,124.90 3,124.90 0.00 0.00% Non-Controllable Operating 0.00 0.00 0.00 0.00% $1,725,659.00 $1,726,025.90 $1,667,025.90 $59,000.00 3.42% Appellate Controllable Personnel $1,479,827.00 $1,479,827.00 $1,424,827.00 $55,000.00 3.72% Fay. due to underfilled positions and turnover. Controllable Operating 6,885.00 6,885.00 8,885.00 0.00 0.00% Non-Controllable Operating 0.00 0.00 0.00 0.00 0.00% $1,486,712.00 $1,486,712.00 $1,431,712.00 $55,000.00 3.70% Department Controllable Personnel $10,888,925.00 $10,888,925.00 $10,658,425.00 $230,500.00 2.12% Controllable Operating 1,699,325.00 1,891,503.08 1,776,703.08 114,800.00 6.07% Non-Controllable Operating 1,792,416.00 2,086,550.00 2,086,550.00 0.00 0.00% $14,380,666.00 $14,886,978.08 $14,521,678.08 $345,300.00 2.32% ============== COUNTY OF OAKLAND 1999 SECOND QUARTER FORECAST EXPENDITURES SHERIFF DEPARTMENT AMOUNT ADOPTED AMENDED FY 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Sheriffs Office Controllable Personnel $725,718.00 $725,718.00 $714,718.00 $11,000.00 1.52% -Fay. salaries & fringes $17,000 due to turnover offset by unfav. overtime ($5,000). Controllable Operating 232,586.00 273,217.17 $273,217.17 0.00 0.00% Non-ControHable Operating 1,330,039 00 1,361,313.00 $1,361,313.00 0.00 0.00% $2,288,343,00 $2,360,248.17 $2,349,248.17 $11,000.00 0.47% Administrative Services Controllable Personnel $1,035,021.00 $1,035,021.00 $1,017,021.00 $18,000.00 1.74% -Fay. salaries, fringes and overtime $18,000 due to staffing changes. Controllable Operating 469,730 00 495,116.86 $500,116.86 (5,000.00) -1.01% -Unfav, training exp. ($5,000) due to extra training per deputy contract. Non-Controllable Operating 394,039.00 394,462.00 $394,462.00 0.00% $1,898,790.00 $1,924,599.86 $1,911,599.86 613,000.00 0.68% Corrective Services Controllable Personnel $17,316,574.00 617,553,217.00 $17,860,217.00 ($307,000.00) -1.75% -Fay. salaries $202,800 due to turnover offset by unfav. overtime ($450,000) and fringes ($60,000). Controllable Operating 5,173,189.00 5,726,946.56 $4,426,946.56 1,300,000.00 22.70% -Fay. laundry & cleaning $40,000 due to laundry being done by inmates, fay. Non-Controllable Operating 7,178,631.00 7,266,809.85 $7,266,809.85 0.00 0.00% hosp. of inmates $1,000,000 due to fewer hospitalizations, and fay. out-county prisoner housing $700,000 due to decrease use of other facilities offset by $29,668,394.00 $30,546,973.41 $29,553,973.41 $993,000.00 3.25% unfav. data processing supplies ($5,000) due to new identification system and medical supplies ($400,000) due to Health Dept. invoicing. Protective *Services Controllable Personnel $17,447,570.00 $17,749,479.00 $17,795,479.00 ($46,000.00) -0.26% -Fay. salaries $149,600 and fringes $14,500 due to turnover offset by unfav. overtime $210,000 due to mini-contracts and no-fill postings. Technical Services Controllable Personnel $6,824,764.00 $6,842,058.00 $6,949,058.00 ($107,000.00) -1.56% -Fair. salaries $7,800 offset by unfav. overtime ($95,000) and fringes ($20,000). Controllable Operating 583,647.00 762,172.90 $762,172.90 0.00 0.00% Non-Controllable Operating 975,256.00 975,353.02 $975,353.02 0.00 0.00% $8,383,667.00 $8,579,583.92 $8,886,583.92 ($107,000.00) -1.25% Department Total Controllable Personnel $53,121,763.00 $53,713,563.00 $54,404,563.00 ($691,000.00) -1.29% Controllable Operating 6,769,015.00 7,679,931.61 6,354,931.61 1,325,000.00 17.25% Non-Controllable Operating 12,672,319.00 12,824,394.87 12,824,394.87 0.00 0.00% $72,563,097.00 $74,217,889.48 $73,583,889.48 $634,000.00 0.85% =. Corrective ServIces-Satellites Controllable Personnel $9,772,116.00 $9,808,070.00 $10,068,070.00 ($260,000.00) -2.65% -Fair. salaries $48,800 offset by unfav. overtime ($250,000) and fringes ($50,000) Controllable Operating 157,308.00 181,442.56 $151,442.56 30,000.00 16.53% -Fav. laundry & cleaning $30,000 due to laundry being done by inmates. Non-Controllable Operating 1,018,164.00 1,018,164.00 $1,018,164.00 0.00 0.00% $10,947,588.00 611,007,678.56 $11,237,676.56 ($230,000.00) -2.09% Controllable Operating 152,555.00 241,035.56 $241,035.56 0.00 0.00% Non-Controllable Operating 1,776,190.00 1,808,293.00 $1,808,293.00 0.00 0.00% $19,376,315.00 $19,798,807.56 $19,844,807.56 ($46,000.00) -0.23% 05/18/99 Register of Deeds Controllable Personnel Controllable Operating Non-Controllable Operating COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES CLERK/REGISTER OF DEEDS AMOUNT ADOPTED AMENDED FY 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating County Clerk Controllable Personnel Controllable Operating Non-Controllable Operating Elections Controllable Personnel Controllable Operating Non-Controllable Operating Jury Commission Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $362,252.00 $362,252.00 $362,252.00 $0.00 0.00% 82,655.00 82,777.44 82,777.44 0.00 0.00% 106,950 00 131,218.87 131,218.87 0.00 0.00% $551,857.00 $576,248.31 $576,248.31 $0.00 0.00% $2,997,422.00 $2,997,422.00 $2,997,422.00 $0.00 0.00% 266,477.00 327,881.07 327,881.07 0.00 0.00% 519,248.00 538,897.01 562,897.01 (24,000.00) -4.45% Unfav. IT Operations due to Increased billings. A budget amendment is recommended. $3,783,147.00 $3,864,200.08 $3,888,200.08 ($24,000.00) -0.62% $379,968.00 $379,968.00 $379,968.00 $0.00 0.00% 441,944.00 575,618.08 575,618.08 0.00 0.00% 79,368.00 113,538.00 132,538.00 (19,000.00) -16.73% Unfav. IT Operations due to Inaeased billings. A budget amendment Is recommended. $901,280.00 $1,1369,124.08 $1,088,124.08 ($19,000.00) -1.78% $1,481,233.00 $1,556,233.00 $1,616,233.00 ($60,000.00) -3.86% Unfav. Overlirne due to Increased document recording and mortgage refinancing. Revenues are exceeding budget as a result of this high activity. A budget amendment is recommended 859,119.00 859,119.00 584,119.00 275,000.00 32.01% Fair. Professional Services due to • delay In implementing the imaging program. 851,238.00 852,507.00 992,507.00 (140,000.00) -16.42% Unfav. IT Operations due to Increased billings. A budget amendment Is recommended. $3,191,590.00 $3,267,859.00 $3,192,859.00 $75,000.00 2.30% $14,454.00 $14,454.00 $14,454.00 $0.00 0.00% 52,363.00 52,363.00 47,363.00 5,000.00 9.55% Favorable Postage due to decreased mailing activity. 82,280.00 86,955.96 46,955.96 40,000.00 46.00% Favorable IT Operations due to decreased billings. A budget amendment is recommended. $149,097.00 $153,772.96 $108,772.96 $45,000.00 29.26% $5,235,329.00 $5,310,329.00 $5,370,329.00 ($60,000.00) -1.13% 1,702,558.00 1,897,758.59 1,617,758.59 280,000.00 14.75% 1,639,084.00 1,723,116.84 1,866,116.84 (143,000.00) -8.30% $8,576,971.00 $8,931,204.43 $8,854,204.43 $77,000.00 0.86% 05/06/99 COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES TREASURER ADOPTED BUDGET AMOUNT AMENDED FY 1999 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating Division Total Department Total $2,274,295.00 $2,274,295.00 $2,274,295.00 236573.00 307,007.05 $307,007.05 394,943.00 488,228.27 543,228.27 $2,905,811.00 $3,049,530.32 $3,124,530.32 $0.00 0.00% 0.00 0.00% (75,000.00) -16.02% Unfav. IT Operations due to increased billings. A budget amendment is recommended. ($75,000.00) -2.46% $2,905,811.00 $3,049,530.32 $3,124,530.32 ($75,000.00) -2.46% === ===== ==== ============ flSflSflfl= ======.=========== 9,) 05/06/99 COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES BOARD OF COMMISSIONERS ADOPTED BUDGET AMENDED BUDGET AMOUNT FY 1999 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating $1,510,957.00 $1,510,957.00 $1,510,957.00 415,636.00 416,082.67 416,082.67 9,912,018.00 9,912,981.25 9,932,981.25 $0.00 0.00 (20,000.00) 0.00% 0,00% -0.20% Unfav. IT Operations due to increased billings. A budget amendment is recommended. $11,838,611.00 $11,840,020.92 $11,860,020.92 ($20,000.00) -0.17% Library Board Controllable Personnel Controllable Operating Non-Controllable Operating $780,533.00 802,958.00 857,153.00 $2,440,644.00 $787,765.00 803,053.34 956,477.52 $2,547,295.86 $787,765.00 803,053.34 960,477.52 $2,551,295.86 ($4,000.00) 0.00% 0.00% -0.42% Unfav. IT Operations due to increased billings. A budget amendment is recommended. -0.16% $0.00 0.00 (4,000.00) Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $2,291,490.00 $2,298,722.00 $2,298,722.00 1,218,594.00 1,219,136.01 1,219,136.01 10,769,171.00 10,869,458.77 10,893,458.77 $0.00 0.00 (24,000.00) 0.00% 0.00% -0.22% $14,279,255.00 $14,387,316.78 $14,411,316.78 ($24,000.00) -0.17% Administration Controllable Personnel Controllable Operating Non-Controllable Operating Division Total Department Total COUNTY OF OAKLAND FY 1999 SECOND QUARTER REVIEW REPORT EXPENDITURES DRAIN COMMISSIONER AMOUNT ADOPTED AMENDED 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $5,639,993.00 $1,851,582.00 $1,900,548.00 ($48,988.00) -2.65% Unfav due to E6C new system direct dune time and labor rates need to be adjusted 418,011.00 425,381.94 368,882.00 58,519.94 13.29% Few due to periodicals, books & pubs, not ordered, end misc cap', outlay budget to be transfered to °per. trans!. o 588,120.00 819,425.00 881,123.00 (41,898.00) -8.73% Unfav. due to Infrastructure Malt budgeted In the wrong line item. $6,622,124.00 $2,896,388.94 $2,930,533.00 ($34,184 08) -1.18% $8,822,124.00 $2,898,388.94 $2,930,533.00 ($34,164.06) -1.18% Prepared by: Budget Division 05/18/99 348,691.09 398,691.09 $1,222,549.40 $1,036,042.00 $1,224,548.00 $1,224,548.00 32,940.60 216,796.27 $1,436,424.00 $1,454,284.87 $1,399,284.87 $3,436,164.00 $3,594,248.00 $3,519,248.00 233,458.00 264,332.60 276,332.60 653,012.00 698,167.76 788,167.76 $4,322,634.00 $4,556,748.36 $4,583,748.36 Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating 0.00 0.00% (20,000.00) -10.16% Unfav. IT Operations due to Increased billings. A budget amendment Is recommended. $55,000.00 3.78% $75,000.00 2.09% (12,000.00) -4.54% (90,000.00) 0.00% ($27,000.00) -0.59% 26,741.00 185,135.00 32,940.60 196,796.27 COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES COUNTY EXECUTIVE ADOPTED BUDGET AMENDED BUDGET FY 1999 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating Auditing Controllable Personnel Controllable Operating Non-Controllable Operating Corporation Counsel Controllable Personnel $1,319,702.00 $1,319,702.00 211,521.00 223,521.00 337,245.00 $1,850,168.00 $1,879,914.09 $1,941,914.09 $891,914.00 $1,049,998.00 $1,049,998.00 13,496.00 19,871.00 19,871.00 130,632.00 152,680.40 172,680.40 $1,242,549.40 $1,149,548.00 $0.00 0.00% (12,000.00) -5.67% (50,000.00) -14.34% ($62,000.00) -3.30% $0.00 0.00% 0.00 0.00% (20,000.00) -13.10% ($20,000.00) -1.64% $75,000.00 6.12% Unfav. Printing ($4,000), Data Processing Supplies ($5,000), and Postage ($3,000) due to increased costs. Unfav. IT Operations due to Increased billings. A budget amendment Is recommended. Unfav. IT Operations due to increased billings. A budget amendment is recommended. Fey. Salaries and Fringe Benefits due to underfilling positions and delay In hiring new personnel. $1,319,702.00 193,221.00 Fiscal Services Controllable Personnel Controllable Operating Non-Controllable Operating Reimbursement Controllable Personnel Controllable Operating $8,492,424.00 $7,819,256.96 $7,822,556.96 $3,499,347.00 $3,499,347.00 $3,459,347.00 121,558.00 137,787.05 138,137.05 $196,700.00 2.52% $40,000.00 1,650.00 1.14% 1.20% 845,859.00 796,964.27 792,964.27 4,000.00 0.50% $4,268,782.00 $4,434,098.32 $4,388,448.32 $45,650.00 1.03% $2,731,887.00 $2,731,887.00 $2,731,887.00 $0.00 0.00% 371,813.00 381,191.65 366,191.65 15,000.00 3.94% $228,000.00 $25,150.00 $7,500.00 $260,850.00 1.84% 1.71% 0.22% 1.51% COUNTY OF OAKLAND 1999 SECOND QUARTER FORECAST EXPENDITURES MANAGEMENT AND BUDGET ADOPTED BUDGET AMENDED 1999 BUDGET FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating Purchasing Controllable Personnel Controllable Operating Non-Controllable Operating $244,731.00 $244,731.00 $244,731.00 7,480.00 7,480.00 6,680.00 9,086.00 9,086.00 9,086.00 $261,297.00 $281,297.00 $280,497.00 $641,826.00 $841,626.00 $841,828.00 28,295.00 27,318.20 27,318.20 185,802.00 187,952.82 187,952.82 $0.00 0.00% 800.00 10.70% - Fav. Personal Mileage $100, Travel & Conf. $300 and Data Processing Supplies $750 reflects lower than anticipated usage; partially offset by unfav. Mem. Dues & Pub. ($350) due to greater demands. 0.00 0.00% $800.00 0.31% $0.00 0.00 0.00 0.00% 0.00% 0.00% Equalization Controllable Personnel Controllable Operating Non-Controllable Operating $0.00 $188,000.00 $7,700.00 $1,000.00 $853,723.00 $856,895.02 $858,895.02 $5,244,283.00 $5,288,031.00 $5,078,031.00 220,049.00 $919,651.32 911,951.32 1,028,112.00 $1,633,574.84 1,832,574.64 0.00% 3.57% - Fay. Salary & Fringe $200,000 due to vacancies and underfilled positions; partially offset by unfav. Overtime ($12,000) due to heavy workload. 0.84% - Fav. Personal Mileage $1,000, Printing $6,000, Travel & Con?. $2,000 and Data Processing $700 due to fewer requirements. 0.08% - Fay. Print Shop $1,000 reflects less than anticipated needs. - Fair. due to turnover. - No outside rented equipment reflects Fay. Equip. Rental $600, Equip. Repairs & Maint. $300 do to replacement of aging equipment, No needs for Data Processing Supplies fay. $750. - Decline in usage in Print Shop fay. $3,000 and Convenience Copier fav. $1,000. - Low Advertising fay. $10,000, Fay. Indirect Costs reflects reduced fringe rate. Delay in hiring Court Service Officer reflects favoribility in Professional Services $4,500 and Leased Vehicles $2,500. Fay. Personal Mileage $500, Printing $2,000 and Data Processing Supplies $700 reflects decline in usage. Unfav. Equipment Rental ($1,300) reflects rental of Image Receipting Camera unbudgeted. Unfav. Filing Fees ($1.400) reflects 10,000 more billings offset in revenue. Non-Controllable Operating 726,627.00 748,832.77 744,332.77 2,500.00 0.33% $3,830,327.00 $3,859,911.42 $3,842,411.42 $17,500.00 0.45% Department Total Controllable Personnel $12,381,854.00 $12,383,622.00 $12,155,622.00 Controllable Operating 747,193.00 1,473,428.22 1,448,276.22 Non-Controllable Operating 2,595,488.00 3,374,410.50 3,366,910.50 $15,704,533.00 $17,231,458.72 $16,970,808.72 05/13/99 COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES CENTRAL SERVICES AMOUNT ADOPTED AMENDED 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administrative Controllable Personnel Controllable Operating Non-Controllable Operating Support Services Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $141,834.00 $141,834.00 5141,834.00 $0.00 0.00% 2,522.00 10,522.00 2,522.00 8,000.00 76.03% Fay due to prior year encumbrance not released 10,684.00 10,906.84 10,906.84 0.00% $155,040.00 $163,262.84 $155,262.84 38,000.00 4.90% $880,707.00 $880,707.00 $836,207.00 $44,500.00 5.05% Fay, due to vacant position and underfilled position. 26,683.00 59,563.54 59563.54 0.00 0.00% 592,776.00 594,590.25 594,590.25 0.00 0.00% 31,500,166.00 $1,534,860.79 $1,490,360.79 $44,500.00 2.90% $1,022,541.00 $1,022,541.00 $978,041.00 $44,500.00 4.35% 29,205.00 70,085.54 62,085.54 8,000.00 11.41% 603,460.00 605,497.09 605,497.09 0.00 0.00% $1,655,206.00 $1,698,123.63 $1,645,623.63 $52,500.00 3.09% 05/07199 Administration Controllable Personnel Controllable Operating Non-Controllable Operating Facilities Engineering Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST FACILITIES MANAGEMENT AMOUNT ADOPTED AMENDED FY 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $988,438.00 $834,171.00 $518,308.00 9115,883.00 18.27% Salaries & Fringes are favorable due to vacancies in Tech. Supt. & Admin. staff. 315,902.00 179,248.00 92,809.00 88,439.00 48.22% Overall Cont. Oper. is fav. largely due to Legal Evens* no longer needed. 345,781.00 118,497.00 149,282.00 (32,785.00) -28.13% Non-Control Oper. is untav. largely due to higher computer oper. & Print Shop $1,650,119.00 $929,916.00 $760.379,00 9189,537,00 18,23% $832,555.00 $832,555.00 $758,821.00 $73,934.00 8.88% Salaries & Fringes we favorable due to position turnover, & vacancies. 126,327.00 148,418.35 150,732.00 (4,315.85) -2.95% Unfav due largely to travel & cont office supplies, training & dues. 151,082.00 155,582.00 185,852.00 (10,290.00) -8.81% Non-Control. Oper. is untav largely due to Info-Tech oper., Mail Dept. & Stationery Stock $1,109,984.00 $1,134,533.35 $1,075,205.00 $59,328.35 5.23% $1,820,991.00 $1,488,728.00 $1,278,929.00 $189,797.00 12.94% 442,229.00 325,664.35 243,541.00 82,123.35 25.22% 498,883.00 272,059.00 315,114.00 (43,055.00) -15.83% 92,780,083.00 92,084,449.35 $1,835,584.00 ....... -m- ====. $228,885.35 11.09% • Nine Month Budget 05112199. $252,109.00 $252,109.00 $252,109.00 4,025.00 4,025.00 4,520.00 -5.92% - Unfav. Convenience Copier ($800) reflects higher usage. 6,359.00 13,505.30 14,305.30 $262,493.00 $269,639.30 $270,934.30 (800.00) ($1,295.00) -0.48% $0.00 0.00% 11,000.00 3.11% $1,709,147.00 $1,712,655.00 $1,712,655.00 350,887.00 353,610.25 342,610.25 507,206.00 583,615.38 583,615.38 0.00 0.00% Administration Controllable Personnel Controllable Operating Non-Conrollable Operating Human Resources Controllable Personnel Controllable Operating Non-Controllable 0.00% (495.00) -12.30% - Unfav. Travel & Conference ($645) due to Peoplesoft conferences and Postage ($400) due to unbudgeted line item; partially offset by fav. Data Processing Supplies $250, Personal Mileage $100 and Communications $200 due to lower usage. Fav. Equip. Repair & Maint. $2,000, Exam Material $5,000 Employee Med. Exams. $5,000, Printing $2,000 and Postage $2,000 reflects decrease in demand; partially offset by unfav. Recruitment Expense ($5,000) due to avertising efforts to attract personnel in a low unemployment enviroment. $632,776.00 213,759.10 115,092.00 $916,913.00 $956,627.10 $961,627.10 Employee Relations Controllable Personnel Controllable Operating Non-Controllable Operating ($5,000.00) -0.80% - Overtime unfav. ($5,000) due to heavy workload. 0.00 0.00% 0.00 0.00% ($5,000.00) -0.52% $618,341.00 183,480.00 115,092.00 $627,776.00 213,759.10 115,092.00 COUNTY OF OAKLAND 1999 SECOND QUARTER FORECAST EXPENDITURES PERSONNEL ADOPTED AMENDED BUDGET BUDGET AMOUNT 1999 FAVORABLE FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $2,567,240.00 $2,649,880.63 $2,638,880.63 $11,000.00 0.42% Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $2,579,597.00 $2,592,540.00 $2,597,540.00 ($5,000.00) 538,392.00 571,394.35 560,889.35 10,505.00 628,657.00 712,212.68 713,012.68 (800.00) -0.19% 1.84% -0.11% $3,746,646.00 $3,876,147.03 $3,871,442.03 $4,705.00 0.12% \)4, 04/27/99 COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES HUMAN SERVICES ADOPTED BUDGET AMOUNT AMENDED FY 1999 FAVORABLE BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration Controllable Personnel Controllable Operating Non-Controllable Operating Health Controllable Personnel Controllable Operating Non-Controllable Operating ChlIdren's Village Controllable Personnel Controllable Operating Non-Controllable Operating Medical Examiner Controllable Personnel Controllable Operating Non-Controllable Operating Department Total Controllable Personnel Controllable Operating Non-Controllable Operating • . • Nine Month Budget $148,277.00 $148,277.00 $148,277.00 9,278,945.00 9.304.945.00 9.299,745.03 7,272.00 7,272.00 7,272.00 $9,434,494.00 $9,460,494.00 $9,455,294.00 $20,202,638.00 $20,433,201.00 $20,307,401.00 3,863,067.00 5.197,805.38 5,151,805.38 2,305,342.00 2,840,617.72 2,829,717.72 $28,371,045.00 $28,471,824.10 $28,288,924.10 $8,348,827.00 $8,348,827.00 $8,373,827.00 2,666,847.00 2,672,498.50 2,490,498.50 1,833,248.00 2,079,736.39 2,108.136.39 $12,848,922.00 $13,101,061.89 $12,972,481.89 $1,750,097.00 $1,750,097.00 $1,709,697.00 381,738.00 381,738.00 432,138.00 591,093.00 888,382.12 690,482.12 $2,722,928.00 $2,820,217.12 $2,832,317.12 $30,449,837.00 $30,680,402.00 $30,539,202.00 16,190,597.00 17,558,988.88 17.374,196.88 4,736,955.00 5,616,008.23 5,635,608.23 $51,377,389.00 $53,853,397.11 $53,548,997.11 $0.00 0.00% 5,200.00 0.06% 0.00 0.00% $5,200.00 0.05% $125,800.00 0.82% 46,000.00 0.88% 10,900.00 0.38% $182,700.00 0.64% ($25,000.00) -0.30% 182,000.00 6.81% (28,400.00) -1.35% $128,600.00 0.98% $40,400.00 2.31% (50,400.00) -13.20% (2,100.00) -0.31% ($12,100.00) -0.43% $141,200.00 0.46% 182,800.00 1.04% (19,600.00) -0.35% 5304.400.00 0.57% Primarily due to use of Travel and Conference and Personal Mileage lower than anticipated. Fav. $253,200 due to turnover; Offset by unfav. Overtime $(48,000) due to continued high activity In Jail Health, with greater turnover of staff; Central Support unit reflects high usage of Overtime due to large volume of data entry done for the new well code system Personal Mileage fav. $46,000 due to more scrutinized usage. Commodities primarily reflect reduction in Drugs $11,000 (continued decrease in TB Cases). Medical Supplies $15,000 (* of clients lower than projected), and X-Ray Supplies $15,000 (decrease in 0 of x-rays performed). Equipment Rental charges lower than anticipated. Salaries and Fringe Benefits fav. $70,000. while Overtime unfav ($95,000) due to high turnover of staff, particularly for secured buildings. Fay. $198,000 for Teachers Services & Expense for Children's Village School due to greater efficiencies; offset by unfav. Drugs ($14,000) due to substantial increase in number of juveniles requiring psychiatric care. Radio Communications unfav. ($18,900) as FY 1998 project to purchase and install security cameras in the Children's Village buildings was not implemented until the beginning of FY 1999. No funds were carried forward to cover project. Due to delay In hire of Forensic Pathologist and Typist I position approved in FY 1999 Budget, Salaries and Fringe Benefits fair. $55,500, while Overtime unfav. ($15,100). Contracted assistance for Medical Services - Autopsies continued to be high during the first four (4) months of FY 1999. This has since then tapered off and is anticipated to remain lower with hiring the additional Forensic Pathologist. A budget amendment is recommended. Materials Management - Misc. unfav. ($1,000) and Radio Communications ($1,000) as actual usage is higher than anticpated. MSU Ext. - Oakland County Controllable Personnel Controllable Operating Non-Controllable Operating Public Services - Admin. Controllable Personnel Controllable Operating Non-Controllable Operating COUNTY OF OAKLAND 1999 SECOND QUARTER FORECAST EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $12965300 $129,653.00 $129,653.00 0.00% 1,743 00 63,543.00 2,993.00 60,550.00 95.29% - Unfav. Communications ($150) due to charges higher than anticipated. Unfav. Membership, Dues and Pub. ($200) and Service Mornentos ($700) due to unbudgeted line item and items purchased to enhance new Troy office. $61,800 appears in appropriations for Tmg. & Psych. & Med. Exam. Inappropriately. This amendment should have materialized in Ck. CI. Probation to cover expenses. Unfav. Office Supplies ($200) reflects higher usage. 11,117.00 11,117 00 10,917.00 200.00 1.80% - Fay. Leased Vehides $200 and Print Shop $200 due to reduced need; partially offset by Stationary Stock unfav. ($200) due to greater demand. $142,513.00 $204.313.00 $143,563.00 $60,750.00 29.73% Veteran's Services Controllable Personnel $1,184,911.00 $1,164,911.00 $1,134,911.00 $30,000.00 2.58% - Turnover Controllable Operating 303,442.00 308,134.51 252,634.51 55,500.00 18.01% - Fay. Equip. Repair & Maint. $300, Fees & Mileage $200, Mem. Dues & Pub. $400 and Misc. $400 due to decreased need. Soldier Burial fay. $50,000 partially due to eligibility requirements. Transport Service fay. $200. Travel & Conference $1,300, Data Proc. Sup. $700 and Postage $2,000 reflect fewer demands on resourses. Expendable Equip. Exp. $3,995 fay, due to delay in opening of Troy office and $10,000 in Rent due to delayed billing from State not in calculation. Non-Controllable Operating 221,819.00 222,487.02 219,787.62 2,700.00 1.21% - Fair. Leased Vehides $2,000 and Print Shop $700 due to reduced need. $1,690,172.00 $1,695,533.13 $1,607,333.13 $88,200.00 5.20% Community Corrections Controllable Personnel $1,152,153.00 $1,273,858.00 $1.186,258.00 $87,400.00 6.86% - Salary & Fringe fay. $100,000 due to delay in filling new positions, partially offset by unfav. Overtime ($12,600) due to rapid expansion of alternative programs. Controllable Operating 74,833.00 116,515.57 90,215.57 26,300.00 22.57% - Grant Match fay. $30,000; partially offset by unfav. Mem. Dues & Pub. ($500), Travel & Conference ($1,500). Material & Supply ($1,300), Office Supplies ($200) and Postage ($200) due to additional program demands. Non-Controllable Operating 75,484.00 86,200.00 86,200.00 0.00% $1,302,470.00 $1,476,373.57 $1.382,873.57 $113,700.00 7.70% Animal Control Controllable Personnel Controllable Operating Non-Controllable Operating 651,604.00 653,489.00 638,489.00 15,000.00 2.30% - Turnover 338,638.00 348,906.85 323,906.85 25,000.00 7.17% - Fay. Personal Mileage $10,000 and Professional Services $25,000 partially due to charges made In unbudgeted line items to reflect spending pattern: Unfav. Car Allowance ($4,500), Field Trips ($500). Workshops & Meetings ($4,900) and Groceries ($100). 208,435.00 214,345.65 214,345.65 0.00% $1,198,677.00 $1,216,741.50 $1,178,741.50 $40,000.00 3.29% $1,227,214.00 $1,227,214 00 $1,242,214.00 ($15.000.00) -1.22% - Reflects heavier workload in Overtime ($10,000) and On-Cal ($5,000). 107,089.00 107,490.00 105,490.00 2,000.00 1.86% - Fay. Damage by Dogs $500, Mem. Dues & Pub. $200 Personal Waage $300, Travel & Conference $500, Uniform Replacement $1,000, Data Proc. Supplies $500 and Housekeeping Expense & Janitor $1,000 reflects less use in these areas; partially offset by unfav. Equip. Repairs & Maint. ($2,000) due to cash register being re-programed to accept HRFIS accounts. 480,897.00 483,012.31 482,012.31 1,000.00 0.21% $1,815,200.00 $1,817,718.90 $1,829,716.31 ($12,000.00) -0.66% 05/08/99 Circuit Court Probation Controllable Personnel Controllable Operating Non-Controllable Operating COUNTY OF OAKLAND 1999 SECOND QUARTER FORECAST EXPENDITURES PUBLIC SERVICES AMOUNT ADOPTED AMENDED 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES $0.00 $0.00 $0.00 0.00% 31,055.00 31,055.00 92,855.00 (61,800.00) 0.00% - Reflects late billings from FY 1998 in Tmg. 8, Psych. IL Med. Exams. A Budget amendment was made in 1st Quarter but incorrectly credited to Public Services Admin. Adjustment being made. 839.085.00 842,615.48 842,615.46 0.00% $870,140.00 8873,670.48 8935,470.46 ($61,800.00) -7.07% Department Total Controllable Personnel $4.325,535.00 $4,448,925.00 $4,331,525.00 8117,400.00 2.64% Controllable Operating 856,800.00 975,644.93 868,094.93 107,550.00 11.02% Non-Controllable Operating 1,836.837.00 1,859,778.04 1,855,878.04 3,900.00 0.21% $7,019,172.00 87,284,347.97 $7,055,497.97 8228,850.00 3.14% 70,978.04 141,201.50 105,581.02 73.55% - Unused Professional Services DISC Res. 98041 1.34% Division Total Department Total COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES INFORMATION TECHNOLOGY AMOUNT ADOPTED AMENDED 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES Administration (101 & 221) Controllable Personnel $0 $354,265.00 $283,286.96 Controllable Operating Expenses 155,808.00 191,989.42 50,787.92 Non-Controllable Operating Expenses 4,851,000.00 7,858,211.82 7,750,650.80 $5,006,808.00 $4,402.466.24 $8,084,725.88 $317,740 58 3.78% $5,008,808.00 $8,402,488.24 $8,084,725.68 $317,740.58 3.78% 05/13/99 COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST EXPENDITURES PLANNING AND ECONOMIC DEVELOPMENT AMOUNT ADOPTED AMENDED 1999 FAVORABLE BUDGET BUDGET FORECAST (UNFAVORABLE) PERCENT Administration Controllable Personnel $142,402.00 $142,402.00 $142,402.00 0.00% Controllable Operating 88,779.00 89,751.00 89,751.00 0.00% Non-Controllable Operating 43,521.00 43,818.36 43,618.36 0.00% $274,702.00 $275,771.36 $275,771.36 $0.00 0.00% Planning and Economic Development Controllable Personnel $2,283,494.00 $2,283,494.00 $2,263,494.00 $20,000.00 0.88% Fav due to turnover. Controllable Operating 647,752.00 655,822.71 655,622.71 0.00% Non-Controllable Operating 545,412.00 578,281.36 578,281.38 0.00% $3,476,658.00 $3,515,398.07 $3,495,398.07 $20,000.00 0.57% Community Development Controllable Personnel Controllable Operating 270,928.00 270,928.00 270,928.00 0.00 0.00% Non-Controllable Operating $270,928.00 $270,928.00 $270,928.00 $0.00 0.00% EXPLANATION OF SIGNIFICANT VARIANCES Department Total Controllable Personnel Controllable Operating Non-Controllable Operating $2,425,896.00 $2,425,896.00 $2,405,896.00 1,007,459.00 1,018,301.71 1,016,301.71 588,933.00 619,899.72 819.899.72 $20,000.00 0.82% 0.00 0.00% 0.00 0.00% $4,022,288.00 $4,062,097.43 $4,042,097.43 $20,000.00 0.49% .32i Zt==3L $622,767.00 4.58% $0.00 0.00% 0.00 0.00 (22,500.00) 0.00 0.00 (153,700.00) 0.00 0.00 0.00 0.00 0.00 0.00 (300,000.00) ($476,200.00) $0.00 0.00 0.00 79,700.00 0.00% 0.00% -44.56% Increased number of sucessful dassification reviews. 0.00% 0.00% -24.16% Increased demand due to tight labor market for full time staff. 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 114.34% Demand higher than anticipated in budget. -42.58% 0.00% 0.00% 0.00% 4.10% COUNTY OF OAKLAND EXPENDITURES /.^ FY 1999 FIRST QUARTER REPORT;-, BUDGET AS ADOPTED BUDGET AS ADJUSTED FY 1999 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION $0.00 100,000.00 0.00 0.00 /02,900.00 (100,000.00) (80,133.00) 0.00 0.00 0.00 [NON-DEPART. APPROPRIATIONS COUNTY OPERATIONS Financial System State Institutions Ambulance Insurance and Surety Bonds Tax Tribunal Appeals Road Commission - Drain Assessment Road Commission - Tri-Party Agreement Remonumentation Man/Nam Grant Match COUNTY BUILDINGS $498,860.00 $498,860.00 635,300.00 535,300.00 19,800.00 19,600.00 85,100.00 85,100.00 702.900.00 0.00 1,118,300.00 1,216,300.00 1,250,000.00 1,330,133.00 1,129,755.55 1,129,755.55 0.00 1,301,721.00 1,301,721.00 0.00 6,844,384.00 6,844,384.00 $3,809,400.00 $13,584,120.55 $12,961,353.55 $3,115,567.00 $2,887,307.21 $2,867,307.21 0.00% 15.74% Reduced use of state facilities for County wards, ordered Into custody by the Circuit Court. 0.00% 0.00% 100.00% Line item no longer used. -8.96% Increased road work requiring additional work on easements. -6.41% Final payment for FY 1998 charged to FY 1999 due to timing difficulty. 0.00% 0.00% 0.00% $000 635,300 00 19,800.00 85,100.00 702,900.00 1,116,300.00 1,250,000.00 0.00 COUNTY ASSOCIATIONS S.E.M.C.O.G. Association of Metro Sewage Groups Area Wide Water Quality National Assoc. of Counties Michigan Assoc. of Counties Traffic Improvement Association $415,000.00 0.00 57,200.00 19,000.00 50,000.00 22,300.00 $583,500.00 $415,000.00 $420,300.00 ($5,300.00) -1.28% Actual dues. 0.00 1,500.00 (1,500.00) -100.00% Actual dues. 57,200.00 52,200.00 5,000.00 8.74% Actual dues. 19,000.00 19,100.00 (100.00) -0.53% Actual dues. 50,000.00 50,000.00 0.00 0.00% 22,300.00 22,300.00 0.00 0.00% $563,500.00 $565,400.00 ($1,900.00) -0.34% $0.00 0.00% SUNDRY RESERVED FOR TRANSFERS Expenditures Contingency Salary Adjustment Classification & Rate Change Overtime Summer Employment Emergency Salaries Fringe Benefit Adjustments Capital Outlay Clinton River Watershed Council Huron River Watershed Council Partnership for Saginaw River Watershed Rouge River Watershed Council Office Automation Transfers to Other Funds ". General Activities Environmental Infrastructure Building Fund Building Authority 4mi= $674,300.00 $874,300.00 9674,300.00 9234,983.00 $187,653.00 $187,653.00 0.00 0.00 0.00 84,627.00 50,494.00 72,994.00 53,000.00 20,780.00 20,780.00 424,200.00 424,200.00 424,200.00 638,300.00 636,300.00 790,000.00 0.00 0.00 0.00 75,000.00 49,546.75 49,546.75 5,141.00 5,141.00 5,141.00 2,706.00 2,708.00 2,706.00 2,276.00 2,276.00 2,276.00 2,177.00 2,177.00 2,177.00 1,200,000.00 (262,371.00) (562,371.00) $2,720,410.00 $1,118,902.75 $995,102.75 $0.00 $0.00 $0.00 5,000,000.00 5,000,000.00 5,000,000.00 3,242,911.00 4,789,272.00 4,789,272.00 3,490,661.00 1,944,300.00 1,864,600.00 1 04/29/99 Prepared by: Budget Division COUNTY OF OAKLAND FY 1999 FIRST QUARTER REPORT EXPENDITURES:, BUDGET AS ADOPTED BUDGET AS ADJUSTED FY 1999 FORECAST AMOUNT FAVORABLE (UNFAVORABLE) PERCENT EXPLANATION TOTAL NON-DEPT. APPROPRIATIONS $1173357200 $11,733,572.00 $11,653,872.00 579,700.00 0.68% S22,616,749.00 $30,541,702.51 $29,717,335.51 $224,367.00 0.73% TRANSFER TO GENERAL PURPOSE FUNDS Friend of the Court Fund Health Fund Juvenile Maintenance Fund Social Welfare Fund CRIMP Fund 59,852,993 00 $10,129,886.53 23,364,748.00 22,352,535.65 14,036,647.00 14,209,415.01 67,378.00 67,378.00 000 0.00 $10,129,886.53 22,352,535.65 14,289,415.01 67,378.00 000 $0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% $0.00 0.00% $47,321,766.00 $46,839,215.19 $46,839,215.19 Prepared by: Budget Division lIA/10/00 2 FY 1999 BUDGET AMENDMENTS General Fund General Purpose FY 1999 BUDGET AS ADOPTED $293,711,502.00 BUDGET AMENDMENTS M.R. #98233 - 10/15/98 $77,477.00 Sheriff Department - Law Enforcement Contract Amendment for Highland Township M.R. #98242 - 10/15/98 552,500.00 Information Technology - Enhancement of County's Assessing, Equalization and Tax Billing and Collection System M.R. #98258 - 10/29198 Sheriff Department - Law Enforcement Contract Amendment for Addison Township M.R. #98258 - 10/29/98 Central Services - Temporary Fleet Expansion for Community Corrections M.R. #98271 - 11/19/98 Health Division - Partnership Agreement with the City of Southfield M.R. #98281 - 11/19/98 Circuit Court - Local Law Enforcement Block Grant Match 83,526.00 9,000.00 73,843.00 17,674.00 M.R. #98282 - 12/10/98 114,179.00 Circuit Court - Use of Mediation Funds M.R. #98295 - 12/10/98 Sheriff Department - Law Enforcement Contract Amendment for Oakland Township M.R. #98296 - 12/10/98 Sheriff Department - Law Enforcement Contract Amendment for Springfield Township M.R. #98325 - 12/10/98 Sheriff Department - Law Enforcement Contract Amendment for Commerce Township M.R. #98294 -12/10/98 Sheriff Department - Contract for Court Security at the 48 th District Court - Bloomfield Township M.R. #98289 - 12/10/98 Drain Commissioner - Implementation of Labor Distribution System, Miscellaneous Accounting Policy Changes and Organizational Changes 60,214.00 68,110.00 48,611.00 13,923.00 ($3,788,431.00) ql M.R. #99056 - 3/18/99 Equalization Division - Digital Photography Project Total Amendments Amended Budget 3/31/99 $97,794.00 $3,826,200.00 $15,393,082.05 $302.104.184.05 04/28/99 M.R. #99060 - 3/18/99 Management and Budget - FY 1999 First Quarter Financial Forecast and Budget Amendments Prepared by: Fiscal Services Division M.R. #98313 - 12/10/98 $100,000.00 Clerk/Register of Deeds - Remonumentation Grant M.R. #98315 - 12/10/98 $7,232.00 Library Board - LBPH - Creation of One GF/GP Clerk I Position and the Deletion of Two PTNE General Clerical Positions M.R. #98328 - 12110/98 $11,706,764.05 Management and Budget - FY 1998 Year End Report and Budget Amendments M.R. #98339 - 12/10/98 $233,807.00 Personnel Actions Related to the Transition of Community Mental Health to an Authority M.R. #99005 - 1/25/99 $350,000.00 Medical Examiner - Case Management System M.R. #99043 -2/25/99 $89,195.00 Sheriff - FY 1998 State Criminal Alien Assistance Grant Acceptance M.R. #99031 - 2/25/99 $126,505.00 Community Corrections - Program Expansion M.R. #99042 - 3/18/99 $2,700.00 Sheriff Department - Processing Fee Increase M.R. #99049 - 3/18/99 $28,000.00 Prosecutor's Office - Fleet Expansion M.R. #99050 - 3/18/99 $1,494,259.00 Health Division - Acceptance of FY 1998/1999 CPBC Contract COUNTY OF OAKLAND FY 1999 SECOND QUARTER FORECAST INTERNAL SERVICE FUNDS DEPARTMENT OF CLERK/REGISTER OF DEEDS ADOPTED AMENDED FY 1999 VARIANCE BUDGET BUDGET FORECAST FAVALINFAV) 11.0,00ed.n•n•n•••••••*.n•••• [MICROGRAPHICS FUND (#654) EXPLANATION OF SIGNIFICANT VARIANCES 0.011001.11140.04.~0,116~••n••n••110.001.14.1••nn•nn•••.~011.0,101.1•001n0110 REVENUES Outside Inside Total Revenues OPERATING EXPENSES REVENUE OVER (UNDER) EXPENDITURES $125,100.00 40%986.00 $526,086.00 $526,086.00 $0.00 $125,100.00 400,986.00 $526,086.00 $526,086.00 $0.00 $225,100.00 450,986.00 $676,086.00 $526,086.00 $150,000.00 $100,000.00 50,000.00 $150,000.00 $0.00 $150,000.00 Title company orders reflect the high real estate activity. Fay. due to increase in internal department demand. 05/06/99 RISK MANAGEMENT INTERNAL SERVICE FUND FY 1999 SECOND QUARTER REPORT ADOPTED AMENDED FY 1999 VARIANCE BUDGET BUDGET FORECAST FAV4UNFAV) COMMENTS [LIABIUTY INSURANCE FUND (#677) REVENUE OPERATING EXPENSE CLAIMS PAID TOTAL EXPENSES $3,596,728 $3,596,728 $3,709,428 $112,700 - Fay. Investment Income 225,000 due to higher than expected interest rates and investment base, partially offset by reduced Liability Insurance revenue due to Community Mental Health's transfer to authority status (87,300) and Rebilled Charges (25,000). $807,561 $807,561 $797,461 $10,100 -Fay. Insurance premium costs 30,000 and turnover 37,900 partially offset by unfav. Legal Services charges (22,800) for preparation for potential legal suit and Information Technology Operations costs (35,000). 2,789,167 2,789,167 2,789,167 0 -Liability Insurance claims costs will be determined by fiscal year-end analysis of claims costs, claims estimates and reserve requirements. $3,596,728 $3,596,728 $3,586,628 $10,100 NET REVENUES OVER/(UNDER) EXPENSES $0 $0 $122,800 $122,800 BUDGET BUDGET FORECAST FAW(UNFAV) COMMENTS $1,534,100 $1,534,100 $1.447.000 (587.100)-Approximately 94.5% of Retirement revenue allocations are anticipated to be recovered in 12,681,100 12.681,100 11.971.200 (709,900) FY 1999. based on recovery through March 1999. The deletion of Community Mental 2,988,100 2,986.100 2,819,400 (166,700) Health positions, effective 1-1-99. reduced both revenue and expenditure to the Fringe 750,000 750,000 708,600 (41,400) Benefit Fund beginning in January 1999. 300,000 300,000 283.400 (16,600) 39,800 39,800 68,600 26,800 -Indudes transfer of interest earned In Deferred Compensation Fund (now dosed). 845,100 845,100 795,600 (49.500) 6,744,400 6,744,400 6,367,200 (377,200) 458,400 458,400 432,600 (25,800) 794,400 794,400 768,800 (25,600) 18,207,700 18,207,700 17,650.100 (548.600)-CMH separation reduces revenue. 13,538,400 13,538,400 12,506,700 (1,031,700)-Social Security (FICA) revenue follows FICA expenditure; CMH separation reduces revenue 2,310,000 2.310.000 2,310,900 900 315,600 315,600 309,900 (5,700) 615,000 615,000 591,400 (23.600) 1,262,300 1,262,300 1,275,800 13,500 -Departments are charged for actual short-term disability costs. 206,500 206,500 0 (206.500)-Payment from employees for enhanced coverages In Flex Benefit Program are now netted against payments paid to employees for enhanced coverages, eliminating this revenue 185,000 185,000 252,500 67,500 -Return of DC Plan contributions from ICMA for employees who separated from County service 3,210,500 3,210,500 3,308,200 97,700 prior to vesting and health & dependent care forfeiture of unused deposits. 225,000 225,000 212,700 (12,300) 750,000 750,000 1,725,000 975.000 -Interest rates and investment base higher than expected. $67,959,400 $67,959,400 $65,812,600 ($2,146,800) $1,534,100 $1,534,100 $0 $1,534,100 -Budget established prior to receipt of latest actuarial calculation. Contribution to Retirement Fund not required for General County employees as per actuarial report. 12,681,100 12.681,100 12,345,000 336,100 -Budget established prior to receipt of latest actuarial calculation. 2,986,100 2,988,100 2,986,100 0 750,000 750,000 750,000 0 300,000 300,000 250,000 50,000 -Cost reflects level of participation in the Tuition Reimbursement Program. 39,800 39,800 39,800 0 485.100 485,100 568,500 (83,400)-PeopleSoft training costs. 360,000 360,000 450,000 (90,000)-Estimate reflects current level of IT training. 6,744,400 6,744,400 5,947,800 796.600 -Est. based on current level of County contributions to ICMA for the Defined Contribution Ran; 458,400 458,400 458,400 0 CMH separation reduces cost. 794.400 794,400 753,100 41,300 -Variance reflects the separation of CMH employees 1/1/99. 18.207,700 18,207,700 18,207,700 0 -Estimated cost based on projection of current usage. -Costs indude actual claims costs, administration and stop/loss charges from BC./BS and HMO premiums. Costs via be credited 835,000 for adjustment of Health IBNR reserve. 13,627,000 13,627,000 12,601,200 1.025,800 -RCA rote applied against actual salaries cost; CMH separation reduces cost. 2,310,000 2,310,000 2,260,000 50,000 -Cost based on actual daims and administration fee paid to Delta Dental beg. January 1999. 315,600 315,600 294,400 21,200 CMH separation reduces cost 1,877,300 1,877.300 1,877,300 0 -Short-term disability claims (recovered by charges to departments). 364,500 364,500 36,700 327,800 -Payments to employees for reduced coverages (including hospitalization opt-outs) in Flexible Benefits Program are now netted against payments received from employees for enhanced 132,300 132,300 132,300 0 coverages, reducing both Program expense and revenue. 3.210.500 3,210,500 2.460,500 750,000 -Adjustment of Workers' Compensation dalm-year reserves wit be determined by fiscal 225,000 225,000 200,000 25,000 year-end analysis of claims. Forecast is based on claims costs through March 1999. 67,800 (67,800)-Charge for accounting services to Fringe Benefit Fund implemented subsequent to budget 1,600,000 (1.1300,000)-Transfer to Capital Improvement Fund for capital costs of on-site chid care facility - MRS98329. $67,403,300 $67,403,300 $64,286,600 $3,116,700 $558,100 $556,100 $1,526,000 $969.900 FRINGE BENEFIT FUND INTERNAL SERVICE FUNDS FY 1999 SECOND QUARTER REPORT ADOPTED AMENDED FY 1999 VARIANCE IMINGE BENEFIT FUND (118711) 1 REVENUE DEFINED BENEFIT CONTRIBUTION RETIREES HOSPITALIZATION RETIREMENT ADMINISTRATION COMPENSATED ABSENCES TUITION REIMBURSEMENT EMPL. DEFERRED COMP. ADMIN. EMPLOYEE IN-SERVICE TRAINING DEFINED CONTRIBUTION PLAN DEFINED CONTRIBUTION ADMIN. GROUP LIFE HOSPITALIZATION SOCIAL SECURITY DENTAL INSURANCE OPTICAL INSURANCE DISABILITY INSURANCE SHORT-TERM DISABILITY FLEXIBLE BENEFITS DEDUCTIONS FORFEITURES WORKERS' COMPENSATION UNEMPLOYMENT COMPENSATION INVESTMENT INCOME TOTAL REVENUE I EXPENSE DEFINED BENEFIT CONTRIBUTION RETIREES' HOSPITALIZATION RETIREMENT ADMINISTRATION COMPENSATED ABSENCES TUITION REIMBURSEMENT EMPL. DEFERRED COMP. ADMIN. EMPLOYEE IN-SERVICE TRAINING IN-SERVICE TRAINING- INFO TECH DEFINED CONTRIBUTION PLAN DEFINED CONTRIBUTION ADMIN. GROUP UFE HOSPITALIZATION SOCIAL SECURITY DENTAL INSURANCE OPTICAL INSURANCE DISABILITY INSURANCE FLEXIBLE BENEFIT PAYMENTS PROFESSIONAL SERVICES WORKERS' COMPENSATION UNEMPLOYMENT COMPENSATION ACCOUNTING SERVICES OPERATING TRANSFER OUT TOTAL EXPENDITURES • REVENUE OVER/(UNDER) EXPENSE DEPARTMENT OF MANAGEMENT AND BUDGET INTERNAL SERVICE FUNDS FY 1999 SECOND QUARTER FORECAST ADOPTED AMENDED FY 1999 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) OFFICE EQUIPMENT FUND (66400) OPERATING REVENUE-Inside 374,067 374,067 338,860 (35,207) - Reduced revenue reflects equipment written off year-end 1998. OPERATING EXPENSE 624,364 624,364 573,608 50,756 - Favoribility in Equipment Repairs & Maint. $15,000, Equipment Replacement $19,900 and Maint. Cont. $26,100 reflect reduced inventory. Unfav. OPERATING INCOME ($250,297) ($250,297) ($234,748) $15,549 Depreciation ($15,000) from equip. write off. NET NON-OPERATING REV (EXP) 250,297 250,297 288,612 (38,315) - Revenue projection low in Income from Investment fay. $26,600 and Gain/Loss on sale of Equipment - fay. $2,100, offset by ($67,000) in Prior Year Rev. INCOME (LOSS) BEFORE OPERATING TRANSFERS $0 ($22,767) $0 ($22,767) OPERATING TRANSFERS IN OPERATING TRANSFERS OUT 0 (215,000) 0 (215,000) NET REVENUES OVER/(UNDER) $0 ($237,767) $0 ($237,767) EXPENSES 05/06/99 $0.00 $2,694,821.00 $2,694,821.00 $2,694,821.00 OPERATING REVENUE $0.00 0.00 $0.00 0.00 0.00 0.00 0.00 0,00 0.00 $0.00 0.00 $0.00 0.00 0.00 TiitOR POOL 661— — OPERATING REVENUE $3,958,476.00 $4,121,940.00 84,056,895.00 (965,045.00) Use of fund balance for compliance with A-87. f$185462.0O1_ 91 3J,L0,00 ___191_29,045.90) KI,145i $0.00 $437,704.00 $477,038.00 $477,038.00 REVENUES - OUTSIDE DEPARTMENT OF CENTRAL SERVICES FY 1999 SECOND QUARTER REPORT ADOPTED BUDGET 'OAKLAND COUNTY INTERNAtIOWAL AIRPORT 681 AMENDED FY 1999 VARIANCE BUDGET FORECAST FAVI(UNFAV) COMMENTS OPERATING EXPENSE OPERATING INCOME (LOSS) NON-OPERATING INCOME INCOME (LOSS) BEFORE OPERATING TRANSFERS OPERATING TRANSFERS IN OPERATING TRANSFERS OUT ADD BACK DEPRECIATION CLOSED TO CONTRIBUTED CAPITAL NET INCOME (LOSS) 3,094.821.00 _ 3,094,821.00 . 3,094.821.00 0400,000.00) ($400,000.00) ($400,000.00) 400,000.00 ..,400,000,00 400,000.00 $0.00 0.00 0.00 0.00 $0.00 _ A0.00 0.00 0.00 OPERATING EXPENSES 4 504,852.00 4.498,166.00 4,396,866.00 (99,300.001 Unfav depredation expense ($200.000) due to vehicles being purchased Instead of leased which is partially offset by leased fay $66,000. OPERATING INCOME (LOSS) NET NON-OPERATING REV (EXP) NET INCOME(LOSS) BEFORE OPERATING TRANSFERS OPERATING TRANSFERS IN ' NET INCOME (LOSS) RADIO COMMUNICATIONS 660 ($546,376.00) ($374,226.00) 355,000.00 279,293.00 ($191,376.00) ($94,933.00) ($538,571.00) ($164,345.00) 313,293.00 34,000.00 Lease contract terminated. Interest expense no longer Incurred. ($225,278.00) ($130,345.00) 5,914.00 98,233.00 96,233.00 0.00 REVENUES - INSIDE TOTAL OPERATING EXPENSES OPERATING INCOME (LOSS) NET NON-OPERATING REV (EXP) INCOME(LOSS) BEFORE OPERATING TRANSFERS • NET OPERATING TRANSFER IN/(OUT) NET INCOME (LOSS) 985,659.00 _1 245,043.00 1,345,043.00 100,000.00 Fay Increased repair charges offset by unfav budgeted use of fund balance 11,413,-36-3.00 $1,722,081.00 $1,822,081.00 $100,000.00 for A-87 compliance. 1,701,916.00 1,762,488.00 1,462,488.00 _ .000,000.00) Unfav depredation due to one time wdle-off of assets under $1,000; unfav equipment repairs, maintenance, parts and accessories due to Increase In ($278,553.00) ($40,407.00) $359,593.00 ($200,000.00) repair requests 0.00_ _ 7,500.00.. 21,484.00 _._ 13,98400 Fay Investment Income due to larger lhan anUdpated fund balance. (9276,553.00) ($32,907.00) $381,077.00 ($188,016.00) 1,157.00 1,157.00 1,157.00 0.00 J$277,398.00) (911.750.00)= $382,04.00 __,(.$1813,018.00)_ DEPARTMENT OF CENTRAL SERVICES INTERNAL SERVICE FUNDS FY 1999 SECOND QUARTER REPORT 'MATERIALS MANAGEMENT FUND 633 OPERATING REVENUE OPERATING EXPENSE OPERATING INCOME(LOSS) NON-OPERATING REVENUE(EXPENSE) NET INCOME (LOSS) ADOPTED BUDGET $3,371,638.00 3,378,138.00 (6,500.00) 6,500.00 $0.00 AMENDED BUDGET $3,371,638.00 3,378,138.00 (6,500.00) 6,500.00 $0.00 FY 1999 FORECAST $3,371,638.00 3,378,136.00 (6,500.00) 6,500.00 $0.00 VARIANCE FAV/IUNFAV $0.00 0.00 0.00 0.00 COMMENTS 'MAILING, eiNVENIENCE -651)1MAND PRINTING FUND 667 OPERATING REVENUE OPERATING EXPENSE OPERATING INCOME(LOSS) NON-OPERATING REVENUE(EXPENSE) NET INCOME (LOSS) $2,698,652.00 $2,647,577.00 2,698,652.00 2,729,774.00 0.00 (82,197.00) 0.00 47,210.00 _ ($34,987:00) $2,447,577.00 ($200,000.00) Unfav revenue from copier machines due to less than anticipated usage offset by fay copier machine rental expenditures 2,929,774.00 200,000.00 (82,197.00) 0.00 47,210.00 0.00 ($3.4,987.00) .10.00 $1,106,122.00 21,226,779.00 $22,332,901.00 $21,470,885.00 $1,106,122.00 21,226,779.00 $22,332,901.00 $21,470,885,00 $862,016.00 $200,000.00 $54,000.00 ($2,350,000.00) ($1,233,984.00) $862,016.00 $200,000.00 $54,000.00 ($2,350,000.00) ($1,233,984.00) $107,562.00 $107,562.00 $0.00 $107,562.00 $107,562.00 $0.00 $0.00 $1.00 $107,562.00 $107,562.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 DEPARTMENT OF FACILITIES MANAGEMENT INTERNAL SERVICE FUNDS 1999 SECOND QUARTER REVIEW REPORT ADOPTED BUDGET IFACILMES MAINTENANCE & OPERATIONS AMENDED BUDGET 1999 VARIANCE SECONDS:II& REV. PAW( UNFAV) (631) COMMENTS OPERATING REVENUES: Outside Revenue Inside Revenue Total Revenue OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS NON-OPERATING REVENUE/(EXPENSE) OPERATING TRANSFERS IN OPERATING TRANSFERS (OUT) NET REVENUES OVER(UNDER) EXPENSES $1,106,122.00 $0.00 21,226,779.00 0.00 $22,332,901.00 $0.00 $20,385,738.00 $1,085,147.00 Fey. due to position vacancies and turnover, lower overtkno, lower Sublet Repairs, & elect. WS. Partially offset by higher Internal Svcs: computer oper. and leased veh. $1,947,163.00 $1,085,147.00 $175,883.00 ($24,117.00) Due to lower Income from investments liquidated to purchase PBX system. $54,000.00 $0.00 ($2,350,000.00) $IG() ($172,954.00) $1,061,030.00 'PONTIAC MARKET (65100)(261) I OPERATING REVENUES - OUTSIDE OPERATING EXPENSES NET INCOME (LOSS) BEFORE OPERATING TRANSFERS OPERATING TRANSFERS IN OPERATING TRANSFERS (OUT) NET REVENUES OVER(UNDER) EXPENSES (PRINT "SELECTION";1;9999;1;1) 211,652.00 60,686.00 272,338.00 157,333.00 0.00 $19,452,380.00 $22,168,213.00 23,009,503.82 19,452,380.00 20,744,204.00 23,009,503.82 0.00 0.00 22,753,787.82 1.424,009.00 (255,736.00) 115,005.00 51,499.43 122,355 00 173,854 43 OPERATING INCOME (LOSS) OAKLAND COUNTY INTERNAL SERVICES INFORMATION TECHNOLOGY FY99 SECOND QUARTER FORECAST Information Technology - Operations (636) ADOPTED BUDGET AMENDED BUDGET FY 1999 FORECAST VARIANCE FAV/(UNFAV) Total Fund: COMMENTS 62,173,161.00 15,581,104.00 1,542,307.00 155,808.00 OPERATING REVENUES: Outside Inside Prior Years Balance OPERATING TRANSFERS IN Total OPERATING EXPENSES OPERATING TRANSFERS (OUT) OPERATING INCOME (LOSS) Information Technology - In-Car Terminals (637) OPERATING REVENUES: Outside Inside OPERATING TRANSFERS IN Total OPERATING EXPENSES OPERATING TRANSFERS (OUT) $2,173,161.00 1,996,326.32 17,383,632.00 18,146,021.50 1,542,307.00 1,542,307 1,069,113.00 1,069,113.00 211,652.00 235,875.67 62,265.00 62,265.00 7,350.00 7,350.00 281,267.00 305,290.67 158,912.00 131,436.24 0.00 0.00 (178,834.68)- Unfav. due to revised Information Technology User Rate Structure 762,389.50 - Fay due to 1999 User Rates 0.00 - Offset of I.T. fund balance to balance I.T. budget 0.00 - Data Warehouse Res, #97138, $155,808—Transfer positions from Comm. & Econ. Dev. to Disc. Res. 698309, 681,690-- Enhancements to Equal. & Tax Billing Sys. Res. Res. #98242, $552,500. Res. #99005 Medical Examiner Equipment for $279,115 585,55482 (2,265,299.82)- Professional Services (unfav) due to Y2K contractors and (unfav) due to replacement of non-compliant pc suites 0 00 (1,679,745.00) Total Fund: 24,023.87 0.00 - 0 00 - Sheriffs Dept. Contract with Addison, Highland and Springfield Township 24,023.67 - Revenue Fav. due to Investment income 27,475.76 - Fav. due to minimum operating expenses 0.00 259,153.00 1,457,000.00 1,716,153.00 1,716,153.00 -------- 0.00 Information Technology - CLEMIS (635) OPERATING REVENUES: Outside Inside OPERATING TRANSFERS IN Total OPERATING EXPENSES OPERATING INCOME (LOSS) 281,153.00 289,383.90 1,435,000.00 1,435,000.00 2,700,000.00 2,700,000.00 4,416,153.00 4,424,383.90 2,931,916.00 1,531,898.86 1,484,237.00 2,892,485.04 Total Fund: 8,230.90 - Fay due to investments 0.00 Sheriff Dept. Contracted Services of $27,000 , plus County Countribution of 1.408,000 0.00 - E-911 8,230.90 1,400,017.14 - Fav. due to minimum operating expenses 1,408,248.04 1 05/13/99 IT2QTR99.VVK4 (129,655.76) (Unfav) due to lower income from investments and over-stated appropriation 198,944,68 - Fay due to 15% retroactive phone rate increase 0.00 - 69,288.92 - 0.00 - Anticipation of PBX equipment 0.00 69,288.92 OAKLAND COUNTY INTERNAL SERVICES INFORMATION TECHNOLOGY FY99 SECOND QUARTER FORECAST ADOPTED AMENDED FY 1999 VARIANCE BUDGET BUDGET FORECAST FAV/(UNFAV) information Technology -Telephone Communication (675) COMMENTS OPERATING REVENUES: Outside 2,524,212.00 1,527,803.00 1,398,147.24 Inside 1,527,803.00 2.524,21200 2,723,156.68 OPERATING TRANSFERS IN Total 4,052,015.00 4.052.015.00 4,121,303,92 OPERATING EXPENSES 3,582,540.00 4,054,353.00 4,054,353.00 OPERATING TRANSFERS (OUT) (535,000.00) 0.00 000 OPERATING INCOME (LOSS) (65,525.00) (2,338.00) 66,950.92 2 05/13/99 IT2QTR99.WK4 •••n I. Interoffice MEMORANDUM to: Tim Soave, Fiscal Services cc: Claudia Martell°, Reimbursement from: Nancy L Wagner, Reimbursement re: Inmate Waived Report date: April 29, 1999 Submitted for your review is the Inmate Report for 1999 for the Months of January, February, and March. Amounts Amount Waived January 99 011586 CZ 79 $ 159,597.00 February 99 012242 CZ 68 $ 107,190.40 March 99 012902 CZ 77 $ 196,595.60 TOTAL 224 $ 463,383.00 From the desk of .... Nancy L. Wagner Reimbursement 1200 N Telegraph Road Pontiac, Michigan 48343 te1:248-858-1459 fax:248-975-4288 tiFREBY FOREGOING RESOLUTION C/A I. L. Brooks Pa, • • t • ). Resolution #99141 June 10, 1999 Moved by Jensen supported by Patterson the resolution be adopted. AYES: Dingeldey, Douglas, Galloway, Garfield, Gregory, Jensen, McPherson, Melton, Millard, Moffitt, Obrecht, Palmer, Patterson, Schmid, Sever, Suarez, Taub, Amos, Appel, Causey-Mitchell, Colasanti, Coleman, Devine. (23) NAYS: None. (0) A sufficient majority having voted therefor, the resolution was adopted. STATE OF MICHIGAN) COUNTY OF OAKLAND) I, G. William Caddell, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and accurate copy of a resolution adopted by the Oakland County Board of Commissioners on June 10, 1999 with the original record thereof now remaining in my office. In Testimony Whereof, I have hereunto set my hand and affixed the seal of the County of Oakland at Pontiac, Michigan this 10th day_of June, 1999.