Back to the archive
Public document · Taxes & Budgets

2021 BUDGET; FINAL VERSION AS OF JANUARY 18, 2021)

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

Source text

2021 BUDGET; FINAL VERSION AS OF JANUARY 18, 2021)


TOWN OF SMITHS FALLS

2021 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 SMITHS FALLS 2021 BUDGET; FINAL VERSION "DEPARTMENTAL SUMMARY"

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.Variance from 2020 Budget
($)
Mayor & Council260,683226,670-34,013255,089000#DIV/0!-2.1%
Community Programs320,824313,976-6,848374,704000#DIV/0!16.8%
TOTAL MAYOR & COUNCIL581,507540,646-40,861629,793000#DIV/0!
POLICE SERVICE
Capital0000000#DIV/0!
Operations4,855,7454,617,743-238,0024,968,338000#DIV/0!
TOTAL POLICE SERVICE4,855,7454,617,743238,0024,968,338000#DIV/0!2.3%
LIBRARY SERVICE
Capital0000000#DIV/0!
Operations464,760360,282-104,478468,821000#DIV/0!
TOTAL LIBRARY SERVICE464,760360,282-104,478468,821000#DIV/0!0.9%
AIRPORT COMMISSION
Capital0000000#DIV/0!
Operations28,99021,163-7,82733,203000#DIV/0!
TOTAL AIRPORT COMMISSION28,99021,163-7,82733,203000#DIV/0!14.5%

TOWN OF SMITHS FALLS 2021 BUDGET

DEPARTMENTAL SUMMARY

January 18, 2021 ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
FIRE SERVICES
Capital Operations0000000#DIV/0!
Capital Operations1,059,2401,083,89324,6531,078,507000#DIV/0!
TOTAL FIRE SERVICE1,059,2401,083,89324,6531,078,507000#DIV/0!
TOTAL ADMINISTRATIONADMINISTRATION#DIV/0!
TOTAL ADMINISTRATION309,379304,921-4,458316,411000#DIV/0!
COUNTY SHARED SERVICES
TOTAL COUNTY SHARED SERVICES2,173,7212,169,021-4,7002,514,141000#DIV/0!
PARKS
Capital0000000#DIV/0!
Operations335,909323,716-12,193307,750000#DIV/0!
TOTAL PARKS335,909323,716-12,193307,750000#DIV/0!
COMMUNITY FACILITIES
Capital0000000#DIV/0!
Operations654,797833,541178,744757,604000#DIV/0!
TOTAL COMMUNITY FACILITIES654,797833,541178,744757,604000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

DEPARTMENTAL SUMMARY

January 18, 20212020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
HILLCREST CEMETERY
Capital Operations0000000#DIV/0!
Capital Operations50,10839,567-10,54149,637000#DIV/0!
TOTAL HILLCREST CEMETERY50,10839,567-10,54149,637000#DIV/0!
CHILD DEVELOPMENT CENTRE
Capital Operations0000000#DIV/0!
Capital Operations198,299102,932-95,367171,152000#DIV/0!
TOTAL CDC198,299102,932-95,367171,152000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

DEPARTMENTAL SUMMARY

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
WATER TREATMENT PLANT
Capital Operations (Now includes "I ranster to Capital Budget")0000000#DIV/0!
-200,732-200,7320-219,064000#DIV/0!
TOTAL WTP-200,732-200,7320-219,064000#DIV/0!
WATER POLLUTION CONTROL PLANT
Capital Operations (Now includes "Transfer to Capital Budget")0000000#DIV/0!
66,83766,836093,979000#DIV/0!
TOTAL WPCP66,83766,836093,979000#DIV/0!
PUBLIC WORKS & UTILITIES
Capital Operations0000000#DIV/0!
2,446,3642,182,991-263,3732,545,600000#DIV/0!
TOTAL WORKS & UTILITIES2,446,3642,182,991-263,3732,545,600000#DIV/0!
WATER DISTRIBUTION
Capital Operations0000000#DIV/0!
772,918772,9180786,957000#DIV/0!
TOTAL WATER DISTRIBUTION772,918772,9180786,957000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

DEPARTMENTAL SUMMARY

January 18, 20212020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
CORPORATE SERVICES; ADMINISTRATION
Capital Operations0000000#DIV/0!
Capital Operations968,7711,046,91078,1391,080,300000#DIV/0!
TOTAL ADMINISTRATIVE SERVICES968,7711,046,91078,1391,080,300000#DIV/0!
INFORMATION TECHNOLOGY
Capital Operations0000000#DIV/0!
Capital Operations193,852220,35526,503195,241000#DIV/0!
TOTAL INFORMATION TECHNOLOGY193,852220,35526,503195,241000#DIV/0!
11.5%$111,529
0.7%$1,389

DEPARTMENTAL SUMMARY

January 18, 20212020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
PLANNING SERVICES
Operational302,954231,089-71,865297,876000#DIV/0!
BUILDING SERVICES DEPARTMENT
Operational0000000#DIV/0!
BY-LAW ENFORCEMENT
Capital0000000#DIV/0!
Operations262,687186,410-76,277286,216000#DIV/0!
TOTAL BY-LAW ENFORCEMENT262,687186,410-76,277286,216000#DIV/0!
ENVIRONMENTAL SERVICES
Capital0000000#DIV/0!
Operations906,491812,171-94,320928,668000#DIV/0!
TOTAL ENVIRONMENTAL SERVICES906,491812,171-94,320928,668000#DIV/0!
-1.7%-$5,078
#DIV/0!$0
9.0%$23,529
2.4%$22,177

TOWN OF SMITHS FALLS 2021 BUDGET

DEPARTMENTAL SUMMARY

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
ECONOMIC DEVELOPMENT
Capital Operations0000000#DIV/0!
Capital Operations463,428435,831-27,597458,403000#DIV/0!
TOTAL COMMUNITY DEVELOPMENT463,428435,831-27,597458,403000#DIV/0!
TOURISM
Operations137,10680,978-56,128137,237000#DIV/0!
HISTORICAL SERVICES
Capital Operations0000000#DIV/0!
Capital Operations66,97859,209-7,76968,535000#DIV/0!
TOTAL HISTORICAL SERVICES66,97859,209-7,76968,535000#DIV/0!
DOWNTOWN BUSINESS ASSOCIATION
Operations0000000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

DEPARTMENTAL SUMMARY

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
TOTAL CAPITAL BUDGET0000000
TOTAL GENERAL BUDGET17,100,10816,292,391-807,71717,955,305000#DIV/0!5.0%
PRIOR YEAR DEFICIT/SURPLUS0000000
TOTAL BUDGET17,100,10816,292,391-807,71717,955,305000#DIV/0!
FINANCE - TOTAL REVENUE-18,829,023-18,594,518234,505-19,074,826000#DIV/0!0.4%
DEFICIT/SURPLUS-1,728,915-2,302,127-573,212-1,119,521000#DIV/0!
TRANSFER TO RESERVE (TAX-SUPPORTED) *1,728,9152,302,127573,2121,119,521000-35.2%
NET BALANCE0000000

LTFP Projected Transfer to Capital Reserve $2,801,534 (Transfer Capital $2,816,596)


TOWN OF SMITHS FALLS 2021 BUDGET

MAYOR/COUNCIL

GENERAL BUDGET

January 10, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ADMINISTRATION
6088-02-11-101-000 Honorarium154,227144,898-9,329154,8220#DIV/0!0.00%
6091-02-11-101-000 Other Payroll Costs9,2568,307-9499,2670#DIV/0!0.00%
6015-02-11-101-000 Travel Expense10,0002,535-7,4655,0000#DIV/0!0.00%
6032-02-11-101-000 Conferences/Training & Dev.10,0001,450-8,55010,0000#DIV/0!0.00%
6025-02-11-101-000 Transfer to/from reserve018,47418,47400#DIV/0!#DIV/0!
6102-02-11-101-000 Council Technology (Incl of Cell Phones & Ipads)2,0004,1522,1522,0000#DIV/0!0.00%
5908-02-11-101-020 Integrity Commissioner Applications-300030000#DIV/0!#DIV/0!
6180-02-11-101-000 Professional Fees5,0001,221-3,7795,0000#DIV/0!0.00%
6029-02-11-101-000 Memberships12,0006,606-5,39411,0000#DIV/0!0.00%
6034-02-11-101-000 Election Expense20,0001,526-18,47420,0000#DIV/0!0.00%
6863-02-11-101-000 Meeting Management25,00030,4525,45225,0000#DIV/0!0.00%
6037-02-11-101-000 Mayor & Council Public Relations5,5004,848-6525,0000#DIV/0!0.00%
6050-02-11-101-000 Employee Recognition8,000926-7,0748,0000#DIV/0!0.00%
TOTAL MAYOR & COUNCIL260,683225,395-35,288255,089000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET MAYOR & COUNCIL GENERAL BUDGET

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
COMMUNITY PROGRAMS/DONATIONS
02-21-250-397-6202 Furry Tales Cat Rescue04,9994,9990#DIV/0!
6406-02-21-250-001 Youth Services (Administered by the County)15,00016,2281,22815,0000#DIV/0!
02-21-250-001-6797 Drug Strategy Committee2,0002,00002,0000#DIV/0!
02-21-250-319-6797 Lanark County Drug Strategy Committee0000#DIV/0!
02-21-250-001-6798 Arts & Culture Council0000#DIV/0!
02-21-250-001-6799 Gordon Pipe Band02,8002,8000#DIV/0!
02-21-250-396-6202 Trinity United Church039,28139,2810#DIV/0!
02-21-250-001-6025 Transfer to Reserve0000#DIV/0!
02-21-250-001-xxxx Overall Community Donations140,0000-140,000140,0000#DIV/0!
02-21-250-001-6664 Hospital Donation *174,341174,3410174,3410#DIV/0!
02-21-250-001-6831 Horticultural Society06006000#DIV/0!
02-21-250-294-6038 Rideau Roundtable/Rideau Paddlefest08,5318,5310#DIV/0!
02-21-250-001-6756 Lanark Transportation09,5009,5008,4660#DIV/0!
02-21-250-001-5612 Transfer From Reserve (Surplus from 2020 Comm Don; $0.00)-45,414-45,0074070#DIV/0!
02-21-250-280-6202 Rise at the Falls Car Show05005000#DIV/0!
02-21-250-279-6202 Big Brothers/Big Sisters020,50020,5000#DIV/0!
02-21-250-008-6202 Big Brothers/Big Sisters (After School Program)0000#DIV/0!
02-21-250-412-6202 Rideau Lakes Amaeur Radio Club Inc.01,3821,3820#DIV/0!
02-21-250-282-6202 DBA Healthy Living Festival0000#DIV/0!
02-21-250-001-6226 SF Railway Musuem (2:1 Ratio; matching funds)020,00020,0000#DIV/0!
02-21-250-368-6202 Two Rivers Food Hub0000#DIV/0!
02-21-250-369-6202 Parkinson Canada024,00024,0000#DIV/0!
02-21-250-377-6202 Service Club Co-op0000#DIV/0!
6568-02-21-250-001 REAL Grant07,5007,5000#DIV/0!
02-21-250-370-6202 Smiths Falls Crimestoppers0000#DIV/0!
02-21-250-391-6202 Eastern Ontario Regional Network Cellular Gap & Capacity Exp Project (3 of 4 year commitment)13,89713,897013,8970#DIV/0!
6202-02-21-250-001 Special Events21,00012,924-8,07621,0000#DIV/0!
TOTAL PROGRAMS320,824313,976-6,848374,7040000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET INDEPENDENT BOARDS CAPITAL BUDGET

ACCOUNT/DESCRIPTION2020 Budget POLICE SERVICESVar.2021 Budget2021 To Date2021 ActualVar.% Var.Completed
6235-01-21-221-000 Police Cruisers50,00048,544-1,45654,0000#DIV/0!0.00%
01-21-221-000-6462 Firewall Upgrade00025,0000#DIV/0!0.00%
01-21-221-000-5612 Transfer from Reserve (PCO)000-25,0000#DIV/0!0.00%
01-21-221-000-6717 Phone System Upgrade00025,0000#DIV/0!0.00%
01-21-221-000-6600 Radio System154,576154,599230#DIV/0!#DIV/0!
01-21-221-309-5612 Trsf from Capital Reserve (Acct 2083)-229,576-228,1431,433-129,0000#DIV/0!0.00%
01-21-221-160-6398 NG 911 System25,0000-25,00050,0000#DIV/0!0.00%
TOTAL POLICE CAPITAL BUDGET0-25,000-25,0000000#DIV/0!#DIV/0!

EMERGENCY COMMUNICATION CENTRE

6401-02-21-221-160Annual System Maintenance23,00018,129-4,87123,0000#DIV/0!0.00%
6182-02-21-221-001CPIC Maintenance Costs1,7001,70001,7000#DIV/0!0.00%
6183-02-21-221-001OPTIC Maintenance Cost29,00025,184-3,81629,0000#DIV/0!0.00%
02-21-221-012-6714Computer Firewall Maintenance8,00010,7982,79810,0000#DIV/0!0.00%
02-21-221-297-6398Northern 911 (3rd party services)4,5004,358-1424,7000#DIV/0!0.00%
02-21-221-160-6398911 System Maintenance1,9000-1,9002,0000#DIV/0!0.00%
TOTAL COMMUNICATION CENTRE68,10060,169-7,93170,400000#DIV/0!0.00%

TOWN OF SMITHS FALLS

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

January 10, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
5430-02-21-221-020 Special Police Grant-48,750-48,7500-48,7500 #DIV/0!0.00%
5898-02-21-221-020 Court Security Grant-8,500-3,2995,201-8,5000 #DIV/0!0.00%
5513-02-21-221-020 Taxi Licenses-2,100-1,427673-2,1000 #DIV/0!0.00%
5517-02-21-221-020 Sale of Equipment-3,000-1,5991,401-3,0000 #DIV/0!0.00%
5525-02-21-221-020 Accident Reports-800-552248-8000 #DIV/0!0.00%
5571-02-21-221-020 CPIC Information Fees-9,000-6,0432,957-6,0000 #DIV/0!0.00%
5572-02-21-221-020 Fingerprinting Fees-600-311289-6000 #DIV/0!0.00%
5572-02-21-221-273 RCMP Fingerprinting Fees-1,500-4251,075-1,5000 #DIV/0!0.00%
6836-02-21-221-273 RCMP Fingerprinting Fees (Deferred Revenue)1,000700-3001,0000 #DIV/0!0.00%
02-21-221-388-5430 Civil Remedies Grant0-54,867-54,86700 #DIV/0!0.00%
02-21-221-388-6862 Civil Remedies Expenses030,21930,21900 #DIV/0!0.00%
02-21-221-388-6836 Civil Remedies Deferred Revenue024,64824,64800 #DIV/0!0.00%
5578-02-21-221-020 Escort Fees-3,000-16,579-13,579-3,0000 #DIV/0!0.00%
5660-02-21-221-020 Prisoner Meal Reimburse-400-38020-4000 #DIV/0!0.00%
02-21-221-389-5421 Ontario Grant (Cannabis Legalization Implementation)01,6001,60000 #DIV/0!0.00%
02-21-221-389-6015 Travel (Cannabis Legalization Implementation)00000 #DIV/0!0.00%
02-21-221-389-6028 Meals Expenses (Cannabis Legalization Implementation)00000 #DIV/0!0.00%
02-21-221-389-6039 Staff Training (Cannabis Legalization Implementation)00000 #DIV/0!0.00%
6035-02-21-221-001 Regular Salaries & Wages2,961,6522,886,482-75,1702,992,4690 #DIV/0!0.00%
6048-02-21-221-001 Part Time Wages154,85495,483-59,371163,7550 #DIV/0!0.00%
6057-02-21-221-001 Overtime95,000107,96512,96595,0000 #DIV/0!0.00%
6638-02-21-221-001 Banked Time Adjustment12,000547-11,45312,0000 #DIV/0!0.00%
6067-02-21-221-001 Shift Premium8,0006,125-1,8758,0000 #DIV/0!0.00%
6069-02-21-221-001 Stat Time14,00025,86711,86715,0000 #DIV/0!0.00%
6078-02-21-221-001 Vacation Pay9,0003,887-5,1136,6210 #DIV/0!0.00%
6091-02-21-221-001 Other Payroll Costs988,075956,506-31,5691,058,5970 #DIV/0!0.00%
6048-02-21-221-413 Part-time Wages (COVID-19)02,4182,41800 #DIV/0!0.00%
6057-02-21-221-413 Overtime (COVID-19)02,4992,49900 #DIV/0!0.00%
6078-02-21-221-413 Vacation Pay (COVID-19)0979700 #DIV/0!0.00%
6091-02-21-221-413 Other Payroll Costs (COVID-19)080280200 #DIV/0!0.00%
6792-02-21-221-413 Other Expenditures (COVID-19)04,7624,76200 #DIV/0!0.00%
5612-02-21-221-413 Trsf from Reserve (COVID-19)0-10,577-10,57700 #DIV/0!0.00%
5612/6025-02-21-221-001 Trsf to/from Reserve (Payroll & PCO)-25,00020,00045,000-45,0000 #DIV/0!0.00%
6011-02-21-221-001 Office Supplies10,0008,856-1,14410,0000 #DIV/0!0.00%
6015-02-21-221-001 Travel Expense15,000978-14,02215,0000 #DIV/0!0.00%
6017-02-21-221-001 Coffee/Food Supplies400238-1625000 #DIV/0!0.00%
6023-02-21-221-001 Postage1,200649-5511,2000 #DIV/0!0.00%
6028-02-21-221-001 Meals Expense6,5003,169-3,3316,5000 #DIV/0!0.00%
6029-02-21-221-001 Membership Fees2,8002,432-3683,0000 #DIV/0!0.00%
6038-02-21-221-001 Advertising1,5001,401-991,5000 #DIV/0!0.00%

TOWN OF SMITHS FALLS 2021 BUDGET INDEPENDENT BOARDS GENERAL BUDGET

January 16, 2021
20202020 Actual2021 Budget2021 To Date2021 Actual2021 Var.% Var.% Completed
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateVar.Var.Completed
6039-02-21-221-001 Staff Training & Develop.25,0001,772-23,22825,0000#DIV/0!0.00%
6040-02-21-221-001 Clothing & Supplies30,00030,21121130,0000#DIV/0!0.00%
6041-02-21-221-001 Drycleaning5000-5005000#DIV/0!0.00%
6042-02-21-221-001 Courier1,000382-6181,0000#DIV/0!0.00%
6054-02-21-221-001 Library in Service2,8002,9921922,8000#DIV/0!0.00%
6055-02-21-221-001 Community Services3,0000-3,0003,0000#DIV/0!0.00%
6056-02-21-221-001 Firearm Training14,00014,88488416,0000#DIV/0!0.00%
6102-02-21-221-001 Telephone **25,00024,618-38227,0000#DIV/0!0.00%
6103-02-21-221-001 Fax1,4001,487871,4000#DIV/0!0.00%
5430-02-21-221-418 CISO Grant0-8,000-8,00000#DIV/0!#DIV/0!
6862-02-21-221-418 CISO Grant Expenditures08,1358,135
6836-02-21-221-418 Trsf to/from Deferred Revenue (CISO Grant)0-1,952-1,952
6173-02-21-221-001 Insurance20,17518,771-1,40422,5250#DIV/0!0.00%
02-21-221-001-6713 Special Operations (New)10,0000-10,00000#DIV/0!#DIV/0!
6180-02-21-221-001 Professional Fees30,00016,200-13,80030,0000#DIV/0!0.00%
6738-02-21-221-001 IT Support17,00016,702-29827,5000#DIV/0!0.00%
6194-02-21-221-001 Computer Lease Contract20,00016,777-3,22320,0000#DIV/0!0.00%
6474-02-21-221-001 Laptop Computer Lease Contract6,0005,969-316,0000#DIV/0!0.00%
6027-02-21-221-001 Photocopy Lease6,0005,075-9256,0000#DIV/0!0.00%
TOTAL POLICE ACCOUNTING STRAITION1,200,0001,107,544100,0001,100,047220#DIV/0!
BUILDING MAINTENANCE
6117-02-21-221-010 Property Maintenance10,0007,647-2,35312,0000#DIV/0!0.00%
6123-02-21-221-010 Property Repairs12,0007,342-4,65815,0000#DIV/0!0.00%
02-21-221-010-6012 Principal110,898110,200-698115,5540#DIV/0!0.00%
02-21-221-010-6014 Interest81,97582,67269777,3180#DIV/0!0.00%
02-21-221-355-6012 Principal2,6442,638-62,7150#DIV/0!0.00%
02-21-221-355-6014 Interest1,3731,370-31,3020#DIV/0!0.00%
02-21-221-010-6105 Hydro23,00020,336-2,66421,1000#DIV/0!0.00%
02-21-221-010-6106 Water3,2553,299443,4000#DIV/0!0.00%
02-21-221-010-6107 Heating Fuel6,4876,7012148,1900#DIV/0!0.00%
02-21-221-010-6116 Janitorial Supplies4,0001,943-2,0574,0000#DIV/0!0.00%
02-21-221-010-6197 Janitorial Services25,00028,3943,39429,9680#DIV/0!0.00%
TOTAL BUILDING MAINTENANCE280,632272,542-8,090290,547000#DIV/0!

TOTAL BUILDING MAINTENANCE


TOWN OF SMITHS FALLS 2021 BUDGET INDEPENDENT BOARDS GENERAL BUDGET

January 18,2021 ACCOUNT/DESCRIPTION

6108-02-21-221-011 Gas & Oil 6110-02-21-221-011 Repairs 6194-02-21-211-011 Vehicle Lease Payments 6836-02-21-211-011 Trsf from Deferred Revenue 6118-02-21-221-011 Tools, Accessories, etc

TOTAL VEHICLE MAINTENANCE

6110-02-21-221-012 Equipment Repairs 6266-02-21-221-012 Breathalyser Repairs 6847-02-21-221-012 Live Scan Maintenance 6834-02-21-221-012 Wash Court Maintenance TOTAL EQUIPMENT MAINTENANCE

6267-02-21-221-022 Supplies 6112-02-21-221-022 Equipment Repairs

TOTAL IDENTIFICATION

5447-02-21-221-023 Arrive Alive Grant 6057-02-21-221-023 Overtime 6091-02-21-221-023 Other Payroll Costs

2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
VEHICLE MAINTENANCE
35,00022,125-12,87535,0000#DIV/0!0.00%
25,00018,051-6,94925,0000#DIV/0!0.00%
00000#DIV/0!#DIV/0!
00000#DIV/0!#DIV/0!
500206-2945000#DIV/0!0.00%
60,50040,382-20,11860,500000#DIV/0!
EQUIPMENT MAINTENANCE
10,0008,110-1,89010,0000#DIV/0!0.00%
1,000402-5981,0000#DIV/0!0.00%
5,5005,295-2055,8000#DIV/0!0.00%
7,2007,015-1857,5000#DIV/0!0.00%
23,70020,822-2,87824,300000#DIV/0!
IDENTIFICATION
1,5000-1,5001,5000#DIV/0!0.00%
5000-5005000#DIV/0!0.00%
2,0000-2,0002,000000#DIV/0!
-9,000-8,715285-9,0000#DIV/0!0.00%
9,0008,374-6269,0000#DIV/0!0.00%
5001,0895895000#DIV/0!0.00%
500748248500000#DIV/0!

TOTAL RIDE PROGRAM


TOWN OF SMITHS FALLS 2021 BUDGET

INDEPENDENT BOARDS GENERAL BUDGET

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
POLICE SERVICES BOARD
6088-02-21-222-001 Honorarium22,19819,978-2,22022,9410#DIV/0!0.00%
6091-02-21-222-001 Other Payroll Costs7091,3436347330#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-2002000#DIV/0!0.00%
6029-02-21-222-001 Membership Fees1,5001,551511,5000#DIV/0!0.00%
6032-02-21-222-001 Conferences2,000916-1,0842,0000#DIV/0!0.00%
6036-02-21-222-001 Public Relations2,0001,748-2522,0000#DIV/0!0.00%
6054-02-21-222-001 Library in Service00000#DIV/0!#DIV/0!
TOTAL POLICE COMMISSION30,10725,536-4,57130,874000#DIV/0!
TOTAL POLICE GENERAL BUDGET4,855,7454,617,743-238,0024,968,338000#DIV/0!
TOTAL POLICE SERVICES BUDGET4,855,7454,592,743-263,0024,968,338000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

INDEPENDENT BOARDS CAPITAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
SMITHS FALLS PUBLIC LIBRARY
01-21-231-000-6782 Building Renovations/Children's Dept.200,00012,841-187,159300,0000#DIV/0!
5612-01-21-231-000 Trsf from Reserve (Acct 2051)-153,800-12,841140,959-189,4820#DIV/0!
6392-01-21-231-000 Carpeting046,20046,2000#DIV/0!
01-21-231-000-6603 Air Conditioner Repairs0005,0000#DIV/0!
01-21-231-309-5612 Trsf from capital reserve (Acct 2083)-46,200-46,2000-140,5180#DIV/0!
01-21-231-000-6409 Eavestrough & Fascia Repairs00017,5000#DIV/0!
01-21-231-000-6641 Ceiling Repairs0007,5000#DIV/0!
TOTAL CAPITAL BUDGET0000000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET INDEPENDENT BOARDS GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
SMITHS FALLS PUBLIC LIBRARY ADMINISTRATION
5473-02-21-231-020 Ministry of Culture Grant-20,921-22,109-1,188-21,0000#DIV/0!0.00%
5517-02-21-231-020 Sale of Equipment-1,500-3651,135-1,5000#DIV/0!0.00%
5521-02-21-231-020 Photocopy Charges-3,200-1,3701,830-3,2000#DIV/0!0.00%
5580-02-21-231-020 Book Sales-400-177223-4000#DIV/0!0.00%
5553-02-21-231-020 Damages Recovery-500-71429-5000#DIV/0!0.00%
5555-02-21-231-020 Library Memberships-4,000-1,3912,609-2,0000#DIV/0!0.00%
5557-02-21-231-020 Donations0-988-98800#DIV/0!#DIV/0!
5661-02-21-231-020 Interlibrary Loan Revenue-50-700-650-500#DIV/0!0.00%
5662-02-21-231-020 Overdue Fines-2,000-2111,789-2,0000#DIV/0!0.00%
5664-02-21-231-020 Audiovisual Fees-1000100-1000#DIV/0!0.00%
5665-02-21-231-020 Genealogical Services-50050-500#DIV/0!0.00%
5711-02-21-231-020 Montague Township Fees-14,470-14,750-280-14,4700#DIV/0!0.00%
6792-02-21-231-413 COVID-19 Expenditures01,6921,69200#DIV/0!#DIV/0!
5557-02-21-231-013 Donations (Fundraising)00000#DIV/0!#DIV/0!
6046-02-21-231-013 Program Supplies (Fundraising)0626200#DIV/0!#DIV/0!
6025-02-21-231-001 Transfer to Reserve0-62-6200#DIV/0!#DIV/0!
6035-02-21-231-001 Regular Salaries & Wages219,080161,566-57,514179,9430#DIV/0!0.00%
6048-02-21-231-001 Part time Wages52,02652,1108497,8260#DIV/0!0.00%
6078-02-21-231-001 Vacation Pay2,7811,799-9824,6270#DIV/0!0.00%
6091-02-21-231-001 Other Payroll Costs76,13860,074-16,06472,4320#DIV/0!0.00%
6011-02-21-231-001 Office Supplies5,0002,057-2,9434,0000#DIV/0!0.00%
6019-02-21-231-001 Photocopy Supplies3,5002,263-1,2373,5000#DIV/0!0.00%
6023-02-21-231-001 Postage1,000265-7355000#DIV/0!0.00%
6029-02-21-231-001 Membership Fees1,425650-7751,4000#DIV/0!0.00%
6038-02-21-231-001 Advertising & Promotion9500-9509500#DIV/0!0.00%
6039-02-21-231-001 Staff Training & Develop.2,600346-2,2542,5000#DIV/0!0.00%
6102-02-21-231-001 Telephone1,6002,2976971,6000#DIV/0!0.00%
6112-02-21-231-001 Equipment Repairs5000-5005000#DIV/0!0.00%
6173-02-21-231-001 Insurance10,90011,19529510,9000#DIV/0!0.00%
6174-02-21-231-001 Audit Fees80080008000#DIV/0!0.00%

TOWN OF SMITHS FALLS 2021 BUDGET

January 18, 2021INDEPENDENT BOARDS GENERAL BUDGET
2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
6177-02-21-231-001 Computer Maintenance *7,0005,116-1,8847,0000#DIV/0!0.00%
6216-02-21-231-001 Copyright Licencing Fee162136-261600#DIV/0!0.00%
6031-02-21-231-001 Automation3,7001,006-2,6942,5000#DIV/0!0.00%
* New software
TOTAL ADMINISTRATION341,971261,240-80,731345,868000#DIV/0!
BUILDING MAINTENANCE
6105-02-21-231-010 Hydro4,1763,243-9334,1000#DIV/0!0.00%
6106-02-21-231-010 Water1,2251,197-281,2250#DIV/0!0.00%
6107-02-21-231-010 Heating Gas4,0003,871-1294,0000#DIV/0!0.00%
02-21-231-010-6012 Principal (Building Renovations)21,70821,708022,4060#DIV/0!0.00%
02-21-231-010-6014 Interest (Building Renovations)3,0933,09302,3940#DIV/0!0.00%
02-21-231-355-6012 Principal (Energy Audit)1,1701,192221,2260#DIV/0!0.00%
02-21-231-355-6014 Interest (Energy Audit)608619115520#DIV/0!0.00%
6110-02-21-231-010 Property Repairs13,90510,863-3,04216,0000#DIV/0!0.00%
6197-02-21-231-010 Janitorial Contract19,26615,714-3,55220,0000#DIV/0!0.00%
TOTAL BUILDING MAINTENANCE69,15161,500-7,65171,903000#DIV/0!
MATERIALS
6165-02-21-231-015 Books32,41621,835-10,58130,0000#DIV/0!0.00%
6166-02-21-231-015 Magazines1,7001,089-6111,7000#DIV/0!0.00%
6167-02-21-231-015 Newspapers1,3501,339-111,3500#DIV/0!0.00%
6168-02-21-231-015 Videos2,9001,169-1,7312,9000#DIV/0!0.00%
6169-02-21-231-015 Compact Discs00000#DIV/0!#DIV/0!
6170-02-21-231-015 Book Binding510-51500#DIV/0!0.00%
6171-02-21-231-015 Interlibrary Loan51172121500#DIV/0!0.00%
6829-02-21-231-015 Processing & Cataloging2,7751,964-8112,5000#DIV/0!0.00%
02-21-231-015-6651 Digital Resources7,3956,503-8927,5000#DIV/0!0.00%
TOTAL LIBRARY MATERIALS48,63834,071-14,56746,050000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

January 18, 2021INDEPENDENT BOARDS GENERAL BUDGET
2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
ACCOUNT/DESCRIPTION
SUMMER PROGRAM(086)/EARLY YEARS PROGRAM(157)
5424-02-21-231-086 Federal Grants0-2,176-2,1760#DIV/0!
5557-02-21-231-086 Donations0-3,250-3,2500#DIV/0!
6025-02-21-231-086 Transfer to/from Reserve04,8584,8580#DIV/0!
6011-02-21-231-086 Office Supplies0000#DIV/0!
6165-02-21-231-086 Books0000#DIV/0!
6169-02-21-231-086 Compact Discs0000#DIV/0!
6048-02-21-231-086 Part Time Wages *5,0003,461-1,5395,0000#DIV/0!
6078-02-21-231-086 Vacation Pay01361360#DIV/0!
6091-02-21-231-086 Other Payroll Costs03083080#DIV/0!
6184-02-21-231-086 Program Supplies01341340#DIV/0!
* Board request for Summer Children's Literacy Program TOTAL SUMMER PROGRAM5,0003,471-1,5295,000000#DIV/0!
COMMUNITY ACCESS PROGRAM
02-21-231-017-5424 Federal Grant0-200-20000#DIV/0!
5557-02-21-231-017 Donations00000#DIV/0!
5612/6025-02-21-231-017 Tsf to/from Reserve020020000#DIV/0!
6048-02-21-231-017 Part Time Wages00000#DIV/0!
6078-02-21-231-017 Vacation Pay00000#DIV/0!
6091-02-21-231-017 Benefits00000#DIV/0!
6112-02-21-231-017 Equipment00000#DIV/0!
0000000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

INDEPENDENT BOARDS GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ADOPT A BOOK PROGRAM
5557-02-21-231-019 Donations0-100-1000#DIV/0!#DIV/0!
6025-02-21-231-019 Tsf to/from Reserve01001000#DIV/0!#DIV/0!
6165-02-21-231-019 Books0000#DIV/0!#DIV/0!
TOTAL ADOPT A BOOK PROGRAM0000000#DIV/0!
MISC GRANTS
5421-02-21-231-163 Provincial Grant (in deferred revenue)00000#DIV/0!#DIV/0!
5421-02-21-231-245 Provincial Grant00000#DIV/0!#DIV/0!
6836-02-21-231-163 Trsf from Deferred Revenue00000#DIV/0!#DIV/0!
6836-02-21-231-245 Trsf to/from Deferred Revenue00000#DIV/0!#DIV/0!
6046-02-21-231-245 Program Supplies00000#DIV/0!#DIV/0!
6738-02-21-231-163 IT Support00000#DIV/0!#DIV/0!
6739-02-21-231-163 Partner Share00000#DIV/0!#DIV/0!
6836-02-21-231-278 Trsf to/from Deferred Revenue ("Read with me"; Childhood Literacy Program)00000#DIV/0!#DIV/0!
6048-02-21-231-278 Part-time Wages00000#DIV/0!#DIV/0!
6078-02-21-231-278 Vacation00000#DIV/0!#DIV/0!
6091-02-21-231-278 Other Benefits00000#DIV/0!#DIV/0!
6046-02-21-231-278 Program Supplies00000#DIV/0!#DIV/0!
6836-02-21-231-278 Trsf to/from Deferred Revenue00000#DIV/0!#DIV/0!
TOTAL IT PROJECT0000000#DIV/0!#DIV/0!
TOTAL LIBRARY GENERAL BUDGET464,760360,282-104,478468,821000#DIV/0!
TOTAL LIBRARY BUDGET464,760360,282-104,478468,821000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

INDEPENDENT BOARDS CAPITAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 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,642-6,35815,0000#DIV/0!0.00%
5711-01-31-330-000 Montague Tsp Fees-5,869-5,057812-3,7500#DIV/0!0.00%
01-31-330-000-6049 Drainage @Old Club House10,0000-10,0000#DIV/0!#DIV/0!
6319-01-31-330-000 Airport Security *0005,0000#DIV/0!0.00%
6808-01-31-330-400 Fuel System Safety Upgrades03,0813,0810#DIV/0!#DIV/0!
6722-01-31-330-000 Airport Beacon Replacement5,5006,8691,3690#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-17,606-15,1722,434-11,2500#DIV/0!0.00%
01-31-330-000-6100 Runway Loading2,9752,961-140#DIV/0!#DIV/0!
01-31-330-000-5612 Transfer from Reserve (Acct 2051)-10,000-1,3248,676-5,000
TOTAL AIRPORT CAPITAL0000000#DIV/0!

*Full amount in reserve; 25% Montague portion paid


TOWN OF SMITHS FALLS 2021 BUDGET

INDEPENDENT BOARDS GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
AIRPORT
5711-02-31-330-020 Montague Twp Fees-9,663-7,0542,609-11,0680#DIV/0!0.00%
6029-02-31-330-001 Membership Fees4350-4354350#DIV/0!0.00%
6032-02-31-330-001 Conferences2,5000-2,5002,5000#DIV/0!0.00%
6105-02-31-330-001 Utilities5,0003,605-1,3954,5000#DIV/0!0.00%
6108-02-31-330-001 Fuel4,5002,834-1,6664,5000#DIV/0!0.00%
6012-02-31-330-001 Annual Repayment (Fuel Tanks) 15,0005,00005,0000#DIV/0!0.00%
6112-02-31-330-001 Equipment Repairs4,0004,1271276,0000#DIV/0!0.00%
6123-02-31-330-001 Property Repairs3,500983-2,5174,0000#DIV/0!0.00%
6289-02-31-330-001 Mowing & Brushing7,0006,706-2947,0000#DIV/0!0.00%
6173-02-31-330-001 Insurance2,9183,7808624,5360#DIV/0!0.00%
6200-02-31-330-001 Snow Removal Contract0002,0000#DIV/0!0.00%
6201-02-31-330-001 Airport Maintenance1,3001,182-1181,3000#DIV/0!0.00%
6025-02-31-330-001 Transfer to Reserve (Account 2064)2,5000-2,5002,5000#DIV/0!0.00%
TOTAL AIRPORT GENERAL28,99021,163-7,82733,203000#DIV/0!
  • Adjust receivable on annual basis for Montague's portion (G/L account 02-41-101-102-1074)

TOWN OF SMITHS FALLS 2021 BUDGET

DEPARTMENTAL CAPITAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
FIRE SERVICES
6095-01-21-211-000 Extrication Equipment45,0000-45,00045,0000#DIV/0!0.00%
6598-01-21-211-000 SCBA Equipment150,000152,5152,51520,0000#DIV/0!0.00%
01-21-211-283-6808 Personal Protective Equipment28,00012,237-15,7630#DIV/0!#DIV/0!
01-21-211-357-6808 CAD6,6862,889-3,7972,7970#DIV/0!0.00%
01-21-211-284-6808 Haz Mat Equipment5,0000-5,0005,0000#DIV/0!0.00%
01-21-211-356-6808 Water Rescue Equipment3,0000-3,00021,0000#DIV/0!0.00%
01-21-211-309-5612 Trsf from Capital Reserve (Acct 2083)-528,091-506,94921,142-183,2700#DIV/0!0.00%
01-21-211-000-6478 Tanker Truck350,740318,611-32,129131,2700#DIV/0!0.00%
01-21-211-000-5612 Transfer from Reserve (Account 2051/2080)-100,335-41,96158,374-86,7970#DIV/0!0.00%
01-21-211-160-6398 Dispatch Command Centre; 911 Upgrade25,0000-25,00025,0000#DIV/0!0.00%
01-21-211-247-6322 Hoses/Nozzles15,00017,6582,65820,0000#DIV/0!0.00%
TOTAL FIRE SERVICES CAPITAL0-45,000-45,0000000#DIV/0!

TOTAL FIRE SERVICES CAPITAL

EMERGENCY COMMUNICATION CENTRE & EMERGENCY PREPAREDNESS

6401-02-21-211-160 Annual System Maintenance21,00019,969-1,03121,0000#DIV/0!0.00%
6452-02-21-211-160 Digitalized Mapping15,00012,463-2,53715,0000#DIV/0!0.00%
5905-02-21-211-160 Fire Marque Revenue-14,00021,57735,577-14,0000#DIV/0!0.00%
6025-02-21-211-160 Fire Marque Revenue (Trsf to Fire Dept Reserve)14,000-21,577-35,57714,0000#DIV/0!0.00%
5853-02-21-211-160 Dispatch Revenue-349,926-270,57079,356-374,0000#DIV/0!0.00%
6039-02-21-211-264 Staff Training (Emergency Preparedness)7000-7007000#DIV/0!0.00%
6046-02-21-211-264 Materials & Supplies (Emergency Preparedness)5,0001,019-3,9815,0000#DIV/0!0.00%
6015-02-21-211-264 Travel (Emergency Preparedness)9000-9001000#DIV/0!0.00%
6792-02-21-211-413 COVID-19 (Emergency Response)011,32311,32310,0000#DIV/0!0.00%
TOTAL COMMUNICATION CENTRE-307,326-225,79681,530-322,20000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

DEPARTMENTAL GENERAL BUDGET
ACCOUNT/DESCRIPTION2020 Budget2020 Actual2021 Var.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
FIRE SERVICES; ADMINISTRATION
5523-02-21-211-020 Fire Certificates-900-789111-9000 #DIV/0!0.00%
5524-02-21-211-020 Fire Calls - Other Munic.-78,500-80,369-1,869-80,0000 #DIV/0!0.00%
5529-02-21-211-020 Permit Fees-1,500-1,155345-1,2000 #DIV/0!0.00%
5556-02-21-211-020 Misc Fees-4,000-4,100-100-5000 #DIV/0!0.00%
6035-02-21-211-001 Regular Salaries & Wages677,672660,020-17,652722,0950 #DIV/0!0.00%
6053-02-21-211-001 Volunteer Fire Fighters125,307125,3070127,8130 #DIV/0!0.00%
6057-02-21-211-001 Overtime55,00086,86731,86745,0000 #DIV/0!0.00%
6061-02-21-211-001 Overtime Training25,00012,152-12,84820,0000 #DIV/0!0.00%
6069-02-21-211-001 Stat Time6,6004,107-2,4936,6000 #DIV/0!0.00%
6090-02-21-211-001 Acting Pay20080-1202000 #DIV/0!0.00%
6091-02-21-211-001 Other Payroll Costs218,124217,551-573215,7850 #DIV/0!0.00%
6025-02-21-211-001 Transfer to Payroll Reserve (Surplus from Group Benefits)02,4142,41400 #DIV/0!#DIV/0!
6011-02-21-211-001 Office Supplies1,2001,179-211,2000 #DIV/0!0.00%
6012-02-21-211-247 Loan Principal (Ladder Truck)59,45259,421-3161,6160 #DIV/0!0.00%
6014-02-21-211-247 Loan Interest (Ladder Truck)34,16134,1923131,9970 #DIV/0!0.00%
6015-02-21-211-001 Travel Expense600335-2655000 #DIV/0!0.00%
6017-02-21-211-001 Coffee/Food Supplies1,5001,049-4511,5000 #DIV/0!0.00%
6019-02-21-211-001 Photocopy Supplies1,6001,7921921,5000 #DIV/0!0.00%
6023-02-21-211-001 Postage30059-2412000 #DIV/0!0.00%
6029-02-21-211-001 Membership Fees1,8003,3091,5092,0000 #DIV/0!0.00%
6032-02-21-211-001 Conferences3,200506-2,6943,2000 #DIV/0!0.00%
6038-02-21-211-001 Advertising1,5001,326-1741,5000 #DIV/0!0.00%
6039-02-21-211-001 Staff Training & Develop.14,7005,186-9,51412,0000 #DIV/0!0.00%
6040-02-21-211-001 Clothing Supplies8,5003,290-5,2108,5000 #DIV/0!0.00%
6040-02-21-211-256 Personal Protective Clothing1,4001,046-3545,0000 #DIV/0!0.00%
6041-02-21-211-001 Turnout Gear Cleaning *3,5002,997-5033,5000 #DIV/0!0.00%
6042-02-21-211-001 Courier25044-2061000 #DIV/0!0.00%
6102-02-21-211-001 Telephone14,00017,2463,24614,0000 #DIV/0!0.00%
6659-02-21-211-001 Communication12,0005,934-6,06612,0000 #DIV/0!0.00%
6173-02-21-211-001 Insurance8,3007,917-3839,5010 #DIV/0!0.00%
6180-02-21-211-001 Legal/Consulting Fees9,00034,67625,6769,0000 #DIV/0!0.00%
6219-02-21-211-001 Fire Prevention5,0000-5,0005,0000 #DIV/0!0.00%
TOTAL FIRE ADMINISTRATION1,204,9661,203,589-1,3771,238,7070000 #DIV/0!

2021 BUDGET PAGE 25

DEPARTMENTAL GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
BUILDING MAINTENANCE
6116-02-21-211-010 Janitorial Supplies1,000817-1831,0000#DIV/0!0.00%
6322-02-21-211-010 Medical Equipment/Services3,700431-3,2693,7000#DIV/0!0.00%
6118-02-21-211-010 Tools, Accessories, etc17,8003,610-14,19017,8000#DIV/0!0.00%
6123-02-21-211-010 Property Repairs **15,00015,45145112,0000#DIV/0!0.00%
6199-02-21-211-010 Hydrant Rentals *63,00063,34134163,0000#DIV/0!0.00%
* Inc. of 1.5% as per LTFP ** Repairs to the former Police station
100,50083,650-16,85097,500000#DIV/0!
VEHICLE MAINTENANCE
6108-02-21-211-258 Gas & Oil (Pumper 820) FA 7-00021,7001,341-3591,7000#DIV/0!0.00%
6110-02-21-211-258 Repairs (Pumper 820) FA 7-00024,0004,2012014,0000#DIV/0!0.00%
6108-02-21-211-259 Gas & Oil (Tanker 830) FA 7-0003500299-2015000#DIV/0!0.00%
6110-02-21-211-259 Repairs (Tanker 830) FA 7-00033,0001,951-1,0493,0000#DIV/0!0.00%
6108-02-21-211-260 Gas & Oil (Aerial 810) FA 7-00561,800982-8181,8000#DIV/0!0.00%
6110-02-21-211-260 Repairs (Aerial 810) FA 7-005615,00013,894-1,10615,0000#DIV/0!0.00%
6108-02-21-211-261 Gas & Oil (Truck 870) FA 7-00062,800714-2,0862,8000#DIV/0!0.00%
6110-02-21-211-261 Repairs (Truck 870) FA 7-00062,700326-2,3742,7000#DIV/0!0.00%
6108-02-21-211-417 Gas & Oil (Pumper 821)0001,7000#DIV/0!0.00%
6110-02-21-211-417 Repairs (Pumper 821)0001,7000#DIV/0!0.00%
6108-02-21-211-263 Gas & Oil (Rescue 840) FA 7-0001600398-2026000#DIV/0!0.00%
6110-02-21-211-263 Repairs (Rescue 840) FA 7-00015,0001,197-3,8035,0000#DIV/0!0.00%
TOTAL VEHICLE MAINTENANCE37,10025,303-11,79740,500000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

DEPARTMENTAL GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 Actual EQUIPMENT MAINTENANCE2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2020 BudgetVar.5,0002021 Budget2021 To Date2021 ActualVar.% Var.% Completed
6110-02-21-211-012 Equipment Repairs5,0004,947-535,0000#DIV/0!0.00%
6119-02-21-211-012 Radio & Pager Repairs5,0004,024-9765,0000#DIV/0!0.00%
6120-02-21-211-012 SCBA Repairs *10,0000-10,00010,0000#DIV/0!0.00%
6122-02-21-211-012 Chemicals4,00087-3,9134,0000#DIV/0!0.00%
TOTAL EQUIPMENT MAINTENANCE24,0009,058-14,94224,000000#DIV/0!
ACCOUNT/DESCRIPTION2020 Budget2020 Actual2021 Var.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTION2020 Budget2021 Budget-558-5580#DIV/0!#DIV/0!
5557-02-21-211-013 Donations0-30-300#DIV/0!#DIV/0!
6140-02-21-211-013 Smoke Detectors0-558-5580#DIV/0!#DIV/0!
TOTAL FUNDRAISING ACTIVITIES0-588-5880000#DIV/0!
TOTAL FIRE SERVICES GENERAL1,059,2401,095,21635,9761,078,507000#DIV/0!
TOTAL FIRE SERVICES BUDGET1,059,2401,050,216-9,0241,078,507000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

COMMUNITY SERVICES GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ADMINISTRATION
6035-02-21-101-001 Regular Salaries & Wages211,215210,392-823218,5260#DIV/0!0.00%
6091-02-21-101-001 Other Payroll Costs75,50473,175-2,32975,9840#DIV/0!0.00%
6011-02-21-101-001 Office Supplies2,0002,1701701,5000#DIV/0!0.00%
6019-02-21-101-001 Photocopy Supplies1,400495-9051,2000#DIV/0!0.00%
6023-02-21-101-001 Postage10057-43500#DIV/0!0.00%
6029-02-21-101-001 Membership Fees5001,0575571,0000#DIV/0!0.00%
6038-02-21-101-001 Advertising1,000328-6721,0000#DIV/0!0.00%
6039-02-21-101-001 Staff Training & Develop.3,000852-2,14800#DIV/0!#DIV/0!
6042-02-21-101-001 Courier0131300#DIV/0!#DIV/0!
6173-02-21-101-001 Insurance13,56013,375-18516,0510#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,0003,0072,0071,0000#DIV/0!0.00%
6279-02-21-101-001 Trophies/Awards1000-1001000#DIV/0!0.00%
TOTAL ADMINISTRATION309,379304,921-4,458316,411000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

COMMUNITY SERVICES DEPARTMENTAL GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
COUNTY SHARED SERVICES
02-21-201-002-6196 AMBULANCE490,000417,264-72,736509,7500#DIV/0!
02-21-201-003-6196 LL&G DISTRICT HEALTH UNIT177,155177,1550177,1550#DIV/0!
02-21-201-004-6231 ODSP/OW NET COST659,566549,180-110,386698,2360#DIV/0!
02-21-201-007-6231 LANARK LODGE400,000530,852130,852545,0000#DIV/0!
02-21-201-009-6231 SOCIAL HOUSING447,000494,57047,570584,0000#DIV/0!
TOTAL COUNTY SHARED SERVICES2,173,7212,169,021-4,7002,514,141000#DIV/0!

Note: The 1st draft is based on 2020 budget figures; subject to change

Emailed County November 13,2020 for update on when these would be available.

Send follow-up email on November 17,2020 and rec'd their first draft

Increase of $340,420


TOWN OF SMITHS FALLS 2021 BUDGET COMMUNITY SERVICES CAPITAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
PARKS DEVELOPMENT
6822-01-21-230-000 Cameras (CC parking lot/Victoria Park/Conf Park)20,00017,998-2,0022,0020#DIV/0!0.00%
6622-01-21-234-149 3/4 Ton Truck (x 2)35,84631,316-4,53070,0000#DIV/0!0.00%
6669-01-21-234-149 Centennial Park Fountain Repairs0000#DIV/0!#DIV/0!
01-21-234-241-6805 Pedestrian Bridges8,5488,574260#DIV/0!#DIV/0!
01-21-230-000-6814 Light/Light Pole Replacements25,0000-25,00025,0000#DIV/0!0.00%
01-21-230-000-6786 Shelters for Dog Park00030,0000#DIV/0!0.00%
01-21-234-290-6533 Lower Reach Park Enhancements16,1150-16,1150#DIV/0!#DIV/0!
01-21-234-309-5612 Trsf from Capital Reserve (Acct 2083)-100,778-71,28829,490-293,8850#DIV/0!0.00%
01-21-234-364-6533 Multi-Use Trail (Beckwith to Lower Reach Park)30,1870-30,18730,2580#DIV/0!0.00%
01-21-230-207-6049 Sprinkler System/Centennial Park20,0005,088-14,91214,9120#DIV/0!0.00%
01-21-234-364-6836 Trsf to/from Deferred Revenue (OMCC Grant Reserve)-19,343019,343-25,5560#DIV/0!0.00%
01-21-230-000-6670 Illuminate the falls & install unique lighting features00035,0000#DIV/0!0.00%
01-21-230-000-6025 Transfer to Reserve047,77947,7790#DIV/0!#DIV/0!
01-21-230-419-6808 Automated Timers for Outdoor Lights00095,0000#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 Improvements25,0005,485-19,51519,5150#DIV/0!0.00%
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,0000-30,00030,0000#DIV/0!0.00%
01-21-230-207-6070 Sprinkler System/Centennial Park0000#DIV/0!#DIV/0!
01-21-230-000-6412 Park Building/Storage Replacements20,0000-20,0000#DIV/0!#DIV/0!
01-21-230-000-5612 Transfer from Reserve (Acct 2051 & 2080)-225,575-46,090179,485-246,1080#DIV/0!0.00%
01-21-234-254-6110 Tennis Court Resurfacing0000#DIV/0!#DIV/0!
01-21-230-122-6808 Basketball Court Renovation75,0001,138-73,86273,8620#DIV/0!0.00%
01-21-230-196-6049 Drains (Victoria Park Pump Out)0000#DIV/0!#DIV/0!
01-21-230-001-6588 Parks & Rec Master Plan40,0000-40,00040,0000#DIV/0!0.00%
01-21-230-000-6234 Playground Equipment Replacement000100,0000#DIV/0!0.00%
* Originally on Eng worksheet; Troy asked that it be reallocated TOTAL LOWER REACH
TREE REPLACEMENT PROGRAM
5612-01-21-232-309 Transfer from Capital Reserve-20,000-4,38715,613-4,3870#DIV/0!0.00%
5612-01-21-232-000 Transfer from Reserve (PCO)-15,613
6009-01-21-232-000 Tree Replacement20,0004,387-15,61320,0000#DIV/0!0.00%
TOTAL TREE REPLACEMENT
00000000#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


TOWN OF SMITHS FALLS 2021 COMMUNITY SERVICES GENERAL BUDGET PARKS

January 18, 2021
20202020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ACCOUNT/DESCRIPTIONBudgetActualVar.00#DIV/0!#DIV/0!
5575-02-21-230-020 Victoria Park; Lease Payment-10,000-7,6002,40000#DIV/0!#DIV/0!
5556-02-21-230-020 Misc Revenue0-30-3000#DIV/0!#DIV/0!
6792-02-21-230-413 COVID-19 Expenditures014,39914,39900#DIV/0!#DIV/0!
6025-02-21-230-001 Transfer to Reserve00000#DIV/0!#DIV/0!
6035-02-21-230-001 Regular Salaries & Wages133,221123,501-9,720133,6890#DIV/0!0.00%
6048-02-21-230-001 Part Time Wages23,32414,696-8,6288,5470#DIV/0!0.00%
6057-02-21-230-001 Overtime3,0001,409-1,5913,0000#DIV/0!0.00%
6078-02-21-230-001 Vacation Pay9331,7828493420#DIV/0!0.00%
6091-02-21-230-001 Other Payroll Costs46,13131,750-14,38144,7150#DIV/0!0.00%
6143-02-230-051-6143 Federal Park Lease0005090#DIV/0!0.00%
6039-02-21-230-001 Staff Training1,500343-1,1571,5000#DIV/0!0.00%
6040-02-21-230-001 Clothing & Supplies4,0002,064-1,9362,5000#DIV/0!0.00%
6102-02-21-230-001 Telephone1,0001,042421,0000#DIV/0!0.00%
6105-02-21-230-196 Victoria Park; Hydro4,0001,026-2,9746000#DIV/0!0.00%
6106-02-21-230-196 Victoria Park; Water5000-50000#DIV/0!#DIV/0!
6123-02-21-230-196 Victoria Park; Property Repairs50050-45000#DIV/0!#DIV/0!
6173-02-21-230-196 Victoria Park; Insurance4,5004,9154155,8980#DIV/0!0.00%
6105-02-21-230-051 Hydro6,0007,7701,7704,5000#DIV/0!0.00%
6106-02-21-230-051 Water25,00022,429-2,57122,0000#DIV/0!0.00%
6116-02-21-230-051 Janitorial Supplies1,0001,2252258000#DIV/0!0.00%
6123-02-21-230-051 Property Repairs30,00026,630-3,37030,0000#DIV/0!0.00%
6197-02-21-230-051 Janitorial Services7,30026,79519,4955,0000#DIV/0!0.00%
6142-02-21-230-051 Shrubbery30,00035,0275,02725,0000#DIV/0!0.00%
6108-02-21-230-011 Vehicle Gas & Oil4,50010,0845,5844,0000#DIV/0!0.00%
6110-02-21-230-011 Vehicle Repairs2,500745-1,7552,5000#DIV/0!0.00%
6128-02-21-230-011 Vehicle Licences4005061064000#DIV/0!0.00%
6110-02-21-230-012 Equipment Repairs4,0001,360-2,6404,0000#DIV/0!0.00%
6115-02-21-230-012 Equipment Rental8,0000-8,0004,0000#DIV/0!0.00%
5554-02-21-230-343 Rental Revenue (Sports Field) *-12,000-74211,258-12,0000#DIV/0!0.00%
6105-02-21-230-343 Hydro (Sports Field) *400485854000#DIV/0!0.00%
6122-02-21-230-343 Chemicals, Etc. (Sports Field) *2,0001,299-7011,0000#DIV/0!0.00%
6123-02-21-230-343 Property Repairs (Sports Field) *10,0000-10,00010,0000#DIV/0!0.00%
6108-02-21-230-343 Equipment Gas & Oil (Sports Field) *1,200187-1,0138500#DIV/0!0.00%
6110-02-21-230-343 Equipment Repairs (Sports Field) *3,0000-3,0003,0000#DIV/0!0.00%
TOTAL PARKS GENERAL335,909323,716-12,762307,750000#DIV/0!
TOTAL PARKS BUDGET335,909323,716-12,762307,750000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET COMMUNITY SERVICES CAPITAL BUDGET

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
COMMUNITY FACILITIES MUNICIPAL COMPLEX
6753-01-21-240-000 Complex Renovations; Phase 3000344,8440#DIV/0!0.00%
6574-01-21-240-000 Complex Renovations; Cust Serv; Phase II3,266,7123,101,049-165,6630#DIV/0!#DIV/0!
6574-01-21-240-359 Town Square/Band Shell01,8171,817275,0260#DIV/0!0.00%
6354-01-21-240-000 HVAC (Fire Dispatch)00010,0000#DIV/0!0.00%
01-21-240-000-5421 COVID ICIP Resilience Funding (Pending)000-175,2050#DIV/0!0.00%
01-21-240-000-6446 Storage Solutions0005,0000#DIV/0!0.00%
01-21-240-000-5612 Transfer from Reserve (Acct 2051/2269)-1,638,838-1,268,993369,845-99,8210#DIV/0!#REF!
01-21-240-309-5612 Trsf from Capital Reserve (Acct 2083)-522,204-728,203-205,999-170,0000#DIV/0!0.00%
01-21-240-420-6808 Window Coverings/Blinds00040,0000#DIV/0!0.00%
01-21-240-000-5852 Capital Financing-1,105,670-1,105,6700-229,8440#DIV/0!0.00%
01-21-240-000-5869 Federal Gas Tax0000#DIV/0!#DIV/0!
TOTAL MUNICIPAL COMPLEX0000000#DIV/0!

MEMORIAL COMMUNITY/YOUTH CENTRE ARENA/OTHER FACILITIES

MEMORIAL COMMUNITY/YOUTH CENTRE ARENA/OTHER FACILITIES
01-21-241-421-6808 FOB Access (CC)00050,0000#DIV/0!0.00%
01-21-241-000-5612 Trsf from Reserve (Acct 2051)-32,554-33,494-9400#DIV/0!#DIV/0!
01-21-241-000-6324 Furniture32,55434,0911,5370#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)0-597-597-50,0000#DIV/0!0.00%
01-21-241-355-5615/5852 Unfinanced/Financed Capital Financing0000#DIV/0!#DIV/0!
01-21-241-355-6808 Energy Audit Projects0000#DIV/0!#DIV/0!
01-21-241-000-6025 Transfer to Reserve0000#DIV/0!#DIV/0!
TOTAL ARENAS00000000#DIV/0!
TOTAL COMMUNITY FACILITIES CAPITAL00000000#DIV/0!

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

January 10, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 Actual MUNICIPAL COMPLEXVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
6102-02-21-240-001 Telephone21,80014,922-6,87821,8000#DIV/0!0.00%
6792-02-21-240-413 COVID-19 Expenditures06,4866,48600#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 - Principal52,91852,848-70154,8090#DIV/0!0.00%
6014-02-21-240-001 Renovations - Interest7,5447,6147028,6300#DIV/0!0.00%
6105-02-21-240-010 Hydro - Complex28,00049,22621,22628,0000#DIV/0!0.00%
6106-02-21-240-010 Water - Complex10,00010,0828210,0000#DIV/0!0.00%
6107-02-21-240-010 Heating Gas - Complex17,00015,898-1,10217,0000#DIV/0!0.00%
6116-02-21-240-010 Janitorial Supplies2,5004,0891,5894,0000#DIV/0!0.00%
6123-02-21-240-010 Property/Lawn Repairs18,00025,5857,58518,0000#DIV/0!0.00%
6173-02-21-240-010 Insurance1,2351,24271,4900#DIV/0!0.00%
6180-02-21-240-010 Professional Fees5,0000-5,00000#DIV/0!#DIV/0!
6197-02-21-240-010 Janitorial Service48,23439,138-9,09648,0000#DIV/0!0.00%
TOTAL MUNICIPAL COMPLEX213,731227,13013,399333,229000#DIV/0!
STATION THEATRE PROJECT
5575-02-41-420-074 Lease Income-10,000-6,0673,933-10,0000#DIV/0!0.00%
6012-02-41-420-074 Principal (Re-pointing)12,56412,172-39212,5640#DIV/0!0.00%
6014-02-41-420-074 Interest (Re-pointing)1,3431,7343911,3430#DIV/0!0.00%
6105-02-41-420-074 Hydro3,5003,383-1173,5000#DIV/0!0.00%
6106-02-41-420-074 Water1,200931-2691,2000#DIV/0!0.00%
6107-02-41-420-074 Heating Fuel7,0006,001-9997,0000#DIV/0!0.00%
6123-02-41-420-074 Property Repairs6,5001,787-4,7136,5000#DIV/0!0.00%
6301-02-41-420-074 Municipal Taxes10,0008,318-1,68210,0000#DIV/0!0.00%
6213-02-41-420-074 CP Lease1,5330-1,5331,5500#DIV/0!0.00%
6197-02-41-420-074 Janitorial Service ("new" VIA Station) *7,2685,547-1,7217,5000#DIV/0!0.00%
6116-02-41-420-074 Janitorial Supplies ("new" VIA Station) *5800-5805000#DIV/0!0.00%
6384-02-41-420-074 Winter Maintenance ("new" VIA Station) *32,00029,002-2,99829,0020#DIV/0!0.00%
TOTAL VIA/THEATRE PROJECT73,48862,808-10,68070,659000#DIV/0!

TOWN OF SMITHS FALLS 2021 COMMUNITY SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
COMMUNITY FACILITIES/MEMORIAL COMMUNITY CENTRE ARENA
5547-02-21-241-020 Board & Bulkhead Advertising-10,000-7779,223-10,0000#DIV/0!0.00%
5548-02-21-241-020 Ice Rental-512,000-289,562222,438-500,0000#DIV/0!0.00%
5549-02-21-241-020 Floor Rental-20,000-73519,265-20,0000#DIV/0!0.00%
02-21-241-020-5566 Hall Rental-9,500-3,3616,139-9,5000#DIV/0!0.00%
5711-02-21-241-020 Township Fees-249,320-216,42932,891-249,3200#DIV/0!0.00%
6025-02-21-241-001 Transfer to Arena Building Reserve (Accl 2181)12,66312,663012,6630#DIV/0!0.00%
5612-02-21-241-000-5612 Transfer from Reserve0-407-40700#DIV/0!#DIV/0!
6035-02-21-241-001 Regular Salaries & Wages247,410208,093-39,317248,2790#DIV/0!0.00%
6048-02-21-241-001 Part Time Wages43,31626,176-17,14015,8720#DIV/0!0.00%
6057-02-21-241-001 Overtime8,0004,252-3,7483,0000#DIV/0!0.00%
6078-02-21-241-001 Vacation Pay1,7333,2041,4716350#DIV/0!0.00%
6067-02-21-241-001 Shift Premium1,500500-1,0001,5000#DIV/0!0.00%
6091-02-21-241-001 Other Payroll Costs85,67194,0438,37281,1570#DIV/0!0.00%
5557-02-21-241-275 Donations (Gerry Lowe Foundation)0-5,360-5,36000#DIV/0!#DIV/0!
6836-02-21-241-275 Deferred Revenue (Gerry Lowe Foundation)05,3605,36000#DIV/0!#DIV/0!
6011-02-21-241-001 Office Supplies8001,9581,1581,0000#DIV/0!0.00%
6012-02-21-241-001 New Arena - Principal148,799148,293-506155,5270#DIV/0!0.00%
6014-02-21-241-001 New Arena - Interest152,545153,051506145,8170#DIV/0!0.00%
6012-02-21-241-355 Principal (Energy Audit)24,21924,213-624,9290#DIV/0!0.00%
6014-02-21-241-355 Interest (Energy Audit)12,57912,578-111,8690#DIV/0!0.00%
6038-02-21-241-001 Advertising1,2001,4402401,2000#DIV/0!0.00%
6040-02-21-241-001 Clothing & Supplies3,5001,536-1,9643,0000#DIV/0!0.00%
6102-02-21-241-001 Telephone/Internet10,00018,2338,23318,0000#DIV/0!0.00%
6173-02-21-241-001 Insurance29,69029,79910935,7580#DIV/0!0.00%
6180-02-21-241-001 Professional Fees2,00015,58813,5882,0000#DIV/0!0.00%
6174-02-21-241-001 Audit Fees5000-5005000#DIV/0!0.00%
6105-02-21-241-010 Hydro (Combined w/YC)151,300153,9902,690145,0000#DIV/0!0.00%
6106-02-21-241-010 Water21,00017,314-3,68621,0000#DIV/0!0.00%
6107-02-21-241-010 Heating Gas28,00033,1905,19026,0000#DIV/0!0.00%
6116-02-21-241-010 Janitorial Supplies8,5003,677-4,8237,5000#DIV/0!0.00%
6197-02-21-241-010 Janitorial Services64,52549,496-15,02963,4070#DIV/0!0.00%
6123-02-21-241-010 Property Repairs45,00069,41424,41445,0000#DIV/0!0.00%
6145-02-21-241-010 Refrigeration Costs38,00034,272-3,72838,0000#DIV/0!0.00%
6108-02-21-241-011 Vehicle Gas & Oil4,5001,962-2,5383,0000#DIV/0!0.00%
6110-02-21-241-011 Vehicle Repairs2,5000-2,5002,5000#DIV/0!0.00%
6110-02-21-241-378 Vehicle Repairs (F/A 7-0020; 2007 Ford F250)5004,8134,3131,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 2021 BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
6108-02-21-241-379 Vehicle Gas & Oil (F/A 7-0024; 2010 Silverado 1500 Summit)015215200#DIV/0!
6110-02-21-241-379 Vehicle Repairs (F/A 7-0024; 2010 Silverado 1500 Summit)8002,2761,4768000#DIV/0!
6110-02-21-241-380 Vehicle Repairs (F/A 7-0062; 2016 Ford Super Duty Pick-up)5001,0885885000#DIV/0!
6128-02-21-241-380 Vehicle Licence (F/A 7-0062; 2016 Ford Super Duty Pick-up)065165100#DIV/0!
6110-02-21-241-012 Equipment Repairs2,5001,144-1,3562,0000#DIV/0!
6110-02-21-241-381 Equipment Repairs (New Holland Tractor; F/A 5-1129)00000#DIV/0!
6110-02-21-241-382 Equipment Repairs (Comm Floor Cleaner; F/A 5-1111)8001,6588581,4000#DIV/0!
6108-02-241-383 Equipment Gas & Oil (2015 Olympia Ice Resurfacer; F/A 5-1135)2,3003,0487482,0000#DIV/0!
6110-02-21-241-383 Equipment Repairs (2015 Olympia Ice Resurfacer; F/A 5-1135)4009845844000#DIV/0!
6108-02-241-384 Equipment Gas & Oil (2005 Olympia Ice Resurfacer; F/A 5-1041)1506484984000#DIV/0!
6110-02-241-384 Equipment Repairs (2005 Olympia Ice Resurfacer; F/A 5-1041)00000#DIV/0!
6108-02-241-392 Gas & Oil (2005 Chev Dump Truck)00000#DIV/0!
6110-02-241-392 Repairs (2005 Chev Dump Truck)01,2241,2241,0000#DIV/0!
6128-02-241-392 Licence (2005 Chev Dump Truck)00000#DIV/0!
6108-02-241-393 Gas & Oil (2018 Massey Ferguson Tractor)030830800#DIV/0!
6110-02-241-393 Repairs (2018 Massey Ferguson Tractor)00000#DIV/0!
6792-02-241-413 COVID-19 Expenditures011,44411,44400#DIV/0!
TOTAL COMMUNITY CENTRE ARENA356,580637,222280,642335,2930000#DIV/0!
MEMORIAL COMMUNITY CENTRE CANTEEN
20202020202120212021%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.Var.Completed
5551-02-21-242-020 Pro-shop/Canteen Lease-11,500-2,7888,712-2,0000#DIV/0!0.00%
5889-02-21-242-020 Bar Sales-10,000-3,6006,400-10,0000#DIV/0!0.00%
5886-02-21-242-020 Canteen Sales00000#DIV/0!#DIV/0!
5887-02-21-242-020 Vending Machine Commission-1,000-862138-9000#DIV/0!0.00%
5888-02-21-242-020 Soft Drink Volume Commission-400-1,100-700-9000#DIV/0!0.00%
6048-02-21-242-001 Part Time Wages (Canteen)00000#DIV/0!#DIV/0!
6048-02-21-242-240 Part Time Wages (Bar)14,000569-13,43114,0000#DIV/0!0.00%
6078-02-21-242-240 Vacation Pay (Bar)56025-5355600#DIV/0!0.00%
6091-02-21-242-240 Other Payroll Costs (Bar)1,60248-1,5541,6000#DIV/0!0.00%
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-4004000#DIV/0!0.00%
6783-02-21-242-001 Bar Supplies4,5002,050-2,4504,5000#DIV/0!0.00%
6742-02-21-242-001 Canteen Supplies00000#DIV/0!#DIV/0!
TOTAL COMMUNITY CENTRE CANTEEN-1,838-5,658-3,8207,260000#DIV/0!
TOTAL COMMUNITY CENTRE GENERAL354,742631,564276,822342,553000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET COMMUNITY SERVICES GENERAL BUDGETPage 35
January 18, 20212020 Budget2020 ActualVar.2021 Budget2021 To Date2021 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 Hydro756487-2697500#DIV/0!
TOTAL TENNIS COURTS756487-269750000#DIV/0!
SENIORS FACILITY
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
02-21-247-001-5557 Donations-3,4005503,950-3,4000#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 Telephone1803611811800#DIV/0!
6105-02-21-247-001 Hydro1,2001,177-231,2000#DIV/0!
6106-02-21-247-001 Water1,000936-641,0000#DIV/0!
02-21-247-001-6107 Heating Fuel2,0001,778-2222,0000#DIV/0!
02-21-247-001-6116 Janitoral Supplies20020-1802000#DIV/0!
6123-02-21-247-001 Property Repairs1,200119-1,0811,2000#DIV/0!
6197-02-21-247-001 Janitorial Services1,0000-1,0001,0000#DIV/0!
TOTAL SENIORS FACILITY3,3804,9411,5613,380000#DIV/0!
KINSMEN PAVILLON "New Sub-section"; (Previously utilities were under "Parks")
02-21-443-001-6105 Hydro2,5002,9214218330#DIV/0!
02-21-443-001-6106 Water1,200980-2201,2000#DIV/0!
02-21-443-001-6107 Heating Fuel3,0002,352-6483,0000#DIV/0!
02-21-443-001-6116 Janitorial Supplies023823800#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 PAVILLON8,7006,491-2,2097,0330#DIV/0!
* Insurance for this facility is under "Parks"
TOTAL COMMUNITY FACILITIES GENERAL654,797933,421278,624757,604000#DIV/0!
TOTAL COMMUNITY FACILITIES BUDGET654,797933,421278,624757,604000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

January 18, 2021COMMUNITY SERVICES CAPITAL BUDGET
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 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)0000#DIV/0!#DIV/0!
6737-01-21-255-000 Columbarium0000#DIV/0!#DIV/0!
6052-01-21-255-000 Lawn Mower0000#DIV/0!#DIV/0!
TOTAL HILLCREST CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

COMMUNITY SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
HILLCREST CEMETERY
5534-02-21-255-020 Interest on Account-8,000-6,2191,781-5,9000#DIV/0!0.00%
5541-02-21-255-020 Sale of Plots-1,500-7,952-6,452-7,0000#DIV/0!0.00%
5542-02-21-255-020 Sale of Services-38,000-52,602-14,602-42,0000#DIV/0!0.00%
5557-02-21-255-020 Donations0-6-600#DIV/0!#DIV/0!
5672-02-21-255-020 Columbarium Revenue-15,000-7,1407,860-6,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 & Wages37,72768,89531,16854,5840#DIV/0!0.00%
6048-02-21-255-001 Part time Wages31,2142,121-29,09318,6050#DIV/0!0.00%
6078-02-21-255-001 Vacation Pay71757-6607440#DIV/0!0.00%
6091-02-21-255-001 Other Payroll Costs21,50523,3561,85120,0590#DIV/0!0.00%
6029-02-21-255-001 Membership Fees2000-2002000#DIV/0!0.00%
6040-02-21-255-001 Clothing & Supplies300285-153000#DIV/0!0.00%
6102-02-21-255-001 Telephone7001,3676678000#DIV/0!0.00%
6105-02-21-255-001 Hydro1,4001,7273271,4000#DIV/0!0.00%
6108-02-21-255-001 Vehicle Gas & Oil1,8001,519-2811,2000#DIV/0!0.00%
6112-02-21-255-001 Equipment Repairs1,5002,3448441,5000#DIV/0!0.00%
6118-02-21-255-001 Tools, Accessories, etc2,0001,650-3502,0000#DIV/0!0.00%
6123-02-21-255-001 Property Repairs9,0006,570-2,4305,0000#DIV/0!0.00%
6160-02-21-255-001 Cemetery License1,400975-4251,0000#DIV/0!0.00%
6173-02-21-255-001 Insurance745744-17450#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,6936931,0000#DIV/0!0.00%
6197-02-21-255-001 Janitorial Services400183-2174000#DIV/0!0.00%
6737-02-21-255-001 Columbarium Expenses00000#DIV/0!#DIV/0!
6191-02-21-255-001 Monument Care & Maintenance1,0000-1,0001,0000#DIV/0!0.00%
6195-02-21-255-001 Grave Opening Contract00000#DIV/0!#DIV/0!
50,10839,567-10,54149,637000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET COMMUNITY SERVICES CAPITAL BUDGETPage 38
January 18, 20212020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
ACCOUNT/DESCRIPTIONCHILD DEVELOPMENT CENTRE
01-21-258-309-5612 Trsf from Capital Reserve-29,130-31,004-1,8740#DIV/0!
01-21-258-000-5612 Trsf from Reserve (Acct 2066/2051)-40,870040,870-70,0000#DIV/0!
01-21-258-000-6745 Toddlers Room0000#DIV/0!
01-21-258-000-6123 Playground Equipment (St Francis site)175,000350-174,650175,0000#DIV/0!
01-21-258-000-6025 Tsf to/frm Reserve029,13029,1300#DIV/0!
01-21-258-000-6836 Tsf to/frm Deferred Revenue0-385-3850#DIV/0!
5441-01-21-258-000 County Grant-105,0001,909106,909-105,0000#DIV/0!
5441-01-21-258-000 Provincial Grant0000#DIV/0!
TOTAL CDC CAPITAL BUDGET0000000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

COMMUNITY SERVICES GENERAL BUDGET

January 16, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.Completed %
ADMINISTRATION
5417-02-21-258-020 County CDC Fee Subsidy-103,074-66,49736,577-103,1000#DIV/0!0.00%
5418-02-21-258-020 Direct Operating Grant *-124,141-198,747-74,606-146,2940#DIV/0!0.00%
5533-02-21-258-020 Parents "In Need" Fees-52,256-16,86235,394-113,6360#DIV/0!0.00%
5441-02-21-258-001 County Grant (Health & Safety)00000#DIV/0!#DIV/0!
5659-02-21-258-020 Parents "Full" Fees - Non-subsid.-340,735-218,210122,525-443,5750#DIV/0!0.00%
02-21-258-413-6782 Expenses (COVID-19)05,7615,76100#DIV/0!#DIV/0!
02-21-258-413-6035 Regular Wages (COVID-19)0100,796100,79600#DIV/0!#DIV/0!
02-21-258-413-6048 Part-time Wages (COVID-19)040,20640,20600#DIV/0!#DIV/0!
02-21-258-413-6078 Vacation Pay (COVID-19)01,5411,54100#DIV/0!#DIV/0!
02-21-258-413-6091 Other Benefit Costs (COVID-19)031,40931,40900#DIV/0!#DIV/0!
02-21-258-413-5441 Prov/County Grant (COVID-19)0-198,709-198,70900#DIV/0!#DIV/0!
02-21-258-293-5421 Provincial Wage Enhancement Grant0-30,969-30,96900#DIV/0!#DIV/0!
02-21-258-293-6836 Provincial Wage Enhancement Grant; Deferred Revenue016,77916,77900#DIV/0!#DIV/0!
02-21-258-293-6035 Provincial Wage Enhancement Grant; FT Wages05,2605,26000#DIV/0!#DIV/0!
02-21-258-293-6048 Provincial Wage Enhancement Grant; PT Wages03,0683,06800#DIV/0!#DIV/0!
02-21-258-293-6091 Provincial Wage Enhancement Grant; Other Benefits01,6501,65000#DIV/0!#DIV/0!
6035-02-21-258-001 Regular Salaries & Wages37,98028,171-9,80939,8760#DIV/0!0.00%
6091-02-21-258-001 Other Payroll Costs25,88612,488-13,39824,3930#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,304-1,1962,5000#DIV/0!0.00%
6015-02-21-258-001 Travel Expense3540-3543000#DIV/0!0.00%
6019-02-21-258-001 Photocopy Supplies30317-2863000#DIV/0!0.00%
6023-02-21-258-001 Postage8128-53800#DIV/0!0.00%
6038-02-21-258-001 Advertising1,0001,5025021,0000#DIV/0!0.00%
6039-02-21-258-001 Staff Training & Develop.5050-5055000#DIV/0!0.00%
6836-02-21-258-001 Trsf to/from Deferred Revenue018,99518,99500#DIV/0!#DIV/0!
6102-02-21-258-001 Telephone3,80011,2167,4164,0000#DIV/0!0.00%
6174-02-21-258-001 Audit Fees0-611-61100#DIV/0!#DIV/0!
6025-02-21-258-001 Trsf to Reserve (Account 2051)0-125-12500#DIV/0!#DIV/0!
6173-02-21-258-001 Insurance2,4902,473-172,9680#DIV/0!0.00%
* Based on 2020 "actuals" @$12,191.16/month
TOTAL ADMINISTRATION-545,307-448,06697,241-730,68800#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

COMMUNITY SERVICES GENERAL BUDGET
January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
PROGRAMS
6035-02-21-258-084 Regular Salaries & Wages252,036124,811-127,225211,7940#DIV/0!
6048-02-21-258-084 Part Time Wages *268,456257,184-11,272444,9390#DIV/0!
6078-02-21-258-084 Vacation Pay12,19710,073-2,12418,4590#DIV/0!
6091-02-21-258-084 Other Payroll Costs105,55390,762-14,791122,5390#DIV/0!
6025-02-21-258-084 Trsf to Payroll Reserve (Surplus from Group Benefits)00000#DIV/0!
6015-02-21-258-084 Travel Expense3030-3031000#DIV/0!
6039-02-21-258-084 Staff Training & Develop.3,5001,658-1,8423,5000#DIV/0!
6046-02-21-258-084 Program Supplies3,5351,066-2,4693,5000#DIV/0!
TOTAL PROGRAMS645,580485,554-160,026804,8310000#DIV/0!
* Reduced; pay equity review will be phased in over 2 years
DIETARY
6048-02-21-258-024 Part Time Wages33,39921,468-11,93134,0670#DIV/0!
6078-02-21-258-024 Vacation Pay2,004927-1,0772,0440#DIV/0!
6091-02-21-258-024 Other Payroll Costs5,7584,790-9684,2980#DIV/0!
6015-02-21-258-024 Travel Expense36063-2971000#DIV/0!
6017-02-21-258-024 Coffee/Food Supplies27,00011,118-15,88227,0000#DIV/0!
TOTAL DIETARY68,52138,366-30,15567,5090000#DIV/0!
CDC FUNDRAISING
5557-02-21-258-013 Donations00000#DIV/0!
6046-02-21-258-013 Program Supplies00000#DIV/0!
6025-02-21-258-013 Transfer to/from Reserve00000#DIV/0!
TOTAL CDC FUNDRAISING00000000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

COMMUNITY SERVICES GENERAL BUDGET

January 18,2021 ACCOUNT/DESCRIPTION

ACCCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 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 Supplies5000-5005000#DIV/0!0.00%
6105-02-21-258-025 Hydro2,8002,371-4292,8000#DIV/0!0.00%
6106-02-21-258-025 Water2008796792000#DIV/0!0.00%
6107-02-21-258-025 Heating Fuel1,0001,5235231,0000#DIV/0!0.00%
6118-02-21-258-025 Tools, Accessories, etc5000-5005000#DIV/0!0.00%
6123-02-21-258-025 Property Repairs098398300#DIV/0!#DIV/0!
6152-02-21-258-025 Lease ("New")24,00021,322-2,67824,0000#DIV/0!0.00%
6015-02-21-258-025 Travel Expense5050-5055000#DIV/0!0.00%
* Now supplied by school
TOTAL OCCUPANCY29,50527,078-2,42729,500000#DIV/0!
TOTAL CDC GENERAL BUDGET198,299102,932-95,367171,152000#DIV/0!
TOTAL CDC BUDGET198,299102,932-95,367171,152000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

WORKS & UTILITIES

ACCOUNT/DESCRIPTION2020Budget2020ActualVar.2021Budget2021To Date2021ActualVar.%Var.%Completed
WATER TREATMENT PLANT CAPITAL BUDGET
5612-01-31-301-309 Trsf from WTP Capital Reserve (Account 2083)-194,725-132,77761,948-191,5000#DIV/0!0.00%
6750-01-31-301-000 Water Tower Detailed Design185,0006,989-178,011178,0100#DIV/0!0.00%
6844-01-31-301-000 WTP Financial Plan Update15,0009,649-5,3515,3510#DIV/0!0.00%
6340-01-31-301-000 Equipment Analyzer Replacements00015,0000#DIV/0!0.00%
6177-01-31-301-000 WIN 911 Software - Alarm Call-out System (SCADA)00020,0000#DIV/0!0.00%
6764-01-31-301-000 Pressurization Pump (Aurora Series)6,0004,620-1,3800#DIV/0!#DIV/0!
01-31-301-350-5900 OCIF Formula-based Funding (Beckwith St./Watermains)-613,765-533,00680,7590#DIV/0!#DIV/0!
01-31-301-000-5869 Federal Gas Tax Reserve $$-426,146-426,1460-25,4750#DIV/0!0.00%
01-31-301-125-6205 Distribution Design; George St.00046,5000#DIV/0!0.00%
01-31-301-350-6732 Beckwith St. Phase 2; Detailed Design35,62510,121-25,50425,5040#DIV/0!0.00%
01-31-301-000-6049 DAF Piping (Drain); Detailed Design35,00013,174-21,82621,8270#DIV/0!0.00%
6226-01-31-301-269 Source Water Protection Implementation Project0154,131154,1310#DIV/0!#DIV/0!
6808-01-31-301-422 New DAF Drain00040,0000#DIV/0!0.00%
6836-01-31-301-269 Trsf to/from Deferred Revenue017,17217,1720#DIV/0!#DIV/0!
6759-01-31-301-000 Vacuum Priming System55,00019,579-35,4210#DIV/0!#DIV/0!
6765-01-31-301-000 HLP 181; Horizontal Centrifugal Split Case Suction Pump15,00017,4012,4010#DIV/0!#DIV/0!
6385-01-31-301-000 Polymer System Piping12,0000-12,0000#DIV/0!#DIV/0!
6808-01-31-301-423 Rebuild HLP 182 (High Lift Pump)00020,0000#DIV/0!0.00%
6205-01-31-301-350 Beckwith St. Project/Water Mains1,325,6251,127,529-198,0960#DIV/0!#DIV/0!
5612-01-31-301-000 Transfer from Reserve (Project Carry-over acct 2051) **-464,614-293,988170,626-205,2170#DIV/0!0.00%
6408-01-31-301-000 LLP 101 Horizontal end suction pump15,0005,552-9,4480#DIV/0!#DIV/0!
01-31-301-001-6360 Replace Turbidity Analyzer (AIT 102 & AIT 184)00020,0000#DIV/0!0.00%
6081-01-31-301-001 Stainless Steel HL pumping Header Repairs00030,0000#DIV/0!0.00%
WATER TREATMENT PLANT CAPITAL

WATER TREATMENT PLANT CAPITAL


TOWN OF SMITHS FALLS 2021 BUDGET

WORKS & UTILITIES GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
WATER TREATMENT PLANT REVENUE
5820-02-31-301-020 Residential Water-566,272-566,434-162-576,1570#DIV/0!0.00%
5821-02-31-301-020 Commercial Water-383,192-357,79925,393-365,6870#DIV/0!0.00%
5823-02-31-301-020 Residential Other Municipalities-59,622-56,1083,514-57,5660#DIV/0!0.00%
5824-02-31-301-020 Commercial Other Municipalities-1,520-1,42496-1,4810#DIV/0!0.00%
5825-02-31-301-020 Public Hydrants-63,000-63,0000-63,6930#DIV/0!0.00%
5826-02-31-301-020 Base Service Charge-1,532,906-1,559,558-26,652-1,575,0430#DIV/0!0.00%
5827-02-31-301-020 Occupancy Charge-7,326-8,286-960-7,5000#DIV/0!0.00%
5556-02-31-301-020 Misc Sales00000#DIV/0!#DIV/0!
5828-02-31-301-020 Misc Water Sales-1,500-9,470-7,970-5,0000#DIV/0!0.00%
5829-02-31-301-020 Late Payment Charge-65,000-24,18640,814-60,0000#DIV/0!0.00%
5831-02-31-301-020 Misc Revenue-15,000-11,7543,246-15,0000#DIV/0!0.00%
Revenue includes a projected 1.1% CPI Increase + Projected surplus from 2020 to 2021
TOTAL DEPTHS2,005,2002,658,04027,2402,707,427000#DIV/0!
6035-02-31-301-001 Regular Salaries & Wages84,08988,8964,80787,4040#DIV/0!0.00%
6091-02-31-301-001 Other Payroll Costs21,34423,1461,80223,8060#DIV/0!0.00%
6025-02-31-301-001 Trsf to Payroll Reserve (Surplus from Group Benefits)00000#DIV/0!#DIV/0!
6011-02-31-301-001 Office Supplies5,0004,048-9525,0000#DIV/0!0.00%
6015-02-31-301-001 Travel1,0000-1,0002500#DIV/0!0.00%
6023-02-31-301-001 Postage15,00015,58858815,0000#DIV/0!0.00%
6029-02-31-301-001 Membership Fees1,8002,3435432,5000#DIV/0!0.00%
6042-02-31-301-001 Courier600107-4936000#DIV/0!0.00%
6102-02-31-301-001 Telephone14,00018,9254,92514,0000#DIV/0!0.00%
6173-02-31-301-001 Insurance21,87521,794-8126,1520#DIV/0!0.00%
6025-02-31-301-309 Transfer to Capital Reserve (Acct 2083) *492,856549,37056,514492,8560#DIV/0!0.00%
6180-02-31-301-001 Professional Fees8,0002,007-5,9938,0000#DIV/0!0.00%
6564-02-31-301-001 Mail Sorter3,5002,543-9573,5000#DIV/0!0.00%
* LTFP projects $1,049,917; Budgeted same as 2020
TOTAL ADMINISTRATION669,064728,76759,703679,068000#DIV/0!

2021 BUDGET WORKS & UTILITIES GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
WATER TREATMENT PLANT OPERATIONS
6035-02-31-301-139 Regular Salaries & Wages *212,262208,652-3,610217,1800#DIV/0!0.00%
6048-02-31-301-139 Part Time Wages **8,9606,594-2,3669,4880#DIV/0!0.00%
6057-02-31-301-139 Overtime14,00017,5433,54314,4000#DIV/0!0.00%
6069-02-31-301-139 Stat Time11,45913,3521,89311,4590#DIV/0!0.00%
6067-02-31-301-139 On-Call Pay11,70015,2733,57312,0000#DIV/0!0.00%
6078-02-31-301-139 Vacation Pay15,87524,8078,93215,8960#DIV/0!0.00%
6084-02-31-301-139 Sick Pay6,6845,253-1,4316,6840#DIV/0!0.00%
6091-02-31-301-139 Other Payroll Costs82,33983,00666782,7250#DIV/0!0.00%
6039-02-31-301-139 Staff Training & Development17,50011,165-6,33511,0000#DIV/0!0.00%
6040-02-31-301-139 Safety Clothing Allowance2,0001,869-1312,4000#DIV/0!0.00%
6105-02-31-301-139 Hydro245,000204,187-40,813230,0000#DIV/0!0.00%
6107-02-31-301-139 Heating Fuel37,00039,7952,79538,0000#DIV/0!0.00%
6316-02-31-301-139 Building Mtce - Supplies9,0006,219-2,78110,0000#DIV/0!0.00%
6197-02-31-301-139 Janitorial Services3,000564-2,4363,0000#DIV/0!0.00%
6317-02-31-301-139 Building Mtce - Equip32,00040,0248,02432,0000#DIV/0!0.00%
6176-02-31-301-139 Computer Maintenance5000-5001,0000#DIV/0!0.00%
6329-02-31-301-139 Equip. Repairs - Low Lift5000-5005000#DIV/0!0.00%
6330-02-31-301-139 - High Lift500379-1215000#DIV/0!0.00%
6331-02-31-301-139 - Intake1,0003,6162,6161,0000#DIV/0!0.00%
6332-02-31-301-139 - AquaDAF6,5002,360-4,1406,5000#DIV/0!0.00%
6333-02-31-301-139 - Filters1,000726-2741,0000#DIV/0!0.00%
6335-02-31-301-139 - Pipes & Valves2,5002,9504502,5000#DIV/0!0.00%
6337-02-31-301-139 - Motor Control5,00018,77213,77210,0000#DIV/0!0.00%
6334-02-31-301-139 - Process Equip7,50010,8853,3857,5000#DIV/0!0.00%
6118-02-31-301-139 - Small Tools500527271,0000#DIV/0!0.00%
6762-02-31-301-139 - SCADA10,0005,543-4,45710,0000#DIV/0!0.00%
6177-02-31-301-139 Annual Software Licenses ("New")11,00016,3505,35015,0000#DIV/0!0.00%
6340-02-31-301-139 Analysis Equipment8,0008,9099098,0000#DIV/0!0.00%
6689-02-31-301-139 Chemical Pumps2,00081-1,9192,0000#DIV/0!0.00%
6690-02-31-301-139 UV System11,0008,309-2,69111,0000#DIV/0!0.00%
6691-02-31-301-139 Reservoir5,0000-5,0005,0000#DIV/0!0.00%
6692-02-31-301-139 Wastewater System1,000285-7151,0000#DIV/0!0.00%
6725-02-31-301-139 Emergency Genset Service5,0009,1764,1765,0000#DIV/0!0.00%
6728-02-31-301-139 Diesel Fuel4,5004,7792794,5000#DIV/0!0.00%
6726-02-31-301-139 Calibrate Flow Meter Repairs2,5001,663-8372,5000#DIV/0!0.00%
6727-02-31-301-139 Process Equipment Inventory16,00015,902-986,0000#DIV/0!0.00%
6110-02-31-301-139 Vehicle Repairs00000#DIV/0!#DIV/0!
6128-02-31-301-139 Vehicle Licence00000#DIV/0!#DIV/0!

2021 BUDGET WORKS & UTILITIES GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
WATER TREATMENT PLANT OPERATIONS
6108-02-31-301-340 Vehicle Fuel (2009 F150 Pick-up; F/A 7-0014)000000#DIV/0!
6110-02-31-301-340 Vehicle Repairs; (2009 F150 Pick-up; F/A 7-0065)000000#DIV/0!
6128-02-31-301-340 Vehicle Licence; (2009 F150 Pick-up; F/A 7-0065)0-80-8000#DIV/0!
6108-02-31-301-341 Vehicle Fuel (2015 Chev's Silverado; F/A 7-0059)1,000621-3791,0000#DIV/0!
6110-02-31-301-341 Vehicle Repairs; (2015 Chev's Silverado; F/A 7-0059)1,500790-7101,5000#DIV/0!
6128-02-31-301-341 Vehicle Licence; (2015 Chev's Silverado; F/A 7-0059)140120-201400#DIV/0!
6319-02-31-301-139 Alarm Monitoring2,0003,8181,8182,5000#DIV/0!
6193-02-31-301-139 Radio & Pager Maintenance2,000318-1,6822,0000#DIV/0!
6301-02-31-301-139 Municipal Taxes - PIL182,178181,141-1,037182,1780#DIV/0!
6342-02-31-301-139 Reagents10,0009,517-48310,0000#DIV/0!
6280-02-31-301-139 Safety Equipment & Supplies2,0001,044-9562,5000#DIV/0!
6343-02-31-301-139 Lab Supplies2,0001,577-4233,0000#DIV/0!
6345-02-31-301-139 Chemicals -Coagulant110,00090,453-19,547115,5000#DIV/0!
6347-02-31-301-139 - Chlorine25,00028,3193,31927,5000#DIV/0!
6385-02-31-301-139 - Polymer2,6002,634342,6000#DIV/0!
6675-02-31-301-139 - Calcium Thiosulfate2,5002,413-872,5000#DIV/0!
6676-02-31-301-139 - Sodium Hydroxide35,00045,09310,09335,0000#DIV/0!
6311-02-31-301-139 Water Sampling/Lead Testing26,00021,028-4,97230,0000#DIV/0!
6763-02-31-301-139 Water Conservation Public Relations1,0000-1,0001,0000#DIV/0!
6387-02-31-301-139 Water Tower Maintenance5,00078-4,9225,0000#DIV/0!
02-31-301-001-6010 Write off Old Accounts0-599-59900#DIV/0!
6012-02-31-301-139 Principal - New WTP220,420220,4200231,1940#DIV/0!
6014-02-31-301-139 Interest - New WTP372,925368,801-4,124362,1510#DIV/0!
6837-02-31-301-139 Compliance Issues4,0001,322-2,6784,0000#DIV/0!
6346-02-31-301-139 Chemicals - Fluoride8,000991-7,00910,0000#DIV/0!
TOTAL WATER TREATMENT PLANT OPERATIONS1,825,5421,769,334-56,2081,828,9950000#DIV/0!
TOTAL WATER TREATMENT PLANT GENERAL-200,732-159,91840,814-219,0640000#DIV/0!
TOTAL WATER TREATMENT PLANT-200,732-159,91840,814-219,0640000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET WORKS & UTILITIES

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
WATER POLLUTION CONTROL PLANT CAPITAL BUDGET
6074-01-31-302-000 Control Building SCADA Upgrade0000#DIV/0!
6844-01-31-302-000 Wastewater Financial Plan Update15,0009,649-5,3515,3510#DIV/0!
6070-01-31-302-000 Building Security for Doors0000#DIV/0!
01-31-302-000-6063 Flow Monitoring Study40,5000-40,50040,5000#DIV/0!
01-31-302-401-6808 Wet Well Pump Rebuild25,00018,100-6,90025,0000#DIV/0!
01-31-302-000-6430 Replacement Bar Screen (Now unde275,00034,663-240,337568,1970#DIV/0!
6823-01-31-302-000 Sludge Tank Mixer20,00020,96196125,0000#DIV/0!
6025-01-31-302-000 Transfer from Reserve0359,200359,2000#DIV/0!
6020-01-31-302-000 Upgrade from obsolete Bristol PCL Prog. Logic Controller201,0000-201,0000#DIV/0!
01-31-302-000-6177 WIN 911 Software - Alarm Call-out System (SCADA)00020,0000#DIV/0!
01-31-302-000-6534 Replacement Flooring - Laboratory00025,7000#DIV/0!
01-31-302-125-6205 Design; George St.00044,7000#DIV/0!
01-31-302-000-6764 High Pressure Effluent Water Pump Motor Replacement0000#DIV/0!
01-31-302-363-6076 Gas Detection (Belt Filer Press Room)0000#DIV/0!
01-31-302-363-6431 Gas Detection (Raw Sludge Building)0000#DIV/0!
01-31-302-000-6767 Trenchless Sewer Lining000100,0000#DIV/0!
01-31-302-000-6153 Replacement of Electrical Equipment/PLC's201,05974,200-126,8590#DIV/0!
01-31-302-000-5869 Federal Gas Tax-130,771-130,77100#DIV/0!
01-31-302-350-6836 Trsf from Deferred Revenue (OCIF Top-up Funding)0000#DIV/0!
01-31-302-348-6205 Contractor (Lorne St.; Sanitary Sewers)0000#DIV/0!
01-31-302-348-5873 CWWF Prov Grant **0000#DIV/0!
01-31-302-348-5424 CWWF Fed Grant **0000#DIV/0!
01-31-302-350-6205 Beckwith St.; Sanitary Sewers1,619,3341,245,053-374,2810#DIV/0!
5869-01-31-302-350 Federal Gas Tax/Beckwith St.0000#DIV/0!
5900-01-31-302-000 OCIF Top-up Funding-363,6800363,6800#DIV/0!
6732-01-31-302-350 Beckwith St.; Phase 2; Detailed Design35,62534,375-1,2501,2500#DIV/0!
5612-01-31-302-309 Transfer from WPCP Capital Reserve (Acct 2085)-668,225-646,29721,928-240,4000#DIV/0!
5612-01-31-302-000 Transfer from Reserve (Acct 2051)-764,828-498,130266,698-615,2980#DIV/0!
6836-01-31-302-394 Trsf from deferred revenue (Rural & Small Municipalities grant)-505,014-521,003-15,9890#DIV/0!
TOTAL WATER POLLUTION CONTROL PLANT CAPITAL00000000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

WORKS & UTILITIES GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
WATER POLLUTION CONTROL PLANT REVENUE
5611-02-31-302-020 Sewer Surcharge-2,666,762-2,625,53241,230-2,667,0580#DIV/0!
5556-02-31-302-020 Misc Sales00000#DIV/0!
5666-02-31-302-020 Pellet Sales-5,000-9514,049-5,0000#DIV/0!
5667-02-31-302-020 Septage Processing Fees00000#DIV/0!
5711-02-31-302-020 Montague Twp Fees-10,800-10,600200-10,8000#DIV/0!
Revenue inclusive of CPI Increase of 1.1% + Deficit from 2020 to 2021
TOTAL REVENUE-2,682,562-2,637,08345,479-2,682,858000#DIV/0!
ADMINISTRATION
6035-02-31-302-001 Regular Salaries & Wages *76,95076,950080,1010#DIV/0!
6091-02-31-302-001 Other Payroll Costs21,17921,179023,4260#DIV/0!
6015-02-31-302-001 Travel1,000103-8972500-100.0%
6102-02-31-302-001 Telephone9,50016,7347,23411,0000-100.0%
6114-02-31-302-001 Town Equipment00000#DIV/0!
5902-02-31-302-001 Town Equipment Adjustment00000#DIV/0!
6025-02-31-302-309 Transfer to Capital Reserve (Acct 2085) **739,166876,625137,459739,1660#DIV/0!
6180-02-31-302-001 Professional Fees10,0002,256-7,74410,0000#DIV/0!
6173-02-31-302-001 Insurance57,21556,998-21768,3980#DIV/0!
* Now inclusive of 25% utility billing clerk
TOTAL ADMINISTRATION915,0101,050,845135,835932,341000#DIV/0!

** LTFP projects $1,749,564; 2021; 2021 1st/2nd draft; Status quo from 2020


January 18, 2021 ACCOUNT/DESCRIPTIONTOWN OF SMITHS FALLS 2021 BUDGET WORKS & UTILITIES GENERAL BUDGET 2020 BudgetTOWN OF SMITHS FALLS 2021 BUDGET WORKS & UTILITIES GENERAL BUDGET 2020 ActualTOWN OF SMITHS FALLS 2021 BUDGET WORKS & UTILITIES GENERAL BUDGET Var. Var.TOWN OF SMITHS FALLS Page 48 WORKS & UTILITIES GENERAL BUDGET 2021 BudgetTOWN OF SMITHS FALLS Page 48 WORKS & UTILITIES GENERAL BUDGET 2021 To DateTOWN OF SMITHS FALLS Page 48 WORKS & UTILITIES GENERAL BUDGET 2021 ActualTOWN OF SMITHS FALLS Page 48 WORKS & UTILITIES GENERAL BUDGET % Var.TOWN OF SMITHS FALLS Page 48 WORKS & UTILITIES GENERAL BUDGET % Completed
6035-02-31-302-001 Regular Salaries & Wages300,690280,489-20,201308,3980 #DIV/0!0.00%
6057-02-31-302-001 Overtime12,00015,3213,32112,0000 #DIV/0!0.00%
6048-02-31-302-001 Part Time Wages8,960896-8,0649,4880 #DIV/0!0.00%
6067-02-31-302-001 On-Call Pay11,70011,97227212,0000 #DIV/0!0.00%
6069-02-31-302-001 Stat Time10,97113,6372,66610,9710 #DIV/0!0.00%
6078-02-31-302-001 Vacation Pay16,35716,102-25516,3790 #DIV/0!0.00%
6084-02-31-302-001 Sick Pay6,6849,2672,5836,6840 #DIV/0!0.00%
6091-02-31-302-001 Other Payroll Costs112,81894,686-18,132108,0860 #DIV/0!0.00%
6011-02-31-302-001 Office Supplies2,7502,764142,7500 #DIV/0!0.00%
6039-02-31-302-001 Staff Training15,0007,916-7,0849,0000 #DIV/0!0.00%
6040-02-31-302-001 Clothing Supplies3,0002,135-8653,0000 #DIV/0!0.00%
6105-02-31-302-001 Hydro405,000379,009-25,991415,0000 #DIV/0!0.00%
6106-02-31-302-001 Water9,00018,1129,11220,0000 #DIV/0!0.00%
6112-02-31-302-001 Equip Rep - Plant - Sewage Lift Station15,00025,53410,53425,0000 #DIV/0!0.00%
6430-02-31-302-001 - Grit Removal2,5004,1041,6043,1000 #DIV/0!0.00%
6431-02-31-302-001 - Raw Sludge Bldg10,0009,051-94910,0000 #DIV/0!0.00%
6432-02-31-302-001 - Primary Collectors10,00014,6574,65710,0000 #DIV/0!0.00%
6433-02-31-302-001 - Aeration Tanks10,0008,986-1,01410,0000 #DIV/0!0.00%
6434-02-31-302-001 - Secondary Clarifiers5,00031-4,9695,0000 #DIV/0!0.00%
6435-02-31-302-001 - RAS Sludge Pumps5,0000-5,0005,0000 #DIV/0!0.00%
6436-02-31-302-001 - Mixing Tanks5,0006,4001,4005,0000 #DIV/0!0.00%
6437-02-31-302-001 - Filters5,0001,305-3,6955,0000 #DIV/0!0.00%
6438-02-31-302-001 - UV System3,0004,9941,9945,0000 #DIV/0!0.00%
6439-02-31-302-001 - Chemical Pumps3,0004,8691,8693,0000 #DIV/0!0.00%
6440-02-31-302-001 - Computers2,0001,723-2772,0000 #DIV/0!0.00%
6441-02-31-302-001 Equip Rep - Pelletizer - Belt Press **47,00070,79823,79847,0000 #DIV/0!0.00%
6442-02-31-302-001 -Twin Mixers2,000427-1,5735,0000 #DIV/0!0.00%
6443-02-31-302-001 Equip Rep - Pelletizer - Drying Drum3,0003,3453453,0000 #DIV/0!0.00%
6444-02-31-302-001 - Secondary Cyclone5,0002,848-2,1525,0000 #DIV/0!0.00%
6445-02-31-302-001 - Bucket Elevator/Sizer2,0000-2,0002,0000 #DIV/0!0.00%
6446-02-31-302-001 - Storage/Pellet Handling1,5000-1,5001,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,5003,7251,2252,5000 #DIV/0!0.00%
6316-02-31-302-001 Building Maintenance & Cleaning47,00040,791-6,20947,0000 #DIV/0!0.00%
6197-02-31-302-001 Janitorial Services3,000497-2,5033,0000 #DIV/0!0.00%
6448-02-31-302-001 Bldg Cleaning Supplies2,8001,594-1,2062,8000 #DIV/0!0.00%
6322-02-31-302-001 Small Equipment & Tools1,5001,571712,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,0008,0000 #DIV/0!0.00%
6029-02-31-302-001 Membership Fees1,0000-1,0001,0000 #DIV/0!0.00%
6280-02-31-302-001 Safety Equipment1,6003,1931,5932,7000 #DIV/0!0.00%

January 18, 2021 ACCOUNT/DESCRIPTIONTOWN OF SMITHS FALLS 2021 BUDGET WORKS & UTILITIES GENERAL BUDGET 2020 BudgetTOWN OF SMITHS FALLS 2021 BUDGET WORKS & UTILITIES GENERAL BUDGET 2020 ActualTOWN OF SMITHS FALLS 2021 BUDGET WORKS & UTILITIES GENERAL BUDGET 2021 Var.TOWN OF SMITHS FALLS Page 49 WORKS & UTILITIES GENERAL BUDGET 2021 BudgetTOWN OF SMITHS FALLS Page 49 WORKS & UTILITIES GENERAL BUDGET 2021 To DateTOWN OF SMITHS FALLS Page 49 WORKS & UTILITIES GENERAL BUDGET % ActualTOWN OF SMITHS FALLS Page 49 WORKS & UTILITIES GENERAL BUDGET % Var.TOWN OF SMITHS FALLS Page 49 WORKS & UTILITIES GENERAL BUDGET % Completed
WATER POLLUTION CONTROL PLANT OPERATIONS
6375-02-31-302-001 Sludge Disposal8,00023,81615,81610,0000#DIV/0!0.00%
6222-02-31-302-001 Pellet Bagging Costs500282-2185000#DIV/0!0.00%
6107-02-31-302-001 Heating Fuel116,00090,232-25,768119,0000#DIV/0!0.00%
6108-02-31-302-342 Vehicle Gas (2013 Chev Silverado; F/A 7-0054)1,200471-7291,2000#DIV/0!0.00%
6110-02-31-302-342 Vehicle Repairs (2013 Chev Silverado; F/A 7-0054)2,0000-2,0002,0000#DIV/0!0.00%
6128-02-31-302-342 Vehicle Licences (2013 Chev Silverado; F/A 7-0054)270265-52700#DIV/0!0.00%
6311-02-31-302-001 Sampling35,00040,5385,53835,0000#DIV/0!0.00%
6547-02-31-302-001 Sampling Equipment Repairs2,000579-1,4212,0000#DIV/0!0.00%
6319-02-31-302-001 Alarm Monitoring2,5001,442-1,0582,5000#DIV/0!0.00%
6119-02-31-302-001 Radio & Pager Maintenance2,5000-2,5002,5000#DIV/0!0.00%
6042-02-31-302-001 Courier525282-2435250#DIV/0!0.00%
6343-02-31-302-001 Lab Supplies5,0006,5541,5545,0000#DIV/0!0.00%
6344-02-31-302-001 Chemicals - Phas90,00080,692-9,30895,0000#DIV/0!0.00%
6385-02-31-302-001 - Polymer45,00026,136-18,86445,0000#DIV/0!0.00%
6012-02-31-302-251 Pelletizer - Principal30,75630,562-19432,0630#DIV/0!0.00%
6014-02-31-302-251 Pelletizer - Interest23,10023,28718721,7920#DIV/0!0.00%
6012-02-31-302-355 Energy Audit - Principal14,52214,451-7114,9350#DIV/0!0.00%
6014-02-31-302-355 Energy Audit - Interest7,5427,596547,1290#DIV/0!0.00%
6342-02-31-302-001 Reagents3,5002,809-6915,0000#DIV/0!0.00%
6095-02-31-302-001 Emergency Equipment28,00015,628-12,37228,0000#DIV/0!0.00%
6177-02-31-302-001 Annual Software Licenses5,0009,9884,9885,0000#DIV/0!0.00%
6762-02-31-302-001 SCADA Repairs12,00010,520-1,48012,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,7001,9602601,7000#DIV/0!0.00%
6073-02-31-302-001 Pelletizer Parts Inventory22,00016,069-5,93122,0000#DIV/0!0.00%
6493-02-31-302-001 Sludge Holding Tanks1,0000-1,0001,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 - Town81,27320,426-60,84743,513000#DIV/0!
6492-02-31-304-012 Use of Town Vehicles56,34857,33698956,690000#DIV/0!
6301-02-31-302-001 Municipal Taxes - PIL108,713108,048-665108,7130#DIV/0!0.00%
TOTAL WATER POLLUTION CONTROL PLANT OPERATIONS1,834,3891,653,074-181,3141,844,496000#DIV/0!
TOTAL WATER POLLUTION CONTROL PLANT GENERAL66,83766,836093,979000#DIV/0!
TOTAL WATER POLLUTION CONTROL PLANT66,83766,836093,979000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

PUBLIC WORKS & UTILITIES CAPITAL BUDGET

INFRASTRUCTURE MAINTENANCE

ROAD PER SCHEDULE A - DEP

& SEWER NETWORK ARTMENTAL SUB-LEDGER (Page 87 - 88)

Equipment Purchases0000000#DIV/0!
Municipal Road Work0000000#DIV/0!
Bridges0000000#DIV/0!
Public Works Buildings0000000#DIV/0!
TOTAL CAPITAL0000000#DIV/0!

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

Sandyay 10, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar. INFRASTRUCTURE MAINTENANCE ADMINISTRATION2021 Budget2021 To Date2021 ActualVar.
ACCOUNT/DESCRIPTION2020 Budget2020 Actual263,88354,503218,3570 #DIV/0!
6035-02-31-303-001 Regular Salaries209,38035,8403,695-32,14592,4360 #DIV/0!
6048-02-31-303-001 Part-time Salaries35,84020,00037,36117,36120,0000 #DIV/0!
6057-02-31-303-001 Overtime17,50020,8153,31517,00017,0000 #DIV/0!
6067-02-31-303-001 Shift Premium27,21325,100-2,11327,21327,2130 #DIV/0!
6069-02-31-303-001 Stat Time62,38035,213-27,16764,64364,6430 #DIV/0!
6078-02-31-303-001 Vacation Pay15,87427,44411,57015,87415,8740 #DIV/0!
6084-02-31-303-001 Sick Time122,290131,7799,48987,47587,4750 #DIV/0!
6091-02-31-303-001 Other Payroll Costs2,0002,084842,0002,0000 #DIV/0!
6280-02-31-303-001 Safety Material0-1,340-1,340000 #DIV/0!
5902-02-31-303-001 Town Equipment Adjustment000000 #DIV/0!
5421-02-31-303-372 Provincial Grant (Safe Cycling)000000 #DIV/0!
6046-02-31-303-372 Program Supplies (Safe Cycling)000000 #DIV/0!
5612-02-31-303-413 Trsf from Reserve; COVID-19000000 #DIV/0!
6792-02-31-303-413 COVID-19 Expenditures04,6094,609000 #DIV/0!
6851-02-31-303-001 Patrols & Records8,50010,4551,9559,0009,0000 #DIV/0!
6180-02-31-303-001 Professional Fees4,0001,608-2,3924,0004,0000 #DIV/0!
6039-02-31-303-001 Staff Training & Equipment18,00014,077-3,92314,00014,0000 #DIV/0!
6164-02-31-303-001 Liability Insurance Claim8,0002,420-5,5808,0008,0000 #DIV/0!
6040-02-31-303-001 Clothing Supplies10,50011,6781,17810,70010,7000 #DIV/0!
6102-02-31-303-001 Telephone6,0004,835-1,1656,0006,0000 #DIV/0!
TOTAL ADMINISTRATION567,477595,71628,239596,6980000 #DIV/0!
DEBT SERVICING
6012-02-31-311-213 Building Loan - Principal1,4011,392-91,4601,4600#DIV/0!
6014-02-31-311-213 Building Loan - Interest1,0521,06199939930#DIV/0!
6012-02-31-302-223 CSO Tank - Principle **36,80736,807038,25738,2570#DIV/0!
6014-02-31-302-223 CSO Tank - Interest **48,45548,455047,00647,0060#DIV/0!
6012-02-31-311-xxx 2020 Capital Roadworks/Beckwith8,7650#DIV/0!
6014-02-31-311-xxx 2020 Capital Roadworks/Beckwith6,7040#DIV/0!
6012-02-31-311-214 2006/7 Road Projects - Princ4,9674,936-315,1795,1790#DIV/0!
6014-02-31-311-214 2006/7 Road Projects - Int3,7303,761313,5183,5180#DIV/0!
** CSO Tank Loan; Previously on WPCP budget on page 51; storm-related; not wastewater
TOTAL DEBT SERVICING96,41296,4120111,8820000 #DIV/0!

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

January 18,2021

2020 ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.

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

Bridges & Culverts46,40034,509-11,89144,300000#DIV/0!
Grass & Weed Mowing21,00019,980-1,02029,275000#DIV/0!
Grading & Shoulder Maintenance11,4002,758-8,64210,025000#DIV/0!
Main Sewers264,900226,362-38,538270,050000#DIV/0!
House Sewers27,4005,091-22,30929,150000#DIV/0!
Storm Sewers/Catch Basins69,00066,756-2,24458,970000#DIV/0!
Railway Crossing Maintenance12,50011,736-76412,000000#DIV/0!
Dust Control4,0000-4,0004,125000#DIV/0!
Winter Control; Plowing/Sanding/Salting Roads237,150125,106-112,044231,142000#DIV/0!
Winter Control; Snow Removal82,20039,845-42,355100,250000#DIV/0!
Winter Control; Sidewalks29,92026,015-3,90531,020000#DIV/0!
Winter Control; Parking & Facilities14,2803,925-10,35517,625000#DIV/0!
Traffic Signals84,86063,199-21,66178,410000#DIV/0!
Traffic Markings34,68028,556-6,12432,128000#DIV/0!
Street Repair216,200210,493-5,707228,450000#DIV/0!
Street Lighting154,350121,763-32,587159,031000#DIV/0!
Street Signs31,90032,65275235,470000#DIV/0!
Street Cleaning50,68036,712-13,96838,505000#DIV/0!
Curbs & Sidewalk Repairs100,60092,556-8,04488,876000#DIV/0!
Tree Servicing50,00038,873-11,12755,250000#DIV/0!
Buildings & Grounds92,10091,287-81396,040000#DIV/0!
Litter and Garbage Pick-up28,45029,8311,38129,450000#DIV/0!
5860-02-31-303-051 Allocated To Water Dept *-81,273-20,42660,847-43,5130000
TOTAL ROADS MAINTENANCE1,582,6971,287,579-295,1181,636,029000#DIV/0!
  • House/Main Sewers reallocated to WPCP; less credit for storm expense allocation from taxation; phase-in @$255,687; increase of $44,660 from 2020

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

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
EQUIPMENT MAINTENANCE PER SCHEDULE C - SUBLEDGER (Page 97 - 105)
6035-02-31-303-052 Regular Salaries & Wages30,00020,211-9,78930,000000#DIV/0!
6091-02-31-303-070 Other Payroll Costs10,8007,276-3,52412,300000#DIV/0!
6108-02-31-303-070 Gas & Oil66,00056,327-9,67370,900000#DIV/0!
6762-02-31-303-070 COVID-19 Expenditures2,500
6110-02-31-303-070 Repairs102,250125,72423,47489,950000#DIV/0!
6128-02-31-303-070 Licenses4,1804,6875074,890000#DIV/0!
6112-02-31-303-070 Equipment Repairs20,00025,7135,71320,000000#DIV/0!
6115-02-31-303-070 Equipment Rental500635135500000#DIV/0!
6119-02-31-303-070 Radio Repairs2,2001,781-4192,500000#DIV/0!
6135-02-31-303-070 Diesel0-1,851-1,8510000#DIV/0!
6173-02-31-303-070 Insurance20,19520,117-7824,141000#DIV/0!
5860-02-31-303-070 Allocated to Water Dept *-56,348-57,336-989-56,6900000
TOTAL ROADS EQUIPMENT MAINTENANCE199,778203,2843,506200,991000#DIV/0!
22% Reallocated to WPCP for maintenance
TOTAL ROAD MAINTENANCE GENERAL BUDGET2,446,3642,182,991-263,3732,545,600000#DIV/0!
TOTAL ROAD MAINTENANCE BUDGET2,446,3642,182,991-263,3732,545,600000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGETPage 54
PUBLIC WORKS & UTILITIES DEPARTMENTAL CAPITAL BUDGET
January 18, 20212020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
ACCOUNT/DESCRIPTIONINFRASTRUCTURE MAINTENANCE WATER DISTRIBUTION NETWORK
01-31-304-000-6072 Water Meter Replacements00046,0000#DIV/0!
01-31-304-424-6808 Correlation Equipment00040,0000#DIV/0!
01-31-304-138-6030 Emergency Repairs (Water Main; Victoria Basin)0920920-86,0000#DIV/0!
01-31-304-309-5612 Trsf from WTP Capital Reserve (Acct 2083)0-920-9200#DIV/0!
01-31-304-000-6614 1/2 Ton Truck (Replacement of 7-0042)0000#DIV/0!
01-31-304-000-5612 Transfer from Reserve (Acct 2051)0000#DIV/0!
TOTAL WATER DISTRIBUTION CAPITAL0000000#DIV/0!

ACCOUNT/DESCRIPTION2020 Budget INFRASTRUCTURE MAINTENANCE2021 Budget To Date2021 ActualVar. PAGE 55% Var.Completed
ACCOUNT/DESCRIPTION2020 Budget ActualVar.2021 Budget2021 Budget To Date2021 ActualVar. PAGE 55% Var.Completed
WATER DISTRIBUTION NETWORK - STAFFING COSTS
6035-02-31-304-001 Regular Salaries & Wages132,782167,78134,999203,3150#DIV/0!0.00%
6057-02-31-304-001 Overtime8,00013,1275,1278,0000#DIV/0!0.00%
6067-02-31-304-001 Shift Premium6,00010,5674,5676,0000#DIV/0!0.00%
6069-02-31-304-001 Stat Time14,5159,654-4,86115,0000#DIV/0!0.00%
6078-02-31-304-001 Vacation Pay18,62819,6511,02319,0000#DIV/0!0.00%
6084-02-31-304-001 Sick Pay71,5188,961-62,55720,0000#DIV/0!0.00%
6091-02-31-304-001 Other Payroll Costs83,557104,36420,80781,9720#DIV/0!0.00%
5831-02-31-304-020 Misc Revenue-4,500-95,213-90,713-4,5000#DIV/0!0.00%
6011-02-31-304-001 Office Supplies4,5505,0244744,5500#DIV/0!0.00%
6025-02-31-304-309 Transfer to Capital Reserve081,71381,71300#DIV/0!#DIV/0!
6039-02-31-304-001 Employee Training8,0005,704-2,2966,5000#DIV/0!0.00%
6280-02-31-304-001 Safety Material2,0001,654-3462,0000#DIV/0!0.00%
6040-02-31-304-001 Clothing Allowance5,4004,347-1,0535,4000#DIV/0!0.00%
6051-02-31-304-001 Safety Equipment2,00091-1,9092,0000#DIV/0!0.00%
TOTAL STAFFING COST352,450337,425-15,025369,237000#DIV/0!
EQUIPMENT MAINTENANCE
6112-02-31-304-012 Small Equipment3,600400-3,2003,6000#DIV/0!0.00%
6118-02-31-304-012 Small Tools2,500776-1,7242,5000#DIV/0!0.00%
6135-02-31-304-012 Diesel4,500249-4,2514,5000#DIV/0!0.00%
TOTAL EQUIPMENT MAINTENANCE10,6001,425-9,17510,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,5002,6941942,5000#DIV/0!0.00%
6110-02-31-304-385 Vehicle Repairs1,200-192-1,3921,2000#DIV/0!0.00%
6128-02-31-304-385 Vehicle Licence1400-1401400#DIV/0!0.00%
TOTAL 2018 CHEV SILVERADO (F/A 7-0071)3,8402,502-1,3383,840000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGETPage 56
WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET
20202020202120212021%%
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,1201,4202,7000#DIV/0!0.00%
6110-02-31-304-333 Vehicle Repairs2,6001,071-1,5292,6000#DIV/0!0.00%
6128-02-31-304-333 Vehicle Licence275265-102750#DIV/0!0.00%
TOTAL 2009 CHEV SILVERADO (F/A 7-0039)5,5755,456-1195,575000#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,5005,0295294,5000#DIV/0!0.00%
6110-02-31-304-334 Vehicle Repairs3,0004,0141,0143,0000#DIV/0!0.00%
6128-02-31-304-334 Vehicle Licence275265-102750#DIV/0!0.00%
TOTAL 2013 CHEV SILVERADO (F/A 7-0050)7,7759,3081,5337,775000#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 & Oil033233200#DIV/0!#DIV/0!
6110-02-31-304-335 Vehicle Repairs0282800#DIV/0!#DIV/0!
6128-02-31-304-335 Vehicle Licence012012000#DIV/0!#DIV/0!
TOTAL 2005 CHEV SILVERADO (F/A 7-0042)04804800000#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,1201201,0000#DIV/0!0.00%
6110-02-31-304-337 Vehicle Repairs2,5002,9954952,5000#DIV/0!0.00%
6128-02-31-304-337 Vehicle Licence375361-143750#DIV/0!0.00%
TOTAL 2010 CHEV CUBE/UTILITY VAN (F/A 7-0041)3,8754,4766013,875000#DIV/0!

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

WATER DISTRIBUTION NETWORK - VEHICLE & HEAVY EQUIPMENT SUMMARY

2019 Case 590N Backhoe
6108-02-31-304-339 Vehicle Gas & Oil4,5003,538-9624,5000#DIV/0!0.00%
6110-02-31-304-339 Vehicle Repairs4,0004,7717714,5000#DIV/0!0.00%
6128-02-31-304-339 Vehicle Licence00000#DIV/0!#DIV/0!
TOTAL 2019 CASE BACKHOE8,5008,309-1919,000000#DIV/0!

WATER DISTRIBUTION NETWORK - WATER MAINS

WATER DISTRIBUTION NETWORK - WATER MAINS
6035-02-31-304-138 Regular Salary Wages30,00041,72311,72330,0000#DIV/0!0.00%
6057-02-31-304-138 Overtime6,500227-6,2734,5000#DIV/0!0.00%
6091-02-31-304-138 Other Benefits12,2418,126-4,11511,5410#DIV/0!0.00%
6303-02-31-304-138 Water Mains00000#DIV/0!#DIV/0!
6268-02-31-304-138 Water Mains; Materials16,00022,6376,63718,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 Services13,00022,0409,04015,0000#DIV/0!0.00%
6303-02-31-304-286 Water Mains Condition Rating5,0000-5,0005,0000#DIV/0!0.00%
6311-02-31-304-138 Water Mains Sampling Stations00000#DIV/0!#DIV/0!
TOTAL WATER MAINS82,74194,75312,01284,041000#DIV/0!

WATER DISTRIBUTION NETWORK - WATER SERVICES

WATER DISTRIBUTION NETWORK - WATER SERVICES
6035-02-31-304-328 Regular Salary Wages25,00024,078-92226,0000#DIV/0!0.00%
6057-02-31-304-328 Overtime2,100225-1,8752,1000#DIV/0!0.00%
6091-02-31-304-328 Other Benefits9,4854,662-4,8239,8350#DIV/0!0.00%
6268-02-31-304-328 Water Services; Materials20,00017,668-2,33220,0000#DIV/0!0.00%
6205-02-31-304-328 Water Services; Contracted Services32,00044,80512,80532,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 SERVICES88,58591,4382,85389,935000#DIV/0!

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

2020 ACCOUNT/DESCRIPTION2020 Budget INFRASTRUCTURE2020 ActualVar.2021 Budget Budget Maintenance2021 To Date2021 ActualVar.% Var.Completed

WATER DISTRIBUTION NETWORK - FIRE HYDRANTS/FLUSHING PROGRAM

6035-02-31-304-329 Regular Salary Wages26,84732,1595,31225,0000#DIV/0!0.00%
6057-02-31-304-329 Overtime80020-7808000#DIV/0!0.00%
6091-02-31-304-329 Other Benefits9,6766,441-3,2359,0300#DIV/0!0.00%
6268-02-31-304-329 Fire Hydrants; Materials9,00014,6485,64812,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,5002,554542,5000#DIV/0!0.00%
6306-02-31-304-138 Fire Hydrants00000#DIV/0!#DIV/0!
TOTAL FIRE HYDRANTS/FLUSHING PROGRAMS48,82355,8226,99949,330000.00%

WATER DISTRIBUTION NETWORK - VALVE MAINTENANCE/VALVE TURNING

6035-02-31-304-320 Regular Salary Wages20,00016,489-3,51118,0000#DIV/0!0.00%
6057-02-31-304-320 Overtime1,00014-9861,0000#DIV/0!0.00%
6091-02-31-304-320 Other Benefits7,3503,329-4,0216,6500#DIV/0!0.00%
6268-02-31-304-320 Valves; Materials7,50010,9343,43410,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 Services2,5005,8103,3104,0000#DIV/0!0.00%
6305-02-31-304-138 Valves00000#DIV/0!#DIV/0!
TOTAL VALVE MAINTENANCE/VALVE TURNING38,35036,576-1,77439,650000#DIV/0!

WATER DISTRIBUTION NETWORK - WATER METERS/METER READING

WATER DISTRIBUTION NETWORK - WATER METERS/METER READING
6035-02-31-304-331 Regular Salary Wages30,00029,079-92122,7000#DIV/0!0.00%
6057-02-31-304-331 Overtime00000#DIV/0!#DIV/0!
6091-02-31-304-331 Other Benefits9,9665,153-4,8137,4110#DIV/0!0.00%
6268-02-31-304-331 Water Meters; Materials35,00043,8238,82335,0000#DIV/0!0.00%
6205-02-31-304-331 Water Meters; Contracted Services4,500400-4,1004,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 READING79,46678,455-1,01169,611000#DIV/0!

ACCOUNT/DESCRIPTIONTOWN OF SMITHS FALLS 2021 BUDGET WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2020 BudgetTOWN OF SMITHS FALLS 2021 BUDGET WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2020 ActualTOWN OF SMITHS FALLS 2021 BUDGET WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2021 Var.TOWN OF SMITHS FALLS Page 59 WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2021 BudgetTOWN OF SMITHS FALLS Page 59 WORKS & UTILITIES DEPARTMENTAL GENERAL BUDGET 2021 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 Wages25,00028,4183,41824,0000#DIV/0!0.00%
6057-02-31-304-332 Overtime25080-1702500#DIV/0!0.00%
6091-02-31-304-332 Other Benefits8,8385,427-3,4118,4880#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,4002,1217211,4000#DIV/0!0.00%
TOTAL ONTARIO ONE CALLS35,48836,04655834,138000#DIV/0!
WATER DISTRIBUTION NETWORK - AIR CARE DR BUILDING
6184-02-31-304-051 Supplies650219-4316500#DIV/0!0.00%
6112-02-31-304-051 Equipment1,700466-1,2341,7000#DIV/0!0.00%
6102-02-31-304-158 Telephone4,5009,7625,2628,0000#DIV/0!0.00%
TOTAL AIR CARE DR BUILDING6,85010,4473,59710,350000#DIV/0!
* Utilities for Air Care Dr. Bldg; under Tax-Supported Budget
TOTAL WATER DISTRIBUTION GENERAL772,918772,9180786,957000#DIV/0!
TOTAL WATER DISTRIBUTION BUDGET772,918772,9180786,957000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

CORPORATE SERVICES CAPITAL BUDGET

ADMINISTRATION

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
6639-01-41-101-000 Land Needs Study00020,0000#DIV/0!0.00%
6833-01-41-101-000 Secondary Plan15,0000-15,00070,0000#DIV/0!0.00%
6283-01-41-101-000 Zoning Bylaw Update00050,0000#DIV/0!0.00%
6838-01-41-101-000 Development Charge Study30,0006,548-23,45223,4520#DIV/0!0.00%
5612-01-41-101-000 Tsf from Reserve (Account 2051)038,45238,452-38,4520#DIV/0!0.00%
5612-01-41-101-309 Trsf from Capital Reserve (Account 2083)-45,000-45,0000-125,0000#DIV/0!0.00%
01-41-101-352-5421 Provincial Grant; Immigration Information Online0000#DIV/0!#DIV/0!
01-41-101-352-6655 Immigration Information Online Project0000#DIV/0!#DIV/0!
01-41-101-352-6836 Trsf to/from Deferred Revenue (MILO Project)05,1625,1620#DIV/0!#DIV/0!
01-41-101-000-5424 Federal Grant-Local Immigration0-29,934-29,9340#DIV/0!#DIV/0!
01-41-101-000-6774 Local Immigration Project024,77224,7720#DIV/0!#DIV/0!
TOTAL ADMINISTRATION CAPITAL0000000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

CORPORATE SERVICES GENERAL BUDGET

January 10, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ADMINISTRATION
5499-02-41-101-020 GST- Rebate-3,300-2,358942-3,3000 #DIV/0!0.00%
5511-02-41-101-020 Tax Certificates-5,000-15,770-10,770-5,0000 #DIV/0!0.00%
5514-02-41-101-020 Business Licenses-2,000-1,800200-5000 #DIV/0!0.00%
5516-02-41-101-020 Interest on Investments-70,000-173,017-103,017-70,0000 #DIV/0!0.00%
6025-02-41-101-000 Trsf interest to reserve accounts0120,610120,61000 #DIV/0!0.00%
6836-02-41-101-000 Trst interest; deferred revenue07,9407,94000 #DIV/0!0.00%
5518-02-41-101-020 Interest/Penalty on Taxes-235,000-96,324138,676-178,0000 #DIV/0!0.00%
5519-02-41-101-020 NSF Cheque Fees-1,800-6801,120-1,8000 #DIV/0!0.00%
5520-02-41-101-020 Postage Charges - Other-15,000-18,119-3,119-15,0000 #DIV/0!0.00%
5521-02-41-101-020 Photocopy Charges - Other-1,000-31969-1,0000 #DIV/0!0.00%
5556-02-41-101-020 Misc. Revenue0-17,598-17,59800 #DIV/0!0.00%
6025-02-41-101-000 Trsf to Capital Reserve (Surplus TCA)016,64616,64600 #DIV/0!0.00%
5562-02-41-101-020 Death Registrations-3,00003,000-3,0000 #DIV/0!0.00%
5563-02-41-101-020 Marriage Licenses-5,0006905,690-4,0000 #DIV/0!0.00%
5658-02-41-101-020 Comm. of Oath Fees-600-56535-5000 #DIV/0!0.00%
5875-02-41-101-020 Freedom of Info Fees-50-3515-500 #DIV/0!0.00%
6618-02-41-101-020 Tax Letters-750-375375-5000 #DIV/0!0.00%
TOTAL ADMINISTRATION REVENUE-342,500-180,786161,714-282,6500000 #DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET CORPORATE SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTIONJanuary 18, 2021 2020 BudgetJanuary 18, 2021 2020 Actual ActualJanuary 18, 2021 Var. Var.January 18, 2021 2021 Budget BudgetJanuary 18, 2021 2021 To Date TotalJanuary 18, 2021 2021 Actual TotalJanuary 18, 2021 Var. Var.January 18, 2021 % Var. Var.January 18, 2021 % Completed Total
6035-02-41-101-000 Regular Salaries & Wages660,356703,26842,912686,4170#DIV/0!0.00%
6048-02-41-101-000 Part Time Wages021,01521,01500#DIV/0!#DIV/0!
6091-02-41-101-000 Other Payroll Costs209,575205,655-3,920205,4000#DIV/0!0.00%
6025-02-41-101-000 Trsf to Payroll Reserve (Surplus Group Benefits)-8,000-31,634-23,63400#DIV/0!#DIV/0!
6792-02-41-101-413 COVID-19 Expenditures01,7941,79400#DIV/0!#DIV/0!
6011-02-41-101-000 Office Supplies *18,00020,6412,64118,0000#DIV/0!0.00%
6015-02-41-101-000 Travel Expenses5,0001,261-3,7395,0000#DIV/0!0.00%
6015-02-41-101-389 Travel Expenses (Cannabis Legalization)00000#DIV/0!#DIV/0!
6180-02-41-101-389 Travel Expenses (Cannabis Legalization)00000#DIV/0!#DIV/0!
6836-02-41-101-389 Trsf from Deferred Revenue (Cannabis Legalization Grant)00000#DIV/0!#DIV/0!
6017-02-41-101-000 Coffee/Food Supplies3,000710-2,2902,0000#DIV/0!0.00%
6019-02-41-101-000 Photocopy Supplies2,0001,025-9752,0000#DIV/0!0.00%
6023-02-41-101-000 Postage33,00031,418-1,58235,0000#DIV/0!0.00%
6026-02-41-101-000 Printing4,0002,993-1,0074,0000#DIV/0!0.00%
6029-02-41-101-000 Membership Fees4,5004,286-2145,0000#DIV/0!0.00%
6032-02-41-101-000 Conferences5,00079-4,9215,0000#DIV/0!0.00%
6038-02-41-101-000 Advertising6,5009,1052,6056,5000#DIV/0!0.00%
6039-02-41-101-000 Staff Training & Develop.25,0001,575-23,42518,0000#DIV/0!0.00%
6042-02-41-101-000 Courier500168-3325000#DIV/0!0.00%
6051-02-41-101-000 Health & Safety3,0001,199-1,8014,0000#DIV/0!0.00%
6101-02-41-101-000 Interest from Tax Write Off00000#DIV/0!#DIV/0!
6102-02-41-101-000 Telephone4,0005,2721,2725,5000#DIV/0!0.00%
6103-02-41-101-000 Fax2000-20000#DIV/0!#DIV/0!
6173-02-41-101-000 Insurance110,000107,997-2,003129,5960#DIV/0!0.00%
6025-02-41-101-000 Transfer to Reserve (Account 2051)00000#DIV/0!#DIV/0!
6174-02-41-101-000 Audit Fees35,00028,785-6,21532,0000#DIV/0!0.00%
6178-02-41-101-000 Bank Service Fees3,0004,1301,1303,0000#DIV/0!0.00%
6258-02-41-101-000 Cash Short & Over0-89-8900#DIV/0!#DIV/0!
6180-02-41-101-000 Professional Fees60,00072,16712,16760,0000#DIV/0!0.00%
5612-02-41-101-000 Transfer from Reserve (Account 2051)-18,397-3,39715,000-15,0000#DIV/0!0.00%
6175-02-41-101-000 Support - Main Hdwe30,00027,037-2,96335,0000#DIV/0!0.00%
6027-02-41-101-000 Photocopier Lease12,0007,468-4,53212,0000#DIV/0!0.00%
6564-02-41-101-000 Mail Sorter3,0002,543-4573,0000#DIV/0!0.00%
TOTAL ADMINISTRATION EXPENSES1,210,2341,226,47116,2371,261,913000#DIV/0!

January 18, 2021TOWN OF SMITHS FALLS 2021 BUDGET CORPORATE SERVICES GENERAL BUDGETPage 63
January 18, 2021PROPERTY ASSESSMENT
6259-02-41-101-000 Levy per Assess. Agency101,037101,225188101,0370#DIV/0!0.00%
TOTAL PROPERTY ASSESSMENT101,037101,225188101,037000#DIV/0!
TOTAL ADMINISTRATION GENERAL968,7711,146,910178,1391,080,300000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

CORPORATE SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
TAXATION REVENUE
5111-02-41-410-077 Residential-9,135,183-9,135,1821-9,342,8600#DIV/0!0.00%
5121-02-41-410-077 Commercial-3,381,580-3,381,5800-3,389,5810#DIV/0!0.00%
5141-02-41-410-077 Farmland-484-4840-4890#DIV/0!0.00%
5151-02-41-410-077 Pipeline-55,675-55,6750-57,2310#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-439,087-438,857230-684,8000#DIV/0!0.00%
5181-02-41-410-077 Multi-Residential-1,344,611-1,344,6110-1,348,7000#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-51,225-53,392-2,167-100,0000#DIV/0!0.00%
5221-02-41-410-077 Commercial Supplemental-37,500-110,538-73,038-60,0000#DIV/0!0.00%
5271-02-41-410-077 Industrial Supplemental-500,000-281,018218,982-50,0000#DIV/0!0.00%
5281-02-41-410-077 Multi-Res Supplemental-6,00006,000-75,0000#DIV/0!0.00%
5850-02-41-410-077 Capping Adjustment0545400#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 18 of 2055,00054,365-63536,6420#DIV/0!0.00%
6376-02-41-410-077 Vacancy Rebate *60,00015,576-44,42430,0000#DIV/0!0.00%
6241-02-41-410-077 Rebate Registered Charities15,0004,371-10,62910,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 10 AA5,5006,1246246,1250#DIV/0!0.00%
6242-02-41-410-077 Tax W/O Residential15,0003,680-11,32010,0000#DIV/0!0.00%
6243-02-41-410-077 Tax W/O Commercial150,000181,99531,995100,0000#DIV/0!0.00%
6246-02-41-410-077 Tax W/O Pipeline0-1,226-1,22600#DIV/0!#DIV/0!
6249-02-41-410-077 Tax W/O Multi Res71,00010,584-60,41610,0000#DIV/0!0.00%
6856-02-41-410-077 Write-offs (Failed Tax Sales)026426400#DIV/0!#DIV/0!
5612-02-41-410-077 Transfer from Reserve **-88,746088,74600#DIV/0!#DIV/0!
6025-02-41-410-077 Transfer to Reserve0000#DIV/0!
6248-02-41-410-077 Tax W/O Industrial14,50029,41414,91410,0000#DIV/0!0.00%
** Reserve account 02-41-101-111-2271
TOTAL UNALLOCATED REVENUE-14,669,723-14,511,003158,720-14,911,526000#DIV/0!

TOTAL UNALLOCATED REVENUE

Current estimated taxation revenue is calculated at 2020 average CPI @1.1% (period ending September 30, 2020); Increase of $157 K

Subject to change; estimated sup billing for 99 Lorne St.; less decreased sup billing for 1 Hershey Dr.

$ ^{ \land\land} $ This will cease in 2021 as these properties are now tax exempt so the revenue will be decreased as will this expense account.


TOWN OF SMITHS FALLS 2021 BUDGET CORPORATE SERVICES GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
PAYMENTS IN LIEU OF TAXES
5313-02-41-410-077 Ontario Hospitals-8,700-7,800900-8,7000#DIV/0!0.00%
5314-02-41-410-077 Ontario Hydro-22,000-21,687313-22,0000#DIV/0!0.00%
5316-02-41-410-077 Water Department-300,000-289,18910,811-300,0000#DIV/0!0.00%
5318-02-41-410-077 MTO0-60-6000#DIV/0!#DIV/0!
02-41-410-077-5321 Province - OPP *-179,000-168,75410,246-169,0000#DIV/0!0.00%
02-41-410-077-6735 Montague - OPP90,00084,377-5,62384,4400#DIV/0!0.00%
02-41-410-077-6839 Montague - Gallipeau Centre *69,00059,532-9,46864,5600#DIV/0!0.00%
5319-02-41-410-077 Public Works Canada-170,000-170,951-951-174,0000#DIV/0!0.00%
TOTAL PAYMENTS IN LIEU-520,700-514,5326,168-524,700000#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-532,704-532,7040-556,9180#DIV/0!0.00%
6025-02-41-410-077 Allocation of Gas Tax532,704532,7040556,9180#DIV/0!0.00%
02-41-410-077-6025/5612 Tsf to/frm Reserve016,34416,34400#DIV/0!#DIV/0!
5900-02-41-410-077 OCIF Formula-based Funding-613,765-604,5889,177-613,7650#DIV/0!0.00%
6025-02-41-410-077 Allocation of OCIF Formula-Based Funding613,765604,588-9,177613,7650#DIV/0!0.00%
5442-02-41-410-077 Provincial Offences Revenue-52,40087353,273-52,4000#DIV/0!0.00%
TOTAL ONTARIO GRANTS-3,638,600-3,568,98369,617-3,638,600000#DIV/0!
TOTAL REVENUE-18,829,023-18,594,518234,505-19,074,826000#DIV/0!
  • Confirmed 2021 Allocation on October 30, 2020

TOWN OF SMITHS FALLS 2021 BUDGET CORPORATE SERVICES CAPITAL BUDGET

January 10, 202120202020202120212021%%
ACCOUNT/DESCRIPTIONBudgetActualVar.BudgetTo DateActualVar.
COMPUTER/INFORMATIONTECHNOLOGYCAPITAL
5612-01-31-335-000 Transfer from Reserve (Acct 2051)-15,084015,084-74,4460#DIV/0!#REF!
6175-01-31-335-288 Outlook Exchange Server5,0840-5,0845,0840#DIV/0!0.00%
6840-01-31-335-000 Website/Rebranding*07,0687,06821,9060#DIV/0!0.00%
6025-01-31-335-000 Transfer to Reserve020,38820,3880#DIV/0!0.00%
5612-01-31-335-309 Trsf from Capital Reserve (Acct 2083)-30,000-30,0000-20,0000#DIV/0!0.00%
6808-01-31-335-360 Data/Records Retention20,0000-20,00050,0000#DIV/0!0.00%
6429-01-31-335-000 Cyber Security/IT Review20,0002,544-17,45617,4560#DIV/0!0.00%
* Rebranding/Signage only in 2018

TOTAL INFORMATION TECHNOLOGY

COMPUTER/INFORMATION TECHNOLOGY GENERAL

ACCCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
COMPUTER/INFORMATION TECHNOLOGY
6035-02-31-335-000 Salaries42,09244,3522,26042,9340#DIV/0!0.00%
6091-02-31-335-000 Benefits12,76013,66190114,2200#DIV/0!0.00%
6011-02-31-335-000 Ink Cartridges/Office Supplies1,000199-8011,0000#DIV/0!0.00%
6792-02-31-335-413 COVID-19 Expenditures08,8988,89800#DIV/0!#DIV/0!
6039-02-31-335-000 Employee Training/Membership3,000361-2,6392,0000#DIV/0!0.00%
6015-02-31-335-000 Travel1,00015-9851,0000#DIV/0!0.00%
6020-02-31-335-000 Software15,0006,617-8,38311,5870#DIV/0!0.00%
6102-02-31-335-000 Telephone1,5001,420-801,5000#DIV/0!0.00%
6118-02-31-335-000 Tools & Equipment15,0009,212-5,78813,0000#DIV/0!0.00%
6150-02-31-335-000 Connectivity *30,00045,81415,81430,0000#DIV/0!0.00%
6840-02-31-335-000 Website Maintenance12,00013,6231,62314,0000#DIV/0!0.00%
6474-02-31-335-000 Computer Lease42,00044,4922,49244,0000#DIV/0!0.00%
6176-02-31-335-000 Computer Maintenance15,00012,357-2,64316,0000#DIV/0!0.00%
6177-02-31-335-000 Support - Main Software3,5004,3348344,0000#DIV/0!0.00%
TOTAL INFORMATION TECHNOLOGY193,852205,35511,503195,241000#DIV/0!
  • Upgrade battery back-up for servers

TOWN OF SMITHS FALLS 2021 BUDGET CORPORATE SERVICES GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
PLANNING/ADMINISTRATION
5567-02-41-415-020 Site Plan Control Fees-6,000-18,500-12,500-8,0000#DIV/0!0.00%
5568-02-41-415-020 PAC-4,000-10,000-6,000-4,0000#DIV/0!0.00%
5569-02-41-415-020 Application Fees-9,000-21,820-12,820-9,0000#DIV/0!0.00%
02-41-415-020-5881 PIL Parking00000#DIV/0!#DIV/0!
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,500754-7461,5000#DIV/0!0.00%
6011-02-41-415-001 Office Supplies2,000343-1,6572,0000#DIV/0!0.00%
6027-02-41-415-001 Photocopier Lease ("New")5,000162-4,8385,0000#DIV/0!0.00%
6035-02-41-415-001 Regular Salaries & Wages &&167,209172,8995,690176,8200#DIV/0!0.00%
6048-02-41-415-001 Part-time Wages7,8400-7,8408,1400#DIV/0!0.00%
6078-02-41-415-001 Vacation Pay3140-3143260#DIV/0!0.00%
6091-02-41-415-001 Other Payroll Costs52,77649,437-3,33953,7900#DIV/0!0.00%
6088-02-41-415-001 COA Honorarium1,5001,475-251,5000#DIV/0!0.00%
6057-02-41-415-375 Overtime (Shared Service; Montague)12,0009,280-2,72012,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-16,997-4,997-12,0000#DIV/0!0.00%
6015-02-41-415-001 Travel500-53-5535000#DIV/0!0.00%
6019-02-41-415-001 Photocopy Supplies2,000612-1,3882,0000#DIV/0!0.00%
6023-02-41-415-001 Postage5009504507000#DIV/0!0.00%
6032-02-41-415-001 Conferences2,000402-1,5982,0000#DIV/0!0.00%
6038-02-41-415-001 Advertising & Promotion2,0001,280-7202,0000#DIV/0!0.00%
6039-02-41-415-001 Staff & Committee Training6,0000-6,0005,0000#DIV/0!0.00%
6845-02-41-415-001 Community Improvement Plan *44,21539,026-5,18945,0000#DIV/0!0.00%
5612/6025-02-41-415-001 Trsf from Reserve (Acct 2051)05,1895,189-15,0000#DIV/0!0.00%
6042-02-41-415-001 Courier1000-1001000#DIV/0!0.00%
6102-02-41-415-001 Telephone2,0001,260-7403,0000#DIV/0!0.00%
6175-02-41-415-001 Computer Main Hardware/Website Maintenance9,5008,996-50410,0000#DIV/0!0.00%
6180-02-41-415-001 Professional/Advisory Fees15,0006,394-8,60614,5000#DIV/0!0.00%
TOTAL PLANNING302,954231,089-71,865297,876000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

CORPORATE SERVICES GENERAL BUDGET

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
BUILDING SERVICES DEPARTMENT
5528-02-31-325-020 Zoning Certificates-2,000-3,000-1,000-2,0000 #DIV/0!0.00%
5531-02-31-325-020 Building Permits-400,000-322,47877,522-500,0000 #DIV/0!0.00%
5656-02-31-325-020 Sign Permits-2,000-1,531469-1,0000 #DIV/0!0.00%
6035-02-31-325-001 Regular Salaries & Wages145,378149,5764,198234,5660 #DIV/0!0.00%
6091-02-31-325-001 Other Payroll Costs38,84840,4621,61444,7500 #DIV/0!0.00%
6011-02-31-325-001 Office Supplies *3,5001,570-1,93020,0000 #DIV/0!0.00%
6027-02-31-325-001 Photocopier Lease5,0000-5,0005,0000 #DIV/0!0.00%
02-31-325-001-6015 Travel3,000496-2,5046,0000 #DIV/0!0.00%
6019-02-31-325-001 Photocopier Lease Supplies1,000446-5541,0000 #DIV/0!0.00%
6020-02-31-325-001 CBO Computer Software19,0009,232-9,76810,0000 #DIV/0!0.00%
xxxx-02-31-325-001 Upgrade Website Presence "New"15,0000 #DIV/0!0.00%
6023-02-31-325-001 Postage2002-1982000 #DIV/0!0.00%
6029-02-31-325-001 Membership Fees2,000548-1,4522,0000 #DIV/0!0.00%
6038-02-31-325-001 Advertising & Promotion2,5002,015-4852,5000 #DIV/0!0.00%
6039-02-31-325-001 Employee Training3,5000-3,5003,5000 #DIV/0!0.00%
6040-02-31-325-001 Clothing & Supplies2,0000-2,0002,0000 #DIV/0!0.00%
02-31-325-001-6102 Telephone2,5002,114-3863,0000 #DIV/0!0.00%
02-31-325-001-6164 Liability Insurance Claim75,0000-75,0007,5000 #DIV/0!0.00%
6180-02-31-325-001 Professional Fees130,00040,283-89,71760,0000 #DIV/0!0.00%
5612/6025-02-31-325-001 Tsf to/frm Reserve-29,42680,265109,69185,9840 #DIV/0!0.00%
TOTAL BUILDING INSPECTION0000000#DIV/0!
  • $15,000 for purchase of office furniture (Building/Planning)

Photocopier lease potential increase in 2021; confirm with Director?


TOWN OF SMITHS FALLS 2021 BUDGET CORPORATE SERVICES BYLAW/PARKING CAPITAL BUDGET

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.Completed

ENFORCEMENT SERVICES (PARKING & BYLAW)

PARKING
6818-01-21-225-000 Parking Inventory/Study *18,2905,750-12,5400#DIV/0!#DIV/0!
5852-01-21-225-076 Capital Financing-100,0000100,0000#DIV/0!#DIV/0!
6072-01-21-225-000 Parking Equipment100,0000-100,00025,000
5612-01-21-225-000 Transfer from Reserve (Acct 2051)-18,290-3,81914,4710#DIV/0!#DIV/0!
5612-01-21-225-309 Transfer from Capital Reserve0-1,931-1,931-25,0000#DIV/0!0.00%
*Carry-over from 2018
TOTAL BYLAW/TRAFFIC0000000#DIV/0!

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

Page 70 GENERAL BUDGET

2020 ACCOUNT/DESCRIPTION2020 Budget2020 Actual2021 Var.2021 Budget2021 To Date% Var.% Var.
5535-02-21-225-020Parking Meter Income *-20,000-16,0213,97900#DIV/0!
5536-02-21-225-020Parking Lot-6,000-1,9824,018-6,0000#DIV/0!
5537-02-21-225-020Parking Fines-4,000-12,870-8,870-3,0000#DIV/0!
5538-02-21-225-020County Court Fines-2,000-4,175-2,175-5000#DIV/0!
xxxx-02-21-225-020Electric Charging Stations; Revenue00000#DIV/0!
6011-02-21-225-001Office Supplies1,00077-9235000#DIV/0!
6012-02-21-225-001Parking Meter Loan/Principal8,6918,69108,9710#DIV/0!
6014-02-21-225-001Parking Meter Loan/Interest1,2381,23809590#DIV/0!
6015-02-21-225-001Travel5000-50000#DIV/0!
6019-02-21-225-001Photocopier Lease Supplies5007-49300#DIV/0!
6023-02-21-225-001Postage1,0001,1991991,0000#DIV/0!
6026-02-21-225-001Printing ( Tickets)2,0000-2,0002,0000#DIV/0!
6027-02-21-225-001Photocopier Lease2,0007-1,99300#DIV/0!
6035-02-21-225-001Regular Salaries & Wages **41,45944,1632,70442,2880#DIV/0!
6091-02-21-225-001Other Payroll Costs8,03011,6893,6599,8700#DIV/0!
6039-02-21-225-001Employee Training5000-50000#DIV/0!
6020-02-21-225-001CGIS Software6,5004,824-1,6766,5000#DIV/0!
6102-02-21-225-001Telephone1,5001,560601,5000#DIV/0!
6105-02-21-225-001Hydro1,000823-1771,0000#DIV/0!
6112-02-21-225-001Equipment for Enforcement3,0000-3,00000#DIV/0!
xxxx-02-21-225-001Electric Charging Stations "New"6,0000#DIV/0!
6118-02-21-225-001Tools, Accessories, etc30030335000#DIV/0!
6173-02-21-225-001Insurance500540406480#DIV/0!
02-21-225-001-6180Professional Fees10,0001,067-8,9335,0000#DIV/0!
6185-02-21-225-001Enforcement Fees94,00060,426-33,574100,0000#DIV/0!
02-21-225-413-6792COVID-19 Expenditures09,3069,30600#DIV/0!
TOTAL BYLAW/TRAFFIC151,718110,872-40,846177,23600#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 10, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
ANIMAL CONTROL
5564-02-21-226-020 Dog Tags-2,000-1,425575-1,5000#DIV/0!
6048-02-21-226-001 Part Time Salaries00000#DIV/0!
6035-02-21-226-001 Salaries00000#DIV/0!
6091-02-21-226-001 Benefits00000#DIV/0!
02-21-226-001-6011 Office Supplies20020662000#DIV/0!
6180-02-21-226-001 Professional Fees45,00036,662-8,33847,0000#DIV/0!
6224-02-21-226-001 Pound Services20,00015,472-4,52817,0000#DIV/0!
6453-02-21-226-001 Emergency Vet Services2,0001,466-5342,0000#DIV/0!
6110-02-21-226-001 Dog Pick-up Bags & Dispensers2,000595-1,4052,0000#DIV/0!
TOTAL ANIMAL CONTROL67,20052,976-14,22466,700000#DIV/0!
CROSSING GUARDS
6048-02-31-305-001 Part Time Salaries *36,60019,268-17,33235,4650#DIV/0!
6078-02-31-305-001 Vacation Pay1,464978-4861,4190#DIV/0!
6091-02-31-305-001 Benefits3,7051,806-1,8993,3960#DIV/0!
6040-02-31-305-001 Clothing & Supplies2,000510-1,4902,0000#DIV/0!
TOTAL CROSSING GUARDS43,76922,562-21,20742,280000#DIV/0!
* Crossing guards were laid off as of March 31, 2020
TOTAL BYLAW ENFORCEMENT GENERAL262,687186,41076,277286,216000#DIV/0!
TOTAL BYLAW ENFORCEMENT262,687186,41076,277286,216000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

PUBLIC WORKS & UTILITIES CAPITAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ENGINEERING; CAPITAL WORKS
01-31-320-290-6767 Lower Reach Park Sewer Lining0000#DIV/0!#DIV/0!
01-31-320-000-5612 Trsf from Reserve (Acct 2051)0000#DIV/0!#DIV/0!
01-31-320-000-5869 Federal Gas Tax0000#DIV/0!#DIV/0!
01-31-320-290-6846 Lower Reach Park Remediation0000#DIV/0!#DIV/0!
01-31-320-000-6733 Upgrade Autocad0000#DIV/0!#DIV/0!
01-31-320-000-6830 Asset Management Plan; Phase II0000#DIV/0!#DIV/0!
TOTAL ENGINEERING CAPITAL WORKS0000000#DIV/0!

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

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ENGINEERING ADMINISTRATION
5529-02-31-320-020 Permits & Other Fees-5,000-3,3001,700-4,5000 #DIV/0!0.00%
6011-02-31-320-001 Engineering Supplies2,5001,281-1,2192,0000 #DIV/0!0.00%
6015-02-31-320-001 Travel1,500115-1,3857500 #DIV/0!0.00%
6019-02-31-320-001 Photocopy Supplies & Printing1,400753-6471,4000 #DIV/0!0.00%
6027-02-31-320-001 Leases3,7001,685-2,0153,7000 #DIV/0!0.00%
6029-02-31-320-001 Membership Fees2,5002,164-3362,5000 #DIV/0!0.00%
6032-02-31-320-001 Conferences1,5001,542429000 #DIV/0!0.00%
6039-02-31-320-001 Staff Training2,500494-2,0062,0000 #DIV/0!0.00%
6040-02-31-320-001 Clothing & Supplies300102-1983000 #DIV/0!0.00%
6180-02-31-320-001 Professional Fees6,5006,6091097,0000 #DIV/0!0.00%
6114-02-31-320-001 Town Equipment00000 #DIV/0!#DIV/0!
5902-02-31-320-001 Town Equipment Adjustment00000 #DIV/0!#DIV/0!
6180-02-31-320-295 Professional Fees (Wood Ave. Subdivision)00000 #DIV/0!#DIV/0!
6108-02-31-320-011 Vehicle Gas & Oil (New vehicle; replaced in 2017)*00000 #DIV/0!#DIV/0!
6128-02-31-320-011 Vehicle Licence (New vehicle; replaced in 2017) *00000 #DIV/0!#DIV/0!
6110-02-31-320-011 Vehicle Repairs (New vehicle; replaced in 2017) *00000 #DIV/0!#DIV/0!
6110-02-31-320-012 Equipment Repairs1,0000-1,00000 #DIV/0!#DIV/0!
* Reallocated to PW Fleet; Schedule C
TOTAL ENGINEERING ADMINISTRATION GENERAL BUDGET18,40011,445-6,95516,050000#DIV/0!
ENGINEERING WAGES AND BENEFITS
6035-02-31-320-125 Regular Salaries & Wages *68,01668,85784169,7950 #DIV/0!
6048-02-31-320-125 Part Time Wages **7,8400-7,8408,1400 #DIV/0!
6078-02-31-320-125 Vacation Pay3140-3143260 #DIV/0!
6091-02-31-320-125 Other Payroll Costs26,14121,041-5,10021,8840 #DIV/0!
* Includes 10% of Director; 1 student only
TOTAL ENGINEERING WAGES AND BENEFITS102,31189,898-12,413100,145000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET PUBLIC WORKS & UTILITIES

January 10, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
SOLID WASTE MANAGEMENT; COLLECTION & DISPOSAL
5588-02-31-322-071 Garbage Tags-14,500-21,203-6,703-14,5000#DIV/0!
xxxx-02-31-322-071 Landfill Monitoring "New"6,0000#DIV/0!
6233-02-31-322-071 Collection Contract150,000150,878878153,0000#DIV/0!
6233-02-31-322-291 Collection Contract; Dumpsters67,50061,942-5,55866,5000#DIV/0!
6273-02-31-322-291 Disposal Contract; Dumpsters49,50046,466-3,03448,0000#DIV/0!
6273-02-31-322-071 Disposal Contract237,500251,51214,012248,0000#DIV/0!
TOTAL WASTE COLL/DISP490,000489,595-405507,000000#DIV/0!
RECYCLING & COMPOSTING
6038-02-31-322-072 Advertising & Promotion8,5006,218-2,2828,5000#DIV/0!
6274-02-31-322-072 Recycling Contract272,500213,752-58,748272,5000#DIV/0!
5601-02-31-322-020 Recycling Revenue00000#DIV/0!
5602-02-31-322-072 Recycling Bin Sales-200-90110-1500#DIV/0!
5594-02-31-322-072 Rain Barrel Revenue00000#DIV/0!
6746-02-31-322-072 Blue Boxes4,8002,823-1,9774,8000#DIV/0!
6825-02-31-322-072 Environmental Initiatives0-40-4000#DIV/0!
5864-02-31-322-020 WDO Revenue-70,939-75,979-5,040-71,0000#DIV/0!
6366-02-31-322-072 Hazardous Waste Day10,50010,499-111,5000#DIV/0!
5573-02-31-322-072 Composter Sales-240-430-190-1500#DIV/0!
6159-02-31-322-072 Site Preparation*15,00016,4271,42720,0000#DIV/0!
6035-02-31-322-072 Regular Salaries & Wages18,79122,4773,68619,1670#DIV/0!
6048-02-31-322-072 Part time Wages15,7926,604-9,18814,5920#DIV/0!
6078-02-31-322-072 Vacation Pay632307-3255840#DIV/0!
6091-02-31-322-072 Other Payroll Costs8,6447,340-1,3048,1300#DIV/0!
6592-02-31-322-072 Yard Waste Pick-up12,00011,325-67517,0000#DIV/0!
* Chipping 14,000/Salt Mgmt 3,000/Compost Screening 3,000
TOTAL RECYCLING & COMPOSTING295,780221,233-74,547305,473000#DIV/0!
TOTAL SOLID WASTE MANAGEMENT785,780710,828-74,952812,473000#DIV/0!
TOTAL ENGINEERING GENERAL BUDGET906,491812,171-94,320928,668000#DIV/0!
TOTAL ENGINEERING BUDGET906,491812,171-94,320928,668000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

ECONOMIC DEVELOPMENT/TOURISM CAPITAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.Completed
01-41-420-000-6635 Development Cycle Tourism Strategy00002,5000#DIV/0!0.00%
01-41-420-309-5612 Transfer from Capital Reserve0000-5,0000#DIV/0!0.00%
01-41-420-000-6784 Update 2013 Cultural Plan2,5000#DIV/0!0.00%
0000#DIV/0!
TOTAL ECONOMIC DEVELOPMENT CAPITAL0000000#DIV/0!

TOWN OF SMITHS FAL 2021 BUDGET ECONOMIC DEVELOPMENT/ GENERAL BUDGET

TOURISM

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
ECONOMIC DEVELOPMENT
5586-02-41-420-020 Land Sales0-94,459-94,45900#DIV/0!#DIV/0!
5575-02-41-420-020 Rental Income (Property @54 Lombard St.)0-7,505-7,50500#DIV/0!#DIV/0!
6123-02-41-420-001 Expenditures (Property @54 Lombard St.)05,4095,40900#DIV/0!#DIV/0!
6025-02-41-420-001 Trsf to reserve (Property @54 Lombard St.)0-1,147-1,14700#DIV/0!#DIV/0!
6701-02-41-420-001 Land Purchases0375,844375,84400#DIV/0!#DIV/0!
6015-02-41-420-319 Travel & Hospitality *2,500878-1,6222,5000#DIV/0!0.00%
6011-02-41-420-001 Office Supplies2,0001,472-5282,0000#DIV/0!0.00%
6015-02-41-420-001 Travel Expense6,0002,906-3,0942,0000#DIV/0!0.00%
6019-02-41-420-001 Photocopy Supplies2,000849-1,1512,0000#DIV/0!0.00%
6023-02-41-420-001 Postage2508-2422500#DIV/0!0.00%
6029-02-41-420-001 Membership Fees8,0005,709-2,2918,0000#DIV/0!0.00%
6035-02-41-420-001 Regular Salaries & Wages158,424160,5762,152166,4970#DIV/0!0.00%
6048-02-41-420-001 Part-time Salaries & Wages &&45,69819,279-26,41941,7680#DIV/0!0.00%
6078-02-41-420-001 Vacation1,828738-1,0901,6710#DIV/0!0.00%
6091-02-41-420-001 Other Payroll Costs57,68452,132-5,55258,6730#DIV/0!0.00%
6038-02-41-420-001 Advertising & Promotion01,2061,20600#DIV/0!#DIV/0!
6039-02-41-420-001 Training & Development5,0004,536-4645,0000#DIV/0!0.00%
6042-02-41-420-001 Courier1000-1001000#DIV/0!0.00%
6060-02-41-420-001 Marketing35,00037,3932,39335,0000#DIV/0!0.00%
6769-02-41-420-001 Leverage %%30,00030,20820830,0000#DIV/0!0.00%
5421-21-41-420-414 RED Grant050,00050,000-24,0000#DIV/0!0.00%
6226-21-41-420-414 RED Expenditures **0-50,000-50,00024,0000#DIV/0!0.00%
6102-02-41-420-001 Telephone1,0001,7167161,0000#DIV/0!0.00%
6180-02-41-420-001 Professional Fees022,08922,08900#DIV/0!#DIV/0!
6036-02-41-420-001 Communications10,00012,8352,83510,0000#DIV/0!0.00%
6800-02-41-420-001 Doctor Recruitment15,00010,595-4,40515,0000#DIV/0!0.00%
02-41-420-001-6284 Property Appraisals/Legal Fees &15,0005,877-9,12315,0000#DIV/0!0.00%
02-41-420-001-6854 Trade Shows8,0006,018-1,9822,0000#DIV/0!0.00%
02-41-420-001-6651 Database Fees2,0001,067-9332,0000#DIV/0!0.00%
6025-02-41-420-001 Transfer To/From Reserve0-281,385-281,38500#DIV/0!#DIV/0!
TOTAL ADMINISTRATION405,484374,844-30,640400,459000#DIV/0!

%% - $ 20 K allocated for "Planning/Marketing Analysis/Lombard St."


TOWN OF SMITHS FALLS 2020 BUDGET ECONOMIC DEVELOPMENT/TOURISM

Society 10, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
SMALL BUSINESS ADVISORY CENTRE
5425-02-41-425-020 MEDT Ontario Grants0-163,499-163,4990#DIV/0!#DIV/0!
5557-02-41-425-020 County of Lanark0-16,000-16,0000#DIV/0!#DIV/0!
5561-02-41-425-020 Seminar Income0-809-8090#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 Supplies02,5402,5400#DIV/0!#DIV/0!
6048-02-41-425-001 Part-time Wages068,04668,0460#DIV/0!#DIV/0!
6057-02-41-425-001 Overtime0000#DIV/0!#DIV/0!
6078-02-41-425-001 Vacation077770#DIV/0!#DIV/0!
6091-02-41-425-001 Other Payroll07,2647,2640#DIV/0!#DIV/0!
6102-02-41-425-001 Communications (Telephone)01,0011,0010#DIV/0!#DIV/0!
6038-02-41-425-001 Advertising & Promotion04,9314,9310#DIV/0!#DIV/0!
6045-02-41-425-001 Seminar Expenses05,3145,3140#DIV/0!#DIV/0!
5559-02-41-425-098 Publication Sales0000#DIV/0!#DIV/0!
6015-02-41-425-098 Travel03833830#DIV/0!#DIV/0!
6380-02-41-425-001 Rent8,1008,10008,1000#DIV/0!0.00%
6560-02-41-425-001 Valley Heartland Admin Fee0000#DIV/0!#DIV/0!
6011-02-41-425-270 Office Supplies (MEDI Starter Co. Program)0000#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)04954950#DIV/0!#DIV/0!
6015-02-41-425-296 Travel (Summer Co. Program)0000#DIV/0!#DIV/0!
6045-02-41-425-296 Seminar Expenses (Summer Co. Program)04704700#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-965-9650#DIV/0!#DIV/0!
6226-02-41-425-296 Grants (Summer Co. Program)0000#DIV/0!#DIV/0!
6380-02-41-425-353 Rent (Extra Office Space) (MEDI Starter Co. Plus)01,8001,8000#DIV/0!#DIV/0!
6102-02-41-425-353 Communications (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!

TOWN OF SMITHS FALLS 2020 BUDGET COMMUNITY DEVELOPMENT GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
SMALL BUSINESS ADVISORY CENTRE
6048-02-41-425-353 Part-time Wages (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!
6078-02-41-425-353 Vacation (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!
6091-02-41-425-353 Other Benefits (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!
6015-02-41-425-353 Travel (MEDI Starter Co. Plus)0000#DIV/0!#DIV/0!
6045-02-41-425-353 Seminar Expenses (MEDI Starter Co. Plus)013,33713,3370#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)065,00065,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)015,61515,6150#DIV/0!#DIV/0!
TOTAL ENTERPRISE CENTRE8,1008,10008,100000#DIV/0!
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
6196-02-41-430-000 RIDEAU VALLEY CON. *49,84449,844049,8440#DIV/0!
TOTAL ECONOMIC DEVELOPMENT GENERAL463,428432,788-30,640458,403000#DIV/0!
  • Still not confirmed as of October 21, 2020

TOWN OF SMITHS FALLS 2021 BUDGET

ECONOMIC DEVELOPMENT/TOURISM GENERAL BUDGET

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
TOURISM
6196-02-21-267-001 Lanark County Tourism Membership00000#DIV/0!#DIV/0!
6788-02-21-266-001 Rideau Heritage Route10,0000-10,00010,0000#DIV/0!0.00%
6029-02-21-266-001 Tourism Membership2,5000-2,5002,5000#DIV/0!0.00%
6048-02-21-266-001 Part-time Staff **7,8400-7,8407,9800#DIV/0!0.00%
6078-02-21-266-001 Vacation3140-3143190#DIV/0!0.00%
6091-02-21-266-001 Other Benefits9520-9529380#DIV/0!0.00%
6062-02-21-266-001 General Tourism Marketing35,00029,783-5,21735,0000#DIV/0!0.00%
6854-02-21-266-001 Trade Shows5,0001,725-3,2755,0000#DIV/0!0.00%
6321-02-21-266-294 Event Contract Support14,5000-14,50014,5000#DIV/0!0.00%
6015-02-21-266-294 Travel & Hospitality (Paddlefest)00000#DIV/0!#DIV/0!
6015-02-21-266-001 Travel & Hospitality2,000137-1,8632,0000#DIV/0!0.00%
6038-02-21-266-001 Advertising1,000471-5291,0000#DIV/0!0.00%
6633-02-21-266-001 Tourism Investment & Development15,00020,9275,92715,0000#DIV/0!0.00%
6859-02-21-266-001 Municipal Reconciliation Projects8,000702-7,2988,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,00023,810-1,19025,0000#DIV/0!0.00%
6064-02-21-266-001 Event Sponsorship10,0003,423-6,57710,0000#DIV/0!0.00%
TOTAL TOURISM137,10680,978-56,128137,237000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

COMMUNITY SERVICES CAPITAL BUDGET

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 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 2021 BUDGET

COMMUNITY SERVICES GENERAL BUDGET

January 18,2021

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.Completed
HISTORICAL SERVICES
HERITAGE HOUSE - ADMINISTRATION
5421-02-21-260-020 Ontario Grants-22,240-22,440-200-22,4400#DIV/0!0.00%
5544-02-21-260-020 Program Fees-3,000-3,833-833-1,0000#DIV/0!0.00%
5555-02-21-260-020 Museum Memberships0-375-37500#DIV/0!#DIV/0!
5556-02-21-260-020 Gift Shop-300-673-373-4000#DIV/0!0.00%
5557-02-21-260-020 Donations-500-296204-5000#DIV/0!0.00%
5558-02-21-260-020 Admissions-300-1,408-1,108-4000#DIV/0!0.00%
5566-02-21-260-020 Hall Rentals-800-2,425-1,625-5000#DIV/0!0.00%
5906-02-21-260-020 RMEO reimbursement for wages-20,000-17,4802,520-20,0000#DIV/0!0.00%
6035-02-21-260-001 Regular Salaries & Wages39,88238,855-1,02739,8820#DIV/0!0.00%
6048-02-21-260-001 Part Time Wages28,42022,410-6,01028,9280#DIV/0!0.00%
6078-02-21-260-001 Vacation Pay2,030949-1,0811,1570#DIV/0!0.00%
6091-02-21-260-001 Other Payroll Costs13,12616,1413,01514,9480#DIV/0!0.00%
6836-02-21-260-001 Trsf from Deferred Revenue0-721-72100#DIV/0!#DIV/0!
6025-02-21-260-001 Trsf from Reserve00000#DIV/0!#DIV/0!
6011-02-21-260-001 Office Supplies2000-2002000#DIV/0!0.00%
6015-02-21-260-001 Travel/Professional Develop00000#DIV/0!#DIV/0!
6019-02-21-260-001 Photocopy Supplies10067-331000#DIV/0!0.00%
6023-02-21-260-001 Postage03300#DIV/0!#DIV/0!
6029-02-21-260-001 Membership Fees175100-751750#DIV/0!0.00%
6038-02-21-260-001 Advertising500430-704000#DIV/0!0.00%
6039-02-21-260-001 Staff Training1000-1001000#DIV/0!0.00%
6042-02-21-260-001 Courier0383800#DIV/0!#DIV/0!
6046-02-21-260-001 Program Supplies3001,7901,4902500#DIV/0!0.00%
6102-02-21-260-001 Telephone3,4005,1551,7553,4000#DIV/0!0.00%
6112-02-21-260-001 Equipment Repairs3006343343000#DIV/0!0.00%
6113-02-21-260-085 Exhibit Supplies400169-2313000#DIV/0!0.00%
6147-02-21-260-001 Gift Shop Supplies1,000125-8751,0000#DIV/0!0.00%
6025-02-21-260-001 Trsf to Reserve (Account 2051)00000#DIV/0!#DIV/0!
6173-02-21-260-001 Insurance1,5851,583-21,5850#DIV/0!0.00%
TOTAL ADMINISTRATION44,37838,7985,58047,485000#DIV/0!

TOTAL ADMINISTRATION


2021 BUDGET - HISTOR January 18, 2021

TOWN OF SMITHS FALLS Page 82 L SERVICES; HERITAGE HOUSE ADMINISTRATION

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
BUILDING MAINTENANCE
6105-02-21-260-010 Hydro10,0009,691-3098,5000#DIV/0!
6106-02-21-260-010 Water8001,2764768000#DIV/0!
6112-02-21-260-010 Equipment Repairs8001,5377378000#DIV/0!
6116-02-21-260-010 Janitorial Supplies30056-2443000#DIV/0!
6197-02-21-260-010 Janitorial Services5,0001,675-3,3255,0000#DIV/0!
6118-02-21-260-010 Tools, Accessories, etc200123-771500#DIV/0!
6142-02-21-260-010 Shrubbery00000#DIV/0!
5612-02-21-260-001 Transfer from Reserve00000#DIV/0!
6123-02-21-260-010 Property Repairs5009514515000#DIV/0!
6152-02-21-260-010 Property Lease010210200#DIV/0!
TOTAL BUILDING MAINTENANCE17,60015,411-2,18916,0500000#DIV/0!
JOB CREATION EMPLOYMENT GRANT
5421-02-21-260-088 Ontario Grant0000#DIV/0!
5424-02-21-260-088 Federal Grant0000#DIV/0!
6046-02-21-260-088 Program Supplies0000#DIV/0!
6048-02-21-260-088 Part Time Wages0000#DIV/0!
6078-02-21-260-088 Vacation Pay0000#DIV/0!
6091-02-21-260-088 Other Payroll Costs0000#DIV/0!
TOTAL EMPLOYMENT GRANT00000000#DIV/0!
TRILLIUM/DOCUMENTARY HERITAGE COMMUNITIES PROGRAM "DHCP"
5424-02-21-260-306 Federal Grant (Documentary Heritage Comm Program; DHCP)0000#DIV/0!
6836-02-21-260-306 Tsf to/frm Deferred Revenue (DHCP)0000#DIV/0!
6048-02-21-260-306 Part Time Wages (DHCP)0000#DIV/0!
6078-02-21-260-306 Vacation Pay (DHCP)0000#DIV/0!
6091-02-21-260-306 Benefits (DHCP)0000#DIV/0!
6046-02-21-260-306 Materials & Supplies (DHCP)0000#DIV/0!
6829-02-21-260-306 Catalogue & Interpretive (DHCP)0000#DIV/0!
5421-02-21-260-192 Ontario Grant (Trillium Grant)0000#DIV/0!
5424-02-21-260-192 Federal Grant0000#DIV/0!
6836-02-21-260-192 Tsf to/frm Deferred Revenue (Trillium Grant)0000#DIV/0!
6046-02-21-260-192 Program Supplies (Trillium Grant)0000#DIV/0!
6048-02-21-260-192 Part Time Wages (Trillium Grant)0000#DIV/0!
6078-02-21-260-192 Vacation Pay (Trillium Grant)0000#DIV/0!
6091-02-21-260-192 Benefits (Trillium Grant)0000#DIV/0!
TOTAL TRILLIUM/VALLEY HEARTLAND GRANT00000000#DIV/0!

TOWN OF SMITHS FALLS Page 83 2021 BUDGET - HISTORIAL SERVICES; HERITAGE HOUSE ADMINISTRATION

2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.Completed
ACCOUNT/DESCRIPTIONJOB CREATION PROGRAM/CULTURAL MARKETING
5424-02-21-260-274 Federal Grant0000#DIV/0!#DIV/0!
6836-02-21-260-274 Trsf to Deferred Revenue0000#DIV/0!#DIV/0!
6046-02-21-260-274 Program Supplies0000#DIV/0!#DIV/0!
TOTAL JOB CREATION PROGRAM/CULTURAL MARKETING0000000#DIV/0!
FUNDRAISING ACTIVITIES
5557-02-21-260-013 Donations0000#DIV/0!#DIV/0!
6377-02-21-260-013 Partners Share0000#DIV/0!#DIV/0!
6411-02-21-260-013 Transfer (Museum Upgrade Reserve)0000#DIV/0!#DIV/0!
6525-02-21-260-013 Museum Upgrades0000#DIV/0!#DIV/0!
6046-02-21-260-013 Program Supplies0000#DIV/0!#DIV/0!
TOTAL FUNDRAISING ACTIVITIES0000000#DIV/0!
CANADIAN MUSEUMS/MINISTRY OF CULTURE EMPLOYMENT GRANT
02-21-260-216-5421 Ont Grant (Cdn. Museums)0-13,061-13,0610#DIV/0!#DIV/0!
6048-02-21-260-216 Part Time Wages (Cdn. Museums)012,31912,3190#DIV/0!#DIV/0!
6078-02-21-260-216 Vacation Pay (Cdn. Museums)03753750#DIV/0!#DIV/0!
6091-02-21-260-216 Benefits (Cdn. Museums)03673670#DIV/0!#DIV/0!
02-21-260-089-5421 Ont Grant (Summer Experience Program)0000#DIV/0!#DIV/0!
02-21-260-089-6836 Tsf to/frm Deferred Revenue (Summer Experience Program)0000#DIV/0!#DIV/0!
6048-02-21-260-322 Part Time Wages (Building Careers in Heritage)0000#DIV/0!#DIV/0!
6078-02-21-260-322 Vacation (Building Careers in Heritage)0000#DIV/0!#DIV/0!
6091-02-21-260-322 Benefits (Building Careers in Heritage)0000#DIV/0!#DIV/0!
02-21-260-322-5424 Federal Grant (Building Careers in Heritage)0000#DIV/0!#DIV/0!
02-21-260-322-6836 Trsf to/from Deferred Revenue (Building Careers in Heritage)0000#DIV/0!#DIV/0!
02-21-260-245-6836 Tsf to/frm Deferred Revenue (Museum & Technology)0000#DIV/0!#DIV/0!
6048-02-21-260-245 Part Time Wages (Museum & Technology)0000#DIV/0!#DIV/0!
6078-02-21-260-245 Vacation Pay (Museum & Technology)0000#DIV/0!#DIV/0!
6091-02-21-260-245 Benefits (Museum & Technology)0000#DIV/0!#DIV/0!
6046-02-21-260-245 Program Supplies (Museum & Technology)0000#DIV/0!#DIV/0!
02-21-260-246-5421 Ont Grant (Cultural Strategic Investment Fund)0000#DIV/0!#DIV/0!
02-21-260-246-6836 Tsf to/frm Deferred Revenue (Cultural Strategic Investment Fund)0000#DIV/0!#DIV/0!
6046-02-21-260-246 Program Supplies (Cultural Strategic Investment Fund)0000#DIV/0!#DIV/0!
6048-02-21-260-246 Part Time Wages (Cultural Strategic Investment Fund)0000#DIV/0!#DIV/0!
6078-02-21-260-246 Vacation Pay (Cultural Strategic Investment Fund)0000#DIV/0!#DIV/0!
6091-02-21-260-246 Benefits (Cultural Strategic Investment Fund)0000#DIV/0!#DIV/0!
TOTAL MUSEUM GRANT
02-21-260-216-216-216-216 Employment Grant

TOWN OF SMITHS FALLS 2021 BUDGETPage 84
COMMUNITY SERVICES GENERAL BUDGET
January 18, 20212020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
% Completed61,97854,209-7,76963,5350000DIV/0!
0.00%61,97854,209-7,76963,5350000DIV/0!
TOWN HISTORY BOOK
5580-02-21-261-020 Book Sales0000#DIV/0!
#DIV/0!6162-02-21-261-001 Author's Royalties0000#DIV/0!
TOTAL TOWN HISTORY00000000DIV/0!
GRANT & CONTRIBUTIONS TO HISTORICAL AGENCIES
MUNICIPAL HERITAGE COMMITTEE (Staff Resource; Nikki McKernan) **5,0001,342-3,6585,00000DIV/0!
0.00%03,6583,658
02-21-260-001-6606 Municipal Heritage Committee0000#DIV/0!
#DIV/0!02-21-260-020-5561 Heritage Symposium Revenue5,0005,00005,0000DIV/0!
TOTAL HISTORICAL SERVICES GENERAL66,97859,209-7,76968,535000DIV/0!

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

ACCOUNT/DESCRIPTION2020 Budget2020 Actual REVENUEVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
5680-02-41-420-097 Donations0-80-800 #DIV/0!#DIV/0!
5555-02-41-020-097 Associate Membership Fees0000 #DIV/0!#DIV/0!
5907-02-41-420-097 Digital Main St. Grant0-12,130-12,130#DIV/0!
5863-02-41-420-097 Trsf from other bank account0000 #DIV/0!#DIV/0!
5191-02-41-420-097 BIA Levy-79,000-79,0000-79,0000 #DIV/0!0.00%
5194-02-41-420-097 DBA Dollar Revenue0-600-6000 #DIV/0!#DIV/0!
6244-02-41-420-097 Tax Write-off & Vacancy Adj4,000284-3,7164,0000 #DIV/0!0.00%
TOTAL REVENUE-75,000-91,526-16,526-75,000000#DIV/0!
EXPENDITURES
6048-02-41-420-097 Part Time Wages28,00030,8612,86146,0860 #DIV/0!0.00%
6078-02-41-420-097 Vacation Pay1,2001,3731731,8430 #DIV/0!0.00%
6091-02-41-420-097 Other Payroll Costs3,5004,1756755,5820 #DIV/0!0.00%
6011-02-41-420-097 Office Supplies1,5002,0865861,5000 #DIV/0!0.00%
6561-02-41-420-097 Outgoing Donations; i.e. Legion Wreath & Scouts1000-1001000 #DIV/0!0.00%
6789-02-41-420-097 Radio Ads1,500182-1,3181,5000 #DIV/0!0.00%
6038-02-41-420-097 Advertising (Branding/Awareness)1,500946-5541,5000 #DIV/0!0.00%
6039-02-41-420-097 Staff Training & Develop.0002,5000 #DIV/0!0.00%
6840-02-41-420-097 Website1,0001,4704701,0000 #DIV/0!0.00%
6757-02-41-420-097 Business Recruitment (Marketing)2,2000-2,2002,2000 #DIV/0!0.00%
6060-02-41-420-097 Restaurant Week2,0002,000000 #DIV/0!#DIV/0!
6029-02-41-420-097 OBIAA Memberships300229-713000 #DIV/0!0.00%
6142-02-41-420-097 Shrubbery5,0005,000010,0000 #DIV/0!0.00%
6562-02-41-420-097 Winter Greenery & Annual Tree Decorating3,0004,7931,7933,0000 #DIV/0!0.00%
6174-02-41-420-097 Audit Fees5000-5005000 #DIV/0!0.00%
6196-02-41-420-097 Other Promotions (P2W Incentive)2,000200-1,8006,0000 #DIV/0!0.00%
6202-02-41-420-097 Christmas Promotions2,50012-2,48800 #DIV/0!#DIV/0!
6286-02-41-420-097 Spring Promotions (Valentine's/Family Day/Easter)2,0005,5783,57800 #DIV/0!#DIV/0!
6858-02-41-420-097 Summer Promotions (Canada Day)1,5002,48598500 #DIV/0!#DIV/0!
6659-02-41-420-097 Winter Promotions2,0000-2,00000 #DIV/0!#DIV/0!
6704-02-41-420-097 Girls Night Out1,5001,203-2971,5000 #DIV/0!0.00%
6594-02-41-420-097 Maintenance3,0000-3,0003,0000 #DIV/0!0.00%
6758-02-41-420-097 Meeting Expenses50095-4055000 #DIV/0!0.00%
6582-02-41-420-097 Transportation20013-1872000 #DIV/0!0.00%
TOTAL EXPENDITURES
66,50062,701-3,79988,811000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

ECONOMIC DEVELOPMENT DBA GENERAL BUDGET

January 18,2021

SUMMARY OF THE YEAR
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
EXPENDITURES
6866-02-41-420-097 DBA Dollars2,0000-2,0002,0000#DIV/0!
xxx-02-41-420-097 Bustle on Russell2,0000-2,0002,0000#DIV/0!
6836-02-41-420-097 Trs'd to/from Deferred Revenue0-894-89400#DIV/0!
6861-02-41-420-097 Medieval Feast Fundraiser00000#DIV/0!
6841-02-41-420-097 Light Up the Night2,0000-2,0002,0000#DIV/0!
6860-02-41-420-097 Brochures and Shopping Guide2,0000-2,0002,0000#DIV/0!
6502-02-41-420-097 Banners & Lights10,00029,72519,72530,0000#DIV/0!
6864-02-41-420-097 Digital Main St. Expenses013,02413,02400#DIV/0!
6228-02-41-420-097 Beckwith St. Reconst. Expenses7,2008,8391,6397,5000#DIV/0!
TOTAL PROJECTS25,20050,69425,49445,500000#DIV/0!
SURPLUS/DEFICIT
6276-02-41-420-097 Previous Deficit/Surplus *00000#DIV/0!
6022-02-41-420-097 Current Deficit/Surplus *-16,700-21,684-4,984-59,3110#DIV/0!
*Reserve account 2211
TOTAL DEFICIT/SURPLUS-16,700-21,684-4,984-59,311000#DIV/0!
TOTAL DBIA BUDGET01851850000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET PUBLIC WORKS & UTILITIES NTAL SUB-LEDGER A(CAPITAL PROJECTS

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
EQUIPMENT PURCHASES
5612-01-31-303-309 Transfer from Capital Reserve000-19,1940#DIV/0!0.00%
5612-01-31-303-000 Transfer from Reserve (Acct 2051)-379,0000379,000-300,8060#DIV/0!0.00%
6013-01-31-303-000 1/2 ton Truck00035,0000#DIV/0!0.00%
6205-01-31-303-222 LED Streetlighting Project0572,790572,7900#DIV/0!#DIV/0!
5615-01-31-303-222 Unfinanced Capital0-520,752-520,7520#DIV/0!#DIV/0!
6417-01-31-303-000 Sidewalk Plow & Attachments94,0000-94,0000#DIV/0!#DIV/0!
01-31-303-000-6661 Plow Truck & Wing285,0000-285,000285,0000#DIV/0!0.00%
TOTAL EQUIPMENT PURCHASES052,03852,0380000#DIV/0!
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
MUNICIPAL ROAD & SEWER WORK
5873-01-31-303-037 Provincial Grant (Connecting Link)-2,100,429-976,6941,123,735-96,2740#DIV/0!0.00%
6205-01-31-303-425 County Rd 43 (Hershey to town limits); Microsurface00070,0000#DIV/0!0.00%
6582-01-31-303-410 Improve Active Transportation Network (Tweed)9,0000-9,0009,0000#DIV/0!0.00%
620501-31-303-426 Condie St. (Comelia to Grovenor); Roads/Curbs/Sidewalks000461,0000#DIV/0!0.00%
5612-01-31-303-365 Trsf from Reserve (Acct 2051)-1,015,717-793,843221,8740#DIV/0!#DIV/0!
6205-01-31-303-366 Improve Old Sly's Pedestrian Accessibility; Design only15,0005,673-9,3279,3270#DIV/0!0.00%
5421-01-31-303-394 Provincial Grant (Rural & Small Municipalities)-200,6660200,6660#DIV/0!#DIV/0!
6836-01-31-303-394 Transferred to Deferred Revenue0-1,085,558-1,085,5580#DIV/0!#DIV/0!
6499-01-31-303-000 Geotechnical (Roads); 2021 Program30,00029,734-2660#DIV/0!#REF!
5612/6025-01-31-303-210 Tsf to/from Reserve (Account 2051)0-69,772-69,772-154,0570#DIV/0!0.00%
6732-01-31-303-210 Design Work (Lombard/Abbott)633,15922,636-610,523628,4410#DIV/0!0.00%
6732-01-31-303-xxx Lombard St. (South side Abbott/Ferrara); sidewalks000217,0000#DIV/0!0.00%
6205-01-31-303-427 Design Work; George St. (Storm/Roads)00088,7000#DIV/0!0.00%
6049-01-31-303-000 Elgin Creek Municipal Drain13,00012,527-4730#DIV/0!#DIV/0!
6205-01-31-303-350 Beckwith St; Phase 1; Reconstruction Project5,300,3224,722,608-577,714189,5660#DIV/0!0.00%
6732-01-31-303-350 Beckwith St; Phase 2; Detailed Design133,25014,102-119,148119,1480#DIV/0!0.00%
5852-01-31-303-350 Financed Capital/Beckwith St.-672,246-287,480384,766-668,1630#DIV/0!0.00%
5612-01-31-303-309 Tsf from Capital Reserve (Account 2083)0-62,410-62,410-5,8440#DIV/0!0.00%
5900-01-31-303-210 OCIF Formula-Based Funding-677,761-676,0391,722-604,5880#DIV/0!0.00%
5904-01-31-303-210 OCIF Top-up Funding-495,462-2,270493,1920#DIV/0!#DIV/0!
01-31-303-000-6582 Active Transportation Plan00030,0000#DIV/0!0.00%
01-31-303-185-6205 Cornelia St. (William to Elmsley); Roads480,000
5869-01-31-303-350 Federal Gas Tax/Beckwith St.-753,489-851,591-98,102-773,2560#DIV/0!0.00%
5869-01-31-303-210 Federal Gas Tax/Old Mill Rd./Lombard/Abbott-217,961-1,623216,3380#DIV/0!#DIV/0!
TOTAL ROADWORK0000000#DIV/0!

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

PAGE 88 JECTS)

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
BRIDGES
01-31-303-207-6825 Confederation Bridge MCEA00075,0000 #DIV/0!0.00%
01-31-303-350-5873 Beckwith St. Structures; Pre-Engineering Work (Connecting Link Grant)0000 #DIV/0!#DIV/0!
01-31-303-350-6836 Transfer to/from Deferred Revenue (Connecting Link Grant)0000 #DIV/0!#DIV/0!
01-31-303-309-5612 Transfer from Capital Reserve000-75,0000 #DIV/0!0.00%
01-31-303-028-6205 Contractor (Stone Arch Bridge)0000 #DIV/0!#DIV/0!
01-31-303-028-6836 Transfer to/from Deferred Revenue0000 #DIV/0!#DIV/0!
01-31-303-028-5612/6025 Transfer to/from Reserve0000 #DIV/0!#DIV/0!
01-31-303-350-5612 Transfer from Reserve (Acct 2051)0000 #DIV/0!#DIV/0!
01-31-303-028-5869 Federal Gas Tax0000 #DIV/0!#DIV/0!
01-31-303-028-5421 Provincial Grant0000 #DIV/0!#DIV/0!
TOTAL SIDEWALKS00000000 #DIV/0!
PUBLIC WORKS BUILDINGS
6808-01-31-303-355 Energy Audit Project0000 #DIV/0!#DIV/0!
01-31-303-309-5612 Tsf From Capital Reserve (Acct 2083)0000 #DIV/0!#DIV/0!
01-31-303-000-6082 Detailed Inspection/Design for Roof Repair35,0000-35,00035,0000 #DIV/0!0.00%
01-31-303-000-5612 Transfer from Reserve (Acct 2051)-35,000035,000-35,0000 #DIV/0!0.00%
TOTAL PUBLIC WORKS BUILDING00000000 #DIV/0!
SUBLEDGER TOTAL052,03852,03800000 #DIV/0!

PUBLIC WORKS & UTILITIES; DEPARTMENT January 18,2021

2021 BUDGET Page 89 ENTAL SUB-LEDGER B (ROAD & SEWER MAINTENANCE)

SUMMARY2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
BRIDGES & CULVERTS
6035-02-31-303-033 Regular Salaries & Wages15,0009,693-5,30715,0000#DIV/0!0.00%
6091-02-31-303-033 Other Payroll Costs5,4003,489-1,9116,3000#DIV/0!0.00%
6211-02-31-303-033 Preventative Maintenance (AMP LOS)00000#DIV/0!#DIV/0!
6361-02-31-303-033 Engineers Fee - Bridges*03,0153,01500#DIV/0!#DIV/0!
6205-02-31-303-033 Contracted Services16,00012,582-3,41818,0000#DIV/0!0.00%
6268-02-31-303-033 Materials10,0005,730-4,2705,0000#DIV/0!0.00%
TOTAL BRIDGES & CULVERTS
* Bi-annual inspections required by province; OSIM due per VB
GRASS & WEED MOWING
6035-02-31-303-034 Regular Salaries & Wages15,00013,292-1,70817,5000#DIV/0!0.00%
6091-02-31-303-034 Other Payroll Costs5,4005,287-1137,1750#DIV/0!0.00%
6205-02-31-303-034 Town Equipment0004,0000#DIV/0!0.00%
6122-02-31-303-034 Materials6001,4018016000#DIV/0!0.00%
TOTAL GRASS & WEED MOWING21,00019,980-1,02029,275000#DIV/0!
MAIN SEWERS
6035-02-31-303-035 Regular Salaries & Wages75,00069,981-5,01975,0000#DIV/0!0.00%
6057-02-31-303-035 Overtime00000#DIV/0!#DIV/0!
6091-02-31-303-035 Other Payroll Costs27,00025,193-1,80732,7500#DIV/0!0.00%
6268-02-31-303-035 Materials23,00021,689-1,31123,0000#DIV/0!0.00%
6205-02-31-303-035 Contractor *120,00090,815-29,185120,0000#DIV/0!0.00%
6206-02-31-303-035 Storm Sewer Lease200101-992000#DIV/0!0.00%
6213-02-31-304-001 Parks Canada Lease **1,7000-1,7001,7000#DIV/0!0.00%
6105-02-31-303-035 Hydro (Pumping Station)5,0003,966-1,0344,4000#DIV/0!0.00%
6102-02-31-303-035 Communications (Pumping Station)3,5003,256-2443,5000#DIV/0!0.00%
6110-02-31-303-035 Pumping Station Repairs ("New Acct"; Prev WPCP)5,5009,4103,9105,5000#DIV/0!0.00%
6114-02-31-303-035 Town Equipment00000#DIV/0!#DIV/0!
6213-02-31-303-035 CP Drain Lease4,0001,951-2,0494,0000#DIV/0!0.00%
5612/6025-02-31-303-035 Transfer Reserve (Acct 2051)00000#DIV/0!#DIV/0!
* Now includes flushing/CCTV annual maintenance @$50,000 ** Previously under "Bldg. & Grounds"
264,900226,362-38,538270,050000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

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

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
STORM SEWERS/CATCH BASINS
6035-02-31-303-036 Regular Salaries & Wages25,00016,707-8,29317,0000#DIV/0!0.00%
6091-02-31-303-036 Other Payroll Costs9,0006,337-2,6636,9700#DIV/0!0.00%
6205-02-31-303-036 Contracted Services25,00025,17317325,0000#DIV/0!0.00%
6125-02-31-303-036 Materials10,00018,5398,53910,0000#DIV/0!0.00%
TOTAL CATCH BASINS & SEWERS69,00066,756-2,24458,970000#DIV/0!
STREET REPAIR
6035-02-31-303-037 Regular Salaries & Wages45,00034,870-10,13045,0000#DIV/0!0.00%
6091-02-31-303-037 Other Payroll Costs16,20012,553-3,64718,4500#DIV/0!0.00%
6269-02-31-303-037 Materials15,00023,3888,38820,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)30,00018,195-11,80525,0000#DIV/0!0.00%
6205-02-31-303-037 Contractor110,000121,48711,487120,0000#DIV/0!0.00%
TOTAL STREET PATCHING216,200210,493-5,707228,450000#DIV/0!
GRADING & SHOULDER MAINTENANCE
6035-02-31-303-038 Regular Salaries & Wages2,5001,633-8672,5000#DIV/0!0.00%
6091-02-31-303-038 Other Payroll Costs900558-3421,0250#DIV/0!0.00%
6124-02-31-303-038 Materials8,000567-7,4336,5000#DIV/0!0.00%
TOTAL SHOULDER MAINTENANCE11,4002,758-8,64210,025000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

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

ACCCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
DUST CONTROL
6035-02-31-303-039 Regular Salaries & Wages2,5000-2,5002,5000#DIV/0!0.00%
6091-02-31-303-039 Other Payroll Costs9000-9001,0250#DIV/0!0.00%
6114-02-31-303-039 Town Equipment00000#DIV/0!#DIV/0!
6122-02-31-303-039 Materials6000-6006000#DIV/0!0.00%
TOTAL DUST CONTROL4,0000-4,0004,125000#DIV/0!
WINTER CONTROL; PLOWING/SANDING/SALTING ROADS
6035-02-31-303-040 Regular Salaries & Wages61,08133,075-28,00661,0000#DIV/0!0.00%
6057-02-31-303-040 Overtime15,500645-14,85513,0000#DIV/0!0.00%
6091-02-31-303-040 Other Payroll Costs27,56911,907-15,66231,2420#DIV/0!0.00%
6025-02-31-303-040 Trsf to Payroll Reserve (Surplus Group Benefits)-13,000-13,000000#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 Salt126,00079,937-46,063105,9000#DIV/0!0.00%
6134-02-31-303-040 Sand20,00012,542-7,45820,0000#DIV/0!0.00%
TOTAL WINTER CONTROL; PLOWING/SANDING/SALTING ROADS237,150125,106-112,044231,142000#DIV/0!
WINTER CONTROL; SNOW REMOVAL
6035-02-31-303-324 Regular Salaries & Wages17,5006,683-10,81720,0000#DIV/0!0.00%
6057-02-31-303-324 Overtime2,50061-2,4395,0000#DIV/0!0.00%
6091-02-31-303-324 Other Payroll Costs7,2002,250-4,95010,2500#DIV/0!0.00%
6114-02-31-303-324 Town Equipment00000#DIV/0!#DIV/0!
6115-02-31-303-324 Contracted Services55,00030,851-24,14965,0000#DIV/0!0.00%
TOTAL WINTER CONTROL; SNOW REMOVAL82,20039,845-42,355100,250000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

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

January 18, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
WINTER CONTROL; SIDEWALKS
6035-02-31-303-325 Regular Salaries & Wages20,00018,384-1,61620,0000#DIV/0!0.00%
6057-02-31-303-325 Overtime2,0001,013-9872,0000#DIV/0!0.00%
6091-02-31-303-325 Other Payroll Costs7,9206,618-1,3029,0200#DIV/0!0.00%
6114-02-31-303-325 Town Equipment00000#DIV/0!#DIV/0!
TOTAL WINTER CONTROL; SIDEWALKS29,92026,015-3,90531,020000#DIV/0!
WINTER CONTROL; PARKING & FACILITIES
6035-02-31-303-326 Regular Salaries & Wages10,0002,886-7,11412,0000#DIV/0!0.00%
6057-02-31-303-326 Overtime5000-5005000#DIV/0!0.00%
6091-02-31-303-326 Other Payroll Costs3,7801,039-2,7415,1250#DIV/0!0.00%
6114-02-31-303-326 Town Equipment00000#DIV/0!#DIV/0!
TOTAL WINTER CONTROL; PARKING & FACILITIES14,2803,925-10,35517,625000#DIV/0!
TRAFFIC SIGNALS
6035-02-31-303-041 Regular Salaries & Wages1,000230-7701,0000#DIV/0!0.00%
6091-02-31-303-041 Other Payroll Costs36083-2774100#DIV/0!0.00%
6105-02-31-303-041 Hydro48,00037,156-10,84441,5000#DIV/0!0.00%
6112-02-31-303-041 Materials5000-5005000#DIV/0!0.00%
6114-02-31-303-041 Town Equipment00000#DIV/0!#DIV/0!
6205-02-31-303-041 Contractor35,00025,730-9,27035,0000#DIV/0!0.00%
TOTAL TRAFFIC SIGNALS84,86063,199-21,66178,410000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

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

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
TRAFFIC MARKINGS
6035-02-31-303-042 Regular Salaries & Wages5001,0995998000#DIV/0!0.00%
6091-02-31-303-042 Other Payroll Costs1803962163280#DIV/0!0.00%
6118-02-31-303-042 Tools, Accessories, etc.012312300#DIV/0!#DIV/0!
6268-02-31-303-042 Paint00000#DIV/0!#DIV/0!
6205-02-31-303-042 Contractor34,00026,938-7,06231,0000#DIV/0!0.00%
TOTAL TRAFFIC MARKINGS34,68028,556-6,12432,128000#DIV/0!
RAILWAY CROSSINGS
6211-02-31-303-043 Maintenance12,50011,736-76412,0000#DIV/0!0.00%
TOTAL RAILWAY CROSSINGS12,50011,736-76412,000000#DIV/0!
HOUSE SEWERS
6035-02-31-303-044 Regular Salaries & Wages15,000432-14,56815,0000#DIV/0!0.00%
6091-02-31-303-044 Other Payroll Costs5,40087-5,3136,1500#DIV/0!0.00%
6114-02-31-303-044 Town Equipment00000#DIV/0!#DIV/0!
6125-02-31-303-044 Materials2,0002,6776773,0000#DIV/0!0.00%
6205-02-31-303-044 Contractor5,0001,895-3,1055,0000#DIV/0!0.00%
TOTAL HOUSE SEWERS27,4005,091-22,30929,150000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

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

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
STREET LIGHTING
6035-02-31-303-045 Regular Salaries & Wages2,5001,986-5142,5000#DIV/0!0.00%
6091-02-31-303-045 Other Payroll Costs900648-2521,0250#DIV/0!0.00%
6105-02-31-303-045 Hydro125,75083,385-42,36541,0000#DIV/0!0.00%
6012-02-31-303-045 Streetlighting Capital Project (Principal Repayment)98,4410#DIV/0!0.00%
6014-02-31-303-045 Streetlighting Capital Project (Principal Repayment)3,5650#DIV/0!0.00%
6112-02-31-303-045 Contracted Services **12,00026,90514,9058,0000#DIV/0!0.00%
6114-02-31-303-045 Town Equipment00000#DIV/0!#DIV/0!
6153-02-31-303-045 Materials12,0006,674-5,3262,0000#DIV/0!0.00%
6188-02-31-303-045 Permits & Repairs - Hydro1,2002,1659652,5000#DIV/0!0.00%
** Increase for "banner" installation (surplused bucket truck)
TOTAL STREET LIGHTING154,350121,763-32,587159,031000#DIV/0!
CURBS & SIDEWALK REPAIRS
5594-02-31-303-047 Misc. Revenue0000
6035-02-31-303-046 Regular Salaries & Wages35,00042,0567,05625,4440#DIV/0!0.00%
6091-02-31-303-046 Other Payroll Costs12,60015,1402,54010,4320#DIV/0!0.00%
6114-02-31-303-046 Town Equipment00000#DIV/0!#DIV/0!
6130-02-31-303-046 Materials20,00024,8264,82620,0000#DIV/0!0.00%
6205-02-31-303-046 Contractor33,00010,534-22,46633,0000#DIV/0!0.00%
TOTAL SIDEWALK REPAIRS100,60092,556-8,04488,876000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

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

January 16, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
STREET SIGNS
6035-02-31-303-048 Regular Salaries & Wages15,00014,071-92917,0000#DIV/0!0.00%
6091-02-31-303-048 Other Payroll Costs5,4005,066-3346,9700#DIV/0!0.00%
6114-02-31-303-048 Town Equipment00000#DIV/0!#DIV/0!
6268-02-31-303-048 Materials11,50013,5152,01511,5000#DIV/0!0.00%
6158-02-31-303-048 Sign Supplies00000#DIV/0!#DIV/0!
TOTAL STREET SIGNS31,90032,65275235,470000#DIV/0!
STREET CLEANING
6035-02-31-303-049 Regular Salaries & Wages38,50026,994-11,50628,5000#DIV/0!0.00%
6091-02-31-303-049 Other Payroll Costs13,8609,718-4,14211,6850#DIV/0!0.00%
5831-02-31-303-049 Misc. Revenue-1,68001,680-1,6800#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 CLEANING50,68036,712-13,96838,505000#DIV/0!
TREE SERVICING
6035-02-31-303-050 Regular Salaries & Wages25,00016,686-8,31425,0000#DIV/0!0.00%
6091-02-31-303-050 Other Payroll Costs9,0006,007-2,99310,2500#DIV/0!0.00%
6268-02-31-303-050 Materials3,0000-3,0005,000
6114-02-31-303-050 Town Equipment00000#DIV/0!#DIV/0!
6186-02-31-303-050 Contracted Services13,00016,1803,18015,0000#DIV/0!0.00%
TOTAL TREE SERVICING50,00038,873-11,12755,250000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGET

TOWN OF SMITHS FALLS 2021 BUDGET

2020 ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.Completed
BUILDINGS & GROUNDS ("New"; 11 Air Care Dr.; previously under "Distribution" budget)
6035-02-31-303-051 Regular Salaries & Wages30,00031,1411,14130,0000#DIV/0!
6091-02-31-303-051 Other Payroll Costs10,80011,21141112,3000#DIV/0!
6105-02-31-303-051 Hydro6,3005,499-8015,9500#DIV/0!
6106-02-31-303-051 Water4,0004,3133134,0000#DIV/0!
6107-02-31-303-051 Heating Gas11,20010,162-1,03811,2900#DIV/0!
6011-02-31-303-051 Office Supplies4,5006,3861,8864,5000#DIV/0!
6102-02-31-303-051 Telephone6,3001,786-4,5149,0000#DIV/0!
6116-02-31-303-051 Janitorial Supplies1,500751-7491,5000#DIV/0!
6118-02-31-303-051 Tools, Accessories, etc.6,30010,2093,9096,3000#DIV/0!
6197-02-31-303-051 Janitorial Services5,2001,282-3,9185,2000#DIV/0!
6123-02-31-303-051 Property Repairs6,0008,5472,5476,0000#DIV/0!
* This has been reallocated to "Main Sewers" as of 2017
TOTAL BUILDING & GROUNDS92,10091,287-81396,040000#DIV/0!
LITTER AND GARBAGE PICK-UP
6035-02-31-303-327 Regular Salaries & Wages20,00021,4291,42920,0000#DIV/0!
6091-02-31-303-327 Other Payroll Costs7,2007,7145148,2000#DIV/0!
6114-02-31-303-327 Town Equipment00000#DIV/0!
6286-02-31-303-327 Materials1,250688-5621,2500#DIV/0!
TOTAL LITTER AND GARBAGE PICK-UP28,45029,8311,38129,450000#DIV/0!
TOTAL ROADS MAINTENANCE1,663,9701,308,005-355,9651,679,542000#DIV/0!

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

P ER EQUIPMENT)

January 18, 2021
2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.Completed% Completed
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.Completed% Completed
6108-02-31-303-052 Gas & Oil5,3005,085-2155,3000#DIV/0!0.00%
6110-02-31-303-052 Repairs8,00026,05518,05510,0000#DIV/0!0.00%
6128-02-31-303-052 License1,2501,242-81,2500#DIV/0!0.00%
TOTAL TRUCK 11114,55032,38217,83216,55000#DIV/0!
2013 CHEV SILVERADO TRUCK; VEHICLE 120; FIXED ASSET #7-0050
6108-02-31-303-053 Gas & Oil3,2002,778-4223,2000#DIV/0!0.00%
6110-02-31-303-053 Repairs2,400158-2,2422,4000#DIV/0!0.00%
6128-02-31-303-053 Licenses140120-201400#DIV/0!0.00%
TOTAL TRUCK 1205,7403,056-2,6845,74000#DIV/0!
2006 CHEV SILVERADO 1/2 TON TRUCK; VEHICLE 122; FIXED ASSET #7-0030
6108-02-31-303-055 Gas & Oil2,7001,607-1,0932,7000#DIV/0!0.00%
6110-02-31-303-055 Repairs2,8001,654-1,1462,8000#DIV/0!0.00%
6128-02-31-303-055 Licenses1400-1401400#DIV/0!0.00%
TOTAL TRUCK 1225,6403,261-2,3795,64000#DIV/0!
2007 6-TON DUMP TRUCK; VEHICLE 123; FIXED ASSET #7-0029
6108-02-31-303-056 Gas & Oil2,7006,0483,3486,5000#DIV/0!0.00%
6110-02-31-303-056 Repairs2,80013,54610,74610,0000#DIV/0!0.00%
6128-02-31-303-056 Licenses1400-1401,2500#DIV/0!0.00%
TOTAL TRUCK 1235,64019,59413,95417,75000#DIV/0!

January 16, 2021
ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.
1990 INTERNATIONAL 4000 SERIES BUCKET TRUCK; VEHICLE 159; FIXED ASSET #7-0038
6108-02-31-303-159 Gas & Oil4000-40000#DIV/0!
6110-02-31-303-159 Repairs5,0001,611-3,38900#DIV/0!
6128-02-31-303-159 Licenses4000-40000#DIV/0!
BUCKET TRUCK TOTAL *5,8001,611-4,1890000#DIV/0!
(Removed from 1st draft to 2nd draft Dec 3/20; see increase to 02-31-303-045-6112; net decrease $2800)
2005 VOLVO GRADER V129; FIXED ASSET 7-0040
6108-02-31-303-058 Gas & Oil3,3001,238-2,0623,3000#DIV/0!
6110-02-31-303-058 Repairs10,5006,340-4,16010,5000#DIV/0!
TOTAL GRADER V12913,8007,578-6,22213,800000#DIV/0!
2010 TRACTOR/HOLDER (HOLDER OF NORTH AMERICA); VEHICLE 146; FIXED ASSET #5-1067
6108-02-31-303-061 Gas & Oil3,500105-3,39500#DIV/0!
6110-02-31-303-061 Repairs15,000377-14,62300#DIV/0!
(Surplused in September, 2020)
TOTAL TRACTOR 14618,500482-18,0180000#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,386-2,6145,0000#DIV/0!
6110-02-31-303-399 Repairs3,0002,183-8173,0000#DIV/0!
TOTAL LOADER 1528,0004,569-3,4318,000000#DIV/0!
2015 FORD (1-TON TRUCK); Vehicle 124; FIXED ASSET #7-0061
6108-02-31-303-298 Gas & Oil3,8005,0451,2453,8000#DIV/0!
6110-02-31-303-298 Repairs2,0002,5785782,0000#DIV/0!
6128-02-31-303-298 Vehicle Licence525506-195250#DIV/0!
TOTAL 2015 FORD (1-TON) TRUCK6,3258,1291,8046,325000#DIV/0!

2021 BUDGETPage 99
PUBLIC WORKS & UTILITIES
DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER EQUIPMENT)
January 18, 202120202020202120212021%%%
ACCOUNT/DESCRIPTIONBudget Actual Var. Budget To Date Actual Var. Var.
2006 BACKHOE; VEHICLE #154; FIXED ASSET #5-1061
6108-02-31-303-064 Gas & Oil3,5001,118-2,3823,5000#DIV/0!0.00%
6110-02-31-303-064 Repairs12,0002,068-9,9325,0000#DIV/0!0.00%
TOTAL BACKHOE 154B15,5003,186-12,3148,500000#DIV/0!
2012 JOHNSTON STREET SWEEPER; VEHICLE #155; FIXED ASSET #7-0053
6108-02-31-303-065 Gas & Oil6,2006,3621626,2000#DIV/0!0.00%
6110-02-31-303-065 Repairs6,50013,0706,5707,0000#DIV/0!0.00%
6128-02-31-303-065 Licence ("New")655652-3655
TOTAL SWEEPER13,35520,0846,72913,855000#DIV/0!
JOE JOHNSTON SIDEWALK TRACTOR (VEHICLE #147)
6108-02-31-303-411-6108 Gas & Oil04,6234,6235,0000#DIV/0!0.00%
6110-02-31-303-411-6110 Repairs021,48721,4878,0000#DIV/0!0.00%
TOTAL BRANDT WHEELED LOADER026,11026,11013,000000#DIV/0!
TENCO PLOW W/WING HARNESS (VEHICLE #115) *
6108-02-31-303-300 Gas & Oil00000#DIV/0!#DIV/0!
6110-02-31-303-300 Repairs00000#DIV/0!#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,8001,974-8262,8000#DIV/0!0.00%
6110-02-31-303-301 Repairs2,5001,884-6162,5000#DIV/0!0.00%
6128-02-31-303-301 Vehicle Licence140120-201400#DIV/0!0.00%
TOTAL 2015 CHEV 1/2 TON (VEHICLE #101)5,4403,978-1,4625,440000#DIV/0!

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

Page 100 R EQUIPMENT)

ACCOUNT/DESCRIPTION2020 Budget 2015 HOLDER (270); VEHICLE #1452021 Budget 2021 To Date2021 ActualVar.%Completed
ACCOUNT/DESCRIPTION2,5001,818-6822,5002021 ActualVar.0#DIV/0!0.00%
6110-02-31-303-304 Gas & Oil8,00024,29816,29810,0000#DIV/0!0.00%
TOTAL 2015 HOLDER (270)10,50026,11615,61612,500000#DIV/0!
2009 RPM TECH SNOW BLOWER; EQUIPMENT #272; FIXED ASSET #5-1059
6108-02-31-303-069 Gas & Oil1,100244-8561,1000#DIV/0!0.00%
6110-02-31-303-069 Repairs5,00087-4,9135,0000#DIV/0!0.00%
TOTAL SNOW BLOWER6,100331-5,7696,10000#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,5001,498-1,0022,5000#DIV/0!0.00%
6128-02-31-303-367 Licence140120-201400#DIV/0!0.00%
6110-02-31-303-367 Repairs2,000201-1,7992,0000#DIV/0!0.00%
TOTAL VEHICLE #1214,6401,819-2,8214,64000#DIV/0!

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

6108-02-31-303-180 Gas & Oil3,0002,403-5973,0000#DIV/0!0.00%
6110-02-31-303-180 Repairs2,7503,2605102,7500#DIV/0!0.00%
6128-02-31-303-180 License5101,8071,2975100#DIV/0!0.00%
TOTAL TRUCK 1266,2607,4701,2106,26000#DIV/0!
2018 CHEV SILVERADO (FIXED ASSET 7-0072/VEH 183) & 2004 CHEVY VAN (FIXED ASSET 7-0049/LOCATION 387); PREV ENG; TO BE DISPOSED OF IN 2019
6108-02-31-303-386 Gas & Oil2,7004,4901,7902,7000#DIV/0!0.00%
6128-02-31-303-386 Vehicle Licence140120-201400#DIV/0!0.00%
6110-02-31-303-386 Repairs2,0002,038382,0000#DIV/0!0.00%
6108-02-31-303-387 Gas & Oil00000#DIV/0!#DIV/0!
6128-02-31-303-387 Vehicle Licence00000#DIV/0!#DIV/0!
6110-02-31-303-387 Repairs00000#DIV/0!#DIV/0!
TOTAL4,8406,6481,8084,840000#DIV/0!

TOWN OF SMITHS FALLS 2021 BUDGETPage 101
PUBLIC WORKS & UTILITIES
DEPARTMENTAL SUB-LEDGER C (ROAD & SEWER EQUIPMENT)
20202020202120212021%%%
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,3001,219-1,0812,3000#DIV/0!0.00%
6110-02-31-303-073 Repairs10,0002,829-7,1715,0000#DIV/0!0.00%
TOTAL GRADER V07312,3004,048-8,2527,300000#DIV/0!
MISCELLANEOUS RDS EQUIPMENT
5812-02-31-303-070 Diesel Allocated-43,000-10,53432,466-43,0000#DIV/0!0.00%
6035-02-31-303-070 Regular Salaries & Wages30,00020,211-9,78930,0000#DIV/0!0.00%
6091-02-31-303-070 Other Payroll Costs10,8007,276-3,52412,3000#DIV/0!0.00%
6108-02-31-303-070 Gas & Oil9,5006,286-3,2149,5000#DIV/0!0.00%
6792-02-31-303-413 COVID-19 Expenditures2,5000#DIV/0!0.00%
6112-02-31-303-070 Equipment Repairs *20,00025,7135,71320,0000#DIV/0!0.00%
6115-02-31-303-070 Equipment Rental5006351355000#DIV/0!0.00%
6119-02-31-303-070 Radio Licences & Repairs2,2001,781-4192,5000#DIV/0!0.00%
6135-02-31-303-070 Diesel43,0008,683-34,31743,0000#DIV/0!0.00%
6173-02-31-303-070 Insurance20,19520,117-7824,1410#DIV/0!0.00%
TOTAL MISCELLANEOUS93,19580,168-13,027101,441000#DIV/0!
TOTAL EQUIPMENT SUBLEDGER256,125260,6204,495257,681000#DIV/0!

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

ACCOUNT/DESCRIPTION2020 Budget2020 ActualVar.2021 Budget2021 To Date2021 ActualVar.% Var.% Completed
6035-02-31-303-052 Regular Salaries & Wages30,00020,211-9,78930,000000#DIV/0!0.00%
6091-02-31-303-070 Other Payroll Costs10,8007,276-3,52412,300000#DIV/0!0.00%
6108-02-31-303-070 Gas & Oil66,00056,327-9,67370,900000#DIV/0!0.00%
6782-02-31-303-413 COVID-19 Expenditures0002,500000#DIV/0!0.00%
6110-02-31-303-070 Repairs102,250125,72423,47489,950000#DIV/0!0.00%
6128-02-31-303-070 Licenses4,1804,6875074,890000#DIV/0!0.00%
6112-02-31-303-070 Equipment Repairs20,00025,7135,71320,000000#DIV/0!0.00%
6115-02-31-303-070 Equipment Rental500635135500000#DIV/0!0.00%
6119-02-31-303-070 Radio Repairs2,2001,781-4192,500000#DIV/0!0.00%
6135-02-31-303-070 Diesel0-1,851-1,8510000#DIV/0!#DIV/0!
6173-02-31-303-070 Insurance20,19520,117-7824,141000#DIV/0!0.00%
Subledger Total256,125260,6204,495257,681000#DIV/0!