1 THE CITY OF
MEMORANDUM
TO: Honorable Mayor and City Council
FROM: Resident Oversight Commission
SUBJECT: Measure Q Fund Financial Report - Fiscal Year 2021-2022 - 15 Quarter DATE: December 16, 2021
The Resident Oversight Commission has reviewed all revenues and expenditures in accordance with Barstow Municipal Code Section 2.26.050 and reports the following:
Fiscal Year 2021-2022 • 1 Quarter (July 1, 2021 - September 30, 2021) TOTAL REVENUES: $2,458,734.80
TOTAL EXPENDITURES: ($ 2,408,163.70)
EXCESS OF REVENUES OVER $ 50,571.10
EXPENDITURES:
See EXHIBIT A for breakdown of revenues and expenditures Kimberl Votersm December 16, 2021
Kimberly Johnson, Chairperson Date
DECEMBER 20,2021
Marg Puckett, Interim Finance Director Date
EXHIBIT A Measure Q Revenues and Expenditure Summary
July 1, 2021 - September 30, 2021
Revenues
7/1 - 7/31/2021 $ 767,422.29
8/1 - 8/31/2021 724,065.42
9/1-9/30/2021 967,247.09
TOTAL 3 2951-227 00
Year-to-Date
Expenditures Appropriation Expenditures Expenditures Description General Govemment - Transfers & Other
Benefits 70,021.00 72,647.02 72,647.02 Pension Unfunded. Lability Cost Allocation 500,000.00 $ 124,999.97 $ 124,999.97 Annual Cost Allocation $500K to General Fund Total 570,021.00 197,646.99 197,646.99
City Manager Division
Operations
Total
General Government - IT Division
Salaries 52,117.00 10,044.91 10,044.91 1 IT Coordinator (Shared Position) Benefits 5,070.00 1,278.67 1,278.67 1 IT Coordinator (Shared Position Operations
Total 57,187.00 11,323.58 11,323.58
General Government - Insurance/Risk Mgmt Division
Operations 93,192.00 92,959.00 92,959.00 Annual Liability Insurance Premium Total 93,192.00 92,959.00 92,959.00
Police Uniform Division
Salaries 1,052,294.00 294,932.56 294,932.56 1 Police Officer Trainee 7 Police Officers
Benefits 230,032.00 139,650.09 139,650.09 1 Police Officer Trainee 7 Police Officers
Operations 504,372.00 57,071.54 57.071.54
Capital & Equipment
Total 1,786,698.00 491,654.19 491,654.19
Police Dispatch Division
Salaries 153,314.00 65,407.61 65,407.61 3 Dispatchers
Benefits 17,086.00 5,994.87 5,994.87 3 Dispatchers
Operations
Total 170,400.00 71,402.48 71,402.48
Police Administration Division
Salaries 58,674.00 12,537.14 12,537.14 1 Police Services Assistant Benefits 8,036.00 1,918.27 1,918.27 1 Police Services Assistant Total 66,710.00 14,455.41 14,455.41
Public Works - Streets Maintenance
Salaries 107,297.00 24,263.67 24,263.67 2 Public Services Assistant t Benefits 10,689.00 3,326.20 3,326.20 2 Public Services Assistant t Operations 165,000.00 2,039,36 2,039.36
Capital & Equipment 105,698.00
Total 388,684.00 29,629.23 29,629.23
EXHIB A Measure Q Revenues and Expenditure Summary
July 1, 2021 • September 30, 2021
Year-to-Date
Expenditures Appropriation Expenditures Expenditures Description Public Works
Capital & Equipment 47,100.00 John Deere 2101 Diesel Mower Total 47,100.00
Public Works - Fleet Maintenance
Salaries 67,962.00 16,296.29 16,296.29 1 Mechanic
Benefits 7,945.00 2,253.92 2,253.92 1 Mechanic
Operations 10,000.00 122.15 122.15
Total 85,907.00 18,672.36 18,672.36
Community Development - Community Promotional Fund
Planned Community Promotions 11,500.00
Downtown Xmas Lights 6,750.00
Mural Program
4th of July Community Event 20,000.00 20,900.00 20,900.00 Military Banners 3,500.00
Community Promotional Fund (Unplanned) 2,500.00
Senior/Youth Funds 50,000.00 2,397.50 2,397.50
Total 94,250.00 23,297.50 23,297.50
Parks & Recreation Division
Capital & Equipment
Total
Barstow Fire Protection District - MQ Fund 102
Holman Capital Lease Payment - April 2021
167,203.00 • New Fire Engine
Operations
• KME Fire Engine Refurbishment
• Hydraulic Lift for Servicing Fire Apparatus
Capital & Equipment
Transfer to Measure Q Fund 103 (see detail belaw)
3 Battalion Chiefs, 6 FF/Paramedic, Operations and
Salaries 1,371,017.00 499,374.85 499,374.85
Capital Equipment
3 Battalion Chiefs. 6 FF/Paramedic. Ooerations and
Benefits 1,299,196.00 927,573.21 927,573,21
Capital Equipment
Operations 646,250.00 9.646.06 1,436,594.12
Total Transfer to Measure Q Fund 103 3,316,463.00 1,436,594.12 1,436,594.12 Total 3,483,666.00 1,436.594.12 1,436,594.12
Barstow Fire Protection District Admin - MQ Fund 102
Benefits 880.97 880.97
Transfer to Measure Q Fund 103 (see detail below)
Salaries 76,204.00 499,374.85 499,374.85 1 Fire Inspector/Arson Investigator Benefits 9,397.00 927 573.21 927,573.21 1 Fire Inspector/Arson Investigator Transfer to Measure Q Fund 103 85.601.00 19,647.87 19 647.87 Total 85.601.00 20,528.84 20,528.84
GRAND TOTAL $ 6,929,416.00 2,408,163.70 $ 2,408,163.70
Measure Q Fund Balance
Beginning Balance $ 6,263,139.58
Q1 Revenues 2,458,734.80
Q1 Expenditures (2,408,163.70)
Q1 Ending Fund Balance 5. 6.313,710.68