Document Burley_doc_45c00b841b

City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 1 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget General Fund Taxes Property Taxes - General Fund 010-011-001-00001 2,280,510.98- 1,720,242.86- 2,432,771.00- 2,453,944.00- 21,173.00- Tax Penalty - Interest 010-011-001-00002 21,232.51- 15,377.97- 26,000.00- 24,000.00- 2,000.00 Override Property-Streets 010-011-001-00003 165,000.00- .00 165,000.00- .00 165,000.00 Highway Users Fund 010-011-001-00007 396,563.96- 302,984.94- 390,000.00- .00 390,000.00 Road/Brdg Tax County Hway Dist 010-011-001-00008 311,139.73- 202,899.75- 295,000.00- .00 295,000.00 2015 Gas & Reg. Tax HB312 010-011-001-00009 123,899.30- 91,920.83- 125,000.00- .00 125,000.00 One Time Street Revenue 2021 010-011-001-00010 118,764.87- .00 .00 .00 .00 Taxes Revenue Total: 3,417,111.35- 2,333,426.35- 3,433,771.00- 2,477,944.00- 955,827.00 Total Taxes: 3,417,111.35- 2,333,426.35- 3,433,771.00- 2,477,944.00- 955,827.00 Gas Franchise 010-011-003-00001 83,364.82- 81,461.74- 90,000.00- 90,000.00- .00 Cable TV Franchise 010-011-003-00002 55,458.75- 29,962.04- 55,000.00- 55,000.00- .00 Electrical Franchise Fee 010-011-003-00003 64,627.93- 81,125.46- 100,000.00- 125,000.00- 25,000.00- Franchise Fees Revenue Total: 203,451.50- 192,549.24- 245,000.00- 270,000.00- 25,000.00- Total Franchise Fees: 203,451.50- 192,549.24- 245,000.00- 270,000.00- 25,000.00- Beer License 010-011-005-00001 5,465.00- 560.00- 5,500.00- 5,500.00- .00 Liquor License 010-011-005-00002 8,342.50- 2,715.00- 7,000.00- 7,000.00- .00 Other Business License 010-011-005-00003 2,475.00- 2,303.00- 2,300.00- 2,300.00- .00 Building Permits 010-011-005-00004 252,403.42- 255,719.42- 85,000.00- 85,000.00- .00 Sign Licenses 010-011-005-00005 5,684.70- 4,595.45- 2,800.00- 2,800.00- .00 Animal License 010-011-005-00006 5,030.00- 4,455.00- 6,000.00- 6,000.00- .00 Amimal Control Pound 010-011-005-00007 2,031.75- 890.00- 2,200.00- 2,200.00- .00 County Animal Control 010-011-005-00009 10,300.00- 10,300.00- 10,300.00- 10,300.00- .00 Electrical Permits 010-011-005-00010 40,346.33- 33,712.02- 25,000.00- 25,000.00- .00 Plumbing Permits 010-011-005-00011 34,032.24- 35,379.26- 15,000.00- 15,000.00- .00 HVAC Permits 010-011-005-00012 36,280.05- 28,546.94- 18,000.00- 18,000.00- .00 Licenses & Permits Revenue Total: 402,390.99- 379,176.09- 179,100.00- 179,100.00- .00 Total Licenses & Permits: 402,390.99- 379,176.09- 179,100.00- 179,100.00- .00 Federal Grants 010-011-007-00001 1,138,073.39- 1,138,073.39- 1,138,073.00- .00 1,138,073.00 Source: 007 Revenue Total: 1,138,073.39- 1,138,073.39- 1,138,073.00- .00 1,138,073.00 Total Source: 007: 1,138,073.39- 1,138,073.39- 1,138,073.00- .00 1,138,073.00 State Liquor Fund 010-011-010-00001 203,437.00- 159,896.00- 175,000.00- 205,000.00- 30,000.00- State Revenue Share 010-011-010-00004 1,060,675.12- 952,140.85- 1,085,000.00- 1,210,000.00- 125,000.00- State Revenues Revenue Total: 1,264,112.12- 1,112,036.85- 1,260,000.00- 1,415,000.00- 155,000.00- Total State Revenues: 1,264,112.12- 1,112,036.85- 1,260,000.00- 1,415,000.00- 155,000.00- Administrative Services Charge 010-011-020-00001 951,206.00- 603,724.50- 979,965.00- 979,965.00- .00 Franchise 010-011-020-00002 347,400.00- 260,550.00- 347,375.00- 347,375.00- .00 Legal Service 010-011-020-00003 138,375.00- 103,781.25- 138,375.00- 138,375.00- .00 Water Admin Charge 010-011-020-00004 120,000.00- 90,000.00- 120,000.00- 120,000.00- .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 2 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Sewer Admin Charge 010-011-020-00005 135,000.00- 101,250.00- 145,000.00- 145,000.00- .00 Rent-Departmental 010-011-020-00006 .00 .00 45,000.00- 45,000.00- .00 Engineering Charges 010-011-020-00007 36,635.00- 6,426.00- 100,000.00- 100,000.00- .00 Shop Charges 010-011-020-00008 44,000.00- .00 50,000.00- 50,000.00- .00 Other Misc Revenue 010-011-020-00009 46,628.81- 18,164.45- 15,000.00- 15,000.00- .00 Interest Earned 010-011-020-00012 8,496.75- 5,892.08- 15,000.00- 15,000.00- .00 Derek Larsen Farm Lease 010-011-020-00013 24,963.60- 63,085.00- 27,600.00- 27,600.00- .00 Library Administration 010-011-020-00014 3,499.92- 2,624.94- 3,500.00- 3,500.00- .00 Late Charges 010-011-020-00020 86,011.06- 66,481.71- 86,000.00- 86,000.00- .00 Airport Farm Rent 010-011-020-00022 10,625.00- 5,313.00- 11,000.00- 11,000.00- .00 Sanitation Administration 010-011-020-00024 24,999.96- 18,749.97- 25,000.00- 25,000.00- .00 Golf Administration Fee 010-011-020-00025 2,499.84- 1,874.88- 2,500.00- 2,500.00- .00 Sanitation Road Use & Shop 010-011-020-00026 45,000.00- .00 45,000.00- 45,000.00- .00 AMERICAN TOWER LEASE 010-011-020-00028 23,482.83- 16,024.90- 19,000.00- 19,000.00- .00 Bear Necessities 010-011-020-00029 6,000.00- 4,500.00- 6,000.00- 6,000.00- .00 Cassia School Land Lease 010-011-020-00030 500.00- 500.00- .00 500.00- 500.00- Industrial Park Rents & Leases 010-011-020-00100 79,835.52- 87,174.60- 100,000.00- 100,000.00- .00 Kodiak Rent 010-011-020-00101 29,111.75- 16,795.83- 16,800.00- 22,516.00- 5,716.00- Bridger Wireless Inc. 010-011-020-00110 25,035.24- 19,031.76- 18,422.00- 18,422.00- .00 Charges For Services Revenue Total: 2,189,306.28- 1,491,944.87- 2,316,537.00- 2,322,753.00- 6,216.00- Total Charges For Services: 2,189,306.28- 1,491,944.87- 2,316,537.00- 2,322,753.00- 6,216.00- Special Fire 010-011-025-00001 217,810.79- 152,253.00- 203,000.00- 205,275.00- 2,275.00- Hazmat Reimbursement 010-011-025-00002 456.93- .00 .00 .00 .00 Reimbursements for Fire Dept. 010-011-025-00003 .00 .00 .00 .00 .00 Special Charges For Services Revenue Total: 218,267.72- 152,253.00- 203,000.00- 205,275.00- 2,275.00- Total Special Charges For Services: 218,267.72- 152,253.00- 203,000.00- 205,275.00- 2,275.00- Swim Revenue 010-011-035-00002 82,270.14- 45,011.92- 68,000.00- 68,000.00- .00 Park Revenue 010-011-035-00003 10,389.74- 6,719.69- 8,800.00- 8,800.00- .00 RV Park Revenue 010-011-035-00004 42,455.20- 18,249.44- 22,000.00- 22,000.00- .00 Swim Reimbursment 010-011-035-00005 950.00- .00 .00 .00 .00 Reimbursement-Revenue Exit 208 010-011-035-00006 6,813.72- 6,867.64- 9,000.00- 9,000.00- .00 Swim Items For Resale 010-011-035-00085 9,796.95- 3,462.90- 11,500.00- 11,500.00- .00 Parks, Rec & Swim Revenue Revenue Total: 152,675.75- 80,311.59- 119,300.00- 119,300.00- .00 Total Parks, Rec & Swim Revenue: 152,675.75- 80,311.59- 119,300.00- 119,300.00- .00 Cemetery Lot Sales 010-011-040-00001 76,465.00- 49,425.00- 45,000.00- 45,000.00- .00 Cemetery Grave - Fees 010-011-040-00002 40,045.00- 40,900.00- 36,000.00- 42,000.00- 6,000.00- Cemetery Other Fees 010-011-040-00003 .00 2,130.00- 1,800.00- 1,800.00- .00 Cemetery Revenue Revenue Total: 116,510.00- 92,455.00- 82,800.00- 88,800.00- 6,000.00- Total Cemetery Revenue: 116,510.00- 92,455.00- 82,800.00- 88,800.00- 6,000.00- Fines & Forfieture Revenue 010-011-045-00001 71,510.62- 55,096.28- 68,000.00- 68,000.00- .00 Fines & Forfieture Revenue Revenue Total: 71,510.62- 55,096.28- 68,000.00- 68,000.00- .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 3 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Total Fines & Forfieture Revenue: 71,510.62- 55,096.28- 68,000.00- 68,000.00- .00 Airport Rents and Leases 010-011-060-00006 13,915.91- 11,622.22- 13,500.00- 13,500.00- .00 Airport Federal Revenue 010-011-060-00080 .00 30,000.00- .00 .00 .00 Airport Revenue Revenue Total: 13,915.91- 41,622.22- 13,500.00- 13,500.00- .00 Total Airport Revenue: 13,915.91- 41,622.22- 13,500.00- 13,500.00- .00 Sale Of Fixed Assets 010-011-070-00001 7,830.00- 19,890.00- 15,000.00- 15,000.00- .00 Sale Of Fixed Assets Revenue Revenue Total: 7,830.00- 19,890.00- 15,000.00- 15,000.00- .00 Total Sale Of Fixed Assets Revenue: 7,830.00- 19,890.00- 15,000.00- 15,000.00- .00 Transfer In 010-011-080-00008 .00 .00 .00 .00 .00 From Fund Balance 010-011-080-00010 .00 .00 200,000.00- 45,000.00- 155,000.00 Loan Proceeds 010-011-080-00090 274,868.00- .00 .00 .00 .00 Transfers & Other Revenue Revenue Total: 274,868.00- .00 200,000.00- 45,000.00- 155,000.00 Total Transfers & Other Revenue: 274,868.00- .00 200,000.00- 45,000.00- 155,000.00 Total Taxes: 9,470,023.63- 7,088,834.88- 9,274,081.00- 7,219,672.00- 2,054,409.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 4 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Legislative-City Council Regular Salaries 010-110-501-00001 28,800.72 21,046.67 28,800.00 28,800.00 .00 Fica 010-110-502-00021 2,125.05 1,593.82 2,205.00 2,205.00 .00 Retirement 010-110-502-00022 2,865.20 2,380.33 3,439.00 3,439.00 .00 Workman’s Comp 010-110-502-00024 36.92 28.86 42.00 42.00 .00 Health Insurance 010-110-505-00025 82,782.53 43,682.94 70,243.00 60,000.00 10,243.00- Life Insurance Amount 010-110-505-00026 310.07 143.13 310.00 250.00 60.00- Postage 010-110-520-00030 3,962.62 .00 300.00 300.00 .00 Office Supplies 010-110-520-00031 1,738.39 4,657.37 1,900.00 1,900.00 .00 Public Relations 010-110-522-00041 24,944.58 23,964.39 25,000.00 25,000.00 .00 Advertising 010-110-522-00044 5,415.37 2,458.37 3,500.00 3,500.00 .00 BAAT Flower Project 010-110-522-00045 32.02 43,631.15 20,000.00 20,000.00 .00 Liability & Property Ins 010-110-523-00046 8,758.00 8,758.00 8,758.00 8,758.00 .00 Travel & Meetings 010-110-524-00047 3,710.83 1,022.88 13,200.00 13,200.00 .00 Membership 010-110-524-00048 14,186.80 2,250.00 16,390.00 16,390.00 .00 Professional Service 010-110-525-00042 18,678.49 16,331.96 15,000.00 15,000.00 .00 City Code Updates 010-110-525-00043 .00 .00 7,000.00 7,000.00 .00 Network and Automation Support 010-110-525-00045 2,600.00 2,800.00 2,800.00 2,800.00 .00 Weed Eradication 010-110-525-00066 .00 .00 .00 .00 .00 Street Lights-United Electric 010-110-526-00052 3,038.02 2,174.34 3,000.00 3,000.00 .00 Building Maintenance 010-110-528-00060 646.86 .00 .00 .00 .00 Interfund Transfers 010-110-530-00068 162,089.00 75,000.00 150,000.00 150,000.00 .00 Miscellaneous 010-110-530-00999 2,363.65 234.51 2,500.00 2,500.00 .00 Property Taxes/Assessments 010-110-540-00010 11,524.36 16,070.96 5,200.00 5,200.00 .00 Simplot Industrial Park 010-110-560-00100 2,956.67 2,744.84 4,200.00 4,200.00 .00 Contingency 010-110-590-00099 3,594.00 692.00 130,000.00 130,000.00 .00 Total Legislative-City Council: 387,160.15 271,666.52 513,787.00 503,484.00 10,303.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 5 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Executive Regular Salaries 010-130-501-00001 14,834.68 10,176.59 15,000.00 15,000.00 .00 Fica 010-130-502-00021 1,147.64 838.66 1,148.00 1,148.00 .00 Retirement 010-130-502-00022 1,790.88 1,308.72 1,749.00 1,749.00 .00 Workman’s Comp 010-130-502-00024 21.06 15.39 22.00 22.00 .00 Health Insurance 010-130-505-00025 7,545.84 1,077.64 8,630.00 8,630.00 .00 Life Insurance Amount 010-130-505-00026 .00 .00 52.00 52.00 .00 Postage 010-130-520-00030 .00 .00 50.00 50.00 .00 Office Supplies 010-130-520-00031 .00 .00 50.00 50.00 .00 Operating Supplies 010-130-520-00032 .00 .00 300.00 300.00 .00 Minor Equipment 010-130-521-00034 .00 .00 .00 .00 .00 Public Relations 010-130-522-00041 75.00 250.00 1,000.00 1,000.00 .00 Liability & Property Ins 010-130-523-00046 1,460.00 1,460.00 1,460.00 1,460.00 .00 Travel & Meetings 010-130-524-00047 .00 .00 2,500.00 2,500.00 .00 Membership 010-130-524-00048 50.00 .00 50.00 50.00 .00 Network and Software Support 010-130-525-00045 1,500.00 1,500.00 1,500.00 1,500.00 .00 Telephone 010-130-526-00051 186.00 139.50 2,200.00 2,200.00 .00 Total Executive: 28,611.10 16,766.50 35,711.00 35,711.00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 6 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Administrative Regular Salaries 010-150-501-00001 533,003.49 375,919.98 540,696.00 554,606.00 13,910.00 Part Time Salaries 010-150-501-00002 .00 .00 .00 .00 .00 Overtime Salaries 010-150-501-00005 .00 .00 .00 .00 .00 Fica 010-150-502-00021 40,483.16 29,649.73 41,363.00 42,427.00 1,064.00 Retirement 010-150-502-00022 63,971.11 46,148.91 64,559.00 66,220.00 1,661.00 Workman’s Comp 010-150-502-00024 3,147.41 2,317.81 3,120.00 3,380.00 260.00 Health Insurance 010-150-505-00025 152,432.40 90,345.40 157,750.00 157,750.00 .00 Life Insurance Amount 010-150-505-00026 356.02 187.17 245.00 245.00 .00 Postage 010-150-520-00030 35,137.37 22,323.61 43,000.00 43,000.00 .00 Office Supplies 010-150-520-00031 4,058.22 1,406.89 2,000.00 2,000.00 .00 Operating Supplies 010-150-520-00032 5,252.92 165.34 3,000.00 3,000.00 .00 Maint Office Equip 010-150-520-00058 4,221.15 703.77 3,000.00 3,000.00 .00 Minor Equipment 010-150-521-00034 3,636.00 1,059.16 1,000.00 1,000.00 .00 Public Relations 010-150-522-00041 50.00 .00 200.00 200.00 .00 Advertising 010-150-522-00044 .00 .00 350.00 350.00 .00 Printing 010-150-522-00045 144.54 225.43 2,000.00 2,000.00 .00 Liability & Property Ins 010-150-523-00046 11,678.00 11,678.00 11,678.00 11,678.00 .00 Travel & Meetings 010-150-524-00047 8,542.51 8,429.75 13,000.00 13,000.00 .00 Membership 010-150-524-00048 3,416.66 7,612.09 3,000.00 3,500.00 500.00 Personnel Training 010-150-524-00049 795.00 .00 600.00 600.00 .00 Local Transport 010-150-524-00053 6,051.00 4,500.00 6,000.00 6,000.00 .00 Temps Contracted Services 010-150-525-00036 .00 .00 .00 .00 .00 Professional Service 010-150-525-00042 7,818.91 647.25 2,500.00 2,500.00 .00 Network and Software Support 010-150-525-00045 11,500.00 12,081.00 12,081.00 12,081.00 .00 Cleaning Service 010-150-525-00050 7,261.47 4,739.69 9,000.00 9,000.00 .00 Software Maint and Support 010-150-525-00063 14,816.94 16,177.50 23,000.00 23,000.00 .00 Contracted Service 010-150-525-00067 3,197.30 1,309.36 5,000.00 5,000.00 .00 Telephone 010-150-526-00051 2,631.56 3,136.46 3,900.00 3,900.00 .00 Rental Bldg 010-150-527-00055 .00 .00 .00 .00 .00 Rental Other 010-150-527-00057 .00 .00 1,000.00 1,000.00 .00 Maint Grounds 010-150-528-00059 .00 .00 1,800.00 1,800.00 .00 Maint Bldg 010-150-528-00060 6,489.50 3,364.95 5,000.00 5,000.00 .00 Fuel & Oil 010-150-529-00035 .00 73.41 .00 .00 .00 Bad Debt 010-150-530-00066 .00 .00 1,000.00 1,000.00 .00 Interfund Transfers 010-150-530-00068 .00 .00 .00 .00 .00 Cash Long Or Short 010-150-530-00099 .00 100.71 200.00 200.00 .00 Election Costs 010-150-532-00001 .00 .00 .00 .00 .00 Office Equipment 010-150-580-00074 27.99 1,400.72 3,000.00 3,000.00 .00 Other Improvements 010-150-584-00073 2,793.08 1,804.16 .00 .00 .00 Land Acqusition 010-150-584-00078 .00 .00 .00 .00 .00 Construction 010-150-584-00079 .00 .00 .00 .00 .00 Salary Increase 2020-2021 010-150-590-00001 .00 .00 84,700.00 90,392.00 5,692.00 Total Administrative: 932,913.71 647,508.25 1,048,742.00 1,071,829.00 23,087.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 7 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Legal Services Regular Salaries 010-170-501-00001 47,127.88 32,329.83 .00 .00 .00 Part Time Salaries 010-170-501-00002 .00 .00 .00 .00 .00 Overtime Salaries 010-170-501-00005 .00 .00 .00 .00 .00 Oncall/Callback Salaries 010-170-501-00010 .00 .00 .00 .00 .00 Fica 010-170-502-00021 3,645.46 2,663.99 4,044.00 4,044.00 .00 Retirement 010-170-502-00022 5,689.84 4,157.96 6,311.00 6,311.00 .00 Fire Retirement Other 010-170-502-00023 .00 .00 .00 .00 .00 Workman’s Comp 010-170-502-00024 93.07 66.12 130.00 130.00 .00 Health Insurance 010-170-505-00025 66,741.60 49,280.80 56,880.00 56,880.00 .00 Life Insurance Amount 010-170-505-00026 50.86 29.36 52.00 52.00 .00 Postage 010-170-520-00030 .00 .00 .00 .00 .00 Operating Supplies 010-170-520-00032 .00 .00 .00 .00 .00 Advertising 010-170-522-00044 .00 .00 .00 .00 .00 Printing 010-170-522-00045 .00 .00 .00 .00 .00 Travel & Meetings 010-170-524-00047 .00 .00 400.00 400.00 .00 Membership 010-170-524-00048 75.00 .00 115.00 115.00 .00 Legal Retainer Services 010-170-525-00041 .00 .00 54,472.00 59,327.00 4,855.00 Prosecution Services 010-170-525-00042 68,712.78 52,450.83 73,774.00 74,960.00 1,186.00 Contracted Service 010-170-525-00067 823.59 2,698.59 .00 .00 .00 Telephone 010-170-526-00051 .00 .00 .00 .00 .00 Law Library 010-170-530-00069 .00 .00 .00 .00 .00 Total Legal Services: 192,960.08 143,677.48 196,178.00 202,219.00 6,041.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 8 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Building Inspection & Maint. Regular Salaries 010-190-501-00001 175,268.05 111,254.57 190,320.00 198,432.00 8,112.00 Part Time Salaries 010-190-501-00002 2,295.00 11,200.00 8,515.00 15,180.00 6,665.00 Overtime Salaries 010-190-501-00005 .00 .00 .00 .00 .00 Oncall/Callback Salaries 010-190-501-00010 .00 .00 .00 .00 .00 Fica 010-190-502-00021 13,896.80 11,620.36 15,214.00 16,341.00 1,127.00 Retirement 010-190-502-00022 20,717.06 16,939.56 22,724.00 23,693.00 969.00 Workman’s Comp 010-190-502-00024 7,491.95 5,392.17 7,079.00 7,582.00 503.00 Health Insurance 010-190-505-00025 56,328.80 29,693.60 59,157.00 59,157.00 .00 Life Insurance Amount 010-190-505-00026 152.58 88.08 150.00 135.00 15.00- Uniform Allowance 010-190-505-00027 172.93 .00 500.00 500.00 .00 Postage 010-190-520-00030 .00 .00 300.00 100.00 200.00- Office Supplies 010-190-520-00031 .00 27.33 250.00 250.00 .00 Operating Supplies 010-190-520-00032 1,066.02 602.42 600.00 800.00 200.00 Maint Office Equip 010-190-520-00058 .00 .00 100.00 100.00 .00 Minor Equipment 010-190-521-00034 92.99 .00 1,500.00 1,000.00 500.00- Liability & Property Ins 010-190-523-00046 4,379.00 4,400.00 4,400.00 4,400.00 .00 Travel & Meetings 010-190-524-00047 .00 .00 3,000.00 3,600.00 600.00 Membership 010-190-524-00048 240.00 .00 500.00 500.00 .00 Personnel Training 010-190-524-00049 285.00 .00 2,000.00 2,000.00 .00 Local Transport 010-190-524-00053 .00 .00 .00 .00 .00 Temps Contracted Service 010-190-525-00036 4,028.05 42.84 12,000.00 8,000.00 4,000.00- Professional Service 010-190-525-00042 2,105.26 270.73 500.00 .00 500.00- Network and Software Support 010-190-525-00045 2,775.00 3,494.75 3,470.00 3,500.00 30.00 Telephone 010-190-526-00051 2,203.66 1,257.93 1,000.00 1,000.00 .00 Rental Other 010-190-527-00057 .00 .00 300.00 300.00 .00 Maint Grounds 010-190-528-00059 96.00 96.00 400.00 400.00 .00 Maint Bldg 010-190-528-00060 .00 61.64 400.00 400.00 .00 Fuel & Oil 010-190-529-00035 3,023.00 2,603.17 4,000.00 6,000.00 2,000.00 Maint Automotive 010-190-529-00061 912.04 287.33 1,500.00 1,500.00 .00 Maint Other Equipment 010-190-529-00062 .00 .00 600.00 600.00 .00 Bank Service Charge 010-190-530-00065 .00 .00 .00 .00 .00 Automotive 010-190-580-00075 .00 .00 .00 .00 .00 Other Machinery 010-190-580-00076 .00 .00 .00 .00 .00 Other Improvements 010-190-584-00073 .00 .00 .00 .00 .00 Construction 010-190-584-00079 .00 .00 .00 .00 .00 Total Building Inspection & Maint.: 297,529.19 199,332.48 340,479.00 355,470.00 14,991.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 9 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Police Services Contracted Service 010-210-525-00067 1,778,285.76 1,426,122.00 1,901,495.00 1,941,495.00 40,000.00 Total Police Services: 1,778,285.76 1,426,122.00 1,901,495.00 1,941,495.00 40,000.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 10 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Fire Regular Salaries 010-230-501-00001 599,761.53 514,224.51 660,044.00 656,232.00 3,812.00- Reserve FF Wages 010-230-501-00002 35,513.00 23,694.00 38,000.00 38,000.00 .00 Overtime Salaries 010-230-501-00005 35,609.87 21,271.73 40,000.00 40,000.00 .00 FT Call Back 010-230-501-00010 26,482.62 19,306.94 23,000.00 23,000.00 .00 FT-Volunteer Training 010-230-501-00015 6,486.99 5,144.13 9,500.00 12,735.00 3,235.00 Fica 010-230-502-00021 11,215.61 9,098.15 18,040.00 15,750.00 2,290.00- Retirement - 401K 010-230-502-00022 .00 .00 37,000.00 43,154.00 6,154.00 Fire Retirement Other 010-230-502-00023 81,099.29 68,567.31 91,016.00 82,283.00 8,733.00- Workman’s Comp 010-230-502-00024 29,124.36 24,806.02 27,380.00 34,550.00 7,170.00 Health Insurance 010-230-505-00025 203,654.00 137,606.90 209,318.00 209,318.00 .00 Life Insurance Amount 010-230-505-00026 504.93 286.26 490.00 490.00 .00 Uniform Allowance 010-230-505-00027 4,235.37 2,194.56 4,300.00 4,900.00 600.00 Postage 010-230-520-00030 44.93 .00 150.00 150.00 .00 Office Supplies 010-230-520-00031 713.80 217.75 1,000.00 1,000.00 .00 Operating Supplies 010-230-520-00032 2,967.19 1,777.83 2,500.00 2,500.00 .00 Maint Office Equip 010-230-520-00058 20.10 76.42 500.00 1,000.00 500.00 Minor Equipment 010-230-521-00034 234.17 1,043.94 3,500.00 3,500.00 .00 Advertising 010-230-522-00044 137.03 .00 300.00 300.00 .00 Printing 010-230-522-00045 1,131.57 1,776.75 1,500.00 1,500.00 .00 Liability & Property Ins 010-230-523-00046 14,597.00 14,597.00 14,597.00 14,597.00 .00 Travel & Meetings 010-230-524-00047 2,760.10 1,259.62 3,500.00 3,500.00 .00 Membership 010-230-524-00048 5,616.53 8,713.46 10,500.00 11,000.00 500.00 Personnel Training 010-230-524-00049 8,161.06 3,934.71 15,000.00 15,000.00 .00 Wellness and Fitness 010-230-524-00050 440.54 163.95 500.00 500.00 .00 Professional Service 010-230-525-00042 5,819.98 5,435.16 9,500.00 9,500.00 .00 Cost of Assist to Others 010-230-525-00043 .00 .00 .00 .00 .00 Network and Software Support 010-230-525-00045 12,001.30 11,486.00 11,486.00 12,000.00 514.00 Telephone 010-230-526-00051 5,179.35 3,837.19 4,000.00 4,000.00 .00 Maint Grounds 010-230-528-00059 832.05 361.06 1,000.00 1,000.00 .00 Maint Bldg 010-230-528-00060 2,218.46 6,272.95 4,000.00 4,000.00 .00 Fuel & Oil 010-230-529-00035 14,349.26 12,382.76 10,000.00 10,000.00 .00 Maint Automotive 010-230-529-00061 21,119.95 30,019.90 18,000.00 20,000.00 2,000.00 Personal Protective Equipment 010-230-529-00062 18,846.94 9,896.10 20,000.00 20,000.00 .00 Hazmat Materials 010-230-530-00100 396.50 .00 400.00 400.00 .00 EMS Supplies 010-230-530-00200 2,576.71- 6,776.38 2,500.00 3,000.00 500.00 Extrication Tools & Equipment 010-230-580-00011 600.00 1,137.50 1,000.00 1,200.00 200.00 Office Equipment 010-230-580-00074 47.57 1,907.87 2,000.00 3,000.00 1,000.00 Automotive 010-230-580-00075 .00 .00 .00 .00 .00 SCBA Maintenance 010-230-580-00076 4,734.69 1,925.05 3,000.00 3,000.00 .00 Other Improvements 010-230-584-00073 2,750.00 .00 .00 .00 .00 Construction 010-230-584-00079 274,867.61 .00 .00 .00 .00 Other Improvements-ISO 010-230-584-00100 7,801.11 849.79 5,000.00 50,000.00 45,000.00 Debt & Lease Payments 010-230-590-00001 106,180.43 139,630.11 166,862.00 166,862.00 .00 Total Fire: 1,545,680.08 1,091,679.76 1,470,383.00 1,522,921.00 52,538.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 11 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Animal Control Regular Salaries 010-270-501-00001 58,670.91 25,266.14 37,440.00 40,560.00 3,120.00 Part Time Salaries 010-270-501-00002 .00 .00 .00 .00 .00 Overtime Salaries 010-270-501-00005 .00 .00 .00 .00 .00 Oncall/Callback Salaries 010-270-501-00010 .00 .00 2,000.00 2,000.00 .00 Fica 010-270-502-00021 4,533.62 2,148.07 2,864.00 3,103.00 239.00 Retirement 010-270-502-00022 7,007.63 3,395.78 4,470.00 4,845.00 375.00 Fire Retirement Other 010-270-502-00023 .00 .00 .00 .00 .00 Workman’s Comp 010-270-502-00024 314.90 472.06 674.00 674.00 .00 Health Insurance 010-270-505-00025 10,871.00 10,584.80 19,719.00 19,917.00 198.00 Life Insurance Amount 010-270-505-00026 8.58 .00 50.00 50.00 .00 Uniform Allowance 010-270-505-00027 191.15 4.99- 400.00 400.00 .00 Postage 010-270-520-00030 .00 .00 1,300.00 1,300.00 .00 Office Supplies 010-270-520-00031 88.50 27.33 200.00 200.00 .00 Operating Supplies 010-270-520-00032 4,490.74 2,016.93 4,200.00 4,400.00 200.00 Maint Office Equip 010-270-520-00058 .00 .00 .00 .00 .00 Items For Resale 010-270-521-00033 .00 .00 .00 .00 .00 Minor Equipment 010-270-521-00034 27.75 .00 600.00 600.00 .00 Public Relations 010-270-522-00041 .00 .00 .00 .00 .00 Advertising 010-270-522-00044 .00 .00 600.00 600.00 .00 Printing 010-270-522-00045 .00 .00 450.00 450.00 .00 Liability & Property Ins 010-270-523-00046 2,730.00 2,730.00 2,730.00 2,730.00 .00 Travel & Meetings 010-270-524-00047 140.00- 395.12 400.00 500.00 100.00 Membership 010-270-524-00048 309.00 .00 500.00 500.00 .00 Personnel Training 010-270-524-00049 .00 100.00 8,000.00 8,000.00 .00 Local Transport 010-270-524-00053 .00 .00 .00 .00 .00 Temps Contracted Service 010-270-525-00036 17,374.86 11,245.55 15,600.00 17,500.00 1,900.00 Professional Service 010-270-525-00042 135.00 .00 750.00 750.00 .00 Network and Software Support 010-270-525-00045 1,500.00 1,695.00 1,695.00 1,695.00 .00 Telephone 010-270-526-00051 599.44 409.38 1,500.00 1,500.00 .00 Rental Other 010-270-527-00057 .00 .00 .00 .00 .00 Maint Grounds 010-270-528-00059 .00 .00 .00 .00 .00 Maint Bldg 010-270-528-00060 .00 .00 1,000.00 2,000.00 1,000.00 Fuel & Oil 010-270-529-00035 2,146.54 2,253.02 2,800.00 3,000.00 200.00 Maint Automotive 010-270-529-00061 174.95 45.50 500.00 600.00 100.00 Maint Other Equipment 010-270-529-00062 .00 .00 .00 .00 .00 Automotive 010-270-580-00075 .00 .00 .00 .00 .00 Other Machinery 010-270-580-00076 .00 .00 .00 .00 .00 Other Improvements 010-270-584-00073 .00 .00 .00 .00 .00 Total Animal Control: 111,034.57 62,779.69 110,442.00 117,874.00 7,432.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 12 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Streets Regular Salaries 010-310-501-00001 248,528.12 180,770.60 283,380.00 .00 283,380.00- Part Time Salaries 010-310-501-00002 .00 .00 .00 .00 .00 Overtime Salaries 010-310-501-00005 .00 .00 8,000.00 .00 8,000.00- Oncall/Callback Salaries 010-310-501-00010 1,870.00 .00 2,000.00 .00 2,000.00- Fica 010-310-502-00021 19,062.89 14,771.90 23,209.00 .00 23,209.00- Retirement 010-310-502-00022 28,856.00 21,153.64 36,224.00 .00 36,224.00- Workman’s Comp 010-310-502-00024 16,679.81 14,448.47 18,378.00 .00 18,378.00- Health Insurance 010-310-505-00025 87,112.40 54,714.70 102,386.00 .00 102,386.00- Life Insurance Amount 010-310-505-00026 232.85 128.45 310.00 .00 310.00- Uniform Allowance 010-310-505-00027 388.77 2,545.88 685.00 .00 685.00- Postage 010-310-520-00030 .00 .00 .00 .00 .00 Office Supplies 010-310-520-00031 73.01 118.33 150.00 .00 150.00- Operating Supplies 010-310-520-00032 664.15 2,604.16 3,000.00 .00 3,000.00- Minor Equipment 010-310-521-00034 75.86 23,174.26 2,000.00 .00 2,000.00- Public Relations 010-310-522-00041 .00 .00 100.00 .00 100.00- Advertising 010-310-522-00044 .00 .00 100.00 .00 100.00- Printing 010-310-522-00045 .00 32.00 .00 .00 .00 Liability & Property Ins 010-310-523-00046 7,289.00 7,298.00 7,298.00 .00 7,298.00- Travel & Meetings 010-310-524-00047 224.09 3,167.88 500.00 .00 500.00- Personnel Training 010-310-524-00049 125.00 195.87 1,000.00 .00 1,000.00- Temps Contracted Service 010-310-525-00036 5,355.06 1,556.54 15,000.00 .00 15,000.00- Professional Service 010-310-525-00042 460.33 1,716.58 1,000.00 .00 1,000.00- Network and Software Support 010-310-525-00045 2,323.44 1,500.00 1,500.00 .00 1,500.00- Cleaning Service 010-310-525-00050 .00 .00 .00 .00 .00 Other Purchased Service 010-310-525-00063 .00 .00 .00 .00 .00 Telephone 010-310-526-00051 976.99 805.67 3,000.00 .00 3,000.00- Utilities 010-310-526-00052 797.07 279.75 3,000.00 .00 3,000.00- Rental Other 010-310-527-00057 .00 .00 700.00 .00 700.00- Maint Grounds 010-310-528-00059 .00 .00 700.00 .00 700.00- Maint Bldg 010-310-528-00060 2,005.75 1,956.34 2,000.00 .00 2,000.00- Fuel & Oil 010-310-529-00035 34,569.58 26,119.14 35,000.00 .00 35,000.00- Maint Automotive 010-310-529-00061 41,890.96 22,780.27 40,000.00 .00 40,000.00- Maint Other Equipment 010-310-529-00062 .36 12,322.99 500.00 .00 500.00- Office Equipment 010-310-580-00074 .00 1,450.98 .00 .00 .00 Automotive 010-310-580-00075 .00 254.29 .00 .00 .00 Other Machinery 010-310-580-00076 .00 .00 .00 .00 .00 Other Improvements 010-310-584-00073 201,978.57 63,839.88 233,635.00 .00 233,635.00- Curb and Gutter 010-310-584-00074 8,725.00 .00 40,000.00 .00 40,000.00- Construction 010-310-584-00079 153,131.67 51,608.82 230,000.00 .00 230,000.00- Debt & Lease Payments 010-310-590-00001 67,947.86 40,283.88 .00 .00 .00 Total Streets: 931,344.59 551,599.27 1,094,755.00 .00 1,094,755.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 13 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Engineering Regular Salaries 010-311-501-00001 105,837.21 72,604.55 107,016.00 110,016.00 3,000.00 Oncall/Callback Salaries 010-311-501-00010 .00 .00 .00 .00 .00 Fica 010-311-502-00021 8,178.82 5,975.90 8,187.00 8,187.00 .00 Retirement 010-311-502-00022 12,777.70 9,337.55 12,778.00 12,136.00 642.00- Workman’s Comp 010-311-502-00024 3,964.97 2,979.58 3,978.00 4,078.00 100.00 Health Insurance 010-311-505-00025 22,358.60 15,080.80 19,718.00 19,917.00 199.00 Life Insurance Amount 010-311-505-00026 50.86 29.36 55.00 50.00 5.00- Uniform Allowance 010-311-505-00027 .00 58.28 300.00 300.00 .00 Postage 010-311-520-00030 .00 .00 100.00 100.00 .00 Office Supplies 010-311-520-00031 33.42 17.06 100.00 100.00 .00 Operating Supplies 010-311-520-00032 144.48 229.03 1,000.00 1,000.00 .00 Maint Office Equip 010-311-520-00058 .00 .00 .00 .00 .00 Minor Equipment 010-311-521-00034 8,061.19 .00 3,500.00 3,500.00 .00 Printing 010-311-522-00045 .00 .00 .00 .00 .00 Liability & Property Ins 010-311-523-00046 1,460.00 1,460.00 1,460.00 1,460.00 .00 Travel & Meetings 010-311-524-00047 .00 501.00 3,000.00 3,000.00 .00 Membership 010-311-524-00048 .00 156.50 300.00 300.00 .00 Personnel Training 010-311-524-00049 .00 .00 .00 .00 .00 Professional Service 010-311-525-00042 1,500.00 11,000.00 7,500.00 7,500.00 .00 Network and Software support 010-311-525-00045 .00 500.00 500.00 500.00 .00 Cleaning Service 010-311-525-00050 .00 .00 .00 .00 .00 Other Purchased Service 010-311-525-00063 .00 .00 .00 .00 .00 Legal Service 010-311-525-00094 .00 .00 .00 .00 .00 Telephone 010-311-526-00051 558.00 418.50 250.00 250.00 .00 Fuel & Oil 010-311-529-00035 349.27 644.59 1,500.00 1,500.00 .00 Maint Automotive 010-311-529-00061 12.42 1,937.70 500.00 1,000.00 500.00 Maint Other Equipment 010-311-529-00062 .00 .00 .00 .00 .00 Office Equipment 010-311-580-00074 117.36 490.00 .00 200.00 200.00 Automotive 010-311-580-00075 .00 1,313.75 .00 .00 .00 Total Engineering: 165,404.30 124,734.15 171,742.00 175,094.00 3,352.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 14 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Equipment Maintenance Regular Salaries 010-312-501-00001 214,464.74 157,512.93 216,892.00 243,982.00 27,090.00 Part Time Salaries 010-312-501-00002 .00 .00 .00 .00 .00 Overtime Salaries 010-312-501-00005 .00 .00 .00 .00 .00 Oncall/Callback Salaries 010-312-501-00010 .00 .00 .00 .00 .00 Fica 010-312-502-00021 16,303.90 12,322.26 16,592.00 18,518.00 1,926.00 Retirement 010-312-502-00022 25,732.23 19,423.31 24,595.00 29,167.00 4,572.00 Workman’s Comp 010-312-502-00024 6,246.96 4,815.13 5,655.00 7,278.00 1,623.00 Health Insurance 010-312-505-00025 77,509.80 50,160.00 78,875.00 79,668.00 793.00 Life Insurance Amount 010-312-505-00026 203.44 117.44 200.00 200.00 .00 Uniform Allowance 010-312-505-00027 32,650.35 4,045.40 4,400.00 4,600.00 200.00 Postage 010-312-520-00030 198.26 .00 200.00 200.00 .00 Office Supplies 010-312-520-00031 3,543.57 311.80 4,000.00 4,000.00 .00 Operating Supplies 010-312-520-00032 13,379.58 4,198.34 12,000.00 12,000.00 .00 Minor Equipment 010-312-521-00034 4,365.86 2,906.89 3,000.00 .00 3,000.00- Advertising 010-312-522-00044 .00 .00 .00 .00 .00 Printing 010-312-522-00045 .00 .00 500.00 .00 500.00- Liability & Property Ins 010-312-523-00046 5,839.00 5,839.00 5,839.00 5,839.00 .00 Travel & Meetings 010-312-524-00047 422.00 351.57 4,000.00 .00 4,000.00- Membership 010-312-524-00048 375.00 232.00 750.00 750.00 .00 Personnel Training 010-312-524-00049 499.00 2,722.76 4,200.00 .00 4,200.00- Temps Contracted Service 010-312-525-00036 .00 .00 1,000.00 .00 1,000.00- Professional Service 010-312-525-00042 220.00 55.00 .00 .00 .00 Network and Computer Support 010-312-525-00045 1,500.00 3,626.00 1,826.00 1,826.00 .00 Telephone 010-312-526-00051 372.00 279.00 2,000.00 2,000.00 .00 Rental Other 010-312-527-00057 .00 .00 250.00 250.00 .00 Maint Grounds 010-312-528-00059 23.36 .00 500.00 500.00 .00 Maint Bldg 010-312-528-00060 3,237.50 6,210.01 5,000.00 2,000.00 3,000.00- Fuel & Oil 010-312-529-00035 14,293.98 6,209.86 7,000.00 7,000.00 .00 Maint Automotive 010-312-529-00061 9,397.53 1,421.35 5,000.00 5,000.00 .00 Maint Other Equipment 010-312-529-00062 97.68 2,692.80 5,200.00 3,000.00 2,200.00- Bank Service Charge 010-312-530-00065 40.44 39.00 .00 .00 .00 Automotive 010-312-580-00075 .00 .00 .00 .00 .00 Other Machinery 010-312-580-00076 .00 .00 .00 .00 .00 Other Improvements 010-312-584-00073 5,877.78 .00 2,000.00 .00 2,000.00- Construction 010-312-584-00079 .00 .00 .00 .00 .00 Debt & Lease Payments 010-312-590-00001 .00 .00 .00 .00 .00 Total Equipment Maintenance: 436,793.96 285,491.85 411,474.00 427,778.00 16,304.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 15 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Airport Postage 010-330-520-00030 .00 .00 50.00 50.00 .00 Office Supplies 010-330-520-00031 .00 27.33 50.00 50.00 .00 Operating Supplies 010-330-520-00032 1,305.00 .00 1,000.00 1,000.00 .00 Advertising 010-330-522-00044 .00 .00 50.00 50.00 .00 Printing 010-330-522-00045 .00 .00 .00 .00 .00 Liability & Property Ins 010-330-523-00046 5,500.00 5,500.00 5,500.00 5,500.00 .00 Travel & Meetings 010-330-524-00047 .00 .00 600.00 600.00 .00 Membership 010-330-524-00048 .00 .00 600.00 600.00 .00 Temps Contracted Service 010-330-525-00036 .00 .00 100.00 100.00 .00 Professional Service 010-330-525-00042 9,000.00 6,750.00 .00 6,000.00 6,000.00 Contracted Service 010-330-525-00067 .00 .00 9,000.00 .00 9,000.00- Legal Service 010-330-525-00094 .00 .00 .00 .00 .00 Telephone 010-330-526-00051 .00 .00 .00 .00 .00 Utilities 010-330-526-00052 4,937.45 1,667.77- 4,500.00 4,500.00 .00 Rental Other 010-330-527-00057 .00 .00 .00 .00 .00 Maint Grounds 010-330-528-00059 .00 13,331.00 14,500.00 14,500.00 .00 Maint Bldg 010-330-528-00060 75.00 2,039.85 200.00 200.00 .00 Maint Automotive 010-330-529-00061 443.78 .00 .00 .00 .00 Other Improvements 010-330-584-00073 31,016.93 .00 .00 .00 .00 FAA Grant Match 010-330-584-00079 .00 .00 18,000.00 22,000.00 4,000.00 Total Airport: 52,278.16 25,980.41 54,150.00 55,150.00 1,000.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 16 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Parks & Recreation Regular Salaries 010-350-501-00001 71,428.63 28,553.51 74,958.00 77,272.00 2,314.00 Overtime Salaries 010-350-501-00005 .00 .00 .00 .00 .00 Fica 010-350-502-00021 6,401.85 2,371.71 5,736.00 5,912.00 176.00 Retirement 010-350-502-00022 9,428.48 3,609.81 10,855.00 9,227.00 1,628.00- Workman’s Comp 010-350-502-00024 1,772.83 1,244.29 1,738.00 1,660.00 78.00- Health Insurance 010-350-505-00025 22,358.60 15,080.80 19,718.00 19,917.00 199.00 Life Insurance Amount 010-350-505-00026 50.86 29.36 50.00 50.00 .00 Uniform Allowance 010-350-505-00027 405.17 117.71 300.00 300.00 .00 Postage 010-350-520-00030 .00 .00 100.00 100.00 .00 Office Supplies 010-350-520-00031 .00 27.33 100.00 100.00 .00 Operating Supplies 010-350-520-00032 5,518.50 2,349.33 3,500.00 3,500.00 .00 Maint Office Equip 010-350-520-00058 16.55 .00 .00 .00 .00 Minor Equipment 010-350-521-00034 3,080.81 2,610.95 2,500.00 3,000.00 500.00 Public Relations 010-350-522-00041 .00 .00 .00 .00 .00 Advertising 010-350-522-00044 .00 .00 .00 .00 .00 Printing 010-350-522-00045 .00 .00 .00 .00 .00 Liability & Property Ins 010-350-523-00046 1,460.00 1,460.00 1,460.00 1,460.00 .00 Travel & Meetings 010-350-524-00047 .00 952.00 1,350.00 1,400.00 50.00 Membership 010-350-524-00048 75.00 75.00 200.00 200.00 .00 Temps Contracted Service 010-350-525-00036 105,191.61 52,987.78 90,000.00 95,000.00 5,000.00 Professional Service 010-350-525-00042 .00 .00 .00 .00 .00 Network and Computer Support 010-350-525-00045 3,176.00 1,500.00 1,500.00 1,500.00 .00 Cleaning Service 010-350-525-00050 .00 .00 .00 .00 .00 Contracted Service 010-350-525-00067 9,642.00 1,620.00 10,000.00 10,000.00 .00 Legal Service 010-350-525-00094 .00 .00 .00 .00 .00 Telephone 010-350-526-00051 186.00 139.50 1,000.00 1,000.00 .00 Utilities 010-350-526-00052 3,159.36 1,021.30 3,500.00 4,000.00 500.00 Rental Other 010-350-527-00057 .00 .00 .00 500.00 500.00 Maint Grounds 010-350-528-00059 32,186.22 17,284.76 49,000.00 50,000.00 1,000.00 Maint Bldg 010-350-528-00060 4,338.43 1,404.25 1,500.00 2,200.00 700.00 Fuel & Oil 010-350-529-00035 12,712.70 7,224.20 11,500.00 12,000.00 500.00 Maint Automotive 010-350-529-00061 3,857.35 4,223.50 7,000.00 5,000.00 2,000.00- Maint Other Equipment 010-350-529-00062 937.70 2,532.14 5,000.00 5,000.00 .00 Other Machinery 010-350-580-00076 3,725.28 .00 .00 .00 .00 Other Improvements 010-350-584-00073 2,794.00 .00 .00 .00 .00 Construction 010-350-584-00079 26,500.00 .00 .00 .00 .00 Debt & Lease payments 010-350-590-00001 9,459.18 18,918.36 10,000.00 10,000.00 .00 Total Parks & Recreation: 339,863.11 167,337.59 312,565.00 320,298.00 7,733.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 17 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Swimming Pool Regular Salaries 010-351-501-00001 73,579.41 1,391.25 16,000.00 20,000.00 4,000.00 Part Time Salaries 010-351-501-00002 24,776.18 9,883.75 80,000.00 79,000.00 1,000.00- Fica 010-351-502-00021 7,524.52 862.58 7,360.00 7,574.00 214.00 Workman’s Comp 010-351-502-00024 4,209.66 482.57 4,400.00 7,360.00 2,960.00 Uniform Allowance 010-351-505-00027 .00 .00 1,000.00 1,000.00 .00 Postage 010-351-520-00030 .00 .00 .00 .00 .00 Office Supplies 010-351-520-00031 790.69 278.68 1,400.00 1,400.00 .00 Operating Supplies 010-351-520-00032 7,631.77 220.66 6,000.00 6,500.00 500.00 Items For Resale 010-351-521-00033 5,738.99 2,026.08 5,700.00 5,700.00 .00 Minor Equipment 010-351-521-00034 592.12 25.96 700.00 700.00 .00 Liability & Property Ins 010-351-523-00046 2,892.00 2,892.00 2,892.00 2,892.00 .00 Travel & Meetings 010-351-524-00047 154.40 840.65 1,000.00 2,000.00 1,000.00 Membership 010-351-524-00048 50.00 350.00 475.00 350.00 125.00- Personnel Training 010-351-524-00049 1,598.04 1,046.37- 1,500.00 1,500.00 .00 Temps Contracted Service 010-351-525-00036 723.22 12,621.93 .00 .00 .00 Professional Service 010-351-525-00042 157.56 .00 .00 .00 .00 Network and Software Support 010-351-525-00045 .00 .00 .00 .00 .00 Contracted Service 010-351-525-00067 .00 .00 .00 .00 .00 Telephone 010-351-526-00051 686.55 199.36 500.00 500.00 .00 Utilities 010-351-526-00052 5,406.87 1,349.12 8,500.00 8,500.00 .00 Maint Grounds 010-351-528-00059 .00 .00 400.00 400.00 .00 Maint Bldg 010-351-528-00060 4,974.61 8,799.46 8,000.00 5,000.00 3,000.00- Pool Maintenance 010-351-528-00061 20,547.18 1,327.74 16,000.00 16,000.00 .00 Maint Other Equipment 010-351-529-00062 .00 .00 .00 .00 .00 Bank Service Charge 010-351-530-00065 930.29 484.66 650.00 650.00 .00 Swim Sales Tax 010-351-580-00089 .00 .00 .00 .00 .00 Construction 010-351-584-00079 2,783.34 .00 .00 .00 .00 Total Swimming Pool: 165,747.40 42,990.08 162,477.00 167,026.00 4,549.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 18 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Cemeteries Regular Salaries 010-410-501-00001 95,010.57 72,029.73 95,498.00 101,988.00 6,490.00 Part Time Salaries 010-410-501-00002 .00 .00 .00 .00 .00 Overtime Salaries 010-410-501-00005 .00 .00 .00 .00 .00 Fica 010-410-502-00021 7,263.65 5,481.34 7,306.00 7,803.00 497.00 Retirement 010-410-502-00022 11,344.29 8,600.39 11,420.00 12,136.00 716.00 Workman’s Comp 010-410-502-00024 5,411.91 4,184.91 5,564.00 5,928.00 364.00 Health Insurance 010-410-505-00025 32,843.60 17,750.40 39,437.00 39,834.00 397.00 Life Insurance Amount 010-410-505-00026 101.72 58.72 104.00 95.00 9.00- Uniform Allowance 010-410-505-00027 279.97 .00 300.00 300.00 .00 Postage 010-410-520-00030 99.27 48.67 100.00 100.00 .00 Office Supplies 010-410-520-00031 75.96 54.33 100.00 100.00 .00 Operating Supplies 010-410-520-00032 1,304.40 909.28 1,000.00 1,000.00 .00 Software 010-410-520-00033 .00 .00 .00 .00 .00 Maint Office Equip 010-410-520-00058 93.97 29.68 150.00 150.00 .00 Items For Resale 010-410-521-00033 .00 .00 .00 .00 .00 Minor Equipment 010-410-521-00034 1,840.04 1,215.31 1,900.00 1,900.00 .00 Printing 010-410-522-00045 156.99 .00 150.00 150.00 .00 Liability & Property Ins 010-410-523-00046 2,919.00 2,625.00 2,625.00 2,625.00 .00 Travel & Meetings 010-410-524-00047 .00 1,160.00 800.00 1,160.00 360.00 Personnel Training 010-410-524-00049 .00 .00 .00 .00 .00 Temps Contracted Service 010-410-525-00036 40,297.99 8,122.72 49,120.00 51,000.00 1,880.00 Professional Service 010-410-525-00042 .00 .00 .00 .00 .00 Network and Computer Support 010-410-525-00045 1,500.00 1,500.00 1,500.00 1,500.00 .00 Cleaning Service 010-410-525-00050 .00 .00 .00 .00 .00 Other Purchased Service 010-410-525-00063 19,513.71 14,614.20 20,000.00 21,000.00 1,000.00 Contracted Service 010-410-525-00067 4,772.47 .00 4,800.00 4,800.00 .00 Legal Service 010-410-525-00094 .00 .00 .00 .00 .00 Telephone 010-410-526-00051 1,514.03 984.87 1,800.00 1,800.00 .00 Rental Other 010-410-527-00057 .00 .00 .00 .00 .00 Maint Grounds 010-410-528-00059 27,759.68 7,505.26 27,800.00 27,800.00 .00 Maint Bldg 010-410-528-00060 1,077.38 502.93 1,000.00 1,000.00 .00 Fuel & Oil 010-410-529-00035 10,443.11 3,934.75 10,800.00 10,800.00 .00 Maint Automotive 010-410-529-00061 917.64 452.15 1,000.00 1,000.00 .00 Maint Other Equipment 010-410-529-00062 2,922.94 1,112.44 3,000.00 3,000.00 .00 Other Machinery 010-410-580-00076 .00 .00 .00 .00 .00 Other Improvements 010-410-584-00073 2,750.00- .00 .00 .00 .00 Construction 010-410-584-00079 .00 .00 .00 .00 .00 Cemetery Property Purchase 010-410-584-10000 15,848.39 .00 14,354.00 14,354.00 .00 Debt & Lease Payments 010-410-590-00001 12,279.37 .00 10,000.00 10,000.00 .00 Total Cemeteries: 294,842.05 152,877.08 311,628.00 323,323.00 11,695.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 19 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Capital Improvements Software 010-700-525-00063 .00 .00 .00 .00 .00 Automotive 010-700-580-00075 .00 .00 .00 .00 .00 Other Machinery 010-700-580-00076 27,207.00 .00 .00 .00 .00 Other Improvements 010-700-584-00073 47,305.45 .00 1,138,073.00 .00 1,138,073.00- Construction 010-700-584-00079 .00 .00 .00 .00 .00 Property Acquisition 010-700-584-10000 .00 .00 .00 .00 .00 Total Capital Improvements: 74,512.45 .00 1,138,073.00 .00 1,138,073.00- General Fund Revenue Total: 9,470,023.63- 7,088,834.88- 9,274,081.00- 7,219,672.00- 2,054,409.00 General Fund Expenditure Total: 7,734,960.66 5,210,543.11 9,274,081.00 7,219,672.00 2,054,409.00- Total General Fund: 1,735,062.97- 1,878,291.77- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 20 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget General Obligation Bond Fund G O Bond Revenue Property Taxes 011-010-010-00001 329,747.67- 165,500.00- 331,000.00- 326,000.00- 5,000.00 Refund bond refinancing 011-010-010-00003 .00 .00 .00 .00 .00 Source: 010 Revenue Total: 329,747.67- 165,500.00- 331,000.00- 326,000.00- 5,000.00 Total Source: 010: 329,747.67- 165,500.00- 331,000.00- 326,000.00- 5,000.00 Total G O Bond Revenue: 329,747.67- 165,500.00- 331,000.00- 326,000.00- 5,000.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 21 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget G O Bond Revenue Debt & Lease Payments 011-010-590-00001 329,747.67 15,249.20 331,000.00 326,000.00 5,000.00- Total G O Bond Revenue: 329,747.67 15,249.20 331,000.00 326,000.00 5,000.00- General Obligation Bond Fund Revenue Total: 329,747.67- 165,500.00- 331,000.00- 326,000.00- 5,000.00 General Obligation Bond Fund Expenditure Total: 329,747.67 15,249.20 331,000.00 326,000.00 5,000.00- Total General Obligation Bond Fund: .00 150,250.80- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 22 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Fund: 012 Income: 010 2- Year Property Tax Overrride 012-010-002-00003 .00 .00 .00 165,000.00- 165,000.00- Highway User Funds 012-010-002-00004 .00 .00 .00 400,000.00- 400,000.00- Local Highway District Tax 012-010-002-00005 .00 .00 .00 315,000.00- 315,000.00- 2015 Gas Tax HB312 012-010-002-00006 .00 .00 .00 124,000.00- 124,000.00- From General Fund 012-010-002-00010 .00 .00 .00 .00 .00 2022 One time Revenue 012-010-002-00011 .00 .00 .00 279,663.00- 279,663.00- Source: 002 Revenue Total: .00 .00 .00 1,283,663.00- 1,283,663.00- Total Source: 002: .00 .00 .00 1,283,663.00- 1,283,663.00- Total Income: 010: .00 .00 .00 1,283,663.00- 1,283,663.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 23 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Department: 010 Regular Wages 012-010-501-00001 .00 .00 .00 285,500.00 285,500.00 Overtime 012-010-501-00005 .00 .00 .00 8,000.00 8,000.00 On Call/Call Back 012-010-501-00010 .00 .00 .00 2,000.00 2,000.00 Fica 012-010-502-00021 .00 .00 .00 22,491.00 22,491.00 PERSI Retirement 012-010-502-00022 .00 .00 .00 37,024.00 37,024.00 Workman's Compensation 012-010-502-00024 .00 .00 .00 18,380.00 18,380.00 Life Insurance 012-010-505-00026 .00 .00 .00 102,386.00 102,386.00 Uniform Expenses 012-010-505-00027 .00 .00 .00 1,000.00 1,000.00 Office Supplies 012-010-520-00031 .00 .00 .00 150.00 150.00 Operating Supplies 012-010-520-00032 .00 .00 .00 3,000.00 3,000.00 Minor Equipment 012-010-521-00034 .00 .00 .00 2,000.00 2,000.00 Advertising 012-010-522-00044 .00 .00 .00 100.00 100.00 Liability & Property Insurance 012-010-523-00046 .00 .00 .00 7,298.00 7,298.00 Training 012-010-524-00049 .00 .00 .00 8,000.00 8,000.00 Temps Contracted Services 012-010-525-00036 .00 .00 .00 15,000.00 15,000.00 Professional Services 012-010-525-00042 .00 .00 .00 1,000.00 1,000.00 Network and Software Support 012-010-525-00045 .00 .00 .00 1,500.00 1,500.00 Telecommunication Services 012-010-526-00051 .00 .00 .00 3,000.00 3,000.00 Utilities 012-010-526-00052 .00 .00 .00 3,000.00 3,000.00 Equipment Rental 012-010-527-00057 .00 .00 .00 700.00 700.00 Maintenance Grounds 012-010-528-00059 .00 .00 .00 700.00 700.00 Maintenance Buildings 012-010-528-00060 .00 .00 .00 2,000.00 2,000.00 Fuel & Oil 012-010-529-00035 .00 .00 .00 35,000.00 35,000.00 Maintenance Equipment 012-010-529-00061 .00 .00 .00 40,000.00 40,000.00 Office Equipment 012-010-580-00074 .00 .00 .00 .00 .00 Automotive Purchases 012-010-580-00075 .00 .00 .00 .00 .00 Capital Improvements 012-010-584-00073 .00 .00 .00 200,000.00 200,000.00 Curb & Gutter Improvements 012-010-584-00074 .00 .00 .00 40,000.00 40,000.00 Construction 012-010-584-00079 .00 .00 .00 444,434.00 444,434.00 Debt & Lease Payments 012-010-590-00001 .00 .00 .00 .00 .00 Total Department: 010: .00 .00 .00 1,283,663.00 1,283,663.00 Fund: 012 Revenue Total: .00 .00 .00 1,283,663.00- 1,283,663.00- Fund: 012 Expenditure Total: .00 .00 .00 1,283,663.00 1,283,663.00 Total Fund: 012: .00 .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 24 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Capital Equip. & Building Capital Equip & Building Fund Transfers from Departments 015-010-010-00001 10,000.00- .00 .00 10,000.00- 10,000.00- Prop Taxes-Capital Improvement 015-010-010-00002 .00 .00 .00 400,000.00- 400,000.00- Source: 010 Revenue Total: 10,000.00- .00 .00 410,000.00- 410,000.00- Total Source: 010: 10,000.00- .00 .00 410,000.00- 410,000.00- Total Capital Equip & Building Fund: 10,000.00- .00 .00 410,000.00- 410,000.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 25 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Capital Equip & Building Fund Mowers 015-010-580-00076 .00 .00 .00 10,000.00 10,000.00 Construction 015-010-584-00079 .00 .00 .00 .00 .00 Construction Other 015-010-584-00084 .00 .00 .00 400,000.00 400,000.00 Total Capital Equip & Building Fund: .00 .00 .00 410,000.00 410,000.00 Capital Equip. & Building Revenue Total: 10,000.00- .00 .00 410,000.00- 410,000.00- Capital Equip. & Building Expenditure Total: .00 .00 .00 410,000.00 410,000.00 Total Capital Equip. & Building: 10,000.00- .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 26 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Water Fund Water Department Water Sales 020-010-010-00001 2,734,587.67- 1,980,125.42- 2,675,000.00- 2,852,000.00- 177,000.00- Water Taps 020-010-010-00002 132,854.05- 10,930.00- 65,000.00- 65,000.00- .00 Low Pressure Sales 020-010-010-00003 148,246.89- 150,678.38- 150,000.00- 153,000.00- 3,000.00- Water Merchandise 020-010-010-00004 .00 .00 .00 .00 .00 Water Misc Revenue 020-010-010-00005 63,763.54- 4,569.00- .00 .00 .00 Water Modeling Fees 020-010-010-00006 .00 .00 .00 .00 .00 Capital Improvement Fee 020-010-010-00010 .00 .00 .00 .00 .00 Water Grants 020-010-010-00030 .00 .00 .00 .00 .00 Interest Earned 020-010-010-00071 2,396.24- 1,736.41- 10,000.00- 5,000.00- 5,000.00 Contrib in Aid of Construction 020-010-010-00073 115,000.00- .00 .00 .00 .00 Loan Proceeds 020-010-010-00080 .00 .00 .00 .00 .00 From Fund Balance 020-010-010-00090 .00 .00 1,100,000.00- 1,800,000.00- 700,000.00- Transfer from Elec 020-010-010-00092 .00 .00 .00 .00 .00 Water Department Revenue Revenue Total: 3,196,848.39- 2,148,039.21- 4,000,000.00- 4,875,000.00- 875,000.00- Total Water Department Revenue: 3,196,848.39- 2,148,039.21- 4,000,000.00- 4,875,000.00- 875,000.00- Total Water Department: 3,196,848.39- 2,148,039.21- 4,000,000.00- 4,875,000.00- 875,000.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 27 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Water Department Regular Salaries 020-010-501-00001 422,080.56 322,010.42 434,000.00 475,000.00 41,000.00 Part Time Salaries 020-010-501-00002 .00 .00 .00 .00 .00 Overtime Salaries 020-010-501-00005 6,094.73 1,013.38 8,000.00 8,000.00 .00 Oncall/Callback Salaries 020-010-501-00010 3,825.00 340.00 5,000.00 5,000.00 .00 Fica 020-010-502-00021 33,061.35 25,654.95 32,000.00 36,000.00 4,000.00 Retirement 020-010-502-00022 6,647.25 38,545.28 46,000.00 52,000.00 6,000.00 Workman’s Comp 020-010-502-00024 14,078.57 11,385.80 15,000.00 16,000.00 1,000.00 Health Insurance 020-010-505-00025 129,079.89 86,186.81 145,000.00 150,000.00 5,000.00 Life Insurance Amount 020-010-505-00026 322.47 182.49 600.00 600.00 .00 Uniform Allowance 020-010-505-00027 6,524.97 1,468.41 6,000.00 6,500.00 500.00 Postage 020-010-520-00030 100.22 25.56 300.00 200.00 100.00- Office Supplies 020-010-520-00031 940.37 434.96 1,500.00 1,500.00 .00 Operating Sup- High Pressure 020-010-520-00032 93,904.57 146,946.50 135,000.00 135,000.00 .00 Operating Sup-Low Pressure 020-010-520-00033 9,573.76 10,935.53 40,000.00 40,000.00 .00 Operating Sup-Burley Ind Park 020-010-520-00034 1,127.59 527.13 5,000.00 5,000.00 .00 Operating Sup-Dutchmen 020-010-520-00035 239.03 456.81 1,000.00 1,000.00 .00 Operating Sup-Eng. & Mapping 020-010-520-00036 4,043.88 30,085.05 7,500.00 7,500.00 .00 Operating Supplies-Other 020-010-520-00037 4,870.02 5,957.12 10,000.00 10,000.00 .00 Mitigation 020-010-520-00038 17,716.16 .00 80,000.00 80,000.00 .00 Maint Office Equip 020-010-520-00058 1,847.66 1,029.87 1,500.00 1,500.00 .00 Items For Resale 020-010-521-00033 .00 .00 .00 .00 .00 Minor Equipment 020-010-521-00034 3,988.37 11,558.76 21,000.00 21,000.00 .00 Public Relations 020-010-522-00041 .00 .00 200.00 200.00 .00 Advertising 020-010-522-00044 46.05 .00 200.00 200.00 .00 Printing 020-010-522-00045 11,793.07 1,265.18 3,000.00 4,000.00 1,000.00 Liability & Property Ins 020-010-523-00046 15,000.00 15,000.00 15,000.00 17,000.00 2,000.00 Travel & Meetings 020-010-524-00047 4,389.90 7,965.62 5,000.00 10,000.00 5,000.00 Membership 020-010-524-00048 3,373.50 3,184.00 4,000.00 4,000.00 .00 Personnel Training 020-010-524-00049 478.50 1,550.00 1,700.00 1,700.00 .00 Local Transport 020-010-524-00053 .00 .00 .00 .00 .00 Temps Contracted Service 020-010-525-00036 2,088.96 .00 25,000.00 25,000.00 .00 Network and Computer Support 020-010-525-00041 30,000.00 30,000.00 30,000.00 35,569.00 5,569.00 Professional Srv-High Pressure 020-010-525-00042 76,586.29 37,439.20 100,000.00 75,000.00 25,000.00- Professional Srv-Low Pressure 020-010-525-00043 2,667.96 2,721.74 15,000.00 20,000.00 5,000.00 Profess. Srv-Burley Ind. Park 020-010-525-00044 6,732.18 6,212.22 15,000.00 20,000.00 5,000.00 Professional Srv-Dutchmen 020-010-525-00045 76.00 2,796.00 15,000.00 20,000.00 5,000.00 Professional Srv-Eng. & Mappng 020-010-525-00046 100.00 100.00 1,000.00 5,000.00 4,000.00 Professional Service-Other 020-010-525-00047 7,724.12 2,673.91 25,000.00 100,000.00 75,000.00 Cleaning Service 020-010-525-00050 216.56 .00 3,000.00 10,000.00 7,000.00 Other Purchased Service 020-010-525-00063 .00 .00 .00 .00 .00 Contracted Service 020-010-525-00067 .00 .00 .00 .00 .00 Legal Service 020-010-525-00094 31,875.00 23,906.25 32,000.00 34,000.00 2,000.00 Telephone 020-010-526-00051 8,579.79 4,341.33 15,000.00 15,000.00 .00 Utilities-High Pressure 020-010-526-00052 159,546.05 113,398.38 222,000.00 222,000.00 .00 Utilities-Low Pressure 020-010-526-00053 25,793.70 7,817.64 35,000.00 35,000.00 .00 Utilities-Burley Ind. Park 020-010-526-00054 80,064.96 52,988.86 95,000.00 105,000.00 10,000.00 Utilities-Dutchmen 020-010-526-00055 .00 .00 .00 .00 .00 Utilities-Eng. & Mapping 020-010-526-00056 .00 .00 .00 .00 .00 Utilities-Other 020-010-526-00057 .00 .00 .00 .00 .00 Rental Bldg 020-010-527-00055 .00 .00 33,000.00 35,000.00 2,000.00 Rental Other 020-010-527-00057 .00 .00 6,000.00 6,000.00 .00 Maint Grounds 020-010-528-00059 329.08 329.02 60,000.00 60,000.00 .00 Maint Bldg 020-010-528-00060 4,119.52 7,862.30 10,000.00 10,000.00 .00 Fuel & Oil 020-010-529-00035 12,154.53 12,619.79 15,000.00 18,000.00 3,000.00 Maint Automotive 020-010-529-00061 3,216.23 2,865.19 7,500.00 7,500.00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 28 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Maint Other Equipment 020-010-529-00062 4,529.86 2,569.11 7,500.00 7,500.00 .00 Bank Service Charge 020-010-530-00065 152.40 80.00 5,000.00 5,000.00 .00 Bad Debts 020-010-530-00066 3,709.69 3,654.31 35,000.00 35,000.00 .00 Administration Service 020-010-530-00091 120,000.00 90,000.00 120,000.00 120,000.00 .00 Depreciation 020-010-530-00098 529,144.32 .00 .00 .00 .00 Electronic Meters 020-010-532-00010 3,118.07 97,147.82 20,000.00 30,000.00 10,000.00 GIS Implementation 020-010-532-00020 9,304.30- 29,560.87 60,000.00 60,000.00 .00 Office Equipment 020-010-580-00074 4,306.66 100.57 6,000.00 6,000.00 .00 Automotive 020-010-580-00075 1,375.84 5,696.60 100,000.00 100,000.00 .00 Other Machinery 020-010-580-00076 4,663.84 9,457.84 10,000.00 10,000.00 .00 Other Improvements 020-010-584-00073 .00 .00 .00 .00 .00 Construction-High Pressure 020-010-584-00079 197,610.62 179,296.03 583,500.00 1,034,531.00 451,031.00 Construction-Low Pressure 020-010-584-00080 204,419.51 8,759.24 50,000.00 150,000.00 100,000.00 Const-Burley Industrial Park 020-010-584-00081 2,284.80 44,091.33 750,000.00 900,000.00 150,000.00 Construction-Dutchmen 020-010-584-00082 16,011.75 82,856.00 250,000.00 300,000.00 50,000.00 Const-Engineering & Mapping 020-010-584-00083 .00 .00 .00 .00 .00 Debt & Lease Payments 020-010-590-00001 26,864.51 25,546.16 170,000.00 170,000.00 .00 Water Int Expense 020-010-590-00010 450.72 .00 .00 .00 .00 Contingency 020-010-590-00099 .00 .00 .00 .00 .00 Total Water Department: 2,356,356.66 1,610,597.34 3,950,000.00 4,875,000.00 925,000.00 Water Fund Revenue Total: 3,196,848.39- 2,148,039.21- 4,000,000.00- 4,875,000.00- 875,000.00- Water Fund Expenditure Total: 2,356,356.66 1,610,597.34 3,950,000.00 4,875,000.00 925,000.00 Total Water Fund: 840,491.73- 537,441.87- 50,000.00- .00 50,000.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 29 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Wastewater Fund Wastewater Collections Sewer Sales Revenue 025-020-010-00001 2,981,286.74- 2,196,838.06- 3,300,000.00- 3,304,500.00- 4,500.00- Sewer Taps 025-020-010-00002 87,800.00- 10,700.00- 60,000.00- 30,000.00- 30,000.00 Industrial Sewer Charges 025-020-010-00003 2,320,433.37- 2,064,965.58- 2,200,000.00- 3,000,000.00- 800,000.00- Misc. Revenue 025-020-010-00005 92,574.20- 31,937.14- 50,000.00- 50,000.00- .00 Federal Grants 025-020-010-00016 .00 .00 .00 .00 .00 Federal Grants 025-020-010-00050 .00 .00 .00 .00 .00 Interest Earned 025-020-010-00071 18,110.12- 8,810.46- 60,000.00- 12,000.00- 48,000.00 Sale of Fixed Assets 025-020-010-00072 .00 .00 .00 .00 .00 Cust Contributions - Aid Of Co 025-020-010-00073 62,750.00- .00 .00 .00 .00 From Fund Balance 025-020-010-00090 .00 .00 .00 .00 .00 Transfer from Electric 025-020-010-00093 .00 .00 .00 .00 .00 CDBG Grant Revenue 025-020-010-00100 .00 .00 .00 .00 .00 From Cap Imp Fund 025-020-010-01000 .00 .00 .00 .00 .00 Wastewater Revenues Revenue Total: 5,562,954.43- 4,313,251.24- 5,670,000.00- 6,396,500.00- 726,500.00- Total Wastewater Revenues: 5,562,954.43- 4,313,251.24- 5,670,000.00- 6,396,500.00- 726,500.00- Total Wastewater Collections: 5,562,954.43- 4,313,251.24- 5,670,000.00- 6,396,500.00- 726,500.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 30 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Wastewater Collections Regular Salaries 025-020-501-00001 151,337.77 119,452.69 139,545.00 150,001.00 10,456.00 Part Time Salaries 025-020-501-00002 .00 .00 .00 .00 .00 Overtime Salaries 025-020-501-00005 9,459.76 4,555.13 12,371.00 12,000.00 371.00- Oncall/Callback Salaries 025-020-501-00010 2,380.00 1,105.00 2,062.00 2,000.00 62.00- Fica 025-020-502-00021 11,641.40 9,775.94 11,794.00 12,000.00 206.00 Retirement 025-020-502-00022 18,144.35 15,382.86 18,402.00 20,000.00 1,598.00 Workman’s Comp 025-020-502-00024 4,108.19 3,568.67 2,825.00 4,200.00 1,375.00 Health Insurance 025-020-505-00025 61,821.80 43,392.60 59,155.00 60,000.00 845.00 Life Insurance Amount 025-020-505-00026 152.58 91.75 156.00 150.00 6.00- Uniform Allowance 025-020-505-00027 .00 .00 1,200.00 600.00 600.00- Postage 025-020-520-00030 95.95 56.54 200.00 100.00 100.00- Office Supplies 025-020-520-00031 .00 27.33 .00 .00 .00 Operating Supplies 025-020-520-00032 7,947.82 2,026.54 20,000.00 12,000.00 8,000.00- Maint Office Equip 025-020-520-00058 25.16 .00 .00 .00 .00 Items For Resale 025-020-521-00033 .00 .00 .00 .00 .00 Minor Equipment 025-020-521-00034 31,233.23 13.50 20,000.00 20,000.00 .00 Public Relations 025-020-522-00041 241.83 .00 2,500.00 2,000.00 500.00- Advertising 025-020-522-00044 .00 .00 .00 .00 .00 Printing 025-020-522-00045 3,093.08 2,501.42 3,000.00 3,000.00 .00 Liability & Property Ins 025-020-523-00046 11,962.00 11,962.00 11,962.00 11,962.00 .00 Travel & Meetings 025-020-524-00047 325.26 287.00 10,000.00 2,500.00 7,500.00- Membership 025-020-524-00048 237.50 30.00 250.00 250.00 .00 Personnel Training 025-020-524-00049 3,524.04 574.00 3,000.00 3,000.00 .00 Temps Contracted Service 025-020-525-00036 17,447.32 14,281.76 7,500.00 10,000.00 2,500.00 Professional Service 025-020-525-00042 40,961.69 28,326.71 50,000.00 50,000.00 .00 Network and Computer Support 025-020-525-00045 6,035.00 8,871.00 8,871.00 8,871.00 .00 Cleaning Service 025-020-525-00050 1,283.64 569.40 .00 .00 .00 Contracted Laboratory Service 025-020-525-00063 .00 .00 .00 .00 .00 Contracted Service 025-020-525-00067 .00 .00 .00 .00 .00 Legal Service 025-020-525-00094 24,999.96 18,749.97 25,000.00 25,000.00 .00 Telephone 025-020-526-00051 5,421.46 2,803.43 3,000.00 3,000.00 .00 Utilities 025-020-526-00052 44,797.34 32,846.83 60,000.00 80,000.00 20,000.00 Rental Bldg 025-020-527-00055 .00 .00 5,000.00 .00 5,000.00- Rental Other 025-020-527-00057 573.24 628.87 1,000.00 1,000.00 .00 Maint Grounds 025-020-528-00059 895.00 .00 1,000.00 .00 1,000.00- Maint Bldg 025-020-528-00060 .00 642.00 1,000.00 .00 1,000.00- Fuel & Oil 025-020-529-00035 5,190.93 4,374.47 6,000.00 6,000.00 .00 Maint Automotive 025-020-529-00061 7,819.59 1,845.63 3,000.00 3,000.00 .00 Maint Other Equipment 025-020-529-00062 27,238.00 6,847.83 25,000.00 25,000.00 .00 Bank Service Charge 025-020-530-00065 160.80 120.00 500.00 500.00 .00 Bad Debts 025-020-530-00066 12,965.36 10,935.49 2,000.00 12,000.00 10,000.00 Administration Service 025-020-530-00091 45,000.00 33,750.00 45,000.00 45,000.00 .00 Depreciation 025-020-530-00098 1,187,744.00 .00 .00 .00 .00 GIS Implementation 025-020-532-00020 13,019.66 3,666.67 2,500.00 2,500.00 .00 INTEREST EXPENSE 025-020-580-00070 .00 .00 .00 .00 .00 Office Equipment 025-020-580-00074 .00 .00 .00 .00 .00 Automotive 025-020-580-00075 .00 .00 .00 .00 .00 Other Machinery 025-020-580-00076 .00 .00 .00 .00 .00 Other Improvements 025-020-584-00073 13,750.00 11,918.83 100,000.00 100,000.00 .00 Construction 025-020-584-00079 103,012.80 169,891.79 231,364.00 208,524.00 22,840.00- Industrial Plant Improvements 025-020-584-00100 .00 .00 .00 .00 .00 Debt/Lease Payments 025-020-590-00001 .00 .00 .00 .00 .00 Sewer-Contingency 025-020-590-00097 .00 .00 .00 251,788.00 251,788.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 31 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Total Wastewater Collections: 1,876,047.51 565,873.65 896,157.00 1,147,946.00 251,789.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 32 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Municipal Plant Operations Regular Salaries 025-030-501-00001 346,352.84 268,583.04 407,930.00 453,256.00 45,326.00 Overtime Salaries 025-030-501-00005 4,280.94 .00 8,240.00 9,150.00 910.00 Oncall/Callback 025-030-501-00010 850.00 .00 4,553.00 4,500.00 53.00- Fica 025-030-502-00021 26,722.80 22,032.90 28,555.00 31,728.00 3,173.00 Retirement 025-030-502-00022 27,669.46- 33,194.72 57,110.00 63,455.00 6,345.00 Workman’s Comp 025-030-502-00024 9,180.98 7,897.85 9,000.00 10,000.00 1,000.00 Health Insurance 025-030-505-00025 120,363.64 83,203.35 138,026.00 153,362.00 15,336.00 Life Insurance 025-030-505-00026 228.23 149.14 312.00 347.00 35.00 Uniform Allowance 025-030-505-00027 648.59 1,325.79 1,500.00 2,000.00 500.00 Postage 025-030-520-00030 155.64 77.23 250.00 250.00 .00 Office Supplies 025-030-520-00031 3,458.34 236.37 2,500.00 2,500.00 .00 Operating Supplies 025-030-520-00032 19,338.79 12,510.39 35,000.00 30,000.00 5,000.00- Lab Supplies 025-030-520-00033 11,602.60 7,689.92 10,000.00 10,000.00 .00 Bio-Solids Disposal 025-030-520-00035 18,557.60 22,714.85 25,000.00 25,000.00 .00 Maint Office Equip 025-030-520-00058 656.98 3,931.38 500.00 500.00 .00 Lab Equipment 025-030-521-00033 688.22 9,111.59 3,500.00 5,000.00 1,500.00 Minor Equipment 025-030-521-00034 149,723.21 29,276.49 75,000.00 75,000.00 .00 Public Relations 025-030-522-00041 731.98 660.03 1,000.00 1,000.00 .00 Advertising 025-030-522-00044 92.79 .00 .00 .00 .00 Printing 025-030-522-00045 .00 .00 500.00 500.00 .00 Liability & Property Ins 025-030-523-00046 11,962.00 11,962.00 11,962.00 11,962.00 .00 Travel & Meetings 025-030-524-00047 2,654.75 2,252.02 4,000.00 4,000.00 .00 Membership 025-030-524-00048 1,642.08 830.64 500.00 750.00 250.00 Personnel Training 025-030-524-00049 2,375.66 196.93 3,000.00 2,500.00 500.00- Professional Service 025-030-525-00042 168,397.36 76,885.78 100,000.00 100,000.00 .00 Network and Computer Support 025-030-525-00045 15,900.00 14,786.00 14,786.00 14,786.00 .00 Contracted Labrotory Service 025-030-525-00063 24,124.43 12,212.31 15,000.00 15,000.00 .00 Legal Service 025-030-525-00094 27,000.00 20,250.00 27,000.00 27,000.00 .00 Annual DEQ Fees 025-030-525-00096 .00 .00 .00 .00 .00 Telephone 025-030-526-00051 3,561.41 2,265.02 3,000.00 3,000.00 .00 Utilities 025-030-526-00052 219,692.90 159,083.27 200,000.00 200,000.00 .00 Rental Other 025-030-527-00057 6,463.02 4,848.55 8,000.00 7,000.00 1,000.00- Maint Grounds 025-030-528-00059 7,969.87 846.01 4,200.00 3,000.00 1,200.00- Maint Bldg 025-030-528-00060 5,898.97 8,720.64 10,000.00 10,000.00 .00 Fuel & Oil 025-030-529-00035 10,494.95 11,072.41 8,000.00 12,000.00 4,000.00 Maint Automotive 025-030-529-00061 7,394.61 2,392.80 4,000.00 4,000.00 .00 Maint Other Equipment 025-030-529-00062 58,756.57 39,631.36 100,000.00 100,000.00 .00 Maint of Belt Presses 025-030-529-00064 26,365.09 1,522.94 10,000.00 10,000.00 .00 Chemicals 025-030-529-01000 26,450.85 43,945.63 15,000.00 45,000.00 30,000.00 Bank Service Charge 025-030-530-00065 50.04 .00 .00 .00 .00 Bad Debts 025-030-530-00066 .00 .00 .00 .00 .00 Administration Service 025-030-530-00091 45,000.00 33,750.00 45,000.00 45,000.00 .00 Depreciation 025-030-530-00098 .00 .00 .00 .00 .00 Automotive 025-030-580-00075 3.14 .00 50,000.00 60,000.00 10,000.00 Other Improvements 025-030-584-00073 .00 .00 .00 .00 .00 Construction 025-030-584-00079 179,301.40 41,011.86 900,000.00 803,878.00 96,122.00- Debt Lease Payments 025-030-590-00001 158,435.85 213,874.92 1,100,000.00 1,100,000.00 .00 Debt Lease 025-030-590-00007 .00 .00 .00 .00 .00 Sewer Interest Exp 025-030-590-00010 450.72 .00 .00 .00 .00 Total Municipal Plant Operations: 1,696,310.38 1,204,936.13 3,441,924.00 3,456,424.00 14,500.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 33 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Industrial Plant Operations Regular Salaries 025-070-501-00001 50,589.94 36,691.14 60,461.00 62,980.00 2,519.00 Overtime Salaries 025-070-501-00005 1,288.98 .00 .00 .00 .00 Oncall/Callback Wages 025-070-501-00010 680.00 .00 .00 .00 .00 Fica 025-070-502-00021 4,055.30 3,031.38 4,500.00 4,690.00 190.00 Retirement 025-070-502-00022 6,342.91 4,718.77 7,000.00 7,290.00 290.00 Workman’s Comp 025-070-502-00024 1,419.93 1,094.68 1,700.00 1,770.00 70.00 Health Insurance 025-070-505-00025 10,994.00 4,917.60 21,000.00 21,000.00 .00 Life Insurance 025-070-505-00026 50.86 29.36 60.00 60.00 .00 Uniform Allowance 025-070-505-00027 .00 .00 200.00 200.00 .00 Office Supplies 025-070-520-00031 .00 422.00 1,200.00 1,000.00 200.00- Operating Supplies 025-070-520-00032 5,256.65 3,196.97 15,000.00 10,000.00 5,000.00- Lab Supplies 025-070-520-00033 .00 .00 2,000.00 1,000.00 1,000.00- Bio-Solids Disposal 025-070-520-00035 .00 13,374.64 25,000.00 5,000.00 20,000.00- Lab equipment 025-070-521-00033 750.00 7,571.00 1,000.00 2,000.00 1,000.00 Minor Equipment 025-070-521-00034 64,867.60 29,977.89 50,000.00 270,000.00 220,000.00 Liability & Property Ins 025-070-523-00046 11,962.00 11,962.00 11,962.00 11,962.00 .00 Main & Overland Project 025-070-524-00049 .00 .00 .00 .00 .00 Professional Service 025-070-525-00042 114,493.36 78,021.94 259,350.00 250,000.00 9,350.00- Network and Computer Support 025-070-525-00045 12,897.50 14,786.00 8,871.00 20,000.00 11,129.00 Contracted Labrotory 025-070-525-00063 250.00 11,608.00 5,000.00 1,000.00 4,000.00- Legal Service 025-070-525-00094 12,000.00 9,000.00 10,000.00 12,000.00 2,000.00 Annual DEQ Fees 025-070-525-00096 .00 .00 .00 .00 .00 Telephone 025-070-526-00051 2,879.89 493.33 2,000.00 2,000.00 .00 Utilities 025-070-526-00052 122,494.87 185,492.48 225,000.00 225,000.00 .00 Rental Other 025-070-527-00057 1,390.00 600.00 2,000.00 2,000.00 .00 Maint Grounds 025-070-528-00059 13,960.00 675.00 50,000.00 20,000.00 30,000.00- Maint Bldg 025-070-528-00060 .00 7,506.19 5,000.00 10,000.00 5,000.00 Fuel & Oil 025-070-529-00035 2,903.12 10,110.79 2,000.00 3,000.00 1,000.00 Maint Automotive 025-070-529-00061 1,759.44 1,827.90 2,000.00 2,400.00 400.00 Maint Other Equipment 025-070-529-00062 71,145.94 68,268.68 25,000.00 50,000.00 25,000.00 Chemicals 025-070-529-01000 76,868.00 107,913.16 150,000.00 150,000.00 .00 Administration Service 025-070-530-00091 45,000.00 33,750.00 45,000.00 45,000.00 .00 Automotive 025-070-580-00075 .00 .00 .00 .00 .00 Construction 025-070-584-00079 382,098.78 102,300.30 138,836.00 400,000.00 261,164.00 Debt Lease 025-070-590-00007 78,920.88 .00 157,561.00 157,560.00 1.00- Contingency 025-070-590-00097 .00 .00 .00 .00 .00 Reserved for bond payments 025-070-590-00099 .00 .00 43,218.00 43,218.00 .00 Total Industrial Plant Operations: 1,097,319.95 749,341.20 1,331,919.00 1,792,130.00 460,211.00 Wastewater Fund Revenue Total: 5,562,954.43- 4,313,251.24- 5,670,000.00- 6,396,500.00- 726,500.00- Wastewater Fund Expenditure Total: 4,669,677.84 2,520,150.98 5,670,000.00 6,396,500.00 726,500.00 Total Wastewater Fund: 893,276.59- 1,793,100.26- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 34 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget WasteWater Capital Improvement Capital Improvement Revenue Sewer Fees 026-010-010-00001 .00 .00 .00 .00 .00 Bond Proceeds 026-010-010-00002 .00 .00 .00 .00 .00 Misc. Revenue 026-010-010-00005 .00 .00 .00 .00 .00 State Grants 026-010-010-00016 .00 .00 .00 .00 .00 Local Grant Matching Funds 026-010-010-00020 .00 .00 .00 .00 .00 Interest Earned 026-010-010-00071 .00 .00 .00 .00 .00 DEQ Loan Proceeds 026-010-010-00080 .00 .00 .00 .00 .00 Bond Proceeds 026-010-010-00090 .00 .00 .00 .00 .00 CDBG 026-010-010-00100 .00 .00 .00 .00 .00 Federal Grants 026-010-010-00200 .00 .00 .00 .00 .00 595 Program Fund 026-010-010-00210 .00 .00 .00 .00 .00 From Fund Balance 026-010-010-01000 .00 .00 .00 .00 .00 Source: 010 Revenue Total: .00 .00 .00 .00 .00 Total Source: 010: .00 .00 .00 .00 .00 Total Capital Improvement Revenue: .00 .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 35 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Capital Improvement Revenue Professional Service 026-010-525-00042 .00 .00 .00 .00 .00 Administration Service 026-010-530-00091 .00 .00 .00 .00 .00 Other Machinery 026-010-580-00076 .00 .00 .00 .00 .00 Construction 026-010-584-00079 .00 .00 .00 .00 .00 Property Acquisition 026-010-584-10000 .00 .00 .00 .00 .00 Admin Building Construction 026-010-584-11000 .00 .00 .00 .00 .00 Overlook Sewer Extension 026-010-584-12000 .00 .00 .00 .00 .00 To Fund Balance 026-010-610-00001 .00 .00 .00 .00 .00 Total Capital Improvement Revenue: .00 .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 36 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Municipal Plant Construction Licenses 026-020-524-00050 .00 .00 .00 .00 .00 Professional Service 026-020-525-00042 .00 .00 .00 .00 .00 Automotive 026-020-580-00075 .00 .00 .00 .00 .00 Other Machinery 026-020-580-00076 .00 .00 .00 .00 .00 Construction 026-020-584-00079 .00 .00 .00 .00 .00 Total Municipal Plant Construction: .00 .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 37 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget BHIP Industrial WWTP Professional Services 026-030-525-00042 .00 .00 .00 .00 .00 Solids Handling-Prof. Services 026-030-525-00043 .00 .00 .00 .00 .00 Grant Admin Solids-Bldg 026-030-525-00045 .00 .00 .00 .00 .00 Administration Service 026-030-525-00091 .00 .00 .00 .00 .00 CDBG Grant 026-030-584-00045 .00 .00 .00 .00 .00 Construction-CDBG-Solids Build 026-030-584-00080 .00 .00 .00 .00 .00 Total BHIP Industrial WWTP: .00 .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 38 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Department: 070 Debt Lease 026-070-590-00007 .00 .00 .00 .00 .00 Total Department: 070: .00 .00 .00 .00 .00 WasteWater Capital Improvement Revenue Total: .00 .00 .00 .00 .00 WasteWater Capital Improvement Expenditure Total: .00 .00 .00 .00 .00 Total WasteWater Capital Improvement: .00 .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 39 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Electric Fund Electric Department Energy Billed 030-010-010-00001 9,101,881.97- 6,999,793.88- 9,000,000.00- 14,900,000.00- 5,900,000.00- Connect Fee 030-010-010-00002 25,920.98- 19,703.95- 38,000.00- 38,000.00- .00 Electric Other Revenue 030-010-010-00003 103,552.38- 28,383.40- 12,000.00- 12,000.00- .00 Electric Merchandise 030-010-010-00004 .00 .00 .00 .00 .00 Electric Misc 030-010-010-00005 16,325.76- 649.15- 2,400.00- 2,400.00- .00 Conservation Grants-BPA 030-010-010-00006 .00 .00 150,000.00- 150,000.00- .00 Bad Debt Recovery Electric Fnd 030-010-010-00010 .00 .00 .00 .00 .00 Interest Earned 030-010-010-00071 3,148.49- 2,281.54- 20,000.00- 20,000.00- .00 Cust Contributions - Aid Of Co 030-010-010-00073 178,617.16- 113,463.08- 200,000.00- 200,000.00- .00 Loan Proceeds 030-010-010-00080 .00 .00 .00 .00 .00 From Fund Balance 030-010-010-00090 .00 .00 80,812.00- 80,812.00- .00 Electric Department Revenue Revenue Total: 9,429,446.74- 7,164,275.00- 9,503,212.00- 15,403,212.00- 5,900,000.00- Total Electric Department Revenue: 9,429,446.74- 7,164,275.00- 9,503,212.00- 15,403,212.00- 5,900,000.00- Total Electric Department: 9,429,446.74- 7,164,275.00- 9,503,212.00- 15,403,212.00- 5,900,000.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 40 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Electric Department Regular Salaries 030-010-501-00001 591,696.58 413,136.93 630,000.00 648,900.00 18,900.00 Part Time Salaries 030-010-501-00002 .00 .00 .00 .00 .00 Overtime Salaries 030-010-501-00005 18,768.57 .00 10,000.00 10,000.00 .00 Oncall/Callback Salaries 030-010-501-00010 3,910.00 595.00 2,000.00 2,000.00 .00 Fica 030-010-502-00021 47,649.46 34,496.54 48,195.00 49,871.00 1,676.00 Retirement 030-010-502-00022 15,220.03- 54,460.47 48,907.00 77,837.00 28,930.00 Workman’s Comp 030-010-502-00024 8,783.76 6,619.67 8,200.00 9,235.00 1,035.00 Health Insurance 030-010-505-00025 169,796.97 104,642.24 157,808.00 159,336.00 1,528.00 Life Insurance Amount 030-010-505-00026 423.60 244.56 430.00 460.00 30.00 Uniform Allowance 030-010-505-00027 5,976.56 3,509.94 7,500.00 7,500.00 .00 Postage 030-010-520-00030 286.74 295.72 800.00 800.00 .00 Office Supplies 030-010-520-00031 4,586.55 320.76 5,500.00 5,500.00 .00 Operating Supplies 030-010-520-00032 17,580.37 26,286.69 16,200.00 16,200.00 .00 Maint Office Equip 030-010-520-00058 1,875.92 570.04 2,000.00 2,000.00 .00 Items For Resale 030-010-521-00033 5,007,942.70 3,116,311.00 6,086,080.00 10,080,070.00 3,993,990.00 Minor Equipment 030-010-521-00034 11,981.59 5,985.45 15,000.00 15,000.00 .00 Public Relations 030-010-522-00041 .00 .00 .00 .00 .00 Advertising 030-010-522-00044 .00 .00 .00 .00 .00 Printing 030-010-522-00045 3,517.15 1,615.53 4,500.00 4,500.00 .00 Liability & Property Ins 030-010-523-00046 13,780.00 13,780.00 13,780.00 13,780.00 .00 Travel & Meetings 030-010-524-00047 9,754.55 768.10 14,000.00 14,000.00 .00 Membership 030-010-524-00048 45,545.93 50,562.65 55,000.00 57,500.00 2,500.00 Personnel Training 030-010-524-00049 6,779.67 4,588.28 14,000.00 14,000.00 .00 Local Transport 030-010-524-00053 .00 .00 .00 .00 .00 Temps Contracted Service 030-010-525-00036 16,775.09 10,589.99 26,000.00 26,000.00 .00 Professional Service 030-010-525-00042 21,354.60 4,890.10 7,000.00 7,000.00 .00 Network and Computer Support 030-010-525-00045 25,820.00 13,024.75 13,000.00 13,025.00 25.00 Cleaning Service 030-010-525-00050 4,900.38 4,187.50 2,500.00 2,500.00 .00 Contracted Service 030-010-525-00067 .00 125.00 5,000.00 5,000.00 .00 Legal Service 030-010-525-00094 36,577.43 23,937.64 27,500.00 27,500.00 .00 Telephone 030-010-526-00051 6,351.30 6,005.58 2,500.00 2,500.00 .00 Utilities 030-010-526-00052 82,172.72 68,239.53 72,000.00 82,000.00 10,000.00 Rental Bldg 030-010-527-00055 .00 .00 30,600.00 30,600.00 .00 Rental Other 030-010-527-00057 .00 .00 400.00 400.00 .00 Maint Grounds 030-010-528-00059 276.88 .00 2,000.00 2,000.00 .00 Maint Bldg 030-010-528-00060 8,030.05 4,795.57 12,000.00 12,000.00 .00 Substation Maintenance 030-010-528-00070 20,737.21 20,430.16 70,000.00 70,000.00 .00 Fuel & Oil 030-010-529-00035 14,515.59 12,326.38 12,500.00 25,000.00 12,500.00 Maint Automotive 030-010-529-00061 22,225.66 22,218.16 15,000.00 18,000.00 3,000.00 Maint Other Equipment 030-010-529-00062 .00 .00 6,200.00 6,200.00 .00 Bank Service Charge 030-010-530-00065 215.40 277.00 7,200.00 7,200.00 .00 Bad Debts 030-010-530-00066 23,055.72 15,268.86 3,000.00 3,000.00 .00 Deposit Interest Expense 030-010-530-00067 4,410.82 3,094.23 3,200.00 3,200.00 .00 Franchise Fee 030-010-530-00080 347,400.00 260,550.00 449,045.00 449,045.00 .00 Administration Service 030-010-530-00091 936,206.00 603,724.50 910,667.00 910,667.00 .00 Depreciation 030-010-530-00098 314,559.65 .00 .00 .00 .00 Cash Long Or Short 030-010-530-00099 .00 .00 .00 .00 .00 Electronic Meters 030-010-532-00010 45,603.18 67,978.00 45,000.00 45,000.00 .00 GIS Implementation 030-010-532-00020 13,019.64 3,666.67 12,000.00 12,000.00 .00 Conservation Projects 030-010-580-00070 .00 .00 .00 .00 .00 Office Equipment 030-010-580-00074 .00 4,569.98 1,000.00 1,000.00 .00 Automotive 030-010-580-00075 28,689.46 .00 262,000.00 307,000.00 45,000.00 Other Machinery 030-010-580-00076 .00 .00 8,000.00 8,000.00 .00 Other Improvements 030-010-584-00073 13,750.00 .00 3,000.00 211,800.00 208,800.00 Construction 030-010-584-00079 427,800.57 449,717.80 320,000.00 1,520,000.00 1,200,000.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 41 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Conservation 030-010-584-00090 61,303.72 16,119.10 .00 .00 .00 Transfer to Water 030-010-584-00092 .00 .00 .00 .00 .00 Transfer to Sewer 030-010-584-00093 .00 .00 .00 .00 .00 Energy Conservation Projects 030-010-584-00094 .00 .00 35,000.00 35,000.00 .00 To Fund Balance/Future Reserve 030-010-590-00097 .00 .00 .00 372,086.00 372,086.00 Total Electric Department: 8,431,167.71 5,454,526.07 9,503,212.00 15,403,212.00 5,900,000.00 Electric Fund Revenue Total: 9,429,446.74- 7,164,275.00- 9,503,212.00- 15,403,212.00- 5,900,000.00- Electric Fund Expenditure Total: 8,431,167.71 5,454,526.07 9,503,212.00 15,403,212.00 5,900,000.00 Total Electric Fund: 998,279.03- 1,709,748.93- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 42 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Library Fund Library Property Taxes-Permanent Levy 040-010-010-00001 195,444.00- 138,168.00- 201,307.00- 207,346.00- 6,039.00- Property Tax-Overide Levy 040-010-010-00002 277,280.00- 138,640.00- 277,280.00- 277,280.00- .00 Miscellaneous Revenue 040-010-010-00005 16,055.46- 7,114.80- 5,400.00- 5,400.00- .00 Donations 040-010-010-00010 .00 1,000.00- 1,300.00- 1,300.00- .00 Donations for Library Programs 040-010-010-00011 2,700.00- 2,300.00- .00 .00 .00 Library Fines 040-010-010-00040 7,178.08- 5,240.57- 6,200.00- 5,000.00- 1,200.00 Non-Resident Library Card 040-010-010-00050 8,080.10- 7,236.09- 7,200.00- 7,200.00- .00 Library Trust Fund 040-010-010-00066 .00 .00 .00 .00 .00 Library Grant 040-010-010-00067 9,500.00- 20,500.00- 30,000.00- 30,000.00- .00 Laser Cat Grant 040-010-010-00068 .00 .00 .00 .00 .00 Construction Grant 040-010-010-00069 .00 .00 .00 .00 .00 Interest Earned 040-010-010-00071 1,058.03- 758.11- 6,000.00- 1,000.00- 5,000.00 Library Sales Tax 040-010-010-00082 .00 .00 .00 .00 .00 From Fund Balance 040-010-010-00090 .00 .00 36,000.00- 200,000.00- 164,000.00- Operating Transfer General 040-010-010-00091 18,000.00- .00 .00 .00 .00 Library Revenue Revenue Total: 535,295.67- 320,957.57- 570,687.00- 734,526.00- 163,839.00- Total Library Revenue: 535,295.67- 320,957.57- 570,687.00- 734,526.00- 163,839.00- Total Library: 535,295.67- 320,957.57- 570,687.00- 734,526.00- 163,839.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 43 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Library Regular Salaries 040-010-501-00001 119,657.35 80,572.14 160,165.00 152,693.00 7,472.00- Part Time Salaries 040-010-501-00002 93,056.34 72,286.80 91,288.00 101,300.00 10,012.00 Overtime Salaries 040-010-501-00005 .00 .00 .00 .00 .00 Oncall/Callback Salaries 040-010-501-00010 .00 .00 .00 .00 .00 Fica 040-010-502-00021 16,140.86 12,154.69 21,456.00 21,456.00 .00 Retirement 040-010-502-00022 20,844.64 15,599.90 23,250.00 23,500.00 250.00 Workman’s Comp 040-010-502-00024 418.90 305.00 1,200.00 1,200.00 .00 Health Insurance 040-010-505-00025 45,493.10 30,583.20 65,000.00 60,200.00 4,800.00- Life Insurance Amount 040-010-505-00026 148.29 88.08 200.00 206.00 6.00 Uniform Allowance 040-010-505-00027 .00 .00 .00 .00 .00 Postage 040-010-520-00030 2,701.25 2,105.22 3,000.00 3,000.00 .00 Office Supplies 040-010-520-00031 2,275.80 2,114.97 3,000.00 3,000.00 .00 Operating Supplies 040-010-520-00032 3,419.79 1,914.11 5,000.00 5,000.00 .00 Inter-Library Postage 040-010-520-00033 .00 .00 .00 .00 .00 Maint Office Equip 040-010-520-00058 .00 .00 750.00 800.00 50.00 Newspaper Subscriptions 040-010-520-00100 892.24 .00 1,000.00 1,000.00 .00 Adult Periodicals 040-010-520-00101 .00 .00 600.00 .00 600.00- Adult Books 040-010-520-00103 52,667.78 27,682.20 35,836.00 40,188.00 4,352.00 Adult Audiobooks 040-010-520-00104 .00 .00 .00 .00 .00 Adult Videos 040-010-520-00105 .00 .00 .00 .00 .00 Young Adult Books 040-010-520-00106 .00 .00 .00 .00 .00 Children Periodicals 040-010-520-00107 .00 .00 .00 .00 .00 Children Books 040-010-520-00108 .00 .00 .00 .00 .00 Children's Audiobooks 040-010-520-00109 .00 .00 .00 .00 .00 Children's Fun Packs 040-010-520-00110 .00 .00 .00 .00 .00 Children's Vidoes 040-010-520-00111 .00 .00 .00 .00 .00 Computer Software 040-010-520-00112 .00 .00 1,000.00 1,000.00 .00 Computer Supplies 040-010-520-00113 1,961.70 .00 500.00 500.00 .00 Computer Support 040-010-520-00114 29,752.95 2,889.90 27,825.00 27,825.00 .00 Computer Replacement 040-010-520-00115 3,406.76 139.99 2,000.00 8,000.00 6,000.00 Items For Resale 040-010-521-00033 .00 .00 .00 .00 .00 Minor Equipment 040-010-521-00034 799.98 154.99 1,200.00 1,200.00 .00 Public Relations 040-010-522-00041 287.22 .00 700.00 1,000.00 300.00 Advertising 040-010-522-00044 1,032.26 65.63- 300.00 300.00 .00 Printing 040-010-522-00045 377.98 .00 800.00 800.00 .00 Liability & Property Ins 040-010-523-00046 10,640.00 7,537.00 7,537.00 7,537.00 .00 Travel & Meetings 040-010-524-00047 480.24 505.22 1,400.00 2,000.00 600.00 Membership 040-010-524-00048 826.43 280.00 500.00 700.00 200.00 Personnel Training 040-010-524-00049 731.50 150.00 1,000.00 1,000.00 .00 Temps Contracted Service 040-010-525-00036 .00 .00 .00 .00 .00 Professional Service 040-010-525-00042 12,279.40 4,811.86 15,000.00 15,000.00 .00 Network and Computer Support 040-010-525-00045 .00 .00 .00 .00 .00 Grant #1 040-010-525-00047 5,513.47 18,867.15 30,000.00 30,000.00 .00 Programs 040-010-525-00048 5,939.68 3,810.58 5,000.00 5,000.00 .00 Cleaning Supplies 040-010-525-00049 185.76 27.99 500.00 500.00 .00 Cleaning Service 040-010-525-00050 3,097.00 2,250.00 3,000.00 3,000.00 .00 Other Purchased Service 040-010-525-00063 .00 .00 .00 .00 .00 Contracted Service 040-010-525-00067 .00 .00 .00 .00 .00 Legal Service 040-010-525-00094 6,000.00 4,500.00 6,000.00 6,000.00 .00 Telephone 040-010-526-00051 4,390.87 4,315.21 3,360.00 5,000.00 1,640.00 Utilities 040-010-526-00052 3,495.95 2,582.72 3,500.00 3,500.00 .00 Rental Bldg 040-010-527-00055 .00 .00 .00 .00 .00 Rental Other 040-010-527-00057 5,189.93 3,928.93 4,000.00 4,000.00 .00 Maint Grounds 040-010-528-00059 510.00 665.99 700.00 800.00 100.00 Maint Bldg 040-010-528-00060 5,332.38 4,337.75 3,000.00 3,000.00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 44 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Fuel & Oil 040-010-529-00035 .00 .00 .00 .00 .00 Maint Other Equipment 040-010-529-00062 .00 .00 .00 .00 .00 Administration Service 040-010-530-00091 4,119.92 2,624.94 4,120.00 4,120.00 .00 Miscellaneous 040-010-580-00069 3,910.73 441.94 .00 43,901.00 43,901.00 Library Sales Tax 040-010-580-00089 .00 .00 .00 .00 .00 Transfer to Building Fund 040-010-580-00090 .00 .00 .00 .00 .00 Other Improvements 040-010-584-00073 .00 .00 .00 .00 .00 Construction 040-010-584-00079 .00 19,034.72 36,000.00 145,300.00 109,300.00 Contingency 040-010-584-00097 2,391.85 .00 .00 .00 .00 Total Library: 470,370.30 329,197.56 570,687.00 734,526.00 163,839.00 Library Fund Revenue Total: 535,295.67- 320,957.57- 570,687.00- 734,526.00- 163,839.00- Library Fund Expenditure Total: 470,370.30 329,197.56 570,687.00 734,526.00 163,839.00 Total Library Fund: 64,925.37- 8,239.99 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 45 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Library Cap. & Building Fund Capital & Building Revenue Building Donations 045-010-010-00001 300.00- .00 .00 .00 .00 Interest Earned 045-010-010-00071 433.29- 225.27- .00 .00 .00 Gain/Loss on Investment 045-010-010-00075 .00 .00 .00 .00 .00 Loan or Bond Proceeds 045-010-010-00090 .00 .00 .00 .00 .00 Transfer From Other Funds 045-010-010-00091 .00 .00 .00 .00 .00 Transfer from Library 045-010-010-00095 .00 .00 .00 .00 .00 Source: 010 Revenue Total: 733.29- 225.27- .00 .00 .00 Total Source: 010: 733.29- 225.27- .00 .00 .00 Total Capital & Building Revenue: 733.29- 225.27- .00 .00 .00 Library Cap. & Building Fund Revenue Total: 733.29- 225.27- .00 .00 .00 Library Cap. & Building Fund Expenditure Total: .00 .00 .00 .00 .00 Total Library Cap. & Building Fund : 733.29- 225.27- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 46 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Sanitation Fund Sanitation Sanitation Services 050-010-010-00001 1,577,379.14- 1,268,775.60- 1,454,924.00- 1,500,000.00- 45,076.00- Sanitation Billed Revenue 050-010-010-00005 138,907.51- 94,546.76- 95,000.00- 100,000.00- 5,000.00- Loan Revenue 050-010-010-00010 .00 .00 .00 .00 .00 Misc Revenue 050-010-010-00012 241.37- .00 15,000.00- 15,000.00- .00 Transfer for Weeds 050-010-010-00015 .00 .00 31,000.00- 31,000.00- .00 Sanitation Interest 050-010-010-00071 38.05- 27.49- 3,000.00- 3,000.00- .00 From Fund Balance 050-010-010-00090 .00 .00 .00 284,932.00- 284,932.00- Loan Proceeds 050-010-010-00093 .00 .00 .00 .00 .00 To Fund Balance 050-010-010-00095 .00 .00 .00 .00 .00 Sanitation Revenue Revenue Total: 1,716,566.07- 1,363,349.85- 1,598,924.00- 1,933,932.00- 335,008.00- Total Sanitation Revenue: 1,716,566.07- 1,363,349.85- 1,598,924.00- 1,933,932.00- 335,008.00- Total Sanitation: 1,716,566.07- 1,363,349.85- 1,598,924.00- 1,933,932.00- 335,008.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 47 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Sanitation Regular Salaries 050-010-501-00001 344,193.56 242,282.56 353,470.00 384,020.00 30,550.00 Part Time Salaries 050-010-501-00002 .00 .00 .00 .00 .00 Overtime Salaries 050-010-501-00005 .00 .00 .00 .00 .00 Oncall/Callback Salaries 050-010-501-00010 .00 .00 .00 .00 .00 Fica 050-010-502-00021 26,348.27 20,233.62 27,040.00 29,378.00 2,338.00 Retirement 050-010-502-00022 7,912.79- 31,950.40 42,204.00 43,548.00 1,344.00 Workman’s Comp 050-010-502-00024 26,641.79 21,166.78 27,950.00 30,376.00 2,426.00 Health Insurance 050-010-505-00025 144,940.00 91,609.60 157,750.00 159,336.00 1,586.00 Life Insurance Amount 050-010-505-00026 351.73 205.52 440.00 440.00 .00 Uniform Allowance 050-010-505-00027 5,385.41 4,221.27 7,000.00 8,200.00 1,200.00 Postage 050-010-520-00030 .00 272.60 200.00 .00 200.00- Office Supplies 050-010-520-00031 383.93 513.09 500.00 500.00 .00 Operating Supplies 050-010-520-00032 3,981.29 2,419.49 7,500.00 7,500.00 .00 Landfill/Green Waste Fees 050-010-520-00033 66,079.44 49,720.77 66,000.00 69,300.00 3,300.00 Maint Office Equip 050-010-520-00058 .00 .00 500.00 500.00 .00 Minor Equipment 050-010-521-00034 61,872.25 18,781.08 30,000.00 30,000.00 .00 Container Maintenance 050-010-521-00035 50,987.08 63,713.86 72,871.00 111,000.00 38,129.00 Public Relations 050-010-522-00041 .00 .00 50.00 50.00 .00 Advertising 050-010-522-00044 .00 .00 500.00 500.00 .00 Printing 050-010-522-00045 2,743.56 1,044.80 500.00 800.00 300.00 Liability & Property Ins 050-010-523-00046 9,349.00 9,349.00 9,349.00 9,439.00 90.00 Travel & Meetings 050-010-524-00047 91.67 746.00 500.00 3,000.00 2,500.00 Personnel Training 050-010-524-00049 .00 .00 300.00 500.00 200.00 Temps Contracted Service 050-010-525-00036 3,747.28 .00 25,000.00 25,000.00 .00 Professional Service 050-010-525-00042 3,655.00 3,097.00 6,000.00 6,000.00 .00 Network and Computer Support 050-010-525-00045 2,500.00 2,500.00 2,500.00 5,195.00 2,695.00 Cleaning Service 050-010-525-00050 200.00 225.00 1,500.00 1,500.00 .00 Weed Eradication 050-010-525-00066 79,599.85 26,483.79 50,000.00 50,000.00 .00 Contracted Service 050-010-525-00067 .00 .00 25,000.00 25,000.00 .00 Legal Service 050-010-525-00094 9,000.00 6,750.00 9,000.00 9,000.00 .00 Telephone 050-010-526-00051 686.54 430.81 3,000.00 3,000.00 .00 Utilities 050-010-526-00052 1,530.10 1,205.52 1,500.00 2,300.00 800.00 Rental Other 050-010-527-00057 707.14 63.40 1,500.00 1,500.00 .00 Maint Grounds 050-010-528-00059 9.09- 35.48 750.00 1,500.00 750.00 Maint Bldg 050-010-528-00060 739.66 864.47 1,500.00 1,500.00 .00 Fuel & Oil 050-010-529-00035 84,257.23 90,630.72 80,000.00 108,000.00 28,000.00 Maint Automotive 050-010-529-00061 113,936.30 69,736.52 75,000.00 90,000.00 15,000.00 Maint Other Equipment 050-010-529-00062 1,031.98 1,194.68 12,500.00 12,500.00 .00 Bank Service Charge 050-010-530-00065 53.60 40.00 50.00 50.00 .00 Bad Debts 050-010-530-00066 2,425.48 1,835.83 2,500.00 2,500.00 .00 Road Use and Shop 050-010-530-00082 45,000.00 .00 60,000.00 60,000.00 .00 Administration Service 050-010-530-00091 24,999.96 18,749.97 25,000.00 25,000.00 .00 Depreciation 050-010-530-00098 162,050.10 .00 .00 .00 .00 Office Equipment 050-010-580-00074 .00 .00 1,000.00 1,000.00 .00 Automotive 050-010-580-00075 1,119.17 .00 397,000.00 505,000.00 108,000.00 Other Machinery 050-010-580-00076 6,608.98 452.39 14,000.00 110,000.00 96,000.00 Other Improvements 050-010-584-00073 .00 .00 .00 .00 .00 Construction 050-010-584-00079 .00 .00 .00 .00 .00 Contingency 050-010-584-00097 .00 .00 .00 .00 .00 Debt & Lease Payment 050-010-590-00001 .00 .00 .00 .00 .00 Total Sanitation: 1,279,275.47 782,526.02 1,598,924.00 1,933,932.00 335,008.00 Sanitation Fund Revenue Total: 1,716,566.07- 1,363,349.85- 1,598,924.00- 1,933,932.00- 335,008.00- Sanitation Fund Expenditure Total: 1,279,275.47 782,526.02 1,598,924.00 1,933,932.00 335,008.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 48 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Total Sanitation Fund: 437,290.60- 580,823.83- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 49 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Golf Fund Golf Maintenance Golf Fee 070-010-010-00001 328,283.40- 225,210.60- 276,000.00- 260,000.00- 16,000.00 Annual Cart Use Fee 070-010-010-00002 9,681.32- 2,809.65- 14,000.00- 13,000.00- 1,000.00 Driving Range/Club Rental 070-010-010-00004 19,619.00- 14,919.00- 14,500.00- 15,000.00- 500.00- Misc Revenue 070-010-010-00005 3,129.22- 659.14- .00 .00 .00 Snack Bar Proceeds 070-010-010-00006 51,742.38- 24,398.87- 43,000.00- 40,000.00- 3,000.00 Golf Cart Rental Fee 070-010-010-00007 169,512.00- 80,770.20- 125,000.00- 125,000.00- .00 Clubhouse Rental 070-010-010-00008 648.00- .00 1,000.00- 500.00- 500.00 Pro Shop Proceeds 070-010-010-00009 91,577.24- 46,458.59- 70,000.00- 70,000.00- .00 From General Fund 070-010-010-00010 144,089.00- 75,000.00- 150,000.00- 150,000.00- .00 Pro Shop Credit - Customers 070-010-010-00011 782.87 576.30- .00 .00 .00 Advertising Proceeds 070-010-010-00017 .00 .00 .00 .00 .00 Golf Improvement-Friends 070-010-010-00018 .00 .00 .00 .00 .00 Interest Earned 070-010-010-00071 12.68- 9.18- .00 .00 .00 Capital Project Fund 070-010-010-00080 .00 .00 .00 .00 .00 Golf Sales Tax 070-010-010-00082 8,347.97- 4,208.28- 6,780.00- 6,600.00- 180.00 Short term Loan 070-010-010-00090 .00 .00 .00 .00 .00 Golf Maintenance Revenue Revenue Total: 825,859.34- 475,019.81- 700,280.00- 680,100.00- 20,180.00 Total Golf Maintenance Revenue: 825,859.34- 475,019.81- 700,280.00- 680,100.00- 20,180.00 Total Golf Maintenance: 825,859.34- 475,019.81- 700,280.00- 680,100.00- 20,180.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 50 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Golf Maintenance Regular Salaries 070-010-501-00001 95,982.70 89,680.01 82,290.00 86,320.00 4,030.00 Fica 070-010-502-00021 6,509.84 6,828.90 6,295.00 9,309.00 3,014.00 Retirement 070-010-502-00022 7,217.04- 10,707.65 9,825.00 13,799.00 3,974.00 Workman’s Comp 070-010-502-00024 2,283.73 1,641.22 8,372.00 2,246.00 6,126.00- Health Insurance 070-010-505-00025 44,716.20 30,161.60 39,434.00 39,834.00 400.00 Life Insurance Amount 070-010-505-00026 101.72 58.72 100.00 .00 100.00- Uniform Allowance 070-010-505-00027 864.08 247.55 1,200.00 1,200.00 .00 Postage 070-010-520-00030 164.51 46.25 400.00 400.00 .00 Office Supplies 070-010-520-00031 32.99 27.33 100.00 100.00 .00 Operating Supplies 070-010-520-00032 1,435.39 855.03 1,800.00 1,800.00 .00 Landfill/Green Waste Fees 070-010-520-00033 .00 .00 200.00 .00 200.00- Maint Office Equip 070-010-520-00058 1,383.98 .00 1,200.00 1,200.00 .00 Items For Resale Snack Bar 070-010-521-00033 .00 .00 .00 .00 .00 Minor Equipment 070-010-521-00034 1,405.01 1,086.99 2,000.00 2,500.00 500.00 Items for Resale Pro Shop 070-010-521-00035 .00 497.67 .00 .00 .00 Liability & Property Ins 070-010-523-00046 3,278.00 3,278.00 3,278.00 3,278.00 .00 Travel & Meetings 070-010-524-00047 .00 973.04 1,100.00 1,100.00 .00 Membership 070-010-524-00048 360.00 240.00 360.00 240.00 120.00- Temps Contracted Service 070-010-525-00036 61,896.44 30,308.77 80,000.00 80,000.00 .00 Professional Service 070-010-525-00042 774.46 750.00 750.00 750.00 .00 Network and Computer Support 070-010-525-00045 1,500.00 1,500.00 1,500.00 1,500.00 .00 Other Purchased Service 070-010-525-00063 .00 .00 .00 .00 .00 Telephone 070-010-526-00051 558.00 418.50 500.00 600.00 100.00 Utilities 070-010-526-00052 14,880.63 5,353.29 13,141.00 14,000.00 859.00 Rental Other 070-010-527-00057 91.00 .00 300.00 .00 300.00- Maint Grounds 070-010-528-00059 48,683.69 22,564.11 41,500.00 50,000.00 8,500.00 Maint Bldg 070-010-528-00060 1,997.94 1,535.42 1,000.00 1,500.00 500.00 Fuel & Oil 070-010-529-00035 12,610.26 13,193.54 14,500.00 18,000.00 3,500.00 Maint Automotive 070-010-529-00061 969.71 234.76 2,000.00 1,500.00 500.00- Maint Other Equipment 070-010-529-00062 19,004.36 19,842.37 19,000.00 22,000.00 3,000.00 Interest Expense-Maintenance 070-010-530-00050 .00 .00 .00 .00 .00 Administration Service 070-010-530-00091 1,099.92 824.94 1,100.00 1,100.00 .00 Depreciation Exp-Maint 070-010-530-00098 41,806.56 .00 .00 .00 .00 Deprec. Exp-Maint 070-010-580-00050 .00 .00 .00 .00 .00 Miscellaneous 070-010-580-00069 .00 .00 .00 .00 .00 Office Equipment 070-010-580-00074 .00 .00 .00 .00 .00 Automotive 070-010-580-00075 .00 .00 .00 .00 .00 Other Machinery 070-010-580-00076 13,426.16 .00 42,304.00 .00 42,304.00- Other Improvements 070-010-584-00073 5,500.00- .00 .00 .00 .00 Construction 070-010-584-00079 .00 .00 .00 .00 .00 Debt/Lease Payments 070-010-590-00001 .00 .00 .00 13,748.00 13,748.00 Total Golf Maintenance: 365,100.24 242,855.66 375,549.00 368,024.00 7,525.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 51 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Golf Pro Shop Regular Salaries 070-020-501-00001 64,172.80 48,360.00 67,704.00 67,704.00 .00 Fica 070-020-502-00021 4,774.03 3,584.62 5,179.00 5,179.00 .00 Retirement 070-020-502-00022 7,662.23 5,626.09 8,084.00 8,084.00 .00 Workman’s Comp 070-020-502-00024 1,174.29 884.92 1,196.00 1,196.00 .00 Health Insurance 070-020-505-00025 22,358.60 15,080.80 19,718.00 19,718.00 .00 Life Insurance Amount 070-020-505-00026 50.86 29.36 55.00 55.00 .00 Postage 070-020-520-00030 91.89 13.38 100.00 100.00 .00 Office Supplies 070-020-520-00031 252.78 166.66 200.00 300.00 100.00 Operating Supplies 070-020-520-00032 586.03 1,895.83 1,000.00 1,500.00 500.00 Pro Shop Inventory 070-020-520-00035 .00 .00 .00 750.00 750.00 Licenses & Permits 070-020-520-00036 718.50 220.17 750.00 2,400.00 1,650.00 Pro-Am & Payouts 070-020-520-00037 1,270.00 .00 2,400.00 2,200.00 200.00- Items For Resale Snack Bar 070-020-521-00033 28,595.45 13,295.96 25,000.00 28,000.00 3,000.00 Minor Equipment 070-020-521-00034 4,741.02 2,846.95 2,950.00 2,400.00 550.00- Cost of Goods Sold Pro Shop 070-020-521-00035 54,293.62 44,696.11 46,000.00 46,000.00 .00 Advertising 070-020-522-00044 2,595.00 2,484.13 4,500.00 4,500.00 .00 Printing 070-020-522-00045 33.75 60.25 400.00 650.00 250.00 Liability & Property Ins 070-020-523-00046 500.00 500.00 500.00 750.00 250.00 Travel & Meetings 070-020-524-00047 .00 .00 700.00 700.00 .00 Membership 070-020-524-00048 436.00 437.00 440.00 440.00 .00 Personnel Training 070-020-524-00049 .00 .00 .00 .00 .00 Temps Contracted Service 070-020-525-00036 37,193.81 23,150.55 50,000.00 50,000.00 .00 Professional Service 070-020-525-00042 750.00 750.00 600.00 750.00 150.00 Network and Computer Support 070-020-525-00045 1,500.00 1,500.00 1,500.00 1,500.00 .00 Cleaning Service 070-020-525-00050 350.00 .00 1,000.00 1,000.00 .00 Software Maintenance & Support 070-020-525-00063 3,396.00 3,099.00 3,700.00 4,400.00 700.00 Contracted Service 070-020-525-00067 .00 .00 .00 .00 .00 Telephone 070-020-526-00051 744.00 558.00 550.00 600.00 50.00 Utilities 070-020-526-00052 7,212.32 4,457.36 10,000.00 10,000.00 .00 Maint Grounds 070-020-528-00059 .00 .00 .00 .00 .00 Maint Bldg 070-020-528-00060 202.29 867.44 6,000.00 2,000.00 4,000.00- Maint Other Equipment 070-020-529-00062 1,021.00 841.00 200.00 200.00 .00 Bank Service Charge 070-020-530-00065 15,099.24 8,716.26 10,000.00 15,000.00 5,000.00 Sales Tax 070-020-530-00089 3,562.86 16,812.51 6,780.00 6,600.00 180.00- Administration Service 070-020-530-00091 1,399.92 1,049.94 1,400.00 1,400.00 .00 Depreciation 070-020-530-00098 11,453.53 .00 .00 .00 .00 Interest Expense 070-020-580-00050 .00 .00 .00 .00 .00 Miscellaneous 070-020-580-00069 .00 .00 .00 .00 .00 Office Equipment 070-020-580-00074 .00 .00 .00 .00 .00 Golf Carts 070-020-580-00076 .00 .00 .00 26,000.00 26,000.00 Other Improvements 070-020-584-00073 .00 .00 .00 .00 .00 Construction 070-020-584-00079 105,660.22 5,753.83 .00 .00 .00 Debt/Lease Payments 070-020-590-00001 20,113.77 .00 46,125.00 .00 46,125.00- Total Golf Pro Shop: 403,965.81 207,738.12 324,731.00 312,076.00 12,655.00- Golf Fund Revenue Total: 825,859.34- 475,019.81- 700,280.00- 680,100.00- 20,180.00 Golf Fund Expenditure Total: 769,066.05 450,593.78 700,280.00 680,100.00 20,180.00- Total Golf Fund: 56,793.29- 24,426.03- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 52 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Grant Fund Grants Community Dev Block Grant 080-010-010-00001 .00 50,000.00- 1,000,000.00- 1,000,000.00- .00 Federal Grant 080-010-010-00002 .00 .00 .00 2,276,146.00- 2,276,146.00- Grant-Misc Revenue 080-010-010-00005 .00 344,692.00- 50,000.00- 50,000.00- .00 LHTAC Sidewalk Grant 080-010-010-00006 .00 .00 .00 .00 .00 State Grant Revenue 080-010-010-00010 184,820.00 .00 500,000.00- 500,000.00- .00 State Waterway Grant 080-010-010-00016 .00 .00 .00 .00 .00 Tree Grant 080-010-010-00017 .00 .00 1,500.00- 1,500.00- .00 Misc contributions 080-010-010-00018 .00 69,594.41- .00 .00 .00 City/County Matching Funds 080-010-010-00020 .00 .00 .00 .00 .00 Senion Center CDBG 080-010-010-00023 .00 .00 150,000.00- 150,000.00- .00 Weatherization Cash 080-010-010-00024 .00 .00 .00 .00 .00 Chamber Of Commerce Office Fnd 080-010-010-00029 .00 .00 .00 .00 .00 Boat Dock Grant 080-010-010-00031 .00 .00 .00 .00 .00 Tennis Courts-Donations 080-010-010-00100 .00 .00 .00 .00 .00 Walking Path Construction 080-010-010-00110 .00 .00 .00 .00 .00 Federal Grant-Homeland Securit 080-010-010-00200 .00 .00 100,000.00- 100,000.00- .00 RV Park 080-010-010-00300 .00 .00 300,000.00- 300,000.00- .00 Fire Department Grants 080-010-010-00312 .00 325.83- .00 .00 .00 Grants Revenue Revenue Total: 184,820.00 464,612.24- 2,101,500.00- 4,377,646.00- 2,276,146.00- Total Grants Revenue: 184,820.00 464,612.24- 2,101,500.00- 4,377,646.00- 2,276,146.00- Total Grants: 184,820.00 464,612.24- 2,101,500.00- 4,377,646.00- 2,276,146.00- ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 53 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Grants Professional Service 080-010-525-00042 2,000.00 2,000.00 25,000.00 25,000.00 .00 Senior Center CDBG 080-010-525-00043 .00 .00 150,000.00 150,000.00 .00 RV Park Grant Expenses 080-010-580-00076 .00 .00 300,000.00 300,000.00 .00 Fire Station Grant Expense 080-010-580-00100 456.63 .00 110,000.00 110,000.00 .00 LHTAC Sidewalk Grant 080-010-580-00101 .00 .00 .00 .00 .00 Tennis Courts 080-010-584-00050 .00 .00 .00 .00 .00 Walking Path 080-010-584-00070 .00 .00 .00 .00 .00 New Park Development-west 080-010-584-00071 .00 .00 .00 .00 .00 Gem Grants 080-010-584-00072 .00 .00 .00 .00 .00 Other Improvements 080-010-584-00073 75,698.00 60.31 .00 .00 .00 Other Improvements Broadband 080-010-584-00074 .00 .00 .00 2,276,146.00 2,276,146.00 Other Improvements-Boat Docks 080-010-584-00075 .00 .00 .00 .00 .00 Other improvements-Tree Grant 080-010-584-00076 .00 .00 1,500.00 1,500.00 .00 Bedke Blvd. Park 2010 080-010-584-00077 .00 .00 .00 .00 .00 Construction 080-010-584-00079 .00 .00 1,515,000.00 1,515,000.00 .00 Construction - Gossners 080-010-584-00080 .00 .00 .00 .00 .00 Construction-Handicap ramps 080-010-584-00081 .00 .00 .00 .00 .00 Walking Path Construction 080-010-584-00082 .00 .00 .00 .00 .00 RV 080-010-584-00083 .00 .00 .00 .00 .00 Construction-Riverview Apts 080-010-584-00090 .00 .00 .00 .00 .00 CDBG- Pickett Equipment 080-010-584-00100 .00 .00 .00 .00 .00 McCains 2018 080-010-584-00111 60.35 .00 .00 .00 .00 Construction-Fairfield Inn 080-010-584-00150 .00 .00 .00 .00 .00 Construction 080-010-584-00170 344,692.00 .00 .00 .00 .00 Construction-Renova 080-010-584-00180 .00 .00 .00 .00 .00 Gem State Processing Grant 080-010-584-00190 .00 .00 .00 .00 .00 Fabri-Kal 080-010-584-00200 .00 .00 .00 .00 .00 DOT RDBG 080-010-584-00250 .00 .00 .00 .00 .00 ICBG High Desert 080-010-584-00300 .00 .00 .00 .00 .00 Bathroom 2008 080-010-584-02008 .00 .00 .00 .00 .00 Property Acquisition 080-010-584-10000 .00 .00 .00 .00 .00 Total Grants: 422,906.98 2,060.31 2,101,500.00 4,377,646.00 2,276,146.00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 54 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Broadband Grant Bradband Grant Reimbursement 080-020-010-00001 1,000,000.00- .00 .00 .00 .00 Source: 010 Revenue Total: 1,000,000.00- .00 .00 .00 .00 Total Source: 010: 1,000,000.00- .00 .00 .00 .00 Total Broadband Grant: 1,000,000.00- .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 55 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Broadband Grant Broadband Water Equipment 080-020-525-00001 .00 .00 .00 .00 .00 Broadband Wastewater Equipment 080-020-525-00002 20.00- .00 .00 .00 .00 Broadband Electric Equipment 080-020-525-00003 .00 .00 .00 .00 .00 Credited Expenses from ETS 080-020-525-00004 15,150.00 .00 .00 .00 .00 Broadband Equipment General 080-020-525-00005 473,521.19 .00 .00 .00 .00 Broadband Grant All Other 080-020-525-00006 381,087.14 .00 .00 .00 .00 Total Broadband Grant: 869,738.33 .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 56 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Airport Grant Revenues FAA Grant 080-033-010-00010 .00 .00 450,000.00- 450,000.00- .00 State Airport Grant 080-033-010-00014 .00 .00 45,000.00- 45,000.00- .00 Local Match 080-033-010-00015 .00 .00 45,000.00- 45,000.00- .00 Local Grant Match -Cash 080-033-010-00095 .00 .00 .00 .00 .00 Source: 010 Revenue Total: .00 .00 540,000.00- 540,000.00- .00 Total Source: 010: .00 .00 540,000.00- 540,000.00- .00 Total Airport Grant Revenues: .00 .00 540,000.00- 540,000.00- .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 57 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Airport Grant Expenditures Professional Service 080-330-525-00042 .00 .00 540,000.00 540,000.00 .00 Travel & Training 080-330-525-00047 .00 .00 .00 .00 .00 Construction 080-330-584-00079 .00 .00 .00 .00 .00 Total Airport Grant Expenditures: .00 .00 540,000.00 540,000.00 .00 Grant Fund Revenue Total: 815,180.00- 464,612.24- 2,641,500.00- 4,917,646.00- 2,276,146.00- Grant Fund Expenditure Total: 1,292,645.31 2,060.31 2,641,500.00 4,917,646.00 2,276,146.00 Total Grant Fund: 477,465.31 462,551.93- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 58 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Health Insurance Int Serv Fund Health Insurance - ISF Health Ins. From Other Funds 110-010-080-00001 1,569,922.49- 1,004,836.58- 1,725,990.00- 1,725,990.00- .00 Life Ins. Pre From Other Fund 110-010-080-00002 3,853.11- 2,176.31- 4,000.00- 4,000.00- .00 Misc. Revenue 110-010-080-00005 1,008.40- .00 500.00- 500.00- .00 Employee Premiums 110-010-080-00010 .00 .00 .00 .00 .00 Interest Earned 110-010-080-00071 .00 .00 .00 .00 .00 Insurance From Oth Fnd Revenue Revenue Total: 1,574,784.00- 1,007,012.89- 1,730,490.00- 1,730,490.00- .00 Total Insurance From Oth Fnd Revenue: 1,574,784.00- 1,007,012.89- 1,730,490.00- 1,730,490.00- .00 Total Health Insurance - ISF: 1,574,784.00- 1,007,012.89- 1,730,490.00- 1,730,490.00- .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 59 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Health Insurance - ISF Contracted Service-Admin Charg 110-010-523-00067 .00 .00 .00 .00 .00 Medical Claim Costs 110-010-523-10000 1,429,564.96 1,257,850.62 1,680,980.00 1,680,980.00 .00 Life Insurance Premium 110-010-523-20000 3,710.65 2,287.09 3,500.00 3,500.00 .00 Stop Loss Insurance 110-010-523-30000 .00 .00 .00 .00 .00 Travel & Meetings 110-010-524-00047 .00 838.36 5,000.00 5,000.00 .00 Wellness Benefit Program 110-010-524-10002 12,144.48 19,447.29 41,010.00 41,010.00 .00 Interfund Transfers 110-010-530-00068 .00 .00 .00 .00 .00 Total Health Insurance - ISF: 1,445,420.09 1,280,423.36 1,730,490.00 1,730,490.00 .00 Health Insurance Int Serv Fund Revenue Total: 1,574,784.00- 1,007,012.89- 1,730,490.00- 1,730,490.00- .00 Health Insurance Int Serv Fund Expenditure Total: 1,445,420.09 1,280,423.36 1,730,490.00 1,730,490.00 .00 Total Health Insurance Int Serv Fund: 129,363.91- 273,410.47 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 60 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Liability Internal Service Fnd Liability - ISF Liability Ins. From Other Fund 120-010-080-00001 159,394.00- 156,027.00- 163,716.00- 163,716.00- .00 MISC. REVENUE 120-010-080-00005 29,603.71- .00 10,627.00- 10,627.00- .00 Interest Earned 120-010-080-00071 .00 .00 .00 .00 .00 Liability Ins Oth Fund Revenue Revenue Total: 188,997.71- 156,027.00- 174,343.00- 174,343.00- .00 Total Liability Ins Oth Fund Revenue: 188,997.71- 156,027.00- 174,343.00- 174,343.00- .00 Total Liability - ISF: 188,997.71- 156,027.00- 174,343.00- 174,343.00- .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 61 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Liability - ISF Operating Supplies 120-010-520-00032 .00 500.00 200.00 200.00 .00 Liability Ins. Premium 120-010-523-00046 162,853.00 172,835.00 159,388.00 159,388.00 .00 Liability Claim Costs 120-010-523-10000 37,676.82 1,500.00 4,000.00 4,000.00 .00 Property Ins. Premium 120-010-523-40000 .00 .00 .00 .00 .00 Personnel Safety Training 120-010-524-00049 .00 .00 10,755.00 10,755.00 .00 Interfund Transfers 120-010-530-00068 .00 .00 .00 .00 .00 Total Liability - ISF: 200,529.82 174,835.00 174,343.00 174,343.00 .00 Liability Internal Service Fnd Revenue Total: 188,997.71- 156,027.00- 174,343.00- 174,343.00- .00 Liability Internal Service Fnd Expenditure Total: 200,529.82 174,835.00 174,343.00 174,343.00 .00 Total Liability Internal Service Fnd: 11,532.11 18,808.00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 62 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Workers Compensation - Int Ser Workers Compensation - ISF Workers Comp. From Other Funds 130-010-010-00001 146,605.95- 115,817.97- 149,905.00- 149,905.00- .00 Dividend Received 130-010-010-00082 .00 .00 8,000.00- 8,000.00- .00 Workers Comp ISF Revenue Revenue Total: 146,605.95- 115,817.97- 157,905.00- 157,905.00- .00 Total Workers Comp ISF Revenue: 146,605.95- 115,817.97- 157,905.00- 157,905.00- .00 Interest Earned 130-010-080-00071 .00 .00 .00 .00 .00 W/Comp From Other Fund Revenue Revenue Total: .00 .00 .00 .00 .00 Total W/Comp From Other Fund Revenue: .00 .00 .00 .00 .00 Total Workers Compensation - ISF: 146,605.95- 115,817.97- 157,905.00- 157,905.00- .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 63 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Workers Compensation - ISF Reserved For Future Claims 130-010-524-00040 .00 .00 .00 .00 .00 Travel & Meetings 130-010-524-00047 .00 .00 1,000.00 1,000.00 .00 Personnel Training 130-010-524-00049 .00 .00 5,000.00 5,000.00 .00 Safety Equipment 130-010-524-00050 .00 .00 2,000.00 2,000.00 .00 Interfund Transfers 130-010-530-00068 .00 .00 .00 .00 .00 Workers Comp Premium 130-010-532-10000 120,928.00 88,610.83 149,905.00 149,905.00 .00 Unemployment Claims 130-010-532-10100 .00 2,245.90 .00 .00 .00 Total Workers Compensation - ISF: 120,928.00 90,856.73 157,905.00 157,905.00 .00 Workers Compensation - Int Ser Revenue Total: 146,605.95- 115,817.97- 157,905.00- 157,905.00- .00 Workers Compensation - Int Ser Expenditure Total: 120,928.00 90,856.73 157,905.00 157,905.00 .00 Total Workers Compensation - Int Ser: 25,677.95- 24,961.24- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 64 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Automation & Communication Income: 010 Interdepartmental Charges 140-010-010-00001 139,124.40- 136,566.00- 135,000.00- 135,000.00- .00 External Charges 140-010-010-00002 .00 .00 .00 .00 .00 Misc. Revenue 140-010-010-00005 572.83- .00 .00 .00 .00 Heyburn It Payment 140-010-010-00006 10,800.00- 8,100.00- 10,800.00- 10,800.00- .00 Interest Earnings 140-010-010-00071 .00 .00 .00 .00 .00 Source: 010 Revenue Total: 150,497.23- 144,666.00- 145,800.00- 145,800.00- .00 Total Source: 010: 150,497.23- 144,666.00- 145,800.00- 145,800.00- .00 Total Income: 010: 150,497.23- 144,666.00- 145,800.00- 145,800.00- .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 65 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Department: 010 Operating Supplies 140-010-520-00032 14,950.00 5,000.00 5,000.00 5,000.00 .00 Internet Service 140-010-520-00035 47,279.01 21,781.29 25,000.00 25,000.00 .00 Office Software Subscriptions 140-010-520-00040 3,468.20 .00 5,000.00 5,000.00 .00 Minor Equipment 140-010-521-00034 6,975.15 .00 2,500.00 2,500.00 .00 Air Fiber Planning 140-010-525-00040 .00 .00 .00 .00 .00 Professional Service 140-010-525-00042 16,053.10 71,480.59 36,000.00 36,000.00 .00 Phone Service 140-010-525-00045 13,015.00 10,222.54 13,000.00 13,000.00 .00 Doors and Cameras Maintenance 140-010-528-00060 .00 .00 22,680.00 22,680.00 .00 Depreciation 140-010-530-00098 .00 .00 36,620.00 36,620.00 .00 Other Improvements 140-010-584-00073 .00 .00 .00 .00 .00 Total Department: 010: 101,740.46 108,484.42 145,800.00 145,800.00 .00 Automation & Communication Revenue Total: 150,497.23- 144,666.00- 145,800.00- 145,800.00- .00 Automation & Communication Expenditure Total: 101,740.46 108,484.42 145,800.00 145,800.00 .00 Total Automation & Communication: 48,756.77- 36,181.58- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 66 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Fuel Services Fund Income: 010 Internal Fuel Charges 150-010-010-00001 185,841.09- 179,058.82- 210,000.00- 210,000.00- .00 Proceeds From Loan 150-010-010-00090 .00 .00 .00 .00 .00 Source: 010 Revenue Total: 185,841.09- 179,058.82- 210,000.00- 210,000.00- .00 Total Source: 010: 185,841.09- 179,058.82- 210,000.00- 210,000.00- .00 Total Income: 010: 185,841.09- 179,058.82- 210,000.00- 210,000.00- .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 67 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Department: 010 Software Maintenance & Support 150-010-525-00045 .00 .00 3,000.00 3,000.00 .00 Fuel Station Maintenance 150-010-528-00061 .00 .00 5,000.00 5,000.00 .00 Fuel and Oil Purchase 150-010-529-00035 73,332.31 59,260.13 202,000.00 202,000.00 .00 Consrtuction 150-010-584-00079 64,648.41 79,377.72 .00 .00 .00 Debt and Lease Payments 150-010-590-00001 .00 .00 .00 .00 .00 Total Department: 010: 137,980.72 138,637.85 210,000.00 210,000.00 .00 Fuel Services Fund Revenue Total: 185,841.09- 179,058.82- 210,000.00- 210,000.00- .00 Fuel Services Fund Expenditure Total: 137,980.72 138,637.85 210,000.00 210,000.00 .00 Total Fuel Services Fund: 47,860.37- 40,420.97- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 68 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Fund: 160 Income: 010 Charges to Departments 160-010-010-00001 .00 .00 .00 .00 .00 Source: 010 Revenue Total: .00 .00 .00 .00 .00 Total Source: 010: .00 .00 .00 .00 .00 Total Income: 010: .00 .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 69 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Department: 010 New Construction 160-010-584-00079 .00 .00 .00 .00 .00 Equipment Purchases 160-010-584-10000 .00 .00 .00 .00 .00 Land Acquisition 160-010-584-11000 .00 .00 .00 .00 .00 Total Department: 010: .00 .00 .00 .00 .00 Fund: 160 Revenue Total: .00 .00 .00 .00 .00 Fund: 160 Expenditure Total: .00 .00 .00 .00 .00 Total Fund: 160: .00 .00 .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 70 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Local Improvement Districts L.I.D. Revenues LID-Assessments 200-010-010-00001 .00 .00 50,000.00- 50,000.00- .00 Misc Revenue 200-010-010-00005 2,800.00- .00 .00 .00 .00 Interest Earned 200-010-010-00071 147.77- .00 .00 .00 .00 Loan /Bond Proceeds 200-010-010-00090 7,437.23- 93,072.00- 50,000.00- 50,000.00- .00 L.I.D. Revenues Revenue Total: 10,385.00- 93,072.00- 100,000.00- 100,000.00- .00 Total L.I.D. Revenues: 10,385.00- 93,072.00- 100,000.00- 100,000.00- .00 Total L.I.D. Revenues: 10,385.00- 93,072.00- 100,000.00- 100,000.00- .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 71 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget L.I.D. Revenues Bad Debts 200-010-530-00066 2,251.07 .00 .00 .00 .00 Construction 200-010-584-00079 .00 .00 50,000.00 50,000.00 .00 Debt & Lease Payments 200-010-590-00001 .00 .00 50,000.00 50,000.00 .00 Interest Expense 200-010-590-00005 .00 .00 .00 .00 .00 Total L.I.D. Revenues: 2,251.07 .00 100,000.00 100,000.00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 72 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget North Burton LID LID-Assessments 200-020-020-00001 .00 .00 .00 .00 .00 Interest Earned #2 200-020-020-00071 1,360.40- 937.20- .00 .00 .00 Loan / Bond Proceeds-L.I.D.#2 200-020-020-00090 8,000.13- 1,881.30- .00 .00 .00 Loan/Bond Proceeds- LID #3 200-020-020-00100 6,560.85- 1,098.38- .00 .00 .00 LID Int #3 200-020-020-00101 528.13- 318.13- .00 .00 .00 Loan/Bond Proceeds LID #4 200-020-020-00110 993.37- 5,815.01- .00 .00 .00 LID Int #4 200-020-020-00111 1,149.70- 619.76- .00 .00 .00 Loan/Bond Proceeds-LID #5 Prin 200-020-020-00120 .00 .00 .00 .00 .00 LID Int #5 200-020-020-00121 .00 .00 .00 .00 .00 Transfer from General 200-020-020-01010 .00 .00 .00 .00 .00 North Burton LID Revenue Total: 18,592.58- 10,669.78- .00 .00 .00 Total North Burton LID: 18,592.58- 10,669.78- .00 .00 .00 Total North Burton LID: 18,592.58- 10,669.78- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 73 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget North Burton LID Construction 200-020-584-00079 .00 .00 .00 .00 .00 Construction Sidewalk LID 200-020-584-00080 .00 .00 .00 .00 .00 Debt & Lease Payments 200-020-590-00001 18,743.56 8,801.61 .00 .00 .00 Loan or Bond Payments 200-020-590-00090 .00 .00 .00 .00 .00 Assessment Shortfall 200-020-590-00091 .00 .00 .00 .00 .00 Total North Burton LID: 18,743.56 8,801.61 .00 .00 .00 Local Improvement Districts Revenue Total: 28,977.58- 103,741.78- 100,000.00- 100,000.00- .00 Local Improvement Districts Expenditure Total: 20,994.63 8,801.61 100,000.00 100,000.00 .00 Total Local Improvement Districts: 7,982.95- 94,940.17- .00 .00 .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 74 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget TRUST & AGENCY Income: 010 Donations 900-010-020-00001 240.00- .00 .00 .00 .00 Donation-North Park 900-010-020-00002 .00 .00 .00 .00 .00 Donation-BAAT Beautification 900-010-020-00003 .00 .00 .00 .00 .00 Donation for Kunau Park 900-010-020-00004 .00 .00 .00 .00 .00 Donations-Christmas Decoration 900-010-020-00005 .00 .00 .00 .00 .00 Donations - Kids Fishing Pond 900-010-020-00006 230.00- 14.00- 20,000.00- 20,000.00- .00 Donations-Library Fund 900-010-020-00007 .00 .00 .00 .00 .00 Donations for Arbor Day 900-010-020-00008 .00 .00 .00 .00 .00 B.A.A.T. Donations-Pride Day 900-010-020-00009 .00 .00 .00 .00 .00 Donation-Operation Facelift 900-010-020-00010 .00 .00 .00 .00 .00 Donations Botanical Garden 900-010-020-00011 .00 .00 .00 .00 .00 Tennis Court Wind Screens 900-010-020-00012 .00 .00 .00 .00 .00 Donations-Animal Shelter 900-010-020-00013 476.00- .00 35,000.00- 35,000.00- .00 Source: 020 Revenue Total: 946.00- 14.00- 55,000.00- 55,000.00- .00 Total Source: 020: 946.00- 14.00- 55,000.00- 55,000.00- .00 Total Income: 010: 946.00- 14.00- 55,000.00- 55,000.00- .00 ---PAGE BREAK--- City of Burley Budget Worksheet - Recommended with current budget, YTD and Prior year Actuals Page: 75 Period: 14/22 Jul 29, 2022 03:34PM 2020-21 2021-22 2021-22 2022-23 Calculated Prior year Current year Current year Recommended Budget Account Title Account Number Actual Actual Budget Department: 010 Professional Service 900-010-525-00042 .00 .00 .00 .00 .00 Other Improvements 900-010-584-00073 579.41 5,304.96 55,000.00 55,000.00 .00 Total Department: 010: 579.41 5,304.96 55,000.00 55,000.00 .00 TRUST & AGENCY Revenue Total: 946.00- 14.00- 55,000.00- 55,000.00- .00 TRUST & AGENCY Expenditure Total: 579.41 5,304.96 55,000.00 55,000.00 .00 Total TRUST & AGENCY: 366.59- 5,290.96 .00 .00 .00