Table 2.

COVID-19 Surge Planning Model Using Cardiac Medications as an Example.

	A	B	C	D	E	F	G	H	I	J	K	L	M
1							20*		20*			75%*
2							x = patient weight (kg)		y = days/admission			z = census adjustment Factor
3	Formulas						=(E3*$G$1)/C3		=H3*G3*$K$1			=K3*($J$1/30)*$L$1	MAX(0,(J3-L3)/I3)
4	Category	Medication	Ref Product	Units	Input Dose*	Units	Products used/day	Estimated Use*	Qty consumed per admission for (y) days	Inventory*	Use Per Month*	Use for (X) days with Global Census Adjustment	[Surge Capacity over (x) days with Census Factor (z)]
5	CARDIAC MEDICATIONS	Epinephrine	1	mg	0.05	mcg/kg/min	1.4	25%	7	2750	2500	1250	208
6		Norepinephrine	4	mg	0.05	mcg/kg/min	0.4	15%	1	100	65	33	63
7		Vasopressin	20	units	0.5	milliunits/kg/min	0.7	5%	1	195	91	45	208
8		Phenylephrine	10	mg	0.5	mcg/kg/min	1.4	10%	3	447	102	51	138
9		Alprostadil	500	mcg	0.05	mcg/kg/min	2.9	1%	1	80	43	22	102
10		Amiodarone	150	mg	5	mcg/kg/min	1.0	5%	1	259	207	104	162
11		Atropine	1	mg	0.02	mg/kg ONCE	0.4	1%	0	60	95	47	159
12		Clevidipine	50	mg	2	mcg/kg/min	1.2	10%	2	175	280	140	15
13		Esmolol	2000	mg	100	mcg/kg/min	1.4	5%	1	136	39	20	81
14		Lidocaine	50	mg	20	mcg/kg/min	11.5	5%	12	1369	1209	605	66
15		Sodium Bicarbonate	50	mEq	1	mEq/kg 3x/day	1.2	20%	5	534	319	160	78

*Input variables

Column M (Surge capacity) was automatically highlighted in for <25 patinets, for 25-100 patients and for >100 patients.