Back to the archive
Public document · Taxes & Budgets

2022 APPROVED BUDGET (AS OF JANUARY 24, 2022)

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

Source text

SMITHS FALLS RISE AT THE FALLS

2022 APPROVED BUDGET (AS OF JANUARY 24, 2022)


TOWN OF SMITHS FALLS

2022 BUDGET INDEX

Page 1-8 Summary

9 Mayor & Council

10 Community Programs

11-15 Police Services

16-20 Library

21-22 Airport

23-26 Fire Services

27-41, 67, 80-84 Community Services

27 Administration 28 County Shared Services 29-30 Parks 31-35 Community Facilities 36-37 Hillcrest Cemetery 38-41 Child Development Centre 80-84 Historical Services

42-59, 72-74 & 87 – 102 Public Works & Utilities

42-45 Water Treatment Plant 46-49 Water Pollution Control Plant 50-53 R & S Network Maintenance 54-59 Water Distribution Network 72-74 Engineering & Waste Management 87-88 Work Schedules (Capital) 89-102 Works Schedules (Operational)

60-67, 68-71 Corporate Services

60-65 Treasury/Administration/Finance 66 Information Technology 67 Planning 68 Building Department 69-71 By-Law Enforcement/Crossing Guards

75-79, 85-86 Economic Development/Tourism

75-78 Economic Development 79 Tourism 85-86 DBA


TOWN OF S APPROVED 2022 OPERATIONAL E "DEPARTMEN

MITHS FALLS JDGET (As per By-Law 10298-2022) AL SUMMARY"

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.Variance from Prior Year ($$) from
Mayor & Council Community Programs255,089221,488-33,601281,70400-33,601-0.13172
374,704386,20511,501355,2230011,5010.03069
TOTAL MAYOR & COUNCIL629,793607,693-22,100636,927000#DIV/0!
POLICE SERVICE
Capital Operations0000000#DIV/0!
4,968,3384,859,376-108,9625,075,524000-0.02193
TOTAL POLICE SERVICE4,968,3384,859,376108,9625,075,524000#DIV/0!
LIBRARY SERVICE
Capital Operations0000000#DIV/0!
468,821403,754-65,067491,525000-0.13879
TOTAL LIBRARY SERVICE468,821403,754-65,067491,525000#DIV/0!
AIRPORT COMMISSION
Capital Operations0000000#DIV/0!
33,20337,3844,18133,71300012.6%
TOTAL AIRPORT COMMISSION33,20337,3844,18133,713000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

DEPARTMENTAL SUMMARY

January 24, 2022 ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
FIRE SERVICES
Capital Operations0000000#DIV/0!
Capital Operations1,078,5071,034,746-43,7611,067,416000-4.1%
TOTAL FIRE SERVICE1,078,5071,034,746-43,7611,067,416000#DIV/0!
ADMINISTRATION
TOTAL ADMINISTRATION316,411320,4384,027343,369004,027
COUNTY SHARED SERVICES
TOTAL COUNTY SHARED SERVICES2,514,1412,245,274-268,8672,322,13600-268,867
PARKS
Capital000000#DIV/0!
Operations307,750338,09830,348404,526000
TOTAL PARKS307,750338,09830,348404,526000
COMMUNITY FACILITIES
Capital000000#DIV/0!
Operations757,604697,550-60,054814,129000
TOTAL COMMUNITY FACILITIES757,604697,550-60,054814,129000

TOWN OF SMITHS FALLS 2022 BUDGET

DEPARTMENTAL SUMMARY

January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
HILLCREST CEMETERY
Capital Operations0000000#DIV/0!
Capital Operations49,637-931-50,56879,294000-101.9%
TOTAL HILLCREST CEMETERY49,637-931-50,56879,294000#DIV/0!
CHILD DEVELOPMENT CENTRE
Capital Operations0000000#DIV/0!
Capital Operations171,15259,219-111,933217,173000-65.4%
TOTAL CDC171,15259,219-111,933217,173000#DIV/0!
29,65759.7%
46,02126.9%

TOWN OF SMITHS FALLS 2022 BUDGET

DEPARTMENTAL SUMMARY

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
WATER TREATMENT PLANT
Capital Operations (Now includes "I ranster to Capital Budget")0000000#DIV/0!
-219,064-219,0640-231,2960000.0%
TOTAL WTP-219,064-219,0640-231,296000#DIV/0!
WATER POLLUTION CONTROL PLANT
Capital Operations (Now includes "Transfer to Capital Budget")0000000#DIV/0!
93,97993,978040,8250000.0%
TOTAL WPCP93,97993,978040,825000#DIV/0!
PUBLIC WORKS & UTILITIES
Capital Operations0000000#DIV/0!
2,545,6002,319,222-226,3792,641,306000-8.9%
TOTAL WORKS & UTILITIES2,545,6002,319,222-226,3792,641,306000#DIV/0!
WATER DISTRIBUTION
Capital Operations0000000#DIV/0!
786,957786,9570727,4290000.0%
TOTAL WATER DISTRIBUTION786,957786,9570727,429000#DIV/0!
CategoryValue
unlabelled 1-12232
unlabelled 2-53154
unlabelled 395706
unlabelled 4-59528

TOWN OF SMITHS FALLS 2022 BUDGET

DEPARTMENTAL SUMMARY

January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
CORPORATE SERVICES; ADMINISTRATION
Capital Operations0000000#DIV/0!
Capital Operations1,080,3001,228,288147,9881,148,73300013.7%
TOTAL ADMINISTRATIVE SERVICES1,080,3001,228,288147,9881,148,733000#DIV/0!
INFORMATION TECHNOLOGY
Capital Operations0000000#DIV/0!
Capital Operations195,241224,41829,177240,56900014.9%
TOTAL INFORMATION TECHNOLOGY195,241224,41829,177240,569000#DIV/0!
68,4336.3%
45,32823.2%

TOWN OF SMITHS FALLS 2022 BUDGET

DEPARTMENTAL SUMMARY

January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
PLANNING SERVICES
Operational297,876231,696-66,180336,120000-22.2%
BUILDING SERVICES DEPARTMENT
Operational0000000#DIV/0!
BY-LAW ENFORCEMENT
Capital0000000#DIV/0!
Operations286,216146,850-139,366332,755000-48.7%
TOTAL BY-LAW ENFORCEMENT286,216146,850-139,366332,755000#DIV/0!
ENVIRONMENTAL SERVICES
Capital0000000#DIV/0!
Operations928,668828,198-100,470992,620000-10.8%
TOTAL ENVIRONMENTAL SERVICES928,668828,198-100,470992,620000#DIV/0!
38,24412.8%
0#DIV/0!
46,53916.3%
63,9526.9%

TOWN OF SMITHS FALLS 2022 BUDGET

DEPARTMENTAL SUMMARY

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
ECONOMIC DEVELOPMENT
Capital Operations0000000#DIV/0!
Capital Operations458,403386,856-71,547503,806000-15.6%
TOTAL COMMUNITY DEVELOPMENT458,403386,856-71,547503,806000#DIV/0!
TOURISM
Operations137,237100,396-36,841132,491000-0.26845
HISTORICAL SERVICES
Capital Operations0000000#DIV/0!
Capital Operations68,53566,470-2,065118,317000-3.0%
TOTAL HISTORICAL SERVICES68,53566,470-2,065118,317000#DIV/0!
DOWNTOWN BUSINESS ASSOCIATION
Operations0000000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

TOWN OF SMITHS FALLS 2022 BUDGET

DEPARTMENTAL SUMMARY

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
TOTAL CAPITAL BUDGET0000000
TOTAL GENERAL BUDGET17,955,30516,796,866-1,158,43918,469,407000#DIV/0!514,102
PRIOR YEAR DEFICIT/SURPLUS0000000
TOTAL BUDGET17,955,30516,796,866-1,158,43918,469,407000#DIV/0!514,102
FINANCE - TOTAL REVENUE-19,074,826-19,983,894-909,068-20,309,2040000-1,234,378
DEFICIT/SURPLUS-1,119,521-3,187,028-2,067,507-1,839,797000#DIV/0!
TRANSFER TO RESERVE (TAX-SUPPORTED) *1,119,5211,119,52101,839,797000720,276
NET BALANCE0000000

2022 LTFP Projected Transfer to Capital Reserve $3,220,153 (Transfer Capital $3,328,010)

2.9% 2.9% 6.5% 64.3%


TOWN OF SMITHS FALLS 2022 BUDGET

MAYOR/COUNCIL

GENERAL BUDGET

January 24,2022

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ADMINISTRATION
6088-02-11-101-000 Honorarium154,822147,053-7,769157,0200#DIV/0!0.00%
6091-02-11-101-000 Other Payroll Costs9,2677,390-1,8779,9840#DIV/0!0.00%
6015-02-11-101-000 Travel Expense5,0000-5,0005,0000#DIV/0!0.00%
6032-02-11-101-000 Conferences/Training & Dev.10,000973-9,02710,0000#DIV/0!0.00%
6025-02-11-101-000 Transfer to/from reserve018,21418,214-74,8100#DIV/0!0.00%
6102-02-11-101-000 Council Technology (Incl of Cell Phones & Ipads) *2,0003,7391,73910,0000#DIV/0!0.00%
5908-02-11-101-020 Integrity Commissioner Applications000-3000#DIV/0!0.00%
6180-02-11-101-000 Professional Fees5,0000-5,0005,0000#DIV/0!0.00%
6029-02-11-101-000 Memberships11,0008,260-2,74012,0000#DIV/0!0.00%
6034-02-11-101-000 Election Expense20,0001,786-18,21474,8100#DIV/0!0.00%
6863-02-11-101-000 Meeting Management25,00029,0384,03860,0000#DIV/0!0.00%
6037-02-11-101-000 Mayor & Council Public Relations5,0004,405-5955,0000#DIV/0!0.00%
6050-02-11-101-000 Employee Recognition8,000630-7,3708,0000#DIV/0!0.00%
TOTAL MAYOR & COUNCIL255,089221,488-33,601281,704000#DIV/0!
  • New tech will be ordered for new elected officials

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


TOWN OF SMITHS FALLS 2022 BUDGET MAYOR & COUNCIL GENERAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
COMMUNITY PROGRAMS/DONATIONS
02-21-250-397-6202 Furry Tales Cat Rescue04,9994,9990 #DIV/0!#DIV/0!
6406-02-21-250-001 Youth Services (Administered by the County)15,00016,3521,35215,0000 #DIV/0!0.00%
02-21-250-001-6797 Drug Strategy Committee2,0000-2,0002,0000 #DIV/0!0.00%
02-21-250-319-6797 Lanark County Drug Strategy Committee0000 #DIV/0!#DIV/0!
02-21-250-001-6798 Arts & Culture Council ***0000 #DIV/0!#DIV/0!
02-21-250-001-6799 Gordon Pipe Band0000 #DIV/0!#DIV/0!
02-21-250-396-6202 Trinity United Church0000 #DIV/0!#DIV/0!
02-21-250-001-6025 Transfer to Reserve029,48129,481-29,4810 #DIV/0!0.00%
02-21-250-001-xxxx Overall Community Donations **140,0000-140,000150,0000 #DIV/0!0.00%
02-21-250-001-6664 Hospital Donation *174,341174,3410174,3410 #DIV/0!0.00%
02-21-250-001-6831 Horticultural Society0000 #DIV/0!#DIV/0!
02-21-250-294-6038 Rideau Roundtable/Rideau Paddlefest0000 #DIV/0!#DIV/0!
02-21-250-001-6756 Lanark Transportation8,4668,46608,4660 #DIV/0!0.00%
02-21-250-001-5612 Transfer From Reserve (Surplus from 2020 Comm Don; $0.00)0000 #DIV/0!#DIV/0!
02-21-250-280-6202 Rise at the Falls Car Show0000 #DIV/0!#DIV/0!
02-21-250-279-6202 Big Brothers/Big Sisters025,00025,0000 #DIV/0!#DIV/0!
02-21-250-008-6202 Big Brothers/Big Sisters (After School Program)0000 #DIV/0!#DIV/0!
02-21-250-412-6202 Rideau Lakes Amaeur Radio Club Inc.0000 #DIV/0!#DIV/0!
02-21-250-282-6202 DBA Healthy Living Festival0000 #DIV/0!#DIV/0!
02-21-250-001-6226 SF Railway Musuem (2:1 Ratio; matching funds)040,00040,0000 #DIV/0!#DIV/0!
02-21-250-368-6202 Two Rivers Food Hub0000 #DIV/0!#DIV/0!
02-21-250-369-6202 Parkinson Canada031,02031,0200 #DIV/0!#DIV/0!
02-21-250-377-6202 Service Club Co-op0000 #DIV/0!#DIV/0!
6568-02-21-250-001 REAL Grant09,5009,5000 #DIV/0!#DIV/0!
02-21-250-370-6202 Smiths Falls Crimestoppers0000 #DIV/0!#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,897013,8970 #DIV/0!0.00%
6202-02-21-250-001 Special Events21,00033,14912,14921,0000 #DIV/0!0.00%
TOTAL PROGRAMS374,704386,20511,501355,2230000 #DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET INDEPENDENT BOARDS CAPITAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget POLICE SERVICESVar.2022 Budget2022 To Date2022 ActualVar.% Var.Completed
ACCOUNT/DESCRIPTION2021 BudgetVar.2022 Budget2022 To Date2022 ActualVar.% Var.Completed
ACCOUNT/DESCRIPTIONActual58,000
6235-01-21-221-000 Police Cruisers54,00050,539-3,461-35,0000#DIV/0!0.00%
01-21-221-000-6462 Firewall Upgrade25,00015,535-9,4650#DIV/0!#DIV/0!
01-21-221-000-5612 Transfer from Reserve (PCO)-25,000025,000-75,0000#DIV/0!0.00%
01-21-221-000-6717 Phone System Upgrade25,0000-25,00025,0000#DIV/0!0.00%
01-21-221-000-6600 Radio System0000#DIV/0!#DIV/0!
01-21-221-309-5612 Trsf from Capital Reserve (Acct 2083)-129,000-116,07412,926-83,0000#DIV/0!0.00%
01-21-221-160-6398 NG 911 System50,0000-50,00075,0000#DIV/0!0.00%
TOTAL POLICE CAPITAL BUDGET0-50,000-50,0000000#DIV/0!#DIV/0!
6401-02-21-221-160 Annual System Maintenance23,00018,352-4,64820,0000#DIV/0!0.00%
6182-02-21-221-001 CPIC Maintenance Costs1,7001,526-1741,7000#DIV/0!0.00%
6183-02-21-221-001 OPTIC Maintenance Cost29,00025,184-3,81625,0000#DIV/0!0.00%
02-21-221-012-6714 Computer Firewall Maintenance10,0003,397-6,6037,0000#DIV/0!0.00%
02-21-221-297-6398 Northern 911 (3rd party services)4,7004,362-3385,0000#DIV/0!0.00%
02-21-221-160-6398 911 System Maintenance2,0000-2,0001,0000#DIV/0!0.00%
TOTAL COMMUNICATION CENTRE70,40052,821-17,57959,70000#DIV/0!0.00%

TOWN OF SMITHS FALLS

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

2021 ACCOUNT/DESCRIPTION2021 Budget2022 Actual2022 Var.2022 Budget2022 To Date% Var.% Var.
5430-02-21-221-020 Special Police Grant-48,750-48,7500-48,7500#DIV/0!
5898-02-21-221-020 Court Security Grant-8,500-7,4911,009-2,0000#DIV/0!
5513-02-21-221-020 Taxi Licenses-2,100-2,596-496-2,5000#DIV/0!
5517-02-21-221-020 Sale of Equipment-3,000-1,8321,168-1,0000#DIV/0!
5525-02-21-221-020 Accident Reports-800-225575-5000#DIV/0!
5571-02-21-221-020 CPIC Information Fees-6,000-9,841-3,841-6,0000#DIV/0!
5572-02-21-221-020 Fingerprinting Fees-600-44556-5000#DIV/0!
5572-02-21-221-273 RCMP Fingerprinting Fees-1,500-1501,350-1,0000#DIV/0!
6836-02-21-221-273 RCMP Fingerprinting Fees (Deferred Revenue)1,000125-8755000#DIV/0!
02-21-221-388-5430 Civil Remedies Grant00000#DIV/0!
02-21-221-388-6862 Civil Remedies Expenses017,54617,54600#DIV/0!
02-21-221-388-6836 Civil Remedies Deferred Revenue0-17,546-17,54600#DIV/0!
5578-02-21-221-020 Escort Fees-3,000-18,898-15,898-3,0000#DIV/0!
5660-02-21-221-020 Prisoner Meal Reimburse-4000400-4000#DIV/0!
02-21-221-389-5421 Ontario Grant (Cannabis Legalization Implementation)0-5,000-5,00000#DIV/0!
02-21-221-389-6015 Travel (Cannabis Legalization Implementation)00000#DIV/0!
02-21-221-389-6028 Meals Expenses (Cannabis Legalization Implementation)00000#DIV/0!
02-21-221-389-6039 Staff Training (Cannabis Legalization Implementation)00000#DIV/0!
02-21-221-389-6836 (Cannbis Legalization Grant) Trsf to deferred revenue05,0005,00000#DIV/0!
6035-02-21-221-001 Regular Salaries & Wages2,992,4692,946,322-46,1473,167,2030#DIV/0!
6048-02-21-221-001 Part Time Wages163,755151,941-11,81495,6540#DIV/0!
6057-02-21-221-001 Overtime95,000105,03010,03095,0000#DIV/0!
6638-02-21-221-001 Banked Time Adjustment12,00011,584-41612,0000#DIV/0!
6067-02-21-221-001 Shift Premium8,0007,758-2428,0000#DIV/0!
6069-02-21-221-001 Stat Time15,00020,2075,20715,0000#DIV/0!
6078-02-21-221-001 Vacation Pay6,6216,147-4743,9340#DIV/0!
6091-02-21-221-001 Other Payroll Costs1,058,597981,245-77,3521,064,7300#DIV/0!
6048-02-21-221-413 Part-time Wages (COVID-19)06,1406,14000#DIV/0!
6057-02-21-221-413 Overtime (COVID-19)04,2104,21000#DIV/0!
6078-02-21-221-413 Vacation Pay (COVID-19)020920900#DIV/0!
6091-02-21-221-413 Other Payroll Costs (COVID-19)01,5841,58400#DIV/0!
6792-02-21-221-413 Other Expenditures (COVID-19)035935900#DIV/0!
5612-02-21-221-413 Trsf from Reserve (COVID-19)0-12,502-12,50200#DIV/0!
5612/6025-02-21-221-001 Trsf to/from Reserve (Payroll $55 K & PCO $10 K)-45,00020,00065,000-65,0000#DIV/0!
6011-02-21-221-001 Office Supplies10,0008,477-1,5239,0000#DIV/0!
6015-02-21-221-001 Travel Expense15,0005,514-9,48614,0000#DIV/0!
6017-02-21-221-001 Coffee/Food Supplies50091-4095000#DIV/0!
6023-02-21-221-001 Postage1,200343-8571,3000#DIV/0!
6028-02-21-221-001 Meals Expense6,5004,460-2,0406,5000#DIV/0!
6029-02-21-221-001 Membership Fees3,0002,457-5433,5000#DIV/0!
6038-02-21-221-001 Advertising1,5001,566662,0000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET INDEPENDENT BOARDS GENERAL BUDGET

20212021202220222022%%
2021 BudgetActualVar.2022 Budget2022 To Date2022 ActualVar.Var.Completed
ACCOUNT/DESCRIPTION25,00013,413-11,58722,0000#DIV/0!0.00%
6039-02-21-221-001 Staff Training & Develop.30,00028,899-1,10130,0000#DIV/0!0.00%
6040-02-21-221-001 Clothing & Supplies5000-5005000#DIV/0!0.00%
6041-02-21-221-001 Drycleaning1,000797-2031,0000#DIV/0!0.00%
6042-02-21-221-001 Courier2,8003,1373372,0000#DIV/0!0.00%
6054-02-21-221-001 Library in Service3,0000-3,0003,0000#DIV/0!0.00%
6055-02-21-221-001 Community Services16,00018,6752,67516,0000#DIV/0!0.00%
6056-02-21-221-001 Firearm Training27,00024,834-2,16627,0000#DIV/0!0.00%
6102-02-21-221-001 Telephone **1,4001,497971,5000#DIV/0!0.00%
6103-02-21-221-001 Fax0-7,924-7,92400#DIV/0!#DIV/0!
5430-02-21-221-418 CISO Grant07,0247,02400#DIV/0!#DIV/0!
6862-02-21-221-418 CISO Grant Expenditures090090000#DIV/0!#DIV/0!
6836-02-21-221-418 Trsf to/from Deferred Revenue (CISO Grant)22,52529,7527,22735,7030#DIV/0!0.00%
6173-02-21-221-001 Insurance00000#DIV/0!#DIV/0!
02-21-221-001-6713 Special Operations (New)30,00028,359-1,64130,0000#DIV/0!0.00%
6180-02-21-221-001 Professional Fees27,50063,76636,26630,0000#DIV/0!0.00%
6738-02-21-221-001 IT Support20,00014,160-5,84028,0000#DIV/0!0.00%
6194-02-21-221-001 Computer Lease Contract6,0005,968-326,0000#DIV/0!0.00%
6474-02-21-221-001 Laptop Computer Lease Contract6,0003,918-2,0826,0000#DIV/0!0.00%
6027-02-21-221-001 Photocopy Lease6,0003,918-2,0826,0000#DIV/0!0.00%
BUILDING MAINTENANCE
6117-02-21-221-010 Property Maintenance12,0009,971-2,02915,0000#DIV/0!0.00%
6123-02-21-221-010 Property Repairs15,00012,859-2,14115,0000#DIV/0!0.00%
02-21-221-010-6012 Principal115,554115,751197120,4060#DIV/0!0.00%
02-21-221-010-6014 Interest77,31877,122-19672,4660#DIV/0!0.00%
02-21-221-355-6012 Principal2,7152,71502,7950#DIV/0!0.00%
02-21-221-355-6014 Interest1,3021,293-91,2140#DIV/0!0.00%
02-21-221-010-6105 Hydro21,10023,0761,97622,0000#DIV/0!0.00%
02-21-221-010-6106 Water3,4003,351-493,5000#DIV/0!0.00%
02-21-221-010-6107 Heating Fuel8,1906,653-1,5378,2000#DIV/0!0.00%
02-21-221-010-6116 Janitorial Supplies4,0003,113-8874,0000#DIV/0!0.00%
02-21-221-010-6197 Janitorial Services29,96824,036-5,93230,0000#DIV/0!0.00%
TOTAL BUILDING MAINTENANCE290,547279,940-10,607294,581000#DIV/0!

January 24,2022

TOWN OF SMITHS FALLS 2022 BUDGET INDEPENDENT BOARDS GENERAL BUDGET

ACCCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
VEHICLE MAINTENANCE
6108-02-21-221-011 Gas & Oil35,00030,192-4,80830,0000 #DIV/0!0.00%
6110-02-21-221-011 Repairs25,00024,910-9025,0000 #DIV/0!0.00%
6194-02-21-211-011 Vehicle Lease Payments00000 #DIV/0!#DIV/0!
6836-02-21-211-011 Trsf from Deferred Revenue00000 #DIV/0!#DIV/0!
6118-02-21-221-011 Tools, Accessories, etc500281-2195000 #DIV/0!0.00%
TOTAL VEHICLE MAINTENANCE60,50055,383-5,11755,500000#DIV/0!
EQUIPMENT MAINTENANCE
6110-02-21-221-012 Equipment Repairs10,0005,986-4,01410,0000 #DIV/0!0.00%
6266-02-21-221-012 Breathalyser Repairs1,000635-3651,0000 #DIV/0!0.00%
6847-02-21-221-012 Live Scan Maintenance5,8005,454-3466,0000 #DIV/0!0.00%
6834-02-21-221-012 Wash Court Maintenance7,5006,786-7147,5000 #DIV/0!0.00%
TOTAL EQUIPMENT MAINTENANCE24,30018,861-5,43924,500000#DIV/0!
IDENTIFICATION
6267-02-21-221-022 Supplies1,5001,453-471,0000 #DIV/0!0.00%
6112-02-21-221-022 Equipment Repairs5000-5005000 #DIV/0!0.00%
TOTAL IDENTIFICATION2,0001,453-5471,500000#DIV/0!
5447-02-21-221-023 Arrive Alive Grant-9,000-8,698302-9,0000 #DIV/0!0.00%
6057-02-21-221-023 Overtime9,0009,7497499,0000 #DIV/0!0.00%
6091-02-21-221-023 Other Payroll Costs5001,4569565000 #DIV/0!0.00%
TOTAL RIDE PROGRAM5002,5072,007500000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

INDEPENDENT BOARDS GENERAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
POLICE SERVICES BOARD
6088-02-21-222-001 Honorarium22,94122,941023,2850#DIV/0!0.00%
6091-02-21-222-001 Other Payroll Costs7331,2775447840#DIV/0!0.00%
6015-02-21-222-001 Travel Expense1,5000-1,5001,5000#DIV/0!0.00%
6028-02-21-222-001 Meals Expense2000-2003000#DIV/0!0.00%
6029-02-21-222-001 Membership Fees1,5001,314-1861,5000#DIV/0!0.00%
6032-02-21-222-001 Conferences2,000253-1,7472,0000#DIV/0!0.00%
6036-02-21-222-001 Public Relations2,0001,806-1943,0000#DIV/0!0.00%
6054-02-21-222-001 Library in Service020520500#DIV/0!#DIV/0!
TOTAL POLICE COMMISSION30,87427,796-3,07832,369000#DIV/0!
TOTAL POLICE GENERAL BUDGET4,968,3384,859,376-108,9625,075,524000#DIV/0!
TOTAL POLICE SERVICES BUDGET4,968,3384,809,376-158,9625,075,524000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGETPage 16
INDEPENDENT BOARDS CAPITAL BUDGET
January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.Completed
SMITHS FALLS PUBLIC LIBRARY
01-21-231-000-6782 Building Renovations/Children's Dept.300,0000-300,000300,0000#DIV/0!
5612-01-21-231-000 Trsf from Reserve (Acct 2051/2302)-189,4820189,482-321,7000#DIV/0!
6392-01-21-231-000 Carpeting0000#DIV/0!
01-21-231-000-6603 Air Conditioner Repairs5,0000-5,0005,0000#DIV/0!
01-21-231-309-5612 Trsf from capital reserve (Acct 2083)-140,518-140,519-10#DIV/0!
01-21-231-000-6409 Eavestrough & Fascia Repairs17,500800-16,70016,7000#DIV/0!
01-21-231-000-6641 Ceiling Repairs7,5007,50110#DIV/0!
TOTAL CAPITAL BUDGET0-132,218-132,2180000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET INDEPENDENT BOARDS GENERAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
SMITHS FALLS PUBLIC LIBRARY ADMINISTRATION
5473-02-21-231-020 Ministry of Culture Grant-21,000-22,109-1,109-20,9210#DIV/0!0.00%
5517-02-21-231-020 Sale of Equipment-1,50001,50000#DIV/0!#DIV/0!
5521-02-21-231-020 Photocopy Charges-3,200-1,4871,713-1,2000#DIV/0!0.00%
5580-02-21-231-020 Book Sales-400-282118-2000#DIV/0!0.00%
5553-02-21-231-020 Damages Recovery-500-209291-2000#DIV/0!0.00%
5555-02-21-231-020 Library Memberships-2,000-2,437-437-1,1000#DIV/0!0.00%
5557-02-21-231-020 Donations0-546,579-546,57900#DIV/0!#DIV/0!
5661-02-21-231-020 Interlibrary Loan Revenue-50-1,158-1,108-1,2000#DIV/0!0.00%
5662-02-21-231-020 Overdue Fines-2,000-411,95900#DIV/0!#DIV/0!
5664-02-21-231-020 Audiovisual Fees-100-98200#DIV/0!#DIV/0!
5665-02-21-231-020 Genealogical Services-50-1535500#DIV/0!0.00%
5711-02-21-231-020 Montague Township Fees-14,470-14,4700-14,4700#DIV/0!0.00%
6792-02-21-231-413 COVID-19 Expenditures047747700#DIV/0!#DIV/0!
6025-02-21-231-001 Transfer to Reserve0540,710540,71000#DIV/0!#DIV/0!
6035-02-21-231-001 Regular Salaries & Wages179,943170,800-9,143188,0350#DIV/0!0.00%
6048-02-21-231-001 Part time Wages97,82692,264-5,56299,9370#DIV/0!0.00%
6078-02-21-231-001 Vacation Pay4,6274,178-4494,7000#DIV/0!0.00%
6091-02-21-231-001 Other Payroll Costs72,43264,484-7,94878,1660#DIV/0!0.00%
6011-02-21-231-001 Office Supplies4,0004,6806805,5000#DIV/0!0.00%
6019-02-21-231-001 Photocopy Supplies3,5002,298-1,2022,5000#DIV/0!0.00%
6023-02-21-231-001 Postage5009424425000#DIV/0!0.00%
6029-02-21-231-001 Membership Fees1,400506-8941,2000#DIV/0!0.00%
6038-02-21-231-001 Advertising & Promotion950647-3031,5000#DIV/0!0.00%
6039-02-21-231-001 Staff Training & Develop.2,500390-2,1108000#DIV/0!0.00%
6102-02-21-231-001 Telephone1,6002,3007002,6000#DIV/0!0.00%
6112-02-21-231-001 Equipment Repairs5000-50000#DIV/0!#DIV/0!
6173-02-21-231-001 Insurance10,900-1,117-12,0175,2320#DIV/0!0.00%
6174-02-21-231-001 Audit Fees8000-8008000#DIV/0!0.00%

TOWN OF SMITHS FALLS 2022 BUDGET

INDEPENDENT BOARDS GENERAL BUDGET

January 24, 2022GENERAL BUDGET
2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION7,0003,273-3,7274,0000#DIV/0!0.00%
6177-02-21-231-001 Computer Maintenance *1600-1601600#DIV/0!0.00%
6216-02-21-231-001 Copyright Licencing Fee2,5002,7652653,0000#DIV/0!0.00%
6031-02-21-231-001 Automation
* New software345,868300,712-45,156359,389000#DIV/0!
TOTAL ADMINISTRATION
BUILDING MAINTENANCE
6105-02-21-231-010 Hydro4,1003,384-7164,1000#DIV/0!0.00%
6106-02-21-231-010 Water1,2251,175-501,2250#DIV/0!0.00%
6107-02-21-231-010 Heating Gas4,0003,339-6614,0000#DIV/0!0.00%
02-21-231-010-6012 Principal (Building Renovations)22,40622,414823,1270#DIV/0!0.00%
02-21-231-010-6014 Interest (Building Renovations)2,3942,387-71,6740#DIV/0!0.00%
02-21-231-355-6012 Principal (Energy Audit)1,2261,22601,2620#DIV/0!0.00%
02-21-231-355-6014 Interest (Energy Audit)552584325480#DIV/0!0.00%
6110-02-21-231-010 Property Repairs16,0009,326-6,67416,0000#DIV/0!0.00%
6197-02-21-231-010 Janitorial Contract20,00015,714-4,28620,0000#DIV/0!0.00%
TOTAL BUILDING MAINTENANCE71,90359,549-12,35471,936000#DIV/0!
MATERIALS
6165-02-21-231-015 Books30,00027,770-2,23035,0000#DIV/0!0.00%
6166-02-21-231-015 Magazines1,700830-8701,5000#DIV/0!0.00%
6167-02-21-231-015 Newspapers1,350615-7351,0000#DIV/0!0.00%
6168-02-21-231-015 Videos2,9001,578-1,3221,5000#DIV/0!0.00%
6170-02-21-231-015 Book Binding500-5000#DIV/0!#DIV/0!
6171-02-21-231-015 Interlibrary Loan501581082000#DIV/0!0.00%
6829-02-21-231-015 Processing & Cataloging2,5002,7422423,0000#DIV/0!0.00%
02-21-231-015-6651 Digital Resources7,5009,8002,30015,0000#DIV/0!0.00%
TOTAL LIBRARY MATERIALS46,05043,493-2,55757,200000#DIV/0!

INDEPENDENT BOARDS GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed

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

5424-02-21-231-086 Federal Grants0-1,148-1,14800#DIV/0!#DIV/0!
5557-02-21-231-086 Donations0-3,959-3,95900#DIV/0!#DIV/0!
6025-02-21-231-086 Transfer to/from Reserve03,0203,02000#DIV/0!#DIV/0!
6011-02-21-231-086 Office Supplies00000#DIV/0!#DIV/0!
6165-02-21-231-086 Books00000#DIV/0!#DIV/0!
6169-02-21-231-086 Compact Discs00000#DIV/0!#DIV/0!
6048-02-21-231-086 Part Time Wages *5,0000-5,00000#DIV/0!#DIV/0!
6078-02-21-231-086 Vacation Pay00000#DIV/0!#DIV/0!
6091-02-21-231-086 Other Payroll Costs00000#DIV/0!#DIV/0!
6184-02-21-231-086 Program Supplies02,0872,0873,0000#DIV/0!0.00%
* Board request for Summer Children's Literacy Program
TOTAL SUMMER PROGRAM5,0000-5,0003,000000#DIV/0!
COMMUNITY ACCESS PROGRAM
02-21-231-017-5424 Federal Grant 5557-02-21-231-017 Donations 5612/6025-02-21-231-017 Tsf to/from Reserve 6048-02-21-231-017 Part Time Wages 6078-02-21-231-017 Vacation Pay 6091-02-21-231-017 Benefits 6112-02-21-231-017 Equipment0-6,162-616200#DIV/0!#DIV/0!
02-21-231-017-5424 Federal Grant 5557-02-21-231-017 Donations 5612/6025-02-21-231-017 Tsf to/from Reserve 6048-02-21-231-017 Part Time Wages 6078-02-21-231-017 Vacation Pay 6091-02-21-231-017 Benefits 6112-02-21-231-017 Equipment00000#DIV/0!#DIV/0!
02-21-231-017-5424 Federal Grant 5557-02-21-231-017 Donations 5612/6025-02-21-231-017 Tsf to/from Reserve 6048-02-21-231-017 Part Time Wages 6078-02-21-231-017 Vacation Pay 6091-02-21-231-017 Benefits 6112-02-21-231-017 Equipment06,162616200#DIV/0!#DIV/0!
02-21-231-017-5424 Federal Grant 5557-02-21-231-017 Donations 5612/6025-02-21-231-017 Tsf to/from Reserve 6048-02-21-231-017 Part Time Wages 6078-02-21-231-017 Vacation Pay 6091-02-21-231-017 Benefits 6112-02-21-231-017 Equipment00000#DIV/0!#DIV/0!
02-21-231-017-5424 Federal Grant 5557-02-21-231-017 Donations 5612/6025-02-21-231-017 Tsf to/from Reserve 6048-02-21-231-017 Part Time Wages 6078-02-21-231-017 Vacation Pay 6091-02-21-231-017 Benefits 6112-02-21-231-017 Equipment00000#DIV/0!#DIV/0!
02-21-231-017-5424 Federal Grant 5557-02-21-231-017 Donations 5612/6025-02-21-231-017 Tsf to/from Reserve 6048-02-21-231-017 Part Time Wages 6078-02-21-231-017 Vacation Pay 6091-02-21-231-017 Benefits 6112-02-21-231-017 Equipment00000#DIV/0!#DIV/0!
02-21-231-017-5424 Federal Grant 5557-02-21-231-017 Donations 5612/6025-02-21-231-017 Tsf to/from Reserve 6048-02-21-231-017 Part Time Wages 6078-02-21-231-017 Vacation Pay 6091-02-21-231-017 Benefits 6112-02-21-231-017 Equipment00000#DIV/0!#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGETPage 20
INDEPENDENT BOARDS GENERAL BUDGET
January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
ACCOUNT/DESCRIPTIONADOPT A BOOK PROGRAM
5557-02-21-231-019 Donations0-600-60000#DIV/0!
6025-02-21-231-019 Tsf to/from Reserve060060000#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)00000#DIV/0!
5421-02-21-231-245 Provincial Grant00000#DIV/0!
6836-02-21-231-163 Trsf from Deferred Revenue00000#DIV/0!
6836-02-21-231-245 Trsf to/from Deferred Revenue00000#DIV/0!
6046-02-21-231-245 Program Supplies00000#DIV/0!
6738-02-21-231-163 IT Support00000#DIV/0!
6739-02-21-231-163 Partner Share00000#DIV/0!
6836-02-21-231-278 Trsf to/from Deferred Revenue ("Read with me"; Childhood Literacy Program)00000#DIV/0!
6048-02-21-231-278 Part-time Wages00000#DIV/0!
6078-02-21-231-278 Vacation00000#DIV/0!
6091-02-21-231-278 Other Benefits00000#DIV/0!
6046-02-21-231-278 Program Supplies00000#DIV/0!
6836-02-21-231-278 Trsf to/from Deferred Revenue TOTAL IT PROJECT0000000#DIV/0!
TOTAL LIBRARY GENERAL BUDGET468,821403,754-65,067491,525000#DIV/0!
TOTAL LIBRARY BUDGET468,821271,536-197,285491,525000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

INDEPENDENT BOARDS CAPITAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 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 Preservation15,0008,605-6,3950#DIV/0!#DIV/0!
5711-01-31-330-000 Montague Tsp Fees-3,750-2,1511,5990#DIV/0!#DIV/0!
01-31-330-000-6049 Drainage @Old Club House0000#DIV/0!#DIV/0!
6319-01-31-330-000 Airport Security *5,0000-5,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 Reserve-11,250-6,4544,7960#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)-5,00005,000
TOTAL AIRPORT CAPITAL0000000#DIV/0!

*Full amount in reserve; 25% Montague portion paid


TOWN OF SMITHS FALLS 2022 BUDGET

INDEPENDENT BOARDS GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
AIRPORT
5711-02-31-330-020 Montague Twp Fees-11,068-12,461-1,393-11,2380#DIV/0!
6029-02-31-330-001 Membership Fees4350-4354350#DIV/0!
6032-02-31-330-001 Conferences2,5000-2,5002,5000#DIV/0!
6105-02-31-330-001 Utilities4,5004,237-2634,5000#DIV/0!
6108-02-31-330-001 Fuel4,5002,851-1,6494,5000#DIV/0!
6012-02-31-330-001 Annual Repayment (Fuel Tanks) *5,0005,00005,0000#DIV/0!
6112-02-31-330-001 Equipment Repairs6,0007,3571,3576,0000#DIV/0!
6123-02-31-330-001 Property Repairs4,000693-3,3074,0000#DIV/0!
6289-02-31-330-001 Mowing & Brushing7,0006,895-1057,0000#DIV/0!
6173-02-31-330-001 Insurance4,5365,9671,4315,2160#DIV/0!
6200-02-31-330-001 Snow Removal Contract2,0000-2,0002,0000#DIV/0!
6321-02-31-330-001 Consulting Fees013,32713,32700#DIV/0!
6201-02-31-330-001 Airport Maintenance1,3001,018-2821,3000#DIV/0!
6025-02-31-330-001 Transfer to Reserve (Account 2064)2,5002,50002,5000#DIV/0!
TOTAL AIRPORT GENERAL33,20337,3844,18133,7130000#DIV/0!
  • Adjust receivable on annual basis for Montague's portion (G/L account 02-41-101-102-1074)

(Note: As per CAO's direction, this draft budget is status quo from 2021; subject to change for 2nd draft)


TOWN OF SMITHS FALLS 2022 BUDGET

DEPARTMENTAL CAPITAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
FIRE SERVICES
6095-01-21-211-000 Extrication Equipment45,00058,34413,3440#DIV/0!#DIV/0!
6598-01-21-211-000 SCBA Equipment20,0006,615-13,38525,0000#DIV/0!0.00%
01-21-211-000-6455 New Radio System000500,0000#DIV/0!0.00%
01-21-211-357-6808 CAD2,7972,823262,8000#DIV/0!0.00%
01-21-211-284-6808 Haz Mat Equipment5,00036-4,9645,0000#DIV/0!0.00%
01-21-211-356-6808 Water Rescue Equipment21,0000-21,0000#DIV/0!#DIV/0!
01-21-211-309-5612 Trsf from Capital Reserve (Acct 2083)-183,270-183,25515-552,8000#DIV/0!0.00%
01-21-211-000-6478 Tanker Truck131,2700-131,2700#DIV/0!#DIV/0!
01-21-211-000-5612 Transfer from Reserve (Account 2051/2080)-86,797-47,83338,964-50,0000#DIV/0!0.00%
01-21-211-160-6398 Dispatch Command Centre; 911 Upgrade25,0000-25,00050,0000#DIV/0!0.00%
01-21-211-247-6322 Hoses/Nozzles20,0000-20,00020,0000#DIV/0!0.00%
TOTAL FIRE SERVICES CAPITAL0-163,270-163,2700000#DIV/0!

EMERGENCY COMMUNICATION CENTRE & EMERGENCY PREPAREDNESS

6401-02-21-211-160 Annual System Maintenance21,00020,149-85121,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-14,000-9,7924,208-10,0000#DIV/0!0.00%
6025-02-21-211-160 Fire Marque Revenue (Trsf to Fire Dept Reserve)14,0009,792-4,20810,0000#DIV/0!0.00%
5853-02-21-211-160 Dispatch Revenue-374,000-288,14485,856-377,8000#DIV/0!0.00%
6039-02-21-211-264 Staff Training (Emergency Preparedness)700213-4877000#DIV/0!0.00%
6046-02-21-211-264 Materials & Supplies (Emergency Preparedness)5,000-155-5,1553,0000#DIV/0!0.00%
6015-02-21-211-264 Travel (Emergency Preparedness)1000-1001000#DIV/0!0.00%
6050-02-21-211-001 Misc. Expenses (Collective Agreement)010010000#DIV/0!#DIV/0!
5421-02-21-211-413 COVID-19 (Municipal Fire Protection Grant)0-6,700-6,70000#DIV/0!#DIV/0!
6792-02-21-211-413 COVID-19 (Emergency Response)10,000536-9,4647,0000#DIV/0!0.00%
TOTAL COMMUNICATION CENTRE-322,200-274,00148,199-330,5000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET EPARTMENTAL GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
FIRE SERVICES; ADMINISTRATION
5523-02-21-211-020 Fire Certificates-900-950-50-9000#DIV/0!0.00%
5524-02-21-211-020 Fire Calls - Other Munic.-80,000-72,6487,352-80,0000#DIV/0!0.00%
5529-02-21-211-020 Permit Fees-1,200-895305-1,2000#DIV/0!0.00%
5556-02-21-211-020 Misc Fees-500-812-312-5000#DIV/0!0.00%
6035-02-21-211-001 Regular Salaries & Wages722,095641,036-81,059677,7730#DIV/0!0.00%
6048-02-21-211-001 Part-time Wages28,5360#DIV/0!0.00%
6053-02-21-211-001 Volunteer Fire Fighters127,813127,783-30130,3690#DIV/0!0.00%
6057-02-21-211-001 Overtime45,00046,2981,29835,0000#DIV/0!0.00%
6061-02-21-211-001 Overtime Training20,0007,976-12,02418,0000#DIV/0!0.00%
6069-02-21-211-001 Stat Time6,6005,919-6816,5000#DIV/0!0.00%
6078-02-21-211-001 Vacation Pay1,1410#DIV/0!0.00%
6090-02-21-211-001 Acting Pay20023-1772000#DIV/0!0.00%
6091-02-21-211-001 Other Payroll Costs215,785226,54410,759227,3890#DIV/0!0.00%
6011-02-21-211-001 Office Supplies1,200669-5311,2000#DIV/0!0.00%
6012-02-21-211-247 Loan Principal (Ladder Truck)61,61661,583-3363,8590#DIV/0!0.00%
6014-02-21-211-247 Loan Interest (Ladder Truck)31,99732,0303329,7540#DIV/0!0.00%
6015-02-21-211-001 Travel Expense5000-5002000#DIV/0!0.00%
6017-02-21-211-001 Coffee/Food Supplies1,500474-1,0261,5000#DIV/0!0.00%
6019-02-21-211-001 Photocopy Supplies1,5001,8203201,5000#DIV/0!0.00%
6023-02-21-211-001 Postage200103-972000#DIV/0!0.00%
6029-02-21-211-001 Membership Fees2,0002,6226223,0000#DIV/0!0.00%
6032-02-21-211-001 Conferences3,200534-2,6663,2000#DIV/0!0.00%
6038-02-21-211-001 Advertising1,50041-1,4591,5000#DIV/0!0.00%
6039-02-21-211-001 Staff Training & Develop.12,0006,351-5,64912,0000#DIV/0!0.00%
6040-02-21-211-001 Clothing Supplies8,50011,6203,12010,0000#DIV/0!0.00%
6040-02-21-211-256 Personal Protective Clothing5,0003,856-1,1445,0000#DIV/0!0.00%
6041-02-21-211-001 Turnout Gear Cleaning *3,5002,759-7413,5000#DIV/0!0.00%
6042-02-21-211-001 Courier1000-1001000#DIV/0!0.00%
6102-02-21-211-001 Telephone14,00015,0201,02014,0000#DIV/0!0.00%
6659-02-21-211-001 Communication12,00039,17627,17614,0000#DIV/0!0.00%
6173-02-21-211-001 Insurance9,50116,7467,24520,0950#DIV/0!0.00%
6180-02-21-211-001 Legal/Consulting Fees9,0009,9149149,0000#DIV/0!0.00%
6219-02-21-211-001 Fire Prevention5,0008,4573,4575,0000#DIV/0!0.00%
TOTAL FIRE ADMINISTRATION1,238,7071,194,049-44,6581,240,916000#DIV/0!

2022 BUDGET PAGE 25

DEPARTMENTAL GENERAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
BUILDING MAINTENANCE
6116-02-21-211-010 Janitorial Supplies1,000879-1211,0000#DIV/0!0.00%
6322-02-21-211-010 Medical Equipment/Services3,7004,0423423,7000#DIV/0!0.00%
6118-02-21-211-010 Tools, Accessories, etc17,80013,638-4,16218,0000#DIV/0!0.00%
6123-02-21-211-010 Property Repairs **12,0005,406-6,59412,0000#DIV/0!0.00%
6199-02-21-211-010 Hydrant Rentals *63,00064,0081,00864,0000#DIV/0!0.00%
* Inc. of 1.5% as per LTFP ** Repairs to the former Police station
97,50087,973-9,52798,700000#DIV/0!
VEHICLE MAINTENANCE
6108-02-21-211-258 Gas & Oil (Pumper 820) FA 7-00021,700136-1,5645000#DIV/0!0.00%
6110-02-21-211-258 Repairs (Pumper 820) FA 7-00024,0003,865-1353,0000#DIV/0!0.00%
6108-02-21-211-259 Gas & Oil (Tanker 830) FA 7-0003500494-65000#DIV/0!0.00%
6110-02-21-211-259 Repairs (Tanker 830) FA 7-00033,0001,408-1,5922,5000#DIV/0!0.00%
6108-02-21-211-260 Gas & Oil (Aerial 810) FA 7-00561,800966-8341,8000#DIV/0!0.00%
6110-02-21-211-260 Repairs (Aerial 810) FA 7-005615,00010,529-4,47115,0000#DIV/0!0.00%
6108-02-21-211-261 Gas & Oil (Truck 870) FA 7-00062,800863-1,9372,8000#DIV/0!0.00%
6110-02-21-211-261 Repairs (Truck 870) FA 7-00062,700384-2,3162,7000#DIV/0!0.00%
6108-02-21-211-417 Gas & Oil (Pumper 821)1,7001,776761,7000#DIV/0!0.00%
6110-02-21-211-417 Repairs (Pumper 821)1,700933-7671,7000#DIV/0!0.00%
6108-02-21-211-263 Gas & Oil (Rescue 840) FA 7-0001600320-2806000#DIV/0!0.00%
6110-02-21-211-263 Repairs (Rescue 840) FA 7-00015,0002,376-2,6243,0000#DIV/0!0.00%
TOTAL VEHICLE MAINTENANCE40,50024,050-16,45035,800000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

DEPARTMENTAL GENERAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 Actual EQUIPMENT MAINTENANCE2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2021 BudgetVar.Budget2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
6110-02-21-211-012 Equipment Repairs5,000749-4,2515,0000#DIV/0!0.00%
6119-02-21-211-012 Radio & Pager Repairs5,00049-4,9515,0000#DIV/0!0.00%
6120-02-21-211-012 SCBA Repairs *10,0001,877-8,1238,5000#DIV/0!0.00%
6122-02-21-211-012 Chemicals4,0000-4,0004,0000#DIV/0!0.00%
TOTAL EQUIPMENT MAINTENANCE24,0002,675-21,32522,500000#DIV/0!
ACCOUNT/DESCRIPTION2021 Budget2021 Actual2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
FIRE FUNDRAISING ACTIVITIES
5557-02-21-211-013 Donations00000#DIV/0!#DIV/0!
6140-02-21-211-013 Smoke Detectors00000#DIV/0!#DIV/0!
TOTAL FUNDRAISING ACTIVITIES0000000#DIV/0!
TOTAL FIRE SERVICES GENERAL1,078,5071,034,746-43,7611,067,416000#DIV/0!
TOTAL FIRE SERVICES BUDGET1,078,507871,476-207,0311,067,416000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

COMMUNITY SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ADMINISTRATION
6035-02-21-101-001 Regular Salaries & Wages218,526220,5742,048236,2590#DIV/0!0.00%
6091-02-21-101-001 Other Payroll Costs75,98478,1592,17582,1990#DIV/0!0.00%
6011-02-21-101-001 Office Supplies1,5003,9082,4081,5000#DIV/0!0.00%
6019-02-21-101-001 Photocopy Supplies1,2001,174-268000#DIV/0!0.00%
6023-02-21-101-001 Postage508434500#DIV/0!0.00%
6029-02-21-101-001 Membership Fees1,0000-1,0001,2000#DIV/0!0.00%
6038-02-21-101-001 Advertising1,00044-9561,0000#DIV/0!0.00%
6039-02-21-101-001 Staff Training & Develop.010910900#DIV/0!#DIV/0!
6042-02-21-101-001 Courier00000#DIV/0!#DIV/0!
6173-02-21-101-001 Insurance16,05116,051019,2610#DIV/0!0.00%
6025-02-21-101-001 Transfer to Reserve (Account 2051)00000#DIV/0!#DIV/0!
6180-02-21-101-001 Legal/Consulting Fees1,000335-6651,0000#DIV/0!0.00%
6279-02-21-101-001 Trophies/Awards1000-1001000#DIV/0!0.00%
TOTAL ADMINISTRATION316,411320,4384,027343,369000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGETPage 28
COMMUNITY SERVICES DEPARTMENTAL GENERAL BUDGET
January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTIONCOUNTY SHARED SERVICES
02-21-201-002-6196 AMBULANCE509,750447,469-62,281513,0000#DIV/0!0.00%0.64%
02-21-201-003-6196 LL&G DISTRICT HEALTH UNIT177,155177,1550180,6980#DIV/0!0.00%2.00%
02-21-201-004-6231 ODSP/OW NET COST698,236703,8985,662768,1380#DIV/0!0.00%10.01%
02-21-201-007-6231 LANARK LODGE545,000380,744-164,256400,0000#DIV/0!0.00%-26.61%
02-21-201-009-6231 SOCIAL HOUSING584,000536,008-47,992460,3000#DIV/0!0.00%-21.18%
TOTAL COUNTY SHARED SERVICES2,514,1412,245,274-268,8672,322,136000#DIV/0!0.00%

2021 budget consisted of capital projects for Lanark Lodge & Social Housing


TOWN OF SMITHS FALLS 2022 BUDGET COMMUNITY SERVICES CAPITAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
PARKS DEVELOPMENT
6822-01-21-230-000 Cameras (CC parking lot/Victoria Park/Conf Park)2,0024,5612,5590 #DIV/0!#DIV/0!
6622-01-21-234-149 3/4 Ton Truck (x 2)70,000564-69,43670,0000 #DIV/0!0.00%
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 Replacements25,00022,512-2,4880 #DIV/0!#DIV/0!
01-21-230-000-6786 Shelters for Dog Park30,00018,477-11,52311,5230 #DIV/0!0.00%
01-21-234-309-5612 Trsf from Capital Reserve (Acct 2083)-293,885-272,70821,177-152,4000 #DIV/0!0.00%
01-21-234-364-6533 Multi-Use Trail (Beckwith to Lower Reach Park)30,2580-30,2580 #DIV/0!#DIV/0!
01-21-230-207-6049 Sprinkler System/Centennial Park14,9120-14,9120 #DIV/0!#DIV/0!
01-21-234-364-6836 Trsf to/from Deferred Revenue (OMCC Grant Reserve)-25,556025,5560 #DIV/0!#DIV/0!
01-21-230-000-6670 Illuminate the falls & install unique lighting features35,0000-35,0000 #DIV/0!#DIV/0!
01-21-230-000-6025 Transfer to Reserve0234,608234,6080 #DIV/0!#DIV/0!
01-21-230-419-6808 Automated Timers for Outdoor Lights95,0000-95,00089,2000 #DIV/0!0.00%
01-21-234-290-6668 Floating Docks (Lower Reach Park)0000 #DIV/0!#DIV/0!
01-21-230-000-6533 Park Improvements19,51510,761-8,7540 #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)30,00013,310-16,6900 #DIV/0!#DIV/0!
01-21-230-207-6070 Sprinkler System/Centennial Park0000 #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)-246,108-150,43895,670-268,3230 #DIV/0!0.00%
01-21-234-254-6110 Tennis Court Resurfacing016,50016,5000 #DIV/0!#DIV/0!
01-21-230-122-6808 Basketball Court Renovation73,86261,879-11,9830 #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 Plan40,00037,583-2,4170 #DIV/0!#DIV/0!
01-21-230-000-6234 Playground Equipment Replacement100,0002,391-97,609250,0000 #DIV/0!0.00%
* Originally on Eng worksheet; Troy asked that it be reallocated TOTAL LOWER REACH00000000 #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
-4,38704,3870#DIV/0!#DIV/0!
-15,613-1,86813,7450#DIV/0!#DIV/0!
20,0001,868-18,1320#DIV/0!#DIV/0!
0000000#DIV/0!
0000000#DIV/0!

TOWN OF SMITHS FALLS 2022 COMMUNITY SERVICES GENERAL BUDGET PARKS

January 24, 2022
20212021202220222022%%
Account/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Completed
5575-02-21-230-020 Victoria Park; Lease Payment000000#DIV/0!
5556-02-21-230-020 Misc Revenue000000#DIV/0!
6792-02-21-230-413 COVID-19 Expenditures01,4851,48500#DIV/0!
6836-02-21-230-413 COVID-19; Trsf from deferred revenue0-9,604-9,60400#DIV/0!
6035-02-21-230-001 Regular Salaries & Wages133,689114,644-19,045130,7500#DIV/0!
6048-02-21-230-001 Part Time Wages *8,54715,5106,96368,6730#DIV/0!
6057-02-21-230-001 Overtime3,000449-2,5513,0000#DIV/0!
6078-02-21-230-001 Vacation Pay3424,3303,9882,7470#DIV/0!
6091-02-21-230-001 Other Payroll Costs44,71541,461-3,25451,4880#DIV/0!
5424-02-21-230-431 Federal Grant; Youth Employment0-4,351-4,3510#DIV/0!
6143-02-230-051-6143 Federal Park Lease5092,1581,6492,5000#DIV/0!
6039-02-21-230-001 Staff Training1,500534-9661,0000#DIV/0!
6040-02-21-230-001 Clothing & Supplies2,5002,430-702,5000#DIV/0!
6102-02-21-230-001 Telephone1,0001,4724728000#DIV/0!
6105-02-21-230-196 Victoria Park; Hydro6002,9232,3231,0000#DIV/0!
6106-02-21-230-196 Victoria Park; Water03,5463,5461,0000#DIV/0!
6123-02-21-230-196 Victoria Park; Property Repairs00000#DIV/0!
6173-02-21-230-196 Victoria Park; Insurance5,89820,44414,54624,5330#DIV/0!
6105-02-21-230-051 Hydro4,5008,5954,0954,5000#DIV/0!
6106-02-21-230-051 Water22,00034,60512,60520,0000#DIV/0!
6116-02-21-230-051 Janitorial Supplies8003,1342,3341,0000#DIV/0!
6123-02-21-230-051 Property Repairs30,00030,59359335,0000#DIV/0!
6197-02-21-230-051 Janitorial Services5,00023,10118,10111,4850#DIV/0!
6142-02-21-230-051 Shrubbery25,00029,7944,79425,0000#DIV/0!
6108-02-21-230-011 Vehicle Gas & Oil4,0008,9584,9585,5000#DIV/0!
6110-02-21-230-011 Vehicle Repairs2,500603-1,8971,0000#DIV/0!
6128-02-21-230-011 Vehicle Licences4000-4004000#DIV/0!
6110-02-21-230-012 Equipment Repairs4,0001,167-2,8331,0000#DIV/0!
6115-02-21-230-012 Equipment Rental4,0001,249-2,7511,0000#DIV/0!
5554-02-21-230-343 Rental Revenue (Sports Field) *-12,000-4,9327,068-6,0000#DIV/0!
5551-02-21-230-343 Canteen Lease0-434-4340#DIV/0!
6105-02-21-230-343 Hydro (Sports Field) *4001,3459455000#DIV/0!
6122-02-21-230-343 Chemicals, Etc. (Sports Field) *1,0000-1,0005000#DIV/0!
6123-02-21-230-343 Property Repairs (Sports Field) *10,0002,577-7,42310,0000#DIV/0!
6108-02-21-230-343 Equipment Gas & Oil (Sports Field) *85020-8306500#DIV/0!
6110-02-21-230-343 Equipment Repairs (Sports Field) *3,000292-2,7083,0000#DIV/0!
TOTAL PARKS GENERAL307,750338,09830,348404,526000#DIV/0!
* Incl. waterfront PT staff
TOTAL PARKS BUDGET307,750338,09830,348404,526000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET COMMUNITY SERVICES CAPITAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
COMMUNITY FACILITIES MUNICIPAL COMPLEX
6753-01-21-240-000 Complex Renovations; Phase 3344,844128,596-216,2481,949,6360 #DIV/0!0.00%
5424-01-21-240-433 CCRF Federal Grant000-750,0000 #DIV/0!0.00%
6574-01-21-240-359 Town Square/Band Shell275,02616,734-258,2921,000,0000 #DIV/0!0.00%
6354-01-21-240-000 HVAC (Fire Dispatch)10,0008,127-1,8730 #DIV/0!#DIV/0!
01-21-240-000-5421 COVID ICIP Resilience Funding-175,205-10,660164,545-161,3810 #DIV/0!0.00%
01-21-240-000-6446 Storage Solutions5,0000-5,0000 #DIV/0!#DIV/0!
01-21-240-000-5612 Transfer from Reserve (Acct 2051/2269)-99,821-6,07593,746-88,6190 #DIV/0!#REF!
01-21-240-309-5612 Trsf from Capital Reserve (Acct 2083)-170,000-163,1276,873-791,8960 #DIV/0!0.00%
01-21-240-420-6808 Window Coverings/Blinds40,0007,457-32,5430 #DIV/0!#DIV/0!
01-21-240-000-5852 Capital Financing-229,8440229,844-584,8440 #DIV/0!0.00%
01-21-240-000-58569 Federal Gas Tax-584,896
01-21-240-000-6593 REAL Building Repairs032,54332,54312,0000 #DIV/0!0.00%
TOTAL MUNICIPAL COMPLEX013,59513,59500000 #DIV/0!

MEMORIAL COMMUNITY/YOUTH CENTRE ARENA/OTHER FACILITIES

MEMORIAL COMMUNITY/YOUTH CENTRE ARENA/OTHER FACILITIES
01-21-241-421-6808 FOB Access (CC)50,0001,138-48,8620#DIV/0!#DIV/0!
01-21-241-000-5612 Trsf from Reserve (Acct 2051)0000#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)-50,000-50,00000#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 Reserve048,86248,8620#DIV/0!#DIV/0!
TOTAL ARENAS00000000#DIV/0!
TOTAL COMMUNITY FACILITIES CAPITAL013,59513,59500000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET COMMUNITY SERVICES/COMMUNITY FACILITIES GENERAL BUDGET/

SUMMARY2021 Budget2021 Actual MUNICIPAL COMPLEX2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
SUMMARY2021 BudgetVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
6102-02-21-240-001 Telephone21,80016,507-5,29321,0000#DIV/0!0.00%
6792-02-21-240-413 COVID-19 Expenditures019019000#DIV/0!#DIV/0!
6378-02-21-240-001 Flags1,5000-1,5001,5000#DIV/0!0.00%
6025-02-21-240-001 Tsf to/frm Pardy Flag Fund00000#DIV/0!#DIV/0!
6012-02-21-240-001 Renovations - Principal154,809154,989180158,8700#DIV/0!0.00%
6014-02-21-240-001 Renovations - Interest28,63028,335-29524,5080#DIV/0!0.00%
6105-02-21-240-010 Hydro - Complex28,00040,01512,01528,0000#DIV/0!0.00%
6106-02-21-240-010 Water - Complex10,0008,715-1,28510,0000#DIV/0!0.00%
6107-02-21-240-010 Heating Gas - Complex17,00013,262-3,73817,0000#DIV/0!0.00%
6116-02-21-240-010 Janitorial Supplies4,0002,231-1,7694,0000#DIV/0!0.00%
6123-02-21-240-010 Property/Lawn Repairs18,00013,774-4,22618,0000#DIV/0!0.00%
6173-02-21-240-010 Insurance1,4909,3197,82911,1830#DIV/0!0.00%
6180-02-21-240-010 Professional Fees00000#DIV/0!#DIV/0!
6197-02-21-240-010 Janitorial Service48,00042,203-5,79745,7910#DIV/0!0.00%
TOTAL MUNICIPAL COMPLEX333,229329,540-3,689339,852000#DIV/0!
STATION THEATRE PROJECT
5575-02-41-420-074 Lease Income-10,000-5,2004,800-10,0000#DIV/0!0.00%
6012-02-41-420-074 Principal (Re-pointing)12,56412,569512,9680#DIV/0!0.00%
6014-02-41-420-074 Interest (Re-pointing)1,3431,338-59390#DIV/0!0.00%
6105-02-41-420-074 Hydro3,5003,9824823,5000#DIV/0!0.00%
6106-02-41-420-074 Water1,200958-2421,2000#DIV/0!0.00%
6107-02-41-420-074 Heating Fuel7,0004,570-2,4307,0000#DIV/0!0.00%
6123-02-41-420-074 Property Repairs6,5003,507-2,9936,5000#DIV/0!0.00%
6301-02-41-420-074 Municipal Taxes10,0008,500-1,50010,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,5008,3928927,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) *29,00229,002030,0000#DIV/0!0.00%
TOTAL VIA/THEATRE PROJECT70,65967,618-3,04171,657000#DIV/0!

TOWN OF SMITHS FALLS 2022 COMMUNITY SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 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-500,000-274,953225,047-457,0000#DIV/0!0.00%
5549-02-21-241-020 Floor Rental-20,000-23719,763-17,0000#DIV/0!0.00%
02-21-241-020-5566 Hall Rental-9,500-1,3608,140-8,0000#DIV/0!0.00%
5711-02-21-241-020 Township Fees-249,320-234,17815,142-252,9500#DIV/0!0.00%
6025-02-21-241-001 Transfer to Arena Building Reserve (Acct 2181)12,66312,663011,7090#DIV/0!0.00%
5612-02-21-241-000-5612 Transfer from Reserve00000#DIV/0!#DIV/0!
6035-02-21-241-001 Regular Salaries & Wages248,279183,186-65,093242,8210#DIV/0!0.00%
6048-02-21-241-001 Part Time Wages15,87233,97418,10216,3850#DIV/0!0.00%
6057-02-21-241-001 Overtime3,0004,9841,9843,0000#DIV/0!0.00%
6078-02-21-241-001 Vacation Pay6355,6615,0266550#DIV/0!0.00%
6067-02-21-241-001 Shift Premium1,5001,000-5001,5000#DIV/0!0.00%
6091-02-21-241-001 Other Payroll Costs81,15784,7863,62982,2340#DIV/0!0.00%
5557-02-21-241-275 Donations (Gerry Lowe Foundation)0-10,253-10,25300#DIV/0!#DIV/0!
6836-02-21-241-275 Deferred Revenue (Gerry Lowe Foundation)010,25310,25300#DIV/0!#DIV/0!
6011-02-21-241-001 Office Supplies1,0004,4573,4572,0000#DIV/0!0.00%
6012-02-21-241-001 New Arena - Principal155,527167,90812,381182,2680#DIV/0!0.00%
6014-02-21-241-001 New Arena - Interest145,817115,189-30,62887,7830#DIV/0!0.00%
6012-02-21-241-355 Principal (Energy Audit)24,92924,920-925,6470#DIV/0!0.00%
6014-02-21-241-355 Interest (Energy Audit)11,86911,871211,1420#DIV/0!0.00%
6038-02-21-241-001 Advertising1,2000-1,2005000#DIV/0!0.00%
6040-02-21-241-001 Clothing & Supplies3,0003,3903903,0000#DIV/0!0.00%
6102-02-21-241-001 Telephone/Internet18,00017,578-42212,0000#DIV/0!0.00%
6173-02-21-241-001 Insurance35,75835,758042,9090#DIV/0!0.00%
6180-02-21-241-001 Professional Fees2,00011,8409,84050,0000#DIV/0!0.00%
6174-02-21-241-001 Audit Fees50050005000#DIV/0!0.00%
6105-02-21-241-010 Hydro (Combined w/YC)145,000134,660-10,340145,0000#DIV/0!0.00%
6106-02-21-241-010 Water21,00036,30615,30621,0000#DIV/0!0.00%
6107-02-21-241-010 Heating Gas26,00039,02013,02026,0000#DIV/0!0.00%
6116-02-21-241-010 Janitorial Supplies7,5006,371-1,1296,0000#DIV/0!0.00%
6197-02-21-241-010 Janitorial Services63,40747,612-15,79561,4640#DIV/0!0.00%
6123-02-21-241-010 Property Repairs45,00039,387-5,61345,0000#DIV/0!0.00%
6145-02-21-241-010 Refrigeration Costs38,00033,906-4,09438,0000#DIV/0!0.00%
6108-02-21-241-011 Vehicle Gas & Oil3,0004,5871,5874,0000#DIV/0!0.00%
6110-02-21-241-011 Vehicle Repairs2,5001,737-7632,0000#DIV/0!0.00%
6110-02-21-241-378 Vehicle Repairs (F/A 7-0020; 2007 Ford F250)1,5008,0816,5813,5000#DIV/0!0.00%
6128-02-21-241-378 Vehicle Licence (F/A 7-0020; 2007 Ford F250)012012000#DIV/0!#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

January 24, 2022
2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION00000#DIV/0!#DIV/0!
6108-02-21-241-379 Vehicle Gas & Oil (F/A 7-0024; 2010 Silverado 1500 Summit)8001,3995998000#DIV/0!0.00%
6110-02-21-241-379 Vehicle Repairs (F/A 7-0024; 2010 Silverado 1500 Summit)50049-4515000#DIV/0!0.00%
6110-02-21-241-380 Vehicle Repairs (F/A 7-0062; 2016 Ford Super Duty Pick-up)050650600#DIV/0!#DIV/0!
6128-02-21-241-380 Vehicle Licence (F/A 7-0062; 2016 Ford Super Duty Pick-up)2,00048-1,9522,0000#DIV/0!0.00%
6110-02-21-241-012 Equipment Repairs00000#DIV/0!#DIV/0!
6110-02-21-241-381 Equipment Repairs (New Holland Tractor; F/A 5-1129)1,4000-1,4001,4000#DIV/0!0.00%
6110-02-21-241-382 Equipment Repairs (Comm Floor Cleaner; F/A 5-1111)2,0003,9421,9422,0000#DIV/0!0.00%
6108-02-241-383 Equipment Gas & Oil (2015 Olympia Ice Resurfacer; F/A 5-1135)4001,4701,0704000#DIV/0!0.00%
6110-02-21-241-383 Equipment Repairs (2015 Olympia Ice Resurfacer; F/A 5-1135)400293-1074000#DIV/0!0.00%
6108-02-241-384 Equipment Gas & Oil (2005 Olympia Ice Resurfacer; F/A 5-1041)00000#DIV/0!#DIV/0!
6110-02-241-384 Equipment Repairs (2005 Olympia Ice Resurfacer; F/A 5-1041)00000#DIV/0!#DIV/0!
6108-02-241-392 Gas & Oil (2005 Chevartruck)1,0001,8038031,0000#DIV/0!0.00%
6110-02-241-392 Repairs (2005 Chevartruck)00000#DIV/0!#DIV/0!
6128-02-241-392 Licence (2005 Chevartruck)00000#DIV/0!#DIV/0!
6108-02-241-393 Gas & Oil (2018 Massey Ferguson Tractor)00000#DIV/0!#DIV/0!
6836-02-241-413 COVID Funding; Trsf from deferred revenue0-331,997-331,99700#DIV/0!#DIV/0!
6792-02-241-413 COVID-19 Expenditures043,46943,46900#DIV/0!#DIV/0!
TOTAL COMMUNITY CENTRE ARENA335,293281,706-53,587391,567000#DIV/0!
MEMORIAL COMMUNITY CENTRE CANTEEN
20212021202220222022%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
5551-02-21-242-020 Pro-shop/Canteen Lease-2,00002,00000#DIV/0!#DIV/0!
5889-02-21-242-020 Bar Sales-10,000010,00000#DIV/0!#DIV/0!
5886-02-21-242-020 Canteen Sales00000#DIV/0!#DIV/0!
5887-02-21-242-020 Vending Machine Commission-900-220680-1100#DIV/0!0.00%
5888-02-21-242-020 Soft Drink Volume Commission-900090000#DIV/0!#DIV/0!
6048-02-21-242-001 Part Time Wages (Canteen)00000#DIV/0!#DIV/0!
6048-02-21-242-240 Part Time Wages (Bar)14,0000-14,00000#DIV/0!#DIV/0!
6078-02-21-242-240 Vacation Pay (Bar)5600-56000#DIV/0!#DIV/0!
6091-02-21-242-240 Other Payroll Costs (Bar)1,6000-1,60000#DIV/0!#DIV/0!
6078-02-21-242-001 Vacation Pay (Canteen)00000#DIV/0!#DIV/0!
6091-02-21-242-001 Other Payroll Costs (Canteen)00000#DIV/0!#DIV/0!
6123-02-21-242-001 Property Repairs4000-40000#DIV/0!#DIV/0!
6783-02-21-242-001 Bar Supplies4,5000-4,50000#DIV/0!#DIV/0!
6742-02-21-242-001 Canteen Supplies00000#DIV/0!#DIV/0!
TOTAL COMMUNITY CENTRE CANTEEN7,260-220-7,480-110000#DIV/0!
TOTAL COMMUNITY CENTRE GENERAL342,553281,486-61,067391,457000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET COMMUNITY SERVICES GENERAL BUDGETPage 35
January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
ACCOUNT/DESCRIPTIONTENNIS COURTS/PARKS CANTEEN
5551-02-21-246-020 Canteen Lease00000#DIV/0!
5575-02-21-246-020 Rental Revenue00000#DIV/0!
6105-02-21-246-001 Hydro750550-2007500#DIV/0!
TOTAL TENNIS COURTS750550-200750000#DIV/0!
SENIORS FACILITY
2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
ACCOUNT/DESCRIPTION-3,400-2,885515-3,4000#DIV/0!
02-21-247-001-5557 Donations00000#DIV/0!
02-21-247-001-6025 Transfer to Reserve00000#DIV/0!
02-21-247-001-6836 Trsf from Deferred Revenue00000#DIV/0!
6102-02-21-247-001 Telephone1803601801800#DIV/0!
6105-02-21-247-001 Hydro1,2001,4282281,2000#DIV/0!
6106-02-21-247-001 Water1,0001,019191,0000#DIV/0!
02-21-247-001-6107 Heating Fuel2,0001,500-5002,0000#DIV/0!
02-21-247-001-6116 Janitoral Supplies2000-2002000#DIV/0!
6123-02-21-247-001 Property Repairs1,20010,2639,0631,2000#DIV/0!
6197-02-21-247-001 Janitorial Services1,0000-1,0001,0000#DIV/0!
TOTAL SENIORS FACILITY3,38011,6858,3053,380000#DIV/0!
KINSMEN PAVILLON "New Sub-section"; (Previously utilities were under "Parks")
02-21-443-001-6105 Hydro8332,7621,9298330#DIV/0!
02-21-443-001-6106 Water1,2001,043-1571,2000#DIV/0!
02-21-443-001-6107 Heating Fuel3,0002,310-6903,0000#DIV/0!
02-21-443-001-6116 Janitorial Supplies00000#DIV/0!
02-21-443-001-6197 Janitorial Services00000#DIV/0!
02-21-443-001-6123 Repairs2,0000-2,0002,0000#DIV/0!
TOTAL KINSMEN PAVILLON7,0336,115-9187,033000#DIV/0!
* Insurance for this facility is under "Parks"
TOTAL COMMUNITY FACILITIES GENERAL757,604696,994-60,610814,129000#DIV/0!
TOTAL COMMUNITY FACILITIES BUDGET757,604710,589-47,015814,129000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGETPage 36
COMMUNITY SERVICES CAPITAL BUDGET
January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 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)000-35,0000#DIV/0!0.00%
6737-01-21-255-000 Columbarium00035,0000#DIV/0!0.00%
6052-01-21-255-000 Lawn Mower0000#DIV/0!#DIV/0!
TOTAL HILLCREST CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

COMMUNITY SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
HILLCREST CEMETERY
5534-02-21-255-020 Interest on Account-5,900-3,9201,980-3,9250#DIV/0!0.00%
5541-02-21-255-020 Sale of Plots-7,000-13,319-6,319-8,5000#DIV/0!0.00%
5542-02-21-255-020 Sale of Services-42,000-69,610-27,610-55,0000#DIV/0!0.00%
5557-02-21-255-020 Donations0-208-20800#DIV/0!#DIV/0!
5672-02-21-255-020 Columbarium Revenue-6,000-30,090-24,090-18,0000#DIV/0!0.00%
5424-02-21-255-088 Federal Grant (Canada Summer Jobs)00000#DIV/0!#DIV/0!
6035-02-21-255-001 Regular Salaries & Wages *54,58466,91912,33596,0180#DIV/0!0.00%
6048-02-21-255-001 Part time Wages18,6051,903-16,70219,2000#DIV/0!0.00%
6078-02-21-255-001 Vacation Pay7448961527680#DIV/0!0.00%
6091-02-21-255-001 Other Payroll Costs20,05921,8971,83831,9280#DIV/0!0.00%
6029-02-21-255-001 Membership Fees2000-2002000#DIV/0!0.00%
6040-02-21-255-001 Clothing & Supplies3007744741900#DIV/0!0.00%
6102-02-21-255-001 Telephone8009981988000#DIV/0!0.00%
6105-02-21-255-001 Hydro1,4001,8644641,6000#DIV/0!0.00%
6108-02-21-255-001 Vehicle Gas & Oil1,2004,0382,8381,2000#DIV/0!0.00%
6112-02-21-255-001 Equipment Repairs1,5002,6421,1421,5000#DIV/0!0.00%
6118-02-21-255-001 Tools, Accessories, etc2,000705-1,2951,5000#DIV/0!0.00%
6123-02-21-255-001 Property Repairs5,0009,6544,6545,0000#DIV/0!0.00%
6160-02-21-255-001 Cemetery License1,0000-1,0001,0000#DIV/0!0.00%
6173-02-21-255-001 Insurance7451,1794341,4150#DIV/0!0.00%
6025-02-21-255-001 Transfer to Reserve (Account 2051)00000#DIV/0!#DIV/0!
6177-02-21-255-001 Computer Maintenance1,0001,8598591,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,000888-1121,0000#DIV/0!0.00%
6195-02-21-255-001 Grave Opening Contract00000#DIV/0!#DIV/0!
49,637-931-50,56879,294000#DIV/0!
  • Incr. F/T staff

TOWN OF SMITHS FALLS 2022 BUDGET COMMUNITY SERVICES CAPITAL BUDGETPage 38
January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTIONCHILD 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)-70,000-7,54462,4560#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)175,0007,544-167,4560#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 Grant-105,0000105,0000#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 2022 BUDGET

TOWN OF SMITHS FALLS 2022 BUDGET

COMMUNITY SERVICES GENERAL BUDGET

January 24, 2022

January 24, 2022
2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.Completed% Completed
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.Completed% Completed

CHILD DEVELOPMENT CENTRE

ADMINISTRATION
5417-02-21-258-020 County CDC Fee Subsidy-103,100-73,29129,809-103,1000#DIV/0!0.00%
5418-02-21-258-020 Direct Operating Grant *-146,294-235,700-89,406-146,2940#DIV/0!0.00%
5533-02-21-258-020 Parents "In Need" Fees-113,636-31,78581,851-113,6360#DIV/0!0.00%
6836-02-21-258-413 COVID-funding; Trsf from deferred revenue0-83,869-83,86900#DIV/0!#DIV/0!
5659-02-21-258-020 Parents "Full" Fees - Non-subsid.-443,575-300,058143,517-443,5750#DIV/0!0.00%
02-21-258-413-6782 Expenses (COVID-19)02,9442,94400#DIV/0!#DIV/0!
02-21-258-413-6035 Regular Wages (COVID-19)013,93713,93700#DIV/0!#DIV/0!
02-21-258-413-6048 Part-time Wages (COVID-19)034,16934,16900#DIV/0!#DIV/0!
02-21-258-413-6078 Vacation Pay (COVID-19)01,7051,70500#DIV/0!#DIV/0!
02-21-258-413-6091 Other Benefit Costs (COVID-19)08,3658,36500#DIV/0!#DIV/0!
02-21-258-413-5441 Prov/County Grant (COVID-19)0-88,007-88,00700#DIV/0!#DIV/0!
02-21-258-293-5421 Provincial Wage Enhancement Grant0-26,786-26,78600#DIV/0!#DIV/0!
02-21-258-293-6836 Provincial Wage Enhancement Grant; Deferred Revenue0-19,478-19,47800#DIV/0!#DIV/0!
02-21-258-293-6035 Provincial Wage Enhancement Grant; FT Wages013,97513,97500#DIV/0!#DIV/0!
02-21-258-293-6048 Provincial Wage Enhancement Grant; PT Wages07,3087,30800#DIV/0!#DIV/0!
02-21-258-293-6091 Provincial Wage Enhancement Grant; Other benefits03,7243,72400#DIV/0!#DIV/0!
6035-02-21-258-001 Regular Salaries & Wages39,87637,471-2,40540,5020#DIV/0!0.00%
6091-02-21-258-001 Other Payroll Costs24,39322,760-1,63325,5680#DIV/0!0.00%
6025-02-21-258-001 Trsf to Payroll Reserve (Surplus from Group Benefits)00000#DIV/0!#DIV/0!
6011-02-21-258-001 Office Supplies2,5001,435-1,0652,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 Postage8052-28800#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.5000-5005000#DIV/0!0.00%
6836-02-21-258-001 Trsf to/from Deferred Revenue00000#DIV/0!#DIV/0!
6102-02-21-258-001 Telephone4,00010,8496,8494,0000#DIV/0!0.00%
6174-02-21-258-001 Audit Fees00000#DIV/0!#DIV/0!
6025-02-21-258-001 Trsf to Reserve (Account 2051)00000#DIV/0!#DIV/0!
6173-02-21-258-001 Insurance2,9685,0492,0816,0590#DIV/0!0.00%
* Based on 2020 "actuals" @$12,191.16/month
TOTAL ADMINISTRATION-730,688-695,23135,457-725,796000#DIV/0!

COMMUNITY SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
PROGRAMS
6035-02-21-258-084 Regular Salaries & Wages211,794148,835-62,959216,7610#DIV/0!0.00%
6048-02-21-258-084 Part Time Wages *444,939385,656-59,283471,7020#DIV/0!0.00%
6078-02-21-258-084 Vacation Pay18,45918,64218320,3790#DIV/0!0.00%
6091-02-21-258-084 Other Payroll Costs122,539106,300-16,239132,2320#DIV/0!0.00%
6025-02-21-258-084 Trsf to Payroll Reserve (Surplus from Group Benefits)00000#DIV/0!#DIV/0!
6015-02-21-258-084 Travel Expense1000-1001000#DIV/0!0.00%
6039-02-21-258-084 Staff Training & Develop.3,5001,309-2,1913,5000#DIV/0!0.00%
6046-02-21-258-084 Program Supplies3,5000-3,5003,5000#DIV/0!0.00%
TOTAL PROGRAMS804,831660,742-144,089848,174000#DIV/0!
* Reduced; pay equity review will be phased in over 2 years
DIETARY
6048-02-21-258-024 Part Time Wages34,06733,515-55234,6010#DIV/0!0.00%
6078-02-21-258-024 Vacation Pay2,0441,922-1222,0760#DIV/0!0.00%
6091-02-21-258-024 Other Payroll Costs4,2987,4673,1694,5180#DIV/0!0.00%
6015-02-21-258-024 Travel Expense1000-1001000#DIV/0!0.00%
6017-02-21-258-024 Coffee/Food Supplies27,00015,543-11,45724,0000#DIV/0!0.00%
TOTAL DIETARY67,50958,447-9,06265,295000#DIV/0!
CDC FUNDRAISING
5557-02-21-258-013 Donations00000#DIV/0!#DIV/0!
6046-02-21-258-013 Program Supplies00000#DIV/0!#DIV/0!
6025-02-21-258-013 Transfer to/from Reserve00000#DIV/0!#DIV/0!
TOTAL CDC FUNDRAISING0000000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

COMMUNITY SERVICES GENERAL BUDGET

January 24,2022 ACCOUNT/DESCRIPTION

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
OCCUPANCY
6048-02-21-258-025 Part Time Wages *00000#DIV/0!#DIV/0!
6078-02-21-258-025 Vacation Pay00000#DIV/0!#DIV/0!
6091-02-21-258-025 Other Payroll Costs00000#DIV/0!#DIV/0!
6046-02-21-258-025 Program Supplies500287-2135000#DIV/0!0.00%
6105-02-21-258-025 Hydro2,8001,989-8112,8000#DIV/0!0.00%
6106-02-21-258-025 Water2001,1739732000#DIV/0!0.00%
6107-02-21-258-025 Heating Fuel1,0001,4874871,0000#DIV/0!0.00%
6118-02-21-258-025 Tools, Accessories, etc50019-4815000#DIV/0!0.00%
6123-02-21-258-025 Property Repairs054054000#DIV/0!#DIV/0!
6152-02-21-258-025 Lease ("New")24,00029,6115,61124,0000#DIV/0!0.00%
6015-02-21-258-025 Travel Expense5000-5005000#DIV/0!0.00%
* Now supplied by school
TOTAL OCCUPANCY29,50035,1065,60629,500000#DIV/0!
TOTAL CDC GENERAL BUDGET171,15259,064-112,088217,173000#DIV/0!
TOTAL CDC BUDGET171,15259,064-112,088217,173000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

WORKS & UTILITIES

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
WATER TREATMENT PLANT CAPITAL BUDGET
5612-01-31-301-309 Trsf from WTP Capital Reserve (Account 2083)-191,500-128,69662,804-641,9440#DIV/0!0.00%
6750-01-31-301-000 Water Tower Detailed Design178,0105,155-172,855165,0000#DIV/0!0.00%
6844-01-31-301-000 WTP Financial Plan Update5,3514,597-7540#DIV/0!#DIV/0!
6340-01-31-301-000 Equipment Analyzer Replacements15,00012,095-2,9057,5000#DIV/0!0.00%
6177-01-31-301-000 WIN 911 Software - Alarm Call-out System (SCADA)20,00016,609-3,3910#DIV/0!#DIV/0!
6205-01-31-301-138 Trunk Upgrade (New Water Tower)0001,820,0000#DIV/0!0.00%
6387-01-31-301-000 New Water Tower0002,335,0000#DIV/0!0.00%
01-31-301-000-5869 Federal Gas Tax Reserve $$-25,475025,475-367,6090#DIV/0!0.00%
01-31-301-125-6205 Distribution Design; George St.46,5000-46,5000#DIV/0!#DIV/0!
01-31-301-350-6732 Beckwith St. Phase 2; Detailed Design25,50411,813-13,6910#DIV/0!#DIV/0!
01-31-301-000-6049 DAF Piping (Drain); Detailed Design21,82716,126-5,7010#DIV/0!#DIV/0!
5421-01-31-301-000 ICIP/Green Stream Grant000-1,833,2500#DIV/0!0.00%
6808-01-31-301-422 New DAF Drain40,00036,021-3,9796,3660#DIV/0!0.00%
5615-01-31-301-000 Unfinanced Capital000-2,321,7500#DIV/0!0.00%
6205-01-31-301-438 Zebra Mussel (Intake) (Incl Engineering)000136,1000#DIV/0!0.00%
6808-01-31-301-438 High Lift Piping (Replacements)00035,0000#DIV/0!0.00%
6808-01-31-301-423 Rebuild HLP 182 (High Lift Pump)20,0000-20,00021,2200#DIV/0!0.00%
6205-01-31-301-350 Beckwith St. Project/Water Mains000672,2980#DIV/0!0.00%
5612-01-31-301-000 Transfer from Reserve (Project Carry-over acct 2051) **-205,217-37,692167,525-177,3800#DIV/0!0.00%
6329-01-31-301-000 Low Lift Pump Rebuild0009,5490#DIV/0!0.00%
6347-01-31-301-0000 AIT 165 Inline Pre-reservoir Chlorine Analyzer Replacement10,0000#DIV/0!0.00%
6433-01-31-301-000 BET (Backwash Equalization Tank) Cleaning & Inspection16,0000#DIV/0!0.00%
6808-01-31-301-439 AIT 180 Inline Free Chlorine Analyzer Replacement10,0000.00%
6808-01-31-301-440 Reservoir 1 & 2 Cleaning & Inspection21,0000.00%
6808-01-31-301-441 Equipment Analyzer Failure15,0000.00%
6690-01-31-301-000 UV Reactor 161 Sensor Replacement25,0000.00%
6478-01-31-301-000 2009 Chev Silverado Replacement36,9000.00%
01-31-301-001-6360 Replace Turbidity Analyzer (AIT 102 & AIT 184)20,00018,676-1,3240#DIV/0!#DIV/0!
6081-01-31-301-001 Stainless Steel HL pumping Header Repairs30,00015,296-14,7040#DIV/0!#DIV/0!
WATER TREATMENT PLANT CAPITAL0-30,000-30,0000000#DIV/0!

WORKS & UTILITIES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
WATER TREATMENT PLANT REVENUE
5820-02-31-301-020 Residential Water-576,157-585,092-8,935-585,5150#DIV/0!0.00%
5821-02-31-301-020 Commercial Water-365,687-349,02816,659-353,2670#DIV/0!0.00%
5823-02-31-301-020 Residential Other Municipalities-57,566-57,717-151-59,2030#DIV/0!0.00%
5824-02-31-301-020 Commercial Other Municipalities-1,481-1,740-259-1,5240#DIV/0!0.00%
5825-02-31-301-020 Public Hydrants-63,693-63,6930-64,0000#DIV/0!0.00%
5826-02-31-301-020 Base Service Charge-1,575,043-1,600,644-25,601-1,629,7760#DIV/0!0.00%
5827-02-31-301-020 Occupancy Charge-7,500-8,154-654-7,5000#DIV/0!0.00%
5556-02-31-301-020 Misc Sales0-150-15000#DIV/0!#DIV/0!
5828-02-31-301-020 Misc Water Sales-5,000-8,649-3,649-5,5000#DIV/0!0.00%
5829-02-31-301-020 Late Payment Charge-60,000-43,68116,319-60,0000#DIV/0!0.00%
5831-02-31-301-020 Misc Revenue-15,000-14,536464-15,0000#DIV/0!0.00%
2020 WTP Financial Plan projects 5.5% rate increase
TOTAL REVENUE-2,727,127-2,733,084-5,957-2,781,285000#DIV/0!
ADMINISTRATION
6035-02-31-301-001 Regular Salaries & Wages87,40481,164-6,24090,0240#DIV/0!0.00%
6091-02-31-301-001 Other Payroll Costs23,80624,41060424,8310#DIV/0!0.00%
6011-02-31-301-001 Office Supplies5,0004,496-5045,0000#DIV/0!0.00%
6015-02-31-301-001 Travel2500-2505000#DIV/0!0.00%
6023-02-31-301-001 Postage15,00016,9471,94715,0000#DIV/0!0.00%
6029-02-31-301-001 Membership Fees2,5002,457-432,5000#DIV/0!0.00%
6042-02-31-301-001 Courier600114-4866000#DIV/0!0.00%
6102-02-31-301-001 Telephone14,00020,2966,29615,0000#DIV/0!0.00%
6173-02-31-301-001 Insurance26,15221,857-4,29526,2280#DIV/0!0.00%
6025-02-31-301-309 Transfer to Capital Reserve (Acct 2083)492,856700,144207,288552,7590#DIV/0!0.00%
6180-02-31-301-001 Professional Fees8,0005,179-2,8218,0000#DIV/0!0.00%
6564-02-31-301-001 Mail Sorter3,5003,390-1103,5000#DIV/0!0.00%
TOTAL ADMINISTRATION679,068880,454201,386743,942000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET WORKS & UTILITIES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
WATER TREATMENT PLANT OPERATIONS
6035-02-31-301-139 Regular Salaries & Wages217,180181,161-36,019209,3390#DIV/0!0.00%
6048-02-31-301-139 Part Time Wages9,48818,1578,6699,1840#DIV/0!0.00%
6057-02-31-301-139 Overtime14,40015,39999914,0000#DIV/0!0.00%
6069-02-31-301-139 Stat Time11,4599,911-1,54811,4590#DIV/0!0.00%
6067-02-31-301-139 On-Call Pay12,00012,40140115,0000#DIV/0!0.00%
6078-02-31-301-139 Vacation Pay15,89616,19730115,8840#DIV/0!0.00%
6084-02-31-301-139 Sick Pay6,6845,216-1,4686,6840#DIV/0!0.00%
6091-02-31-301-139 Other Payroll Costs82,72576,066-6,65983,7430#DIV/0!0.00%
6039-02-31-301-139 Staff Training & Development11,0004,144-6,85615,0000#DIV/0!0.00%
6040-02-31-301-139 Safety Clothing Allowance2,4001,614-7862,5000#DIV/0!0.00%
6105-02-31-301-139 Hydro230,000175,780-54,220210,0000#DIV/0!0.00%
6107-02-31-301-139 Heating Fuel38,00030,271-7,72938,0000#DIV/0!0.00%
6316-02-31-301-139 Building Mtce - Supplies10,0002,813-7,18710,0000#DIV/0!0.00%
6197-02-31-301-139 Janitorial Services3,000907-2,0933,0000#DIV/0!0.00%
6317-02-31-301-139 Building Mtce - Equip32,00029,168-2,83232,0000#DIV/0!0.00%
6176-02-31-301-139 Computer Maintenance1,000323-6772,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 Lift5006781785000#DIV/0!0.00%
6331-02-31-301-139 - Intake1,0003,6162,6163,6160#DIV/0!0.00%
6332-02-31-301-139 - AquaDAF6,5001,753-4,7476,5000#DIV/0!0.00%
6333-02-31-301-139 - Filters1,000236-7641000#DIV/0!0.00%
6335-02-31-301-139 - Pipes & Valves2,5000-2,5002,5000#DIV/0!0.00%
6337-02-31-301-139 - Motor Control10,0008,064-1,93615,0000#DIV/0!0.00%
6334-02-31-301-139 - Process Equip7,5006,461-1,0397,5000#DIV/0!0.00%
6118-02-31-301-139 - Small Tools1,000277-7231,0000#DIV/0!0.00%
6762-02-31-301-139 - SCADA10,0007,194-2,80610,0000#DIV/0!0.00%
6177-02-31-301-139 Annual Software Licenses ("New")15,00016,8591,85915,0000#DIV/0!0.00%
6340-02-31-301-139 Analysis Equipment8,0007,660-3409,0000#DIV/0!0.00%
6689-02-31-301-139 Chemical Pumps2,0001,965-352,0000#DIV/0!0.00%
6690-02-31-301-139 UV System11,00011,91891811,0000#DIV/0!0.00%
6691-02-31-301-139 Reservoir5,0002,486-2,5145,0000#DIV/0!0.00%
6692-02-31-301-139 Wastewater System1,000163-8371,0000#DIV/0!0.00%
6725-02-31-301-139 Emergency Genset Service5,00015,84210,84210,0000#DIV/0!0.00%
6728-02-31-301-139 Diesel Fuel4,5001,352-3,1484,5000#DIV/0!0.00%
6726-02-31-301-139 Calibrate Flow Meter Repairs2,5001,826-6742,5000#DIV/0!0.00%
6727-02-31-301-139 Process Equipment Inventory6,00011,5845,5848,0000#DIV/0!0.00%

TOWN OF SMITHS FALLS 2022 BUDGET WORKS & UTILITIES GENERAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
WATER TREATMENT PLANT OPERATIONS
6108-02-31-301-340 Vehicle Fuel (2009 F150 Pick-up; F/A 7-0014)021821800#DIV/0!#DIV/0!
6110-02-31-301-340 Vehicle Repairs; (2009 F150 Pick-up; F/A 7-0065)00000#DIV/0!#DIV/0!
6128-02-31-301-340 Vehicle Licence; (2009 F150 Pick-up; F/A 7-0065)00000#DIV/0!#DIV/0!
6108-02-31-301-341 Vehicle Fuel (2015 Chev Silverado; F/A 7-0059)1,000691-3091,0000#DIV/0!0.00%
6110-02-31-301-341 Vehicle Repairs; (2015 Chev Silverado; F/A 7-0059)1,500144-1,3561,5000#DIV/0!0.00%
6128-02-31-301-341 Vehicle Licence; (2015 Chev Silverado; F/A 7-0059)140120-201400#DIV/0!0.00%
6319-02-31-301-139 Alarm Monitoring2,5001,554-9462,5000#DIV/0!0.00%
6193-02-31-301-139 Radio & Pager Maintenance2,000264-1,7362,0000#DIV/0!0.00%
6301-02-31-301-139 Municipal Taxes - PIL182,178167,853-14,325167,8530#DIV/0!0.00%
6342-02-31-301-139 Reagents10,00010,66866810,0000#DIV/0!0.00%
6280-02-31-301-139 Safety Equipment & Supplies2,5002,095-4053,0000#DIV/0!0.00%
6343-02-31-301-139 Lab Supplies3,0005,2952,2953,0000#DIV/0!0.00%
6345-02-31-301-139 Chemicals -Coagulant115,50092,130-23,370115,5000#DIV/0!0.00%
6347-02-31-301-139 - Chlorine27,50027,65315327,5000#DIV/0!0.00%
6385-02-31-301-139 - Polymer2,6002,634342,7000#DIV/0!0.00%
6675-02-31-301-139 - Calcium Thiosulfate2,5002,588882,5000#DIV/0!0.00%
6676-02-31-301-139 - Sodium Hydroxide35,00017,553-17,44735,0000#DIV/0!0.00%
6311-02-31-301-139 Water Sampling/Lead Testing30,00019,085-10,91525,0000#DIV/0!0.00%
6763-02-31-301-139 Water Conservation Public Relations1,000486-5141,0000#DIV/0!0.00%
6387-02-31-301-139 Water Tower Maintenance5,000554-4,4465,0000#DIV/0!0.00%
02-31-301-001-6010 Write off Old Accounts0-11-1100#DIV/0!#DIV/0!
6012-02-31-301-139 Principal - New WTP231,194231,1940242,4960#DIV/0!0.00%
6014-02-31-301-139 Interest - New WTP362,151358,046-4,105350,8490#DIV/0!0.00%
6837-02-31-301-139 Compliance Issues4,0002,072-1,9284,0000#DIV/0!0.00%
6346-02-31-301-139 Chemicals - Fluoride10,00010,76376310,0000#DIV/0!0.00%
TOTAL WATER TREATMENT PLANT OPERATIONS1,828,9951,633,111-195,8841,806,047000#DIV/0!
TOTAL WATER TREATMENT PLANT GENERAL-219,064-219,519-455-231,296000#DIV/0!
TOTAL WATER TREATMENT PLANT-219,064-249,519-30,455-231,296000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET WORKS & UTILITIES

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
WATER POLLUTION CONTROL PLANT CAPITAL BUDGET
6074-01-31-302-000 Control Building SCADA Upgrade0000#DIV/0!#DIV/0!
6844-01-31-302-000 Wastewater Financial Plan Update5,3514,597-7540#DIV/0!#DIV/0!
6508-01-31-302-000 Chemical Feed Pump #100010,6100#DIV/0!0.00%
01-31-302-000-6063 Flow Monitoring Study40,50015,814-24,6860#DIV/0!#DIV/0!
01-31-302-401-6808 Wet Well Pump Rebuild25,00020,090-4,9100#DIV/0!#DIV/0!
01-31-302-000-6430 Replacement Bar Screen (Now under one PLC Project)568,19730,372-537,825546,2710#DIV/0!0.00%
6823-01-31-302-000 Sludge Tank Mixer25,00026,9481,9480#DIV/0!#DIV/0!
6808-01-31-302-441 Equipment/Analyzer Failure070,40070,40015,0000#DIV/0!0.00%
6508-01-31-302-442 Sewage Lift Pump Rebuild00026,5250#DIV/0!0.00%
01-31-302-000-6177 WIN 911 Software - Alarm Call-out System (SCADA)20,00016,609-3,3910#DIV/0!#DIV/0!
01-31-302-000-6534 Replacement Flooring - Laboratory25,7000-25,70025,7000#DIV/0!0.00%
01-31-302-125-6205 Design; George St.44,7000-44,7000#DIV/0!#DIV/0!
01-31-302-429-6823 Sludge Tank Mixer Shaft010,24310,2430#DIV/0!#DIV/0!
6511-01-31-302-000 South Secondary Tank Collector00026,5250#DIV/0!0.00%
6689-01-31-302-000 Chemical Feed Pump #200010,6100#DIV/0!0.00%
01-31-302-000-6767 Trenchless Sewer Lining100,00076,400-23,6000#DIV/0!#DIV/0!
6434-01-31-302-000 South Secondary Tank Isolation Gates00053,0500#DIV/0!#REF!
01-31-302-000-5869 Federal Gas Tax0000#DIV/0!#DIV/0!
01-31-302-000-6081 Bar Screen Project (Headworks)000550,0000#DIV/0!0.00%
01-31-302-348-6205 Contractor (Lorne St.; Sanitary Sewers)0000#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 Sewers019,85619,856411,4040#DIV/0!0.00%
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 Design1,2501,119-1310#DIV/0!#DIV/0!
5612-01-31-302-309 Transfer from WPCP Capital Reserve (Acct 2085)-240,400-240,546-146-1,103,7240#DIV/0!0.00%
5612-01-31-302-000 Transfer from Reserve (Acct 2051)-615,298-51,902563,396-571,9710#DIV/0!0.00%
6836-01-31-302-394 Tref from deferred revenue (Rural & Small Municipalities grant)0000#DIV/0!#DIV/0!
TOTAL WATER POLLUTION CONTROL PLANT CAPITAL0000000#DIV/0!

WORKS & UTILITIES GENERAL BUDGET

ACCCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
WATER POLLUTION CONTROL PLANT REVENUE
5611-02-31-302-020 Sewer Surcharge-2,667,058-2,668,234-1,176-2,710,8310#DIV/0!0.00%
5556-02-31-302-020 Misc Sales00000#DIV/0!#DIV/0!
5666-02-31-302-020 Pellet Sales-5,000-9844,016-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 Fees-10,800-10,600200-10,8000#DIV/0!0.00%
2020 WPCP Financial Plan projects 3.5% rate increase TOTAL REVENUE-2,682,858-2,679,8183,040-2,726,631000#DIV/0!
ADMINISTRATION
6035-02-31-302-001 Regular Salaries & Wages80,10178,832-1,26982,6060#DIV/0!0.00%
6091-02-31-302-001 Other Payroll Costs23,42616,131-7,29524,2770#DIV/0!0.00%
6015-02-31-302-001 Travel25057-1935000-100.0%0.00%
6102-02-31-302-001 Telephone11,00019,0258,02515,0000-100.0%0.00%
6025-02-31-302-309 Transfer to Capital Reserve (Acct 2085)739,1661,027,104287,938721,4690#DIV/0!0.00%
6180-02-31-302-001 Professional Fees10,0005,152-4,84810,0000#DIV/0!0.00%
6173-02-31-302-001 Insurance68,39864,732-3,66677,6790#DIV/0!0.00%
TOTAL ADMINISTRATION932,3411,211,033278,692931,531000#DIV/0!

TOWN OF SMITHS FALLS

2022 GENERAL BUDGET WORKS & UTILITIES January 24, 2022 ACCOUNT/DESCRIPTION2022 GENERAL BUDGET WORKS & UTILITIES 2021 Budget2022 GENERAL BUDGET WORKS & UTILITIES 2021 Actual2022 GENERAL BUDGET WORKS & UTILITIES 2022 Var.Page 48 2022 BudgetPage 48 2022 To DatePage 48 % Var.Page 48 % Var.
6035-02-31-302-001 Regular Salaries & Wages308,398272,222-36,176306,4120 #DIV/0!0.00%
6057-02-31-302-001 Overtime12,00017,4895,48912,0000 #DIV/0!0.00%
6048-02-31-302-001 Part Time Wages9,488683-8,8059,1840 #DIV/0!0.00%
6067-02-31-302-001 On-Call Pay12,00014,8862,88615,0000 #DIV/0!0.00%
6069-02-31-302-001 Stat Time10,97114,6873,71610,9710 #DIV/0!0.00%
6078-02-31-302-001 Vacation Pay16,37918,9312,55216,3660 #DIV/0!0.00%
6084-02-31-302-001 Sick Pay6,6847,4677836,6840 #DIV/0!0.00%
6091-02-31-302-001 Other Payroll Costs108,086105,507-2,579117,9240 #DIV/0!0.00%
6011-02-31-302-001 Office Supplies2,7503,0242743,0000 #DIV/0!0.00%
6039-02-31-302-001 Staff Training9,0003,321-5,67915,0000 #DIV/0!0.00%
6040-02-31-302-001 Clothing Supplies3,0002,407-5933,0000 #DIV/0!0.00%
6105-02-31-302-001 Hydro415,000331,228-83,772400,0000 #DIV/0!0.00%
6106-02-31-302-001 Water20,00016,540-3,46018,0000 #DIV/0!0.00%
6112-02-31-302-001 Equip Rep - Plant - Sewage Lift Station25,00022,882-2,11825,0000 #DIV/0!0.00%
6430-02-31-302-001 - Grit Removal3,1000-3,1003,0000 #DIV/0!0.00%
6431-02-31-302-001 - Raw Sludge Bldg10,0001,583-8,41710,0000 #DIV/0!0.00%
6432-02-31-302-001 - Primary Collectors10,000182-9,81810,0000 #DIV/0!0.00%
6433-02-31-302-001 - Aeration Tanks10,0000-10,0005,0000 #DIV/0!0.00%
6434-02-31-302-001 - Secondary Clarifiers5,0000-5,00010,0000 #DIV/0!0.00%
6435-02-31-302-001 - RAS Sludge Pumps5,0006,9101,9105,0000 #DIV/0!0.00%
6436-02-31-302-001 - Mixing Tanks5,0005,8588585,0000 #DIV/0!0.00%
6437-02-31-302-001 - Filters5,000549-4,4515,0000 #DIV/0!0.00%
6438-02-31-302-001 - UV System5,00020,26215,26220,0000 #DIV/0!0.00%
6439-02-31-302-001 - Chemical Pumps3,000534-2,4665,0000 #DIV/0!0.00%
6440-02-31-302-001 - Computers2,000173-1,8272,0000 #DIV/0!0.00%
6441-02-31-302-001 Equip Rep - Pelletizer - Belt Press47,00054,2027,20250,0000 #DIV/0!0.00%
6442-02-31-302-001 -Twin Mixers5,0000-5,0005,0000 #DIV/0!0.00%
6443-02-31-302-001 Equip Rep - Pelletizer - Drying Drum3,0005,7452,7453,0000 #DIV/0!0.00%
6444-02-31-302-001 - Secondary Cyclone5,0002,820-2,1805,0000 #DIV/0!0.00%
6445-02-31-302-001 - Bucket Elevator/Sizer2,0002,1511512,0000 #DIV/0!0.00%
6446-02-31-302-001 - Storage/Pellet Handling1,500202-1,2981,5000 #DIV/0!0.00%
6447-02-31-302-001 - Computers2,5000-2,5002,5000 #DIV/0!0.00%
6456-02-31-302-001 - Lift Truck2,5004,0691,5692,5000 #DIV/0!0.00%
6316-02-31-302-001 Building Maintenance & Cleaning47,00021,120-25,88047,0000 #DIV/0!0.00%
6197-02-31-302-001 Janitorial Services3,0001,244-1,7563,0000 #DIV/0!0.00%
6448-02-31-302-001 Bldg Cleaning Supplies2,8001,436-1,3643,0000 #DIV/0!0.00%
6322-02-31-302-001 Small Equipment & Tools2,0001,242-7582,0000 #DIV/0!0.00%
6207-02-31-302-001 Rideau Canal Lease35635603560 #DIV/0!0.00%
6208-02-31-302-001 CN Lease2540-2542540 #DIV/0!0.00%
6210-02-31-302-001 Sewer Monitoring Program8,0000-8,0005,0000 #DIV/0!0.00%
6029-02-31-302-001 Membership Fees1,000621-3791,0000 #DIV/0!0.00%
6280-02-31-302-001 Safety Equipment2,7006,9584,2583,0000 #DIV/0!0.00%

TOWN OF SMITHS FALLS 2022 BUDGET

WORKS & UTILITIES GENERAL BUDGET
January 24, 202220212021202220222022%%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateVar.Var.Completed
WATER POLLUTION CONTROL PLANT OPERATIONS
6375-02-31-302-001 Sludge Disposal10,0004,054-5,94610,0000#DIV/0!0.00%
6222-02-31-302-001 Pellet Bagging Costs5009894897500#DIV/0!0.00%
6107-02-31-302-001 Heating Fuel119,00081,479-37,521119,0000#DIV/0!0.00%
6108-02-31-302-342 Vehicle Gas (2013 Chev Silverado; F/A 7-0054)1,200243-9571,2000#DIV/0!0.00%
6110-02-31-302-342 Vehicle Repairs (2013 Chev Silverado; F/A 7-0054)2,000688-1,3122,0000#DIV/0!0.00%
6128-02-31-302-342 Vehicle Licences (2013 Chev Silverado; F/A 7-0054)270266-42700#DIV/0!0.00%
6311-02-31-302-001 Sampling35,00028,839-6,16135,0000#DIV/0!0.00%
6547-02-31-302-001 Sampling Equipment Repairs2,000293-1,7072,0000#DIV/0!0.00%
6319-02-31-302-001 Alarm Monitoring2,500732-1,7682,5000#DIV/0!0.00%
6119-02-31-302-001 Radio & Pager Maintenance2,500162-2,3382,5000#DIV/0!0.00%
6042-02-31-302-001 Courier525350-1755000#DIV/0!0.00%
6343-02-31-302-001 Lab Supplies5,0004,499-5015,0000#DIV/0!0.00%
6344-02-31-302-001 Chemicals - Phas95,00068,674-26,32695,0000#DIV/0!0.00%
6385-02-31-302-001 - Polymer45,00036,675-8,32540,0000#DIV/0!0.00%
6012-02-31-302-251 Pelletizer - Principal32,06332,063033,4260#DIV/0!0.00%
6014-02-31-302-251 Pelletizer - Interest21,79221,786-620,4230#DIV/0!0.00%
6012-02-31-302-355 Energy Audit - Principal14,93514,935015,3700#DIV/0!0.00%
6014-02-31-302-355 Energy Audit - Interest7,1297,112-176,6780#DIV/0!0.00%
6342-02-31-302-001 Reagents5,0004,067-9335,0000#DIV/0!0.00%
6095-02-31-302-001 Emergency Equipment28,00010,634-17,36630,0000#DIV/0!0.00%
6177-02-31-302-001 Annual Software Licenses5,00010,5065,50610,0000#DIV/0!0.00%
6762-02-31-302-001 SCADA Repairs12,00018,7276,72712,0000#DIV/0!0.00%
6766-02-31-302-001 CSO Repairs5,0000-5,0005,0000#DIV/0!0.00%
6607-02-31-302-001 Compliance Issues1,7002,5098091,5000#DIV/0!0.00%
6073-02-31-302-001 Pelletizer Parts Inventory22,00029,7637,76325,0000#DIV/0!0.00%
6493-02-31-302-001 Sludge Holding Tanks1,0001,4654651,0000#DIV/0!0.00%
6494-02-31-302-001 Sludge Pumps1,0000-1,0001,0000#DIV/0!0.00%
6495-02-31-302-001 Main Heat Exchanger1,0000-1,0001,0000#DIV/0!0.00%
6491-02-31-304-138 Contracted Services - Town43,51353,4189,90524,84000#DIV/0!0.00%
6492-02-31-304-012 Use of Town Vehicles56,69058,2221,53353,19500#DIV/0!0.00%
6301-02-31-302-001 Municipal Taxes - PIL108,713100,122-8,591100,1220#DIV/0!0.00%
TOTAL WATER POLLUTION CONTROL PLANT OPERATIONS1,844,4961,562,763-281,7321,835,925000#DIV/0!
TOTAL WATER POLLUTION CONTROL PLANT GENERAL93,97993,978040,825000#DIV/0!
TOTAL WATER POLLUTION CONTROL PLANT93,97993,978040,825000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGETPage 50
PUBLIC WORKS & UTILITIES CAPITAL BUDGET
January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 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 Work000000-35,000#DIV/0!#DIV/0!
Bridges0000000#DIV/0!#DIV/0!
Public Works Buildings000000-285,000#DIV/0!#DIV/0!
TOTAL CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET PUBLIC WORKS & UTILITIES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 Actual INFRASTRUCTURE MAINTENANCE2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2021 BudgetVar.2022 Budget2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ADMINISTRATION
6035-02-31-303-001 Regular Salaries218,357186,306-32,051209,3970#DIV/0!0.00%
6048-02-31-303-001 Part-time Salaries92,43611,209-81,22738,4000#DIV/0!0.00%
6057-02-31-303-001 Overtime20,00034,31514,31520,0000#DIV/0!0.00%
6067-02-31-303-001 Shift Premium17,00017,81881817,0000#DIV/0!0.00%
6069-02-31-303-001 Stat Time27,21323,351-3,86227,2130#DIV/0!0.00%
6078-02-31-303-001 Vacation Pay64,64344,255-20,38862,4820#DIV/0!0.00%
6084-02-31-303-001 Sick Time15,87427,94012,06615,8740#DIV/0!0.00%
6091-02-31-303-001 Other Payroll Costs87,475135,11247,63799,9680#DIV/0!0.00%
6280-02-31-303-001 Safety Material2,0003,0521,0522,0000#DIV/0!0.00%
6197-02-31-303-001 Janitorial Services00000#DIV/0!#DIV/0!
5421-02-31-303-372 Provincial Grant (Safe Cycling)022622600#DIV/0!#DIV/0!
6046-02-31-303-372 Program Supplies (Safe Cycling)0333300#DIV/0!#DIV/0!
5612-02-31-303-413 Trsf from Reserve; COVID-190-1,581-1,58100#DIV/0!#DIV/0!
6792-02-31-303-413 COVID-19 Expenditures01,3221,32200#DIV/0!#DIV/0!
6851-02-31-303-001 Patrols & Records9,0008,005-99514,0000#DIV/0!0.00%
6180-02-31-303-001 Professional Fees4,00011,3087,3084,0000#DIV/0!0.00%
6039-02-31-303-001 Staff Training & Equipment14,00010,007-3,99314,0000#DIV/0!0.00%
6164-02-31-303-001 Liability Insurance Claim8,0004,110-3,8908,0000#DIV/0!0.00%
6040-02-31-303-001 Clothing Supplies10,70010,598-10211,0000#DIV/0!0.00%
6102-02-31-303-001 Telephone6,0007,5301,5306,5000#DIV/0!0.00%
TOTAL ADMINISTRATION596,698534,916-61,782549,834000#DIV/0!
DEBT SERVICING
6012-02-31-311-213 Building Loan - Principal1,4601,46001,5230#DIV/0!0.00%
6014-02-31-311-213 Building Loan - Interest99399309300#DIV/0!0.00%
6012-02-31-302-223 CSO Tank - Principle **38,25738,257039,7630#DIV/0!0.00%
6014-02-31-302-223 CSO Tank - Interest **47,00647,006045,4990#DIV/0!0.00%
6012-02-31-311-428 2020 Capital Roadworks/Beckwith8,7650-8,7650#DIV/0!#DIV/0!
6014-02-31-311-428 2020 Capital Roadworks/Beckwith6,7040-6,7040#DIV/0!#DIV/0!
6012-02-31-311-214 2006/7 Road Projects - Princ5,1795,178-15,3980#DIV/0!0.00%
6014-02-31-311-214 2006/7 Road Projects - Int3,5183,51913,2990#DIV/0!0.00%
** CSO Tank Loan; Previously on WPCP budget on page 51; storm-related; not wastewater
TOTAL DEBT SERVICING111,88296,413-15,46996,412000#DIV/0!

Subject to change at year-end; deferral to 2022; estimated 6012 $25,231/6014 18,517 = $43,748


TOWN OF SMITHS FALLS 2022 BUDGETPage 52%
PUBLIC WORKS & UTILITIES
GENERAL BUDGET
January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
INFRASTRUCTURE MAINTENANCE
PER SCHEDULE B - DEPARTMENTAL SUBLEDGER (Page 89 - 96)
Bridges & Culverts44,30047,9103,61049,40000000.00%
Grass & Weed Mowing29,27518,452-10,82327,80000000.00%
Grading & Shoulder Maintenance10,0251,330-8,69513,300000-10.00%
Main Sewers270,050308,36738,317293,21500000.00%
House Sewers29,150738-28,41228,400000-10.00%
Storm Sewers/Catch Basins58,97071,74712,77769,20000000.00%
Railway Crossing Maintenance12,00011,739-26112,50000000.00%
Dust Control4,1250-4,1257,300000-10.00%
Winter Control; Plowing/Sanding/Salting Roads231,142164,501-66,641231,08000000.00%
Winter Control; Snow Removal100,25050,477-49,773112,60000000.00%
Winter Control; Sidewalks31,02026,513-4,50743,52000000.00%
Winter Control; Parking & Facilities17,6254,368-13,25717,000000-10.00%
Traffic Signals78,41089,65811,24878,36000000.00%
Traffic Markings32,12828,689-3,43936,36000000.00%
Street Repair228,450228,954504266,01300000.00%
Street Lighting159,031144,597-14,434171,38100000.00%
Street Signs35,47031,426-4,04440,20000000.00%
Street Cleaning38,50532,670-5,83538,80000000.00%
Curbs & Sidewalk Repairs88,876118,04729,171118,92000000.00%
Tree Servicing55,25036,263-18,98754,00000000.00%
Buildings & Grounds96,04094,688-1,35293,50000000.00%
Litter and Garbage Pick-up29,45023,752-5,69828,45000000.00%
5860-02-31-303-051 Allocated To Water Dept *-43,513-53,418-9,905-24,84000000.00%
TOTAL ROADS MAINTENANCE1,636,0291,481,468-154,5611,806,459000#DIV/0!
  • House/Main Sewers reallocated to WPCP; less credit for storm expense allocation from taxation; phase-in @$296,775; increase of $41,088 from 2021

January 24, 2022TOWN OF SMITHS FALLS 2022 BUDGET PUBLIC WORKS & UTILITIES GENERAL BUDGETPage 53
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
EQUIPMENT MAINTENANCE PER SCHEDULE C - SUBLEDGER (Page 97 - 105)
6035-02-31-303-052 Regular Salaries & Wages30,00024,438-5,56230,000000#DIV/0!0.00%
6091-02-31-303-070 Other Payroll Costs12,3007,449-4,85110,800000#DIV/0!0.00%
6108-02-31-303-070 Gas & Oil70,90066,770-4,13068,500000#DIV/0!0.00%
6762-02-31-303-070 COVID-19 Expenditures2,5000-2,5002,000000#DIV/0!0.00%
6110-02-31-303-070 Repairs89,950127,90437,95489,500000#DIV/0!0.00%
6128-02-31-303-070 Licenses4,8904,635-2555,040000#DIV/0!0.00%
6112-02-31-303-070 Equipment Repairs20,00023,2833,28323,000000#DIV/0!0.00%
6115-02-31-303-070 Equipment Rental5003,5023,0021,000000#DIV/0!0.00%
6119-02-31-303-070 Radio Repairs2,5001,177-1,3232,500000#DIV/0!0.00%
6135-02-31-303-070 Diesel0-4,891-4,891-3,000000#DIV/0!0.00%
6173-02-31-303-070 Insurance24,14110,380-13,76112,456000#DIV/0!0.00%
5860-02-31-303-070 Allocated to Water Dept *-56,690-58,222-1,533-53,19500000.00%
TOTAL ROADS EQUIPMENT MAINTENANCE 22% Reallocated to WPCP for maintenance200,991206,4255,433188,601000#DIV/0!
TOTAL ROAD MAINTENANCE GENERAL BUDGET2,545,6002,319,222-226,3792,641,306000#DIV/0!
TOTAL ROAD MAINTENANCE BUDGET2,545,6002,319,222-226,3792,641,306000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

TOWN OF SMITHS FALLS 2022 BUDGET

PUBLIC WORKS & UTILITIES DEPARTMENTAL CAPITAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
INFRASTRUCTURE MAINTENANCE WATER DISTRIBUTION NETWORK
01-31-304-000-6072 Water Meter Replacements46,00043,499-2,50147,3800#DIV/0!0.00%
01-31-304-424-6808 Correlation Equipment40,00036,003-3,9970#DIV/0!#DIV/0!
01-31-304-138-6030 Emergency Repairs (Water Main; Victoria Basin)0000#DIV/0!0.00%
01-31-304-309-5612 Trsf from WTP Capital Reserve (Acct 2083)-86,000-79,5026,498-47,3800#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

ACCOUNT/DESCRIPTION2021 Budget INFRASTRUCTURE MAINTENANCE2022 Budget To Date2022 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2021 Budget ActualVar.2022 Budget2022 Budget To Date2022 ActualVar.% Var.% Completed
WATER DISTRIBUTION NETWORK - STAFFING COSTS
6035-02-31-304-001 Regular Salaries & Wages *203,315136,875-66,440149,2100#DIV/0!0.00%
6057-02-31-304-001 Overtime8,0005,582-2,4188,0000#DIV/0!0.00%
6067-02-31-304-001 Shift Premium6,0009,5823,5826,0000#DIV/0!0.00%
6069-02-31-304-001 Stat Time15,0009,315-5,68515,0000#DIV/0!0.00%
6078-02-31-304-001 Vacation Pay19,00022,6673,66719,0000#DIV/0!0.00%
6084-02-31-304-001 Sick Pay20,00018,721-1,27920,0000#DIV/0!0.00%
6091-02-31-304-001 Other Payroll Costs81,97297,36215,39066,1260#DIV/0!0.00%
5831-02-31-304-020 Misc Revenue-4,500-6,588-2,088-4,5000#DIV/0!0.00%
6011-02-31-304-001 Office Supplies4,5501,231-3,3194,5500#DIV/0!0.00%
6025-02-31-304-309 Transfer to Capital Reserve055,39955,39900#DIV/0!#DIV/0!
6039-02-31-304-001 Employee Training6,5005,772-7286,5000#DIV/0!0.00%
6280-02-31-304-001 Safety Material2,000703-1,2972,0000#DIV/0!0.00%
6040-02-31-304-001 Clothing Allowance5,4004,074-1,3265,5000#DIV/0!0.00%
6051-02-31-304-001 Safety Equipment2,0000-2,0002,0000#DIV/0!0.00%
(Incl. 25% of AM Coordinator; balance reallocated TOTAL STAFFING COST)369,237360,695-8,542299,386000#DIV/0!
EQUIPMENT MAINTENANCE
6112-02-31-304-012 Small Equipment3,6003,9703703,6000#DIV/0!0.00%
6118-02-31-304-012 Small Tools2,5001,419-1,0812,5000#DIV/0!0.00%
6135-02-31-304-012 Diesel4,5000-4,5004,5000#DIV/0!0.00%
TOTAL EQUIPMENT MAINTENANCE10,6005,389-5,21110,60000#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,0155152,5000#DIV/0!0.00%
6110-02-31-304-385 Vehicle Repairs1,200213-9871,2000#DIV/0!0.00%
6128-02-31-304-385 Vehicle Licence140120-201600#DIV/0!0.00%
TOTAL 2018 CHEV SILVERADO (F/A 7-0071)3,8403,348-4923,86000#DIV/0!

TOWN OF SMITHS FALLS
2022 BUDGETPage 56
WORKS &UTILITIESDEPARTMENTALGENERALBUDGET
20212021202220222022%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
INFRASTRUCTURE MAINTENANCE
WATER DISTRIBUTION NETWORK - VEHICLE & HEAVY EQUIPMENT SUMMARY
2009 CHEV SILVERADO 1/2-TON 4 X 4, UNIT 105 (F/A #7-0039)
6108-02-31-304-333 Vehicle Gas & Oil2,7004,6891,9893,0000#DIV/0!0.00%
6110-02-31-304-333 Vehicle Repairs2,6001,953-6472,6000#DIV/0!0.00%
6128-02-31-304-333 Vehicle Licence275265-102950#DIV/0!0.00%
TOTAL 2009 CHEV SILVERADO (F/A 7-0039)5,5756,9071,3325,895000#DIV/0!
2013 CHEV SILVERADO 1/2-TON 4 X 4, UNIT 106 (F/A #7-0050)
6108-02-31-304-334 Vehicle Gas & Oil4,5004,439-614,5000#DIV/0!0.00%
6110-02-31-304-334 Vehicle Repairs3,0002,276-7243,0000#DIV/0!0.00%
6128-02-31-304-334 Vehicle Licence275265-102950#DIV/0!0.00%
TOTAL 2013 CHEV SILVERADO (F/A 7-0050)7,7756,980-7957,795000#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)0000000#DIV/0!
* Transferred to Community Services June 22, 2018
2010 CHEV CUBE/UTILITY VAN; UNIT 102 (F/A 7-0041)
6108-02-31-304-337 Vehicle Gas & Oil1,0001,1001001,0000#DIV/0!0.00%
6110-02-31-304-337 Vehicle Repairs2,500384-2,1162,5000#DIV/0!0.00%
6128-02-31-304-337 Vehicle Licence375361-143950#DIV/0!0.00%
TOTAL 2010 CHEV CUBE/UTILITY VAN (F/A 7-0041)3,8751,845-2,0303,895000#DIV/0!

TOWN OF SMITHS FALLS
2022 BUDGETPage 57
WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET
20212021202220222022%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.
INFRASTRUCTURE MAINTENANCE

WATER DISTRIBUTION NETWORK - VEHICLE & HEAVY EQUIPMENT SUMMARY

2019 Case 590N Backhoe

2019 Case 590N Backhoe
6108-02-31-304-339 Vehicle Gas & Oil4,5005,5261,0264,5000#DIV/0!0.00%
6110-02-31-304-339 Vehicle Repairs4,5001,683-2,8174,5000#DIV/0!0.00%
6128-02-31-304-339 Vehicle Licence00000#DIV/0!#DIV/0!
TOTAL 2019 CASE BACKHOE9,0007,209-1,7919,000000#DIV/0!

WATER DISTRIBUTION NETWORK - WATER MAINS

6035-02-31-304-138 Regular Salary Wages30,00037,5717,57125,0000#DIV/0!0.00%
6057-02-31-304-138 Overtime4,500634-3,8664,5000#DIV/0!0.00%
6091-02-31-304-138 Other Benefits11,5417,566-3,97510,6200#DIV/0!0.00%
6303-02-31-304-138 Water Mains00000#DIV/0!#DIV/0!
6268-02-31-304-138 Water Mains; Materials18,00027,7509,75020,0000#DIV/0!0.00%
6114-02-31-304-001 Town Equipment00000#DIV/0!#DIV/0!
5902-02-31-304-001 Town Equipment Adjustment00000#DIV/0!#DIV/0!
6205-02-31-304-138 Water Mains; Contracted Services15,00043,54328,54320,0000#DIV/0!0.00%
6303-02-31-304-286 Water Mains Condition Rating5,000153-4,8475,0000#DIV/0!0.00%
6311-02-31-304-138 Water Mains Sampling Stations00000#DIV/0!#DIV/0!
TOTAL WATER MAINS84,041117,21733,17685,120000#DIV/0!
WATER DISTRIBUTION NETWORK - WATER SERVICES
6035-02-31-304-328 Regular Salary Wages26,00024,671-1,32920,0000#DIV/0!0.00%
6057-02-31-304-328 Overtime2,100270-1,8302,1000#DIV/0!0.00%
6091-02-31-304-328 Other Benefits9,8355,152-4,6837,9560#DIV/0!0.00%
6268-02-31-304-328 Water Services; Materials20,00021,6471,64722,0000#DIV/0!0.00%
6205-02-31-304-328 Water Services; Contracted Services32,00030,093-1,90735,0000#DIV/0!0.00%
6114-02-31-304-328 Town Equipment00000#DIV/0!#DIV/0!
5902-02-31-304-328 Town Equipment Adjustment00000#DIV/0!#DIV/0!
6304-02-31-304-138 Water Services00000#DIV/0!#DIV/0!
6307-02-31-304-138 Road Allowance Restoration00000#DIV/0!#DIV/0!
TOTAL WATER SERVICES89,93581,833-8,10287,056000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET

2021 ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.Completed

INFRASTRUCTURE MAINTENANCE

WATER DISTRIBUTION NETWORK - FIRE HYDRANTS/FLUSHING PROGRAM

6035-02-31-304-329 Regular Salary Wages25,00032,9397,93920,0000#DIV/0!0.00%
6057-02-31-304-329 Overtime80091-7098000#DIV/0!0.00%
6091-02-31-304-329 Other Benefits9,0306,404-2,6267,4880#DIV/0!0.00%
6268-02-31-304-329 Fire Hydrants; Materials12,0004,320-7,68012,0000#DIV/0!0.00%
6114-02-31-304-329 Town Equipment00000#DIV/0!#DIV/0!
5902-02-31-304-329 Town Equipment Adjustment00000#DIV/0!#DIV/0!
6205-02-31-304-329 Fire Hydrants; Contracted Services2,5000-2,5002,5000#DIV/0!0.00%
6306-02-31-304-138 Fire Hydrants00000#DIV/0!#DIV/0!
TOTAL FIRE HYDRANTS/FLUSHING PROGRAMS49,33043,754-5,57642,788000#DIV/0!

WATER DISTRIBUTION NETWORK - VALVE MAINTENANCE/VALVE TURNING

WATER DISTRIBUTION NETWORK - VALVE MAINTENANCE/VALVE TURNING
6035-02-31-304-320 Regular Salary Wages18,00015,614-2,38618,0000#DIV/0!0.00%
6057-02-31-304-320 Overtime1,0000-1,0001,0000#DIV/0!0.00%
6091-02-31-304-320 Other Benefits6,6503,375-3,2756,8400#DIV/0!0.00%
6268-02-31-304-320 Valves; Materials10,000917-9,08310,0000#DIV/0!0.00%
6114-02-31-304-320 Town Equipment00000#DIV/0!#DIV/0!
5902-02-31-304-320 Town Equipment Adjustment00000#DIV/0!#DIV/0!
6205-02-31-304-320 Valves; Contracted Services4,0000-4,0004,0000#DIV/0!0.00%
6305-02-31-304-138 Valves00000#DIV/0!#DIV/0!
TOTAL VALVE MAINTENANCE/VALVE TURNING39,65019,906-19,74439,840000#DIV/0!

WATER DISTRIBUTION NETWORK - WATER METERS/METER READING

6035-02-31-304-331 Regular Salary Wages22,70033,54710,84730,0000#DIV/0!0.00%
6057-02-31-304-331 Overtime00000#DIV/0!#DIV/0!
6091-02-31-304-331 Other Benefits7,4116,527-88410,8000#DIV/0!0.00%
6268-02-31-304-331 Water Meters; Materials35,00041,5016,50140,0000#DIV/0!0.00%
6205-02-31-304-331 Water Meters; Contracted Services4,5003,490-1,0102,5000#DIV/0!0.00%
6114-02-31-304-331 Town Equipment00000#DIV/0!#DIV/0!
5902-02-31-304-331 Town Equipment Adjustment00000#DIV/0!#DIV/0!
6309-02-31-304-138 Water Meters00000#DIV/0!#DIV/0!
TOTAL WATER METERS/METER READING69,61185,06515,45483,300000#DIV/0!

ACCOUNT/DESCRIPTIONTOWN OF SMITHS FALLS 2022 BUDGET WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2021 BudgetTOWN OF SMITHS FALLS 2022 BUDGET WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2021 ActualTOWN OF SMITHS FALLS 2022 BUDGET WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2022 Var.TOWN OF SMITHS FALLS Page 59 WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2022 BudgetTOWN OF SMITHS FALLS Page 59 WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2022 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 Wages24,00028,2824,28227,0620#DIV/0!0.00%
6057-02-31-304-332 Overtime250137-1132500#DIV/0!0.00%
6091-02-31-304-332 Other Benefits8,4885,875-2,6139,8320#DIV/0!0.00%
6114-02-31-304-332 Town Equipment00000#DIV/0!#DIV/0!
5902-02-31-304-332 Town Equipment Adjustment00000#DIV/0!#DIV/0!
6205-02-31-304-332 Ontario One Calls; Contractor1,4001,486861,4000#DIV/0!0.00%
TOTAL ONTARIO ONE CALLS34,13835,7801,64238,544000#DIV/0!
WATER DISTRIBUTION NETWORK - AIR CARE DR BUILDING
6184-02-31-304-051 Supplies6500-6506500#DIV/0!0.00%
6112-02-31-304-051 Equipment1,700129-1,5711,7000#DIV/0!0.00%
6102-02-31-304-158 Telephone8,00010,9002,9008,0000#DIV/0!0.00%
TOTAL AIR CARE DR BUILDING10,35011,02967910,350000#DIV/0!
* Utilities for Air Care Dr. Bldg; under Tax-Supported Budget
TOTAL WATER DISTRIBUTION GENERAL786,957786,9570727,429000#DIV/0!
TOTAL WATER DISTRIBUTION BUDGET786,957786,9570727,429000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

CORPORATE SERVICES CAPITAL BUDGET

ADMINISTRATION

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
6639-01-41-101-000 Land Needs Study20,0000-20,0000#DIV/0!
6833-01-41-101-000 Secondary Plan70,0000-70,00090,0000#DIV/0!
6283-01-41-101-000 Zoning Bylaw Update50,00027,328-22,67223,0670#DIV/0!
6838-01-41-101-000 Development Charge Study23,45213,794-9,6580#DIV/0!
5612-01-41-101-000 Tsf from Reserve (Account 2051)-38,452-13,79424,658-169,7360#DIV/0!
5612-01-41-101-309 Trsf from Capital Reserve (Account 2083)-125,000-125,0000-140,0000#DIV/0!
01-41-101-000-6845 Affordable Housing & CIP Update0-17,329-17,32950,0000#DIV/0!
01-41-101-430-6177 E-Permitting Solution/Records Digitization00076,1800#DIV/0!
01-41-101-430-5421 Municipal Moderization Grant097,67297,672-49,5110#DIV/0!
01-41-101-430-6836 Trsf to/from Deferred Revenue017,32917,3290#DIV/0!
01-41-101-352-6836 Trsf to/from Deferred Revenue (MIIO Project)0000#DIV/0!
01-41-101-000-5424 Federal Grant-Local Immigration0000#DIV/0!
01-41-101-000-6639 Heritage Conservation District Study000120,0000#DIV/0!
TOTAL ADMINISTRATION CAPITAL00000000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

CORPORATE SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ADMINISTRATION
5499-02-41-101-020 GST- Rebate-3,300-2,551749-3,3000 #DIV/0!0.00%
5511-02-41-101-020 Tax Certificates-5,000-17,600-12,600-15,0000 #DIV/0!0.00%
5514-02-41-101-020 Business Licenses-500-700-200-5000 #DIV/0!0.00%
5516-02-41-101-020 Interest on Investments-70,000-108,340-38,340-70,0000 #DIV/0!0.00%
6025-02-41-101-000 Trsf interest to reserve accounts067,12467,12400 #DIV/0!#DIV/0!
6836-02-41-101-000 Trst interest; deferred revenue072372300 #DIV/0!#DIV/0!
5518-02-41-101-020 Interest/Penalty on Taxes-178,000-163,59714,403-178,0000 #DIV/0!0.00%
5519-02-41-101-020 NSF Cheque Fees-1,800-4401,360-1,8000 #DIV/0!0.00%
5520-02-41-101-020 Postage Charges - Other-15,000-19,236-4,236-15,0000 #DIV/0!0.00%
5521-02-41-101-020 Photocopy Charges - Other-1,00001,000-1,0000 #DIV/0!0.00%
5556-02-41-101-020 Misc. Revenue0-5,581-5,58100 #DIV/0!#DIV/0!
6025-02-41-101-000 Trsf to Capital Reserve (Surplus TCA)04,0004,00000 #DIV/0!#DIV/0!
5562-02-41-101-020 Death Registrations-3,000-6,500-3,500-3,5000 #DIV/0!0.00%
5563-02-41-101-020 Marriage Licenses-4,000-5,270-1,270-5,0000 #DIV/0!0.00%
5658-02-41-101-020 Comm. of Oath Fees-500-615-115-1,5000 #DIV/0!0.00%
5875-02-41-101-020 Freedom of Info Fees-50-3020-500 #DIV/0!0.00%
6618-02-41-101-020 Tax Letters-500-4955-5000 #DIV/0!0.00%
TOTAL ADMINISTRATION REVENUE-282,650-259,10823,542-295,1500000 #DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET CORPORATE SERVICES GENERAL BUDGET

2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION686,417775,60089,183744,3760#DIV/0!0.00%
6035-02-41-101-000 Regular Salaries & Wages00000#DIV/0!#DIV/0!
6048-02-41-101-000 Part Time Wages205,400221,66816,268208,0570#DIV/0!0.00%
6091-02-41-101-000 Other Payroll Costs00000#DIV/0!#DIV/0!
6025-02-41-101-000 Trsf to Payroll Reserve (Surplus Group Benefits)00000#DIV/0!#DIV/0!
6792-02-41-101-413 COVID-19 Expenditures02,3602,36000#DIV/0!#DIV/0!
5421-02-41-101-413 COVID-19 Funding0-255,446-255,44600#DIV/0!#DIV/0!
6011-02-41-101-000 Office Supplies *18,00024,4216,42120,0000#DIV/0!0.00%
6015-02-41-101-000 Travel Expenses5,000227-4,7735,0000#DIV/0!0.00%
6017-02-41-101-000 Coffee/Food Supplies2,000595-1,4052,0000#DIV/0!0.00%
6019-02-41-101-000 Photocopy Supplies2,0000-2,0002,0000#DIV/0!0.00%
6023-02-41-101-000 Postage35,00039,3264,32637,0000#DIV/0!0.00%
6026-02-41-101-000 Printing4,0001,069-2,9314,0000#DIV/0!0.00%
6029-02-41-101-000 Membership Fees5,0004,747-2535,5000#DIV/0!0.00%
6032-02-41-101-000 Conferences5,000178-4,8225,0000#DIV/0!0.00%
6038-02-41-101-000 Advertising6,50012,0725,5727,0000#DIV/0!0.00%
6039-02-41-101-000 Staff Training & Develop.18,0009,716-8,28425,0000#DIV/0!0.00%
6042-02-41-101-000 Courier500176-3245000#DIV/0!0.00%
6051-02-41-101-000 Health & Safety4,0008,5394,5394,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,039-1,4615,5000#DIV/0!0.00%
6103-02-41-101-000 Fax00000#DIV/0!#DIV/0!
6173-02-41-101-000 Insurance129,596110,344-19,252132,4130#DIV/0!0.00%
6025-02-41-101-000 Transfer to Reserve (Account 2051)00000#DIV/0!#DIV/0!
6836-02-41-101-413 Transfer to Deferred Revenue0253,086253,08600#DIV/0!#DIV/0!
6174-02-41-101-000 Audit Fees32,00025,364-6,63632,0000#DIV/0!0.00%
6178-02-41-101-000 Bank Service Fees3,0006,4553,4553,0000#DIV/0!0.00%
6258-02-41-101-000 Cash Short & Over0-1,558-1,55800#DIV/0!#DIV/0!
6180-02-41-101-000 Professional Fees60,000103,42543,42570,0000#DIV/0!0.00%
5612-02-41-101-000 Transfer from Reserve (Account 2051 PCO)-15,000015,000-25,0000#DIV/0!0.00%
6175-02-41-101-000 Support - Main Hdwe35,00030,237-4,76340,0000#DIV/0!0.00%
6027-02-41-101-000 Photocopier Lease12,0006,567-5,43312,0000#DIV/0!0.00%
6564-02-41-101-000 Mail Sorter3,0003,3903903,5000#DIV/0!0.00%
TOTAL ADMINISTRATION EXPENSES1,261,9131,386,597124,6841,342,846000#DIV/0!

January 24, 2022TOWN OF SMITHS FALLS 2022 BUDGET CORPORATE SERVICES GENERAL BUDGETPage 63
PROPERTY ASSESSMENT
6259-02-41-101-000 Levy per Assess. Agency *101,037100,799-238101,0370#DIV/0!0.00%
TOTAL PROPERTY ASSESSMENT101,037100,799-238101,037000#DIV/0!
TOTAL ADMINISTRATION GENERAL1,080,3001,228,288147,9881,148,733000#DIV/0!
  • Status quo from 2021; confirmed via email on October 18, 2021

TOWN OF SMITHS FALLS 2022 BUDGET

CORPORATE SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
TAXATION REVENUE
5111-02-41-410-077 Residential-9,342,860-9,345,187-2,327-9,626,6600#DIV/0!0.00%
5121-02-41-410-077 Commercial-3,389,581-3,390,425-844-3,472,3140#DIV/0!0.00%
5141-02-41-410-077 Farmland-489-4890-4900#DIV/0!0.00%
5151-02-41-410-077 Pipeline-57,231-57,246-15-57,4970#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 **-684,800-681,2803,520-2,496,5550#DIV/0!0.00%
5181-02-41-410-077 Multi-Residential *-1,348,700-1,349,036-336-1,425,7660#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-123,850-23,850-100,0000#DIV/0!0.00%
5221-02-41-410-077 Commercial Supplemental-60,000-366,413-306,413-100,0000#DIV/0!0.00%
5271-02-41-410-077 Industrial Supplemental-50,000-2,069,937-2,019,937-100,0000#DIV/0!0.00%
5281-02-41-410-077 Multi-Res Supplemental-75,000-28,89646,104-75,0000#DIV/0!0.00%
5850-02-41-410-077 Capping Adjustment00000#DIV/0!#DIV/0!
5878-02-41-410-077 Tax Sale Revenue-7650765-7650#DIV/0!0.00%
6487-02-41-410-077 Rideau Lakes Adjustment Yr 20 of 2036,64236,6773518,2610#DIV/0!0.00%
6376-02-41-410-077 Vacancy Rebate30,0002,392-27,60800#DIV/0!#DIV/0!
6241-02-41-410-077 Rebate Registered Charities10,000268-9,7325,0000#DIV/0!0.00%
6427-02-41-410-077 Royal Cdn Leg. Tax Ex Yr 4 of 10 (2021)00000#DIV/0!#DIV/0!
6596-02-41-410-077 RCAF Tax Ex Yr 4 of 106,1256,9067816,9060#DIV/0!0.00%
6242-02-41-410-077 Tax W/O Residential10,0005,443-4,5575,0000#DIV/0!0.00%
6243-02-41-410-077 Tax W/O Commercial100,00065,817-34,183100,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 Res *10,0000-10,00065,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)000-80,0000#DIV/0!0.00%
6025-02-41-410-077 Transfer to Reserve01,410,6671,410,6671,163,9730#DIV/0!0.00%
6248-02-41-410-077 Tax W/O Industrial **10,0000-10,00010,0000#DIV/0!0.00%
** Reserve account 02-41-101-111-2271
TOTAL UNALLOCATED REVENUE-14,911,526-15,899,456-987,930-16,175,774000#DIV/0!
  • Increase for Hotel Rideau; offset with multi-residential W/O; pending tax abatement rebate; est. $55 K; pending Council approval

** Adj due to OPTA "actual" rates for industrial decreased due to banding


TOWN OF SMITHS FALLS 2022 BUDGET CORPORATE SERVICES GENERAL BUDGET

CORPORATE SERVICES GENERAL BUDGET
January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
PAYMENTS IN LIEU OF TAXES
5313-02-41-410-077 Ontario Hospitals-8,700-7,800900-7,8000#DIV/0!0.00%
5314-02-41-410-077 Ontario Hydro-22,000-22,929-929-23,0000#DIV/0!0.00%
5316-02-41-410-077 Water Department-300,000-267,97532,025-267,9750#DIV/0!0.00%
5318-02-41-410-077 MTO0-56-56-550#DIV/0!0.00%
02-41-410-077-5321 Province - OPP *-169,000-170,774-1,774-171,0000#DIV/0!0.00%
02-41-410-077-6735 Montague - OPP84,44085,38794784,4400#DIV/0!0.00%
02-41-410-077-6839 Montague - Galipeau Centre *64,56060,245-4,31564,5600#DIV/0!0.00%
5319-02-41-410-077 Public Works Canada-174,000-160,32213,678-174,0000#DIV/0!0.00%
TOTAL PAYMENTS IN LIEU-524,700-484,22440,476-494,830000#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,586,2000#DIV/0!0.00%
5869-02-41-410-077 Federal Gas Tax-556,918-1,092,299-535,381-556,9180#DIV/0!0.00%
6025-02-41-410-077 Allocation of Gas Tax556,9181,092,299535,381556,9180#DIV/0!0.00%
02-41-410-077-6025/5612 Tsf to/frm Reserve05,9865,9861,161,9000#DIV/0!0.00%
5900-02-41-410-077 OCIF Formula-based Funding *-613,765-604,5889,177-1,161,9000#DIV/0!0.00%
6025-02-41-410-077 Allocation of OCIF Formula-Based Funding613,765604,588-9,17700#DIV/0!#DIV/0!
5442-02-41-410-077 Provincial Offences Revenue-52,400-20,00032,400-52,4000#DIV/0!0.00%
TOTAL ONTARIO GRANTS-3,638,600-3,600,21438,386-3,638,600000#DIV/0!
TOTAL REVENUE-19,074,826-19,983,894-909,068-20,309,204000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET CORPORATE SERVICES CAPITAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
COMPUTER/INFORMATION TECHNOLOGY CAPITAL
5612-01-31-335-000 Transfer from Reserve (Acct 2051)-74,446-16,64757,799-55,0840#DIV/0!#REF!
6175-01-31-335-288 Outlook Exchange Server5,084926-4,15825,0000#DIV/0!0.00%
6840-01-31-335-000 Website/Rebranding*21,9060-21,9060#DIV/0!#DIV/0!
6808--01-31-335-434 Cloud-based Server Back-up020,00020,000100,0000#DIV/0!0.00%
5612-01-31-335-309 Trsf from Capital Reserve (Acct 2083)-20,000-20,0000-119,9160#DIV/0!0.00%
6808-01-31-335-360 Data/Records Retention50,0000-50,00050,0000#DIV/0!0.00%
6429-01-31-335-000 Cyber Security/IT Review17,45615,721-1,7350#DIV/0!#DIV/0!
* Rebranding/Signage only in 2018
TOTAL INFORMATION TECHNOLOGY0000000#DIV/0!

COMPUTER/INFORMATION TECHNOLOGY GENERAL

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
COMPUTER/INFORMATION TECHNOLOGY
6035-02-31-335-000 Salaries42,93454,51911,58545,9770#DIV/0!0.00%
6091-02-31-335-000 Benefits14,22014,009-21115,0920#DIV/0!0.00%
6011-02-31-335-000 Ink Cartridges/Office Supplies1,0001,2212212,0000#DIV/0!0.00%
6792-02-31-335-413 COVID-19 Expenditures08,6308,63000#DIV/0!#DIV/0!
6836-02-31-335-413 COVID-19 Funding; Trsf from Def Rev0-18,202-18,20200#DIV/0!#DIV/0!
6057-02-31-335-413 COVID-19 Overtime09,57200#DIV/0!#DIV/0!
6039-02-31-335-000 Employee Training/Memberships2,0001,408-5922,0000#DIV/0!0.00%
6015-02-31-335-000 Travel1,00064-9361,0000#DIV/0!0.00%
6020-02-31-335-000 Software11,5876,254-5,33312,0000#DIV/0!0.00%
6102-02-31-335-000 Telephone1,5001,208-2921,5000#DIV/0!0.00%
6118-02-31-335-000 Tools & Equipment13,0002,279-10,72115,0000#DIV/0!0.00%
6150-02-31-335-000 Connectivity30,00050,95120,95140,0000#DIV/0!0.00%
6840-02-31-335-000 Website Maintenance14,00015,1381,13814,0000#DIV/0!0.00%
6474-02-31-335-000 Computer Lease *44,00059,86215,86270,0000#DIV/0!0.00%
6025-31-335-000 Transfer from Reserve (PCO)-15,0000#DIV/0!0.00%
6176-02-31-335-000 Computer Maintenance16,00012,795-3,20530,0000#DIV/0!0.00%
6177-02-31-335-000 Support - Main Software4,0004,7107107,0000#DIV/0!0.00%
TOTAL INFORMATION TECHNOLOGY195,241224,41819,605240,569000#DIV/0!
  • Increased for computer deployment

TOWN OF SMITHS FALLS 2022 BUDGET CORPORATE SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
PLANNING/ADMINISTRATION
5567-02-41-415-020 Site Plan Control Fees-8,000-24,000-16,000-15,0000#DIV/0!0.00%
5568-02-41-415-020 PAC-4,000-5,500-1,500-3,0000#DIV/0!0.00%
5569-02-41-415-020 Application Fees-9,000-24,150-15,150-10,0000#DIV/0!0.00%
02-41-415-020-5894 PIL Parkland00000#DIV/0!#DIV/0!
02-41-415-020-6025 Tsf to/from Reserve (Parking/Parkland Fund)00000#DIV/0!#DIV/0!
02-41-415-000-6029 Memberships1,5001,322-1781,5000#DIV/0!0.00%
6011-02-41-415-001 Office Supplies2,000648-1,3522,0000#DIV/0!0.00%
6027-02-41-415-001 Photocopier Lease ("New")5,0001,844-3,1565,0000#DIV/0!0.00%
6035-02-41-415-001 Regular Salaries & Wages &&176,820177,783963179,8790#DIV/0!0.00%
6048-02-41-415-001 Part-time Wages8,1400-8,1408,4000#DIV/0!0.00%
6078-02-41-415-001 Vacation Pay3260-3263360#DIV/0!0.00%
6091-02-41-415-001 Other Payroll Costs53,79056,7402,95057,5050#DIV/0!0.00%
6088-02-41-415-001 COA Honorarium1,5001,250-2502,0000#DIV/0!0.00%
6057-02-41-415-375 Overtime (Shared Service; Montague)12,00025,72213,72212,0000#DIV/0!0.00%
6091-02-41-415-375 Benefits (Shared Service; Montague)00000#DIV/0!#DIV/0!
5711-02-41-415-375 Township Fees for Shared Services-12,000-27,779-15,779-12,0000#DIV/0!0.00%
6015-02-41-415-001 Travel500-41-5415000#DIV/0!0.00%
6019-02-41-415-001 Photocopy Supplies2,0000-2,0002,0000#DIV/0!0.00%
6023-02-41-415-001 Postage7001,0933939000#DIV/0!0.00%
6032-02-41-415-001 Conferences2,0000-2,0002,0000#DIV/0!0.00%
6038-02-41-415-001 Advertising & Promotion2,000254-1,7464,0000#DIV/0!0.00%
6039-02-41-415-001 Staff & Committee Training5,000371-4,6294,0000#DIV/0!0.00%
6845-02-41-415-001 Community Improvement Plan *45,00049,1674,16700#DIV/0!#DIV/0!
5612/6025-02-41-415-001 Trsf from Reserve (Acct 2051)-15,000-19,167-4,16700#DIV/0!#DIV/0!
6042-02-41-415-001 Courier1000-1001000#DIV/0!0.00%
6102-02-41-415-001 Telephone3,0001,769-1,2313,0000#DIV/0!0.00%
6175-02-41-415-001 Computer Main Hardware/Website Maintenance10,0009,139-86111,0000#DIV/0!0.00%
6180-02-41-415-001 Professional/Advisory Fees14,5005,231-9,26980,0000#DIV/0!0.00%
TOTAL PLANNING297,876231,696-66,180336,120000#DIV/0!

*Based on Affordable Housing Taskforce's recommendation: 1st draft budget to include 2% of the tax revenue; for Council's direction; 1st draft budget


TOWN OF SMITHS FALLS 2022 BUDGET

CORPORATE SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
BUILDING SERVICES DEPARTMENT
5537-02-31-325-020 Building Fines-31-3100#DIV/0!#DIV/0!
5528-02-31-325-020 Zoning Certificates-2,000-4,530-2,530-3,0000#DIV/0!0.00%
5531-02-31-325-020 Building Permits-500,000-383,430116,570-750,0000#DIV/0!0.00%
5656-02-31-325-020 Sign Permits-1,000-1,205-205-5,0000#DIV/0!0.00%
6035-02-31-325-001 Regular Salaries & Wages **234,566191,143-43,423223,5930#DIV/0!0.00%
6091-02-31-325-001 Other Payroll Costs44,75054,77710,02767,4610#DIV/0!0.00%
6011-02-31-325-001 Office Supplies *20,0005,723-14,27720,0000#DIV/0!0.00%
6027-02-31-325-001 Photocopier Lease5,0001,725-3,2755,0000#DIV/0!0.00%
02-31-325-001-6015 Travel6,000783-5,2176,0000#DIV/0!0.00%
6019-02-31-325-001 Photocopier Lease Supplies1,000120-8801,0000#DIV/0!0.00%
6020-02-31-325-001 CBO Computer Software10,0009,084-91610,0000#DIV/0!0.00%
6840-02-31-325-001 Upgrade Website Presence "New"15,0000-15,00015,0000#DIV/0!0.00%
6023-02-31-325-001 Postage200134-662000#DIV/0!0.00%
6029-02-31-325-001 Membership Fees2,000481-1,5192,0000#DIV/0!0.00%
6038-02-31-325-001 Advertising & Promotion2,5001,125-1,3752,5000#DIV/0!0.00%
6039-02-31-325-001 Employee Training3,5001,525-1,9753,5000#DIV/0!0.00%
6040-02-31-325-001 Clothing & Supplies2,000161-1,8392,5000#DIV/0!0.00%
02-31-325-001-6102 Telephone3,0001,879-1,1213,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,00041,871-18,12960,0000#DIV/0!0.00%
5612/6025-02-31-325-001 Tsf to/frm Reserve85,98478,629-7,355328,7460#DIV/0!0.00%
TOTAL BUILDING INSPECTION0-36-360000#DIV/0!

TOTAL BUILDING INSPECTION

  • Purchase of new office equipment

** This now includes 10% of the Fire Chief


TOWN OF SMITHS FALLS 2022 BUDGET CORPORATE SERVICES BYLAW/PARKING CAPITAL BUDGETPage 69
January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.
ACCOUNT/DESCRIPTION% 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 Equipment25,0005,939-19,061
5612-01-21-225-000 Transfer from Reserve (Acct 2051)0000#DIV/0!#DIV/0!
5612-01-21-225-309 Transfer from Capital Reserve-25,000-25,00000#DIV/0!#DIV/0!
TOTAL BYLAW/TRAFFIC0-19,061-19,0610000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET CORPORATE SERVICES

ENFORCEMENT SERVICES (PARKING & BYLAW CONTROL) GENERAL BUDGET

202020212021 Actual%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateVar.Var.Completed
5535-02-21-225-020 Parking Meter Income *0-300-30000#DIV/0!#DIV/0!
5536-02-21-225-020 Parking Lot-6,000-5,370630-6,0000#DIV/0!0.00%
5537-02-21-225-020 Parking Fines-3,000-15,052-12,052-20,0000#DIV/0!0.00%
5538-02-21-225-020 County Court Fines-500-5,858-5,358-1,0000#DIV/0!0.00%
5569-02-21-225-020 Appeal Application Fees0-100-10000#DIV/0!#DIV/0!
xxxx-02-21-225-020 Electric Charging Stations; Revenue00000#DIV/0!#DIV/0!
6011-02-21-225-001 Office Supplies500324-1761,0000#DIV/0!0.00%
6012-02-21-225-001 Parking Meter Loan/Principal8,9718,97439,2590#DIV/0!0.00%
6014-02-21-225-001 Parking Meter Loan/Interest959956-36700#DIV/0!0.00%
6015-02-21-225-001 Travel0002,0000#DIV/0!0.00%
6019-02-21-225-001 Photocopier Lease Supplies0005000#DIV/0!0.00%
6023-02-21-225-001 Postage1,000682-3181,0000#DIV/0!0.00%
6026-02-21-225-001 Printing ( Tickets)2,00076-1,9242,0000#DIV/0!0.00%
6040-02-21-225-001 Clothing0002,0000#DIV/0!0.00%
6035-02-21-225-001 Regular Salaries & Wages **42,28834,997-7,291154,0820#DIV/0!0.00%
6091-02-21-225-001 Other Payroll Costs9,8708,089-1,78144,6260#DIV/0!0.00%
6039-02-21-225-001 Employee Training0005000#DIV/0!0.00%
6020-02-21-225-001 CGIS Software6,5004,901-1,5996,5000#DIV/0!0.00%
6102-02-21-225-001 Telephone1,5001,7582582,0000#DIV/0!0.00%
6105-02-21-225-001 Hydro1,000902-981,0000#DIV/0!0.00%
6112-02-21-225-001 Equipment for Enforcement0003,0000#DIV/0!0.00%
6505-02-21-225-001 Electric Charging Stations "New"6,0000-6,00000#DIV/0!#DIV/0!
6118-02-21-225-001 Tools, Accessories, etc5006681681,0000#DIV/0!0.00%
6173-02-21-225-001 Insurance648127-5211530#DIV/0!0.00%
02-21-225-001-6180 Professional Fees5,000-90-5,0905,0000#DIV/0!0.00%
6185-02-21-225-001 Enforcement Fees100,00074,487-25,51300#DIV/0!#DIV/0!
02-21-225-413-6792 COVID-19 Expenditures010110100#DIV/0!#DIV/0!
TOTAL BYLAW/TRAFFIC177,236110,272-66,964209,290000#DIV/0!

** Includes CBO, Admin @25% & Customer Service Support 10%


TOWN OF SMITHS FALLS 2021 BUDGET CORPORATE SERVICES ENFORCEMENT SERVICES (PARKING & BYLAW CONTROL GENERAL BUDGET

GENERAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ANIMAL CONTROL
5564-02-21-226-020 Dog Tags-1,500-995505-1,5000#DIV/0!0.00%
6048-02-21-226-001 Part Time Salaries00000#DIV/0!#DIV/0!
6035-02-21-226-001 Salaries00000#DIV/0!#DIV/0!
xxxx-02-21-226-001 Equipment ("New account")0004,0000#DIV/0!0.00%
02-21-226-001-6011 Office Supplies2000-2002000#DIV/0!0.00%
6180-02-21-226-001 Professional Fees47,0002,608-44,39247,0000#DIV/0!0.00%
6224-02-21-226-001 Pound Services17,00012,436-4,56417,0000#DIV/0!0.00%
6453-02-21-226-001 Emergency Vet Services2,000485-1,5153,0000#DIV/0!0.00%
6110-02-21-226-001 Dog Pick-up Bags & Dispensers2,000438-1,5622,0000#DIV/0!0.00%
TOTAL ANIMAL CONTROL66,70014,972-51,72871,700000#DIV/0!
CROSSING GUARDS
6048-02-31-305-001 Part Time Salaries *35,46518,118-17,34742,4500#DIV/0!0.00%
6078-02-31-305-001 Vacation Pay1,419915-5042,5170#DIV/0!0.00%
6091-02-31-305-001 Benefits3,3961,749-1,6474,2980#DIV/0!0.00%
6040-02-31-305-001 Clothing & Supplies2,000824-1,1762,5000#DIV/0!0.00%
TOTAL CROSSING GUARDS42,28021,606-20,67451,765000#DIV/0!
* Crossing guards were laid off as of March 31, 2020
TOTAL BYLAW ENFORCEMENT GENERAL286,216146,850-139,366332,755000#DIV/0!
TOTAL BYLAW ENFORCEMENT286,216127,789-158,427332,755000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGETPage 72
PUBLIC WORKS & UTILITIES CAPITAL BUDGET
January 24, 20222021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
ACCOUNT/DESCRIPTIONENGINEERING; CAPITAL WORKS
01-31-320-435-6808 Food Waste Diversion Project00015,0000#DIV/0!
01-31-320-309-5612 Trsf from Reserve (Capital)000-15,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 WORKS0000000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET PUBLIC WORKS & UTILITIES GENERAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
ENGINEERING ADMINISTRATION
5529-02-31-320-020 Permits & Other Fees-4,500-4,715-215-5,0000#DIV/0!0.00%
6011-02-31-320-001 Engineering Supplies2,0005,4603,4602,0000#DIV/0!0.00%
6015-02-31-320-001 Travel7500-7507500#DIV/0!0.00%
6019-02-31-320-001 Photocopy Supplies & Printing1,400252-1,1482,0000#DIV/0!0.00%
6027-02-31-320-001 Leases3,7003,268-4323,7000#DIV/0!0.00%
6177-02-31-320-001 Annual Software Licenses "New"4,5000#DIV/0!0.00%
6029-02-31-320-001 Membership Fees2,5001,077-1,4232,0000#DIV/0!0.00%
6032-02-31-320-001 Conferences9000-9001,0000#DIV/0!0.00%
6039-02-31-320-001 Staff Training2,0001,634-3662,0000#DIV/0!0.00%
6040-02-31-320-001 Clothing & Supplies3000-3003000#DIV/0!0.00%
6180-02-31-320-001 Professional Fees7,0003,434-3,5667,0000#DIV/0!0.00%
TOTAL ENGINEERING ADMINISTRATION GENERAL BUDGET16,05010,410-5,64020,250000#DIV/0!
ENGINEERING WAGES AND BENEFITS
6035-02-31-320-125 Regular Salaries & Wages *69,79570,00921489,2160#DIV/0!
6048-02-31-320-125 Part Time Wages **8,1406,090-2,05016,8000#DIV/0!
6078-02-31-320-125 Vacation Pay326236-906720#DIV/0!
6091-02-31-320-125 Other Payroll Costs21,88423,0191,13529,2840#DIV/0!
TOTAL ENGINEERING WAGES AND BENEFITS100,14599,354-791135,972000#DIV/0!
SOLID WASTE MANAGEMENT; COLLECTION & DISPOSAL
5588-02-31-322-071 Garbage Tags-14,500-23,543-9,043-16,0000#DIV/0!0.00%
xxxx-02-31-322-071 Landfill Monitoring "New"6,00006,0000#DIV/0!0.00%
6233-02-31-322-071 Collection Contract153,000155,2082,208159,0000#DIV/0!0.00%
6233-02-31-322-291 Collection Contract; Dumpsters66,50064,137-2,36368,5000#DIV/0!0.00%
6273-02-31-322-291 Disposal Contract; Dumpsters48,00048,97597549,5000#DIV/0!0.00%
6273-02-31-322-071 Disposal Contract248,000253,7665,766248,0000#DIV/0!0.00%
TOTAL WASTE COLL/DISP507,000498,543-2,457515,000000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET PUBLIC WORKS & UTILITIES

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
RECYCLING & COMPOSTING
6038-02-31-322-072 Advertising & Promotion8,5007,351-1,1499,2250 #DIV/0!0.00%
6274-02-31-322-072 Recycling Contract272,500219,696-52,804240,0000 #DIV/0!0.00%
5601-02-31-322-020 Recycling Revenue00000 #DIV/0!#DIV/0!
5602-02-31-322-072 Recycling Bin Sales-150-9060-1500 #DIV/0!0.00%
5594-02-31-322-072 Rain Barrel Revenue000-2000 #DIV/0!0.00%
6746-02-31-322-072 Blue Boxes4,8008,7543,9549,0000 #DIV/0!0.00%
6825-02-31-322-072 Environmental Initiatives **0-480-48025,0000 #DIV/0!0.00%
5864-02-31-322-020 WDO Revenue-71,000-95,985-24,985-71,0000 #DIV/0!0.00%
6366-02-31-322-072 Hazardous Waste Day11,50010,057-1,44312,0000 #DIV/0!0.00%
5573-02-31-322-072 Composter Sales-150-160-10-1600 #DIV/0!0.00%
6159-02-31-322-072 Site Preparation*20,00017,013-2,98740,0000 #DIV/0!0.00%
6035-02-31-322-072 Regular Salaries & Wages19,16727,0437,87619,4570 #DIV/0!0.00%
6048-02-31-322-072 Part time Wages14,59210,559-4,03316,8000 #DIV/0!0.00%
6078-02-31-322-072 Vacation Pay584431-1536720 #DIV/0!0.00%
6091-02-31-322-072 Other Payroll Costs8,1308,7175878,7540 #DIV/0!0.00%
6592-02-31-322-072 Yard Waste Pick-up17,0006,985-10,01512,0000 #DIV/0!0.00%
TOTAL RECYCLING & COMPOSTING305,473219,891-85,582321,3980000 #DIV/0!
TOTAL SOLID WASTE MANAGEMENT812,473718,434-88,039836,3980000 #DIV/0!
TOTAL ENGINEERING GENERAL BUDGET928,668828,198-94,470992,6200000 #DIV/0!
TOTAL ENGINEERING BUDGET928,668828,198-94,470992,6200000 #DIV/0!

TOTAL SOLID WASTE MANAGEMENT TOTAL ENGINEERING GENERAL BUDGET TOTAL ENGINEERING BUDGET * Need to manage "pandemic" brush per VB ** Verbal from VB Sept 15/2021


TOWN OF SMITHS FALLS 2022 BUDGET

ECONOMIC DEVELOPMENT/TOURISM CAPITAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
01-41-420-000-6635 Development Cycle Tourism Strategy2,5000-2,5000#DIV/0!#DIV/0!
01-41-420-309-5612 Transfer from Capital Reserve-5,00005,000-38,0940#DIV/0!0.00%
01-41-420-000-5612 Transfer from Reserve (Acct 2013 & 2269)-36,9060#DIV/0!0.00%
01-41-420-000-6784 Update 2013 Cultural Plan2,5000-2,5000#DIV/0!#DIV/0!
01-41-420-000-6591 New Website050,0000#DIV/0!0.00%
01-41-420-164-6784 Centre St. Design Renderings025,0000#DIV/0!0.00%
00000000#DIV/0!
TOTAL ECONOMIC DEVELOPMENT CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET ECONOMIC DEVELOPMENT/TOURISM/CULTURE/COMMUNICATIONS GENERAL BUDGET

January 24, 2022
20212021202220222022%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
ECONOMIC DEVELOPMENT (ADMIN/DEPARTMENTAL)
6015-02-41-420-319 Travel & Hospitality2,500271-2,2295,5000#DIV/0!0.00%
6011-02-41-420-001 Office Supplies2,0001,847-1531,0000#DIV/0!0.00%
6015-02-41-420-001 Travel Expense2,000233-1,76700#DIV/0!#DIV/0!
6019-02-41-420-001 Photocopy Supplies2,00061-1,9392,0000#DIV/0!0.00%
6023-02-41-420-001 Postage25019-2312500#DIV/0!0.00%
6029-02-41-420-001 Membership Fees8,0009,2441,24412,5000#DIV/0!0.00%
6035-02-41-420-001 Regular Salaries & Wages166,497126,167-40,330191,6090#DIV/0!0.00%
6048-02-41-420-001 Part-time Salaries & Wages41,76830,754-11,01416,8000#DIV/0!0.00%
6078-02-41-420-001 Vacation1,6711,182-4896720#DIV/0!0.00%
6091-02-41-420-001 Other Payroll Costs58,67346,331-12,34268,7950#DIV/0!0.00%
6039-02-41-420-001 Training & Development5,0001,377-3,6236,0000#DIV/0!0.00%
6042-02-41-420-001 Courier1000-1001000#DIV/0!0.00%
6792-21-41-420-413 COVID-19 Expenditures23230#DIV/0!#DIV/0!
6102-02-41-420-001 Telephone1,0001,6326322,0000#DIV/0!0.00%
TOTAL ADMINISTRATION291,459219,141-72,318307,226000#DIV/0!0
  • Inc. includes reallocated of Event Contract support/Tourism budget
ECONOMIC DEVELOPMENT & COMMUNICATIONS#DIV/0!
6060-02-41-420-001 Marketing35,00042,0907,09035,0000#DIV/0!0.00%
6038-02-41-420-001 Advertising & Promotion024724700#DIV/0!#DIV/0!
6769-02-41-420-001 Partnership Initiatives (Prev Leverage)30,00012,638-17,36230,0000#DIV/0!0.00%
5421-02-41-420-414 RED Grant-24,000-21,2392,76100#DIV/0!#REF!
6226-02-41-420-414 RED Expenditures24,00025,9351,93500#DIV/0!#REF!
6180-02-41-420-001 Professional Fees030,85030,85020,0000#DIV/0!0.00%
6036-04-41-420-001 Communications10,00010,0787800#DIV/0!#DIV/0!
6800-02-41-420-001 Doctor Recruitment15,0001,424-13,57615,0000#DIV/0!0.00%
02-41-420-001-6284 Property Appraisals/Legal Fees15,00014,854-1465,0000#DIV/0!0.00%
02-41-420-001-6854 Trade Shows2,000225-1,7752,0000#DIV/0!0.00%
02-41-420-001-6651 Digital Tools & Subscriptions (Prev. Database Fees) *2,0001,014-98628,0960#DIV/0!0.00%
5586-02-41-420-020 Land Sales00000#DIV/0!#DIV/0!
6123-02-41-420-001 Expenditures (Property @54 Lombard St.)051,23051,23000#DIV/0!#DIV/0!
6301-02-41-420-001 Municipal Taxes (Property @54 Lombard St.)3,2793,2790
6701-02-41-420-001 Land Purchases092592500#DIV/0!#DIV/0!
6025-02-41-420-001 Transfer To/From Reserve0-66,017-66,01700#DIV/0!#DIV/0!
TOTAL COMMUNICATIONS109,000107,533-1,467135,096000#DIV/0!
  • Inc. Executive Pulse $2,000/Bang the Table $9,792/Survey Monkey $500/Sprout $1,200/Canva Pro $155/CinToast Website Retainer $7,200

TOWN OF SMITHS FALLS 2022 BUDGET ECONOMIC DEVELOPMENT & TOURISM

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
SMALL BUSINESS ADVISORY CENTRE
5425-02-41-425-020 MEDT Ontario Grants0-158,691-158,6910#DIV/0!#DIV/0!
5557-02-41-425-020 County of Lanark091,32591,3250#DIV/0!#DIV/0!
5561-02-41-425-020 Seminar Income0000#DIV/0!#DIV/0!
5845-02-41-425-020 Other Grants0-5,000-5,0000#DIV/0!#DIV/0!
6011-02-41-425-001 Office Supplies03,0703,0700#DIV/0!#DIV/0!
6048-02-41-425-001 Part-time Wages081,70281,7020#DIV/0!#DIV/0!
6057-02-41-425-001 Overtime0000#DIV/0!#DIV/0!
6078-02-41-425-001 Vacation03233230#DIV/0!#DIV/0!
6091-02-41-425-001 Other Payroll08,7038,7030#DIV/0!#DIV/0!
6102-02-41-425-001 Communications (Telephone)01,1711,1710#DIV/0!#DIV/0!
6038-02-41-425-001 Advertising & Promotion09,7609,7600#DIV/0!#DIV/0!
6045-02-41-425-001 Seminar Expenses09,7529,7520#DIV/0!#DIV/0!
5559-02-41-425-098 Publication Sales0000#DIV/0!#DIV/0!
6015-02-41-425-098 Travel02342340#DIV/0!#DIV/0!
6380-02-41-425-001 Rent8,1008,7756758,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)01921920#DIV/0!#DIV/0!
6015-02-41-425-296 Travel (Summer Co. Program)02842840#DIV/0!#DIV/0!
6045-02-41-425-296 Seminar Expenses (Summer Co. Program)07897890#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 Revenue0-14,588-14,5880#DIV/0!#DIV/0!
6226-02-41-425-296 Grants (Summer Co. Program)015,00015,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 2022 BUDGET ECONOMIC DEVELOPMENT & TOURISM GENERAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
SMALL BUSINESS ADVISORY CENTRE
6048-02-41-425-353 Part-time Wages (MEDI Starter Co. Plus)03303300#DIV/0!#DIV/0!
6078-02-41-425-353 Vacation (MEDI Starter Co. Plus)013130#DIV/0!#DIV/0!
6091-02-41-425-353 Other Benefits (MEDI Starter Co. Plus)036360#DIV/0!#DIV/0!
6015-02-41-425-353 Travel (MEDI Starter Co. Plus)01251250#DIV/0!#DIV/0!
6045-02-41-425-353 Seminar Expenses (MEDI Starter Co. Plus)013,78813,7880#DIV/0!#DIV/0!
6038-02-41-425-353 Marketing/Promo (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!
6226-02-41-425-353 Grants (MEDI Starter Co. Plus)080,00080,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)0-138,318-138,3180#DIV/0!#DIV/0!
TOTAL ENTERPRISE CENTRE8,1008,7756758,100000#DIV/0!
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
6196-02-41-430-000 RIDEAU VALLEY CON. *49,84451,4071,56353,3840#DIV/0!
TOTAL ECONOMIC DEVELOPMENT GENERAL458,403386,856-71,547503,806000#DIV/0!
  • Status quo for 2022 1st draft; still not confirmed as of October 4, 2021

TOWN OF SMITHS FALLS 2022 BUDGET

ECONOMIC DEVELOPMENT & TOURISM GENERAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
TOURISM & CULTURE
6788-02-21-266-001 Rideau Heritage Route10,00010,00009,4910#DIV/0!0.00%
6029-02-21-266-001 Tourism Membership2,5000-2,50000#DIV/0!#DIV/0!
6048-02-21-266-001 Part-time Staff **7,9800-7,98000#DIV/0!#DIV/0!
6078-02-21-266-001 Vacation3190-31900#DIV/0!#DIV/0!
6091-02-21-266-001 Other Benefits9380-93800#DIV/0!#DIV/0!
6062-02-21-266-001 General Tourism Marketing35,00032,522-2,47836,0000#DIV/0!0.00%
6854-02-21-266-001 Trade Shows5,0003,057-1,9435,0000#DIV/0!0.00%
6321-02-21-266-294 Event Contract Support14,5000-14,50000#DIV/0!#DIV/0!
6798-02-21-266-001 Arts & Culture *0005,0000#DIV/0!0.00%
6015-02-21-266-001 Travel & Hospitality2,000200-1,80000#DIV/0!#DIV/0!
6038-02-21-266-001 Advertising1,000395-60500#DIV/0!#DIV/0!
6633-02-21-266-001 Tourism Investment & Development15,00013,881-1,11925,0000#DIV/0!0.00%
6859-02-21-266-001 Cultural Investment & Development8,0005,064-2,93652,0000#DIV/0!0.00%
5576-02-21-266-020 Indigenous Cultural Experiences (Pow Wow); Revenue00000#DIV/0!#DIV/0!
6865-02-21-266-001 On The Roll Expenditures25,00026,9951,99500#DIV/0!#DIV/0!
6064-02-21-266-001 Event Sponsorship10,0007,773-2,22700#DIV/0!#DIV/0!
TOTAL TOURISM137,23799,887-37,350132,491000#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 2021 BUDGET

TOWN OF SMITHS FALLS 2021 BUDGET

ECONOMIC DEVELOPMENT & TOURISM CAPITAL BUDGET

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 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 2022 BUDGET ECONOMIC DEVELOPMENT & TOURISM GENERAL BUDGET

January 24, 2022
2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.Completed% Completed
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.Completed% Completed
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
HISTORICAL SERVICES
HERITAGE HOUSE - ADMINISTRATION
5421-02-21-260-020 Ontario Grants-22,440-23,210-770-22,4400#DIV/0!0.00%
5544-02-21-260-020 Program Fees-1,000-13,891-12,891-5000#DIV/0!0.00%
5555-02-21-260-020 Museum Memberships0-40-4000#DIV/0!#DIV/0!
5556-02-21-260-020 Gift Shop-400-3,064-2,664-4000#DIV/0!0.00%
5557-02-21-260-020 Donations-500-1,499-999-5000#DIV/0!0.00%
5558-02-21-260-020 Admissions-400-1,148-748-5000#DIV/0!0.00%
5566-02-21-260-020 Hall Rentals-500-699-199-5000#DIV/0!0.00%
5906-02-21-260-020 RMEO reimbursement for wages-20,00027820,278-20,0000#DIV/0!0.00%
5424-02-21-260-413 COVID-19 Federal Grant00000#DIV/0!#DIV/0!
6836-02-21-260-413 Trsf to/from Deferred Revenue (COVID-19)0-12,696-12,69600#DIV/0!#DIV/0!
6035-02-21-260-001 Regular Salaries & Wages39,88236,818-3,06459,5960#DIV/0!0.00%
6048-02-21-260-001 Part Time Wages28,92819,421-9,50732,2700#DIV/0!0.00%
6078-02-21-260-001 Vacation Pay1,1571,9537961,2910#DIV/0!0.00%
6091-02-21-260-001 Other Payroll Costs14,94815,43949130,7180#DIV/0!0.00%
6836-02-21-260-001 Trsf from Deferred Revenue00000#DIV/0!#DIV/0!
6025-02-21-260-001 Trsf from Reserve00000#DIV/0!#DIV/0!
6011-02-21-260-001 Office Supplies200182-184000#DIV/0!0.00%
6015-02-21-260-001 Travel/Professional Development010210200#DIV/0!#DIV/0!
6019-02-21-260-001 Photocopy Supplies1008507505000#DIV/0!0.00%
6023-02-21-260-001 Postage00000#DIV/0!#DIV/0!
6029-02-21-260-001 Membership Fees1750-1751750#DIV/0!0.00%
6038-02-21-260-001 Advertising400486863000#DIV/0!0.00%
6039-02-21-260-001 Staff Training10073-271000#DIV/0!0.00%
6042-02-21-260-001 Courier00000#DIV/0!#DIV/0!
6046-02-21-260-001 Program Supplies2504,8084,5584000#DIV/0!0.00%
6102-02-21-260-001 Telephone3,4005,6322,2323,5000#DIV/0!0.00%
6112-02-21-260-001 Equipment Repairs300281-194000#DIV/0!0.00%
6113-02-21-260-085 Exhibit Supplies300321214000#DIV/0!0.00%
6147-02-21-260-001 Gift Shop Supplies1,0002,7461,7464000#DIV/0!0.00%
6025-02-21-260-001 Trsf to Reserve (Account 2051)0-321-32100#DIV/0!#DIV/0!
6173-02-21-260-001 Insurance1,5852,7561,1713,3070#DIV/0!0.00%
TOTAL ADMINISTRATION47,48535,578-11,90788,917000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET - HISTORIAL SERVICES; HERITAGE HOUS

ADMINISTRATION

January 24,2022

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
BUILDING MAINTENANCE
6105-02-21-260-010 Hydro8,5008,9024027,0000#DIV/0!0.00%
6106-02-21-260-010 Water8001,4496498000#DIV/0!0.00%
6112-02-21-260-010 Equipment Repairs800140-6608000#DIV/0!0.00%
6116-02-21-260-010 Janitorial Supplies300220-803000#DIV/0!0.00%
6197-02-21-260-010 Janitorial Services5,0002,243-2,7575,0000#DIV/0!0.00%
6118-02-21-260-010 Tools, Accessories, etc1505614115000#DIV/0!0.00%
6142-02-21-260-010 Shrubbery00000#DIV/0!#DIV/0!
5612-02-21-260-001 Transfer from Reserve00000#DIV/0!#DIV/0!
6123-02-21-260-010 Property Repairs5002,0471,5475,0000#DIV/0!0.00%
6152-02-21-260-010 Property Lease010210200#DIV/0!#DIV/0!
TOTAL BUILDING MAINTENANCE16,05015,664-38619,400000#DIV/0!
JOB CREATION EMPLOYMENT GRANT
5421-02-21-260-088 Ontario Grant00000#DIV/0!#DIV/0!
5424-02-21-260-088 Federal Grant0-5,613-5,61300#DIV/0!#DIV/0!
6046-02-21-260-088 Program Supplies00000#DIV/0!#DIV/0!
6048-02-21-260-088 Part Time Wages010,14610,14600#DIV/0!#DIV/0!
6078-02-21-260-088 Vacation Pay038838800#DIV/0!#DIV/0!
6091-02-21-260-088 Other Payroll Costs01,2631,26300#DIV/0!#DIV/0!
TOTAL EMPLOYMENT GRANT06,1846,1840000#DIV/0!
TRILLIUM/RESILIENT COMMUNITIES GRANT
5421-02-21-260-192 Ontario Grant (Trillium Grant)0-48,500-48,50000#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)00000#DIV/0!#DIV/0!
6836-02-21-260-192 Tsf to/frm Deferred Revenue (Trillium Grant)022,49022,49000#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)022,34522,34500#DIV/0!#DIV/0!
6078-02-21-260-192 Vacation Pay (Trillium Grant)085185100#DIV/0!#DIV/0!
6091-02-21-260-192 Benefits (Trillium Grant)02,8142,81400#DIV/0!#DIV/0!
TOTAL TRILLIUM/VALLEY HEARTLAND GRANT0000000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET - HISTORIAL SERVICES; HERITAGE HOUSE

Page 83 ADMINISTRATION

2021 ACCOUNT/DESCRIPTION2021 Budget2021 Actual2022 Var.2022 Budget2022 To Date2022 Actual2022 Var.% Var.% Completed
JOB CREATION PROGRAM/CULTURAL MARKETING
5424-02-21-260-274 Federal Grant00000#DIV/0!#DIV/0!
6836-02-21-260-274 Trsf to Deferred Revenue00000#DIV/0!#DIV/0!
6046-02-21-260-274 Program Supplies00000#DIV/0!#DIV/0!
TOTAL JOB CREATION PROGRAM/CULTURAL MARKETING0000000#DIV/0!
FUNDRAISING ACTIVITIES
5557-02-21-260-013 Donations00000#DIV/0!#DIV/0!
6377-02-21-260-013 Partners Share00000#DIV/0!#DIV/0!
6411-02-21-260-013 Transfer (Museum Upgrade Reserve)00000#DIV/0!#DIV/0!
6525-02-21-260-013 Museum Upgrades00000#DIV/0!#DIV/0!
6046-02-21-260-013 Program Supplies00000#DIV/0!#DIV/0!
TOTAL FUNDRAISING ACTIVITIES0000000#DIV/0!
CANADIAN MUSEUMS/YOUNG CANADA WORKS
02-21-260-216-5421 Ont Grant (Cdn. Museums)0-21,869-21,86900#DIV/0!#DIV/0!
6048-02-21-260-216 Part Time Wages (Cdn. Museums)022,38622,38600#DIV/0!#DIV/0!
6078-02-21-260-216 Vacation Pay (Cdn. Museums)085185100#DIV/0!#DIV/0!
6091-02-21-260-216 Benefits (Cdn. Museums)02,7242,72400#DIV/0!#DIV/0!
02-21-260-089-5421 Ont Grant (Summer Experience Program)00000#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 Trsf to/frm Deferred Revenue (Building Careers in Heritage)00000#DIV/0!#DIV/0!
02-21-260-245-6836 Tsf to/frm Deferred Revenue (Museum & Technology)00000#DIV/0!#DIV/0!
6048-02-21-260-245 Part Time Wages (Museum & Technology)00000#DIV/0!#DIV/0!
6078-02-21-260-245 Vacation Pay (Museum & Technology)00000#DIV/0!#DIV/0!
6091-02-21-260-245 Benefits (Museum & Technology)00000#DIV/0!#DIV/0!
6046-02-21-260-245 Program Supplies (Museum & 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!
6091-02-21-260-246 Benefits (Cultural Strategic Investment Fund)00000#DIV/0!#DIV/0!
TOTAL MUSEUM GRANT04,0924,0920000#DIV/0!

ECONOMIC DEVELOPMENT & TOURISM GENERAL BUDGET
January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
TOTAL HERITAGE HOUSE GENERAL63,53561,518-2,017108,317000#DIV/0!
TOTAL HERITAGE HOUSE BUDGET63,53561,518-2,017108,317000#DIV/0!
TOWN HISTORY BOOK
5580-02-21-261-020 Book Sales0-48-4800#DIV/0!#DIV/0!
6162-02-21-261-001 Author's Royalties00000#DIV/0!#DIV/0!
TOTAL TOWN HISTORY0-48-480000#DIV/0!
GRANT & CONTRIBUTIONS TO HISTORICAL AGENCIES
MUNICIPAL HERITAGE COMMITTEE *5,000974-4,02610,0000#DIV/0!
02-21-260-001-6606 Municipal Heritage Committee000
02-21-260-020-5561 Heritage Symposium Revenue04,0264,0260#DIV/0!
5,0005,000010,0000#DIV/0!
TOTAL HISTORICAL SERVICES GENERAL68,53566,470-2,065118,317000#DIV/0!
  • Increased from $5000 to $10,000

TOWN OF SMITHS FALLS 2022 BUDGET ECONOMIC DEVELOPMENT - DBA GENERAL BUDGET

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 Actual REVENUEVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
5680-02-41-420-097 Donations0000#DIV/0!
5555-02-41-020-097 Associate Membership Fees0000#DIV/0!
5907-02-41-420-097 Digital Main St. Grant0310310#DIV/0!
5863-02-41-420-097 Trsf from other bank account0000#DIV/0!
5191-02-41-420-097 BIA Levy-79,000-78,498502-79,0000#DIV/0!
5194-02-41-420-097 DBA Dollar Revenue0-1,400-1,4000#DIV/0!
6244-02-41-420-097 Tax Write-off & Vacancy Adj4,0002,421-1,5794,0000#DIV/0!
TOTAL REVENUE-75,000-77,167-2,167-75,0000000#DIV/0!
EXPENDITURES
6048-02-41-420-097 Part Time Wages46,08624,598-21,48839,5850#DIV/0!
6078-02-41-420-097 Vacation Pay1,843928-9150#DIV/0!
6091-02-41-420-097 Other Payroll Costs5,5823,078-2,50414,8770#DIV/0!
6011-02-41-420-097 Office Supplies1,500424-1,0761,5000#DIV/0!
6561-02-41-420-097 Outgoing Donations; i.e. Legion Wreath & Scouts1000-1000#DIV/0!
6789-02-41-420-097 Radio Ads1,5000-1,5000#DIV/0!
6038-02-41-420-097 Advertising (Branding/Awareness)1,500375-1,1250#DIV/0!
6039-02-41-420-097 Staff Training & Develop.2,500228-2,2720#DIV/0!
6840-02-41-420-097 Website1,000611-3890#DIV/0!
6757-02-41-420-097 Business Recruitment (Marketing)2,20076-2,1240#DIV/0!
6060-02-41-420-097 Restaurant Week0000#DIV/0!
6029-02-41-420-097 OBIAA Memberships3000-3003000#DIV/0!
6142-02-41-420-097 Shrubbery10,00010,000010,0000#DIV/0!
6562-02-41-420-097 Winter Greenery & Annual Tree Decorating3,0002,900-1000#DIV/0!
6174-02-41-420-097 Audit Fees50050005000#DIV/0!
6196-02-41-420-097 Other Promotions (P2W Incentive)6,000251-5,7490#DIV/0!
6202-02-41-420-097 Christmas Promotions066660#DIV/0!
6286-02-41-420-097 Spring Promotions (Valentine's/Family Day/Easter)0000#DIV/0!
6858-02-41-420-097 Summer Promotions (Canada Day)0000#DIV/0!
6659-02-41-420-097 Winter Promotions0000#DIV/0!
6704-02-41-420-097 Girls Night Out1,500282-1,2180#DIV/0!
6594-02-41-420-097 Maintenance3,0000-3,0003,0000#DIV/0!
6758-02-41-420-097 Meeting Expenses5000-5000#DIV/0!
6582-02-41-420-097 Transportation2000-2000#DIV/0!
TOTAL EXPENDITURES88,81144,317-44,49469,7620000#DIV/0!

ECONOMIC DEVELOPMENT DBA GENERAL BUDGET

ACCCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
EXPENDITURES
6866-02-41-420-097 DBA Dollars2,000254-1,7460 #DIV/0!#DIV/0!
xxx-02-41-420-097 Bustle on Russell2,0000-2,0000 #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 Night2,0000-2,0000 #DIV/0!#DIV/0!
6860-02-41-420-097 Brochures and Shopping Guide2,000921-1,0790 #DIV/0!#DIV/0!
6502-02-41-420-097 Banners & Lights30,00022,995-7,00512,7240 #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. Expenses7,5000-7,5000 #DIV/0!#DIV/0!
TOTAL PROJECTS45,50024,170-21,33012,724000#DIV/0!
SURPLUS/DEFICIT
6276-02-41-420-097 Previous Deficit/Surplus *00000 #DIV/0!#DIV/0!
6022-02-41-420-097 Current Deficit/Surplus *-59,3118,68067,991-7,4860 #DIV/0!0.00%
*Reserve account 2211
TOTAL DEFICIT/SURPLUS-59,3118,68067,991-7,486000#DIV/0!
TOTAL DBIA BUDGET0000000#DIV/0!

TOWN OF SMITHS FALLS

Page 87

PUBLIC WORKS & UTILITIES; DEPARTMENTAL SUB-LEDGER A (CAPITAL PROJECTS)
January 24, 202220212021202220222022%%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateVar.Var.Completed
EQUIPMENT PURCHASES
5612-01-31-303-309 Transfer from Capital Reserve-19,194-19,1940-28,0000#DIV/0!0.00%
5852-01-31-303-222 Capital Financing019,19419,1940#DIV/0!#DIV/0!
5612-01-31-303-000 Transfer from Reserve (Acct 2051)-300,8060300,806-35,0000#DIV/0!0.00%
6013-01-31-303-000 1/2 ton Truck35,0000-35,00035,0000#DIV/0!0.00%
6205-01-31-303-222 LED Streetlighting Project014,43014,4300#DIV/0!#DIV/0!
5615-01-31-303-222 Unfinanced Capital0-14,430-14,4300#DIV/0!#DIV/0!
6808-01-31-303-436 Geotechnical Total Station00028,0000#DIV/0!0.00%
01-31-303-000-6661 Plow Truck & Wing285,0000-285,0000#DIV/0!#DIV/0!
TOTAL EQUIPMENT PURCHASES000000#DIV/0!
ACCOUNT/DESCRIPTION20212021202220222022%%%
BudgetActualVar.BudgetTo DateVar.Var.Completed
MUNICIPAL ROAD & SEWER WORK
5873-01-31-303-037 Provincial Grant (Connecting Link)-96,274-1,030,867-934,593-1,895,3680#DIV/0!0.00%
6205-01-31-303-425 County Rd 43 (Hershey to town limits); Microsurface70,00069,177-8230#DIV/0!#DIV/0!
6582-01-31-303-410 Improve Active Transportation Network (Tweed)9,0000-9,0000#DIV/0!#DIV/0!
6321-01-31-303-286 Road/Sidewalk Condition Assessment041,78341,7830#DIV/0!#DIV/0!
5424-01-31-303-286 FCM fed grant; Road/Sidewalk Condition Assessment0-26,725-26,7250#DIV/0!#DIV/0!
6205-01-31-303-426 Connie St. (Cornelia to Grovenor); Roads/Curbs/Sidewalks461,000276,773-184,2270#DIV/0!#DIV/0!
5424-01-31-303-433 CCRF Funding000-750,0000#DIV/0!0.00%
6205-01-31-303-366 Improve Old Sly's Pedestrian Accessibility; Design only9,3270-9,3270#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)-154,057-60,63593,4220#DIV/0!#DIV/0!
6732-01-31-303-210 Design Work (Lombard/Abbott)628,441576,745-51,6960#DIV/0!#DIV/0!
6732-01-31-303-030 Lombard St. (South side Abbott/Ferrara); sidewalks217,000161,383-55,6170#DIV/0!#DIV/0!
6205-01-31-303-427 Design Work; George St. (Storm/Roads)88,70037,761-50,9390#DIV/0!#DIV/0!
5869-01-31-303-295 Federal Gas Tax/Wood St.000-221,1400#DIV/0!0.00%
6205-01-31-303-350 Beckwith St; Phase 1; Reconstruction Project189,56644,642-144,9240#DIV/0!#DIV/0!
6732-01-31-303-350 Beckwith St; Phase 2; Detailed Design119,148164,43345,2850#DIV/0!#DIV/0!
6836-01-31-303-350 Trsf from deferred revenue (CL/Phase)0947,652947,6520#DIV/0!#DIV/0!
6149-01-31-303-350 Beckwith St; Phase 2; Reconstruction Project0-509,998-509,9984,045,2050#DIV/0!0.00%
5852-01-31-303-350 Financed Capital/Beckwith St.-668,1630668,1630#DIV/0!#DIV/0!
5612-01-31-303-309 Tsf from Capital Reserve (Account 2083)-5,844-86,298-80,454-433,6590#DIV/0!0.00%
5900-01-31-303-210 OCIF Formula-Based Funding-604,588-420,361184,227-1,400,2890#DIV/0!0.00%
6205-01-31-303-295 Wood St/Storm Sewers000655,2510#DIV/0!0.00%
01-31-303-000-6582 Active Transportation Plan30,00031,3821,3820#DIV/0!#DIV/0!
01-31-303-185-6205 Cornelia St. (William to Elmsley); Roads480,000498,69918,6990#DIV/0!#DIV/0!
5869-01-31-303-350 Federal Gas Tax/Beckwith St.-773,256-690,68982,5670#DIV/0!#DIV/0!
5869-01-31-303-210 Federal Gas Tax/Old Mill Rd./Lombard/Abbott0000#DIV/0!#DIV/0!
TOTAL ROADWORK024,85724,8570000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER A(CAPITAL PRO

PAGE 88 JECTS)

SUMMARY OF THE YEAR 2021
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
BRIDGES
01-31-303-207-6825Confederation Bridge MCEA75,0008,510-66,4900#DIV/0!
01-31-303-350-5873Beckwith St. Structures; Pre-Engineering Work (Connecting Link Grant)0000#DIV/0!
01-31-303-350-6836Transfer to/from Deferred Revenue (Connecting Link Grant)0000#DIV/0!
01-31-303-309-5612Transfer from Capital Reserve-75,000075,0000#DIV/0!
01-31-303-028-6205Contractor (Stone Arch Bridge)0000#DIV/0!
01-31-303-028-6836Transfer to/from Deferred Revenue0000#DIV/0!
01-31-303-028-5612/6025Transfer to/from Reserve0000#DIV/0!
01-31-303-350-5612Transfer from Reserve (Acct 2051)0-8,510-8,5100#DIV/0!
01-31-303-028-5869Federal Gas Tax0000#DIV/0!
01-31-303-028-5421Provincial Grant0000#DIV/0!
TOTAL SIDEWALKS0000000#DIV/0!
PUBLIC WORKS BUILDINGS
6808-01-31-303-355Energy Audit Project0000#DIV/0!
01-31-303-309-5612Tsf From Capital Reserve (Acct 2083)000-30,0000#DIV/0!
01-31-303-000-6082Detailed Inspection/Design for Roof Repair35,0003,113-31,88761,8870#DIV/0!
01-31-303-000-5612Transfer from Reserve (Acct 2051)-35,000-3,11331,887-31,8870#DIV/0!
TOTAL PUBLIC WORKS BUILDING0000000#DIV/0!
SUBLEDGER TOTAL024,85724,8570000#DIV/0!

PUBLIC WORKS & UTILITIES; DEPAR January 24, 2022

2022 BUDGET Page 89 MENTAL SUB-LEDGER B (ROAD & SEWER MAINTENANCE)

SUMMARY | YEAR 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
BRIDGES & CULVERTS
6035-02-31-303-033 Regular Salaries & Wages15,00011,378-3,62215,0000#DIV/0!
6091-02-31-303-033 Other Payroll Costs6,3003,591-2,7095,4000#DIV/0!
6211-02-31-303-033 Preventative Maintenance (AMP LOS)00000#DIV/0!
6361-02-31-303-033 Engineers Fee - Bridges*04,0144,0145,0000#DIV/0!
6205-02-31-303-033 Contracted Services18,00019,8321,83218,0000#DIV/0!
6268-02-31-303-033 Materials5,0009,0954,0956,0000#DIV/0!
TOTAL BRIDGES & CULVERTS44,30047,9103,61049,400000#DIV/0!
* Bi-annual inspections required by province; OSIM due per VB
GRASS & WEED MOWING
6035-02-31-303-034 Regular Salaries & Wages17,50012,642-4,85820,0000#DIV/0!
6091-02-31-303-034 Other Payroll Costs7,1754,367-2,8087,2000#DIV/0!
6205-02-31-303-034 Town Equipment4,0000-4,00000#DIV/0!
6122-02-31-303-034 Materials6001,4438436000#DIV/0!
TOTAL GRASS & WEED MOWING29,27518,452-10,82327,800000#DIV/0!
MAIN SEWERS
6035-02-31-303-035 Regular Salaries & Wages75,00073,769-1,23191,1980#DIV/0!
6057-02-31-303-035 Overtime00000#DIV/0!
6091-02-31-303-035 Other Payroll Costs32,75024,570-8,18038,6170#DIV/0!
6268-02-31-303-035 Materials23,00032,6369,63625,0000#DIV/0!
6205-02-31-303-035 Contractor *120,000157,63037,630120,0000#DIV/0!
6206-02-31-303-035 Storm Sewer Lease200101-992000#DIV/0!
6213-02-31-304-001 Parks Canada Lease **1,7000-1,7001,7000#DIV/0!
6105-02-31-303-035 Hydro (Pumping Station)4,4004,033-3675,0000#DIV/0!
6102-02-31-303-035 Communications (Pumping Station)3,5003,266-2343,5000#DIV/0!
6110-02-31-303-035 Pumping Station Repairs ("New Acc"; Prev WPCP)5,5008,8643,3645,5000#DIV/0!
6114-02-31-303-035 Town Equipment00000#DIV/0!
6213-02-31-303-035 CP Drain Lease4,0003,498-5022,5000#DIV/0!
5612/6025-02-31-303-035 Transfer Reserve (Acct 2051)00000#DIV/0!
* Now includes flushing/CCTV annual maintenance @$50,000 ** Previously under "Bldg. & Grounds"*
270,050308,36738,317293,2150000#DIV/0!

(Now Incl 25% of AM Coordinator)


TOWN OF SMITHS FALLS 2022 BUDGET

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

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
STORM SEWERS/CATCH BASINS
6035-02-31-303-036 Regular Salaries & Wages17,00019,6812,68120,0000#DIV/0!0.00%
6091-02-31-303-036 Other Payroll Costs6,9705,018-1,9527,2000#DIV/0!0.00%
6205-02-31-303-036 Contracted Services25,00029,2904,29030,0000#DIV/0!0.00%
6125-02-31-303-036 Materials10,00017,7587,75812,0000#DIV/0!0.00%
TOTAL CATCH BASINS & SEWERS58,97071,74712,77769,200000#DIV/0!
STREET REPAIR
6035-02-31-303-037 Regular Salaries & Wages45,00036,154-8,84662,6670#DIV/0!0.00%
6091-02-31-303-037 Other Payroll Costs18,45010,895-7,55528,3460#DIV/0!0.00%
6269-02-31-303-037 Materials20,00017,317-2,68320,0000#DIV/0!0.00%
6114-02-31-303-037 Town Equipment00000#DIV/0!#DIV/0!
6855-02-31-303-037 Cracksealing Maintenance (AMP LOS)25,00014,459-10,54125,0000#DIV/0!0.00%
6205-02-31-303-037 Contractor (Now Incl 25% of AM Coordinator)120,000150,12930,129130,0000#DIV/0!0.00%
TOTAL STREET PATCHING228,450228,954504266,013000#DIV/0!
GRADING & SHOULDER MAINTENANCE
6035-02-31-303-038 Regular Salaries & Wages2,5001,118-1,3825,0000#DIV/0!0.00%
6091-02-31-303-038 Other Payroll Costs1,025212-8131,8000#DIV/0!0.00%
6124-02-31-303-038 Materials6,5000-6,5006,5000#DIV/0!0.00%
TOTAL SHOULDER MAINTENANCE10,0251,330-8,69513,300000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

TOWN OF SMITHS FALLS 2022 BUDGET

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

ACCCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
DUST CONTROL
6035-02-31-303-039 Regular Salaries & Wages2,5000-2,5005,0000#DIV/0!0.00%
6091-02-31-303-039 Other Payroll Costs1,0250-1,0251,8000#DIV/0!0.00%
6114-02-31-303-039 Town Equipment00000#DIV/0!#DIV/0!
6122-02-31-303-039 Materials6000-6005000#DIV/0!0.00%
TOTAL DUST CONTROL4,1250-4,1257,300000#DIV/0!
WINTER CONTROL; PLOWING/SANDING/SALTING ROADS
6035-02-31-303-040 Regular Salaries & Wages61,00032,754-28,24665,0000#DIV/0!0.00%
6057-02-31-303-040 Overtime13,0006,846-6,15413,0000#DIV/0!0.00%
6091-02-31-303-040 Other Payroll Costs31,24211,129-20,11328,0800#DIV/0!0.00%
6025-02-31-303-040 Trsf to Payroll Reserve (Surplus Group Benefits)00000#DIV/0!#DIV/0!
6114-02-31-303-040 Town Equipment00000#DIV/0!#DIV/0!
6115-02-31-303-040 Contracted Services00000#DIV/0!#DIV/0!
6133-02-31-303-040 Salt105,900102,901-2,999105,0000#DIV/0!0.00%
6134-02-31-303-040 Sand20,00010,871-9,12920,0000#DIV/0!0.00%
TOTAL WINTER CONTROL; PLOWING/SANDING/SALTING ROADS231,142164,501-66,641231,080000#DIV/0!
WINTER CONTROL; SNOW REMOVAL
6035-02-31-303-324 Regular Salaries & Wages20,00017,769-2,23130,0000#DIV/0!0.00%
6057-02-31-303-324 Overtime5,0000-5,0005,0000#DIV/0!0.00%
6091-02-31-303-324 Other Payroll Costs10,2506,027-4,22312,6000#DIV/0!0.00%
6114-02-31-303-324 Town Equipment00000#DIV/0!#DIV/0!
6115-02-31-303-324 Contracted Services65,00026,681-38,31965,0000#DIV/0!0.00%
TOTAL WINTER CONTROL; SNOW REMOVAL100,25050,477-49,773112,600000#DIV/0!

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

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
WINTER CONTROL; SIDEWALKS
6035-02-31-303-325 Regular Salaries & Wages20,00018,614-1,38630,0000#DIV/0!0.00%
6057-02-31-303-325 Overtime2,0001,454-5462,0000#DIV/0!0.00%
6091-02-31-303-325 Other Payroll Costs9,0206,445-2,57511,5200#DIV/0!0.00%
6114-02-31-303-325 Town Equipment00000#DIV/0!#DIV/0!
TOTAL WINTER CONTROL; SIDEWALKS31,02026,513-4,50743,520000#DIV/0!
WINTER CONTROL; PARKING & FACILITIES
6035-02-31-303-326 Regular Salaries & Wages12,0003,130-8,87012,0000#DIV/0!0.00%
6057-02-31-303-326 Overtime500141-3595000#DIV/0!0.00%
6091-02-31-303-326 Other Payroll Costs5,1251,097-4,0284,5000#DIV/0!0.00%
6114-02-31-303-326 Town Equipment00000#DIV/0!#DIV/0!
TOTAL WINTER CONTROL; PARKING & FACILITIES17,6254,368-13,25717,000000#DIV/0!
TRAFFIC SIGNALS
6035-02-31-303-041 Regular Salaries & Wages1,000283-7171,0000#DIV/0!0.00%
6091-02-31-303-041 Other Payroll Costs410102-3083600#DIV/0!0.00%
6105-02-31-303-041 Hydro41,50045,2113,71142,0000#DIV/0!0.00%
6112-02-31-303-041 Materials5000-50000#DIV/0!#DIV/0!
6114-02-31-303-041 Town Equipment00000#DIV/0!#DIV/0!
6205-02-31-303-041 Contractor35,00044,0629,06235,0000#DIV/0!0.00%
TOTAL TRAFFIC SIGNALS78,41089,65811,24878,360000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

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

MAINTENANCE)

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
TRAFFIC MARKINGS
6035-02-31-303-042 Regular Salaries & Wages80018-7821,0000#DIV/0!0.00%
6091-02-31-303-042 Other Payroll Costs3284-3243600#DIV/0!0.00%
6118-02-31-303-042 Tools, Accessories, etc.01,2611,26100#DIV/0!#DIV/0!
6268-02-31-303-042 Paint00000#DIV/0!#DIV/0!
6205-02-31-303-042 Contractor31,00027,406-3,59435,0000#DIV/0!0.00%
TOTAL TRAFFIC MARKINGS0
TOTAL TRAFFIC MARKINGS32,12828,689-3,43936,360000#DIV/0!
RAILWAY CROSSINGS
6211-02-31-303-043 Maintenance12,00011,739-26112,5000#DIV/0!0.00%
TOTAL RAILWAY CROSSINGS12,00011,739-26112,500000#DIV/0!
HOUSE SEWERS
6035-02-31-303-044 Regular Salaries & Wages15,0008-14,99215,0000#DIV/0!0.00%
6091-02-31-303-044 Other Payroll Costs6,1502-6,1485,4000#DIV/0!0.00%
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,000728-4,2725,0000#DIV/0!0.00%
TOTAL HOUSE SEWERS29,150738-28,41228,400000#DIV/0!

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

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
STREET LIGHTING
6035-02-31-303-045 Regular Salaries & Wages2,5001,356-1,1444,7750#DIV/0!0.00%
6091-02-31-303-045 Other Payroll Costs1,025289-7361,7190#DIV/0!0.00%
6105-02-31-303-045 Hydro41,00052,22311,22345,0000#DIV/0!0.00%
6012-02-31-303-045 Streetlighting Capital Project (Principal Repayment)98,44175,205-23,236102,5300#DIV/0!0.00%
6014-02-31-303-045 Streetlighting Capital Project (Principal Repayment)3,5652,747-8182,8570#DIV/0!0.00%
6112-02-31-303-045 Contracted Services **8,00012,7254,72510,0000#DIV/0!0.00%
6114-02-31-303-045 Town Equipment00000#DIV/0!#DIV/0!
6153-02-31-303-045 Materials2,000-764-2,7642,0000#DIV/0!0.00%
6188-02-31-303-045 Permits & Repairs - Hydro2,500816-1,6842,5000#DIV/0!0.00%
** Increase for "banner" installation (surplused bucket truck)
TOTAL STREET LIGHTING159,031144,597-14,434171,381000#DIV/0!
CURBS & SIDEWALK REPAIRS
5594-02-31-303-047 Misc. Revenue0000
6035-02-31-303-046 Regular Salaries & Wages25,44460,54835,10447,0000#DIV/0!0.00%
6091-02-31-303-046 Other Payroll Costs10,43219,5259,09316,9200#DIV/0!0.00%
6114-02-31-303-046 Town Equipment00000#DIV/0!#DIV/0!
6130-02-31-303-046 Materials20,00022,7102,71025,0000#DIV/0!0.00%
6205-02-31-303-046 Contractor33,00015,264-17,73630,0000#DIV/0!0.00%
TOTAL SIDEWALK REPAIRS88,876118,04729,171118,920000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET

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

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
STREET SIGNS
6035-02-31-303-048 Regular Salaries & Wages17,00011,769-5,23120,0000#DIV/0!0.00%
6091-02-31-303-048 Other Payroll Costs6,9704,944-2,0267,2000#DIV/0!0.00%
6114-02-31-303-048 Town Equipment00000#DIV/0!#DIV/0!
6268-02-31-303-048 Materials11,50014,6943,19413,0000#DIV/0!0.00%
6158-02-31-303-048 Sign Supplies0191900#DIV/0!#DIV/0!
TOTAL STREET SIGNS35,47031,426-4,04440,200000#DIV/0!
STREET CLEANING
6035-02-31-303-049 Regular Salaries & Wages28,50026,271-2,22930,0000#DIV/0!0.00%
6091-02-31-303-049 Other Payroll Costs11,6858,792-2,89310,8000#DIV/0!0.00%
5831-02-31-303-049 Misc. Revenue-1,680-2,393-713-2,0000#DIV/0!0.00%
6114-02-31-303-049 Town Equipment00000#DIV/0!#DIV/0!
6268-02-31-303-049 Supplies00000#DIV/0!#DIV/0!
TOTAL STREET CLEANING38,50532,670-5,83538,800000#DIV/0!
TREE SERVICING
6035-02-31-303-050 Regular Salaries & Wages25,00016,859-8,14125,0000#DIV/0!0.00%
6091-02-31-303-050 Other Payroll Costs10,2504,822-5,4289,0000#DIV/0!0.00%
6268-02-31-303-050 Materials5,0000-5,0005,000
6114-02-31-303-050 Town Equipment00000#DIV/0!#DIV/0!
6186-02-31-303-050 Contracted Services15,00014,582-41815,0000#DIV/0!0.00%
TOTAL TREE SERVICING55,25036,263-18,98754,000000#DIV/0!

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

January 24,2022

2021 ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.Completed

BUILDINGS & GROUNDS ("New"; 11 Air Care Dr.; previously under "Distribution" budget)

6035-02-31-303-051 Regular Salaries & Wages30,00030,49249230,0000#DIV/0!0.00%
6091-02-31-303-051 Other Payroll Costs12,3008,985-3,31510,8000#DIV/0!0.00%
6105-02-31-303-051 Hydro5,9505,996466,0000#DIV/0!0.00%
6106-02-31-303-051 Water4,0004,4034034,0000#DIV/0!0.00%
6107-02-31-303-051 Heating Gas11,2907,509-3,78111,0000#DIV/0!0.00%
6011-02-31-303-051 Office Supplies4,5008,5984,0984,5000#DIV/0!0.00%
6102-02-31-303-051 Telephone9,0004,657-4,3436,0000#DIV/0!0.00%
6116-02-31-303-051 Janitorial Supplies1,500959-5411,5000#DIV/0!0.00%
6118-02-31-303-051 Tools, Accessories, etc.6,3008,1661,8666,5000#DIV/0!0.00%
6197-02-31-303-051 Janitorial Services5,2002,857-2,3435,2000#DIV/0!0.00%
6123-02-31-303-051 Property Repairs6,00012,0666,0668,0000#DIV/0!0.00%
* This has been reallocated to "Main Sewers" as of 2017
TOTAL BUILDING & GROUNDS96,04094,688-1,35293,500000#DIV/0!
LITTER AND GARBAGE PICK-UP
6035-02-31-303-327 Regular Salaries & Wages20,00016,532-3,46820,0000#DIV/0!0.00%
6091-02-31-303-327 Other Payroll Costs8,2005,683-2,5177,2000#DIV/0!0.00%
6114-02-31-303-327 Town Equipment00000#DIV/0!#DIV/0!
6286-02-31-303-327 Materials1,2501,5372871,2500#DIV/0!0.00%
TOTAL LITTER AND GARBAGE PICK-UP29,45023,752-5,69828,450000#DIV/0!
TOTAL ROADS MAINTENANCE1,679,5421,534,886-144,6561,831,299000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER

Page 97 EQUIPMENT)

January 24,2022

January 24, 2022
2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.Completed% Completed
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.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,3006,9681,6685,3000#DIV/0!0.00%
6110-02-31-303-052 Repairs10,0009,645-35510,0000#DIV/0!0.00%
6128-02-31-303-052 License1,2501,242-81,3000#DIV/0!0.00%
TOTAL TRUCK 11116,55017,8551,30516,60000#DIV/0!

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

6108-02-31-303-053 Gas & Oil3,2003,7355353,2000#DIV/0!0.00%
6110-02-31-303-053 Repairs2,400298-2,1022,0000#DIV/0!0.00%
6128-02-31-303-053 Licenses140120-201600#DIV/0!0.00%
TOTAL TRUCK 1205,7404,153-1,5875,360000#DIV/0!

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

6108-02-31-303-055 Gas & Oil2,7000-2,70000#DIV/0!#DIV/0!
6110-02-31-303-055 Repairs2,8000-2,80000#DIV/0!#DIV/0!
6128-02-31-303-055 Licenses1400-14000#DIV/0!#DIV/0!
This is now out of service per JD)
TOTAL TRUCK 1225,6400-5,6400000#DIV/0!
2007 6-TON DUMP TRUCK; VEHICLE 123; FIXED ASSET #7-0029
6108-02-31-303-056 Gas & Oil6,5005,829-6716,0000#DIV/0!0.00%
6110-02-31-303-056 Repairs10,00034,72024,72010,0000#DIV/0!0.00%
6128-02-31-303-056 Licenses1,2501,249-11,3000#DIV/0!0.00%
TOTAL TRUCK 12317,75041,79824,04817,30000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER

Page 98 EQUIPMENT)

January 24, 2022
ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.
1990 INTERNATIONAL 4000 SERIES BUCKET TRUCK; VEHICLE 159; FIXED ASSET #7-0038
6108-02-31-303-159 Gas & Oil00000#DIV/0!
6110-02-31-303-159 Repairs00000#DIV/0!
6128-02-31-303-159 Licenses00000#DIV/0!
BUCKET TRUCK TOTAL *0000000#DIV/0!
(This is now out of service per JD)
2005 VOLVO GRADER V129; FIXED ASSET 7-0040
6108-02-31-303-058 Gas & Oil3,3004,1468463,3000#DIV/0!
6110-02-31-303-058 Repairs10,50011,7311,23110,0000#DIV/0!
TOTAL GRADER V12913,80015,8772,07713,300000#DIV/0!
2010 TRACTOR/HOLDER (HOLDER OF NORTH AMERICA); VEHICLE 146; FIXED ASSET #5-1067
6108-02-31-303-061 Gas & Oil00000#DIV/0!
6110-02-31-303-061 Repairs00000#DIV/0!
(Surplused in September, 2020)
TOTAL TRACTOR 1460000000#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,0002,697-2,3035,0000#DIV/0!
6110-02-31-303-399 Repairs3,0006,5203,5203,5000#DIV/0!
TOTAL LOADER 1528,0009,2171,2178,500000#DIV/0!
2015 FORD (1-TON TRUCK); Vehicle 124; FIXED ASSET #7-0061
6108-02-31-303-298 Gas & Oil3,8004,0482484,0000#DIV/0!
6110-02-31-303-298 Repairs2,0001,304-6962,0000#DIV/0!
6128-02-31-303-298 Vehicle Licence525506-195500#DIV/0!
TOTAL 2015 FORD (1-TON) TRUCK6,3255,858-4676,550000#DIV/0!

2022 BUDGET PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER EQUIPMENT)

January 24, 2022
2021 ACCOUNT/DESCRIPTION2021 Budget 2006 BACKHOE; VEHICLE #154; FIXED ASSET #5-10612022 Budget 2022 To Date2022 Actual2022 Var.% Var.% Completed
6108-02-31-303-064 Gas & Oil3,5002,577-9233,0000#DIV/0!0.00%
6110-02-31-303-064 Repairs5,0006,1301,1305,0000#DIV/0!0.00%
TOTAL BACKHOE 154B8,5008,7072078,000000#DIV/0!
6108-02-31-303-065 Gas & Oil6,2004,551-1,6496,0000#DIV/0!0.00%
6110-02-31-303-065 Repairs7,00010,0883,0888,0000#DIV/0!0.00%
6128-02-31-303-065 Licence ("New")655652-3700
TOTAL SWEEPER13,85515,2911,43614,700000#DIV/0!
JOE JOHNSTON SIDEWALK TRACTOR (VEHICLE #147)
6108-02-31-303-411 Gas & Oil5,0008,8133,8136,0000#DIV/0!0.00%
6110-02-31-303-411 Repairs8,00018,41110,41110,0000#DIV/0!0.00%
TOTAL BRANDT WHEELED LOADER13,00027,22414,22416,000000#DIV/0!
6108-02-31-303-300 Gas & Oil00000#DIV/0!#DIV/0!
6110-02-31-303-300 Repairs00000#DIV/0!#DIV/0!
0000000#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 & Oil2,8003,2054053,0000#DIV/0!0.00%
6110-02-31-303-301 Repairs2,5001,556-9442,5000#DIV/0!0.00%
6128-02-31-303-301 Vehicle Licence140120-201600#DIV/0!0.00%
TOTAL 2015 CHEV 1/2 TON (VEHICLE #101)5,4404,881-5595,66000#DIV/0!

TOWN OF SMITHS FALLS 2022 BUDGET PUBLIC WORKS & UTILITIES DEPARTMENTAL SUB-LEDGER C (ROAD & SEWE

Page 100 R EQUIPMENT)

ACCCOUNT/DESCRIPTION2021 Budget 2015 HOLDER (270); VEHICLE #1452022 Budget 2022 To Date2022 ActualVar.% Var.Completed
ACCCOUNT/DESCRIPTION2,5002,7862862,5000#DIV/0!
6108-02-31-303-304 Gas & Oil10,00011,3721,37210,0000#DIV/0!
6110-02-31-303-304 Repairs
TOTAL 2015 HOLDER (270)12,50014,1581,65812,500000#DIV/0!
2009 RPM TECH SNOW BLOWER; EQUIPMENT #272; FIXED ASSET #5-1059
6108-02-31-303-069 Gas & Oil1,100482-6181,0000#DIV/0!0.00%
6110-02-31-303-069 Repairs5,0007,9032,9035,0000#DIV/0!0.00%
TOTAL SNOW BLOWER6,1008,3852,2856,00000#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 & Oil2,5006,7874,2873,0000#DIV/0!0.00%
6128-02-31-303-367 Licence140120-201600#DIV/0!0.00%
6110-02-31-303-367 Repairs2,0001,531-4692,0000#DIV/0!0.00%
TOTAL VEHICLE #1214,6408,4383,7985,160000#DIV/0!

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

6108-02-31-303-180 Gas & Oil3,0002,533-4672,5000#DIV/0!0.00%
6110-02-31-303-180 Repairs2,7501,562-1,1882,5000#DIV/0!0.00%
6128-02-31-303-180 License510506-45500#DIV/0!0.00%
TOTAL TRUCK 1266,2604,601-1,6595,550000#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 20196108-02-31-303-386 Gas & Oil6128-02-31-303-386 Vehicle Licence6110-02-31-303-386 Repairs6108-02-31-303-387 Gas & Oil6128-02-31-303-387 Vehicle LicenceTOTAL2,700251-2,449-202,7000#DIV/0!0.00%
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 20196108-02-31-303-386 Gas & Oil6128-02-31-303-386 Vehicle Licence6110-02-31-303-386 Repairs6108-02-31-303-387 Gas & Oil6128-02-31-303-387 Vehicle LicenceTOTAL140120-2016000#DIV/0!0.00%
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 20196108-02-31-303-386 Gas & Oil6128-02-31-303-386 Vehicle Licence6110-02-31-303-386 Repairs6108-02-31-303-387 Gas & Oil6128-02-31-303-387 Vehicle LicenceTOTAL2,0002,000-1,2732,00000#DIV/0!0.00%
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 20196108-02-31-303-386 Gas & Oil6128-02-31-303-386 Vehicle Licence6110-02-31-303-386 Repairs6108-02-31-303-387 Gas & Oil6128-02-31-303-387 Vehicle LicenceTOTAL000000#DIV/0!#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 20196108-02-31-303-386 Gas & Oil6128-02-31-303-386 Vehicle Licence6110-02-31-303-386 Repairs6108-02-31-303-387 Gas & Oil6128-02-31-303-387 Vehicle LicenceTOTAL000000#DIV/0!#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 20196108-02-31-303-386 Gas & Oil6128-02-31-303-386 Vehicle Licence6110-02-31-303-386 Repairs6108-02-31-303-387 Gas & Oil6128-02-31-303-387 Vehicle LicenceTOTAL000000#DIV/0!#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 20196108-02-31-303-386 Gas & Oil6128-02-31-303-386 Vehicle Licence6110-02-31-303-386 Repairs6108-02-31-303-387 Gas & Oil6128-02-31-303-387 Vehicle LicenceTOTAL4,8401,098-3,7424,86000#DIV/0!0.00%

TOWN OF SMITHS FALLS 2022 BUDGETPage 101
PUBLIC WORKS & UTILITIES
DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER EQUIPMENT)
20212021202220222022%%%
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,3003,3111,0112,5000#DIV/0!0.00%
6110-02-31-303-073 Repairs5,0004,406-5945,0000#DIV/0!0.00%
TOTAL GRADER V0737,3007,7174177,500000#DIV/0!
MISCELLANEOUS RDS EQUIPMENT
5812-02-31-303-070 Diesel Allocated-43,000-25,82817,172-43,0000#DIV/0!0.00%
6035-02-31-303-070 Regular Salaries & Wages30,00024,438-5,56230,0000#DIV/0!0.00%
6091-02-31-303-070 Other Payroll Costs12,3007,449-4,85110,8000#DIV/0!0.00%
6108-02-31-303-070 Gas & Oil9,5004,051-5,4499,5000#DIV/0!0.00%
6792-02-31-303-413 COVID-19 Expenditures2,5000-2,5002,0000#DIV/0!0.00%
6112-02-31-303-070 Equipment Repairs *20,00023,2833,28323,0000#DIV/0!0.00%
6115-02-31-303-070 Equipment Rental5003,5023,0021,0000#DIV/0!0.00%
6119-02-31-303-070 Radio Licences & Repairs2,5001,177-1,3232,5000#DIV/0!0.00%
6135-02-31-303-070 Diesel43,00020,937-22,06340,0000#DIV/0!0.00%
6173-02-31-303-070 Insurance24,14110,380-13,76112,4560#DIV/0!0.00%
TOTAL MISCELLANEOUS101,44169,389-32,05288,256000#DIV/0!
TOTAL EQUIPMENT SUBLEDGER257,681264,6476,966241,796000#DIV/0!

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

ACCOUNT/DESCRIPTION2021 Budget2021 ActualVar.2022 Budget2022 To Date2022 ActualVar.% Var.% Completed
6035-02-31-303-052 Regular Salaries & Wages30,00024,438-5,56230,000000#DIV/0!0.00%
6091-02-31-303-070 Other Payroll Costs12,3007,449-4,85110,800000#DIV/0!0.00%
6108-02-31-303-070 Gas & Oil70,90066,770-4,13068,500000#DIV/0!0.00%
6782-02-31-303-413 COVID-19 Expenditures2,5000-2,5002,000000#DIV/0!0.00%
6110-02-31-303-070 Repairs89,950127,90437,95489,500000#DIV/0!0.00%
6128-02-31-303-070 Licenses4,8904,635-2555,040000#DIV/0!0.00%
6112-02-31-303-070 Equipment Repairs20,00023,2833,28323,000000#DIV/0!0.00%
6115-02-31-303-070 Equipment Rental5003,5023,0021,000000#DIV/0!0.00%
6119-02-31-303-070 Radio Repairs2,5001,177-1,3232,500000#DIV/0!0.00%
6135-02-31-303-070 Diesel0-4,891-4,891-3,000000#DIV/0!0.00%
6173-02-31-303-070 Insurance24,14110,380-13,76112,456000#DIV/0!0.00%
Subledger Total257,681264,6476,966241,796000#DIV/0!