Exhibit B - Propane Pricing Bid Sheet (RFP 210000002160) AD1.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- Delivery of Liquid Propane Gas - Statewide
- Solicitation number
- RFP 171 210000002160 3
- Issued by
- Michigan
About this file
This is a propane pricing bid sheet for RFP 210000002160 issued by the State of Michigan to solicit bids for propane supply and delivery services across ten prosperity regions encompassing all Michigan counties. The procurement seeks propane supply for both customer-owned and vendor-owned tanks, with estimated annual usage of 621,149.70 gallons based on median consumption over the preceding five years. Bidders must provide pricing for base propane prices at terminal locations, mark-up prices per gallon for both tank types, estimated yearly and five-year delivery costs, emergency and after-hours surcharges per gallon, and remote monitoring system fees. The bid sheet is organized by region and county, detailing estimated monthly and yearly usage volumes specific to each geographic area and tank ownership category.
The bid sheet requires vendors to supply pricing for optional State-purchased above-ground propane tanks in 500-gallon and 1,000-gallon sizes, with separate pricing required for initial installation and replacement during the contract term. All tank pricing must be all-inclusive of purchase, delivery, hookup, installation, and necessary accessories. Bidders must identify the terminal location from which they will deliver propane and specify any non-standard tank sizes offered. The document establishes a framework for evaluating bids based on comprehensive pricing across multiple service components, geographic regions, and tank configurations, allowing the State to assess total cost of ownership across the full contract scope and service territory.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| RFP 210000002160 - Liquid Propane Gas (Questions and Answers) AD1.pdf | ||
| Exhibit A - Propane Delivery Locations and Historical Usage (RFP 210000002160).xlsx | XLSX spreadsheet | |
| AD 1 Instructions - Liquid Propane Gas AD1.pdf | ||
| RFP 210000002160 - Liquid Propane Gas AD1.docx | DOCX document | |
| Exhibit D - MDOC Vendor Handbook (RFP 210000002160).docx | DOCX document | |
| Exhibit E - PREA Standards (RFP 210000002160).docx | DOCX document | |
| RFP 210000002160 - Liquid Propane Gas.docx | DOCX document | |
| Exhibit B - Propane Pricing Bid Sheet (RFP 210000002160).xlsx | XLSX spreadsheet |
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
Exhibit B - Bid Sheet
| Exhibit B - Propane Pricing Bid Sheet | Bidder Name | ||||||||||||
| Column 1 | Column 2 | Column 3 | Column 4 | Column 4A | Column 4B | Column 5 | Column 6A | Column 6B | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 |
| Region | Counties | Total Estimated Monthly Usage/Gallons |
(Based on Median usage last 5 years) Total Estimated Yearly Usage/Gallons
(Based on Median usage last 5 years) Customer Owned Tank Estimated Yearly Usage/Gallons
(Based on Median usage last 5 years) Vendor Owned Tank Estimated Yearly Usage/Gallons
| (Based on Median usage last 5 years) | "Base Price" Terminal | Customer Owned Tank | ||||||||||
| Mark-Up Price per Gallon | Vendor Owned Tank | |||||||||||
| Mark-Up Price per Gallon | Estimated Yearly Cost for Delivery Only not including Propane Price Per Gallon | Five Year Estimated Cost for Delivery not including Propane Price Per Gallon | Sunday, Emergency or After-Hours Incremental Cost per Gallon | Location of Terminal that Bidder will be Delivering From | Price Per Tank for Remote Monitoring System Per Year | |||||||
| 1a - Western UP Prosperity Region | 4,724 | 56,686.85 | 6,425.65 | 50,261.20 | $ - 0 | |||||||
| 1a | BARAGA | 336.83 | 4,042.00 | 857.80 | 3,184.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1a | GOGEBIC | 213.28 | 2,559.40 | 1,288.00 | 1,271.40 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1a | HOUGHTON | 451.60 | 5,419.25 | 1,347.30 | 4,071.95 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1a | IRON | 1,238.42 | 14,861.00 | 848.20 | 14,012.80 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1a | KEWEENAW | 524.55 | 6,294.65 | 725.00 | 5,569.65 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1a | ONTONAGON | 1,959.21 | 23,510.55 | 1,359.35 | 22,151.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b - Central UP Prosperity Region | 3,864 | 46,369.80 | 17,846.25 | 28,523.55 | $ - 0 | |||||||
| 1b | ALGER | 521.21 | 6,254.50 | 771.10 | 5,483.40 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b | DELTA | 739.74 | 8,876.85 | 1,267.10 | 7,609.75 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b | DICKINSON | 180.24 | 2,162.90 | 714.50 | 1,448.40 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b | MARQUETTE | 483.78 | 5,805.40 | 3,031.25 | 2,774.15 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b | MENOMINEE | 519.50 | 6,234.05 | 1,283.75 | 4,950.30 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b | SCHOOLCRAFT | 1,419.68 | 17,036.10 | 10,778.55 | 6,257.55 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1c - Eastern UP Prosperity Region | 2,895 | 34,745.05 | 13,123.75 | 21,621.30 | $ - 0 | |||||||
| 1c | CHIPPEWA | 771.84 | 9,262.10 | 2,511.05 | 6,751.05 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1c | LUCE | 1,533.12 | 18,397.40 | 9,087.65 | 9,309.75 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1c | MACKINAC | 590.46 | 7,085.55 | 1,525.05 | 5,560.50 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 - Northwest Prosperity Region | 4,657 | 55,884.60 | 18,815.80 | 37,068.80 | $ - 0 | |||||||
| 2 | ANTRIM | 55.59 | 667.10 | 375.00 | 292.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | BENZIE | 126.58 | 1,518.90 | 201.90 | 1,317.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | CHARLEVOIX | 442.21 | 5,306.55 | 275.00 | 5,031.55 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | EMMET | 655.33 | 7,863.90 | 1,513.75 | 6,350.15 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | GRAND TRAVERSE | 137.41 | 1,648.90 | 289.90 | 1,359.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | KALKASKA | 150.15 | 1,801.85 | 1,542.35 | 259.50 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | LEELANAU | 94.39 | 1,132.70 | 492.55 | 640.15 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | MANISTEE | 1,095.69 | 13,148.25 | 9,763.60 | 3,384.65 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | MISSAUKEE | 217.77 | 2,613.30 | 265.70 | 2,347.60 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | WEXFORD | 1,681.93 | 20,183.15 | 4,096.05 | 16,087.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 - Northeast Prosperity Region | 10,133 | 121,595.45 | 58,022.10 | 63,573.35 | $ - 0 | |||||||
| 3 | ALCONA | 133.32 | 1,599.85 | 1,100.65 | 499.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | ALPENA | 29.69 | 356.30 | 356.30 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 3 | CHEBOYGAN | 481.75 | 5,780.95 | 1,449.90 | 4,331.05 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | CRAWFORD | 6,611.15 | 79,333.85 | 43,866.15 | 35,467.70 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | IOSCO | 134.85 | 1,618.20 | 548.10 | 1,070.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | MONTMORENCY | 28.64 | 343.70 | 343.70 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 3 | OGEMAW | 995.24 | 11,942.90 | 3,361.00 | 8,581.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | OSCODA | 39.22 | 470.65 | 470.65 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 3 | OTSEGO | 217.60 | 2,611.20 | 1,099.60 | 1,511.60 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | PRESQUE ISLE | 208.50 | 2,502.05 | 473.85 | 2,028.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | ROSCOMMON | 1,252.98 | 15,035.80 | 4,952.20 | 10,083.60 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4a - West Central Prosperity Region | 1,769 | 21,226.35 | 3,481.00 | 17,745.35 | $ - 0 | |||||||
| 4a | LAKE | 43.97 | 527.60 | 527.60 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 4a | MASON | 982.00 | 11,783.95 | 749.25 | 11,034.70 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4a | MECOSTA | 19.74 | 236.90 | 236.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 4a | NEWAYGO | 193.73 | 2,324.75 | 846.05 | 1,478.70 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4a | OCEANA | 447.35 | 5,368.20 | 777.35 | 4,590.85 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4a | OSCEOLA | 82.08 | 984.95 | 343.85 | 641.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b - West Michigan Prosperity Region | 3,768 | 45,210.45 | 18,333.45 | 26,877.00 | $ - 0 | |||||||
| 4b | ALLEGAN | 529.27 | 6,351.25 | 1,367.40 | 4,983.85 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | BARRY | 462.88 | 5,554.60 | 331.50 | 5,223.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | IONIA | 1,227.00 | 14,723.95 | 8,393.10 | 6,330.85 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | KENT | 577.33 | 6,928.00 | 1,855.20 | 5,072.80 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | MONTCALM | 44.08 | 529.00 | 350.10 | 178.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | MUSKEGON | 879.58 | 10,554.90 | 5,672.15 | 4,882.75 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | OTTAWA | 47.40 | 568.75 | 364.00 | 204.75 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 - East Central Michigan Prosperity Region | 3,102 | 37,219.75 | 30,846.85 | 6,372.90 | $ - 0 | |||||||
| 5 | ARENAC | 247.48 | 2,969.70 | 2,969.70 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 5 | BAY | 637.24 | 7,646.90 | 5,164.10 | 2,482.80 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | CLARE | 47.21 | 566.50 | 566.50 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 5 | GRATIOT | 1,681.50 | 20,178.00 | 19,428.00 | 750.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | ISABELLA | 59.77 | 717.20 | 717.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 5 | MIDLAND | 47.33 | 567.95 | 567.95 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 5 | SAGINAW | 381.13 | 4,573.50 | 1,433.40 | 3,140.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 - East Michigan Prosperity Region | 2,288 | 27,458.15 | 18,669.05 | 8,789.10 | $ - 0 | |||||||
| 6 | GENESEE | 642.95 | 7,715.45 | 6,615.05 | 1,100.40 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 | HURON | 44.69 | 536.30 | 536.30 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 6 | LAPEER | 527.56 | 6,330.75 | 5,132.65 | 1,198.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 | SANILAC | 49.41 | 592.90 | 592.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 6 | SHIAWASSEE | 140.96 | 1,691.55 | 371.70 | 1,319.85 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 | ST CLAIR | 457.03 | 5,484.35 | 5,087.20 | 397.15 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 | TUSCOLA | 425.57 | 5,106.85 | 333.25 | 4,773.60 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 7 - South Central Prosperity Region | 907 | 10,878.00 | 2,676.15 | 8,201.85 | $ - 0 | |||||||
| 7 | CLINTON | 497.43 | 5,969.20 | 5,969.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 7 | EATON | 377.51 | 4,530.15 | 2,313.50 | 2,216.65 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 7 | INGHAM | 31.55 | 378.65 | 362.65 | 16.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 - Southwest Prosperity Region | 2,723 | 32,671.15 | 18,977.05 | 13,694.10 | $ - 0 | |||||||
| 8 | BERRIEN | 539.70 | 6,476.40 | 2,181.30 | 4,295.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 | BERRIEN COUNTY | 31.67 | 380.00 | 380.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 8 | BRANCH | 619.83 | 7,438.00 | 7,438.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 8 | CALHOUN | 551.10 | 6,613.15 | 6,613.15 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 8 | CASS | 234.68 | 2,816.20 | 441.90 | 2,374.30 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 | KALAMAZOO | 392.73 | 4,712.75 | 912.10 | 3,800.65 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 | ST JOSEPH | 45.16 | 541.90 | 541.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |||
| 8 | VAN BUREN | 307.73 | 3,692.75 | 468.70 | 3,224.05 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 - Southeast Michigan Prosperity Region | 5,532 | 66,379.60 | 24,460.50 | 41,919.10 | $ - 0 | |||||||
| 9 | HILLSDALE | 57.77 | 693.20 | 406.40 | 286.80 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 | JACKSON | 1,035.30 | 12,423.60 | 4,055.60 | 8,368.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 | LENAWEE | 342.54 | 4,110.50 | 638.90 | 3,471.60 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 | LIVINGSTON | 1,287.03 | 15,444.40 | 7,138.00 | 8,306.40 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 | MONROE | 835.67 | 10,028.00 | - 0 | 10,028.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 | WASHTENAW | 1,973.33 | 23,679.90 | 12,221.60 | 11,458.30 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 10 - Detroit Metro Prosperity Region | 5,402 | 64,824.50 | 39,800.90 | 25,023.60 | $ - 0 | |||||
| 10 | MACOMB | 157.26 | 1,887.10 | 1,887.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| 10 | OAKLAND | 2,503.79 | 30,045.50 | 9,907.15 | 20,138.35 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 10 | WAYNE | 2,740.99 | 32,891.90 | 28,006.65 | 4,885.25 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Grand Total 51,762.48 621,149.70 271,478.50 349,671.20 $ - 0
Opt Tank Purchase & Install
| 500 Gallons | 500 Gallons | 1000 Gallons | 1000 Gallons | ____ Gallons | ____ Gallons | |
| Bidders shall provide pricing for the optional State purchase and installation of above ground propane tanks. | Purchase and Installation Price Per Tank at initial swap out - For New State Tank Purchase Only | Purchase and Installation Price Per Tank at after initial swap out is completed with leased tank - For New State Tank Purchase Only | Purchase and Installation Price Per Tank at initial swap out - For New State Tank Purchase Only | Purchase and Installation Price Per Tank at after initial swap out is completed with leased tank - For New State Tank Purchase Only | Purchase and Installation Price Per Tank at initial swap out - For New State Tank Purchase Only | Purchase and Installation Price Per Tank at after initial swap out is completed with leased tank - For New State Tank Purchase Only |
| 1a - Western UP Prosperity Region | ||||||
| 1b - Central UP Prosperity Region | ||||||
| 1c - Eastern UP Prosperity Region | ||||||
| 2 - Northwest Prosperity Region | ||||||
| 3 - Northeast Prosperity Region | ||||||
| 4a - West Central Prosperity Region | ||||||
| 4b - West Michigan Prosperity Region | ||||||
| 5 - East Central Michigan Prosperity Region | ||||||
| 6 - East Michigan Prosperity Region | ||||||
| 7 - South Central Prosperity Region | ||||||
| 8 - Southwest Prosperity Region | ||||||
| 9 - Southeast Michigan Prosperity Region | ||||||
| 10 - Detroit Metro Prosperity Region |
| Pricing shall be all inclusive (tank price, delivery, hookup, installation, accessories needed, etc.) |
| initial swap out - This will occur when the new vendor is initially replacing the incumbent vendor's tanks at the beginning of the contract |
| after initial swap out - This will occur after the new vendor has replaced the incumbent vendor's tanks. This pricing would apply during the base term of the contract |
| Please provide a description for any tank sizes you are proposing. |
File details come from the government source that posted it. Updated .