36C10G19R0003-044.xls

XLS spreadsheet 49 KB Posted Dec 6, 2018

Attached to: Copy of MSPV Puerto Rico Recompete
Solicitation number: 36C10G19R0003
Issued by: Department of Veterans Affairs Strategic Acquisition Center Frederick

About this file

Written by GovTribe AI · Dec 29, 2023

This spreadsheet contains sales and delivery metrics for medical and surgical prime vendor facilities within the Department of Veterans Affairs. It provides monthly sales estimates and actual sales data by facility for core and non-core items from January through December, including total sales, orders placed, and average dollars per order. Additional tabs include delivery quality reports by facility with fill rates for core item lines and reasons for failed or incomplete deliveries. Metrics such as total lines, lines filled, and percentage filled are given. The final tab outlines monthly prime vendor metrics including sales to orders placed ratios. The related federal contract opportunity is a draft request for proposal for a Veteran Affairs Medical/Surgical Prime Vendor Program in Puerto Rico with an anticipated solicitation number of 36C10G19R0003. Details include the type of opportunity, a description of medical/surgical prime vendor services for Puerto Rico facilities, and the contracting agency as the Department of Veterans Affairs Strategic Acquisition Center located in Frederick.

From the source

36C10G19R0003 Attachment 6 MSPV Metrics.xls

View the file

Other files

File	Type	Posted
36C10G19R0003_0003.docx	DOCX document	Jan 3, 2019
4_-_VA_MSPV_-_P.R._Q_and_A_-_36C10G19R0003_-_Final_-_12-21-2018.docx	DOCX document	Dec 21, 2018
36C10G19R0003_0002.docx	DOCX document	Dec 21, 2018
36C10G19R0003-051.xls	XLS spreadsheet	Dec 6, 2018
36C10G19R0003-049.xls	XLS spreadsheet	Dec 6, 2018
36C10G19R0003-048.xls	XLS spreadsheet	Dec 6, 2018
36C10G19R0003-053.xlsx	XLSX spreadsheet	Dec 6, 2018
36C10G19R0003-038.xlsx	XLSX spreadsheet	Dec 6, 2018
36C10G19R0003-045.xlsx	XLSX spreadsheet	Dec 6, 2018
36C10G19R0003-040.xlsb	XLSB spreadsheet	Dec 6, 2018
36C10G19R0003-039.xlsb	XLSB spreadsheet	Dec 6, 2018
36C10G19R0003-036.docx	DOCX document	Dec 6, 2018
36C10G19R0003-043.xls	XLS spreadsheet	Dec 6, 2018
36C10G19R0003-042.xlsx	XLSX spreadsheet	Dec 6, 2018
36C10G19R0003-050.xls	XLS spreadsheet	Dec 6, 2018
36C10G19R0003-047.xlsx	XLSX spreadsheet	Dec 6, 2018
36C10G19R0003-046.xls	XLS spreadsheet	Dec 6, 2018
36C10G19R0003-052.xls	XLS spreadsheet	Dec 6, 2018
36C10G19R0003-054.pdf	PDF	Dec 6, 2018
36C10G19R0003-041.docx	DOCX document	Dec 6, 2018
36C10G19R0003-037.docx	DOCX document	Dec 6, 2018
36C10G19R0003-0001000.docx	DOCX document	Nov 26, 2018
36C10G19R0003-035.xlsx	XLSX spreadsheet	Nov 1, 2018
36C10G19R0003-025.xls	XLS spreadsheet	Nov 1, 2018
36C10G19R0003-018.docx	DOCX document	Nov 1, 2018
36C10G19R0003-022.xlsb	XLSB spreadsheet	Nov 1, 2018
36C10G19R0003-017.docx	DOCX document	Nov 1, 2018
36C10G19R0003-031.xls	XLS spreadsheet	Nov 1, 2018
36C10G19R0003-023.docx	DOCX document	Nov 1, 2018
36C10G19R0003-019.docx	DOCX document	Nov 1, 2018
36C10G19R0003-028.xls	XLS spreadsheet	Nov 1, 2018
36C10G19R0003-032.xls	XLS spreadsheet	Nov 1, 2018
36C10G19R0003-020.xlsx	XLSX spreadsheet	Nov 1, 2018
36C10G19R0003-024.xlsx	XLSX spreadsheet	Nov 1, 2018
36C10G19R0003-021.docx	DOCX document	Nov 1, 2018
36C10G19R0003-026.xls	XLS spreadsheet	Nov 1, 2018
36C10G19R0003-030.xls	XLS spreadsheet	Nov 1, 2018
36C10G19R0003-029.xlsx	XLSX spreadsheet	Nov 1, 2018
36C10G19R0003-033.xls	XLS spreadsheet	Nov 1, 2018
36C10G19R0003-027.xlsx	XLSX spreadsheet	Nov 1, 2018
36C10G19R0003-034.xls	XLS spreadsheet	Nov 1, 2018

Show all 41

On GovTribe

Work with this file

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

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 Month Year &C&P vhaalnlebrer:

=Monthly Sales/Total Orders Placed vhaalnlebrer:

=Monthly Sales/Total Orders Placed

Sheet2

Sheet3

File details come from the government source that posted it. Updated Dec 29, 2023.