VAULT3 Budget Planning

	B	C	D	E	F	G	H	I	J	K	L	M	O
1
2	Workload
3	Category			Rate	01/07/2023	01/08/2023	01/09/2023	01/10/2023	01/11/2023	01/12/2023	01/01/2024	Total hours
4	Development	Full stack development	External	€100	0%	0%	60%	60%	60%	60%	60%	300%
5		Full stack development	Internal	€50	0%	60%	20%	20%	20%	20%	40%	180%
6		UI / UX design	Internal	€50	0%	40%	20%	0%	0%	0%	0%	60%
7		Testing	Internal	€50	0%	5%	5%	5%	5%	10%	30%	60%
8		Team lead	Internal	€50	40%	10%	20%	20%	20%	20%	20%	150%
9	Marketing	Marketing strategy	Internal	€50	5%	5%	5%	5%	5%	5%	5%	35%
10		Community manager	Internal	€50	10%	10%	10%	10%	10%	20%	20%	90%
11		Content creation	Internal	€50	20%	10%	10%	10%	10%	10%	20%	90%
12		Partnership and sales	Internal	€50	10%	20%	20%	20%	20%	20%	20%	130%
13	Admin	Admin and finance	Internal	€50	5%	5%	5%	5%	5%	5%	5%	35%
14	Total				90%	165%	175%	155%	155%	170%	220%	1130%
15
16	Costs
17	Development	Full stack development	External	€100	€0	€0	€9,600	€9,600	€9,600	€9,600	€9,600	€48,000
18		Full stack development	Internal	€50	€0	€4,800	€1,600	€1,600	€1,600	€1,600	€3,200	€14,400
19		UI / UX design	Internal	€50	€0	€3,200	€1,600	€0	€0	€0	€0	€4,800
20		Testing	Internal	€50	€0	€400	€400	€400	€400	€800	€2,400	€4,800
21		Team lead	Internal	€50	€3,200	€800	€1,600	€1,600	€1,600	€1,600	€1,600	€12,000
22	Marketing	Marketing strategy	Internal	€50	€400	€400	€400	€400	€400	€400	€400	€2,800
23		Community manager	Internal	€50	€800	€800	€800	€800	€800	€1,600	€1,600	€7,200
24		Content creation	Internal	€50	€1,600	€800	€800	€800	€800	€800	€1,600	€7,200
25		Partnership and sales	Internal	€50	€800	€1,600	€1,600	€1,600	€1,600	€1,600	€1,600	€10,400
26	Admin	Admin and finance	Internal	€50	€400	€400	€400	€400	€400	€400	€400	€2,800
27	Hosting	Mongodb prod cluster	External	n/a	€ -	€ -	€ -	€ -	€ -	€500	€500	€1,000
28		Mongodb staging cluster	External	n/a	€ -	€300	€300	€300	€300	€300	€300	€1,800
29		Vercel hosting	External	n/a	€100	€100	€100	€100	€100	€100	€100	€700
30		IPFS pinning service*	External	n/a	€ -	€ -	€ -	€ -	€ -	€ -	€ -	€0	*Sponsored by NMKR
31		Cardano indexing	External	n/a	€ -	€200	€200	€200	€200	€400	€400	€1,600
32	Total				€7,300	€13,800	€19,400	€17,800	€17,800	€19,700	€23,700	€119,500
33
34	Milestones				Milestone 0	Milestone 1	Milestone 1.1	Milestone 1.2	Milestone 1.3	Milestone 1.4	Milestone 2	Total
35	Estimated cost				€7,300	€13,800	€19,400	€17,800	€17,800	€19,700	€23,700
36	Buffer	10.00%			€8,030	€15,180	€21,340	€19,580	€19,580	€21,670	€26,070
37	Category breakdown	Development			€3,520	€10,120	€16,280	€14,520	€14,520	€14,960	€18,480
38					₳23,467	₳67,467	₳108,533	₳96,800	₳96,800	₳99,733	₳123,200
39		Marketing			€3,960	€3,960	€3,960	€3,960	€3,960	€4,840	€5,720
40					₳26,400	₳26,400	₳26,400	₳26,400	₳26,400	₳32,267	₳38,133
41		Admin			€440	€440	€440	€440	€440	€440	€440
42					₳2,933	₳2,933	₳2,933	₳2,933	₳2,933	₳2,933	₳2,933
43		Hosting			€110	€660	€660	€660	€660	€1,430	€1,430
44					₳733	₳4,400	₳4,400	₳4,400	₳4,400	₳9,533	₳9,533
45	Total €	(rounded up to 10^2)			€8,100	€15,200	€21,400	€19,600	€19,600	€21,700	€26,100	€131,700
46	Total ₳	(rounded up to 10^2)			₳53,600	₳101,200	₳142,300	₳130,600	₳130,600	₳144,500	₳173,800	₳876,600
47
48	Conversion	usd / ada	eur / ada
49	worst case	0.16	0.15
50	best case	0.26	0.24
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