23137bid_attachment08.xlsx
XLSX spreadsheet 38 KB Posted
- Contract number
- 23137-GR
- Issued by
- New York
About this file
This document is a New York State contract usage reporting template for a statewide contract (Contract 05302) for Photovoltaic Systems and Installation Services. The contract appears to be structured across two primary lots: Lot 1 covering PV Systems and Lot 2 focusing on Installation Services. The template is designed for contractors to report contract usage, with fields for tracking purchases by authorized users such as state agencies, departments (e.g., DOT), and local government entities.
The contract encompasses multiple product categories including Packaged Photovoltaic Systems, Solar Modules, Racking Systems, Inverters, Charge Controllers, Battery Packs, and Ancillary Products. The reporting template includes detailed tracking mechanisms for pricing, including list prices, contract prices, and percentage discounts. There are specific provisions for capturing diversity and inclusion data, with fields to identify NYS Certified Minority/Women-owned Business Enterprises (M/WBE) and Service-Disabled Veteran-Owned Businesses (SDVOB). The document provides a comprehensive framework for reporting contract usage, capturing transaction details such as invoice numbers, purchase orders, quantities, manufacturers, and system specifications for photovoltaic-related products and services.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 23137bid_attachment12.docx | DOCX document | |
| 23137bid_attachment04.docx | DOCX document | |
| 23137bid_attachment02.docx | DOCX document | |
| 23137bidtracked.pdf | ||
| 0530223137AppendixD.docx | DOCX document | |
| 23137bid_attachment07.xlsx | XLSX spreadsheet | |
| 0530223137HowToUse.pdf | ||
| 23137bid_attachment09.docx | DOCX document | |
| 23137bid_attachment11.xlsx | XLSX spreadsheet | |
| 0530223137ra.pdf | ||
| 23137bid_attachment10.docx | DOCX document | |
| 23137bid_prebidwebinar.pdf | ||
| 23137bid_appendixa.pdf | ||
| 23137bid_attachment05.xlsx | XLSX spreadsheet | |
| 23137bid_appendixd.docx | DOCX document | |
| 23137updates.pdf | ||
| 23137bid_qna.pdf | ||
| 23137bid_appendixc.docx | DOCX document | |
| 23137bid_attachment01.xlsx | XLSX spreadsheet | |
| 0530223137InsuranceRequirements.pdf | ||
| 23137bid_mwbe-sdvob.pdf | ||
| 23137bid_attachment03.docx | DOCX document | |
| 0530223137p.pdf | ||
| 23137bid_appendixb.pdf | ||
| 23137bid.pdf | ||
| 23137bid_attachment06.xlsx | XLSX spreadsheet |
Show all 26
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
Instructions
| NEW YORK STATE |
| Report of Contract Usage |
| Award 23137 - xxxx |
Enter your contact information in the cells below. The information entered below will be prepopulated on the Contract Usage tab.
A Contractor must complete all non-shaded cells on the workbook The shaded cells perform automatic calculations of the data entered and are locked or provide the Contractor with additional information in a read-only format. All other cells are read-only. Only those cells provided for entering Sales information are to be accessed by the Contractor.
| Contract Usage Sheet | |
| Contractor's Invoice # | Invoice number on contractor's invoice to ordering entity |
| Invoice Date | Date on contractor's invoice to ordering entity |
| Ordering Entity PO # | Number on ordering entity's purchase order |
| Product Category | Category name of the products awarded by OGS (i.e., Packaged Solar Systems, Solar Modules (solar panels), and Racking Systems). Choose category in drop down |
| Authorized User Organization Name | Authorized User placing purchase order with contractor (i.e.. DOT, OGS, Albany County, etc.) |
| Contractor's Part/Stock # | Part/Stock used for ordering |
| Item Description | Description of part/stock product |
| System Size (kW, DC) | The capacity of the PV system |
| Manufacturer Name | Manufacturer of the item purchased |
| Manufacturer's Part No. | The manufacturer’s unique identifier assigned to the item, which consists of alphanumeric characters. Examples of manufacturer’s part numbers include Product Order Codes, ID Numbers, Model Numbers and Catalog Numbers. Should the Manufacturer’s Model Number and Part Number be identical, then this information should be listed in both the ‘Manufacturer’s Model Number’ and ‘Manufacturer’s Part Number’ fields’ |
| Unit of Measure | Packing size of product |
| Quantity | Quantity purchased by the authorized user for the term of the reporting period |
| List Price (Unit Price) | Price published in the catalog for the item purchased |
| Extended List Price | The multiplied value of quantity and list price |
| NYS Contract Price (Unit Price) | Unit price of the product that an authorized user will be invoiced |
| Extended Contract Price | The multiplied value of quantity and NYS contract price |
| % Discount off List | The percent difference between list price and NYS contract price |
| Reseller/Distributor/Dealer | Name of the approved reseller/distributor/dealer that sold a contract item to an authorized user |
| NYS Certified M/WBE | Contractor to answer "Yes/No" if reseller/distributor/dealer is a NYS Certified M/WBE |
| NYS Certified SDVOB | Contractor to answer "Yes/No" if reseller/distributor/dealer is a SDVOB |
GROUP No 05302 - Photovoltaic Systems and Installation Services (Statewide)
&F Page &P of &N
Lot 1 - PV Systems
| Contractor Name: |
| Catalog Name: |
| Contract Reporting Period (Dates): |
| Contract Number: |
| Contractor's Invoice # | Invoice Date | Ordering Entity PO # | Product Category | Authorized User Organization Name | Contractor's Part/Stock # | Item Description | Manufacturer Name | Manufacturer's Part # | Unit of Measure | Quantity | List Price (Unit Price) | Extended List Price | NYS Contract Price | |||||||
| (Unit Price) | Extended Contract Price | % Discount off List Price | Reseller/Distributor/Dealer (if applicable) | NYS Certified M/WBE | NYS Certified SDVOB | Product Categories | ||||||||||||||
| Sample: ABC123 | 10/1/15 | 12-12345 | Packaged Solar Systems | DOT | A1234 | Claw Hammer | Acme Co. | 4567B | each | 2 | $ 17.00 | $ 34.00 | $ 13.50 | $ 27.00 | 21% | Road Runner Inc. | Yes | No | Packaged Photovoltaic Systems | |
| Solar Modules | ||||||||||||||||||||
| Racking Systems | ||||||||||||||||||||
| Inverters | ||||||||||||||||||||
| Charge Controllers | ||||||||||||||||||||
| Battery Packs | ||||||||||||||||||||
| Ancillary Products | ||||||||||||||||||||
| Miscellaneous Photovoltaic Products |
05302 - Photovoltaic Systems and Installation Services (Statewide)
Award XXXXX &P of &N
Lot 2 - Installation Services
| Contractor Name: |
| Contract Reporting Period (Dates): |
| Contract Number: |
| Contractor's Invoice # | Invoice Date | Ordering Entity PO # | Invoice Amount | Product Category | Authorized User Organization Name | Authorized User Contact Name | Authorized User Contact Phone Number | Authorized User Contact Email | Region | Item Description | System Size | ||||
| (kW, DC) | Name of Subcontractor used for Installation Services (if applicable) | NYS Certified M/WBE | NYS Certified SDVOB | ||||||||||||
| Sample: ABC123 | 10/1/15 | 12-12345 | $15,000 | Installation Services | NYSDOT | John Doe | 123-456-789 | Jdoe@NYSDOT | 1 | 1 | 50 | PV Support Services | Yes | No | |
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services | |||||||||||||||
| Installation Services |
05302 - Photovoltaic Systems and Installation Services (Statewide)
Award XXXXX &P of &N mailto:Jdoe@NYSDOT Data Validation
| Packaged Solar Systems | Yes |
| Solar Modules (Solar Panels) | No |
| Racking Systems | |
| Inverters | |
| Charger Controllers | |
| Battery Packs | |
| Ancillary Products | |
| Miscellaneous Solar Products |
Sheet1
File details come from the government source that posted it. Updated .