Price-Cost Schedule 23Q0638 - V3.xlsx

XLSX spreadsheet 36 KB Posted Jun 5, 2023

Attached to: S209--VA Northeast Ohio Healthcare System Laundry/Linen Services
Solicitation number: 36C25023Q0638
Issued by: Department of Veterans Affairs Veterans Health Administration Veterans Integrated Service Network 10

View the file

Other files

File	Type	Posted
36C25023Q0638 0003.docx	DOCX document	Jun 5, 2023
36C25023Q0638 0002.docx	DOCX document	May 25, 2023
36C25023Q0638 0001.docx	DOCX document	May 23, 2023
36C25023Q0638.docx	DOCX document	May 10, 2023
23Q0638 - QASP.pdf	PDF	May 10, 2023
Price-Cost Schedule 23Q0638.xlsx	XLSX spreadsheet	May 10, 2023

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.

Instructions

PLEASE enter PRICE PER UNIT into Column E and enter any additional services (if required) into Column H.
CLIN/SLIN	Service/Item(s)	Estimated lbs./Year	Unit Measure	Price/Lb.*	Estimated Product Weight (EA Per LB)	Quantity Conversion
Special Service/Each*	Total Price
0002AB	Scrub Shirts	34237	EA	$ 0.67	2	17119.000	$ 0.50	$ 28,588.23

Conversion: (Column G) is the result of taking the amount in (Column C) and dividing by (Column F) to achieve an estimated weight

Total Price Formula is (=sum(E6*G6)+ (C6*H6))

Example, if you charge .67/LB for laundering and .50/EA for Special Service the total price is $28,558.23 for that SLIN during period of performance

All totals will populate into the appropriate CLINS from your inputs into Column E and Column H

If you do not charge special service charges simply enter (0) into the appropriate fields

Pricing Sheet

Base Period 09-1-2023 through 03-31-2024
CLIN/SLIN	Service/Item(s)	Estimated / Period	Unit Measure	Price/Lb.*	Estimated Product Weight (EA Per LB)	Quantity Conversion
Special Service/Each*	Total Price
0001	General Linen Items						CLIN TOTAL	$ - 0
0001AA	General Linen	828919	lb.					$ - 0
0001AB	OR/Surgery	70203	lb.					$ - 0
0002	Patient Clothing						CLIN TOTAL	$ - 0
0002AA	Laundry Bags	7455.0	lb.	$ - 0				$ - 0
0002AB	Scrub Shirts	34237	EA		2	17119.000	$ - 0	$ - 0
0002AC	Scrub Shirts (Special Service)	Pricing for this Line item is indicated in H8* if applicable
0002AD	Scrub Pants	33474	EA		2	16737.000		$ - 0
0002AE	Scrub Pants (Special Service)	Pricing for this Line item is indicated in H10* if applicable
0002AF	Scrub Warm-Ups	3129	EA		2	1565.000		$ - 0
0002AG	Scrub Warm-Ups (Special Service)	Pricing for this Line item is indicated in H12* if applicable
0002AH	Uniform Dresses	119	EA		3.333	36.000		$ - 0
0002AJ	Uniform Dresses (Special Service)	Pricing for this Line item is indicated in H14* if applicable
0002AK	Lab Coats Long	4158	EA	$ - 0	1	4158.000		$ - 0
0002AL	Lab Coats Long (Special Service)	Pricing for this Line item is indicated in H16* if applicable
0002AM	Lab Coats Short	1890	EA	$ - 0	1	1890.000		$ - 0
0002AN	Lab Coats Short (Special Service)	Pricing for this Line item is indicated in H18* if applicable
0002AP	Barrier Lab Coats	875	EA	$ - 0	1	875.000		$ - 0
0002AQ	Barrier Lab Coats (Special Service)	Pricing for this Line item is indicated in H20* if applicable
0003	Housekeepers/Warehouse/ Dietary/Engineering/Painters						CLIN TOTAL	$ - 0
0003AA	Processed Uniforms	5922	lb.					$ - 0
0004	Specialty Items Slings						CLIN TOTAL	$ - 0
0004AA	Slings, Cleaning	5691	EA		1	5691.000		$ - 0
0004AB	Slings, Cleaning (Special Service)	Pricing for this Line item is indicated in H25* if applicable
0004AB	Initial Chipping Sling* Estimated	581	EA					$ - 0
0004AC	Re-Tasking (Chipping) Slings	434	EA					$ - 0
0005	Specialty Items Other						CLIN TOTAL	$ - 0
0005AA	Cubicle Curtain	497	EA	$ - 0	0.33	1506.000		$ - 0
0005AB	Cubicle Curtain (Special Service)	Pricing for this Line item is indicated in H30* if applicable
0005AC	Table Skirts	840	EA	$ - 0	1	840.000		$ - 0
0005AD	Table Skirts (Special Service)	Pricing for this Line item is indicated in H32* if applicable
0005AE	Table Clothes	602	EA	$ - 0	1	602.000		$ - 0
0005AF	Table Clothes (Special Service)	Pricing for this Line item is indicated in H34* if applicable
0005AG	Napkins	31941	EA	$ - 0	20	1597.000		$ - 0
0005AH	Napkins (Special Service)	Pricing for this Line item is indicated in H36* if applicable
0005AJ	Hover Mats	504	EA	$ - 0	1	504.000		$ - 0
0005AK	Hover Mats (Special Service)	Pricing for this Line item is indicated in H38* if applicable
0005AL	Microfiber Dust Mop	5460	EA	$ - 0	2.5	2184.000		$ - 0
0005AM	Microfiber Dust Mop (Special Service)	Pricing for this Line item is indicated in H40* if applicable
0005AN	String Mops	21581	EA	$ - 0	1	21581.000		$ - 0
0005AP	String Mops (Special Service)	Pricing for this Line item is indicated in H42* if applicable
0005AQ	Microfiber Mops	48503	EA	$ - 0	2.5	19401.000		$ - 0
0005AR	Microfiber Mops (Special Service)	Pricing for this Line item is indicated in H44* if applicable
0005AS	Aprons	4550	EA	$ - 0	4	1138.000		$ - 0
0005AT	Aprons (Special Service)	Pricing for this Line item is indicated in H46* if applicable
0005AU	Hypoallergenic Packs	1855	EA	$ - 0	1	1855.000		$ - 0
0005AV	Hypoallergenic Packs (Special Service)	Pricing for this Line item is indicated in H48* if applicable
0006	Uniform Purchases						CLIN TOTAL	$ - 0
0006AA	Uniforms	11732	EA	$ - 0				$ - 0
0007	Loss Charges / LB						CLIN TOTAL	$ - 0
0007AA	Loss Charges / LB	137620	EA	$ - 0				$ - 0
0008	alEX CBOC Distibution	Visits / YR	Frequency	$ / Visit	Per Year	CLIN Total	$ - 0
0008AA	Akron CRRC	28	WK	$ - 0	$ - 0
0008AB	Akron Annex	28	WK	$ - 0	$ - 0
0008AC	Canton - CBOC	28	WK	$ - 0	$ - 0
0008AD	East Liverpool - CBOC	7	MO	$ - 0	$ - 0
0008AE	Lorain - CBOC	14	EOW	$ - 0	$ - 0
0008AF	Mansfield - CBOC	28	WK	$ - 0	$ - 0
0008AG	Parma - CBOC	28	WK	$ - 0	$ - 0
0008AH	Lake County OP	28	WK	$ - 0	$ - 0
0008AJ	Sandusky - CBOC	14	EOW	$ - 0	$ - 0
0008AK	Cleveland Hemo Dialysis	56	2xWK	$ - 0	$ - 0
0008AL	Cleveland Surgical Center	56	2XWK	$ - 0	$ - 0
0009	CBOC Non-alEx Distibution	Visits / YR	Frequency	$ / Visit	Per Year	CLIN Total	$ - 0
0009AA	New Philadelphia - CBOC	11	OC* Estimated	$ - 0	$ - 0
0009AB	Ravenna - CBOC	7	MO	$ - 0	$ - 0
0009AC	Warren - CBOC	7	MO	$ - 0	$ - 0
0009AD	Youngstown - CBOC	28	WK	$ - 0	$ - 0
0009AE	VA Cleve CRRC	28	WK	$ - 0	$ - 0
0008AF	Cleveland Transitional Housing	28	WK	$ - 0	$ - 0

Option Year 1 - 4/1/2024 through 03/31/2025
CLIN/SLIN	Service/Item(s)	Estimated / Period	Unit Measure	Price/Lb.*	Estimated Product Weight (EA Per LB)	Quantity Conversion
Special Service/Each*	Total Price
1001	General Linen Items						CLIN TOTAL	$ - 0
1001AA	General Linen	1421005	lb.					$ - 0
1001AB	OR/Surgery	120345	lb.					$ - 0
1002	Patient Clothing						CLIN TOTAL	$ - 0
1002AA	Laundry Bags	19258	lb.	$ - 0				$ - 0
1002AB	Scrub Shirts	58696	EA		2	29348.000		$ - 0
1002AC	Scrub Shirts (Special Service)	Pricing for this Line item is indicated in H81* if applicable
1002AD	Scrub Pants	57386	EA		2	28693.000		$ - 0
1002AE	Scrub Pants (Special Service)	Pricing for this Line item is indicated in H83* if applicable
1002AF	Scrub Warm-Ups	5360	EA		2	1565.000		$ - 0
1002AG	Scrub Warm-Ups (Special Service)	Pricing for this Line item is indicated in H85* if applicable
1002AH	Uniform Dresses	200	EA		3.333	36.000		$ - 0
1002AJ	Uniform Dresses (Special Service)	Pricing for this Line item is indicated in H87* if applicable
1002AK	Lab Coats Long	7129	EA	$ - 0	1	7129.000		$ - 0
1002AL	Lab Coats Long (Special Service)	Pricing for this Line item is indicated in H89* if applicable
1002AM	Lab Coats Short	3238	EA	$ - 0	1	3238.000		$ - 0
1002AN	Lab Coats Short (Special Service)	Pricing for this Line item is indicated in H91* if applicable
1002AP	Barrier Lab Coats	1501	EA	$ - 0	1	1501.000		$ - 0
1002AQ	Barrier Lab Coats (Special Service)	Pricing for this Line item is indicated in H93* if applicable
1003	Housekeepers/Warehouse/ Dietary/Engineering/Painters						CLIN TOTAL	$ - 0
1003AA	Processed Uniforms	10154	lb.	$ - 0				$ - 0
1004	Specialty Items Slings						CLIN TOTAL	$ - 0
1004AA	Slings, Cleaning	9750	EA		1	9750.000		$ - 0
1004AB	Slings, Cleaning (Special Service)	Pricing for this Line item is indicated in H98* if applicable
1004AC	Initial Chipping Sling* Estimated	1000	EA					$ - 0
1004AD	Re-Tasking (Chipping) Slings	750	EA					$ - 0
1005	Specialty Items Other						CLIN TOTAL	$ - 0
1005AA	Cubicle Curtain	851	EA	$ - 0	0.33	1506.000		$ - 0
1005AB	Cubicle Curtain (Special Service)	Pricing for this Line item is indicated in H103* if applicable
1005AC	Table Skirts	1435	EA	$ - 0	1	1435.000		$ - 0
1005AD	Table Skirts (Special Service)	Pricing for this Line item is indicated in H105* if applicable
1005AE	Table Clothes	1037	EA	$ - 0	1	1037.000		$ - 0
1005AF	Table Clothes (Special Service)	Pricing for this Line item is indicated in H107* if applicable
1005AG	Napkins	54750	EA	$ - 0	20	1597.000		$ - 0
1005AH	Napkins (Special Service)	Pricing for this Line item is indicated in H109* if applicable
1005AJ	Hover Mats	867	EA	$ - 0	1	867.000		$ - 0
1005AK	Hover Mats (Special Service)	Pricing for this Line item is indicated in H111* if applicable
1005AL	Microfiber Dust Mop	9478	EA	$ - 0	2.5	3792.000		$ - 0
1005AM	Microfiber Dust Mop (Special Service)	Pricing for this Line item is indicated in H113* if applicable
1005AN	String Mops	37000	EA	$ - 0	1	37000.000		$ - 0
1005AP	String Mops (Special Service)	Pricing for this Line item is indicated in H115* if applicable
1005AQ	Microfiber Mops	83150	EA	$ - 0	2.5	19401.000		$ - 0
1005AR	Microfiber Mops (Special Service)	Pricing for this Line item is indicated in H117* if applicable
1005AS	Aprons	7800	EA	$ - 0	4	1138.000		$ - 0
1005AT	Aprons (Special Service)	Pricing for this Line item is indicated in H119* if applicable
1005AU	Hypoallergenic Packs	3182	EA	$ - 0	1	3182.000		$ - 0
1005AV	Hypoallergenic Packs (Special Service)	Pricing for this Line item is indicated in H121* if applicable
1006	Uniform Purchases						CLIN TOTAL	$ - 0
1006AA	Uniforms	20105	EA	$ - 0				$ - 0
1007	Loss Charges / LB						CLIN TOTAL	$ - 0
1007AA	Loss Charges / LB	261456	EA	$ - 0				$ - 0
1008	alEX CBOC Distibution	Visits / YR	Frequency	$ / Visit	Per Year	CLIN Total	$ - 0
1008AA	Akron CRRC	52	WK	$ - 0	$ - 0
1008AB	Akron Annex	52	WK	$ - 0	$ - 0
1008AC	Canton - CBOC	52	WK	$ - 0	$ - 0
1008AD	East Liverpool - CBOC	12	MO	$ - 0	$ - 0
1008AE	Lorain - CBOC	26	EOW	$ - 0	$ - 0
1008AF	Mansfield - CBOC	52	WK	$ - 0	$ - 0
1008AG	Parma - CBOC	52	WK	$ - 0	$ - 0
1008AH	Lake County OP	52	WK	$ - 0	$ - 0
1008AJ	Sandusky - CBOC	26	EOW	$ - 0	$ - 0
1008AK	Cleveland Hemo Dialysis	104	2xWK	$ - 0	$ - 0
1008AL	Cleveland Surgical Center	104	2XWK	$ - 0	$ - 0
1009	CBOC Non-alEx Distibution	20	Frequency	$ / Visit	Per Year	CLIN Total	$ - 0
1009AA	New Philadelphia - CBOC	20	OC* Estimated	$ - 0	$ - 0
1009AB	Ravenna - CBOC	12	MO	$ - 0	$ - 0
1009AC	Warren - CBOC	12	MO	$ - 0	$ - 0
1009AD	Youngstown - CBOC	52	WK	$ - 0	$ - 0
1009AE	VA Cleve CRRC	52	WK	$ - 0	$ - 0
1009AF	Cleveland Transitional Housing	52	WK	$ - 0	$ - 0

Option Year 2 - 4/1/2025 through 03/31/2026
CLIN/SLIN	Service/Item(s)	Estimated / Period	Unit Measure	Price/Lb.*	Estimated Product Weight (EA Per LB)	Quantity Conversion
Special Service/Each*	Total Price
2001	General Linen Items						CLIN TOTAL	$ - 0
2001AA	General Linen	1563105	lb.					$ - 0
2001AB	OR/Surgery	126360	lb.					$ - 0
2002	Patient Clothing						CLIN TOTAL	$ - 0
2002AA	Laundry Bags	20632	lb.	$ - 0				$ - 0
2002AB	Scrub Shirts	62804	EA		2	31402	$ - 0	$ - 0
2002AC	Scrub Shirts (Special Service)	Pricing for this Line item is indicated in H154* if applicable
2002AD	Scrub Pants	61403	EA		2	30702		$ - 0
2002AE	Scrub Pants (Special Service)	Pricing for this Line item is indicated in H156* if applicable
2002AF	Scrub Warm-Ups	5735	EA		2	1565.000		$ - 0
2002AG	Scrub Warm-Ups (Special Service)	Pricing for this Line item is indicated in H158* if applicable
2002AH	Uniform Dresses	214	EA		3.333	36.000		$ - 0
2002AJ	Uniform Dresses (Special Service)	Pricing for this Line item is indicated in H160* if applicable
2002AK	Lab Coats Long	7628	EA	$ - 0	1	7628.000		$ - 0
2002AL	Lab Coats Long (Special Service)	Pricing for this Line item is indicated in H162* if applicable
2002AM	Lab Coats Short	3465	EA	$ - 0	1	3465.000		$ - 0
2002AN	Lab Coats Short (Special Service)	Pricing for this Line item is indicated in H164* if applicable
2002AP	Barrier Lab Coats	1606	EA	$ - 0	1	1606.000		$ - 0
2002AQ	Barrier Lab Coats (Special Service)	Pricing for this Line item is indicated in H166* if applicable
2003	Housekeepers/Warehouse/ Dietary/Engineering/Painters						CLIN TOTAL	$ - 0
2003AA	Processed Uniforms	11169	lb.	$ - 0				$ - 0
2004	Specialty Items Slings						CLIN TOTAL	$ - 0
2004AA	Slings, Cleaning	10433	EA		1	10433.000		$ - 0
2004AB	Slings, Cleaning (Special Service)	Pricing for this Line item is indicated in H171* if applicable
2004AC	Initial Chipping Sling* Estimated	1070	EA					$ - 0
2004AD	Re-Tasking (Chipping) Slings	803	EA					$ - 0
2005	Specialty Items Other						CLIN TOTAL	$ - 0
2005AA	Cubicle Curtain	851	EA	$ - 0	0.33	1506.000		$ - 0
2005AB	Cubicle Curtain (Special Service)	Pricing for this Line item is indicated in H176* if applicable
2005AC	Table Skirts	1435	EA		1	1435.000		$ - 0
2005AD	Table Skirts (Special Service)	Pricing for this Line item is indicated in H178* if applicable
2005AE	Table Clothes	1037	EA	$ - 0	1	1037.000		$ - 0
2005AF	Table Clothes (Special Service)	Pricing for this Line item is indicated in H180* if applicable
2005AG	Napkins	58583	EA	$ - 0	20	1597.000		$ - 0
2005AH	Napkins (Special Service)	Pricing for this Line item is indicated in H182* if applicable
2005AJ	Hover Mats	928	EA	$ - 0	1	928.000		$ - 0
2005AK	Hover Mats (Special Service)	Pricing for this Line item is indicated in H184* if applicable
2005AL	Microfiber Dust Mop	10141	EA		2.5	4056		$ - 0
2005AM	Microfiber Dust Mop (Special Service)	Pricing for this Line item is indicated in H186* if applicable
2005AN	String Mops	40700	EA	$ - 0	1	40700.000		$ - 0
2005AP	String Mops (Special Service)	Pricing for this Line item is indicated in H188* if applicable
2005AQ	Microfiber Mops	87171	EA	$ - 0	2.5	19401.000		$ - 0
2005AR	Microfiber Mops (Special Service)	Pricing for this Line item is indicated in H190* if applicable
2005AS	Aprons	8346	EA	$ - 0	4	1138.000		$ - 0
2005AT	Aprons (Special Service)	Pricing for this Line item is indicated in H192* if applicable
2005AU	Hypoallergenic Packs	3405	EA	$ - 0	1	3405.000		$ - 0
2005AV	Hypoallergenic Packs (Special Service)	Pricing for this Line item is indicated in H194* if applicable
2006	Uniform Purchases						CLIN TOTAL	$ - 0
2006AA	Uniforms	21512	EA	$ - 0				$ - 0
2007	Loss Charges / LB						CLIN TOTAL	$ - 0
2007AA	Loss Charges / LB	261456	EA	$ - 0				$ - 0
2008	alEX CBOC Distibution	Visits / YR	Frequency	$ / Visit	Per Year	CLIN Total	$ - 0
2008AA	Akron CRRC	52	WK	$ - 0	$ - 0
2008AB	Akron Annex	52	WK	$ - 0	$ - 0
2008AC	Canton - CBOC	52	WK		$ - 0
2008AD	East Liverpool - CBOC	12	MO		$ - 0
2008AE	Lorain - CBOC	26	EOW	$ - 0	$ - 0
2008AF	Mansfield - CBOC	52	WK	$ - 0	$ - 0
2008AG	Parma - CBOC	52	WK	$ - 0	$ - 0
2008AH	Lake County OP	52	WK	$ - 0	$ - 0
2008AJ	Sandusky - CBOC	26	EOW	$ - 0	$ - 0
2008AK	Cleveland Hemo Dialysis	104	2xWK		$ - 0
2008AL	Cleveland Surgical Center	104	2XWK	$ - 0	$ - 0
2009	CBOC Non-alEx Distibution	20	Frequency	$ / Visit	Per Year	CLIN Total	$ - 0
2009AA	New Philadelphia - CBOC	20	OC* Estimated	$ - 0	$ - 0
2009AB	Ravenna - CBOC	12	MO	$ - 0	$ - 0
2009AC	Warren - CBOC	12	MO	$ - 0	$ - 0
2009AD	Youngstown - CBOC	52	WK	$ - 0	$ - 0
2009AE	VA Cleve CRRC	52	WK	$ - 0	$ - 0
2009AF	Cleveland Transitional Housing	52	WK	$ - 0	$ - 0

Total

Performance Period	Value
Short Base	$ - 0
OY1	$ - 0
OY2	$ - 0
Total Contract Value	$ - 0
Pricing for each CLIN is derived from the totals deposited in the subsequent SLIN.

Example: I4 = C3*E3, I3 = I4:I5. Each POP total in Column L is data from the corresponding SLINs that occur during that particular POP

You cannot edit NSP data in Column K .

Please report any discrepencies/formatting issues to Joshua.Kovar@VA.gov

Note: Some identified and listed quantities are estimates (CLIN 0001 - 0007 and subsequent Options).

Vendor shall invoice monthly, for ONLY actual services rendered.

DO NOT perform other than those identified in Base CLINs (0001-0009), OY1 (1001-1009), OY2 (2001-2009), unless the ACO has issued a modification to the contract to add a CLIN for that sepcific action.

Contractor shall invoice for Actual Performance and shall indicate CLINs/SLINs on all invoices.

File details come from the government source that posted it. Updated Jun 5, 2023.