UV Cost-Benefit Model.xlsx

	A	B	C	D	E	G	H	I	J	L	M	N	O
1	SITE INPUTS					222nm PRICES					254nm (upper room) PRICES
2		Building	Net Floor Area	200	m2	Currency Multiplier		1	NZD	Currency Multiplier		1	NZD
3			Room Height	3	m	Unit Price		$4,759	+GST	Unit Price		$5,346	+GST
4			Typical Head Height Above Floor	1.3	m
5			Days of Operation (per year)	250	Days	Shipping		$2,200	+GST	Shipping		$2,200	+GST
6			Hours of Operation (per day)	8	Hours	Installation		$6,000	+GST	Installation		$279	+GST
7			Electricity Price	0.22	$/KWh	Unit replacement cost		$1,716	+GST	Unit replacement cost		$1,716	+GST
8			Air Changes per Hour (ACH)	4		Discount rate		2.0%	pa	Discount rate		2.0%	pa
9		People	Occupants	30
10			Approximate Age	Teen/Adult
11			Average Annual Value (per Occupant)	$300,000
12			Baseline sickdays from respiratory illness caught within the building	0.26
13			% of hours spent WFH or Out Of Office	20%
14
15	COSTS	60° unit	Estimated Units Needed	43		100° unit	Estimated Units Needed	10		Upper Room Unit	Units Needed	2
16			Capex	$212,837			Capex	$55,790			Capex	$13,171
17			Unit Power	20.0	W		Unit Power	20	W		Unit Power	75	W
18			Hours of Operation (per day)	6.4	Hours		Hours of Operation (per day)	6.4	Hours		Hours of Operation (per day)	8.0	Hours
19			Daily Consumption	5504	Wh		Daily Consumption	1280	Wh		Daily Consumption	1200	Wh
20			Daily Electicity Cost	$ 1.21			Daily Electicity Cost	$ 0.28			Daily Electicity Cost	$ 0.26
21			Annual Electricity Cost	$ 302.72			Annual Electricity Cost	$ 70.40			Annual Electricity Cost	$ 66.00
22			Bulb Lifetime	10000	Hours		Bulb Lifetime	10000	Hours		Bulb Lifetime	10000	Hours
23			Replace after	6.3	Years		Replace after	6.3	Years		Replace after	5.0	Years
24			Unit replacement cost	$1,716			Unit replacement cost	$1,716			Unit replacement cost	$5,346
25			Number of Replacements	2			Number of Replacements	2			Number of Replacements	3
26			Replacement Costs (within 20years)	$3,432			Replacement Costs (within 20 years)	$3,432			Replacement Costs (within 20 years)	$16,038
27			Years of Operation	18.8			Years of Operation	18.8			Years of Operation	20.0
28			Lifetime Cost	$221,945			Lifetime Cost	$60,542			Lifetime Cost	$30,529
29
30	BENEFITS
31		Likelihood of infection from another infectious occupant		0.039	per person	Likelihood of infection from another infectious occupant		0.039	per person	Likelihood of infection from another infectious occupant		0.039	per person
32		Likelihood of infection with 60° units installed		0.003	per person	Likelihood of infection (per person) with 100° units installed		0.013	per person	Likelihood of infection (per person) with upper room units installed		0.023	per person
33		Infection rate reduction		93.1%		Infection rate reduction		66.0%		Infection rate reduction		39.7%
34		Fewer Annual Sick Days		7.34		Fewer Annual Sick Days		5.20		Fewer Annual Sick Days		3.13
35		Annual Savings		$8,805		Annual Savings		$6,238		Annual Savings		$3,752
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100