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.