EPA Operating Expense Projections

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	EcoProteccion Akumal (EPA) Operating Expense Projections
2
3	NOTE: These are projections. The actual amounts required to operate and maintain the barrier will be determined after the barrier is installed.
4
5	Barrier length, meters	800
6	In water Installation Services cost per day	$1,310
7	In water Repair Services cost per day	$620
8	Barrier Transportation each way	$1,000
9	Months barrier in water	6						$0
10	Barrier storage monthly rate	$200
11
12	Item	Year 1		Year 2		Year 3		Year 4		Year 5		5 year Totals	Average/year
13		#	Cost	#	Cost	#	Cost	#	Cost	#	Cost
14	Management, Admin, Accounting, Legal	1	$20,000		$21,000		$22,000		$23,000		$24,000
15	Monitoring Services (Drone, Diver, boat)	1	$20,000		$21,000		$22,050		$23,153		$24,310
16	Barrier Storage	12	$2,400		$2,520		$2,646		$2,778		$2,917
17	Barrier Installation (2 days per cycle)	2	$5,240	2	$5,502	2	$5,777	2	$6,066	2	$6,369	$28,954	$5,791
18	Barrier Removal (2 days per cycle)	2	$5,240	2	$5,502	2	$5,777	2	$6,066	2	$6,369	$28,954	$5,791
19	Barrier Transportation (each way)	4	$4,000	4	$4,200	4	$4,410	4	$4,631	4	$4,862	$22,103	$4,421
20	In water repairs	20	$12,400	22	$28,820	24	$31,702	27	$34,872	29	$38,359	$146,154	$29,231
21	Out of water maintenance (days)	4	$2,000	4	$2,100	4	$2,205	4	$2,315	4	$2,431	$11,051	$2,210
22	Parts Provision		$10,000		$15,000		$20,000		$25,000		$30,000	$100,000	$20,000
23
24	Totals		$81,280		$61,124		$69,871		$78,950		$88,391	$379,616	$75,923
25	Unforseen Expenses (+10%)		$8,128		$6,112		$6,987		$7,895		$8,839	$37,962	$7,592
26	Budget Totals		$89,408		$67,236		$76,858		$86,845		$97,230	$417,578	$83,516
27
28
29	Monthly Operating Projections by Bedroom
30	Total bedrooms in HIZ	277
31	Average Monthly Expense per bedroom	$25
32	Average Monthly Expense per 2 bedroom Condo	$50	If every property owner in the HIZ helps cover operating expenses, it will cost about $750 per year per condo to keep the barrier operating
33
34	HIZ bedrooms pledged	133
35	Proposed Monthly Fee per bedroom	$52
36	Proposed Monthly Fee per 2 bedroom Condo	$105	If operating expenses are covered solely by those who have already pledged support for the project, these donors will have to pay about $1,500 per year per condo to keep the barrier operating.
37
38
39		** The HMB Sargassum Project does not expect that the barrier will impact nesting turtles and their hatchlings.
40		Nor do we expect the barrier to cause much additional accumulation of sargassum on the southern headlands.
41		That being said, the initial budget for installation DOES INCLUDE a contingency fund
42		of $100,000 to mitigate either of these problems if it turns our projections are wrong.
43		In other words, any costs associated with these POTENTIAL PROBLEMS are not included here in Projected Operating Expenses.
44
45
46	In Water Daily Service Rate Calculation	Qty	Rate	Total
47	Manager	1	$200.00	$200.00
48	Diver	1	$200.00	$200.00
49	Bonus Pay for HIZ Provided Workers	10	$10.00	$100.00
50	Third Party Workers	10	$25.00	$250.00
51	Boat Rental (includes Captain & Mate)	1	$500.00	$500.00
52	Food & Drink	12	$5.00	$60.00
53
54
55
56	Total			$1,310.00
57
58	In Water Repairs Daily Rate Calculation	Qty	Rate	Total
59	Manager	1	$0.00	$0.00
60	Diver	1	$200.00	$200.00
61	Workers	4	$30.00	$120.00
62	Boat Rental/day	1	$300.00	$300.00
63
64	Total			$620.00
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