_ THE CITY OF
O BARSTOW
CROSSROADS OF OPPORTUNITY
MEMORANDUM
TO: Honorable Mayor and City Council
FROM: Resident Oversight Commission
SUBJECT: Measure Q Fund Financial Report - Fiscal Year 2021-2022 - 2nd Quarter DATE: March 17, 2022
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 • 25 Quarter (October 1, 2021 - December 31, 2021) TOTAL REVENUES: $2,444,685.06
TOTAL EXPENDITURES: ($3,114,936.12)
EXCESS OF REVENUES OVER ($670,251.06)
EXPENDITURES:
See EXHIBIT A for breakdown of revenues and expenditures Kimbee 1 ohnson. 3.17.2022
imberly Johnson, Chairperso Date
3-17-2022
Marc Puckett, Interim Finance Director Date
Measure Q Revenues and Expenditure Summary
October 1, 2021 - December 31, 2021
Revenues
10/1 - 10/31/2021 $ 691,547.59
11/1 - 11/30/2021
5 1,90,585.32
12/1 - 12/31/2021
TOTAL REVENUE $ 2,444,685.06
Q2 Year-to-Date
Expenditures Appropriation Expenditures Expenditures Description General Government - Transfers & Other
Benefits 70,021.00 72,647.02 Pension Unfunded Liability Cost Allocation $ 500,000.00 125,000.01 $ 249,999.98 Annual Cost Allocation $500K to General Fund Total S 570,021.00 125,000.01 322,647.00
City Manager Divisjon
Operations
Tetal
General Government - IT Division
Salaries 52,117.00 14,275.02 24,319.93 1 IT Coordinator (Shared Position) Benefits 5,070.00 1,545.47 2,824.14 1 IT Coordinator (Shared Position) Operations
Total 57,187.00 15,820.49 27,144.07
General Government - Insurance/Risk Mgmt Division
Operations 93,192.00 92,959.00 Annual Liability Insurance Premium Total 93,192.00 92,959.00
Police Uniform Division
Salaries 1,052,294.00 426,508.74 721,441.30 1 Police Officer Trainee 7 Police Officers
Benefits 230,032.00 33,026.74 172,676.83 1 Police Officer Trainee 7 Police Officers
Operations 637,145.00 85,921.65 142,993.19
Capital & Equipment
Total 1,919,471.00 545,457.13 1,037,111.32
Police Dispatch Division
Salaries 153,314.00 74,222.99 139,630.60 3 Dispatchers
Benefits 17,086.00 6,492.01 12,486.88 3 Dispatchers
Operations
Total 170,400.00 80,715.00 152,117.48
Police Administration Division
Salaries 58,674.00 16,736.27 29,273.41 1 Police Services Assistant Benefits 8,036.00 3,134.95 5,053.22 1 Police Services Assistant Total 66,710,00 19,871.22 34,326.63
Measure Q Revenues and Expenditure Summary
October 1, 2021 - December 31, 2021
Public Works - Streets Maintenance
Salaries 107,297.00 28,178.10 52,441.77 2 Public Services Assistant I Benefits 10,689.00 3,381.20 6,707.40 2 Public Services Assistant operations 165,000.00 4,602.68 6,642.04
Capital & Equipment 105,698.00
Total 388,684.00 36,161.98 65,791.21
Public Works
Capital & Equipment 47,100.00 John Deere 210L Diesel Mower Total 47,100.00
Public Works - Fleet Maintenance
Salaries 67,962.00 21,985.45 38,281.74 1 Mechanic
Benefits 7,945.00 2,677.64 4,931.56 1 Mechanic
Operations 10,000.00 432.28 554.43
Total 85,907.00 25,095.37 43,767.73
Community Development - Community Promotional Fund
Planned Community Promotions 32,200.00 -
Downtown Xmas Lights 6,750.00 2,800.00 2,800.00
Mural Program
4th of July Community Event 20,000.00 20,900.00
Military Banners 3,500.00 1,542.33 1,542.33
Community Promotional Fund (Unplanned) 2,500.00
Senior/Youth Funds 50,000.00 3,646.12 11,523.62
Total 114,950.00 12,988.45 36,765.95
Parks & Recreation Division
Capital & Equipment 62,792.00
Total 62,792.00 | :
Measure Q Revenues and Expenditure Summary
October 1, 2021 - December 31, 2021
Barstow Fire Protection District - MQ Fund 102
Holman Capital Lease Payment - April 2021
• New Fire Engine
Operations 167,203.00 83,601.48 83,601.48
• KME Fire Engine Refurbishment
• Hydraulic Lift for Servicing Fire Apparatus
Transfer to Measure Q Fund 103 3,316,463.00 1,022,017.91 2,466,620.49 Total 3,483,666.00 1,105,619.39 2,550,221.97
Barstow Fire Protection District - MQ Fund 102
Transfer to Measure Q Fund 103 85,601.00 27,179.56 47,708.40 Total 85,601.00 27,179.56 47,708.40
TOTAL FUND 102 7,145,681.00 1,993,908.60 4,410,560.76
Barstow Fire Protection District - MQ Fund 103
Salaries 1,371,017.00 477,274.48 976,649.33 3 Battalion Chiefs, 6 FF/Paramedic Benefits 1,299,196.00 100,879.00 1,036,460.67 3 Battalion Chiefs, 6 FF/Paramedic Operations 646,250.00 16,501.70 26,147.76
Transfer - 225 to 101 Fire Loan 500,000.00 500,000.00
Total 3,316,463.00 1,094,655.18 2,539,257.76
Barstow Fire Protection District Admin - MQ Fund 103
Salaries 76,204.00 23,468.02 41,460.35 1 Fire Inspector/Arson Investigator Benefits 9,397.00 2,904.32 4,559.86 • 1 Fire Inspector/Arson Investigator Total 85,601.00 26,372.34 46,020.21
TOTAL FUND 103 3,402,064.00 1,121,027.52 2,585,277.97
GRAND TOTAL $ 10,547,745.00 $ 3,114,936.12 $ 6,995,838.73