DNR Trail Dust Control - Revised Quantities.xlsx
XLSX spreadsheet 11 KB Posted
- Solicitation number
- RFP-751-190000001931-3
- Issued by
- Emmet County, Michigan
About this file
This is a spreadsheet from the Department of Natural Resources (DNR) detailing dust control treatment quantities and rates for various trail locations. The document outlines the application rates and quantities of three dust control substances - Calcium Chloride, PEP, and Magnesium Chloride - across 15 different trail locations spanning 6.34 total miles. The treatment locations include Watersmeet, Marenisco, Twin Lakes, Toivola, Atlantic Mine, South Range, Calumet, Dollar Bay, Iron River, Caspian, Crystal Falls (3 sites), Lake Emily, Fortune Lakes, Beachwood (2 sites), and Scott Lake, with individual segments ranging from 0.1 to 1.0 miles in length.
The pricing structure shows application rates per 0.1 mile at 176.00 gallons for Calcium Chloride, 218.00 gallons for PEP, and 293.00 gallons for Magnesium Chloride. The total annual quantities required are 11,158.40 gallons of Calcium Chloride, 13,821.20 gallons of PEP, and 18,576.20 gallons of Magnesium Chloride. The document indicates a three-year total requirement of 33,475.20 gallons of Calcium Chloride, 41,463.60 gallons of PEP, and 55,728.60 gallons of Magnesium Chloride.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| DNR Western UP Trail Dust Control Pricing Schedule B.docx | DOCX document | |
| DNR Western UP Trail Dust Control SOW Schedule A.docx | DOCX document | |
| RFP 19-1931 DNR Western U.P. Trail Dust Control.docx | DOCX document | |
| Standard Contract Terms.docx | DOCX document | |
| 5-2-19 DNR WUP Treatment Worksheet Revised VERSION 3.xlsx | XLSX spreadsheet | |
| DNR Western UP Trail Dust Control Aerial Maps.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
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 |
| 6.34 | 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 .