18-05_Attachment 7_NG Supplier Bid Form.xls
XLS spreadsheet 438 KB Posted
- Attached to
- 18-05: Natural Gas Supply
- Solicitation number
- BD-18-1064-1064-02481-20743
- Issued by
- Middlesex County, Massachusetts
About this file
This document is a Supplier Bid Form for a Natural Gas Supply contract opportunity issued by MassBay Community College in Massachusetts. The RFP requests proposals from qualified Natural Gas suppliers to provide supply and related services for an estimated annual consumption of 12,559 DTH across 9 accounts, including a Central Steam Plant account with 6,628 DTH and 8 non-steam plant accounts with 5,932 DTH. The required service start date is December 2017, and the contract term options are 12, 24, 36, 48, and 60 months.
The bid form provides line items for suppliers to submit pricing for various contract term and product options, including Basis: Monthly Cashout - 0% Swing, Basis: Monthly Cashout - 10% Swing, and Basis: Full Requirements NYMEX + Basis (Fixed). Suppliers must include the $0.10/DTH CES fee in their pricing. The bid form also requires suppliers to provide information on their credit approval status for MassBay. This contract opportunity is open to all qualified Natural Gas suppliers, and the award will go to the responsive and responsible bidder whose proposal is most advantageous to MassBay.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 18-05_Attachment 5_Supplier Diversity Form.pdf | ||
| 18-05_Attachment 1_Standard Contract Form.doc | DOC document | |
| Massachusetts_Substitute_W9_Form.doc | DOC document | |
| Standard_Contract_Form.doc | DOC document | |
| Commonwealth_Terms_Conditions.doc | DOC document | |
| 18-05_NStar Usage.CSV | CSV file | |
| 18-05_Attachment 2_Commonwealth Terms and Conditions.doc | DOC document | |
| 18-05_Attachment 3_Contractor Authorized Signatory Listing.doc | DOC document | |
| 18-05_Attachment 4_W-9.doc | DOC document | |
| 18-05_Attachment 8_Supplier Checklist.docx | DOCX document | |
| RFP_18-05_Natural Gas Supply.docx | DOCX document | |
| 18-05_Attachment 6_Certificate of Good Faith.pdf | ||
| 18-05_NGrid Usage.xlsx | XLSX spreadsheet |
Show all 13
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
Supplier Bid Form
| Natural Gas Supplier Bid Form | |||||||||
| Customer Name | MassBay Community College | ||||||||
| Supplier Name | |||||||||
| Estimated Annual Consumption for all 9 accounts | 12,559 | ||||||||
| CES Fee $/DTH | $0.10 | ||||||||
| Required Start Date | Dec-17 | ||||||||
| Supplier Bids - All 9 accounts | CES fee included, in $/Dth | Leave cells below blank for NON BID terms & products | |||||||
| Check this box if the CES fee is NOT included in your bids ► | |||||||||
| TERMS requested | Cashout Adder | Liquidity point | Swing - Aggregate or Individual | ||||||
| Product: | 12 mo. | 24 mo. | 36 mo. | 48 mo. | 60 mo. | ||||
| Basis: Monthly Cashout - 0% Swing | |||||||||
| Basis: Monthly Cashout - 10% Swing | |||||||||
| Basis: Full Requirements | |||||||||
| NYMEX + Basis (Fixed): Monthly Cashout - 0% Swing | |||||||||
| NYMEX + Basis (Fixed): Monthly Cashout - 10% Swing | |||||||||
| NYMEX + Basis (Fixed): Full Requirements | |||||||||
| Estimated Annual Consumption for the Central Steam Plant | 6,628 | ||||||||
| CES Fee $/DTH | $0.10 | ||||||||
| Required Start Date | Dec-17 | ||||||||
| Supplier Bids - Central Steam Plant Account # 5072622612 | CES fee included, in $/Dth | Leave cells below blank for NON BID terms & products | |||||||
| Check this box if the CES fee is NOT included in your bids ► | |||||||||
| TERMS requested | Cashout Adder | Liquidity point | Swing - Aggregate or Individual | ||||||
| Product: | 12 mo. | 24 mo. | 36 mo. | 48 mo. | 60 mo. | ||||
| Basis: Monthly Cashout - 0% Swing | |||||||||
| Basis: Monthly Cashout - 10% Swing | |||||||||
| Basis: Full Requirements | |||||||||
| NYMEX + Basis (Fixed): Monthly Cashout - 0% Swing | |||||||||
| NYMEX + Basis (Fixed): Monthly Cashout - 10% Swing | |||||||||
| NYMEX + Basis (Fixed): Full Requirements | |||||||||
| Estimated Annual Consumption for the 8 NON-steam plant accounts | 5,932 | ||||||||
| CES Fee $/DTH | $0.10 | ||||||||
| Required Start Date | Dec-17 | ||||||||
| Supplier Bids - 8 NON-Steam plant accounts | CES fee included, in $/Dth | Leave cells below blank for NON BID terms & products | |||||||
| Check this box if the CES fee is NOT included in your bids ► | |||||||||
| TERMS requested | Cashout Adder | Liquidity point | Swing - Aggregate or Individual | ||||||
| Product: | 12 mo. | 24 mo. | 36 mo. | 48 mo. | 60 mo. | ||||
| Basis: Monthly Cashout - 0% Swing | |||||||||
| Basis: Monthly Cashout - 10% Swing | |||||||||
| Basis: Full Requirements | |||||||||
| NYMEX + Basis (Fixed): Monthly Cashout - 0% Swing | |||||||||
| NYMEX + Basis (Fixed): Monthly Cashout - 10% Swing | |||||||||
| NYMEX + Basis (Fixed): Full Requirements | |||||||||
| Approved | Pending | Declined | Identify Docs required, if necessary: | ||||||
| STATUS of SUPPLIER APPROVAL of CREDIT for MassBay | |||||||||
| Please note that both normalized and raw data are supplied. The raw data is as supplied by the local utility. Normalized data has been calculated on | |||||||||
| a monthly basis and missing data has been filled in according to a seasonal fill algorithm. | |||||||||
| Acknowledgement of Price Submittal | Acknowledgement of Addenda _____ to _______ | ||||||||
| Supplier Signature | Date | Supplier Signature | Date |
&L&D
CES FORM - Account Information
| CompanyName | ServiceAddress | ServiceCity | ServiceState | LDC | Account | Meter | RateClassCode | TCQ | TCQ_Units | Telemeterd | dtLastRead | UsageUnits | January | February | March | April | May | June | July | August | September | October | November | December | TotalUsage | TotalDTH | Organization | idCustomer | Salutation | FirstName | LastName | Title | MailingAddress | MailingCity | MailingState | MailingZip | Phone | Ext | Fax |
| MassBay Community College | 50 Oakland St | Wellesley | MA | NGRID Keyspan/Boston Gas | 5072622612 | 10111833 | G-43 | 854.166 | thm | 8/8/17 | thm | 13604.975 | 11146.625 | 12206.4193548387 | 6627.1520737327 | 708.4285714286 | 0 | 0 | 0 | 15.5806451613 | 2550.6096774194 | 7231.6294117647 | 12183.8705882353 | 66275.2903225806 | 6627.5290322581 | CES | 1038848 | Joseph | Delisle | 50 Oakland Street | Wellesley Hills | MA | 2481 | 7812393000 | |||||
| MassBay Community College | 19 Flagg Dr | Framingham | MA | NSTAR Gas | 10915850027 | X000659 | G42 | 3.6171 | thm | 8/17/17 | thm | 3202.8551617874 | 569.9661016949 | 2303.6164469554 | 5593.4259259259 | 799.6142857143 | 147.6 | 90.4642857143 | 65.7393171345 | 208.7272727273 | 730.8823529412 | 1758.5659229209 | 3396.1880877743 | 18867.6451612903 | 1886.764516129 | CES | 1038848 | Joseph | Delisle | 50 Oakland Street | Wellesley Hills | MA | 2481 | 7812393000 | |||||
| MassBay Community College | 50 Oakland St | Wellesley | MA | NGRID Keyspan/Boston Gas | 5072622630 | 5272237 | G-42 | 77.842 | thm | 8/4/17 | thm | 1409.8928571429 | 1274.3392857143 | 1506.0416666667 | 1136.8333333333 | 870.25 | 703.474137931 | 672.275862069 | 609.7860215054 | 693.3107526882 | 983.3655913979 | 1314.3523809524 | 1091.2071428571 | 12265.1290322581 | 1226.5129032258 | CES | 1038848 | Joseph | Delisle | 50 Oakland Street | Wellesley Hills | MA | 2481 | 7812393000 | |||||
| MassBay Community College | 250 Eliot St | Ashland | MA | NSTAR Gas | 10965530040 | S000968 | G42 | 22.216 | thm | 8/10/17 | thm | 2478.6752688172 | 1899.6284348865 | 2102.9108796296 | 1106.5118534483 | 316.8432601881 | 80.3636363636 | 0.6551724138 | 0.3448275862 | 13.0344827586 | 361.7586206897 | 1296.3887147335 | 2326.8848484848 | 11984 | 1198.4 | CES | 1038848 | Joseph | Delisle | 50 Oakland Street | Wellesley Hills | MA | 2481 | 7812393000 | |||||
| MassBay Community College | 270 Eliot St RT FR | Ashland | MA | NSTAR Gas | 10965260069 | S000448 | G41 | 9.47 | thm | 8/10/17 | thm | 1493.5043010753 | 1238.7956989247 | 1365.0520833333 | 764.5226293103 | 248.394984326 | 60.3636363636 | 0 | 0 | 26.6896551724 | 287.3448275862 | 821.9655172414 | 1349.3666666667 | 7656 | 765.6 | CES | 1038848 | Joseph | Delisle | 50 Oakland Street | Wellesley Hills | MA | 2481 | 7812393000 | |||||
| MassBay Community College | 50 Oakland St | Wellesley | MA | NGRID Keyspan/Boston Gas | 5072623290 | 6467173 | G-42 | 93.325 | thm | 8/5/17 | thm | 1149.9400921659 | 1023.5523809524 | 1173.4752688172 | 470.9677419355 | 314.1994134897 | 83.6980519481 | 13.4573732719 | 5.776344086 | 6.8688172043 | 87.2626728111 | 583.1919642857 | 928.8679435484 | 5841.2580645161 | 584.1258064516 | CES | 1038848 | Joseph | Delisle | 50 Oakland Street | Wellesley Hills | MA | 2481 | 7812393000 | |||||
| MassBay Community College | 50 Oakland St | Wellesley | MA | NGRID Keyspan/Boston Gas | 5072623140 | 6472963 | G-52 | 6.874 | thm | 8/5/17 | thm | 159.8824884793 | 188.7476190476 | 192.0795698925 | 195.4838709677 | 152.660801564 | 126.7067099567 | 154.7292626728 | 122.1322580645 | 121.6096774194 | 157.1105990783 | 161.8258928571 | 167.9344758065 | 1900.9032258065 | 190.0903225806 | CES | 1038848 | Joseph | Delisle | 50 Oakland Street | Wellesley Hills | MA | 2481 | 7812393000 | |||||
| MassBay Community College | 50 Oakland St | Wellesley | MA | NGRID Keyspan/Boston Gas | 5072623770 | 5368784 | G-41 | 21.279 | thm | 8/4/17 | thm | 139.3214285714 | 186.4821428571 | 191.7083333333 | 38.5 | 40.6666666667 | 10.6551724138 | 46.2781609195 | 7.3247311828 | 14.8387096774 | 16.9605734767 | 4.6412698413 | 82.2357142857 | 779.6129032258 | 77.9612903226 | CES | 1038848 | Joseph | Delisle | 50 Oakland Street | Wellesley Hills | MA | 2481 | 7812393000 | |||||
| MassBay Community College | 50 Oakland St | Wellesley | MA | NGRID Keyspan/Boston Gas | 5072622620 | 13088776 | G-43 | 0.121 | thm | 8/8/17 | thm | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16.6764705882 | 4.3235294118 | 21 | 2.1 | CES | 1038848 | Joseph | Delisle | 50 Oakland Street | Wellesley Hills | MA | 2481 | 7812393000 |
File details come from the government source that posted it. Updated .