Save Budget Analysis Excel Spreadsheet into Word By-law

Excel to PDF to Word

Save Budget Analysis Excel Spreadsheet
into Word By-law

Open the Budget Analysis spreadsheet in Excel
Select View, then uncheck the gridlines box
Select the print area
Save as a PDF to your desktop > selection
Open the PDF
Save as a Word.docx:

File > Export To > Microsoft Word > Word Document > Save to Desktop

(Screenshot following page)

Open the Budget By-law in Word in Alfresco
At the bottom of the document, open Layout tab and select the Breaks dropdown and choose Next Page
In the blank page choose Narrow from the Margins dropdown in the Layouttab
1. Choose Landscape from the Orientation dropdown
Select the Insert tab

Click the Object dropdown and choose Text from File
1. Browse for the new WORD on your desktop
2. Double click the document or Select Insert
Centre the table in each page and make any other required adjustments
Remove any blank pages
Save the Budget By-law

(Example on pages 3-5)

Save PDF as a Word Document

File > Export To > Microsoft Word > Word Document > Save to Desktop

FUNCTION

2018

2019

BUDGETS

Change

19 Levy to 18

Combined

Operating

Capital

Combined

Net Operating Budget

Net Capital Budget

Net Tax Levy

Net Operating Budget

Net Capital Budget

Net Tax Levy

Increase / (Decrease)

CORPORATE SERVICES

643,978 4,221,665

1,816,600

(385,435) 378,112

(63,300)

102,200

786,839

643,978 4,323,865

1,816,600

(385,435) 1,164,951

(63,300)

752,400 4,539,200

1,849,200

(418,900) 298,492

(136,900)

156,850

788,439

752,400 4,696,050

1,849,200

(418,900) 1,086,931

(136,900)

108,422

372,185

32,600

(33,465)

(78,020)

(73,600)

Council

Administration Departments

Workers Comp & Wkly Indem. Self Ins.

Information Systems

Assessment (MPAC)

Provincial Offences

Property

Taxation and Other

Sub Total

6,611,620

889,039

7,500,659

6,883,492

945,289

7,828,781

328,122

Health Unit

Hospital Grants & Health Care Funding

Georgian College - MED Training Centre

1,625,421 271,700

200,000

1,625,421 271,700

200,000

1,647,700 277,300

200,000

1,647,700 277,300

200,000

22,279 5,600

Sub Total

2,097,121

2,125,000

27,879

Total Corporate Services

8,708,741

889,039

9,597,780

9,008,492

945,289

9,953,781

356,001

PLANNING & COMMUNITY DEVELOPMENT

1,518,776

1,821,820

102,500

317,300

1,621,276

2,139,120

1,599,626

1,865,405

177,960

308,700

1,777,586

2,174,105

156,310

34,985

ECONOMIC DEVELOPMENT, AGRICULTURE, FORESTRY, TOURISM, TRAILS & GREY ROOTS

Econ. Dev't/Ag/Forestry/Tourism/Trails

Grey Roots

Sub Total

3,340,596

419,800

3,760,396

3,465,031

486,660

3,951,691

191,295

PLANNING & DEVELOPMENT

Planning & Studies

688,508

4,000

692,508

719,160

17,650

736,810

44,302

Sub Total

688,508

4,000

692,508

719,160

17,650

736,810

44,302

Total Planning & Community Development

4,029,104

423,800

4,452,904

4,184,191

504,310

4,688,501

235,597

FUNCTION

2018

2019

BUDGETS

Change

19 Levy to 18

Combined

Operating

Capital

Combined

Net Operating Budget

Net Capital Budget

Net Tax Levy

Net Operating Budget

Net Capital Budget

Net Tax Levy

Increase / (Decrease)

SOCIAL SERVICES, HOUSING & LONG TERM CARE

87,250

95,550

8,300

Ontario Works & Child Care

Social Assistance

Community Homelessness Prevention Initiative

Ontario Works Administration

1,301,712

1,330,174

28,462

Ontario Works

556,842

569,913

13,071

Child Care

1,164,296

44,000

1,208,296

1,156,216

44,350

1,200,566

(7,730)

County Social Initiatives

298,310

305,310

7,000

Sub Total

3,408,410

44,000

3,452,410

3,457,163

44,350

3,501,513

49,103

Housing

Housing

6,123,819

1,342,604

7,466,423

5,868,994

1,369,500

7,238,494

(227,929)

Sub Total

6,123,819

1,342,604

7,466,423

5,868,994

1,369,500

7,238,494

(227,929)

Long Term Care

Grey Gables

1,112,683

281,892

1,394,575

1,112,683

281,892

1,394,575

Lee Manor

1,705,882

219,109

1,924,991

1,705,882

219,109

1,924,991

Rockwood Terrace

1,269,061

320,009

1,589,070

1,299,061

290,009

1,589,070

Long Term Care Redevelopment

1,361,010

Sub Total Long Term Care

4,087,626

2,182,020

6,269,646

4,117,626

2,152,020

6,269,646

Total Social Services, Housing and Long Term Care

13,619,855

3,568,624

17,188,479

13,443,783

3,565,870

17,009,653

(178,826)

FUNCTION

2018

2019

BUDGETS

Change

19 Levy to 18

Combined

Operating

Capital

Combined

Net Operating Budget

Net Capital Budget

Net Tax Levy

Net Operating Budget

Net Capital Budget

Net Tax Levy

Increase / (Decrease)

TRANSPORTATION & PUBLIC SAFETY

6,324,413

78,593

6,403,006

6,556,923

93,996

6,650,919

247,913

Paramedic Services

Paramedic Services

Sub Total Paramedic Services

6,324,413

78,593

6,403,006

6,556,923

93,996

6,650,919

247,913

Transportation Services

Ordinary Maintenance/Winter Control

7,700,600

7,862,700

162,100

Construction, Resurfacing and Minor Capital

7,564,196

8,357,006

792,810

Supervision & Overhead

1,764,900

1,820,400

55,500

Housing & Depots

329,500

300,000

629,500

321,000

306,000

627,000

(2,500)

Equipment - Operations & Cap

Asset Management, Studies and Engineering

144,000

238,000

94,000

Quarry

12,000

13,000

1,000

Sub Total Transportation Services

9,951,000

7,864,196

17,815,196

10,255,100

8,663,006

18,918,106

1,102,910

Total Transportation & Public Safety

16,275,413

7,942,789

24,218,202

16,812,023

8,757,002

25,569,025

1,350,823

TOTAL TO RAISE FROM TAXATION

42,633,113

12,824,252

55,457,365

43,448,489

13,772,471

57,220,960

1,763,595

2019 Levy Increase Over 2018 Approved Budget

2018 New Growth

$779,747

Calculation of Tax Rate Increase Less: Estimated New Assessment Growth for 20192019 Budgetary Levy Increase Net of New Growth

1% = $562,3712019 Budgetary Increase over the 2018 Approved Budget

1,763,595

(779,747)

983,848

1.7495%