7720023141_Attachment06.xlsx

Contractor Info-Instructions

(Two-Way Radios and Satellite Phones)

Please complete the fields indicated in yellow in the table below. This information will populate into the Detail and Summary sheets.

Period End Date:

Management Specialist:

Contractors must complete all non-shaded cells on the Contract Usage Report worksheet. The shaded cells perform automatic calculations based on the data entered and are locked or provide the Contractor with additional information in a read-only format. Only those cells provided for entering Sales information are to be accessed by the Contractor.

Column Name Column Header Instructions

A Contractor/Reseller Name Enter the name of the Contractor or Reseller.

B Federal ID of Contractor or Reseller Enter the Federal ID number of the Contractor or Reseller.

C Minority or Women Owned Business (MBE, WBE, MWBE, NA) Using the dropdown, select the value that best describes the Contractor or Reseller:

- MBE: Minority Owned Business

- WBE: Women Owned Business

- MWBE: Minority Women Owned Business

- NA: Not Applicable

D Service Disabled Veteran Owned Business?

(SDVOB)

(Y/N) Using the dropdown, select whether the Contractor or Reseller is a Service Disabled Veteran Owned Business (SDVOB).

E Small Business Enterprise?

(SBE)

(Y/N) Using the dropdown, select whether the Contractor or Reseller is a Small Business Enterprise (SBE).

- 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)

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.

I Purchase Order # Enter Purchase Order #. Only ONE Purchase Order # may be entered per line item.

J Purchase Order Date Enter Purchase Order Date.

K Invoice # Enter Invoice #, if available. Only ONE Invoice # may be entered per line item.

L Invoice Date Enter Invoice Date, if available.

M Manufacturer Name Enter the Manufacturer/Brand Name.

N Product Line Enter the Product Line Name as it appears in the Contractor's Contract Price List (Attachment 1 - NYS Pricing). Only ONE Product Line Name may be entered per line item.

O Product/Model Number Enter the Manufacturer's listed Product/Model Number as it appears in the Contractor's Contract Price List (Attachment 1 - NYS Pricing). Only ONE Product/Model Number may be entered per line item.

P Complete Product Description Insert the complete description of the Product/Model Number as it appears in the Contractor's Contract Price List (Attachment 1 - NYS Pricing).

Q Product Type Insert the Product Type of the Product/Model Number, as it appears in the Contractor's Contract Price List (Attachment 1 - NYS Pricing). (e.g. Radio, Cable, Battery, etc.)

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

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

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

U Additional Percent Discount (%) Enter any Additional Percent Discount offered. If none, enter 0%.

V NYS Contract Price - Column T will automatically populate once Columns Q, R, and S are complete. This column automatically calculates NYS Contract Price by multiplying the List Price/MSRP by the Contract Percent (%) Discount and the Additional Percent Discount (%). This column is locked and cannot be edited.

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

NYS Contract Price = (List Price/MSRP * (1-(Contract Percent Discount+Additional Percent Discount)) $75.00 = $100 * (1-(10%+15%)) In this case, the List Price/MSRP is $100; the Contract Percent (%) Discount is 10%; and the Additional Percent Discount is 15%.

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

W Total Percent Discount (%) - Column U will automatically populate once Columns R and S are complete. This column automatically calculates the Total Percent Discount based on the Contract Percent Discount (%) and the Additional Percent Discount (%). This column is locked and cannot be edited.

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

Total Percent Discount = (Contract Percent Discount + Additional Percent Discount) 25% = (10% + 15%) In this case, the Contract Percent Discount is 10%; and the Additional Percent Discount is 15%.

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

X Net Price - Column V will automatically populate once Columns P and T 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 $750.00 = 10 * $75.00 In this case, the Quantity is 10, and the NYS Contract Price is $75.00

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

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

Contract Usage Report Group 77200 Award 23141 - Public Safety Communications Equipment and Services (Two-Way Radios and Satellite Phones)

(SDVOB)

(Y/N) Small Business Enterprise?

(SBE)

(Y/N) Authorized User Type (Select) If 'Other,' skip Column G and manually enter Authorized User name in Column H.

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