A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Click here to copy the template, and customize it | ||||||||||||||||||||||||||||
2 | |||||||||||||||||||||||||||||
3 | |||||||||||||||||||||||||||||
4 | Variables | Recruitment costs | |||||||||||||||||||||||||||
5 | Job boards | Job boards | January | February | March | April | May | June | July | August | September | October | November | December | 2021 | Monthly average | |||||||||||||
6 | 500.00 zł | Cost | 500 zł | 1,000 zł | 1,500 zł | 10,000 zł | 7,500 zł | 1,500 zł | 1,000 zł | 2,000 zł | 0 zł | 500 zł | 500 zł | 500 zł | 26,500 zł | 2,208 zł | |||||||||||||
7 | Pracuj | 1,000.00 zł | Number of job posts | 1 | 2 | 3 | 20 | 15 | 3 | 2 | 4 | 1 | 1 | 1 | 53 | 4 | |||||||||||||
8 | Jobs.pl | 500.00 zł | Cost / post | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 6,000 zł | 500 zł | ||||||||||||
9 | Pracuj | Cost | 3,000 zł | 2,000 zł | 14,000 zł | 1,000 zł | 2,000 zł | 1,000 zł | 3,000 zł | 2,000 zł | 3,000 zł | 1,000 zł | 2,000 zł | 2,000 zł | 36,000 zł | 3,000 zł | |||||||||||||
10 | Number of job posts | 3 | 2 | 14 | 1 | 2 | 1 | 3 | 2 | 3 | 1 | 2 | 2 | 36 | 3 | ||||||||||||||
11 | Cost / post | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 12,000 zł | 1,000 zł | ||||||||||||||
12 | Jobs.pl | Cost | 1,000 zł | 500 zł | 0 zł | 0 zł | 0 zł | 0 zł | 0 zł | 0 zł | 0 zł | 0 zł | 0 zł | 0 zł | 1,500 zł | 125 zł | |||||||||||||
13 | Number of job posts | 2 | 1 | 3 | 0 | ||||||||||||||||||||||||
14 | Cost / post | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 6,000 zł | 500 zł | ||||||||||||||
15 | Total | Cost | 4,500 zł | 3,500 zł | 15,500 zł | 11,000 zł | 9,500 zł | 2,500 zł | 4,000 zł | 4,000 zł | 3,000 zł | 1,500 zł | 2,500 zł | 2,500 zł | 64,000 zł | 5,333 zł | |||||||||||||
16 | Number of job posts | 6 zł | 5 zł | 17 zł | 21 zł | 17 zł | 4 zł | 5 zł | 6 zł | 3 zł | 2 zł | 3 zł | 3 zł | 92 zł | 8 zł | ||||||||||||||
17 | Cost / post | 750 zł | 700 zł | 912 zł | 524 zł | 559 zł | 625 zł | 800 zł | 667 zł | 1,000 zł | 750 zł | 833 zł | 833 zł | 8,953 zł | 746 zł | ||||||||||||||
18 | Recruitment agencies | Recruitment agencies | January | February | March | April | May | June | July | August | September | October | November | December | 2021 | Monthly average | |||||||||||||
19 | Average gross salary per new position | 8,000.00 zł | Recruitment Agency 1 | Cost | 134,400 zł | 26,880 zł | 13,440 zł | 40,320 zł | 53,760 zł | 26,880 zł | 53,760 zł | 26,880 zł | 53,760 zł | 26,880 zł | 53,760 zł | 26,880 zł | 537,600 zł | 44,800 zł | |||||||||||
20 | Success fee of Recruitment Agency 1 | 14.00% | Number of positions | 10 | 2 | 1 | 3 | 4 | 2 | 4 | 2 | 4 | 2 | 4 | 2 | 40 | 3 | ||||||||||||
21 | Success fee of Talentuno | 6.00% | Cost / position | 13,440 zł | 13,440 zł | 13,440 zł | 13,440 zł | 13,440 zł | 13,440 zł | 13,440 zł | 13,440 zł | 13,440 zł | 13,440 zł | 13,440 zł | 13,440 zł | 161,280 zł | 13,440 zł | ||||||||||||
22 | Talentuno | Cost | 57,600 zł | 11,520 zł | 5,760 zł | 17,280 zł | 23,040 zł | 11,520 zł | 23,040 zł | 11,520 zł | 23,040 zł | 11,520 zł | 23,040 zł | 11,520 zł | 230,400 zł | 19,200 zł | |||||||||||||
23 | Number of positions | 10 | 2 | 1 | 3 | 4 | 2 | 4 | 2 | 4 | 2 | 4 | 2 | 40 | 3 | ||||||||||||||
24 | Cost / position | 5,760 zł | 5,760 zł | 5,760 zł | 5,760 zł | 5,760 zł | 5,760 zł | 5,760 zł | 5,760 zł | 5,760 zł | 5,760 zł | 5,760 zł | 5,760 zł | 69,120 zł | 5,760 zł | ||||||||||||||
25 | Total | Cost | 192,000 zł | 38,400 zł | 19,200 zł | 57,600 zł | 76,800 zł | 38,400 zł | 76,800 zł | 38,400 zł | 76,800 zł | 38,400 zł | 76,800 zł | 38,400 zł | 768,000 zł | 64,000 zł | |||||||||||||
26 | Number of positions | 20 | 4 | 2 | 6 | 8 | 4 | 8 | 4 | 8 | 4 | 8 | 4 | 80 | 7 | ||||||||||||||
27 | Cost / position | 9,600 zł | 9,600 zł | 9,600 zł | 9,600 zł | 9,600 zł | 9,600 zł | 9,600 zł | 9,600 zł | 9,600 zł | 9,600 zł | 9,600 zł | 9,600 zł | 115,200 zł | 9,600 zł | ||||||||||||||
28 | Employer Branding | January | February | March | April | May | June | July | August | September | October | November | December | 2021 | Monthly average | ||||||||||||||
29 | Job expos | Cost | 25,000 zł | 0 zł | 0 zł | 40,000 zł | 0 zł | 0 zł | 0 zł | 0 zł | 60,000 zł | 0 zł | 0 zł | 0 zł | 125,000 zł | 10,417 zł | |||||||||||||
30 | Occassions | 1 | 2 | 3 | 6 | 0.5 | |||||||||||||||||||||||
31 | Cost / Occasion | 25,000 zł | 20,000 zł | 20,000 zł | 65,000 zł | 5,417 zł | |||||||||||||||||||||||
32 | Branding materials | Cost | 3,000 zł | 0 zł | 0 zł | 4,500 zł | 0 zł | 0 zł | 0 zł | 0 zł | 6,000 zł | 0 zł | 0 zł | 0 zł | 13,500 zł | 1,125 zł | |||||||||||||
33 | Number of copies | 1,000 | 1,500 | 2,000 | 4,500 | 375 | |||||||||||||||||||||||
34 | Cost / Copy | 3 zł | 3 zł | 3 zł | 9 zł | 1 zł | |||||||||||||||||||||||
35 | Conference sponsorship | Cost | 0 zł | 5,000 zł | 0 zł | 0 zł | 4,000 zł | 0 zł | 0 zł | 0 zł | 0 zł | 4,000 zł | 0 zł | 0 zł | 13,000 zł | 1,083 zł | |||||||||||||
36 | Occassions | 1 | 1 | 1 | 3 | 0.25 | |||||||||||||||||||||||
37 | Cost / Occasion | 5,000 zł | 4,000 zł | 4,000 zł | 13,000 zł | 1,083 zł | |||||||||||||||||||||||
38 | Total | Cost | 28,000 zł | 5,000 zł | 0 zł | 44,500 zł | 4,000 zł | 0 zł | 0 zł | 0 zł | 66,000 zł | 4,000 zł | 0 zł | 0 zł | 151,500 zł | 12,625 zł | |||||||||||||
39 | Career site | January | February | March | April | May | June | July | August | September | October | November | December | 2021 | Monthly average | ||||||||||||||
40 | Development | Cost | 1,500 zł | 0 zł | 0 zł | 0 zł | 0 zł | 0 zł | 2,000 zł | 0 zł | 0 zł | 0 zł | 0 zł | 0 zł | 3,500 zł | 292 zł | |||||||||||||
41 | Occassions | 1 | 1 | 2 | 0.2 | ||||||||||||||||||||||||
42 | Cost / Occasion | 1,500 zł | 2,000 zł | 3,500 zł | 292 zł | ||||||||||||||||||||||||
43 | Maintanace | Cost | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 6,000 zł | 500 zł | |||||||||||||
44 | Occassions | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12 | 1 | ||||||||||||||
45 | Cost / Occasion | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 6,000 zł | 500 zł | ||||||||||||||
46 | Total | Cost | 2,000 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 2,500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 500 zł | 9,500 zł | 792 zł | |||||||||||||
47 | Kifizetés gyakorisága | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 14 | 1.17 | ||||||||||||||
48 | Partnerships | January | February | March | April | May | June | July | August | September | October | November | December | 2021 | Monthly average | ||||||||||||||
49 | University partnerships | Cost | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 12,000 zł | 1,000 zł | |||||||||||||
50 | Professional partnerships | Cost | 2,000 zł | 2,000 zł | 2,000 zł | 2,000 zł | 2,000 zł | 2,000 zł | 2,000 zł | 2,000 zł | 2,000 zł | 2,000 zł | 2,000 zł | 2,000 zł | 24,000 zł | 2,000 zł | |||||||||||||
51 | Total | Cost | 3,000 zł | 3,000 zł | 3,000 zł | 3,000 zł | 3,000 zł | 3,000 zł | 3,000 zł | 3,000 zł | 3,000 zł | 3,000 zł | 3,000 zł | 3,000 zł | 36,000 zł | 3,000 zł | |||||||||||||
52 | Staff costs | Staff costs | January | February | March | April | May | June | July | August | September | October | November | December | 2021 | Monthly average | |||||||||||||
53 | Number of recruiters | 3 | Recruiter (in-house) | Cost | 19,200 zł | 19,200 zł | 19,200 zł | 19,200 zł | 19,200 zł | 19,200 zł | 19,200 zł | 19,200 zł | 19,200 zł | 19,200 zł | 19,200 zł | 19,200 zł | 230,400 zł | 19,200 zł | |||||||||||
54 | Hours spent with recruitment | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 480 | 5760 | 480 | ||||||||||||||
55 | Average gross hourly salary | 40 zł | 40 zł | 40 zł | 40 zł | 40 zł | 40 zł | 40 zł | 40 zł | 40 zł | 40 zł | 40 zł | 40 zł | 480 zł | 40 zł | ||||||||||||||
56 | Hiring manager 1 | Cost | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 1,000 zł | 12,000 zł | 1,000 zł | |||||||||||||
57 | Hours spent with recruitment | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 240 | 20 | ||||||||||||||
58 | Average gross hourly salary | 50 zł | 50 zł | 50 zł | 50 zł | 50 zł | 50 zł | 50 zł | 50 zł | 50 zł | 50 zł | 50 zł | 50 zł | 600 zł | 50 zł | ||||||||||||||
59 | Hiring manager 2 | Cost | 1,200 zł | 1,200 zł | 1,200 zł | 1,200 zł | 1,200 zł | 1,200 zł | 1,200 zł | 1,200 zł | 1,200 zł | 1,200 zł | 1,200 zł | 1,200 zł | 14,400 zł | 1,200 zł | |||||||||||||
60 | Hours spent with recruitment | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 240 | 20 | ||||||||||||||
61 | Average gross hourly salary | 60 zł | 60 zł | 60 zł | 60 zł | 60 zł | 60 zł | 60 zł | 60 zł | 60 zł | 60 zł | 60 zł | 60 zł | 720 zł | 60 zł | ||||||||||||||
62 | Total | Spend | 21,400 zł | 21,400 zł | 21,400 zł | 21,400 zł | 21,400 zł | 21,400 zł | 21,400 zł | 21,400 zł | 21,400 zł | 21,400 zł | 21,400 zł | 21,400 zł | 256,800 zł | 21,400 zł | |||||||||||||
63 | # hours spent | 520 | 520 | 520 | 520 | 520 | 520 | 520 | 520 | 520 | 520 | 520 | 520 | 6240 | 520 | ||||||||||||||
64 | Total Recruitment Spend per month | 250,900 zł | 71,800 zł | 59,600 zł | 138,000 zł | 115,200 zł | 65,800 zł | 107,700 zł | 67,300 zł | 170,700 zł | 68,800 zł | 104,200 zł | 65,800 zł | 1,285,800 zł | 107,150 zł | ||||||||||||||
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 |