Office of the Chief Financial Officer - City Of Windsor

[Pages:2]Office of the Chief Financial Officer

Table of Contents

Finance

A. Overview..........................................................................................................................................................................................................1.............. B. Budgeted Full Time Equivalents ........................................................................................................................................................................ 2 C. Budget Summary by Division..............................................................................................................................................................................5...... D. Budget Summary by Major Revenue / Expense ......................................................................................................................................................6......................................................... E. Budget Issue Summary.................................................................................................................................................................................... 8

Information Technology

A. Overview...........................................................................................................................................................................................................9 ................. B. Budgeted Full Time Equivalents ........................................................................................................................................................................ 11 C. Budget Summary by Division..............................................................................................................................................................................1...3... D. Budget Summary by Major Revenue / Expense .......................................................................................................................................................1...4 ............ E. Budget Issue Summary.................................................................................................................................................................................... 16

Office of the Chief Financial Officer - Finance

A. Departmental Overview

Mission

To provide timely, responsive, efficient and innovative financial services to all our customers in compliance with all legislative requirements, while fostering a spirit of trust through accountability.

Description

The Finance department provides financial services to its internal and external customers through the Asset Planning, Financial Accounting & Corporate Controls, Financial Planning and Taxation, Treasury & Financial Projects divisions. The Asset Planning division provides asset planning, capital budget development and monitoring, corporate energy management services and capital grant funding programs to the organization. The Financial Accounting & Corporate Controls division provides accounts payable, accounts receivable, accounting and payroll services to the organization. The Financial Planning division provides operating budget development and monitoring services along with performance measurement and overall financial planning leadership for the Corporation and Council. The Taxation,Treasury & Financial Projects division provides property billing and tax collection services, cash management and leadership on corporate financial projects.

2020 Approved Budgeted Full Time Equivalents (FTE's)

Office of the Chief Financial Officer

Finance

Snr. Management: 1.0 FTE Management: 19.0 FTE Non-Union: 44.0 FTE Local 543: 30.0 FTE Total: 94.0 FTE

Administration Finance Snr. Management: 1.0 FTE

Non-Union: 2.0 FTE Total: 3.0 FTE

Asset Planning Management: 5.0 FTE Non-Union: 6.0 FTE

Total: 11.0 FTE

Financial Accounting and Corporate Controls Management: 5.0 FTE Non-Union: 7.0 FTE Local 543: 14.0 FTE Total: 26.0 FTE

Financial Planning Management: 5.0 FTE Non-Union: 23.0 FTE

Local 543: 3.0 FTE Total: 31.0 FTE

Taxation, Treasury & Financial Projects

Management: 4.0 FTE Non-Union: 6.0 FTE Local 543: 13.0 FTE

Total: 23.0 FTE

1

B. Budgeted Full Time Equivalent (FTE's)

Division

Position Description

Position Profile

Administration Finance Asset Planning

Financial Accounting and Corporate Controls

Chief Finanacial Officer/City Treasurer Executive Initiative Coordinator Executive Administrative Assistant Sub-Total

Senior Manager of Asset Planning Manager of Energy Initiatives Manager, Capital Budget & Reserves Supervisor of Energy Contracts Asset Coordinator Financial Analyst Sub-Total

Snr Management Non-Union Non-Union

Management Management Management Management Non-Union Non-Union

Deputy Treasurer - Financial Accounting & Corporate Controls Manager of Financial Accounting Manager of Accounting Services Manager of Payroll Services Manager of Financial Accounting - WPL Financial Adminstrator - Capital Assets Corporate Controls Coordinator Financial Analyst Financial Analysis Accounting Clerk Accounts Receivable Clerk Financial Reconciliation Clerk Financial Reconciliation Clerk - Social Services Accounting Clerk Payroll Control & Reporting Specialist Accounts Payable Control Clerk

Management Management Management Management Management Non-Union Non-Union Non-Union Local 543 Local 543 Local 543 Local 543 Local 543 Local 543 Local 543

2

2018 FTE (Approved)

1.0 1.0 1.0 3.0

1.0 1.0 1.0 2.0 1.0 3.0 9.0

Office of the Chief Financial Officer - Finance

Excludes Temporary / Seasonal Employees

2019 FTE (Approved)

1.0 1.0 1.0 3.0

1.0 1.0 1.0 2.0 2.0 3.0 10.0

2020 FTE (Approved)

1.0 1.0 1.0 3.0

1.0 1.0 1.0 2.0 3.0 3.0 11.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

1.0

2.0

2.0

2.0

4.0

4.0

4.0

1.0

1.0

1.0

1.0

1.0

1.0

2.0

2.0

2.0

1.0

1.0

1.0

1.0

1.0

1.0

3.0

3.0

3.0

1.0

1.0

1.0

B. Budgeted Full Time Equivalent (FTE's)

Division

Position Description

Position Profile

General Accounts Payable Clerk Accounts Payable Vendor Control Specialist Administrative Clerk Sub-Total

Local 543 Local 543 Local 543

Financial Planning

Deputy Treasurer - Financial Planning

Manager of Strategic Operating Budget Development & Control

Management Management

Manager of Development Revenue & Financial Administration

Management

Manager of Performance Measurement & Business Case Management Development

Manager of Intergovernmental Funding ? Human Services Management Integration

Financial Planning Administrator Financial Analyst Financial Planning Clerk Subsidy Claims Clerk Intermediate Clerk Sub-Total

Non-Union Non-Union Local 543 Local 543 Local 543

Taxation, Treasury & Financial Projects

Deputy Treasurer - Taxation, Tgreasury & Financial Projects

Manager Treasury & Cash Management Manager, Property Valuation & Administration Manager, Revenue & Collections Assessment Management Officer Senior Tax Analyst Senior Treasury Analyst & Financial System Coordinator

Management

Management Management Management Non-Union Non-Union Non-Union

3

2018 FTE (Approved)

2.0 1.0 1.0 26.0

1.0 1.0

1.0

1.0

1.0

15.0 7.0 1.0 1.0 1.0 30.0

1.0

1.0 1.0 1.0 1.0 1.0 0.0

Office of the Chief Financial Officer - Finance

Excludes Temporary / Seasonal Employees

2019 FTE (Approved)

2.0 1.0 1.0 26.0

1.0 1.0

1.0

1.0

1.0

15.0 8.0 1.0 1.0 1.0 31.0

1.0

1.0 1.0 1.0 1.0 2.0 1.0

2020 FTE (Approved)

2.0 1.0 1.0 26.0

1.0 1.0

1.0

1.0

1.0

15.0 8.0 1.0 1.0 1.0 31.0

1.0

1.0 1.0 1.0 1.0 2.0 1.0

B. Budgeted Full Time Equivalent (FTE's)

Division Total

Position Description

Financial Analyst Corporate Collections Analyst Property Assessor Tax Account & Collection Control Clerk Tax Registration Clerk Tax Account Administrator Mortgage & Ownership Clerk Property Tax Clerk Tax & Accounts Receivable Collector Customer Service Clerk Sub-Total

Position Profile

Non-Union Local 543 Local 543 Local 543 Local 543 Local 543 Local 543 Local 543 Local 543 Local 543

2018 FTE (Approved)

2.0 1.0 1.0 2.0 3.0 2.0 1.0 2.0 1.0 1.0 22.0 90.0

Office of the Chief Financial Officer - Finance

Excludes Temporary / Seasonal Employees

2019 FTE (Approved)

2.0 1.0 1.0 2.0 3.0 2.0 1.0 2.0 1.0 1.0 24.0 94.0

2020 FTE (Approved)

2.0 1.0 1.0 2.0 2.0 2.0 1.0 2.0 1.0 1.0 23.0 94.0

4

C. Budget Summary by Division

Division

Revenues Administration - Finance Asset Planning Financial Accounting and Corporate Controls Financial Planning Taxation, Treasury & Financial Projects Total Revenue

Expenditures Administration - Finance Asset Planning Financial Accounting and Corporate Controls Financial Planning Taxation, Treasury & Financial Projects Total Expenses

Net Administration - Finance Asset Planning Financial Accounting and Corporate Controls Financial Planning Taxation, Treasury & Financial Projects Total Net

Office of the Chief Financial Officer - Finance

2017 Actuals

2018 Actuals

2019 Actuals

0 (5,545,991)

(618,951) (936,768) (1,520,289) (8,621,999)

0 (2,609,946)

(951,302) (1,082,809) (1,822,461) (6,466,518)

0 (6,178,371)

(844,213) (1,032,704) (1,793,417) (9,848,705)

573,337 6,185,399 2,777,891 3,108,845 2,100,658 14,746,130

602,411 3,153,307 2,946,826 3,504,557 2,390,804 12,597,905

647,291 6,684,452 3,009,042 3,537,807 2,436,277 16,314,869

573,337 639,408 2,158,940 2,172,077 580,369 6,124,131

602,411 543,361 1,995,524 2,421,748 568,343 6,131,387

647,291 506,081 2,164,829 2,505,103 642,860 6,466,164

2020 Budget

2021 Budget

$ Budget Change

% Budget Change

0 (662,757) (944,671) (985,293) (2,342,206) (4,934,927)

0 (783,279) (1,018,716) (1,080,653) (2,761,947) (5,644,595)

0 (120,522) (74,045) (95,360) (419,741) (709,668)

n/a 0.0% 0.0% 9.7% 17.9% 14.4%

654,203 1,573,805 3,079,134 3,628,044 2,697,757 11,632,943

657,210 1,671,052 3,169,542 3,842,816 2,844,020 12,184,640

3,007

0.5%

97,247

6.2%

90,408

2.9%

214,772

5.9%

146,263

5.4%

551,697

4.7%

654,203 911,048 2,134,463 2,642,751 355,551 6,698,016

657,210 887,773 2,150,826 2,762,163 82,073 6,540,045

3,007 (23,275) 16,363 119,412 (273,478) (157,971)

0.5% (2.6%) 0.8% 4.5% (76.9%) (2.4%)

5

D. Budget Summary by Major Revenue / Expense Accounts

Office of the Chief Financial Officer - Finance

GL Category

Revenues Other Miscellaneous Revenue Recovery of Expenditures Transfer From Reserve Accounts Transfers From Other Funds User Fees, Permits & Charges Total Revenue

Expenditures Financial Expenses Minor Capital Operating & Maintenance Supplies Other Miscellaneous Expenditures Purchased Services Salaries & Benefits Transfers to Reserves & Capital Funds Utilities, Insurance & Taxes Total Expenses

Total Net

2017 Actuals

2018 Actuals

2019 Actuals

(17,425) (1,849,655)

0 (5,249,688) (1,505,231) (8,621,999)

(21,481) (2,310,120)

0 (2,487,437) (1,647,480) (6,466,518)

(13,607) (2,074,450)

(30,469) (6,214,933) (1,515,246) (9,848,705)

0 15,047 37,805 122,733 783,216 8,784,934 5,268,690 (266,295) 14,746,130

6,124,131

(2) 21,258 32,625 152,081 845,811 9,799,489 2,109,493 (362,850) 12,597,905

6,131,387

315 17,989 38,137 128,341 797,082 10,010,245 5,640,460 (317,700) 16,314,869

6,466,164

2020 Budget

2021 Budget

$ Budget Change

% Budget Change

0 (2,372,276)

0 (659,437) (1,903,214) (4,934,927)

0 (2,557,363)

0 (862,647) (2,224,585) (5,644,595)

0 (185,087)

0 (203,210) (321,371) (709,668)

n/a (7.8%)

n/a (30.8%) (16.9%) (14.4%)

0 14,687 35,335 131,886 861,862 10,573,845

1 15,327 11,632,943

6,698,016

0 14,687 35,335 132,886 873,992 11,112,412

1 15,327 12,184,640

6,540,045

0 0 0 1,000 12,130 538,567 0 0 551,697

(157,971)

n/a 0.0% 0.0% 0.8% 1.4% 5.1% n/a 0.0% 4.7%

(2.4%)

6

D. Budget Summary by Major Revenue / Expense Accounts

Revenues

2021 Budget

Recovery of Expenditures Transfers From Other Funds User Fees, Permits & Charges

Total Revenue

(2,557,363) (862,647)

(2,224,585)

(5,644,595)

45.3% 15.3% 39.4%

100.0%

Expenditures

Minor Capital Operating & Maintenance Supplies Other Miscellaneous Expenditures Purchased Services Salaries & Benefits Transfers to Reserves & Capital Funds Utilities, Insurance & Taxes

Total Expenses

2021 Budget

14,687 35,335 132,886 873,992 11,112,412

1 15,327

12,184,640

0.1% 0.3% 1.1% 7.2% 91.2% 0.0% 0.1%

100.0%

7

Office of the Chief Financial Officer - Finance

User Fees, Permits & Charges

39.4%

Recovery of Expenditures

45.3%

Transfers From Other Funds 15.3%

Transfers to Reserves & Capital Funds

0.0%

Utilities, Insurance &

Taxes 0.1%

Operating & Maintenance

Supplies 0.3%

Minor Capital Other 0.1% Miscellaneous Expenditures 1.1%

Purchased Services

7.2%

Salaries & Benefits 91.2%

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download