| ATTACHMENT
D -Burney Express Comparison |
| |
|
| |
Hours |
Cost Per Hr |
Amount |
Farebox |
Ratio |
|
|
|
| Jul-00 |
115.7 |
42.95 |
$
4,970.17 |
1095 |
22.03% |
|
| Aug-00 |
159.4 |
42.95 |
$
6,847.52 |
1320 |
19.28% |
|
| Sep-00 |
115.8 |
42.95 |
$
4,971.46 |
1026 |
20.64% |
|
| Oct-00 |
132.0 |
42.95 |
$
5,667.25 |
918 |
16.20% |
|
| Nov-00 |
125.0 |
42.95 |
$
5,367.03 |
864 |
16.10% |
|
| Dec-00 |
117.4 |
42.95 |
$
5,041.90 |
1179 |
23.38% |
|
| Jan-01 |
131.6 |
42.95 |
$
5,650.07 |
1095 |
19.38% |
|
| Feb-01 |
119.7 |
42.95 |
$
5,139.40 |
1173 |
22.82% |
|
| Mar-01 |
128.9 |
42.95 |
$
5,535.40 |
1620 |
29.27% |
|
| Apr-01 |
125.9 |
42.95 |
$
5,406.55 |
1584 |
29.30% |
|
| May-01 |
131.7 |
42.95 |
$
5,657.37 |
1488 |
26.30% |
|
| Jun-01 |
125.1 |
42.95 |
$
5,371.33 |
1317 |
24.52% |
|
|
1528.0 |
|
$
65,625.45 |
|
| Average Monthly 00/01 |
127.3 |
|
$
5,468.79 |
|
|
|
|
|
|
| Jul-01 |
121.1 |
41.40 |
$
5,011.47 |
1302 |
25.98% |
|
| Aug-01 |
128.7 |
41.40 |
$
5,329.01 |
1761 |
33.05% |
|
| Sep-01 |
108.8 |
41.40 |
$
4,504.73 |
1224 |
27.17% |
|
| Oct-01 |
130.7 |
41.40 |
$
5,412.64 |
1290 |
23.83% |
|
| Nov-01 |
189.1 |
41.40 |
$
7,827.91 |
Intermtn Starts |
|
| Dec-01 |
179.8 |
41.40 |
$
7,442.06 |
Intermtn Service |
|
| Jan-02 |
205.0 |
41.40 |
$
8,488.66 |
Intermtn Service |
|
| Feb-02 |
186.4 |
41.40 |
$
7,716.96 |
Intermtn Service |
|
| Mar-02 |
195.7 |
41.40 |
$
8,102.81 |
Intermtn Service |
|
| misfiled |
0.0 |
41.40 |
$ - |
Intermtn Service |
|
| May-02 |
205.0 |
41.40 |
$
8,488.66 |
Intermtn Service |
|
| Jun-02 |
186.4 |
41.40 |
$
7,716.96 |
Intermtn Service |
|
|
1836.8 |
|
$
76,041.86 |
|
| Average Monthly 01/02 |
167.0 |
|
$
6,912.90 |
|
|
| Jul-02 |
205.0 |
41.40 |
$
8,488.66 |
Intermtn Service |
|
| Aug-02 |
205.0 |
41.40 |
$
8,488.66 |
Intermtn Service |
|
| Sep-02 |
186.4 |
41.40 |
$
7,716.96 |
Intermtn Service |
|
| Oct-02 |
214.4 |
41.40 |
$
8,874.50 |
Intermtn Service |
|
| Nov-02 |
185.0 |
41.40 |
$ 7,659.00 |
686 |
8.96% |
|
| Dec-02 |
203.3 |
41.40 |
$
8,416.62 |
836 |
9.93% |
|
| Jan-03 |
203.5 |
41.40 |
$
8,424.90 |
971 |
11.53% |
|
| Feb-03 |
185.0 |
41.40 |
$ 7,659.00 |
824 |
10.76% |
|
|
|
41.40 |
|
|
|
|
| March estimated |
194.2 |
41.40 |
$
8,039.88 |
829 |
|
|
| April estimated |
194.2 |
41.40 |
$
8,039.88 |
829 |
|
|
| May estimated |
194.2 |
41.40 |
$
8,039.88 |
829 |
|
|
| June estimated |
194.2 |
41.40 |
$
8,039.88 |
829 |
Based
on 4 months from Nov 02-Feb 03 |
|
| July estimated |
194.2 |
41.40 |
$
8,039.88 |
829 |
|
|
| Aug estimated |
194.2 |
41.40 |
$
8,039.88 |
829 |
|
|
| September estimated |
194.2 |
41.40 |
$
8,039.88 |
829 |
|
|
| October estimated |
194.2 |
41.40 |
$
8,039.88 |
829 |
|
|
2330.4 |
|
$
96,478.56 |
9949 |
|
|
|
|
|
| Average Before Intermountain |
126.1 |
|
$
5,367.71 |
|
| During Intermountain |
196.2 |
|
$
8,122.98 |
|
| After Intermountain |
534.1 |
|
$
22,109.67 |
|
|
|
|
|
| Average
Farebox Recovery Prior to Intermountain Express |
|
|
| 8
Months Prior to Intermountain Express |
|
|
|
| Cost |
|
$
42,228.49 |
|
|
| Farebox |
|
$
11,586.00 |
|
|
| Farebox Ratio |
|
27.44% |
|
|
|
| Average
Farebox Recovery After Intermountain Express |
|
|
| 4
Months After Intermountain Express |
|
|
|
| Cost |
|
$
32,159.52 |
|
|
| Farebox |
|
$ 3,317.00 |
|
|
| Farebox Ratio |
|
10.31% |
|
|
|
| Projected Burney Express
farebox 12 months |
|
|
|
| November 02-October 03 |
|
|
|
| Cost |
|
$ 96,478.56 |
|
|
| Farebox |
|
$ 9,949.00 |
|
|
| Farebox Ratio |
|
10.31% |
|
|
|
|
|
|
|
|
|
|
|