| A | B | C | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Milestone | Activity type | Number of hours | open budget | Budget = 2,000$ | Budget per activity | open budget | ||||
2 | |||||||||||
3 | Milestone 1 | tot(h) | % of work done | $/h agreed on | total $ reward =tot(h)*$/h | % from budget based on tot$ | Budget (from 2000$) | Rare per hour agreed on | Hours paid | Hours not paid | |
4 | 18.77 | ||||||||||
5 | Coordination and Facilitation | 24 | 19.52% | 20 | 480.00 | 15.16% | $303.28 | 20 | 15.16 | 8.84 | |
6 | R&D | 42.43 | 34.52% | 30 | 1272.90 | 40.21% | $804.26 | 30 | 26.81 | 15.62 | |
7 | Outreach | 24.5 | 19.93% | 25 | 612.50 | 19.35% | $387.00 | 25 | 15.48 | 9.02 | |
8 | Documentation | 32 | 26.03% | 25 | 800.00 | 25.27% | $505.47 | 25 | 20.22 | 11.78 | |
9 | 141.7 | 100.00% | 3165.40 | 100.00% | $2,000.00 | ||||||
10 | 141.7 | 122.93 | |||||||||
11 | |||||||||||
12 | |||||||||||
13 | projected | actual | |||||||||
14 | Coordination and facilitation | 5% | 19.52% | ||||||||
15 | Electronics design | 15% | 85% | 34.52% | |||||||
16 | Mechanical design | 30% | |||||||||
17 | Software architecture | 40% | |||||||||
18 | Outreach | 5% | 19.93% | ||||||||
19 | Documentation | 5% | 26.03% | ||||||||
20 | |||||||||||
21 | 100.00% | ||||||||||
22 | |||||||||||
23 | |||||||||||
24 | Milestone 1 | % of work done | Rare per hour agreed on | Work done * rate | % of $ | ||||||
25 | Initiation | 18.77 | |||||||||
26 | Coordination and Facilitation | 24 | 19.52% | 20 | $480.00 | 15.16396032 | |||||
27 | R&D | 42.43 | 34.52% | 30 | $1,272.90 | 40.21292728 | |||||
28 | Outreach | 24.5 | 19.93% | 25 | $612.50 | 19.3498452 | |||||
29 | Documentation | 32 | 26.03% | 25 | $800.00 | 25.2732672 | |||||
30 | $3,165.40 | 100 | |||||||||
31 | |||||||||||
32 | |||||||||||
33 | Milestone 2 | tot(h) | % of work done | Time rate | %from budget | Budget (from 5000$) | $/h agreed on | Hours paid | Hours not paid | ||
34 | Coordination and facilitation | 40.2 | 21% | 20 | 5% | $250.00 | 20 | 12.50 | 27.70 | ||
35 | Electronics design | 13.77 | 7% | 30 | 15% | $750.00 | 30 | 25.00 | -11.23 | ||
36 | Mechanical design | 98.1 | 51% | 30 | 30% | $1,500.00 | 30 | 50.00 | 48.10 | ||
37 | Software prototype | 13.5 | 7% | 30 | 40% | $2,000.00 | 30 | 66.67 | -53.17 | ||
38 | Outreach | 5.8 | 3% | 25 | 5% | $250.00 | 25 | 10.00 | -4.20 | ||
39 | Documentation (writing) | 21 | 11% | 25 | 5% | $250.00 | 25 | 10.00 | 11.00 | ||
40 | TOTAL | 192.37 | 100% | 160 | 0 | 100% | $5,000.00 | 174.17 | 18.20 | ||
41 | |||||||||||
42 | |||||||||||
43 | |||||||||||
44 | |||||||||||
45 | |||||||||||
46 | |||||||||||
47 | |||||||||||
48 |