2310623185RCU.xlsx

Instructions

Please complete the fields below. The information entered below will be prepopulated on the Contract Usage tab.

Instructions for Completing Attachment 3

A Contractor must complete all non-shaded cells on the Contract Usage Report 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.

B Federal ID of Contractor or Reseller Enter the Contractor's contract number for this award

C Authorized User Type (Select) If 'Other,' skip Column D and manually enter Authorized User name in Column E.

Using the dropdown, select the value that best describes the Authorized User:

- STATE: NYS Entity (see NYS Entities worksheet to determine which Authorized Users are considered NYS Entities)

- SUNY: State University of New York (see SUNY Schools worksheet to determine which Authorized Users are considered SUNY)

- CUNY: City University of New York (see CUNY Schools worksheet to determine which Authorized Users are considered CUNY)

- OTHER: Other Authorized User (Nonstate Entities, non-SUNY, non-CUNY)

D Authorized User Name - State, SUNY, CUNY (Selection) Refer to 'NYS Entities,' 'SUNY Schools,' 'CUNY Schools' worksheets. If the Authorized User is a NYS Entity, SUNY, or CUNY, select a name from the dropdown.

IMPORTANT:

- For all NYS Entities (excluding SUNY and CUNY), enter the Entity's name as it appears on the NYS Entities worksheet.

- For all SUNY Schools, enter the name as it appears on the SUNY Schools worksheet.

- For all CUNY Schools, enter the name as it appears on the CUNY Schools worksheet.

F Contractor's Invoice # Enter the invoice number on Contractor's invoice to ordering entity.

G Invoice Date Enter the date on Contractor's invoice to ordering entity.

H Ordering Entity PO # Enter the number on ordering entity's purchase order.

I Lot Choose Lot from drop down menu.

J Product Category Choose the category, from the drop down menu, that the product is in (ie. 3D Printing, Science Laboratory and Teaching. Supplies, etc.)

K Contractor's Part/Stock # Enter the Part/Stock number used for ordering.

L Item Description Enter the Description of part/stock product.

M Manufacturer Name Enter the Manufacturer of the Item purchased.

N Manufacturer's Part # Enter 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 ‘Contractor's Part/Stock #’ and ‘Manufacturer’s Part #’ fields’

O Unit of Measure Enter the packing size of product (Each or Package)

P Quantity Enter the quantity of Products purchased in the unit/amount the Product/Model Number is sold (e.g. 5 each, 12 pounds, etc.).

Q List Price/MSRP ($) Enter the List Price/MSRP for each Product from the Manufacturer's Price List with List Price/MSRP.

R Contract Percent Discount (%) Enter the Contract Percent (%) Discount for the Product.

S NYS Contract Price - Column R will automatically populate once Columns P and Q are complete. This column automatically calculates the Total Percent Discount based on the difference between the List Price/MSRP and the NYS Contract Price. This column is locked and cannot be edited.

The following is an example of how the Total Percent Discount is calculated:

Total Percent Discount = (List Price/MSRP - NYS Contract Price) / 100 24% = ($100 - $76.50) / 100 In this case, the List Price/MSRP is $100; and the NYS Contract Price is $76.50.

Do not attempt to change this formula, as this may result in the Contractor's Report of Usage being rejected.

T Net Price - Column S will automatically populate once Columns O and R are complete. This column automatically calculates the Net Price by multiplying the Quantity of Product(s) purchased by the NYS Contract Price. This column is locked and cannot be edited.

The following is an example of how the Net Price is calculated:

Net Price = Quantity * NYS Contract Price $765.00 = 10 * $76.50 In this case, the Quantity is 10, and the NYS Contract Price is $76.50

For Instructions for SUNY School Names, see SUNY Schools worksheet.

For Instructions for CUNY School Names, see CUNY Schools worksheet.

GROUP 23106 - STEM/STEAM and Science Laboratory Educational Supplies and Equipment

&F Page &P of &N

Contract Usage

If 'Other,' skip Column D and manually enter Authorized User name in Column E.

Authorized User Name - State, SUNY, CUNY (Selection)

Group 23106 - STEM/STEAM and Science Laboratory Educational Supplies and Equipment

Award 23185 &P of &N

NYS Entities

http://511ny.org/http://www.scoc.ny.gov/http://www.corcraft.org/webapp/wcs/stores/servlet/TopCategoriesDisplay?langId=-1&storeId=10001&catalogId=10051https://www.ny.gov/agencies/council-children-and-familieshttps://www.arts.ny.gov/https://www.agriculture.ny.gov/https://www.cs.ny.gov/http://www.doccs.ny.gov/https://www.ny.gov/agencies/department-educationhttp://www.dec.ny.gov/index.htmlhttps://www.dfs.ny.gov/https://apa.ny.gov/http://www.health.ny.gov/http://www.labor.ny.gov/http://dmv.ny.gov/http://www.dps.ny.gov/http://www.dos.ny.gov/http://www.tax.ny.gov/https://www.dot.ny.gov/http://ddpc.ny.gov/https://www.dos.ny.gov/consumerprotection/http://dcjs.ny.gov/https://www.abo.ny.gov/http://www.dhses.ny.gov/https://dhr.ny.gov/http://dmna.ny.gov/https://www.troopers.ny.gov/http://www.dta.ny.gov/http://www.budget.ny.gov/http://www.veterans.ny.gov/http://www.dasny.org/http://esd.ny.gov/https://www.nyserda.ny.gov/https://bpca.ny.gov/http://www.efc.ny.gov/http://www.ecfsa.state.ny.us/http://www.fcb.state.ny.us/http://gaming.ny.gov/https://gis.ny.gov/gisdata/http://www.goer.ny.gov/http://www.safeny.ny.gov/http://www.hesc.ny.gov/content.nsfhttp://www.nyshcr.org/http://www.sonyma.org/http://www.elections.ny.gov/http://www.hudsonriverpark.org/https://hudsongreenway.ny.gov/https://www.javitscenter.com/http://www.jcope.ny.gov/http://www.justicecenter.ny.gov/http://www.nylb.org/http://www.sla.ny.gov/http://www.mta.info/http://mtaig.state.ny.us/http://www.nifa.state.ny.us/http://www.nysba.state.ny.us/http://assembly.state.ny.us/http://www.nysif.com/http://www.lawrevision.state.ny.us/http://www.nysenate.gov/http://nyc.gov/311http://www.canals.ny.gov/http://www.newamericans.ny.gov/http://www.opwdd.ny.gov/http://www.aging.ny.gov/http://www.opdv.ny.gov/http://www.bfsa.state.ny.us/http://www.oasas.ny.gov/http://www.ag.ny.gov/https://ocfs.ny.gov/http://www.dhses.ny.gov/oct/http://www.dhses.ny.gov/oem/http://www.dhses.ny.gov/ofpc/http://www.ogs.ny.gov/http://www.its.ny.gov/http://www.dhses.ny.gov/oiec/https://www.omig.ny.gov/http://pb.state.ny.us/http://www.omh.ny.gov/https://parks.ny.gov/https://www.osc.state.ny.us/https://otda.ny.gov/http://www.governor.ny.gov/http://ig.state.ny.us/http://www.owig.state.ny.us/http://www.ovs.ny.gov/http://www.orda.org/corporate/http://www.panynj.gov/http://www.cjc.ny.gov/http://www.nypa.gov/http://rioc.ny.gov/https://www.dec.ny.gov/lands/31847.htmlhttp://www.sefanys.org/http://www.sucf.suny.edu/http://www.nystrs.org/http://www.thruway.ny.gov/index.shtmlhttp://www.wcb.ny.gov/index.jsp SUNY Schools

http://www.sunyacc.edu/http://www.canton.edu/https://www.cayuga-cc.edu/http://www.clinton.edu/http://www.cobleskill.edu/http://www.sunycgcc.edu/https://cals.cornell.edu/http://www.human.cornell.edu/http://www.ilr.cornell.edu/http://www.vet.cornell.edu/https://www.corning-cc.edu/https://www.albany.edu/http://www.cortland.edu/http://www.delhi.edu/http://www.downstate.edu/http://www.sunydutchess.edu/https://www.esc.edu/http://www.esf.edu/http://www.ecc.edu/http://www.farmingdale.edu/http://www.fitnyc.edu/http://www.flcc.edu/https://alfred.edu/academics/colleges-schools/college-ceramics/index.cfmhttp://www.fredonia.edu/http://www.fmcc.edu/http://www.genesee.edu/http://www.geneseo.edu/http://www.herkimer.edu/http://www.hvcc.edu/http://www.sunyjcc.edu/http://www.sunyjefferson.edu/http://www.sunymaritime.edu/http://www.mvcc.edu/http://www.alfredstate.edu/http://www.monroecc.edu/http://www.morrisville.edu/http://www.ncc.edu/http://www.newpaltz.edu/http://www.niagaracc.suny.edu/http://www.nccc.edu/http://www.oldwestbury.edu/http://www.oneonta.edu/http://www.sunyocc.edu/https://www.sunyopt.edu/https://www.binghamton.edu/http://www.sunyorange.edu/http://www.oswego.edu/http://www.plattsburgh.edu/http://www.potsdam.edu/https://www.purchase.edu/http://www.sunyrockland.edu/http://www.sunysccc.edu/https://www.stonybrook.edu/http://www.sunysuffolk.edu/http://www.sunysullivan.edu/https://www.brockport.edu/https://sunypoly.edu/http://www.tompkinscortland.edu/http://www.sunyulster.edu/http://www.upstate.edu/http://www.sunywcc.edu/http://www.suny.edu/http://www.sunybroome.edu/http://www.buffalo.edu/http://www.buffalostate.edu/ CUNY Schools

http://www.baruch.cuny.edu/http://www.citytech.cuny.edu/https://www.qc.cuny.edu/https://sps.cuny.edu/https://www.york.cuny.edu/https://www.bmcc.cuny.edu/http://www.bcc.cuny.edu/http://www.hostos.cuny.edu/http://guttman.cuny.edu/http://www.kbcc.cuny.edu/http://www.laguardia.cuny.edu/http://www.brooklyn.cuny.edu/http://www.qcc.cuny.edu/https://www.journalism.cuny.edu/http://sph.cuny.edu/https://www.gc.cuny.edu/Homehttp://www.cuny.edu/http://law.cuny.edu/https://www.ccny.cuny.edu/https://www.csi.cuny.edu/http://www.hunter.cuny.edu/http://www.jjay.cuny.edu/http://www.lehman.cuny.edu/https://macaulay.cuny.edu/https://ares.mec.cuny.edu/ Sheet1