Mayor's Office Budget - Jan-Jul 2012

Download as pdf or txt
Download as pdf or txt
You are on page 1of 4

City of Calgary

ESS Financials - Operating Budget Executive Summary


(Operating Fund)
For the Period Ended: 2012-07-31
(In Dollars)

90001 (Mayor)

Budget

Year to Date
Actual

Variance $

0
0
0

0
-3,894
-50,353

0
3,894
50,353

0
0
0

-54,247
-54,247
-54,247

54,247
54,247
54,247

-54,247

54,247

2,218
0
124,238
0

2,307
1,269
128,544
0

-89
-1,269
-4,306
0

126,456
126,456

132,120
132,120

-5,664
-5,664

215,677
71,546
404,458

216,161
72,436
415,728

-484
-890
-11,270

691,681

704,325

-12,644

0
0
1,044
1,044

0
0
0
0

0
0
1,044
1,044

2,088
693,769

0
704,325

2,088
-10,556

1,566

1,566

1,566

1,566

2012 Year
Budget

Prior YTD
Actual

Prior Year
Actual

Account

Description

15210

Misc Rev - Contribution

-1,500

Miscellaneous Revenue

-1,500

93667
94615
97150

Revenue

-1,500

Recoveries-Other Intrnl Serv


Recoveries-Insurance Claims
Recoveries-Salary Redistrib-n

0
0
0

0
0
0

0
0
-44,564

General Recoveries
General Recoveries
Total Recoveries

0
0
0

0
0
0

-44,564
-44,564
-44,564

Internal Recoveries
28100
28405
29900
29901

Canada Pension Plan Exp.


Enhanced Benefits-Other
Fringe Benefits - Intrnl
Fringe Benefit - Intrnl Offset

Fringe Benefits
Total Fringe Benefits

-44,564

2,218
0
213,327
0

2,218
0
98,196
0

2,218
0
180,345
0

215,545
215,545

100,413
100,413

182,563
182,563

370,062
122,851
694,494

162,611
60,150
309,421

284,121
110,612
569,537

964,270

20000
20600
24500

Sal - Legislative Sal


Sal - Mgmt Exempt
Sal - Other

1,187,407

532,182

24510

Wages - Other

22,947

39,904

Wages

22,947

39,904

0
0
1,044
1,044

0
2,693
7,448
6,076

0
2,693
7,448
6,076

2,088
1,189,495

16,218
571,347

16,218
1,020,392

Salaries

24590
24805
24810
27100

Temporary Emp. - Other


Intrl-TESA Wages OH
Wages - TESA Wages
Agency Personnel

Temporary
Salary & Wages
27400

Awards - SIP/Emp. Suggestions

Miscellaneous S&W

Page 1 of 4

2,087

2,087

City of Calgary

ESS Financials - Operating Budget Executive Summary


(Operating Fund)
For the Period Ended: 2012-07-31
(In Dollars)

90001 (Mayor)

Budget

Year to Date
Actual

Variance $

0
0

0
0

0
0

0
0

2,892
0

-2,892
0

0
821,791

2,892
839,337

-2,892
-17,546

0
821,791

0
839,337

0
-17,546

0
20,684
1,124

0
23,508
999

0
-2,824
125

21,808
21,808

24,507
24,507

-2,699
-2,699

3,409

2,954

455

3,409

2,954

455

11,669
0
1,500
725
0
19,863
6,419
5,705
700
0
1,000
5,000
0

15,401
0
1,055
141
0
20,112
10,992
894
647
0
0
4,654
0

-3,732
0
445
584
0
-249
-4,573
4,811
53
0
1,000
347
0

2012 Year
Budget

Prior YTD
Actual

Prior Year
Actual

Account

Description

20670
24570

S & A Credits - Mgmt Exempt


S & A Credits - Other

0
0

-2,867
0

-2,867
0

Sickness & Accident

-2,867

-2,867

20666
24812

Vacation Payout
Stat Holiday Pay

0
0

0
0

0
0

0
1,407,127

0
668,893

0
1,200,088

Salary Payout
Salary, Wages & Ben excl OT
24530

Wages O.T. - Other

Salary & Wages Overtime


Salary, Wages & Benefits Total
36650
41000
69175

HR & Admin Fees - Internal


Info Serv - Intrnl InfrastO/H
Alloc Inventory Mgmt-Intrnl

Internal Expenditures
Intrnl Exp offset by Recovery
77500
30992
30993
30996
30997
30998
39995
59993
62770
70810
73002
77420
77520
77530

0
1,407,127

0
668,893

0
1,200,088

0
25,172
1,124

0
13,419
999

1,963
23,587
999

26,296
26,296

14,418
14,418

26,548
26,548

Car & Parking Allowances

5,844

2,963

4,844

Employee Allowances

5,844

2,963

4,844

Meeting Supplies/Refresh-t(1)
Meeting Supplies/Refresh-t(2)
Employee Recognition /Banquet
Parking - Not CPA
Parking - CPA
Parking - intrl - Corp Pkg Str
Program Expenses
Business Hosting (Ext only)
Service Fees
Honorarium
Other Exp-Contingency
Membership Fees & Dues
Employee Relocation Exp

20,000
0
2,500
1,225
0
33,909
11,000
9,777
1,200
0
1,500
5,000
0

8,466
481
0
49
0
19,922
0
2,873
468
0
8,553
0
4,549

29,434
0
306
50
3
34,573
0
5,038
1,208
500
10,429
125
4,549

Page 2 of 4

City of Calgary

ESS Financials - Operating Budget Executive Summary


(Operating Fund)
For the Period Ended: 2012-07-31
(In Dollars)

90001 (Mayor)

Budget

Year to Date
Actual

Variance $

11,051
0
3,400

4,959
0
3,095

6,092
0
305

70,441

64,904

5,537

0
2,226
5,162
1,550
0
19,169
1,379
0
2,429
0
4,669

8
92
5,096
530
845
995
71
36
2,120
216
1,800

-8
2,134
66
1,020
-845
18,174
1,308
-36
309
-216
2,869

36,584

11,809

24,775

0
0
0
0

0
0
1,000
0

0
0
-1,000
0

1,000

-1,000

0
0
3,484

0
0
3,666

0
0
-182

3,484
132,317

3,666
105,886

-182
26,431

9,793
2,100

4,444
765

5,349
1,335

Account

Description

77540
77550
77660

Business Travel
Training/Staff Dev (1)
Conferences

31050
31300
32540
32590
32700
32800
33000
33050
33070
33600
62810

Postage/Courier/Freight
Postage/Courier/Freight-Intrnl
Wireless Comm - Rental/Airtime
Telecommunications - Intrnl
Communications
Communications - Intrnl
Printing
Reproduction/Printing - Intrnl
Photocopier Services - Intrnl
Advertising & Promotion
Comm-Sponsorship of Indiv/Orgs

36699
36890
37575
39950

Prof Fees - Other


Intrnl Contract-GIS/Mapping
Intrnl Contract-Train/StaffDev
Contract - Other (1)

36700

Consultants

Prior Year
Actual

17,347
237
0

22,263
237
2,993

140,175

65,907

116,552

0
3,821
8,990
2,800
0
50,000
2,360
0
4,158
0
8,000

65
139
5,259
863
217
15,198
51
564
2,585
0
0

132
205
9,378
1,135
2,731
22,660
51
1,168
3,841
200
95

80,129

24,940

41,597

0
0
0
0

0
209
0
0

0
209
0
0

Contracted Service Providers

209

209

Consultants - Other

159

829

159

829

0
0
3,484

63
0
3,666

63
0
3,666

3,484
250,084

3,729
109,362

3,729
189,464

16,787
3,597

2,868
1,085

5,268
1,501

Communication Services

Security General Internal


Ins Premiums - One-Time
Ins Premiums - Intrnl

Insurance and Security


Contract & General Services
52000
52050

Prior YTD
Actual

37,512
0
10,708

Business Expenses

45110
45501
45550

2012 Year
Budget

Supplies - Office
Subscriptions & Publications

Page 3 of 4

City of Calgary

ESS Financials - Operating Budget Executive Summary


(Operating Fund)
For the Period Ended: 2012-07-31
(In Dollars)

90001 (Mayor)

Budget

Year to Date
Actual

Variance $

0
0
1,540
0
0
0

100
89
227
0
74
0

-100
-89
1,313
0
-74
0

13,433

5,698

7,735

2,002

780

1,222

2,002

780

1,222

0
3,500
0
2,100

0
3,045
0
3,686

0
455
0
-1,586

5,600

6,731

-1,131

0
700
0

510
625
0

-510
75
0

700
21,735
975,843

1,135
14,344
959,567

-435
7,391
16,276

975,843
975,843

959,567
905,320

16,276
70,523

2012 Year
Budget

Prior YTD
Actual

Prior Year
Actual

Account

Description

52990
53000
53150
53250
53300
53910

Supplies - Misc
Small Tools/Equipment
Equipment - Computer Hardware
Equipment - Computer Software
Equipment - Electronic
Office Furniture/Equipment

0
529
2,645
526
0
0

0
0
0
75
366
0

138
0
2,073
75
786
0

Materials and Commodities

24,084

4,393

9,840

60020

Fuel Purchase - Other

3,432

624

1,438

3,432

624

1,438

0
6,000
0
3,597

0
3,065
0
820

0
5,275
0
6,319

9,597

3,885

11,594

0
1,270
0

0
0
0

0
1,058
0

Maintenance/Rental Equipment
Materials,Equipment&Supplies
Expenditures Excl Debt & Depn

1,270
38,383
1,695,594

0
8,903
787,158

1,058
23,930
1,413,482

Expenditures
Income Statement Accounts

1,695,594
1,695,594

787,158
787,158

1,413,482
1,367,418

Fuel and Oil


40200
40310
40400
40410

V&E- HITS (Hired Trucks)


V&E-Leases - Intrnl
V&E-Maint
V&E-Maint - Intrnl

42030
42380
42390

BldgMntc - Offc Move- Intrnl


Maint - Info Systems -Software
Maint - Info Systems -Hardware

Vehicle & Equipment Charges

Page 4 of 4

You might also like