Filetype Excel XLSX | Posted on 08 Aug 2022 | 3 years ago
Authentication
digital resources
275x Filetype XLSX File size 0.06 MB Source: vendornet.wi.gov
Sheet 1: Overview
| State of Wisconsin |
| Electrical & Plumbing Maintenance, Repair, and Operations (MRO) Supplies Reporting |
| #28424-BLG |
| General Report Requirements: |
| →Reports must be received on or before Due Dates. |
| →All reports are required on the 15th of each month even if there is No Activity. Indicate "No Activity" somewhere on the spreadsheet. |
| →(Reporting Period = purchases for previous month) |
| →Return completed reports to Brooke.Gullick@wisconsin.gov via email. Subject line of email should read; E&P MRO Monthly Sales Report - (reporting month) |
| →All data columns on the report must be completed accurately when spend data is reported. |
| →Fill out the Reporting Data (e.g., Full Vendor Name, Reporting Period, etc. on the spreadsheet.) |
| →All State Agency spend including all University of Wisconsin campuses must be included on the same worksheet. A separate worksheet contained within the monthly excel report shall be submitted for municipality spend. |
| General Report Format: |
| →Enter only orders issued the previous month. (i.e., Report due January 15th will have December invoice dates reported.) |
| →Enter only one order date and one order number per line. |
| →Add rows to the bottom of report as necessary. |
| →The "Quantity per Unit of Measure" column should be filled out with integers only (e.g. for a pack of 2, enter only "2") |
| →All pricing ordinarily includes shipping. If additional shipping charges were levied, enter them as |
| a separate line item. |
| For Questions Regarding the Contract: |
| Brooke Gullick, Contract Manager |
| Brooke.Gullick@wisconsin.gov |
| Municipalities are also part of the Contract and are defined as any county, city, village town, school district, board of school |
| directors, sewer district, drainage district, vocational, technical and adult education district, or any other public body having the |
| authority to award public contracts (s. 16.70(8), Wis Stats.)and must also be included in the report. |
| Column A | Column B | Column C | Column D | Column E | Column F |
| Full Vendor Name | Reporting Period Start Date - End Date |
Telephone | Order Number | Order Date | Product Subcategory |
| Provide your company name | Provide date range for reporting period. Reporting period is for purchases made the previous month | Provide your telephone number |
Provide only one order number per line | Provide date order was placed | For each line item, list which subcategory (ie market basket tab; lamps/data cable, etc) the product falls under regardless of its Tier. If it doesn't fit in one of the tabbed categories, please indicate however it's commerically categorized. |
| This Form Filled Out By | P-Card Purchase (Y/N) | ||||
| Provide your name | Provide your email address | Indicate 'Y' for Yes, if a State Purchasing Pcard was used as method of payment. Indicate 'N' if No. | |||
| Name of Agency/University/ Municipality | Customer Account Number | ||||
| Use Acronyms tab to fill out name. For example of report sales for TAYCHEEDAH CORRECTIONAL INST, you would list them as DOC |
Account number linked to the person who made the purchase. | ||||
| Use all CAPS to keep the field uniform | |||||
| The use of generics such as STATE or UW are not acceptable. | |||||
| Keep naming convention for each municipality uniform throughtout life cycle of contract reporting; if reporting for BROWN CO HWY COMMISSION then always list as BROWN CO HWY COMMISSION,not occassionally as BROWN CO HIGHWAY COMM or any other variation. | |||||
| Column G | Column H | Column I | Column J | Column K | Column L |
| Product Tier (1, 2, or 3) | Manufacturer Name | Manufacturer SKU/Product # | Product Description | Contractor Product Number | Unit of Measure (UOM) |
| Indicate which Tier the product fall into. Tier 1 - if it is specifically listed on one of the tabs from the Market Basket categories Tier 2 - if discount from manufacturer's price list Tier 3 - if discount from contracter's price list |
Consistent Naming convention is required. | Provide Manufacturer SKU/Product # | Maintain consistent description for product each time it's listed throughout reporting for the lifecyle of contract. | Provide your contractor product number | Indicate in what quantity the product is sold. IE EA (each), FT (foot), PK (pack) |
| Column M | Column N | Column O | Column P | ||
| Cost to Contractor | End User Unit Price | Quantity Ordered | Extended Price (calculates automatically) |
||
| Inidcate what your purchase price is for the product listed on this line. | Inidcate the price the end user is paying for the product listed on this line. | Indicate quantity of UOM ordered. | You should not need to enter data into this field. This field should auto-populate once data is entered into columns F & G. |
| When filling out Column A - 'Name of Agency/University/ Municipality' (on Template Tabs) the following standardized naming convention in orange below should be used. | ||||||||||||||||||||
| State Agency Name | Acronym To Be Used | State Agency Name | Acronym To Be Used | Standardized naming to be used for University of Wisconsin Campus | Standardized naming to be used for University of Wisconsin Campus | |||||||||||||||
| BRD FOR PEOPLE WITH DEV. DISABILITIES | BPDD | DEPT OF WORKFORCE DEV. | DWD | UW BARABOO/SAUK CO | UW STEVENS POINT | |||||||||||||||
| BRD ON AGING & LONG TERM CARE | BALTC | DISTRICT ATTORNEYS | DA | UW BARRON CO | UW STOUT | |||||||||||||||
| CHILD ABUSE & NEGLECT PREVENTION BRD | CANPB | EDUCATIONAL COMMUNICATIONS BRD | ECB | UW COLLEGES | UW SUPERIOR | |||||||||||||||
| CIRCUIT COURTS | COURTS | EMPLOYMENT RELATIONS COMMISSION | WERC | UW EAU CLAIRE | UW WASHINGTON CO | |||||||||||||||
| COMMISSIONER OF INSURANCE | OCI | FOX RIVER NAV SYSTEM AUTHORITY | FRSA | UW EXTENSION | UW WAUKESHA | |||||||||||||||
| COMMISSIONERS OF PUBLIC LANDS | PLCOMM | GOVERNORS OFFICE | GOV | UW FOND DU LAC | UW WHITEWATER | |||||||||||||||
| CORT OF APPEALS | APPEALS | HOUSING AND ECONOMIC DEV AUTH. | WHEDA | UW FOX VALLEY | ||||||||||||||||
| DEPT OF ADMINISTRATION | DOA | INVESTMENT BRD | INV | UW GREEN BAY | ||||||||||||||||
| DEPT OF AGRICULTURE, TRADE & CONSUMER PROTECTION | DATCP | LEGISLATURE | LEG | UW LA CROSSE | ||||||||||||||||
| DEPT OF CHILDREN & FAMILIES | DCF | LIEUTENANT GOVERNORS OFFICE | LTGOV | UW MADISON | ||||||||||||||||
| DEPT OF CORRECTIONS | DOC | LOWER WI STATE RIVERWAY BRD | LWSR | UW MANITOWOC | ||||||||||||||||
| DEPT OF EMPLOYEE TRUST FUNDS | ETF | MEDICAL COLLEGE OF WISCONSIN | MEDCOLLG | UW MARATHON CO | ||||||||||||||||
| DEPT OF FINANCIAL INSTITUTIONS | DFI | PUBLIC DEFENDER BRD | PDB | UW MARINETTE | ||||||||||||||||
| DEPT OF HEALTH SERVICES | DHS | PUBLIC SERVICE COMMISSION | PSC | UW MARSHFIELD/WOOD CO | ||||||||||||||||
| DEPT OF JUSTICE | DOJ | SECRETARY OF STATE | SOS | UW MILWAUKEE | ||||||||||||||||
| DEPT OF MILITARY AFFAIRS | DMA | STATE EMPLOYMENT RELATIONS | SER | UW OSHKOSH | ||||||||||||||||
| DEPT OF NATURAL RESOURCES | DNR | STATE FAIR PARK BRD | SFP | UW PARKSIDE | ||||||||||||||||
| DEPT OF PUBLIC INSTRUCTION | DPI | STATE HISTORICAL SOCIETY | SHS | UW PLATTEVILLE | ||||||||||||||||
| DEPT OF REVENUE | DOR | SUPREME COURT | SUPREME | UW RICHLAND | ||||||||||||||||
| DEPT OF SAFETY & PROFESSIONAL SRVS | DSPS | TREASURER | OST | UW RIVER FALLS | ||||||||||||||||
| DEPT OF TOURISM | TOURISM | WI ECONOMIC DEV CORP | WEDC | UW ROCK CO | ||||||||||||||||
| DEPT OF TRANSPORTATION | DOT | WISCONSIN TECHNICAL COLLEGE SYSTEM | WTCS | UW SHEBOYGAN | ||||||||||||||||
| DEPT OF VETERANS AFFAIRS | DVA | |||||||||||||||||||
no reviews yet
Please Login to review.
