HomeMy WebLinkAboutResolutions - 1994.12.08 - 24035• • it
MISCELLANEOUS RESOLUTION #94 344
By: Finance Committee, John P. McCulloch, Chairperson
IN RE: DEPARTMENT OF MANAGEMENT & BUDGET - 1994 THIRD QUARTER BUDGET
AMENDMEENTS
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
provides for budget adjustments for variances between the budgeted revenue and actual revenue, and
Section 23, which provides for budget adjustments for variances between estimated revenue and projected
expenditures, adjustments be made; and
WHEREAS the 1994 Third Quarter Forecast Report has identified several variances and budget
amendments are recommended; and
WHEREAS State Court Fund Disbursement revenue and expenditure accounts need to be
budgeted to reflect the receipt of P.A. 189 of 1993 funds from the State; and
WHEREAS the Probate Court has increased commitments to boot camp programs from 10 to 15
youth per month causing an unfavorable budget variance; and
WHEREAS the State has increased rates for youth committed to its care and an additional
appropriations are needed in the Probate Court and the Non-Departmental Juvenile Waiver Account; and
WHEREAS real estate activity in the Register of Deeds has continued to remain high due to low
interest rates resulting in additional revenue and additional operating expenses; and
WHEREAS Sheriffs overtime is anticipated to exceed budget by $1,034,000 due to staff turnover
leaving vacancies which must be tilled on a 24 hour basis; higher number of inmates being housed in the
main jail requiring additional staff coverage; increased hospital watches due to several cases requiring
longer-term hospital stays; and increased requests for patrol hours by local communities on a mini
contract basis; and
WHEREAS due to several complex medical cases the cost for the hospitalization of prisoners will
rise $215,000 above the 1994 budget and $336,000 above the anticipated amount budgeted for the
contract with Blue Cross beginning December 1, 1994; and
WHEREAS due to the crowding of the main jail, the cost of housing prisoners outside the County
is projected to exceed budget by $45,000; and
WHEREAS the Sheriff is anticipated to generate $1,020,000 in revenue above the 1994 Amended
Budget, primarily in state reimbursement for housing O.U.I.L. Third Offense and Deferred Offender
inmates, increased mini-contract revenue, and additional board and care revenue due to more aggressive
collection methods; and
WHEREAS Sheriffs staff turnover has generated salary and fringe benefit savings in an amount,
when combined with additional revenue, sufficient to cover forecasted over expenditures in the Sheriffs
budget; and
WHEREAS the Prosecuting Attorney hasxonirolt-able operating unfavorability which is offset by
salary and fringe favorability from unfilled positions and turnover; and
WHEREAS the 1994 Adopted Budget did not include a $138,000 appropriation for Facilities
Management to continue 9-1-1 equipment depreciation and maintenance; and
WHEREAS interest revenue from the sale of land and reimbursement of Solid waste site fees is
projected to be less than originally estimated; and
WHEREAS the Drain Commissioner's reorganization has resulted in the assignment of special
revenue fund employees to budgeted drain projects, thereby increasing the non-controllable operating
expenditures which is offset by increased Soil Erosion Fee revenue; and
WHEREAS Drain Commissioner revenue, Reimbursement of Salaries - Drain Projects, is
unfavorable due to reduced billings associated with vacant positions resulting from the early retirement
program; and
WHEREAS funds were budgeted in the Non-Departmental Future Space Requirements account
for the Novi District Court's furniture, equipment and security devices, need to be transferred to Facilities
Maintenance and Operations Project Work Order Fund ; and
WHEREAS consolidating Fund #40100, Capital Improvement Buildings and Fund #40200,
Capital Improvement - Utilities, into one Capital Improvement Fund will allow for a single financial
record of Capital Improvement expenditures and improve the efficiency of the accounting process; and
WHEREAS the Reimbursement Division's overtime expense is unfavorable due to workload and
disability leaves, and funds are available in controllable operating budget to cover the overtime increase;
and
WHEREAS the County's financial records indicate the Oakland County Building Authority,
Medical Care Facility Bond and Interest Funds account has a balance; and
WHEREAS it is recommended the fund be closed and the balance, approximately $27,600, be
transferred to the Medical Care Facility's budget to purchase equipment; arid
WHEREAS the Medical Care Facility has received two Medicaid inter-governmental transfers
totaling $252,800 which were not anticipated; and
WHEREAS an adjustment of the Departmental Administration's leased vehicle budgets is needed
to correspond to actual charges; and
WHEREAS in agreement with the CLEM1S user group (Police Chiefs) and the County, effective
retroactive to January 1, 1994, a separate fund be created to more effectively monitor CLEM1S operations
rather than remaining combined with the operations of the Department of Information Technology; and
WHEREAS the Fringe Benefit Review Committee has selected KPMG Peat Marwick to review
the health-care component of the Flexible Benefit Plan, as well as the jail inmate health care program, and
make recommendations on revisions at a cost not to exceed $97,500 with funding available in the Fringe
Benefit Fund (#73500): and
WHEREAS the final payment for the Phase IV Id-Party agreement exceeds the balance of the
appropriation by $7,237; and
WHEREAS various departmental budgets reflect an unfavorable variance in the Computer
Services - Operation account due to billings associated with training staff to effectively utilize Office
Automation Equipment and installation of new the equipment; and
$7,237
(1.879,627)
(1
so
Road Improvements
Revenue Sharing Loss
I
State Reimbursement
Deeds
Mortgages
Recording Fees
Land Transfer Tax
Miscellaneous Revenue
Sale of Land & Buildings
Income from Investments
$142,000
60,000
488,700
606,700
KIM
$2,2_4/ADD
$252.800
($86,642)
($3.677.443)
($1.263.885)
EXPENDITURES
ADMINISTRATION
4-10100-121-01-00-6610
4-10100-131-01-00-6610
4-10100-151-01-00-6610
4-10100-161-01-00-6610
4-10100-171-01-00-6610
4-10100-191-01-00-6610
NON-DEPARTMENTAL/PROBATE COURT
4-10100-901-01-00-3711 General Fund-State Institutions
4-29260-343-01-00-3589 Juvenile Maint Fund-Private Instit
4-29260-343-01-00-3711 Juvenile Maint Fund-State Instit
Sub-Total
CLERK/REGISTER OF DEEDS
4-10100-213-01-00-1002 Overtime
4-10100-214-01-00-1002 Overtime
4-10100-214-01-00-4909 Postage
4-10100-215-01-00-4909 Postage
4-10100-215-01-00-6672 Print Shop
Sub-Total
M & B - Admin.
Centeral Svs - Admin.
Personnel - Admin.
Human Sys. - Admin.
Public Sys - Admin.
Comm & Econ Admin,
$1,460
210
175
210
(3,510)
144.6.G
$5
$200,000
120,000
215.000
$535,000
$5,000
44,000
20,000
3,000
1,50D
$73,500
REVENUE
CLERK/REGISTER OF DEEDS
3-10100-213-01-00-2596
3-101 00-21 3-01-00-2093
3-10100-214-01-00-2343
3-10100-214-01-00-2463
3-10100-214-01-00-9203
Sub-total
MEDICAL CARE FACILITY
3-52'100-163-01-00-2340
SOLID WASTE
3-10100-141-15-00-2561
MISCELLANEOUS REVENUE
3-10100-906-01-00-2233
TOTAL REVENUE
NON-DEPARTMENTAL
4-10100-901-01-00-9107
4-10100-909-01-00-3755
Sub-Total
TOTAL EXPENDITURES
TOTAL
SCHEDULE B
4-10100-111-01-00-6360
4-10100-111-05-00-6360
4-10100-112-01-00-6360
4-10100-115-01-00-6360
4-10100-122-01-00-6360
4-10100-123-01-00-6360
4-10100-124-01-00-6360
4-10100-127-01-00-6360
4-10100-138-03-00-6360
4-10100-141-01-00-6360
4-10100-141-15-00-6360
4-10100-148-01-00-6360
4-10100-154-01-00-6360
4-10100-169-01-00-6360
4-10100-173-01-00-6360
4-10100-175-01-00-6360
4-10100-179-01-00-6360
4-10100-181-01-00-6360
4-10100-191-01-00-6360
4-10100-192-01-00-6360
4-10100-194-01-00-6360
4-10100-212-10-00-6360
4-10100-213-01-00-6360
4-10100-215-01-00-6360
4-10100-221-01-00-6360
4-10100-311-01-00-6360
4-10100-322-01-00-6360
4-10100-323-01-00-6360
4-10100-324-01-00-6360
4-10100-325-01-00-6360
4-10100-341-01-00-6360
4-10100-344-01-00-6360
4-10100-411-01-00-6360
4-10100-433-10-00-6360
4-10100-511-01-00-6360
4-10100-513-03-00-6360
4-10100-611-01-00-6360
4-21500-312-01-00-6360
4-22100-141-30-05-6360
4-22100-162-)0(-00-6360
4-22100-178-01-00-6360
4-29230-165-01-00-6360
4-52100-163-01-00-6360
4-10100-909-01-00-3755
County Executive
Community & Minority Affairs
Auditing Division
Corporation Counsel
Budget
Accounting
Purchasing
Reimbursement Division
Radio Communications
Facilities Management
Solid Waste
Facilities Engineering
Personnel
Medical Examiner
Veterans Services
Cooperative Extension
Circuit Court Probation
Information Technology
Community & Economic Develop.
Development & Planning
Equalization
Cleric/Register of Deeds
Clerk's Office - Elections
Jury Commission
Treasurers Office
Circuit Court
52nd Dist Ct Div 1
52nd Dist Ct Div 2
52nd Dist Ct Div 3
52nd Dist Ct Div 4
Probate Court - Juvenile
Probate Court
OC Prosecutor
Sheriff
Board of Commissioners
Reference Library
Drain Commissioner
Friend of the Court
Facilities Management/EMS
Health Division
Animal Control Division
Children's Village
Medical Care Facility
Revenue Sharing Loss
$7,200
160
5,505
4,275
8,685
29,240
8,770
11,940
2,150
1,240
160
425
21,910
2,555
1,945
2,645
5,050
59,068
11,180
11,505
24,965
7,830
1,520
405
13,420
18,410
6,700
3,185
7,795
1,800
785
23,235
18,425
24,700
4,405
17,590
5,685
7,345
1,280
13,235
1,020
19,540
29.(1
$419,173
($419,173)
$0
1994 THIRD QUARTER FORECAST • •
REVENUE AND EXPENDITURES
SUMMARY BY DEPARTMENT.
1954 BUDGET AMOUNT
ADOPTED AS 1994 FAVORABLE/
13111S1E1 AMENDED FORECAST {UNFAVORABLE PERCENT
SWALE
GENERAL FUND
Taxes 133,306,612 133.308.812 132.531,660 (775,1621 -0.56%
Intergovernmental 21.432,711 21,432,711 22,166,574 733,863 342%
Charges for Services 52.000,711 52,456,907 55,742 455 3.265,548 6.26%
SUB-TOTAL GENERAL FUND $206,740,234 $207,196,430 5210,440.679 $3,244,249
_OTHER BEMS
Intergovernmental 97.426,169 99,678.164 99.678,164 0 0.00%
Charges for Services 12.129.557 11,251,719 12.758.419 (493,300) -3 .12%
Miscellaneous Revenue 13,500,000 14,194.048 10,294,048 (3.900.000) -27.40%
SUB-TOTAL OTHER FUNDS 121.257,726 127.123,931 122,730,631 (4.393.300) -3.46%
TOTAL BUDGETED FUNDS $329,997.960 $334,320.361 ;333,171,310 ($1,149,051) -0.34%
Resources canied forward 364,775 3,282,366 3.282,366 0 0.00%
TOTAL GOVERNMENTAL RESOURCES $330362735 $337,602,726 1336,453.675 ($1,149,051) -0 34%
-----
EXPENDITURES
ADMINISTRATION OF JUSTICE
Circuit Court
52nd District Court
Probate Coon
TOTAL ADMIN. OF JUSTICE
LAW ENFORCEMENT
Prosecuting Attorney
Sheriff
TOTAL LAW ENFORCEMENT
GENERAL GOVERNMENT
Clerk/Register of Deeds
Treasurer
Board of Commissioners
Drain Commissioner
TOTAL GENERAL GOVERNMENT
COUNTY EXECUTIVE
County Executive Admn.
Management and Budget
Central Serv..oes
Facilities Management
Personnel
Human Svs.
Public Services
Information Technology
Community & Economic Dev.
TOTAL COUNTY EXECUTIVE
$20,261,037 120.991,055 120.299.055 9692.000 3.30%
8,169.724 8,306,683 7,918.783 387,900 4 87%
18,027.085 17.913,903 17,901,903 12,000 0 07%
96,457.847 47,211,641 48.119,741 1.091.900 2.31%
11.488,067 11.550,791 11,140.391 410,400 3.55%
55.643,198 56.008,119 56,964.119 (956,000) -1.71%
67,131,265 67,556 999 68 104,509 (545.600) -0.81%
6.867,737 6.897,879 6,936 579 (36.700) -0.56%
2,302,151 2,388.425 2,370 028 18.4130 0 77%
3,347,802 3.649,103 3,599.303 49 860 1.36%
4,877,410 4.604,103 4,289.103 315.000 684%
17.255.100 17,539.513 17,195,013 344,500 1.96%
2,918.860 2,978.030 2,904,530 73.500 2 47%
8,420,736 8,879,837 8,638,637 241.200 2.72%
2.445,803 2,554,249 2.554,249 0 0.00%
2,270.323 2,591.913 2,581,213 14,700 0.41%
3,262,054 3.429.100 3,388,100 41,000 1 20%
148,365,556 152,210,049 149.731,049 2.479,000 1.63%
3,938.961 4.155.365 3,999,575 155.380 3.74%
3845.417 3.625,027 3,375.027 250.000 6.90%
6853,629 7.363,764 7,276.164 87.600 1.19%
$1152.361,339 $187,787.324 $184.445.944 13.338.380 178%
TOTAL DEPARTMENTS $313,205 551 $320,097,387 1315,868.207 14.229.180
NON-DEPARTMENTAL APPROPRIATIONS
TOTAL NON-DEPARTMENTALS 117,157.164 917,5E15,339 $17,677,341 ($172,002) -0.95%
TOTAL GOVERNMENTAL EXPENDITURES $330.362,735 $337,602,726 9333.545,548 14,057.178 1.20%
Governmental Funds
Favorable/(Unfavorable) $0 $0 $2,908,127 52 908127
C. ...NT? OF OAKLAND
STATEMENT OF RECEIPTS -COUNTY OPERATING FUNDS
E.C41.11111ENONTHS.ENDING_SEETEMBER 311.1.994
PERCENT OF YEAR
BALANCE ELAPSED
BUDGET BUDGET REVENUE OF ESTIMATE 75.00%
AS BUDGET AS THRU TO BE PERCENTAGE
ADOPTED ADJUSTMENTS ADJUSTED 09130/94 COLLECTED COLLECTED
BUDGETED RECEIPTS
OTHER THAN TAXES
GENERAL FUND
STATE AND FEDERAL:
CIRCUIT JUDGES SALARIES $584,000.00 $584,000.00 $442,623.00 $141,377.00 75.8%
PROBATE JUDGES SALARIES 352,000.00 352,000.00 263,919.00 88,081.00 75.0%
DISTRICT JUDGES SALARIES 383,250.00 383,250.00 287,542.50 95,707.50 75.0%
MARINE SAFETY 194,000.00 194,000.00 191,479.94 2,520.06 98.7%
STATE INCOME TAX 14,677,000.00 14,677,000.00 8,358,153.79 6,318,846.21 56.9%
STATE REIMB. - P.A. 228 2,181,700.00 2,181,700.00 2,181,718.85 (18.85) 100.0%
CONVENTION FAC TAX PA 106107 510,002.00 510,002.00 494,403.87 15,598.13 96.9%
CIGARETTE TAX D1STRB 1,825,759.00 1,825,759.00 1,120,265.36 705,493.64 61.4%
INDIRECT COST RECOVERY 725,000.00 725,000.00 617,571.19 107,428.81 85.2%
COMMUNITY CORRECTIONS 0.00 0.00
TOTAL STATE AND FEDERAL 821.432.711.00 $0.00 $21,432,711.40 $13,957,677.50 $7,475,033.50 65.1%
CHARGES FOR SERVICES.
BOARD OF COMMISSIONERS $20,500.00 $20,500.00 . $15,145.00 $5,355.00 73.9%
COUNTY EXECUTIVE 14,200.00 8,600.00 22,800.00 995.00 21,605.00 4.4%
AUDITING 65,000.00 65,000.00 67,745.16 (2,745.16) 104.2%
DEVELOPMENT & PLANNING 337,013.00 5,664.00 342,677.00 212,648.50 130,028.50 62.1%
ACCOUNTING 223,019.00 (45,431.00) 177,58840 68,830.98 108,757.02 38.8%
EQUALIZATION 875,824.00 46,958.00 922,782.00 1,120,135.79 (197,353.79) 121.4%
REIMBURSEMENT 221,450.00 221,450.00 195,944.15 25,505.85 88.5%
CENTRAL SERVICES - ADMIN. 11,750.00 11,750.00 11 .750.00 0.0%
SUPPORT SERVICES 79,498.00 79,498.00 79,490.00 8.00 100.0%
AUCTION REVENUE - 13,000.00 13,000.00 873.31 12,126.69 6.7%
PrpnArPri hv Archtiniina as of 10121194
REVENUES
OTHER FUNDS
STATE AND FEDERAL
HEALTH - STATE SUBSIDY
DISASTER CONTROL
CHILD CARE SUBSIDY
COMMUNITY MENTAL HEALTH
SOCIAL SERVICES - FOSTER CARE
STATE COURT DISBURSEMENT FD,
TOTAL STATE AND FEDERAL
$2,165,700.00 $1,252,182.00 5913,518.00 57.8%
22,603.00 23,796.91 (1,193.91) 105.3%
4,100,000.00 4,982,089.46 (882,089.46) 121.5%
93,365,361.00 61,847,201.37 31,518,159.63 66.2%
24,500.00 26,378.30 (1,P8.30) 107.7%
553,899.00 (553,899.00)
$97,428,169.00 $2,249,995.00 $99,678,164.00 $68,685,547.04 $30,992,616.96 669%
$2,165,700.00
22,603,00
4,100,00000
91,115,366.00
24,500.00
2,249,995.00
4441TY OF OAKLAND
STATEMENT OF RECEIPTS -COUNTY OPERATING FUNDS
EQR_ININEMONILISINDING SEPTEMBER 301294
PERCENT OF YEAR
BALANCE ELAPSED
BUDGET BUDGET REVENUE OF ESTIMATE 75.00%
AS BUDGET AS THRU TO BE PERCENTAGE
ADOPTED ADJUSTMENTS ADJUSTED 09(30/94 COLLECTED COLLECTED
CHARGES FOR SERVICES:
FRIEND OF THE COURT $441,000.00 $441,000.00 $376,042.90 $64,957.10 65.3%
HEALTH 2,549,400.00 2,980.00 2,552,380.00 1,714,647.34 837,532.66 67.2%
EMERGENCY MEDICAL SERVICE 68,424.00 141,422.00 209,846.00 143,944.05 65,901.95 68.6%
ANIMAL CONTROL 825,233.00 825,233.00 716,467.08 108,765.92 86.8%
CHILDREN'S VILLAGE 1,330,000.00 777,760.00 2,107,760.00 1,110,476.13 997,283.87 52.7%
SOCIAL SERVICES - HOSP. 5,00000 5,000.00 1,124.92 3,875.08 22.5%
JUVENILE MAINTENANCE 770,000.00 770,000.00 564,539.94 205,460.06 73.3%
MEDICAL CARE FACILITY 6,340,500 00 6,340,500.00 4,949,711.93 1,390,788.07 78.1%
TOTAL CHARGES FOR SERVICES $12,329,557.00 $922,162.00 $13,251,719.00 $9,577,154.29 $3,674,564.71 72.3%
TOTAL OTHER FUNDS $109,757,726.00 $3,172,157.00 $112,929,883.00 $78,262,701.33 $34,667.181.67 69.3%
Prepared by Accounting a3 of 10121/94
C. .1TY OF OAKLAND
STATEMENT OF RECEIPTS -COUNTY OPERATING FUNDS
FOR NINE MONTHS ENDING ._sEETEmBEilao.1994
PERCENT OF YEAR
BALANCE ELAPSED
BUDGET BUDGET REVENUE OF ESTIMATE 75.00%
AS BUDGET AS THRU TO BE PERCENTAGE
ADOPTED ADJUSTMENTS ADJUSTED 09/30/94 COLLECTED COLLECTED
SPECIAL REVENUE AND
PROPIETARY FUNDS
PROPERTY TAX:
PARKS AND RECREATION $7,338,329.00 $7,338,329.00 $7,286,895.61 $51.433.39 99.3%
INTERGOVERNMENTAL REVENUE:
COMMUNITY DEVELOPMENT $5,444,848.00 $585,242.00 $6,030,090.00 $3,581,700.52 $2,448,389.48 59.4%
EMERGENCY SHELTER 52,000.00 67,000.00 119,000.00 62,975.46 56,024.54 52.9%
COMM DEV. HOME INVEST. 1,140,649,00 255,240.00 1,395,889.00 993,312.50 402,576.50 71.2%
FAMILY PLANNING 405,310,00 405,310.00 288,334.93 116,975.07 71.1%
WIC, GRANT 877,999.00 877,999.00 729,229.33 148,769.67 83,1%
M ID P.H.O.S.A.S. 3,911,994.00 3,911,994.00 3,214,669.68 697,324.32 82.2%
MICHIGAN BLOCK GRANT 41,012.00 41,012.00 56,417.71 (15,405.71) 131.6%
CHILDREN'S HEALTH SERVICES 251,034.00 251,034.00 176,593.81 74,440.19 70.3%
EARLY PREGNANCY SCREENING 214,170.00 214,170.00 365,014.62 (150,844.62) 170.4%
INFANT MORTALITY 157,594.00 157,594.00 112,669.22 44,924.78 71.5%
MINORITY LOW INCOME 35,196.00 35,196.00 35,196.00 0.0%
T.B. OUTREACH GRANT 51,598.00 51,598.00 21,18514 30,412.88 41.1%
T.B. SURVEY GRANT 16,728.00 16,728.00 5,617.04 11,110.95 33.6%
PRENATAL COORDINATION 67,390.00 67,390.00 47,596.51 19,793.49 70,8%
M.I.C. I 1.H.I.P. 170,881.00 170,881.00 68,928.74 101,952.26 40.3%
HIV SURVEY GRANT 18,670.00 18,670.00 18,670.00 0.0%
AIDS TESTING PROGRAM 213,783.00 213,783.00 141,725.00 72,058.00 66.3%
PREGNANCY PREVENTION 231,792.00 231,792.00 103,345.91 128,446.09 44.5%
IMMUNIZATION ACTION PLAN 385,907.00 365,907.00 44,591.79 321,315.21 12.2%
WORKSITE I COMMUNITY 214,017.00 214,017.00 114,579,11 99,437.89 53,5%
Prepared by Accounting as of 10/21/94
BALANCE
OF ESTIMATE
TO BE
COLLECTED
PERCENT OF YEAR
ELAPSED
75.00%
PERCENTAGE
COLLECTED
61.5%
79.9%
70.1% I
53.8%
85.8%
57.4%
79.6%
60,2%
100.3%
TOTAL CHARGES FOR SERVICES $58,440,240.00 $0.00 $58,440,240.00 $47,436,978.12 $11,003,261.88 81.2%
GRAND TOTAL RESOURCES
AVAILABLE - ALL FUNDS $420,868,965.00 $9,313,571.41 $430,182,536.41 $345.585,861.80 $84,595,874.61 80.3%
TY OF OAKLAND
STATEMENT OF RECEIPTS -COUNTY OPERATING FUNDS
MONIj$,E4DING SEPTEMBER
A
"PRINT SHOP
'RADIO COMMUNICATIONS
COMMISSARY FUND
"MATERIALS MANAGEMENT
COUNTY LIBRARY FUND
AVIATION
'DRAIN / W&S EQUIPMENT
DRAIN / SEWAGE ENTERPRISE
INFORMATION TECHNOLOGY- OPER.
`INFORMATION TECHNOLOGY - MDT
BUDGET
AS
ADOPTED
55,300.00
26,000.00
368,140.00
65,000.00
2,038,054.00
921,694.00
44,639,049.00
1,801,758.W
381,000.00
BUDGET
ADJUSTMENTS
BUDGET
AS
ADJUSTED
55,300.00
26,000.00
368,140.00
65,000.00
2,038,064.00
921,694.00
44,639,049.00
1,801,758.00
381,000.00
REVENUE
THRU
09/30194
34,025.26
20,762 86
257,952.62
34,950.35
9,167.24
1,748,321.25
529,117.46
35,537,952.45
1,084,128.91
382,000.00
21,274.74
5,237.14
110,187.38
30,049.65
(9,167.24)
289,742.75
392,576.54
9,101,096.55
717,629.09
(1,000,00)
TOTAL - SPECIAL REVENUE
AND PROPRIETARY FUNDS $90,506,230.00 $2,073,580.00 $92,579,810.00 $72,398,407.47 $20,181,402.53 78.2%
*INTERNAL SERVICE FUNDS -
Prepared by Accounting as of 10/21194
COUNTY OF OAKLAND
STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS
E_OR NINE MONTHS ENDING SEPIEMBER34-1994
PERCENT OF YEAR
ELAPSED
BUDGET BUDGET EXPENDITURES 75.00%
AS BUDGET AS AND UNENCUMBERED PERCENTAGE
ADOPTED ADJUSTMENTS ADJUSTED TRANSFERS BALANCE SPENT
BOARD OF COMMISSIONERS
LIBRARY BOARD
DRAIN COMMISSIONER
TOTAL GENERAL GOVERNMENT
1,930,527.00
1,417,275.00
4,877,410.00
269,616.76
31,683.86
(273,306.94)
2,200,143.76
1,448,95816
4,604,103.06
1,348,754.12
1,079,156.56
3,126,749.68
851,389.64
369,802.30
1,477,353.38
61.3%
74.5%
67.9%
$17,255,100.00 $284,412 65 $17,539,512.65 $12,483,947.20 $5,055,565.45 71.2%
COUNTY EXECUTIVE
EXECUTIVE
ADMINISTRATION $1,505,085.00 $43,622.11 $1,548,707.11 $1,149,348.27 $399,358.84 74.2%
AUDITING 547,395.00 2,061.22 549,456.22 432,102.63 117,353.59 78.6%
CORPORATION COUNSEL 866,380.00 13,488.69 879,866.69 586,520.27 293,348.42 66.7%
$2,918,860.00 $59,170.02 $2,978,030.02 $2,167,971.17 $810,058.85 72.8%
MANAGEMENT & BUDGET
ADMINISTRATION $117,319.00 $886,152.00 $1,003,471.00 $240,908.45 $762,564.55 24.0%
BUDGET DIVISION 873,397.00 58,006.49 931,403.49 697,050.40 234,353.09 74.8%
ACCOUNTING DIVISION 5,377,539.00 (2,106,349.34) 3,271,189.66 2,558,644.61 712,545.05 78.2%
PURCHASING DIVISION 670,342.00 59,544.29 729,886.29 532,651.84 197,234.45 73.0%
REIMBURSEMENT DIVISION 1,382,139.00 1,561,747.85 2,943,886.85 2,204,695.15 739,191.70 74.9%
$8,420,736.00 $459,10t29 $8,879,837.29 $6,233,948.45 $2,645,888.84 70.2%
CENTRAL SERVICES
ADMINISTRATION $126,15500 ($307.00) $125,848.00 $97,634.29 $28,213.71 77.6%
SUPPORT SERVICES 2,319,648.00 108,753.36 2,428,401.36 1,956,799.33 471,602.03 80.6%
$2,445,803.00 $108,446.36 $2,554,249.38 $2,054,433.62 $499,815.74 80.4%
Prepared by Accountina as of 10/21194
Gus-MTV OF OAKLAND
STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS
FOR NINE MONTHS EN DM SEPTEMBER 30.
PERCENT OF YEAR
ELAPSED
BUDGET BUDGET EXPENDITURES 75.00%
AS BUDGET AS AND UNENCUMBERED PERCENTAGE
ADOPTED ADJUSTMENTS ADJUSTED TRANSFERS BALANCE SPENT
VETERANS' SERVICES
COOPERATIVE EXTENSION
ANIMAL CONTROL
CIRCUIT COURT PROBATION
1,302,862.00
570,223.00
1.467,836.00
480,363.00
2,402.49 1,305,264.49 973,496.23 331,768.26 74,6%
216,252.59 786,475.59 552,100.10 234,375,49 70.2%
14,529.07 1,482.365.07 1,113,144.32 369,220.75 75.1%
3,372.79 483,735.79 367,249.86 116,485.93 75.9%
53.938.961.00 216,393.94 $4,155,354.94 $3,095,636.89 $1,059,718.05 74.5%
INFORMATION TECHNOLOGY $3,885,417.00 ($260,390.23) $3,625,026.77 $1,294,984.17 $2,330,042.60 35,7%
COMMUNITY & ECONOMIC DEV.
ADMINISTRATION $216,385.00 $44,279.67 $260,664.67 $155,927.52 $104,737.15 59.8%
DEVELOPMENT & PLANNING 2,288.524.00 171,193.19 2,459,717.19 1,781,153.84 678,563.35 72.4%
EQUALIZATION 4,081,653.00 294,662.40 4,376,315.40 3,021,588.53 1,354,726.87 69.0%
COMMUNITY DEVELOPMENT 267,067,00 267,067.00 252,889.00 14,178 00 94.7%
$6,853,609.00 $510,135.26 $7,363,764.26 $5.211,558.89 $2.152,205.37 70.8%
TOTAL COUNTY EXECUTIVE
TOTAL DEPT. & INSTITUTIONS
$182,361,339.00 $5,425,985.46 $187,787,324.46 $134,423,879.64 $53,363,444.82 71.6%
5313,205,551.00 $6,891,836.45 320,097,387.45 $232,210,380.37 587,887,007.08 72.5%
NON-DEPT. APPROPRIATIONS
COUNTY OPERATIONS
STATE INSTITUTION! JUVENILE WAIV. $300,000.00 $300,000.00 $361,430.94 ($61,430.94) 120.5%
PROJECT WORK ORDERS $500,000.00 $500,000.00 5500.000.00
CAPITAL UTILITIES 150,000.00 150,000,00 374,999.99 (224,999.99) 250.0%
LIABILITY INS. FUND 1,178.55 1.178,55 1,178.55 0.00 100.0%
COMPUTER SERVICE DEVELOP. 281,607.25 (281,607.25)
Prepared by Accounting as of 10/21194
MINTY OF OAKLAND
STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS
FOR NINE MONIII 30. 1994
PERCENT OF YEAR
ELAPSED
BUDGET BUDGET EXPENDITURES 75.00%
AS BUDGET AS AND UNENCUMBERED PERCENTAGE
ADOPTED ADJUSTMENTS ADJUSTED TRANSFERS BALANCE SPENT
---
SUNDRY $400,000.00 $400,000.00 $767,208.64 ($367,208.64) 191.8%
RESERVED FOR TRANSFERS
TRANSFER TO RESERVES
REVENUE SHARING LOSS $2,249,159.00 $49,641.00 $2,298,800.00 $2,298,800.00 0.0%
DEFENSE ATTORNEY FEES-G
CONTINGENCY 250,000.00 258,491.50 508,491.50 508,491.50 0.0%
SALARY ADJUSTMENT (2,201,047.00) 1,863,487.00 (337,560.00) (337,580.00) 0.0%
CLASS, & RATE CHANGE 60,000.00 (33,068.00) 26,912,00 26,912.00 0.0%
OVERTIME 50,000.00 (15,000.00) 35,000.00 35,000.00 0.0%
SUMMER EMPLOYMENT 300,000.00 (300,000.00) 0.00 000
EMERGENCY SALARIES 450,000.00 (410,612.00) 39,388.00 39,388.00 0.0%
FRINGE BENEFIT ADJ. (99,973.00) 480,000.00 380,027.00 380,027.00 0.0%
CAPITAL OUTLAY 75,000.00 71,811.41 146,811.41 146,811.41 0.0%
DISABILITY INSURANCE 858,500.00 858,500.00 858,500.00 0.0%
DEFERRED COMPENSATION PLAN 225.00 (225.00)
DISABILITY RESERVE (858,500.00) (858,500.00) (858,500.00) 0.0%
OFFICE AUTOMATION 2,000,000.00 (1,357,673.00) 642,327.00 642,327.00 0.0%
$3,133,139.00 $607.057.91 $3,740,196.91 $225.00 $3,739,971.91 0.0%
TOTAL NON-DEPT APPROPRIATIONS $17,157,184.00 $348,154.96 $17,505,338.96 $10,810,380.01 $8,694,958.95 61.8%
TOTAL GOVERNMENTAL FUNDS $330,362,735.00 $7,239,991.41 $337,602,726.41 $243,020,760.38 $94,581,966.03 72.0%
PROPRIETARY & SPECIAL REV. FUNDS
ADMINISTRATION OF JUSITICE
Prepared by Accounting as of 10121/94
COUNTY OF OAKLAND
STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS
EORNINEMONIHS_ENQING_SEPIEMBERM-19.M
PERCENT OF YEAR
ELAPSED
BUDGET BUDGET EXPENDITURES 75.00%
AS BUDGET AS AND UNENCUMBERED PERCENTAGE
ADOPTED ADJUSTMENTS ADJUSTED TRANSFERS BALANCE SPENT
CENTRAL SERVICES
PARKS & RECREATION
AVIATION DIVISION
• MATERIAL MANAGEMENT
* LEASED VEHICLES
* PRINT SHOP
* RADIO COMMUNICATIONS
$10,035,625.00
2,027,379.00
65,000.00
152,500.00
55,300.00
26,000.00
$10,035,625.00 $7,369,610.25 $2,666,014.75 73.4%
2,027,379.00 1.358,255.21 669,123.79 67.0%
65,000.00 34,950.35 30,00.65 53.8%
152,500.00 6,931.45 145,568.55 4.5%
55,300.00 34,025.26 21,274.74 61.5%
26,000.00 20,762.86 5,237.14 79.9%
$0.00 • $12,361,804.00 $6,824,535.38 $3537,268.62 71.4% $12,361,804.00
$1,471,709.00
817,105.00
261,840.00
$2,550,654.00
FACILITIES MANAGEMENT
• MAINTENANCE & OPERATIONS
• TELEPHONE COMMUNICATIONS
• MARKETS
$1,471,709.00
817,105.00
261,840.00
$1,632,053.90
642,979.39
210,930.45
($160,344.90) 110,9%
174,125.61 78.7%
50,909.55 80.6%
$0.00' $2,550,654.00 $2,485,963.74 $64,690.26 97.5%
INSTITUTIONAL & HUMAN SERVICES
EARLY PREGNANCY SCREENING
FAMILY PLANNING GRANT
W.I C GRANT
M D.P H. .f 0.S.A.S. GRANT
MCH BLOCK GRANT
CHILDRENS HEALTH SERVICES
INFANT MORTALITY REDUCTION
T.B. OUTREACH GRANT
T.B. SURVEY GRANT
AIDS TESTING PROGRAM
$214,170.00 $214,170.00 $365,014.62 ($150,844.62) 170.4%
405,310.00 405,310.00 288,334.93 116,975 07 71.1%
877,999.00 877.999.00 729,229.33 148,769,67 83.1%
3,911,994.00 3,911,994.00 3,214,669.68 697,324.32 62.2%
41,012.00 41,012.00 56,417.71 (15,405.71) 137.6%
251,034.00 251,034.00 176,593.81 74,440 19 70.3%
157,594.00 157,594.130 112,669,22 44,924.78 71.5%
51,598.00 51,598.00 21.185.14 30,412.86 41.1%
16,728.00 16,728.00 5,617.04 11,110.96 33.6%
213,783.00 213,783.00 141.725,00 72,058,00 66.3%
Prepared by Accounting as of 10/21/94
52,000.00
1,140,649.00
67,000 00
255,240.00
119,000.00
1,395,889.00
$7,544,979.00
62,975.46
993,312.50
$4,637,988.48
$89,926,945.00
$6,637,497.00 $907,482.00
$87,853,365.00 $2,073,580.00 $66,182,775.27
32.652,865.00 32,652.665.00
$420,866,965.00 $9,313.571.41 $430.182,536.41 $309,203,535.65
EMERGENCY SHELTER GRANT
HOME INVESTMENT GRANT
TOTAL SPECIAL REVENUE
PROPRIETARY FUNDS
EQUITY AND OPERATING
TRANSFERS
GRAND TOTAL - ALL FUNDS
56,024.54 52.9%
402,576.50 71.2%
32,906.990.52 61.5%
$23.744,169.73 73.6%
$2,652,865.00 0.0%
5120,979,000 76 71.9%
COuNTY OF OAKLAND
STATEMENT OF EXPENDITURES INCLUDING ENCUMBRANCES COMPARED WITH APPROPRIATIONS
EOB NINE MONTHS ENDING_aelEMBER30..129A
BUDGET
AS
ADOPTED
BUDGET
ADJUSTMENTS
BUDGET
AS
ADJUSTED
EXPENDITURES
AND
TRANSFERS
UNENCUMBERED
BALANCE
PERCENT OF YEAR
ELAPSED
75.00%
PERCENTAGE
SPENT
1) • INTERNAL SERVICE FUNDS •- NON-COUNTY EXPENDITURES
2) GRANT FUND AMOUNTS REFLECT FUNDS RECEIVED DURING THE CALENDAR YEAR;
FISCAL YEAR FOR GRANTS MAY VARY.
Prepared by Accounting as of 10/21/94
Cafeteria
Radio Communications
Cooperative Extension
Facilities Engineering
Solid Wasle
Facilities Mgt. - Admin.
Personnel-Emp4oyee Relation
Medical Examiner
Public Services
Clerk/Regisler of Deeds
Clerk • Land Transfer 'Tax
Treasurer
Circuit Court
Friend of the Court
District Ct. I Walled Lake
District Ct. II Clarkston
District Ct III Rode Hills
District Ct. IV Troy
Probate Court
71,480 71,480 71,480
27,709 27,700 27,700
8,000 109,250 109,250
9,000 9,000 1,500 (7,500)
401,838 401,838 315,196 (86,642)
47,170 47,170 47,170
10,500 10,500 10,500
43,900 58,900 43,900 (15,000)
8,500 8,500 11,000 2,500
3,951,400 4,005,987 5,303,187 1,297,200
2,437,779 2,437,779 2,264,679 (173,100)
928,366 926,366 837,166 (91,200)
2,399,269 2,399,269 2,062,269 (337,000)
1,306,270 1,306,270 1,367,770 61,500
949,700 1,094,700 1,127,700 33,000
1994 THIRD QUARTER FORECAST
REVENUE
BUDGET BUDGET AMOUNT
AS AS 1994 FAVORABLE
ADOPTED AMENDED FORECAST (UNFAVOFtAeLE) PERCENT EXPLANATION
...........nn•••.•n••n••n••n•••nn•
0.00%
0.00%
0 00% - The State is expected to reimburse 50% of Gypsy Moth Suppression Program cost (total cost
approximately $106,5130); the remaining portion is to be deeded among participating focal units, less
administrative cost from the County.
-83.33% Reduced activities for outside agencies.
-21.56% - Interest income for sale of land and reimb, of site fees less than expected. Budget amendment is recom.
000%
0.00%
-25.47% - Unfav. Medical Sys. arid Miscellaneous revenue ($19000) due to Mass Spectrometer on-line delay, partially
offset by increase in number of requests for cremation approvals, $40,000
29.41% - Increase in time applied to JTPA Administration.
32.38% - Low interest rates earlier in the year increased mortgage refinancing activity, $1.155,400; backlog in recording
activity has been resolved. which increased revenue for recording fees; State reimbursement for special election
$142,000. Budget amendment is recommended for Register of Deeds overtime due to increased work load,
4,900,000 4,900,000 5,850,000 950,000 19.39% - Mortgage refinancing activity increased earlier in the year due to low interest rates.
5,214,640 5,214,640 5,888,440 673,800 12.92% - New industrial Facilities Tax Abatements, 9154,300; May tax sale, $203,000; TIFA/DDA recovery attributed to
Treasurers office efforts, $160,400: Inheritance Tax, $42,000; COMIllertifil Facilities Tax, $28,000; and Tax
Statements, $65,000 due to increase activity. .
3,096,000 3,183,500 2,983,500 (200,000) -6.28% - Court Costs unfav. ($75,000), Defense Ally Fees Reimbursement unfav. ($150,000) rate of criminal caseload
not increasing as high as preiected; partially offset by Mediation Fines fay. $20,000.
6,821,100 6,821,100 6,821,100 0.00% Alimony Service Fees unfav, ($175,000) and Processing Fees unfav. ($90,000) due to delay in implementation
legislation change; offset by Performance Incentive fay. $26,000.
-7.10% - Unfav. due to decrease in caseload. Filing fees ($17,400), Probation Assessment and Evaluation ($77,400)
and Probation Oversight, ($78,100).
-9.82% - State Law Costs decrease in caseload.
-14.05% - Unfav. due to decrease in tickets. Ordinance Fines & Costs, ($196,000) and State Law Costs, (5130,100).
Decrease in Probation Fees, ($11,000).
4.71% - Fey, increase in caseload. Ordinance Pines & Costs $97,700. Probation Assessment & Evaluation ureav.
(814,900) due to delay in program start-up, Probation Oversee Fees, ($21,300).
3.01% - Fay. revenue due to demand for certified copies $48,000; collection for misc. court costs, 518,000; Atry Fees-
Marital Health, $3,000 & reimbursement for Clinical Evaluations, $24,000 which is partially offset by decrease
in Gov't Benefit Board & Care, ($30,000), Probation Fees, ($27,000) and Misc. Fees, ($3,000).
Prosecuting Attorney
Sheriff
188,000 188,000 106,000 0.00%
14,117,190 14,317,863 15,340,883 1,023,000 7.14% - Increased O.U.I,L. Third Offense reimbursement due to higher number of cases, $600,000; increased Deferred
Offender reimbursement due to more timely reporting, $165,000; increased Board & Care revenue due to more
aggressive collections. 125.000; increased mini-contract revenue due to additional hours, $225,000; partially
offset by reduced contract revenue, ($95,000)
NOTE: mini-contract revenue reflects increased overtime costs, budget amendment recommended
Library Board
Drain Commissioner
REVENUES OTHER FUNDS
STATE AND FEDERAL
140,579 t40579 140,579
3,061,076 2.897 451 2,839,551 (57,900)
--
$52,000,711 $52,456,907 $55,742,455 $3,285,548 6.26%
0..00%
-200% - Vacant positions due to early retirement program ($141,000), partially offset by increase in Soil Erosion Fees,
$81,000 Budget Amendment Recommended.
Prepared by: Budget Division 11/22/94
Friend of the Court
Controllable Personnel
Conte°Ileble Operating
Non-Controllable Operating
COUNTY OF OAKLAND
1994 THIRD QUARTER FORECAST
EXPENDITURES
Circuit Court
BUDGET BUDGET AMOUNT
AS AS 1004 FAVORABLE
ADOPTED AMENDED FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel $5,415,369 $5,444,104 $5,319,104 5125,000 2.30% - Turnover.
Controllable Operating 6,255,663 6,341,884 6,861,884 480,000 7.57% - Far. Defense Attorney Fees, 5400000, and various other operating, $70,000 due to caseloa
increasing at a level less than budgeted. fav. Publishing Court Calendar, $24,000 attributed .
Court's effort and Visiting Judge fail. $44,000 due to use of grant funding. Partially offset by
Transcripts on Appeals unfav. ($55,000) due to increase in number of requests.
Non-Controllable Operating 1,606,607 1,932,805 1,932,805 0.00%
$13,278,644 $13,718,793 $13,113.793 5605,000 4.41%
$5,366,960 55,345,584 $5,258,564 $57,000 1.63% - Salaries and Fringe Benefits fay. $80,000 due to turnover and overtime fay. $7,000 due to
FOC procedural changes.
670,145 709,145 709,145 0.00%
945,288 1,217,553 1,217,553 0.00%
56,982,393 57,272,262 $7,185,262 587,000 1.20%
Department Total
Controllable Personnel $10,783,329 $10,789,663 $10,577,663 $212,000 1.96%
Controllable Operating 5,925,313 To:151,021 5,571,023 430,000 6.31%
Non-Controllable Operating 2,551,895 3,150,358 3.150,358 0 0.00%
520.261,037 $20,991,055 520.299.055 5892,000 3.30%
.T a SIT.Z.ZZIMMILMIN111116i 1•NALIS
JudiciaL/Administration
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Juvenile Maintenance
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Estates and Mental
Controllable Personnel
Controllable Operating
Non-controllable Operating
Training & Clinical Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
Field Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
EXPLANATION OF SIGNIFICANT VARIANCES
- Salary and fringe fay., $96,500, due to administrator vacancy and turnover, offset
by increased overtime. ($7,300).
- Fav. reflects defense attorney fees, $80,000, due to revised payment schedule,
offset by visiting judges, ($20,000). due to judges illness, appeal transcripts, ($13,000),
and personal mileage of court officers, ($4,000).
- Untev, in leased vehicles, ($7,000), radio communications, ($3,000), equipment
rental, ($4,000), offset by fay, in telephone communications, $3,000.
Salary and fringe lay. due to turnover.
• Fay. due to decreased use of professional contracts, $15,000, milage, $12,000,
student workers. $3,000, and supplies, $2,000.
- Fair. due to decreased print shop, $4,000, telephone and copier costs, $3,000,
COUNTY OF OAKLAND
1994 THIRD QUARTER FORECAST
EXPENDITURES
Probate Court
Department Total
Controllable Personnel
Controllable Operating
Non-Controllable Operating
BUDGET BUDGET AMOUNT
AS AS 1994 FAVORABLE
ADOPTED AMENDED FORECAST (UNFAVORABLE) PERCENT
54,425,070 $4,277,110 $4,188,110 589,000 2.08%
952,487 952,788 909,788 43,000 4,51%
648.675 688 387 700.387 (12,000) 0.00%
$6,026,232 55.918,285 $5,798,285 $120,000 2.03%
$6 $0 $0 0.00%
3,197,578 3,597,578 3,932,878 (335,000) -9.31%
0 0 0.00%
$3,197,576 53,597,576 53.932,576 ($335,000) -9.31%
$1,838,879 $1,458,740 $1,394,740 $82,000 4.28%
677,239 880,034 590,034 90,000 13.23%
273,740 289,238 296,238 (7,000) 0.00%
52,587,858 52,426,012 52,281,012 5145,000 5.98%
$716,859 $714,699 $700,899 314,000 1.98%
83,351 83,361 83,3151 0.00%
49,106 49,110 49,110 0.00%
5849,128 5847,170 $833,170 514,000 1.65%
$4,953,433 $4,721,857 $4,892,857 $29,000 0.61%
188,091 188,091 156,091 32,000 17.01%
214,768 214,912 207,912 7,000 3.26%
$5,366,292 $5,124,860 $5,056,860 $68,000 1.33%
511,742,041 311,170,406 $10,976,406 $194,000 1.74%
5,098,754 5,501,850 5,571,850 (170,000) -3.09%
1,188,291 1,241,647 1,253,647 (12,000) 0.00%
318.027,086 517,913,903 517.901,903 812,000 0.07%
Unfav. due to 10% increase in state care rate, ($243,000), private institution boot
camp committments Increased from 10 to 15, ($120,000), offset by fay. in foster care
institution cost, $20,000, and physicians care. 57.500.
Salary and fringe fav. reflects turnover.
Fav. reflects reduced guardian fees, $40,000, attorneys, 120.000, guardianship bea7ring
costs, $50,000, and medical reviews, 510,000, by using contractors and volunteers.
Unfav, reflects increased professionsal services, ($25,000), and postage, ($57:000).
Unfav. reflecti cost of automated attendant telephone, ($13,000), microfilm and
printing costs, ($7,000), offset by reduced demand for copier and stationery, $13,00 .0.
Salary and fringe fay.. $16,500, due to turnover offset by overtime, ($2,500).
Sheriffs Office
Controllable Personnel
Controllable Operating
Non-Controllable Operating
1514,863 $617.767 $820,667.00
$211,660 $211,650 $203,250
$1,061,714 $1,081,714 $1,227,214
($2,900) -0.47%
58,400 3.97%
(5145400) -13.45%
11.908,227 $1,911,131 $2.051,131 ($140,000) -7.33%
Adrninistrabve Services
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$977,503 $979,547 $970,547.00
$369,095 $372,831 $393,531
$453,143 1568,680 5529480
$9,000 0.92%
($21,000) -5.63%
339.000 6.86%
51,799,741 51,921,058 11,894,058 $27,000 1.41%
Corrective Services
Controllable Personnel
Controllable Operating
$14,849,924 $14,816,624 $15,001,124 mummy -1.25%
$2,625,000 $2,630,274 $3,002,974 (372,700) -14.17%
Non-Controllable Operating $6,649,060 $6,767,481 $6,810,281 (42,800) -0.63%
524,123,964 524,214,379 524,814,379 ($600,000) -2.48%
COUNTY OF OAKLAND
1994 THIRD QUARTER FORECAST
EXPENDITURES
Sheriffs Department
BUDGET
AS
ADOPTED
BUDGET AMOUNT
AS 1994 FAVORABLE
AMENDED FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Fay. turnover, $3,900, offset by unfav. overtime ($6,800) covering vacancies.
Fay professional services, $9,500, partially offset by increased expendable equipment
purchases. ($1,100).
Use of radio communications, ($85,000) and leased vehicles, ($60,500) consistent with
historical experience, adopted budget did not match historical expenditures.
- Fay. turnover, $20,000, offset by unfav. overtime ($11,000) covering vacancies.
- New Oakland Community College charge for police academy, ($17,000) as well as
increased postage use ($3,500),
- Fay, radio communications, $11,200, and leased vehicles, 59,000, reflecting historical
expenditures; as well as reduced use of stationery stock, $13,000 and reduced
equipment rental, $5,800, as equipment is returned.
Fav, turnover, $556,900, offset by additional overtime ($741,400) covering vacancies,
increased hospital watches, and jail overcrowding. A budget amendment coveting
the increased overtime by use of turnover fay. and additional revenue will be •
recommended.
Increased physician cost, ($113,700). and increased hospitalization of prisoners
($215,000), due several severe cases, partially offset by reduced medical expenses
$20,000. as cases are sent to the hospital increased out-County housing (45,000).
laundry (130.000) and dry goods ($20,000) due to jail crowding; reduced outside
outside provision cost, $31,000 reflecting increased use of materials management.
A budget amendment covering the anticipated shortfall with increased revenues
will be recommended.
Increased use of material management provisions, ($91,000), partially offset by
reductions in other material management purchases, $70,000; also use of leased
vehicles reflects historical pattern, ($21,000) as well as increased prisoner transport.
0.53%
14.77%
-2.04%
Corrective Services-Satellites
Controllable Personnel
Controllable Operating
Non-Controllable Operating
$6,203,645 $6,202,020
$71,150 $71,760
5547,165 $567,965
$6,169,020 $33,000
$61,160 10,600
$579,565 (11,600)
- Fay. turnover, 133.000.
- Fav. commodity expenditures due to more efficient purchasing practices-
- Fay. housekeeping purchases. $10,000, offset by radio communications usage
($21,600), reflecting historical pattern.
$6,621,960 36,841,745 $6,809,745 532,000 0.47%
EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
1994 THIRD QUARTER FORECAST
EXPENDITURES
Cleric/Register of Deeds
BUDGET BUDGET AMOUNT
AS AS 1994 FAVORABLE
ADOPTED AMENDED FORECAST (UNFAVORABLL) PERCENT
Administration
Controllable Personnel $298,941 $300,436 $300,436 0.00%
Controllable Operating 66,680 66,680 66,680 0.00%
Non-Controllable Operating 137,197 202,328 202,328 0.00%
$502,818 $569,444 $569,444 $0 0.00%
County Clerk
Controllable Personnel $2,001,295 $2,024,702 $2,018,442 $6,300 0.31% - Turnover fay. $31,300; Overtime unfav. due to increase in caseload activity.
Controllable Operating 12,700 303,230 232,434 74,804 23.35% - Court transcripts fay. $70,800 due to increase in caseload activity.
Non-Controllable Operating 1,228,876 996,460 1,038,760 (42,300) -4.25% - Equipment Rental unfav. (54,600) due to purchase of additional equipment; Stationery
Stock unfav. ($37,700) as budget reflects no appropriation for this account.
$3,242,871 $3,324,392 $3,289,592 634,800 1,05%
Elections
Controllable Personnel $274,448 $282,988 $287,988 ($5,000) -127% - Overtime unfav. due to special elections activity.
Controllable Operating 4,000 841,404 841,404 0.00%
Non-Controllable Operating 885,100 49,243 49,243 0.00%
$1,163,548 $1,173,635 $1,178,635 ($5,000) -0.43% .
Register of Deeds .
Controllable Personnel $1,122,621 $1,208,190 $1,252,190 ($44,000) -3.84% - Turnover fav. $21,140; Overtime unfov. ($66,049) due to increase in financing activity.
Controllable Operating 30,000 58,119 78,119 (20,000) -34.41% - Postage unfav, clue to increase in number of deeds. ..
Non-Controllable Operating 442,772 386,952 386,952 0.00%
$1,595,463 $1,653,261 $1,717,261 ($64,000) -3.87%
Jury Commission
Controllable Personnel $14,466 $14,455 $14,455 0.00%
Controllable Operating 41,232 45,732 (4,6001 -10.91% - Postage unfav. (53,000) and Print Shop unfav. (51500)due to increase in juror
Non-Controllable Operating 148,571 121,460 121,460 0.00% selection activity.
5163,037 5177,147 $181,647 ($4,500) -2.54%
Department Total
Controllable Personnel $3,711,841 $3,830,771 $3,873,471 ($42,700) -1.11%
Controllable Operating 113,380 1,310,665 1,284,365 46,300 3.53%
Non-Controllable Operating 2,842,516 1,756443 1,798,743 (42,300) -2.41%
$6,657,737 66,897,879 $6,936,579 ($38,700) -0.56%
Ii
COUNTY OF OAKLAND
1994 THIRD QUARTER FORECAST
EXPENDITURES
Board of Commissioners
BUDGET BUDGET AMOUNT
AS AS 1994 FAVORABLE
ADOPTED AMENDED FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel $1,496,832 $1,34005 $1,309,685 $35,200 2.62% . Fay. reflected previous vacancies.
Controllable Operating 500 654,527 639,527 15,000 2.29% - Fey, reflects decreased travel
Non-Controllable Operating 433.195 200,732 200.732 0 000%
$1,930,527 $2,200,144 $2,149,944 350,200 2.28%
Library Board
Controllable Personnel $593,346 $622,250 $578,250 $44,000 7.07% - Fay. reflects turnover, $45,600, increased overtime ($1 .000).
Controllable Operating 15,000 570,112 614,512 (44,400) -7.79% - Unfav. reflects purctune of new law books, ($55,000). Computer Research Fees
($11.100). and Library Addition Satellites 323.300.
Non-Ccntrollable Operating 808,929 258,597 256.597 0 0.00%
$1,417,275 31,448,959 11,449,359 ($400) -0,03%
Department Total
Controllable Personnel $2,090,178 $1,967.135 $1,867•935 579,200 4.03%
Controllable Operating 15,500 1324,639 1,254,039 (29,400) -2.40%
Non-Controllable Operating 1,242,124 457,329 457,329 0 0.00%
$3,347,602 $3,649,103 33.599,303 549.800 1.36%
COUNTY OF OAKLAND
1994 THIRD QUARTER FORECAST
EXPENDITURES
County Executive
I3UDGET BUDGET AMOUNT
AS AS 1994 FAVORABLE
ADOPTED AMENDED FORECAST {UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Administration
Controllable Personnel $1,164,417 $1,165,974 $1,166,974 0.00%
Controllable Operating 124,336 177,087 177,087 0.00%
Non-Controllable Operating 216,333 204,646 204,646 0.00%
$1,505,085 $1,648,707 $1,548,707 50 0.00%
Auditing
Controllable Personnel $486,626 $464,833 $484,833 0.00%
Controllable Operating 7,494 10,972 10,972 0.00%
Non-Controllable Operating 54,276 73,651 73,651 0.00%
$547,395 $549,456 $549,456 $0 000%
Corporation Counsel
Controllable Personnel $682,721 $693,804 5676,304 $17,500 2.52% - Turnover,
Controllable Operating 79,534 79,534 23,534 56,000 70.41% - Professional Services not utilized prior to filling of Corporation
Counsel position.
Non-Controllable Operating 104,125 106,529 106,529 0.00%
5866,360 5879,867 $806,367 573,500 8.35%
Department Total
Controllable Personnel $2,332,763 $2,325,611 $2,308,111 $17,500 0.75%
Controllable Operating 211,363 267,693 211,593 56,000 20.93%
Non-Controllable Operating 374,734 364,826 384,826 0 0.00%
52,918,860 52,978,030 52,904,530 573,500 2.47%
COUNTY OF OAKLAND
1994 THIRD QUARTER FORECAST
EXPENDITURES
Central Services
BUDGET BUDGET AMOUNT
AS AS 1994 FAVORABLE
ADOPTED AMENDED FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
n•n••n••-••• •n•-n•nn•n ...,,r•••••••
Administrative
Controllable Personnel $117,888 $117,582 $117,582 0.001
Controllable Operating 1,690 1,690 1,890 0.00%
Non-Controllable Operating 6,577 6,577 8.577 0.00%
8126.155 $125,849 $125,849 $0 0.00%
Support Services
Controllable Personnel $782,375 $758,288 $765,288 0.00%
Controllable Operating 27,287 27,287 27,287 0.00%
Non-Controllable Operating 1,529.986 1.634,826 1,634,828 0.00%
82,319,648 $2,428,401 $2,428,401 $0 0.00%
Department Total
Controllable Personnel $880,283 $1113,870 $883.870 0.00%
Controllable Operating 28,977 28,977 28,977 0.00%
Non-Controllable Operating 1,536563 1.641,403 1,641,403 0.00%
12,445,803 12554,249 $2,554,249
MIMIC 2 22=MM=
0.00%
COUNTY OF OAKLAND
1994 THIRD QUARTER FORECAST
EXPENDITURES
Personnel
t..
WW1 f BUDGET AMOUNT
AS AS 1994 FAVORABLE
ADOPTED AMENDED FORECAST (UNFAVORABLE) PERCENT
Administration
Controllable Personnel $115,062 $114,782 $114,782 0.00%
Controllable Operating 2091 2,091 2,091 0.00%
Non-Conrollable Operating 6,547 104,532 104,532 0.00%
$123,700 $221,405 5221,405 50 0.00%
EXPLANATION OF SIGNIFICANT VARIANCES
Human Resources
Controllable Personnel $1,292,762 $1,356,580 $1,335,960 $20,600 1..52% - Turnover.
Controllable Operating 222,508 222,588 205,588 17,000 7.84% - Fay. Employee Medical Exams and Recruitment Expense.
Non-Controllable 297,184 305,514 320,914 (12,400) -4.02% - Unfav. Print Shop costs due to greater demand for exam announcements.
51,812,534 $1,567,662 $1,862,462 525,200 1.33%
Employee Relations
Controllable Personnel $708,054 $702,267 5882,267 520,000 2.85% - Turnover.
Controllable Operating 529,484 529,484 529,484 0 0.00%
Non-Controllable Operating 88,282 88.282 92,482 (4,200) -4.76% - Untav. Telephone Communications and Convenience Copier.
51,325.820 $1,320,033 $1,304,233 $15,800 1.21%
Department Total
Controllable Personnel $2.115,878 $2,173,809 $2,133,009 $40,800 1.87%
Controllable Operating $754,183 $754,183 $737,163 $17,000 7.64%
Non-Controllable Operating 5392,013 $501,328 $517,928 (516,600) -3.31%
$3,252,054 $3.429,100 $3,355;100 $41,000 1.21%
COUNTY OF OAKLAND
1994 THIRD QUARTER FORECAST
EXPENDITURES
Human Services
BUDGET BUDGET AMOUNT
AS AS 1994 FAVORABLE
ADOPTED AMENDED FORECAST (UNFAVORABLE) PERCENT EXPLANATION OF SIGNIFICANT VARIANCES
Medical Examiner
Controllable Personnel $1,218,520 '$1,227,071 $1,227,071 0.00%
Controllable Operating 305,400 370,402 370,402 0.00%
Non-Controllable Operating 285,397 300,873 300,873 0.00%
$1,810,317 $1,898,346 $1,898,346 $0 0.00%
Department Total
Controllable Personnel
Controllable Operating
Mon-Controllable Operating
$44,149,987 $43,483,524 $41,208,528 $2,275,000 5.23%
98,970,253 102,738,144 102,532,144 204,000 0.20%
5,245,316 5,990,377 5,99D377 0 0.00%
$148,385,556 $152,210,049 $149,731,049 $2,479,000 1.63%
r-bM=Z WUXI
EXPLANATION OF SIGNIFICANT VARIANCES
COUNTY OF OAKLAND
1994 THIRD QUARTER FORECAST
EXPENDITURES
Informabon Technology
BUDGET BUDGET AMOUNT
AS AS 1994 FAVORABLE
ADOPTED AMENDED FORECAST (UNFAVORABLE PERCENT
Administration (10100)
Non-Controllable Expense $3,685,417 53,625,027 $3,375,027 $250,000 6.90% - Development favorable due to vacant posttions.
Division Total 63,685,417 $3,625.027 $3,375,027 5250,000 6.90%
Department Total $3,865,417 53,625,027 53,375,027 $250,000 6.90% =====.....3==
. .
' !Tr: 1"!""mi-7.401111111WIPS7)
($200,000) -66.67% - Rate increase (411194).
54
°4'
(5200,000) -2.04%
DC
COUNTY BUILDINGS $3,670,791 $3,072,240 53,072,240 0.00%
0.00% $400,000 $400,000 $400,000 SUNDRY
BUDGET BUDGET
AS AS
ADOPTED ADJUSTED
NON-DEPART. APPROPRIATIONS
AMOUNT
1994 FAVORABLE
FORECAST (UNFAVORABLE) PERCENT EXPLANATION
COUNTY OPERATIONS
State institutions/Juvenile Waivers $300,000 $300,000 $500,000
Project Work Orders 500,000 500,000
Capital Utilities 150,000 150,000 150,000
Liability inssance Fund 1,179 1,175
Building Authority 3,693,959 3,693,959 3,693,959 Ambulance 12,000 12,000 12,000
Insurance & Surety Bonds 98,000 98,000 98,000
Road Improvements 1,000,000 980,000 980,000
Tax Tribunal Appeals 2,000,000 1,778,813 1,778,613
CETA Audit 364,775 364,775 364,775
Current Drain Assessments 702,500 935,957 935,9.57 WTE Contract Termination 40,000 40,000
Future Space Requirements 1,158,920 965,320 965,320
$9,480,154 59.819,803 $10,019,803
COUNTY ASSOCIATIONS
S.E.IvI.0 0 G
Area Wide Water Duality
National Assoc of Counties
Michigan Assoc. of Counties
$375,000 $375,000 5347,002 27,998 7.47%
46,100 46,100 46,100 0.00%
12,800 12,800 12,800 0.00%
39,200 39,200 30,200 0.00%
5473,100 $473,100 5445,102 527,998 5.92%
RESERVED FOR TRANSFEFtS
Revenue Sharing Loss
Contingency
Salary Adjustment
Classification & Rate Change
Overtime
Summer Employment
Emergency Satanes
Fringe Benefit Adj.
Capital Outlay
Disability Insurance
Disability Reserve
CRIMP.
Office Automation
$2,249, 159 52,298,800 52,208,800
250,000 508,492 508,492
(2,201,047) (337,560) (337,560)
60,000 26,912 26,912
50,000 35,000 35,000
300,000 3 0
450,000 39,388 39,388
(99,973) 380,027 380,027
75,000 146,811 146,811
858,500 858,500 858,500
(858,500) (858,500) (858,500)
2,000,000 642,327 642,327 0.00%
:1/4%
$3,133,139 $3,740,197 13,740,197 50 0.00%
TOTAL NON-DEPT. APPROPRIATIONS $17,157,184 517,505,339 $17,677,341 (5172,002) -0.98%
Prepared by Budget Division 11115/94
M.R. # 94079 - 03/24/94
COMMUNITY AND ECONOMIC DEVELOPMENT /
DEVELOPMENT AND PLANNING - POSITION
RECLASSIFICATION
,
••
5,664.00 5,664.00
M.R. # 94096 - 04/14/94
CIRCUIT COURT - USE MEDIATION FUNDS FOR THE
PURCHASE OF FURNITURE 5,000.00 5,000.00
# 94092 - 04114194
COMMUNITY DEVELOPMENT - 1994 EMERGENCY
SHELTER GRANT ACCEPTANCE
M.R. #94101 - 04/14/94
COMMUNITY CORRECTIONS PLAN
MR. #94136 - 05/12194
COUNTY EXECUTIVE/CULTURAL AFFAIRS -
REGRANTING ACCEPTANCE
MR. #94083 - 05/12/94
MEDICAL EXAMINER - PURCHASE OF MASS
SPECTROMETER
M.R. #94120 - 05(12194
CLERK/REGISTER OF DEEDS - CREATION OF THREE (3)
POSITIONS
M.R. #94139 - 05112/94
HEALTH DIVISION - MOBIL HOME INSPECTION
AGREEMENT
M. R. #94049 - 03/10/94
HEALTH DIVISION - PREGNANCY PREVENTION GRANT
#94158 - 05/26/94
HEALTH DIVISION - IMMUNIZATION ACTION PLAN
M. R. #94119 - 05/26/94
COMMUNITY CORRECTION PLAN
M.R. #94
COMMUNITY DEVELOPMENT
KR. #94
COMMUNITY DEVELOPMENT HOME INVESTMENT
KR. #94166 - 05126194
AMENDMENT OF COMMUNITY CORRECTIONS PLAN
67,000.00 67,000.00
445,631.00 445,631.00
8,600.00 8,600.00
15,000.00 15,000.00
54,587.00 54,587.00
2,980.00 2,980,00
231,792.00 231,792.00
365,907.00 365,907.00
789,331.00 789,331.00
585,242.00 585,242.00
255,240.00 255,240.00
(445,631.00) (445,631.00)
V
V V
M.R. 094262 - 09/08/94 s
4 DRAIN COMMISSION-DEPT. REORG. AND CHANGE 44,579.00 44,579.00
OF SALARY FOR DRAIN COMMISSIONER
M.R. 094257 - 09/08/94
SUNDRY-SECOND QUARTER BUDGET AMENDMENTS 3,560.51 3,560.51
$337,602,726.41 $92,579,810.00 $430,182,536.41
NA8UDGETWORECASTINAMEND.WK4
I
•
r 10.
41.
Resolution #94344 December 8, 1994
Moved by McCulloch supported by Powers the resolution be adopted.
AYES: Moffitt, Newby, Oaks, Obrecht, Palmer, Pernick, Powers, Schmid,
Taub, Crake, Dingeldey, Douglas, Garfield, Gosling, Huntoon, Jensen, Johnson,
Kaczmar, Kingzett, Kramer, Law, McCulloch, McPherson, Miltner. (24)
NAYS: None. (0)
A sufficient majority having voted therefor, the resolution was adopted.
HERE E FOREGOING RESOLUTION
174kL Brooke Patteraotetounty Executive Date
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, Lynn D. Allen, 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 December 8, 1994 with the original
record thereof now remaining in my office.
t 1-0fiEG
In Testimony Whereof, I have hereunto set my hand and fixed the se
County of Oakland at Pontiac, Michigan this 8th day o ecemtur-
40(A,C1.0
D. Allen, County Clerk