7300123356Attachment03.xlsx

XLSX spreadsheet 51 KB Posted

Attached to
Services NY|23356|PS70438
Contract number
PS70438
Issued by
New York

About this file

This document is a quarterly contract usage reporting template for a state and local government contract vehicle, specifically related to the New York State Office of General Services (OGS). The report covers contract sales for Quarter 1 (January-March 2023) and involves multiple vendor classifications including Umbrella Contractors, Divisions, and Resellers. The reporting period saw 190 Umbrella Vendors, 4 Divisions, and 15 Resellers submit quarterly reports, with an additional 18 Umbrella Vendors, 0 Divisions, and 20 Resellers failing to submit reports.

The contract involves technology and consulting services, with detailed reporting requirements for sales across state agencies, SUNY/CUNY institutions, and non-state authorized users. The administrative fee structure includes a 0.10% surcharge remitted to contractors and a 0.75% fee remitted to OGS, with a total 15% payment calculated on sales. The reporting template mandates comprehensive transaction details including product descriptions, SKUs, pricing, authorized user information, and specific instructions for reporting different types of purchases such as software licenses, subscriptions, and consulting services. The contract covers a wide range of state and local entities, including New York State agencies, SUNY/CUNY institutions, and various municipal and state authorities.

View the file

Other files

File Type Posted
7300123356_AppendixC.pdf PDF
7300123356_AppendixA.pdf PDF
7300123356_AppendixB.pdf PDF
7300123356_AppendixD.pdf PDF
7300123356_AppendixE.pdf PDF
7300123356pm.pdf PDF
7300123356ra.pdf PDF
7300123356Attachment02.pdf PDF

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

Q Summary

Fill out column B for Contractors (Umbrella Vendors) who submitted directlyFill out column F for Divisions who submitted directly
(A Division is part of the Umbrella contractor's business that chooses to send in their reports separately from the prime Umbrella contractor.)Fill out column I for Resellers who submitted directly
sample answers below based on $115,000,000 in sales & 15% contractor feesample answers below based on $1,500,000 in sales & 15% contractor feesample answers below based on $3,000,000 in sales & 15% contractor fee
Quarter #1Quarter #1Quarter #1
Date RangeJan-Mar 2023Date RangeJan-Mar 2023Date RangeJan-Mar 2023
Vendor Classification
ContractorVendor Classification
DivisionVendor Classification
Reseller
Total Surcharge Remitted to Contractor from Division (.10%) (Division sales x .10%) (Contractor keeps this)$1,500Total Surcharge Remitted to Contractor from Reseller (.10%) (Reseller sales x .10%) (Contractor keeps this)$3,000
Total Fees Remitted to Contractor (.75%)
(by Umbrella Contractor) (sales x .75%)$862,500Total Fees Remitted to Contractor (.75%)

(by Umbrella Contractor Division) (sales x .75%) $11,250 Total Fees Remitted to Contractor (.75%) (by Umbrella Contractor Reseller)

(sales x .75%)$22,500
Total Monies OGS to pay Contractor (15%) (B7 x 15%)$129,375Total Monies OGS to Pay Contractor (15%) (F7 x 15%) (F8 + F6)$3,187.50Total Monies OGS to Pay Contractor (15%) (I7 x 15%) (I8 + I6)$6,375
Fees Remitted to OGS (B7 minus B8)$733,125Fees Remitted to OGS (F7 minus F8)$8,062.50Fees Remitted to OGS (I7 minus I8)$17,250
# of Umbrella Vendors that submitted quarterly report190# of Divisions that submitted quarterly report4# of Resellers that submitted quarterly report15
# of Umbrella Vendors that did not submit quarterly report18# of Divisions that did not submit quarterly report0# of Resellers that did not submit quarterly report20
sample answers below
TOTAL # of Reports received this quarter

Contractor/Division/Reseller

combined209
TOTAL # of Reports NOT received this quarter

Contractor/Division/Reseller combined 38

Did Contractor submit FULL fee owed to OGS for this quarter? yes

Non-Submittals Quarter Missing Contractor, Division, or Reseller, (Use company or division name of who is submitting) Contract # (PMxxxxx) Contact Name Contact Email Contact Phone Action Taken

Instructions Instructions: Contractor shall furnish OGS a report of all sales provided under the Contract on a quarterly basis, to be established by OGS utilizing “7300123356_Report of Contract Usage” template. Purchases by Non-State Agencies, political subdivisions and others authorized by law shall be reported in the same report and indicated as required. In order to uniformly and accurately record authorized user information, a drop-down list has been provided in Column Q which allows the contractor to select 'State', 'SUNY/CUNY' or 'Non-State' for each entity. For purchases made by a State Agency or SUNY/CUNY, Contractor must then select the entity name from the drop down list found in Column R. For purchases made by 'Non-State' authorized users, the entity name may be manually entered by the Contractor in Column S.

All fields of information shall be accurate and complete.

All Manufacturer Part Numbers (SKUs) in Column V must match the Manufacturer Part Numbers (SKUs) listed on the Contractor's Attachment 1 - Pricing.

The report is to be submitted electronically in Microsoft Excel format unprotected, via e-mail to the attention of the designated OGS Procurement Services Contract Administrator and shall reference the Group Number, Award Number, Contract Number, Sales Period, Contractor's Name and all other fields required. OGS reserves the right to amend the “7300123356_Report of Contract Usage” template or to require sales to be reported in a different format. Further, additional related sales information and/or detailed Authorized User purchases may be required by OGS and must be supplied upon request.

For Column X, Contractors should only add a Quantity other than "1" if the product has a specific time frequency (e.g. monthly license subscription, Consumption Cloud, # of hours for implementation, etc.). If there is no time frequency for a product or if it is an annual subscription purchase, then insert a "1" into Column X and leave Column Y blank.

For Columns AD & AE, Administrative Fee, please refer to Section 2.37 - Contract Administrative Fee of the Piggyback Contract.

Template Last Updated 07/17/24

&F &A

Template 2024

Template Last Updated7/17/2024
Contractor InfoTransaction/ PO InfoAuthorized User Contact Info
Status Designation (If Applicable)
contractor_name
(use company name of whomever is reporting sale)federal_id_numbernys_vendor_id_numberMBEWBEMWBESDVOBSBEdate_report_submittedcontractor_contact_namecontractor_contact_phone_numbercontractor_contact_emailcontract_numberquarter_endingorder_datepo_numberstate_SUNY_or_non_stateauthorized_user_entity
(State or SUNY)authorized_user_entity

(Non-State)

Manual Fill-inauthorized_user_zip_codeproduct_name_descriptionskuquantityTime Multiplier
(if Applicable - See Instructions tab)Time Measurement
(If Applicable - See Instructions tab)list_priceNYS Net Contract PriceAuthorized User Net Price per UnitExtended Authorized User PriceAdministrative Fee
per UnitExtended Administrative Feeauthorized_user_contact_nameauthorized_user_contact_emailauthorized_user_contact_phone
Tech Nology Inc.48-111111114099999996/30/2023Ben Franklin800-123-1234ben.franklin@basic.tech.comPSxxxxx6/30/20235/2/2023PO1111111StateDOL- Department of Labor11501Software License for "Fast Moving Services"3BA09046JA112months$ 1,940.00$ 1,940.00$ 1,940.00$ 23,280.0014.55174.60John Doejohn.doe@dol.ny.gov516-123-1234
Yook o'Clock50-021995014099999996/30/2023Five Somewhere888-007-6006yook@oclock.comPSxxxxx6/30/20235/2/2023PO1111111SUNY_CUNYSUNY Albany (University at Albany)12222Born to Research - 1 monthBTR-1M124weeks$ 321.00$ 321.00$ 321.00$ 7,704.002.4157.78Sami Bourne3x2@sami.com914-333-2222
Big Wave10-041994014099999996/30/2023Hang Ten877-111-3321agi@jagi.comPSxxxxx6/30/20235/2/2023PO1111111Non_State
(enter manually in Column S)Brooklyn Academy of Music11217YeJiApSa Consulting - AdvisorYJAS-C-A11years$ 1,004.00$ 1,004.00$ 1,004.00$ 1,004.007.537.53Melody Harmonymelody@btob.com347-321-2862
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0
$ - 0- 0- 0

&F &A mailto:john.doe@dol.ny.gov Updated AU List

Authorized User List State SUNY_CUNY Non_State (enter manually in Column S)

511NYAdirondack Community College
ABO- Authorities Budget OfficeBroome Community College, SUNY
AGM- Department of Agriculture and MarketsCayuga Community College
APA- Adirondack Park AgencyClinton Community College
Battery Park City AuthorityColumbia-Greene Community College
BFSA- Buffalo Fiscal Stability AuthorityCorning Community College
Board of ElectionsCUNY GRADUATE CENTER
Canal CorporationCUNY GRADUATE SCHOOL OF PUBLIC HEALTH AND HEALTH POLICY
CCF- Council on Children and FamiliesCUNY SCHOOL OF LABOR AND URBAN STUDIES
Central Pine Barrens Joint Planning and Policy CommissionCUNY SCHOOL OF PROFESSIONAL STUDIES
CJC- Commission on Judicial ConductDutchess Community College
CorcraftErie Community College
Council on the ArtsFashion Institution of Technology
CS- Department of Civil ServiceFinger Lakes Community College
DASNY- Dormitory AuthorityFulton-Montgomery Community College
DCJS- Division of Criminal Justice ServicesGenesee Community College
DDPC- Developmental Disabilities Planning CouncilHerkimer County Community College
DEC- Department of Environmental ConservationHudson Valley Community College
DFS- Department of Financial ServicesHUNTER COLLEGE
DHR- Division of Human RightsJamestown Community College
DHSES- Division of Homeland Security and Emergency ServicesJefferson Community College
Division of Consumer ProtectionKEUKA COLLEGE
Division of State PoliceKINGSBOROUGH COMMUNITY COLLEGE
DMNA- Division of Military and Naval AffairsLAGUARDIA COMMUNITY COLLEGE
DMV- Department of Motor VehiclesMACAULAY HONORS COLLEGE
DOB- Division of BudgetMEDGAR EVERS COLLEGE
DOCCS- Department of Corrections and Community SupervisionMid-Hudson Region Small Business Development Center
DOH- Department of HealthMohawk Valley Community College
DOL- Department of LaborMonroe Community College
DOS- Department of StateNEW YORK CITY COLLEGE OF TECHNOLOGY (CITY TECH)
DOT- Department of TransportationNiagara County Community College
DPS- Department of Public ServiceNorth Country Community College
DTA- Division of Tax Appeals and Tax Appeals TribunalOnondaga Community College
DTF- Department of Taxation and FinanceOrange County Community College
DVA- Veterans AffairsQUEENS COLLEGE
ECFSA-Erie County Fiscal Stability AuthorityQUEENSBOROUGH COMMUNITY COLLEGE
EFC- Environmental Facilities CorporationROCHESTER CITY SCHOOL DISTRICT
ERIE COUNTY - NYRockland Community College
ESD- Empire State DevelopmentSchenectady County Community College
Financial Control BoardSuffolk County Community College
Gaming CommissionSullivan County Community College
Geographic Information Systems ClearinghouseSUNY - CENTRAL ADMINISTRATION
GOER- Governor's Office of Employee RelationsSUNY - GENESEO
Governor's Traffic Safety CommitteeSUNY - ITEC
GUTTMAN COMMUNITY COLLEGESUNY Albany (University at Albany)
HCR- Homes and Community RenewalSUNY Alfred State (College of Ceramics)
HESC- Higher Education Services CorporationSUNY Alfred State (College of Technology)
HOSTOS COMMUNITY COLLEGESUNY Binghamton (Binghamton University)
Hudson River Park TrustSUNY Brockport
Hudson River Valley GreenwaySUNY Brooklyn Educational Opportunity Center
IG- Inspector GeneralSUNY Buffalo (University at Buffalo)
ITS - Information Technology ServicesSUNY Buffalo State
Javits CenterSUNY Canton (College of Technology at Canton)
JCOPE- Joint Commission on Public EthicsSUNY Capital District Opportunity Center
Justice Center for the Protection of People with Special NeedsSUNY Cobleskill (College of Agriculture & Technology)
Law Revision CommissionSUNY College of Optometry
LEHMAN COLLEGESUNY Cornell University (College of Agriculture & Life Sciences)
Liquidation BureauSUNY Cornell University (College of Human Ecology)
Liquor AuthoritySUNY Cornell University (College of Veterinary Medicine)
MTA - Metropolitan Transportation AuthoritySUNY Corning Community College
MTA Inspector GeneralSUNY Cortland
New York AssemblySUNY Delhi (College of Technology at Delhi)
New York State SenateSUNY Downstate Medical Center
NIFA- Nassau County Interim Finance AuthoritySUNY Empire State College
NY COUNTY DIST ATTORNEY OFFICESUNY EOC (Manhattan Educational Opportunity Center)
NY POWER AUTHORITYSUNY ESF (College of Environmental Science and Forestry)
NYC - DOITTSUNY Farmingdale State College
NYC 311SUNY Fredonia
NYC ADMINISTRATION FOR CHILDRENSUNY Maritime College
NYC COMPTROLLER'S OFFICESUNY Morrisville
NYC CYBER COMMANDSUNY New Paltz
NYC DEPT OF CITYWIDE ADMIN SVCS (DCAS)SUNY NYS School of Industrial & Labor Relations at Cornell
NYC DEPT OF CORRECTIONSSUNY Old Westbury
NYC DEPT OF DESIGN & CONSTRUCTIONSUNY Oneonta
NYC DEPT OF EDUCATIONSUNY Oswego
NYC DEPT OF ENVIRONMENTAL PROTECTIONSUNY Plattsburgh
NYC DEPT OF FINANCESUNY Polytechnical Institute (SUNY CNSE)
NYC DEPT OF HEALTH & MENTAL HYGIENESUNY Polytechnical Institute (SUNY IT)
NYC DEPT OF HOUSING PRESEVATION & DEVSUNY Potsdam
NYC DEPT OF PARKS & RECREATIONSUNY Purchase
NYC DEPT OF SANITATIONSUNY Research Institute on Addictions (@ University at Buffalo)
NYC DEPT OF SOCIAL SERVICESSUNY Small Business Development Corporation (Kingston)
NYC DEPT OF YOUTH & COMMUNITY DEVELOPMESUNY State University Plaza (System Administration)
NYC ECONOMIC DEVELOPMENTSUNY Stony Brook
NYC EMPLOYEE RETIREMENT SYSSUNY Stony Brook - Long Island State Veterans Home
NYC FISASUNY Stony Brook - University Hospital
NYC HEALTH & HOSPITAL CORPSUNY UNIVERSITY AT BUFFALO
NYC HOUSING AUTHORITYSUNY UPSTATE MEDICAL UNIVERSITY
NYC HUMAN RESOURCES ADMINSUNY UPSTATE MEDICAL UNIVERSITY - HOSPITAL PURCHASING
NYC LAW DEPARTMENTSUNY UPSTATE MEDICAL UNIVERSITY (HEALTH SCIENCES CENTER)
NYC OFFICE OF SCHOOL SUPPORT SERVICESTHE CITY COLLEGE OF NEW YORK
NYC POLICE DEPTTHRUWAY AUTHORITY
NYC SCHOOL CONSTRUCTION AUTHORITYTOMPKINS CORTLAND COMMUNITY COLLEGE
NYC SMALL BUSINESS SERVICESULSTER COUNTY COMMUNITY COLLEGE
NYC TAXI & LIMOUSINE COMMISSIONWESTCHESTER COMMUNITY COLLEGE
NYC TEACHERS' RETIREMENT SERVICEYORK COLLEGE
NYGOV
NYPA - New York Power Authority
NYS BOARD OF ELECTIONS
NYS DEPARTMENT OF PUBLIC SERVICE
NYS DEPT OF FINANCIAL SERVICES
NYS DEPT OF HEALTH
NYS DEPT OF LABOR
NYS DEPT OF MOTOR VEHICLES
NYS DIVISION OF BUDGET
NYS DORMITORY AUTHORITY
NYS EDUCATION DEPARTMENT
NYS ENERGY RESEARCH & DEVELOPMENT AUTH
NYS INSURANCE FUND
NYS METROPOLITAN TRANSIT AUTHORITY
NYS OFFICE OF ATTORNEY GENERAL
NYS OFFICE OF GENERAL SERVICES
NYS OFFICE OF IT SERVICES (ITS)
NYS OFFICE OF MENTAL HEALTH
NYS OFFICE OF THE COMPTROLLER
NYS PUBLIC SERVICE COMMISSION
NYS TEACHERS RETIREMENT SYSTEM
NYS THRUWAY AUTHORITY
NYS UNITED TEACHERS - UNION
NYS WORKERS COMPENSATION BOARD
NYSBA- Bridge Authority
NYSED- Department of Education
NYSERDA - NYS Energy Research and Development Authority
NYSIF- New York State Insurance Fund
NYSTRS- Teachers Retirement System
OAG- Office of The Attorney General
OASAS- Office of Alcoholism and Substance Abuse Services
OCFS- Office of Children and Family Services
OCT- Office of Counter Terrorism
OEM- Office of Emergency Management
OFA- Office for the Aging
Office of Fire Prevention and Control
Office of the Governor
OGS - Office of General Services
OIEC- Interoperable and Emergency Communications
OMH- Office of Mental Health
OMIG- Medicaid Inspector General
ONA- New Americans
OPDV- Office for the Prevention of Domestic Violence
OPRHP- Parks, Recreation and Historic Preservation
OPWDD- Office of People with Developmental Disabilities
ORDA- Olympic Regional Development Authority
OSC -Office of the State Comptroller
OTDA - Office of Temporary Disability Assistance
OVS- Office of Victim Services
OWIG- Office of the Welfare Inspector General
Port Authority of NY and New Jersey
RIOC- Roosevelt Island Operating Corporation
SCOC-Commission of Correction
SEFA - NYS Employees Federated Appeal
SONYMA- Housing Finance Agency/ State of NY Mortgage Agency
South Shore Estuary Council
SPECIAL FUNDS CONSERVATION COMMITTEE
SUCF- State University Construction Fund
SUNY- See SUNY
Thruway Authority
UNICEF - NY
Unified Court System
UNITED NATIONS - NY
UNITED NATIONS DEVELOPMENT
UNITED NATIONS DPKO
UNITED NATIONS POPULATION FUND (UNPFA)
WCB- Workers Compensation Board
WESTCHESTER COUNTY

File details come from the government source that posted it. Updated .