Awarded Salt Prices 22-23.xlsx

XLSX spreadsheet 43 KB Posted

Attached to
Wisconsin Road Salt 2022 - 2023
Contract number
395002-O17-0510464-000
Issued by
Wisconsin

About this file

This document is an awarded contracts spreadsheet for sodium chloride (road salt) procurement covering Wisconsin counties for the contract period of July 1, 2022 through April 30, 2023, with bids received on April 19, 2022. The procurement involves 72 Wisconsin counties with three competing vendors: Compass Minerals, Morton, and Cargill. The contract was awarded through TIPS (The Interlocal Purchasing System) cooperative purchasing program under contract number 510464, with bonds received totaling $15,078,348.63 for Compass Minerals, $17,084,765.61 for Morton, and $5,061,859.33 for Cargill.

The contract covers 903,485 total authorized tons of sodium chloride across all participating counties, with unit prices ranging from $69.90 to $125.04 per ton depending on the vendor and county. In the final awards, Compass Minerals received contracts for 675,659 tons totaling $54,702,045.34, while Morton was awarded contracts for 227,826 tons totaling $18,551,290.77. Cargill did not receive any contract awards despite submitting competitive bids. The total contract value across all awards is $73,253,336.11. Several counties have separate line items for "EFO" (Emergency Fuel Only) allocations, and pricing varies significantly by geographic region, with northern and central Wisconsin counties generally receiving higher unit prices than southeastern counties near major transportation corridors.

View the file

Other files

File Type Posted
23 - 24 Awarded Salt Prices_5.15.23 NB.pdf PDF
Awarded Salt Prices_07232024.xlsx XLSX spreadsheet
Awarded Salt Prices_6.4.25.pdf PDF

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

All Bids

Sodium Chloride - All Bids Received
Bid Date: 4/19/22
Contract Information - 7/1/22 - 4/30/23
Compass MineralsMortonCargill
TIPS Contract Number
Date Bond Received & Value$15,078,348.63$17,084,765.61$5,061,859.33
Delivery Terms
Cooperative Purchasing
Bid LineCountyAuthorized TonsUnit PriceExtended PriceUnit PriceExtended PriceUnit PriceExtended Price
1Adams5,230$99.86$522,267.80$118.20$618,186.00$109.91$574,829.30
2Florence3,075$90.13$277,149.75$116.23$357,407.25$0.00
3Forest5,100$88.89$453,339.00$114.84$585,684.00$0.00
4Green Lake3,814$95.38$363,779.32$94.60$360,804.40$95.55$364,427.70
5AIron (EFO)3,700$99.05$366,485.00$113.66$420,542.00$0.00
5BIron240$99.05$23,772.00$0.00$0.00
6Langlade5,900$90.53$534,127.00$95.22$561,798.00$95.19$561,621.00
7Lincoln5,640$94.53$533,149.20$117.05$660,162.00$107.22$604,720.80
8Marathon25,690$92.11$2,366,305.90$113.74$2,921,980.60$0.00
9Marquette4,717$92.88$438,114.96$116.13$547,785.21$105.16$496,039.72
10Menominee3,080$87.78$270,362.40$89.52$275,721.60$90.26$278,000.80
11Oneida6,700$91.31$611,777.00$119.25$798,975.00$0.00
12Portage13,519$85.69$1,158,443.11$112.18$1,516,561.42$0.00
13Price3,830$94.99$363,811.70$116.46$446,041.80$0.00
14Shawano10,570$78.24$826,996.80$85.11$899,612.70$0.00
15Vilas6,160$100.03$616,184.80$121.31$747,269.60$0.00
16Waupaca10,670$78.04$832,686.80$107.58$1,147,878.60$93.27$995,190.90
17Waushara2,680$95.92$257,065.60$99.81$267,490.80$98.37$263,631.60
18Wood12,932$91.50$1,183,278.00$117.14$1,514,854.48$0.00
19Brown42,405$70.96$3,009,058.80$99.53$4,220,569.65$0.00
20Calumet7,611$86.64$659,417.04$81.65$621,438.15$89.91$684,305.01
21Door7,850$90.49$710,346.50$83.41$654,768.50$92.64$727,224.00
22Fond Du Lac20,808$80.13$1,667,345.04$108.47$2,257,043.76$0.00
23Kewaunee6,100$85.24$519,964.00$83.79$511,119.00$89.34$544,974.00
24Manitowoc15,224$87.17$1,327,076.08$76.66$1,167,071.84$0.00
25Marinette16,245$70.80$1,150,146.00$82.12$1,334,039.40$0.00
26Oconto13,630$72.57$989,129.10$83.38$1,136,469.40$0.00
27Outagamie26,804$85.49$2,291,473.96$73.72$1,975,990.88$0.00
28Sheboygan18,749$87.73$1,644,849.77$90.22$1,691,534.78$0.00
29Winnebago18,020$76.81$1,384,116.20$82.91$1,494,038.20$0.00
30Kenosha28,030$84.21$2,360,406.30$73.45$2,058,803.50$0.00
31Milwaukee64,762$69.90$4,526,863.80$98.06$6,350,561.72$0.00
32Ozaukee12,205$70.09$855,448.45$78.63$959,679.15$90.62$1,106,017.10
33ARacine (EFO)8,000$77.08$616,640.00$85.34$682,720.00$88.21$705,680.00
33BRacine1,040$76.12$79,164.80$85.34$88,753.60$88.21$91,738.40
34Walworth17,917$72.65$1,301,670.05$79.76$1,429,059.92$0.00
35Washington23,979$79.89$1,915,682.31$86.28$2,068,908.12$0.00
36Waukesha69,850$71.33$4,982,400.50$99.67$6,961,949.50$0.00
37AAshland (EFO)1,750$93.34$163,345.00$108.07$189,122.50$97.78$171,115.00
37BAshland1,170$90.43$105,803.10$0.00$97.78$114,402.60
38Barron8,210$83.01$681,512.10$108.75$892,837.50$98.84$811,476.40
39Bayfield8,320$85.67$712,774.40$82.69$687,980.80$85.46$711,027.20
40ABuffalo (EFO)2,300$89.22$205,206.00$108.60$249,780.00$95.28$219,144.00
40BBuffalo1,122$88.33$99,106.26$96.94$108,766.68$95.28$106,904.16
41Burnett4,200$87.95$369,390.00$88.44$371,448.00$96.33$404,586.00
42Chippewa10,780$91.53$986,693.40$115.46$1,244,658.80$0.00
43Clark6,048$103.77$627,600.96$117.28$709,309.44$107.22$648,466.56
44Douglas9,250$80.58$745,365.00$74.22$686,535.00$75.81$701,242.50
45Dunn11,900$101.88$1,212,372.00$88.40$1,051,960.00$95.84$1,140,496.00
46Eau Claire12,900$95.01$1,225,629.00$108.64$1,401,456.00$99.56$1,284,324.00
47Jackson10,428$92.00$959,376.00$95.46$995,456.88$98.10$1,022,986.80
48Pepin1,180$98.08$115,734.40$91.81$108,335.80$95.82$113,067.60
49Pierce6,330$97.05$614,326.50$86.55$547,861.50$94.12$595,779.60
50Polk13,240$83.63$1,107,261.20$109.61$1,451,236.40$97.58$1,291,959.20
51Rusk2,860$92.76$265,293.60$115.17$329,386.20$0.00
52St Croix21,010$96.92$2,036,289.20$83.18$1,747,611.80$93.65$1,967,586.50
53Sawyer6,275$86.25$541,218.75$109.59$687,677.25$99.52$624,488.00
54Taylor3,776$104.87$395,989.12$125.04$472,151.04$111.32$420,344.32
55Trempealeau5,450$89.89$489,900.50$107.80$587,510.00$92.21$502,544.50
56Washburn8,450$86.68$732,446.00$83.57$706,166.50$90.99$768,865.50
57Columbia9,760$96.70$943,792.00$93.86$916,073.60$0.00
58ACrawford (EFO)1,100$97.12$106,832.00$87.74$96,514.00$0.00
58BCrawford570$96.08$54,765.60$87.74$50,011.80$0.00
59Dane50,789$82.50$4,190,092.50$90.55$4,598,943.95$0.00
60Dodge24,755$75.99$1,881,132.45$79.65$1,971,735.75$0.00
61AGrant (EFO)11,200$89.88$1,006,656.00$82.37$922,544.00$103.73$1,161,776.00
61BGrant2,310$96.64$223,238.40$82.37$190,274.70$103.73$239,616.30
62Green2,827$98.78$279,251.06$100.15$283,124.05$104.91$296,580.57
63Iowa6,755$99.41$671,514.55$85.17$575,323.35$104.52$706,032.60
64Jefferson8,830$82.18$725,649.40$87.12$769,269.60$96.78$854,567.40
65Juneau12,260$93.96$1,151,949.60$112.00$1,373,120.00$0.00
66ALa Crosse (EFO)7,700$92.44$711,788.00$80.18$617,386.00$0.00
66BLa Crosse3,470$92.38$320,558.60$80.18$278,224.60$0.00
67LaFayette4,150$97.59$404,998.50$85.27$353,870.50$103.98$431,517.00
68Monroe9,551$96.31$919,856.81$89.24$852,331.24$0.00
69Richland2,902$100.63$292,028.26$92.53$268,522.06$0.00
70Rock18,801$81.55$1,533,221.55$108.97$2,048,744.97$0.00
71Sauk9,845$97.47$959,592.15$119.20$1,173,524.00$0.00
72Vernon6,485$97.44$631,898.40$83.85$543,767.25$0.00
Contract Totals:$75,391,743.16$85,423,828.04$25,309,296.64

Total tons: 903,485

Award

Sodium Chloride - Awards
Bid Date: 4/19/22 510464
Contract Information - 7/1/22 - 4/30/23
Compass MineralsMortonCargillAward
TIPS Contract Number
Date Bond Received & Value$10,940,409.07$3,710,258.15$0.00$14,650,667.22
Delivery Terms
Cooperative PurchasingNoYes
Bid LineCountyAuthorized TonsUnit PriceExtended PriceUnit PriceExtended PriceUnit PriceExtended PriceVendorUnit PriceExtended Price
1Adams5,230$99.86$522,267.80$0.00$0.00Compass$99.86$522,267.80
2Florence3,075$90.13$277,149.75$0.00$0.00Compass$90.13$277,149.75
3Forest5,100$88.89$453,339.00$0.00$0.00Compass$88.89$453,339.00
4Green Lake3,814$0.00$94.60$360,804.40$0.00Morton$94.60$360,804.40
5AIron (EFO)3,700$99.05$366,485.00$0.00$0.00Compass$99.05$366,485.00
5BIron240$99.05$23,772.00$0.00$0.00Compass$99.05$23,772.00
6Langlade5,900$90.53$534,127.00$0.00$0.00Compass$90.53$534,127.00
7Lincoln5,640$94.53$533,149.20$0.00$0.00Compass$94.53$533,149.20
8Marathon25,690$92.11$2,366,305.90$0.00$0.00Compass$92.11$2,366,305.90
9Marquette4,717$92.88$438,114.96$0.00$0.00Compass$92.88$438,114.96
10Menominee3,080$87.78$270,362.40$0.00$0.00Compass$87.78$270,362.40
11Oneida6,700$91.31$611,777.00$0.00$0.00Compass$91.31$611,777.00
12Portage13,519$85.69$1,158,443.11$0.00$0.00Compass$85.69$1,158,443.11
13Price3,830$94.99$363,811.70$0.00$0.00Compass$94.99$363,811.70
14Shawano10,570$78.24$826,996.80$0.00$0.00Compass$78.24$826,996.80
15Vilas6,160$100.03$616,184.80$0.00$0.00Compass$100.03$616,184.80
16Waupaca10,670$78.04$832,686.80$0.00$0.00Compass$78.04$832,686.80
17Waushara2,680$95.92$257,065.60$0.00$0.00Compass$95.92$257,065.60
18Wood12,932$91.50$1,183,278.00$0.00$0.00Compass$91.50$1,183,278.00
19Brown42,405$70.96$3,009,058.80$0.00$0.00Compass$70.96$3,009,058.80
20Calumet7,611$0.00$81.65$621,438.15$0.00Morton$81.65$621,438.15
21Door7,850$0.00$83.41$654,768.50$0.00Morton$83.41$654,768.50
22Fond Du Lac20,808$80.13$1,667,345.04$0.00$0.00Compass$80.13$1,667,345.04
23Kewaunee6,100$0.00$83.79$511,119.00$0.00Morton$83.79$511,119.00
24Manitowoc15,224$0.00$76.66$1,167,071.84$0.00Morton$76.66$1,167,071.84
25Marinette16,245$70.80$1,150,146.00$0.00$0.00Compass$70.80$1,150,146.00
26Oconto13,630$72.57$989,129.10$0.00$0.00Compass$72.57$989,129.10
27Outagamie26,804$0.00$73.72$1,975,990.88$0.00Morton$73.72$1,975,990.88
28Sheboygan18,749$87.73$1,644,849.77$0.00$0.00Compass$87.73$1,644,849.77
29Winnebago18,020$76.81$1,384,116.20$0.00$0.00Compass$76.81$1,384,116.20
30Kenosha28,030$0.00$73.45$2,058,803.50$0.00Morton$73.45$2,058,803.50
31Milwaukee64,762$69.90$4,526,863.80$0.00$0.00Compass$69.90$4,526,863.80
32Ozaukee12,205$70.09$855,448.45$0.00$0.00Compass$70.09$855,448.45
33ARacine (EFO)8,000$77.08$616,640.00$0.00$0.00Compass$77.08$616,640.00
33BRacine1,040$76.12$79,164.80$0.00$0.00Compass$76.12$79,164.80
34Walworth17,917$72.65$1,301,670.05$0.00$0.00Compass$72.65$1,301,670.05
35Washington23,979$79.89$1,915,682.31$0.00$0.00Compass$79.89$1,915,682.31
36Waukesha69,850$71.33$4,982,400.50$0.00$0.00Compass$71.33$4,982,400.50
37AAshland (EFO)1,750$93.34$163,345.00$0.00$0.00Compass$93.34$163,345.00
37BAshland1,170$90.43$105,803.10$0.00$0.00Compass$90.43$105,803.10
38Barron8,210$83.01$681,512.10$0.00$0.00Compass$83.01$681,512.10
39Bayfield8,320$0.00$82.69$687,980.80$0.00Morton$82.69$687,980.80
40ABuffalo (EFO)2,300$89.22$205,206.00$0.00$0.00Compass$89.22$205,206.00
40BBuffalo1,122$88.33$99,106.26$0.00$0.00Compass$88.33$99,106.26
41Burnett4,200$87.95$369,390.00$0.00$0.00Compass$87.95$369,390.00
42Chippewa10,780$91.53$986,693.40$0.00$0.00Compass$91.53$986,693.40
43Clark6,048$103.77$627,600.96$0.00$0.00Compass$103.77$627,600.96
44Douglas9,250$0.00$74.22$686,535.00$0.00Morton$74.22$686,535.00
45Dunn11,900$0.00$88.40$1,051,960.00$0.00Morton$88.40$1,051,960.00
46Eau Claire12,900$95.01$1,225,629.00$0.00$0.00Compass$95.01$1,225,629.00
47Jackson10,428$92.00$959,376.00$0.00$0.00Compass$92.00$959,376.00
48Pepin1,180$0.00$91.81$108,335.80$0.00Morton$91.81$108,335.80
49Pierce6,330$0.00$86.55$547,861.50$0.00Morton$86.55$547,861.50
50Polk13,240$83.63$1,107,261.20$0.00$0.00Compass$83.63$1,107,261.20
51Rusk2,860$92.76$265,293.60$0.00$0.00Compass$92.76$265,293.60
52St Croix21,010$0.00$83.18$1,747,611.80$0.00Morton$83.18$1,747,611.80
53Sawyer6,275$86.25$541,218.75$0.00$0.00Compass$86.25$541,218.75
54Taylor3,776$104.87$395,989.12$0.00$0.00Compass$104.87$395,989.12
55Trempealeau5,450$89.89$489,900.50$0.00$0.00Compass$89.89$489,900.50
56Washburn8,450$0.00$83.57$706,166.50$0.00Morton$83.57$706,166.50
57Columbia9,760$0.00$93.86$916,073.60$0.00Morton$93.86$916,073.60
58ACrawford (EFO)1,100$0.00$87.74$96,514.00$0.00Morton$87.74$96,514.00
58BCrawford570$0.00$87.74$50,011.80$0.00Morton$87.74$50,011.80
59Dane50,789$82.50$4,190,092.50$0.00$0.00Compass$82.50$4,190,092.50
60Dodge24,755$75.99$1,881,132.45$0.00$0.00Compass$75.99$1,881,132.45
61AGrant (EFO)11,200$0.00$82.37$922,544.00$0.00Morton$82.37$922,544.00
61BGrant2,310$0.00$82.37$190,274.70$0.00Morton$82.37$190,274.70
62Green2,827$98.78$279,251.06$0.00$0.00Compass$98.78$279,251.06
63Iowa6,755$0.00$85.17$575,323.35$0.00Morton$85.17$575,323.35
64Jefferson8,830$82.18$725,649.40$0.00$0.00Compass$82.18$725,649.40
65Juneau12,260$93.96$1,151,949.60$0.00$0.00Compass$93.96$1,151,949.60
66ALa Crosse (EFO)7,700$0.00$80.18$617,386.00$0.00Morton$80.18$617,386.00
66BLa Crosse3,470$0.00$80.18$278,224.60$0.00Morton$80.18$278,224.60
67LaFayette4,150$0.00$85.27$353,870.50$0.00Morton$85.27$353,870.50
68Monroe9,551$0.00$89.24$852,331.24$0.00Morton$89.24$852,331.24
69Richland (EFO)2,902$0.00$92.53$268,522.06$0.00Morton$92.53$268,522.06
70Rock18,801$81.55$1,533,221.55$0.00$0.00Compass$81.55$1,533,221.55
71Sauk9,845$97.47$959,592.15$0.00$0.00Compass$97.47$959,592.15
72Vernon6,485$0.00$83.85$543,767.25$0.00Morton$83.85$543,767.25
Contract Totals:$54,702,045.34$18,551,290.77$0.00$73,253,336.11

Total tons: 903,485 Tons: 675,659 Tons: 227,826

File details come from the government source that posted it. Updated .