Back to the archive
Public document · Taxes & Budgets

TOWN OF SMITHS FALLS Page 4 2023 BUDGET

Public source material preserved in the Field Guide. Consult the original for authoritative wording and current status.

Source text

TOWN OF SMITHS FALLS Page 1 2023 FINAL OPERATIONAL BUDGET "DEPARTMENTAL SUMMARY"

INDEPENDENT BOARDS

Passed February 21, 2023
ACCOUNT/DESCRIPTIONBudgetActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.Variance from Prior Year ($$) from Prior Year (%)
Mayor & Council Community Programs281,704208,129-73,575272,908000#DIV/0!
Mayor & Council Community Programs355,223328,276-26,947332,807000#DIV/0!
TOTAL MAYOR & COUNCIL636,927536,405-100,522605,715000#DIV/0!-31,212
POLICE SERVICE
Capital Operations00000000
Capital Operations5,075,5244,340,399-735,1255,226,780000#DIV/0!
TOTAL POLICE SERVICE5,075,5244,340,399735,1255,226,780000#DIV/0!151,256
LIBRARY SERVICE
Capital Operations0000000#DIV/0!
Capital Operations491,525415,835-75,690521,742000#DIV/0!
TOTAL LIBRARY SERVICE491,525415,835-75,690521,742000#DIV/0!30,217
AIRPORT COMMISSION
Capital Operations0000000#DIV/0!
Capital Operations33,71331,156-2,55736,202000#DIV/0!
TOTAL AIRPORT COMMISSION33,71331,156-2,55736,202000#DIV/0!2,489

TOWN OF SMITHS FALLS Page 2 2023 BUDGET

DEPARTMENTAL SUMMARY

Passed February 21, 202320222022202320232023%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.
FIRE SERVICES
Capital Operations0000000#DIV/0!
Capital Operations1,067,4161,129,73462,3181,147,4920000.0%
TOTAL FIRE SERVICE1,067,4161,129,73462,3181,147,492000#DIV/0!
ADMINISTRATION
TOTAL ADMINISTRATION343,369273,500-69,869365,852000 #DIV/0!
COUNTY SHARED SERVICES
TOTAL COUNTY SHARED SERVICES2,322,1361,945,511-376,6252,596,536000 #DIV/0!
PARKS
Capital000000#DIV/0!
Operations404,526394,138-10,388509,633000 #DIV/0!
TOTAL PARKS404,526394,138-10,388509,633000 #DIV/0!
COMMUNITY FACILITIES
Capital000000#DIV/0!
Operations814,129813,201-928811,531000 #DIV/0!
TOTAL COMMUNITY FACILITIES814,129813,201-928811,531000 #DIV/0!

TOWN OF SMITHS FALLS Page 3 2023 BUDGET

DEPARTMENTAL SUMMARY

Passed February 21, 2023
2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.
ACCOUNT/DESCRIPTION

COMMUNITY SERVICES (Continued)

HILLCREST CEMETERY
Capital Operations0 79,2940 1,6140 -77,6800 30,7180 00 00 0#DIV/0! #DIV/0!
TOTAL HILLCREST CEMETERY79,2941,614-77,68030,718000#DIV/0!
CHILD DEVELOPMENT CENTRE
Capital Operations0 217,1730 123,9240 -93,2490 222,3150 00 00 0#DIV/0! 0.0%
TOTAL CDC217,173123,924-93,249222,315000#DIV/0!

TOWN OF SMITHS FALLS Page 4 2023 BUDGET

TOWN OF SMITHS FALLS Page 4

DEPARTMENTAL SUMMARY

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.
WATER TREATMENT PLANT
Capital Operations (now includes "I transfer to Capital Budget")0000000#DIV/0!
Capital Operations (now includes "I transfer to Capital Budget")-231,296156,760388,056-352,3010000.0%
TOTAL WTP-231,296156,760388,056-352,301000#DIV/0!-121,005
WATER POLLUTION CONTROL PLANT
Capital Operations (Now includes "Transfer to Capital Budget")00000000
Capital Operations (Now includes "Transfer to Capital Budget")40,82539,204-1,622-101,7470000.0%
TOTAL WPCP40,82539,204-1,622-101,747000#DIV/0!-142,572
PUBLIC WORKS & UTILITIES
Capital Operations00000000
Capital Operations2,641,3062,314,221-327,0853,128,236000#DIV/0!
TOTAL WORKS & UTILITIES2,641,3062,314,221-327,0853,128,236000#DIV/0!486,930
WATER DISTRIBUTION
Capital Operations0000000#DIV/0!
Capital Operations727,429764,36436,935989,3920000.0%
TOTAL WATER DISTRIBUTION727,429764,36436,935989,392000#DIV/0!261,963

TOWN OF SMITHS FALLS Page 5

DEPARTMENTAL SUMMARY

Passed February 21, 2023
2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.
ACCOUNT/DESCRIPTION
CORPORATE SERVICES; ADMINISTRATION
Capital Operations0000000#DIV/0!
Capital Operations1,148,7331,026,780-121,9531,447,0890000.0%
TOTAL ADMINISTRATIVE SERVICES1,148,7331,026,780-121,9531,447,089000#DIV/0!
INFORMATION TECHNOLOGY
Capital Operations0000000#DIV/0!
Capital Operations240,569145,718-94,851365,384000#DIV/0!
TOTAL INFORMATION TECHNOLOGY240,569145,718-94,851365,384000#DIV/0!
298,35626.0%
124,81551.9%

TOWN OF SMITHS FALLS Page 6 2023 BUDGET

DEPARTMENTAL SUMMARY

Passed February 21, 20232022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.

PLANNING & SUSTAINABLE DEVELOPMENT

PLANNING SERVICES
Operational336,120223,277-112,843494,8660000.0%
BUILDING SERVICES DEPARTMENT
Operational00000000
BY-LAW ENFORCEMENT
Capital0000000#DIV/0!
Operations332,755184,466-148,289343,9580000.0%
TOTAL BY-LAW ENFORCEMENT332,755184,466-148,289343,958000#DIV/0!
ENVIRONMENTAL SERVICES
Capital0000000#DIV/0!
Operations992,620898,868-93,7521,146,3570000.0%
TOTAL ENVIRONMENTAL SERVICES992,620898,868-93,7521,146,357000#DIV/0!
CategoryValueShare (%)
unlabelled 115874647.2
unlabelled 20
unlabelled 3112033.4
unlabelled 415373715.5

TOWN OF SMITHS FALLS Page 7 2023 BUDGET

DEPARTMENTAL SUMMARY

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.
ECONOMIC DEVELOPMENT
Capital Operations0000000#DIV/0!
Capital Operations503,806348,321-155,485554,856000#DIV/0!
TOTAL COMMUNITY DEVELOPMENT503,806348,321-155,485554,856000#DIV/0!
TOURISM
Operations132,49174,716-57,775157,0000000
HISTORICAL SERVICES
Capital Operations0000000#DIV/0!
Capital Operations118,31772,042-46,275150,3590000.0%
TOTAL HISTORICAL SERVICES118,31772,042-46,275150,359000#DIV/0!
DOWNTOWN BUSINESS ASSOCIATION
Operations0000000#DIV/0!

TOWN OF SMITHS FALLS Page 8 2023 BUDGET

TOWN OF SMITHS FALLS Page 8

DEPARTMENTAL SUMMARY

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.
TOTAL CAPITAL BUDGET0000000
TOTAL GENERAL BUDGET18,469,40716,254,153-2,215,25420,397,965000#DIV/0!1,928,558
PRIOR YEAR DEFICIT/SURPLUS0000000
TOTAL BUDGET18,469,40716,254,153-2,215,25420,397,965000#DIV/0!1,928,558
FINANCE - TOTAL REVENUE-20,309,204-20,416,289-107,085-22,136,5980000-1,827,394
DEFICIT/SURPLUS-1,839,797-4,162,136-2,322,339-1,738,633000#DIV/0!
TRANSFER TO RESERVE (TAX-SUPPORTED) *1,839,7971,839,79701,738,633000-101,164
NET BALANCE0000000

10.4% 10.4% 9.0% -5.5%


TOWN OF SMITHS FALLS Page 9 2023 FINAL OPERATIONAL BUDGET

TOWN OF SMITHS FALLS Page 9

Passed February 21, 2023 GENERAL BUDGET

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ADMINISTRATION
6088-02-11-101-000 Honorarium157,020136,484-20,536159,9960#DIV/0!
6091-02-11-101-000 Other Payroll Costs9,9848,490-1,49410,2120#DIV/0!
6015-02-11-101-000 Travel Expense5,0001,318-3,6825,0000#DIV/0!
6032-02-11-101-000 Conferences/Training & Dev.10,0002,910-7,09015,0000#DIV/0!
6025-02-11-101-000 Transfer to/from reserve-74,810-34,74240,06800#DIV/0!
6102-02-11-101-000 Council Technology (Incl of Cell Phones & Ipads) *10,0007,406-2,5942,0000#DIV/0!
5908-02-11-101-020 Integrity Commissioner Applications-3000300-3000#DIV/0!
6180-02-11-101-000 Professional Fees5,000305-4,6955,0000#DIV/0!
6029-02-11-101-000 Memberships12,0008,185-3,81512,0000#DIV/0!
6034-02-11-101-000 Election Expense74,81031,242-43,56810,0000#DIV/0!
6863-02-11-101-000 Meeting Management60,00039,339-20,66140,0000#DIV/0!
6037-02-11-101-000 Mayor & Council Public Relations5,0007,1922,1925,0000#DIV/0!
6050-02-11-101-000 Employee Recognition8,0000-8,0009,0000#DIV/0!
TOTAL MAYOR & COUNCIL281,704208,129-73,575272,9080000#DIV/0!
  • New tech will be ordered for new elected officials

** Escribe software fees for livestreaming (3/week)


TOWN OF SMITHS FALLS Page 10 2023 FINAL OPERATIONAL BUDGET COMMUNITY PROGRAMS/DONATIONS

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
COMMUNITY PROGRAMS/DONATIONS
02-21-250-397-6202 Furry Tales Cat Rescue04,9994,9990#DIV/0!
6406-02-21-250-001 Youth Services (Administered by the County)15,00015,0909015,0000#DIV/0!
02-21-250-001-6797 Drug Strategy Committee2,0000-2,0002,0000#DIV/0!
02-21-250-319-6797 Lanark County Drug Strategy Committee0000#DIV/0!
02-21-250-001-6798 Arts & Culture Council ***0000#DIV/0!
02-21-250-446-6202 Cornerstone Youth Services05,0005,0000#DIV/0!
02-21-250-445-6202 The Table Community Food Centre040,00040,0000#DIV/0!
02-21-250-001-6025 Transfer to Reserve-29,481-29,48100#DIV/0!
02-21-250-001-xxxx Overall Community Donations **150,0000-150,000133,0000#DIV/0!
02-21-250-001-6664 Hospital Donation *174,341174,3410174,3410#DIV/0!
02-21-250-001-6831 Horticultural Society06006000#DIV/0!
02-21-250-294-6038 Rideau Roundtable/Rideau Paddlefest02,5702,5700#DIV/0!
02-21-250-001-6756 Lanark Transportation8,4668,46608,4660#DIV/0!
02-21-250-001-5612 Transfer From Reserve (Surplus from 2020 Comm Don; $0.00)0000#DIV/0!
02-21-250-280-6202 Rise at the Falls Car Show05,0005,0000#DIV/0!
02-21-250-279-6202 Big Brothers/Big Sisters025,00025,0000#DIV/0!
02-21-250-008-6202 Big Brothers/Big Sisters (After School Program)0000#DIV/0!
02-21-250-412-6202 Rideau Lakes Amaeur Radio Club Inc.0000#DIV/0!
02-21-250-282-6202 DBA Healthy Living Festival0000#DIV/0!
02-21-250-001-6226 SF Railway Musuem (2:1 Ratio; matching funds)023,00023,0000#DIV/0!
02-21-250-368-6202 Two Rivers Food Hub0000#DIV/0!
02-21-250-369-6202 Parkinson Canada0000#DIV/0!
02-21-250-377-6202 Service Club Co-op0-5,816-5,8160#DIV/0!
6568-02-21-250-001 REAL Grant07,5007,5000#DIV/0!
02-21-250-370-6202 Smiths Falls Crimestoppers010,00010,0000#DIV/0!
02-21-250-391-6202 Eastern Ontario Regional Network Cellular Gap & Capacity Exp Project (4 of 4 year commitment; 2019 - 2022)13,89713,89700#DIV/0!
6202-02-21-250-001 Special Events (Now under Tourism)21,00028,1107,1100#DIV/0!
TOTAL PROGRAMS355,223328,276-26,947332,8070000#DIV/0!

** Based on 1% of taxation revenue - reduced at Jan 30 COW

  • Requires Council's Direction - approved Jan 9 COW


TOWN OF SMITHS FALLS Page 11 2023 FINAL OPERATIONAL BUDGET INDEPENDENT BOARDS

ACCOUNT/DESCRIPTION

Passed February 21, 2023
2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
POLICE SERVICES
6235-01-21-221-000 Police Cruisers58,00054,187-3,8130#DIV/0!#DIV/0!
01-21-221-000-6462 Firewall Upgrade0000#DIV/0!#DIV/0!
01-21-221-000-5612 Transfer from Reserve (PCO)-75,000-17,41357,5870#DIV/0!#DIV/0!
01-21-221-000-6717 Phone System Upgrade25,00017,413-7,5870#DIV/0!#DIV/0!
01-21-221-309-5612 Trsf from Capital Reserve (Acct 2083)-83,000-54,18728,8130#DIV/0!#DIV/0!
01-21-221-160-6398 NG 911 System75,0000-75,0000#DIV/0!#DIV/0!
TOTAL POLICE CAPITAL BUDGET0000000#DIV/0!#DIV/0!

EMERGENCY COMMUNICATION CENTRE

6401-02-21-221-160 Annual System Maintenance20,00015,408-4,59224,0000#DIV/0!0.00%
6182-02-21-221-001 CPIC Maintenance Costs1,7000-1,7001,8000#DIV/0!0.00%
6183-02-21-221-001 OPTIC Maintenance Cost25,0002,595-22,40526,0000#DIV/0!0.00%
02-21-221-012-6714 Computer Firewall Maintenance7,0000-7,0002,0000#DIV/0!0.00%
02-21-221-297-6398 Northern 911 (3rd party services)5,0004,001-9995,5000#DIV/0!0.00%
02-21-221-160-6398 911 System Maintenance1,0000-1,0001,0000#DIV/0!0.00%
TOTAL COMMUNICATION CENTRE59,70022,004-37,69660,300000#DIV/0!0.00%
POLICE GRANTS
5430-02-21-221-020 CSP - Local Stream Grant-48,750-45,3193,431-60,893
5898-02-21-221-020 Court Security Grant-2,0002,5924,592-3,0000#DIV/0!
5430-02-21-221-450 CSP - Provincial Stream Grant0-25,486-25,486-22,2720#DIV/0!
6862-02-21-221-450 CSP - Provincial Stream Expenditures09,7759,7750#DIV/0!
6836-02-21-221-450 CSP Deferred Revenue15,71115,7110#DIV/0!
5430-21-221-444 Prov Grant (Mobile Crisis Response Team)0-101,658-101,658-6,0000#DIV/0!
6862-21-221-444 Mobile Crisis Response Team Expenditures077,44377,4430#DIV/0!
6836-21-221-444 Trsf to Def. Revenue Mobile Crisis Response Team024,21524,2150#DIV/0!
02-21-221-443-5430 Prov Grant (Victim Support)0-72,012-72,012-4,5000#DIV/0!
02-21-221-443-6836 Trsf to deferred revenue (Victim Support)01,7341,7340#DIV/0!
02-21-221-443-6862 Victim Support Expenses070,27870,2780#DIV/0!
02-21-221-389-5421 Ontario Grant (Cannabis Legalization Implementation)0000#DIV/0!
02-21-221-389-6836 (Cannbis Legalization Grant) Trsf to deferred revenue0000#DIV/0!
02-21-221-388-6862 Civil Remedies Expenses0000#DIV/0!
02-21-221-388-6836 Civil Remedies Deferred Revenue0000#DIV/0!
TOTAL COMMUNICATION CENTRE-50,750-42,7278,023-96,665000#DIV/0!

TOWN OF SMITHS FALLS Page 12

2023 BUDGET INDEPENDENT BOARDS GENERAL BUDGET (POLICE DEPT./ADMINISTRATION)

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
5513-02-21-221-020 Taxi Licenses-2,500-2,887-387-2,6000#DIV/0!0.00%
5517-02-21-221-020 Sale of Equipment-1,000-200800-1,5000#DIV/0!0.00%
5525-02-21-221-020 Accident Reports-500-150350-1000#DIV/0!0.00%
5571-02-21-221-020 CPIC Information Fees-6,000-10,236-4,236-7,0000#DIV/0!0.00%
5572-02-21-221-020 Fingerprinting Fees-500-398102-3000#DIV/0!0.00%
5572-02-21-221-273 RCMP Fingerprinting Fees-1,000-1,025-25-1,0000#DIV/0!0.00%
6836-02-21-221-273 RCMP Fingerprinting Fees (Deferred Revenue)5008503505000#DIV/0!0.00%
5578-02-21-221-020 Escort Fees-3,000-8,877-5,877-3,0000#DIV/0!0.00%
5660-02-21-221-020 Prisoner Meal Reimburse-4000400-4000#DIV/0!0.00%
6035-02-21-221-001 Regular Salaries & Wages3,167,2032,758,878-408,3253,291,3460#DIV/0!0.00%
6048-02-21-221-001 Part Time Wages95,654107,48511,831107,1970#DIV/0!0.00%
6057-02-21-221-001 Overtime95,00069,613-25,387100,0000#DIV/0!0.00%
6638-02-21-221-001 Banked Time Adjustment12,0001,192-10,80812,0000#DIV/0!0.00%
6067-02-21-221-001 Shift Premium8,00059-7,9418,0000#DIV/0!0.00%
6069-02-21-221-001 Stat Time15,00010,367-4,63320,0000#DIV/0!0.00%
6078-02-21-221-001 Vacation Pay3,9344,3494155,0000#DIV/0!0.00%
6091-02-21-221-001 Other Payroll Costs1,064,730905,808-158,9221,081,5360#DIV/0!0.00%
6048-02-21-221-413 Part-time Wages (COVID-19)024,86124,86100#DIV/0!#DIV/0!
6057-02-21-221-413 Overtime (COVID-19)018,26518,26500#DIV/0!#DIV/0!
6078-02-21-221-413 Vacation Pay (COVID-19)099299200#DIV/0!#DIV/0!
6091-02-21-221-413 Other Payroll Costs (COVID-19)07,1297,12900#DIV/0!#DIV/0!
6792-02-21-221-413 Other Expenditures (COVID-19)023823800#DIV/0!#DIV/0!
5612-02-21-221-413 Trsf from Reserve (COVID-19)0-238-23800#DIV/0!#DIV/0!
5612/6025-02-21-221-001 Trsf to/from Reserve-65,000-20,00045,000-45,0000#DIV/0!0.00%
6011-02-21-221-001 Office Supplies9,0008,204-7969,0000#DIV/0!0.00%
6015-02-21-221-001 Travel Expense14,00010,904-3,09615,0000#DIV/0!0.00%
6017-02-21-221-001 Coffee/Food Supplies50050-4505000#DIV/0!0.00%
6023-02-21-221-001 Postage1,300180-1,1205000#DIV/0!0.00%
6028-02-21-221-001 Meals Expense6,5003,352-3,1486,5000#DIV/0!0.00%
6029-02-21-221-001 Membership Fees3,5001,873-1,6273,5000#DIV/0!0.00%
6038-02-21-221-001 Advertising2,000587-1,4132,0000#DIV/0!0.00%

TOWN OF SMITHS FALLS Page 13 2023 BUDGET INDEPENDENT BOARDS GENERAL BUDGET

Passed February 21, 2023

2022 ACCOUNT/DESCRIPTION2022 Budget2022 Actual2023 Var.2023 Budget2023 To DateActual% Var.% Completed
6039-02-21-221-001 Staff Training & Develop.22,00016,091-5,90925,0000#DIV/0!
6040-02-21-221-001 Clothing & Supplies30,00016,919-13,08125,0000#DIV/0!
6041-02-21-221-001 Drycleaning5000-5005000#DIV/0!
6042-02-21-221-001 Courier1,000739-2611,0000#DIV/0!
6054-02-21-221-001 Library in Service2,0002,8158151,0000#DIV/0!
6055-02-21-221-001 Community Services3,0002,670-3304,0000#DIV/0!
6056-02-21-221-001 Firearm Training16,0004,885-11,11518,0000#DIV/0!
6102-02-21-221-001 Telephone27,00022,450-4,55030,0000#DIV/0!
6103-02-21-221-001 Fax1,5001,342-1581,5000#DIV/0!
5430-02-21-221-418 CISO Grant0-2,612-2,612-8,0000#DIV/0!
6862-02-21-221-418 CISO Grant Expenditures06,4396,4398,0000#DIV/0!
6836-02-21-221-418 Trsf to/from Deferred Revenue (CISO Grant)0-900-90000#DIV/0!
6173-02-21-221-001 Insurance35,70334,846-85741,8150#DIV/0!
02-21-221-001-6713 Special Operations (New)00000#DIV/0!
6180-02-21-221-001 Professional Fees30,0006,378-23,62230,0000#DIV/0!
6738-02-21-221-001 IT Support30,00025,203-4,79740,0000#DIV/0!
6194-02-21-221-001 Computer Lease Contract28,00011,921-16,07920,0000#DIV/0!
6474-02-21-221-001 Laptop Computer Lease Contract6,0005,471-5295,0000#DIV/0!
6027-02-21-221-001 Photocopy Lease6,0004,237-1,7636,0000#DIV/0!

TOTAL POLICE ADMINISTRATION

BUILDING MAINTENANCE
6117-02-21-221-010 Property Maintenance15,0006,474-8,52615,0000#DIV/0!0.00%
6123-02-21-221-010 Property Repairs15,0003,215-11,78515,0000#DIV/0!0.00%
02-21-221-010-6012 Principal120,406110,182-10,224125,4620#DIV/0!0.00%
02-21-221-010-6014 Interest72,46666,618-5,84867,4110#DIV/0!0.00%
02-21-221-355-6012 Principal2,7952,559-2362,8760#DIV/0!0.00%
02-21-221-355-6014 Interest1,2141,116-981,1320#DIV/0!0.00%
02-21-221-010-6105 Hydro22,00019,704-2,29625,0000#DIV/0!0.00%
02-21-221-010-6106 Water3,5002,561-9393,5000#DIV/0!0.00%
02-21-221-010-6107 Heating Fuel8,2004,766-3,4349,0000#DIV/0!0.00%
02-21-221-010-6116 Janitorial Supplies4,0001,995-2,0055,0000#DIV/0!0.00%
02-21-221-010-6197 Janitorial Services30,00023,259-6,74128,0000#DIV/0!0.00%
TOTAL BUILDING MAINTENANCE294,581242,449-52,132297,38100#DIV/0!

TOWN OF SMITHS FALLSPage 14
2023 BUDGET
INDEPENDENT BOARDS
GENERAL BUDGET
Passed February 21, 202320222022202320232023%%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.
VEHICLE MAINTENANCE
6108-02-21-221-011 Gas & Oil30,00034,3794,37935,0000#DIV/0!
6110-02-21-221-011 Repairs25,00011,337-13,66320,0000#DIV/0!
6194-02-21-211-011 Vehicle Lease Payments0000#DIV/0!
6836-02-21-211-011 Trsf from Deferred Revenue0000#DIV/0!
6118-02-21-221-011 Tools, Accessories, etc5000-5005000#DIV/0!
TOTAL VEHICLE MAINTENANCE55,50045,716-9,78455,500000#DIV/0!
EQUIPMENT MAINTENANCE
6110-02-21-221-012 Equipment Repairs10,0004,813-5,18710,0000#DIV/0!
6266-02-21-221-012 Breathalyser Repairs1,000731-2691,0000#DIV/0!
6847-02-21-221-012 Live Scan Maintenance6,0005,618-3826,0000#DIV/0!
6834-02-21-221-012 Wash Court Maintenance7,5005,565-1,9357,5000#DIV/0!
TOTAL EQUIPMENT MAINTENANCE24,50016,727-7,77324,500000#DIV/0!
IDENTIFICATION
6267-02-21-221-022 Supplies1,000376-6241,0000#DIV/0!
6112-02-21-221-022 Equipment Repairs5000-5005000#DIV/0!
TOTAL IDENTIFICATION1,500376-1,1241,500000#DIV/0!
5447-02-21-221-023 Arrive Alive Grant-9,000-8228,178-9,0000#DIV/0!
6057-02-21-221-023 Overtime9,000822-8,1789,0000#DIV/0!
6091-02-21-221-023 Other Payroll Costs500193-3075000#DIV/0!
TOTAL RIDE PROGRAM500193-307500000#DIV/0!

TOWN OF SMITHS FALLS Page 15 2023 BUDGET

INDEPENDENT BOARDS GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
POLICE SERVICES BOARD
6088-02-21-222-001 Honorarium23,2850-23,28523,7510#DIV/0!0.00%
6091-02-21-222-001 Other Payroll Costs7840-7848190#DIV/0!0.00%
6015-02-21-222-001 Travel Expense1,5000-1,5001,0000#DIV/0!0.00%
6028-02-21-222-001 Meals Expense3000-3003000#DIV/0!0.00%
6029-02-21-222-001 Membership Fees1,5001,380-1201,7000#DIV/0!0.00%
6032-02-21-222-001 Conferences2,0001,221-7791,5000#DIV/0!0.00%
6036-02-21-222-001 Public Relations3,0002,845-1554,0000#DIV/0!0.00%
6054-02-21-222-001 Library in Service096962000#DIV/0!0.00%
TOTAL POLICE COMMISSION32,3695,542-26,82733,270000#DIV/0!
TOTAL POLICE GENERAL BUDGET5,075,5244,340,399-735,1255,226,780000#DIV/0!
TOTAL POLICE SERVICES BUDGET5,075,5244,340,399-735,1255,226,780000#DIV/0!

TOWN OF SMITHS FALLS Page 16 2023 FINAL OPERATIONAL BUDGET

TOWN OF SMITHS FALLS Page 16

Passed February 21, 2023

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
SMITHS FALLS PUBLIC LIBRARY
01-21-231-000-6782 Building Renovations/Children's Dept.300,0002,127-297,8730#DIV/0!#DIV/0!
5612-01-21-231-000 Trsf from Reserve (Acct 2051/2302)-321,700-21,953299,7470#DIV/0!#DIV/0!
6392-01-21-231-000 Carpeting0000#DIV/0!#DIV/0!
01-21-231-000-6603 Air Conditioner Repairs5,00012,0847,0840#DIV/0!#DIV/0!
01-21-231-309-5612 Trsf from capital reserve (Acct 2083)0-16,588-16,5880#DIV/0!#DIV/0!
01-21-231-000-6409 Eavestrough & Fascia Repairs16,70014,826-1,8740#DIV/0!#DIV/0!
01-21-231-000-6641 Ceiling Repairs09,5049,5040#DIV/0!#DIV/0!
TOTAL CAPITAL BUDGET0000000#DIV/0!

TOWN OF SMITHS FALLS Page 17 2023 BUDGET INDEPENDENT BOARDS GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
SMITHS FALLS PUBLIC LIBRARY ADMINISTRATION
5473-02-21-231-020 Ministry of Culture Grant-20,921020,921-20,9210#DIV/0!0.00%
5521-02-21-231-020 Photocopy Charges-1,200-2,147-947-2,0000#DIV/0!0.00%
5580-02-21-231-020 Book Sales-200-209-9-1800#DIV/0!0.00%
5553-02-21-231-020 Damages Recovery-200-13763-1250#DIV/0!0.00%
5555-02-21-231-020 Library Memberships-1,100-1,930-830-1,9000#DIV/0!0.00%
5557-02-21-231-020 Donations0-6,642-6,642-1,0000#DIV/0!0.00%
5661-02-21-231-020 Interlibrary Loan Revenue-1,200-1,492-292-1,5000#DIV/0!0.00%
xxxx-02-21-231-001 Pay Equity Review Payroll Increase0009,8240#DIV/0!0.00%
5664-02-21-231-020 Audiovisual Fees0-364-364-3500#DIV/0!0.00%
5665-02-21-231-020 Genealogical Services500-50-500#DIV/0!0.00%
5711-02-21-231-020 Montague Township Fees-14,470-14,750-280-14,7500#DIV/0!0.00%
6792-02-21-231-413 COVID-19 Expenditures064164100#DIV/0!#DIV/0!
5612-02-21-231-001 Transfer from Reserve (Account 2050)000-9,8240#DIV/0!0.00%
6035-02-21-231-001 Regular Salaries & Wages188,035163,546-24,489186,1100#DIV/0!0.00%
6048-02-21-231-001 Part time Wages99,93792,119-7,818114,6890#DIV/0!0.00%
6078-02-21-231-001 Vacation Pay4,7003,949-7514,5880#DIV/0!0.00%
6091-02-21-231-001 Other Payroll Costs78,16663,463-14,70387,5890#DIV/0!0.00%
6011-02-21-231-001 Office Supplies5,5001,836-3,6643,5000#DIV/0!0.00%
6324-02-21-231-001 Minor Furniture Supplies "New"2,0000#DIV/0!0.00%
6019-02-21-231-001 Photocopy Supplies2,5001,715-7852,5000#DIV/0!0.00%
6023-02-21-231-001 Postage5006201205000#DIV/0!0.00%
6029-02-21-231-001 Membership Fees1,200237-9636000#DIV/0!0.00%
6029-02-21-231-001 Membership Fees1,5001,522222,0000#DIV/0!0.00%
6039-02-21-231-001 Staff Training & Develop.800105-6952,5000#DIV/0!0.00%
6102-02-21-231-001 Telephone2,6001,932-6682,6000#DIV/0!0.00%
601102-21-231-454 Library Board expenses "New"0008000#DIV/0!0.00%
6173-02-21-231-001 Insurance5,2323,406-1,8265,5000#DIV/0!0.00%
6174-02-21-231-001 Audit Fees80080008000#DIV/0!0.00%

TOWN OF SMITHS FALLS Page 18 2023 BUDGET

TOWN OF SMITHS FALLS 2023 BUDGETPage 18
INDEPENDENT BOARDS GENERAL BUDGET
Passed February 21, 20232022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION4,0005,8161,8166,5000#DIV/0!0.00%
6177-02-21-231-001 Computer Maintenance *16081-79810#DIV/0!0.00%
6216-02-21-231-001 Copyright Licencing Fee3,0002,206-7942,5000#DIV/0!0.00%
6031-02-21-231-001 Automation * New software359,389316,323-43,066382,581000#DIV/0!
TOTAL ADMINISTRATION359,389316,323-43,066382,581000#DIV/0!
BUILDING MAINTENANCE
6105-02-21-231-010 Hydro4,1003,009-1,0913,5000#DIV/0!0.00%
6106-02-21-231-010 Water1,225891-3341,2000#DIV/0!0.00%
6107-02-21-231-010 Heating Gas4,0006,6322,6329,0000#DIV/0!0.00%
02-21-231-010-6012 Principal (Building Renovations)23,12721,172-1,95523,8710#DIV/0!0.00%
02-21-231-010-6014 Interest (Building Renovations)1,6741,562-1129300#DIV/0!0.00%
02-21-231-355-6012 Principal (Energy Audit)1,2621,156-1061,2990#DIV/0!0.00%
02-21-231-355-6014 Interest (Energy Audit)548504-445110#DIV/0!0.00%
6110-02-21-231-010 Property Repairs16,0009,233-6,76716,0000#DIV/0!0.00%
6197-02-21-231-010 Janitorial Contract20,00013,095-6,90516,0000#DIV/0!0.00%
TOTAL BUILDING MAINTENANCE71,93657,254-14,68272,311000#DIV/0!
MATERIALS
6165-02-21-231-015 Books35,00031,086-3,91440,0000#DIV/0!0.00%
6166-02-21-231-015 Magazines1,5000-1,5001,0000#DIV/0!0.00%
6167-02-21-231-015 Newspapers1,0001,079791,2000#DIV/0!0.00%
6168-02-21-231-015 Videos1,500895-6051,5000#DIV/0!0.00%
6170-02-21-231-015 Book Binding0000#DIV/0!#DIV/0!
6171-02-21-231-015 Interlibrary Loan2000-2001500#DIV/0!0.00%
6829-02-21-231-015 Processing & Cataloging3,0002,804-1964,0000#DIV/0!0.00%
02-21-231-015-6651 Digital Resources15,00011,394-3,60615,0000#DIV/0!0.00%

TOTAL LIBRARY MATERIALS57,20047,258-9,94262,850000#DIV/0!
2022 BUDGETPage 19

INDEPENDENT BOARDS GENERAL BUDGET

Passed February 21, 20232022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.Completed
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.Completed

SUMMER PROGRAM(086)/EARLY YEARS PROGRAM(157)

5424-02-21-231-086 Federal Grants0000#DIV/0!#DIV/0!
5557-02-21-231-086 Donations0000#DIV/0!#DIV/0!
6025-02-21-231-086 Transfer to/from Reserve0-4,258-4,2580#DIV/0!#DIV/0!
6011-02-21-231-086 Office Supplies0000#DIV/0!#DIV/0!
6165-02-21-231-086 Books0000#DIV/0!#DIV/0!
6169-02-21-231-086 Compact Discs0000#DIV/0!#DIV/0!
6048-02-21-231-086 Part Time Wages *0000#DIV/0!#DIV/0!
6078-02-21-231-086 Vacation Pay0000#DIV/0!#DIV/0!
6091-02-21-231-086 Other Payroll Costs0000#DIV/0!#DIV/0!
6184-02-21-231-086 Program Supplies3,0004,2581,2584,0000#DIV/0!0.00%
* Board request for Summer Children's Literacy Program
TOTAL SUMMER PROGRAM3,0000-3,0004,000000#DIV/0!

COMMUNITY ACCESS PROGRAM

COMMUNITY ACCESS PROGRAM
02-21-231-017-5424 Federal Grant0-4,737-47370#DIV/0!#DIV/0!
5557-02-21-231-017 Donations0000#DIV/0!#DIV/0!
5612/6025-02-21-231-017 Tsf to/from Reserve04,73747370#DIV/0!#DIV/0!
6048-02-21-231-017 Part Time Wages0000#DIV/0!#DIV/0!
6078-02-21-231-017 Vacation Pay0000#DIV/0!#DIV/0!
6091-02-21-231-017 Benefits0000#DIV/0!#DIV/0!
6112-02-21-231-017 Equipment0000#DIV/0!#DIV/0!
00000000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGETPage 20
INDEPENDENT BOARDS GENERAL BUDGET
Passed February 21, 20232022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.
ACCOUNT/DESCRIPTIONADOPT A BOOK PROGRAM
5557-02-21-231-019 Donations0000#DIV/0!
6025-02-21-231-019 Tsf to/from Reserve0000#DIV/0!
6165-02-21-231-019 Books00000#DIV/0!
TOTAL ADOPT A BOOK PROGRAM0000000#DIV/0!
MISC GRANTS
5421-02-21-231-163 Provincial Grant (in deferred revenue)0000#DIV/0!
5421-02-21-231-245 Provincial Grant0000#DIV/0!
6836-02-21-231-163 Trsf from Deferred Revenue0000#DIV/0!
6836-02-21-231-245 Trsf to/from Deferred Revenue0000#DIV/0!
6046-02-21-231-245 Program Supplies0000#DIV/0!
6738-02-21-231-163 IT Support0000#DIV/0!
6739-02-21-231-163 Partner Share0000#DIV/0!
6836-02-21-231-278 Trsf to/from Deferred Revenue ("Read with me"; Childhood Literacy Program)0000#DIV/0!
6048-02-21-231-278 Part-time Wages0000#DIV/0!
6078-02-21-231-278 Vacation0000#DIV/0!
6091-02-21-231-278 Other Benefits0000#DIV/0!
6046-02-21-231-278 Program Supplies0000#DIV/0!
6836-02-21-231-278 Trsf to/from Deferred Revenue0000#DIV/0!
TOTAL IT PROJECT000000#DIV/0!
TOTAL LIBRARY GENERAL BUDGET491,525420,835-70,690521,742000#DIV/0!

TOTAL LIBRARY BUDGET491,525420,835-70,690521,742000#DIV/0!

TOWN OF SMITHS FALLS 2023 FINAL OPERATIONAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION

Passed February 21, 2023
2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
AIRPORT
01-31-330-309-5612 Trsf from Capital Reserve (Acct 2083)0000#DIV/0!#DIV/0!
6553-01-31-330-000 Runway Asphalt Preservation0000#DIV/0!#DIV/0!
5711-01-31-330-000 Montague Tsp Fees0000#DIV/0!#DIV/0!
01-31-330-000-6049 Drainage @Old Club House0000#DIV/0!#DIV/0!
6319-01-31-330-000 Airport Security *0000#DIV/0!#DIV/0!
6808-01-31-330-400 Fuel System Safety Upgrades0000#DIV/0!#DIV/0!
6722-01-31-330-000 Airport Beacon Replacement0000#DIV/0!#DIV/0!
6025-01-31-330-000 Transfer to Reserve; Fuel System (Capital reserve 2065)0000#DIV/0!#DIV/0!
5612-01-31-330-309 Transfer from Capital Reserve0000#DIV/0!#DIV/0!
01-31-330-000-6100 Runway Loading0000#DIV/0!#DIV/0!
01-31-330-000-5612 Transfer from Reserve (Acct 2051)0000#DIV/0!#DIV/0!
TOTAL AIRPORT CAPITAL0000000#DIV/0!

*Full amount in reserve; 25% Montague portion paid


TOWN OF SMITHS FALLS 2023 BUDGET Page 22

2023 BUDGET Page 22

INDEPENDENT BOARDS GENERAL BUDGET

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
AIRPORT
5711-02-31-330-020 Montague Twp Fees-11,238-10,386852-12,0670#DIV/0!0.00%
6029-02-31-330-001 Membership Fees4350-4354350#DIV/0!0.00%
6032-02-31-330-001 Conferences2,5000-2,5002,5000#DIV/0!0.00%
6105-02-31-330-001 Utilities4,5003,597-9034,5000#DIV/0!0.00%
6108-02-31-330-001 Fuel4,5002,433-2,0674,5000#DIV/0!0.00%
6012-02-31-330-001 Annual Repayment (Fuel Tanks) *5,0005,00005,0000#DIV/0!0.00%
6112-02-31-330-001 Equipment Repairs6,0001,087-4,9136,0000#DIV/0!0.00%
6123-02-31-330-001 Property Repairs4,0001,119-2,8814,0000#DIV/0!0.00%
6289-02-31-330-001 Mowing & Brushing7,0008,5181,5187,0000#DIV/0!0.00%
6173-02-31-330-001 Insurance5,21616,27011,0548,5340#DIV/0!0.00%
6200-02-31-330-001 Snow Removal Contract2,0000-2,0002,0000#DIV/0!0.00%
6321-02-31-330-001 Consulting Fees0000#DIV/0!#DIV/0!
6201-02-31-330-001 Airport Maintenance1,3001,018-2821,3000#DIV/0!0.00%
6025-02-31-330-001 Transfer to Reserve (Account 2064)2,5002,50002,5000#DIV/0!0.00%
TOTAL AIRPORT GENERAL33,71331,156-2,55736,202000#DIV/0!

This draft budget is status quo from 2022; subject to change for 2nd draft

Account 2064 is for pending consulting fees to maintain the approaches for NavCanada per email from L. McKimm


TOWN OF SMITHS FALLS Page 23 2023 FINAL OPERATIONAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
FIRE SERVICES
6095-01-21-211-000 Extrication Equipment0000#DIV/0!#DIV/0!
6598-01-21-211-000 SCBA Equipment25,0000-25,0000#DIV/0!#DIV/0!
01-21-211-000-6455 New Radio System500,0000-500,0000#DIV/0!#DIV/0!
01-21-211-357-6808 CAD2,8000-2,8000#DIV/0!#DIV/0!
01-21-211-284-6808 Haz Mat Equipment5,0000-5,0000#DIV/0!#DIV/0!
01-21-211-356-6808 Water Rescue Equipment0000#DIV/0!#DIV/0!
01-21-211-309-5612 Trsf from Capital Reserve (Acct 2083)-552,800-550,0002,8000#DIV/0!#DIV/0!
01-21-211-000-6478 Tanker Truck0000#DIV/0!#DIV/0!
01-21-211-000-5612 Transfer from Reserve (Account 2051/2080)-50,000050,0000#DIV/0!#DIV/0!
01-21-211-160-6398 Dispatch Command Centre; 911 Upgrade50,0000-50,0000#DIV/0!#DIV/0!
01-21-211-247-6322 Hoses/Nozzles20,0000-20,0000#DIV/0!#DIV/0!
TOTAL FIRE SERVICES CAPITAL0-550,000-550,0000000#DIV/0!

EMERGENCY COMMUNICATION CENTRE & EMERGENCY PREPAREDNESS

6401-02-21-211-160 Annual System Maintenance21,5001,582-19,91821,5000#DIV/0!0.00%
6452-02-21-211-160 Digitalized Mapping15,0000-15,00015,0000#DIV/0!0.00%
5905-02-21-211-160 Fire Marque Revenue-10,000-8,5841,416-10,0000#DIV/0!0.00%
6025-02-21-211-160 Fire Marque Revenue (Trsf to Fire Dept Reserve)10,0008,584-1,41610,0000#DIV/0!0.00%
5853-02-21-211-160 Dispatch Revenue-377,800-137,198240,602-377,8000#DIV/0!0.00%
6039-02-21-211-264 Staff Training (Emergency Preparedness)700-542-1,2421,0000#DIV/0!0.00%
6046-02-21-211-264 Materials & Supplies (Emergency Preparedness)3,00061-2,9393,0000#DIV/0!0.00%
6015-02-21-211-264 Travel (Emergency Preparedness)1000-1001000#DIV/0!0.00%
xxxx-02-21-211-001 Pay Equity Review Increase (non-union only)01301305,2930#DIV/0!0.00%
5612-02-21-211-0020 Transfer from Reserve (Acct 2050)000-5,2930#DIV/0!0.00%
6792-02-21-211-413 COVID-19 (Emergency Response)7,0002,345-4,65500#DIV/0!#DIV/0!
TOTAL COMMUNICATION CENTRE-330,500-133,622196,878-337,2000#DIV/0!

TOWN OF SMITHS FALLS Page 24 2023 BUDGET DEPARTMENTAL GENERAL BUDGET
2022 2023

ACCOUNT/DESCRIPTIONDEPARTMENTAL GENERAL BUDGET
ACCOUNT/DESCRIPTION2022 Budget2022 Actual2023 Var.2023 Budget2023 To Date2023 Actual% Var.% Completed
FIRE SERVICES; ADMINISTRATION
5523-02-21-211-020 Fire Certificates-900-930-30-9000#DIV/0!
5524-02-21-211-020 Fire Calls - Other Munic.-80,000080,000-80,0000#DIV/0!
5529-02-21-211-020 Permit Fees-1,200-960240-1,2000#DIV/0!
5556-02-21-211-020 Misc Fees-5000500-5000#DIV/0!
6035-02-21-211-001 Regular Salaries & Wages677,773568,819-108,954687,9280#DIV/0!
6048-02-21-211-001 Part-time Wages28,53623,74426,5410#DIV/0!
6053-02-21-211-001 Volunteer Fire Fighters130,36965,181-65,188130,3690#DIV/0!
6057-02-21-211-001 Overtime35,00053,60518,60540,0000#DIV/0!
6061-02-21-211-001 Overtime Training18,0009,689-8,31115,0000#DIV/0!
6069-02-21-211-001 Stat Time6,5006,347-1536,5000#DIV/0!
6078-02-21-211-001 Vacation Pay1,14117,7071,0620#DIV/0!
6090-02-21-211-001 Acting Pay2005-1952000#DIV/0!
6091-02-21-211-001 Other Payroll Costs227,389190,532-36,857261,4830#DIV/0!
6011-02-21-211-001 Office Supplies1,2001,032-1681,2000#DIV/0!
6012-02-21-211-247 Loan Principal (Ladder Truck)63,85958,449-5,41066,1830#DIV/0!
6014-02-21-211-247 Loan Interest (Ladder Truck)29,75427,363-2,39127,4300#DIV/0!
6015-02-21-211-001 Travel Expense2000-2005000#DIV/0!
6017-02-21-211-001 Coffee/Food Supplies1,5001,359-1412,0000#DIV/0!
6019-02-21-211-001 Photocopy Supplies1,5001,316-1841,5000#DIV/0!
6023-02-21-211-001 Postage2006-1941500#DIV/0!
6029-02-21-211-001 Membership Fees3,0002,389-6113,0000#DIV/0!
6032-02-21-211-001 Conferences3,2000-3,2003,2000#DIV/0!
6038-02-21-211-001 Advertising1,50051-1,4491,5000#DIV/0!
6039-02-21-211-001 Staff Training & Develop.12,00013,6531,65325,0000#DIV/0!
6040-02-21-211-001 Clothing Supplies10,0006,112-3,88810,0000#DIV/0!
6040-02-21-211-256 Personal Protective Clothing5,0003,555-1,4458,0000#DIV/0!
6041-02-21-211-001 Turnout Gear Cleaning *3,5002,169-1,3313,5000#DIV/0!
6042-02-21-211-001 Courier10078-221000#DIV/0!
6102-02-21-211-001 Telephone14,00014,23023014,0000#DIV/0!
6659-02-21-211-001 Communication14,0007,898-6,10214,0000#DIV/0!
6173-02-21-211-001 Insurance20,09520,48639124,5830#DIV/0!
6180-02-21-211-001 Legal/Consulting Fees9,00027,32418,32415,0000#DIV/0!
6219-02-21-211-001 Fire Prevention5,0005,2082085,0000#DIV/0!
TOTAL FIRE ADMINISTRATION1,240,9161,126,417-126,2731,312,329000#DIV/0!

2023 BUDGET PAGE 25

2023 BUDGET PAGE 25

DEPARTMENTAL GENERAL BUDGET

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
BUILDING MAINTENANCE
6116-02-21-211-010 Janitorial Supplies1,000944-561,2000#DIV/0!0.00%
6322-02-21-211-010 Medical Equipment/Services3,7000-3,7003,7000#DIV/0!0.00%
6118-02-21-211-010 Tools, Accessories, etc18,0005,404-12,59618,0000#DIV/0!0.00%
6123-02-21-211-010 Property Repairs **12,0004,630-7,37012,0000#DIV/0!0.00%
6199-02-21-211-010 Hydrant Rentals *64,00064,000064,0000#DIV/0!0.00%
* Inc. of 1.5% as per LTFP ** Repairs to the former Police station
98,70074,978-23,72298,900000#DIV/0!
VEHICLE MAINTENANCE
6108-02-21-211-258 Gas & Oil (Pumper 820) FA 7-0002 (Being disposed of)5000-50000#DIV/0!#DIV/0!
6110-02-21-211-258 Repairs (Pumper 820) FA 7-00023,0001,919-1,08100#DIV/0!#DIV/0!
6108-02-21-211-259 Gas & Oil (Tanker 830) FA 7-00035006151155000#DIV/0!0.00%
6110-02-21-211-259 Repairs (Tanker 830) FA 7-00032,500643-1,8572,5000#DIV/0!0.00%
6108-02-21-211-260 Gas & Oil (Aerial 810) FA 7-00561,8002,0432432,0000#DIV/0!0.00%
6110-02-21-211-260 Repairs (Aerial 810) FA 7-005615,00010,493-4,50715,0000#DIV/0!0.00%
6108-02-21-211-456 Gas & Oil (Truck 870) FA 7-0006 *2,8001,600-1,2002,8000#DIV/0!0.00%
6110-02-21-211-456 Repairs (Truck 870) FA 7-0006 *2,70033-2,6675000#DIV/0!0.00%
6108-02-21-211-417 Gas & Oil (Pumper 821)1,7008,0356,3358,0000#DIV/0!0.00%
6110-02-21-211-417 Repairs (Pumper 821)1,7002,0073071,7000#DIV/0!0.00%
6108-02-21-211-263 Gas & Oil (Rescue 840) FA 7-00016001,0324328000#DIV/0!0.00%
6110-02-21-211-263 Repairs (Rescue 840) FA 7-00013,000634-2,3662,5000#DIV/0!0.00%
6270-02-211-456 Vehicle Lease Payments15,6630#DIV/0!0.00%
TOTAL VEHICLE MAINTENANCE35,80029,054-6,74651,963000#DIV/0!

*** Being replaced with leased vehicle (Veh #871)**


TOWN OF SMITHS FALLS Page 26 2023 BUDGET

DEPARTMENTAL GENERAL BUDGET

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 Actual EQUIPMENT MAINTENANCE2023 Budget2023 To Date2023 ActualVar.% Var.
6110-02-21-211-012 Equipment Repairs5,0003,465-1,5355,5000#DIV/0!0.00%
6119-02-21-211-012 Radio & Pager Repairs5,0000-5,0005,0000#DIV/0!0.00%
6120-02-21-211-012 SCBA Repairs *8,5003,679-4,8217,0000#DIV/0!0.00%
6122-02-21-211-012 Chemicals4,0000-4,0004,0000#DIV/0!0.00%
TOTAL EQUIPMENT MAINTENANCE22,5007,144-15,35621,500000#DIV/0!
ACCOUNT/DESCRIPTION2021 Budget2021 Actual FIRE FUNDRAISING ACTIVITIESVar.2022 Budget2022 To Date2022 ActualVar.% Var.Completed
5557-02-21-211-013 Donations0000#DIV/0!#DIV/0!
6140-02-21-211-013 Smoke Detectors0000#DIV/0!#DIV/0!
TOTAL FUNDRAISING ACTIVITIES0000000#DIV/0!
TOTAL FIRE SERVICES GENERAL1,067,4161,103,97124,7811,147,492000#DIV/0!
TOTAL FIRE SERVICES BUDGET1,067,416553,971-525,2191,147,492000#DIV/0!

TOWN OF SMITHS FALLS Page 27 2023 FINAL OPERATIONAL BUDGET

TOWN OF SMITHS FALLS Page 27

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ADMINISTRATION
6035-02-21-101-001 Regular Salaries & Wages236,259175,567-60,692240,7770#DIV/0!0.00%
6091-02-21-101-001 Other Payroll Costs82,19959,980-22,21987,2130#DIV/0!0.00%
6011-02-21-101-001 Office Supplies1,5003,8932,3932,5000#DIV/0!0.00%
6019-02-21-101-001 Photocopy Supplies8009141141,0000#DIV/0!0.00%
6023-02-21-101-001 Postage508030500#DIV/0!0.00%
6029-02-21-101-001 Membership Fees1,2006,1184,9181,2000#DIV/0!0.00%
6038-02-21-101-001 Advertising1,0000-1,0003,0000#DIV/0!0.00%
6039-02-21-101-001 Staff Training & Development4,0000#DIV/0!0.00%
xxxx-02-21-101-001 Pay Equity Review Increase0008,2000#DIV/0!0.00%
6042-02-21-101-001 Courier00000#DIV/0!#DIV/0!
6173-02-21-101-001 Insurance19,26119,260-123,1120#DIV/0!0.00%
5612-02-21-101-001 Transfer from Reserve (Account 2050)000-8,2000#DIV/0!0.00%
6180-02-21-101-001 Legal/Consulting Fees1,0007,6386,6383,0000#DIV/0!0.00%
6279-02-21-101-001 Trophies/Awards10050-5000#DIV/0!#DIV/0!
TOTAL ADMINISTRATION343,369273,500-69,869365,852000#DIV/0!

TOWN OF SMITHS FALLS Page 28 2023 FINAL OPERATIONAL BUDGET

TOWN OF SMITHS FALLS Page 28

Passed February 21, 2023

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
COUNTY SHARED SERVICES
02-21-201-002-6196 AMBULANCE513,000407,342-105,658665,0000#DIV/0!0.00%29.63%
02-21-201-003-6196 LL&G DISTRICT HEALTH UNIT *180,698165,367-15,331186,0980#DIV/0!0.00%2.99%
02-21-201-004-6231 ODSP/OW NET COST768,138722,270-45,868755,3380#DIV/0!0.00%-1.67%
02-21-201-007-6231 LANARK LODGE400,000236,025-163,975436,0000#DIV/0!0.00%9.00%
02-21-201-009-6231 SOCIAL HOUSING460,300414,507-45,793554,1000#DIV/0!0.00%20.38%
TOTAL COUNTY SHARED SERVICES2,322,1361,945,511-376,6252,596,536000#DIV/0!0.00%

Status quo from 2022; not yet confirmed from County (sent email Nov 14/22)

  • December 9, 2022 - We were advised that we would not know the 2023 levy until after their year-end in January.

TOWN OF SMITHS FALLS Page 29 2023 FINAL OPERATIONAL BUDGET COMMUNITY SERVICES

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
PARKS DEVELOPMENT
6822-01-21-230-000 Cameras (CC parking lot/Victoria Park/Conf Park)0000#DIV/0!#DIV/0!
6622-01-21-234-149 3/4 Ton Truck (x 2)70,0000-70,0000#DIV/0!#DIV/0!
6669-01-21-234-149 Centennial Park Fountain Repairs0000#DIV/0!#DIV/0!
01-21-234-241-6805 Pedestrian Bridges0000#DIV/0!#DIV/0!
01-21-230-000-6814 Light/Light Pole Replacements012,53612,5360#DIV/0!#DIV/0!
01-21-230-000-6786 Shelters for Dog Park11,5237,149-4,3740#DIV/0!#DIV/0!
01-21-234-309-5612 Trsf from Capital Reserve (Acct 2083)-152,400-10,048142,3520#DIV/0!#DIV/0!
01-21-234-364-6533 Multi-Use Trail (Beckwith to Lower Reach Park)0000#DIV/0!#DIV/0!
01-21-230-207-6049 Sprinkler System/Centennial Park0000#DIV/0!#DIV/0!
01-21-234-364-6836 Trsf to/from Deferred Revenue (OMCC Grant Reserve)0000#DIV/0!#DIV/0!
01-21-230-000-6670 Illuminate the falls & install unique lighting features0000#DIV/0!#DIV/0!
01-21-230-000-6025 Transfer to Reserve0000#DIV/0!#DIV/0!
01-21-230-419-6808 Automated Timers for Outdoor Lights89,20029,314-59,8860#DIV/0!#DIV/0!
01-21-234-290-6668 Floating Docks (Lower Reach Park)0000#DIV/0!#DIV/0!
01-21-230-000-6533 Park Improvements07537530#DIV/0!#DIV/0!
01-21-230-395-6808 Inflatable (Murphy Park Waterfront)0000#DIV/0!#DIV/0!
01-21-234-196-6808 Benches/Chairs/Picnic Tables (Victoria Park Basin)09,3169,3160#DIV/0!#DIV/0!
01-21-230-207-6070 Sprinkler System/Centennial Park06856850#DIV/0!#DIV/0!
01-21-230-000-6412 Park Building/Storage Replacements0000#DIV/0!#DIV/0!
01-21-230-000-5612 Transfer from Reserve (Acct 2051 & 2080)-268,323-51,712216,6110#DIV/0!#DIV/0!
01-21-234-254-6110 Tennis Court Resurfacing0000#DIV/0!#DIV/0!
01-21-230-122-6808 Basketball Court Renovation0000#DIV/0!#DIV/0!
01-21-230-196-6049 Drains (Victoria Park Pump Out)0000#DIV/0!#DIV/0!
01-21-230-001-6588 Parks & Rec Master Plan01,5491,5490#DIV/0!#DIV/0!
01-21-230-000-6234 Playground Equipment Replacement250,000458-249,5420#DIV/0!#DIV/0!
* Originally on Eng worksheet; Troy asked that it be reallocated
TOTAL LOWER REACH000000#DIV/0!

5612-01-21-232-309 Transfer from Capital Reserve 5612-01-21-232-000 Transfer from Reserve (PCO) 6009-01-21-232-000 Tree Replacement TOTAL TREE REPLACEMENT TOTAL PARKS CAPITAL

TREE REPLACEMENT PROGRAM
0000#DIV/0!#DIV/0!
0-4,401-4,4010#DIV/0!#DIV/0!
04,4014,4010#DIV/0!#DIV/0!
0000000#DIV/0!
0000000#DIV/0!

TOWN OF SMITHS FALLS Page 30 2023 COMMUNITY SERVICES GENERAL BUDGET PARKS

Passed February 21, 2023
2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION0-200-20000#DIV/0!#DIV/0!
5575-02-21-230-020 Victoria Park; Lease Payment0-100-10000#DIV/0!#DIV/0!
5557-02-21-230-020 Donation010010000#DIV/0!#DIV/0!
6025-02-21-230-000 Transfer to Reserve010010000#DIV/0!#DIV/0!
6792-02-21-230-413 COVID-19 Expenditures01,7711,77100#DIV/0!#DIV/0!
6035-02-21-230-001 Regular Salaries & Wages130,75094,315-36,435149,4790#DIV/0!0.00%
6048-02-21-230-001 Part Time Wages *68,67313,886-54,78711,2850#DIV/0!0.00%
6057-02-21-230-001 Overtime3,0002,273-7273,0000#DIV/0!0.00%
6078-02-21-230-001 Vacation Pay2,7474,7952,0484520#DIV/0!0.00%
6091-02-21-230-001 Other Payroll Costs51,48840,155-11,33360,4600#DIV/0!0.00%
5612-02-21-230-020 Trsf from reserve (Account 2050)000-5,6170#DIV/0!0.00%
xxxx-02-21-230-001 Pay Equity Review Increase05,6170#DIV/0!0.00%
6143-02-230-051-6143 Federal Park Lease2,5001,547-9531,5000#DIV/0!0.00%
6039-02-21-230-001 Staff Training1,0002,9321,9325,0000#DIV/0!0.00%
6040-02-21-230-001 Clothing & Supplies2,5002,347-1533,0000#DIV/0!0.00%
6102-02-21-230-001 Telephone8001,2684682,5000#DIV/0!0.00%
6105-02-21-230-196 Victoria Park; Hydro1,0002,8781,8782,8000#DIV/0!0.00%
6106-02-21-230-196 Victoria Park; Water1,0003,6862,6862,5000#DIV/0!0.00%
6123-02-21-230-196 Victoria Park; Property Repairs04094092,5000#DIV/0!0.00%
6173-02-21-230-196 Victoria Park; Insurance24,53325,47293930,5660#DIV/0!0.00%
6105-02-21-230-051 Hydro4,5007,0102,5105,5000#DIV/0!0.00%
6106-02-21-230-051 Water20,00030,09710,09740,0000#DIV/0!0.00%
6116-02-21-230-051 Janitorial Supplies1,000891-1091,0000#DIV/0!0.00%
6123-02-21-230-051 Property Repairs35,00048,30813,30860,0000#DIV/0!0.00%
6197-02-21-230-051 Janitorial Services11,48519,5828,09718,9110#DIV/0!0.00%
6142-02-21-230-051 Shrubbery25,00067,90242,90280,0000#DIV/0!0.00%
6108-02-21-230-011 Vehicle Gas & Oil5,5008,8683,3688,5000#DIV/0!0.00%
6110-02-21-230-011 Vehicle Repairs1,0001,1871871,0000#DIV/0!0.00%
6128-02-21-230-011 Vehicle Licences400480804800#DIV/0!0.00%
6110-02-21-230-012 Equipment Repairs1,00010,0029,0028,5000#DIV/0!0.00%
6270-02-21-230-012 Vehicle Lease Payments21,7050#DIV/0!0.00%
6115-02-21-230-012 Equipment Rental1,000120-88000#DIV/0!#DIV/0!
5612-02-21-230-012 Trsf from PCO Reserve (Acct 2051)-21,7050#DIV/0!0.00%
5554-02-21-230-343 Rental Revenue (Sports Field) *-6,000-11,823-5,823-8,5000#DIV/0!0.00%
6105-02-21-230-343 Hydro (Sports Field) *5001,6611,1611,2000#DIV/0!0.00%
6122-02-21-230-343 Chemicals, Etc. (Sports Field) *5000-50000#DIV/0!#DIV/0!
6123-02-21-230-343 Property Repairs (Sports Field) *10,0006,992-3,00815,0000#DIV/0!0.00%
6108-02-21-230-343 Equipment Gas & Oil (Sports Field) *6502,9292,27900#DIV/0!#DIV/0!
6110-02-21-230-343 Equipment Repairs (Sports Field) *3,0002,398-6023,0000#DIV/0!0.00%
TOTAL PARKS GENERAL404,526394,138-10,388509,633000#DIV/0!
TOTAL PARKS BUDGET404,526394,138-10,388509,633000#DIV/0!

5,000 added to sports field repairs for softballs hitting cars solutions


TOWN OF SMITHS FALLS Page 31 2023 FINAL OPERATIONAL BUDGET COMMUNITY SERVICES

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
COMMUNITY FACILITIES MUNICIPAL COMPLEX
6753-01-21-240-000 Complex Renovations; Phase 31,949,6361,634,428-315,2080#DIV/0!#DIV/0!
5424-01-21-240-433 CCRF Federal Grant-750,000-151,735598,2650#DIV/0!#DIV/0!
6574-01-21-240-359 Town Square/Band Shell1,000,000405,336-594,6640#DIV/0!#DIV/0!
6354-01-21-240-000 HVAC (Fire Dispatch)0000#DIV/0!#DIV/0!
01-21-240-000-5421 COVID ICIP Resilience Funding-161,381-161,38100#DIV/0!#DIV/0!
01-21-240-000-6446 Storage Solutions0000#DIV/0!#DIV/0!
01-21-240-000-5612 Transfer from Reserve (Acct 2051/2269)-88,619-288,206-199,5870#DIV/0!#REF!
01-21-240-309-5612 Trsf from Capital Reserve (Acct 2083)-791,896-891,242-99,3460#DIV/0!#DIV/0!
01-21-240-420-6808 Window Coverings/Blinds0000#DIV/0!#DIV/0!
01-21-240-000-5852 Capital Financing-584,8440584,8440#DIV/0!#DIV/0!
01-21-240-000-58569 Federal Gas Tax-584,896-584,89600#DIV/0!#DIV/0!
01-21-240-000-6593 REAL Building Repairs12,0001,872-10,1280#DIV/0!#DIV/0!
TOTAL MUNICIPAL COMPLEX0-35,824-35,8240000#DIV/0!

MEMORIAL COMMUNITY/YOUTH CENTRE ARENA/OTHER FACILITIES 0 27,036 27,036

MEMORAL COMMON T/ TOUR CENTER ARENA/OTHER FACILITIES
01-21-241-421-6808 FOB Access (CC)027,03627,0360#DIV/0!#DIV/0!
01-21-241-000-5612 Trsf from Reserve (Acct 2051)0-27,036-27,0360#DIV/0!#DIV/0!
01-21-241-000-6324 Furniture0000#DIV/0!#DIV/0!
01-21-241-000-6628 Community Centre Board Dividers0000#DIV/0!#DIV/0!
01-21-241-309-5612 Trsf from Capital Reserve (Acct 2083)0000#DIV/0!#DIV/0!
01-21-241-355-5615/5852 Unfinanced/Financed Capital Financing0000#DIV/0!#DIV/0!
01-21-241-355-6808 Energy Audit Projects0000#DIV/0!#DIV/0!
01-21-241-000-6025 Transfer to Reserve0000#DIV/0!#DIV/0!
TOTAL ARENAS00000000#DIV/0!
TOTAL COMMUNITY FACILITIES CAPITAL0-35,824-35,82400000#DIV/0!

TOWN OF SMITHS FALLS Page 32 2023 BUDGET COMMUNITY SERVICES/COMMUNITY FACILITIES GENERAL BUDGET/

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 Actual MUNICIPAL COMPLEX2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2022 BudgetVar.2023 Budget2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
6102-02-21-240-001 Telephone21,00013,612-7,38815,0000#DIV/0!0.00%
6792-02-21-240-413 COVID-19 Expenditures00000#DIV/0!#DIV/0!
6378-02-21-240-001 Flags1,500766-7341,5000#DIV/0!0.00%
6025-02-21-240-001 Tsf to/frm Pardy Flag Fund000-1,5000#DIV/0!0.00%
6012-02-21-240-001 Renovations - Principal158,870145,429-13,441179,5560#DIV/0!0.00%
6014-02-21-240-001 Renovations - Interest24,50822,618-1,89054,1290#DIV/0!0.00%
6105-02-21-240-010 Hydro - Complex28,00023,843-4,15725,0000#DIV/0!0.00%
6106-02-21-240-010 Water - Complex10,0006,570-3,4307,5000#DIV/0!0.00%
6107-02-21-240-010 Heating Gas - Complex17,00014,657-2,34319,0000#DIV/0!0.00%
6116-02-21-240-010 Janitorial Supplies4,0002,407-1,5934,0000#DIV/0!0.00%
6123-02-21-240-010 Property/Lawn Repairs18,00024,2026,20225,0000#DIV/0!0.00%
6173-02-21-240-010 Insurance11,18313,7252,54216,4700#DIV/0!0.00%
6180-02-21-240-010 Professional Fees00000#DIV/0!#DIV/0!
6197-02-21-240-010 Janitorial Service45,79143,907-1,88449,1690#DIV/0!0.00%
TOTAL MUNICIPAL COMPLEX339,852311,736-28,116394,824000#DIV/0!
STATION THEATRE PROJECT
5575-02-41-420-074 Lease Income-10,000010,000-10,0000#DIV/0!0.00%
6012-02-41-420-074 Principal (Re-pointing)12,96811,872-1,09613,3850#DIV/0!0.00%
6014-02-41-420-074 Interest (Re-pointing)939876-635210#DIV/0!0.00%
6105-02-41-420-074 Hydro3,5004,3478474,0000#DIV/0!0.00%
6106-02-41-420-074 Water1,200771-4291,2000#DIV/0!0.00%
6107-02-41-420-074 Heating Fuel7,0006,752-2488,0000#DIV/0!0.00%
6123-02-41-420-074 Property Repairs6,500137-6,3636,5000#DIV/0!0.00%
6301-02-41-420-074 Municipal Taxes10,0007,707-2,29310,0000#DIV/0!0.00%
6213-02-41-420-074 CP Lease1,5500-1,5501,5500#DIV/0!0.00%
6197-02-41-420-074 Janitorial Service ("new" VIA Station) *7,50010,7803,2807,5000#DIV/0!0.00%
6116-02-41-420-074 Janitorial Supplies ("new" VIA Station) *5000-5005000#DIV/0!0.00%
6384-02-41-420-074 Winter Maintenance ("new" VIA Station) *30,00029,002-99835,0000#DIV/0!0.00%
TOTAL VIA/THEATRE PROJECT71,65772,24458778,156000#DIV/0!

TOWN OF SMITHS FALLS Page 33 2023 COMMUNITY SERVICES GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
COMMUNITY FACILITIES/MEMORIAL COMMUNITY CENTRE ARENA
5547-02-21-241-020 Board & Bulkhead Advertising-10,000010,000-10,0000#DIV/0!0.00%
5548-02-21-241-020 Ice Rental-457,000-250,573206,427-553,2600#DIV/0!0.00%
5549-02-21-241-020 Floor Rental-17,000-13,0713,929-10,0000#DIV/0!0.00%
02-21-241-020-5566 Hall Rental-8,000-2,7305,270-9,0000#DIV/0!0.00%
5711-02-21-241-020 Township Fees-252,950-342,279-89,329-342,2800#DIV/0!0.00%
6025-02-21-241-001 Transfer to Arena Building Reserve (Acct 2181)11,70911,709044,0520#DIV/0!0.00%
5612-02-21-241-000-5612 Transfer from Reserve (Account 2050)000-10,4050#DIV/0!0.00%
xxxx-02-21-241-000-001 Pay Equity Review Increase10,4050#DIV/0!0.00%
6035-02-21-241-001 Regular Salaries & Wages242,821194,124-48,697277,6040#DIV/0!0.00%
6048-02-21-241-001 Part Time Wages16,38534,36717,98220,9580#DIV/0!0.00%
6057-02-21-241-001 Overtime3,0009,0666,0663,0000#DIV/0!0.00%
6078-02-21-241-001 Vacation Pay65511,07210,4178390#DIV/0!0.00%
6067-02-21-241-001 Shift Premium1,5000-1,5001,5000#DIV/0!0.00%
6091-02-21-241-001 Other Payroll Costs82,23484,8382,604112,2830#DIV/0!0.00%
5557-02-21-241-275 Donations (Gerry Lowe Foundation)0-20-2000#DIV/0!#DIV/0!
6836-02-21-241-275 Deferred Revenue (Gerry Lowe Foundation)0202000#DIV/0!#DIV/0!
6011-02-21-241-001 Office Supplies2,0003,6601,6603,5000#DIV/0!0.00%
6012-02-21-241-001 New Arena - Principal182,268166,883-15,385187,4750#DIV/0!0.00%
6014-02-21-241-001 New Arena - Interest87,78380,675-7,10882,5880#DIV/0!0.00%
6012-02-21-241-355 Principal (Energy Audit)25,64723,482-2,16526,3960#DIV/0!0.00%
6014-02-21-241-355 Interest (Energy Audit)11,14210,243-89910,3950#DIV/0!0.00%
6038-02-21-241-001 Advertising500280-22000#DIV/0!#DIV/0!
6040-02-21-241-001 Clothing & Supplies3,000881-2,1193,5000#DIV/0!0.00%
6102-02-21-241-001 Telephone/Internet12,00014,8032,80314,0000#DIV/0!0.00%
6173-02-21-241-001 Insurance42,90942,9201151,5040#DIV/0!0.00%
6180-02-21-241-001 Professional Fees50,0004,084-45,9168,0000#DIV/0!0.00%
6174-02-21-241-001 Audit Fees50050002,5000#DIV/0!0.00%
6105-02-21-241-010 Hydro (Combined w/YC)145,00094,296-50,704130,0000#DIV/0!0.00%
6106-02-21-241-010 Water21,00023,1642,16421,0000#DIV/0!0.00%
6107-02-21-241-010 Heating Gas26,00029,3863,38630,0000#DIV/0!0.00%
6116-02-21-241-010 Janitorial Supplies6,0008,6762,6767,0000#DIV/0!0.00%
6197-02-21-241-010 Janitorial Services61,46440,686-20,77864,8470#DIV/0!0.00%
6123-02-21-241-010 Property Repairs45,00060,81615,81670,0000#DIV/0!0.00%
6145-02-21-241-010 Refrigeration Costs38,00036,072-1,92838,0000#DIV/0!0.00%
6108-02-21-241-011 Vehicle Gas & Oil4,00010,3596,35911,0000#DIV/0!0.00%
6110-02-21-241-011 Vehicle Repairs2,0006,1464,1466,5000#DIV/0!0.00%
6110-02-21-241-378 Vehicle Repairs (F/A 7-0020; 2007 Ford F250)3,5002,244-1,2563,5000#DIV/0!0.00%
6128-02-21-241-378 Vehicle Licence (F/A 7-0020; 2007 Ford F250)00000#DIV/0!#DIV/0!

TOWN OF SMITHS FALLS Page 34 2023 BUDGET

Passed February 21, 2023

2022 ACCOUNT/DESCRIPTION2022 BudgetActual2023 Var.2023 Budget2023 To DateActual% Var.% Completed
6108-02-21-241-379 Vehicle Gas & Oil (F/A 7-0024; 2010 Silverado 1500 Summit)0000#DIV/0!
6110-02-21-241-379 Vehicle Repairs (F/A 7-0024; 2010 Silverado 1500 Summit)8005,3454,5453,0000#DIV/0!
6110-02-21-241-380 Vehicle Repairs (F/A 7-0062; 2016 Ford Super Duty Pick-up)5009064063,0000#DIV/0!
6128-02-21-241-380 Vehicle Licence (F/A 7-0062; 2016 Ford Super Duty Pick-up)0000#DIV/0!
6110-02-21-241-012 Equipment Repairs2,0001,070-9300#DIV/0!
6110-02-21-241-381 Equipment Repairs (New Holland Tractor; F/A 5-1129)02,2762,2763,0000#DIV/0!
6110-02-21-241-382 Equipment Repairs (Comm Floor Cleaner; F/A 5-1111)1,4000-1,4000#DIV/0!
6108-02-241-383 Equipment Gas & Oil (2015 Olympia Ice Resurfacer; F/A 5-1135)2,0004,4202,4200#DIV/0!
6110-02-21-241-383 Equipment Repairs (2015 Olympia Ice Resurfacer; F/A 5-1135)40014,89314,4938,0000#DIV/0!
6108-02-241-384 Equipment Gas & Oil (2005 Olympia Ice Resurfacer; F/A 5-1041)400428280#DIV/0!
6110-02-241-384 Equipment Repairs (2005 Olympia Ice Resurfacer; F/A 5-1041)0000#DIV/0!
6108-02-241-392 Gas & Oil (2005 Chev Dump Truck)0000#DIV/0!
6110-02-241-392 Repairs (2005 Chev Dump Truck)1,0000-1,0001,0000#DIV/0!
6128-02-241-392 Licence (2005 Chev Dump Truck)0000#DIV/0!
6108-02-241-393 Gas & Oil (2018 Massey Ferguson Tractor)0001,0000#DIV/0!
6836-02-241-413 COVID Funding; Trsf from deferred revenue0-43,199-43,1990#DIV/0!
6792-02-241-413 COVID-19 Expenditures024,87624,8760#DIV/0!
TOTAL COMMUNITY CENTRE ARENA391,567407,79416,227326,4010000#DIV/0!
MEMORIAL COMMUNITY CENTRE CANTEEN
20222022202320232023%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
5551-02-21-242-020 Pro-shop/Canteen Lease0-1,917-1,917-2,0000#DIV/0!0.00%
5889-02-21-242-020 Bar Sales0000#DIV/0!#DIV/0!
5886-02-21-242-020 Canteen Sales0000#DIV/0!#DIV/0!
5887-02-21-242-020 Vending Machine Commission-110-640-530-5000#DIV/0!0.00%
5888-02-21-242-020 Soft Drink Volume Commission0000#DIV/0!#DIV/0!
6048-02-21-242-001 Part Time Wages (Canteen)0000#DIV/0!#DIV/0!
6048-02-21-242-240 Part Time Wages (Bar)0000#DIV/0!#DIV/0!
6078-02-21-242-240 Vacation Pay (Bar)0000#DIV/0!#DIV/0!
6091-02-21-242-240 Other Payroll Costs (Bar)0000#DIV/0!#DIV/0!
6078-02-21-242-001 Vacation Pay (Canteen)0000#DIV/0!#DIV/0!
6091-02-21-242-001 Other Payroll Costs (Canteen)0000#DIV/0!#DIV/0!
6123-02-21-242-001 Property Repairs0000#DIV/0!#DIV/0!
6783-02-21-242-001 Bar Supplies0000#DIV/0!#DIV/0!
6742-02-21-242-001 Canteen Supplies0000#DIV/0!#DIV/0!
TOTAL COMMUNITY CENTRE CANTEEN-110-2,557-2,447-2,500000#DIV/0!

TOTAL COMMUNITY CENTRE GENERAL391,457405,23713,780323,901000#DIV/0!
TOWN OF SMITHS FALLS 2022 BUDGET COMMUNITY SERVICES GENERAL BUDGET
Passed February 21, 202320222022202320232023%%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
TENNIS COURTS/PARKS CANTEEN
5551-02-21-246-020 Canteen Lease00000#DIV/0!#DIV/0!
5575-02-21-246-020 Rental Revenue00000#DIV/0!#DIV/0!
6105-02-21-246-001 Hydro750402-3484000#DIV/0!0.00%
TOTAL TENNIS COURTS750402-348400000#DIV/0!
SENIORS FACILITY
20222022202320232023%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
02-21-247-001-5557 Donations-3,400-1,6681,732-2,0000#DIV/0!0.00%
02-21-247-001-6025 Transfer to Reserve00000#DIV/0!#DIV/0!
02-21-247-001-6836 Trsf from Deferred Revenue00000#DIV/0!#DIV/0!
6102-02-21-247-001 Telephone1803281483500#DIV/0!
6105-02-21-247-001 Hydro1,2001,7415411,4000#DIV/0!0.00%
6106-02-21-247-001 Water1,000914-861,0000#DIV/0!0.00%
02-21-247-001-6107 Heating Fuel2,0002,4034032,0000#DIV/0!0.00%
02-21-247-001-6116 Janitoral Supplies2000-2002000#DIV/0!0.00%
6123-02-21-247-001 Property Repairs1,20011,64110,4411,5000#DIV/0!0.00%
6197-02-21-247-001 Janitorial Services1,0000-1,0001,0000#DIV/0!0.00%
TOTAL SENIORS FACILITY3,38015,35911,9795,450000#DIV/0!
KINSMEN PAVILLON "New Sub-section"; (Previously utilities were under "Parks")
02-21-443-001-6105 Hydro8333,0012,1682,0000#DIV/0!0.00%
02-21-443-001-6106 Water1,200820-3808000#DIV/0!0.00%
02-21-443-001-6107 Heating Fuel3,0003,8518514,0000#DIV/0!0.00%
02-21-443-001-6116 Janitorial Supplies055155100#DIV/0!#DIV/0!
02-21-443-001-6197 Janitorial Services00000#DIV/0!#DIV/0!
02-21-443-001-6123 Repairs2,0000-2,0002,0000#DIV/0!0.00%
TOTAL KINSMEN PAVILLON7,0338,2231,1908,800000#DIV/0!
* Insurance for this facility is under "Parks"
TOTAL COMMUNITY FACILITIES GENERAL814,129813,201-928811,531000#DIV/0!

TOTAL COMMUNITY FACILITIES BUDGET814,129777,377-36,752811,531000#DIV/0!




TOWN OF SMITHS FALLS Page 36 2023 FINAL OPERATIONAL BUDGET

TOWN OF SMITHS FALLS Page 36

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
HILLCREST CEMETERY
6641-01-21-255-000 Replace chapel roof0000#DIV/0!#DIV/0!
5612-01-21-255-309 Trsf from Capital Reserve (Acct 2083)-35,000-92034,0800#DIV/0!#DIV/0!
6737-01-21-255-000 Columbarium35,000920-34,0800#DIV/0!#DIV/0!
6052-01-21-255-000 Lawn Mower0000#DIV/0!#DIV/0!
TOTAL HILLCREST CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS Page 37 2023 BUDGET

TOWN OF SMITHS FALLS Page 37

COMMUNITY SERVICES GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
HILLCREST CEMETERY
5534-02-21-255-020 Interest on Account-3,925-7,818-3,893-7,0000#DIV/0!0.00%
5541-02-21-255-020 Sale of Plots-8,500-16,491-7,991-10,0000#DIV/0!0.00%
5542-02-21-255-020 Sale of Services-55,000-62,484-7,484-70,0000#DIV/0!0.00%
5557-02-21-255-020 Donations00000#DIV/0!#DIV/0!
5672-02-21-255-020 Columbarium Revenue-18,000-9,8608,140-15,0000#DIV/0!0.00%
xxxx-02-21-255-001 Pay Equity Review Increase0002,8550#DIV/0!0.00%
6035-02-21-255-001 Regular Salaries & Wages *96,01857,690-38,32843,2330#DIV/0!0.00%
6048-02-21-255-001 Part time Wages19,2005,487-13,71348,0000#DIV/0!0.00%
6078-02-21-255-001 Vacation Pay7683,1292,3611,2530#DIV/0!0.00%
6091-02-21-255-001 Other Payroll Costs31,92819,915-12,01321,7100#DIV/0!0.00%
6029-02-21-255-001 Membership Fees2000-2002000#DIV/0!0.00%
6040-02-21-255-001 Clothing & Supplies190204142000#DIV/0!0.00%
6102-02-21-255-001 Telephone800833331,0000#DIV/0!0.00%
6105-02-21-255-001 Hydro1,6001,429-1711,8000#DIV/0!0.00%
6108-02-21-255-001 Vehicle Gas & Oil1,2002,0968962,5000#DIV/0!0.00%
6112-02-21-255-001 Equipment Repairs1,50046-1,4541,5000#DIV/0!0.00%
6118-02-21-255-001 Tools, Accessories, etc1,500853-6471,0000#DIV/0!0.00%
6123-02-21-255-001 Property Repairs5,0002,495-2,5055,0000#DIV/0!0.00%
6160-02-21-255-001 Cemetery License1,000975-251,0000#DIV/0!0.00%
6173-02-21-255-001 Insurance1,4151,6021871,9220#DIV/0!0.00%
5612-02-21-255-020 Transfer from Reserve (Account 2050)000-2,8550#DIV/0!0.00%
6177-02-21-255-001 Computer Maintenance1,0001,5135131,0000#DIV/0!0.00%
6197-02-21-255-001 Janitorial Services4000-4004000#DIV/0!0.00%
6737-02-21-255-001 Columbarium Expenses00000#DIV/0!#DIV/0!
6191-02-21-255-001 Monument Care & Maintenance1,0000-1,0001,0000#DIV/0!0.00%
6195-02-21-255-001 Grave Opening Contract00000#DIV/0!#DIV/0!
79,2941,614-77,68030,718000#DIV/0!
  • Incr. F/T staff

TOWN OF SMITHS FALLS Page 38 2023 FINAL OPERATIONAL BUDGET COMMUNITY SERVICES

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
CHILD DEVELOPMENT CENTRE
01-21-258-309-5612 Trsf from Capital Reserve0000#DIV/0!#DIV/0!
01-21-258-000-5612 Trsf from Reserve (Acct 2066/2051)0000#DIV/0!#DIV/0!
01-21-258-000-6745 Toddlers Room0000#DIV/0!#DIV/0!
01-21-258-000-6123 Playground Equipment (St Francis site)0000#DIV/0!#DIV/0!
01-21-258-000-6025 Tsf to/frm Reserve0000#DIV/0!#DIV/0!
01-21-258-000-6836 Tsf to/frm Deferred Revenue0000#DIV/0!#DIV/0!
5441-01-21-258-000 County Grant0000#DIV/0!#DIV/0!
5441-01-21-258-000 Provincial Grant0000#DIV/0!#DIV/0!
TOTAL CDC CAPITAL BUDGET0000000#DIV/0!

TOWN OF SMITHS FALLS Page 39 2023 BUDGET COMMUNITY SERVICES GENERAL BUDGET

Passed February 21, 2023

20222022202320232023%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.

CHILD DEVELOPMENT CENTRE

ADMINISTRATION
5417-02-21-258-020 County CDC Fee Subsidy-103,100-34,77068,330-103,1000#DIV/0!0.00%
5418-02-21-258-020 Direct Operating Grant-146,294-247,101-100,807-247,1000#DIV/0!0.00%
5533-02-21-258-020 Parents "In Need" Fees-113,636-14,25499,382-113,7000#DIV/0!0.00%
6836-02-21-258-001 Trsf from deferred revenue4,7494,7490#DIV/0!#DIV/0!
5659-02-21-258-020 Parents "Full" Fees - Non-subsid.-443,575-338,010105,565-450,0000#DIV/0!0.00%
02-21-258-413-6035 Regular Wages (COVID-19)02,9962,99600#DIV/0!#DIV/0!
02-21-258-413-6048 Part-time Wages (COVID-19)03,3903,39000#DIV/0!#DIV/0!
02-21-258-413-6078 Vacation Pay (COVID-19)015015000#DIV/0!#DIV/0!
02-21-258-413-6091 Other Benefit Costs (COVID-19)091591500#DIV/0!#DIV/0!
02-21-258-413-5441 Prov/County Grant (COVID-19)0-4,294-4,29400#DIV/0!#DIV/0!
02-21-258-293-5421 Provincial Wage Enhancement Grant0-28,111-28,11100#DIV/0!#DIV/0!
02-21-258-293-6836 Provincial Wage Enhancement Grant; Deferred Revenue02,3782,37800#DIV/0!#DIV/0!
02-21-258-293-6035 Provincial Wage Enhancement Grant; FT Wages018,08518,08500#DIV/0!#DIV/0!
02-21-258-293-6048 Provincial Wage Enhancement Grant; PT Wages02,3392,33900#DIV/0!#DIV/0!
02-21-258-293-6091 Provincial Wage Enhancement Grant; Other benefits02,9962,99600#DIV/0!#DIV/0!
6035-02-21-258-001 Regular Salaries & Wages40,50236,964-3,53842,4750#DIV/0!0.00%
6091-02-21-258-001 Other Payroll Costs25,56817,098-8,47032,0210#DIV/0!0.00%
5441-02-21-258-453 CWELCC Funding *-38,692-38,692-161,8420#DIV/0!0.00%
5612-02-21-258-001 Trsf from Reserve (Account 2050)0-30,2970#DIV/0!0.00%
6011-02-21-258-001 Office Supplies2,5001,388-1,1122,5000#DIV/0!0.00%
6015-02-21-258-001 Travel Expense3000-3003000#DIV/0!0.00%
6019-02-21-258-001 Photocopy Supplies3000-3003000#DIV/0!0.00%
6023-02-21-258-001 Postage8036-44500#DIV/0!0.00%
6038-02-21-258-001 Advertising1,0000-1,0001,0000#DIV/0!0.00%
6039-02-21-258-001 Staff Training & Develop.5001,0945941,0000#DIV/0!0.00%
6871-02-21-258-453 CWELCC Parent Reimbursement29,31329,3130#DIV/0!#DIV/0!
6836-02-21-258-453 CWELCC; Transfer to Deferred Revenue6,5006,5000#DIV/0!#DIV/0!
xxxx-02-21-258-001 Pay Equity Review Increase0030,2970#DIV/0!0.00%
6102-02-21-258-001 Telephone4,0009,6945,6947,5000#DIV/0!0.00%
6174-02-21-258-001 Audit Fees08,6808,68000#DIV/0!#DIV/0!
6025-02-21-258-001 Trsf to Reserve (Account 2051)08,0008,00000#DIV/0!#DIV/0!
6173-02-21-258-001 Insurance6,0596,104457,3250#DIV/0!0.00%
TOTAL ADMINISTRATION-725,796-542,363183,433-981,271000#DIV/0!

*This funding is a projection only; based on 80% of new staffing requirements; additional 3 FT's


TOWN OF SMITHS FALLS Page 40 2023 BUDGET

TOWN OF SMITHS FALLS Page 40

COMMUNITY SERVICES GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
PROGRAMS
6035-02-21-258-084 Regular Salaries & Wages216,761157,409-59,352317,9450 #DIV/0!0.00%
6048-02-21-258-084 Part Time Wages471,702314,552-157,150482,0370 #DIV/0!0.00%
6078-02-21-258-084 Vacation Pay20,37912,520-7,85921,4860 #DIV/0!0.00%
6091-02-21-258-084 Other Payroll Costs132,23288,631-43,601217,1580 #DIV/0!0.00%
6015-02-21-258-084 Travel Expense1000-1001000 #DIV/0!0.00%
6039-02-21-258-084 Staff Training & Develop.3,5001,633-1,8673,5000 #DIV/0!0.00%
6046-02-21-258-084 Program Supplies3,500242-3,2583,5000 #DIV/0!0.00%
TOTAL PROGRAMS848,174574,987-273,1871,045,726000#DIV/0!
DIETARY
6048-02-21-258-024 Part Time Wages34,60131,058-3,54365,6850 #DIV/0!0.00%
6078-02-21-258-024 Vacation Pay2,0761,718-3583,3330 #DIV/0!0.00%
6091-02-21-258-024 Other Payroll Costs4,5186,7482,23014,3900 #DIV/0!0.00%
6015-02-21-258-024 Travel Expense1000-1001000 #DIV/0!0.00%
6017-02-21-258-024 Coffee/Food Supplies24,00016,013-7,98724,0000 #DIV/0!0.00%
TOTAL DIETARY65,29555,537-9,758107,508000#DIV/0!
CDC FUNDRAISING
5557-02-21-258-013 Donations0000 #DIV/0!#DIV/0!
6046-02-21-258-013 Program Supplies0000 #DIV/0!#DIV/0!
6025-02-21-258-013 Transfer to/from Reserve0000 #DIV/0!#DIV/0!
TOTAL CDC FUNDRAISING0000000#DIV/0!

COMMUNITY SERVICES GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
OCCUPANCY
6048-02-21-258-025 Part Time Wages *00012,0900#DIV/0!0.00%
6078-02-21-258-025 Vacation Pay0007250#DIV/0!0.00%
6091-02-21-258-025 Other Payroll Costs0002,5370#DIV/0!0.00%
6046-02-21-258-025 Program Supplies5006731735000#DIV/0!0.00%
6105-02-21-258-025 Hydro2,8001,538-1,2622,0000#DIV/0!0.00%
6106-02-21-258-025 Water2007365361,0000#DIV/0!0.00%
6107-02-21-258-025 Heating Fuel1,0001,9849842,5000#DIV/0!0.00%
6118-02-21-258-025 Tools, Accessories, etc5000-50000#DIV/0!#DIV/0!
6123-02-21-258-025 Property Repairs010,83010,8305,0000#DIV/0!0.00%
6152-02-21-258-025 Lease ("New")24,00020,002-3,99824,0000#DIV/0!0.00%
6015-02-21-258-025 Travel Expense5000-50000#DIV/0!#DIV/0!
* Custodian
TOTAL OCCUPANCY29,50035,7636,26350,352000#DIV/0!
TOTAL CDC GENERAL BUDGET217,173123,924-93,249222,315000#DIV/0!
TOTAL CDC BUDGET217,173123,924-93,249222,315000#DIV/0!

TOWN OF SMITHS FALLS 2023 FINAL OPERATIONAL BUDGET WORKS & UTILITIES

Passed February 21, 202320222022202320232023%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
WATER TREATMENT PLANT CAPITAL BUDGET
5612-01-31-301-309 Trsf from WTP Capital Reserve (Account 2083)-641,944-365,495276,4490#DIV/0!#DIV/0!
6750-01-31-301-000 Water Tower Detailed Design165,00013,691-151,3090#DIV/0!#DIV/0!
6844-01-31-301-000 WTP Financial Plan Update0000#DIV/0!#DIV/0!
6340-01-31-301-000 Equipment Analyzer Replacements7,5004,312-3,1880#DIV/0!#DIV/0!
6177-01-31-301-000 WIN 911 Software - Alarm Call-out System (SCADA)0000#DIV/0!#DIV/0!
6205-01-31-301-138 Trunk Upgrade (New Water Tower)1,820,0000-1,820,0000#DIV/0!#DIV/0!
6387-01-31-301-000 New Water Tower2,335,0000-2,335,0000#DIV/0!#DIV/0!
01-31-301-000-5869 Federal Gas Tax Reserve $$-367,609-363,6803,9290#DIV/0!#DIV/0!
01-31-301-125-6205 Distribution Design; George St.0000#DIV/0!#DIV/0!
01-31-301-350-6732 Beckwith St. Phase 2; Detailed Design0000#DIV/0!#DIV/0!
01-31-301-000-6049 DAF Piping (Drain); Detailed Design0000#DIV/0!#DIV/0!
5421-01-31-301-000 ICIP/Green Stream Grant-1,833,25001,833,2500#DIV/0!#DIV/0!
6808-01-31-301-422 New DAF Drain6,3660-6,3660#DIV/0!#DIV/0!
5615-01-31-301-000 Unfinanced Capital-2,321,75002,321,7500#DIV/0!#DIV/0!
6205-01-31-301-438 Zebra Mussell (Intake) (Incl Engineering)136,1008,971-127,1290#DIV/0!#DIV/0!
6808-01-31-301-438 High Lift Piping (Replacements)35,00033,204-1,7960#DIV/0!#DIV/0!
6808-01-31-301-423 Rebuild HLP 182 (High Lift Pump)21,2200-21,2200#DIV/0!#DIV/0!
6205-01-31-301-350 Beckwith St. Project/Water Mains672,298517,638-154,6600#DIV/0!#DIV/0!
5612-01-31-301-000 Transfer from Reserve (Project Carry-over acct 2051) **-177,380-10,000167,3800#DIV/0!#DIV/0!
6329-01-31-301-000 Low Lift Pump Rebuild9,5490-9,5490#DIV/0!#DIV/0!
6347-01-31-301-000 AIT 165 Inline Pre-reservoir Chlorine Analyzer Replacement10,0008,678-1,3220#DIV/0!#DIV/0!
6433-01-31-301-000 BET (Backwash Equalization Tank) Cleaning & Inspection16,0000-16,0000#DIV/0!#DIV/0!
6808-01-31-301-439 AIT 180 Inline Free Chlorine Analyzer Replacement10,0008,689-1,3110#DIV/0!#DIV/0!
6808-01-31-301-440 Reservoir 1 & 2 Cleaning & Inspection21,0002,851-18,1490#DIV/0!#DIV/0!
6808-01-31-301-441 Equipment Analyzer Failure15,0000-15,0000#DIV/0!#DIV/0!
6690-01-31-301-000 UV Reactor 161 Sensor Replacement25,00014,012-10,9880#DIV/0!#DIV/0!
6478-01-31-301-000 2009 Chev Silverado Replacement36,9000-36,9000#DIV/0!#DIV/0!
01-31-301-001-6360 Replace Turbidity Analyzer (AIT 102 & AIT 184)0000#DIV/0!#DIV/0!
6081-01-31-301-001 Stainless Steel HL pumping Header Repairs0000#DIV/0!#DIV/0!
WATER TREATMENT PLANT CAPITAL0-127,129-127,1290000#DIV/0!

WORKS & UTILITIES GENERAL BUDGET

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
WATER TREATMENT PLANT REVENUE
5820-02-31-301-020 Residential Water-585,515-423,951161,564-621,2210#DIV/0!0.00%
5821-02-31-301-020 Commercial Water-353,267-303,73349,534-347,2270#DIV/0!0.00%
5823-02-31-301-020 Residential Other Municipalities-59,203-50,7328,471-64,2340#DIV/0!0.00%
5824-02-31-301-020 Commercial Other Municipalities-1,524-3,159-1,635-3,9300#DIV/0!0.00%
5825-02-31-301-020 Public Hydrants-64,000-64,0000-64,0000#DIV/0!0.00%
5826-02-31-301-020 Base Service Charge-1,629,776-1,211,066418,710-1,739,7210#DIV/0!0.00%
5827-02-31-301-020 Occupancy Charge-7,500-5,1902,310-7,5000#DIV/0!0.00%
5556-02-31-301-020 Misc Sales00000#DIV/0!#DIV/0!
5828-02-31-301-020 Misc Water Sales-5,500-9,143-3,643-8,1900#DIV/0!0.00%
5829-02-31-301-020 Late Payment Charge-60,000-41,86918,131-55,0000#DIV/0!0.00%
5831-02-31-301-020 Misc Revenue-15,000-9,5905,410-15,0000#DIV/0!0.00%
2020 WTP Financial Plan projects 5.5% rate increase
TOTAL REVENUE-2,781,285-2,122,433658,852-2,926,023000#DIV/0!
ADMINISTRATION
6035-02-31-301-001 Regular Salaries & Wages90,02478,981-11,043107,1750#DIV/0!0.00%
6091-02-31-301-001 Other Payroll Costs24,83117,504-7,32729,4530#DIV/0!0.00%
6011-02-31-301-001 Office Supplies5,0008,4893,4896,5000#DIV/0!0.00%
6015-02-31-301-001 Travel5000-5005000#DIV/0!0.00%
6023-02-31-301-001 Postage15,00013,741-1,25915,0000#DIV/0!0.00%
6029-02-31-301-001 Membership Fees2,5001,252-1,2482,5000#DIV/0!0.00%
6042-02-31-301-001 Courier600212-3886000#DIV/0!0.00%
6102-02-31-301-001 Telephone15,00016,6371,63715,0000#DIV/0!0.00%
6173-02-31-301-001 Insurance26,22826,228031,4740#DIV/0!0.00%
6025-02-31-301-309 Transfer to Capital Reserve (Acct 2083)552,759552,7590552,7590#DIV/0!0.00%
6180-02-31-301-001 Professional Fees8,0007,023-9778,0000#DIV/0!0.00%
6564-02-31-301-001 Mail Sorter3,5003,390-1103,5000#DIV/0!0.00%
TOTAL ADMINISTRATION743,942726,216-17,726772,461000#DIV/0!

TOTAL ADMINISTRATION


TOWN OF SMITHS FALLS 2023 BUDGET Page 44
WORKS & UTILITIES GENERAL BUDGET

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
WATER TREATMENT PLANT OPERATIONS
6035-02-31-301-139 Regular Salaries & Wages209,339159,919-49,420170,4670#DIV/0!0.00%
6048-02-31-301-139 Part Time Wages9,18410,4621,2789,9200#DIV/0!0.00%
6057-02-31-301-139 Overtime14,0008,937-5,06314,0000#DIV/0!0.00%
6069-02-31-301-139 Stat Time11,4599,364-2,09511,4590#DIV/0!0.00%
6067-02-31-301-139 On-Call Pay15,00014,640-36015,0000#DIV/0!0.00%
6078-02-31-301-139 Vacation Pay15,88419,0113,12715,9140#DIV/0!0.00%
6084-02-31-301-139 Sick Pay6,6842,869-3,8156,6840#DIV/0!0.00%
6091-02-31-301-139 Other Payroll Costs83,74372,363-11,38067,4630#DIV/0!0.00%
6039-02-31-301-139 Staff Training & Development15,00010,652-4,34817,5000#DIV/0!0.00%
6040-02-31-301-139 Safety Clothing Allowance2,5002,225-2752,5000#DIV/0!0.00%
6105-02-31-301-139 Hydro210,000122,702-87,298190,0000#DIV/0!0.00%
6107-02-31-301-139 Heating Fuel38,00034,456-3,54438,0000#DIV/0!0.00%
6316-02-31-301-139 Building Mtce - Supplies10,0004,900-5,10010,0000#DIV/0!0.00%
6197-02-31-301-139 Janitorial Services3,0002,953-473,0000#DIV/0!0.00%
6317-02-31-301-139 Building Mtce - Equip32,00031,887-11332,0000#DIV/0!0.00%
6176-02-31-301-139 Computer Maintenance2,5002,160-3403,5000#DIV/0!0.00%
6329-02-31-301-139 Equip. Repairs - Low Lift5000-5005000#DIV/0!0.00%
6330-02-31-301-139 - High Lift5006951955000#DIV/0!0.00%
6331-02-31-301-139 - Intake3,6163,61603,6160#DIV/0!0.00%
6332-02-31-301-139 - AquaDAF6,500171-6,3296,5000#DIV/0!0.00%
6333-02-31-301-139 - Filters1000-1001000#DIV/0!0.00%
6335-02-31-301-139 - Pipes & Valves2,5001,224-1,2762,5000#DIV/0!0.00%
6337-02-31-301-139 - Motor Control15,00010,796-4,20415,0000#DIV/0!0.00%
6334-02-31-301-139 - Process Equip7,50012,8085,3087,5000#DIV/0!0.00%
6118-02-31-301-139 - Small Tools1,00056-9441,5000#DIV/0!0.00%
6762-02-31-301-139 - SCADA10,0008,500-1,50010,0000#DIV/0!0.00%
6177-02-31-301-139 Annual Software Licenses ("New")15,00019,7364,73615,0000#DIV/0!0.00%
6340-02-31-301-139 Analysis Equipment9,0004,128-4,87212,0000#DIV/0!0.00%
6689-02-31-301-139 Chemical Pumps2,0002,5085084,0000#DIV/0!0.00%
6690-02-31-301-139 UV System11,0007,976-3,02411,0000#DIV/0!0.00%
6691-02-31-301-139 Reservoir5,0000-5,0005,0000#DIV/0!0.00%
6692-02-31-301-139 Wastewater System1,0000-1,0001,0000#DIV/0!0.00%
6725-02-31-301-139 Emergency Genset Service10,0005,775-4,22510,0000#DIV/0!0.00%
6728-02-31-301-139 Diesel Fuel4,5000-4,5005,0000#DIV/0!0.00%
6726-02-31-301-139 Calibrate Flow Meter Repairs2,5000-2,5002,8000#DIV/0!0.00%
6727-02-31-301-139 Process Equipment Inventory8,0000-8,0008,0000#DIV/0!0.00%

TOWN OF SMITHS FALLS 2023 BUDGET Page 45
WORKS & UTILITIES GENERAL BUDGET

00-Jan-00
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
WATER TREATMENT PLANT OPERATIONS
xxxx-02-31-301-139 Pay Equity Review Increase00011,1880#DIV/0!0.00%
5612-02-31-301-020 Trsf from Reserve (Acct 2108)000-11,1880#DIV/0!0.00%
6220-02-31-301-139 MESH Contract0009,5000#DIV/0!0.00%
6108-02-31-301-341 Vehicle Fuel (2015 Chev Silverado; F/A 7-0059)1,0001,2672671,0000#DIV/0!0.00%
6110-02-31-301-341 Vehicle Repairs; (2015 Chev Silverado; F/A 7-0059)1,500180-1,3201,5000#DIV/0!0.00%
6128-02-31-301-341 Vehicle Licence; (2015 Chev Silverado; F/A 7-0059)1400-1401400#DIV/0!0.00%
6319-02-31-301-139 Alarm Monitoring2,5001,437-1,0632,5000#DIV/0!0.00%
6193-02-31-301-139 Radio & Pager Maintenance2,000360-1,6402,0000#DIV/0!0.00%
6301-02-31-301-139 Municipal Taxes - PIL167,853167,8530167,8530#DIV/0!0.00%
6342-02-31-301-139 Reagents10,0009,274-72612,0000#DIV/0!0.00%
6280-02-31-301-139 Safety Equipment & Supplies3,0001,346-1,6543,0000#DIV/0!0.00%
6343-02-31-301-139 Lab Supplies3,0005,1182,1185,0000#DIV/0!0.00%
6345-02-31-301-139 Chemicals -Coagulant115,50074,806-40,694133,0000#DIV/0!0.00%
6347-02-31-301-139 - Chlorine27,50031,6104,11027,5000#DIV/0!0.00%
6385-02-31-301-139 - Polymer2,7002,769693,0000#DIV/0!0.00%
6675-02-31-301-139 - Calcium Thiosulfate2,5000-2,5003,0000#DIV/0!0.00%
6676-02-31-301-139 - Sodium Hydroxide35,00044,6479,64740,0000#DIV/0!0.00%
6122-02-31-301-139 - Sodium Chlorite25,00025,0000#DIV/0!0.00%
6311-02-31-301-139 Water Sampling/Lead Testing25,00017,532-7,46823,0000#DIV/0!0.00%
6763-02-31-301-139 Water Conservation Public Relations1,000127-8731,0000#DIV/0!0.00%
6387-02-31-301-139 Water Tower Maintenance5,00016,98311,9835,0000#DIV/0!0.00%
02-31-301-001-6010 Write off Old Accounts0-832-83200#DIV/0!#DIV/0!
6012-02-31-301-139 Principal - New WTP242,496242,4960254,3500#DIV/0!0.00%
6014-02-31-301-139 Interest - New WTP350,849345,200-5,649338,9950#DIV/0!0.00%
6837-02-31-301-139 Compliance Issues4,0002,281-1,7194,0000#DIV/0!0.00%
6346-02-31-301-139 Chemicals - Fluoride10,0000-10,00010,0000#DIV/0!0.00%
TOTAL WATER TREATMENT PLANT OPERATIONS1,806,0471,551,943-229,1041,801,261000#DIV/0!
TOTAL WATER TREATMENT PLANT GENERAL-231,296155,726412,022-352,301000#DIV/0!
TOTAL WATER TREATMENT PLANT-231,29628,597284,893-352,301000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 46
WORKS & UTILITIES

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
WATER POLLUTION CONTROL PLANT CAPITAL BUDGET
6074-01-31-302-000 Control Building SCADA Upgrade0584,632584,6320 #DIV/0!#DIV/0!
6844-01-31-302-000 Wastewater Financial Plan Update0000 #DIV/0!#DIV/0!
6508-01-31-302-000 Chemical Feed Pump #110,6100-10,6100 #DIV/0!#DIV/0!
01-31-302-000-6063 Flow Monitoring Study0000 #DIV/0!#DIV/0!
01-31-302-401-6808 Wet Well Pump Rebuild0000 #DIV/0!#DIV/0!
01-31-302-000-6430 Replacement Bar Screen (Now under one PLC Project)546,271431,592-114,6790 #DIV/0!#DIV/0!
6823-01-31-302-000 Sludge Tank Mixer0000 #DIV/0!#DIV/0!
6808-01-31-302-441 Equipment/Analyzer Failure15,00013,636-1,3640 #DIV/0!#DIV/0!
6508-01-31-302-442 Sewage Lift Pump Rebuild26,52527,2206950 #DIV/0!#DIV/0!
01-31-302-000-6177 WIN 911 Software - Alarm Call-out System (SCADA)0000 #DIV/0!#DIV/0!
01-31-302-000-6534 Replacement Flooring - Laboratory25,70014,170-11,5300 #DIV/0!#DIV/0!
01-31-302-125-6205 Design; George St.0000 #DIV/0!#DIV/0!
01-31-302-429-6823 Sludge Tank Mixer Shaft0000 #DIV/0!#DIV/0!
6511-01-31-302-000 South Secondary Tank Collector26,52521,040-5,4850 #DIV/0!#DIV/0!
6689-01-31-302-000 Chemical Feed Pump #210,6100-10,6100 #DIV/0!#DIV/0!
01-31-302-000-6767 Trenchless Sewer Lining0000 #DIV/0!#DIV/0!
6434-01-31-302-000 South Secondary Tank Isolation Gates53,05018,418-34,6320 #DIV/0!#REF!
01-31-302-000-5869 Federal Gas Tax0000 #DIV/0!#DIV/0!
01-31-302-000-6081 Bar Screen Project (Headworks)550,0000-550,0000 #DIV/0!#DIV/0!
01-31-302-348-6205 Contractor (Lorne St.; Sanitary Sewers)027,22027,2200 #DIV/0!#DIV/0!
01-31-302-348-5873 CWWF Prov Grant **0000 #DIV/0!#DIV/0!
01-31-302-348-5424 CWWF Fed Grant **0000 #DIV/0!#DIV/0!
01-31-302-350-6205 Beckwith St.; Sanitary Sewers411,404320,031-91,3730 #DIV/0!#DIV/0!
5869-01-31-302-350 Federal Gas Tax/Beckwith St.0000 #DIV/0!#DIV/0!
5900-01-31-302-000 OCIF Top-up Funding0000 #DIV/0!#DIV/0!
6732-01-31-302-350 Beckwith St.; Phase 2; Detailed Design0000 #DIV/0!#DIV/0!
5612-01-31-302-309 Transfer from WPCP Capital Reserve (Acct 2085)-1,103,724-1,012,19791,5270 #DIV/0!#DIV/0!
5612-01-31-302-000 Transfer from Reserve (Acct 2051)-571,971-445,762126,2090 #DIV/0!#DIV/0!
6836-01-31-302-394 Trsf from deferred revenue (Rural & Small Municipalities grant)0000 #DIV/0!#DIV/0!
TOTAL WATER POLLUTION CONTROL PLANT CAPITAL00000000 #DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 47

WORKS & UTILITIES GENERAL BUDGET

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.Completed
WATER POLLUTION CONTROL PLANT REVENUE
5611-02-31-302-020 Sewer Surcharge-2,710,831-2,058,440652,391-2,805,9890#DIV/0!0.00%
5556-02-31-302-020 Misc Sales00000#DIV/0!#DIV/0!
5666-02-31-302-020 Pellet Sales-5,000-7714,229-5,0000#DIV/0!0.00%
5667-02-31-302-020 Septage Processing Fees00000#DIV/0!#DIV/0!
5711-02-31-302-020 Montague Twp Fees000-10,8000#DIV/0!0.00%
6491-02-31-302-138 Contracted Services - Town *24,840-99,422-124,262-107,5060#DIV/0!0.00%

2020 WPCP Financial Plan projects 3.5% rate increase

TOTAL REVENUE

* Revised sub-dept. # from 304 to 302 (Formula in cell E247 which is a credit of Works & Utilities cell E115)
ADMINISTRATION
6035-02-31-302-001 Regular Salaries & Wages82,60672,226-10,38097,6800#DIV/0!0.00%
6091-02-31-302-001 Other Payroll Costs24,27715,215-9,06227,8890#DIV/0!0.00%
xxxx-02-31-302-001 Pay Equity Review Increase14,9590#DIV/0!0.00%
5612-02-31-302-020 Trsf from Reserve (Acct 2084)-14,9590#DIV/0!0.00%
6015-02-31-302-001 Travel5000-5005000-100.0%0.00%
6102-02-31-302-001 Telephone15,00015,75975915,0000-100.0%0.00%
6025-02-31-302-309 Transfer to Capital Reserve (Acct 2085)721,469721,4690721,4690#DIV/0!0.00%
6180-02-31-302-001 Professional Fees10,0007,173-2,82710,0000#DIV/0!0.00%
6173-02-31-302-001 Insurance77,67971,189-6,49085,4270#DIV/0!0.00%
TOTAL ADMINISTRATION931,531903,031-28,500957,965000#DIV/0!

TOWN OF SMITHS FALLS

00-Jan-002023 GENERAL BUDGET WORKS & UTILITIESPage 48
2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var. Completed
ACCOUNT/DESCRIPTION306,412215,839-90,573290,1990#DIV/0! 0.00%
6035-02-31-302-001 Regular Salaries & Wages12,00015,2983,29812,0000#DIV/0! 0.00%
6057-02-31-302-001 Overtime9,1844,752-4,4329,9200#DIV/0! 0.00%
6048-02-31-302-001 Part Time Wages15,00015,94794715,0000#DIV/0! 0.00%
6067-02-31-302-001 On-Call Pay10,97111,9741,00310,9710#DIV/0! 0.00%
6069-02-31-302-001 Stat Time16,36615,974-39216,3960#DIV/0! 0.00%
6078-02-31-302-001 Vacation Pay6,6845,537-1,1476,6840#DIV/0! 0.00%
6084-02-31-302-001 Sick Pay117,92492,553-25,371111,6150#DIV/0! 0.00%
6091-02-31-302-001 Other Payroll Costs3,0002,382-6183,5000#DIV/0! 0.00%
6011-02-31-302-001 Office Supplies15,0008,337-6,66317,5000#DIV/0! 0.00%
6039-02-31-302-001 Staff Training3,0002,630-3703,5000#DIV/0! 0.00%
6040-02-31-302-001 Clothing Supplies400,000233,983-166,017380,0000#DIV/0! 0.00%
6105-02-31-302-001 Hydro18,0007,480-10,52018,0000#DIV/0! 0.00%
6106-02-31-302-001 Water25,00020,904-4,09630,0000#DIV/0! 0.00%
6112-02-31-302-001 Equip Rep - Plant - Sewage Lift Station3,00073-2,9273,0000#DIV/0! 0.00%
6430-02-31-302-001 - Grit Removal10,00011,3041,30410,0000#DIV/0! 0.00%
6431-02-31-302-001 - Raw Sludge Bldg10,000499-9,50110,0000#DIV/0! 0.00%
6432-02-31-302-001 - Primary Collectors5,0000-5,0005,0000#DIV/0! 0.00%
6433-02-31-302-001 - Aeration Tanks10,0000-10,00010,0000#DIV/0! 0.00%
6434-02-31-302-001 - Secondary Clarifiers5,0006,9631,9635,0000#DIV/0! 0.00%
6435-02-31-302-001 - RAS Sludge Pumps5,000583-4,4175,0000#DIV/0! 0.00%
6436-02-31-302-001 - Mixing Tanks5,00012,6557,6555,0000#DIV/0! 0.00%
6437-02-31-302-001 - Filters20,00027,1267,12625,0000#DIV/0! 0.00%
6438-02-31-302-001 - UV System5,0000-5,0005,0000#DIV/0! 0.00%
6439-02-31-302-001 - Chemical Pumps2,0001,124-8762,0000#DIV/0! 0.00%
6440-02-31-302-001 - Computers2,00020,200-29,80055,0000#DIV/0! 0.00%
6441-02-31-302-001 Equip Rep - Pelletizer - Belt Press50,0000-5,0005,0000#DIV/0! 0.00%
6442-02-31-302-001 -Twin Mixers5,0003,7967963,0000#DIV/0! 0.00%
6443-02-31-302-001 Equip Rep - Pelletizer - Drying Drum3,0004,698-3025,0000#DIV/0! 0.00%
6444-02-31-302-001 - Secondary Cyclone5,0000-2,0002,0000#DIV/0! 0.00%
6445-02-31-302-001 - Bucket Elevator/Sizer2,000295-1,2051,5000#DIV/0! 0.00%
6446-02-31-302-001 - Storage/Pellet Handling1,5000-2,5002,5000#DIV/0! 0.00%
6447-02-31-302-001 - Computers2,5004,1081,6083,0000#DIV/0! 0.00%
6456-02-31-302-001 - Lift Truck2,50028,614-18,38648,0000#DIV/0! 0.00%
6316-02-31-302-001 Building Maintenance & Cleaning47,0002,312-6883,0000#DIV/0! 0.00%
6197-02-31-302-001 Janitorial Services3,000906-2,0943,0000#DIV/0! 0.00%
6448-02-31-302-001 Bldg Cleaning Supplies3,0002,312-1,7842,5000#DIV/0! 0.00%
6322-02-31-302-001 Small Equipment & Tools2,000216-1,7842,5000#DIV/0! 0.00%
6207-02-31-302-001 Rideau Canal Lease356254-1023560#DIV/0! 0.00%
6208-02-31-302-001 CN Lease2540-2542540#DIV/0! 0.00%
6210-02-31-302-001 Sewer Monitoring Program5,0000-5,0003,0000#DIV/0! 0.00%
6029-02-31-302-001 Membership Fees1,000826-1741,0000#DIV/0! 0.00%
6280-02-31-302-001 Safety Equipment3,0001,399-1,6013,5000#DIV/0! 0.00%

TOWN OF SMITHS FALLS 2023 BUDGET Page 49
WORKS & UTILITIES GENERAL BUDGET 2022 2023

2023 BUDGETPage 49
WORKS & UTILITIES GENERAL BUDGET
00-Jan-0020222022202320232023%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
WATER POLLUTION CONTROL PLANT OPERATIONS
6375-02-31-302-001 Sludge Disposal10,0003,130-6,87010,0000#DIV/0!
6222-02-31-302-001 Pellet Bagging Costs7501,0002507500#DIV/0!
6107-02-31-302-001 Heating Fuel119,00075,042-43,958124,9500#DIV/0!
6108-02-31-302-342 Vehicle Gas (2013 Chev Silverado; F/A 7-0054)1,200985-2151,2000#DIV/0!
6110-02-31-302-342 Vehicle Repairs (2013 Chev Silverado; F/A 7-0054)2,000842-1,1582,0000#DIV/0!
6128-02-31-302-342 Vehicle Licenses (2013 Chev Silverado; F/A 7-0054)2700-2702700#DIV/0!
6311-02-31-302-001 Sampling35,00022,538-12,46235,0000#DIV/0!
6547-02-31-302-001 Sampling Equipment Repairs2,0003,0731,0732,5000#DIV/0!
6319-02-31-302-001 Alarm Monitoring2,500778-1,7222,5000#DIV/0!
6119-02-31-302-001 Radio & Pager Maintenance2,5000-2,5002,5000#DIV/0!
6042-02-31-302-001 Courier5009364361,0000#DIV/0!
6343-02-31-302-001 Lab Supplies5,0003,322-1,6787,5000#DIV/0!
6344-02-31-302-001 Chemicals - Coagulant95,00062,469-32,531115,0000#DIV/0!
6385-02-31-302-001 - Polymer40,00033,807-6,19340,0000#DIV/0!
6012-02-31-302-251 Pelletizer - Principal33,42630,587-2,83934,8470#DIV/0!
6014-02-31-302-251 Pelletizer - Interest20,42318,775-1,64819,0030#DIV/0!
6012-02-31-302-355 Energy Audit - Principal15,37014,073-1,29715,8190#DIV/0!
6014-02-31-302-355 Energy Audit - Interest6,6786,137-5416,2280#DIV/0!
6342-02-31-302-001 Reagents5,0003,769-1,2317,5000#DIV/0!
6095-02-31-302-001 Emergency Equipment30,00035,4425,44235,0000#DIV/0!
6177-02-31-302-001 Annual Software Licenses10,00014,8454,84512,0000#DIV/0!
6762-02-31-302-001 SCADA Repairs12,0002,001-9,99910,0000#DIV/0!
6766-02-31-302-001 CSO Repairs5,000672-4,3285,0000#DIV/0!
6607-02-31-302-001 Compliance Issues1,500772-7281,5000#DIV/0!
6073-02-31-302-001 Pelletizer Parts Inventory25,00023,882-1,11830,0000#DIV/0!
6493-02-31-302-001 Sludge Holding Tanks1,000646-3541,0000#DIV/0!
6494-02-31-302-001 Sludge Pumps1,0000-1,0002,5000#DIV/0!
6495-02-31-302-001 Main Heat Exchanger1,0000-1,0001,0000#DIV/0!
6105-02-31-302-035 Hydro (Pumping Station)4,5000#DIV/0!
6102-31-302-035 Communications (Pumping Station)6,0000#DIV/0!
6110-02-302-035 Pumping Station Repairs7,5000#DIV/0!
6220-02-31-302-001 MESH Contract "New"9,5000#DIV/0!
6491-02-31-304-138 Contracted Services - Town (See "revenue" section)24,840-99,422-124,2620000#DIV/0!
6492-02-31-302-012 Use of Town Vehicles; Subject to change *53,19553,62042463,499000#DIV/0!
6301-02-31-302-001 Municipal Taxes - PIL100,122100,1220100,1220#DIV/0!
* Chg'd sub-dept. from 304 to 302
TOTAL WATER POLLUTION CONTROL PLANT OPERATIONS1,835,9251,195,384-640,5421,869,5830000#DIV/0!
TOTAL WATER POLLUTION CONTROL PLANT GENERAL76,465-60,219-136,684-101,7470000#DIV/0!

TOTAL WATER POLLUTION CONTROL PLANT76,465-60,219-136,684-101,747000#DIV/0!

TOWN OF SMITHS FALLS 2023 FINAL OPERATIONAL BUDGET

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
INFRASTRUCTURE MAINTENANCE
ROAD & SEWER NETWORK PER SCHEDULE A - DEPARTMENTAL SUB-LEDGER (Page 87 - 88)
Equipment Purchases0000000#DIV/0!#DIV/0!
Municipal Road Work0000000#DIV/0!#DIV/0!
Bridges0000000#DIV/0!#DIV/0!
Public Works Buildings0000000#DIV/0!#DIV/0!
TOTAL CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 51
PUBLIC WORKS & UTILITIES GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 Actual INFRASTRUCTURE MAINTENANCE ADMINISTRATION2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2022 Budget247,46538,068830,1992023 Budget2023 To Date2023 ActualVar.% Var.% Completed
6035-02-31-303-001 Regular Salaries *209,397120-38,28039,6800#DIV/0!0.00%
6048-02-31-303-001 Part-time Salaries38,40034,56914,56915,0000#DIV/0!0.00%
6057-02-31-303-001 Overtime20,00017,62662617,0000#DIV/0!0.00%
6067-02-31-303-001 Shift Premium17,00027,013-20027,2130#DIV/0!0.00%
6069-02-31-303-001 Stat Time27,21342,176-20,30662,4340#DIV/0!0.00%
6078-02-31-303-001 Vacation Pay62,48240,11524,24115,8740#DIV/0!0.00%
6084-02-31-303-001 Sick Time15,874174,06574,097359,1620#DIV/0!0.00%
6091-02-31-303-001 Other Payroll Costs99,9683,4301,4303,0000#DIV/0!0.00%
6280-02-31-303-001 Safety Material2,000007,8000#DIV/0!0.00%
6176-02-31-303-001 GSP Main Fee "New"00034,1640#DIV/0!0.00%
xxx-02-31-303-001 Pay Equity Review Increase000-34,1640#DIV/0!0.00%
5612-02-31-303-413 Trsf from Reserve (Account 2050)00000#DIV/0!0.00%
6792-02-31-303-413 COVID-19 Expenditures05,8465,84600#DIV/0!#DIV/0!
6851-02-31-303-001 Patrols & Records14,00011,042-2,95822,0000#DIV/0!0.00%
6180-02-31-303-001 Professional Fees4,0001,600-2,4004,0000#DIV/0!0.00%
6039-02-31-303-001 Staff Training & Equipment14,00011,098-2,90215,0000#DIV/0!0.00%
6164-02-31-303-001 Liability Insurance Claim8,00027,30619,30610,0000#DIV/0!0.00%
6040-02-31-303-001 Clothing Supplies11,00015,2424,24212,0000#DIV/0!0.00%
6102-02-31-303-001 Telephone6,5007,9751,4757,2000#DIV/0!0.00%
TOTAL ADMINISTRATION549,834666,688116,8541,447,5620000#DIV/0!
* $35 K in Dist & $40 K in PW "Main Sewers"
DEBT SERVICING
6012-02-31-311-213 Building Loan - Principal1,5231,393-1301,5870#DIV/0!0.00%
6014-02-31-311-213 Building Loan - Interest930855-758660#DIV/0!0.00%
6012-02-31-302-223 CSO Tank - Principle **39,76319,690-20,07341,3290#DIV/0!0.00%
6014-02-31-302-223 CSO Tank - Interest **45,49922,942-22,55743,9330#DIV/0!0.00%
6012-02-31-311-428 2020 Capital Roadworks *00022,1670#DIV/0!0.00%
6014-02-31-311-428 2020 Capital Roadworks *00044,5190#DIV/0!0.00%
6012-02-31-311-214 2006/7 Road Projects - Princ5,3984,940-4585,6280#DIV/0!0.00%
6014-02-31-311-214 2006/7 Road Projects - Int3,2993,033-2663,0690#DIV/0!0.00%
* Pending loan at 2022 year-end ** CSO Tank Loan; Previously on WPCP budget on page 51; storm-related; not wastewater
TOTAL DEBT SERVICING96,41252,853-43,559163,098000#DIV/0!

TOWN OF SMITHS FALLS
2023 BUDGETPage 52
PUBLIC WORKS & UTILITIES
GENERAL BUDGET
Passed February 21, 202320222022202320232023%%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.

INFRASTRUCTURE MAINTENANCE

PER SCHEDULE B - DEPARTMENTAL SUBLEDGER (Page 89 - 96)

Bridges & Culverts49,4002,599-46,80154,000000#DIV/0!0.00%
Grass & Weed Mowing27,8009,600-18,2003,000000#DIV/0!0.00%
Grading & Shoulder Maintenance13,3004,843-8,4576,500000#DIV/0!0.00%
Main Sewers293,215189,292-103,923190,900000#DIV/0!0.00%
House Sewers28,4008,061-20,3398,000000#DIV/0!0.00%
Storm Sewers/Catch Basins69,20053,180-16,02015,000000#DIV/0!0.00%
Railway Crossing Maintenance12,5009,810-2,69013,000000#DIV/0!0.00%
Dust Control7,3000-7,300500000#DIV/0!0.00%
Winter Control; Plowing/Sanding/Salting Roads231,080118,097-112,983130,000000#DIV/0!0.00%
Winter Control; Snow Removal112,60065,920-46,68071,500000#DIV/0!0.00%
Winter Control; Sidewalks43,52016,831-26,6890000#DIV/0!#DIV/0!
Winter Control; Parking & Facilities17,0002,343-14,6570000#DIV/0!#DIV/0!
Traffic Signals78,36056,521-21,83977,000000#DIV/0!0.00%
Traffic Markings36,36029,149-7,21142,000000#DIV/0!0.00%
Street Repair266,013224,121-41,892205,000000#DIV/0!0.00%
Street Lighting171,381190,12918,748180,936000#DIV/0!0.00%
Street Signs40,20026,587-13,61323,000000#DIV/0!0.00%
Street Cleaning38,80031,017-7,7830000#DIV/0!#DIV/0!
Curbs & Sidewalk Repairs118,920121,5992,67984,000000#DIV/0!0.00%
Tree Servicing54,00033,888-20,11219,500000#DIV/0!0.00%
Buildings & Grounds93,50091,897-1,60359,600000#DIV/0!0.00%
Litter and Garbage Pick-up28,45019,668-8,7821,500000#DIV/0!0.00%
5860-02-31-303-051 Allocated To Water Dept *-24,84099,422124,262107,50600000.00%
TOTAL ROADS MAINTENANCE1,806,4591,404,574-401,8851,292,442000#DIV/0!

*** House/Main Sewers reallocated to WPCP; less credit for storm expense allocation from taxation; phase-in @$306,406; increase of $9,631 from 2022** As of Nov 23, 2022, Jason Barlow requested that this be reallocated to WPCP revenue section (see formula in cell E115)


ACCOUNT/DESCRIPTION

TOWN OF SMITHS FALLS 2023 BUDGET PUBLIC WORKS & UTILITIES GENERAL BUDGETPage 53
Passed February 21, 20232022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
EQUIPMENT MAINTENANCE PER SCHEDULE C - SUBLEDGER (Page 97 - 105)
6035-02-31-303-052 Regular Salaries & Wages30,00020,907-9,0930000#DIV/0!#DIV/0!
6091-02-31-303-070 Other Payroll Costs10,8006,559-4,2410000#DIV/0!#DIV/0!
6108-02-31-303-070 Gas & Oil68,50083,12514,625113,500000#DIV/0!0.00%
6762-02-31-303-070 COVID-19 Expenditures2,0005,8463,8462,000000#DIV/0!0.00%
6110-02-31-303-070 Repairs89,50083,585-5,915103,000000#DIV/0!0.00%
6128-02-31-303-070 Licenses5,0400-5,0404,500000#DIV/0!0.00%
6112-02-31-303-070 Equipment Repairs23,00021,629-1,37125,000000#DIV/0!0.00%
xxxx-02-31-303-070 Enterprise Lease Payments42,685000#DIV/0!0
5612-02-31-303-070 Trsf from Reserve (PCO; acct 2051)-35,000000#DIV/0!0
6115-02-31-303-070 Equipment Rental1,000853-1471,500000#DIV/0!0.00%
6119-02-31-303-070 Radio Repairs2,5001,217-1,2831,500000#DIV/0!0.00%
6135-02-31-303-070 Diesel-3,0007,54810,54815,000000#DIV/0!0.00%
6173-02-31-303-070 Insurance12,45612,456014,948000#DIV/0!0.00%
5860-02-31-303-070 Allocated to Water Dept *-53,195-53,620-424-63,49900000.00%
TOTAL ROADS EQUIPMENT MAINTENANCE * 22% Reallocated to WPCP for maintenance188,601190,1061,505225,134000#DIV/0!
TOTAL ROAD MAINTENANCE GENERAL BUDGET2,641,3062,314,221-327,0853,128,236000#DIV/0!
TOTAL ROAD MAINTENANCE BUDGET2,641,3062,314,221-327,0853,128,236000#DIV/0!

TOWN OF SMITHS FALLS 2023 FINAL OPERATIONAL BUDGET

Passed February 21, 2023

Passed February 21, 2023
2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTIONINFRASTRUCTURE MAINTENANCE WATER DISTRIBUTION NETWORK
01-31-304-000-6072 Water Meter Replacements47,38038,730-8,6500#DIV/0!#DIV/0!
01-31-304-424-6808 Correlation Equipment0000#DIV/0!#DIV/0!
01-31-304-138-6030 Emergency Repairs (Water Main; Victoria Basin)0000#DIV/0!#DIV/0!
01-31-304-309-5612 Trsf from WTP Capital Reserve (Acct 2083)-47,380-38,7308,6500#DIV/0!#REF!
01-31-304-000-6614 1/2 Ton Truck (Replacement of 7-0042)0000#DIV/0!#DIV/0!
01-31-304-000-5612 Transfer from Reserve (Acct 2051)0000#DIV/0!#DIV/0!
TOTAL WATER DISTRIBUTION CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 55

WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET

WORKS & STEM HES DEPARTMENTAL GENERAL BUDGET
20222022202320232023%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
INFRASTRUCTURE MAINTENANCE
WATER DISTRIBUTION NETWORK - STAFFING COSTS
6035-02-31-304-001 Regular Salaries & Wages *149,210197,91148,701326,0150#DIV/0!0.00%
6048-02-31-304-001 Part-time Wages9,9200#DIV/0!0.00%
6057-02-31-304-001 Overtime8,0007,399-60116,6500#DIV/0!0.00%
6067-02-31-304-001 Shift Premium6,0008,6112,6116,0000#DIV/0!0.00%
6083-02-31-304-001 On-Call15,0000#DIV/0!0.00%
6069-02-31-304-001 Stat Time15,00010,212-4,78815,0000#DIV/0!0.00%
6078-02-31-304-001 Vacation Pay19,00025,3966,39619,3970#DIV/0!0.00%
6084-02-31-304-001 Sick Pay20,0003,483-16,51720,0000#DIV/0!0.00%
6091-02-31-304-001 Other Payroll Costs66,12689,18723,061132,0280#DIV/0!0.00%
xxxx-02-31-304-001 Pay Equity Review Increase15,2660#DIV/0!0.00%
5612-02-31-304-020 Trsf from Reserve (Acct 2108)-15,2660#DIV/0!0.00%
5831-02-31-304-020 Misc Revenue-4,500-16,336-11,836-4,5000#DIV/0!0.00%
6011-02-31-304-001 Office Supplies4,550759-3,7914,5500#DIV/0!0.00%
6025-02-31-304-309 Transfer to Capital Reserve00000#DIV/0!#DIV/0!
6039-02-31-304-001 Employee Training6,5001,924-4,5766,5000#DIV/0!0.00%
6280-02-31-304-001 Safety Material2,000705-1,2952,0000#DIV/0!0.00%
6220-02-31-304-001 MESH Contract "New"7,5000#DIV/0!0.00%
6040-02-31-304-001 Clothing Allowance5,5002,067-3,4335,5000#DIV/0!0.00%
6051-02-31-304-001 Safety Equipment2,000705-1,2952,0000#DIV/0!0.00%
TOTAL STAFFING COST200,386222,02222,627582,560000#DIV/0!
EQUIPMENT MAINTENANCE
6112-02-31-304-012 Small Equipment3,6003,244-3564,0000#DIV/0!0.00%
6118-02-31-304-012 Small Tools2,5002,039-4614,2000#DIV/0!0.00%
6135-02-31-304-012 Diesel4,5000-4,5004,5000#DIV/0!0.00%
TOTAL EQUIPMENT MAINTENANCE10,6005,283-5,31712,700000#DIV/0!
WATER DISTRIBUTION NETWORK - VEHICLE & HEAVY EQUIPMENT SUMMARY
2018 CHEV SILVERADO TRUCK (F/A #7-0071)
6108-02-31-304-385 Vehicle Gas & Oil2,5003,7661,2663,5000#DIV/0!0.00%
6110-02-31-304-385 Vehicle Repairs1,200703-4971,2000#DIV/0!0.00%
6128-02-31-304-385 Vehicle Licence1600-1601600#DIV/0!0.00%
TOTAL 2018 CHEV SILVERADO (F/A 7-0071)3,8604,4696094,860000#DIV/0!

TOWN OF SMITHS FALLS

2023 BUDGET Page 56

WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2022 2022 2023 2023

20222022202320232023%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.
INFRASTRUCTURE MAINTENANCE

WATER DISTRIBUTION NETWORK - VEHICLE & HEAVY EQUIPMENT SUMMARY

2009 CHEV SILVERADO 1/2-TON 4 X 4, UNIT 105 (F/A #7-0039) 3,000 4,471 1,471

6108-02-31-304-333 Vehicle Gas & Oil3,0004,4711,4710#DIV/0!#DIV/0!
6270-02-31-304-334 Lease Payments (Enterprise)21,5130#DIV/0!0.00%
5612-02-31-304-334 Trsf from Reserve (PCO acct 2051)-21,5130#DIV/0!0.00%
6110-02-31-304-333 Vehicle Repairs2,6002,343-2570#DIV/0!#DIV/0!
6128-02-31-304-333 Vehicle Licence2950-2952950#DIV/0!0.00%
TOTAL 2009 CHEV SILVERADO (F/A 7-0039)5,8956,814919295000#DIV/0!

2013 CHEV SILVERADO 1/2-TON 4 X 4, UNIT 106 (F/A #7-0050) 4,500 5,256 756

2010 CHEV SILVERADO / 2 / TON 4 × 4, 8N1 100 (7/A #7/8050)
6108-02-31-304-334 Vehicle Gas & Oil4,5005,2567560#DIV/0!#DIV/0!
6270-02-31-304-334 Lease Payments (Enterprise)21,5130#DIV/0!0.00%
5612-02-31-304-334 Trsf from Reserve (PCO acct 2051)-15,3870#DIV/0!0.00%
6110-02-31-304-334 Vehicle Repairs3,0002,489-5110#DIV/0!#DIV/0!
6128-02-31-304-334 Vehicle Licence2950-2952950#DIV/0!0.00%
TOTAL 2013 CHEV SILVERADO (F/A 7-0050)7,7957,745-506,421000#DIV/0!

1-ton being replaced with 1/2-ton

2005 CHEV SILVERADO 1-TON; UNIT 107 (F/A 7-0042) *
6108-02-31-304-335 Vehicle Gas & Oil00000#DIV/0!#DIV/0!
6110-02-31-304-335 Vehicle Repairs00000#DIV/0!#DIV/0!
6128-02-31-304-335 Vehicle Licence00000#DIV/0!#DIV/0!
TOTAL 2005 CHEV SILVERADO (F/A 7-0042)00000000#DIV/0!

*** Transferred to Community Services June 22, 2018**

2010 CHEV CUBE/UTILITY VAN; UNIT 102 (F/A 7-0041) 1,000 2,835 1,835 2,500

2010 CHEV CUBE/UTILITY VAN; UNIT 102 (F/A 7-0041)
6108-02-31-304-337 Vehicle Gas & Oil1,0002,8351,8352,5000#DIV/0!0.00%
6270-02-31-304-337 Lease Payments (Enterprise)15,1910#DIV/0!0.00%
6110-02-31-304-337 Vehicle Repairs2,500202-2,29800#DIV/0!#DIV/0!
6128-02-31-304-337 Vehicle Licence3950-3953950#DIV/0!0.00%
TOTAL 2010 CHEV CUBE/UTILITY VAN (F/A 7-0041)3,8953,037-85818,08600#DIV/0!

TOWN OF SMITHS FALLS
2023 BUDGETPage 57
WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET
20222022202320232023%%
ACCOUNT/DESCRIPTIONBudget INFRASTRUCTURE MAINTENANCEBudget to DateActualVar.Var.Completed

WATER DISTRIBUTION NETWORK - VEHICLE & HEAVY EQUIPMENT SUMMARY 2019 Case 590N Backhoe

2019 Case 590N Backhoe
6108-02-31-304-339 Vehicle Gas & Oil4,5003,105-1,39500#DIV/0!#DIV/0!
6110-02-31-304-339 Vehicle Repairs4,50015,65411,15400#DIV/0!#DIV/0!
6128-02-31-304-339 Vehicle Licence00000#DIV/0!#DIV/0!
TOTAL 2019 CASE BACKHOE9,00018,7599,7590000#DIV/0!

WATER DISTRIBUTION NETWORK - WATER MAINS

6035-02-31-304-138 PW Regular Salary Wages ("New")25,00036,41111,41135,0000#DIV/0!0.00%
6057-02-31-304-138 Overtime4,5001,289-3,2115,0000#DIV/0!0.00%
6091-02-31-304-138 Other Benefits10,6208,267-2,35310,6200#DIV/0!0.00%
6268-02-31-304-138 Water Mains; Materials20,00028,7558,75530,0000#DIV/0!0.00%
6205-02-31-304-138 Water Mains; Contracted Services20,00097,50777,50760,0000#DIV/0!0.00%
6303-02-31-304-286 Water Mains Condition Rating5,000153-4,8470#DIV/0!#DIV/0!
6311-02-31-304-138 Water Mains Sampling Stations0005,0000#DIV/0!0.00%
TOTAL WATER MAINS85,120172,38287,262145,620000#DIV/0!

WATER DISTRIBUTION NETWORK - WATER SERVICES 20,000 5,995-14,005 0

WATER DISTRIBUTION NETWORK - WATER SERVICES
6035-02-31-304-328 Regular Salary Wages20,0005,995-14,00500#DIV/0!#DIV/0!
6057-02-31-304-328 Overtime2,1001,166-93400#DIV/0!#DIV/0!
6091-02-31-304-328 Other Benefits7,9561,561-6,39500#DIV/0!#DIV/0!
6268-02-31-304-328 Water Services; Materials22,00029,9517,95125,0000#DIV/0!0.00%
6205-02-31-304-328 Water Services; Contracted Services35,00047,65512,65540,0000#DIV/0!0.00%
6304-02-31-304-138 Water Services00015,0000#DIV/0!0.00%
TOTAL WATER SERVICES87,05686,328-72880,000000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 58
WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget INFRASTRUCTURE2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.Completed

WATER DISTRIBUTION NETWORK - FIRE HYDRANTS/FLUSHING PROGRAM 6035-02-31-304-329 Regular Salary Wages 20,000 11,976-8,024 0

6035-02-31-304-329 Regular Salary Wages20,00011,976-8,02400#DIV/0!#DIV/0!
6057-02-31-304-329 Overtime80023-77700#DIV/0!#DIV/0!
6091-02-31-304-329 Other Benefits7,4882,552-4,93600#DIV/0!#DIV/0!
6268-02-31-304-329 Fire Hydrants; Materials12,00028,13816,13815,0000#DIV/0!0.00%
5902-02-31-304-329 Town Equipment Adjustment0000#DIV/0!#DIV/0!
6205-02-31-304-329 Fire Hydrants; Contracted Services2,5005,3882,88810,0000#DIV/0!0.00%
6306-02-31-304-138 Fire Hydrants00015,0000#DIV/0!0.00%
TOTAL FIRE HYDRANTS/FLUSHING PROGRAMS42,78848,0775,28940,000000#DIV/0!

WATER DISTRIBUTION NETWORK - VALVE MAINTENANCE/VALVE TURNING 6035-02-31-304-320 Regular Salary Wages 18,000 15,979-2,021

WATER DISTRIBUTION NETWORK - VALVE MAINTENANCE/VALVE TURNING
6035-02-31-304-320 Regular Salary Wages18,00015,979-2,0210#DIV/0!#DIV/0!
6057-02-31-304-320 Overtime1,00093-9070#DIV/0!#DIV/0!
6091-02-31-304-320 Other Benefits6,8403,580-3,2600#DIV/0!#DIV/0!
6268-02-31-304-320 Valves; Materials10,000481-9,51915,0000#DIV/0!0.00%
6205-02-31-304-320 Valves; Contracted Services4,0000-4,00010,0000#DIV/0!0.00%
6305-02-31-304-138 Valves0000#DIV/0!#DIV/0!
TOTAL VALVE MAINTENANCE/VALVE TURNING39,84020,133-19,70725,000000#DIV/0!

WATER DISTRIBUTION NETWORK - WATER METERS/METER READING 6035-02-31-304-331 Regular Salary Wages 30,000 15,346-14,654

6035-02-31-304-331 Regular Salary Wages30,00015,346-14,6540#DIV/0!#DIV/0!
6057-02-31-304-331 Overtime0000#DIV/0!#DIV/0!
6091-02-31-304-331 Other Benefits10,8003,368-7,4320#DIV/0!#DIV/0!
6268-02-31-304-331 Water Meters; Materials40,0007,188-32,81250,0000#DIV/0!0.00%
6205-02-31-304-331 Water Meters; Contracted Services2,5004,7342,23410,0000#DIV/0!0.00%
6309-02-31-304-138 Water Meters0000#DIV/0!#DIV/0!
TOTAL WATER METERS/METER READING83,30030,636-52,66460,000000#DIV/0!

ACCOUNT/DESCRIPTIONTOWN OF SMITHS FALLS 2023 BUDGET WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2022 BudgetTOWN OF SMITHS FALLS 2023 BUDGET WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2022 ActualTOWN OF SMITHS FALLS 2023 BUDGET WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2023 Var.TOWN OF SMITHS FALLS Page 59 WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2023 BudgetTOWN OF SMITHS FALLS Page 59 WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2023 To DateTOWN OF SMITHS FALLS Page 59 WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET ActualTOWN OF SMITHS FALLS WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET % Var.TOWN OF SMITHS FALLS WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET % Var.TOWN OF SMITHS FALLS WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET Completed
INFRASTRUCTURE MAINTENANCE
WATER DISTRIBUTION NETWORK - ONTARIO ONE CALLS
6035-02-31-304-332 Regular Salary Wages27,06212,222-14,8400#DIV/0!#DIV/0!
6057-02-31-304-332 Overtime2500-2500#DIV/0!#DIV/0!
6091-02-31-304-332 Other Benefits9,8322,673-7,1590#DIV/0!#DIV/0!
6114-02-31-304-332 Town Equipment0000#DIV/0!#DIV/0!
5902-02-31-304-332 Town Equipment Adjustment0000#DIV/0!#DIV/0!
6205-02-31-304-332 Ontario One Calls; Contractor1,4001,6102102,5000#DIV/0!0.00%
TOTAL ONTARIO ONE CALLS38,54416,505-22,0392,500000#DIV/0!
WATER DISTRIBUTION NETWORK - AIR CARE DR BUILDING
6184-02-31-304-051 Supplies65026-6246500#DIV/0!0.00%
6112-02-31-304-051 Equipment1,7000-1,7001,7000#DIV/0!0.00%
6102-02-31-304-158 Telephone8,0009,4151,4158,0000#DIV/0!0.00%
TOTAL AIR CARE DR BUILDING10,3509,441-90910,350000#DIV/0!
* Utilities for Air Care Dr. Bldg; under Tax-Supported Budget
TOTAL WATER DISTRIBUTION GENERAL727,429761,63234,203989,392000#DIV/0!
TOTAL WATER DISTRIBUTION BUDGET727,429761,63234,203989,392000#DIV/0!

TOWN OF SMITHS FALLS PAGE 60 2023 FINAL OPERATIONAL BUDGET

TOWN OF SMITHS FALLS PAGE 60

Passed February 21, 2023

ADMINISTRATION

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
6639-01-41-101-000 Land Needs Study0000#DIV/0!#DIV/0!
6833-01-41-101-000 Secondary Plan90,0000-90,0000#DIV/0!#DIV/0!
6283-01-41-101-000 Zoning Bylaw Update23,06726,9213,8540#DIV/0!#DIV/0!
6838-01-41-101-000 Development Charge Study011,35611,3560#DIV/0!#DIV/0!
5612-01-41-101-000 Tsf from Reserve (Account 2051)-169,736-58,067111,6690#DIV/0!#DIV/0!
5612-01-41-101-309 Trsf from Capital Reserve (Account 2083)-140,000-28,192111,8080#DIV/0!#DIV/0!
01-41-101-000-6845 Affordable Housing & CIP Update50,00030,682-19,3180#DIV/0!#DIV/0!
01-41-101-430-6177 E-Permitting Solution/Records Digitization76,18063,326-12,8540#DIV/0!#DIV/0!
01-41-101-430-5421 Municipal Modernization Grant-49,511-32,18217,3290#DIV/0!#DIV/0!
01-41-101-430-6836 Trsf to/from Deferred Revenue0-17,417-17,4170#DIV/0!#DIV/0!
01-41-101-352-6836 Trsf to/from Deferred Revenue (MIIO Project)0000#DIV/0!#DIV/0!
01-41-101-000-5424 Federal Grant-Local Immigration0000#DIV/0!#DIV/0!
01-41-101-000-6639 Heritage Conservation District Study120,0003,573-116,4270#DIV/0!#DIV/0!
TOTAL ADMINISTRATION CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS Page 61 2023 BUDGET

CORPORATE SERVICES GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ADMINISTRATION
5499-02-41-101-020 GST - Rebate-3,30003,300-3,3000 #DIV/0!0.00%
5511-02-41-101-020 Tax Certificates-15,000-10,2564,744-15,0000 #DIV/0!0.00%
5514-02-41-101-020 Business Licenses-500-1,050-550-5000 #DIV/0!0.00%
5865-02-41-101-020 Development Charges Revenue0-1,050,014-1,050,01400 #DIV/0!#DIV/0!
5516-02-41-101-020 Interest on Investments-70,000-364,596-294,596-100,0000 #DIV/0!0.00%
6025-02-41-101-000 Trsf interest to reserve accounts0226,782226,78200 #DIV/0!#DIV/0!
6836-02-41-101-000 Trst interest; deferred revenue04,4164,41600 #DIV/0!#DIV/0!
6869-02-41-101-000 Trst to DC Fund Reserve01,050,0141,050,01400 #DIV/0!#DIV/0!
5518-02-41-101-020 Interest/Penalty on Taxes-178,000-161,63016,370-178,0000 #DIV/0!0.00%
5519-02-41-101-020 NSF Cheque Fees-1,800-1,871-71-2,0000 #DIV/0!0.00%
5520-02-41-101-020 Postage Charges - Other-15,000-15,160-160-16,0000 #DIV/0!0.00%
5521-02-41-101-020 Photocopy Charges - Other-1,00001,00000 #DIV/0!#DIV/0!
5556-02-41-101-020 Misc. Revenue0-1,217-1,21700 #DIV/0!#DIV/0!
6025-02-41-101-000 Trsf to Capital Reserve (Surplus TCA)00000 #DIV/0!#DIV/0!
5562-02-41-101-020 Death Registrations-3,50003,500-3,5000 #DIV/0!0.00%
5563-02-41-101-020 Marriage Licenses-5,000-10,690-5,690-5,0000 #DIV/0!0.00%
5658-02-41-101-020 Comm. of Oath Fees-1,500-1,538-38-1,0000 #DIV/0!0.00%
5875-02-41-101-020 Freedom of Info Fees-50-105-55-500 #DIV/0!0.00%
6618-02-41-101-020 Tax Letters-500-825-325-1,0000 #DIV/0!0.00%
0
TOTAL ADMINISTRATION REVENUE-295,150-337,740-42,590-325,3500000 #DIV/0!

TOWN OF SMITHS FALLS Page 62 2023 BUDGET CORPORATE SERVICES GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
6035-02-41-101-000 Regular Salaries & Wages *744,376682,215-62,161904,4860#DIV/0!0.00%
6048-02-41-101-000 Part Time Wages00000#DIV/0!#DIV/0!
6091-02-41-101-000 Other Payroll Costs208,057209,2451,188252,1380#DIV/0!0.00%
5612-02-41-101-020 Trsf from Reserve (Acct 2050)000-28,9160#DIV/0!0.00%
6792-02-41-101-413 COVID-19 Expenditures037637600#DIV/0!#DIV/0!
5421-02-41-101-413 COVID-19 Funding00000#DIV/0!#DIV/0!
6011-02-41-101-000 Office Supplies20,00015,518-4,48220,0000#DIV/0!0.00%
6015-02-41-101-000 Travel Expenses5,0001,117-3,8835,0000#DIV/0!0.00%
6017-02-41-101-000 Coffee/Food Supplies2,000822-1,1782,0000#DIV/0!0.00%
6019-02-41-101-000 Photocopy Supplies2,0000-2,0001,0000#DIV/0!0.00%
6023-02-41-101-000 Postage37,00043,2466,24639,0000#DIV/0!0.00%
6026-02-41-101-000 Printing4,0003,154-8464,0000#DIV/0!0.00%
6029-02-41-101-000 Membership Fees5,5004,007-1,4937,0000#DIV/0!0.00%
6032-02-41-101-000 Conferences5,000458-4,5425,0000#DIV/0!0.00%
6038-02-41-101-000 Advertising7,0008,3391,3392,0000#DIV/0!0.00%
6039-02-41-101-000 Staff Training & Develop.25,0003,875-21,12525,0000#DIV/0!0.00%
6042-02-41-101-000 Courier500127-3735000#DIV/0!0.00%
6051-02-41-101-000 Health & Safety4,0008,5734,5735,0000#DIV/0!0.00%
6101-02-41-101-000 Interest from Tax Write Off00000#DIV/0!#DIV/0!
6102-02-41-101-000 Telephone5,5004,673-8275,5000#DIV/0!0.00%
6173-02-41-101-000 Insurance132,413132,4141158,8960#DIV/0!0.00%
xxxx-02-41-101-000 Pay Equity Review Increase00028,9160#DIV/0!0.00%
6836-02-41-101-413 Transfer to Deferred Revenue00000#DIV/0!#DIV/0!
6174-02-41-101-000 Audit Fees32,00035,3343,33445,0000#DIV/0!0.00%
6178-02-41-101-000 Bank Service Fees3,0005,3202,32000#DIV/0!#DIV/0!
6258-02-41-101-000 Cash Short & Over02,4932,49300#DIV/0!#DIV/0!
6180-02-41-101-000 Professional Fees **70,00089,13219,132188,0000#DIV/0!0.00%
5612-02-41-101-000 Transfer from Reserve (Account 2271)-25,000-25,0000-50,0000#DIV/0!0.00%
6175-02-41-101-000 Support - Main Hdwe40,00028,806-11,19440,0000#DIV/0!0.00%
6027-02-41-101-000 Photocopier Lease12,0004,729-7,2717,0000#DIV/0!0.00%
6564-02-41-101-000 Mail Sorter3,5003,390-1103,5000#DIV/0!0.00%

TOTAL ADMINISTRATION EXPENSES1,342,8461,262,363-80,4831,670,020000#DIV/0!
  • Incl of potential increase due to reorganizational structure per CAO @$100 K ** Inclusive of ARB appeal & recruitment fees

TOWN OF SMITHS FALLS Page 63 2023 BUDGET CORPORATE SERVICES GENERAL BUDGET

TOWN OF SMITHS FALLS Page 63

Passed February 21, 2023

PROPERTY ASSESSMENT

PROPERTY ASSESSMENT
6259-02-41-101-000 Levy per Assess. Agency101,037102,1571,120102,4190#DIV/0!0.00%
TOTAL PROPERTY ASSESSMENT101,037102,1571,120102,419000#DIV/0!
TOTAL ADMINISTRATION GENERAL1,148,7331,026,780-121,9531,447,089000#DIV/0!

TOWN OF SMITHS FALLS Page 64 2023 BUDGET

CORPORATE SERVICES GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
TAXATION REVENUE
5111-02-41-410-077 Residential-9,626,660-9,626,6600-10,079,8710#DIV/0!0.00%
5121-02-41-410-077 Commercial-3,472,314-3,472,3140-3,583,8790#DIV/0!0.00%
5141-02-41-410-077 Farmland-490-4900-5060#DIV/0!0.00%
5151-02-41-410-077 Pipeline-57,497-57,4970-59,7780#DIV/0!0.00%
5161-02-41-410-077 Railway/Hydro-2,388-2,3880-2,3880#DIV/0!0.00%
5171-02-41-410-077 Industrial-2,496,555-2,496,559-14-2,579,1770#DIV/0!0.00%
5181-02-41-410-077 Multi-Residential-1,425,766-1,425,7660-1,605,7570#DIV/0!0.00%
5192-02-41-410-077 Power Dam Revenue-12,479-12,4790-12,4790#DIV/0!0.00%
5211-02-41-410-077 Residential Supplemental-100,000-107,099-7,099-115,0000#DIV/0!0.00%
5221-02-41-410-077 Commercial Supplemental-100,000-149,523-49,523-100,0000#DIV/0!0.00%
5271-02-41-410-077 Industrial Supplemental-100,000-4,22695,774-100,0000#DIV/0!0.00%
5281-02-41-410-077 Multi-Res Supplemental-75,000-104,037-29,037-115,0000#DIV/0!0.00%
5850-02-41-410-077 Capping Adjustment00000#DIV/0!#DIV/0!
5878-02-41-410-077 Tax Sale Revenue-765-300465-7650#DIV/0!0.00%
6487-02-41-410-077 Rideau Lakes Adjustment (Completed 2022)18,2610-18,26100#DIV/0!#DIV/0!
6376-02-41-410-077 Vacancy Rebate00000#DIV/0!#DIV/0!
6241-02-41-410-077 Rebate Registered Charities5,0001,623-3,3775,0000#DIV/0!0.00%
6427-02-41-410-077 Royal Cdn Leg. Tax Exempt00000#DIV/0!#DIV/0!
6596-02-41-410-077 RCAF Tax Exempt6,9066,90606,9060#DIV/0!0.00%
6242-02-41-410-077 Tax W/O Residential5,0007,0812,0817,0000#DIV/0!0.00%
6243-02-41-410-077 Tax W/O Commercial100,000100,511511100,0000#DIV/0!0.00%
6246-02-41-410-077 Tax W/O Pipeline00000#DIV/0!#DIV/0!
6249-02-41-410-077 Tax W/O Multi Res65,0000-65,00040,0000#DIV/0!0.00%
6856-02-41-410-077 Write-offs (Failed Tax Sales)00000#DIV/0!#DIV/0!
5612-02-41-410-077 Transfer from Reserve (Assessment at Risk)-80,000-80,000000#DIV/0!#DIV/0!
6025-02-41-410-077 Transfer to Reserve1,163,9731,163,973000#DIV/0!#DIV/0!
6248-02-41-410-077 Tax W/O Industrial10,0000-10,00010,0000#DIV/0!0.00%

TOWN OF SMITHS FALLS Page 65 2023 BUDGET CORPORATE SERVICES GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
PAYMENTS IN LIEU OF TAXES
5313-02-41-410-077 Ontario Hospitals-7,800-7,8000-7,8000#DIV/0!0.00%
5314-02-41-410-077 Ontario Hydro-23,000-22,92971-23,0000#DIV/0!0.00%
5316-02-41-410-077 Water Department-267,975-267,9750-267,9750#DIV/0!0.00%
5318-02-41-410-077 MTO-55-61-6-610#DIV/0!0.00%
02-41-410-077-5321 Province - OPP *-171,000-170,774226-171,0000#DIV/0!0.00%
02-41-410-077-6735 Montague - OPP84,4400-84,44085,3870#DIV/0!0.00%
02-41-410-077-6839 Montague - Gallipeau Centre *64,5600-64,56060,2450#DIV/0!0.00%
5319-02-41-410-077 Public Works Canada-174,000-111,64862,352-112,0000#DIV/0!0.00%
TOTAL PAYMENTS IN LIEU-494,830-581,187-86,357-436,204000#DIV/0!
* Minimum @50,030 or 50% of Levy
UNCONDITIONAL GRANTS - ONTARIO
5411-02-41-410-077 OMPF (Municipal Partnership Fund)-3,586,200-3,586,2000-3,469,7000#DIV/0!0.00%
5869-02-41-410-077 Federal Gas Tax-556,918-556,9180-581,1320#DIV/0!0.00%
6025-02-41-410-077 Allocation of Gas Tax556,918556,9180581,1320#DIV/0!0.00%
02-41-410-077-6025/5612 Tsf to/frm Reserve1,161,9001,171,6529,7520#DIV/0!#DIV/0!
5900-02-41-410-077 OCIF Formula-based Funding *-1,161,900-1,161,9000-1,336,1850#DIV/0!0.00%
6025-02-41-410-077 Allocation of OCIF Formula-Based Funding *0001,336,1850#DIV/0!0.00%
5442-02-41-410-077 Provincial Offences Revenue-52,4001,03653,436-45,0000#DIV/0!0.00%
TOTAL ONTARIO GRANTS-3,638,600-3,575,41263,188-3,514,700000#DIV/0!

*Subtotal of this same G/L account $1,917,317


TOTAL REVENUE


TOWN OF SMITHS FALLS

2023 FINAL OPERATIONAL BUDGET

CORPORATE SERVICES; CAPITAL BUDGET

Passed February 21, 202320222022202320232023%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.
COMPUTER/INFORMATION TECHNOLOGY CAPITAL
5612-01-31-335-000 Transfer from Reserve (Acct 2051)-55,084-4,15850,9260#DIV/0!#REF!
6175-01-31-335-288 Outlook Exchange Server25,00010,478-14,5220#DIV/0!#DIV/0!
6840-01-31-335-000 Website/Rebranding*0000#DIV/0!#DIV/0!
6808--01-31-335-434 Cloud-based Server Back-up100,00056,499-43,5010#DIV/0!#DIV/0!
5612-01-31-335-309 Trsf from Capital Reserve (Acct 2083)-119,916-62,81957,0970#DIV/0!#DIV/0!
6808-01-31-335-360 Data/Records Retention50,0000-50,0000#DIV/0!#DIV/0!
6429-01-31-335-000 Cyber Security/IT Review0000#DIV/0!#DIV/0!
* Rebranding/Signage only in 2018
TOTAL INFORMATION TECHNOLOGY0000000#DIV/0!

COMPUTER/INFORMATION TECHNOLOGY GENERAL

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
COMPUTER/INFORMATION TECHNOLOGY
6035-02-31-335-000 Salaries45,97757,67711,70032,3540#DIV/0!0.00%
6091-02-31-335-000 Benefits15,0928,972-6,12012,0300#DIV/0!0.00%
6011-02-31-335-000 Ink Cartridges/Office Supplies2,00074-1,9262,0000#DIV/0!0.00%
xxxx-02-31-335-000 Pay Equity Review Increase0001,1100#DIV/0!0.00%
5612-02-31-335-020 Trsf from Reserve (Acct 2050)000-1,1100#DIV/0!0.00%
6057-02-31-335-413 COVID-19 Overtime0000#DIV/0!#DIV/0!
6039-02-31-335-000 Employee Training/Memberships2,0000-2,0002,0000#DIV/0!0.00%
6015-02-31-335-000 Travel1,0000-1,0001,0000#DIV/0!0.00%
6020-02-31-335-000 Software12,0004,619-7,38115,0000#DIV/0!0.00%
6102-02-31-335-000 Telephone1,500792-7082,0000#DIV/0!0.00%
6118-02-31-335-000 Tools & Equipment15,0002,937-12,06325,0000#DIV/0!0.00%
6150-02-31-335-000 Connectivity40,00039,124-87648,0000#DIV/0!0.00%
6840-02-31-335-000 Website Maintenance14,000803-13,1975000#DIV/0!0.00%
6474-02-31-335-000 Computer Lease *70,00050,180-19,82075,0000#DIV/0!0.00%
6025-31-335-000 Transfer from Reserve (PCO)-15,000-15,000000#DIV/0!#DIV/0!
6176-02-31-335-000 Infrastructure Maintenance30,000-4,460-34,460150,0000#DIV/0!0.00%
6177-02-31-335-000 Support - Main Software7,0000-7,0005000#DIV/0!0.00%
TOTAL INFORMATION TECHNOLOGY240,569145,718-94,851365,384000#DIV/0!

TOWN OF SMITHS FALLS Page 67 2023 FINAL OPERATIONAL BUDGET CORPORATE SERVICES

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
PLANNING/ADMINISTRATION
5567-02-41-415-020 Site Plan Control Fees-15,000-32,300-17,300-5,0000 #DIV/0!0.00%
5568-02-41-415-020 PAC/Minor Variances/Consents-3,000-2,800200-3,0000 #DIV/0!0.00%
5569-02-41-415-020 Application Fees-10,000-10,500-500-8,0000 #DIV/0!0.00%
02-41-415-020-5894 PIL Parkland0-66,000-66,00000 #DIV/0!#DIV/0!
02-41-415-020-6025 Tsf to/from Reserve (Parking/Parkland Fund)067,50067,50000 #DIV/0!#DIV/0!
02-41-415-000-6029 Memberships1,5001,318-1822,0000 #DIV/0!0.00%
6011-02-41-415-001 Office Supplies2,0001,142-8582,0000 #DIV/0!0.00%
6027-02-41-415-001 Photocopier Lease ("New")5,0001,254-3,7465,0000 #DIV/0!0.00%
6035-02-41-415-001 Regular Salaries & Wages &&179,879176,472-3,407246,7040 #DIV/0!0.00%
6048-02-41-415-001 Part-time Wages8,4008,076-3249,2400 #DIV/0!0.00%
6078-02-41-415-001 Vacation Pay336314-223700 #DIV/0!0.00%
6091-02-41-415-001 Other Payroll Costs57,50557,335-17068,1520 #DIV/0!0.00%
6088-02-41-415-001 COA Honorarium2,0000-2,0005,0000 #DIV/0!0.00%
6057-02-41-415-375 Overtime (Shared Service; Montague)12,0001,565-10,4350 #DIV/0!#DIV/0!
5711-02-41-415-375 Township Fees for Shared Services-12,000-1,56510,4350 #DIV/0!#DIV/0!
6015-02-41-415-001 Travel5000-5001,0000 #DIV/0!0.00%
6019-02-41-415-001 Photocopy Supplies2,0000-2,0000 #DIV/0!#DIV/0!
6023-02-41-415-001 Postage900636-2649000 #DIV/0!0.00%
6032-02-41-415-001 Conferences2,0000-2,0003,0000 #DIV/0!0.00%
6038-02-41-415-001 Advertising & Promotion4,0004,6956952,0000 #DIV/0!0.00%
6039-02-41-415-001 Staff & Committee Training4,0001,908-2,0925,0000 #DIV/0!0.00%
6845-02-41-415-001 Community Improvement Plan *02,5242,524100,0000 #DIV/0!0.00%
6606-02-41-415-001 Municipal Heritage Committee **10,0000 #DIV/0!0.00%
xxxx-02-41-415-001 Pay Equity Review Increase8,1120 #DIV/0!0.00%
5612/6025-02-41-415-001 Trsf from Reserve (Acct 2050)0-2,524-2,524-8,1120 #DIV/0!0.00%
6042-02-41-415-001 Courier1000-10000 #DIV/0!#DIV/0!
6102-02-41-415-001 Telephone3,0001,022-1,9783,0000 #DIV/0!0.00%
6175-02-41-415-001 Computer Main Hardware/Website Maintenance11,0008,793-2,20711,0000 #DIV/0!0.00%
6180-02-41-415-001 Professional/Advisory Fees80,0005,912-74,08836,5000 #DIV/0!0.00%
TOTAL PLANNING336,120224,777-111,343494,8660000 #DIV/0!
  • Increased from $50 K to $100 K as per Council Direction

** Moved from Heritage House budget as per Julia


TOWN OF SMITHS FALLS 2023 FINAL OPERATIONAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
BUILDING SERVICES DEPARTMENT
5537-02-31-325-020 Building Fines00000#DIV/0!#DIV/0!
5528-02-31-325-020 Zoning Certificates-3,000-3610-610-3,0000#DIV/0!0.00%
5531-02-31-325-020 Building Permits-750,000-1029994-279,994-500,0000#DIV/0!0.00%
5656-02-31-325-020 Sign Permits (Now under Planning)-5,000-10663,934-5,0000#DIV/0!0.00%
6035-02-31-325-001 Regular Salaries & Wages *223,593182942-40,651281,0280#DIV/0!0.00%
6091-02-31-325-001 Other Payroll Costs67,46154382-13,07964,5230#DIV/0!0.00%
6011-02-31-325-001 Office Supplies20,0003113-16,88725,0000#DIV/0!0.00%
6027-02-31-325-001 Photocopier Lease5,0001254-3,7465,0000#DIV/0!0.00%
02-31-325-001-6015 Travel6,0001339-4,6616000#DIV/0!0.00%
6019-02-31-325-001 Photocopier Lease Supplies1,0000-1,0001,0000#DIV/0!0.00%
6020-02-31-325-001 CBO Computer Software10,0003978-6,02210,0000#DIV/0!0.00%
6840-02-31-325-001 Upgrade Website Presence15,0000-15,00010,0000#DIV/0!0.00%
6023-02-31-325-001 Postage200116-842000#DIV/0!0.00%
6029-02-31-325-001 Membership Fees2,00025-1,9752,0000#DIV/0!0.00%
6038-02-31-325-001 Advertising & Promotion2,50041-2,4592,5000#DIV/0!0.00%
6039-02-31-325-001 Employee Training3,500864-2,6363,5000#DIV/0!0.00%
6040-02-31-325-001 Clothing & Supplies2,500102-2,3982,5000#DIV/0!0.00%
02-31-325-001-6102 Telephone3,0001514-1,4863,0000#DIV/0!0.00%
02-31-325-001-6164 Liability Insurance Claim7,5000-7,5007,5000#DIV/0!0.00%
6180-02-31-325-001 Professional Fees60,0007941119,41180,0000#DIV/0!0.00%
5612/6025-02-31-325-001 Tsf to/frm Reserve328,746709,474380,7289,6490#DIV/0!0.00%
TOTAL BUILDING INSPECTION03,8853,8850000#DIV/0!
  • Incl. of potential reorganizational changes @$50 K per CAO

TOWN OF SMITHS FALLS Page 69 2023 FINAL OPERATIONAL BUDGET CORPORATE SERVICES

TOWN OF SMITHS FALLS Page 69

Passed February 21, 2023

Passed February 21, 20232022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed

ENFORCEMENT SERVICES (PARKING & BYLAW)

PARKING
6818-01-21-225-000 Parking Inventory/Study0000#DIV/0!#DIV/0!
5852-01-21-225-076 Capital Financing0000#DIV/0!#DIV/0!
6072-01-21-225-000 Parking Equipment08,3588,3580#DIV/0!#DIV/0!
5612-01-21-225-000 Transfer from Reserve (Acct 2051)0-8,358-8,3580#DIV/0!#DIV/0!
5612-01-21-225-309 Transfer from Capital Reserve0000#DIV/0!#DIV/0!
TOTAL BYLAW/TRAFFIC0000000#DIV/0!

TOWN OF SMITHS FALLS Page 70 2023 BUDGET CORPORATE SERVICES ENFORCEMENT SERVICES (PARKING & BYLAW CONTROL) GENERAL BUDGET

Passed February 21, 2023

2022 ACCOUNT/DESCRIPTION2022 Budget2022 Actual2023 Var.2023 Budget2023 To DateActual% Var.% Completed
6176-02-21-225-0001 OPS COM Support/Licencing & Moneris Fees00007,5000#DIV/0!
5536-02-21-225-020 Parking Lot-6,000-13,688-7,688-9,0000#DIV/0!
5537-02-21-225-020 Parking Fines-20,000-12,9977,003-12,0000#DIV/0!
5538-02-21-225-020 County Court Fines-1,000-4,715-3,715-3,0000#DIV/0!
5612-02-21-225-020 Trsf from reserve (Account 2050)0004,5960#DIV/0!
xxxx-02-21-225-001 Pay Equity Review Increase000-4,5960#DIV/0!
6011-02-21-225-001 Office Supplies1,0001,071711,5000#DIV/0!
6012-02-21-225-001 Parking Meter Loan/Principal9,2598,476-7839,5570#DIV/0!
6014-02-21-225-001 Parking Meter Loan/Interest670625-453720#DIV/0!
6015-02-21-225-001 Travel2,000193-1,8072,0000#DIV/0!
6019-02-21-225-001 Photocopier Lease Supplies5000-50000#DIV/0!
6023-02-21-225-001 Postage1,000328-6727500#DIV/0!
6026-02-21-225-001 Printing ( Tickets)2,0000-2,00000#DIV/0!
6040-02-21-225-001 Clothing2,0002,3613612,7000#DIV/0!
6035-02-21-225-001 Regular Salaries & Wages154,082124,011-30,071140,9290#DIV/0!
6091-02-21-225-001 Other Payroll Costs44,62626,954-17,67242,8990#DIV/0!
6039-02-21-225-001 Employee Training/Conferences5000-5003,0000#DIV/0!
6020-02-21-225-001 CGIS Software6,5005,047-1,4536,0000#DIV/0!
6102-02-21-225-001 Telephone2,0001,697-3032,0000#DIV/0!
6105-02-21-225-001 Hydro1,000634-3661,0000#DIV/0!
6112-02-21-225-001 Equipment for Enforcement3,00014-2,9866,5000#DIV/0!
6270-02-21-225-001 Vehicle Lease Payments00010,0000#DIV/0!
6118-02-21-225-001 Tools, Accessories, etc1,000188-8121,0000#DIV/0!
6173-02-21-225-001 Insurance1538767231,0510#DIV/0!
02-21-225-001-6180 Professional Fees5,0003,105-1,8952,0000#DIV/0!
6110-02-21-225-001 Vehicle Maintenance00010,0000#DIV/0!
02-21-225-413-6792 COVID-19 Expenditures070170100#DIV/0!
TOTAL BYLAW/TRAFFIC209,290144,881-64,409226,758000#DIV/0!

TOWN OF SMITHS FALLS Page 71 2023 BUDGET CORPORATE SERVICES ENFORCEMENT SERVICES (PARKING & BYLAW CONTROL) GENERAL BUDGET GENERAL BUDGET

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ANIMAL CONTROL
5564-02-21-226-020 Dog Tags-1,500-1,631-131-1,5000#DIV/0!0.00%
6035-02-21-226-001 Salaries00019,4550#DIV/0!0.00%
6091-02-21-226-001 Benefits0006,8980#DIV/0!#REF!
6322-02-21-226-001 Equipment4,000188-3,8124,0000#DIV/0!0.00%
02-21-226-001-6011 Office Supplies200113-8700#DIV/0!#DIV/0!
6180-02-21-226-001 Professional Fees47,0002,993-44,0075,0000#DIV/0!0.00%
6224-02-21-226-001 Pound Services17,00010,838-6,16217,0000#DIV/0!0.00%
6453-02-21-226-001 Emergency Vet Services3,000649-2,3513,0000#DIV/0!0.00%
6110-02-21-226-001 Dog Pick-up Bags & Dispensers2,0000-2,0002,0000#DIV/0!0.00%
TOTAL ANIMAL CONTROL71,70013,150-58,55055,853000#DIV/0!
CROSSING GUARDS
6048-02-31-305-001 Part Time Salaries42,45022,939-19,51146,9550#DIV/0!0.00%
6078-02-31-305-001 Vacation Pay2,5171,196-1,3212,7790#DIV/0!0.00%
6091-02-31-305-001 Benefits4,2982,300-1,9989,1130#DIV/0!0.00%
6040-02-31-305-001 Clothing & Supplies2,5000-2,5002,5000#DIV/0!0.00%
TOTAL CROSSING GUARDS51,76526,435-25,33061,347000#DIV/0!
TOTAL BYLAW ENFORCEMENT GENERAL332,755184,466-148,289343,958000#DIV/0!
TOTAL BYLAW ENFORCEMENT332,755184,466-148,289343,958000#DIV/0!

TOWN OF SMITHS FALLS Page 75 2023 FINAL OPERATIONAL BUDGET

Passed February 21, 2023

Passed February 21, 2023
2022 ACCOUNT/DESCRIPTION2022 BudgetVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
01-41-420-000-6635 Development Cycle Tourism Strategy0000#DIV/0!#DIV/0!
01-41-420-309-5612 Transfer from Capital Reserve-38,094038,0940#DIV/0!#DIV/0!
01-41-420-000-5612 Transfer from Reserve (Acct 2013 & 2269)-36,906036,9060#DIV/0!#DIV/0!
01-41-420-000-6784 Update 2013 Cultural Plan0000#DIV/0!#DIV/0!
01-41-420-000-6591 New Website50,0000-50,0000#DIV/0!#DIV/0!
01-41-420-164-6784 Centre St. Design Renderings25,0000-25,0000#DIV/0!#DIV/0!
0000000#DIV/0!
TOTAL ECONOMIC DEVELOPMENT CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS Page 76 2023 BUDGET ECONOMIC DEVELOPMENT/TOURISM/CULTURE/COMMUNICATIONS GENERAL BUDGET
Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ECONOMIC DEVELOPMENT (ADMIN/DEPARTMENTAL)
6015-02-41-420-319 Travel & Hospitality5,5001,169-4,3315,0000#DIV/0!0.00%
6011-02-41-420-001 Office Supplies1,000252-7485000#DIV/0!0.00%
6015-02-41-420-001 Travel Expense00000#DIV/0!#DIV/0!
6019-02-41-420-001 Photocopy Supplies2,000279-1,7211,0000#DIV/0!0.00%
6023-02-41-420-001 Postage2500-2501000#DIV/0!0.00%
6029-02-41-420-001 Membership Fees12,50011,301-1,19912,5000#DIV/0!0.00%
6035-02-41-420-001 Regular Salaries & Wages191,609145,614-45,995202,8290#DIV/0!0.00%
6048-02-41-420-001 Part-time Salaries & Wages16,8008,335-8,46518,4800#DIV/0!0.00%
6078-02-41-420-001 Vacation672316-3567390#DIV/0!0.00%
6091-02-41-420-001 Other Payroll Costs68,79549,605-19,19073,8520#DIV/0!0.00%
6039-02-41-420-001 Training & Development6,000804-5,1966,0000#DIV/0!0.00%
6042-02-41-420-001 Courier1000-1001000#DIV/0!0.00%
xxxx-21-41-420-001 Pay Equity Review Increase0007,3800#DIV/0!0.00%
5612-21-41-420-020 Trsf from Reserve (Acct 2050)-7,3800#DIV/0!0.00%
6102-02-41-420-001 Telephone2,0001,582-4182,0000#DIV/0!0.00%
TOTAL ADMINISTRATION307,226219,257-87,969323,100000#DIV/0!0
  • Inc. includes reallocated of Event Contract support/Tourism budget ECONOMIC DEVELOPMENT & COMMUNICATIONS
ECONOMIC DEVELOPMENT & COMMUNICATIONS#DIV/0!
6060-02-41-420-001 Marketing35,00025,084-9,91630,0000#DIV/0!0.00%
6038-02-41-420-001 Advertising & Promotion0000#DIV/0!#DIV/0!
6769-02-41-420-001 Partnership Initiatives (Prev Leverage)30,0009,380-20,62030,0000#DIV/0!0.00%
5421-02-41-420-414 RED Grant0000#DIV/0!#REF!
6226-02-41-420-414 RED Expenditures0000#DIV/0!#REF!
6180-02-41-420-001 Professional Fees20,00024,8734,8735,0000#DIV/0!0.00%
6036-04-41-420-001 Corporate Marketing Initiatives00050,0000#DIV/0!0.00%
6800-02-41-420-001 Doctor Recruitment15,0000-15,00015,0000#DIV/0!0.00%
02-41-420-001-6284 Property Appraisals/Legal Fees5,0003,306-1,6945,0000#DIV/0!0.00%
02-41-420-001-6854 Trade Shows2,00015-1,9852,0000#DIV/0!0.00%
02-41-420-001-6651 Town Website28,0969,317-18,77925,0000#DIV/0!0.00%
5586-02-41-420-020 Land Sales0000#DIV/0!#DIV/0!
6123-02-41-420-001 Expenditures (Property @54 Lombard St.)0000#DIV/0!#DIV/0!
6301-02-41-420-001 Municipal Taxes (Property @54 Lombard St.)0000#DIV/0!#DIV/0!
6701-02-41-420-001 Land Purchases015,06315,0630#DIV/0!#DIV/0!
6025-02-41-420-001 Transfer To/From Reserve0-15,063-15,0630#DIV/0!#DIV/0!
TOTAL COMMUNICATIONS135,09671,975-63,121162,000000#DIV/0!

TOWN OF SMITHS FALLS Page 77 2023 BUDGET ECONOMIC DEVELOPMENT & TOURISM

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
SMALL BUSINESS ADVISORY CENTRE
5425-02-41-425-020 MEDT Ontario Grants0-163,499-163,4990#DIV/0!#DIV/0!
5557-02-41-425-020 County of Lanark0-21,000-21,0000#DIV/0!#DIV/0!
5561-02-41-425-020 Seminar Income0000#DIV/0!#DIV/0!
5845-02-41-425-020 Other Grants0000#DIV/0!#DIV/0!
6011-02-41-425-001 Office Supplies04,9534,9530#DIV/0!#DIV/0!
6048-02-41-425-001 Part-time Wages064,41764,4170#DIV/0!#DIV/0!
6057-02-41-425-001 Overtime0000#DIV/0!#DIV/0!
6078-02-41-425-001 Vacation0000#DIV/0!#DIV/0!
6091-02-41-425-001 Other Payroll07,2957,2950#DIV/0!#DIV/0!
6102-02-41-425-001 Communications (Telephone)09409400#DIV/0!#DIV/0!
6038-02-41-425-001 Advertising & Promotion09,5289,5280#DIV/0!#DIV/0!
6045-02-41-425-001 Seminar Expenses013,33513,3350#DIV/0!#DIV/0!
5559-02-41-425-098 Publication Sales0000#DIV/0!#DIV/0!
6015-02-41-425-098 Travel01,1861,1860#DIV/0!#DIV/0!
6380-02-41-425-001 Rent8,1002,025-6,0758,1000#DIV/0!0.00%
6560-02-41-425-001 Valley Heartland Admin Fee0000#DIV/0!#DIV/0!
6038-02-41-425-270 Advertising (MEDI Starter Co. Program)0000#DIV/0!#DIV/0!
6048-02-41-425-270 Wages (MEDI Starter Co. Program)0000#DIV/0!#DIV/0!
6091-02-41-425-270 Other benefits (MEDI Starter Co. Program)0000#DIV/0!#DIV/0!
6045-02-41-425-270 Seminar Expenses (MEDI Starter Co. Program)0000#DIV/0!#DIV/0!
6015-02-41-425-270 Travel (MEDI Starter Co. Program)0000#DIV/0!#DIV/0!
6102-02-41-425-270 Communications (MEDI Starter Co. Program)0000#DIV/0!#DIV/0!
6380-02-41-425-270 Rent (Extra office space) (MEDI Starter Co. Program)0000#DIV/0!#DIV/0!
6174-02-41-425-270 Audit Fees (MEDI Starter Co. Program)0000#DIV/0!#DIV/0!
6836-02-41-425-270 Tsf to/frm Deferred Revenue0000#DIV/0!#DIV/0!
6038-02-41-425-296 Advertising (Summer Co. Program)01,0481,0480#DIV/0!#DIV/0!
6015-02-41-425-296 Travel (Summer Co. Program)03633630#DIV/0!#DIV/0!
6045-02-41-425-296 Seminar Expenses (Summer Co. Program)01,9831,9830#DIV/0!#DIV/0!
6048-02-41-425-296 Part-time Wages (Summer Co. Program)0000#DIV/0!#DIV/0!
6836-02-41-425-296 Tsf to/frm Deferred Revenue0000#DIV/0!#DIV/0!
6226-02-41-425-296 Grants (Summer Co. Program)06,0006,0000#DIV/0!#DIV/0!
6380-02-41-425-353 Rent (Extra Office Space) (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!
6102-02-41-425-353 Communications (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!

TOWN OF SMITHS FALLS Page 78 2023 BUDGET ECONOMIC DEVELOPMENT & TOURISM GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
SMALL BUSINESS ADVISORY CENTRE
6048-02-41-425-353 Part-time Wages (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!
6078-02-41-425-353 Vacation (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!
6091-02-41-425-353 Other Benefits (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!
6015-02-41-425-353 Travel (MEDI Starter Co. Plus)01191190#DIV/0!#DIV/0!
6045-02-41-425-353 Seminar Expenses (MEDI Starter Co. Plus)07,1087,1080#DIV/0!#DIV/0!
6038-02-41-425-353 Marketing/Promo (MEDI Starter Co. Plus)029290#DIV/0!#DIV/0!
6226-02-41-425-353 Grants (MEDI Starter Co. Plus)045,00045,0000#DIV/0!#DIV/0!
6836-02-41-425-353 Trsf to/from Deferred Revenue0000#DIV/0!#DIV/0!
6025/5612-02-41-425-098 Tsfr to/from Reserve (Acct 2062)021,19521,1950#DIV/0!#DIV/0!
TOTAL ENTERPRISE CENTRE8,1002,025-6,0758,100000#DIV/0!
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.Completed
6196-02-41-430-000 RIDEAU VALLEY CON.*53,38453,384061,6560#DIV/0!
TOTAL ECONOMIC DEVELOPMENT GENERAL503,806346,641-157,165554,856000#DIV/0!

TOWN OF SMITHS FALLS 2023 FINAL OPERATIONAL BUDGET

Passed February 21, 2023

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ENGINEERING; CAPITAL WORKS
01-31-320-435-6808 Food Waste Diversion Project15,0000-15,0000#DIV/0!
01-31-320-309-5612 Trsf from Reserve (Capital)-15,000015,0000#DIV/0!
01-31-320-000-5869 Federal Gas Tax0000#DIV/0!
01-31-320-290-6846 Lower Reach Park Remediation0000#DIV/0!
01-31-320-000-6733 Upgrade Autocad0000#DIV/0!
01-31-320-000-6830 Asset Management Plan; Phase II0000#DIV/0!
TOTAL ENGINEERING CAPITAL WORKS00000000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 73
PUBLIC WORKS & UTILITIES GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ENGINEERING ADMINISTRATION
5529-02-31-320-020 Permits & Other Fees-5,000-49,980-44,980-5,0000#DIV/0!0.00%
6011-02-31-320-001 Engineering Supplies2,0001,387-6132,0000#DIV/0!0.00%
6015-02-31-320-001 Travel75025-7253,2500#DIV/0!0.00%
6019-02-31-320-001 Photocopy Supplies & Printing2,0004,7262,7262,0000#DIV/0!0.00%
6027-02-31-320-001 Photocopy Leases3,7000-3,7003,7000#DIV/0!0.00%
6270-02-31-320-001 Vehicle Lease10,0000#DIV/0!0.00%
6108-02-31-320-001 Vehicle Fuel2,5000#DIV/0!0.00%
6173-02-31-320-001 Vehicle Insurance1,0000#DIV/0!0.00%
6177-02-31-320-001 Annual Software Licenses4,5007,6013,1017,0500#DIV/0!0.00%
6029-02-31-320-001 Membership Fees2,0002,4044043,5000#DIV/0!0.00%
6032-02-31-320-001 Conferences1,00076-9244,0000#DIV/0!0.00%
6039-02-31-320-001 Staff Training2,0004,7422,7423,5000#DIV/0!0.00%
6040-02-31-320-001 Clothing & Supplies3000-3001,0000#DIV/0!0.00%
6180-02-31-320-001 Professional Fees7,0004,902-2,0987,0000#DIV/0!0.00%
TOTAL ENGINEERING ADMINISTRATION GENERAL BUDGET20,250-24,117-44,36745,500000#DIV/0!
ENGINEERING WAGES AND BENEFITS
6035-02-31-320-125 Regular Salaries & Wages *89,21675,913-13,303152,6180#DIV/0!
6048-02-31-320-125 Part Time Wages **16,8008,912-7,88817,3600#DIV/0!
6078-02-31-320-125 Vacation Pay672347-3256940#DIV/0!
xxxx-02-31-320-125 Pay Equity Review6,7790#DIV/0!
5612-02-31-320-125 Trsf from Reserve Account 2050-6,7790#DIV/0!
6091-02-31-320-125 Other Payroll Costs29,28425,819-3,46551,7990#DIV/0!
TOTAL ENGINEERING WAGES AND BENEFITS135,972110,991-24,981222,471000#DIV/0!

SOLID WASTE MANAGEMENT; COLLECTION & DISPOSAL -16,000-13,969 2,031-16,000

5588-02-31-322-071 Garbage Tags-16,000-13,9692,031-16,0000#DIV/0!0.00%
xxxx-02-31-322-071 Landfill Monitoring6,0003,532-2,46800#DIV/0!#DIV/0!
6233-02-31-322-071 Collection Contract159,000200,72241,722271,0000#DIV/0!0.00%
6233-02-31-322-291 Collection Contract; Dumpsters68,50057,645-10,85583,0000#DIV/0!0.00%
6273-02-31-322-291 Disposal Contract; Dumpsters49,50043,187-6,31355,0000#DIV/0!0.00%
6273-02-31-322-071 Disposal Contract248,000222,415-25,585284,0000#DIV/0!0.00%
TOTAL WASTE COLL/DISP515,000513,532-1,468677,000000#DIV/0!

Passed February 21, 2023

TOWN OF SMITHS FALLS 2023 BUDGET Page 74
PUBLIC WORKS & UTILITIES

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
RECYCLING & COMPOSTING
6038-02-31-322-072 Advertising & Promotion9,2259,7585333,0000#DIV/0!0.00%
6274-02-31-322-072 Recycling Contract240,000220,841-19,159140,0000#DIV/0!0.00%
5601-02-31-322-020 Recycling Revenue0000#DIV/0!#DIV/0!
5602-02-31-322-072 Recycling Bin Sales-150-7575-1500#DIV/0!0.00%
5594-02-31-322-072 Rain Barrel Revenue-200020000#DIV/0!#DIV/0!
6746-02-31-322-072 Blue Boxes9,000560-8,4403,0000#DIV/0!0.00%
6825-02-31-322-072 Environmental Initiatives **25,00030,0155,0150#DIV/0!#DIV/0!
5864-02-31-322-020 WDO Revenue-71,000-44,69026,310-35,0000#DIV/0!0.00%
6366-02-31-322-072 Hazardous Waste Day12,0000-12,00012,0000#DIV/0!0.00%
5573-02-31-322-072 Composter Sales-1609951,155-1600#DIV/0!0.00%
6159-02-31-322-072 Site Preparation*40,00039,427-57320,0000#DIV/0!0.00%
6035-02-31-322-072 Regular Salaries & Wages19,45719,63918219,8500#DIV/0!0.00%
6048-02-31-322-072 Part time Wages16,80011,267-5,53317,3600#DIV/0!0.00%
6078-02-31-322-072 Vacation Pay672478-1946940#DIV/0!0.00%
6091-02-31-322-072 Other Payroll Costs8,7546,837-1,91710,7920#DIV/0!0.00%
6592-02-31-322-072 Yard Waste Pick-up12,0003,410-8,59010,0000#DIV/0!0.00%
** Refer to food recycling on capital summary
TOTAL RECYCLING & COMPOSTING321,398298,462-22,936201,386000#DIV/0!
TOTAL SOLID WASTE MANAGEMENT836,398811,994-24,404878,386000#DIV/0!
TOTAL ENGINEERING GENERAL BUDGET992,620898,868-93,7521,146,357000#DIV/0!
TOTAL ENGINEERING BUDGET992,620898,868-93,7521,146,357000#DIV/0!

Contact for Waste/Recycling: Vanessa Bernicky


TOWN OF SMITHS FALLS Page 79 2023 FINAL OPERATIONAL BUDGET

TOWN OF SMITHS FALLS Page 79

Passed February 21, 2023

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
TOURISM & CULTURE
6788-02-21-266-001 Rideau Heritage Route9,4910-9,4910 #DIV/0!#DIV/0!
6029-02-21-266-001 Tourism Membership0000 #DIV/0!#DIV/0!
6048-02-21-266-001 Part-time Staff **0000 #DIV/0!#DIV/0!
6078-02-21-266-001 Vacation0000 #DIV/0!#DIV/0!
6091-02-21-266-001 Other Benefits0000 #DIV/0!#DIV/0!
6062-02-21-266-001 General Tourism Marketing36,00019,090-16,91040,0000 #DIV/0!0.00%
6854-02-21-266-001 Trade Shows5,000523-4,4775,0000 #DIV/0!0.00%
6321-02-21-266-294 Event Contract Support0000 #DIV/0!#DIV/0!
6798-02-21-266-001 Arts & Culture *5,0003,000-2,0005,0000 #DIV/0!0.00%
6015-02-21-266-001 Travel & Hospitality0000 #DIV/0!#DIV/0!
6038-02-21-266-001 Advertising0000 #DIV/0!#DIV/0!
6633-02-21-266-001 Tourism Investment & Development25,00017,390-7,61030,0000 #DIV/0!0.00%
6859-02-21-266-001 Cultural Investment & Development52,00035,738-16,26252,0000 #DIV/0!0.00%
6202-02-21-266-001 Special Events (Moved from Comm Grants page)00025,0000 #DIV/0!0.00%
6865-02-21-266-001 On The Roll Expenditures0-950-9500 #DIV/0!#DIV/0!
6064-02-21-266-001 Event Sponsorship0-50-500 #DIV/0!#DIV/0!
TOTAL TOURISM132,49174,741-57,750157,0000000 #DIV/0!
  • As per CAO's direction, Arts & Culture will now be a "line item" in this budget; previously under Community Donations/Grants

** See Ec Dev budget


TOWN OF SMITHS FALLS Page 80 2023 FINAL OPERATIONAL BUDGET

Passed February 21, 2023

2022 ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
HISTORICAL SERVICES
HERITAGE HOUSE
01-21-260-347-6808 Frost & Woods Display0000#DIV/0!#DIV/0!
01-21-260-238-6836 Transferred from Deferred Revenue0000#DIV/0!#DIV/0!
01-21-260-309-5612 Transfer From Capital Reserve0000#DIV/0!#DIV/0!
01-21-260-347-5424 Federal Grant0000#DIV/0!#DIV/0!
01-21-260-373-6808 Canada 150 Capital Projects0000#DIV/0!#DIV/0!
01-21-260-373-5424 Federal Grant0000#DIV/0!#DIV/0!
01-21-260-000-6025 Transfer to Reserve0000#DIV/0!#DIV/0!
01-21-260-000-5612 Transfer From Reserve (Acct 2051/2093)0000#DIV/0!#DIV/0!
01-21-260-355-5615/5852 Financed/Unfinanced Capital Financing0000#DIV/0!#DIV/0!
01-21-260-355-6808 Energy Audit Project0000#DIV/0!#DIV/0!
TOTAL HERITAGE HOUSE CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS Page 81 2023 BUDGET ECONOMIC DEVELOPMENT & TOURISM GENERAL BUDGET

Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.Completed
HISTORICAL SERVICES
HERITAGE HOUSE - ADMINISTRATION
5421-02-21-260-020 Ontario Grants-22,440-22,4400-22,4400#DIV/0!0.00%
5544-02-21-260-020 Program Fees-500-12,526-12,026-10,0000#DIV/0!0.00%
5555-02-21-260-020 Museum Memberships0-55-55-1000#DIV/0!0.00%
5556-02-21-260-020 Gift Shop-400-1,047-647-1,0000#DIV/0!0.00%
5557-02-21-260-020 Donations-500-2,328-1,828-1,5000#DIV/0!0.00%
5558-02-21-260-020 Admissions-500-2,158-1,658-2,5000#DIV/0!0.00%
5566-02-21-260-020 Hall Rentals-500-1,129-629-5000#DIV/0!0.00%
5906-02-21-260-020 RMEO reimbursement for wages-20,000020,0000#DIV/0!#DIV/0!
5424-02-21-260-413 COVID-19 Federal Grant0-22,133-22,133-9,7320#DIV/0!0.00%
5913-02-21-260-020 Research Services Revenue0000#DIV/0!#DIV/0!
6035-02-21-260-001 Regular Salaries & Wages59,59640,162-19,434104,5320#DIV/0!0.00%
6048-02-21-260-001 Part Time Wages32,27039,7267,45619,2190#DIV/0!0.00%
6078-02-21-260-001 Vacation Pay1,2911,5262357390#DIV/0!0.00%
6091-02-21-260-001 Other Payroll Costs30,71817,651-13,06733,9400#DIV/0!0.00%
xxxx-02-21-260-001 Pay Equity Review Increase0003,9290#DIV/0!0.00%
5612-02-21-260-020 Trsf from Reserve (Acct 2050)000-3,9290#DIV/0!0.00%
6011-02-21-260-001 Office Supplies40077-3231000#DIV/0!0.00%
6015-02-21-260-001 Travel/Professional Develop0001,0000#DIV/0!0.00%
6019-02-21-260-001 Photocopy Supplies5001,2187181,5000#DIV/0!0.00%
6023-02-21-260-001 Postage067671000#DIV/0!0.00%
6029-02-21-260-001 Membership Fees175161-142750#DIV/0!0.00%
6038-02-21-260-001 Advertising3000-3005000#DIV/0!0.00%
6039-02-21-260-001 Staff Training1000-1000#DIV/0!#DIV/0!
6042-02-21-260-001 Courier0000#DIV/0!#DIV/0!
6046-02-21-260-001 Program Supplies4003,3592,9597,0000#DIV/0!0.00%
6102-02-21-260-001 Telephone3,5004,5541,0542,0000#DIV/0!0.00%
6112-02-21-260-001 Security System400140-2604000#DIV/0!0.00%
6113-02-21-260-085 Exhibit Supplies400356-441,0000#DIV/0!0.00%
6147-02-21-260-001 Gift Shop Supplies400267-1332,0000#DIV/0!0.00%
6025-02-21-260-001 Trsf to Reserve (Account 2051)0000#DIV/0!#DIV/0!
6173-02-21-260-001 Insurance3,3073,6883814,4260#DIV/0!0.00%
TOTAL ADMINISTRATION88,91749,136-39,781130,959000#DIV/0!

TOWN OF SMITHS FALLS Page 82 2023 BUDGET - HISTORIAL SERVICES; HERITAGE HOUSE ADMINISTRATION Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
BUILDING MAINTENANCE
6105-02-21-260-010 Hydro7,0006,760-2407,0000 #DIV/0!0.00%
6106-02-21-260-010 Water8009431438000 #DIV/0!0.00%
6112-02-21-260-010 Equipment Repairs8000-8008000 #DIV/0!0.00%
6116-02-21-260-010 Janitorial Supplies300130-1703000 #DIV/0!0.00%
6197-02-21-260-010 Janitorial Services5,0002,603-2,3975,0000 #DIV/0!0.00%
6118-02-21-260-010 Tools, Accessories, etc5000-5005000 #DIV/0!0.00%
6142-02-21-260-010 Shrubbery0000 #DIV/0!#DIV/0!
5612-02-21-260-001 Transfer from Reserve0000 #DIV/0!#DIV/0!
6123-02-21-260-010 Property Repairs5,0001,654-3,3465,0000 #DIV/0!0.00%
6152-02-21-260-010 Property Lease0000 #DIV/0!#DIV/0!
TOTAL BUILDING MAINTENANCE19,40012,090-7,31019,4000000 #DIV/0!
JOB CREATION EMPLOYMENT GRANT
5421-02-21-260-088 Ontario Grant0-7,759-7,75900 #DIV/0!#DIV/0!
5424-02-21-260-088 Federal Grant00000 #DIV/0!#DIV/0!
6046-02-21-260-088 Program Supplies00000 #DIV/0!#DIV/0!
6048-02-21-260-088 Part Time Wages07,3567,35600 #DIV/0!#DIV/0!
6078-02-21-260-088 Vacation Pay029629600 #DIV/0!#DIV/0!
6091-02-21-260-088 Other Payroll Costs092392300 #DIV/0!#DIV/0!
TOTAL EMPLOYMENT GRANT081681600000 #DIV/0!
TRILLIUM/RESILIENT COMMUNITIES GRANT
5421-02-21-260-192 Ontario Grant (Trillium Grant)0-5,300-5,30000 #DIV/0!#DIV/0!
6015-02-21-260-192 Mileage (Trillium Grant)00000 #DIV/0!#DIV/0!
6051-02-21-260-192 Health & Safety Supplies (Trillium Grant)00000 #DIV/0!#DIV/0!
6039-02-21-260-192 Workshops/Meetings (Trillium Grant)00000 #DIV/0!#DIV/0!
6180-02-21-260-192 Consultant Fees (Trillium Grant)01,3481,34800 #DIV/0!#DIV/0!
6836-02-21-260-192 Tsf to/frm Deferred Revenue (Trillium Grant)0-19,375-19,37500 #DIV/0!#DIV/0!
6046-02-21-260-192 Program Supplies (Trillium Grant)00000 #DIV/0!#DIV/0!
6048-02-21-260-192 Part Time Wages (Trillium Grant)020,00220,00200 #DIV/0!#DIV/0!
6078-02-21-260-192 Vacation Pay (Trillium Grant)075775700 #DIV/0!#DIV/0!
6091-02-21-260-192 Benefits (Trillium Grant)02,5682,56800 #DIV/0!#DIV/0!
TOTAL TRILLIUM/VALLEY HEARTLAND GRANT00000000 #DIV/0!

TOWN OF SMITHS FALLS Page 83 2023 BUDGET - HISTORIAL SERVICES; HERITAGE HOUSE ADMINISTRATION Passed February 21, 2023

2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.Completed
ACCOUNT/DESCRIPTION000000#DIV/0!#DIV/0!#DIV/0!
JOB CREATION PROGRAM/CULTURAL MARKETING
5424-02-21-260-274 Federal Grant000000#DIV/0!#DIV/0!#DIV/0!
6836-02-21-260-274 Trsf to Deferred Revenue000000#DIV/0!#DIV/0!#DIV/0!
6046-02-21-260-274 Program Supplies000000#DIV/0!#DIV/0!#DIV/0!
TOTAL JOB CREATION PROGRAM/CULTURAL MARKETING000000#DIV/0!#DIV/0!#DIV/0!
FED DEV SOUTHERN ONTARIO - TOURISM RELIEF FUND
5424-02-21-260-477 Federal Grant0-30,085-30,08500#DIV/0!#DIV/0!
6048-02-21-260-477 Part-time Wages024,87324,87300#DIV/0!#DIV/0!
6078-02-21-260-477 Vacation095595500#DIV/0!#DIV/0!
6091-02-21-260-477 Benefits03,2173,21700#DIV/0!#DIV/0!
6046-02-21-260-477 Program Costs01,0400#DIV/0!#DIV/0!
6836-02-21-260-477 Trsf to/from deferred revenue00000#DIV/0!#DIV/0!
TOTAL TOURISM RELIEF FUND00-1,0400000#DIV/0!
CANADIAN MUSEUMS/YOUNG CANADA WORKS
02-21-260-216-5421 Ont Grant (Cdn. Museums)0-18,891-18,89100#DIV/0!#DIV/0!
6048-02-21-260-216 Part Time Wages (Cdn. Museums)00000#DIV/0!#DIV/0!
6078-02-21-260-216 Vacation Pay (Cdn. Museums)00000#DIV/0!#DIV/0!
6091-02-21-260-216 Benefits (Cdn. Museums)00000#DIV/0!#DIV/0!
02-21-260-089-5421 Ont Grant (Summer Experience Program)018,89118,89100#DIV/0!#DIV/0!
02-21-260-089-6836 Tsf to/frm Deferred Revenue (Summer Experience Program)00000#DIV/0!#DIV/0!
6048-02-21-260-322 Part Time Wages (Building Careers in Heritage)00000#DIV/0!#DIV/0!
6078-02-21-260-322 Vacation (Building Careers in Heritage)00000#DIV/0!#DIV/0!
6091-02-21-260-322 Benefits (Building Careers in Heritage)00000#DIV/0!#DIV/0!
02-21-260-322-5424 Federal Grant (Building Careers in Heritage)00000#DIV/0!#DIV/0!
02-21-260-322-6836 Tsf to/from Deferred Revenue (Building Careers in Heritage)00000#DIV/0!#DIV/0!
02-21-260-245-6836 Tsf to/frm Deferred Revenue (Musuem & Technology)00000#DIV/0!#DIV/0!
6048-02-21-260-245 Part Time Wages (Musuem & Technology)00000#DIV/0!#DIV/0!
6078-02-21-260-245 Vacation Pay (Musuem & Technology)00000#DIV/0!#DIV/0!
6091-02-21-260-245 Benefits (Musuem & Technology)00000#DIV/0!#DIV/0!
6046-02-21-260-245 Program Supplies (Musuem & Technology)00000#DIV/0!#DIV/0!
02-21-260-246-5421 Ont Grant (Cultural Strategic Investment Fund)00000#DIV/0!#DIV/0!
02-21-260-246-6836 Tsf to/frm Deferred Revenue (Cultural Strategic Investment Fund)00000#DIV/0!#DIV/0!
6046-02-21-260-246 Program Supplies (Cultural Strategic Investment Fund)00000#DIV/0!#DIV/0!
6048-02-21-260-246 Part Time Wages (Cultural Strategic Investment Fund)00000#DIV/0!#DIV/0!
6078-02-21-260-246 Vacation Pay (Cultural Strategic Investment Fund)00000#DIV/0!#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGETPage 84
ECONOMIC DEVELOPMENT & TOURISM GENERAL BUDGET
Passed February 21, 202320222022202320232023%%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.
TOTAL HERITAGE HOUSE GENERAL108,31762,042-47,315150,359000#DIV/0!
TOTAL HERITAGE HOUSE BUDGET108,31762,042-47,315150,359000#DIV/0!
TOWN HISTORY BOOK
5580-02-21-261-020 Book Sales00000#DIV/0!#DIV/0!
6162-02-21-261-001 Author's Royalties00000#DIV/0!#DIV/0!
TOTAL TOWN HISTORY000000#DIV/0!
GRANT & CONTRIBUTIONS TO HISTORICAL AGENCIES
MUNICIPAL HERITAGE COMMITTEE *10,00016,9216,9210#DIV/0!#DIV/0!
02-21-260-001-6606 Municipal Heritage Committee000
02-21-260-020-5612 Trsf from reserve0-6,921-6,9210#DIV/0!#DIV/0!
10,00010,000000#DIV/0!
TOTAL HISTORICAL SERVICES GENERAL118,31772,042-47,315150,359000#DIV/0!
  • Moved to Planning budget

TOWN OF SMITHS FALLS Page 85 2023 FINAL OPERATIONAL BUDGET ECONOMIC DEVELOPMENT - DBA GENERAL BUDGET

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 Actual REVENUEVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
5680-02-41-420-097 Donations0000#DIV/0!#DIV/0!
5910-02-41-020-097 My Mainstreet Grant0-15,557-15,5570#DIV/0!#DIV/0!
5907-02-41-420-097 Digital Main St. Grant0000#DIV/0!#DIV/0!
5863-02-41-420-097 Trsf from other bank account0000#DIV/0!#DIV/0!
5191-02-41-420-097 BIA Levy-79,000-104,000-25,000-104,0000#DIV/0!0.00%
5194-02-41-420-097 DBA Dollar Revenue0-5,000-5,0000#DIV/0!#DIV/0!
6244-02-41-420-097 Tax Write-off & Vacancy Adj4,0000-4,0004,0000#DIV/0!0.00%
TOTAL REVENUE-75,000-124,557-49,557-100,000000#DIV/0!
EXPENDITURES
6048-02-41-420-097 Part Time Wages39,58537,456-2,12941,8600#DIV/0!0.00%
6078-02-41-420-097 Vacation Pay01221220#DIV/0!#DIV/0!
6091-02-41-420-097 Other Payroll Costs14,8774,804-10,0738,9520#DIV/0!0.00%
6011-02-41-420-097 Office Supplies1,500486-1,0147000#DIV/0!0.00%
6561-02-41-420-097 Outgoing Donations; i.e. Legion Wreath & Scouts0001000#DIV/0!0.00%
6789-02-41-420-097 Radio Ads03,2463,2460#DIV/0!#DIV/0!
6038-02-41-420-097 Advertising (Branding/Awareness)09,3949,3940#DIV/0!#DIV/0!
6039-02-41-420-097 Staff Training & Develop.02472470#DIV/0!#DIV/0!
6840-02-41-420-097 Website02,6362,6360#DIV/0!#DIV/0!
6757-02-41-420-097 Business Recruitment (Marketing)03,3173,3170#DIV/0!#DIV/0!
6060-02-41-420-097 Restaurant Week0000#DIV/0!#DIV/0!
6029-02-41-420-097 OBIAA Memberships300345451,0000#DIV/0!0.00%
6142-02-41-420-097 Shrubbery10,00010,000010,0000#DIV/0!0.00%
6562-02-41-420-097 Winter Greenery & Annual Tree Decorating0000#DIV/0!#DIV/0!
6174-02-41-420-097 Audit Fees5000-5002,5500#DIV/0!0.00%
6196-02-41-420-097 Other Promotions (P2W Incentive)03583580#DIV/0!#DIV/0!
6202-02-41-420-097 Christmas Promotions0000#DIV/0!#DIV/0!
6286-02-41-420-097 Spring Promotions (Valentine's/Family Day/Easter)02872870#DIV/0!#DIV/0!
6858-02-41-420-097 Summer Promotions (Canada Day)01611610#DIV/0!#DIV/0!
6659-02-41-420-097 Winter Promotions0000#DIV/0!#DIV/0!
6704-02-41-420-097 Girls Night Out07397390#DIV/0!#DIV/0!
6594-02-41-420-097 Maintenance3,0000-3,0003,0000#DIV/0!0.00%
6758-02-41-420-097 Meeting Expenses0000#DIV/0!#DIV/0!
6582-02-41-420-097 Transportation0000#DIV/0!#DIV/0!
TOTAL EXPENDITURES
69,76273,5983,83668,162000#DIV/0!

ECONOMIC DEVELOPMENT DBA GENERAL BUDGET

00-Jan-00
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
EXPENDITURES
6866-02-41-420-097 DBA Dollars06826820 #DIV/0!#DIV/0!
xxx-02-41-420-097 Bustle on Russell0000 #DIV/0!#DIV/0!
6836-02-41-420-097 Trs'd to/from Deferred Revenue0000 #DIV/0!#DIV/0!
6861-02-41-420-097 Medieval Feast Fundraiser0000 #DIV/0!#DIV/0!
6841-02-41-420-097 Light Up the Night0000 #DIV/0!#DIV/0!
6860-02-41-420-097 Brochures and Shopping Guide07997990 #DIV/0!#DIV/0!
6502-02-41-420-097 Banners & Lights12,72414,3101,58631,7820 #DIV/0!0.00%
6864-02-41-420-097 Digital Main St. Expenses0000 #DIV/0!#DIV/0!
6228-02-41-420-097 Beckwith St. Reconst. Expenses023,10623,1060 #DIV/0!#DIV/0!
TOTAL PROJECTS12,72438,89726,17331,7820000 #DIV/0!
SURPLUS/DEFICIT
6276-02-41-420-097 Previous Deficit/Surplus *0000 #DIV/0!#DIV/0!
6022-02-41-420-097 Current Deficit/Surplus *-7,48612,06219,548560 #DIV/0!0.00%
*Reserve account 2211
TOTAL DEFICIT/SURPLUS-7,48612,06219,548560000 #DIV/0!
TOTAL DBIA BUDGET00000000 #DIV/0!

TOWN OF SMITHS FALLS

2023 FINAL OPERATIONAL BUDGET

PUBLIC WORKS & UTILITIES; DEPARTMENTAL SUB-LEDGER A (CAPITAL PROJECTS) 2022 2022 2023 2023 2023

20222022202320232023%%
Passed February 21, 2023Budget EQUIPMENT PURCHASESVar.BudgetTo DateActualVar.Var.Completed
5612-01-31-303-309 Transfer from Capital Reserve-28,000-27,99460#DIV/0!#DIV/0!
5852-01-31-303-222 Capital Financing0000#DIV/0!#DIV/0!
5612-01-31-303-000 Transfer from Reserve (Acct 2051)-35,000035,0000#DIV/0!#DIV/0!
6013-01-31-303-000 1/2 ton Truck35,0000-35,0000#DIV/0!#DIV/0!
6205-01-31-303-222 LED Streetlighting Project0000#DIV/0!#DIV/0!
5615-01-31-303-222 Unfinanced Capital0000#DIV/0!#DIV/0!
6808-01-31-303-436 Geotechnical Total Station28,00027,994-60#DIV/0!#DIV/0!
01-31-303-000-6661 Plow Truck & Wing0000#DIV/0!#DIV/0!
TOTAL EQUIPMENT PURCHASES0000000#DIV/0!
ACCOUNT/DESCRIPTION2022 Budget MUNICIPAL ROAD & SEWER WORK2023 Budget To Date2023 Actual2023 Var.% Var.% Completed
ACCOUNT/DESCRIPTION2022 Budget MUNICIPAL ROAD & SEWER WORK2023 Budget To Date2023 Budget To Date2023 Actual2023 Var.% Var.% Completed
5873-01-31-303-037 Provincial Grant (Connecting Link)-1,895,368-639,3021,256,0660#DIV/0!#DIV/0!
6205-01-31-303-425 County Rd 43 (Hershey to town limits); Microsurface07,5577,5570#DIV/0!#DIV/0!
6582-01-31-303-410 Improve Active Transportation Network (Tweed)0000#DIV/0!#DIV/0!
6321-01-31-303-286 Road/Sidewalk Condition Assessment0000#DIV/0!#DIV/0!
5424-01-31-303-286 FCM fed grant; Road/Sidewalk Condition Assessment0000#DIV/0!#DIV/0!
6205-01-31-303-426 Condie St. (Cornelia to Grovenor); Roads/Curbs/Sidewalks0000#DIV/0!#DIV/0!
5424-01-31-303-433 CCRF Funding-750,000-365,827384,1730#DIV/0!#DIV/0!
6205-01-31-303-366 Improve Old Sly's Pedestrian Accessibility; Design only0000#DIV/0!#DIV/0!
6499-01-31-303-000 Geotechnical (Roads); 2021 Program0000#DIV/0!#REF!
5612/6025-01-31-303-210 Tsf to/from Reserve (Account 2051)0-44,334-44,3340#DIV/0!#DIV/0!
6732-01-31-303-210 Design Work (Lombard/Abbott)03,7433,7430#DIV/0!#DIV/0!
6732-01-31-303-030 Lombard St. (South side Abbott/Ferrara); sidewalks0000#DIV/0!#DIV/0!
6205-01-31-303-427 Design Work; George St. (Storm/Roads)040,59140,5910#DIV/0!#DIV/0!
5869-01-31-303-295 Federal Gas Tax/Wood St.-221,140-171,21349,9270#DIV/0!#DIV/0!
6205-01-31-303-350 Beckwith St; Phase 1; Reconstruction Project01,3241,3240#DIV/0!#DIV/0!
6732-01-31-303-350 Beckwith St; Phase 2; Detailed Design0000#DIV/0!#DIV/0!
6836-01-31-303-350 Tsf from deferred revenue (CL/Phase)0-953,610-953,6100#DIV/0!#DIV/0!
6149-01-31-303-350 Beckwith St; Phase 2; Reconstruction Project4,045,2052,547,870-1,497,3350#DIV/0!#DIV/0!
5852-01-31-303-350 Financed Capital/Beckwith St.0000#DIV/0!#DIV/0!
5612-01-31-303-309 Tsf from Capital Reserve (Account 2083)-433,659-103,422330,2370#DIV/0!#DIV/0!
5900-01-31-303-210 OCIF Formula-Based Funding-1,400,289-928,701471,5880#DIV/0!#DIV/0!
6205-01-31-303-295 Wood St/Storm Sewers655,251605,324-49,9270#DIV/0!#DIV/0!
01-31-303-000-6582 Active Transportation Plan0000#DIV/0!#DIV/0!
01-31-303-185-6205 Cornelia St. (William to Elmsley); Roads0000#DIV/0!#DIV/0!
5869-01-31-303-350 Federal Gas Tax/Beckwith St.0000#DIV/0!#DIV/0!
5869-01-31-303-210 Federal Gas Tax/Old Mill Rd./Lombard/Abbott0000#DIV/0!#DIV/0!

TOTAL ROADWORK0000000#DIV/0!
TOWN OF SMITHS FALLS
2023 BUDGETPAGE 88
PUBLIC WORKS & UTILITIES
DEPARTMENTAL SUB-LEDGER A (CAPITAL PROJECTS)
00-Jan-0020222022202320232023%%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateVar.Var.Completed
BRIDGES
01-31-303-207-6825 Confederation Bridge MCEA090,38790,3870#DIV/0!#DIV/0!
01-31-303-350-5873 Beckwith St. Structures; Pre-Engineering Work (Connecting Link Grant)0000#DIV/0!#DIV/0!
01-31-303-350-6836 Transfer to/from Deferred Revenue (Connecting Link Grant)0000#DIV/0!#DIV/0!
01-31-303-309-5612 Transfer from Capital Reserve0-23,897-23,8970#DIV/0!#DIV/0!
01-31-303-028-6205 Contractor (Stone Arch Bridge)0000#DIV/0!#DIV/0!
01-31-303-028-6836 Transfer to/from Deferred Revenue0000#DIV/0!#DIV/0!
01-31-303-028-5612/6025 Transfer to/from Reserve0000#DIV/0!#DIV/0!
01-31-303-350-5612 Transfer from Reserve (Acct 2051)0-66,490-66,4900#DIV/0!#DIV/0!
01-31-303-028-5869 Federal Gas Tax0000#DIV/0!#DIV/0!
01-31-303-028-5421 Provincial Grant0000#DIV/0!#DIV/0!
TOTAL SIDEWALKS0000000#DIV/0!
PUBLIC WORKS BUILDINGS
6808-01-31-303-355 Energy Audit Project0000#DIV/0!#DIV/0!
01-31-303-309-5612 Tsf From Capital Reserve (Acct 2083)-30,000030,0000#DIV/0!#DIV/0!
01-31-303-000-6082 Detailed Inspection/Design for Roof Repair61,8872,213-59,6740#DIV/0!#DIV/0!
01-31-303-000-5612 Transfer from Reserve (Acct 2051)-31,887-2,21329,6740#DIV/0!#DIV/0!
TOTAL PUBLIC WORKS BUILDING0000000#DIV/0!
SUBLEDGER TOTAL0000000#DIV/0!


2023 FINAL OPERATIONAL BUDGET PUBLIC WORKS & UTILITIES; DEPARTMENTAL SUB-LEDGER B (ROAD & SEWER MAINTENANCE)

Passed February 21, 2023
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
BRIDGES & CULVERTS
6035-02-31-303-033 Regular Salaries & Wages15,0001,242-13,7580#DIV/0!#DIV/0!
6091-02-31-303-033 Other Payroll Costs5,400194-5,2060#DIV/0!#DIV/0!
6211-02-31-303-033 Preventative Maintenance (AMP LOS)0000#DIV/0!#DIV/0!
6361-02-31-303-033 Engineers Fee - Bridges*5,0000-5,00028,0000#DIV/0!0.00%
6205-02-31-303-033 Contracted Services18,000934-17,06618,0000#DIV/0!0.00%
6268-02-31-303-033 Materials6,000229-5,7718,0000#DIV/0!0.00%
TOTAL BRIDGES & CULVERTS49,4002,599-46,80154,000000#DIV/0!
* OSIM inspection and deck surveyGRASS & WEED MOWING
6035-02-31-303-034 Regular Salaries & Wages20,0007,232-12,7680#DIV/0!#DIV/0!
6091-02-31-303-034 Other Payroll Costs7,2001,572-5,6280#DIV/0!#DIV/0!
6205-02-31-303-034 Contracted Services0002,0000#DIV/0!0.00%
6122-02-31-303-034 Materials6007961961,0000#DIV/0!0.00%
TOTAL GRASS & WEED MOWING27,8009,600-18,2003,000000#DIV/0!
MAIN SEWERS (Some expenditures have been reallocated to "Wastewater Budget")
6035-02-31-303-035 Regular Salaries & Wages91,19873,136-18,06240,0000#DIV/0!0.00%
6057-02-31-303-035 Overtime00000#DIV/0!#DIV/0!
6091-02-31-303-035 Other Payroll Costs38,61721,721-16,89600#DIV/0!#DIV/0!
6268-02-31-303-035 Materials25,00040,36315,36325,0000#DIV/0!0.00%
6205-02-31-303-035 Contractor120,00044,468-75,532120,0000#DIV/0!0.00%
6206-02-31-303-035 Storm Sewer Lease200101-992000#DIV/0!0.00%
6213-02-31-304-001 Parks Canada Lease1,700814-8861,7000#DIV/0!0.00%
6105-02-31-303-035 Hydro (Pumping Station) **5,0002,788-2,21200#DIV/0!#DIV/0!
6102-02-31-303-035 Communications (Pumping Station) **3,5002,961-53900#DIV/0!#DIV/0!
6110-02-31-303-035 Pumping Station Repairs **5,5002,126-3,37400#DIV/0!#DIV/0!
6114-02-31-303-035 Town Equipment00000#DIV/0!#DIV/0!
6213-02-31-303-035 CP Drain Lease2,500814-1,6864,0000#DIV/0!0.00%
5612/6025-02-31-303-035 Transfer Reserve (Acct 2051)00000#DIV/0!#DIV/0!
* Now includes flushing/CCTV annual maintenance @$50,000 ** Previously under "Bldg. & Grounds"
293,215189,292-103,923190,9000000#DIV/0!

(Now Incl 25% of AM Coordinator)

** Now included in the Wastewater Budget


TOWN OF SMITHS FALLS 2023 BUDGET Page 90

PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER B (ROAD & SEWER MAINTENANCE)

00-Jan-00
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
STORM SEWERS/CATCH BASINS
6035-02-31-303-036 Regular Salaries & Wages20,00013,295-6,7050#DIV/0!#DIV/0!
6091-02-31-303-036 Other Payroll Costs7,2003,674-3,5260#DIV/0!#DIV/0!
6205-02-31-303-036 Contracted Services30,00023,482-6,5180#DIV/0!#DIV/0!
6125-02-31-303-036 Materials12,00012,72972915,0000#DIV/0!0.00%
TOTAL CATCH BASINS & SEWERS69,20053,180-16,02015,000000#DIV/0!
STREET REPAIR
6035-02-31-303-037 Regular Salaries & Wages62,66754,459-8,2080#DIV/0!#DIV/0!
6091-02-31-303-037 Other Payroll Costs28,34615,840-12,5060#DIV/0!#DIV/0!
6269-02-31-303-037 Materials20,00025,2475,24725,0000#DIV/0!0.00%
6114-02-31-303-037 Town Equipment0000#DIV/0!#DIV/0!
6855-02-31-303-037 Cracksealing Maintenance (AMP LOS)25,00024,806-19430,0000#DIV/0!0.00%
6205-02-31-303-037 Contractor (Now Incl 25% of AM Coordinator)130,000103,769-26,231150,0000#DIV/0!0.00%
TOTAL STREET PATCHING266,013224,121-41,892205,000000#DIV/0!
GRADING & SHOULDER MAINTENANCE
6035-02-31-303-038 Regular Salaries & Wages5,0001,612-3,3880#DIV/0!#DIV/0!
6091-02-31-303-038 Other Payroll Costs1,800350-1,4500#DIV/0!#DIV/0!
6124-02-31-303-038 Materials6,5002,881-3,6196,5000#DIV/0!0.00%
TOTAL SHOULDER MAINTENANCE13,3004,843-8,4576,500000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 91

2023 BUDGET Page 91

PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER B (ROAD & SEWER MAINTENANCE)

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
DUST CONTROL
6035-02-31-303-039 Regular Salaries & Wages5,0000-5,0000#DIV/0!#DIV/0!
6091-02-31-303-039 Other Payroll Costs1,8000-1,8000#DIV/0!#DIV/0!
6114-02-31-303-039 Town Equipment0000#DIV/0!#DIV/0!
6122-02-31-303-039 Materials5000-5005000#DIV/0!0.00%
TOTAL DUST CONTROL7,3000-7,300500000#DIV/0!
WINTER CONTROL; PLOWING/SANDING/SALTING ROADS
6035-02-31-303-040 Regular Salaries & Wages65,00030,096-34,9040#DIV/0!#DIV/0!
6057-02-31-303-040 Overtime13,0001,442-11,5580#DIV/0!#DIV/0!
6091-02-31-303-040 Other Payroll Costs28,08010,744-17,3360#DIV/0!#DIV/0!
6025-02-31-303-040 Trsf to Payroll Reserve (Surplus Group Benefits)0000#DIV/0!#DIV/0!
6114-02-31-303-040 Town Equipment0000#DIV/0!#DIV/0!
6115-02-31-303-040 Contracted Services0000#DIV/0!#DIV/0!
6133-02-31-303-040 Salt105,00059,362-45,638110,0000#DIV/0!0.00%
6134-02-31-303-040 Sand20,00016,453-3,54720,0000#DIV/0!0.00%
TOTAL WINTER CONTROL; PLOWING/SANDING/SALTING ROADS231,080118,097-112,983130,000000#DIV/0!
WINTER CONTROL; SNOW REMOVAL
6035-02-31-303-324 Regular Salaries & Wages30,00011,320-18,6800#DIV/0!#DIV/0!
6057-02-31-303-324 Overtime5,00037-4,9630#DIV/0!#DIV/0!
6091-02-31-303-324 Other Payroll Costs12,6002,531-10,0690#DIV/0!#DIV/0!
6114-02-31-303-324 Town Equipment0000#DIV/0!#DIV/0!
6115-02-31-303-324 Contracted Services65,00052,032-12,96871,5000#DIV/0!0.00%
TOTAL WINTER CONTROL; SNOW REMOVAL112,60065,920-46,68071,500000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 92

PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER B (ROAD & SEWER MAINTENANCE)

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
WINTER CONTROL; SIDEWALKS
6035-02-31-303-325 Regular Salaries & Wages30,00013,122-16,8780 #DIV/0!#DIV/0!
6057-02-31-303-325 Overtime2,000703-1,2970 #DIV/0!#DIV/0!
6091-02-31-303-325 Other Payroll Costs11,5203,006-8,5140 #DIV/0!#DIV/0!
6114-02-31-303-325 Town Equipment0000 #DIV/0!#DIV/0!
TOTAL WINTER CONTROL; SIDEWALKS43,52016,831-26,6890000#DIV/0!
WINTER CONTROL; PARKING & FACILITIES
6035-02-31-303-326 Regular Salaries & Wages12,0001,927-10,0730 #DIV/0!#DIV/0!
6057-02-31-303-326 Overtime5000-5000 #DIV/0!#DIV/0!
6091-02-31-303-326 Other Payroll Costs4,500416-4,0840 #DIV/0!#DIV/0!
6114-02-31-303-326 Town Equipment0000 #DIV/0!#DIV/0!
TOTAL WINTER CONTROL; PARKING & FACILITIES17,0002,343-14,6570000#DIV/0!
TRAFFIC SIGNALS
6035-02-31-303-041 Regular Salaries & Wages1,0000-1,0000 #DIV/0!#DIV/0!
6091-02-31-303-041 Other Payroll Costs3600-3600 #DIV/0!#DIV/0!
6105-02-31-303-041 Hydro42,00032,099-9,90142,0000 #DIV/0!0.00%
6112-02-31-303-041 Materials0000 #DIV/0!#DIV/0!
6114-02-31-303-041 Town Equipment0000 #DIV/0!#DIV/0!
6205-02-31-303-041 Contractor35,00024,422-10,57835,0000 #DIV/0!0.00%
TOTAL TRAFFIC SIGNALS78,36056,521-21,83977,000000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 93

PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER B (ROAD & SEWER MAINTENANCE)

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
TRAFFIC MARKINGS
6035-02-31-303-042 Regular Salaries & Wages1,000341-6590#DIV/0!#DIV/0!
6091-02-31-303-042 Other Payroll Costs36065-2950#DIV/0!#DIV/0!
6118-02-31-303-042 Tools, Accessories, etc.0000#DIV/0!#DIV/0!
6268-02-31-303-042 Paint0000#DIV/0!#DIV/0!
6205-02-31-303-042 Contractor35,00028,743-6,25742,0000#DIV/0!0.00%
TOTAL TRAFFIC MARKINGS0
TOTAL TRAFFIC MARKINGS36,36029,149-7,21142,000000#DIV/0!
RAILWAY CROSSINGS
6211-02-31-303-043 Maintenance12,5009,810-2,69013,0000#DIV/0!0.00%
TOTAL RAILWAY CROSSINGS12,5009,810-2,69013,000000#DIV/0!
HOUSE SEWERS
6035-02-31-303-044 Regular Salaries & Wages15,0001,063-13,93700#DIV/0!#DIV/0!
6091-02-31-303-044 Other Payroll Costs5,400231-5,16900#DIV/0!#DIV/0!
6114-02-31-303-044 Town Equipment00000#DIV/0!#DIV/0!
6125-02-31-303-044 Materials3,0000-3,0003,0000#DIV/0!0.00%
6205-02-31-303-044 Contractor5,0006,7671,7675,0000#DIV/0!0.00%
TOTAL HOUSE SEWERS28,4008,061-20,3398,000000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 94

2023 BUDGET Page 94

PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER B (ROAD & SEWER MAINTENANCE)

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
STREET LIGHTING
6035-02-31-303-045 Regular Salaries & Wages4,7751,403-3,3720#DIV/0!
6091-02-31-303-045 Other Payroll Costs1,719313-1,4060#DIV/0!
6105-02-31-303-045 Hydro45,00035,022-9,97845,0000#DIV/0!
6013-02-31-303-045 Repayment of Unfinanced Capital (Principal)102,530100,916-1,614101,6550#DIV/0!
6014-02-31-303-045 Repayment of Unfinanced Capital (Interest)2,8573,0211642,2810#DIV/0!
6112-02-31-303-045 Contracted Services **10,00026,01716,01725,0000#DIV/0!
6114-02-31-303-045 Town Equipment0000#DIV/0!
6153-02-31-303-045 Materials2,0001,979-212,0000#DIV/0!
6188-02-31-303-045 Permits & Repairs - Hydro2,50021,45818,9585,0000#DIV/0!
** Increase for "banner" installation (surplused bucket truck)
TOTAL STREET LIGHTING171,381190,12918,748180,9360000#DIV/0!
CURBS & SIDEWALK REPAIRS
5594-02-31-303-047 Misc. Revenue000
6035-02-31-303-046 Regular Salaries & Wages47,00049,5412,5410#DIV/0!#DIV/0!
6091-02-31-303-046 Other Payroll Costs16,92011,747-5,1730#DIV/0!#DIV/0!
6114-02-31-303-046 Town Equipment0000#DIV/0!#DIV/0!
6130-02-31-303-046 Materials25,00029,7834,78340,0000#DIV/0!0.00%
6205-02-31-303-046 Contractor30,00030,52852844,0000#DIV/0!0.00%
TOTAL SIDEWALK REPAIRS118,920121,5992,67984,000000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 95

2023 BUDGET Page 95

PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER B (ROAD & SEWER MAINTENANCE)

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
STREET SIGNS
6035-02-31-303-048 Regular Salaries & Wages20,00012,322-7,6780 #DIV/0!#DIV/0!
6091-02-31-303-048 Other Payroll Costs7,2002,657-4,5430 #DIV/0!#DIV/0!
6205-02-31-303-048 Contracted Services0008,0000 #DIV/0!0.00%
6268-02-31-303-048 Materials13,00011,608-1,39215,0000 #DIV/0!0.00%
6158-02-31-303-048 Sign Supplies0000 #DIV/0!#DIV/0!
TOTAL STREET SIGNS40,20026,587-13,61323,000000#DIV/0!
STREET CLEANING
6035-02-31-303-049 Regular Salaries & Wages30,00024,067-5,9330 #DIV/0!#DIV/0!
6091-02-31-303-049 Other Payroll Costs10,8006,950-3,8500 #DIV/0!#DIV/0!
5831-02-31-303-049 Misc. Revenue-2,00002,0000 #DIV/0!#DIV/0!
6114-02-31-303-049 Town Equipment0000 #DIV/0!#DIV/0!
6268-02-31-303-049 Supplies0000 #DIV/0!#DIV/0!
TOTAL STREET CLEANING38,80031,017-7,7830000#DIV/0!
TREE SERVICING
6035-02-31-303-050 Regular Salaries & Wages25,00019,163-5,8370 #DIV/0!#DIV/0!
6091-02-31-303-050 Other Payroll Costs9,0005,068-3,9320 #DIV/0!#DIV/0!
6268-02-31-303-050 Materials5,0000-5,0002,500
6114-02-31-303-050 Town Equipment0000 #DIV/0!#DIV/0!
6186-02-31-303-050 Contracted Services15,0009,657-5,34317,0000 #DIV/0!0.00%
TOTAL TREE SERVICING54,00033,888-20,11219,500000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 96

2023 BUDGET Page 96

PUBLIC WORKS & UTILITIES

DEPARTMENTAL SUB-LEDGER B (ROAD & SEWER MAINTENANCE)

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
BUILDINGS & GROUNDS
6035-02-31-303-051 Regular Salaries & Wages30,00031,3471,3470 #DIV/0!#DIV/0!
6091-02-31-303-051 Other Payroll Costs10,8009,398-1,4020 #DIV/0!#DIV/0!
6105-02-31-303-051 Hydro6,0004,996-1,0046,5000 #DIV/0!0.00%
6106-02-31-303-051 Water4,0003,439-5614,0000 #DIV/0!0.00%
6107-02-31-303-051 Heating Gas11,0008,678-2,32212,5000 #DIV/0!0.00%
6011-02-31-303-051 Office Supplies4,5008,2463,7466,5000 #DIV/0!0.00%
6102-02-31-303-051 Telephone6,0004,194-1,8066,0000 #DIV/0!0.00%
6116-02-31-303-051 Janitorial Supplies1,5001,6351351,6000 #DIV/0!0.00%
6118-02-31-303-051 Tools, Accessories, etc.6,5007,6331,1338,0000 #DIV/0!0.00%
6197-02-31-303-051 Janitorial Services5,2004,918-2825,5000 #DIV/0!0.00%
6123-02-31-303-051 Property Repairs8,0007,413-5879,0000 #DIV/0!0.00%
TOTAL BUILDING & GROUNDS93,50091,897-1,60359,600000#DIV/0!
LITTER AND GARBAGE PICK-UP
6035-02-31-303-327 Regular Salaries & Wages20,00014,242-5,7580 #DIV/0!#DIV/0!
6091-02-31-303-327 Other Payroll Costs7,2004,111-3,0890 #DIV/0!#DIV/0!
6114-02-31-303-327 Town Equipment0000 #DIV/0!#DIV/0!
6286-02-31-303-327 Materials1,2501,315651,5000 #DIV/0!0.00%
TOTAL LITTER AND GARBAGE PICK-UP28,45019,668-8,7821,500000#DIV/0!
TOTAL ROADS MAINTENANCE1,831,2991,305,152-526,1471,184,936000#DIV/0!


TOWN OF SMITHS FALLS

2023 FINAL OPERATIONAL BUDGET

PUBLIC WORKS & UTILITIES

Passed February 21, 20232022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed

2012 INTERNATIONAL SINGLE AXEL (5-TON SALT/PLOW) DUMP TRUCK; VEHICLE 111; FIXED ASSET #7-0052

6108-02-31-303-052 Gas & Oil5,30015,66910,36915,0000#DIV/0!0.00%
6110-02-31-303-052 Repairs10,0007,514-2,48610,0000#DIV/0!0.00%
6128-02-31-303-052 License1,3000-1,3001,3500#DIV/0!0.00%
TOTAL TRUCK 11116,60023,1836,58326,350000#DIV/0!

2013 CHEV SILVERADO TRUCK; VEHICLE 120; FIXED ASSET #7-0050

2013 CHEV SILVERADO TRUCK; VEHICLE 120; FIXED ASSET #7-0050
6108-02-31-303-053 Gas & Oil3,2002,961-23900#DIV/0!#DIV/0!
6110-02-31-303-053 Repairs2,0002,005500#DIV/0!#DIV/0!
6128-02-31-303-053 Licenses1600-16000#DIV/0!#DIV/0!
*This was previously Engineering; now Dist. TOTAL TRUCK 1205,3604,966-3940000#DIV/0!

2006 CHEV SILVERADO 1/2 TON TRUCK; VEHICLE 122; FIXED ASSET #7-0030

2006 CHEV SILVERADO 1/2 TON TRUCK; VEHICLE 122; FIXED ASSET #7-0030
6108-02-31-303-055 Gas & Oil0003,5000#DIV/0!0.00%
6110-02-31-303-055 Repairs0001,0000#DIV/0!0.00%
6270-02-31-303-055 Enterprise Lease Payments14,4340#DIV/0!0.00%
6128-02-31-303-055 Licenses00000#DIV/0!#DIV/0!
Replacement vehicle being ordered
TOTAL TRUCK 12200018,934000#DIV/0!
2007 6-TON DUMP TRUCK; VEHICLE 123; FIXED ASSET #7-0029
6108-02-31-303-056 Gas & Oil6,0009,1143,11415,0000#DIV/0!0.00%
6110-02-31-303-056 Repairs10,0007,278-2,72210,0000#DIV/0!0.00%
6128-02-31-303-056 Licenses1,3000-1,3001,3500#DIV/0!0.00%
TOTAL TRUCK 12317,30016,392-90826,350000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 98
PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER EQUIPMENT)
Passed February 21, 2023

ACCOUNT/DESCRIPTION

DEPARTMENTAL SUB-DELEGENT C (HOAD & SEVENTEEN EQUIPMENT)
Passed February 21, 2023
2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
PATROL Truck (New truck on order)
#DIV/0!#DIV/0!
6108-02-31-303-455 Gas & Oil0005,0000#DIV/0!0.00%
6110-02-31-303-455 Repairs0001,0000#DIV/0!0.00%
6270-02-31-303-455 Enterprise Lease Payments00012,5820#DIV/0!0.00%
BUCKET TRUCK TOTAL *00018,582000#DIV/0!#DIV/0!
2005 VOLVO GRADER V129; FIXED ASSET 7-0040
6108-02-31-303-058 Gas & Oil3,3002,298-1,0024,0000#DIV/0!0.00%
6110-02-31-303-058 Repairs10,0004,236-5,76410,0000#DIV/0!0.00%
TOTAL GRADER V12913,3006,534-6,76614,000000#DIV/0!
2019 CASE 590N BACKHOE (ORIGINALLY IN DIST BUDGET; REALLOCATED IN 2023)
6108-02-31-303-339 Gas & Oil0005,0000#DIV/0!0.00%
6110-02-31-303-339 Repairs00010,0000#DIV/0!0.00%
TOTAL TRACTOR 14600015,000000#DIV/0!
TRADE-IN FOR F/A 5-1176 IN 2019 (2000 JOHN DEERE WHEELED; VEHICLE 152; FIXED ASSET #5-1068)
6108-02-31-303-399 Gas & Oil5,0007,3632,3635,5000#DIV/0!0.00%
6110-02-31-303-399 Repairs3,5006,1662,6665,0000#DIV/0!0.00%
TOTAL LOADER 1528,50013,5295,02910,500000#DIV/0!
2015 FORD (1-TON TRUCK); Vehicle 124; FIXED ASSET #7-0061
6108-02-31-303-298 Gas & Oil4,0007,3483,3487,5000#DIV/0!0.00%
6110-02-31-303-298 Repairs2,0003,0301,0302,0000#DIV/0!0.00%
6128-02-31-303-298 Vehicle Licence5500-5505500#DIV/0!0.00%
TOTAL 2015 FORD (1-TON) TRUCK6,55010,3783,82810,050000#DIV/0!

2023 BUDGET Page 99
PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER EQUIPMENT)
Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget 2006 BACKHOE; VEHICLE #154; FIXED ASSET #5-10612023 Budget To Date2023 Actual2023 Var.% Var.Completed
ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 Actual2023 Budget To Date2023 Actual2023 Var.% Var.Completed
6108-02-31-303-064 Gas & Oil3,0001,767-1,2333,0000#DIV/0!0.00%
6110-02-31-303-064 Repairs5,0002,538-2,4625,0000#DIV/0!0.00%
TOTAL BACKHOE 154B8,0004,305-3,6958,000000#DIV/0!

2012 JOHNSTON STREET SWEEPER; VEHICLE #155; FIXED ASSET #7-0053

6108-02-31-303-065 Gas & Oil6,0004,875-1,1256,0000#DIV/0!0.00%
6110-02-31-303-065 Repairs8,00013,8285,82810,0000#DIV/0!0.00%
6128-02-31-303-065 Licence ("New")7000-7007000#DIV/0!0.00%
TOTAL SWEEPER14,70018,7034,00316,700000#DIV/0!
JOE JOHNSTON SIDEWALK TRACTOR (VEHICLE #147)
6108-02-31-303-411 Gas & Oil6,0004,792-1,2086,5000#DIV/0!0.00%
6110-02-31-303-411 Repairs10,00017,0667,06610,0000#DIV/0!0.00%
TOTAL BRANDT WHEELED LOADER16,00021,8585,85816,500000#DIV/0!

**TENCO PLOW W/WING HARNESS (VEHICLE #115) ***

TENCO PLOW W/WING HARNESS (VEHICLE #115) *
6108-02-31-303-300 Gas & Oil0000#DIV/0!#DIV/0!
6110-02-31-303-300 Repairs0000#DIV/0!#DIV/0!
00000000#DIV/0!
TOTAL PLOW W/WING HARNESS (VEH #115); *Now included in 02-31-303-070-6112; general equipment repair
2015 CHEV 1/2 TON (VEHICLE #101)
6108-02-31-303-301 Gas & Oil3,0004,2891,2895,0000#DIV/0!0.00%
6110-02-31-303-301 Repairs2,5002,420-802,5000#DIV/0!0.00%
6128-02-31-303-301 Vehicle Licence1600-1600#DIV/0!#DIV/0!
TOTAL 2015 CHEV 1/2 TON (VEHICLE #101)5,6606,7091,0497,5000000#DIV/0!

TOWN OF SMITHS FALLS

2023 BUDGET Page 100 PUBLIC WORKS & UTILITIES

DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER EQUIPMENT) Passed February 21, 2023

ACCOUNT/DESCRIPTION2022 Budget 2015 HOLDER (270); VEHICLE #1452023 Budget To Date2023 ActualVar.% Var.Completed
ACCOUNT/DESCRIPTION2,50072-2,4284,5000#DIV/0!0.00%
6110-02-31-303-304 Gas & Oil10,00010,72972910,0000#DIV/0!0.00%
TOTAL 2015 HOLDER (270)12,50010,801-1,69914,500000#DIV/0!
2009 RPM TECH SNOW BLOWER; EQUIPMENT #272; FIXED ASSET #5-1059
6108-02-31-303-069 Gas & Oil1,0000-1,0001,0000#DIV/0!0.00%
6110-02-31-303-069 Repairs5,000775-4,2255,0000#DIV/0!0.00%
TOTAL SNOW BLOWER6,000775-5,2256,000000#DIV/0!
2018 CHEV SILVERADO 1500 2WD; FIXED ASSET #7-0068 (REPLACED 2005 CHEV SILVERADO 3/4 TON TRUCK; FIXED ASSET #7-0031)
6108-02-31-303-367 Gas & Oil3,0006,0133,0136,5000#DIV/0!0.00%
6128-02-31-303-367 Licence1600-16000#DIV/0!#DIV/0!
6110-02-31-303-367 Repairs2,000521-1,4792,0000#DIV/0!0.00%
TOTAL VEHICLE #1215,1606,5341,3748,500000#DIV/0!

2008 CHEV 1-TON TRUCK; VEHICLE # 126; FIXED ASSET #7-0028

6108-02-31-303-180 Gas & Oil2,5003,9031,4034,0000#DIV/0!0.00%
6110-02-31-303-180 Repairs2,5003,1576572,5000#DIV/0!0.00%
6270-02-31-303-180 Enterprise Lease Payments15,6690#DIV/0!0.00%
6128-02-31-303-180 License5500-5505500#DIV/0!0.00%
TOTAL TRUCK 1265,5507,0601,51022,719000#DIV/0!
2018 CHEV SILVERADO (FIXED ASSET 7-0072/VEH 183) & 2004 CHEVY VAN (FIXED ASSET 7-0049/LOCATION 387); PREV ENG; TO BE DISPOSED OF IN 2019
6108-02-31-303-386 Gas & Oil2,7004,2081,5084,5000#DIV/0!0.00%
6128-02-31-303-386 Vehicle Licence1600-1600#DIV/0!#DIV/0!
6110-02-31-303-386 Repairs2,000438-1,5622,0000#DIV/0!0.00%
6108-02-31-303-387 Gas & Oil0000#DIV/0!#DIV/0!
6128-02-31-303-387 Vehicle Licence0000#DIV/0!#DIV/0!
6110-02-31-303-387 Repairs0000#DIV/0!#DIV/0!
TOTAL4,8604,646-2146,5000000#DIV/0!

TOWN OF SMITHS FALLSPage 101
2023 BUDGET
PUBLIC WORKS & UTILITIES
DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER EQUIPMENT)
20222022202320232023%%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
1992 CHAMPION 730 SERIES ROAD GRADER; EQUIPMENT #073; FIXED ASSET #5-1064
6108-02-31-303-073 Gas & Oil2,500131-2,3692,5000#DIV/0!0.00%
6110-02-31-303-073 Repairs5,0001,884-3,1165,0000#DIV/0!0.00%
TOTAL GRADER V0737,5002,015-5,4857,500000#DIV/0!
MISCELLANEOUS RDS EQUIPMENT
5812-02-31-303-070 Diesel Allocated-43,000-61,444-18,444-55,0000#DIV/0!0.00%
5612-02-31-303-070 Trsf from Reserve (PCO; account 2051)-35,0000#DIV/0!0.00%
6035-02-31-303-070 Regular Salaries & Wages30,00020,907-9,09300#DIV/0!#DIV/0!
6091-02-31-303-070 Other Payroll Costs10,8006,559-4,24100#DIV/0!#DIV/0!
6108-02-31-303-070 Gas & Oil9,5008,322-1,1789,5000#DIV/0!0.00%
6792-02-31-303-413 COVID-19 Expenditures2,0005,8463,8462,0000#DIV/0!0.00%
6112-02-31-303-070 Equipment Repairs *23,00021,629-1,37125,0000#DIV/0!0.00%
6115-02-31-303-070 Equipment Rental1,000853-1471,5000#DIV/0!0.00%
6119-02-31-303-070 Radio Licences & Repairs2,5001,217-1,2831,5000#DIV/0!0.00%
6135-02-31-303-070 Diesel40,00068,99228,99270,0000#DIV/0!0.00%
6173-02-31-303-070 Insurance12,45612,456014,9480#DIV/0!0.00%
TOTAL MISCELLANEOUS88,25685,337-2,91934,448000#DIV/0!
TOTAL EQUIPMENT SUBLEDGER241,796243,7251,929288,633000#DIV/0!

TOWN OF SMITHS FALLS 2023 BUDGET Page 102
PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER EQUIPMENT)

ACCOUNT/DESCRIPTION2022 Budget2022 ActualVar.2023 Budget2023 To Date2023 ActualVar.% Var.% Completed
6035-02-31-303-052 Regular Salaries & Wages30,00020,907-9,0930000#DIV/0!#DIV/0!
6091-02-31-303-070 Other Payroll Costs10,8006,559-4,2410000#DIV/0!#DIV/0!
6108-02-31-303-070 Gas & Oil68,50083,12514,625113,500000#DIV/0!0.00%
6782-02-31-303-413 COVID-19 Expenditures2,0005,8463,8462,000000#DIV/0!0.00%
6110-02-31-303-070 Repairs89,50083,585-5,915103,000000#DIV/0!0.00%
6128-02-31-303-070 Licenses5,0400-5,0404,500000#DIV/0!0.00%
6270-02-31-303-070 Enterprise Lease Payments42,685000#DIV/0!0.00%
5612-02-31-303-070 Trsf from reserve (Account 2051 PCO)-35,000000#DIV/0!0.00%
6112-02-31-303-070 Equipment Repairs23,00021,629-1,37125,000000#DIV/0!0.00%
6115-02-31-303-070 Equipment Rental1,000853-1471,500000#DIV/0!0.00%
6119-02-31-303-070 Radio Repairs2,5001,217-1,2831,500000#DIV/0!0.00%
6135-02-31-303-070 Diesel-3,0007,54810,54815,000000#DIV/0!0.00%
6173-02-31-303-070 Insurance12,45612,456014,948000#DIV/0!0.00%
Subledger Total241,796243,7251,929288,633000#DIV/0!