vancouver_encampment_cleanup_cost.xlsx

	A	B	D	E	F	G
1	Vancouver Encampment Cleanup Cost Summary
2	Based on Encampment_Cleanup_Database_2021-3.4.26.xlsx, Costing sheet (231 cleanup-event rows; 2021-03-09 to 2026-02-12).
3
4	Metric	Value	Category	Amount	% of reconstructed total	Notes
5	Cleanup events in Costing sheet	231 events	Contractor cleanup / biohazard response	$647,753	46.9%	Rapid/Bio Management/Junk It cleanup contractor columns
6	Date range	2021-03-09 to 2026-02-12	Disposal / CRC dump fees	$167,902	12.1%	Dump/CRC disposal costs and tonnage records
7	Cleanup-only hard costs	$815,655	City labor + vehicle costs	$566,253	41.0%	Outside the narrow PRA hard-cost scope, but included in worksheet
8	Internal labor/vehicle costs listed	$566,253
9	Reconstructed total from components	$1,381,908
10	Spreadsheet Total Cost column sum	$1,361,797
11	Total Cost column apparent understatement	$20,111
12	Tonnage recorded	1,726.9
13
14
15	Key Takeaways
16	1. The cleanup-only hard cost is about $815,655: contractor cleanup/biohazard response plus CRC disposal.
17	2. The workbook also lists about $566,253 in City labor and vehicle costs; those were outside the narrow PRA hard-cost request, but they matter for a full cost picture.
18	3. Burnt Bridge Creek / trail corridor and Share House / Jefferson / downtown corridor dominate the hard-cost total.
19	4. The worksheet Total Cost column appears to understate the reconstructed component total by $20,111.10 because several 2025/2026 rows omit Rapid Cost from Total Cost.
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
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