min_viable_village.ods
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Minimum viable villageChildren in schoolAdults of working ageAdults retiredJobs in economyAffordable houses
2
35.00268.33105.00241.50248.89
3
4
This model attempts to understand what is required to make a remote rural village viable, economically and socially. Generally all numbers with a green background are inputs; you can sensibly change these to see what happens to the model. Numbers with a pink background are outputs; they are calculated from inputs and you should not change them.
5
Generally, my assumption was that to be viable, a village must have a school. All outputs are therefore fundamentally driven off the number of children in the school.
6
These numbers reflect only those residents of the village whose incomes (when of working age) depend on the local economy. Retired incomers bringing pensions earned in the cities do slightly increase the amount of money in the local economy, but don't contribute to children in the school and substantially raise the cost of housing.
7
Feel free to criticise this model, especially errors in the arithmetic!
8
9
Assumptions
10
Children per woman2.00
Travel to school radius, Km
5.00
11
Average age entering workforce
21.00
% productive land
50.00%
12
Average age leaving workforce67.00
Farmable area, Ha
3925.00
13
Average age at death85.00
Average holding size
101.00
14
% Employment90.00%
Number of holdings
38.86
15
Years of working age46.00
Average incomes per holding
1.00
16
Years retired18.00
Direct agricultural employment
38.86
17
Adults per household1.50
Non-agricultural employment
202.64
18
19
Income
(annualised)
(number of)
Total
20
Average farm income£12,600.00£12,600.0038.86£489,653.47
21
Average hourly wage£10.50£19,110.00202.64£3,872,423.91
22
Average not-in-work benefit£73.10£3,801.2026.83£101,998.87
23
Average pension£159.55£8,296.60105.00£871,143.00
24
Universal Basic Income, ann.£0.00£0.00373.33£0.00
25
26
Total income of village£5,335,219.24
27
28
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
Loading...
 
 
 
Sheet1
 
 
Main menu