ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Actual Grant Earned
2
Job DescriptionHours WorkedGrant Supported Hourly WageHourly Wage PaidGross PayMERCSGross Pay Plus MERCSMB Healthy Hire EarnedPotential CSJ EarnedCSJ Claw BackReduced CSJ EarnedTotal Earned GrantsNetNotes
3
Local Bike Groups Coordinator213.30$11.90$18.00$4,002.34$357.10$4,359.43$546.75$2,906.03$132.13$2,773.90$3,320.65$1,038.78
4
Videographer51.00$11.90$18.00$954.72$34.33$989.05$357.75$643.78$88.64$555.14$912.89$76.16
5
$4,957.06$391.43$5,348.48$904.50$3,549.81$220.77$3,329.04$4,233.54$1,114.94
6
7
Minimum WageActual WageMERCSGross Pay/HrNet Pay/Hr
8
Net Hourly Rate (beyond November 15th)$11.95$18.0014.00%$20.52$6.05
9
10
Revenue
11
ACU$2,500.00
12
MB Health Hire$900.00
13
Potential CSJ Earned$3,549.81
14
CSJ Claw Back due to MB Healthy Hire$220.77
15
Retrain MB$0.00
16
Total Revenue$7,170.58
17
18
Expenses
19
Videoagrapher Wages and MERCS$989.05
20
Local Bike Group Coordinator Wages and Mercs$4,359.43
21
Training$75.00
22
23
Total Expenses$5,423.4815.00%
24
Admin$813.52
25
Total Expenses plus Admin$6,237.00
26
27
Remaining Funding$933.58
28
Remaining Funded Hours (approximate)45.50
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