VAULT3 Admin Dashboard Budget Planning

	B	C	D	E	F	G	H	I	J	K
1
2	Workload
3	Category			Rate	02/01/2024	03/01/2024	04/01/2024	05/01/2024	06/01/2024	Total hours
4	Development	Full stack development	External	€100	60%	60%	60%	60%	60%	300%
5		Full stack development	Internal	€60	20%	20%	20%	20%	20%	100%
6		UI / UX design	Internal	€50	30%	0%	0%	0%	0%	30%
7		Testing	Internal	€50	5%	5%	5%	5%	5%	25%
8		Team lead	Internal	€0	20%	10%	10%	10%	10%	60%
9	Admin	Admin and finance	Internal	€0	5%	5%	5%	5%	5%	25%
10	Total				140%	100%	100%	100%	100%	540%
11
12	Costs
13	Development	Full stack development	External	€100	€9,600	€9,600	€9,600	€9,600	€9,600	€48,000
14		Full stack development	Internal	€60	€1,920	€1,920	€1,920	€1,920	€1,920	€9,600
15		UI / UX design	Internal	€50	€2,400	€0	€0	€0	€0	€2,400
16		Testing	Internal	€50	€400	€400	€400	€400	€400	€2,000
17		Team lead	Internal	€0	€0	€0	€0	€0	€0	€0
18	Admin	Admin and finance	Internal	€0	€0	€0	€0	€0	€0	€0
19	Total				€14,320	€11,920	€11,920	€11,920	€11,920	€62,000
20
21	Milestones				Milestone 1	Milestone 2	Milestone 3	Milestone 4	Milestone 5	Total
22	Estimated cost				€14,320	€11,920	€11,920	€11,920	€11,920
23	Buffer	5.00%			€15,036	€12,516	€12,516	€12,516	€12,516
24	Category breakdown	Development			€15,036	€12,516	€12,516	€12,516	€12,516
25					₳50,120	₳41,720	₳41,720	₳41,720	₳41,720
26		Admin			€0	€0	€0	€0	€0
27					₳0	₳0	₳0	₳0	₳0
28	Total €	(rounded up to 10^2)			€15,100	€12,600	€12,600	€12,600	€12,600	€65,500
29	Total ₳	(rounded up to 10^2)			₳50,200	₳41,800	₳41,800	₳41,800	₳41,800	₳217,400
30
31	Conversion	usd / ada	eur / ada
32	worst case	0.33	0.3
33	best case	0.39	0.36
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