8-4094 Interactive, 031412 - Char

Report
Evaluating – Fleet Performance
SE-4094 Transportation Expense Report
Interactive Form
And
Data Analytics
3/14/2012
Part II Evaluating - Fleet Performance
1
During the Part I Program, I presented an interactive SE-4094 Transportation
Expense Report. The objective was to provide a document that allows fleet
managers to input expense data and produce data analytics. The output helps a
manger evaluate the accuracy of information reported to the MDoE. These data
also allow for evaluating fleet performance. Such an evaluation will aid fleet
managers weigh coordinating, cooperating, collaborating, or consolidating parts or
all of school bus fleet operation.
3/14/2012
Part II Evaluating - Fleet Performance
2
Li
ne
Account Code Description
Reg/Vo
c Ed
FTE
Spec
Ed-Sec
53a
Spec EdSec 52
Expenditure
1
2
FTE
Expenditure
3
4
FTE
Total
Expenditure
5
Total FTE
6
7
8
1000-Salaries
1
1190
Supervison
2.00
$145,521
3.00
$175,888
2
1610
Bus Driver
43.00
$1,133,933
81.00
$2,091,242
3
1620
Secretarial
Clerical
3.00
$98,369
4.00
$132,559
4
1630
Aides
0.00
$0
81.00
$1,316,277
5
16xx
Other Support
Mechanics
Helper
6.00
$244,554
0.00
$0
0
$0
0
$0.00
$321,409
5.00
$3,225,175
124.00
$230,928
7.00
$1,316,277
81.00
$244,554
6.00
6
223.00
Toal Salaries
3/14/2012
54.00
$1,622,377
169.00
$3,715,966
0.00
Part II Evaluating - Fleet Performance
$0
$5,338,343
Total FTEs
3
7
2000
Employee
Benefits
$1,051,248
$0
$2,403,691
$3,454,939
39%
Benes % of
Comp
3000/4000 - Purchased Services - Non-Vehicle Related
8
$0
$2,476
$41,746
$44,222
$11,154
$31,562
$42,716
$33,162
$0
$33,162
$0
$0
$0
$12,121
$18,702
$30,823
$58,913
$92,010
Local Expenses
9
34xx
10
38xx/55xx
Telephone/Postag
e
Other Utilities
11
31xx
Purchase
Services - Staff
12
Other Non-Veh
Purch Serv
13 Total Non-Veh Related P/S
3/14/2012
Part II Evaluating - Fleet Performance
$0
$150,923
4
3000/4000-Purchased Services-Veh Related Costs
# of
Veh
14
3310
15
3310
16
3330
17
3310
18
3930
19
4230
20
4xxx
Pupil Trans by
Carrier
# of
Vehicles
# of
Veh
$/Reg Ed
$/ Sec 53a
$/Sec 52 Veh
Veh
Veh
0
$0
0
$0
0
$0
0
#DIV/0!
#DIV/0!
#DIV/0!
0
$0
0
$0
0
$0
0
#DIV/0!
#DIV/0!
#DIV/0!
0
$0
0
$0
0
$0
0
#DIV/0!
#DIV/0!
#DIV/0!
Puil Trans
Taxi Cab
0
$0
0
$0
0
$0
0
#DIV/0!
#DIV/0!
#DIV/0!
Pupil Trans
Fleet Ins
76
$90,940
113
$60,015
0
$150,955
189
$1,197
531.10619
#DIV/0!
10
$130,500
0
$0
0
$130,500
10
$13,050
#DIV/0!
#DIV/0!
$846,648
OK
Pupil Trans by
Carrier (b/y)
Pupil
TransFamily
Veh Cost
Contracted/
Leased Buses
Other Vehicle
Costs
21 Total Veh Rel P/S
3/14/2012
# of
Veh
$43,289
$521,904
$264,729
$581,919
$0
$565,193
$0
$846,648
Part II Evaluating - Fleet Performance
5
5000-Supplies
22
5710
Gas/Fuel
$362,187
$667,325
$1,029,512
Where's #s
23
5710
Oil/Grease
$12,256
$18,746
$31,002
Where's #s
24
5720
Tires/Battery
$37,408
$71,721
$109,129
Where's #s
25
57xx
Other Supplies
& Repair Parts
$94,018
$440,670
$534,688
26
5910
Office
Supplies
$1,461
$4,120
$5,581
27
28
Total Supplies
7000
Other
Expenses/
Adjustment
Bus
Amortization
29
30 Total Expenditures
3/14/2012
$507,330
$1,200
$298,781
$3,804,578
$0 $1,709,912
$1,202,582
$7,327
0
$936,694
$8,940,189
$8,527
0
$1,235,475
$0
$12,744,767
Part II Evaluating - Fleet Performance
Where's #s
Reg Ed % Sec 52 % of Sce 53a % of
of Total
Total
Total
30%
70%
6
Mileage Data
31
794,161
1,997,642
2,791,803
32 Total Riders per Count Week
5,474.0
930.0
6,404
Total Fuel Consumed Gallons
135,618
296,589
432,207
5.9
6.7
Total Annual Miles
Where's #
OK #
OK#
Where's #
Where's #
33
Miles per Gallon
Where's #
34
Ck MPG #s
3/14/2012
Part II Evaluating - Fleet Performance
7
Rides per School Year
394,128
66,960
Cost per Mile
$4.79
$4.48
Cost per Rider
$695
$9,613
Cost per Ride
$9.65
$133.52
Cost per Bus
$50,060
$79,117
Cost of Fuel per Gallon
$2.67
$2.25
FTE Drivers per School Bus
0.57
0.72
Miles per Passenger
145
2,148
Miles per Vehicle
10,449
17,678
Vehicles per FTE Tech
13
Garage Total Expense
$505,875
Garage Ops as % of Total Exp
20%
Fuel as % of Total Exp
10%
7%
Benefits as % of Total Exp
28%
27%
Gallons of Fuel/Bus/Year
4,766
5,906
Annual Veh Operating Cost
$50,060
$79,117
Annual Cost of Veh Maint
$9,874
3/14/2012
Data Analytics
Good! Average is 13
Part II Evaluating - Fleet Performance
Where's#
8
Touch HERE to move on to
Evaluating – Performance Standards
3/14/2012
Part II Evaluating - Fleet Performance
9

similar documents