| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | AF | AG | AH | AI | AJ | AK | AL | AM | AN | AO | AY | AZ | BA | BB | BC | BD | BE | BF | BG | BH | BI | BJ | BK | BL | BM | BN | BO | BP | BQ | BR | BS | BT | BU | BV | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Subcontract itemization | Provenance of Line Items (were items in original bid or added in revised bid) | Race/Ethnicity participation | SBLE participation | LBE participation | ||||||||||||||||||||||||||||||||||||||||||||||||||||
2 | Incorrect classification formulas were used on the original bids corrected in June 2022 on the revised bids. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
3 | Projects 1006103 and 1006104 | Projects 1006103 and 1006104 | Filtered to Original Specialty Classification | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
4 | Subcontract | Provenance | Firm | Location | Supply Type | Corrected Supply Type | Location Type | Size | Demographic | Race / Ethnicity | Original Contract Value | Negotiated Contract Value | Change | Sum Change across 4 contracts | Provenance | Subcontract | SUM of Original Contract Value | SUM of Negotiated Contract Value | SUM of Change | % Change | Race / Ethnicity | Subcontract | Provenance | SUM of Original Contract Value | SUM of Original Contract Value | SUM of Negotiated Contract Value | SUM of Negotiated Contract Value | SUM of Change | % Change | Size | Supply Type | SUM of Original Contract Value | SUM of Original Contract Value | SUM of Negotiated Contract Value | SUM of Negotiated Contract Value | SUM of Change | Location Type | Provenance | SUM of Original Contract Value | SUM of Original Contract Value | SUM of Negotiated Contract Value | SUM of Negotiated Contract Value | SUM of Change | % Change | |||||||||||||
5 | Trucking | Original | Monroe Trucking | Oakland | Non-speciality | Non-speciality | LBE | SLBE | MBE | AA | $350,000 | $1,100,000 | $750,000 | $3,000,000 | Added | Prime / Speciality (unspecified) | $0 | $658,000 | $658,000 | #DIV/0! | AA | Trucking | Original | $350,000 | 2.56% | $1,100,000 | 7.32% | $750,000 | 214.29% | Non-SLBE | Non-speciality | $10,401,000 | 77.69% | $7,615,250 | 66.71% | -$2,785,750 | LBE | Added | $0 | 0.00% | $1,158,000 | 7.71% | $1,158,000 | #DIV/0! | |||||||||||||
6 | Utilities | Added | Focon, Inc. | Oakland | Non-speciality | Non-speciality | LBE | SLBE | MBE | AA | $500,000 | $500,000 | $2,000,000 | Utilities | $0 | $500,000 | $500,000 | #DIV/0! | Utilities | Added | $0 | 0.00% | $500,000 | 3.33% | $500,000 | #DIV/0! | SLBE | Non-speciality | $2,986,500 | 22.31% | $3,800,000 | 33.29% | $813,500 | Original | $11,387,650 | 83.38% | $11,730,250 | 78.08% | $342,600 | 3.01% | |||||||||||||||||
7 | Concrete | Original | Rosas Brothers | Oakland | Non-speciality | Non-speciality | LBE | SLBE | MBE | H | $2,136,500 | $2,200,000 | $63,500 | $254,000 | Added Total | $0 | $1,158,000 | $1,158,000 | #DIV/0! | AA Total | $350,000 | 2.56% | $1,600,000 | 10.65% | $1,250,000 | 357.14% | Grand Total | $13,387,500 | 100.00% | $11,415,250 | 100.00% | -$1,972,250 | LBE Total | $11,387,650 | 83.38% | $12,888,250 | 85.79% | $1,500,600 | 13.18% | ||||||||||||||||||
8 | Trucking | Original | S&S Trucking | Oakland | Non-speciality | Non-speciality | LBE | SLBE | MBE | H | $500,000 | -$500,000 | -$2,000,000 | Original | A&C | $2,812,000 | $2,950,000 | $138,000 | 4.91% | C | A&C | Original | $2,812,000 | 20.59% | $2,950,000 | 19.64% | $138,000 | 4.91% | Non-LBE | Original | $2,269,850 | 16.62% | $2,135,000 | 14.21% | -$134,850 | -5.94% | |||||||||||||||||||||
9 | Prime | Original | Gallagher & Burk | Oakland | Non-speciality | Non-speciality | LBE | Non-SLBE | White | C | $5,589,150 | $5,480,250 | -$108,900 | -$435,600 | Concrete | $2,136,500 | $2,200,000 | $63,500 | 2.97% | Prime | Original | $5,589,150 | 40.92% | $5,480,250 | 36.48% | -$108,900 | -1.95% | Filtered to Corrected Specialty Classification | Non-LBE Total | $2,269,850 | 16.62% | $2,135,000 | 14.21% | -$134,850 | -5.94% | ||||||||||||||||||||||
10 | A&C | Original | Gallagher & Burk | Oakland | Non-speciality | -- | LBE | Non-SLBE | White | C | $2,542,000 | -$2,542,000 | -$10,168,000 | Prime | $5,589,150 | $5,480,250 | -$108,900 | -1.95% | Prime / Speciality (unspecified) | Added | $0 | 0.00% | $658,000 | 4.38% | $658,000 | #DIV/0! | Size | Supply Type | SUM of Original Contract Value | SUM of Original Contract Value | SUM of Negotiated Contract Value | SUM of Negotiated Contract Value | SUM of Change | Grand Total | $13,657,500 | 100.00% | $15,023,250 | 100.00% | $1,365,750 | 10.00% | |||||||||||||||||
11 | A&C | Original | Gallagher & Burk | Oakland | Specialty | Specialty | LBE | Non-SLBE | White | C | $270,000 | $2,950,000 | $2,680,000 | $10,720,000 | Seal | $289,100 | $300,000 | $10,900 | 3.77% | Seal | Original | $289,100 | 2.12% | $300,000 | 2.00% | $10,900 | 3.77% | Non-SLBE | Non-speciality | $7,859,000 | 72.46% | $7,615,250 | 66.71% | -$243,750 | |||||||||||||||||||||||
12 | Prime / Speciality (unspecified) | Added | Gallagher & Burk | Oakland | Specialty | Specialty | LBE | Non-SLBE | White | C | $658,000 | $658,000 | $2,632,000 | Striping | $1,780,750 | $1,835,000 | $54,250 | 3.05% | Striping | Original | $1,780,750 | 13.04% | $1,835,000 | 12.21% | $54,250 | 3.05% | SLBE | Non-speciality | $2,986,500 | 27.54% | $3,800,000 | 33.29% | $813,500 | ||||||||||||||||||||||||
13 | Seal | Original | Bond Blacktop | Hayward | Non-speciality | Non-speciality | Non-LBE | Non-SLBE | WBE | C | $289,100 | $300,000 | $10,900 | $43,600 | Trucking | $1,050,000 | $1,100,000 | $50,000 | 4.76% | Trucking | Original | $200,000 | 1.46% | $0 | 0.00% | -$200,000 | -100.00% | Grand Total | $10,845,500 | 100.00% | $11,415,250 | 100.00% | $569,750 | ||||||||||||||||||||||||
14 | Striping | Original | Chrisp Company | Fremont | Non-speciality | Non-speciality | Non-LBE | Non-SLBE | White | C | $1,780,750 | $1,835,000 | $54,250 | $217,000 | Original Total | $13,657,500 | $13,865,250 | $207,750 | 1.52% | C Total | $10,671,000 | 78.13% | $11,223,250 | 74.71% | $552,250 | 5.18% | |||||||||||||||||||||||||||||||
15 | Trucking | Original | Double D Trucking | Dublin | Non-speciality | Non-speciality | Non-LBE | Non-SLBE | White | C | $200,000 | -$200,000 | -$800,000 | Grand Total | $13,657,500 | $15,023,250 | $1,365,750 | 10.00% | H | Concrete | Original | $2,136,500 | 15.64% | $2,200,000 | 14.64% | $63,500 | 2.97% | ||||||||||||||||||||||||||||||
16 | TOTAL | $13,657,500 | $15,023,250 | $1,365,750 | $5,463,000 | Trucking | Original | $500,000 | 3.66% | $0 | 0.00% | -$500,000 | -100.00% | ||||||||||||||||||||||||||||||||||||||||||||
17 | 10.00% | H Total | $2,636,500 | 19.30% | $2,200,000 | 14.64% | -$436,500 | -16.56% | |||||||||||||||||||||||||||||||||||||||||||||||||
18 | Grand Total | $13,657,500 | 100.00% | $15,023,250 | 100.00% | $1,365,750 | 10.00% | ||||||||||||||||||||||||||||||||||||||||||||||||||
19 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
20 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
21 | Project 1006105 | Project 1006105 | Filtered to Original Specialty Classification | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
22 | Subcontract | Provenance | Firm | Location | Supply Type | Corrected Supply Type | Location Type | Size | Demographic | Race / Ethnicity | Original Contract Value | Negotiated Contract Value | Change | Sum Change across 1 contracts | Provenance | Subcontract | SUM of Original Contract Value | SUM of Negotiated Contract Value | SUM of Change | % Change | Race / Ethnicity | Subcontract | Provenance | SUM of Original Contract Value | SUM of Original Contract Value | SUM of Negotiated Contract Value | SUM of Negotiated Contract Value | SUM of Change | % Change | Size | Supply Type | SUM of Original Contract Value | SUM of Original Contract Value | SUM of Negotiated Contract Value | SUM of Negotiated Contract Value | SUM of Change | Location Type | Provenance | SUM of Original Contract Value | SUM of Original Contract Value | SUM of Negotiated Contract Value | SUM of Negotiated Contract Value | SUM of Change | % Change | |||||||||||||
23 | Trucking | Original | Monroe Trucking | Oakland | Non-speciality | Non-speciality | LBE | SLBE | MBE | AA | $200,000 | $525,000 | $325,000 | $325,000 | Added | Prime / Speciality (unspecified) | $0 | $0 | $0 | #DIV/0! | AA | Trucking | Original | $200,000 | 3.82% | $525,000 | 9.12% | $325,000 | 162.50% | Non-SLBE | Non-speciality | $4,092,275 | 79.41% | $3,237,978 | 71.83% | -$854,298 | LBE | Added | $0 | 0.00% | $105,000 | 1.82% | $105,000 | #DIV/0! | |||||||||||||
24 | Utilities | Added | Focon, Inc. | Oakland | Non-speciality | Non-speciality | LBE | SLBE | MBE | AA | $105,000 | $105,000 | $105,000 | Utilities | $0 | $105,000 | $105,000 | #DIV/0! | Utilities | Added | $0 | 0.00% | $105,000 | 1.82% | $105,000 | #DIV/0! | SLBE | Non-speciality | $1,061,250 | 20.59% | $1,270,000 | 28.17% | $208,750 | Original | $4,451,365 | 85.04% | $4,898,978 | 85.08% | $447,613 | 10.06% | |||||||||||||||||
25 | Concrete | Original | Rosas Brothers | Oakland | Non-speciality | Non-speciality | LBE | SLBE | MBE | H | $636,250 | $640,000 | $3,750 | $3,750 | Added Total | $0 | $105,000 | $105,000 | #DIV/0! | AA Total | $200,000 | 3.82% | $630,000 | 10.94% | $430,000 | 215.00% | Grand Total | $5,153,525 | 100.00% | $4,507,978 | 100.00% | -$645,548 | LBE Total | $4,451,365 | 85.04% | $5,003,978 | 86.91% | $552,613 | 12.41% | ||||||||||||||||||
26 | Trucking | Original | S&S Trucking | Oakland | Non-speciality | Non-speciality | LBE | SLBE | MBE | H | $225,000 | -$225,000 | -$225,000 | Original | A&C | $2,812,000 | $1,250,000 | -$1,562,000 | -55.55% | C | A&C | Original | $2,812,000 | 53.72% | $1,250,000 | 21.71% | -$1,562,000 | -55.55% | Non-LBE | Original | $783,160 | 14.96% | $754,000 | 13.09% | -$29,160 | -3.72% | |||||||||||||||||||||
27 | Prime | Original | Gallagher & Burk | Oakland | Non-speciality | Non-speciality | LBE | Non-SLBE | White | C | $578,115 | $2,483,978 | $1,905,863 | $1,905,863 | Concrete | $636,250 | $640,000 | $3,750 | 0.59% | Prime | Original | $578,115 | 11.04% | $2,483,978 | 43.14% | $1,905,863 | 329.67% | Filtered to Corrected Specialty Classification | Non-LBE Total | $783,160 | 14.96% | $754,000 | 13.09% | -$29,160 | -3.72% | ||||||||||||||||||||||
28 | A&C | Original | Gallagher & Burk | Oakland | Non-speciality | -- | LBE | Non-SLBE | White | C | $2,731,000 | -$2,731,000 | -$2,731,000 | Prime | $578,115 | $2,483,978 | $1,905,863 | 329.67% | Prime / Speciality (unspecified) | Added | $0 | 0.00% | $0 | 0.00% | $0 | #DIV/0! | Size | Supply Type | SUM of Original Contract Value | SUM of Original Contract Value | SUM of Negotiated Contract Value | SUM of Negotiated Contract Value | SUM of Change | Grand Total | $5,234,525 | 100.00% | $5,757,978 | 100.00% | $523,453 | 10.00% | |||||||||||||||||
29 | A&C | Original | Gallagher & Burk | Oakland | Specialty | Specialty | LBE | Non-SLBE | White | C | $81,000 | $1,250,000 | $1,169,000 | $1,169,000 | Seal | $124,410 | $124,000 | -$410 | -0.33% | Seal | Original | $124,410 | 2.38% | $124,000 | 2.15% | -$410 | -0.33% | Non-SLBE | Non-speciality | $1,361,275 | 56.19% | $3,237,978 | 71.83% | $1,876,703 | |||||||||||||||||||||||
30 | Prime / Speciality (unspecified) | Added | Gallagher & Burk | Oakland | Specialty | Specialty | LBE | Non-SLBE | White | C | $0 | $0 | Striping | $608,750 | 630000 | $21,250 | 3.49% | Striping | Original | $608,750 | 11.63% | 630000 | 10.94% | $21,250 | 3.49% | SLBE | Non-speciality | $1,061,250 | 43.81% | $1,270,000 | 28.17% | $208,750 | |||||||||||||||||||||||||
31 | Seal | Original | Bond Blacktop | Hayward | Non-speciality | Non-speciality | Non-LBE | Non-SLBE | WBE | C | $124,410 | $124,000 | -$410 | -$410 | Trucking | $475,000 | $525,000 | $50,000 | 10.53% | Trucking | Original | $50,000 | 0.96% | $0 | 0.00% | -$50,000 | -100.00% | Grand Total | $2,422,525 | 100.00% | $4,507,978 | 100.00% | $2,085,453 | ||||||||||||||||||||||||
32 | Striping | Original | Chrisp Company | Fremont | Non-speciality | Non-speciality | Non-LBE | Non-SLBE | White | C | $608,750 | 630000 | $21,250 | $21,250 | Original Total | $5,234,525 | $5,652,978 | $418,453 | 7.99% | C Total | $4,173,275 | 79.73% | $4,487,978 | 77.94% | $314,703 | 7.54% | |||||||||||||||||||||||||||||||
33 | Trucking | Original | Double D Trucking | Dublin | Non-speciality | Non-speciality | Non-LBE | Non-SLBE | White | C | $50,000 | -$50,000 | -$50,000 | Grand Total | $5,234,525 | $5,757,978 | $523,453 | 10.00% | H | Concrete | Original | $636,250 | 12.15% | $640,000 | 11.12% | $3,750 | 0.59% | SLBE % for all contracts | Original calculation | 22.16% | 32.83% | ||||||||||||||||||||||||||
34 | TOTAL | $5,234,525 | $5,757,978 | $523,453 | $523,453 | Trucking | Original | $225,000 | 4.30% | $0 | 0.00% | -$225,000 | -100.00% | Corrected calculation | 28.40% | 32.83% | |||||||||||||||||||||||||||||||||||||||||
35 | 10.00% | Total | $59,864,525 | $65,850,978 | $5,986,453 | H Total | $861,250 | 16.45% | $640,000 | 11.12% | -$221,250 | -25.69% | |||||||||||||||||||||||||||||||||||||||||||||
36 | Grand Total | $5,234,525 | 100.00% | $5,757,978 | 100.00% | $523,453 | 10.00% | ||||||||||||||||||||||||||||||||||||||||||||||||||
37 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
38 | Observations | Observations | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
39 | 6003 | 6003 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
40 | Total cost increase across all 5 contracts was $5.986M (9.1%) | Original line items increased $207K in total (1.5%) | AA fees increased $1.25M (from 2.5% to 10.7% share of contract), $500K shifted from Hispanic SLBE. $200K from White non-LBE. Plus $500K of new line items | By original classification of specialty items, bid came in at 22.3% SLBE -- 2.7% short of SLBE requirement. | |||||||||||||||||||||||||||||||||||||||||||||||||||||
41 | White firms gained $2.5M in fees. Black firms gained $5.4M in fees. Hispanic firms lost $2M in fees. | New line items added $1,158K in total (8.5%). Split evenly between new utilities and new prime contractor fees | White firm fees increased $552K (lowering share from 78.1% to 74.7%). $550K increase in fees to prime | By revised classification of specialty items, bid would have come in at 27.5% of SLBE -- 2.5% above SLBE requirement. | |||||||||||||||||||||||||||||||||||||||||||||||||||||
42 | SLBE participation increased from 28.4% to 32.8%, by revised compliance standard, and was above threshold in both cases. | Hispanic fees dropped 437K (lowering share from 19.3% to 14.6%). All due to loss of trucking contract | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
43 | 6005 | 6005 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
44 | Original line items increased $418 in total (8%). Primarily from prime contractor fees. | AA fees increased $430K (from 3.8% to 10.9% share of contract), $225K shifted from Hispanic SLBE. $50K from White non-LBE. Plus $500K of new line items | By original classification of specialty items, bid came in at 2.6% SLBE -- 4.4% short of SLBE requirement. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
45 | New line items added $105K in total (2%) | White firm fees increased $315K (lowering share from 79.7% to 78.0%). $550K increase in fees to prime | By revised classification of specialty items, bid would have come in at 43.8% of SLBE -- 18.8% above SLBE requirement. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
46 | Hispanic fees dropped $221K (lowering share from 16.5% to 11.1%). All due to loss of trucking contract | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
47 | General | General | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
48 | Gallagher is able to shift fees between A&C and Prime. Illustrates the advantage they have in overall bidding | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
49 | They can shift money to specialty to benefit SBLE %, and they can reduce overall costs by lowering A&C profit to win bid | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
50 | City should exclude speciality items from lowest-bid selection, and put more scrutiny on specialty items | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||
51 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
52 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
53 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
54 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
55 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
56 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
57 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
58 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
59 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
60 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
61 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
62 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
63 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
64 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
65 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
66 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
67 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
68 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
69 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
70 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
71 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
72 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
73 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
74 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
75 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
76 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
77 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
78 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
79 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
80 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
81 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
82 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
83 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
84 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
85 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
86 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
87 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
88 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
89 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
90 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
91 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
92 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
93 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
94 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
95 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
96 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
97 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
98 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
99 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||
100 |