TIP AS OF 4-26-21.PDF

Maricopa County — Formal (2021-05-19)

View PDF Item 78 Meeting page

Extracted text (via pymupdf_layout) 15197 characters
FY 21 Budget as of April 26, 2021
-
Actual % of Projected % of
Approved Working Projected Total Revised Revised
TIP TIP NAME Budget Budget Actuals To-Date Projections for Year Variance Budget Spent Budget
A B C D E F G = E + F H = D - G I = E/D J = G/D
TT0195 Northern Ave: SR 303 to Grand - - 10 - 10 (10) - -
TT0347 Northern Parkway: Dysart to 111th/Auga Fria 8,717,000 6,052,000 6,861,926 (1,304,999) 5,556,927 495,073 113% 92%
TT0372 Northern Parkway: Northern at L101 1,805,000 430,000 70,494 288,000 358,494 71,506 16% 83%
TT0427 Dysart Ave Overpass 8,813,000 4,008,000 184,469 3,811,220 3,995,689 12,311 5% 100%
TT0486 Northern Pkwy 111th to Grand ROW - - - - - - - -
TT0498 Northern Pk: El Mirage Alt Acc 560,000 363,000 42,153 768,575 810,728 (447,728) 12% 223%
TT0499 Northern Pkwy: El Mirage Overpass 111,000 185,000 138,494 21,000 159,494 25,506 75% 86%
TT0502 Northern PkwY: Agua Fria to 99th Ave 370,000 - - - - - - -
TT0573 Northern Pkwy: Loop 101 to Grand Scoping - - 386 - 386 (386) - -
TT0339 Gilbert Rd Bridge 695,000 1,380,000 1,368,306 458,545 1,826,851 (446,851) 99% 132%
TT0342 McKellips Rd 1-10 to Alma School 40,000 1,560,000 162,752 1,722,401 1,885,153 (325,153) 10% 121%
TT0367 El Mirage: Northern to Peoria - - - - - - - -
TT0600 Northern Parkway Agua Fria to 99th Ave Scop 697,000 1,492,000 1,148,111 42,000 1,190,111 301,889 77% 80%
TT0543 Northern Pkwy Storm Drain - - - - - - - -
TT0621 Northern Pkwy Sarival to Agua Fria - - - - - - - -
ALCP BIN RESERVE 2,300,000 8,927,000 8,614,157
BIN LABOR RESERVE 290,000 1,000 -
Total MAG ALCP Projects 24,398,000 24,398,000 9,977,101 5,806,742 15,783,843 8,614,157 65%
TT0003 TAB Special Projects - - 2,800 - 2,800 (2,800) - -
TT0248 Deer Valley: El Mirage to Lk P 13,645,000 1,080,000 391,128 239,000 630,128 449,872 36% 58%
TT0251 Riggs: Ellsworth to Crismon - - 1,364 - 1,364 (1,364) - -
TT0406 Riggs Rd Power to Hawes - - 3,486 - 3,486 (3,486) - -
TT0430 Rittenhouse Bridge at QC Wash 1,313,000 1,314,197 1,313,221 1,313,197 2,626,418 (1,312,221) 100% 200%
TT0495 Lower Buckeye 71st to 67th Ave 145,000 205,200 72,793 109,341 182,134 23,066 35% 89%
TT0517 Val Vista Riggs to Appleby - - - - - - - -
TT0520 Camelback at Beardsley Canal - 56,000 21,403 - 21,403 34,597 38% 38%
TT0538 Riggs Rd Crismon to Meridian - - 24 - 24 (24) - -
TT0554 Pinnacle Pk 99th Ave to 91st Ave - - - - - - - -
TT0561 Olive Ave SR 303 to Sarival Ave 1,490,000 599,000 153,142 216,984 370,126 228,874 26% 62%
TT0562 Olive Ave Sarival to Reems Rd 1,520,000 1,061,000 25,160 1,098,022 1,123,182 (62,182) 2% 106%
TT0563 Rio Verde Dr 136th St to 152nd St - - - - - - - -
TT0568 Happy Valley Loop 303 to Agua Fria River - - - - - - - -
TT0571 Litchfield Rd Northern Pkwy to Peoria 46,000 133,000 51,499 51,965 103,464 29,536 39% 78%
TT0575 Broadway Rd 75th Ave to 51st Ave 894,000 95,000 77,550 - 77,550 17,450 82% 82%
TT0579 83rd Ave Northern to Butler - - 24,021 - 24,021 (24,021) - -
TT0612 University Drive: Higley Road to Power Road 124,000 259,000 249,704 74,665 324,369 (65,369) 96% 125%
TT0613 El Mirage Rd: Glendale to Northern - - - - - - - -
TT0614 Ocotillo Rd: Signal Butte to Meridian 1,003,000 - - - - - - -
TT0633 Southern Ave 41st Ave to 39th Ave 700,000 711,000 718,717 26,629 745,346 (34,346) 101% 105%
CAPY BIN RESERVE 3,800,000 19,531,603 - 18,809,184 -
CAPY BIN LABOR RESERVE 365,000 - - -
Total Capacity Projects 25,045,000 25,045,000 3,106,013 3,129,803 6,235,816 18,809,184 25%
TT0408 Palm Lane Drainage 2,845,000 2,717,000 2,402,094 20,790 2,422,884 294,116 88% 89%
TT0453 Rockaway Hills 255th-251st Ave - - - - - - - -
TT0457 Carefree Hwy Area - - - - - - - -
TT0458 Laveen Area - - - - - - - -
TT0491 Vulture Mountain RecArea Roads 15,000 143,000 140,676 - 140,676 2,324 98% 98%
TT0508 Narramore at Waterman Wash - - - - - - - -
TT0556 Pinnacle Vista Dr 40th to 46th St 100,000 129,000 93,790 37,750 131,540 (2,540) 73% 102%
TT0576 Peoria Ave Citrus Rd to SR 303 528,000 319,000 70,761 219,710 290,471 28,529 22% 91%
TT0583 20th St Cloud Rd to Tamar Rd 700,000 467,000 405,490 165,374 570,864 (103,864) 87% 122%
TT0606 Peak View LVR - - 1,281 - 1,281 (1,281) - -
TT0609 Tonto Hills LVR Package 1 530,000 597,000 330,722 535,367 866,089 (269,089) 55% 145%
TT0611 Dove Valley Road: 171st Ave to 163rd Ave 90,000 146,000 33,375 25,179 58,554 87,446 23% 40%
TT0619 Estrella Park Road - - - - - - - -
TT0652 Elliot Rd, 30th Dr to 27th Ave 310,000 345,000 167,392 95,000 262,392 82,608 49% 76%
TT0653 11th Ave Honda Bow to 13th Ave 370,000 255,000 98,195 136,000 234,195 20,805 39% 92%
TT0655 Figs Springs LVR 300,000 182,000 56,660 122,000 178,660 3,340 31% 98%
TT0657 227th Ave Montgomery to Dove Valley 250,000 125,000 54,031 15,000 69,031 55,969 43% 55%
TT0658 White Tanks Area 4 30,000 70,000 48,209 26,467 74,676 (4,676) 69% 107%
- - - - - - - -
DMIT BIN RESERVE 2,300,000 3,500,159 - 3,694,845 -
DMIT BIN LABOR RESERVE 628,159 1,000 0 -
Total DUST MITIGATION 8,996,159 8,996,159 3,902,677 1,398,637 5,301,314 3,694,845 43% 59%
TT0338 Miller Rd I-10 to 1 m north 62,000 240,000 184,647 4,590 189,237 50,763 77% 79%
TT0477 Pavement Preservation Projects - - 6,292 - 6,292 (6,292) - -
TT0549 Palo Verde Rd Bridge at RID 1,203,000 972,000 797,540 108,587 906,127 65,873 82% 93%
TT0557 Broadway Rd Bridges at Tempe Canal 150,000 276,000 24,726 263,442 288,168 (12,168) 9% 104%
TT0566 2018 Local and Collectors Rehab - - 999 - 999 (999) - -
TT0585 Sun Valley Parkway Restoration Phase I - - - - - - - -
TT0590 Country Place and Laurelwood Park Rehab 1,333,000 198,000 601,828 - 601,828 (403,828) 304% 304%
TT0592 Sun City West Unit 36 Rehab 1,478,000 1,658,000 939,119 785,284 1,724,403 (66,403) 57% 104%
TT0593 Sun Valley Parkway Restoration Phase 2 - - - - - - - -
TT0595 FY 19 ARAC – South Arterials 596,000 1,340,000 47,792 1,219,603 1,267,395 72,605 4% 95%
TT0596 96th St University to Brown Overlay - - - - - - - -
TT0597 FY 19 ARAC - NE Arterials 2,495,000 2,681,000 898,132 1,929,692 2,827,825 (146,825) 33% 105%
TT0598 HIPR - New River Area 672,000 776,000 1,670,365 - 1,670,365 (894,365) 215% 215%
TT0599 Sun Valley Parkway Restoration Phase 3 - - - - - - - -
TT0622 Sun Lakes Rehab Units 1-10 and 41 525,000 648,000 277,596 440,591 718,187 (70,187) 43% 111%
TT0623 Sun Lakes Rehab Units 11-22 423,000 1,100,000 1,004,802 114,042 1,118,844 (18,844) 91% 102%
TT0634 ARAC M&R NE Arterials 65,000 30,000 14,939 9,000 23,939 6,061 50% 80%
TT0635 ARAC Overlay SO Arterials - 813,000 27,962 776,000 803,962 9,038 3% 99%
TT0636 HIPR - McDowell Mountain Rd 135,000 157,000 112,218 53,292 165,510 (8,510) 71% 105%
TT0637 NE Locals Overlay <1980 10,000 25,000 12,769 - 12,769 12,231 51% 51%
TT0638 Sun City West Units 35, 38A, 40 135,000 325,000 155,626 121,215 276,841 48,159 48% 85%
TT0639 ARAC Overlay NW & SO Arterials - - - - - - - -
TT0640 ARAC M&R NW & SO Arterials - - - - - - - -
Dreamland Villa Rehab Units 1-10, 14; Velda
TT0641 Rose Units 2-4 - - - - - - - -
Dreamland Villa Units 11-19, Granite Reef,
TT0642 Velda Rose, Vineyards - - - - - - - -
TT0650 Rocky Point Rd Box Culvert - - - - - - - -
TT0656 Cotton Lane at Camelback 270,000 1,000 4,137 - 4,137 (3,137) 414% 414%
Camelback Rd Drainage Channel - Reems
TT0682 Rd to 2800 feet East - - 19,723 5,000 24,723 (24,723) - -
Granite Reef Dam Rd and Bush Hwy
TT0687 Guardrail - formerly MG2001 - - 28,627 312,633 341,260 (341,260) - -
90th Street: McDowell Rd to EOM -
TT0688 formerly MM2105 - - 11,164 330,000 341,164 (341,164) - -
TT0689 Power Rd S/O Warner Rd - formerly MT2101 - - 36,485 - 36,485 (36,485) - -
96th St: Broadway Rd to Pueblo Ave -
TT0690 formerly MM2102 - - 431,923 - 431,923 (431,923) - -
Jackrabbit Trail (195th Ave) and Medlock
TT0691 Dr. - formerly MW2103 - - 342,635 - 342,635 (342,635) - -
Arlington School Rd & Cactus Rose Rd -
TT0692 formerly MW2004 - - 224,690 - 224,690 (224,690) - -
TT0694 Sun Valley Parkway Restoration Phase 4 - - - - - - - -
TT0695 Sun Valley Parkway Restoration Phase 5 - - - - - - - -
TT0696 Sun Valley Parkway Restoration Phase 6 - - - - - - - -
https://d.docs.live.net/7d3941829eda9db8/Documents/Budget/FY 21 Working TIP/PB Forecast/FY 21 Page Forecast 1 Mar with Actuals 4/26/2021

FY 21 Budget as of April 26, 2021
-
Actual % of Projected % of
Approved Working Projected Total Revised Revised
TIP TIP NAME Budget Budget Actuals To-Date Projections for Year Variance Budget Spent Budget
A B C D E F G = E + F H = D - G I = E/D J = G/D
SPAR BIN RESERVE 1,721,570 543,570 - (2,565,138)
SPAR BIN LABOR RESERVE 511,000 1,000 0
Total SYSTEM PRESERVATION AND RECONSTRUCTI 11,784,570 11,784,570 7,876,737 6,472,971 14,349,708 (2,565,138) 67% 122%
TT0008 Property Management on prior year TIP Projec 50,000 50,000 2,884 (3,480) (596) 50,596 6% -1%
TT0011 R.O.W. In-fill on Road Inventory System 200,000 214,215 74,902 2,000 76,902 137,313 35% 36%
TT0345 MC 85 95th to 75th Ave 3,275,000 4,781,000 3,613,825 231,900 3,845,725 935,275 76% 80%
TT0365 Traffic Calming 100,000 100,000 - - - 100,000 0% 0%
TT0412 Eagle Eye Rd at Tiger Wash 187,000 219,000 315,154 11,000 326,154 (107,154) 144% 149%
TT0447 Bell Rd Adaptive Signal - - - - - - - -
TT0466 Fiber Inst Ind Sch McDwl DMtn - - (5,000) - (5,000) 5,000 - -
TT0467 Riggs Rd ITS - - - - - - - -
TT0480 Mountain Rd Drainage Improvements 50,000 15,000 294 - 294 14,706 2% 2%
TT0487 Yuma at Jackrabbit Trail - - 13,039 - 13,039 (13,039) - -
TT0490 Lower Buckeye at 107th Ave - - 35 - 35 (35) - -
TT0497 Olive Ave: Citrus to Cotton Ln - 311,000 98,712 196,066 294,778 16,222 32% 95%
TT0511 MC 85 107th Ave to 95th Ave 2,040,000 60,000 52,915 15,000 67,915 (7,915) 88% 113%
TT0513 35TH Ave Carver to Elliot 2,730,000 311,000 168,201 60,600 228,801 82,199 54% 74%
TT0534 MC 85 at Rainbow Rd - - - - - - - -
TT0535 Queen Creek Cooper Rd ROW IGA - - - - - - - -
TT0537 Salome Hwy at Wintersburg Signal Upgrade - - - - - - - -
TT0539 Power Rd at Elliot Rd - - - - - - - -
TT0548 MC 85 Liberty School to Cotton Ln - 522,133 460 - 460 521,673 0% 0%
TT0551 Skunk Creek Crossing at Desert Hills 202,000 363,000 232,174 57,703 289,877 73,123 64% 80%
TT0552 Mary St Storm Drain - - - - - - - -
TT0553 MC 85 at 79th Ave Traffic Signal - - - - - - - -
TT0559 U S 80 at Rainbow Wash - - - - - - - -
TT0560 U S 80 at Butterfield Wash - - 4,623 1,000 5,623 (5,623) - -
TT0572 MC 85 at Verado Way 425,000 112,000 117,180 925,050 1,042,230 (930,230) 105% 931%
TT0577 Elliot Rd SR 202 to Signal Butte IGA 1,500,000 - - - - - - -
TT0580 Lindsay Rd Right-of-way Support IGA - - - - - - - -
TT0581 High Friction Surface Treatment Pilot Project - - 178 - 178 (178) - -
TT0582 Germann /Lindsay ROW Assistance IGA - - 13,597 - 13,597 (13,597) - -
Baseline Rd at Meridian Rd Intersection
TT0591 Signalization 97,000 96,000 93,291 12,490 105,781 (9,781) 97% 110%
TT0594 Chandler Heights ROW Support IGA - - - - - - - -
TT0601 Stardust Boulevard at Heritage Drive and Ech 595,000 844,000 703,439 139,899 843,338 662 83% 100%
TT0602 Meeker Boulevard at Granite Valley Drive 217,000 258,000 163,335 101,250 264,585 (6,585) 63% 103%
TT0603 MASH Guardrail Evaluation - NE Area 250,000 105,000 108,497 - 108,497 (3,497) 103% 103%
TT0604 MASH Guardrail Evaluation - NW Area - - - - - - - -
TT0615 Sun p City West Canal Crossing gg 100,000 105,000 73,771 8,462 82,233 22,767 70% 78%
TT0616 Assistance p IGA gg - - 3,092 - 3,092 (3,092) - -
TT0617 Improvements IGA 658,000 - - - - - - -
TT0624 Recker Rd ROW Assistance IGA - - 1,246 - 1,246 (1,246) - -
TT0625 Bush Hwy Animal Detection - 22,000 77,241 14,350 91,591 (69,591) 351% 416%
TT0626 Maricopa Rd MP 16 to MP 16.5 HFST Prep - - - - - - - -
TT0627 Ocotillo Gilbert Rd to 148th St 369,000 - 114 369,000 369,114 (369,114) - -
TT0628 Chandler Hts McQueen to Val Vista - - 9,651 - 9,651 (9,651) - -
TT0629 Southern Ave at 97th St Traffic Signal 448,000 332,000 193,861 56,742 250,603 81,397 58% 75%
TT0630 Lindsay Rd Spur Rd to Layton Lakes Blvd IGA 1,410,000 - 1,137 - 1,137 (1,137) - -
TT0631 Chandler Hts Recker to 600 ft E of Power Rd - - - - - - - -
TT0632 Peoria Ave Reems to Dysart IGA - - - - - - - -
TT0643 Dysart Rd and Rose Ln Intersection 25,000 64,000 28,700 8,228 36,928 27,072 45% 58%
TT0644 Camelback Rd and 127th Ave 125,000 627,000 108,186 327,000 435,186 191,814 17% 69%
TT0645 67th Avenue and Vinyeard Rd 125,000 176,000 137,366 15,000 152,366 23,634 78% 87%
TT0646 Ellsworth Rd and Pueblo Ave 175,000 78,000 38,119 33,000 71,119 6,881 49% 91%
TT0647 San Tan Blvd and Power Road 175,000 59,000 51,200 1,963 53,163 5,837 87% 90%
TT0648 Meeker Blvd and Echo Mesa Dr 17,000 85,000 38,561 15,800 54,361 30,639 45% 64%
TT0649 Bush Hwy Cattle Guard Installation - 572,000 51,524 586,999 638,523 (66,523) 9% 112%
TT0651 MC 85 91st Ave 260,000 1,536,000 1,461,126 4,805,936 6,267,062 (4,731,062) 95% 408%
TT0659 Van Buren at Jackrabbit Tr 155,000 65,000 35,094 12,000 47,094 17,906 54% 72%
TT0660 Gavilan Pk Pkwy and Cloud Rd - 75,000 19,239 12,000 31,239 43,761 26% 42%
TT0661 McDowell Rd at Jackrabbit Tr - - 261 - 261 (261) - -
TT0662 Gavilan Pk Pkwy and King Dr - - 533 - 533 (533) - -
TT0663 ADA Improvemet Package 1 180,000 133,000 100,004 18,000 118,004 14,996 75% 89%
TT0664 ADA Improvemet Package 2 - - 9,247 643,868 653,115 (653,115) - -
TT0665 ADA Improvemet Package 3 - - 543 618,387 618,930 (618,930) - -
TT0666 Stardust Blvd Amigo Dr to Sunglow Dr - - - - - - - -
TT0667 Bell Rd Communication Enhancements 100,000 201,000 125,681 43,508 169,189 31,811 63% 84%
TT0668 MASH Guardrail Evaluation NW Area Ph 1 135,000 221,000 88,164 87,354 175,518 45,483 40% 79%
TT0669 El Mirage Rd, Indian Springs Rd to Southern A 600,000 268,000 94,352 65,000 159,352 108,648 35% 59%
TT0676 Sun City Area ADA Ramps Phase 1 30,000 - 150 - 150 (150) - -
TT0677 MASH Guardrail Evaluation NW Area Ph 4 - - - - - - - -
TT0678 Signal Butte Williams Fld to Pecos ROW Asst - - - - - - - -
TT0679 Reems at Peoria Traffic Signal y IGA - - - 75,000 75,000 (75,000) - -
TT0680 Signal IGA - - - 62,000 62,000 (62,000) - -
TT0681 Signal IGA - 755,000 541 152,000 152,541 602,459 0% 20%
TT0683 Hidden Valley Basin & Storm Drain - - 2,443 - 2,443 (2,443) - -
TT0684 Cotton Lane at Orangewood Ave - 110,000 16,670 21,000 37,670 72,330 15% 34%
TT0685 111th Ave: y Peoria Ave to Alabama Ave - 106,000 33,840 24,000 57,840 48,160 32% 55%
TT0686 Signal Improvements - - 8,566 - 8,566 (8,566) - -
TT0693 ADA Improvement Package 4 - - 59 1,996 2,055 (2,055) - -
TT0697 McDowell Road at Perryville Road. - - - - - - - -
TT0698 Glendale Ave and Cotton Lane - - - - - - - -
TT0699 Lindsay Road Riggs to Ocotillo IGA - - - - - - - -
TT0700 Lower Buckeye El Mirage to 125th Ave IGA - - - - - - - -
TT0701 Carefree Hwy at 32nd St - - - - - - - -
TMAN BIN RESERVE 2,000,000 5,965,923 - 1,510,124
TMAN BIN LABOR RESERVE 916,215 3,944 0
Total TRAFFIC MANAGEMENT 19,921,215 19,921,215 8,582,020 9,829,071 18,411,091 1,510,124 43% 92%
Misc 1,430 71
TOTAL 90,144,944 90,144,944 33,445,978 26,637,224 60,081,843
(5,534) 0
-
Total Projected for Year 60,081,843
Percent of Budget 66.7%
Percent Expenditures of Budget less Unallocated Reserves 77%
https://d.docs.live.net/7d3941829eda9db8/Documents/Budget/FY 21 Working TIP/PB Forecast/FY 21 Page Forecast 2 Mar with Actuals 4/26/2021