March 22, 2011 Budget Package AddendumElgu�a�tnt}
Are rsM1e.17l Ward
REPORT TO COUNCIL
FROM: Jim Bundschuh - Director of Financial Services
DATE: March 7th, 2010
SUBJECT: 2011 Proposed Budget
INTRODUCTION:
The 2011 proposed budget is presented to Council with an overall levy increase of 2.4%
or $0.6 million resulting in a Net Income loss of $3.9 million. This increase will equate to
a 0.8% property tax rate decrease. An average home that had no change in assessed
value would see a $10 decrease in County taxes, and a more typical home would see a
4% increase equal to $48. The disparity between the percentage increase for the levy
and the average household is driven by the tax burden shift caused by MPAC's
reassessment of the Ford property.
DISCUSSION:
Attachment I Schedule A outlines the tax ratios which remain unchanged from prior
years. Schedule B summarizes the budget request by department. Schedule C
provides the tax rates. Tax rates are lower than the prior year by 0.8% and result in a
2.4% levy increase.
The causal factors driving changes in the 2011 budget from 2010 levels are found in
Attachment 11, including a forecast for the next ten years, and are summarized as
follows:
• 2010 was budgeted for a positive Net Income of $1.7 million (line 1). Including a
levy increase (line 26) of $0.6 million, the Net Income for 2011 (line 27) is
budgeted at a loss of $3.9 million or $5.6 million degradation from 2010.
• The single largest factor is the loss of Infrastructure Grants (line 15) worth $3.1
million and the change in the Karen Street Pumping Station from Capital to
Operating (line 16).
• Inflation (lines 11 -13) contributes a further $1.4 million in cost increases with the
increase split equally between supply /purchased services and wages /benefits.
Partially offsetting this is inflation related revenue (line 14) increases of $0.6
million.
• Based on the 2011 reassessment, Ford is appealing their assessments for 2009-
2010. It is therefore prudent to budget for this potential, adding an incremental
$0.5 million to the budget for 2011 (line 6).
• OMPF funding net of uploading (lines 2 -3) is resulting in a $0.2 million loss in
revenue.
1
• A negative Impact of $0.2 million resulting from the combination of the lease rate
reduction provided to the Board of Health along with the Elgin St. Thomas Public
Health's budget increase of 5.2% (line 5).
• One -time cost for the International Plowing Match (line 17) of $0.2 million
budgeted in 2010 are more than offset by one -time 2011 costs for an EA study
for Dexter Line of $0.3 million (line 19).
• Service -level increases (line 23) in Economic Development /Tourism, Library
branch hours and Ambulance IV training have added $0.1 million in costs.
• County staff have continued to improve the efficiencies of the operation with a
commitment of $0.4 million for 2011 (line 24).
Included in the Budget package are the updated 2011 Capital Budget found in
Attachment 111 (adjustments for the Karen Street Pumping Station) and the 2011 Balance
Sheet and Reserves Budget found in Attachment IV. The 2011 Ending Municipal
Position is $187.0 million (lines 14 and 38), down from the prior year's $190.9 million by
the budgeted $3.9 million negative net income. As a result, no contributions will be
made to the Capital Funds (lines 35 and 55), and Capital Reserves (lines 37 and 67) will
decrease by $0.3 million. Furthermore, Operating Reserves (lines 41 and 95) will be
reduced by $1.6 million.
CONCLUSION:
The attached budget is resulting in a $3.9 million reduction in the Municipal Position and
a corresponding reduction in Reserves contained within the Municipal Position. A
primary purpose of reserves is to soften the impact of external shocks to the rate payers.
Given that the cumulative annual impact of a loss of $1.7 million in OMPF funding and
the loss of Ford tax revenue growing to $0.6 million annually, the next five year period
will require the use of Reserves to allow the measured increases (4% annually) in
residential taxes proposed in the Ten Year Plan to bring Net Income back to a
favourable position.
RECOMMENDATION:
THAT the report titled 2011 Proposed Budget dated March 7t", 2011 be received and
filed; and
THAT the 2011 Proposed Budget, which includes the Operating Budget, the Capital
Budget and Grants be approved; and
THAT the 2011 Tax Rates and Ratios in Attachment I be approved; and
THAT the necessary by -law be prepared.
Respectfully Submitted Approved for Submission
Jim Bundschuh Mark G. McDonald
Director of Financial Services Chief Administrative Officer
2
COUNTY OF ELGIN
BY -LAW 10 - 12
SCHEDULE A
Ratios
PROPERTY CLASS
Attachment 1
2011 2010
RESIDENTIAL /FARM 1.0000 1.0000
MULTI - RESIDENTIAL 2.3458 2.3458
FARMLAND AWAITING DEVELOPMENT - RESIDENTIAL 0.5000 0.5000
COMMERCIAL OCCUPIED 1.6376 1.6376
COMMERCIAL VACANT LAND 1.1463 1.1463
INDUSTRIAL OCCUPIED 2.2251 2.2251
INDUSTRIAL VACANT LAND 1.4463 1.4463
LARGE INDUSTRIAL OCCUPIED 2.8318 2.8318
LARGE INDUSTRIAL VACANT 1.8407 1.8407
PIPELINES 1.1446 1.1446
FARM 0.2500 0.2500
MANAGED FORESTS 0.2500 0.2500
3
Attachment I
Column 1 Column 2 Column 3 Column 4 Column 5 Column 6 Column 7 Column 8 Column 9
2011 Operating
Budget
(Over)/ Under Percent
2010 Impact on
Levy
(388,347) 1.7%
- 0.0%
1,017,028 -4.3%
(67,808) 0.3%
7,425 0.0%
(148,585) 0.6%
(17,530) 0.1%
(1,068,400) 4.6%
38,321 -0.2%
0
N
0)
CO
r
N
CO
(4,655) 0.0%
(29,206) 0.1%
(43,668) 0.2%
32,247 -0.1%
(145,826) 0.6%
(21,568) 0.1%
(5,030,775) 21.4%
(314,060) 1.3%
(4,858) 0.0%
89,139 -0.4%
(14,365) 0.1%
(4,257) 0.0%
5 0.0%
(237,849) 1.0%
145,692 -0.6%
(5,584,003) 23.8%
0)
CO
N-
N-
N
Cfl
2011 Operating Budget
Revenue Expense Net Budget
(Revenue)/
Expense
24,724,962 1,286,095 (23,438,867)
2,613,023 2,538,023 (75,000)
3,252,668 3,252,668
223,068 1,125,364 902,296
55,376 55,376
18,405 (302,115) (320,520)
32,712 738,334 705,622
22,414 (2,415,886) (2,438,300)
36,779 756,178 719,399
27,671,364 8,320,131 (20,637,327)
348,152 348,152
35,040 471,510 436,470
557,667 557,667
413,266
355,822 982,381 626,560
1,000 575,783 574,783
2,596,631 13, 339, 862 10, 743, 231
15,985,808 20,590,335 4,604,527
44,264 412,507 368,243
277,335 2,620,263 2,342,928
- 728,872 728,872
1,345,000 1,294,429 (50,571)
334,998 319,762 (15,236)
5,696,779 8,103,113 2,406,334
189,184 1,277,720 1,088,536
26,861,861 51,622,356 25,173,761
54,533,225 59,942,487 4,536,434
2010 Operating 2010
24,214,714 387,500 (23,827,214) (24,284,088)
75,000 - (75,000) (41,995)
- 4,269,696 4,269,696 4,052,852
- 834,488 834,488 836,313
- 62,800 62,800 56,250
469,105 - (469,105) (464,784)
- 688,092 688,092 688,091
3,506,700 - (3,506,700) (3,506,700)
- 757,720 757,720 520,842
28,265,519 7,000,296 (21,265,223) (22,143,218)
343,497 343,497 305,715
407,264 407,264 401,286
- 513,999 513,999 498,241
- 445,513 445,513 402,923
349,497 830,231 480,734 370,850
- 553,215 553,215 469,185
5,592,610 11,305,066 5,712,456 6,345,817
14,406,239 18,696,706 4,290,467 4,081,636
34,212 397,597 363,385 349,295
341,838 2,773,905 2,432,067 2,397,138
- 714,507 714,507 689,925
1,155,000 1,100,172 (54,828) (52,493)
259,998 244,767 (15,231) (13,899)
5,581,720 7,750,205 2,168,485 2,242,263
223,446 1,457,674 1,234,228 986,601
27, 944, 560 47, 534, 318 19, 589, 758 19, 474, 484
56,210,079 54,534,614 (1,675,465) (2,668,734)
Schedule B:
2011 Operating
Budget
CORPORATE ACTIVITIES
1) Taxes
2) Interest Charges & Income
3) Social Services - St. Thomas
4) Health Unit
5) Grants
6) Rental Income
7) Property Assessment
8) Ontario Municipal Partnership Fund
9) Project Costs
10) Corporate
Departmental
11) Warden and Council
12) Administrative Services
13) Financial Services
14) Human Resources
15) Administrative Building
16) Corporate Expenditures
17) Eng'r & Land Div.
18) Homes
19) Museum & Archives
20) Library Services
21) Information Technology
22) Provincial Offences
23) Collections
24) Ambul. & Emergency Meas.
25) Econ.Dev'I, Tourism & Plan.
26) Departmental
27) Elgin County
N
Levy Increase
Net Income
co
(0
0
V
N
J: \Common \Finance \Budget Development \Financial Services \SummaryOperating Budget 16/03/2041 3:10 PM
Attachment 1
COUNTY OF ELGIN
BY -LAW 10 -12
SCHEDULE C
a) 0 0 0 0 0 0 0 0 0 0 0 0
O, a) o 0 0 0 0 0 0 0 0 0 0 0
c E LO 00 00 LO O O N— CO CO N
CO Cn 6 4 O O I: O 4 M N
o N
o a
w000000000000
N N N N N N N N N N N N
H 00 00 00 00 00 00 00 00 00 00 00 00
C= a O O O O O O O O O O O O
al Ce
(I X
o
PROPERTY CLASS
0.575531
0.580309%
RESIDENTIAL
1.350081
1.361288%
MULTI - RESIDENTIAL
0 0 0 0
CO O N LO
(O O) CO
CO
N. N O) O
00 LO 00
N (3) (0
0.290154%
FARMLAND AWAITING DEVELOPMENT - RESIDENTIAL
0.950314%
O IS)
• C
(13 O)
(O N
O
0
Z
0 J
W 1-
d Z
D Q
O • 0
O >
Q Q
O 0
w
O • 0
O 0
INDUSTRIAL OCCUPIED
0.832391
0.839309%
INDUSTRIAL VACANT LAND
1.629790%
1.643318%
LARGE INDUSTRIAL OCCUPIED
1.059381
1.068157%
LARGE INDUSTRIAL VACANT
0.658753%
0.143883%
PIPELINES
2
u_
0.143883%
0.145077%
MANAGED FORESTS
• a)
a)
Q
O N
o_ N
a)
L • CO
CO a)
0
a)
j N
N
a) al
_a Q
o �
N E
L a)
X
CO X
a) N
i O
• (1)
i:3)
CD CO CV
E
a)
a) L
Q o
L><
C
73 o_
a) 0
o cn o_
a) a)
X4• -
0 o
Attachment 11
c
as Q)
a�
cn
cn
W z
M
L +,
a)
ct
O
r Q
O
N
N
OI
O
N
N
V
O O
V o0 N.
O O O O
LO ,- Q
O O O
N
O
CO
.—
0
O
O
co
CO
In
O)
,—
M
O
N
0)
N
In
N
O
O O
V CO N-
O O O O
LO a- V
O O O
N
O
In
O
O
N
V
d)
CO
In W
CO
N
N
M
O
O O O.—
V co N-
O O O O
In V V
O.— O
N
V
.-
O
O
LO
N
CO
00
CO
.
W
1-
O
N
In
N
.— N - O
O O O O O
O V co N-
.— 0 0 0 0
O In a- V
N O O O
(O
O
co.
.—
0
O
N
M
V
In
0o
r
(O
ao
ao
r
OI
O
N
V
O
,— N 0 0
O O O 0 0
0,- V CO D
0 0 0 0
0 0 V
N O O
W
O
co.
.—
0
O
LO
N
CO
N
00
r
V
In
�
r
toI
O
N
00
O
N 0,—
O O O O O
a- CO D. CO
O O O O
0 V
O O
O
O
N
.—
0
O
V
O
In
N
CO
N
�
Tr
0
N
O
N
.-..— N .— O
O O O O O
.— CO D. CO
O O O O
0 V
O O
O
O
N
.—
0
O
CO
O
--
CO
M
0o
LO
N
ao
MI
O
N
R
.— N.— O O 00
0 0 0 0 O O O
CO CO N- CO
0 0 0 0
0 V
O O
CO
O
0
O
O
N
M
In
00
CO
C)
�
NI
O
N
M
co .— N In a - a - CO
O O O O O O O
CO CO N - CO O)
0 0 0 0 0—
O
a- V
O O O
In
a-
D.
O
0
O
n
....
O
o:
0o
CO
In
ao
OIN
I-
a)
O)
C
,- O) ,— N In a-
0 0 0 0 0
V M N CO a- D) N
O O O O M.— O
M a- V
O O O
N
(O
....
CO
O
o
O
W
M
....
O
d)
O
f:
�
a
0 0 co
Attachment III
2011 -2020 Average
881,200
'
'
000
O O 0
O O 0 '
16 00 00
CO I-
O
0
0 '
CO
N
0000
0 O O O
LO 0 N n '
In N M O
N LO CO
10 LO
N N
O O O
O O O
CO CO Tr '
In N W
N CO
., .,
0
O
O
LO
O)
N
'
0
O
0 '
CO
0
'
00
M
0
O
CO '
N
O)
0
O
0 '
O)
co
CO
' '
0
0
LO
V
0
0
LO '
V
12,938,089
2016 -2020 Total
O
O
O
O
0
0
(O
'
CO
CO
�
O
0
O)
V
0 0
0 0
O O
In V
,-
0
0
O
0)
,-
0 0
0 0
O O
In 0
O
(O
0
0
O
In
O
(O
0 0 0
0 0 0
O O O
In In 0
N CO
0
0
O
V
LO
r
'
CO
CO
I _
CO
r
N-
0
0
lf _
CO
V
0
0
O
In
0
N
'
'
66,859,824
2011 -2015 Total
'
O
O
O '
t.,-.
00
N
' '
O
O
O
_
00
00
M
M
'
'
0 0 0
0 0 0
0 0 0 '
_ _ _
O O O
0 CO v
� co co
0
0
0 '
_
O
N
0
0
0
_
LO
In
0 0
0 0
0 0
_ _
O N
n CO
r In
O)
.,
0
0
0 '
_
n
N-
n
O)
.,
0 O 0
0 0 0
0 0 0 '
_ _ Ti
00 (O
0 n CO
� O) O
O
0
_
0
O
0)
N
'
O
0
0 '
_
O
CO
N
(O
LO '
_
M
�
'
O
0
LO '
_
co
•ct
O
0
0 '
_
O
co
co
I 45,000
62,521,062
887,000 385,000 440,000 550,000 550,000
40,000 100,000 10,000 10,000 10,000
347,000 605,000 555,000 9,025,000 9,000,000
268,013 277,931 288,272 299,053 310,293
- 45,000 - - -
6,962,313 8,801,231 9,470,572 18,663,353 18,623,593
15) Administrative Building
18b iv Terrace Lodge Nursing & Personal Care
18b vii Terrace Lodge Building & Property
20) Library Services
Tourism
27) Elgin County
16/03/2011 3:32 PM
J: \Common \Finance \Budget Development \Financial Services \SummarySummaryCapital Budget
Attachment IV
County of Elgin
2011 Balance Sheet and Reserve Budget
Balance Sheet
Balance Sheet
7 Cash & Investments
8 Accounts Receivable
9 Pre -Paids & Loans
10 TCA
11 WIP
12
14 Accounts Payable
15 Payroll, Remits & WSIB Accrual
16 Debt
17
Total Assets
Total Liabilities
20 Municipal Position
23 Explanation of Municipal Position
25 In- Service Tangible Capital Assets (Net Book Value)
26 Work -In- Progress Tangible Capital Assets
27 Total Tangible Capital Assets
29 Reserve for Completion of WIP
31 Anticipated Tangible Capital Assets
33 Reserve for Non - specific Capital Needs
35 Capital Funds
37 Capital Reserves
39 Net Capital Portion
41 Operating Reserves
44 Municipal Position
8
2010
2011
11,203,506
1,422,687
493,063
182,250,322
2,115,385
197,484,963
(3,448,175)
(3,065,284)
(6,513,459)
190,971,503
182,250,322
2,115,385
184,365,707
4,233,557
188,599,264
(5,662,457)
2,217,969
185,154,776
5,816,727
190,971,503
Change
Ending Bal.
(1,951,844) 9,251,662
1,422,687
493,063
(1,986,811) 180,263,512
2,115,385
(3,938,654) 193,546,308
(3,448,175)
(3,065,284)
(6,513,459)
(3,938,654) 187,032,849
(1,986,811) 180,263,512
2,115,385
(1,986,811) 182,378,897
4,233,557
(1,986,811) 186,612,453
(325,347)
(2,312,158)
(1,626,497)
(5,662,457)
1,892,622
182,842,618
4,190,231
(3,938,654) 187,032,849
Attachment IV
County of Elgin
2011 Balance Sheet and Reserve Budget
Capital Funds
47 Capital Fund Garage
48 Captial Fund Elgin Manor
49 Captial Fund Health Unit
50 Captial Fund Sewage Treatment Plant
51 Capital Fund Pumping Station
52 Capital Fund Ambulance Bases
Capital Fund - ISF Calton Line
55 Capital Funds
Capital Reserves
58 Reserves Library Capital
59 Reserves Terrace Lodge Renovations
60 Reserves Land Purchases
61 Reserves Bridge Replacement
62 Reserves Dutton Ambulance Base
63 Reserves Ambulance Vehicles & Equipment
64 Reserves IT Equipment Replacement
65 Reserves Vehicle Replacement
67 Capital Reserves
70
71
72
73
74
75
76
77 Reserves Staff Training
78 Reserves Donations Library
79 Reserve Economic Development and Tourism
80 Reserves Strategic Planning
81 Reserves Insurance Deductible
82 Reserves Tree Replanting
83 Reserves OMPF One Time Funding
84 Reserves Museum
85 Reserves International Plowing Match
86 Reserves St. Thomas -Elgin General Hospital Foundatio
87 Reserves Performance Excellenc
88 Reserves Orthodonitics
89 Reserves Road Maintenance
90 Reserves WSIB Schedule 2
91 Reserves Archives
92 Reserves Woodlot
93 Reserves Police Services
Operating Reserves
Reserves Donations Elgin
Reserves Donations Terrace
Reserves Donations Bobier
Reserves Donations Alma College Alumnae
Reserves Social Committee
Reserves Working Funds
(33,789)
(1,314,656)
(231, 981)
(1,282,246)
(1,064,000)
(1,735,785)
(5,662,457)
43,804
1,264,446
83,329
444,847
60,000
296,543
10,000
15,000
2,217,969
172,767
11,800
153,399
7,529
1,972
500,000
(33,789)
(1,314,656)
(231, 981)
(1,282,246)
(1,064,000)
(1,735,785)
(5,662,457)
(13,804) 30,000
1,264,446
83,329
444,847
0 60,000
(296,543) -
10,000
(15,000)
(325,347) 1,892,622
(60,000)
(106,000)
112,767
11,800
47,399
7,529
1,972
500,000
Reserves Mill Rate Stabilizati
1,975,844
(14,928) 1,960,917
66,880
102,095
21,923
66,432
6,379
1,959,001
1,745
29,785
333,334
15,873
19,519
254,260
93,586
8,950
13,654
95 Operating Reserves 5,816,727
9
(15,000)
(8,450)
(1,559,001)
2,000
(29,785)
166,667
(2,000)
51,880
93,645
21,923
66,432
6,379
400,000
3,745
500,000
15,873
19,519
254,260
91,586
8,950
13,654
(1,626,497) 4,190,231
County of Elgin
2011 Budget
Departmental Detail
ACCOUNT
4000000
4010000
4020000
4030000
4040000
4050000
4060000
Total Levy
COUNTY OF ELGIN
Corporate Activities
Proposed Budget
Description
Levy Town of Aylmer
Levy Municip of Dutton /Dunwich
Levy Municip of West Elgin
Levy Municip of Bayham
Levy Township of Malahide
Levy Township of Southwold
Levy Municip of Central Elgin
2010
FORECAST/
BUDGET ACTUAL
- 2,930,257
- 1,679,002
- 2,351,823
- 2,554,416
- 3,756,760
- 3,186,979
- 7,003,977
- 2,930,261
- 1,679,217
- 2,351,831
- 2,563,187
- 3,771,994
- 3,186,980
- 7,003,995
Total 2011
Zero Based
Budget
- 2,930,260
- 1,679,009
- 2,351,823
- 2,554,415
- 3,756,759
- 3,186,979
- 7,003,978
4100000 Supp Town of Aylmer
4110000 Supp Municip of Dutton /Dunwich
4120000 Supp Municip of West Elgin
4130000 Supp Municip of Bayham
4140000 Supp Township of Malahide
4150000 Supp Township of Southwold
4160000 Supp Municip of Central Elgin
Total Supplementary Taxes
4400000
4410000
4420000
4430000
4440000
4450000
4460000
Total PILs
PIL Town of Aylmer
PIL Municip of Dutton /Dunwich
PIL Municip of West Elgin
PIL Municip of Bayham
PIL Township of Malahide
PIL Township of Southwold
PIL Municip of Central Elgin
- 23,463,214 - 23487464 - 23,463,223
- 390,000 - 14,839 - 14,839
0 - 48,300 - 48,300
0 - 13,326 - 13,326
0 - 17,001 - 17,001
0 - 52,915 - 52,915
0 -7,568 -7,568
0 - 69,118 - 69,118
- 390,000 - 223,068 - 223,068
- 16,000 - 18,405 - 18,405
- 40,000 - 32,712 - 32,712
- 24,000 - 22,414 - 22,414
0 - 36,779 - 36,779
- 93,000 - 272,235 - 272,235
- 221,500 - 390,729 - 554,658
- 17,000 - 18,224 - 18,224
4270000 Capping Town of Aylmer
4220000 Capping Municip of West Elgin
4230000 Capping Municip of Bayham
4240000 Capping Township of Malahide
4250000 Capping Township of Southwold
4260000 Capping Municip of Central Elgin
Total Capping
5000000
5010000
5020000
5030000
5040000
5050000
5060000
Tax w/o Town of Aylmer
Tax w/o Municip of Dutton /Dunw
Tax w/o Municip of West Elgin
Tax w/o Municip of Bayham
Tax w/o Township of Malahide
Tax w/o Township of Southwold
Tax w/o Municip of Central Elgin
Total Tax Write -Offs
5150000 Tax Relief
- 411,500 - 791,499 - 955,428
0 - 32,401 - 32,401
0 22,463 22,463
50,000 2,001 2,001
0 9,782 9,782
0 - 73,170 - 73,170
0 53,352 53,352
50,000 - 17,973 - 17,973
225,000 43,774 43,774
0 41,062 41,062
0 39,674 39,674
0 0 0
0 49,145 49,145
160,000 22,153 904,590
0 44,081 140,081
385,000 239,888 1,218,325
2,500 0
2,500
Net Tax Revenue - 23,827,214 - 24,280,116 - 23,438,867
16/03/20112:35 PM
J: \Common \Finance \Budget Development \Corporate \Corporate Activities
% CHANGE
Zero Base
Budget
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
- 96.20%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
- 42.80%
15.03%
- 18.22%
- 6.61 %
0.00%
192.73%
150.41%
7.20%
132.18%
0.00%
0.00%
- 96.00%
0.00%
0.00%
0.00%
- 135.95%
- 80.55%
0.00%
0.00%
0.00%
0.00%
465.37%
0.00%
216.45%
0.00%
- 1.63%
ACCOUNT Description
4320000 Interest Income
4370000 Other Revenue
Total Interest & Other Revenue
COUNTY OF ELGIN
Corporate Activities
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
% CHANGE
Zero Base
Budget
- 75,000 - 35,470 - 75,000 0.00%
0 -6,524 0 0.00%
- 75,000 - 41,995 - 75,000 0.00%
5140000 Social Housing 1,577,076 1,578,569 1,511,130 -4.18%
5220000 Child Care /St. Thomas 222,504 174,653 209,503 -5.84%
5230000 Income Maint/St. Thomas 2,089,884 1,939,452 1,244,258 - 40.46%
5210000 Admin Fee /St. Thomas 380,232 360,178 287,776 - 24.32%
Total Social Services 4,269,696 4,052,852 3,252,668 - 23.82%
5160000 Health Unit 834,488 836,313 902,296 8.13%
5110000 Grants 62,800 56,250 55,376 - 11.82%
4330000 Rental Revenue - 664,930 - 677,987 - 516,345 - 22.35%
8000000 Amortization 195,825 213,203 195,825 0.00%
Net Rental Revenue - 469,105 - 464,784 - 320,520 - 31.67%
5120000 Property Assessments 688,092 688,091 705,622 2.55%
4210000 Community Reinvestment - 3,506,700 - 3,510,672 - 2,438,300 - 30.47%
5960000 Project Costs 757,720 590,932 719,399 -5.06%
Other
TOTAL OPERATING COST
0 3 0 0.00%
- 21,265,223 - 22,073,126 - 20,637,327 -2.95%
16/03/20112:35 PM
J: \Common \Finance \Budget Development \Corporate \Corporate Activities
C0
O
0
LC)
O
0
O
O
0
0)
N
O
0
lV
N
O
0
Z N ,
CD �• d
J >
LLJ
u_ Q m
O -0 0
d d 0
i
0
Z 0
O O O
U (� a
0
0
N
O
0
O
N
O
0
N
O
0
O
0
0
O
N
Net Funding Current Year Current Year
LO (0 ) 000000000
CO LO ' ' ' ' 0 0 0 0 0 0 0 0 0
NI �CO (000N • LO- N • 0 • N 0• 0) 0• 0000')
0
0
a)
a)
Cumulative
Project Budget Reserve Name
O I0
0
0
(0 op
00
000000000 CO
" 0 0 0 0 0 0 0 0 0(9
O O • L O - • LC) O • LC) 0- (.6
CO N — • (.0 N 0) CO C0
r
Co
co
Co
co
L.L
O
U
c
0
O
LL
0
O
2
000000000
000000000
'' 0 0 0 0 0 0 0 0 0
C00 0-
N • � N C• 00 • N • 0 0) 0• 00 CO
000000000
000000000
" 000000000
C00NN• �N C• 0 0• N 0• 0) 0• 00 CO
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 LC) N 0 LC) 0 LC) 0
0N— 0N(3)00 CO
CO
N
ti
co
N
ti
0
0
0
ti
CO
1)
0
0
0
ti
co
1)
a) a) v
0) 0) o d
o `o m o `0 m c 0
Q � 0_ N o d
Ul C a) m '— C O O D
Ea) N .c o N .E N N N .0 (0 N 'c c H
c73 92 0) a) • E • -13 E a).- a) E ' -0 E.o O
U 'O N o O c U U -O a) 0 O
a) 'c 3w QHWCT) 73 If X QHWCT) ++
O_ (n c V V (n V m 1 W V V (n v c i
00a-O� a)a0 „a) .Up��� OD U.0 O .- .-.- w 0 d
of `m a) c E.0 0 c o(0r)u)u)LAC)- m o m o(0r)(0r)U)U) -L` 0
C.1 0 0 Z m rn c E ° co co co co O o c E 0 0o 0o 0o 0o O
Q .� � m m W m `p o m 03 03 03 03 4-, 03 0 0 03 03 03 03 0 '0_ CU
0� =cn=CC SCO :665 a0 =sa0 _ 1—
N CO V LC) CO CO (V N M V LC) O') N N (Y) V LC) C0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
V V V V V V V 0 0 () V 0 0 0 0 0 V 0 () V 0 0 0 0 0 0
C0 CO CO CO CO CO CO r r 00 00 0 0 0 0 0 (O r CO CO 0 0 0 0 0 0
N N N N N N N N N N N N N N N N N N N N N N N N N N
16/03/2011
a)
0)
0
U
N-2
0
(0
a)
a)
0
0
(.0
a)
U
a)
0
0
a)
0
O
U_
c
a)
E
0
O
a)
aa)
0
0)
0
a)
U
c
c
ii
0
E
E
0
0
COUNTY OF ELGIN
GRANTS AND LOANS
2011 Budget 2010 2011
Grants
1 Shedden Agricultural Society 4,500 4,500
2 Wallacetown Agricultural Society 4,500 4,500
3 Rodney - Aldborough Agricultural Society 4,500 4,500
4 Aylmer & East Elgin Agricultural Society 7,500 7,500
5 Elgin 4 -H Association 2,000 2,000
6 Tillsonburg & District Multi- Service Centre 4,500 4,022 Based on proportion of clients
7 Quad County Support Services 2,000 2,000
8 Seniors Picnic 2,500 2,500
9 Non - specific 2,797 5,000 Re- establish normal level for Non -
Specific
10 Town Crier 2,000 2,000
11 Second Stage Housing 5,000 5,400 Increase requested
12 Elgin Community Nutrition Partnership 5,000 5,000
14 Elgin County Plowmen's Association 200 200
15 Med Quest Pilot Project 3,500 3,500
16 Dutton Medical Centre 10,000 10,000 each year for three years 2008-
2010
19 Ontario 911 Advisory Board 100 100
20 Tourism Signage Grants 2,204 2,654 Adding Signs for Pearce Williams
Total Regular Grants 62,800 55,376
Current Year (Higher) /Lower Prior 7,425
Tab 10 - Page 1 of 1
14
2011 Operating Budget
Revenue
Warden and Council
Warden
Council
11) Warden and Council
Expense
80,282
267,870
348,152
J: \Finance \2011 Budget PDF \SummaryTempOperating ii§dget 16/03/2011 4:20 PM
Net Budget
(Revenue)/
Expense
80,282
267,870
348,152
ACCOUNT Description
Total Revenue
5300100 Wages
Total Salary
5400100 Benefits
5490100 Benefits - Manulife
Total Benefit
5500100
5505100
5510100
5600100
5610100
5630100
5730100
5750100
6090100
Travel
Travel - Other
Development
Recognition
Memberships
Office Supplies
Expenses
Election Reception
Miscellaneous
Total Operations
Other
TOTAL OPERATING COST
COUNTY OF ELGIN
Warden
Proposed Budget
2010 Total 2011
FUKI AS 1 /I Lero Based
BUDGET ACTUAL I Budget
0
0 0
0
52,500
0
52,296
0
53,681
52,500
2,556
0
2,556
4,500
0
12,499
7,750
1,000
0
3,000
1,000
0
29,749
0
84,805
52,296
2,441
0
53,681
2,851
0
2,441
2,799
0
11,755
6,760
50
73
2,990
1,279
88
2,851
4,500
0
6,499
7,750
1,000
0
3,000
1,000
0
25,795 23,749
0 0
% CHANGE
Lero base
Budget
0.00%
0.00%
2.25%
80,531 80,282
11.55%
0.00%
11.55%
0.00%
0.00%
- 48.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
- 20.17%
0.00%
-5.33%
16/03/20112:19 PM 16
J: \Common \Finance \Budget Development \Corporate \Warden
ACCOUNT Description
COUNTY OF ELGIN
Council
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
0 0
Total 2011
Zero Based
Budget
0
Total Revenue 0 0 0
5300110 Wages 155,652 153,547 159,154
% CHANGE
Zero Base
Budget
0.00%
0.00%
2.25%
Total Salary 155,652 153,547 159,154
5400110 Benefits 30,744 17,703 31,620 2.85%
5490110 Benefits - Manulife 0 13,585 0 0.00%
Total Benefit 30,744 31,288 31,620 2.85%
5500110 Travel 6,996 7,442 6,996 0.00%
5505110 Travel - Other 0 0 0 0.00%
5510110 Development 36,996 18,511 36,996 0.00%
5600110 Recognition 0 1,585 0 0.00%
5610110 Memberships 10,000 12,620 10,000 0.00%
5630110 Office Supplies 1,500 723 1,500 0.00%
5650110 Advertising 900 755 900 0.00%
5660110 Printing 2,000 1,688 2,000 0.00%
5760110 Meals /Refreshments 8,004 6,492 8,004 0.00%
5860110 Supplies 396 0 396 0.00%
6080110 Ties, Crests, Pens, Gifts 4,004 1,365 8,804 119.88%
6090110 Miscellaneous 1,500 1,643 1,500 0.00%
Total Operations 72,296 52,824 77,096 6.64%
Other 0 0 0 0.00%
TOTAL OPERATING COST 258,692 237,658 267,870 3.55%
16/03/20112:18 PM 17
J: \Common \Finance \Budget Development \Corporate \Council
Administrative Services
Administrative Services
Agriculture
Police Services Board
12) Administrative Services
2011 Operating Budget
Revenue
1,200
33,840
35,040
Expense Net Budget
(Revenue)/
Expense
401,561
36,109
33,840
471,510
400,361
36,109
436,470
J: \Finance \2011 Budget PDF \SummaryTempOperating gdget 16/03/2011 4:22 PM
COUNTY OF ELGIN
Administrative Services
Proposed Budget
ACCOUNT Description
4360130 Project Revenue
Total Revenue
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
0 0 -1,200
0 0 -1200
5300130 Wages 278,526 267,181 309,564
5310130 Vacation Pay 0 716 0
5330130 Vacation Hrs 0 21,307 0
5370130 Sick /Bereavement 0 1,789 0
% CHANGE
Zero Base
Budget
0.00%
0.00%
11.14%
0.00%
0.00%
0.00%
Total Salary 278,526 290,992 309,564
5400130 Benefits 69,333 51,480 51,227 -26.11%
5480130 Benefits - STD 0 292 3,547 0.00%
5490130 Benefits - Manulife 0 10,404 17,926 0.00%
Total Benefit 69,333 62,175 72,701 4.86%
5240130 Accessibility Committee 2,000 0 2,000 0.00%
5245130 Rural Initiatives Committ 5,000 0 0 - 100.00%
5500130 Travel 3,504 3,260 4,004 14.27%
5505130 Travel - Other 0 203 0 0.00%
5510130 Development 7,896 4,201 7,896 0.00%
5610130 Memberships 1,596 930 2,096 31.33%
5620130 Subscriptions 996 117 996 0.00%
5630130 Office Supplies 1,296 2,863 1,296 0.00%
5880130 Equipment 504 0 504 0.00%
5910130 Special Projects 504 500 504 0.00%
6090130 Miscellaneous 0 72 0 0.00%
0 0 0 0.00%
Total Operations 23,296 12,147 19,296 - 17.17%
Other 0 -11 0 0.00%
TOTAL OPERATING COST 371,155 365,303 400,361 7.87%
16/03/20112:03 PM 19
J: \Common \Finance \Budget Development\Administrative Services\Administrative Services
COUNTY OF ELGIN
Administrative Services
m
0
0
O
0
O
co
O
0
O
N
0
0
co
N
O
0
N
N
0
0
N
O
0
O
O
0
N
O
0
CD
O
N
Net Funding Current Year Current Year
o▪ f0
a)
a)
O
▪ a)
E• a
O
0
oIXo
ct
Cumulative
Project Budget Reserve Name
t I
m
O▪ I0
Description
_
O
0 0
0
0
V
a)
0
a)
0
O
0
N
0
0
N
0
0
0
0
0
N
0
0
N
0
0
N
0
0
N
0
0
N
0
0
N
PSB Administrator Fee
Total Operations Pr
a
m
0
N
16/03/2011
0
0
m
U
a)
O
d
a)
a)
U
a)
a)
O(6
NE—
a)
U
a)
N
c
E
5
a)
U
a)
o
g
a)
a)
T.)
aa))
0
rn
a3
ii
0
ACCOUNT Description
Total Revenue
Total Salary
Total Benefit
COUNTY OF ELGIN
Agriculture
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
o o 0
o o 0
o o 0
o o 0
% CHANGE
Zero Base
Budget
0.00%
0.00%
0.00%
0 0 0 0.00%
0 0 0 0.00%
5850230 Purchased Services 35,508 36,109 35,509 0.00%
5930230 Vehicle Repairs /Maint /Ft 601 74 600 -0.17%
Total Operations 36,109 36,183 36,109 0.00%
Other 0 -200 0 0.00%
Total 36,109 35,983 36,109 0.00%
16/03/20112:05 PM a
J: \Common \Finance \Budget Development\AdrrJ rlt e 5 ii6 404ri5ulture
ACCOUNT Description
4350250 Recoveries
Total Revenue
5300250 Wages
Total Salary
5400250 Benefits
Total Benefit
5500250
5505250
5510250
5850250
6090250
Travel
Travel
Development
Purchased Services
Miscellaneous
Total Operations
Other
TOTAL OPERATING COST
COUNTY OF ELGIN
PoliceServiceBoard
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
-27,340 - 23,152
Total 2011
Zero Based
Budget
-33,840
-27340 - 23152.28
9,200 9,200
9,200
0
0
2,000
0
14,000
0
2,140
18,140
0
0
-33840
9,200
9,200 9,200
1 0
1
785
0
3,221
0
9,946
0
2,000
0
14,000
0
8,640
13,951 24,640
0 0
% CHANGE
Zero Base
Budget
23.77%
23.77%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
303.74%
35.83%
0.00%
0
0
0.00%
16/03/20112:11 PM 22
J: \Common \Finance \Budget Development\ Administrative Services \PoliceServiceBoard
ACCOUNT Description
COUNTY OF ELGIN
Financial Services
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
0 0
Total 2011
Zero Based
Budget
0
Total Revenue 0 0 0
5300140 Wages 397,205 350,808 438,041
5330140 Vacation 0 33,901 0
5370140 Sick 0 8,331 0
% CHANGE
Zero Base
Budget
0.00%
0.00%
10.28%
0.00%
0.00%
Total Salary 397,205 393,039 438,041
5400140 Benefits 98,653 72,682 68,433 - 30.63%
5490140 Benefits - Manulife 0 18,519 32,053 0.00%
Total Benefit 98,653 91,200 100,485 1.86%
5500140 Travel 2,249 1,935 2,749 22.23%
5505140 Travel - Other 0 57 0 0.00%
5510140 Development 6,500 3,661 7,000 7.69%
5610140 Memberships 3,446 2,822 3,446 0.00%
5630140 Office Supplies 5,196 5,105 5,196 0.00%
5880140 Equipment 0 0 0 0.00%
5920140 Repairs /Maintenance 500 0 500 0.00%
6090140 Miscellaneous 250 358 250 0.00%
Total Operations 18,141 13,938 19,141 5.51%
Other 0 64 0 0.00%
TOTAL OPERATING COST 513,999 498,241 557,667 8.50%
16/03/201111:59 AM 23
J: \Common \Finance \Budget Development \Financial Services \Financial Services
ACCOUNT Description
Total Revenue
5300160 Wages
5330160 Vacation Hrs
5370160 Sick /Bereav
Total Salary 330,254 313,305 311,105
COUNTY OF ELGIN
Human Resources
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
0 0
Total 2011
Zero Based
Budget
0
0 0 0
330,254 289,245 311,105
0 20,839 0
0 3,222 0
% CHANGE
Zero Base
Budget
0.00%
0.00%
-5.80%
0.00%
0.00%
5400160 Benefits 75,959 62,841 48,794 - 35.76%
5490160 Benefits - Manulife 0 12,586 24,367 0.00%
Total Benefit 75,959 75,427 73,161 -3.68%
5500160 Travel 5,496 3,055 3,996 - 27.29%
5505160 Travel - Other 0 0 0 0.00%
5510160 Development 5,004 3,543 4,504 -9.99%
5610160 Memberships 996 2,040 996 0.00%
5620160 Subscriptions 300 338 300 0.00%
5630160 Office Supplies 5,004 3,074 3,504 - 29.98%
5880160 Equipment 0 0 0 0.00%
5960160 Project Misc 15,000 1,211 15,000 0.00%
6090160 Miscellaneous 7,500 684 700 - 90.67%
Total Operations 39,300 13,944 29,000 -26.21%
Other 0 247 0 0.00%
TOTAL OPERATING COST 445,513 402,923 413,266 -7.24%
16/03/201111:57 AM 24
J: \Common \Finance \Budget Development \Human Resources \Human Resources
O
0
0)
0
0
O
M
O
0
O
N
0
0
N
0
N
O
0
N
O
0
N
N
0
0
N
O
0
0
0
0
N
O
0
O
0
O
N
Current Year Current Year
0
I yI -0 O ccA
Cumulative
Project Budget Reserve Name
O▪ I0
N
r
.O
0
Description
O
O
0
O
O
O
15,000 Reserves Staff Tra A
O
O
0
0)
O
O
O
0)
0
0
0
1)
0
0
1)
0
0
0
1)
0
0
0
1)
0
0
0
1)
Total Operations Pr
16/03/2011 11:57 AM
0)
D
m
U
D
O
d
LOU
N'5
O
a)
a)
c
as
E
a)
a)
O
0 O
a)
a)
c
a3
E
2
N
a)
0
O
a)
a)
c
as
E
2
c
a)
E
Q
O
a)
a)
0
a)
rn
0
m
a)
O
C
c
c
ii
E
O
E
E
O
0
ACCOUNT Description
4330200 Rental Revenue
4370200 Other Revenue
Total Revenue
5300200
5330200
5370200
Total Salary
Wages
Vacation Hrs
Sick /Bereav
COUNTY OF ELGIN
Administration Building
Proposed Budget
5400200 Benefits
5490200 Benefits - Manulife
Total Benefit
5500200
5505200
5510200
5850200
5880200
5920200
5940200
5950200
5960200
6090200
8000200
Travel
Travel - Other
Development
Purchased Services
Equipment
Repairs /Maintenance
Utilities
Property Taxes
Project Costs
Miscellaneous
Depreciation
Total Operations
Other
Total
2010 Total 2011
FORECAST/ Zero Based
BUDGET ACTUAL Budget
-348,002 -362,390
-1,495 -4,419
- 349497 - 366808.66
204,922 185,606
0 11,978
0 0
204,922 197,583
50,204 36,595
0 0
50,204 36,595
9,996 7,135
0 1,417
4,001 2,064
223,404 211,517
3,996 6,316
30,000 21,355
162,998 134,447
26,780 17,045
75,000 56,098
4,500 148
34,430 35,822
575,105 493,365
-354,327
-1,495
- 355821,667
204,691
0
0
204,691
44,483
0
44,483
9,653
0
4,000
224,000
6,000
30,000
162,000
27,000
231,125
5,000
34,430
0 0
480,734 360,734
733,208
0
% CHANGE
Zero Base
Budget
1.82%
0.00%
1.81%
- 0.11%
0.00%
0.00%
626,560
- 11.40%
0.00%
- 11.40%
- 3.44%
0.00%
- 0.02%
0.27%
50.15%
0.00%
- 0.61%
0.82%
208.17%
11.11%
0.00%
27.49%
0.00%
30.33%
16/03/20118:45 AM 26
J: \Common \Finance \Budget Development \Engineering Reports\Administration Building
COUNTY OF ELGIN
Proposed Budget
(0
O
0
0
0
O
O
0
rn
O
0
[V
0
O
0
0
0
O
0
O
0
O
O
0
O
0
O
0
O
N
Current Year Current Year
0
0
v
v
v
Cumulative
Project Budget Reserve Name
0
0
0000 0 [n
0 0 0 0 O N
" ' 0000 O
O [n O O O (O
N M V
0 0
0 0
0 0
0 0
0 [n
0 N
O [n O O O O-
N— N M V
0 0 0 0 0 U)
'' 0 0 0 0 0
O [n O O O CO-
N— N M V
0 0 0 0
00 00 0 0
0 0
0 [n
00 N
LO- O O 66(.6
0 0
0 0
0 [LO
0 0
O 0
O 0
0 [n
0 N
N N 66 (.
N
M
N
N
M
N
0
O)
0
111011
O
0
O
0 0 0 0 0 0 0
0 0 0 0 0 0 0
'' 0 0 0 0 0 0 U)
O U) U) LO O)
0 N M M N
0 0 0 0 0 0 0
000000 [f)
O U) [f) C ) O)
N N
O N— N M M N
0 0 0 0 0 0 0
'' 0 0 0 0 0 0 U))
O U) [f) C ) O)
N N
O N— N M M N
0 0 0 0 0 0 0
0 0 0 0 0 0 0
'' 0 0 0 0 0 0 U)
O N M M N
0 0 0 0
0 00 00 00 00 00 00 00
[n 0 in in in 0 0 U)
6
O N M co N 0
O
O
O
M
O
O
O
O
co
co
co
N
co
O N
O r
cO
M (D
a)
O N
O r
co-
C
co
O N
O r
C O
co
co
Description
U
0
0
c
E
(n -0 c .� 0)
= . E 0
E< aa)Q
O Qa E t U U)
L 0 U a) .
d w U m E L 0 .= U) E U) U U U U) w 0
a 0_ cn N E N m Q U 6 U Q 0 0
.2 = i a-_ m.0 c, N a}1 2 L O N °_-
n m Q 32 " a) n
CU
E E_ O o E c c c
ful mc006 a
1 > D m m con o
..
U N U C: U
O m _ >
i 1 2 > QLE
0 0 0— N 0 0 0 0 0
0 0 0 O 0 N-
ous maintenance
0 0 0
CO CO CO
N N N
Karen St. Pumping Station DC Charges
0 0 0 0 0 0 O O
co co co co co co co co
N N N N N N NN
Total Operations Projects
CO
V
a)
O
L
a
Q
cc
U
c
E a
Q LL Q
w w ' E
a E
c m e c o m <
c �� E m n w
'-a a c D< •EQ > _ E a) c
Q 0 Q C T •m .� Q o :w N Q ° N
w m. E E w 0 o n w° Q Q
U) „,,,..,,,,),T) N a= 2' Q E N E. U
N C 'O O U Q Q N .0 E U) H O
Q m m o rn o 'E - w 0 m> U`) m O m
�� nO EO:cU m m aQ E Os `owH
w U)�' >t m,- rnL O QED w�
> ; 0 m ° E t 5 O
Q I E O< ui J U) :1E: D>, C Os.) U o .0 Q
N 0 Q m m o o f.c m o5 m.0 E >
U> U) ct-, ._ 0 U O- .5 -0-a S N C
U 2' '7 7 X C [6 U .N O2 '7 7 0 c U U
Q a iJ: = m m w w m (.n 0 d m m 0 m d' Z
CO M M N M V [n CO V V U) CO I- 0N— N
0 0 0 0 0 0 0 0 0 0 N— 0 0 0 0 N— N— N-
O O O CO 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO
CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO
N N N N N N N N N N N N N N N N N N
Total Capital Projects
Total Operating and Capital Projects Budgets
16/03/2011 8:45 AM
ACCOUNT Description
4350120 Recoveries
4360120 Project Revenue
Total Revenue
Total Salary
5470120
5490120
Total Benefit
5510120
5600120
5610120
5640120
5680120
5700120
5720120
5770120
5780120
5800120
5810120
5860120
5940120
6080120
COUNTY OF ELGIN
Corporate
Proposed Budget
Benefits Retiree
Benefits Retiree - Manul
Development
Recognition
Memberships
Photocopy
Telephone /Fax
911 Emergency Respon
Postage /Courier
Legal & Professional
2010
FORECAST
BUDGET /ACTUAL
- 1,000 -1,000
0 -2,050
Total 2011 % CHANGE
Zero Based Zero Base
Budget Budget
-1,000 0.00%
0 0.00%
Audit
Insurance
Payroll Charges
Supplies
Utilities - Hedge
Bereavement Flowers /Di
Total Operations
Other
TOTAL OPERATING COST
- 1,000 -3,050
0 0
15,539 2,119
0 9,479
15,539 11,598
-1000 0.00%
0 37
10,000 12,071
0 0
7,000 4,881
37,500 35,931
0 0
19,500 16,878
128,800 78,666
21,500 20,941
277,200 277,598
25,380 23,040
1,800 1,120
0 - 18,314
9,996 7,252
538,676 460,102
0 535
553,215 469,185
0
15,539 0.00%
0 0.00%
15,539 0.00%
0 0.00%
12,500 25.00%
1,500 0.00%
7,000 0.00%
37,500 0.00%
0 0.00%
19,500 0.00%
128,800 0.00%
21,500 0.00%
294,768 6.34%
25,380 0.00%
1,800 0.00%
0 0.00%
9,996 0.00%
560,244 4.00%
0 0.00%
574,783 3.90%
16/03/20112:21 PM 28
J: \Common \Finance \Budget Development \Corporate \Corporate
Engineering & Land Division
Engineering Services
Land Division
17) Eng'r & Land Div.
2011 Operating Budget
Revenue
2,496,635
99,996
2,596,631
Expense
13,253,030
86,832
13,339,862
J: \Finance \2011 Budget PDF \SummaryTempOperating fidget 16/03/2011 4:23 PM
Net Budget
(Revenue)/
Expense
10,756,395
(13,164)
10,743,231
ACCOUNT Description
4205170
4215170
4360170
4370170
COUNTY OF ELGIN
Engineering Services
Proposed Budget
Project Rev - Prov
Project Rev - Fed
Project Revenue
Other Revenue
Total Revenue
5300170 Wages
5310170 Vacation Pay
5330170 Vacation Hrs
Total Salary
5400170 Benefits
5490170
Total Benefit
5500170
5505170
5510170
5610170
5630170
5640170
5880170
5930170
5940170
5960170
6090170
6310170
6320170
8000170
Benefits - Manulife
2010
FORECAST/
BUDGET ACTUAL
- 1,926,960
- 3,442,465
- 37,188
- 86,001
- 1,334,544
- 2,844,443
- 37,828
-158,982
Total 2011
Zero Based
Budget
- 396,965
- 1,912,469
- 87,201
- 100,001
- 5,492,614
276,913
0
0
- 4,375,797
246,351
838
15,716
- 2,496,635
278,645
0
0
276,913
67,844
0
262,905
48,300
12,065
278,645
66,753
0
Travel
Travel - Other
Development
Memberships
Office Supplies
Photocopy
Equipment
Vehicle Repairs /Maint /Ft
Utilities Street Lights
Project Costs
Miscellaneous
Railway Protection
Maintenance /Lower Tier
Amortization
Total Operations
Other
TOTAL OPERATING COST
67,844
17,000
0
6,000
2,800
2,496
2,004
3,000
7,000
20,004
748,310
9,996
54,997
2,719,094
7,265,102
60,366
11,509
219
5,643
2,350
1,744
0
2,764
5,693
18,336
625,316
8,733
43,379
2,671,742
7,002,697
66,753
16,300
0
6,000
2,500
2,500
2,000
3,000
7,000
20,000
2,747,789
10,000
55,000
2,770,441
7,265,102
10,857,803 10,400,124 12,907,632
0 642 0
% CHANGE
Zero Base
Budget
- 79.40%
- 44.44%
134.49%
16.28%
- 54.55%
0.63%
0.00%
0.00%
5,709,946 6,348,240 10, 756, 395
- 1.61%
0.00%
- 1.61%
- 4.12%
0.00%
0.00%
- 10.71 %
0.16%
- 0.20%
0.00%
0.00%
- 0.02%
267.20%
0.04%
0.01%
1.89%
0.00%
18.88%
0.00%
88.38%
16/03/20118:36 AM 30
J: \Common \Finance \Budget Development \Engineering Reports \Engineering Services
M
O
0
V
O
0
0
0
0
N
0
0
r
N
0
0
ei N
Z v W 0
J .0
w w
LL N
Oa)-0
w
N N
Z as Q 0
C O
O �5
w
N
O
0
0
N
O
0
0
N
Current Year Current Year
M 0 0 0 0 0 0 0 0
' ' 0) ' ' O ' ' ' ' 000000 ' O
N CO 0 ONO LO- ' O0 N
0I 0
rn
0)) M
a)
N
O M CO 000 0000 LO
0' ' ' ' LOO ' ' 0 0 0 0 0 0 0 CO N
C N N M S ON V 0- ON- N OD
0
LL
N W
Z
Cumulative
Project Budget
O O CO COO 0000000
O O CO 0 00 0 0 0 0 N
' ' 0 ' ' 0 ' ' ' U ' ' 000000000
CCOO r N- O N V O 0 N- N CO L0
M 0) .- .- .- r
0 M COO 0000000
' ' ' 0 ' ' ' ' ' ' LOO ' ' N-000 0 0 0 0 CO N
Ln (N I�OLn Ln OO Ln Ln
a 'a N V V M N CO r
N m
Z
O o0000000L0
O0
LO-
O O LO- ' O 0 N- N M LO o N CO
al
7
C
al
0)
M CO Ln
0 .- 0 0
N M M 110
V
M
tD
O
co
0
M
CO
N
N
M
0
M
N
N
M
0
M
0
1)
CO
O
N
N
M
1)
M
r
aa)) LL N
_C 0 ( .Es
0
0 O- m O ct N
C.) m m Q 0) m Y N
t U C c
0) O- -0 C1
c • w ul W _C ul aa.) i) c d
N r+ L -0 Q m .0 0 a)
L O c p a) C 0 2 (0 d
U C1 m d m E c Q c W -0 c 3 N
N
0) U D m o •
0 .S .� ' 0 M,- -M m
WeEscDac O W M O i () .J C a) Es O N U tl) •Es - J (6 .. L
CO S c m o -0 0> c a1i o S .> 0) c t °) &_ in 0.
L i ._ N J d O N N O Q' =) 0' N N c m (0 C 0) 0
Q 0 a) O 0 Q W c 0 ul 'c Q 0) o E +�+ rzsE 0 0inIYDIYCOLU(OO 0_Et (7 ° 0 o Eio2 °a I-
V NM00000000 V NM 000 O
i
00000000000000 0 0 0 0 0 00
O 00000000000000000 00000
0 O 0)0) 0)O) 0)0) 0)0) 0)O CO 000) 0)O) 0)O) 000
0 N 0 0 0 0 0 0 0 0 0 N N M N O 0 0 0 0 0 N 0
M (DOOM OM (DOOM C0 C0 M C0 OM (DOOM CO
ce
c.)
O
L
0 To
o.
co
U
I� 0) OM
O M O
' OM
N O0 N N
0
0
0 ' '
0
0
N
0
LO
0)
m
M
00
0
N
co
O
M
N
0
0 0 CO CO m
0 . . 0
0
000 0 N-
N
M N O
N 0
0
E
oo 0
0 . . n . . . . N-0)
o �N
c
'En
c
W
a)
O_
O O
O O a)
O O U)
O 0)
N
a)
c
cC
O V W
E 0
N LO Q
LO Et
0_ - 0)
0 c
°o m a) a)
0 U W CO 0 ,= C
Do a 0 _c a m
Q m o f . c . m w_
LL m 0 N W t c
N
C m E N M D O 0 E
0 E
m TN C (O U .(0 O _ �^ 0 O-
c 2. 0 0 ° o 0 o Sao
a) m m aw) Y W c 0 2-0m00-- n rn rn
m
C 5 0 c M. N Et a0i 0 .0 .(05 O)
W N 0 0- Ll U - > °° N z N t
g 2. cn ac) m co a) m (0W .5 a) LL(OLLDD ) F, W U) m
mt 3
(6 102 g Q m (6 ct M (0 O) C 0 0 0 0 0
0
C
w m. c c c az c d (0_,9)
- o 0 0 lc
c 0 'Z1 'Z1 J00 3NN000(00
W c c () O 0
Q.� a) O 0 c — -0 -0 10 -0 -0 -0 -0 -0 0 E
E Z a) C u l - ' - m c m m m m m m m
m- °) ul m m o m O m 0 0 0 O O O O E
d > 0<00 HEt _JEt Et Et ix ix ix ix U
(O N- V N- MN- N,- N M.- x- NN- N M V LO
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0) 0 0 N- CO 0) 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O CO 0) 0) 0) 0 0 0 0 0 N N N N N N N N
N N CO CO CO CND CND CND CND CND CO CO CO CO CO CO CO CO
M
O
U
V
O
0
0
O
0
N
O
0
N
0
0
ei N
Z 0 0 0
J ..
w
LL CO
Oa)-0
4: N
L N N
Z d Q 0
C O
O �a a
w
N
0
U
0
N
Current Year Current Year
LO V O (0aa 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
' ' L C) I- 0 0) ' ' ' ' 0 0 0 ' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
m-00 OON 1.60-1.6 0-660-6(660-60-666666
CO L O N- () (O N- N N V NN- N- W N M O C) CO O N (O I- O I- CO LC) O) O
V N N- N- N- N- N- N- N- N M M N O) N N N- 1616 N
O O 000000000000 0 0 0 0 0 0 0 0 0 0 0 0
"""""00.
"000000000000.000000000000
00 OIn Ln Ln LnOOln (V CO M(O O(OOLn016000000
V CO LO N- N N N V N N- N- a0 N M M CO O N CO I- O r CO L6 O) O
7
() CO N O)NN N-LO L6N
a W
Z
al . . . . . . . . . . . .
al
CD Z
Cumulative
Project Budget
:rail
OIU
O
O
0000 000 0000000000000000000
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0
"00000. "000.000000000000000000000
00000 161(1( 1()OOIn (V CO M(O O(0OL()016000000
0 0 0 N V CO N- N N V N N- N- a0 N M O M CO O N CO I- O r CO L6 O) O
N- LO N N- N- .- N- N- N- N- N M CO N O) N N N- 1616 N
M
0 0
' 00 '
000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
"000.000000000000000000000
00 01010 Lo O OL0(V CO C)(0 O(O 0 Ln 016000000
V CO LO N- N N V NN- N- a0 N M O M M 0 N M N O I- M M L0) O
00 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
00 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
00 000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
00 01010 Lo O OL0(V (O C)(0 0(0010 O Ln 000000
V M LO N- N N V NN- N- a0 N M O M M 0 N M N O r M M L0) O
al
X
O 0 a)
O > J W
U N r I --D
a) r 0 > t
aj > N M cc E
T a)
a3
C 0 U N N
U
c c W c°) N C v 0 E
0 p> O O .--.- N E O_ U M O r a) t O N
O O C ON V, — M N O M M w ct O O
v M E E S 0 r 0 .° 0 .2 o m 0 0 0 0 0� S E °) c W() °
o a)
p � � te
Et Ct CtQ m m C- m m° a0i 3 m m .--1v 0 vv v(n Q D t o
N �' O) O) O) O) 0.E c O O) Q E W N . . . . . . . . . M 4) Dc-N=
C C C C C O W a0 w ' 0 0 0 0 0 0 0 0 0
U i
W W U rn rn rn 't t t t 't D U U) , 0 -a -0 E as as as as as as as as as .o �).� in
to M (n (n (n (n Q_. N O) m m a) () ;6 .5E ' 7 7 7 7 7 7 7 7 7 0, v0) m g E E O 'ES q
0 0 0 0 0 a) > m -a rn a) D= °o c w> (1) vi) 0 0 0 0 0 0 0 0 0 n t -o
0 0 0 0 0 0) 0_ m e a) a) U a) U C O N o U U U U U U U U U o a) d N a) n n -(0 a)
° U a) a) :c_ &- c°. " °) a) (°) ° c t .2 E E E E E E E E E m w M 1 m.
00 M V mE JM N OM C 0(\ a3 2 E V I-ONN' LO N(Y)0EtO ' I-rM CNN
V V 10 r r N O M> M C C_ C O -0 M 0 O) - N- N V V V V Ln r M N- a0 L° M V° 16 Ln
Y ° ° °UU Em` (1) -.S °- -D73 73 73 73 73-D (1)7373737373 0_7373
0 0 0 0 0 m .� D° D°- E .c w 0= o o c c o 0 0 0 0 0 0 0 0 0 0 D o 0 0 0 0. 0 0
V (O r W O) O M N N M V LO M r a0 O) O LO (0 N M V LO M r W O) 0 M Ln N N N M V
.-00000r-W0000000000
0 0 0 0000000000N-00000N-N-000
0 ^ 000000000000000000000
^0000000000000000000 LO 101010100)0)0)0)0)0)0)0)0)0)0)0)0)0) (6 (6 (6 (6 (6 (6 (6 (6 (6 (6 N O) O N N (6 LO O) N N
U N N N N N N N N N N N N N N N N N O O N N N N N N N N N N N N N N N N N N N N N
CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO CO
1)
0
O
co
1)
OCT
er
N
er
co
N
O
0
0
1)
O
0
0
1)
16/03/2011 8:36 AM
a)
O)
0
co N m
W
r ti O
o I- o
U
a) CO M
W CND)
��
0) w
o o .S
M tD )
W
O O U
O CO
M
�) N
� ti �
c
er-
0
1)
1)
1)
0)
c
a)
a)
W
W
CO a)
E
cL
, 0
v O
d
" °
w
c4
W 0) a m
WI. U
U
O. 73 c
c4 LL
Cp 0
!3 C E
E O
i E
W U
W
O
O
1—
ACCOUNT Description
4340220 Fees
Total Revenue
COUNTY OF ELGIN
Land Division
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
-99,996 -75,950
Total 2011
Zero Based
Budget
-99,996
-99996 -75950 -99996
5300220 Wages 40,718 40,455 40,352
5310220 Vacation Hrs 0 2,572 0
5350220 Wages Land Committee 15,600 5,850 9,748
% CHANGE
Zero Base
Budget
0.00%
0.00%
-0.90%
0.00%
- 37.52%
Total Salary 56,318 48,877 50,100
5400220 Benefits 9,972 9,345 8,996 -9.78%
5450220 Lieu 600 1,330 600 0.00%
5490220 Benefits - Manulife 0 0 0 0.00%
Total Benefit 10,572 10,675 9,596 -9.23%
5500220 Travel 2,004 1,233 2,004 0.00%
5505220 Travel - Other 0 0 0 0.00%
5510220 Development 3,996 905 3,996 0.00%
5610220 Memberships 756 660 656 - 13.23%
5620220 Subscriptions 300 297 230 - 23.33%
5630220 Office Supplies 8,000 954 10,000 25.00%
5770220 Legal & Professional 16,704 9,684 10,000 - 40.13%
6090220 Miscellaneous 3,856 207 250 - 93.52%
Total Operations 35,616 13,940 27,136 -23.81%
Total
Other 0 0 0 0.00%
2,510 -2,458 - 13,164 - 624.46%
16/03/201110:16 AM 33
J: \Common \Finance \Budget Development \Engineering Reports \Land Division
Homes
18a i Elgin Manor Revenue
18a ii Elgin Manor Program & Support
18a iii Elgin Manor Dietary
18a iv Elgin Manor Nursing & Personal Can
18a v Elgin Manor Housekeeping
18a vi Elgin Manor Laundry
18a vii Elgin Manor Building & Property
18a viii Elgin Manor General & Admin
18a ix Elgin Manor Facility
18a) Elgin Manor
18b i Terrace Lodge Revenue
18b ii Terrace Lodge Program & Support
18b iii Terrace Lodge Dietary
18b iv Terrace Lodge Nursing & Personal C
18b v Terrace Lodge Housekeeping
18b vi Terrace Lodge Laundry
18b vii Terrace Lodge Building & Property
18b viii Terrace Lodge General & Admin
18b ix Terrace Lodge Facility
18b) Terrace Lodge
18c i
18c ii
18c iii
18c iv
18c v
18c vi
18c vii
18c viii
18c ix
18c) Bobier
Bobier Villa
Bobier Villa
Bobier Villa
Bobier Villa
Bobier Villa
Bobier Villa
Bobier Villa
Bobier Villa
Bobier Villa
18) Homes
Revenue
Program & Support
Dietary
Nursing & Personal Care
Housekeeping
Laundry
Building & Property
General & Admin
Facility
2011 Operating Budget
Revenue
Expense
Net Budget
(Revenue)/
Expense
5,374,591 - (5,374,591)
38,335 304,309 265,974
12,362 944,232 931,870
184,144 4,369,538 4,185,393
425,827 425,827
190,390 190,390
272,732 272,732
404,990 837,282 432,293
258,153 258,153
6,014,422 7,602,464 1,588,041
5,963,200 (5,963,200)
30,368 352,590 322,222
45,398 1,118,128 1,072,730
231,842 4,730,969 4,499,127
401,653 401,653
96 193,997 193,901
286,414 286,414
18,600 562,098 543,498
8,004 209,310 201,306
6,297,508 7,855,160 1,557,651
3,406,315 (3,406,315)
21,168 218,634 197,466
24,986 683,555 658,570
156,518 2,892,538 2,736,020
243,806 243,806
153,840 153,840
268,682 268,682
451,823 441,194
165,571 165,571
5,132,712 1,458,834
10,629
3,673,878
15,985,808
20,590,335 4,604,527
J: \Finance \2011 Budget PDF \SummaryTempOperating fidget 16/03/2011 4:25 PM
COUNTY OF ELGIN
Elgin Manor Revenue
Proposed Budget
ACCOUNT Description
420010 Province of Ontario
450010 Private
451010 Private - Basic Comp
452010 Semi - Private
453010 Semi - Private - Basic Col
454010 Basic
455010 Respite
456010 Bed Retention
458010 Pre LTC
Total Revenue
2010
FORECAST/
BUDGET ACTUAL
- 3,305,394
- 287,350
- 837,889
-34,651
- 227,228
- 552,305
-8,693
-377
0
-3,348,304
- 280,671
- 827,772
- 28,047
- 186,045
- 587,062
- 12,974
-403
0
Total 2011
Zero Based
Budget
- 3,466,694
- 278,987
- 825,027
- 27,836
- 185,214
- 576,786
- 14,046
0
0
- 5,253,887 - 5,271,278 - 5,374,591
% CHANGE
Zero Base
Budget
4.88%
- 2.91%
- 1.54%
- 19.67%
- 18.49%
4.43%
61.58%
- 100.00%
0.00%
0
TOTAL OPERATING COST - 5,253,887 - 5,271,278 - 5,374,591
2.30%
15/03/201112:11 PM 35
J: \Common \Finance \Budget Development \Homes Reports \Elgin Manor \Elgin Manor Revenue
COUNTY OF ELGIN
Elgin Manor Program Support
Proposed Budget
ACCOUNT Description
435040010 Recoveries
Total Revenue
530040010 Wages
530640010 Project Wages
Total Salary
540040010 Benefits
543040010 Vacation Hrs
545040010 Lieu
547040010 Sick/Bereavement
549040010 Benefits - Manulife
Total Benefit
550040010 Travel
550540010 Travel - Other
551040010 Development
585040010 Purchased Services
586040010 Supplies
588040010 Equipment
680040010 Program Specific Raw
Total Operations
Other
TOTAL OPERATING COST
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
- 38,004 - 39,661 - 38,335
- 38,004
177,660
0
177,660
67,821
0
0
0
0
67,821
504
0
96
47,000
4,500
0
F 2,003
54,103
0
261,580
- 39,661 - 38,335
167,093 185,703
0 - 22,439
167,093 163,264
56,648
5,245
3,272
1,039
3,917
48,463
6,613
6,537
1,989
8,498
70,120 72,101
162
0
68
37,865
5,956
0
2,401
504
0
796
57,000
4,500
4,142
2,003
46,452 68,945
0 0
% CHANGE
Zero Base
Budget
0.87%
244,004 265,974
0
4.53%
0.00%
- 28.54%
0.00%
0.00%
0.00%
0.00%
6.31%
0.00%
0.00%
729.17%
21.28%
0.00%
0.00%
0.00%
27.43%
0.00%
1.68%
15/03/201112:07 PM 36
J: \Common \Finance \Budget Development \Homes Reports\EIgin Manor\EIgin Manor Program Support
COUNTY OF ELGIN
CD
0
0
0
co
0
0
SV
0
N.
O N
Q 0
CD
E
L � N
aim o
o -0 U
a°'
O
O a
(� O N
2 a o
U
W
N
0
0
0
N
O
0
N
O
0
0
4—
7
U
4
U
Year Cost
Cumulative
d
N
c ^+ W
N
as c
•/o J E
re
cp — H v
C
J as w
i ~2 a)
1
Description
cm
CO cs) O a)
O
L a) E U
2 1— < c
2
U ct
O�zO 1<
N co
0 0 0 0
0) 0) 0) 0)
Total Operations
COUNTY OF ELGIN
Elgin Manor Dietary
Proposed Budget
ACCOUNT Description
435041010 Recoveries
Total Revenue
530041010 Wages
530641010 Project Wages
Total Salary
540041010 Benefits
541041010 Vacation Pay
543041010 Vacation Hrs
545041010 Lieu
547041010 Sick/Bereave
549041010 Benefits - Manulife
Total Benefit
550041010 Travel
550541010 Travel - Other
551041010 Development
585041010 Purchased Services
586041010 Supplies
588041010 Equipment
592041010 Repairs /Maintenance
681041010 Raw Food
Total Operations
Other
TOTAL OPERATING COST
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
- 12,362 - 10,818 - 12,362
- 12,362 - 10,818 - 12,362
450,719 422,629 426,840
0 0 1,516
450,719 422,629 428,356
217,011 126,757 105,788
0 352 17,420
0 27,646 30,554
0 16,039 23,993
0 3,811 5,734
0 21,561 40,073
217,011 196,166 223,561
504 355 504
0 0 0
1,500 2,044 1,500
3,498 3,301 3,498
23,004 27,293 23,004
3,997 1,526 3,997
6,000 5,563 6,000
253,812 251,283 253,812
292,315 291,366 292,315
0 0 0
947,683 899,342 931,870
% CHANGE
Zero Base
Budget
0.00%
-0
-5.30%
0.00%
- 51.25%
0.00%
0.00%
0.00%
0.00%
0.00%
3.02%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.01%
0.00%
0.00%
0.00%
-1.67%
15/03/201111:44 AM 38
J: \Common \Finance \Budget Development \Homes Reports\EIgin Manor\EIgin Manor Dietary
14- 0
0
L L
O a)
+- a)
L
U d
N
c a)
7 7
1 N
N W
z
++
c
O O
O +, �I
E O
Q 0
m 21 wI
d
E
ct
z
d
d
0
Nd
N
Cumulative
0
N-
o LO
N M
0
N-
o LO
N Cr)
N-
O N-
0 LO
N Cr)
0 r
0 LO
N Cr)
0
LO
0
N
S
0
c
0
•o cn
CD
v E
as
CL N
U i—
c
O c
W •— co
a) 2
1- c N
E •) a)
> O ct
L �j r) cu
cs)Q
.c
2
0 •- o
p��L_
Q Z J
Description
N Cr)
0 0 0 0
0) 0) 0) 0)
cG
Total Operations
15/03/2011 11:44 AM
a)
0)
co
U
O
d
as
0
L
O
cas
G
0)
W
as
0
L
O
as
0)
w
O
cas
G
0)
w
0
0_
a)
cn
a)
E
0
2
c
a)
E
0_
0
a)
0
4)
0)
c
co
N
as
0
E
E
0
U_
COUNTY OF ELGIN
Elgin Manor Nursing
Proposed Budget
ACCOUNT Description
435042010 Recoveries - Supplies & Services
435542010 Recoveries - Wages
436042010 Project Revenue
Total Revenue
530142010 Wages (new) - RN
530742010 Project Wages (new) - RN
Wages RN
531542010 Project Wages - RN
530242010 Wages (new) - RPN
530842010 Project Wages (new) - RPN
532042010 Wages RPN
532542010 Project Wages - RPN
530342010 Wages (new) - HCA
530942010 Project Wages (new) - HCA
533042010 Wages HCA
533542010 Project Wages - HCA
530442010 Wages (new) - DON
531042010 Project Wages DON
534042010 Wages DON
530542010 Wages(new) - WC
535042010 Wages WC
Total Salary
540142010 Benefits (new) - RN
540742010 Project Benefits (new) - RN
Benefits RN
541142010 Vacation Pay - RN
541542010 Project Benefits - RN
543142010 Vacation Hrs - RN
545142010 Lieu - RN
547142010 Sick/Bereav - RN
549142010 Benefits Manulife - RN
540242010 Benefits (new) - RPN
540842010 Project Benefits (new) - RPN
542042010 Benefits RPN
542542010 Project Benefits - RPN
543242010 Vacation Hrs - RPN
545242010 Lieu - RPN
547242010 Sick/Bereav - RPN
549242010 Benefits Manulife - RPN
540342010 Benefits (new) - HCA
540942010 Project Benefits (new) - HCA
541342010 Vacation Pay - HCA
2010
FORECAST/
BUDGET ACTUAL
-9,996 - 11,075
- 45,000 3,048
- 95,956 - 168,199
Total 2011
Zero Based
Budget
-9,996
- 58,044
- 116,104
- 150,952 - 176,225 - 184,144
295,814 277,852 482,977
8,992 25,511 33,279
207,004 200,105 0
21,740 33,065 0
275,188 298,497 446,357
10,351 37,767 57,709
172,079 152,746 0
14,690 37,672 0
971,614 978,986 1,606,658
23,446 20,734 20,908
611,719 618,295 0
21,350 21,350 0
59,512 48,523 97,179
9,718
36,368 30,601 0
30,044 24,052 48,106
18,360 17,362 0
2,778,271 2,823,118 2,802,891
126,751 48,073 106,634
2,340 3,922 16,640
67,605 64,175 0
0 6,793 12,302
5,654 8,502 0
0 27,440 33,444
0 12,949 23,580
0 19,454 16,584
0 16,170 30,421
108,121 58,170 84,794
2,691 14,727 28,855
61,341 60,248 0
3,819 9,622 0
0 21,965 28,420
0 19,752 28,654
0 7,085 11,392
0 19,241 37,512
385,798
6,094
0
250,450
3,782
2,952
16/03/20115:24 PM 40
J: \Common \Finance \Budget Development \Homes Reports\EIgin Manor\EIgin Manor Nursing
390,395
10,454
58,874
% CHANGE
Zero Base
Budget
0.00%
28.99%
21.00%
0
63.27%
270.10%
- 100.00%
- 100.00%
62.20%
457.52%
- 100.00%
- 100.00%
65.36%
- 10.83%
- 100.00%
- 100.00%
63.29%
0.00%
- 100.00%
60.12%
- 100.00%
0.89%
- 15.87%
611.09%
- 100.00%
0.00%
- 100.00%
0.00%
0.00%
0.00%
0.00%
- 21.58%
972.27%
- 100.00%
- 100.00%
0.00%
0.00%
0.00%
0.00%
1.19%
71.54%
0.00%
COUNTY OF ELGIN
Elgin Manor Nursing
Proposed Budget
ACCOUNT Description
543042010 Benefits HCA
543342010 Vacation Hrs - HCA
545342010 Vacation Hrs - HCA
545742010 Lieu $$
545842010 Lieu $$
545942010 Lieu $$
546342010 Top Up - HCA
547342010 Sick/Bereav - HCA
548342010 STD - HCA
549342010 Benefits Manulife - HCA
540442010 Benefits (new) - DON
541042010 Project Benefits - DON
543442010 Vacation Hrs(new) - DON
544042010 Benefits DON
547442010 Sick/Bereav - DON
549442010 Benefits Manulife - DON
540542010 Benefits (new) - WC
543542010 Vacation Hrs - WC
545042010 Benefits WC
549542010 Benefits Manulife - WC
Total Benefit
550042010 Travel
550542010 Travel - Other
551042010 Development
585042010 Purchased Services
586042010 Supplies
588042010 Equipment
592042010 Repairs /Maintenance
596042010 Project Costs
682042010 Medical Director
683042010 Incontinence
689042010 High Intensity Supp /Equipment
Total Operations
Other
TOTAL OPERATING COST
2010
FORECAST/
BUDGET ACTUAL
215,146
0
0
0
0
0
0
0
0
0
285,790
88,914
59,911
27
161
242
2,964
19,543
8,778
72,315
15,819 10,057
0
8,697
0
0
5,300
14,155
2,141
2,760
Total 2011
Zero Based
Budget
0
108,548
90,732
28
166
198
5,933
34,115
0
167,560
18,358
4,859
9,498
0
7,584
4,207
7,295 6,143 11,712
5,550 3,507 4,548
5,172 6,087 0
0 3,074 5,685
1,027,893 1,267,340 1,392,686
495 306 495
0 0 0
2,498 5,072 3,998
19,178 13,728 19,178
44,733 43,943 44,733
12,499 16,538 26,693
9,997 6,079 9,341
8,630 6,550 8,628
19,836 19,855 19,836
41,059 43,785 41,059
0 0 0
158,925 155,856 173,961
0 2,237 0
% CHANGE
Zero Base
Budget
- 100.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
16.05%
0.00%
0.00%
- 100.00%
0.00%
0.00%
60.55%
- 18.05%
- 100.00%
0.00%
35.49%
0.00%
0.00%
60.05%
0.00%
0.00%
113.56%
- 6.56%
- 0.02%
0.00%
0.00%
0.00%
9.46%
0.00%
3,814,137 4,072,326 4,185,393
9.73%
16/03/20115:24 PM 41
J: \Common \Finance \Budget Development \Homes Reports\EIgin Manor\EIgin Manor Nursing
0
U
V
O
0
O
co
O
0
(3)
N
O
0
0
N
N
0
0
N
O
0
O
0
0
N
O
0
O
0
O
N
Current Year
Current Year
Net Funding
N (3)
0 0
0)
✓ )
O
U
N 0)
LO cr)
r 0)
N
N
N
O
C N
O a N
E °ayi
ce
0
y-01
Cumulative
Project Budget Reserve Name
O IU
0 CO O r 1.0 C C9 CO N N
"N- 'M '0 ' ' OO OO O) N ' Ln ' '
N C0 N LC) '- O) V
LC) M N- ,- N
NO 0)
CO CO . N
N
(.0 M 0) I-
I- C9 N r
- M . 0 0 LO
N C0 V
M N- N- N-
(.0 CM9 0) r
- M . 0 0
M co H H
C9 M 0 r
' M ' 0 M
N M H V
M H H H
0 (9 N00NCO
N ' CO ' 0 ' ' CO OD 0) N LO
00 N M N Ln O) •1--
(.0 CO ,- N- N
Oo 00 o rn
N ON ' co 000 ' N
7 N CV- L6 N
C
N }1
ati C)
O: w w
N W N >,
c
aLu 0 W C w � u1 a� .w w
r W M w N W H U W 0
w 1 W c' .m rn,- .c c N. p
O_ 0 W W> O) � .0 H .� > (6 W 0) N N .� N N
c c "'E' c O' ul c
.. ) W a 0 .0) ' .� N O N N .g N 0 rn N Z O .F w N U
L � 3 .c c c H d H c c 0) w N N&- . C O
y a�LL.cp�HO �U Q��O c� N o c�>,a� wU 03 Q m-0 m,_ ,_ o U w c 02 m m 0 0 U - N 03
U�Hw(722�a �ii(7cAH2 &_ c -U EUw.c)
_ O Z Z Z IX Z Z 0-I 0< 2 d_1 H H
ON N N N N N CO 0) 0M CO M CO M N 0) CO N M M M ON N M CO M 0)
0 0 0 0 0 0 0 0 0 0 0 0 0
L
0
U
00000000000000000000000000
vvvvvvvvvvvvvvvvvvvvvvvvvv
0
Total Operations Pr
16/03/2011
COUNTY OF ELGIN
Elgin Manor Housekeeping
Proposed Budget
2010
FORECAST/
ACCOUNT Description BUDGET ACTUAL
Total 2011
Zero Based
Budget
% CHANGE
Zero Base
Budget
Total Revenue 0 0 0 0.00%
530043010 Wages 276,211 259,045 256,119 -7.27%
530643010 Project Wages - HSK 0 0 -3,177 0.00%
Total Salary 276,211 259,045 252,942
540043010 Benefits 84,432 84,745 61,071 - 27.67%
540643010 Project Stat/Combined 0 0 2,759 0.00%
543043010 Vacation Hrs 0 27,876 29,693 0.00%
545043010 Lieu 0 8,757 12,965 0.00%
547043010 Sick/Bereav 0 0 7,765 0.00%
549043010 Benefits - Manulife 0 0 25,375 0.00%
Total Benefit 84,432 121,377 139,628 65.37%
550043010 Travel 253 0 253 0.00%
550543010 Travel - Other 0 0 0 0.00%
551043010 Development 0 75 0 0.00%
585043010 Purchased Services 3,003 3,158 3,003 0.00%
586043010 Supplies 22,499 18,199 22,499 0.00%
588043010 Equipment 7,002 5,040 5,503 - 21.42%
592043010 Repairs /Maintenance 2,000 2,227 2,000 0.02%
Total Operations 34,757 28,698 33,258 -4.31%
Other
Total
0 418 0 0.00%
395,400 409,539 425,827 7.70%
16/03/20112:57 PM 43
J: \Common \Finance \Budget Development \Homes Reports\EIgin Manor\EIgin Manor Housekeeping
COUNTY OF ELGIN
0
N
4
L
U
O
E
Cumulative
rn
LO
C)
N CD O
N CO- (O
rn
Lt) O)
N CD O
N CO- (O
O)
Lt) O)
N CD O
N CO- (O
C)
W +' N CD O
LO
W N 0 cO
4
W m
z
rn
LO C)
N (O O
o� N
U
Description
L
a)
0
New Hire Orientation - TL
N
E o
c) a)
H
co W
2 a)
0 cm
cm cm
> c
QU a)
U
2 L
cn
I— -a O
Q LL
Cr) LO (O
LO LO LO LO
0 0 0 0
CO M M
op
op
op
co
op
Total Operation:
G
0
r-
0
4-
a)
CL
a)
a)
a)
cn
as
2
a)
Y
a)
N
as
as
2
a)
cn
a)
c
a)
a)
as
O
O
U_
ACCOUNT Description
457044010 Valet
Total Revenue
530044010 Wages
Total Salary
540044010 Benefits
549044010 Benefits Manulife
Total Benefit
COUNTY OF ELGIN
Elgin Manor Laundry
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
0 0
Total 2011
Zero Based
Budget
0
0
43,779
0 0
43,779 43,809
43,779 43,779 43,809
% CHANGE
Zero Base
Budget
0.00%
0.00%
0.07%
16,450 16,450 27,600 67.78%
0 0 0 0.00%
16,450 16,450 27,600 67.78%
585044010 Purchased Services 114,997 100,845 114,997 0.00%
586044010 Supplies 2,784 1,644 2,784 0.00%
592044010 Repairs and Maintenanc 0 478 1,200 0.00%
Total Operations 117,781 102,967 118,981 1.02%
Other
TOTAL OPERATING COST
0 125 0 0.00%
178,010 163,321 190,390 6.95%
15/03/201111:58 AM 45
J: \Common \Finance \Budget Development \Homes Reports\EIgin Manor\EIgin Manor Laundry
COUNTY OF ELGIN
Elgin Manor Building
Proposed Budget
2010
FORECAST/
ACCOUNT Description BUDGET ACTUAL
Total Revenue
Total 2011
Zero Based
Budget
% CHANGE
Zero Base
Budget
0 0 0 0.00%
530045010 Wages 44,681 37,854 44,744 0.14%
530645010 Project Wages 0 0 - 11,112 0.00%
Total Salary 44,681 37,854 33,632
540045010 Benefits 19,025 10,263 9,149 -51.91%
543045010'Vacation Hrs 0 3,484 0 0.00%
549045010 'Benefits - Manulife 0 2,877 5,358 0.00%
Total Benefit 19,025 16,624 14,506 - 23.75%
550045010 Travel 96 0 96 0.00%
550545010 Travel - Other 0 0 0 0.00%
551045010 Development 0 0 0 0.00%
585045010 Purchased Services 119,000 133,350 119,000 0.00%
586045010 Supplies 0 49 0 0.00%
588045010 Equipment 2,497 975 2,497 0.00%
592045010 Repairs /Maintenance 23,001 18,474 23,001 0.00%
596045010 Project Costs 66,000 54,297 80,000 21.21%
Total Operations 210,594 207,144 224,594 6.65%
Other 0 332 0 0.00%
TOTAL OPERATING COST 274,300 261,955 272,732 -0.57%
15/03/201111:33 AM 46
J: \Common \Finance \Budget Development \Homes Reports\EIgin Manor\EIgin Manor Building
M
O
0
C L)
0
0
O
0
0
0)
0
0
0
N-
N
O
0
O
0
O
0
0
0
0
0
0
0
N
4
O
E
a1
C
:a
u_
N
z
O
fF
O
0
�IH
d
7
N
d
N
N
a31 OI
N
N
N
Cumulative
Ew
E
co
z
Project Budget
Description
O
0
0 0 0 0 0 0 0 O N
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0.. 0 N-
O N O l(') c lr O Lf- N
0 0 0 0 0 0 0 O
0 0 0 0 0 0 0 0-
0 0 0 0 0 0 0 0
O lf) O lf) O lf) O Lf-
N- N N- N-
0 0 0 0 0 0 0 O
0 0 0 0 0 0 0 0-
0 0 0 0 0 0 0 0 N-
o Lf) o Lf) o Lf) o Lf)
N
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 N-
o Lf) o Lf) o Lf) o Lf)
N
0 0 0 0 0 0 0 0 E
0 0 0 0 0 0 0 0
w 0 0 0 0 0 0 0 0
0- L.6 0- L.6 0- L.6 o L.
N- N N- N-
.
c
O
as
c
0
c w D o
a) (0 N
m in E
+(i)+ a) co
c as
(.) 2 Q
(
d m c -
c
c -o o
.O w 0WW 0) c
co a) 0
CI 0
E u) a) a) _c -2 c E .c
co w E E C Y c
as
cc Q c �=mnW.470 a) (p �o (0
0 >+ 0 N
03 r:t Q C9 0 2 c Q a) a) a>)
W a) w p 0 0 0 0_ , o) L O (0 a)
Q Q a) i .� Y 0_ 0 0
OE m o m m m oo -o o. c o N- N
Hwo Oww _o-°° QHE- m
I,- CO O) O N M V LO (O CO 0)
0 0 0 N- 0 0 0 0 0 0 0 0
0 0 0 0 0
CO
CO
CO
co
CD
CO
CO
CO
CO.
CD
CO
CO
CO
co
t0
CO
CO
CO
co
CD
CO
CO
CO
co
CD
50 Absenteeism Efficiencies
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O) O) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0)
Total Operations Projects
CO CO 0 0
N O 0 0
I� CO , , , , 0 , 0 ,
N- M M N-
0 0
o 0 0
1 0 1 1 1 1 0 1 O
O Lf) LO
N M N-
0 0 0 0
0 0 0 0
0 0 1 1 1 1 0 1 0
CO- d Lf)
N V M
o 0 0
o 0 0
1 0 1 1 1 1 0 1 O
O Lf)
N M
O O
O O
O O
Lf)
N
w
c c w
O
c Q
o w ° E
c
C w
o. °o°w c
c m 0 c .c o uN) o
Qc O W co a)
w w °o o f D c 0 U
c _
O 0 >+ N N V a) N O
> O U
O c c 2 0 0
a) 0 N
0 N N 0 .N
C1)1w=c�c� 0_w
N M V LO CO � 0
0 0 0 0 0 0 0
0 0 0 0 0 0 N- N-
0 0 0 0 0 0 0 0
O) O) O) O) O) O) O) CD
LO LO LO LO
CD
O
0
0
CO
CO
CO
co
ti
O CO
O co 0
CO
O co 0
O CO
CCT
f- M
O CO
O co 0
CCT
f- M
Total Capital Projects
Total Operating and Capital Projec
15/03/2011 11:33 AM
COUNTY OF ELGIN
Elgin Manor Admin
Proposed Budget
2010
ACCOUNT Description
420546010 Project Rev - Prov
435046010 Recoveries
436046010 Project Revenue
Total Revenue
530046010 Wages
530646010 Project Wages
Total Salary
540046010 Benefits
543046010 Vacation Hrs
547046010 Sick/Bereav
549046010 Benefits - Manulife
Total Benefit
550046010 Travel
550546010 Travel - Other
551046010 Development
560046010 Recognition
561046010 Memberships
562046010 Subscriptions
563046010 Office Supplies
564046010 Photocopy
565046010 Advertising
575046010 Petty Cash Over /Short
585046010 Purchased Services
588046010 Equipment
592046010 Repairs /Maintenance
596046010 Project Costs
609046010 Miscellaneous
682046010 Medical Director
685046010 Reimbursed Supplies /CI
800046010 Amortization
Total Operations
Other
TOTAL OPERATING COST
FORECAST/
BUDGET ACTUAL
- 340,932 - 283,330
- 25,847 - 36,964
- 25,000 - 89,416
Total 2011
Zero Based
Budget
- 339,996
- 24,994
- 40,000
- 391,779
158,140
0
- 409,710 - 404,990
137,200 164,252
0 - 18,662
158,140 137,200 145,589
37,324 37,330 34,537
0 12,257 13,832
0 1,717 3,576
0 8,134 15,930
37,324
59,438 67,876
1,254 226 1,254
0 0 0
2,002 2,422 2,252
0 365 0
7,700 7,689 8,200
600 220 600
5,496 3,632 5,000
4,604 4,953 4,604
1,080 769 1,080
0 -26 0
3,004 2,221 3,004
1,505 1,695 1,505
504 1,258 504
31,500 39,938 61,000
504 215 504
3,996 5,955 4,796
25,440 17,262 24,000
505,514 502,701 505,514
594,703 591,493 623,817
0 -179 0
% CHANGE
Zero Base
Budget
- 0.27%
- 3.30%
60.00%
0
3.86%
0.00%
- 7.47%
0.00%
0.00%
0.00%
81.85%
0.00%
0.00%
12.49%
0.00%
6.49%
0.00%
- 9.02%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
93.65%
0.00%
20.03%
- 5.66%
0.00%
4.90%
0.00%
398,388 378,242 432,293
8.51%
16/03/20115:37 PM 48
J: \Common \Finance \Budget Development \Homes Reports\EIgin Manor\EIgin Manor Admin
Description
O 0 0 0 0 0 0 O
' ' O ' 0 0 0 0 0
L6 L() O • O • i c 'Cr- N CO-
'
O O
O O
O O
L(i LO-
N-
Donations Elgir A
111
c
0
c
0
0
O O o
O O O
L0 O O
c a
1.6
O
O
O
O
O
O
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
LO O • c • LO c • V
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
LOS O • c • LOS c • V
0 0 0 0 0 0
0 0 0 0 0 0
0 0 0 0 0 0
LO O • c • LO c • V
(((
o o o o
O
O N
O o N CO-
N-
((
o o
0 N
O o N CO-
N-
O 0 0 0 0 0 0 O N
O 0 0 0 0 0 0 O (0
O 0 0 0 0 0 0 O (0
LO) L() O • O • L() c • V N CO-
---,
■
c
o 0o ' w
co Ln a)
c s
o
0 W
(A a) W W , 0_
0
c .Q c U
^▪ + 92 O O Q T
i-
.2
ri
4-'
W
0
Donations - EM
0 7 O C C
O OQ a) V
c W D 0 c c O 0)
a) p
E c _
• ' p '� N .— C C Y U
�_ c O a) c E U 1 O O O) in
Q a) � � c W
E.°- ED- E QQ a)0 °
a) C �, — N N a) a3 0
W • Q • O (6
W - 0 c- O , V O c. • L- LO a)� >
a) J (n O c H J • a) c 0 fn °
E E c c E -> • o a) a)
CE •o O� a) O O O a) N a3 U +.-' O fl
O w o o 0 0 0 O o m o w< O 0<
N CO V LO N
0 0 N- N- 0 0
0 0 0 0 0 0
CO V L0 (O N- CO 0) 0
O
O O O O O O O O O
O O- 0 0 0 0 0 0 0 0 0
(O N 0) 0) 0) 0) (O N (O (O (O (O (O (O (O (O (O
N C) LO LO LO LO N CO V V V V V V V N V
Total Operations Projects
16/03/2011 5:37 PM
9-
O
E
Cumulative
Current Year
Net Funding
O
Year Cost
Reserve Name s
O O O
O O O
O O O
L(i O • LO
N N-
O O
O O
O O
O LO
O
O
O
10
O O O
O O O
o O O
L(7 O • Lri
N
v O O O
O+r ' °O °O °O
.O L(i O • LO
N
a 13
N m
Z
O O O
O O O
0 0 0
OI N O • L(7
U
m v
c
N co
> co
a
O
O
O
Q
()
Donations Elgir A
Q�
. )w
w �
c
LL
0
m
c Q
o m
0 0
O (o
O 0)
O 1 0)
1.6
V (O
O
O
O
O
O
O
Lci
O
O
O
ti
N
CD
N
(364,996)1 115,000
Description
0
L
0
0
c
o c
E ° o 0
- E -0
m 2 m
°
O U �'� 0) O
o O co Q 0 Q C 0 - w o)
CY .c O Q +-- D Li) D g
N w c o N >
N H _ (_°6 O N (6 C
E c c 03 o o Q w E o Et E W
0
0 Q 0 0 E o Qs °- -
(6 c ', 1- C c N -O
5° w m D c° U a'S °n 0 () c
in o o- o- Et o ,-(D
E W 0 ii Li_
mc 0 03 co
5HZF0Owza °m�°0
N CO V LO CO CO 0) 0 = Cr) V (0 LO
O O O 0 N- N- 0 N- N- O
O - O - O O 0 - 0
(0 (0 (0 (0 (0 (0
Total Capital Projects
16/03/2011 5:37 PM
COUNTY OF ELGIN
Elgin Manor Facility
Proposed Budget
ACCOUNT Description
Total Revenue
Total Salary
Total Benefit
568047010 Telephone /Fax
572047010 Postage /Courier
585047010 Purchased Services
592047010 Repairs /Maintenance
594047010 Utilities
596047010 Project Costs
Total Operations
Other
Total
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
0
0
0
0 0 0
0 0 0
9,504 10,460 9,504
0 787 0
67,896 60,016 67,896
7,999 5,522 7,999
210,999 172,754 172,754
20,000 8,156 0
316,398 257,694 258,153
0 0 0
316,398 257,694 258,153
% CHANGE
Zero Base
Budget
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
- 18.13%
- 100.00%
- 18.41%
0.00%
-18.41%
16/03/20114:36 PM 51
J: \Common \Finance \Budget Development \Homes Reports\EIgin Manor\EIgin Manor Facility
COUNTY OF ELGIN
Terrace Lodge Revenue
Proposed Budget
ACCOUNT Description
420020 Province of Ontario
450020 Private
451020 Private - Basic Comp
452020 Semi - Private
453020 Semi - Private - Basic Co
454020 Basic
455020 Respite
456020 Bed Retention
458020 Pre LTC
Total Revenue
Total Salary
Total Benefit
Total Operations
Other
TOTAL OPERATING COST
2010
FORECAST/
ACTUAL
- 3,874,295
- 127,173
- 375,059
- 114,245
- 758,091
- 622,705
- 15,195
-134
0
BUDGET
- 3,786,636
- 126,984
- 370,181
- 118,649
- 778,061
- 630,105
- 13,679
-329
0
Total 2011
Zero Based
Budget
- 3,942,715
- 127,423
- 376,819
- 112,996
- 751,849
- 634,526
- 16,872
0
0
- 5,824,624 - 5,886,898 - 5,963,200
0 0 0
0 0 0
0 0 0
0 0 0
% CHANGE
Zero Base
Budget
4.12%
0.35%
1.79%
- 4.76%
- 3.37%
0.70%
23.34%
- 100.00%
0.00%
0
- 5,824,624 - 5,886,898 - 5,963,200
0.00%
0.00%
0.00%
2.38%
15/03/20113:33 PM 52
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodge Revenue
COUNTY OF ELGIN
Terrace Lodge Program Support
Proposed Budget
ACCOUNT Description
435040020 Recoveries
Total Revenue
530040020 Wages
530640020 Project Wages
Total Salary
540040020 Benefits
543040020 Vacation Hrs
545040020 Lieu
547040020 Sick/Bereave
549040020 Benefits - Menu life
Total Benefit
550040020 Travel
550540020 Travel - Other
551040020 Development
585040020 Purchased Services
586040020 Supplies
592040020 Repairs /Maintenance
609040020 Miscellaneous
680040020 Program Specific Raw
Total Operations
Other
TOTAL OPERATING COST
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
- 24,998 - 31,900 - 30,368
- 24,998
204,435
0
204,435
73,299
0
0
0
0
73,299
748
0
495
36,140
4,296
495
0
F 2,496
44,670
0
297,406
- 31,900 - 30,368
200,402 197,540
0 -9,422
200,402 188,118
59,516
4,497
5,818
1,111
8,016
67,457
11,057
10,865
3,948
17,339
78,958 110,666
647
0
564
35,824
4,434
90
0
1,383
500
0
700
45,500
5,106
0
0
2,000
42,942 53,806
53 0
% CHANGE
Zero Base
Budget
21.48%
0
- 3.37%
0.00%
290,454 322,222
- 7.97%
0.00%
0.00%
0.00%
0.00%
50.98%
- 33.16%
0.00%
41.41%
25.90%
18.85%
- 100.00%
0.00%
- 19.87%
20.45%
0.00%
8.34%
15/03/20111:51 PM 53
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodge Program Support
COUNTY OF ELGIN
0
U
O
co
O
U
N
O
U
0
O
Q
0.
N
N • O
E
0
i
O m
L
a a;
cn N
Cr) 0 0
0 0
- a
c.)
4: N
O
U
N
O
U
0
0
U
N
O
U
O
U
O
N
Net Funding Current Year Current Year
Cumulative
Net Project
Project Budget Reserve Name
00
O▪ IU
Description
L
0
U
N
N
o
N
N
o
N
N
o
E
_ E U
H a)
I L H U
W
O
• J a) W
(• 6 a )
++
Q) • CF) a) m
a)
O .E o
92 ai 2 ~<
C U w
O zo�Q
✓ N M U)
V V V
O 000
N N N N
O 0) 0) 0)
(0U) U) U)
c
a) = a)
N
N
C:
N
N
N
N
N
N
N
N
Total Operations Pr
15/03/2011 1:51 PM
COUNTY OF ELGIN
Terrace Lodge Dietary
Proposed Budget
ACCOUNT Description
435041020 Recoveries
Total Revenue
530041020 Wages
530641020 Project Wages
Total Salary
540041020 Benefits
540641020 Project Benefits
543041020 Vacation Hrs
541041020 Vacation Pay
545041020 Lieu
547041020 Sick/Bereave
549041020 Benefits - Manulife
Total Benefit
550041020 Travel
550541020 Travel - Other
551041020 Development
585041020 Purchased Services
586041020 Supplies
588041020 Equipment
592041020 Repairs /Maintenance
596041020 Project Costs
681041020 Raw Food
Total Operations
Other
TOTAL OPERATING COST
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
- 43,979 - 45,398 - 45,398
- 43,979 - 45,398 - 45,398
508,924 488,606 514,056
0 0 - 24,331
508,924 488,606 489,725
184,819
0
0
0
0
0
0
155,443
0
18,078
92
12,047
6,740
22,429
131,522
592
29,213
17,294
22,980
13,112
46,795
184,819
502
0
2,497
2,996
29,000
3,001
1,500
0
310,795
214,830
710
0
2,088
2,683
33,091
2,650
1,271
0
305,078
261,509
502
0
2,497
2,996
29,580
4,001
1,500
4,145
321,673
350,291 347,570 366,894
0
0 0
% CHANGE
Zero Base
Budget
3.23%
0
1.01%
0.00%
- 28.84%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
41.49%
0.00%
0.00%
0.00%
0.00%
2.00%
33.32%
0.00%
0.00%
3.50%
4.74%
0.00%
1,000,055 1,005,608 1,072,730
7.27%
15/03/20111:18 PM 55
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodge Dietary
COUNTY OF ELGIN
0
O
0
O)
O
U
O
N
O
N
O
N
0
N
O
N
O
N
Current Year Current Year
a1
m
N
Z
0
0
N
d
N
d
7
—49c1 w
O ce
Cumulative
Project Budget Reserve Name
V
N
O
O a 3
U _ y CO
0
0
O
N
N
O
U
LO LO
N— CO CO
O M
c) ()
M LO
LO
N— • CO CO
O M
c) CO
LO
Li
LO LO
CD • 01 CO LO
- CO LO LO
CO
O M CO LO
- Li
—1 WI a)i
Description
v
R
O E'
O p
U
I
O O O O O
N N N N N
O) O) O) O) O)
LO LO LO LO LO
0
O
Total Operations P
CD CD
cD cD
O O
M N
CD CD
cD cD
O O
Ufi CD-
(,) N
CD CD
O O
0 0
M N
CD CD
cD cD
O O
Ufi CD-
(,) N
CD CD
cD cD
0 0
UD O
M N
N
W 0)
c
' o
0
L o
OmLL
c
L
U
c Y
▪ a)
o m
U
co zc
N
0 N-
O 0
O et
LO% Lp
LO M
O O
O et
L�0 M
ti
Lt
Total Capital Project 1 55,000
Total Operating and Capital
15/03/2011 1:18 PM
COUNTY OF ELGIN
Terrace Lodge Nursing
Proposed Budget
2010
FORECAST/
ACCOUNT Description BUDGET ACTUAL
435042020 Recoveries - Supplies & Service
435542020 Recoveries - Wages
436042020 Project Revenue
- 10,992
- 91,868
- 112,101
- 11,521
- 21,685
- 176,671
Total 2011
Zero Based
Budget
- 10,000
- 63,447
- 158,395
Total Revenue - 214,961 - 209,876 - 231,842
530142020 Wages (new) - RN
530742020 Project Wages (new) - RN
Wages RN
531542020 Project Wages - RN
530242020 Wages (new) - RPN
530842020 Project Wages (new) - RPN
532042020 Wages RPN
532542020 Project Wages - RPN
530342020 Wages (new) - HCA
530942020 Project Wages (new) - HCA
533042020 Wages HCA
533542020 Project Wages - HCA
530442020 Wages (new) - DON
531042020 Project Wages - DON
534042020 Wages DON
530542020 Wages (new) - WC
535042020 Wages WC
Total Salary
540142020 Benefits (new) - RN
540742020 Project Benefits (new) - RN
Benefits RN
541142020 Vacation Pay - RN
541542020 Project Benefits - RN
543142020 Vacation Hrs - RN
545142020 Lieu - RN
545742020 Lieu $$
547142020 Sick/Bereav - RN
549142020 Benefits Manulife - RN
540242020 Benefits (new) - RPN
540842020 Project Benefits (new) - RPN
542042020 Benefits RPN
542542020 Project Benefits - RPN
543242020 Vacation Hrs - RPN
545242020 Lieu - RPN
545842020 Lieu $$
546242020 Top Up - RPN
547242020 Sick/Bereav - RPN
548242020 Sick/Bereav - RPN
549242020 Benefits Manulife - RPN
292,102
25,259
179,270
21,174
327,603
45,983
204,467
23,106
1,081,807
15,210
674,947
5,785
253,874
28,636
159,260
26,153
328,541
52,721
190,683
47,019
1,116,065
8,299
698,901
5,785
59,512 49,092
36,368 34,950
30,044 21,661
18,360 15,377
499,502
8,907
0
0
515,191
90,149
0
0
1,782,787
7,490
0
0
97,179
9,718
0
48,106
0
3,040,997 3,037,018 3,059,027
121,533 42,699 177,529
6,570 4,768 14,264
67,490 57,771 0
0 5,638 8,753
5,506 6,768 0
0 23,932 32,344
0 9,280 14,346
0 472 471
0 6,435 14,941
0 12,159 24,382
96,958
11,957
60,743
6,008
0
0
0
0
0
0
0
83,349
10,417
104,718
12,109
25,867
21,526
2,014
6,324
5,669
789
24,346
15/03/20111:43 PM 57
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodge Nursing
83,760
50,756
0
0
29,586
36,170
1,422
21,442
11,821
0
54,963
% CHANGE
Zero Base
Budget
-9.02%
- 30.94%
41.30%
0
71.00%
- 64.74%
- 100.00%
- 100.00%
57.26%
96.05%
- 100.00%
- 100.00%
64.80%
- 50.76%
- 100.00%
- 100.00%
63.29%
0.00%
- 100.00%
60.12%
- 100.00%
0.59%
46.07%
117.10%
- 100.00%
0.00%
- 100.00%
0.00%
0.00%
0.00%
0.00%
0.00%
- 13.61%
324.48%
- 100.00%
- 100.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
COUNTY OF ELGIN
Terrace Lodge Nursing
Proposed Budget
ACCOUNT Description
540342020 Benefits (new) - HCA
543042020 Benefits HCA
540942020 Project Benefits (new) HCA
541342020 Vacation Pay - HCA
543342020 Vacation Hrs - HCA
543542020 Project Benefits - HCA
545342020 Lieu - HCA
545942020 Lieu $$
546342020 Top Up - HCA
547342020 Sick/Bereav - HCA
548342020 STD - HCA
549342020 Benefits Manulife - HCA
540442020 Benefits (new) - DON
541042020 Project Benefits - DON
543442020 Vacation Hrs - DON
544042020 Benefits DON
547442020 Sick/Bereav - DON
549442020 Benefits Manulife - DON
540542020 Benefits (new) - WC
545042020 Benefits WC
547542020 Sick/Bereav - WC
549542020 Benefits Manulife - WC
Total Benefit
550042020 Travel
550542020 Travel - Other
551042020 Development
585042020 Purchased Services
586042020 Supplies
588042020 Equipment
592042020 Repairs /Maintenance
596042020 Project Costs
609042020 Miscellaneous
682042020 Medical Director
683042020 Incontinence
689042020 High Intensity Supp /Equipment
Total Operations
Other
TOTAL OPERATING COST
2010
FORECAST/
BUDGET ACTUAL
437,544
305,710
15,210
0
0
5,785
0
0
0
0
0
0
274,169
302,963
1,474
268
75,659
2,133
75,559
667
4,304
28,446
4,947
85,289
15,243 10,144
0
8,596
0
0
16,535
6,680
0
0
6,945
8,038
0
4,493
5,438
4,845
328
2,479
Total 2011
Zero Based
Budget
389,897
0
16,297
0
91,206
2,694
114,980
622
6,023
41,817
0
195,074
20,933
4,859
6,764
0
0
6,905
11,078
0
842
4,609
1,188,068 1,365,637 1,491,548
2,002 706 2,002
0 190 0
4,004 1,704 4,004
23,202 11,866 23,202
39,939 32,686 39,939
14,999 14,937 14,999
2,498 1,414 2,498
27,200 11,680 27,197
0 0 0
20,928 22,834 20,928
45,625 46,518 45,625
0 -0 0
180,397 144,535 180,394
0 4,630 0
% CHANGE
Zero Base
Budget
- 10.89%
- 100.00%
7.15%
0.00%
0.00%
- 53.42%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
37.33%
0.00%
0.00%
- 100.00%
0.00%
0.00%
- 33.01%
- 100.00%
0.00%
0.00%
25.54%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
-0.01%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
4,194,501 4,341,944 4,499,127
7.26%
15/03/20111:43 PM 58
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodge Nursing
0
0
N
a)
0
0
N
O
O
0
0
0
0
(
L
- -0
LV Z
LL CO
O 0
Z CD a
0 0
C.) La
H
O
0
0
0
O
0
O
0
O
N
0
N
0
N
0
N
0
N
O
N
0
N
0
N
Current Year
Current Year
0
O
0
N
d
cc
a1
v N
d
7 7
LL
N
d �
Z
0
r
E 'a
O N
E O N
a
0
mi R NI
Cumulative
Project Budget Reserve Name
0
0
N
N
Description
1.5
_ L
O E'
0 0
0
UD 0)
0) (0
N i
N V
N
V 0)
CO O
N i 0
- (0 (0 O) CO R N O V I■
in aO r` V (0 N CO O) O N ■
UD (O (O LO V N O I• - N L
co- O) co- O) N V (0 co- co- V
CO N N M H 1.0 N
Lf) CO
0)
LO
O) O f`
I� V N
in co O O) co I.
O f` V (0 I■ CO
CO CO LO V N O '
O) M O) N V CO-
N H M H
UD O O O) co I.
O) N V (0 I■ CO
CO (0 U) t N O '
M 0) N V CO-
N H M H
UDco co a) co R.
O) N V (0 I,- CO
CO (0 U) t N O '
M 0) N V CO-
N H M H
14-)
(0 V (0 (0 0) CO I2 T■ O V I■
co co V (0 N co 0) O N f`
(D (0 LO V N O I, V N Lf)
I� 0) M 0) N V (0 CO- CO- V
I∎ N N H M H.- N N-
N co co f` V N
/ } ♦� f` 0) CO- aO
J
•O fn
J ~ E o co J O
^L H J J J H° J H o a) H J
CL NH H�fnH.� NH H c� Hp
N J ' J o i O O (0 O° H O O J N W -O L., O O
Z O pH. 'a3 :O N .0 O N N '� N& J N Z O H -0
L O U m m m o U °
ai ° o LL m¢ m 2 1m m m °
)
—0 0cKH0 1ICL N a)�0f.,_ c c o0.°
� Z � o0— N �� � ��w .� O � er J I J Q J O Z Z Z J H Z Z O O< I J J H
O H N M LO (O O) O H N M V LO N O) H (O N (O N O H M O)
N N N N N N N () () () () () () N N () N P) () () N N N 0)
O O O O O O O O O O O O O
O O O O O O O O O O O O O O O O O O O O O O O O
N N N N N N N N N N N N N N N N N N N N N N N N
0 0 0 0 0 0 0 0 0 0 0) 0) 0) 0) 0) 0 0 0 0 0 0 0 0 0
Total Operations P
O O
O O
O O
O O
H
O O
O O
O O
O O
H
O O
CD cD
O O
O O
CD cD
O O
H
O O
O O
O O
O O
H
O
er
O
er
O
0
O
N
0
O
I0
O
0
O
0
O
0
ti
O
N
Total Capital Projec
Total Operating and Capital
15/03/2011 1:43 PM
singTerrace Lodge NursingProject Budget
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodg
COUNTY OF ELGIN
Terrace Lodge Housekeeping
Proposed Budget
2010
FORECAST/
ACCOUNT Description BUDGET ACTUAL
0 0
Total 2011
Zero Based
Budget
0
Total Revenue 0 0 0
530043020 Wages 277,653 263,988 267,595
530643020 Project Wages - HSK 0 0 - 28,336
% CHANGE
Zero Base
Budget
0.00%
0.00%
-3.62%
0.00%
Total Salary 277,653 263,988 239,259
540043020 Benefits 107,347 92,212 56,176 - 47.67%
540643020 Project Stat/Combined 0 0 752 0.00%
543043020 Vacation Hrs. 0 17,778 23,966 0.00%
545043020 Lieu 0 10,905 16,602 0.00%
547043020 Sick/Bereav 0 5,616 7,941 0.00%
549043020 Benefits - Menu life 0 9,600 22,606 0.00%
Total Benefit 107,347 136,110 128,044 19.28%
550043020 Travel 252 239 252 0.00%
550543020 Travel - Other 0 0 0 0.00%
551043020 Development 0 4 0 0.00%
585043020 Purchased Services 3,000 1,394 3,000 0.00%
586043020 Supplies 27,499 29,076 27,499 0.00%
588043020 Equipment 2,003 1,476 2,003 0.00%
592043020 Repairs /Maintenance 1,596 -793 1,596 0.00%
609043020 Miscellaneous 0 14 0 0.00%
Total Operations 34,350 31,410 34,350 0.00%
Other 0 0 0 0.00%
TOTAL OPERATING COST 419,350 431,508 401,653 -4.22%
15/03/20111:26 PM 60
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodge Housekeeping
COUNTY OF ELGIN
O
0
0
0
0
0) o
i UN
.Q
a)
ai
a) 0)
co U)
• N
CO O O
= . o
a) a)
0) co
-0 O
O Q
J O
N
TD
L U
a)
0
0
O
0
0
0
0
Current Year Current Year
a1
LL
N
Z
rri
0
0
N
N
d
7
a O
Y�I
WI Y!1
Cumulative
Project Budget Reserve Name
Description
.5
R
o '
o 0
0
N
(.)
• m 0
CO v
CO CO CO
• O
• m o
CO N.- V
CO CO CO
H O
co
ti
co
ti
c•1
co
ti
c•1
co
ti
co
ti
c•1
as c
0 (1) a H .5
c C
O J 03 w
is H a)
= C ' N O
4.+ • , 0) (0
.c) a) a)
CU • 0: o
O Z O J H _o
Q
0 - 0 0 - 0
N N N N
O O O O
Total Operations Proje
15/03/2011 1:26 PM
O
to
U
a)
0
0
0)
c
.Q
a)
Y
a)
(1)
O
a)
0
O
J
a)
N
H
O
c
.Q
a)
Y
a)
(1)
a)
0)
0
a)
0
a)
Q
a)
a)
a)
Q
T.)
0
m
N
U_
ACCOUNT Description
COUNTY OF ELGIN
Terrace Lodge Laundry
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
435044020 Recoveries -96 -8 -96
457044020 Valet 0 0 0
Total Revenue -96 -8 -96
530044020 Wages 53,603 53,603 53,742
Total Salary 53,603 53,603 53,742
% CHANGE
Zero Base
Budget
0.00%
0.00%
0
0.26%
540044020 Benefits 17,207 17,207 27,600 60.40%
549044020 Benefits Manulife 0 0 0 0.00%
Total Benefit 17,207 17,207 27,600 60.40%
585044020 Purchased Services 105,000 109,006 105,000 0.00%
586044020 Supplies 7,404 4,362 6,404 -13.51%
592044020 Repairs /Maintenance 251 1,301 1,251 398.41 %
Total Operations 112,655 114,669 112,655 0.00%
Other 0 0 0 0.00%
TOTAL OPERATING COST 183,369 185,471 193,901 5.74%
15/03/20111:30 PM 62
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodge Laundry
ACCOUNT Description
435045020 Recoveries
Total Revenue
COUNTY OF ELGIN
Terrace Lodge Building
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
0 -1
Total 2011
Zero Based
Budget
0
0 -1 0
530045020 Wages 37,685 38,390 44,744
530645020 Project Wages 0 0 -3,815
Total Salary 37,685 38,390 40,929
% CHANGE
Zero Base
Budget
0.00%
0.00%
18.73%
0.00%
540045020 Benefits 21,637 10,240 9,056 - 58.14%
543045020 Vacation Hrs 0 4,182 0 0.00%
549045020 Benefits Manulife 0 2,888 5,377 0.00%
Total Benefit 21,637 17,311 14,434 - 33.29%
550045020 Travel 748 615 748 0.00%
550545020 Travel - Other 0 0 0 0.00%
551045020 Development 495 0 495 0.00%
585045020 Purchased Services 95,000 115,629 95,000 0.00%
586045020 Supplies 999 273 999 0.00%
588045020 Equipment 0 1,969 0 0.00%
592045020 Repairs /Maintenance 20,809 16,196 20,809 0.00%
596045020 Project Costs 49,000 28,469 113,000 130.61%
Total Operations 167,051 163,150 231,051 38.31%
Other 0 166 0 0.00%
TOTAL OPERATING COST 226,373 219,016 286,414 26.52%
15/03/20114:56 PM 63
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodge Building
CD
0
0
L)
0
0
O
0
0
O
0
0
0
N-
N
0
0
0
0
O
O
0
O
0
O
N
0
E
Q
Current Year Current Year
0 O1
N
N
ea
m N vI
Cumulative
Project Budget
1 m
m
NI
O
0
Description
0 0 0 0 0 0 0 0 0
0 0 UD O O O O UD O CO
LO- V O) O CO- O CO- N 0 M
N
000000000(cD
0 0 0 CO CO CO CO 0 0
oOUD0000UD0ao
l(i V O) O CO- O (M N (O
N
CO-
O
O O O O O O O O
0 0 LO 0 0 0 0 LO 0 CO
V O O CO- O() N (O M
N
000000
0 CO CO O CO CO
0 o O
ooUD0000UDoao
L (7 V O O CO- O M N (O M
N
CO-
O
O O O O O O O O
0 0 LO 0 0 0 0 LO o CO
V O O CO- O N (O M
N
y J J
H H
/L U U
A c U
a) ° E (o U c
H E Q a)
(0 a) (0 a) a) N U
c
U c U Q' i c .(7
O N O c (B > (0 (0 Q W c
a) - N
a)) a2 .( Et o Q a) m (O '(
J U e W U Y U H 0 O a) e
w ~ CO a� m
ci c .0 O C. a� < H fl N: U
0
0_ u_ �(iv�v)IOOC <
co
0
I0
co
0
co
w
co
0
co
0
CO O) O CO O) O N M V LC) (O O) O
O O O O LC)
O O O
O O O O O O O O O O O O O
N N N N N N N N N N N N N
O O O O O O O O O O O O O
LO LO LO LO LO LO LO LO LO LO LO LO LO
New Building Financing
Total Operations Project:
15/03/2011 4:56 PM
C9
O
0
L)
0
0
O
O
0
O
0
0
0
•
T-
N
0
0
0
0
O
O
0
0
0
O
0
O
N
0
E
Q
Current Year Current Year
O▪ I0
N
N
cl m V.) vI
Cumulative
Project Budget
N1
O
0
Description
O
0
0 CO
O (O
0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
N LC) LC) LXD O • O O O O N-
CO N N N CO N
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
' 0 0 0 0 0 0 0 0 0'
LC) LC) LC) O O O O O N-
N N .— N CO N -
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0
N
J
H J
H
LC) LO. l6 O • O O O O N
N N N CO N
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0'
LC) LO. UD O • O O O O N
N N N CO N
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0
LC) LO. u, O O O O O N
N N N CO N
CO ce)
CO LO
CO
C4 ce)
• LO
LO
co
CD
Lp
LO
✓
LO CD
• LO
LO
✓
M LO
LO
co
O r
M LO
J J C N
H H a) E 2
▪ E J H a.) J Q E u)
°' co• ~ >, H ° ( E
i co J O >, +- >+ M E
E Q Q • H Q
E c8o E °� m ~ a) o c E a0i 0 > E CO
• Y O
a• �i • °) v E Y U c �° as T uu)) '- 0 u) a) `O
• 4_0) =QO %��Q °�w8D 00)
� _Uct 2J QcnHct . =Qy_ a)Q¢00 el-• -o E
`O 0 C N- . O N c QQ O C C o • m ct
Q >-0c w U _I'a
C
- N o Laa3 Laa3 U 0_ i L_ lii
e l - • CO I W - 5 U) CO J CO I> Q CO LL 0 W Ct J J H Ct z H
N V N (') V UD (O I■ V() V LO CO 0 V LC) 0) 0
000000000N— O N N N N M M M M V
0) 0) 0 0 0 0 0 0 0 0
O O
O O O O O O O O O O O O O O O O O O O O
N N N N N N N N N N N N N N N N N N N N
O O O O O O O O O O O O O O O O O O O O
Total Capital Projects
15/03/2011 4:56 PM
ACCOUNT Description
435046020 Recoveries
436046020 Project Revenue
COUNTY OF ELGIN
Terrace Lodge Admin
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
- 14,496 - 17,796 - 18,600
- 10,000 - 12,659 0
Total Revenue - 24,496 - 30,455 - 18,600
530046020 Wages 215,223 193,838 218,699
530646020 Project Wages 0 0 - 45,091
% CHANGE
Zero Base
Budget
28.31%
- 100.00%
-0
1.61%
0.00%
Total Salary 215,223 193,838 173,608
540046020 Benefits 48,640 45,111 67,272 38.31%
543046020 Vacation Hrs 0 11,183 0 0.00%
547046020 Sick/Bereav 0 2,172 0 0.00%
549046020 Benefits Manulife 0 8,751 18,950 0.00%
Total Benefit 48,640 67,217 86,222 77.27%
550046020 Travel 2,498 2,299 2,498 0.00%
550546020 Travel - Other 0 0 0 0.00%
551046020 Development 4,500 2,921 4,500 0.00%
560046020 Recognition 0 491 500 0.00%
561046020 Memberships 8,062 8,061 8,801 9.17%
562046020 Subscriptions 0 1,022 800 0.00%
563046020 Office Supplies 6,996 5,500 5,996 - 14.29%
564046020 Photocopy 0 3,751 2,000 0.00%
565046020 Advertising 0 903 2,000 0.00%
575046020 Petty Cash Over /Short 0 160 0
585046020 Purchased Services 7,002 3,034 3,700 - 47.16%
588046020 Equipment 3,003 577 3,003 -0.02%
596046020 Project Costs 10,000 11,735 37,700 277.00%
609046020 Miscellaneous 2,002 364 1,002 - 49.95%
682046020 Medical Director 3,600 4,032 4,000 11.10%
685046020 Reimbursed Supplies /CI 14,496 18,397 17,496 20.70%
800046020 Amortization 208,274 208,274 208,274 0.00%
Total Operations 270,433 271,522 302,269 11.77%
Other 0 -149 0 0.00%
TOTAL OPERATING COST 509,800 501,973 543,498 6.61%
15/03/20111:00 PM 66
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodge Admin
0
0
0
N
O
d 0
a
cD
vM
L W LC)
0 0 N
O U
z Q
Oco 0 t:
:a
V 1- N
N
O
U
0
0
0
E
Net Funding Current Year Current Year
0) 0
o�
L() I�
CO
0
0) 0
0 r
N V M
al
Cumulative
Project Budget
0
0) 00 i i
V CO
0
0) 0
V CO
0
0) 0
O I•-•
CI V M
U
N
O
U
O
0
Description
0
U
ice'
C.)
a)
ul
•O J E c
N
^L a)
L i H U
� C
0 J a) W
(6 w
)
N
O 0 C a) O
0 .E > a)
.721
a) as U O
W =HQ ca
O Z O Q
aoa)0
u) u) U)0(0
0 0 0 0 0
� U) U) U) U)
Total Operations Proje
15/03/2011 1:00 PM
a)
rn
0
00
U
a)
O
• d
c
E
a)
rn
0
0
J
a)
U
(6
(pc
Q
a)
rn
0
0
J
a)
U
(6
a)
H
a)
rn
0
0
J
a)
U
(6
a)
al
O
a)
a)
al
a)
E
O
2
C
a)
E
Q
O
a)
a)
0
a)
O)
0
m
a)
U
c
a)
c
ii
cc
O
E
E
O
U
ACCOUNT Description
435047020 Recoveries
Total Revenue
COUNTY OF ELGIN
Terrace Lodge Facility
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
- 8,004 - 10,098 -8,004
- 8,004
- 10,098 -8,004
Total Salary 0 0 0
Total Benefit
% CHANGE
Zero Base
Budget
0.00%
0
0 0 0 0.00%
568047020 Telephone /Fax 18,000 18,099 18,000 0.00%
572047020 Postage /Courier 756 676 756 0.00%
594047020 Utilities 208,710 190,554 190,554 -8.70%
596047020 Project Costs 0 0 0 0.00%
Total Operations 227,466 209,330 209,310 -7.98%
Other
Total
0 0 0 0.00%
219,462 199,232 201,306 -8.27%
15/03/20111:20 PM 68
J: \Common \Finance \Budget Development \Homes Reports \Terrace Lodge \Terrace Lodge Facility
ACCOUNT Description
420030 Province of Ontario
450030 Private
451030 Private - Basic Comp
452030 Semi - Private
453030 Semi - Private - Basic Co
454030 Basic
455030 Respite
456030 Bed Retention
Total Revenue
Total Salary
Total Benefit
COUNTY OF ELGIN
Bobier Revenue
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
- 2,133,190 - 2,146,476 - 2,209,984
- 172,280 - 178,756 - 179,227
- 502,371 - 527,229 - 530,014
- 20,571 - 15,571 - 15,157
- 134,899 - 103,284 - 100,852
- 350,698 - 368,800 - 360,811
- 13,390 - 10,680 - 10,270
-329 -187 0
- 3,327,728 - 3,350,984 - 3,406,315
0 0 0
% CHANGE
Zero Base
Budget
3.60%
4.03%
5.50%
- 26.32%
- 25.24%
2.88%
- 23.30%
- 100.00%
0
0 0 0 0.00%
Total Operations 0 0 0 0.00%
Other 0 0 0 0.00%
TOTAL OPERATING COST - 3,327,728 - 3,350,984 - 3,406,315 2.36%
15/03/20115:49 PM 69
J: \Common \Finance \Budget Development \Homes Reports \Bobier Villa \Bobier Revenue
COUNTY OF ELGIN
Bobier Program Support
Proposed Budget
ACCOUNT Description
435040030 Recoveries
Total Revenue
530040030 Wages
530640030 Project Wages
Total Salary
540040030 Benefits
543040030 Vacation Hrs
545040030 Lieu
547040030 Sick/Bereav
549040030 Benefits Manulife
Total Benefit
550040030 Travel
550540030 Travel - Other
551040030 Development
585040030 Purchased Services
586040030 Supplies
588040030 Equipment
592040030 Repairs /Maintenance
609040030 Miscellaneous
680040030 Program Specific Raw
Total Operations
Other
TOTAL OPERATING COST
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
- 24,996 - 21,714 - 21,168
- 24,996
119,057
0
119,057
43,575
0
0
0
0
43,575
504
0
96
35,837
1,664
504
252
0
F 1,248
40,105
0
177,741
- 21,714 - 21,168
111,963 122,080
0 - 10,822
111,963 111,258
37,344
7,650
2,505
644
2,753
41,743
10,392
4,608
1,323
5,972
50,896 64,039
130
0
8
37,692
320
42
21
0
822
200
0
300
40,837
1,200
0
0
0
800
39,035 43,337
0 0
% CHANGE
Zero Base
Budget
- 15.32%
-0
2.54%
0.00%
180,179 197,466
-4.20%
0.00%
0.00%
0.00%
0.00%
46.96%
- 60.32%
0.00%
212.50%
13.95%
- 27.88%
- 100.00%
- 100.00%
0.00%
- 35.90%
8.06%
0.00%
11.10%
15/03/20115:47 PM 70
J: \Common \Finance \Budget Development \Homes Reports \Bobier Villa \Bobier Program Support
O
z - Q w
W - N
LL E m
O i -0
• o
za °Q
i 0
( a
CO
Ln
0
0
O
co
O
0
O
N
O
0
N
O
0
LO
N
0
0
N
N
0
0
N
O
0
0
0
0
N
O
0
O
0
0
O
N
Current Year Current Year
Net Funding
Cumulative
Project Budget Reserve Name
tI
N
N
co
O
N
co
O
N
N
O
Description
0
0
N
C.)
0)
T
E
_ E co
^L N a)
CL H U
O �W
_ J a3 W
(• 6 a )
}I Q) (1) 0)
a)
2 0 .S Et o
92 t
CD =HQ
O Z • 0 Q
N CO LO
✓ V V
0000
C) M MM
O O O O
LO LO LO LO
N
N
CO
O
N
N
CO
O
N
N
CO
O
N
N
CO
O
N
N
CO
O
Total Operations Pr
0
iri
15/03/2011
a)
rn
0
m
U
a)
0
0
O
Q
Q
CO
E
(6
0)
d
N-03
0
Q
Q
CO
E
Es
0)
0
d
a)
O
m
i
COUNTY OF ELGIN
Bobier Dietary
Proposed Budget
ACCOUNT Description
435041030 Recoveries
Total Revenue
530041030 Wages
530641030 Project Wages
Total Salary
540041030 Benefits
540641030 Project Benefits
543041030 Vacation Hrs
541041030 Vacation Pay
545041030 Lieu
546041030 Top Up
547041030 Sick/Bereave
549041030 Benefits Manulife
Total Benefit
550041030 Travel
550541030 Travel - Other
551041030 Development
585041030 Purchased Services
586041030 Supplies
588041030 Equipment
592041030 Repairs /Maintenance
681041030 Raw Food
Total Operations
Other
TOTAL OPERATING COST
2010
FORECAST/
BUDGET ACTUAL
Total 2011
Zero Based
Budget
- 20,849 - 24,986 - 24,986
- 20,849
328,325
0
328,325
- 24,986 - 24,986
320,772 311,149
0 5,885
320,772 317,034
111,650 98,067 83,768
0 0 2,942
0 12,142 15,676
0 807 12,967
0 10,241 18,687
0 1,402 3,101
0 1,307 3,913
0 8,506 19,606
111,650 132,472 160,661
504 449 504
0 0 0
2,004 1,929 1,004
2,599 2,584 2,599
22,449 18,670 19,949
1,500 0 1,500
2,003 4,617 4,503
175,801 171,722 175,801
206,860 199,970 205,860
0 0 0
% CHANGE
Zero Base
Budget
19.84%
0
- 5.23%
0.00%
625,986 628,229 658,570
- 24.97%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
43.90%
0.00%
0.00%
- 49.90%
0.00%
- 11.14%
0.00%
124.81%
0.00%
- 0.48%
0.00%
5.21%
15/03/20115:05 PM 72
J: \Common \Finance \Budget Development \Homes Reports \Bobier Villa \Bobier Dietary
COUNTY OF ELGIN
O
C)
O
U
N
0
U
0
N
2 13
CD m
CI
L
d
la 0
N N
0 Q U
m o
a
0
N
N
O
N
0
N
N
N
0
U
N
N
O
U
O
O
U
N
O
U
O
U
0
N
O
N
0
N
Current Year Current Year
O
U
N
N
Cumulative
Project Budget Reserve Name
thi
av
0
a) m
z
OIU
- N- 0 (99 LO N
LO O N N
N Ln L()
O (0LLOC
Ln O N N
- N L() L()
O (0LLOC
Ln O N N
- N L() L()
O (0LLOC
Ln O N N
- N L() L()
O - (9LLOC
LO O N N
- LO- Ln
Description
M
CD
M
CD
M
:D
Total Operations Pr
0
0
Ln
15/03/2011
a)
rn
D
m
U
4)
corod
T
(\0
4)
0
m
4)
O
4)
0
m
4)
O
m
N
0
O
Q
a)
a)
4)
E
O
2
C
4)
E
Q
O
4)
0
4)
O)
D
m
4)
U
c
c
c
Li
E
O
E
E
O
U
COUNTY OF ELGIN
Bobier Nursing
Proposed Budget
ACCOUNT Description
435042030 Recoveries - Supplies & Services
435542030 Recoveries - Wages
436042030 Project Revenue
Total Revenue
530142030 Wages (new) - RN
530742030 Project Wages (new) - RN
Wages RN
531542030 Project Wages - RN
530242030
530842030
532042030
532542030
530342030
530942030
533042030
533542030
530442030
531042030
534042030
Total Salary
540142030
540742030
541142030
541542030
543142030
545142030
545742030
546142030
547142030
549142030
540242030
540842030
541242030
542042030
542542030
543242030
545242030
545842030
547242030
549242030
Wages (new) - RPN
Project Wages (new) - RPN
Wages RPN
Project Wages - RPN
Wages (new) - HCA
Project Wages (new) - HCA
Wages HCA
Project Wages - HCA
Wages (new) - DON
Project Wages (new) - DON
Wages DON
Benefits (new) - RN
Project Benefits (new) - RN
Benefits RN
Vacation Pay - RN
Project Benefits - RN
Vacation Hrs - RN
Lieu - RN
Lieu $$
Top Up - RN
Sick /Bereav - RN
Benefits Manulife - RN
Benefits (new) - RPN
Project Benefits (new) - RPN
Vacation Pay - RPN
Benefits RPN
Project Benefits - RPN
Vacation Hrs - RPN
Lieu - RPN
Lieu $$
Sick /Bereav - RPN
Benefits Manulife - RPN
540342030 Benefits (new) - HCA
2010
FORECAST/
BUDGET ACTUAL
-9,996
- 55,626
- 65,023
- 11,636
-1,432
- 129,310
Total 2011
Zero Based
Budget
-9,996
- 41,855
- 104,667
- 130,645 - 142,378 - 156,518
249,245 206,455 388,933
20,893 27,106 13,951
152,573 134,985 0
7,953 13,343 0
163,427 177,194 258,390
39,104 55,612 66,355
102,651 108,048 0
36,373 28,221 0
637,176 659,432 1,056,621
11,924 5,070 -6,068
402,880 404,231 0
2,175 4,531 0
60,884 49,916 55,937
7,188
38,818 37,611 0
1,926,076 1,911,756 1,841,308
90,505 38,267 65,535
4,807 4,119 16,786
52,362 50,828 0
0 3,471 4,792
1,828 3,098 0
0 18,982 22,673
0 8,123 12,104
0 528 543
0 4,810 4,955
0 7,625 21,401
0 10,045 19,399
65,770 52,319 54,813
8,997 9,661 38,859
0 6,590 8,108
35,200 40,500 0
8,367 7,366 0
0 23,490 29,923
0 10,610 17,211
0 3,218 2,212
0 -1,466 11,709
0 9,527 19,218
231,455 158,679 253,534
15/03/20115:38 PM 74
J: \Common \Finance \Budget Development \Homes Reports \Bobier Villa \Bobier Nursing
% CHANGE
Zero Base
Budget
0.00%
- 24.76%
60.97%
0
56.04%
- 33.23%
- 100.00%
- 100.00%
58.11%
69.69%
- 100.00%
- 100.00%
65.83%
- 150.89%
- 100.00%
- 100.00%
- 8.13%
0.00%
- 100.00%
- 4.40%
- 27.59%
249.19%
- 100.00%
0.00%
- 100.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
- 16.66%
331.91%
0.00%
- 100.00%
- 100.00%
0.00%
0.00%
0.00%
0.00%
0.00%
9.54%
COUNTY OF ELGIN
Bobier Nursing
Proposed Budget
ACCOUNT Description
540942030 Project Benefits (new) - HCA
541342030 Vacation Pay - HCA
543042030 Benefits HCA
543342030 Vacation Hrs - HCA
543542030 Project Benefits - HCA
545342030 Lieu - HCA
545942030 Lieu $$
546342030 Top Up - HCA
547342030 Sick /Bereav- HCA
548342030 STD - HCA
549342030 Benefits Manulife- HCA
549542030 Benefits WC - Manulife
540442030
541042030
543442030
544042030
547442030
549442030
Total Benefit
550042030
550542030
551042030
585042030
586042030
588042030
592042030
596042030
609042030
682042030
683042030
689042030
Benefits (new) - DON
Project Benefits (new) - DON
Vacation Hrs - DON
Benefits DON
Sick /Bereav - DON
Benefits Manulife - DON
Travel
Travel - Other
Development
Purchased Services
Supplies
Equipment
Repairs /Maintenance
Project Costs
Miscellaneous
Medical Director
Incontinence
High Intensity Supp /Equipment
Total Operations
Other
TOTAL OPERATING COST
2010
FORECAST/
BUDGET ACTUAL
2,981
0
187,704
0
544
0
0
0
0
0
0
0
1,024
31,121
148,811
53,921
0
33,038
6
0
48,269
0
38,612
0
9,748 10,373
0 8,364
8,171 9,558
0 0
0 3,752
Total 2011
Zero Based
Budget
7,394
53,316
0
76,608
0
49,974
6
0
39,734
0
84,780
0
22,136
3,594
7,395
0
0
6,990
708,439 857,235 955,702
504
0
2,003
15,148
24,747
996
8,001
4,907
0
16,224
22,995
0
808
192
2,618
10,550
28,938
-5,808
0
5,006
69
16,245
21,929
0
1,004
0
2,503
15,148
24,747
3,996
4,000
4,911
0
16,224
22,995
0
95,525
0
80,547 95,529
769
0
% CHANGE
Zero Base
Budget
148.04%
0.00%
- 100.00%
0.00%
- 100.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
127.09%
0.00%
0.00%
- 100.00%
0.00%
0.00%
34.90%
99.27%
0.00%
24.98%
0.00%
0.00%
301.20%
- 50.00%
0.08%
0.00%
0.00%
0.00%
0.00%
0.00%
0.00%
2,599,395 2,707,929 2,736,020
5.26%
15/03/20115:38 PM 75
J: \Common \Finance \Budget Development \Homes Reports \Bobier Villa \Bobier Nursing
O
co
0
U
;o12 Col 29
0
0
N
O
N
0
N
0
N
0
N
N
N
0
0 —
N
N
0
U
0
0
N
O
N
O
U —
N
O
0
O
U
O
N
C
O
E
Current Year
Current Year
Net Funding
Cumulative
Project Budget Reserve Name
OIU
Description
L
0
U
O V
V I 0)
00
CO 01
0) 0)
0
N O)
✓ - O M 0) 0 W N
0) CO LM() CO 0 M CO ON I� CO
CO Mi. NY- 0 • CO LC) Y- N N CO 0
M N M Y- Y- LU N y-
O r
LO 00
M
O -
CO
' N r 0) '
C\I C\IN
LOOMN -LO0) CO
' ' CO V LO 00 CO 00 ' ' ' r
01 V • O • CO LO N- O
NY M NV M LO CO
M V LO CO
M CO ' ' ' I"-
O M • O • CO- LO- LO O
NY M NV M LO CO
M V LO CO
M CO ' ' ' I"-
01 V • O • CO LO N- 0
N V 0 M I� V 0) 0 N- CO N
• 0 V LO W M CO C I 0)) I
CO- CO- - 0 • o LO N N C9 0
• N M s LO N
0) 0) O d-
I� (9 N I� 0)
0I CO CO-
NY N-N-N
V >
a) m >
N m co 0
.2> CI. > > t> ti)- > >m aa) Nm > ,-
1 m,- > m> UP m N m . H '(7) . CO 0
° m > mi 0 0 (6 _cm -,z O N W U i O O
a) N O O)m m> O .-I= C H. > N m N N N (6 1 LT—E 0 _8 H'112- N; i 1 E, 2 . )' En c 0> , a .c z
2 2 0 0 a) u c 0 H 0 � Q La— O .E Et N o .( 0_ a) O
L o N c Q �_ o U N c 3 m Y U a) N, U
CD 1E 0 as _ _ L _ m m rn OC sUZ
LL �cn awC� �i��LLO a) =n ai �UU.�
0 rn a 0 p o a1) a1) a1) m 0 aai a aa)) aa)) H p °_) m 0 'm
2 J J 2 O Z Z Z J Z Z O J 0 Q 2 J J H
ON N N N N N O N N N M ON 0
N N CO CO M M M CO M M N N 0)
0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO
r
4
M
Total Operations Pr
O O
O O
CO- O
U) N-
U) O
CO- O
in
0
0
0
co
CD
0
0
0
co
CD
0
0
0
co
CD
0
0
0
co
CD
0
0
0
co
CD
0
ti
O
N
N
ti
CD
CD
O
N
co
M
O
N
co
M
O
N
co
M
O
M
N
CO
N
0
N
Total Capital Projec
Total Operating and Capital
15/03/2011
COUNTY OF ELGIN
Bobier Housekeeping
Proposed Budget
2010
FORECAST/
ACCOUNT Description BUDGET ACTUAL
Total Revenue
Total 2011
Zero Based
Budget
% CHANGE
Zero Base
Budget
0 0 0 0.00%
530043030 Wages 168,295 164,609 142,920 - 15.08%
530643030 Project Wages - HSK 0 0 1,003 0.00%
530943030 Project Wages 0 0 0 0.00%
Total Salary 168,295 164,609 143,923
540043030 Benefits 71,578 51,546 21,860 - 69.46%
540643030 Project Stat/Combined 0 0 502 0.00%
540943030 Project Stat/Combined 0 135 0 0.00%
541043030 Vacation Pay 0 0 10,790 0.00%
543043030 Vacation Hrs 0 9,855 13,413 0.00%
545043030 Lieu 0 6,369 12,050 0.00%
545943030 Lieu $$ 0 48 49 0.00%
547043030 Sick/Bereav 0 1,379 4,664 0.00%
549043030 Benefits Manulfe 0 4,632 10,048 0.00%
Total Benefit 71,578 73,964 73,377 2.51%
550043030 Travel 0 0 0 0.00%
550543030 Travel - Other 0 0 0 0.00%
551043030 Development 0 180 0 0.00%
585043030 Purchased Services 1,248 1,119 1,248 0.00%
586043030 Supplies 19,003 18,567 19,003 0.00%
588043030 Equipment 2,004 1,216 6,003 199.57%
592043030 Repairs /Maintenance 251 927 251 0.00%
Total Operations 22,506 22,009 26,505 17.77%
Other 0 0 0 0.00%
TOTAL OPERATING COST 262,379 260,582 243,806 -7.08%
15/03/20115:18 PM 77
J: \Common \Finance \Budget Development \Homes Reports \Bobier Villa \Bobier Housekeeping
COUNTY OF ELGIN
L0
0
0
Ln
0
0
O
co
O
0
0)
N
O
0
0
N
0) 0
.a
v
as m
to
0 V N
O toCD U
= O
L
d 0
0
0
O
m
N
N
0
0
N
O
0
O
N
O
0
N
O
0
O
0
O
N
Net Funding Current Year Current Year
0
O
E
a S.
O_
DI RI an v o
Cumulative
Project Budget Reserve Name
Description
L
C
0
0
N M
CO 00
0)
0) CO
CO CO
0)
0) CO
M CO
N CO
CO 00
cn
�I
c.)
0)
(0 T
. � > E O
L m a) aa)
a ' H v
c C w
0> 0)W
Y m a)
w C 0) E
L
O :c o
92 m v 0
�I =HQ
2 c
) 0 a))
OZ0 <
N CO LO
L() LO LO LO
OOOO
co co MM
0) 0) 0) 0)
LO LO LO LO
co
N
M
CO
co
N
M
CO
co
N
M
CO
co
N
M
CO
Total Operations Proje
0
0o
Ln
15/03/2011
a)
rn
0
m
a)
a)
O
0
O)
c
a
a)
a)
a)
a)
Ul
0
O
2
COo
m
c
c
.Q
a)
a)
a)
a)
ul
0
0
2
a`)
O
m
m
a)
O
m
N
O
a)
a)
a)
a)
E
O
2
a)
a)
Q
O
a)
a)
0
a)
O)
0
m
a)
O
c
c
c
ii
E
O
E
E
O
U_
COUNTY OF ELGIN
Bobier Laundry
Proposed Budget
2010
FORECAST/
ACCOUNT Description BUDGET ACTUAL
Total Revenue
Total 2011
Zero Based
Budget
% CHANGE
Zero Base
Budget
0 0 0 0.00%
530044030 Wages 62,286 62,286 57,976 -6.92%
530644030 Project Wages 0 0 125 0.00%
Total Salary 62,286 62,286 58,102
540044030 Benefits
549044030 Benefits Manulife
Total Benefit
20,440 20,440 28,988 41.82%
0 0 0 0.00%
20,440 20,440 28,988 41.82%
551044030 Development 0 0 0 0.00%
585044030 Purchased Services 63,995 66,029 63,995 0.00%
586044030 Supplies 1,999 1,338 1,999 0.00%
588044030 Equipment 504 120 504 0.00%
592044030 Repairs /Maintenance 252 42 252 0.00%
Total Operations 66,750 67,528 66,750 0.00%
Other
TOTAL OPERATING COST
0 0 0 0.00%
149,476 150,254 153,840 2.92%
15/03/20115:25 PM 79
J: \Common \Finance \Budget Development \Homes Reports \Bobier Villa \Bobier Laundry
O
co
O
U
rr
N
0
U
O
N
N
•
O
N
O
N
0
N
N
N
0
U —
0
N
N
O
0
O
N
O
O
U —
N
O
U
O
0
0
N
Current Year Current Year
Net Funding
OIU
a)
al
0
C a)
7 a
EO
0
X E
Cumulative
Project Budget Reserve Name
tI
a a)
z
Description
L
0
U
N
N
C.)
0)
•o
L m a)
L H
a)
I..
c c
O > �p
m
}1 a) C 0)
O .E
ai =HQ
U
0 z 0
N M
LO U) U)
O O O
0) M M
rr 0) 0) in
in in
ILO
N
ILO
N
ILO
N
ILO
N
N
ILO
Total Operating Pro
15/03/2011
a)
rn
D
U
a)
T
0
Oc
co J
a)
O
to
c
C
J
a)
O
m
a)
O
to
N
O
a)
a)
a)
E
O
2
C
a)
E
Q
O
a)
0
a)
O)
0
m
tts
a)
U
c
c
c
ii
cc
O
E
E
O
U_
COUNTY OF ELGIN
Bobier Building
Proposed Budget
2010
FORECAST/
ACCOUNT Description BUDGET ACTUAL
Total Revenue
Total 2011
Zero Based
Budget
% CHANGE
Zero Base
Budget
0 0 0 0.00%
530045030 Wages 41,928 40,476 44,724 6.67%
530645030 Project Wages 0 0 -4,845 0.00%
Total Salary 41,928 40,476 39,879
540045030 Benefits 21,583 9,594 9,604 - 55.50%
543045030 Vacation Hrs 0 2,992 0 0.00%
549045030 Manulife 0 0 3,939 0.00%
Total Benefit 21,583 12,587 13,544 - 37.25%
550045030 Travel 252 147 252 0.00%
550545030 Travel - Other 0 0 0 0.00%
551045030 Development 96 0 96 0.00%
585045030 Purchased Services 76,000 91,364 76,000 0.00%
586045030 Supplies 996 168 996 0.00%
588045030 Equipment 0 159 0 0.00%
592045030 Repairs /Maintenance 17,000 11,815 17,000 0.00%
596045030 Project Costs 99,999 66,962 120,915 20.92%
Total Operations 194,343 170,615 215,259 10.76%
Other
Total
0 0 0 0.00%
257,854 223,678 268,682 4.20%
15/03/20114:59 PM 81
J: \Common \Finance \Budget Development \Homes Reports \Bobier Villa \Bobier Building
M
0
0
L)
0
U
O
0
0
0)
0
U
0
z 0
� U
a)
g
J C
W
m di N
a) y 0
Z QU
o o
O ro
0
U
0
0
O
O
U
O
U
0
N
0
E
Current Year Current Year
m
N
Z
0
fF
0
0
N
d
7
N
d
N
N
of %I-01g .g "I
V
Cumulative
Project Budget Reserve Name
0 O O O O l(7
000 00 CCO
d c CO- LO-
CD O O
O O O
O O O
O O M
O O
O O
O O
M Lf)
CO
OOO 0
000 00 CCO
O O CO- M LO
0 000 00 4
O . . 0 0 0 . 0 0 . CO
cc CO- lc;
0) N— N— N-
0 O O O O O UD
0 0 0 0 0 0 CO
TA L.O. d O CO- M
U
O
Description
r
R
_ L
O
0 0
0
- m m
dN
To > >
�° 'co
o 0
•0 m t a) m a) m
2 I U 0 CO N
A N C C 'V N 0
N N> co E co E N U as
E c m' N 0 c 0 C p 0
N .0
U c O C O O U C '.G
_ (0 (n .O 0 U (B - N w
Lois (e.14 as Ct N> N Et N Et o U 0 N N
L Et o Q o> o � Q c > c
^, o U m o L, m 'co 0
W c N Q . 7 w 7 N C - C
O(0 E U C C U C O O C C U 0
OO N m .N • () m 0 L- O N N N
LL I CO w U_ LL LL LL J w Q
V L0 (0 OO 0) N CO V LO (0 N O
O O O O O O O O O O O O O LO
0 0 0 0 0 0
O O O O O O O O O O O O O O
CO CO CO CO CO CO CO CO CO CO CO CO CO CO
0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0)
L)
I0
I0
CD
I0
I0
I0
I0
Total Operations Proje
15/03/2011 4:59 PM
Current Year
Current Year
Cumulative
Project Budget Reserve Name
0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 O
0 0 0 0 0 0 0 0 0
d Lf)
(O N
O
O
O
Lf)
N
L6 L6 0• 00 0
CO N
0 0
0 0
O O
0 0 0 0
0000_
(O O O O
CO N
O
O
0
0 0 0 0 0 0 0 0 O
0 0 0 0 0 0 0 0 0
d Lf)
(O N
O
O
O
Lf)
N
LO. L co0• 0• 0
CO N
0 0 0 0 0 0 0
0 0 0 0 0 0 0
0 0 0 0 0 0. . 0
L6 L60.d d • o d
CO N N
0 0 0 0 0 0 0 0 O
0 0 0 0 0 0 0 0 LO. L6 LO-
N• I N ,- ,- ,- ,- • CO • N N
O
0
Description
W_
.O
L
a
.co
0
E
o
o a)
m CO CO r aa)
0
0 N N
a) ) a) -O 0_
N
i O - > > a) 0) N
m m (n (n > r=
0) a) O •> i N
7
' a) ° ° • m C E • N a) >•,
L a) N °-
0� • u0 0 � 5 �� � o
0• ° c c � m U cC o m m L c • Ct • 2 m
00 0 7 7 a)) 0 0 0 0 N C a) C • 0 U Q a) f/)
Q ' o m mu) LL U ' > m O J LL ( n J • C O Y= 0
N CO M CO 0) O N- N (h V LO (O N-
O 0) - 0 0 - 0 0 0
0) O O ,- O
0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
010101010101010101010101010-) M
0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0) 0)
LO LO LO LO LO LO LO LO LO LO LO LO LO LO LO
N
Lt
ti
CD
Lp
Lp
O
N
LO
LO
O r
ti
▪ 0
N M
LLO
O r
✓ N
co
✓ M
LLO
O r
▪ N
co
✓ M
Total Capital Projects
15/03/2011 4:59 PM
ACCOUNT Description
435046030 Recoveries
436046030 Project Revenue
COUNTY OF ELGIN
Bobier Admin
Proposed Budget
2010
FORECAST/
BUDGET ACTUAL
-5,699 - 10,318
0 - 67,533
Total 2011
Zero Based
Budget
- 10,629
0
Total Revenue -5,699 - 77,851 - 10,629
530046030 Wages 77,452 70,434 125,438
530646030 Project Wages 0 0 - 12,521
% CHANGE
Zero Base
Budget
86.51%
0.00%
1
61.96%
0.00%
Total Salary 77,452 70,434 112,917
540046030 Benefits 19,303 19,716 17,796 -7.81%
541046030 Vacation Pay 0 2,029 3,123 0.00%
543046030 Vacation Hrs 0 3,876 4,734 0.00%
545046030 Lieu 0 1,682 2,640 0.00%
547046030 Sick/Bereav 0 277 1,153 0.00%
549046030 Benefits Manulife 0 3,071 5,730 0.00%
Total Benefit 19,303 30,650 35,177 82.23%
550046030 Travel 1,500 580 1,500 0.00%
550546030 Travel - Other 0 0 0 0.00%
551046030 Development 3,098 2,854 3,098 0.00%
560046030 Recognition 504 41 504 0.00%
561046030 Memberships 5,460 5,460 5,740 5.13%
562046030 Subscriptions 0 220 200 0.00%
563046030 Office Supplies 9,000 4,393 6,000 - 33.33%
564046030 Photocopy 0 3,189 2,000 0.00%
565046030 Advertising 0 769 800 0.00%
575046030 Petty Cash Over /Short 0 -95 0 0.00%
585046030 Purchased Services 2,000 5,707 2,000 0.00%
588046030 Equipment 3,003 0 3,003 0.00%
591546030 Special - General Store 0 -247 0 0.00%
596046030 Project Costs 0 25,128 0 0.00%
609046030 Miscellaneous 0 31 28,900 0.00%
682046030 Medical Director 495 4 495 0.00%
685046030 Reimbursed Supplies /CI 5,805 11,879 10,000 72.27%
800046030 Amortization 239,489 238,009 239,489 0.00%
Total Operations 270,354 297,921 303,729 12.34%
Other 0 11 0 0.00%
TOTAL OPERATING COST 361,410 321,165 441,194 22.08%
15/03/20113:42 PM 84
J: \Common \Finance \Budget Development \Homes Reports \Bobier Villa \Bobier Admin
COUNTY OF ELGIN
O
O
0
0
0
O
co
0
0
O
N
0
0
N
O
0
N
O
0
N
N
0
0
N
0
0
O
O
0
N
O
0
O
0
0
N
Current Year Current Year
a
a
Cumulative
Project Budget Reserve Name
tI Z m
OI0
Description
0
0
N
V
a)
0
a)
0
co
O
O
O
O
O
O
26401007 Total Operations Projects
0
0
0
O
1)
CD
O
0
CD
O
0
Total Operations Pr
16/03/2011 1:30 PM
a)
rn
0
- O
d
rn
c
c
c
ccs
0
0)
c
c
c
a)
d
E
N
0
H
0
c
a)
0
0
E
O
c
0
0
W_
C
a)
E
Q
O
a)
aa)
0
a)
rn
0
a)
0
c
c
c
ii
cc
O
E
E
O
0
COUNTY OF ELGIN
Bobier Facility
Proposed Budget
Total 2011% CHANGE
2010
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
Total Revenue0000.00%
Total Salary000
Total Benefit0000.00%
568047030Telephone/Fax6,5045,4186,5040.00%
572047030Postage/Courier7552457550.00%
594047030Utilities161,000157,316157,316-2.29%
596047030Project Costs0000.00%
684047030Cable9968889960.00%
Total Operations169,255163,868165,571-2.18%
0.00%
Other000
Total169,255163,868165,571-2.18%
86
15/03/20115:07 PM
J:\Common\Finance\Budget Development\Homes Reports\Bobier Villa\Bobier Facility
2011 Operating Budget
RevenueExpenseNet Budget
(Revenue)/
Ex p ense
Museums & Archives
Museum 25,364 210,138 184,774
Archives 18,900 202,369 183,469
19 Museum & Archives
)
44,264 412,507 368,243
87
J:\Finance\2011 Budget PDF\SummaryTempOperating Budget 16/03/2011 4:27 PM
COUNTY OF ELGIN
Museum
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
4200240Province of Ontario-15,000-15,638-15,0000.00%
4215240Federal Funding - Proje -4,081 0-4,364 6.93%
c
4300240Grants -4,000 0-4,000 0.00%
4360240Project Revenue -4,050-8,085-2,000-50.62%
4370240Other Revenue 0370 0 0.00%
4375240Other Revenue - Gift Sh 0-1,778 0 0.00%
o
4380240Membership Revenue 0 0 0 0.00%
4390240Admissions 0-1,464 0 0.00%
Total Revenue -27131-26593.89-25364-6.51%
5300240Wages 104,949104,792106,000 1.00%
5306240Project Wages 0 08,044 0.00%
5310240Vacation 0263 0 0.00%
5330240Vacation Hrs 04,990 0 0.00%
5360240Subsidized Wages 0 0 0 0.00%
5315240Project Wages (Old) 6,126 0 0-100.00%
Total Salary 111,075110,045114,044
5400240Benefits 25,18722,02325,907 2.86%
5406240Project Benefits 0 0668 0.00%
5460240Subsidized Benefits 0 0 0 0.00%
5415240Project Benefits (Old) 675 0 0-100.00%
5490240Benefits - Manulife 04,896 0 0.00%
Total Benefit 25,86226,91826,575 2.76%
5500240Travel 1,9983231,998 0.00%
5505240Travel - Other 0 0 0 0.00%
5510240Development 1,5004021,500 0.00%
5610240Memberships 30,50130,37730,501 0.00%
5620240Publications 500 0500 0.00%
5630240Office Supplies 5041,277504 0.00%
5640240Photocopy 500224500 0.00%
5650240Advertising 3,5023,2143,502 0.00%
5740240Curatorial 20,00227,46620,002 0.00%
5880240Equipment 3,0003993,000 0.00%
5910240Special - Events 2,0049522,004 0.00%
5915240Special - Gift Shop 0692 0 0.00%
16/03/201111:28 AM
88
J:\Common\Finance\Budget Development\Cultural Services\Museum
COUNTY OF ELGIN
Museum
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
5920240Repairs/Maintenance 504 0504 0.00%
5940240Utilities 0 0 0 0.00%
5960240Project Costs 700-175 0-100.00%
6090240Miscellaneous 504 50504 0.00%
6500240Shipping 1,5001,6191,500 0.00%
6660240Website Maintenance 0 0 0 0.00%
6700240Acquisitions 3,0002313,000 0.00%
Total Operations 70,21967,05169,519-1.00%
Other 0 0 0 0.00%
TOTAL OPERATING COS 180,025177,420184,774 2.64%
T
16/03/201111:28 AM
89
J:\Common\Finance\Budget Development\Cultural Services\Museum
COUNTY OF ELGIN
Archives
Proposed Budget
Total 2011% CHANGE
2010
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescription BUDGET
c -4,081-2,535-5,90044.57%
4215185Federal Funding - Proje
4300185Grants0000.00%
4360185Project Revenue0-9,730-10,0000.00%
4370185Other Revenue-3,000-1,901-3,0000.00%
Total Revenue-7081-14165.49-18900166.91%
5300185Wages108,134100,548109,2010.99%
5306185Project Wages 208,98610,6870.00%
5310185Vacation Pay01100.00%
5315185Project Wages6,12600-100.00%
5316185Vacation Pay Project049500.00%
5330185Vacation Hours06,92300.00%
Total Salary114,260116,963119,888
5400185Benefits25,95019,14226,4681.99%
5406185Stat/Combined064200.00%
5415185Project Benefits67501,457115.91%
5490185Benefits - Manulife03,59400.00%
Total Benefit26,62523,37927,9254.88%
5500185Travel3,0007833,0000.00%
5505185Travel - Other0000.00%
5510185Development3,0001,6483,0000.00%
5610185Memberships997259970.00%
5620185Publications9974879970.00%
5630185Office Supplies503595030.00%
5640185Photocopy3001043000.00%
5850185Purchased Services99709970.00%
5860185Supplies - Archival7,5008,6187,5000.00%
5870185Furniture & Fixtures01,13600.00%
5880185Equipment4,5004024,5000.00%
5910185Promotions2,0021,7322,0020.00%
5920185Repairs/Maintenance5035155030.00%
5960185Project Costs06,0005,0000.00%
6090185Miscellaneous5042195040.00%
6640185Microfilming/Scanning/ C 21,00319,81821,0030.00%
6660185Website Maintenance50005000.00%
6700185Acquisitions3,2503,9853,2500.00%
Total Operations49,55645,53154,55610.09%
Other01680 0.00%
TOTAL OPERATING COS 183,360171,875183,4690.06%
T
16/03/201111:00 AM
91
J:\Common\Finance\Budget Development\Cultural Services\Archives
COUNTY OF ELGIN
Library Services
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
4200180Province of Ontario-116,739-116,739-116,7390.00%
4205180Province of Ontario - Pr -70,791-37,801 0-100.00%
o
4215180Federal Funding - Proje -55,281-35,258-43,150-21.94%
c
4300180Grants0-4,28900.00%
4360180Project Revenue-77,031-70,926-82,4507.03%
4370180Other Revenue-21,996-31,969-34,99659.10%
Total Revenue -341838-296981.54-277335-18.87%
5300180Wages 1,254,8081,122,3471,320,333 5.22%
5306180Project Wages2 040,70222,299 0.00%
5310180Vacation 031,140 0 0.00%
5315180Project Wages 72,11431,629 0-100.00%
5316180Vacation Pay 01,798 0 0.00%
5330180Vacation Hrs 045,770 0 0.00%
5360180Wages Subsidized 0 0 0 0.00%
5370180Bereavement 09,580 0 0.00%
Total Salary 1,326,9221,282,9661,342,632
5400180Benefits 338,796246,146311,479-8.06%
5406180Stat/Combined 03,471 0 0.00%
5415180Project Benefits 8,8732,09113,85156.10%
5450180Lieu 026,787 0 0.00%
5460180Benefits Subsidized 0 0 0 0.00%
5490180Benefits - Manulife 034,525 0 0.00%
Total Benefit 347,669313,021325,329-6.43%
5500180Travel 12,00013,71510,000-16.67%
5505180Travel - Other 09454,000 0.00%
5510180Development 14,4965,48114,496 0.00%
5610180Memberships 2,0041,4852,004 0.00%
5630180Office Supplies 15,00019,22715,000 0.00%
5640180Photocopy 6,9966,9876,996 0.00%
5650180Advertising 9961,196996 0.00%
5680180Telephone/Fax 20,00419,84320,004 0.00%
5760180Meals/Refreshments 2,2801,8022,280 0.00%
5870180Furniture & Fixtures 6,9967,9466,996 0.00%
5880180Equipment 01,668 0 0.00%
5890180Lease Space 324,327318,200334,536 3.15%
16/03/20116:08 PM
93
J:\Common\Finance\Budget Development\Cultural Services\Library Services
COUNTY OF ELGIN
Library Services
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
5920180Repairs/Maintenance 504345504 0.00%
5930180Vehicle Repairs/Maint/F 6,0007,9418,00033.33%
u
5960180Project Costs212,517175,71837,175-82.51%
6090180Miscellaneous2,0044,2282,0040.00%
6630180Periodicals/Newspapers010,88313,4710.00%
6670180Electronic Resources21,50018,32022,1503.02%
6680180Programs9,99615,8699,9960.00%
8000180Amortization441,694466,338441,6940.00%
Total Operations1,099,3141,098,137952,302-13.37%
Other0-40 0.00%
TOTAL OPERATING COS 2,432,0672,397,1382,342,928-3.67%
T
16/03/20116:08 PM
94
J:\Common\Finance\Budget Development\Cultural Services\Library Services
COUNTY OF ELGIN
Information Technology
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
4350150Recoveries0-19100.00%
Total Revenue 0-190.5 0 0.00%
5300150Wages 204,631190,847222,028 8.50%
5330150Vacation Hrs 010,538 0 0.00%
Total Salary 204,631201,386222,028
5400150Benefits 54,02139,37631,916-40.92%
5490150Benefits - Manulife 010,08619,071 0.00%
5370150Sick/Bereavement 01,272 0 0.00%
Total Benefit 54,02150,73550,988-5.61%
5500150Travel 6,7002,8236,700 0.00%
5505150Travel - Other 0 0 0 0.00%
5510150Development 9,0006,5919,000 0.00%
5620150Subscriptions 1,0001051,000 0.00%
5790150Consultant 40,00030,29840,000 0.00%
5860150Supplies 3,6001,5283,375-6.25%
6110150Hardware 0 0 0 0.00%
6120150Support/Maintenance220,925197,194221,197 0.12%
6130150Licenses 69,04695,51569,000-0.07%
8000150Depreciation 105,584103,941105,584 0.00%
Total Operations 455,855437,995455,856 0.00%
Other 0 0 0 0.00%
TOTAL OPERATING COS 714,507689,925728,872 2.01%
T
16/03/201111:52 AM
96
J:\Common\Finance\Budget Development\Information Technology\Information Technology
COUNTY OF ELGIN
POA
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
4300135Grants-80,000-11,029-80,0000.00%
4340135Fines Revenue-1,075,000-1,525,710-1,265,00017.67%
4370135Other Revenue0-69,00000.00%
Total Revenue-1155000-1605738.85-134500016.45%
5300135Wages179,048166,551236,55732.12%
5310135Vacation Pay020900.00%
5330135Vacation Hrs09,48600.00%
5370135Sick01,95900.00%
Total Salary179,048178,205236,557
5400135Benefits44,16534,70235,837-18.86%
5490135Benefits - Manulife08,25120,6330.00%
Total Benefit44,16542,95356,47027.86%
5500135Travel4999614990.00%
5505135Travel - Other0000.00%
5510135Development1,5001,6391,5000.00%
5610135Memberships2002002000.00%
5630135Office Supplies18,0008,66318,0000.00%
5680135Telephone/Fax9971,9599970.00%
5770135Legal & Professional115,000166,898155,00034.78%
5830135Bank Charges13,50015,97213,5000.00%
5850135Purchased Services17,42723,70331,42780.34%
5870135Furniture & Fixtures0000.00%
5880135Equipment1,0005,2161,000-0.03%
5970135Municipal Partner Paym 425,404718,205454,393 6.81%
e
5971135Victim Fine Surcharge a 211,546322,393253,00019.60%
n
6090135Miscellaneous5,5005,0805,5000.00%
6120135Support-ICON & Mailing32,00127,93232,0010.00%
6860135Building Occupancy34,38534,38534,3850.00%
Total Operations876,9591,333,2051,001,40114.19%
Other000 0.00%
TOTAL OPERATING COS -54,828-51,376-50,571-7.76%
T
16/03/201111:37 AM
98
J:\Common\Finance\Budget Development\POA\POA
COUNTY OF ELGIN
Collections
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
4340145Revenue-259,998-317,869-259,9980.00%
4350145Recoveries-75,000-85,232-75,0000.00%
Total Revenue -334998-403101.2-334998 0.00%
5300145 0 0 0 0.00%
Total Salary 0 0 0
5400145 0 0 0 0.00%
Total Benefit 0 0 0 0.00%
5500145Travel 1,000 281,000 0.00%
5505145Travel - Other 0 0 0 0.00%
5510145Development 8001,108800 0.00%
5630145Office Supplies 48 8 45-6.25%
5850145Purchased Services150,519133,667150,517 0.00%
5970145Municipal Partner Paym 167,400254,392167,400 0.00%
e
Total Operations 319,767389,202319,762 0.00%
Other 0 0 0 0.00%
TOTAL OPERATING COS -15,231-13,899-15,236 0.03%
T
16/03/201111:34 AM
99
J:\Common\Finance\Budget Development\POA\Collections
2011 Operating Budget
RevenueExpenseNet Budget
(Revenue)/
Ex p ense
Ambulance & Emer enc Measures
g y
Ambulance Services 8,073,619 5,693,029 2,380,590
Emergency Measures3,750 29,494 25,744
24 Ambul. & Emer enc Meas.
) g y
5,696,779 8,103,113 2,406,334
100
J:\Finance\2011 Budget PDF\SummaryTempOperating Budget 16/03/2011 4:28 PM
COUNTY OF ELGIN
Ambulance
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
4200270Province of Ontario-3,879,319-3,889,981-4,046,8084.32%
4360270Project Revenue0-80,49900.00%
4310270City of St. Thomas - Am -1,698,651-1,565,606-1,646,222-3.09%
b
Total Revenue -5,577,970-5,536,086-5,693,029 2.06%
5300270Wages 29,19225,62329,190-0.01%
5330270Vacation Hrs 02,389 0 0.00%
Total Salary 29,19228,01129,190
5400270Benefits 7,2964,2687,298 0.03%
Total Benefit7,2964,2687,2980.03%
5500270Travel5040500-0.79%
5505270Travel - Other0000.00%
5510270Development9961,1581,0000.40%
5610270Memberships50460060019.05%
5630270Office Supplies50400-100.00%
5680270Telephone/Fax0000.00%
5850270Purchased Serv. - Contr 7,628,0377,636,3347,884,528 3.36%
a
5920270Repairs/ Maintenance 0 0 0 0.00%
5960270Project Costs 0 060,000 0.00%
6090270Miscellaneous 504-11504 0.00%
8000270Amortization 52,98889,60390,00069.85%
Total Operations 7,684,0377,727,6848,037,132 4.60%
Other 0 0 0 0.00%
Total 2,142,5552,223,8772,380,59011.11%
16/03/20119:06 AM
101
J:\Common\Finance\Budget Development\Engineering Reports\Ambulance
COUNTY OF ELGIN
Emergency Measures
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
4370210Other Revenue-3,750-1,751-3,7500.00%
Total Revenue -3750-1750.8-3750 0.00%
5300210Wages 15,39911,24516,192 5.15%
Total Salary 15,39911,24516,192
5400210Benefits 3,7731,9742,543-32.59%
Total Benefit 3,7731,9742,543-32.59%
5500210Travel 504 0504 0.00%
5505210Travel - Other 0 0 0 0.00%
5510210Development 9961,241996 0.00%
5630210Office Supplies 252454252 0.00%
5650210Advertising 504237500-0.79%
5850210Purchased Services 4,5001,8035,00011.11%
5860210Supplies 9969591,002 0.60%
5870210Furniture & Fixtures 252 0 0-100.00%
5920210Repairs & Maintenance2,0001,7272,000 0.00%
6090210Miscellaneous 504437504 0.00%
Total Operations 10,5086,85810,758 2.38%
Other 0 61 0 0.00%
Total 25,93018,38725,744-0.72%
16/03/201110:14 AM
103
J:\Common\Finance\Budget Development\Engineering Reports\Emergency Measures
2011 Operating Budget
RevenueExpenseNet Budget
(Revenue)/
Ex p ense
Economic Development, Tourism & Plannin
g
Economic Development 32,788 692,836 660,049
Tourism 156,397 317,388 160,991
Planning - 267,496 267,496
25 Econ.Dev'l, Tourism & Plan.
)
189,184 1,277,720 1,088,536
104
J:\Finance\2011 Budget PDF\SummaryTempOperating Budget 16/03/2011 4:29 PM
COUNTY OF ELGIN
Economic Development
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
4215280Federal Funding - Proje -168,092-168,092 0-100.00%
c
4300280Grants 0 0 0 0.00%
4360280Project Revenue -45,500-28,991-32,788 -27.94%
4370280Other Revenue - Logo It 0-203 0 0.00%
e
Total Revenue -213592-197286.46-32787.5 -84.65%
5300280Wages 151,019173,836261,893 73.42%
5306280Project Wages2 016,8003,569 0.00%
5315280Project Wages 63,81025,300 0-100.00%
5316280Vaction Pay 0584 0 0.00%
5330280Vacation Hrs 07,402 0 0.00%
5370280Sick/Bereav 0 0 0 0.00%
Total Salary 214,829223,922265,462
5400280Benefits 44,92032,10362,722 39.63%
5406280Project Benefits 2 01,355535 0.00%
5415280Project Benefits 6,8513,021 0-100.00%
5490280Benefits - Manulife 0 0 0 0.00%
Total Benefit 51,77136,48063,258 22.19%
5500280Travel 11,00011,1754,500 -59.09%
5505280Travel - Other 04,39510,000 0.00%
5510280Development 3,0001,5813,000 0.00%
5610280Memberships 20,00017,72948,500142.50%
5620280Subscriptions 300252300 0.00%
5630280Office Supplies 2,0043,6543,504 74.85%
5650280Advertising/Promotion75,00073,24777,000 2.67%
5660280Printing 23,00219,14320,000 -13.05%
5680280Telephone/Fax 1,2002,7612,800133.33%
5720280Postage/Courier 250 35250 0.00%
5850280Purchased Services119,000108,602126,500 6.30%
5910280Special Projects/Events42,60041,32045,900 7.75%
5960280Misc Project Costs481,893326,98720,363 -95.77%
6090280Miscellaneous 1,2962,3521,500 15.74%
Total Operations 780,545613,232364,117 -53.35%
Other 0-109 0 0.00%
Total 833,553676,238660,049 -20.82%
16/03/20111:20 PM
105
J:\Common\Finance\Budget Development\Economic Dev and Tourism\Economic Development
COUNTY OF ELGIN
Tourism
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Cost Attack
ACTUAL Budget Implement
ACCOUNTDescriptionBUDGET
4205285Provincial Funding - Pro 0 0-5,7000.00%
j
-10,000-11,647-6,00040.00%
4215285Federal Funding - Proje c
4300285Grants0000.00%
-88,860-88,860-107,328-20.78%
4310285City of St. Thomas - To u
4340285Fees - Partnerships0000.00%
4360285Project Revenue-71,086-71,144-27,36961.50%
4380285Revenue Memberships-8,000-9,232-10,000-25.00%
Total Revenue-177946-180883.02-156396.50912.11%
5300285Wages63,65656,85568,398-7.45%
5306285Project Wages (new)016,34123,8780.00%
5310285Vacation Pay028200.00%
5315285Project Wages21,45911,2700100.00%
5316285Project Vacation Pay065400.00%
5330285Vacation Hrs02,32000.00%
5370285Sick/Bereav0000.00%
Total Salary85,11587,72192,276
5400285Benefits16,11813,17816,910-4.92%
5406285Project Benefits (new)01,2771,9660.00%
5415285Project Benefits3,5461,7570100.00%
5460285Lieu08,85800.00%
5490285Manulife0000.00%
Total Benefit19,66425,07118,8764.01%
5500285Travel4,8004,5099,800-104.17%
5505285Travel - Other02033,0000.00%
5510285Development2,5005742,5000.00%
5610285Memberships2,8002,7292,8000.00%
5620285Subscriptons100681000.00%
5630285Office Supplies6966851,200-72.41%
5640285Printing/Communication s 17,0005,8506,50061.76%
5650285Advertising/Promotion70,00072,40453,03124.24%
5660285Printing0000.00%
5680285Telephone/Fax2,7003,3672,7000.00%
5720285Postage/Courier1,4044050064.39%
5850285Purchased Services14,68520,0893,40076.85%
5910285Special Projects & Even9,0008,1589,0000.00%
5960285Project Costs 77,89977,879107,705-38.26%
6090285Miscellaneous 3,9963,0154,000-0.10%
0 0 00.00%
1 V e h i c l e M a i n t e n a n c e
Total Operations 207,580199,568206,2360.65%
0.00%
Other 0 0 0
Total 134,413131,476160,991-19.77%
107
16/03/20116:15 PM
J:\Common\Finance\Budget Development\Economic Dev and Tourism\Tourism
COUNTY OF ELGIN
Planning
Proposed Budget
2010 Total 2011% CHANGE
FORECAST/ Zero Based Zero Base
ACTUAL Budget Budget
ACCOUNTDescriptionBUDGET
5300290Wages89,88166,173102,38013.91%
Total Salary89,88166,173102,380
5400290Benefits12,3894,6585,037-59.34%
5490290Benefits - Manulife035830.00%
Total Benefit12,3894,6935,120-58.67%
5500290Travel3,0001,3042,000-33.33%
5505290Travel - Other0000.00%
5510290Development002,0000.00%
5610290Memberships99600-100.00%
5630290Office Supplies9,9964844,996-50.02%
5870290Furniture & Fixtures04,75200.00%
5960290Project Costs150,00086,887150,0000.00%
6090290Miscellaneous01,1161,0000.00%
Total Operations163,99294,542159,996-2.44%
Other000 0.00%
TOTAL OPERATING COS 266,262165,408267,496 0.46%
T
16/03/20111:30 PM
109
J:\Common\Finance\Budget Development\Economic Dev and Tourism\Planning