5-2-19 DNR WUP Treatment Worksheet Revised VERSION 3.xlsx
XLSX spreadsheet 11 KB Posted
- Solicitation number
- RFP 751 190000001931 3
- Issued by
- Huron County, Michigan
About this file
This is a DNR Water Use Program (WUP) Treatment Worksheet from the Michigan Department of Natural Resources outlining road treatment chemical application rates and quantities for multiple municipalities across a specified service area. The document specifies treatment requirements for three chemical options—Calcium Chloride, PEP (Polymerized Epichlorohydrin), and Magnesium Chloride—across 16 treatment sites located in communities including Watersmeet, Marenisco, Twin Lakes, Toivola, Atlantic Mine, South Range, Calumet, Dollar Bay, Iron River, Caspian, Crystal Falls, Lake Emily, Fortune Lakes, Beachwood, Scott Lake, and Swedetown. Treatment quantities are calculated based on application rates of 176 gallons per 0.1 mile for Calcium Chloride, 218 gallons per 0.1 mile for PEP, and 293 gallons per 0.1 mile for Magnesium Chloride, with individual site mileages ranging from 0.1 to 1 mile.
Annual treatment requirements total 11,158.40 gallons of Calcium Chloride, 13,821.20 gallons of PEP, or 18,576.20 gallons of Magnesium Chloride, with three-year contract totals of 33,475.20, 41,463.60, and 55,728.60 gallons respectively. The pricing structure indicates unit cost differences among the three chemical options, with Magnesium Chloride representing the highest-cost option and Calcium Chloride the lowest-cost option. The worksheet serves as a baseline for budgeting and procurement planning for the multi-year road dust control treatment program across the DNR service region.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP 19-1931 DNR Western U.P. Trail Dust Control.docx | DOCX document | |
| Standard Contract Terms.docx | DOCX document | |
| DNR Trail Dust Control - Revised Quantities.xlsx | XLSX spreadsheet | |
| DNR Western UP Trail Dust Control Pricing Schedule B.docx | DOCX document | |
| DNR Western UP Trail Dust Control Aerial Maps.pdf | ||
| DNR Western UP Trail Dust Control SOW Schedule A.docx | DOCX document |
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
Sheet1
| Calcium Chloride | PEP | Magnesium Choride | ||
| RATE GAL PER 0.1 MILE → | 176.00 | 218.00 | 293.00 | |
| MILES ↓ | ||||
| 0.3 | WATERSMEET | 528.00 | 654.00 | 879.00 |
| 1 | MARENISCO | 1,760.00 | 2,180.00 | 2,930.00 |
| 1 | TWIN LAKES | 1,760.00 | 2,180.00 | 2,930.00 |
| 0.2 | TOIVOLA | 352.00 | 436.00 | 586.00 |
| 0.1 | ATLANTIC MINE | 176.00 | 218.00 | 293.00 |
| 0.5 | SOUTH RANGE | 880.00 | 1,090.00 | 1,465.00 |
| 0.4 | CALUMET | 704.00 | 872.00 | 1,172.00 |
| 0.6 | DOLLAR BAY | 1,056.00 | 1,308.00 | 1,758.00 |
| 0.6 | IRON RIVER | 1,056.00 | 1,308.00 | 1,758.00 |
| 0.5 | CASPIAN | 880.00 | 1,090.00 | 1,465.00 |
| 0.34 | CRYSTAL FALLS - 3 SITES | 598.40 | 741.20 | 996.20 |
| 0.2 | LAKE EMILY | 352.00 | 436.00 | 586.00 |
| 0.25 | FORTUNE LAKES | 440.00 | 545.00 | 732.50 |
| 0.25 | BEACHWOOD - 2 SITES | 440.00 | 545.00 | 732.50 |
| 0.1 | SCOTT LAKE | 176.00 | 218.00 | 293.00 |
| 0.2 | SWEDETOWN | 352.00 | 436.00 | 586.00 |
| 6.54 | TOTALS PER YEAR | 11,158.40 | 13,821.20 | 18,576.20 |
| TOTALS FOR THREE YEARS | 33,475.20 | 41,463.60 | 55,728.60 |
File details come from the government source that posted it. Updated .