General Fund Sub Fund -Measure Q
Revenues and Expenditure Summary
April 1, 2022 - June 30, 2022
Revenues Q1 Q2 Q3 Q4 YTD
07/01/21 $ 767,422.29 10/1/2021 $ 691,547.59 01/01/22 $ 691,954.52 4/1/2022 783,466.96 08/01/21 $ 724,065.42 11/1/2021 $ 562,552.15 02/01/22 $ 629,283.21 5/1/2022 770,340.50 09/01/21 $ 967,247.09 12/1/2021 $ 1,190,585.32 03/01/22 $ 1,141,075.36 6/1/2022 1,152,738.99 TOTAL REVENUE $ 2,458,734.80 $ 2,444,685.06 $ 2,462,313.09 2,706,546.45 $ 10,072,279.40 Q1 Q2 Q3 Q4 Year-to-Date
Expenditures Appropriation Expenditures Expenditures Expenditures Expenditures Description General Government - Transfers & Other
Benefits 72,648.00 72,647.02 - 72,647.02 Pension Unfunded Liability Cost Allocation $ 500,000.00 $ 124,999.97 $ 125,000.01 $ 125,000.01 $ 125,000.01 $ 500,000.00 Annual Cost Allocation $500K to General Fund Total $ 572,648.00 197,646.99 125,000.01 125,000.01 125,000.01 572,647.02 City Manager Division
Operations 1,800.00 - 1,796.65 - 1,796.65 HDL Measure Q Audit Total 1,800.00 - 1,796.65 1,796.65
General Government - IT Division
Salaries 52,467.00 10,044.91 14,275.02 10,263.95 13,872.54 48,456.42 1 IT Coordinator (Shared Position) Benefits 5,420.00 1,278.67 1,545.47 1,044.26 1,047.40 4,915.80 1 IT Coordinator (Shared Position) Operations 11,000.00 - - 7,125.81 2,412.48 9,538.29
Total 68,887.00 11,323.58 15,820.49 18,434.02 17,332.42 62,910.51 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,662,794.00 294,932.56 426,508.74 335,933.05 535,686.59 1,593,060.94 1 Police Officer Trainee 7 Police Officers
Benefits 281,227.00 139,650.09 33,026.74 30,232.54 33,801.90 236,711.27 Operations 596,050.00 57,071.54 85,921.65 57,099.71 259,048.73 459,141.63 Capital & Equipment - - -
Total 2,540,071.00 491,654.19 545,457.13 423,265.30 828,537.22 2,288,913.84 Police Dispatch Division
Salaries 307,314.00 65,407.61 74,222.99 57,545.50 103,387.05 300,563.15 3 Dispatchers Benefits 24,775.00 5,994.87 6,492.01 2,872.71 5,988.84 21,348.43 Operations - - -
Total 332,089.00 71,402.48 80,715.00 60,418.21 109,375.89 321,911.58 Police Administration Division
Salaries 60,349.00 12,537.14 16,736.27 12,768.40 16,822.44 58,864.25 1 Police Services Assistant Benefits 8,361.00 1,918.27 3,134.95 1,656.91 1,741.63 8,451.76 Total 68,710.00 14,455.41 19,871.22 14,425.31 18,564.07 67,316.01 General Fund Sub Fund -Measure Q
Revenues and Expenditure Summary
April 1, 2022 - June 30, 2022
Public Works - Streets Maintenance
Salaries 108,991.00 24,263.67 28,178.10 20,273.39 35,737.15 108,452.31 2 Public Services Assistant I Benefits 13,989.00 3,326.20 3,381.20 2,132.57 2,812.64 11,652.61 Operations 164,551.00 - - 34,700.27 108,830.71 143,530.98 Capital & Equipment 126,698.00 2,039.36 4,602.68 2,236.56 115,320.91 124,199.51 Total 414,229.00 29,629.23 36,161.98 59,342.79 262,701.41 387,835.41 Public Works
Capital & Equipment 47,100.00 - - - - - John Deere 210L Diesel Mower Total 47,100.00 - - - - -
Public Works - Fleet Maintenance
Salaries 78,567.00 16,296.29 21,985.45 16,883.53 23,011.38 78,176.65 1 Mechanic Benefits 8,795.00 2,253.92 2,677.64 1,825.16 3,717.37 10,474.09 Operations 10,000.00 122.15 432.28 6,244.83 1,720.28 8,519.54 Total 97,362.00 18,672.36 25,095.37 24,953.52 28,449.03 97,170.28 Community Development - Community Promotional Fund
Planned Community Promotions 32,200.00 - - 1,500.00 2,713.13 4,213.13 Downtown Xmas Lights 5,850.00 - 2,800.00 2,007.89 - 4,807.89 Mural Program - - - - -
4th of July Community Event 20,900.00 20,900.00 - - 269.04 21,169.04 Military Banners 3,500.00 - 1,542.33 - - 1,542.33
Community Promotional Fund (Unplanned) 2,500.00 - - - - - Senior/Youth Funds 50,000.00 2,877.50 8,646.12 13,203.56 12,772.82 37,500.00 Total 114,950.00 23,777.50 12,988.45 16,711.45 15,754.99 69,232.39 Parks & Recreation Division
IT Services 4,500.00 - - - 4,500.00 4,500.00
Capital & Equipment 62,792.00 - - 57,154.15 3,284.22 60,438.37 Total 67,292.00 - - 57,154.15 7,784.22 64,938.37
General Fund Sub Fund -Measure Q
Revenues and Expenditure Summary
April 1, 2022 - June 30, 2022
Barstow Fire Protection District - MQ Fund 102
Operations 167,203.00 - 83,601.48 - 83,601.48 167,202.96 Holman Capital Lease Payment - April 2021
• New Fire Engine
• KME Fire Engine Refurbishment
• Hydraulic Lift for Servicing Fire Apparatus
Transfer to Measure Q Fund 103 3,823,326.00 1,444,602.58 1,094,655.18 455,844.01 620,258.45 3,615,360.22 Total 3,990,529.00 1,444,602.58 1,178,256.66 455,844.01 703,859.93 3,782,563.18 Barstow Fire Protection District - MQ Fund 102
Transfer to Measure Q Fund 103 90,726.00 20,528.84 27,179.56 20,287.04 26,351.49 94,346.93 Total 90,726.00 20,528.84 27,179.56 20,287.04 26,351.49 94,346.93 TOTAL FUND 102 8,499,585.00 2,416,652.16 2,066,545.87 1,277,632.46 2,143,710.68 7,904,541.17 Barstow Fire Protection District - MQ Fund 103
Salaries 1,930,017.00 499,374.85 477,274.48 358,807.00 445,813.26 1,781,269.59 3 Battalion Chiefs, 6 FF/Paramedic Benefits 1,222,696.00 935,581.67 100,879.00 79,244.70 91,789.04 1,207,494.41 Operations 205,613.00 9,646.06 16,501.70 35,128.44 76,819.65 138,095.85 Transfer - 225 to 101 Fire Loan 500,000.00 - 500,000.00 - 500,000.00 Total 3,858,326.00 1,444,602.58 1,094,655.18 473,180.14 614,421.95 3,626,859.85 Barstow Fire Protection District Admin - MQ Fund 103
Salaries 85,254.00 17,992.33 23,468.02 18,254.22 24,329.28 84,043.85 1 Fire Inspector/Arson Investigator Benefits 10,272.00 1,655.54 2,904.32 3,721.01 2,022.21 10,303.08 Total 95,526.00 19,647.87 26,372.34 21,975.23 26,351.49 94,346.93 TOTAL FUND 103 3,953,852.00 1,464,250.45 1,121,027.52 495,155.37 640,773.44 3,721,206.78 GRAND TOTAL $ 12,453,437.00 $ 3,880,902.61 $ 3,187,573.39 $ 1,772,787.83 $ 2,784,484.12 $ 11,625,747.95
MEMORANDUM
TO: Honorable Mayor and City Council
FROM: Resident Oversight Commission
SUBJECT: Measure Q Fund Financial Report - Fiscal Year 2021-2022 – 4 th Quarter
DATE: September 28, 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 4th Quarter (April 1, 2022 – June 30, 2022) TOTAL REVENUES: $2,706,546.45
TOTAL EXPENDITURES: ($ 2,784,484.12)
EXCESS OF REVENUES OVER
EXPENDITURES:
($77,937.67)
See EXHIBIT A for breakdown of revenues and expenditures ____________________________________ _____________________ Kimberly Johnson, Chairperson Date
____________________________________ _____________________ Marc Puckett, Interim Finance Director Date