SP_Attachment-2_Cost Sheet.xlsx

XLSX spreadsheet 38 KB Posted May 18, 2023

Attached to: NOTICE OF SPECIAL PROCUREMENT AMENDMENT: Pharmacy Automation Equipment, Software and Services
Solicitation number: S-DASOBO-00006947
Issued by: Marion County, Oregon

About this file

Written by GovTribe AI · Apr 3, 2024

This document is related to a state and local contract opportunity for Pharmacy Automation Equipment, Software, and Services. The opportunity is being issued by Marion County and the City of Salem, Oregon. The contract will include the lease and purchase of pharmacy automation equipment, software, and related services. The contract has multiple amendments, with the latest amendment (#4) addressing a lease that rolled over to month-to-month and should have been re-executed. The contract has an original NTE (not-to-exceed) amount of $1,010,963.34, which has been increased through subsequent amendments up to a current NTE of $5,533,082.74 for the lease portion only. There is an additional NTE of $10,309,765.55 for the purchase portion, for a total combined NTE of $10,570,713.74. The contract includes a variety of leased pharmacy equipment, servers, and automated dispensing cabinets. Funding for this contract comes from the participating agencies, and the contract term includes renewal options.

View the file

Other files

File	Type	Posted
SP_REQ-DASOBO-00030542_Amd-1_OSH Pharmacy_Approved.pdf	PDF	May 18, 2023
SP_Attachment-1_REQ-DASOBO-00018863_Approved.pdf	PDF	May 18, 2023
SP-REQ-DASOBO-00030542_Amend_1_Special_Procurement_Notice.pdf	PDF	May 18, 2023
SP_Attachment-1_Oregon-Agency-Expectations.pdf	PDF	May 18, 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.

MAIN

REQ-DASOBO-00030542
Cost Sheet
SP Attachment - 1
AMENDMENT #	PRICING SUPPLEMENT	LEASE RENTAL #	Month/Unit Cost	DESCRIPTION	PO#	LEASE START	LEASE END	COST ADJUST	PURCHASE ORDER COST	NTE INCREASE	NTE BALANCE
ORIGINAL CONTRACT
	5028170	CMS005941	$5,214.40	MedOne Lease Number 1	CONTRACT	1/1/14	12/31/18		$314,281.92
	5029897	CMS006131	$1,942.20	MedOne Lease Number 2	CONTRACT	4/1/14	3/31/19		$119,134.94
	5042384	CMS006130	$9,532.03	MedOne Lease Number 3	CONTRACT	4/1/14	3/31/19		$577,546.48
ORIGINAL CONTRACT TOTAL: $1,010,963.34									$1,010,963.34	$0.00	$1,010,963.34
AMENDMENT #1
See note

Reynolds David O: Reynolds David O:

This is the lease that rolled over to month to month 6/1/20 that we have continued to pay as we require the equipment. A new lease should have been executed.	5058861	CMS006705	$7,037.03	MedOne Lease Number 4	PO329664	6/1/15	5/31/20		$429,229.31		$429,229.31
	AMENDMENT #1 TOTAL $429,229.31 CONTRACT TOTAL $1,440,192.65									$1,440,192.65		$429,229.31	$1,440,192.65
	AMENDMENT #2
		5030962	CMS007093	$1,756.25	MedOne Lease Number 5	CONTRACT	2/1/16	1/31/21		$105,843.75		$105,843.75
		5148295	CMS007282	$3,016.09	MedOne Lease Number 8 OSH Servers - Original Order	PO335632	8/1/16	7/31/19	$111,896.64	$109,039.88		$109,039.88
		5161930	N/A		OSH Servers - Change Order (Returns)	PO335632			-$83,922.48	-		-
		5161656	N/A		OSH Servers - Change Order (Adds)	PO335632			$81,065.72	-		-
		5153560	CMS007367	$2,769.77	MedOne Lease Number 9 Atmosera Servers - Original Order	PO335816	10/1/16	9/30/19	$111,896.64	$101,403.92		$101,403.92
		5161957	N/A		Atmosera Servers - Change Order (Returns)	PO335816			-$83,922.48	-		-
		5161956	N/A		Atmosera Servers - Change Order (Adds)	PO335816			$73,429.76	-		-
		5102537	CMS007648	$48,657.94	MedOne Lease Number 14 Automated Dispensing Cabinets (Adjustments from 5030405)	PO334641	4/1/17	3/31/22	$2,655,741.89	$2,962,186.49		$2,962,186.49
		5030405	N/A		ADC's from base contract	PO334641	4/1/17	3/31/22	$2,441,949.16	-		-
		5102600	N/A		Debooks PS#5030405	PO334641		N/A	-$2,135,504.56	-		-
	AMENDMENT #2 TOTAL									$3,278,474.04		$3,278,474.04	$4,718,666.69
	AMENDMENT #3
		5204894	CMS007586	$386.78	MedOne Lease Number 10	PO339134	2/1/17	5/31/19		$10,829.84		$10,829.84
		5206097	CMS007589	$386.78	MedOne Lease Number 11	PO339134	2/1/17	5/31/19		$10,829.84		$10,829.84
		5206103	CMS007587	$267.76	MedOne Lease Number 12	PO339133	2/1/17	5/31/19		$11,245.92		$11,245.92
		5204895	CMS007588	$386.78	MedOne Lease Number 13	PO339133	2/1/17	5/31/19		$10,829.84		$10,829.84
	Active Lease, Payment to MedOne	5330131	CMS008464	$98.30	MedOne Lease Number 15	PO347732	9/1/18	8/31/23		$5,898.00		$5,898.00
		5363251	CMS008572	$101.89	MedOne Lease Number 16	PO349224	12/1/18	2/28/22		$4,011.82		$4,011.82
	Active Lease, Payment to MedOne	5381860	CMS008716	$96.44	MedOne Lease Number 17	PO350149	4/1/19	9/30/23		$5,249.61		$5,249.61
	Active Lease, Payment to MedOne	5381861	CMS008717	$96.44	MedOne Lease Number 18	PO350177	4/1/19	9/30/23		$5,249.61		$5,249.61
	Active Lease, Payment to MedOne	5376672	CMS008752	$8,898.04	MedOne Lease Number 19	PO350236	4/1/19	8/31/23		$471,596.12		$471,596.12
	AMENDMENT #3 TOTAL									$535,740.60		$535,740.60	$5,254,407.29
	AMENDMENT #4

Woods Jill S: Woods Jill S:

This is the lease that rolled over to month to month 6/1/20 that we have continued to pay as we require the equipment. A new lease should have been executed.

Reynolds David O: Reynolds David O:

This is the lease that rolled over to month to month 6/1/20 that we have continued to pay as we require the equipment. A new lease should have been executed.

Payment made to OmniCell	VP251841	7145.71	LS# CMS006705 JUNE 2020 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP251841	7145.71	LS# CMS006705 JULY 2020 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP250778	7145.71	LS# CMS006705 AUG 2020 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP250778	7145.71	LS# CMS006705 SEPT 2020 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP250778	7145.71	LS# CMS006705 OCT 2020 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP251732	7145.71	LS# CMS006705 NOV 2020 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP253105	7145.71	LS# CMS006705 DEC 2020 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP255693	7145.71	LS# CMS0006705 JAN 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP258425	7145.71	LS# CMS006705 FEB 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP258385	7145.71	LS# CMS006705 MARCH 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP260586	7145.71	LS# CMS006705 APR 2021			$7,145.71	$7,145.71
Payment made to OmniCell	VP261989	7145.71	LS#CMS006705 MAY 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP263984	7145.71	LS# CMS006705 JUNE 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP266786	7145.71	LS# CMS006705 JULY 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP271314	7145.71	LS# CMS006705 AUGUST 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP271314	7145.71	LS# CMS006705 SEPT 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP275300	7145.71	LS# CMS006705 OCT 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP275300	7145.71	LS# CMS006705 NOV 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP276753	7145.71	LS# CMS006705 DEC 2021 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP277725	7145.71	LS# CMS006705 JAN 2022 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP280254	7145.71	LS# CMS006705 FEB 2022 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP282475	7145.71	LS# CMS006705 MAR 2022 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP290036	7145.71	LS# CMS006705 APR 2022 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP290036	7145.71	LS# CMS006705 MAY 2022 OSH			$7,145.71	$7,145.71
Payment made to OmniCell	VP291288	7145.71	LS# CMS006705 JUNE 2022 OSH			$7,145.71	$7,145.71
	JC MTM	7145.71	Month to Month Rental Expired CMS006705	7/1/22	8/31/23	$100,039.94	$100,039.94
AMENDMENT #4 TOTAL							$278,682.69	$5,533,089.98

Lease NTE by EXE

140842 Leases ONLY
PS in which KT Execution	Med One Lease #	Pricing Supplement	PO	Med One Lease Rental #	Adjustments	NTE	Lease Start Date	Notes
Base Contract	1	5028170	N/A	CMS005941	$ - 0	$ 314,281.92	1/1/14	-
Base Contract	2	5029897	N/A	CMS006131	$ - 0	$ 119,134.94	4/1/14	-
Base Contract	3	5042384	N/A	CMS006130	$ - 0	$ 577,546.48	4/1/14	-
						$ 1,010,963.34

NTE Prior to AMD1						$ 1,010,963.34
AMD1	4	5058861	PO329664	CMS006705		$ 429,229.31	6/1/15	This is the lease that rolled over to month to month 6/1/20 that we have continued to pay as we require the equipment. A new lease should have been executed.
NTE Prior to AMD2						$ 1,440,192.65
Base Contract	5	5030962	N/A	CMS007093		$ 105,843.75	2/1/16	-
AMD2	8	5148295	PO335632	CMS007282	$ 111,896.64	$ 109,039.88	8/1/16	OSH Servers - Original Order
AMD2	-	5161930	PO335632	N/A	$ (83,922.48)	-		OSH Servers - Change Order (Returns)
AMD2	-	5161656	PO335632	N/A	$ 81,065.72	-		OSH Servers - Change Order (Adds)
AMD2	9	5153560	PO335816	CMS007367	$ 111,896.64	$ 101,403.92	10/1/16	Atmosera Servers - Original Order
AMD2	-	5161957	PO335816	N/A	$ (83,922.48)	-		Atmosera Servers - Change Order (Returns)
AMD2	-	5161956	PO335816	N/A	$ 73,429.76	-		Atmosera Servers - Change Order (Adds)
AMD2	14	5102537	PO334641	CMS007648	$ 2,655,741.89	$ 2,962,186.49	4/1/17	Automated Dispensing Cabinets (Adjustments from 5030405)
Base Contract	-	5030405	PO334641	N/A	$ 2,441,949.16	-		ADC's from base contract
AMD2	-	5102600	PO334641	N/A	$ (2,135,504.56)	-		Debooks PS#5030405
						$ 3,278,474.04
NTE Prior to AMD3 (NTE on 118 for AMD2)						$ 4,718,666.69

Woods Jill S: Woods Jill S:

Mike Adamson's tracker had the NTE at $4,798,666.69. He had this amount as the NTE on the 118 submitted for AMD2 as well. However, he had the NTE on lease 2, CMS006131 as $199,134.94 in error instead of the $119,134.94 the lease was executed for. This $80,000 difference is the NTE for lease 2 explains the $80,000 difference in Mike's calculations and mine at the execution of AMD2.

New Amd	10	5204894	PO339134	CMS007586	$ 10,829.84
New Amd	11	5206097	PO339134	CMS007589	$ 10,829.84
New Amd	12	5206103	PO339133	CMS007587	$ 11,245.92
New Amd	13	5204895	PO339133	CMS007588	$ 10,829.84
New Amd	15	5330131	PO347732	CMS008464	$ 5,898.00
New Amd	16	5363251	PO349224	CMS008572	$ 4,011.82
New Amd	17	5381860	PO350149	CMS008716	$ 5,249.61
New Amd	18	5381861	PO350177	CMS008717	$ 5,249.61
New Amd	19	5376672	PO350236	CMS008752	$ 471,596.12
					$ 535,740.60
Total NTE of Executed Leases					$ 5,254,407.29

SFMA NTE

Med One Executed Lease #	Pricing Supp	PO	Med One Lease Rental #	Adjustments	Correct NTE	NTE in SFMA
1 - Expired	5028170	N/A	CMS005941		$ 314,281.92	$ 314,281.92
2	5029897	N/A	CMS006131		$ 119,134.94

Woods Jill S: Woods Jill S:

Mike Adamson had this lease NTE at $199,134.94. But, I double checked the PS and past payments for this lease.	$ 199,134.94
	3	5042384	N/A	CMS006130		$ 577,546.48	$ 577,546.48
	4	5058861	PO329664	CMS006705		$ 429,229.31	$ 429,229.31
	5	5030962	N/A	CMS007093		$ 105,843.75	$ 105,843.75
	8	5148295	PO335632	CMS007282	$ 111,896.64

Woods Jill S: Woods Jill S:

All cells highlighted yellow reflect the change orders done and final execution on lease CMS007282	$ 109,039.88	$ 109,039.88
	-	5161930	PO335632	adjustment to -8	$ (83,922.48)	N/A	N/A
	-	5161656	PO335632	adjustment to -8	$ 81,065.72	N/A	N/A
	9	5153560	PO335816	CMS007367	$ 111,896.64

Woods Jill S: Woods Jill S:

All cells highlighted orange reflect the change orders and final executed lease for CMS007367	$ 101,403.92	$ 101,403.92
	-	5161957	PO335816	adjustment to -9	$ (83,922.48)	N/A	N/A
	-	5161956	PO335816	adjustment to -9	$ 73,429.76	N/A	N/A
	10	5204894	PO339134	CMS007586		$ 10,829.84

Woods Jill S: Woods Jill S:

All cells highlighted green reflect leases that I have not added their NTE into the contract NTE in SFMA as I was unaware of them until I discovered Mike's tracker. However, I cannot add this amount now as the NTE in SFMA is arleady overstate due to the excess $80,000 recorded for lease CMS006131 as this overage was built into the SFMA NTE at AMD2

11	5206097	PO339134	CMS007589		$ 10,829.84	RECON COLUMN G TO F, LINE 27
12	5206103	PO339133	CMS007587		$ 11,245.92
13	5204895	PO339133	CMS007588		$ 10,829.84		$ 5,308,399.11	G 27	NTE SFMA
14	5102537	PO334641	CMS007648	$ 2,655,741.89

Woods Jill S: Woods Jill S:

All cells highlighted grey reflect the change orders and final execution of lease CMS007648	$ 2,962,186.49	$ 2,962,186.49			$ (17,727.26)	G26	Less Cost overun
	-	5030405	PO334641	adjustment to -14	$ 2,441,949.16	N/A	N/A		$ (80,000.00)	G28	less over statement
	-	5102600	PO334641	adjustment to -14	$ (2,135,504.56)	N/A	N/A		$ 43,735.44	sum F14-F17	plus column F 14-14 leases
	15	5330131	PO347732	CMS008464		$ 5,898.00	$ 5,898.00		$ 5,254,407.29	TOTAL	matches F27
	16	5363251	PO349224	CMS008572		$ 4,011.82	$ 4,011.82
	17	5381860	PO350149	CMS008716		$ 5,249.61	$ 5,249.61
	18	5381861	PO350177	CMS008717		$ 5,249.61	$ 5,249.61
	19	5376672	PO350236	CMS008752		$ 471,596.12	$ 471,596.12		$5,272,134.55
	Cost Overrun for April, May and June 2022 Payments of Off Lease for CMS006705					-	$ 17,727.26
	Totals:					$ 5,254,407.29	$ 5,308,399.11	Current KT NTE in SFMA Under 140842 (lease portion ONLY)	difference between F27 and G27 SEE TABLE ABOVE
							$ (80,000.00)

Woods Jill S: Woods Jill S:

To Correct $80,000 NTE in SFMA for Overstatement on lease CMS006131 (lease #3 on line 5) Woods Jill S: Woods Jill S:

All cells highlighted green reflect leases that I have not added their NTE into the contract NTE in SFMA as I was unaware of them until I discovered Mike's tracker. However, I cannot add this amount now as the NTE in SFMA is arleady overstate due to the excess $80,000 recorded for lease CMS006131 as this overage was built into the SFMA NTE at AMD2	$5,308,399.11
		$ 5,228,399.11	$5,254,407.29
		$ 43,735.44

Woods Jill S: Woods Jill S:

increase for Leases on Mikes list that I didn't know existed but found PO's for in ADPIX and found 2017 invoice from Med One that included these leases. See leases 10-13 on lines 14-17.

Woods Jill S: Woods Jill S:

All cells highlighted grey reflect the change orders and final execution of lease CMS007648 Woods Jill S: Woods Jill S:

Mike Adamson had this lease NTE at $199,134.94. But, I double checked the PS and past payments for this lease.

Woods Jill S: Woods Jill S:

All cells highlighted yellow reflect the change orders done and final execution on lease CMS007282 Woods Jill S: Woods Jill S:

All cells highlighted orange reflect the change orders and final executed lease for CMS007367	$53,991.82
		$ 5,272,134.55	What should be SFMA NTE 140842 (lease portion ONLY) Currently
		$ 5,037,631.00	NTE for Purchase in SFMA as 140842-4(purchase portion ONLY)

$ 10,309,765.55 Current Total NTE for Leases and Purchase Combined. (G31+G32)

$ 178,642.51	Funds expended to pay expired lease CMS006705 from June 2020-June2022 (amount applied against 140842 in error)
$ (17,727.26)	Less amount of Cost Overrun already added to KT for May 2020-June 2020 payments to Omnicell for expired lease CMS006705
$ 160,915.25	Total additonal funds needed to cover payments already made to Omnicell from June 2020-June 2022 for expired lease CMS006705
$ 100,032.94	Plus funds required to pay expired lease CMS006705 for 14 months (July 2022-August 2023 to match other carousel lease CMS008752/PS5376672)
$ 260,948.19	TOTAL approx additional amount needed in NTE to cover expired lease CMS006705. That currently does NOT have an executed Pricing Supplement and PO. This amount would cover a term of 6/1/20-8/31/23, including payments already made to Omnicell while lease was expired from June 2020-June2022. Plus an addtional POTENTIAL 14 months of future payments from 7/1/22-8/31/23 at the same off lease rate of $7,145.71, if the lease is re-instated and the term is extending to match the expiration of lease CMS008752.

$ 5,533,082.74 TOTAL NEW NTE for Leases ONLY - IF New AMD Done to Reinstate Lease CMS006705 Eff: 6/1/2020-8/31/2023 (G31+G41)

$ 10,570,713.74 TOTAL NEW Total NTE for Leases and Purchase Combined. IF New AMD Done to Reinstate Lease CMS006705 Eff: 6/1/2020-8/31/2023 (G32+G43)

Spent to Date on Purchase Expenditures for Purchase 140842-1 Woods Jill S: Woods Jill S:

To not comingle funds we set up the purchase portion of the contract as 140842-1 in SFMA

PURCHASE: 140842 AMD 3
NTE for Purchase Portion of KT 140842	$ 5,037,631.00

Funds Spent on Equipment and Software to Date on Purchase Portion of KT 140842	$ 3,686,388.07
Funds Spent on Support Services to Date on Purchase Portion of KT 140842:	$ 104,048.00
Total Expenditure to Date on Purchase Portion of KT 140842	$ 3,790,436.07

File details come from the government source that posted it. Updated Apr 3, 2024.