SUMMARY OF IN-KIND CONTRIBUTIONS - ACTUAL AND BUDGET
A B C D E Total $ In-kind Item
eg, Lab tests (this is an example only) Hours or units Budgeted $/hr or units Total Budgeted for Year Actual to Date D=BxC 10000 20 $200,000 E=H+J+L+N $185,000 tests $70,000 $70,000 $30,000 $50,000 $50,000 $30,000 $50,000 $35,000 Hrs or Units
F
G Quarter 1
Budget
H
I Quarter 2
Budget
J
K Quarter 3
Budget
L
M Quarter 4
Budget
N
Actual
Actual
Actual
Actual
Scientists Lab tests Lab time
$0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Farmer time labouring Farmer time advice Vehicle costs - tractor
25 75
$0 $0 $0 $0 $0 $0 $0
TOTALS
$0
1. Put all new in-kind items, the number of hours or units and the value of those units on this sheet. They will automatically appear on the next sheet. 2. Divide the total budget for each in-kind item between the quarters reflecting the amount that will be used in that quarter.
WORKSHEET FOR ACTUAL IN-KIND CONTRIBUTIONS
Quarter 1 Actual Hours or Units
3500
Quarter 2 Actual Hours or Units
$70,000 2500
Quarter 3 Actual Hours or Units
1500
Quarter 4 Actual Hours or Units
1750
In-Kind Item
eg, Lab tests (this is an example only)
$/hr or unit
20
Total
$/hr or unit Total
$20 $50,000
$/hr or unit Total
$20 $30,000
$/hr or unit Total
$20 $35,000
Total Unexpired Budgeted budget
$200,000 $15,000
Scientists Lab tests Lab time 0 Farmer time labouring Farmer time advice Vehicle costs - tractor 0 0 0 0 TOTALS
0 0 0 0 25 75 0 0 0 0 0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0
$0 $0 $0 $0 $25 $75 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0
$0 $0 $0 $0 $25 $75 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 0
$0 $0 $0 $0 $25 $75 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
1. This sheet will give the information required for claiming quarterly grant funding relating to in-kind contributions 2. The totals for each in-kind contribution will automatically transfer to the summary sheet so actual income can be regularly compared to the budget.