02__Route_Support.xlsx

XLSX spreadsheet 53 KB Posted Feb 14, 2022

Attached to: Visitor Transportation Services for Glacier Nation Federal contract opportunity
Solicitation number: 140P1422Q0003
Issued by: Department of the Interior National Park Service Intermountain Region

View the file

Other files for this federal contract opportunity

Other files attached to Visitor Transportation Services for Glacier Nation, newest first.
File	Type	Posted
Sol_140P1422Q0003_Amd_0003.pdf	PDF	Mar 16, 2022
Sol_140P1422Q0003_Amd_0002.pdf	PDF	Feb 28, 2022
Sol_140P1422Q0003_Amd_0001.pdf	PDF	Feb 22, 2022
09__Q_A_Document_Amendment_0001_0001.pdf	PDF	Feb 22, 2022
04__Quality_Assurance_Surveillance_Plan.xlsx	XLSX spreadsheet	Feb 14, 2022
06__Wage_Determinations.pdf	PDF	Feb 14, 2022
03__Transit_Route_Map.jpg	JPG image	Feb 14, 2022
07__Vaccination_Certification_Notification_Template.pdf	PDF	Feb 14, 2022
05__Price_Schedule.xlsx	XLSX spreadsheet	Feb 14, 2022
01__Statement_of_Work.pdf	PDF	Feb 14, 2022
08__Certification_of_Vaccination_Form.pdf	PDF	Feb 14, 2022
Sol_140P1422Q0003.pdf	PDF	Feb 14, 2022

Show all 12

On GovTribe

Work with this file on GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Lake McDonald Valley Route

Number of Runs

Normal Seat Capacity

tc={4F8B13B0-A227-473B-85B8-9F8028F6D98F}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:

Glaval

Lake McDonald Valley Route, Headway: 30-min

1092

9 Buses in Loop

Deadhead to Aval

COVID-Mitigations

bus

312

Min

Start of day

8:30

9:00

9:30

10:00

10:30

11:00

16:30

17:15

17:30

Assembly to AVC

0:30

468

Max

AVC Start

9:00

9:30

10:00

10:30

11:00

11:30

17:00

17:45

18:00

Aval/AVC Loop

1:20

Start Looping

9:00

9:30

10:00

10:30

11:00

11:30

17:00

17:45

18:00

Lunch

0:30

Loop Aval to AVC, #1

10:20

10:50

11:50

12:20

12:50

18:20

19:05

19:20

Number of Runs (rebalanced)

Loop Aval to AVC, #2

11:40

12:40

13:10

14:10

19:40

20:25

20:40

Loop Aval to AVC, #3

13:30

14:00

14:30

15:00

15:30

16:00

Normal Seat Capacity

Loop Aval to AVC, #4

14:50

15:20

15:50

16:20

16:50

17:20

Note:

Bus 1 converts to bus 7

1232

Loop Aval to AVC, #5

16:10

16:40

17:10

17:40

18:10

18:40

Bus 2 converts to bus 8

COVID-Mitigations

Bus 3 converts to bus 9

352

Min

528

Max

End Day

16:30

17:00

17:30

18:00

18:30

19:00

8:00

Runs Before 1pm

Tickets to Allocate

Lunch included

Total Day Hours

51.25

176

Min

Headway 5-min increase

Hours per week

358.75

264

Max

Deadhead bus if needed

Hours per season (10 weeks)

3587.5

Begin Looping

Bus Type:	Glaval + IHC
Number of buses required:	6
Number of Drivers:	13	Plus 2 spare drivers

	Number of Drivers Analysis
Bus	Driver	Sat	Sun	Mon	Tue	Wed	Thru	Fri	Total
1	W1	8.00		8.00		8.00		8.00	32.00
	W2		8.00		8.00		8.00		24.00
2	W3	8.00		8.00		8.00		8.00	32.00
	W4		8.00		8.00		8.00		24.00
3	W5	8.00		8.00		8.00		8.00	32.00
	W6		8.00		8.00		8.00		24.00
4	W7	8.00		8.00		8.00		8.00	32.00
	W8		8.00		8.00		8.00		24.00
5	W9	8.00		8.00		8.00		8.00	32.00
	W10		8.00		8.00		8.00		24.00
6	W11	8.00		8.00		8.00		8.00	32.00
	W12		8.00		8.00		8.00		24.00
7	W13	3.75	3.75	3.75	3.75	3.75	3.75	3.75	26.25
8	W14	3.75	3.75	3.75	3.75	3.75	3.75	3.75	26.25
9	W16	15.00	3.75	3.75	3.75	3.75	3.75	3.75	37.50

Express + West Alpine

	Number of Runs
	66	5-6 runs each
(buses * seats * runs)	Normal Daily Seat Capacity

tc={BE199E12-0F31-497E-A92E-E0693D055568}: [Threaded comment]

Comment:

5 2006, 7 2008

Express + Wast Alpine Routes, Headways: 15-min Express, 10-min Alpine

14 (08); 11 (06)

849

9 Buses in Loop

Deadhead to LPVC

COVID Seat Capacity

bus

5 (08); 4 (06)

305

Min

Start of day

6:30

6:45

7:00

7:15

7:30

7:45

8:00

12:45

13:15

13:45

Assembly to AVC

0:30

0:05

8 (08); 7 (06)

503

Max

AVC Start

7:00

7:15

7:30

7:45

8:00

8:15

8:30

13:15

13:45

14:15

AVC to LPVC

1:15

0:10

Arrive LPVC

8:15

8:30

8:45

9:00

9:15

9:30

9:45

14:30

15:00

15:30

LPVC to Aval

0:45

0:15

Tickets to Allocate

Arrive Avalanche

9:00

9:15

9:30

9:45

10:00

10:15

10:30

Aval/LPVC Loop

1:30

0:20

# of Runs <1pm

Start Looping

9:00

9:10

9:20

9:30

9:40

9:50

10:00

10:15

10:30

14:30

15:00

15:30

192

Min

At LPVC

15:10

288

Max

Loop LPVC to Aval, #1

10:30

10:40

11:20

11:00

11:10

11:50

11:30

11:45

12:30

16:00

16:30

17:00

Lunch

0:30

Loop LPVC to Aval, #2

12:00

12:40

12:50

12:30

13:10

13:20

13:00

13:45

14:00

17:30

18:00

18:30

Aval to AVC

0:35

Loop LPVC to Aval, #3

14:00

14:10

14:20

14:30

14:40

14:50

15:00

15:15

15:30

19:00

19:30

20:00

Loop LPVC to Aval, #4

15:30

15:40

15:50

16:00

16:10

16:20

Arrive AVC

16:05

16:15

16:25

16:35

16:45

16:55

15:35

15:45

16:05

19:35

20:05

20:35

End Day

16:30

16:45

16:55

17:00

17:15

16:00

16:15

16:30

20:00

20:30

21:00

10:00

10:10

10:00

8:30

7:15

Lunch included	Total Day Hours	107.25
Headway 5-min increase	Hours per week	750.75
Deadhead bus if needed	Hours per season (10 weeks)	7507.5
Begin Looping

Bus Type:	Sprinter
Number of buses required:	12
Number of Drivers:	24	plus 5 spare drivers

	Number of Drivers Analysis
Bus	Driver	Sat	Sun	Mon	Tue	Wed	Thru	Fri	Total
1	WA	10.00		10.00		10.00		10.00	40.00
	WB		10.00		10.00		10.00		30.00
2	WC	10.00		10.00		10.00		10.00	40.00
	WD		10.00		10.00		10.00		30.00
3	WE	10.00		10.00		10.00		10.00	40.00
	WF		10.00		10.00		10.00		30.00
4	WG	10.00		10.00		10.00		10.00	40.00
	WH		10.00		10.00		10.00		30.00
5	WI	10.00		10.00		10.00		10.00	40.00
	WJ		10.00		10.00		10.00		30.00
6	WK	10.00		10.00		10.00		10.00	40.00
	WL		10.00		10.00		10.00		30.00
7	WM	8.50		8.50		8.50		8.50	34.00
	WN		8.50		8.50		8.50		25.50
8	WO	8.50		8.50		8.50		8.50	34.00
	WP		8.50		8.50		8.50		25.50
9	WQ	8.50		8.50		8.50		8.50	34.00
	WR		8.50		8.50		8.50		25.50
10	WS	7.25		7.25		7.25		7.25	29.00
	WT		7.25		7.25		7.25		21.75
11	WU	7.25		7.25		7.25		7.25	29.00
	WV		7.25		7.25		7.25		21.75
12	WW	7.25		7.25		7.25		7.25	29.00
	WX		7.25		7.25		7.25		21.75
	WAA								0.00
	WAB								0.00
	WAC								0.00
									0.00
									0.00
									0.00

St. Mary Lake Valley Route

Number of Runs

Seat Capacity

St. Mary Lake Valley Route, Headway: 30-min

1512

9 Buses in Loop

Deadhead to Sun Point

COVID-Mitigations

bus

432

Min

Start of day

7:30

8:00

8:30

9:00

16:00

16:30

17:00

Assembly to SMVC

0:30

648

Max

SMVC Start

8:00

8:30

9:00

9:30

16:30

17:00

17:30

SP/SMVC Loop

0:45

Start Looping

8:00

8:30

9:00

9:30

16:30

17:00

17:30

Note:

Bus 9 converts to bus 13

Lunch

0:30

Number of Runs (limited)

Loop SP to SMVC, #1

8:45

9:15

9:45

10:45

17:15

17:45

18:15

Bus 10 converts to bus 14

Loop SP to SMVC, #2

9:30

10:00

11:00

11:30

18:00

18:30

19:00

Bus 11 converts to bus 15

Seat Capacity

Loop SP to SMVC, #3

10:15

11:15

11:45

12:15

18:45

19:15

19:45

1232

Loop SP to SMVC, #4

11:30

12:00

12:30

13:00

19:30

20:00

COVID-Mitigations

Loop SP to SMVC, #5

12:15

12:45

13:15

13:45

352

Min

Loop SP to SMVC, #6

13:00

13:30

14:00

14:30

528

Max

Loop SP to SMVC, #7

13:45

14:15

14:45

15:15

Loop SP to SMVC, #8

14:30

15:00

15:30

16:00

Tickets to Allocate

Loop SP to SMVC, #9

15:15

15:45

16:15

16:45

# of Runs <1pm

End Day

15:45

16:15

16:45

17:15

20:00

20:30

21:00

184

Min

8:15

4:00

276

Max

Lunch included

Total Day Hours

(buses * seats * runs)

Headway 5-min increase

Hours per week

315

Deadhead bus if needed

Hours per season (10 weeks)

3150

Begin Looping

Bus Type:	Glaval
Number of buses required:	3
Number of Drivers:	9	Plus 2 spare drivers

	Number of Drivers Analysis
Bus	Driver	Sat	Sun	Mon	Tue	Wed	Thru	Fri	Total
9	E1	8.25		8.25		8.25		8.25	33.00
	E2		8.25		8.25		8.25		24.75
10	E3	8.25		8.25		8.25		8.25	33.00
	E4		8.25		8.25		8.25		24.75
11	E5	8.25		8.25		8.25		8.25	33.00
	E6		8.25		8.25		8.25		24.75
13	E9	4.00	4.00	4.00	4.00	4.00	4.00	4.00	28.00
14	E10	4.00	4.00	4.00	4.00	4.00	4.00	4.00	28.00
15	E11	4.00	4.00	4.00	4.00	4.00	4.00	4.00	28.00

Express + East Alpine

	Number of Runs
	69	7-8 runs each
(buses * seats * runs)	Seat Capacity

tc={A09D9346-A610-48C0-8CCE-BCDC8AB7C7D1}: [Threaded comment]

Comment:

8 sprinter (2006)

Express + East Alpine Routes, Headways: 15-min Express, 10-min Alpine

14 (08); 11 (06)

671

5 Buses in Loop

Deadhead to LPVC

COVID-Mitigations

bus

5 (08); 4 (06)

244

Min

Start of day

6:30

6:45

7:00

7:15

13:00

13:15

13:30

Assembly to SMVC

0:30

0:05

8 (08); 7 (06)

427

Max

SMVC Start

7:00

7:15

7:30

7:45

13:30

13:45

14:00

SMVC to LPVC

0:50

0:10

Arrive LPVC

7:50

8:05

8:20

8:35

14:20

14:35

14:50

SMVC to SP

0:30

0:15

Tickets to Allocate

Arrive Sun Point

8:20

8:35

8:50

9:05

SP/LPVC Loop

1:00

0:20

# of Runs <1pm

Start Looping

8:20

8:30

8:40

8:50

9:05

14:20

14:35

14:50

0:25

128

Min

Loop LPVC to SP, #1

9:20

9:30

9:40

9:50

10:05

15:20

15:35

15:50

Lunch

0:30

224

Max

Loop LPVC to SP, #2

10:20

10:30

11:10

10:50

11:05

16:20

16:35

16:50

SP to SMVC

0:25

Loop LPVC to SP, #3

11:20

12:00

12:10

11:50

12:35

17:20

17:35

17:50

Loop LPVC to SP, #4

12:50

13:00

13:10

13:20

13:35

18:20

18:35

18:50

Loop LPVC to SP, #5

13:50

14:00

14:10

14:20

14:35

19:20

19:35

19:50

Loop LPVC to SP, #6

14:50

15:00

15:10

15:20

15:35

Arrive LPVC

15:15

15:25

15:35

15:45

16:00

19:45

20:00

20:15

End Day

15:45

16:00

16:15

16:30

20:15

20:30

20:45

9:15

7:15

Lunch included	Total Day Hours	68
Headway 5-min increase	Hours per week	476
Deadhead bus if needed	Hours per season (10 weeks)	4760
Begin Looping

Bus Type:	Sprinter
Number of buses required:	8
Number of Drivers:	16	Plus 4 spare drivers

	Number of Drivers Analysis
Bus	Driver	Sat	Sun	Mon	Tue	Wed	Thru	Fri	Total
13	EA	9.25		9.25		9.25		9.25	37.00
	EB		9.25		9.25		9.25		27.75
14	EC	9.25		9.25		9.25		9.25	37.00
	ED		9.25		9.25		9.25		27.75
15	EE	9.25		9.25		9.25		9.25	37.00
	EF		9.25		9.25		9.25		27.75
16	EG	9.25		9.25		9.25		9.25	37.00
	EH		9.25		9.25		9.25		27.75
17	EI	9.25		9.25		9.25		9.25	37.00
	EJ		9.25		9.25		9.25		27.75
18	EK	7.25		7.25		7.25		7.25	29.00
	EL		7.25		7.25		7.25		21.75
19	EM	7.25		7.25		7.25		7.25	29.00
	EN		7.25		7.25		7.25		21.75
20	EO	7.25		7.25		7.25		7.25	29.00
	EP		7.25		7.25		7.25		21.75

0.00

Hourly Seats

	LMV	St. Mary V
7:00	30-48	20-35
8:00	13-22	24-36
9:00	16-24	32-48
10:00	32-48	16-24
11:00	40-60	32-48
12:00	24-36	32-48
1:00	24-36	32-48
2:00	40-60	32-48
Possible:	274	287	561

Hiker-Biker

Hiker/Biker Service, Headway: 15-min
	9 Buses in Loop
bus	1	2	3	4	5
Start of day	6:30	6:45	7:00	7:15	7:30	Assembly to AVC	0:30
AVC Start	7:00	7:15	7:30	7:45	8:00	Aval/AVC Loop	1:20
Start Looping	7:00	7:15	7:30	7:45	8:00	Lunch	0:30
Loop Aval to AVC, #1	8:20	8:35	8:50	9:05	9:20
Loop Aval to AVC, #2	10:10	9:55	10:10	10:25	10:40
Loop Aval to AVC, #3	11:30	11:45	11:30	11:45	12:30
Loop Aval to AVC, #4	12:50	13:05	13:20	13:05	13:50
Loop Aval to AVC, #5	14:10	14:25	14:40	14:55	15:10

End Day	14:30	14:45	15:00	15:15	15:30	Total Day Hours	47.5
	8:00	8:00	8:00	8:00	8:00	Hours per week	95
						Hours per season (8 weeks, weekends only)	760
		Includes 30 minute lunch
		Start of route
	Bus Type:	Sprinter with receiver
	Number of buses required:	5
	Number of Drivers:	5

	Number of Drivers Analysis
Bus	Driver	Sat	Sun	Total
1	W1	9.50		9.50
	W2		9.50	9.50
2	W3	9.50		9.50
	W4		9.50	9.50
3	W5	9.50		9.50
	W6		9.50	9.50
4	W7	9.50		9.50
	W8		9.50	9.50
5	W9	9.50		9.50
	W10		9.50	9.50

Shift Analysis

Shift Analysis
	Dispatchers
	3 per side of the Park; early, mid, and late day shifts 7-days per week from 7/1 to 9/7
		Shift Start	Shift End	Hrs/shift
	Early	7:00	11:00	4:00
	Mid	11:00	15:00	4:00
	Late	15:00	19:00	4:00
	Half AM	7:00	13:00	6:00
	Half PM	13:00	19:00	6:00
		Sat	Sun	Mon	Tue	Wed	Thur	Fri
	Early	A	B
	Half AM			A	B	no shift

Foster, James: Handled by Lead and/or Deputies

C	A
		Mid	B	C
		Half PM			B	C	C	A	B
		Late	C	A
					C off	A off	A & B off	B off	C off
					Ea position has 2 days off
			Shift hours per day							Tot Hours
		A	4	4	6			6	4	24	per week
		B	4	4	6	6			4	24	per week
		C	4	4		6	6	6		26	per week
		Duplicate for both sides

	Lead (L), West Deputy (W), and East Deputy (E)
	Shift Start	Shift End	Hrs/shift	Sat	Sun	Mon	Tue	Wed	Thur	Fri
AM	6:30	14:00	7:30	E&W	E&W					E&W
PM	13:00	20:00	7:00	L	L					L
Hybrid 1	6:30	16:00	9:30			E	E
Hybrid 2	10:30	20:00	9:30			W	W
Hybird PM	9:00	18:00	9:00					L	L
						L off	L off	E&W off	E&W off
				Shift hours per day							Tot Hours
	L			7.5	7.5			9	9	7.5	40.5
	E			7	7	9.5	9.5			7	40
	W			7	7	9.5	9.5			7	40

File details come from the government source that posted it. Updated Feb 14, 2022.