ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
Source (xlsx file preprocessed by python) https://github.com/fernflower/countforeignchildren
17039
2
Age groupProportion womenCost per person w/r to men/women proportionAvg cost per personTotal foreignersTotal expenses (mln czk) w/r gender distributionTotal expenses (mln czk)Age groupMenWomen
3
0-40,484945547721121,6060221084357175,425255175,2909640-4-18391732
4
5-90,487140218911235,6182211209,5336937,8527977737,76480555-9-17281641
5
10-140,483022250312327,1272812322252631,1383235131,12537210-14-13061220
6
15-190,482140838713603,0842713647,57573103,0161571103,352517515-19-39223651
7
20-240,46592128812463,276211260022780283,913432287,02820-24-1216610614
8
25-290,438325202914783,2877215192,528269417,9087606429,476782525-29-1587812391
9
30-340,436637989916613,457331707625265419,7389993431,4251430-34-1423311032
10
35-390,427893518517052,742591746020690352,8212442361,247435-39-118378853
11
40-440,413086373518202,4672618488,516502300,3771146305,09722740-44-96856817
12
45-490,389829339821461,7245321865,513168282,6079886287,92490445-49-80355133
13
50-540,364177175726465,331226685,59599254,0407142256,154114550-54-61033496
14
55-590,364418662232858,65197325626823224,1945824222,17052655-59-43372486
15
60-640,375880747841573,6800440524,53468144,1775224140,53896660-64-21641304
16
65-690,427852673751507,4471450573,52004103,2209241101,34929465-69-1147857
17
70-740,434232121962985,9498261911,5134384,5901306183,147144570-74-760583
18
75-790,434299411673173,817177210587964,3197852963,38029575-79-497382
19
80-840,536496350475619,919717604741931,6847463631,86369380-84-194225
20
85-890,561304039781902,9666982282,517714,496825114,564002585-89-7899
21
90-940,618104667685251,0028385478766,4790762156,49632890-94-2947
22
95+0,624040920790388,0383690975292,6212531132,63827595+-1118
23
TotalRate foreign seniors0,02923515101
24
Rate czech seniors
25
Total foreigners168530
26
Total VZP expenses gender distribution equal (mln czk)
3272,035751Total VZP expenses w/r gender distribution3234,625633
27
VZP expenses children 0-19 equal gender distribution (mln czk)
247,533659VZP expenses children w/r gender247,4325335
28
VZP expenses pensioneers equal gender (mln czk)
303,439032VZP expenses pensioneers w/r gender307,4127408
29
Average cost per person (czk)19415,15309Average cost per person w/r gender (czk)19193,17411
30
Average cost per adult (czk)19964,89621Average cost per adult w/r gender (czk)19718,6176
31
Average cost per child (czk)14527,47573Average cost per child w/r gender (czk)14521,54079
32
Average cost per pensioneer (czk)61586,97625Average cost per pensioneer w/r gender (czk)62393,49315
33
34
Source https://www.czso.cz/documents/10180/125507871/290027200305.xlsx/395bb607-46eb-49d7-abcb-2b2f4e93e7e3?version=1.1
35
Average salaries 2019 https://www.czso.cz/csu/czso/cri/prumerne-mzdy-4-ctvrtleti-2019
36
Average salaries foreigners 2019 https://www.czso.cz/documents/10180/125507871/290027200318.pdf/154e2f10-b1ed-4687-8ff0-911aea44a6fd?version=1.3
37
min salaryContribution to VZP (mln czk)
38
Employed foreigners ZK59209343823297,872618
39
Employed foreigners MK7305157360,9902298
40
Employed rate (20-64)0,4089612729
41
42
Question 1: Are employed foreigners paying enough already to cover medical expenses for themselves and their dependents? YES
43
Total minimal VZP contribution of employed foreigners without permanent residence (mln czk)
3358,862847
44
Balance (mln czk) avg expenses86,82709636Balance (mln czk) w/r to gender distribution124,2372147
45
46
Question 2: If all dependents were paying as OBZP, would that be enough to cover their expenses? YES
47
OBZP 2019 rate1803
48
Total minimal contribution of all foreigners as OBZP per year (mln czk)
2349,474876
49
Total expenses of unemployed foreigners per year avg (mln czk)
2159,226338Total expenses of all foreigners w/r to gender2138,699246
50
Balance190,2485376Balance210,7756297
51
52
Question 3: If children were paying 50% of OBZP, others 100% - would that be enough? YES
53
Minimal contribution of adults as OBZP, children are paying 50% of OBZP
2165,146974
54
Balance5,920635634Balance26,44772774
55
56
Question 4: If children were paying 70% of OBZP - would they be able to cover their expenses? YES
57
Contribution258,0590628
58
Total expenses247,533659Total expenses children w/r to gender247,4325335
59
Balance10,5254038Balance10,62652927
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