METRO SAN FERNANDO VALLEY GOVERNANCE COUNCIL June 6, 2007
SUBJECT: ACTION:
REPORT ON BUDGET UPDATE RECEIVE AND FILE
BACKGROUND: The budget update provides detail of Fiscal Year-to-Date (YTD) Metro San Fernando Valley Bus Operations financial information. The form and content of this report will be modified each month to include salient issues that are requested by the Governance Council.
DISCUSSION The following items for April 2007 Fiscal Year-to-Date are presented for discussion: 1. Metro San Fernando Valley Budget Update 2. Revenue Report 3. Fare Revenue per Boarding Report
Prepared by Metro San Fernando Valley Sector Administration and Finance Staff.
Copies of Agendas or Agenda Items may be obtained by contacting Metro San Fernando Valley at (818) 701-2800.
Metro San Fernando Valley Summary of Operations Expenses By Enterprise Fund for SFV Projects For the Ten Months Ended April 30, 2007 % of YTD Budget Used 101.48% 96.76% 111.47% 102.64% 51.73% 99.21% 107.91% 0.00%
Category Labor
Annual Budget 66,548,209 Contract Wages - AFSCME 4,169,853 Contract Wages - ATU 13,761,786 Contract Wages - TCU 2,418,224 Contract Wages - Teamsters 805,704 Contract Wages - UTU 43,193,146 Non-Contract Salaries 2,199,496 TDP 0 High Level 35,804,242 1,338,866 575,402 12,012,910 76,433 1,300,632 281,828 8,524,117 11,304,655 211,146 178,252 42,500,351 25,605,104 (893,323) 876,865 9,099,614 7,812,091 144,852,802
YTD Budget 55,608,735 3,474,878 11,468,155 2,015,191 671,420 36,146,177 1,832,915 0 29,712,517 1,115,722 480,455 10,013,814 63,694 1,083,843 234,857 7,103,430 9,283,804 175,955 156,943 35,405,571 21,326,198 (744,436) 730,721 7,583,012 6,510,076 120,726,823
YTD Actual 56,433,397 3,362,418 12,783,651 2,068,435 347,347 35,860,759 1,977,880 32,907 27,607,520 1,019,257 479,051 7,770,555 51,179 1,057,858 157,063 8,296,407 8,536,312 141,871 97,966 39,637,257 24,781,795 (543,107) 788,700 8,852,074 5,757,794 123,678,174
YTD Variance (824,662) 112,460 (1,315,496) (53,245) 324,072 285,418 (144,965) (32,907)
Non Labor Casualty & Liability Fringe Benefits Fuel and Lubricants Leases & Rentals Materiel & Supplies Miscellaneous Parts/Tires Rev. Equip Services Taxes Utilities Other Alloc Fringe Benefits Applied - Others Chargeback R/C CHARGEBACK W/C CHARGEBACK-PL/PD Grand Total
2,104,997 92.92% 96,465 91.35% 1,404 99.71% 2,243,259 77.60% 12,515 80.35% 25,985 97.60% 77,794 66.88% (1,192,977) 116.79% 747,491 91.95% 34,084 80.63% 58,977 62.42% (4,231,686) (3,455,597) (201,329) (57,979) (1,269,063) 752,282 111.95% 116.20% 72.96% 107.93% 116.74% 88.44%
(2,951,350) 102.44%
Page 1 of 7
Metro San Fernando Valley Summary of Operations Expenses By Enterprise Fund for SFV Projects For the Ten Months Ended April 30, 2007
Category Direct Expenses Transportation Labor Non Labor Other Sector Administration Labor Non Labor Other Maintenance Labor Non Labor Other Other Support Labor Non Labor Other Subtotal Regular Bus Revenue Service Hours (RSH) Cost Per RSH Regular Bus Metro Orange Line Labor Non Labor Other Revenue Service Hours (RSH) Cost Per RSH Orange Line $ $ Annual Budget 117,474,933 74,194,134 43,487,599 352,130 30,354,405 2,530,279 1,042,485 141,722 1,346,072 40,750,520 14,777,773 19,149,596 6,823,151 8,042,410 1,206,453 6,260,122 575,836 125,517,343 1,286,860 97.54 $ 19,335,459 6,033,899 9,900,672 3,400,888 84,168 229.72 $ YTD Budget 98,032,261 61,965,026 36,382,139 293,439 25,289,448 2,107,468 868,737 118,101 1,120,629 33,959,766 12,314,811 15,960,852 5,684,104 6,707,373 1,005,385 5,222,865 479,123 104,739,634 1,072,385 97.67 $ 15,987,189 5,037,663 8,117,260 2,832,266 70,138 227.94 $ YTD Actual 102,115,595 62,598,490 35,897,362 261,527 26,439,601 2,090,615 841,032 97,238 1,152,344 37,426,490 14,005,038 15,047,424 8,374,029 6,898,659 1,361,421 4,775,412 761,826 109,014,254 1,058,947 102.95 14,663,920 4,328,544 7,425,918 2,909,457 73,739 198.86 $ $ % of YTD Budget YTD Variance Used (4,083,334) 104.17% (633,464) 101.02% 484,777 98.67% 31,912 89.12% (1,150,152) 104.55% 16,853 27,705 20,863 (31,715) (3,466,724) (1,690,227) 913,428 (2,689,925) (191,286) (356,036) 447,453 (282,702) (4,274,620) 13,438 (5.28) 1,323,270 709,119 691,342 (77,191) (3,601) 29.08 99.20% 96.81% 82.33% 102.83% 110.21% 113.73% 94.28% 147.32% 102.85% 135.41% 91.43% 159.00% 104.08% 98.75% 105.40% 91.72% 85.92% 91.48% 102.73% 105.13% 87.24%
Total Regular Bus & OL Labor Non Labor Other Combined RSH Combine Cost Per RSH
Note: Planned RSH vs Delivered RSH
144,852,802 66,548,209 35,804,242 42,500,351 1,371,028 $ 105.65 $
120,726,823 55,608,735 29,712,517 35,405,571 1,142,523 105.67 $
123,678,174 56,433,397 27,607,520 39,637,257 1,132,686 109.19 $
(2,951,350) (824,662) 2,104,997 (4,231,686) 9,837 (3.52)
102.44% 101.48% 92.92% 111.95% 99.14% 103.33%
Page 2 of 7
Metro San Fernando Valley Summary of Operations Expenses - Regular Bus By Enterprise Fund for SFV Projects For the Ten Months Ended April 30, 2007 % of YTD Budget Used 101.02% 98.67%
84.21% 108.23% 99.42% 104.38% 0.00%
Category Transportation Labor
High Level
Annual Budget 74,194,134 43,487,599
2,556,913 83,714 40,090,522 756,451 0
YTD Budget 61,965,026 36,382,139
2,130,761 69,762 33,551,241 630,376 0
YTD Actual 62,598,490 35,897,362
1,794,217 75,500 33,356,357 658,009 13,279
YTD Variance (633,464) 484,777
336,543 (5,739) 194,884 (27,633) (13,279)
Contract Wages - AFSCME Contract Wages - TCU Contract Wages - UTU Non-Contract Salaries TDP
Non Labor
Fringe Benefits Fuel and Lubricants Materiel & Supplies Miscellaneous Parts/Tires Rev. Equip Services
352,130
300,896 0 35,208 16,025 0 0
293,439
250,747 0 29,338 13,354 0 0
261,527
215,596 3 37,779 5,569 1,892 688
31,912
35,151 (3) (8,441) 7,785 (1,892) (688)
89.12%
85.98% 0.00% 128.77% 41.70% 0.00% 0.00%
Other
Alloc Fringe Benefits CHARGEBACK W/C CHARGEBACK-PL/PD
30,354,405
15,892,664 7,118,141 7,343,600
25,289,448
13,237,998 5,931,784 6,119,667
26,439,601
15,207,222 5,785,977 5,446,402
(1,150,152)
(1,969,224) 145,807 673,265
104.55%
114.88% 97.54% 89.00%
Sector Administration Labor
Contract Wages - AFSCME Contract Wages - TCU Contract Wages - UTU Non-Contract Salaries
2,530,279 1,042,485
77,484 50,010 251,310 663,681
2,107,468 868,737
64,570 41,675 209,425 553,067
2,090,615 841,032
50,611 42,581 184,183 563,657
16,853 27,705
13,959 (906) 25,242 (10,589)
99.20% 96.81%
78.38% 102.17% 87.95% 101.91%
Non Labor
Acquisitions Fringe Benefits Leases & Rentals Materiel & Supplies Miscellaneous Services
141,722
0 57,273 0 15,705 50,509 18,234
118,101
0 47,728 0 13,087 42,091 15,195
97,238
0 41,338 162 19,916 21,428 14,394
20,863
0 6,390 (162) (6,829) 20,663 801
82.33%
0.00% 86.61% 0.00% 152.18% 50.91% 94.73%
Other
Alloc Fringe Benefits Chargeback R/C CHARGEBACK W/C
1,346,072
401,844 876,865 67,363
1,120,629
333,773 730,721 56,135
1,152,344
363,644 788,700 0
(31,715)
(29,872) (57,979) 56,135
102.83%
108.95% 107.93% 0.00%
Page 3 of 7
Metro San Fernando Valley Summary of Operations Expenses - Regular Bus By Enterprise Fund for SFV Projects For the Ten Months Ended April 30, 2007 % of YTD Budget YTD Variance Used (3,466,724) 110.21% (1,690,227) 113.73%
7,663 (1,641,151) (35,694) (1,988) (19,058) 98.91% 116.32% 103.07% 100.51% 0.00%
Category Maintenance Labor
High Level
Annual Budget 40,750,520 14,777,773
845,816 12,070,960 1,395,942 465,056 0
YTD Budget 33,959,766 12,314,811
704,846 10,059,133 1,163,285 387,547 0
YTD Actual 37,426,490 14,005,038
697,183 11,700,284 1,198,979 389,534 19,058
Contract Wages - AFSCME Contract Wages - ATU Contract Wages - TCU Non-Contract Salaries TDP
Non Labor
Acquisitions Fringe Benefits Fuel and Lubricants Materiel & Supplies Miscellaneous Parts/Tires Rev. Equip Services Taxes
19,149,596
0 151,650 11,314,950 994,100 11,510 6,437,903 37,946 201,537
15,960,852
0 126,375 9,431,987 828,410 9,592 5,364,918 31,622 167,948
15,047,424
0 122,318 7,078,878 852,416 9,115 6,809,064 38,665 136,968
913,428
0 4,057 2,353,109 (24,006) 477 (1,444,145) (7,043) 30,980
94.28%
0.00% 96.79% 75.05% 102.90% 95.03% 126.92% 122.27% 81.55%
Other
Alloc Fringe Benefits Applied - Others CHARGEBACK W/C
6,823,151
6,527,762 (893,323) 1,188,712
5,684,104
5,437,946 (744,436) 990,593
8,374,029
6,660,672 (543,107) 2,256,464
(2,689,925)
(1,222,726) (201,329) (1,265,870)
147.32%
122.49% 72.96% 227.79%
Other Support Labor
Contract Wages - AFSCME Contract Wages - ATU Contract Wages - TCU Contract Wages - Teamsters Contract Wages - UTU Non-Contract Salaries TDP
8,042,410 1,206,453
125,281 410,031 293,638 221,704 17,004 138,795 0
6,707,373 1,005,385
104,401 341,693 244,703 184,753 14,170 115,666 0
6,898,659 1,361,421
274,509 428,440 269,450 152,671 24,015 211,767 569
(191,286) (356,036)
(170,108) (86,747) (24,748) 32,082 (9,845) (96,101) (569)
102.85% 135.41%
262.94% 125.39% 110.11% 82.64% 169.48% 183.09% 0.00%
Non Labor
Casualty & Liability Fringe Benefits Fuel and Lubricants Leases & Rentals Materiel & Supplies Miscellaneous Parts/Tires Rev. Equip Services Taxes Utilities
6,260,122
1,098,431 12,453 0 63,600 105,566 203,002 1,456,767 3,168,650 0 151,652
5,222,865
915,359 10,886 0 53,000 87,970 169,168 1,213,973 2,639,831 0 132,677
4,775,412
827,917 81,016 24 43,570 74,759 120,703 1,105,153 2,436,323 0 85,947
447,453
87,443 (70,130) (24) 9,430 13,211 48,465 108,820 203,508 0 46,729
91.43%
90.45% 744.21% 0.00% 82.21% 84.98% 71.35% 91.04% 92.29% 0.00% 64.78%
Other
Alloc Fringe Benefits CHARGEBACK W/C
575,836
512,164 63,672
479,123
426,063 53,060
761,826
683,254 78,572
(282,702)
(257,191) (25,511)
159.00%
160.36% 148.08%
Total Regular Bus
125,517,343
104,739,634
109,014,254
(4,274,620)
104.08%
Page 4 of 7
Metro San Fernando Valley Summary of Operations Expenses - Metro Orange Line By Enterprise Fund for SFV Projects For the Ten Months Ended April 30, 2007 % of YTD Budget YTD Actual YTD Variance Used 4,328,544 709,119 85.92%
545,897 654,927 481,925 194,676 2,296,204 154,914 (75,597) 412,401 13,842 291,991 75,137 (8,654) 116.07% 61.36% 97.21% 40.00% 96.83% 105.92%
Category Labor
High Level
Contract Wages - AFSCME Contract Wages - ATU Contract Wages - TCU Contract Wages - Teamsters Contract Wages - UTU Non-Contract Salaries
Annual Budget 6,033,899
564,360 1,280,795 594,920 584,000 2,834,310 175,513
YTD Budget 5,037,663
470,300 1,067,329 495,767 486,667 2,371,341 146,260
Non Labor
Casualty & Liability Fringe Benefits Fuel and Lubricants Leases & Rentals Materiel & Supplies Miscellaneous Parts/Tires Rev. Equip Services Taxes Utilities
9,900,672
240,435 53,130 697,960 12,833 150,053 782 629,447 8,079,824 9,609 26,600
8,117,260
200,362 44,719 581,827 10,694 125,038 652 524,539 6,597,155 8,008 24,267
7,425,918
191,340 18,783 691,649 7,448 72,988 248 380,298 6,046,242 4,903 12,019
691,342
9,022 25,936 (109,822) 3,247 52,049 403 144,241 550,913 3,104 12,248 23,416 (179,624) 79,017
91.48%
95.50% 42.00% 118.88% 69.64% 58.37% 38.10% 72.50% 91.65% 61.23% 49.53% 98.76% 132.57% 79.76%
Other
Alloc Fringe Benefits CHARGEBACK W/C CHARGEBACK-PL/PD
3,400,888
2,270,670 661,727 468,491
2,832,266
1,890,418 551,439 390,409
2,909,457
1,867,002 731,062 311,392
(77,191) 102.73%
Total Metro Orange Line
19,335,459
15,987,189
14,663,920
1,323,270
91.72%
Page 5 of 7
Metro San Fernando Valley Revenue Report For the Ten Months Ended April 30, 2007 ( in millions)
Total Revenue $121.943m
$18,064 FAREBOX 14.81%
$11,715 PASSES 9.61%
$1,868 TOKENS 1.53% $2,815 AD & MISC INC 2.31%
$87,482 TAX & GRANTS 71.74%
Page 6 of 7
Metro San Fernando Valley Passenger Fare Revenue per Boarding Estimates
Boarding Estimates and Fare Revenue
8,000 6,000 4,000 2,000 6 Ju n06 Ju l-0 6 Au g06 Se p06 O ct -0 6 N ov -0 6 D ec -0 6 Ja n07 Fe b07 M ar -0 7 6 Ap r-0 ay -0
Fare Revenue per Boarding Estimates
0.700
Boarding Estimates Fare Revenue
0.650 0.600 0.550 0.500
Ap r-0 6 M ay -06 Se p06 Ju l-0 6 Oc t -0 6 No v- 0 6 De c-0 6 Fe b07 M ar -07 Au g-0 6 Ju n06
Fare Revenue per Boarding Estimates
M
Boarding Estimates April-06 May-06 June-06 July-06 August-06 September-06 October-06 November-06 December-06 January-07 February-07 March-07 April-07 FY07 YTD 48,434,211 $ 4,611,593 5,675,058 5,775,273 5,333,484 5,674,196 5,511,871 5,834,982 5,513,400 5,122,941 5,128,786 4,467,158 5,847,392
Fare Revenue 3,003,691 2,840,214 3,321,063 3,262,707 3,530,541 3,064,476 3,585,178 3,251,214 2,969,451 2,882,605 2,677,880 2,677,330 3,744,923 31,646,305
Fare Revenue per Boarding Estimates 0.651 0.500 0.575 0.612 0.622 0.556 0.614 0.590 0.580 0.562 0.599 0.458
1
Note: Revenue includes passenger fares: cash, tokens, and passes. Taxes, grants and adverstisement revenue is not included.
1.
April boarding data not available at the time of the report.
Page 7 of 7
Jan -07