Exhibit B - Propane Pricing Bid Sheet (RFP 210000002160).xlsx
XLSX spreadsheet 26 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 covering service delivery across ten regional prosperity regions encompassing all 83 counties in the state. The bid sheet establishes estimated propane usage requirements based on median consumption over the previous five years, with total statewide estimated annual usage of 621,149.70 gallons and monthly usage of 51,762.48 gallons. The regions are geographically organized as follows: Western UP Prosperity Region (1a), Central UP Prosperity Region (1b), Eastern UP Prosperity Region (1c), Northwest Prosperity Region (2), Northeast Prosperity Region (3), West Central Prosperity Region (4a), West Michigan Prosperity Region (4b), East Central Michigan Prosperity Region (5), East Michigan Prosperity Region (6), South Central Prosperity Region (7), Southwest Prosperity Region (8), Southeast Michigan Prosperity Region (9), and Detroit Metro Prosperity Region (10). Each county-level entry includes specific monthly and annual usage estimates to provide bidders with detailed baseline consumption data for pricing proposals.
The bid sheet requires bidders to submit pricing across multiple cost categories including base price per gallon at terminal, terminal mark-up price per gallon, estimated yearly delivery costs exclusive of propane price, five-year estimated delivery costs exclusive of propane price, Sunday/emergency/after-hours incremental costs per gallon, terminal location, and annual pricing for remote monitoring systems per tank. All pricing columns are currently marked as zero, indicating this is a blank template awaiting bidder completion. The structure enables comparative analysis of propane supply proposals across all regional service areas with transparent consumption baseline data derived from historical usage patterns.
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 | ||
| Exhibit B - Propane Pricing Bid Sheet (RFP 210000002160) AD1.xlsx | XLSX spreadsheet | |
| 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 |
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 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 |
| Region | Counties | Estimated Monthly Usage/Gallons |
(Based on Median usage last 5 years) Estimated Yearly Usage/Gallons
| (Based on Median usage last 5 years) | "Base Price" Terminal | 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 | |||||||||
| 1a | BARAGA | 336.83 | 4,042.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1a | GOGEBIC | 213.28 | 2,559.40 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1a | HOUGHTON | 451.60 | 5,419.25 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1a | IRON | 1,238.42 | 14,861.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1a | KEWEENAW | 524.55 | 6,294.65 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1a | ONTONAGON | 1,959.21 | 23,510.55 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b - Central UP Prosperity Region | 3,864 | 46,369.80 | |||||||||
| 1b | ALGER | 521.21 | 6,254.50 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b | DELTA | 739.74 | 8,876.85 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b | DICKINSON | 180.24 | 2,162.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b | MARQUETTE | 483.78 | 5,805.40 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b | MENOMINEE | 519.50 | 6,234.05 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1b | SCHOOLCRAFT | 1,419.68 | 17,036.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1c - Eastern UP Prosperity Region | 2,895 | 34,745.05 | |||||||||
| 1c | CHIPPEWA | 771.84 | 9,262.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1c | LUCE | 1,533.12 | 18,397.40 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 1c | MACKINAC | 590.46 | 7,085.55 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 - Northwest Prosperity Region | 4,657 | 55,884.60 | |||||||||
| 2 | ANTRIM | 55.59 | 667.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | BENZIE | 126.58 | 1,518.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | CHARLEVOIX | 442.21 | 5,306.55 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | EMMET | 655.33 | 7,863.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | GRAND TRAVERSE | 137.41 | 1,648.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | KALKASKA | 150.15 | 1,801.85 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | LEELANAU | 94.39 | 1,132.70 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | MANISTEE | 1,095.69 | 13,148.25 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | MISSAUKEE | 217.77 | 2,613.30 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 2 | WEXFORD | 1,681.93 | 20,183.15 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 - Northeast Prosperity Region | 10,133 | 121,595.45 | |||||||||
| 3 | ALCONA | 133.32 | 1,599.85 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | ALPENA | 29.69 | 356.30 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | CHEBOYGAN | 481.75 | 5,780.95 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | CRAWFORD | 6,611.15 | 79,333.85 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | IOSCO | 134.85 | 1,618.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | MONTMORENCY | 28.64 | 343.70 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | OGEMAW | 995.24 | 11,942.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | OSCODA | 39.22 | 470.65 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | OTSEGO | 217.60 | 2,611.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | PRESQUE ISLE | 208.50 | 2,502.05 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 3 | ROSCOMMON | 1,252.98 | 15,035.80 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4a - West Central Prosperity Region | 1,769 | 21,226.35 | |||||||||
| 4a | LAKE | 43.97 | 527.60 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4a | MASON | 982.00 | 11,783.95 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4a | MECOSTA | 19.74 | 236.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4a | NEWAYGO | 193.73 | 2,324.75 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4a | OCEANA | 447.35 | 5,368.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4a | OSCEOLA | 82.08 | 984.95 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b - West Michigan Prosperity Region | 3,768 | 45,210.45 | |||||||||
| 4b | ALLEGAN | 529.27 | 6,351.25 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | BARRY | 462.88 | 5,554.60 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | IONIA | 1,227.00 | 14,723.95 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | KENT | 577.33 | 6,928.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | MONTCALM | 44.08 | 529.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | MUSKEGON | 879.58 | 10,554.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 4b | OTTAWA | 47.40 | 568.75 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 - East Central Michigan Prosperity Region | 3,102 | 37,219.75 | |||||||||
| 5 | ARENAC | 247.48 | 2,969.70 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | BAY | 637.24 | 7,646.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | CLARE | 47.21 | 566.50 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | GRATIOT | 1,681.50 | 20,178.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | ISABELLA | 59.77 | 717.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | MIDLAND | 47.33 | 567.95 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 5 | SAGINAW | 381.13 | 4,573.50 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 - East Michigan Prosperity Region | 2,288 | 27,458.15 | |||||||||
| 6 | GENESEE | 642.95 | 7,715.45 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 | HURON | 44.69 | 536.30 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 | LAPEER | 527.56 | 6,330.75 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 | SANILAC | 49.41 | 592.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 | SHIAWASSEE | 140.96 | 1,691.55 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 | ST CLAIR | 457.03 | 5,484.35 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 6 | TUSCOLA | 425.57 | 5,106.85 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 7 - South Central Prosperity Region | 907 | 10,878.00 | |||||||||
| 7 | CLINTON | 497.43 | 5,969.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 7 | EATON | 377.51 | 4,530.15 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 7 | INGHAM | 31.55 | 378.65 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 - Southwest Prosperity Region | 2,723 | 32,671.15 | |||||||||
| 8 | BERRIEN | 539.70 | 6,476.40 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 | BERRIEN COUNTY | 31.67 | 380.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 | BRANCH | 619.83 | 7,438.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 | CALHOUN | 551.10 | 6,613.15 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 | CASS | 234.68 | 2,816.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 | KALAMAZOO | 392.73 | 4,712.75 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 | ST JOSEPH | 45.16 | 541.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 8 | VAN BUREN | 307.73 | 3,692.75 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 - Southeast Michigan Prosperity Region | 5,532 | 66,379.60 | |||||||||
| 9 | HILLSDALE | 57.77 | 693.20 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 | JACKSON | 1,035.30 | 12,423.60 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 | LENAWEE | 342.54 | 4,110.50 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 | LIVINGSTON | 1,287.03 | 15,444.40 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 | MONROE | 835.67 | 10,028.00 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | ||
| 9 | WASHTENAW | 1,973.33 | 23,679.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 10 - Detroit Metro Prosperity Region | 5,402 | 64,824.50 | |||||||
| 10 | MACOMB | 157.26 | 1,887.10 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 10 | OAKLAND | 2,503.79 | 30,045.50 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| 10 | WAYNE | 2,740.99 | 32,891.90 | MB | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
Grand Total 51,762.48 621,149.70
File details come from the government source that posted it. Updated .