2007023260att08-report-of-contract-usage_rev_051322.xlsx
XLSX spreadsheet 64 KB Posted
- Contract number
- 23260
- Issued by
- New York
About this file
This document is a New York State Contract Usage Reporting Template (Solicitation 23260) for Books, Serials, Databases, and Library Resource Management Products. The template is designed for contractors to report detailed contract usage across four distinct lots, with the primary contracting entity being the New York State Office of General Services (OGS). The document provides a structured spreadsheet format for contractors to record procurement details, including purchase orders, authorized users, product information, and pricing metrics.
The contract covers multiple product categories including books, databases, library resources, and management products, with provisions for both perpetual access and subscription-based purchases. The reporting template allows for tracking key procurement metrics such as list prices, contract net prices, discounts (with a sample 24.99% discount demonstrated), and extended pricing. The document supports reporting across different library types and tiers, enabling granular tracking of purchases by various authorized users within the New York State government ecosystem. While specific contract values are not populated in the sample, the template is designed to capture comprehensive transactional data for contract compliance and spending analysis.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 2007023260p01.pdf | ||
| 2007023260att09-eo16_certification.pdf | ||
| 2007023260att06-biddersubmissionchecklist_rev_051322.xlsx | XLSX spreadsheet | |
| 2007023260att02-nys-required-certifications.pdf | ||
| 2007023260History.pdf | ||
| 2007023260att07-bidder-questions-form.xlsx | XLSX spreadsheet | |
| 2007023260att04-insurance-requirements_rev_051322.pdf | ||
| 2007023260i_solicitation_rev_05132022.pdf | ||
| 2007023260att05-bidderinformationquestionnaire_rev_051322.xlsx | XLSX spreadsheet | |
| 2007023260_bidinquiries.pdf | ||
| 2007023260att03-encouraging-use-of-nys-businesses.pdf | ||
| 2007023260att01-pricing_rev_051322.xlsx | XLSX spreadsheet | |
| 2007023260p.pdf | ||
| 2007023260ContractorInfo.pdf | ||
| 2007023260ra.pdf |
Show all 15
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 |
| Attachment 8 - Report of Contract Usage (Revised 05/13/2022) |
| SOLICITATION 23260 - BOOKS, SERIALS, DATABASES, AND LIBRARY RESOURCE MANAGEMENT PRODUCTS |
Enter your Contact information in the cells below. The information entered below will be prepopulated on the Contract Usage tab.
| Contractor Name: |
| NYS Contract Number: |
Contract Reporting Period (Dates):
| A Contractor must complete all non-shaded cells on the worksheet. 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 | |
| PO # | Number on Authorized User's purchase order |
| Order Date | Date Product was ordered (XX/XX/XXXX) |
| Contract # | Contractor's Contract Number |
| Pricelist Item Number | Item Number listed on Contractor's Pricelist (i.e. 1, Cloth Binding - Trade) |
| Authorized User | Authorized User placing purchase order with Contractor (i.e. DOT, OGS, Albany County, etc.) |
| ISBN/ISSN | International Standard Book Number or International Standard Serial Number |
| Perpetual Access or Subscription | The length of Authorized User's purchase. Include time-defined license purhcases as Subscription |
| SKU | Stock Keeping Unit number used for ordering |
| Library Type | Type of library Authorized User belongs to, as defined by Contractor's pricelist |
| Tier | Authorized User's tier, as defined by Contractor's pricelist |
| Item Description | Description of product |
| Publisher | Name of publisher, if applicable |
| 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 Price (List) | The Multiplied Value of Quantity and List Price |
| Contract Net Price | Unit Price of the product that an Authorized User will be invoiced |
| Contract Extended Price | The Multiplied Value of Quantity and Contract Net Price |
| % Discount off List | The percent difference between List Price and Contract Net Price |
23260 - Attachment 8 (Revised 05/13/2022) &A &P of &N
ContractUsage - Lot 1
| Contractor Name: | 0 |
| Lot Number: | 1 |
| Contract Reporting Period (Dates): | 0 |
| Contract Number: | 0 |
| PO # | Order Date (XX/XX/XXXX) | Contract # | Pricelist Item Number | Authorized User | ISBN/ISSN | Item Description | Publisher | Quantity | List Price | Extended Price (List) | % Discount off List Price | Contract Net Price | Net Handling Service Charge | Contract Extended Price | Product Category |
| Sample: 12-12345 | 6/1/2022 | PC12345 | 1 | Office of General Services | 978-1401210823 | The Absolute Sandman, Vol. 1 | Vertigo | 2 | $99.99 | $199.98 | 24.99% | $75.00 | $4.99 | $154.99 | 1 |
| 2 | |||||||||||||||
| 3 | |||||||||||||||
| 4 | |||||||||||||||
| 5 | |||||||||||||||
| 6 | |||||||||||||||
| 7 | |||||||||||||||
| 8 | |||||||||||||||
| 9 | |||||||||||||||
| 10 | |||||||||||||||
| 11 | |||||||||||||||
| 12 | |||||||||||||||
| 13 | |||||||||||||||
| 14 | |||||||||||||||
| 15 | |||||||||||||||
| 16 | |||||||||||||||
| 17 | |||||||||||||||
| 18 | |||||||||||||||
| 19 | |||||||||||||||
| 20 | |||||||||||||||
| 21 | |||||||||||||||
| 22 | |||||||||||||||
| 23 | |||||||||||||||
| 24 | |||||||||||||||
| 25a | |||||||||||||||
| 25b | |||||||||||||||
| 25c | |||||||||||||||
| 25d | |||||||||||||||
| 25e | |||||||||||||||
| 25f | |||||||||||||||
| 26 | |||||||||||||||
| 27 | |||||||||||||||
| 28 | |||||||||||||||
| 29 | |||||||||||||||
| 30 | |||||||||||||||
| 31 | |||||||||||||||
| 32 | |||||||||||||||
| 33 | |||||||||||||||
| 34a | |||||||||||||||
| 34b | |||||||||||||||
| 35 | |||||||||||||||
| 36 | |||||||||||||||
| 37 | |||||||||||||||
| 38 | |||||||||||||||
| 39 | |||||||||||||||
| 40 | |||||||||||||||
| 41 | |||||||||||||||
| 42 | |||||||||||||||
| 43 | |||||||||||||||
| 44a | |||||||||||||||
| 44b | |||||||||||||||
| 45 | |||||||||||||||
| 46 | |||||||||||||||
| 47 | |||||||||||||||
| 48 | |||||||||||||||
| 49 | |||||||||||||||
| 50 | |||||||||||||||
| 51 | |||||||||||||||
| 52 | |||||||||||||||
| 53 | |||||||||||||||
| 54 | |||||||||||||||
| 55 | |||||||||||||||
| 56a | |||||||||||||||
| 56b | |||||||||||||||
| 56c | |||||||||||||||
| 56d | |||||||||||||||
| 56e |
&A &P of &N
ContractUsage - Lot 2
| Contractor Name: | 0 |
| Lot Number: | 2 |
| Contract Reporting Period (Dates): | 0 |
| Contract Number: | 0 |
| PO # | Order Date (XX/XX/XXXX) | Contract # | Pricelist Item Number | Authorized User | ISBN/ISSN | Perpetual Access or Subscription | Item Description | Publisher | Quantity | List Price | Extended Price (List) | % Discount off List Price | Contract Net Price | Net Handling Service Charge | Contract Extended Price | Product Category | Perpetual or Subscription |
| Sample: 12-12345 | 6/1/22 | PC12345 | 1 | Office of General Services | 978-1401210823 | Perpetual Access | The Absolute Sandman, Vol. 1 | Vertigo | 2 | $99.99 | $199.98 | 24.99% | $75.00 | $4.99 | $154.99 | 1 | Perpetual Access |
| 2 | Subscription | ||||||||||||||||
| 3 | |||||||||||||||||
| 4 | |||||||||||||||||
| 5 | |||||||||||||||||
| 6 | |||||||||||||||||
| 7 | |||||||||||||||||
| 8 | |||||||||||||||||
| 9 | |||||||||||||||||
| 10 | |||||||||||||||||
| 11 | |||||||||||||||||
| 12 | |||||||||||||||||
| 13 | |||||||||||||||||
| 14 | |||||||||||||||||
| 15a | |||||||||||||||||
| 15b | |||||||||||||||||
| 15c |
&A &P of &N
ContractUsage - Lot 3
| Contractor Name: | 0 |
| Lot Number: | 3 |
| Contract Reporting Period (Dates): | 0 |
| Contract Number: | 0 |
| PO # | Order Date (XX/XX/XXXX) | Contract # | Authorized User | SKU | Library Type | Tier | Item Description | Quantity | List Price | Extended Price (List) | % Discount off List Price | Contract Net Price | Contract Extended Price |
| Sample: 12-12345 | 6/1/2022 | PC12345 | Office of General Services | ULTI123 | Other | 1 | The Ultimate Database of Everything | 2 | $99.99 | $199.98 | 24.99% | $75.00 | $150.00 |
&A &P of &N
ContractUsage - Lot 4
| Contractor Name: | 0 |
| Lot Number: | 4 |
| Contract Reporting Period (Dates): | 0 |
| Contract Number: | 0 |
| PO # | Order Date (XX/XX/XXXX) | Contract # | Authorized User | SKU | Library Type | Tier | Item Description | Quantity | List Price | Extended Price (List) | % Discount off List Price | Contract Net Price | Contract Extended Price |
| Sample: 12-12345 | 6/1/2022 | PC12345 | Office of General Services | ULTI123 | Other | 1 | The Ultimate Library Resource Management Product | 2 | $99.99 | $199.98 | 24.99% | $75.00 | $150.00 |
&A &P of &N
Sheet1
File details come from the government source that posted it. Updated .