36C10G19R0003-021.docx

SCHEDULE OF DELIVERABLES (NOT SEPERATELY PRICED CLINs xxxxBB) Note: Days used in the table below refer to calendar days unless otherwise stated. Deliverables with due dates falling on a weekend or holiday shall be submitted the following Government work day after the weekend or holiday.

Unless otherwise specified, reports shall be available online, in real time, printable and downloadable as an export delimited file and Excel compatible format to the agencies identified. Customers shall be able to print multiple pages simultaneously and to scroll through multiple pages. Customers shall also be able to access online global data and be able to create/customize data into consolidated reports. Report formats are required (Attachment 4), and the fields cited therein shall be provided. The MSPV shall provide its standard periodic report package through a Management Information System (MIS) module that is interfaced with the Automated Ordering System (AOS), Transaction Processing System (TPS) used for placing electronic orders. This MIS module shall be available to the VHA Procurement & Logistics Office, and designated Points of Contact (POCs). These periodic reports shall be available at the ordering facility level. Failure by the MSPV to provide the reports within two business days of due date if not made available on-line, may adversely affect the MSPV’s performance rating. Reports shall be able to be generated for purchases made to date over the duration of the contract. The MSPV shall provide all archived purchase data upon request by the SAC and designated Program Offices within 30 days of request. (Reference Section 39, “Reports”, for additional guidance.)

(Report Templates)

38.1 Purchase History Raw Data

38.2 MSPV Metrics

38.3 Core Item List Report

38.4 Credit and Rebill Report

38.5 Outstanding Invoice Report

38.6 Facility Service Level Support

38.7 Distribution Center Out-of-Stock Report

38.4 Purchase History Raw Data. The prime vendor shall have a transaction processing system capable of recording and tracking each line item of each task/delivery order transaction between the customer and the prime vendor. Purchase History Raw Data includes all Core Items and Non-Core Items. As part of the monthly report, the prime vendor shall provide customers the raw transaction data captured by the prime vendor transaction processing system and reported to the government monthly. The raw transaction data shall include at a minimum the following fields:

AJ Quantity Killed (Not Filled) Due to Pricing Error

38.5 MSPV Metrics. A combination of data points that provides a snapshot of critical elements to help in management of the program at a Facility level and to provide a history for analysis at a National level. The MSPV Contract includes Core and Non-Core Items.

38.5.1 Sales Estimate Versa Actual Sales

A Facility Core Item Sales Facility Non-Core Item Sales Facility Total Sales (includes Core and Non-Core)

Monthly Facility Non-Core Item Sales Monthly Facility Total Sales (includes Core and Non-Core) (Header identifies the Current Months Report with the preceding 11 Months Listed)

38.5.2 Delivery Quality Report

38.5.3 Facility Service Level Report

38.5.4 Fill Rate Report This metric provides an individual facility snapshot of various points within the VISN to determine if the MSPV is meeting required fill rates and for facility management to determine efficiency of the program.

N Lines Killed Due to Pricing Error

38.6 Core Item List Report. The Core Item List is used by the Facility and the prime vendor to identify and manage inventory levels at the prime vendor, to ensure an adequate on hand supply to accommodate the needs of the Facility and to meet the Fill Rate Requirements of the agreement. An automated system will look at existing levels, current month’s usage, and proposed adjustments and new levels. Core Item Listings are reviewed at least once a month with documented communication between the Facility and the prime vendor, during which final determination is made concerning new levels. No Core Item will be altered from the listing without mutual acceptance.

The Core Item List Report shall include at a minimum the following fields:

38.7 Credit and Rebill Report. Clearly identifies Credits and Rebill problems that might require the attention of the MSPV or Facility during the month of the Report. This report shall include at a minimum the following fields:

38.8 Outstanding Invoice Report Monthly VISN Report that identifies Invoice (debits and credits) that are over 30 days old and considered outstanding.

38.9 Facility Service Level Report. The prime vendor shall provide a single aggregate report of the service level being provided to each facility. Reviews are required as identified within the Statement of Work. MSPV is required to conduct these reviews, especially the Core Item Listing review on schedule and document the results as indicated. This report shall include at a minimum the following fields:

38.10 Distribution Center Out-of-Stock Report. The prime vendor shall provide a single aggregate “out of stock” report for each VISN. For each task/delivery order line item which (I) corresponded to the ordering facility Core Item List and (ii) was not filled at 100% (i.e., completely and on time), this report shall identify the product ordered and the reason the line item was not filled completely or on time (e.g. backorder by the manufacturer or non-manufacturing supplier). Report shall include at a minimum the following fields:

AE Quantity Killed (Not Filled) Due to Pricing Error image3.emf

M:\MSPV National Group\MSPV Statement of Work Rewrite 38.3 Core Item Listing Template.xls Batavia

Facility Facility Facility Government Supplier Government Supplier Government Supplier Government Supplier Product MSPV MSPV Substitute Nov Est. Core New YTD Est Usage Minus

VISN # Station # Name Item Number Name Contract Number Contract Expiration Date Description Item Code Item Code U/M # Per Usage Usage Adjustment Estimate Usage Nov Usage

2 528A4 BATAVIA VAMC 23331 KENDALL HEALTHCARE PROD 797BP0094 05/31/09 WINGS CHOICE BRIEF LRG KDL-60044 CS 72 45 42 3 45 412 -3

2 528A4 BATAVIA VAMC 2076 PROPPER MFG CO. V797P4202A 06/30/09 STEAM INDICATOR STRIP PMC-264101 BX 250 10 7 0 7 67 -3

2 528A4 BATAVIA VAMC 911 KENDALL HEALTHCARE PROD 797BP0059 07/31/12 CURITY GAUZE SPNG ST 4X4 KDL-3033 CS 600 4 2 1 3 18 -2

2 528A4 BATAVIA VAMC 630 3M DLK5874 V797P4021B 09/30/12 DURAPORE TAPE 1 MMM-1538/1 BX 12 10 8 1 9 74 -2

2 528A4 BATAVIA VAMC 10182 ATTENDS HEALTHCARE V797P4399A 11/14/12 UNDERPAD 30X36 PPP-UFPP360 CS 10 4 2 1 3 25 -2

2 528A4 BATAVIA VAMC 35425 CONVATEC BP0108 10/14/13 SENSICARE BODY CRM 3OZ CVT-324403 CS 24 1 1 0 1 10 0

2 528A4 BATAVIA VAMC 773 KENDALL HEALTHCARE PROD 797BP0059 07/31/12 GZE SPNG STER 2 X2 8P 2'S KDL-1806 CS 1500 1 1 0 1 7 0

2 528A4 BATAVIA VAMC 580 KENDALL HEALTHCARE PROD 797BP0072 10/25/09 DISP INS SYR 1CC 29G X 1/2 KDL-511110 CS 500 2 2 0 2 20 0

2 528A4 BATAVIA VAMC 803 KENDALL HEALTHCARE PROD V797P4951R 08/14/11 SORBIT SPNG 4X4 ST KDL-6242P CS 300 1 1 0 1 10 0

2 528A4 BATAVIA VAMC 30789 KENDALL HEALTHCARE PROD V797P4951R 08/14/11 PUMP SET 1000ML W/AF KDL-773610 CS 30 2 2 0 2 22 0

2 528A4 BATAVIA VAMC KENDALL HEALTHCARE PROD 797BP0056 04/30/12 TENDERSORB AB PAD 10X8 KDL-9194A CS 216 1 1 0 1 6 0

2 528A4 BATAVIA VAMC 20729 3M DLK5874 V797P4021B 09/30/12 ATTES STEAM IND TEST PK MMM-1276 CS 25 1 1 0 1 9 0

2 528A4 BATAVIA VAMC 33628 CONVATEC BP0108 10/14/13 PERINEAL FOAM CVT-325208 CS 12 6 7 0 7 71 1

2 528A4 BATAVIA VAMC 772 KENDALL HEALTHCARE PROD V797BP0063 10/14/12 KERLIX RL STR 4 1/2 KDL-6715 CS 100 2 3 0 3 23 1

2 528A4 BATAVIA VAMC 855 KENDALL HEALTHCARE PROD V797P4951R 08/14/11 WEB ALCOHOL PREP STR MED KDL-6818 CS 4000 1 2 0 2 15 1

2 528A4 BATAVIA VAMC 2202 3M DLK5874 V797P4021B 09/30/12 MICROPORE TAPE 2 MMM-1530/2 BX 6 8 9 1 10 90 1

2 528A4 BATAVIA VAMC BECTON-DICKINSON V797P4493a 12/31/08 PLUS SST TB RED 8.5ml BD -367988 CS 1000 1 3 0 3 19 2

2 528A4 BATAVIA VAMC LSL INDUSTRIES INC. 797BP0117 11/14/13 MEDICINE CUP 1OZ LSL-10041 CS 5000 1 3 0 3 22 2

2 528A4 BATAVIA VAMC LSL INDUSTRIES INC. V797P4922A 06/14/11 URINARY DRAIN BAG LSL-1450VA CS 20 1 3 0 3 23 2

2 528A4 BATAVIA VAMC SWEEN CORPORATION V797P5970X 11/30/12 ISOGEL HAND GEL 2OZ SWE-7043 CS 36 1 3 -1 2 17 2

2 528A4 BATAVIA VAMC 26837 KENDALL HEALTHCARE PROD 797BP0094 05/31/09 WINGS CHOICE BRIEF XLG KDL-60035 CS 60 15 33 -4 29 365 18

2 528A4 BATAVIA VAMC 147 L C INDUSTRIES V797P2058 05/31/09 FACIAL TISSUE LCI-751 BX 100 207 245 -33 212 2520 38

&C&"Arial,Bold"&12 38.3 Facility Month Year Core Item Listing

&C&P image4.emf

M:\MSPV National Group\MSPV Statement of Work Rewrite 38.4 Credit and Rebill.xls Visn #

Facility VISN Number Facility Station Number Facility Name Purchase Order Date Facility Designated Purchase Order Number MSPV Invoice Number MSPV Product Number Product Description Government Supplier Name Government Supplier Contract Number Unit Cost (Includes Distribution Fees) Total Invoice Amount Original Invoice Amount Amount of Credit Amount of Rebill Reason for Credit / Rebill

2 528A7 Syracuse 09/26/08 528A84849 2671962 BD -305187 NDL 19GX1-1/2" Becton Dickinson V797P-4493A 30.23 60.46 60.46 60.46 2 CS picked wrong, shipped 2 BX, BD - 364880

&C&"Arial,Bold"&12 38.4 CREDIT AND REBILL REPORT Month Year image5.emf

M:\MSPV National Group\MSPV Statement of Work Rewrite 38.5 Outstanding Invoice.xls Visn #

Facility VISN Number Facility Station Number Facility Name Facility Designated Purchase Order Number Procurement Method MSPV Invoice Number MSPV Invoice Date Purchase Order Date Invoice Amount Payment Reference Number Payment Date Payment Amount Outstanding Balance - Credit

2 528A7 Syracuse 528A84849 2671962 09/26/08

&C&"Arial,Bold"&12 38.5 Outstanding Invoice Report VISN # Month Year image6.emf

M:\MSPV National Group\MSPV Statement of Work Rewrite 38.6 Facility Service Level Report.xls Facility

Facility VISN Number 2

Facility Station Number 528

Facility Name Buffalo

Phone 716-862-6383

Address 3495 Bailey Avenue, Buffalo, NY 14215

Facility Representative John Doe Phone 716-862-1000

MSPV Representative Al Joke Phone 716-862-3000

Date Method of Contact (In person, e-mail, phone) Identify Contact People Core Item Listing Reviewed and Approved Y/N Core Item Listing Approval By Outcome - Describe the main context of contact

10/10/08 E-Mail John Y John Contract and Pricing Updates - Review usage/commitment levels

10/27/08 E-Mail John Y John Contract and Pricing Updates - Review usage/commitment levels

10/3/08 In Person Jane-Joe-John N Routine Call reviewed Invoice issues.

10/10/08 In Person Jane-Joe-Gail N Routine Call. Discussed Custom Kits from Deroyal and Medical Action.

10/17/08 In Person Jane-Joe-Gail Y Jane Contract and Pricing Updates - Review usage/commitment levels

10/23/08 In Person Jane-Joe-Gail N Routine Call. Reviewed Open Market purchases.

10/31/08 In Person Jane-Joe-Rose Y Jane Routine call. Reviewed Wound Care Products & Gloves. Discussed Core Items & Open Market purchases.

&CMonth Year

38.6 FACILITY SERVICE

LEVEL SUPPORT

image7.emf

M:\MSPV National Group\MSPV Statement of Work Rewrite 38.7 Distribution Center Out-of-Stock.xls 38.7_Distribution_Center_Out_of

Facility VISN # Facility Station Number Facility Name Facility Designated Purchase Order Number MSPV Invoice Number Purchase Order Date Facility Required Delivery Date Government Supplier Item Number Government Supplier Name Government Supplier Contract Number Product Description National Item File Number Universal Product Number Government Contract Item (Y/N) Unit of Measure Ordered Unit of Measure Package Multiple Core Item List (Y/N) Emergency Order (Y/N) Line Filled Complete by Required Date (Y/N) Date Line Filled Complete MSPV Product Number Unit Cost (includes distribution fees) Total Cost (includes distribution fees) Total Distribution Fees per Line Distribution Fees % Quantity Ordered Quantity Filled on Required Date Remaining Quantity Quantity Failed Due to 10% Over Level Usage Quantity Failed Due to Mfg BO

2 528A7 VA MEDICAL CENTER (SYR) 528A94054 01-2459444 10/31/08 11/1/08 BARD UROLIGICAL DIV. V797P3357K COUDE CATH 20FR 5CC Y CS 100 Y N 11/1/08 0168L20 99.36 99.36 4.17 4.2 1 0 1

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 01-2459262 10/31/08 11/1/08 CARDINAL HEALTH V797P3492K FLAT DRAIN 7MM SIL Y BX 25 Y N 11/1/08 SU1301310 57.4 57.4 2.41 4.2 1 0 1

2 528A7 VA MEDICAL CENTER (SYR) 528A94052 01-2459029 10/31/08 11/1/08 KENDALL HEALTHCARE PROD V797P4951R RIGID SOLE FOOT COVER REG Y CS 100 Y N 11/1/08 5065 278.53 278.53 11.7 4.2 1 0 1

2 528A5 VA MED CTR - CANANDAIGUA 528A92014 01-2460695 11/3/08 11/4/08 CINCINATTI ASSOC BLIND V797P2000 EXAM TABLE PAPER Y CS 100 Y N 11/4/08 4790 54.92 54.92 2.31 4.2 1 0 1

2 528A7 VA MEDICAL CENTER (SYR) 528A94055 01-2460430 11/3/08 11/4/08 CARDINAL HEALTH V797P3492K OXYGEN TUBING CONN Y CS 100 Y N 11/4/08 001811 5.28 26.4 1.11 4.2 5 3 2

2 528A5 VA MED CTR - CANANDAIGUA 528A92014 01-2460695 11/3/08 11/4/08 CARDINAL HEALTH V797P3492K KWIK HEAT HOT PACK Y CS 100 Y N 11/4/08 211 14.9 14.9 0.63 4.2 1 0 1

2 528A5 VA MED CTR - CANANDAIGUA 528A92014 01-2460695 11/3/08 11/4/08 CONVATEC V797P4152A DURAHESIVE WAFER 45MM Y BX 25 Y N 11/4/08 413166 17.32 34.64 1.45 4.2 2 0 2

2 528A5 VA MED CTR - CANANDAIGUA 528A92014 01-2460695 11/3/08 11/4/08 HUDSON OXYGEN THERAPY V797P4233A ELON AEROSOL MASK W/O TB Y CS 100 Y N 11/4/08 1083 20.35 20.35 0.85 4.2 1 0 1

2 528 VA MEDICAL CENTER (BUF) 528A90067 01-2460429 11/3/08 11/4/08 STERIS CORPORATION V797P4921A H-KLENZ II 5 GAL PL Y CS 100 Y N 11/4/08 120805 67 67 2.81 4.2 1 0 1

2 528A4 BATAVIA VAMC 528A90068 01-2460213 11/3/08 11/4/08 KENDALL HEALTHCARE PROD V797P4951R MAGELLAN 3CC 22X1 Y CS 100 Y N 11/4/08 833210 98.43 196.86 8.27 4.2 2 0 2

2 528A5 VA MED CTR - CANANDAIGUA 528A92014 01-2460695 11/3/08 11/4/08 KENDALL HEALTHCARE PROD V797P4951R PUMP SET 1000ML W/AF Y CS 100 Y N 11/4/08 773610 69.34 69.34 2.91 4.2 1 0 1

2 528A5 VA MED CTR - CANANDAIGUA 528A92014 01-2460695 11/3/08 11/4/08 KENDALL HEALTHCARE PROD V797P4951R XLG ADH BAND LTX FR Y CS 100 Y N 11/4/08 6136LF 55.7 55.7 2.34 4.2 1 0 1

2 528A5 VA MED CTR - CANANDAIGUA 528A92014 01-2460695 11/3/08 11/4/08 SWEEN CORPORATION V797P5970X ISOGEL HAND GEL 2OZ Y CS 100 Y N 11/4/08 7043 22.32 44.64 1.87 4.2 2 1 1

2 528A7 VA MEDICAL CENTER (SYR) 528A94057 01-2461279 11/4/08 11/5/08 WASH-GREENE BLIND ASSOC V797P2002 TRACH CARE TRAY Y CS 100 Y N 5011748844 45.8 45.8 1.92 4.2 2 1 1

2 528A6 VAMC BATH PRIME VENDOR 528A95038 01-2461626 11/4/08 11/5/08 BOSMA INDUSTRIES V797P-2071 EX GLV VINYL PF NS LG Y CS 100 Y N 11/5/08 7290603 57.21 343.26 14.42 4.2 6 5 1

2 528 VA MEDICAL CENTER (BUF) 528A90070 01-2461222 11/4/08 11/5/08 WELCH ALLYN INC. V797P3486K CUFF LRG ADT DIS 1T Y CS 100 Y N SOFT121HP 73.96 369.8 15.53 4.2 8 5 3

2 528 VA MEDICAL CENTER (BUF) 528A90070 01-2461222 11/4/08 11/5/08 WELCH ALLYN INC. V797P3486K DISP AD BP CUFF 1-T Y CS 100 Y N SOFT111HP 73.96 0 0 4.2 15 0 15

2 528 VA MEDICAL CENTER (BUF) 528A90070 01-2461222 11/4/08 11/5/08 WELCH ALLYN INC. V797P3486K UNISCOPE YELLOW ADULT Y EA 1 Y N 11/5/08 17461 2.95 88.5 3.72 4.2 30 0 30

2 528A7 VA MEDICAL CENTER (SYR) 528A94058 01-2461582 11/4/08 11/5/08 KIMBERLY CLARK V797P3767K IMPER STOCKINETT 12X48 Y CS 100 Y N 11/5/08 89821 134.32 134.32 5.64 4.2 1 0 1

2 528A7 VA MEDICAL CENTER (SYR) 528A94057 01-2461279 11/4/08 11/5/08 3M DLK5874 V797P4021B DURAPORE TAPE 2 Y CS 100 Y N 1538/2 64.4021 515.22 21.64 4.2 10 8 2

2 528A6 VAMC BATH PRIME VENDOR 528A95038 01-2461626 11/4/08 11/5/08 ALARIS CORPORATION V797P4091A PIGGYBACK SET Y CS 100 Y N 11/5/08 72213N 88 88 3.7 4.2 1 0 1

2 528 VA MEDICAL CENTER (BUF) 528A90070 01-2461222 11/4/08 11/5/08 HUDSON OXYGEN THERAPY V797P4233A ELON AEROSOL MASK W/O TB Y CS 100 Y N 11/5/08 1083 20.35 20.35 0.85 4.2 1 0 1

2 528 VA MEDICAL CENTER (BUF) 528A90070 01-2461222 11/4/08 11/5/08 HUDSON OXYGEN THERAPY V797P4233A ELON MEDIUM CONCEN MASK Y CS 100 Y N 11/5/08 1041 28.32 56.64 2.38 4.2 2 0 2

2 528 VA MEDICAL CENTER (BUF) 528A90070 01-2461222 11/4/08 11/5/08 HUDSON OXYGEN THERAPY V797P4233A NEB 760ML W/028 ADAPTOR Y CS 100 Y N 11/5/08 03728 30.31 151.55 6.37 4.2 5 0 5

2 528A6 VAMC BATH PRIME VENDOR 528-R91068 01-2461381 11/4/08 11/5/08 HUDSON OXYGEN THERAPY V797P4233A POCKET CHAMBER Y CS 100 Y N 11/5/08 100110 46.61 233.05 9.79 4.2 5 2 3

2 528A7 VA MEDICAL CENTER (SYR) 528A94057 01-2461279 11/4/08 11/5/08 CINCINNATTI SUB ZERO V797P4239A BLANKET WARMAIR 88 X30 Y BX 25 Y N 11/5/08 443 62.5 187.5 7.88 4.2 3 1 2

2 528A6 VAMC BATH PRIME VENDOR 528A95038 01-2461626 11/4/08 11/5/08 HEALTHMARK INDUSTRIES CO V797P4387A STERILIZATION POUCH 3X7.75 Y CS 100 Y N 11/5/08 2 50.41 100.82 4.23 4.2 2 0 2

2 528 VA MEDICAL CENTER (BUF) 528A90070 01-2461222 11/4/08 11/5/08 KENDALL HEALTHCARE PROD V797P4951R PUMP SET 1000ML W/AF Y CS 100 Y N 11/5/08 773610 69.34 416.04 17.47 4.2 6 3 3

2 528A6 VAMC BATH PRIME VENDOR 528A95038 01-2461626 11/4/08 11/5/08 KENDALL HEALTHCARE PROD V797P4951R MONOFLO DRN BAG W/CSR Y CS 100 Y N 11/5/08 6209 55.16 165.48 6.95 4.2 3 0 3

2 528A8 VA MEDICAL CENTER ALBANY 528A93036 01-2461758 11/5/08 11/6/08 HOLLISTER V797P-2026 RESTORE + TAPE EDGE 17S Y BX 25 Y N 11/6/08 9959 11.65 233 9.79 4.2 20 0 20

2 528A7 VA MEDICAL CENTER (SYR) 528A94060 01-2462187 11/5/08 11/6/08 WELCH ALLYN INC. V797P3486K BP CUFF LG ADULT Y EA 1 Y N 11/6/08 520002 21.16 211.6 8.89 4.2 10 0 10

&C&"Arial,Bold"&14 &12 38.7 Distribution Center Out-of-Stock Report image1.emf

M:\MSPV National Group\MSPV Statement of Work Rewrite 38.1 Template.xls 39.1_Purchase_History_Raw_Data_

Facility Facility Facility Facility Procurement MSPV Invoice Order Required Government Supplier Government Supplier Government Supplier Government Supplier Government Supplier Product National Item Universal Government Contract Standardized UM UM Core Emergency Filled Complete Date Line MSPV MSPV Substitute Unit Total Distribution Distribution Quantity Quantity Filled Remaining Qty Failed 10% Qty Failed Due

VISN # Station ID Name PO Number Method No. Date Delivery Date Item No. Name Business Size See Comments for code Contract No. Contract Expiration Date Description File Number Product Number Item Item Ordered Pk Multiple Item Order By Required Date Filled Complete Item Code Item Code Cost Cost Fee Fee % Ordered on Required Date Quantity Over Level Usage To MFG B/O

2 528A7 VA MEDICAL CENTER (SYR) 528A94052 p 01-2459029 10/31/08 11/1/08 5075 KENDALL HEALTHCARE PROD s V797P4951R RIGID SOLE FOOT COVER LG Y N CS Y N Y 11/1/08 KDL5075 278.53 278.53 11.7 4.2 1 1 0 0 0

2 528A7 VA MEDICAL CENTER (SYR) 528A94053 s 01-2459153 10/31/08 11/1/08 1296 3M DLK5874 o V797P4021B RAPID ATTEST PACK/STEAM Y N CS Y N Y 11/1/08 MMM1296 151.64 151.64 6.37 4.2 1 1 0 0 0

2 528A7 VA MEDICAL CENTER (SYR) 528A94053 s 01-2459153 10/31/08 11/1/08 405184 BECTON-DICKINSON w V797P4493a SPINAL NEEDLE 18GX3.5 Y N BX Y N Y 11/1/08 BD405184 27.27 27.27 1.15 4.2 1 1 0 0 0

2 528A7 VA MEDICAL CENTER (SYR) 528A94053 s 01-2459153 10/31/08 11/1/08 ETMCS20 ETHICON v V797P3773K LIGACLP MCA 6 3/8 20SM Y N BX Y N Y 11/1/08 ETHMCS20 334.59 334.59 14.05 4.2 1 1 0 0 0

2 528A7 VA MEDICAL CENTER (SYR) 528A94053 s 01-2459153 10/31/08 11/1/08 ET1952 J&J MEDICAL dv V797P3773K SURGICEL 4 X8 STERILE Y N BX Y N Y 11/1/08 JJ1952 592.505 1185.01 49.77 4.2 2 2 0 0 0

2 528A7 VA MEDICAL CENTER (SYR) 528A94053 s 01-2459153 10/31/08 11/1/08 PRECEPT MEDICAL d V797P4086A TABLE COVER 44X90 Y N CS Y N Y 11/1/08 MWK55264 42.22 42.22 1.77 4.2 1 1 0 0 0

2 528A7 VA MEDICAL CENTER (SYR) 528A94053 s 01-2459153 10/31/08 11/1/08 1015 3M DLK5874 o V797P4021B STERI DRAPE U ORTHOPED Y N CS Y N Y 11/1/08 MMM1015 171.8374 171.84 7.22 4.2 1 1 0 0 0

2 528A5 VA MED CTR - CANANDAIGUA 528A82247 w 01-2459256 10/31/08 11/1/08 BECTON-DICKINSON w V797P4493a INTEGRA SYR 3ML 23GX1 Y N CS Y N Y 11/1/08 BD305271 152 608 25.54 4.2 4 4 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 3512V KENDALL HEALTHCARE PROD s V797P4951R DRAIN BAG 200ML W/VELCRO Y N CS Y N Y 11/1/08 KDL3512V 39.83 199.15 8.36 4.2 5 5 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 364815 BECTON-DICKINSON w V797P4493a 1 USE NDL NON-STACKABL Y N CS Y N Y 11/1/08 BD364815 20.41 61.23 2.57 4.2 3 3 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 369714 BECTON-DICKINSON w V797P4493a BLUE STR TB 4.5ML Y N BX Y N Y 11/1/08 BD369714 5.95 35.7 1.5 4.2 6 6 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 52200 AUGUSTINE MEDICAL INC 8a V797P4028A UPPER BODY BLANKET Y N CS Y N Y 11/1/08 AUG52200 58.4982 117 4.91 4.2 2 2 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 727 BUSSE HOSPITAL DISP. h V797P4219A SHROUD KIT X-LARGE Y N EA Y N Y 11/1/08 BUS727 1.602 8.01 0.34 4.2 5 5 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 CARDINAL HEALTH V797P3492K UNIVERSAL SPLIT PACK Y N CS Y N Y 11/1/08 BAX29131 53.22 159.66 6.71 4.2 3 3 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 10854 KIMBERLY CLARK V797P3767K KC300 STER WRAP 54X54 Y N CS Y N Y 11/1/08 KCC10854 77.67 155.34 6.52 4.2 2 2 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 60035 KENDALL HEALTHCARE PROD s 797BP0094 WINGS CHOICE BRIEF XLG Y N CS Y N Y 11/1/08 KDL60035 25.86 77.58 3.26 4.2 3 3 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 PRECEPT MEDICAL d V797P4086A TABLE COVER 44X90 Y N CS Y N Y 11/1/08 MWK55264 42.22 42.22 1.77 4.2 1 1 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 89272 KIMBERLY CLARK V797P4493a ORTHOAR HND DRPE 76X150 N CS N Y 11/1/08 KCC89272 91.37 91.37 3.84 4.2 1 1 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 PRECEPT MEDICAL d V797P4086A CYSTOSCOPY PACK Y N CS Y N Y 11/1/08 MWK44631 95.1 95.1 3.99 4.2 1 1 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 325614 CONVATEC BP0108 SENSI PROT BARR 4 OZ Y N CS Y N Y 11/1/08 CVT325614 82.59 82.59 3.47 4.2 1 1 0 0 0

2 528A8 VA MEDICAL CENTER ALBANY 528A93034 edi 01-2459262 10/31/08 11/1/08 8884433605 KENDALL HEALTHCARE PROD s V797P4951R XEROFORM GZE 5 X 9 STRIP Y N BX Y N Y 11/1/08 KDL433605 36.5637 146.25 6.14 4.2 4 3 1 0 0

&C38.1 Purchase History Raw Data MSPV Template

VISN 2 User:

s - Small Busines o - Other than small business w - Woman Owned business v - Veteran Owned Small business dv -Service Disabled Veteran Owned Small business d - SBA Certified Small Disadvantaged business 8a - SBA Certified 8(a) Firm h - SBA Certified HUBZone Firm

VISN 2 User:

p - Purchase Card

EDI

w - Web Based s - Standard Purchase Order image2.emf

M:\MSPV National Group\MSPV Statement of Work Rewrite 38.2 Metrics Template.xls Sheet1

SALES ESTIMATE VERSA ACTUAL SALES

Facility Name Facility Station Number VISN Number Annual Sales Estimate Monthly Sales Estimate Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Buffalo Core Items 528 2 $128,671.71 $85,600.18 $94,808.85 $135,461.17 $99,979.03 $103,514.90 $149,174.47 $129,860.67 $171,164.50 $172,372.76 $125,004.91 $88,923.58

Buffalo Non-Core Items 528 2 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00

Buffalo Total Sales 528 2 $1,358,700.00 $113,225.00 $168,671.71 $125,600.18 $134,808.85 $175,461.17 $139,979.03 $143,514.90 $189,174.47 $169,860.67 $211,164.50 $212,372.76 $165,004.91 $128,923.58

Batavia Core Items 528A4 2 $9,311.44 $6,793.71 $7,597.66 $8,259.46 $9,213.63 $7,274.78 $14,121.73 $10,905.45 $11,677.18 $11,976.26 $10,850.06 $9,041.96

Batavia Non-Core Items 528A4 2 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00 $3,000.00

Batavia Total Sales 528A4 2 $60,196.80 $5,016.40 $12,311.44 $9,793.71 $10,597.66 $11,259.46 $12,213.63 $10,274.78 $17,121.73 $13,905.45 $14,677.18 $14,976.26 $13,850.06 $12,041.96

Canandaigua Core Items 528A5 2 $9,793.77 $21,766.13 $13,285.62 $17,809.02 $14,176.07 $12,290.29 $18,898.81 $37,077.41 $22,872.48 $20,370.56 $21,543.48 $12,283.06

Canandaigua Non-Core Items 528A5 2 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00 $4,000.00

Canandaigua Total Sales 528A5 2 $44,605.20 $3,717.10 $13,793.77 $25,766.13 $17,285.62 $21,809.02 $18,176.07 $16,290.29 $22,898.81 $41,077.41 $26,872.48 $24,370.56 $25,543.48 $16,283.06

Bath Core Items 528A6 2 $15,911.82 $14,949.46 $17,064.06 $17,138.15 $14,895.29 $34,710.86 $26,566.76 $47,818.47 $26,297.16 $18,175.08 $27,736.94 $5,749.08

Bath Non-Core Items 528A6 2 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00 $5,000.00

Bath Total Sales 528A6 2 $41,420.40 $3,451.70 $20,911.82 $19,949.46 $22,064.06 $22,138.15 $19,895.29 $39,710.86 $31,566.76 $52,818.47 $31,297.16 $23,175.08 $32,736.94 $10,749.08

Syracuse Core Items 528A7 2 $117,553.62 $125,777.31 $112,906.14 $105,525.66 $139,837.72 $87,138.54 $102,450.53 $148,352.88 $168,053.86 $141,414.46 $120,848.27 $86,256.78

Syracuse Non-Core Items 528A7 2 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00

Syracuse Total Sales 528A7 2 $977,029.80 $81,419.15 $152,553.62 $160,777.31 $147,906.14 $140,525.66 $174,837.72 $122,138.54 $137,450.53 $183,352.88 $203,053.86 $176,414.46 $155,848.27 $121,256.78

Albany Core Items 528A8 2 $72,533.50 $62,933.45 $65,562.30 $76,053.54 $81,601.99 $82,105.13 $71,854.56 $84,297.20 $65,613.26 $126,873.75 $83,903.78 $71,585.43

Albany Non-Core Items 528A8 2 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00 $10,000.00

Albany Total Sales 528A8 2 $655,186.80 $54,598.90 $82,533.50 $72,933.45 $75,562.30 $86,053.54 $91,601.99 $92,105.13 $81,854.56 $94,297.20 $75,613.26 $136,873.75 $93,903.78 $81,585.43

Total $3,137,139.00 $261,428.25 $450,775.86 $414,820.24 $408,224.63 $457,247.00 $456,703.73 $424,034.50 $480,066.86 $555,312.08 $562,678.44 $588,182.87 $486,887.44 $370,839.89

DELIVERY QUALITY REPORT Facility Service Level Report

Facility Name Facility Station Number Visn Number Month Regular Monthly Deliveries Emergency Deliveries Drop Shipments Failed Deliveries Report of Damaged Product Report of Expired Product Incorrect Line Items Delivered Core Item Listing Review Date Person at Facility

Buffalo 528 2 Nov-08 12 0 0 0 0 0 0

Batavia 528A4 2 Nov-08 12 0 0 0 0 0 0

Canandaigua 528A5 2 Nov-08 12 0 0 0 0 0 0

Bath 528A6 2 Nov-08 12 0 0 0 0 0 0

Syracuse 528A7 2 Nov-08 12 0 0 0 0 0 0

Albany 528A8 2 Nov-08 8 0 0 0 0 0 0

FILL RATE REPORT

Buffalo 528 VISN 2

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Core Lines Total: 321 271 272 349 272 257 603 520 537 604 462 425

Core Lines Filled Complete: 303 245 249 322 258 245 555 468 493 549 431 409

Percentage Filled Complete: 94.39 90.41 91.54 92.26 94.85 95.33 92.04 90 91.81 90.89 93.29 96.24

Lines Failed where >10% over usage: 4 8 5 4 1 2 8 5 5 7 2 5

Lines Failed due to Mfr B/O: 2 7 2 2 2 0 4 6 2 4 3 0

Fill Rate Core Lines 96.26 95.94 94.12 93.98 95.96 96.11 94.03 92.12 93.11 92.72 94.37 97.41

Total Non-Core Lines

Total Core and Non-Core Lines

Total Orders Placed: Core & Non-Core 23 23 18 17 24 25 43 32 37 47 24 27

Total Lines Per Order Core + Non-Core Items 13.96 11.78 15.11 20.53 11.33 10.28 14.02 16.25 14.51 12.85 19.25 15.74

Average Dollars Per Order Core + Non-Core Items $7,333.55 $5,460.88 $7,489.38 $10,321.25 $5,832.46 $5,740.60 $4,399.41 $5,308.15 $5,707.15 $4,518.57 $6,875.20 $4,774.95

FILL RATE REPORT

Batavia 528A4 VISN 2

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Core Lines Total: 20 16 12 21 23 27 98 78 81 79 74 53

Core Lines Filled Complete: 20 16 10 19 20 26 92 64 69 70 60 48

Percentage Filled Complete: 100 100 83.33 90.48 86.96 96.3 93.88 82.05 85.19 88.61 81.08 90.57

Lines Failed where >10% over usage: 0 0 1 0 0 0 0 0 0 0 0 0

Lines Failed due to Mfr B/O: 0 0 0 0 2 0 0 3 0 3 0 0

Fill Rate Core Lines 100 100 91.67 90.48 95.65 96.3 93.88 85.9 85.19 92.41 81.08 90.57

Total Non-Core Lines

Total Core and Non-Core Lines

Total Orders Placed: Core & Non-Core 8 7 6 7 10 10 15 9 15 14 12 8

Total Lines Per Order Core + Non-Core Items 2.5 2.29 2.00 3 2.3 2.7 6.53 8.67 5.4 5.64 6.17 6.63

Average Dollars Per Order Core + Non-Core Items $1,538.93 $1,399.10 $1,766.28 $1,608.49 $1,221.36 $1,027.48 $1,141.45 $1,545.05 $978.48 $1,069.73 $1,154.17 $1,505.25

FILL RATE REPORT

Canandaigua 528A5 VISN 2

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Core Lines Total: 12 26 21 28 17 27 135 98 143 125 140 42

Core Lines Filled Complete: 12 23 21 28 17 26 119 82 121 115 126 34

Percentage Filled Complete: 100 88.46 100 100 100 96.3 88.15 83.67 84.62 92 90 80.95

Lines Failed where >10% over usage: 0 3 0 0 0 0 0 2 0 0 0 0

Lines Failed due to Mfr B/O: 0 1 0 0 0 0 0 1 3 1 0 1

Fill Rate Core Lines 100 103.85 100 100 100 96.3 88.15 86.73 86.71 92.8 90 83.33

Total Non-Core Lines

Total Core and Non-Core Lines

Total Orders Placed: Core & Non-Core 6 9 10 11 4 10 18 20 14 12 15 8

Total Lines Per Order Core + Non-Core Items 2 2.89 2.10 2.55 4.25 2.70 7.50 4.90 10.21 10.42 9.33 5.25

Average Dollars Per Order Core + Non-Core Items $2,298.96 $2,862.90 $1,728.56 $1,982.64 $4,544.02 $1,629.03 $1,272.16 $2,053.87 $1,919.46 $2,030.88 $1,702.90 $2,035.38

FILL RATE REPORT

Bath 528A6 VISN 2

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Core Lines Total: 48 38 42 64 61 75 140 96 103 133 131 57

Core Lines Filled Complete: 44 38 40 62 60 68 125 90 92 122 120 54

Percentage Filled Complete: 91.67 100 95.24 96.88 98.36 90.67 89.29 93.75 89.32 91.73 91.6 94.74

Lines Failed where >10% over usage: 0 0 0 0 0 2 0 0 0 2 3 0

Lines Failed due to Mfr B/O: 1 0 0 0 0 0 0 0 2 0 0 1

Fill Rate Core Lines 93.75 100 95.24 96.88 98.36 93.33 89.29 93.75 91.26 93.23 93.89 96.49

Total Non-Core Lines

Total Core and Non-Core Lines

Total Orders Placed: Core & Non-Core 10 9 12 14 10 13 17 12 14 17 11 14

Total Lines Per Order Core + Non-Core Items 4.8 4.22 3.50 4.57 6.1 5.77 8.24 8.00 7.36 7.82 11.91 4.07

Average Dollars Per Order Core + Non-Core Items $2,091.18 $2,216.61 $1,838.67 $1,581.30 $1,989.53 $3,054.68 $1,856.87 $4,401.54 $2,235.51 $1,363.24 $2,976.09 $767.79

FILL RATE REPORT

Syracuse 528A7 VISN 2

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Core Lines Total: 297 310 339 381 330 262 559 698 648 717 534 357

Core Lines Filled Complete: 279 292 326 363 322 251 531 649 600 674 514 335

Percentage Filled Complete: 93.94 94.19 96.17 95.28 97.58 95.8 94.99 92.98 92.59 94 96.25 93.84

Lines Failed where >10% over usage: 7 6 2 5 1 0 5 4 9 8 1 1

Lines Failed due to Mfr B/O: 1 4 4 1 1 0 0 5 3 0 0 2

Fill Rate Core Lines 96.63 97.42 97.94 96.85 98.18 95.8 95.89 94.27 94.44 95.12 96.44 94.68

Total Non-Core Lines

Total Core and Non-Core Lines

Total Orders Placed: Core & Non-Core 52 51 58 60 59 51 99 75 67 72 68 42

Total Lines Per Order Core + Non-Core Items 5.71 6.08 5.84 6.35 5.59 5.14 5.65 9.31 9.67 9.96 7.85 8.50

Average Dollars Per Order Core + Non-Core Items $2,933.72 $3,152.50 $2,550.11 $2,342.09 $2,963.35 $2,394.87 $1,388.39 $2,444.71 $3,030.65 $2,450.20 $2,291.89 $2,887.07

FILL RATE REPORT

Albany 528A8 VISN 2

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

Core Lines Total: 181 160 155 203 158 166 327 345 281 445 338 262

Core Lines Filled Complete: 170 152 146 197 150 158 308 330 251 406 318 248

Percentage Filled Complete: 93.92 95 94.19 97.04 94.94 95.18 94.19 95.65 89.32 91.24 94.08 94.66

Lines Failed where >10% over usage: 1 4 0 1 1 2 4 0 2 3 1 3

Lines Failed due to Mfr B/O: 0 2 2 0 0 0 2 1 2 3 0 0

Fill Rate Core Lines 94.48 98.75 95.48 97.54 95.57 96.39 96.02 95.94 90.75 92.58 94.38 95.8

Total Non-Core Lines

Total Core and Non-Core Lines

Total Orders Placed: Core & Non-Core 13 10 9 13 12 11 22 18 16 21 22 8

Total Lines Per Order Core + Non-Core Items 13.92 16 17.22 15.62 13.17 15.09 14.86 19.17 17.56 21.19 15.36 32.75

Average Dollars Per Order Core + Non-Core Items $6,348.73 $7,293.35 $8,395.81 $6,619.50 $7,633.50 $8,373.19 $3,720.66 $5,238.73 $4,725.83 $6,517.80 $4,268.35 $10,198.18

&C&"Arial,Bold"&12 38.2 MED/SURG PRIME VENDOR METRICS

&C&P vhaalnlebrer:

=Monthly Sales/Total Orders Placed vhaalnlebrer:

=Monthly Sales/Total Orders Placed vhaalnlebrer:

=Monthly Sales/Total Orders Placed vhaalnlebrer:

=Monthly Sales/Total Orders Placed vhaalnlebrer:

=Monthly Sales/Total Orders Placed vhaalnlebrer:

=Monthly Sales/Total Orders Placed

Sheet2

Sheet3