BRT Program Cost Schedule 20170927

2016 2017 Programmed Funds (Committed) 2018 Risk Mitigation Needs (Uncommitted) 2019 December November October Se...

0 downloads 109 Views 397KB Size
2016 2017

Programmed Funds (Committed) 2018

Risk Mitigation Needs (Uncommitted)

2019

December

November

October

September

August

July

June

May

April

March

February

January

December

November

October

September

August

July

June

May

April

March

February

January

December

November

October

September

August

July

June

May

April

March

February

January

December

November

October

September

August

July

Millions

BRT Program Cost Schedule 9/28/2017

Program Cash Flow

 $16

 $14

 $12

 $10

 $8

 $6

 $4

 $2

 $‐

9/28/2017

BRT Program Cost Schedule

Program Expenditures by Activity  $16  $14

 $10  $8  $6  $4  $2

2016

2017

2018

2019

Internal Resource Effort

BP3 Construction

Professional Services

(27) Vehicle Procurement

Utility Agreement

System Activation

Integrated Art Enhancement

Risk Mitigation (uncommitted)

December

November

October

September

August

July

June

May

April

March

February

January

December

November

October

September

August

July

June

May

April

March

February

January

December

November

October

September

August

July

June

May

April

March

February

January

December

November

October

September

August

 $‐ July

Millions

 $12

9/28/2017

BRT Program Cost Schedule

2016 July

August

September

2017 October

November

December

January

February

March

April

May

June

Internal Resource Effort

                 275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362

BP3 Construction

                          ‐

                          ‐

Professional Services

                          ‐

                 429,970                  429,970                  429,970                  429,970                  429,970                  429,970                  429,970                  429,970                  429,970                  429,970                  429,970

(27) Vehicle Procurement

                          ‐

                          ‐

Utility Agreement

                 183,333                  279,940                  712,513                           ‐

                   96,607                           ‐

                          ‐

                   96,607                  240,820                           ‐

                   96,607                           ‐

System Activation

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

Integrated Art Enhancement

                          ‐

                 153,044                           ‐

                          ‐

                 153,044                           ‐

                          ‐

                 153,044                           ‐

                          ‐

                 153,044                           ‐

Risk Mitigation (uncommitted)

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐                           ‐

                          ‐

                          ‐                           ‐

                          ‐                           ‐

                          ‐

                          ‐

              2,236,634                           ‐

                          ‐

                          ‐                           ‐

                          ‐                           ‐

                          ‐

              1,491,147               2,048,073               4,693,092                           ‐

                          ‐

              2,236,634                           ‐                  425,000

                 458,695               1,138,317               1,417,845                  705,332                  954,983               2,941,967                  705,332                  954,983                  946,152               2,196,480               3,003,056               8,060,059

2017 July

August

September

2018 October

November

December

January

February

March

April

May

June

Internal Resource Effort

                 275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362                  275,362

BP3 Construction

              5,627,365               5,721,108               6,675,665               5,444,432               2,817,924               2,221,691               4,720,754               4,126,717               6,313,760               6,854,403               4,283,870               3,111,223

Professional Services

                 429,970                  429,970                  465,801                  465,801                  465,801                  465,801                  465,801                  465,801                  465,801                  465,801                  465,801                  465,801

(27) Vehicle Procurement

                          ‐

                          ‐

              3,354,952            10,064,855               6,709,903               5,591,586                           ‐

                          ‐

                          ‐

                          ‐

                          ‐

Utility Agreement

                          ‐

                   96,607                           ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

System Activation

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                 275,000                  275,000                  275,000                  275,000

Integrated Art Enhancement

                          ‐

                 153,044                           ‐

                          ‐

                 153,044                           ‐

                          ‐

                 153,044                           ‐

Risk Mitigation (uncommitted)

                 462,533                  462,533                  462,533               1,315,467               1,315,467               1,315,467               1,714,790               1,714,790               1,714,790               1,714,790               1,714,790               1,714,790

                          ‐

                          ‐

                 153,044                           ‐

              6,795,231               7,138,625               7,879,361            10,856,014            15,092,453            10,988,223            12,768,293               6,735,714               9,044,713               9,585,356               7,167,867               5,842,176

9/28/2017

BRT Program Cost Schedule

2018 July

August

September

2019 October

November

December

January

February

March

April

May

June

Internal Resource Effort

                 275,362                  275,362                  275,362                  275,362                  275,362                  247,826                  247,826                  247,826                  247,826                  247,826                  247,826                  247,826

BP3 Construction

              7,794,341               6,710,655               5,994,388               5,840,130               5,665,170               1,390,532               1,711,821               1,370,788               1,370,788               1,370,788               1,370,788               1,370,788

Professional Services

                 465,801                  465,801                  465,801                  465,801                  465,801                  465,801                  537,463                  537,463                  537,463                  537,463                  465,801                  465,801

(27) Vehicle Procurement

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

Utility Agreement

              1,803,034                           ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

System Activation

                 275,000                  275,000                  275,000                  275,000                           ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

Integrated Art Enhancement

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

Risk Mitigation (uncommitted)

              1,464,790               1,464,790               1,464,790               1,464,790               1,464,790               1,464,790               1,137,280               1,137,280               1,137,280               1,086,160               1,086,160               1,086,160

                          ‐

                          ‐

                          ‐

                          ‐

           12,078,328               9,191,608               8,475,341               8,321,083               7,871,123               3,568,949               3,634,390               3,293,356               3,293,356               3,242,236               3,170,574               3,170,574

2019 July

August

September

October

November

December

TOTAL

Internal Resource Effort

                 247,826                  247,826                    27,536                    27,536                    27,536                    27,536            10,326,075

BP3 Construction

                          ‐

Professional Services

                 429,970                  394,139                  394,139                  394,139                  394,139                  322,478            18,452,885

(27) Vehicle Procurement

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

System Activation

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

             2,200,000

Integrated Art Enhancement

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

             1,224,354

Risk Mitigation (uncommitted)

              1,254,743               1,254,743               1,254,743               1,248,356               1,248,356               1,248,356            39,016,096

                          ‐

                          ‐

                          ‐

                          ‐

                          ‐

Utility Agreement

         108,112,200            30,194,565              3,606,068

              1,932,539               1,896,708               1,676,418               1,670,031               1,670,031               1,598,370          213,132,242