SR-1000-007 (7)L-6AUD96
\0
\H
\M
\N
ANN_WEEK
COMBOP
MAIN_MENU
TOT_SYS
TABLE L-6
TPM / TDA REPORT FORM
Fiscal Year:________________
__________Audited
__________Estimated
TPM/TDA REPORTING FORM
__________Planned
X
AUDITED
CONTACT PERSON: David Feinberg
ACTUAL
FAP Funded
Non-FAP Funded
ESTIMATED
Included
LOCAL SERVICE
FAP FUNDED
NON-FAP FUNDED
Annual Weekday
Local
Express
Dial-A-
FAP
Dedicated
Other
System
ANNUAL WEEKDAY
DEMAND BASED
POLICY BASED
INTRA-COMM.
TOTAL
MULTI-LOCAL
FEW LOCAL
TOTAL
Other
Service
Ride1
Subtotal
Funding2
Ride
Codes3
Total
HEADWAY
CIRCULATION
LOCAL
STOP
STOPS
EXPRESS
Dial-A-Ride1
SUBTOTAL
Dial-A_Ride
SYSTEM
Total Vehicle Miles (000)
Total Vehicle Miles (000)
Vehicle Service Miles (000)
Vehicle Service Miles (000)
Total Vehicle Hours (000)
Vehicle Service Hours (000)
Peak Vehicles
Unlinked Passengers (000)
Linked Passengers (000)
Passenger Revenue (000)
Passenger Revenue (000)
????Auxiliary Rev/Local Subs. (000)
Auxiliary Revenue and Local Subsidies (000)
Operating Cost Less Depr. (000)
Total Operating Cost Less Depreciation (000)
Full Time Equivalent Employees
FAREBOX RECOVERY CALCULATION:
Base Fare
Less Prop. A Fare Subsidy (000)
Farebox Recovery Ratio Operating Cost* (000)
Full Time Equivalent Employees**
Total System:
Annual Saturday
LOCAL SERVICE
EXPRESS SERVICE
NON-FAP FUNDED
Sunday & Holiday
TOTAL SYSTEM
& Weekdays
Funding
Codes
Codes3 (5)
1. "Included Dial-A-Ride" only includes operations that historically have been included in FAP calculations.
2. "Dedicated Funding" includes: FEMA, Base Restructuring, TSE & Overcrowding, Other Special Funding arrangements.
3. "Other Codes" includes Subscription, Contract, Special Events service.
3. "OTHER SERVICE CODES": (1) Subscription (2) Contract (3) Special Events (4) Local Return Fully Funded (5) Charter
* Farebox Recovery Ratio Operating Cost should be used in calculating TPM farebox (+local) return ratio, in accordance with Section 3.1 of the Prop. A Discretionary Fund
Guidelines adopted April 24, 1991.
Auxiliary and Non-Transportation Revenues
Prop A Local Return Revenues
SANTA MONICA'S BIG BLUE BUS
TABLE L-5
FISCAL YEAR: 1998
DATE SUBMITTED: February 8, 1999
** ANNUAL FTE EQUALS: 269.4 WEEKDAY APPORTIONMENT BASED ON TOTAL VEHICLE HOURS
DATE SUBMITTED: August 8, 1999
FISCAL YEAR: 1999
FISCAL YEAR: 2000
** ANNUAL FTE EQUALS: 293.8 WEEKDAY APPORTIONMENT BASED ON TOTAL VEHICLE HOURS
** ANNUAL FTE EQUALS: 308 WEEKDAY APPORTIONMENT BASED ON TOTAL VEHICLE HOURS
DATE SUBMITTED: August 19, 1999
trans\users\davidf\l-6aud981
2856.57
0.00
0.00
2856.57
338.80
338.80
3195.37
56.33
0.49
3251.70
3212.94
0.00
0.00
3212.94
338.80
338.80
3551.74
54.65
0.49
3606.39
0.73
3224.91
0.00
0.00
3224.91
442.90
442.90
3667.81
56.44
0.49
3724.25
0.73
2623.51
0.00
0.00
2623.51
285.30
285.30
2908.81
51.49
0.49
2960.30
2949.17
0.00
0.00
2949.17
285.30
285.30
3234.47
48.47
0.49
3282.94
0.75
2968.91
0.00
0.00
2968.91
373.10
373.10
3342.01
50.08
0.49
3392.09
0.75
248.45
0.00
0.00
248.45
18.00
18.00
266.45
4.55
0.49
271.00
273.12
0.00
0.00
273.12
18.00
18.00
291.12
4.34
0.49
295.46
0.76
279.64
0.00
0.00
279.64
25.60
25.60
305.24
4.55
0.49
309.78
0.76
229.79
0.00
0.00
229.79
15.60
15.60
245.39
4.21
0.49
249.60
252.64
0.00
0.00
252.64
15.60
15.60
268.24
3.89
0.49
272.13
0.78
259.04
0.00
0.00
259.04
22.20
22.20
281.24
4.07
0.49
285.31
0.78
116.00
0.00
0.00
116.00
12.00
12.00
128.00
1.00
129.00
117.00
0.00
0.00
117.00
12.00
12.00
129.00
1.00
130.00
121.00
0.00
0.00
121.00
14.00
14.00
135.00
1.00
136.00
16682.82
0.00
0.00
16682.82
498.40
498.40
17181.22
269.98
0.49
17451.20
17760.15
0.00
0.00
17760.15
498.40
498.40
18258.55
242.96
0.49
18501.50
0.85
17878.10
0.00
0.00
17878.10
707.73
707.73
18585.83
247.31
0.49
18833.15
0.85
13508.28
0.00
0.00
13508.28
403.56
403.56
13911.84
218.58
0.49
14130.40
14380.49
0.00
0.00
14380.49
403.56
403.56
14784.05
196.72
0.49
14980.77
0.85
14475.95
0.00
0.00
14475.95
573.05
573.05
15049.00
200.25
0.49
15249.25
0.85
$5,693.36
$0.00
$0.00
$5,693.36
462.75
462.75
6156.11
96.58
0.49
$6,252.69
$6,102.41
$0.00
$0.00
$6,102.41
462.75
462.75
6565.15
87.36
0.49
$6,652.51
$6,288.97
$0.00
$0.00
$6,288.97
401.90
401.90
6690.87
89.03
0.49
$6,779.90
$1,565.82
$0.00
1000.00
$0.00
1000.00
$1,565.82
$175.48
1000.00
$175.48
1741.30
30.81
0.49
$1,772.10
1000.00
$1,284.81
$0.00
1000.00
$0.00
1000.00
$1,284.81
$128.23
1000.00
$128.23
1413.04
29.03
0.49
$1,442.07
1000.00
$1,258.15
$0.00
1000.00
$0.00
1000.00
$1,258.15
$163.26
1000.00
$163.26
1421.41
29.16
0.49
$1,450.57
1000.00
$13,569.37
59.05
$1,172.50
75.16
$1,172.50
75.16
$14,741.87
248.01
4.20
59.05
$14,500.20
$14,918.39
59.05
$1,172.50
75.16
$16,090.88
248.01
4.20
59.05
$14,500.20
$15,296.29
59.05
$1,668.55
75.16
$16,964.84
248.01
4.20
59.05
$17,212.85
($1,489.66)
($44.50)
($1,534.16)
($1,534.16)
($1,693.97)
($47.54)
($1,741.51)
($1,741.51)
($1,748.91)
($69.23)
($1,818.14)
($1,818.14)
$12,079.71
$1,127.99
$13,207.71
$12,966.04
$13,224.41
$1,124.96
$14,349.37
$12,758.69
$13,547.38
$1,599.32
$15,146.70
$15,394.71
203.70
269.40
203.70
222.14
293.80
222.14
232.88
308.00
232.88
$0.50
$1.25
$0.50
$1.25
$0.50
$1.25
3831.00
0.00
0.00
3831.00
360.20
360.20
4191.20
115.20
132.70
4439.10
4318.74
0.00
0.00
4318.74
360.20
360.20
4678.94
111.76
0.02
132.70
4923.40
4285.08
0.00
0.00
4285.08
551.10
551.10
4836.18
115.41
0.02
132.70
5084.29
1.13
3524.90
0.00
0.00
3524.90
306.50
306.50
3831.40
105.30
3936.70
3960.58
0.00
0.00
3960.58
306.50
306.50
4267.08
99.11
99.11
0.02
4366.19
3944.94
0.00
0.00
3944.94
464.00
464.00
4408.94
102.41
0.02
4511.35
317.80
0.00
0.00
317.80
19.10
19.10
336.90
9.30
12.20
358.40
350.60
0.00
0.00
350.60
19.10
19.10
369.70
8.87
0.02
12.20
390.77
356.71
0.00
0.00
356.71
31.50
31.50
388.21
9.30
0.02
12.20
409.71
1.12
295.70
0.00
0.00
295.70
16.70
16.70
312.40
8.60
321.00
325.36
0.00
0.00
325.36
16.70
16.70
342.06
7.95
0.02
350.00
331.13
0.00
0.00
331.13
27.50
27.50
358.63
8.33
0.02
366.96
114.00
0.00
0.00
114.00
12.00
12.00
126.00
3.00
129.00
115.00
0.00
0.00
115.00
12.00
12.00
127.00
3.00
130.00
119.00
0.00
0.00
119.00
14.00
14.00
133.00
3.00
136.00
19562.80
0.00
0.00
19562.80
528.40
528.40
20091.20
552.10
20643.30
20862.25
0.00
0.00
20862.25
528.40
528.40
21390.65
496.85
0.02
21887.50
20910.15
0.00
0.00
20910.15
863.93
863.93
21774.08
505.75
0.02
22279.84
15834.21
0.00
0.00
15834.21
433.83
1.22
433.83
16268.04
17602352.00
14252792.00
447.00
16715.10
16886.39
0.00
0.00
16886.39
433.83
1.22
433.83
17320.22
17602352.00
14252792.00
402.30
0.02
17722.43
16921.38
0.00
0.00
16921.38
709.31
1.22
709.31
17630.68
17602352.00
14252792.00
409.51
0.02
18040.05
$6,708.30
$0.00
$0.00
$6,708.30
$490.60
$490.60
7198.90
197.50
$7,396.40
$7,200.75
$0.00
$0.00
$7,200.75
$490.60
$490.60
7691.35
178.65
0.02
$7,870.00
$7,348.03
$0.00
$0.00
$7,348.03
$490.60
$490.60
7838.63
182.07
0.02
$8,020.70
$2,105.08
$0.00
1000.00
$0.00
1000.00
$2,105.08
$188.52
1000.00
$188.52
$2,293.60
1000.00
$63.00
$764.30
$3,057.90
$1,720.77
$0.00
1000.00
$0.00
1000.00
$1,720.77
$137.76
1000.00
$137.76
$1,858.53
1000.00
59.37
0.02
$757.00
$2,615.53
$1,666.55
$0.00
1000.00
$0.00
1000.00
$1,666.55
$203.03
1000.00
$203.03
$1,869.58
1000.00
59.62
0.02
$757.00
$2,626.58
$17,719.10
$1,241.40
18960.50
$542.00
$764.30
$20,266.80
$21,239.63
$1,241.40
22481.03
$542.00
$757.00
$23,780.03
$24,240.99
$1,241.40
25482.39
$542.00
$757.00
$26,781.39
($1,746.82)
($47.18)
($1,794.00)
($1,989.86)
($50.40)
($2,040.25)
($2,045.51)
($84.51)
($2,130.03)
$15,972.28
$1,194.22
$17,166.50
$19,249.78
$1,191.00
$20,440.78
$22,195.48
$1,156.89
$23,352.36
$2,111,180.00
622017.00
1489163.00
1660700.00
780900.00
879800.00
1660700.00
780900.00
879800.00
$245,418.50
0.25
981674.00
257207.00
268500.00
From Cost Per Hour Calculation spreadsheet, Express system service total costs.
Sect. 15, Form 203 line 13, Charter Service Funds
Sect. 15, Form 301, Line 24, column d
From Sect. 15, form 404 line 09. Take this number and divide by 2080 hours.
TPM Calculation Spreadsheet
Form 406 line 06 plus charter miles.
form 406 line 08
form 406 line 11 plus line 07
form 406 line 09
form 406 line 24
developed these amounts by dividing the amount of BSIP money $542.0 (cell U41) into $2066.8 (cell X41) to come up with a percentage (.0267) which was mulitiplied the appropriate Sect.
15 number (i.e. 4306.4) for this cell.
amount of BSIP funding for FY 1998.
Stephanie gave me this one. Not sure where she got it from.
Get number from Mabel.
Get this and the numbers below from Mabel except peak buses. This number hasn't changed because Line 10 service hasn't changed. In 99 there will be an increase in service not sure if
it will affect this number.
48.9% of the new service provided by the BSIP funding took place during the week. This number was determined by using Stephanie's sipup-milehours.xls spreadsheet.
The first seven lines down (except peak fleet) all come from Form 406 Column F.
TPM Calculation Spreadsheet, Express Weekday Service Total Costs
TPM Spreadsheet, Local Weekday Cost Per Hour Service
Get number from Mabel
From Monthly Operating Summary Spreadsheet via Mabel
48.9% of the new service provided by the BSIP funding took place during the week. This number was determined by using Stephanie's sipup-milehours.xls spreadsheet.
The first seven lines down (except peak fleet) all come from Form 406 Column F.
Get number from Mabel
TPM Spreadsheet, Local Weekday Cost Per Hour Service
TPM Calculation Spreadsheet, Express Weekday Service Total Costs
Get this and the numbers below from Mabel except peak buses. This number hasn't changed because Line 10 service hasn't changed. In 99 there will be an increase in service not sure if
it will affect this number.
developed these amounts by dividing the amount of BSIP money $542.0 (cell U41) into $2066.8 (cell X41) to come up with a percentage (.0267) which was mulitiplied the appropriate Sect.
15 number (i.e. 4306.4) for this cell.
From Monthly Operating Summary Spreadsheet via Mabel
Form 406 line 06 plus charter miles.
form 406 line 08
form 406 line 11 plus line 07
form 406 line 09
Get number from Mabel.
form 406 line 24
From Cost Per Hour Calculation spreadsheet, Express system service total costs.
TPM Calculation Spreadsheet
amount of BSIP funding for FY 1998.
Sect. 15, Form 203 line 13, Charter Service Funds
Sect. 15, Form 301, Line 24, column d
Stephanie gave me this one. Not sure where she got it from.
From Sect. 15, form 404 line 09. Take this number and divide by 2080 hours.
48.9% of the new service provided by the BSIP funding took place during the week. This number was determined by using Stephanie's sipup-milehours.xls spreadsheet.
The first seven lines down (except peak fleet) all come from Form 406 Column F.
Get number from Mabel
TPM Spreadsheet, Local Weekday Cost Per Hour Service
TPM Calculation Spreadsheet, Express Weekday Service Total Costs
Get this and the numbers below from Mabel except peak buses. This number hasn't changed because Line 10 service hasn't changed. In 99 there will be an increase in service not sure if
it will affect this number.
developed these amounts by dividing the amount of BSIP money $542.0 (cell U41) into $2066.8 (cell X41) to come up with a percentage (.0267) which was mulitiplied the appropriate Sect.
15 number (i.e. 4306.4) for this cell.
From Monthly Operating Summary Spreadsheet via Mabel
Form 406 line 06 plus charter miles.
form 406 line 08
form 406 line 11 plus line 07
form 406 line 09
Get number from Mabel.
form 406 line 24
From Cost Per Hour Calculation spreadsheet, Express system service total costs.
TPM Calculation Spreadsheet
amount of BSIP funding for FY 1998.
Sect. 15, Form 203 line 13, Charter Service Funds
Sect. 15, Form 301, Line 24, column d
Stephanie gave me this one. Not sure where she got it from.
From Sect. 15, form 404 line 09. Take this number and divide by 2080 hours.
Richard N. gave me the express miles and hours data based on new projected service levels.