36C24C19Q0036-0001003.xlsm

Overview & Instructions

Medical Surgical Prime Vendor (MSPV) 2.0 Price Quote Sheet

OPTOMETRY (OP)

Overview This workbook contains a quote sheet for suppliers to use to quote items under MSPV 2.0. Prospective Suppliers should quote medical/surgical supplies from their catalog appropriate to the VA recognized Product Category. This workbook also contains a detailed list of VA historically-used medical/surgical supplies from Calendar Year 2018 that suppliers can use for reference purposes to inform supply quotes.

The MSPV Supply procurement is organized into multiple Product Categories, which are all being solicited separately under Open Market solicitation. Suppliers shall only quote items under the relevant Product Category, as defined by VHA. Quote sheets with supplies quoted in the wrong category may be returned and recommended for submission in other Product Category solicitations or may not be evaluated.

Workbook tabs This quote sheet workbook contains 4 separate tabs:

Overview & Instructions OP Historical Data - VA historical 12-month usage for MSPV medical/surgical supplies (from CY 2018) OP Quoted Supplies - Quoted supplies for the MSPV program should be entered and priced here, both historical supplies and additional supplies relevant to the specified Product Category Data Field For Reference - Definition and examples of data fields to complete

OP Historical Data This tab provides detailed information on VA usage of medical/surgical supplies from Calendar Year 2018. It should be used as a reference for specific supplies that the VA has previously purchased. The OP Historical Data tab includes VA Spend for the entire Product Category across the 12-month period, as well as the potential usage (quantity of Unit of Measures (UOM) ordered) for each supply line item.

OP Quoted Supplies – Enter Data on this tab Suppliers should add data, UOM measure information, and price quotes in this tab for each quoted item.

Supplier information shall be filled out completely at the top, ensuring business designation is accurately captured. Suppliers should enter each quoted item on a separate line. When quoting items listed on the Historical Data tab (reference), please copy and paste data (as values) from the Historical Data tab to the Quoted Supplies tab to ensure data integrity.

The first two columns ("Index" and "From Historical Data tab") are locked as they populate automatically based on user input in the other columns. Users cannot changes these values.

For each supply quoted, manually complete all the GREEN fields; the copy paste data function is limited by the quote sheet’s validation macros. BLUE fields are optional, but are highly encouraged for completion if the information is known.

This quote sheet has built in validation that will alert the user when they enter data in the wrong format, e.g. filling in a field as text when it should be a date or number. The RED fields indicate missing information required for submission; RED text will change to GREEN when corrected.

Blank and NULL cells are counted as errors and are summarized at the top of the OP Quoted Supplies sheet. Quote sheets with errors will not be accepted. Do not submit the files until there are no errors identified by the sheet.

Last Revision: July 26, 2019

Key Steps to being able to edit the Quoted Supplies worksheet

1) Ensure to save and work from a local version of the file

2) Click on 'Enable Editting' if the warning pops-up

3) Click on 'Enable Content' to enable the built in validation macros of the workbook. The validation macros will assist you in filling out the Quoted Supplies tab

OP Historical Data