Body: Council Type: Budget Meeting: Regular Date: 2023 Collection: Budgets Municipality: Frontenac County
[View Document (PDF)](/docs/frontenac-county/Item Attachments/Agenda Item/2023/December/Discussion on history and future challenges for the County/5 Year Segmented Budgets.pdf)
Document Text
County of Frontenac All Departments Segmented Budget 2023
2024
Budget
Budget
$
$
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue Taxation from Other Governments User Charges Payments in Lieu of Taxes Federal and Provincial
53,000
61,000
8,000
(15.09%)
61,860
62,729
63,606
64,492
3,665,215
3,981,235
42,297
42,839
316,020
(8.62%)
4,072,918
4,164,813
4,259,641
4,345,966
542
(1.28%)
43,267
43,700
44,137
44,578
22,176,688
24,206,164
2,029,476
(9.15%)
23,828,570
24,619,006
25,101,203
25,571,637
Provincial Offences Net Revenue
81,298
68,372
(12,926)
15.90%
68,372
68,372
68,372
68,372
Investment Income
160,000
600,000
440,000
(275.00%)
480,000
440,000
400,000
360,000
Other
981,620
1,064,190
82,570
(8.41%)
1,104,477
1,127,407
1,155,796
1,169,680
Transfers from Obligatory Reserve
902,851
892,851
(10,000)
1.11%
892,851
892,851
892,851
892,851
Transfers from Reserve
570,929
627,477
56,548
(9.90%)
781,132
797,245
580,074
580,074
Total Operating Revenue
28,633,898
31,544,128
2,910,230
(10.16%)
31,333,447
32,216,123
32,565,680
33,097,650
38,525,966
41,094,136
2,568,170
6.67%
43,318,389
45,513,279
46,859,035
47,281,673
Operating Expense Salaries & Benefits Materials
5,217,203
5,348,221
131,018
2.51%
4,102,007
4,146,746
4,180,266
4,218,752
Contracted Services
8,471,810
9,202,286
730,476
8.62%
9,297,080
9,425,162
9,725,864
9,995,316
Rents & Financing
221,675
218,395
(3,280)
(1.48%)
221,667
221,736
221,807
221,879
External Transfers
249,299
151,861
(97,438)
(39.08%)
151,861
151,861
151,861
151,861
Depreciation
1,942,002
2,056,311
114,309
5.89%
2,056,311
2,056,311
2,056,311
2,056,311
Reserve Transfers
2,995,459
3,484,970
489,511
16.34%
3,526,231
3,657,826
3,762,171
3,776,808
#DIV/0!
120,091
120,091
120,091
120,091
Four Hours of Care Unapproved Projects
#DIV/0!
Total Operating Expense
57,623,414
61,556,180
3,932,766
6.82%
62,793,637
65,293,012
67,077,406
67,822,691
Net Municipal Contribution
28,989,516
30,012,052
1,022,536
3.53%
31,460,190
33,076,889
34,511,726
34,725,041
LESS: Depreciation
(1,942,002)
(2,056,311)
(114,309)
(5.89%)
(2,056,311)
(2,056,311)
(2,056,311)
(2,056,311)
Net Municipal Contribution LESS Depreciation
27,047,514
27,955,741
908,227
3.36%
29,403,879
31,020,578
32,455,415
32,668,730
City of Kingston
(14,723,294)
(15,409,626)
(686,332)
4.66%
(16,262,467)
(17,299,262)
(17,910,183)
(18,119,005)
County Contribution - Operating
12,324,220
12,546,115
221,895
1.80%
13,141,412
13,721,316
14,545,232
14,549,725
County of Frontenac All Departments Segmented Budget 2023
2024
Budget
Budget
$
$
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
69.17%
2,039,125
3,876,859
1,978,558
1,950,597
Capital Revenue
7,892,704
2,433,236
(5,459,468)
Capital Expense
10,474,880
2,433,236
(8,041,644)
(76.77%)
2,330,125
3,892,848
1,994,558
2,233,597
Net Capital Expense
2,582,176
(2,582,176)
(100.00%)
291,000
15,989
16,000
283,000
City of Kingston - Capital
(2,582,176)
2,582,176
(100.00%)
County Contribution - Capital County Contribution - Debenture Total Requisition
(218,625)
#DIV/0!
291,000
(202,636)
16,000
283,000
131,989
282,241
150,252
113.84%
282,241
282,239
282,241
282,241
12,456,209
12,828,356
372,147
2.99%
13,714,653
13,800,919
14,843,473
15,114,966
County of Frontenac General Segmented Budget 2023
2024
Budget
Budget
$
$
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue Taxation from Other Governments
53,000
61,000
8,000
(15.09%)
61,860
User Charges
53,664
53,664
Payments in Lieu of Taxes
42,297
Provincial Offences Net Revenue
81,298
62,729
63,606
64,492
53,664
53,664
53,664
53,664
42,839
542
(1.28%)
43,267
43,700
44,137
44,578
68,372
(12,926)
15.90%
68,372
68,372
68,372
68,372
Investment Income
160,000
600,000
440,000
(275.00%)
480,000
440,000
400,000
360,000
Total Operating Revenue
390,259
825,875
435,616
(111.62%)
707,163
668,465
629,779
591,106
Contracted Services
1,501
1,501
1,501
1,501
1,501
1,501
Rents & Financing
250
1
(249)
(99.60%)
1
1
1
1
Reserve Transfers
759,508
1,089,597
330,089
43.46%
1,013,614
1,023,778
1,034,349
1,045,343
Total Operating Expense
761,259
1,091,099
329,840
43.33%
1,015,116
1,025,280
1,035,851
1,046,845
Net Municipal Contribution
371,000
265,224
(105,776)
(28.51%)
307,953
356,815
406,072
455,739
307,953
356,815
406,072
455,739
307,953
356,815
406,072
455,739
307,953
356,815
406,072
455,739
Operating Expense
LESS: Depreciation Net Municipal Contribution LESS Depreciation
#DIV/0! 371,000
265,224
(105,776)
(28.51%)
371,000
265,224
(105,776)
(28.51%)
City of Kingston County Contribution - Operating
#DIV/0!
Capital Revenue
#DIV/0!
Capital Expense
#DIV/0!
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
371,000
265,224
(105,776)
(28.51%)
County of Frontenac Governance Segmented Budget 2023
2024
Budget
Budget
$
$
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue Transfers from Reserve
22,500
10,000
(12,500)
55.56%
25,000
25,000
Total Operating Revenue
22,500
10,000
(12,500)
55.56%
25,000
25,000
Salaries & Benefits
180,330
184,160
3,830
2.12%
187,540
190,988
194,503
198,090
Materials
63,998
61,880
(2,118)
(3.31%)
61,964
62,751
61,838
61,927
Operating Expense
Contracted Services
67,402
92,106
24,704
36.65%
58,405
62,368
91,357
92,374
Reserve Transfers
15,000
25,000
10,000
66.67%
25,000
25,000
25,000
25,000
Total Operating Expense
326,730
363,146
36,416
11.15%
332,909
341,107
372,698
377,391
Net Municipal Contribution
304,230
353,146
48,916
16.08%
332,909
341,107
347,698
352,391
332,909
341,107
347,698
352,391
332,909
341,107
347,698
352,391
332,909
341,107
347,698
352,391
Unapproved Projects
#DIV/0!
LESS: Depreciation Net Municipal Contribution LESS Depreciation
#DIV/0! 304,230
353,146
48,916
City of Kingston County Contribution - Operating
16.08% #DIV/0!
304,230
353,146
48,916
16.08%
Capital Revenue
#DIV/0!
Capital Expense
#DIV/0!
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
304,230
353,146
48,916
16.08%
County of Frontenac Corporate Segmented Budget 2023
2024
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Budget
Budget
Projected
Projected
Projected
Projected
$
$
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue User Charges Other
132,689
132,689
#DIV/0!
132,689
132,689
132,689
132,689
605,561
618,693
13,132
(2.17%)
648,165
659,969
676,915
679,197
Transfers from Reserve
5,000
20,000
15,000
(300.00%)
5,000
11,000
5,000
5,000
Total Operating Revenue
610,561
771,382
160,821
(26.34%)
785,854
803,658
814,604
816,886
1,670,900
1,726,095
55,195
3.30%
1,804,221
1,874,149
1,942,182
1,910,012
Materials
215,235
232,061
16,826
7.82%
201,594
209,248
206,844
208,423
Contracted Services
945,863
943,097
(2,766)
(0.29%)
940,361
946,715
956,613
968,316
Rents & Financing
7,000
720
(6,280)
(89.71%)
720
720
720
720
Depreciation
416,484
510,484
94,000
22.57%
510,484
510,484
510,484
510,484
Reserve Transfers
17,500
17,500
17,500
17,500
17,500
17,500
Total Operating Expense
3,272,982
3,429,957
156,975
4.80%
3,474,880
3,558,816
3,634,343
3,615,455
Net Municipal Contribution
2,662,421
2,658,575
(3,846)
(0.14%)
2,689,026
2,755,158
2,819,739
2,798,569
Operating Expense Salaries & Benefits
Unapproved Projects
#DIV/0!
LESS: Depreciation
(416,484)
(510,484)
(94,000)
(22.57%)
(510,484)
(510,484)
(510,484)
(510,484)
Net Municipal Contribution LESS Depreciation
2,245,937
2,148,091
(97,846)
(4.36%)
2,178,542
2,244,674
2,309,255
2,288,085
2,178,542
2,244,674
2,309,255
2,288,085
City of Kingston
#DIV/0!
County Contribution - Operating
2,245,937
2,148,091
(97,846)
(4.36%)
Capital Revenue
4,825,730
6,500
(4,819,230)
99.87%
Capital Expense
4,825,730
6,500
(4,819,230)
(99.87%)
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture Total Requisition
90,476
240,728
150,252
166.07%
240,728
240,727
240,728
240,728
2,336,413
2,388,819
52,406
2.24%
2,419,270
2,485,401
2,549,983
2,528,813
County of Frontenac Ferry Segmented Budget 2023
2024
Budget
Budget
$
$
283,080
282,606
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue User Charges
(474)
0.17%
293,656
303,064
313,508
313,508
Federal and Provincial
1,097,059
1,130,547
33,488
(3.05%)
1,157,554
1,186,493
1,216,155
1,246,559
Total Operating Revenue
1,380,139
1,413,153
33,014
(2.39%)
1,451,210
1,489,557
1,529,663
1,560,067
1,246,433
1,294,811
48,378
3.88%
1,461,056
1,508,163
1,560,371
1,516,316
Operating Expense Salaries & Benefits Materials
48,152
53,467
5,315
11.04%
48,785
48,785
48,785
48,785
Contracted Services
85,554
64,875
(20,679)
(24.17%)
68,379
70,651
72,890
75,305
Depreciation
4,770
4,770
4,770
4,770
4,770
4,770
1,582,990
1,632,369
1,686,816
1,645,176
131,780
142,812
157,153
85,109
Unapproved Projects
#DIV/0!
Total Operating Expense
1,384,909
1,417,923
Net Municipal Contribution
4,770
4,770
LESS: Depreciation
(4,770)
(4,770)
33,014
2.38%
Net Municipal Contribution LESS Depreciation
#DIV/0!
City of Kingston
#DIV/0!
County Contribution - Operating
#DIV/0!
Capital Revenue
#DIV/0!
Capital Expense
#DIV/0!
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
#DIV/0!
(4,770)
(4,770)
(4,770)
(4,770)
127,010
138,042
152,383
80,339
127,010
138,042
152,383
80,339
127,010
138,042
152,383
80,339
County of Frontenac Social Housing Segmented Budget 2023
2024
Budget
Budget
$
$
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue Transfers from Reserve
#DIV/0!
Total Operating Revenue
#DIV/0!
Operating Expense Contracted Services
818,041
793,668
(24,373)
Reserve Transfers
(2.98%)
817,478
842,003
867,263
893,281
#DIV/0!
Unapproved Projects
#DIV/0!
Total Operating Expense
818,041
793,668
(24,373)
(2.98%)
817,478
842,003
867,263
893,281
Net Municipal Contribution
818,041
793,668
(24,373)
(2.98%)
817,478
842,003
867,263
893,281
817,478
842,003
867,263
893,281
817,478
842,003
867,263
893,281
817,478
842,003
867,263
893,281
LESS: Depreciation Net Municipal Contribution LESS Depreciation
#DIV/0! 818,041
793,668
(24,373)
City of Kingston County Contribution - Operating
(2.98%) #DIV/0!
818,041
793,668
(24,373)
(2.98%)
Capital Revenue
#DIV/0!
Capital Expense
#DIV/0!
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
818,041
793,668
(24,373)
(2.98%)
County of Frontenac Fairmount - County Segmented Budget 2023
2024
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Budget
Budget
Projected
Projected
Projected
Projected
$
$
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue User Charges
3,322,971
3,506,776
183,805
(5.53%)
3,587,409
3,669,896
3,754,280
3,840,605
Federal and Provincial
8,873,306
9,810,670
937,364
(10.56%)
9,972,164
10,031,228
10,093,690
10,156,777
Other
105,367
118,567
13,200
(12.53%)
119,883
121,225
122,591
123,813
Transfers from Reserve
288,471
276,471
(12,000)
4.16%
276,471
288,471
25,000
25,000
Total Operating Revenue
12,590,115
13,712,484
1,122,369
(8.91%)
13,955,927
14,110,820
13,995,561
14,146,195
Salaries & Benefits
14,247,375
15,281,588
1,034,213
7.26%
15,800,653
16,275,467
16,801,879
16,638,875
Materials
1,319,662
1,458,599
138,937
10.53%
1,417,097
1,435,801
1,454,446
1,473,436
Contracted Services
1,452,803
1,587,102
134,299
9.24%
1,602,718
1,643,529
1,683,921
1,784,654
3,334
3,401
67
2.01%
3,469
3,538
3,609
3,681
12,309
2.00%
Operating Expense
Rents & Financing Depreciation
615,436
627,745
Reserve Transfers
834,681
834,681
Four Hours of Care
627,745
627,745
627,745
627,745
834,681
834,681
834,681
834,681
120,091
120,091
120,091
120,091
7.14%
20,406,454
20,940,852
21,526,372
21,483,163 7,336,968
#DIV/0!
Unapproved Projects
#DIV/0!
Total Operating Expense
18,473,291
19,793,116
1,319,825
Net Municipal Contribution
5,883,176
6,080,632
197,456
3.36%
6,450,527
6,830,032
7,530,811
LESS: Depreciation
(615,436)
(627,745)
(12,309)
(2.00%)
(627,745)
(627,745)
(627,745)
(627,745)
Net Municipal Contribution LESS Depreciation
5,267,740
5,452,887
185,147
3.51%
5,822,782
6,202,287
6,903,066
6,709,223
City of Kingston
(3,753,063)
(3,876,963)
(123,900)
3.30%
(4,147,155)
(4,405,218)
(4,710,748)
(4,578,934)
County Contribution - Operating
1,514,677
1,575,924
61,247
4.04%
1,675,627
1,797,069
2,192,318
2,130,289
Capital Revenue
353,084
641,304
288,220
(81.63%)
521,620
423,875
426,628
398,667
Capital Expense
353,084
641,304
288,220
81.63%
521,620
423,875
426,628
398,667
1,675,627
1,797,069
2,192,318
2,130,289
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
1,514,677
1,575,924
61,247
4.04%
County of Frontenac Social Services Segmented Budget 2023
2024
Budget
Budget
$
$
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue
#DIV/0!
Operating Expense Contracted Services
1,161,556
1,243,565
82,009
7.06%
1,280,873
1,319,273
1,358,824
1,399,562
Total Operating Expense
1,161,556
1,243,565
82,009
7.06%
1,280,873
1,319,273
1,358,824
1,399,562
Net Municipal Contribution
1,161,556
1,243,565
82,009
7.06%
1,280,873
1,319,273
1,358,824
1,399,562
1,161,556
1,243,565
82,009
1,280,873
1,319,273
1,358,824
1,399,562
1,280,873
1,319,273
1,358,824
1,399,562
1,280,873
1,319,273
1,358,824
1,399,562
LESS: Depreciation Net Municipal Contribution LESS Depreciation
#DIV/0!
City of Kingston County Contribution - Operating
7.06% #DIV/0!
1,161,556
1,243,565
82,009
7.06%
Capital Revenue
#DIV/0!
Capital Expense
#DIV/0!
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
1,161,556
1,243,565
82,009
7.06%
County of Frontenac Frontenac Paramedics Segmented Budget 2023
2024
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Budget
Budget
Projected
Projected
Projected
Projected
$
$
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue User Charges
#DIV/0!
Federal and Provincial
12,206,323
13,264,947
1,058,624
(8.67%)
12,698,852
13,401,285
13,791,358
14,168,301
Transfers from Reserve
121,520
164,356
42,836
(35.25%)
299,761
420,074
420,074
420,074
Total Operating Revenue
12,327,843
13,429,303
1,101,460
(8.93%)
12,998,613
13,821,359
14,211,432
14,588,375
Salaries & Benefits
20,282,858
21,662,296
1,379,438
6.80%
23,064,932
24,628,109
25,283,291
25,976,302
Materials
2,617,556
2,591,387
(26,169)
(1.00%)
1,422,989
1,442,783
1,460,975
1,478,803
Contracted Services
1,843,130
2,188,742
345,612
18.75%
2,157,173
2,234,444
2,305,368
2,357,405
Rents & Financing
211,091
214,273
3,182
1.51%
217,477
217,477
217,477
217,477
Operating Expense
Depreciation
905,312
913,312
8,000
0.88%
913,312
913,312
913,312
913,312
1,183,690
1,294,771
111,081
9.38%
1,406,330
1,522,042
1,642,062
1,645,705
Total Operating Expense
27,043,637
28,864,781
1,821,144
6.73%
29,182,213
30,958,167
31,822,485
32,589,004
Net Municipal Contribution
14,715,794
15,435,478
719,684
4.89%
16,183,600
17,136,808
17,611,053
18,000,629
Reserve Transfers Unapproved Projects
LESS: Depreciation
#DIV/0!
(905,312)
(913,312)
(8,000)
(0.88%)
(913,312)
(913,312)
(913,312)
(913,312)
Net Municipal Contribution LESS Depreciation
13,810,482
14,522,166
711,684
5.15%
15,270,288
16,223,496
16,697,741
17,087,317
City of Kingston
(10,970,231)
(11,532,663)
(562,432)
5.13%
(12,115,312)
(12,894,044)
(13,199,435)
(13,540,071)
County Contribution - Operating
2,840,251
2,989,503
149,252
5.25%
3,154,976
3,329,452
3,498,306
3,547,246
Capital Revenue
1,766,890
1,057,432
(709,458)
40.15%
867,505
3,452,984
1,551,930
1,551,930
Capital Expense
4,349,066
1,057,432
(3,291,634)
(75.69%)
1,158,505
3,468,973
1,567,930
1,834,930
291,000
15,989
16,000
283,000
Net Capital Expense
2,582,176
(2,582,176)
(100.00%)
City of Kingston - Capital
(2,582,176)
2,582,176
(100.00%)
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
2,840,251
2,989,503
149,252
5.25%
(218,625) 291,000
(202,636)
16,000
283,000
3,445,976
3,126,816
3,514,306
3,830,246
County of Frontenac Health Unit Segmented Budget 2023
2024
Budget
Budget
$
$
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue
#DIV/0!
Operating Expense Contracted Services
834,078
854,930
20,852
2.50%
876,303
898,211
920,666
920,891
Total Operating Expense
834,078
854,930
20,852
2.50%
876,303
898,211
920,666
920,891
Net Municipal Contribution
834,078
854,930
20,852
2.50%
876,303
898,211
920,666
920,891
834,078
854,930
20,852
876,303
898,211
920,666
920,891
876,303
898,211
920,666
920,891
876,303
898,211
920,666
920,891
LESS: Depreciation Net Municipal Contribution LESS Depreciation
#DIV/0!
City of Kingston County Contribution - Operating
2.50% #DIV/0!
834,078
854,930
20,852
2.50%
Capital Revenue
#DIV/0!
Capital Expense
#DIV/0!
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
834,078
854,930
20,852
2.50%
County of Frontenac Library Segmented Budget 2023
2024
Budget
Budget
$
$
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue Transfers from Reserve
33,150
33,150
#DIV/0!
153,400
31,200
58,500
58,500
Total Operating Revenue
33,150
33,150
#DIV/0!
153,400
31,200
58,500
58,500
Operating Expense Contracted Services
946,275
1,010,652
64,377
6.80%
1,160,227
1,068,232
1,126,643
1,158,687
Reserve Transfers
34,000
38,000
4,000
11.76%
42,000
46,000
50,000
50,000
Total Operating Expense
980,275
1,048,652
68,377
6.98%
1,202,227
1,114,232
1,176,643
1,208,687
Net Municipal Contribution
980,275
1,015,502
35,227
3.59%
1,048,827
1,083,032
1,118,143
1,150,187
1,048,827
1,083,032
1,118,143
1,150,187
1,048,827
1,083,032
1,118,143
1,150,187
1,048,827
1,083,032
1,118,143
1,150,187
LESS: Depreciation Net Municipal Contribution LESS Depreciation
#DIV/0! 980,275
1,015,502
35,227
980,275
1,015,502
35,227
City of Kingston County Contribution - Operating
3.59% #DIV/0! 3.59%
Capital Revenue
#DIV/0!
Capital Expense
#DIV/0!
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
980,275
1,015,502
35,227
3.59%
County of Frontenac Planning & Development Segmented Budget 2023
2024
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Budget
Budget
Projected
Projected
Projected
Projected
$
$
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue User Charges
5,500
5,500
5,500
5,500
5,500
5,500
Other
270,392
326,630
56,238
(20.80%)
336,129
345,913
355,990
366,370
Transfers from Obligatory Reserve
20,000
10,000
Transfers from Reserve
36,000
103,500
(10,000)
50.00%
10,000
10,000
10,000
10,000
67,500
(187.50%)
46,500
46,500
46,500
46,500
Total Operating Revenue
331,892
445,630
113,738
(34.27%)
398,129
407,913
417,990
428,370
Salaries & Benefits
881,080
927,930
46,850
5.32%
981,749
1,018,090
1,058,317
1,023,710
Materials
54,127
55,722
1,595
2.95%
52,246
52,246
52,246
52,246
Contracted Services
308,185
395,845
87,660
28.44%
326,878
331,103
333,303
335,403
Reserve Transfers
129,080
131,421
2,341
1.81%
133,106
134,825
136,579
136,579
Total Operating Expense
1,372,472
1,510,918
138,446
10.09%
1,493,979
1,536,264
1,580,445
1,547,938
Net Municipal Contribution
1,040,580
1,065,288
24,708
2.37%
1,095,850
1,128,351
1,162,455
1,119,568
1,040,580
1,065,288
24,708
1,095,850
1,128,351
1,162,455
1,119,568
1,095,850
1,128,351
1,162,455
1,119,568
41,513
41,512
41,513
41,513
1,137,363
1,169,863
1,203,968
1,161,081
Federal and Provincial
#DIV/0!
Operating Expense
Unapproved Projects
#DIV/0!
LESS: Depreciation Net Municipal Contribution LESS Depreciation
#DIV/0!
City of Kingston County Contribution - Operating
2.37% #DIV/0!
1,040,580
1,065,288
24,708
2.37%
Capital Revenue
947,000
728,000
(219,000)
23.13%
650,000
Capital Expense
947,000
728,000
(219,000)
(23.13%)
650,000
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture Total Requisition
41,513
41,513
1,082,093
1,106,801
24,708
2.28%
County of Frontenac Continuous Improvement GIS Segmented Budget 2023
2024
Budget
Budget
$
$
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue Transfers from Reserve
20,000
20,000
#DIV/0!
Total Operating Revenue
20,000
20,000
#DIV/0!
Operating Expense Salaries & Benefits
16,990
17,256
266
1.57%
18,238
18,313
18,492
18,368
Materials
13,622
10,254
(3,368)
(24.72%)
12,481
10,281
10,281
10,281
Contracted Services
1,870
22,903
21,033
1,124.76%
3,484
3,832
4,215
4,637
Unapproved Projects
#DIV/0!
Total Operating Expense
32,482
50,413
17,931
55.20%
34,203
32,426
32,988
33,286
Net Municipal Contribution
32,482
30,413
(2,069)
(6.37%)
34,203
32,426
32,988
33,286
32,482
30,413
(2,069)
(6.37%)
34,203
32,426
32,988
33,286
32,482
30,413
(2,069)
(6.37%)
34,203
32,426
32,988
33,286
34,203
32,426
32,988
33,286
LESS: Depreciation Net Municipal Contribution LESS Depreciation
#DIV/0!
City of Kingston County Contribution - Operating
#DIV/0!
Capital Revenue
#DIV/0!
Capital Expense
#DIV/0!
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
32,482
30,413
(2,069)
(6.37%)
County of Frontenac Other Segmented Budget 2023
2024
Budget
Budget
$
$
2023-2024
2023-2024
2025
2026
2027
2028
Budget
Budget
Projected
Projected
Projected
Projected
Variance $
Variance (%)
Budget
Budget
Budget
Budget
Operating Revenue Other
300
300
Transfers from Obligatory Reserve
882,851
882,851
Transfers from Reserve
97,438
Total Operating Revenue
980,589
883,151
Materials
882,851
882,851
External Transfers
249,299
Reserve Transfers
22,000
300
300
300
300
882,851
882,851
882,851
882,851
883,151
883,151
883,151
(97,438)
100.00%
(97,438)
9.94%
883,151
882,851
882,851
882,851
882,851
151,861
(97,438)
(39.08%)
151,861
151,861
151,861
151,861
54,000
32,000
145.45%
54,000
54,000
22,000
22,000
Operating Expense
Unapproved Projects
#DIV/0!
Total Operating Expense
1,154,150
1,088,712
(65,438)
(5.67%)
1,088,712
1,088,712
1,056,712
1,056,712
Net Municipal Contribution
173,561
205,561
32,000
18.44%
205,561
205,561
173,561
173,561
173,561
205,561
32,000
18.44%
205,561
205,561
173,561
173,561
205,561
205,561
173,561
173,561
205,561
205,561
173,561
173,561
LESS: Depreciation Net Municipal Contribution LESS Depreciation
#DIV/0!
City of Kingston County Contribution - Operating
#DIV/0! 173,561
205,561
32,000
18.44%
Capital Revenue
#DIV/0!
Capital Expense
#DIV/0!
Net Capital Expense
#DIV/0!
City of Kingston - Capital
#DIV/0!
County Contribution - Capital
#DIV/0!
County Contribution - Debenture
#DIV/0!
Total Requisition
173,561
205,561
32,000
18.44%
