5-2-19 DNR WUP Treatment Worksheet Revised VERSION 3.xlsx
XLSX spreadsheet 11 KB Posted
- Solicitation number
- RFP-751-190000001931-3
- Issued by
- Emmet County, Michigan
About this file
This is a pricing worksheet from the Department of Natural Resources (DNR) detailing dust control treatment rates and quantities for various locations. The worksheet outlines the application rates and total gallons needed for three different treatment options - Calcium Chloride, PEP, and Magnesium Chloride - across 16 different sites, with distances ranging from 0.1 to 1.0 miles per location. The total treatment distance is 6.54 miles.
The pricing structure shows per-unit rates of 176.00 gallons per 0.1 mile for Calcium Chloride, 218.00 gallons for PEP, and 293.00 gallons for Magnesium Chloride. The annual totals are calculated at 11,158.40 gallons for Calcium Chloride, 13,821.20 gallons for PEP, and 18,576.20 gallons for Magnesium Chloride. Three-year totals are projected at 33,475.20 gallons for Calcium Chloride, 41,463.60 gallons for PEP, and 55,728.60 gallons for Magnesium Chloride.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 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 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 | |
| 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 |
| 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 .