Metropolitan Transportation Authority MTA Long Island Bus

MTA LONG ISLAND BUS Metropolitan Transportation Authority MTA Long Island Bus Reconciliation of 2004 Preliminary Budget with Revised 2003 Budget ($ ...
Author: Maryann Burke
1 downloads 0 Views 218KB Size
MTA LONG ISLAND BUS

Metropolitan Transportation Authority MTA Long Island Bus Reconciliation of 2004 Preliminary Budget with Revised 2003 Budget ($ in thousands)

Variance: favorable / (unfavorable) 2003 Net Operating Cash Deficit - Approved March 2003 Plan Eliminate Unspecified PEG for 2004 - March 2003 Plan Adjusted Operating Cash Deficit - March 2003 Plan 2004 Unspecified PEG Now Identified Additional Operating PEG Total Operating PEG New Needs Baseline Operating Cash Deficit - July 2003 Plan variance: compared with Approved March 2003 Plan

($57,533) $0 ($57,533) $0 3,501 $3,501

2004 ($59,091) $0 ($59,091) $0 968 $968

Two-Year Total ($116,624) $0 ($116,624) $0 4,469 $4,469

(1,451)

(1,274)

(2,725)

($55,483)

($59,397)

($114,880)

$2,050

($306)

$1,744

Attachment A MTA LONG ISLAND BUS Reconciliation Tables of the Revised 2003 Budget to the 2003 Mid-Year Forecast and Revised 2004 Projection to the Preliminary 2004 Budget

Schedule A – 1 Schedule A – 2 Schedule A – 3 Schedule A – 4 Schedule A – 5

Operating Budget Summary Operating Statement Expenses Summary Cash Summary Cash Adjustments

MTA LONG ISLAND BUS CONSOLIDATED OPERATING BUDGET SUMMARY

Schedule A-1

(Dollars Stated In Thousands)

Revised 2003 Budget Revenue

$37,478

Expenses Operating Expenses Capital Reimbursements

100,471 (4,278)

2003 Mid-Year Forecast

Revised 2004 Projection

2004 Preliminary Budget

Variance More/(Less) Projection

$275

$40,232

$40,507

$275

98,860 (4,176)

(1,611) 102

104,185 (4,335)

104,444 (4,335)

259 0

96,193

94,684

(1,509)

99,850

100,109

259

(58,715)

(56,931)

1,784

(59,618)

(59,602)

16

Prior Year Cash Balance Cash Adjustments

1,670 (488)

1,670 (222)

0 266

0 527

0 205

0 (322)

Total Adjustments

1,182

1,448

266

527

205

(322)

Net Expenses Net Operating Deficit Before Subsidies and Adjustments

$37,753

Variance More/(Less) Budget

Adjustments to Operating Deficit

Net Cash Deficit Before Subsidies

($57,533)

($55,483)

$2,050

($59,091)

($59,397)

($306)

MTA LONG ISLAND BUS CONSOLIDATED OPERATING STATEMENT

Schedule A - 2

(Dollars Stated In Thousands)

Revenue Passenger Fixed Route Passenger Paratransit Advertising All Other Contract Total Operating Revenue

Revised 2003 Budget

2003 Mid-Year Forecast

Variance More/(Less) Budget

Revised 2004 Projection

2004 Preliminary Budget

Variance More/(Less) Projection

$33,728 925 961 196 1,668

$34,172 957 961 158 1,505

$444 32 0 (38) (163)

$35,753 1,040 1,101 197 2,141

$36,550 1,082 1,101 193 1,581

$797 42 0 (4) (560)

37,478

37,753

275

40,232

40,507

275

372 2,287 3,264 6,459 2,868 75,814 9,407

364 2,117 3,252 6,299 2,721 74,880 9,227

(8) (170) (12) (160) (147) (934) (180)

384 2,358 3,365 5,630 2,957 78,803 10,688

393 2,348 3,547 5,794 2,974 79,028 10,360

9 (10) 182 164 17 225 (328)

100,471

98,860

(1,611)

104,185

104,444

259

Departmental Expenses President Finance Administration Legal Information Technology Operations Paratransit Total Expenses

Other Charges and Credits Capital Reimbursement Depreciation

Total Other Charges and Credits

Net Income (Loss) Before Subsidies

(4,278) 0

(4,176) 0

102 0

(4,335) 0

(4,335) 0

0 0

(4,278)

(4,176)

102

(4,335)

(4,335)

0

($58,715)

($56,931)

$1,784

($59,618)

($59,602)

$16

MTA LONG ISLAND BUS CONSOLIDATED EXPENSE BUDGET SUMMARY BY MAJOR ACCOUNT

Schedule A-3

(Dollars Stated In Thousands)

Revised 2003 Budget Labor Fringe Benefits SUBTOTAL LABOR & FRINGES

Professional Services Maintenance Services Operating Services Fuel, Oil, and Lubricants Material Supplies Tires Utilities Communications Claims Insurance Leases and Rentals Depreciation Other SUBTOTAL NON-COMPENSATION

OPERATING EXPENSES CAPITAL REIMBURSEMENTS NET OPERATING EXPENSES

2003 Mid-Year Forecast

Variance More/(Less) Budget

Revised 2004 Projection

2004 Preliminary Budget

Variance More/(Less) Projection

$60,609 18,340

$60,171 16,488

($438) (1,852)

$62,311 20,187

$62,170 20,495

($141) 308

$78,949

$76,659

($2,290)

$82,498

$82,665

$167

$1,782 2,123 1,065 4,872 4,042 1,220 417 1,836 299 3,320 11 104 0 431

$1,781 2,067 1,070 5,509 3,974 1,310 418 1,922 297 3,380 11 103 0 359

($1) (56) 5 637 (68) 90 1 86 (2) 60 0 (1) 0 (72)

$1,939 2,391 1,151 5,029 4,145 1,311 435 2,012 315 2,450 11 109 0 389

$1,802 2,235 1,162 5,271 4,116 1,374 440 1,888 306 2,625 12 107 0 441

($137) (156) 11 242 (29) 63 5 (124) (9) 175 1 (2) 0 52

$21,522

$22,201

$21,687

$21,779

$92

$100,471

$98,860

$104,185

$104,444

$259

(4,278) $96,193

(4,176) $94,684

$679

($1,611) 102 ($1,509)

(4,335) $99,850

(4,335) $100,109

0 $259

MTA LONG ISLAND BUS CONSOLIDATED OPERATIONS CASH BUDGET SUMMARY BY MAJOR ACCOUNT

Schedule A-4

(Dollars Stated In Thousands)

CASH RECEIPTS

Revised 2003 Budget

2003 Mid-Year Forecast

Variance More/(Less) Budget

Revised 2004 Projection

2004 Preliminary Budget

Variance More/(Less) Projection

Operating Passenger Other Reimbursable Expenses

$34,247 4,026 4,384

$34,686 4,315 4,282

$439 289 (102)

$36,400 4,691 4,325

$37,237 4,609 4,325

$837 (82) 0

Total Cash Receipts

42,657

43,283

626

45,416

46,171

755

60,208 14,754 4,622 1,050 11 4,932 4,100 1,220 312 1,791 520 3,100 4,595 75 570

59,753 14,936 2,259 1,100 13 5,564 4,017 1,286 310 1,878 519 3,600 4,468 150 583

(455) 182 (2,363) 50 2 632 (83) 66 (2) 87 (1) 500 (127) 75 13

61,588 15,373 4,879 1,000 13 5,049 4,154 1,296 317 2,018 540 2,600 5,034 75 571

61,451 16,419 4,954 1,000 14 5,276 4,140 1,309 319 1,894 543 2,725 4,777 150 597

(137) 1,046 75 0 1 227 (14) 13 2 (124) 3 125 (257) 75 26

101,860

100,436

(1,424)

104,507

105,568

1,061

(59,203)

(57,153)

2,050

(59,091)

(59,397)

1,670

1,670

CASH DISBURSEMENTS Payroll Fringe Benefits Pension Workers Compensation Insurance Fuel and Lubricants Material Supplies Communications Utilities Leases and Rentals Claims Purchased Services MetroCard Sales Other Total Cash Disbursements Net Increase/(Decrease) In Cash Beginning Cash Balance Cash Balance Before Subsidies

($57,533)

($55,483)

0 $2,050

0 ($59,091)

0 ($59,397)

(306) 0 ($306)

MTA LONG ISLAND BUS CONSOLIDATED OPERATIONS CASH ADJUSTMENTS

Schedule A-5

(Dollars Stated In Thousands)

Revised 2003 Budget

2003 Mid -Year Forecast

Variance More/ (less) Budget

Revised 2004 Projection

2004 Preliminary Budget

Variance More/ (less) Projection

Accounts Recievable Inventory Prepayments Fixed Assets - Depreciation - Aquistitions Accounts Payable Wages Fringe Benefits Vacation and Sick Accrued Expenses NYS Pension Legal Injury and Damages Workers Compensation Other

$88 (99) (3) 0 0 60 226 42 155 (13) (1,020) 0 220 (138) (6)

$118 (79) (3) 0 0 12 273 72 155 27 (429) 0 (220) (140) (8)

$30 20 0 0 0 (48) 47 30 0 40 591 0 (440) (2) (2)

$36 (50) 0 0 0 72 473 45 205 10 (49) 0 (150) (65) 0

$179 (50) 0 0 0 39 474 119 205 0 (674) 0 (100) 13 0

$143 0 0 0 0 (33) 1 74 0 (10) (625) 0 50 78 0

Net Cash Adjustments

($488)

($222)

$266

$527

$205

($322)

Attachment B MTA LONG ISLAND BUS Financial Plan Tables 2002 Actual 2003 Mid-Year Forecast 2004 Preliminary Budget

Schedule B – 1

Operating Budget Summary

Schedule B – 2

Operating Statement

Schedule B – 3

Expense Summary

Schedule B – 4

Cash Summary

Schedule B – 5

Cash Adjustments

MTA LONG ISLAND BUS CONSOLIDATED OPERATING BUDGET SUMMARY

Schedule B-1

(Dollars Stated In Thousands)

2002 Actual Revenue

$33,705

2003 Mid-Year Forecast $37,753

Variance More/ (less) $4,048

2004 Preliminary Budget $40,507

Variance More/ (less) $2,754

Expenses Operating Expenses Capital Reimbursements

91,601 (4,171)

98,860 (4,176)

7,259 (5)

104,444 (4,335)

5,584 (159)

Net Expenses

87,430

94,684

7,254

100,109

5,425

(53,725)

(56,931)

(3,206)

(59,602)

(2,671)

Net Operating Deficit Before Subsidies and Adjustments

Adjustments to Operating Deficit Prior Year Cash Balance Cash Adjustments

990 1,647

1,670 (222)

680 (1,869)

0 205

(1,670) 427

Total Adjustments

2,637

1,448

(1,189)

205

(1,243)

Net Cash Deficit Before Subsidies

($51,088)

($55,483)

($4,395)

($59,397)

($3,914)

MTA LONG ISLAND BUS CONSOLIDATED OPERATING STATEMENT

Schedule B-2

(Dollars Stated In Thousands)

Revenue Passenger Fixed Route Passenger Paratransit Advertising All Other Contract Total Operating Revenue

2002 Actual

2003 Mid-Year Forecast

Variance More/ (less)

2004 Preliminary Budget

Variance More/ (less)

$29,994 770 719 214 2,008

$34,172 957 961 158 1,505

$4,178 187 242 (56) (503)

$36,550 1,082 1,101 193 1,581

$2,378 125 140 35 76

33,705

37,753

4,048

40,507

2,754

338 1,974 2,775 5,651 2,413 70,401 8,049

364 2,117 3,252 6,299 2,721 74,880 9,227

26 143 477 648 308 4,479 1,178

393 2,348 3,547 5,794 2,974 79,028 10,360

29 231 295 (505) 253 4,148 1,133

91,601

98,860

7,259

104,444

5,584

(4,171) 0

(4,176) 0

(5) 0

(4,335) 0

(159) 0

(4,171)

(4,176)

(5)

(4,335)

(159)

($53,725)

($56,931)

($3,206)

($59,602)

($2,671)

Departmental Expenses President Finance Administration Legal Information Technology Operations Paratransit Total Expenses

Other Charges and Credits Capital Reimbursement Depreciation

Total Other Charges and Credits

Net Income (Loss) Before Subsidies

MTA LONG ISLAND BUS CONSOLIDATED EXPENSE BUDGET SUMMARY BY MAJOR ACCOUNT

Schedule B-3

(Dollars Stated In Thousands)

2002 Actual Labor Fringe Benefits SUBTOTAL LABOR & FRINGES

Professional Services Maintenance Services Operating Services Fuel, Oil, and Lubricants Material Supplies Tires Utilities Communications Claims Insurance Leases and Rentals Depreciation Other SUBTOTAL NON-COMPENSATION

OPERATING EXPENSES CAPITAL REIMBURSEMENTS NET OPERATING EXPENSES

2003 Mid-Year Forecast

Variance More/ (less)

2004 Preliminary Budget

Variance More/ (less)

$58,545 13,951

$60,171 $16,488

$1,626 2,537

$62,170 20,495

$1,999 4,007

$72,496

$76,659

$4,163

$82,665

$6,006

$1,622 1,923 899 4,460 3,670 1,077 386 1,672 285 2,676 10 88 0 337

$1,781 $2,067 $1,070 $5,509 $3,974 $1,310 $418 $1,922 $297 $3,380 $11 $103 $0 $359

$159 144 171 1,049 304 233 32 250 12 704 1 15 0 22

$1,802 2,235 1,162 5,271 4,116 1,374 440 1,888 306 2,625 12 107 0 441

$21 168 92 (238) 142 64 22 (34) 9 (755) 1 4 0 82

$19,105

$22,201

$3,096

$21,779

($422)

$91,601

$98,860

$7,259

$104,444

(4,171) $87,430

($4,176) $94,684

(5) $7,254

(4,335) $100,109

$5,584 (159) $5,425

MTA LONG ISLAND BUS CONSOLIDATED OPERATIONS CASH BUDGET SUMMARY BY MAJOR ACCOUNT

Schedule B-4

(Dollars Stated In Thousands)

CASH RECEIPTS

2002 Actual

2003 Mid-Year Forecast

Variance More/ (less)

2004 Preliminary Budget

Variance More/ (less)

Operating Passenger Other Reimbursable Expenses

$30,565 4,660 4,047

$34,686 4,315 4,282

$4,121 (345) 235

$37,237 4,609 4,325

$2,551 294 43

Total Cash Receipts

39,272

43,283

4,011

46,171

2,888

57,933 13,763 493 1,169 13 4,374 3,513 1,178 246 1,523 469 1,989 4,074 80 533

59,753 14,936 2,259 1,100 13 5,564 4,017 1,286 310 1,878 519 3,600 4,468 150 583

1,820 1,173 1,766 (69) 0 1,190 504 108 64 355 50 1,611 394 70 50

61,451 16,419 4,954 1,000 14 5,276 4,140 1,309 319 1,894 543 2,725 4,777 150 597

1,698 1,483 2,695 (100) 1 (288) 123 23 9 16 24 (875) 309 0 14

91,350

100,436

9,086

105,568

5,132

(52,078)

(57,153)

(5,075)

(59,397)

(2,244)

CASH DISBURSEMENTS Payroll Fringe Benefits Pension Workers Compensation Insurance Fuel and Lubricants Material Supplies Communications Utilities Leases and Rentals Claims Purchased Services MetroCard Sales Other Total Cash Disbursements Net Increase/(Decrease) In Cash Beginning Cash Balance Cash Balance Before Subsidies

990 ($51,088)

1,670 ($55,483)

680 ($4,395)

0 ($59,397)

(1,670) ($3,914)

MTA LONG ISLAND BUS CONSOLIDATED OPERATIONS CASH ADJUSTMENTS

Schedule B-5

(Dollars Stated In Thousands)

2002 Actual Accounts Recievable Inventory Prepayments Fixed Assets - Depreciation - Aquistitions Accounts Payable Wages Fringe Benefits Vacation and Sick Accrued Expenses NYS Pension Legal Injury and Damages Workers Compensation Other Net Cash Adjustments

$47 147 0 0 0 92 294 25 239 233 (66) 0 494 143 (1) $1,647

2003 Mid -Year Forecast

Variance More/ (less)

$118 (79) (3) 0 0 12 273 72 155 27 (429) 0 (220) (140) (8)

$71 (226) (3) 0 0 (80) (21) 47 (84) (206) (363) 0 (714) (283) (7)

($222)

($1,869)

2004 Preliminary Budget

Variance More/ (less)

$179 (50) 0 0 0 39 474 119 205 0 (674) 0 (100) 13 0

$61 29 3 0 0 27 201 47 50 (27) (245) 0 120 153 8

$205

$427

Attachment C MTA LONG ISLAND BUS Major Assumptions in the 2004 Preliminary Budget

Attachment C Major Assumptions in the 2004 Preliminary Budget Revenues •

Fixed route general growth projections are zero percent for 2003 and .25% for 2004.



As a result of the fare increase, fixed route passenger revenues are expected to increase $5.8 million over two years. Ridership loss of 1.3 million (4.8%) is expected over the same period.



Fixed route services continue to expand with Community Solutions for Transportation (CST), Job Access/Reverse Commute (JARC) and Conjestion Mitigation/Air quality (CMAQ) grant funds. Passenger revenue from these services will increase approximately 1.2% per year for 2003 and 2004. Contract revenues in 2003 and 2004 reflect these service improvements.



Paratransit revenues are expected to increase due to fare increase and growth projections of 12.0% in 2003 and 7.6% in 2004 are anticipated. Fleet is expanding by 5 vehicles in 2003 and 5 in 2004.

Expenses •

Labor provisions for represented personnel are consistent with the current labor settlement pattern, the regional CPI was used for nonrepresented employees.



Fringe benefit CPI factors for 2003 and 2004 were 15% and 22%, respectively. The two predominant items that caused this large increase were pension and health costs. Health costs increased 11.5% in 2003 and are projected to increase from 13% to 17% in 2004, as determined by the State of New York, Department of Civil Service.



Pension rate increases are determined by the New York State Employees Retirement System and were adjusted by the state comptroller (for 2003) are as follows: 2002 2003 2004 Rate 1.2% 4.9% 10.1% Increase 325% 106%



Fuel CPI projections for 2004 indicate a 6.86% reduction for fixed route and 10.99% reduction for paratransit.



Utility CPI projections for 2004 indicate a 4.81% reduction for fixed route and .29% reduction for paratransit.



Expenses for service expansions for fixed route and paratransit are included in the 2004 preliminary budget.

Attachment D MTA LONG ISLAND BUS Reconciliation of 2004 Preliminary Budget with Revised 2003 Budget PEGs and New Needs

Schedule D – 1

Summary Table

MTA LONG ISLAND BUS

Schedule D - 1

Reconciliation of 2004 Preliminary Budget with Revised 2003 Budget (In Thousands) Variance Favorable / (Unfavorable) 2003 Net Cash Deficit Before Subsidies - Revised 2003 Budget

($57,533)

2004

Two Year

($59,091)

($116,624)

Reconciling Items: PEG's: Effects of NYSERS pension rate reduction for 2003

2,363

(75)

2,288

Effects of lower than anticipated revenue losses due to fare increase

439

837

1,276

Effects of wage increase elimination for non-represented and other labor savings

455

137

592

Other net revenue and expense changes

244

69

313

3,501

968

4,469

Total PEG's New Needs: Effects of economy on fuel and utilities

(719)

(103)

(822)

Effects of New York State health insurance premiums and other fringe benefits

(182)

(1,046)

(1,228)

Effects of higher claims and workers compensation

(550)

(125)

(675)

(1,451)

(1,274)

(2,725)

Total New Needs Total Reconciling Items Net Cash Deficit Before Subsidies - 2004 Preliminary Budget

2,050 ($55,483)

(306) ($59,397)

1,744 ($114,880)

Attachment E MTA LONG ISLAND BUS Headcount Tables 2003 and 2004

MTA LONG ISLAND BUS OPERATING BUDGET SUMMARY HEADCOUNT 2003 AND 2004

Department President

Attachment - E

2003 Mid-Year Forecast

2004 Preliminary Budget 4

4

Administration

25

25

Finance

26

26

Legal

24

24

Information Technology

24

24

876

884

979

987

199

207

1,178

1,194

Operations Sub-total Fixed Route Operations Paratransit Operations Total MTA LI Bus Headcount

This page has been intentionally left blank.

Suggest Documents