04224_BidTabFinal.xlsx
XLSX spreadsheet 28 KB Posted
- Attached to
- STATEWIDE CONTRACT WA|04224|w7249
- Contract number
- 04224
- Issued by
- Washington
About this file
The document is a bid tabulation spreadsheet for a multi-regional HVAC services contract, covering six geographic regions: Eastern, North Central, Northwest, Olympic, South Central, and Southwest. The competitive bidding process involved multiple vendors including Apollo, Carrier, Elite, Entek, Hermanson, JH Kelly, McKinstry, Pacific Facility Solutions, TRS West Coast, and Western Mechanical. The bid evaluation process considered labor and parts costs, with scoring across different regions and a standardized evaluation framework.
The contract appears to be an indefinite delivery vehicle for HVAC services, with vendors evaluated on labor rates (ranging from 26.071% to 392.364%) and parts markup percentages (ranging from 10% to 90%). Each region had multiple apparent successful bidders, with vendors like Apollo, Carrier, and others being selected for main and reserved awards. The scoring methodology included labor and parts evaluations out of 800 and 200 points respectively, with additional points for EO 18-03 compliance. Final total scores ranged from 0.00 for non-bidding companies to 890.000 for top performers, indicating a comprehensive and competitive selection process across different regional markets.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 04224_BidPkg_McKinstry.pdf | ||
| 04224_BidPrice_Apollo.xlsx | XLSX spreadsheet | |
| 04224_BidPrice_Elite.xlsx | XLSX spreadsheet | |
| 04224_BidPrice_McKinstry.xlsx | XLSX spreadsheet | |
| 04224_SoL_AMD_Q&A.pdf | ||
| 04224p.xlsx | XLSX spreadsheet | |
| 04224_BidPkg_JHKelly.pdf | ||
| 04224a.McKinstry.pdf | ||
| 04224c.McKinstry.pdf | ||
| 04224_BidPkg_Apollo.pdf | ||
| 04224_BidPkg_TRS.pdf | ||
| 04224_BidPrice_TRS.xlsx | XLSX spreadsheet | |
| 04224_BidPrice_WestCoast.xlsx | XLSX spreadsheet | |
| 04224_SoL_BidPkg.pdf | ||
| 04224c.Apollo.pdf | ||
| 04224c.WestCoast.pdf | ||
| 04224_BidPrice_JHKelly.xlsx | XLSX spreadsheet | |
| 04224c.JHKelly.pdf | ||
| 04224a.Apollo.pdf | ||
| 04224_BidPkg_Elite.pdf | ||
| 04224_BidPkg_WestCoast.pdf | ||
| 04224_BidPkg_Western.pdf | ||
| 04224_Sol_BidEX-C.xlsx | XLSX spreadsheet | |
| 04224c.Elite.pdf | ||
| 04224c.TRS.pdf | ||
| 04224c.WesternMech.pdf |
Show all 26
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Cost Factors
| Eastern Region | |||||||||||
| HVAC Services | Apollo | Carrier | Elite | Entek | Hermanson | JHKelly | McKinstry | Pacific Facility Solutions | TRS | West Coast | Western Mechanical |
| Subtotal for Labor | 134.250% | 392.364% | No Bid | No Bid | 183.833% | No Bid | 112.472% | No Bid | 40.714% | No Bid | No Bid |
| Subtotal for Parts | 14.000% | 10.000% | No Bid | No Bid | 25.000% | No Bid | 16.000% | No Bid | 90.000% | No Bid | No Bid |
| Evaluted Labor (out of 800 points) | 242.616 | 83.013 | No Bid | No Bid | 177.178 | No Bid | 289.594 | No Bid | 800.000 | No Bid | No Bid |
| Evaluated Parts (out of 200 points) | 142.857 | 200.000 | No Bid | No Bid | 80.000 | No Bid | 125.000 | No Bid | 22.222 | No Bid | No Bid |
| Final Bid Total | 385.473 | 283.013 | No Bid | No Bid | 257.178 | No Bid | 414.594 | No Bid | 822.222 | No Bid | No Bid |
| EO 18-03 | 50 | 50 | No Bid | No Bid | 50 | No Bid | 50 | No Bid | 50 | No Bid | No Bid |
| Total Score | 435.473 | 333.013 | 0.00 | 0.00 | 307.178 | 0.00 | 464.594 | 0.00 | 872.222 | 0.00 | 0.00 |
| Main Award Apparent Successful Bidder | X | X | |||||||||
| Reserved Award - Apparent Successful Bidder | |||||||||||
| North Central Region | |||||||||||
| HVAC Services | Apollo | Carrier | Elite | Entek | Hermanson | JHKelly | McKinstry | Pacific Facility Solutions | TRS | West Coast | Western Mechanical |
| Subtotal for Labor | 126.983% | 340.683% | No Bid | No Bid | 183.833% | No Bid | 118.643% | No Bid | 40.000% | No Bid | No Bid |
| Subtotal for Parts | 14.000% | 10.000% | No Bid | No Bid | 25.000% | No Bid | 16.000% | No Bid | 90.000% | No Bid | No Bid |
| Evaluted Labor (out of 800 points) | 252.002 | 93.929 | No Bid | No Bid | 174.071 | No Bid | 269.717 | No Bid | 800.000 | No Bid | No Bid |
| Evaluated Parts (out of 200 points) | 142.857 | 200.000 | No Bid | No Bid | 80.000 | No Bid | 125.000 | No Bid | 22.222 | No Bid | No Bid |
| Final Bid Total | 394.859 | 293.929 | No Bid | No Bid | 254.071 | No Bid | 394.717 | No Bid | 822.222 | No Bid | No Bid |
| EO 18-03 | 50 | 50 | No Bid | No Bid | 50 | No Bid | 50 | No Bid | 50 | No Bid | No Bid |
| Total Score | 444.859 | 343.929 | 0.00 | 0.00 | 304.071 | 0.00 | 444.717 | 0.00 | 872.222 | 0.00 | 0.00 |
| Main Award Apparent Successful Bidder | X | X | |||||||||
| Reserved Award - Apparent Successful Bidder | |||||||||||
| Northwest Region | |||||||||||
| HVAC Services | Apollo | Carrier | Elite | Entek | Hermanson | JHKelly | McKinstry | Pacific Facility Solutions | TRS | West Coast | Western Mechanical |
| Subtotal for Labor | 146.429% | 314.609% | No Bid | No Bid | 161.625% | 100.000% | 121.144% | 174.000% | 26.071% | 98.810% | 73.179% |
| Subtotal for Parts | 20.000% | 10.000% | No Bid | No Bid | 22.857% | 20.000% | 25.000% | 30.000% | 44.286% | 22.000% | 30.000% |
| Evaluted Labor (out of 800 points) | 142.436 | 66.294 | No Bid | No Bid | 129.044 | 208.568 | 172.165 | 119.867 | 800.000 | 211.080 | 285.011 |
| Evaluated Parts (out of 200 points) | 100.000 | 200.000 | No Bid | No Bid | 87.501 | 100.000 | 80.000 | 66.667 | 45.161 | 90.909 | 66.667 |
| Final Bid Total | 242.436 | 266.294 | No Bid | No Bid | 216.545 | 308.568 | 252.165 | 186.533 | 845.161 | 301.989 | 351.677 |
| EO 18-03 | 50 | 50 | No Bid | No Bid | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
| Total Score | 292.436 | 316.294 | 0.00 | 0.00 | 266.545 | 358.568 | 302.165 | 236.533 | 895.161 | 351.989 | 401.677 |
| Main Award Apparent Successful Bidder | X | X | |||||||||
| Reserved Award - Apparent Successful Bidder | |||||||||||
| Olympic Region | |||||||||||
| HVAC Services | Apollo | Carrier | Elite | Entek | Hermanson | JHKelly | McKinstry | Pacific Facility Solutions | TRS | West Coast | Western Mechanical |
| Subtotal for Labor | No Bid | 300.639% | 125.917% | No Bid | 161.625% | 100.000% | 118.402% | No Bid | 31.500% | 87.267% | No Bid |
| Subtotal for Parts | No Bid | 10.000% | 30.000% | No Bid | 25.000% | 20.000% | 25.000% | No Bid | 50.000% | 22.000% | No Bid |
| Evaluted Labor (out of 800 points) | No Bid | 83.821 | 200.132 | No Bid | 155.916 | 252.000 | 212.834 | No Bid | 800.000 | 288.769 | No Bid |
| Evaluated Parts (out of 200 points) | No Bid | 200.000 | 66.667 | No Bid | 80.000 | 100.000 | 80.000 | No Bid | 40.000 | 90.909 | No Bid |
| Final Bid Total | No Bid | 283.821 | 266.798 | No Bid | 235.916 | 352.000 | 292.834 | No Bid | 840.000 | 379.678 | No Bid |
| EO 18-03 | No Bid | 50 | 50 | No Bid | 50 | 50 | 50 | No Bid | 50 | 50 | No Bid |
| Total Score | 0.00 | 333.821 | 316.798 | 0.00 | 285.916 | 402.000 | 342.834 | 0.00 | 890.000 | 429.678 | 0.00 |
| Main Award Apparent Successful Bidder | X | X | |||||||||
| Reserved Award - Apparent Successful Bidder | X | ||||||||||
| South Central Region | |||||||||||
| HVAC Services | Apollo | Carrier | Elite | Entek | Hermanson | JHKelly | McKinstry | Pacific Facility Solutions | TRS | West Coast | Western Mechanical |
| Subtotal for Labor | 125.385% | 343.621% | No Bid | No Bid | 183.833% | No Bid | 109.664% | No Bid | 39.375% | No Bid | No Bid |
| Subtotal for Parts | 14.000% | 10.000% | No Bid | No Bid | 25.000% | No Bid | 16.000% | No Bid | 70.000% | No Bid | No Bid |
| Evaluted Labor (out of 800 points) | 251.226 | 91.671 | No Bid | No Bid | 171.351 | No Bid | 287.241 | No Bid | 800.000 | No Bid | No Bid |
| Evaluated Parts (out of 200 points) | 142.857 | 200.000 | No Bid | No Bid | 80.000 | No Bid | 125.000 | No Bid | 28.571 | No Bid | No Bid |
| Final Bid Total | 394.083 | 291.671 | No Bid | No Bid | 251.351 | No Bid | 412.241 | No Bid | 828.571 | No Bid | No Bid |
| EO 18-03 | 50 | 50 | No Bid | No Bid | 50 | No Bid | 50 | No Bid | 50 | No Bid | No Bid |
| Total Score | 444.083 | 341.671 | 0.00 | 0.00 | 301.351 | 0.00 | 462.241 | 0.00 | 878.571 | 0.00 | 0.00 |
| Main Award Apparent Successful Bidder | X | X | |||||||||
| Reserved Award - Apparent Successful Bidder | |||||||||||
| Southwest Region | |||||||||||
| HVAC Services | Apollo | Carrier | Elite | Entek | Hermanson | JHKelly | McKinstry | Pacific Facility Solutions | TRS | West Coast | Western Mechanical |
| Subtotal for Labor | 159.726% | 317.122% | 125.917% | 199.548% | 174.315% | 100.000% | 119.201% | No Bid | 35.000% | 93.452% | No Bid |
| Subtotal for Parts | 25.000% | 10.000% | 30.000% | 15.000% | 23.571% | 20.000% | 25.000% | No Bid | 58.571% | 22.000% | No Bid |
| Evaluted Labor (out of 800 points) | 175.300 | 88.294 | 222.369 | 140.317 | 160.629 | 280.000 | 234.897 | No Bid | 800.000 | 299.619 | No Bid |
| Evaluated Parts (out of 200 points) | 80.000 | 200.000 | 66.667 | 133.333 | 84.850 | 100.000 | 80.000 | No Bid | 34.147 | 90.909 | No Bid |
| Final Bid Total | 255.300 | 288.294 | 289.035 | 273.650 | 245.479 | 380.000 | 314.897 | No Bid | 834.147 | 390.528 | No Bid |
| EO 18-03 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | No Bid | 50 | 50 | No Bid |
| Total Score | 305.300 | 338.294 | 339.035 | 323.650 | 295.479 | 430.000 | 364.897 | 0.00 | 884.147 | 440.528 | 0.00 |
| Main Award Apparent Successful Bidder | X | X | |||||||||
| Reserved Award - Apparent Successful Bidder | X |
File details come from the government source that posted it. Updated .