1 | No | Name | Audience 2 | Sponsor | Funding type | Cost type | Unit | Cost per unit | Units per month | Cost per month | Qty of people | Times per year | Units per year | Total cost | Formula | Assumption | Source | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | 1 | Coaching | Children | Government | Cash | HR | hour | €5.79 | 280 | €810.60 | 140 | 11 | €8,916.60 | cost per unit * qty of people * times per year | Every child pays 6 eur per month. There are 140 children who are training for 11 months in a year. | |||||||||||||||||||
3 | 2 | Administration/technical staff | Children | Government | Cash | HR | hour | €9.43 | 160 | €1,508.08 | 28 | 12 | €18,097.00 | see assumption | 28 roles of admin staff (excluding coaches) divided by 12 sports (18K spent per December 2016) | |||||||||||||||||||
4 | 3 | Rent outside venue for trainings | Children | Government | Service | Ground | hour | €31.00 | 280 | €8,680.00 | 140 | 7 | 1,960.00 | €60,760.00 | cost per unit * units per month * times per year | It covers astroturf venue including electricity/water/changing rooms. 70 coaching hours per week for 5 coaches. All coaches 280 hours per month over 7 months. | ||||||||||||||||||
5 | 4 | Rent indoor venue for trainings | Children | Government | Service | Ground | hour | €12.00 | 280 | €3,360.00 | 140 | 4 | 1,120.00 | €13,440.00 | cost per unit * units per month * times per year | same as above but covers indoor venue including electricity/water and changing rooms | http://vrpc.lt/sporto-sales/ | |||||||||||||||||
6 | 5 | Transport services (including driver) | Children | Government | Service | Transport | away match | €150.00 | 4.91 | €736.36 | 140 | 11 | €8,100.00 | cost per unit * untis per month * times per year | Assumption that 2 teams played 36 away official matches per year. Other 3 teams played 18 away matches together. In total: 36+18=54. 1 of 2 teams: spring (8), summer (0), autumn (16) and winter (12). | https://youtu.be/rBoGvPw8_-s | ||||||||||||||||||
7 | 6 | Team kit | Children | Third party | Cash | Equipment | team kit | €300.00 | 2 | €600.00 | 40 | 1 | €600.00 | cost per unit * units per month * times per year | Last year 2 team kits are purchased. | |||||||||||||||||||
8 | 7 | Training equipment | Children | Third party | Cash | Equipment | tool | €1,000.00 | 1 | 1000 | 140 | 1 | €1,000.00 | cost per unit * units per month * times per year | It includes balls, cones, bibs and other tools for 5 teams | |||||||||||||||||||
9 | 8 | Excursion / football match visits | Children | Third party | Cash | Trip | trip | €35.00 | 1 | €525.00 | 15 | 6 | €3,150.00 | cost per unit * units per month * qty of people * times per year | 1 team practised | |||||||||||||||||||
10 | 9 | Performance review meetings | Children | Third party | Cash | Misc | snacks | €2.00 | 1 | €2.00 | 15 | 12 | €24.00 | cost per month * times per year | 1 team practised | |||||||||||||||||||
11 | 10 | Long trip to the international tournament | Children | Third party | Cash | Trip | child | €500.00 | 1 | €8,000.00 | 16 | 1 | €8,000.00 | cost per unit * qty of people | 1 team practised | https://youtu.be/VY7DlN4RtiE | ||||||||||||||||||
12 | 11 | Long trip to the international tournament | Children | Third party | Cash | Trip | child | €150.00 | 1 | - | 10 | 1 | €1,500.00 | cost per unit * qty of people | 1 team practised | |||||||||||||||||||
13 | 12 | Short trip to the tournaments inside or nearby country | Children | Third party | Cash | Trip | child | €40.00 | 1 | - | 50 | 4 | €2,000.00 | cost per unit * qty of people | Trips to Daugavpils, Vilnius (Ateitis), Poland (I), Poland (Z): 2 trips * 10 children + 2 trips * 15 children | |||||||||||||||||||
14 | 13 | Summer camp: rent outside venue for trainings | Children | Government | Service | Ground | hour | €26.00 | 80 | €2,080.00 | 50 | 1 | 80.00 | €2,080.00 | cost per unit * units per month | 4 hours during 20 days about 30-50 children | ||||||||||||||||||
15 | 14 | Summer camp: food & beverages | Children | Third party | Cash | Misc | child | €50.00 | - | - | 50 | 1 | €1,900.00 | cost per unit * qty of people | 3 teams practised (about 3 trainings & meals per day during 3 weeks) | |||||||||||||||||||
16 | 15 | Summer camp: HR | Children | Third party | Cash | HR | €600.00 | |||||||||||||||||||||||||||
17 | 16 | Rent outside venue | First Team | Government | Service | Ground | hour | €31.00 | 14.50 | €449.50 | 25 | 6 | 87.00 | €2,697.00 | cost per unit * untis per month * times per year | (12 trainings per month + 10 home matches) by 1,5 hour average duration | ||||||||||||||||||
18 | 17 | Coaching | First Team | Government | Cash | HR | coach | - | - | - | 1 | 6 | €1,224.05 | see assumption | see source | https://youtu.be/rBoGvPw8_-s?t=2m20s | ||||||||||||||||||
19 | 18 | Team kit | First Team | Government | Cash | Equipment | person | €513.67 | - | - | 25 | 6 | €513.67 | see assumption | see source | https://youtu.be/rBoGvPw8_-s?t=2m20s | ||||||||||||||||||
20 | 19 | League administration fee | First Team | Government | Cash | Misc | team | - | - | - | 1 | 6 | €1,448.10 | see assumption | see source | https://youtu.be/rBoGvPw8_-s?t=2m20s | ||||||||||||||||||
21 | 20 | Transport services (including driver) | First Team | Government | Cash | Transport | away match | - | - | - | - | 6 | €2,606.58 | see assumption | see source | https://youtu.be/rBoGvPw8_-s?t=2m20s | ||||||||||||||||||
22 | 21 | Rent outside venue | Amateur Team | Government | Service | Ground | hour | €31.00 | 18 | €558.00 | 25 | 8 | 144.00 | €2,232.00 | cost per unit * units per month * times per year / 2 | 3 trainings per week. Each training 1,5 hour on average. Total cost divided by 2 as share with senior team | ||||||||||||||||||
23 | 22 | Rent indoor venue | Amateur Team | Government | Service | Ground | hour | €12.00 | 12 | €144.00 | 25 | 4 | 48.00 | €288.00 | cost per unit * units per month * times per year / 2 | 8 trainings per month. Each training 1,5 hour on average. Total cost divided by 2 as share with senior team | http://vrpc.lt/sporto-sales/ | |||||||||||||||||
24 | 23 | Training equipment | Amateur Team | Third party | Cash | Equipment | item | - | - | - | - | €160.00 | It includes balls, bibs, cones, etc | Bill | ||||||||||||||||||||
25 | 24 | Rent outside venue | Senior Team | Government | Service | Ground | hour | €31.00 | 18 | €558.00 | 25 | 8 | 144.00 | €2,232.00 | cost per unit * units per month * times per year / 2 | 3 trainings per week. Total cost divided by 2 as share with amateur team | ||||||||||||||||||
26 | 25 | Rent indoor venue | Senior Team | Government | Service | Ground | hour | €12.00 | 12 | €144.00 | 25 | 4 | 48.00 | €288.00 | cost per unit * units per month * times per year / 2 | 8 trainings per month. Total cost divided by 2 as share with amateur team | http://vrpc.lt/sporto-sales/ | |||||||||||||||||
27 | 26 | Transport services (including driver) | Senior Team | Government | Service | Transport | trip | €50.00 | 1.083333333 | €54.17 | 15 | 12 | €650.00 | cost per unit * units per month * times per year | There are 13 trips: summer league (4 away games) + winter league (7 away games) + 2 tournament (2 trips) | http://www.uafa.lt/lt/article/kupiskyje_vyko_uafa_senjoru_sales_futbolo_pirmenybiu_iii_turas http://www.uafa.lt/lt/aukstaitijos_pirmenybes_2015_lff_iii_lyga | ||||||||||||||||||
28 | 27 | Training equipment | Senior Team | Third party | Cash | Equipment | team | - | - | - | - | 12 | €100.00 | - | Balls, cones, bibs | |||||||||||||||||||
29 | 28 | Team kit | Senior Team | Third party | Cash | Equipment | team | €300.00 | - | - | - | 12 | €0.00 | - | ||||||||||||||||||||
30 | 29 | Seminar with FK Utenos Utenis - Rent indoor venue | Seminars | Government | Service | Ground | hour | €12.00 | 1 | €12.00 | - | 1 | 1.00 | €12.00 | cost per unit * units per month | |||||||||||||||||||
31 | 30 | Seminar with FK Utenos Utenis - Expenses | Seminars | Third party | Cash | Misc | mixed | - | - | - | - | 1 | €75.00 | - | 15 petrol + 60 food & beverages | |||||||||||||||||||
32 | 31 | Seminar with FK Utenos Utenis - HR | Seminars | Third party | Service | HR | hour | €11.00 | 4 | €44.00 | - | 1 | €44.00 | cost per unit * units per month | 4 coaches | |||||||||||||||||||
33 | 32 | Seminar with City Group - Rent indoor venue | Seminars | Government | Service | Ground | hour | €12.00 | 1 | €12.00 | - | 1 | 1.00 | €12.00 | cost per unit * units per month | |||||||||||||||||||
34 | 33 | Seminar with City Group - HR | Seminars | Third party | Service | HR | hour | €11.00 | 2 | €22.00 | - | 1 | €22.00 | cost per unit * units per month | 11x2 coaches | |||||||||||||||||||
35 | 34 | Seminar with City Group - Expenses | Seminars | Third party | Cash | Misc | mixed | - | - | - | - | 1 | €60.00 | - | 60 food & beverages | |||||||||||||||||||
36 | 35 | Organising 8 tournaments - expenses | Tournaments | Government | Service | Equipment | mixed | €100.00 | 1 | €100.00 | - | 8 | €800.00 | cost per unit * times per year | 1 tournament includes about 100-150 euros on cups/medals/etc | |||||||||||||||||||
37 | 36 | Organising 8 tournaments - HR | Tournaments | Government | Cash | HR | €100.00 | 1 | €100.00 | 8 | €800.00 | cost per unit * times per year | 1 tournament includes about 100-50 on referees | |||||||||||||||||||||
38 | 37 | Evikonas - Rent indoor venue | Tournaments | Government | Service | Ground | hour | €12.00 | 20 | €240.00 | - | 1 | 20.00 | €240.00 | cost per unit * units per month | |||||||||||||||||||
39 | 38 | Evikonas - Cups, medals, prizes | Tournaments | Third party | Cash | Equipment | item | €150.00 | 1 | €150.00 | - | 1 | €150.00 | - | very raw estimate | |||||||||||||||||||
40 | 39 | Evikonas - HR | Tournaments | Third party | Cash | HR | - | - | - | - | - | 1 | €150.00 | - | very raw estimate | |||||||||||||||||||
41 | 40 | Fire Ball - Third party funds | Tournaments | Third party | Cash | Misc | mixed | €869.19 | 1 | €869.19 | - | 1 | €869.19 | - | ||||||||||||||||||||
42 | 41 | Fire Ball - HR | Tournaments | Third party | Cash | HR | - | €336.00 | - | - | - | 1 | €336.00 | - | ||||||||||||||||||||
43 | 42 | Fire Ball - Rent indoor venue | Tournaments | Government | Service | Ground | hour | €16.00 | 20 | €320.00 | - | 1 | 20.00 | €320.00 | cost per unit * units per month | 13 hours first day and 7 hours second day | ||||||||||||||||||
44 | 43 | Visaginas Cup - HR | Tournaments | Third party | Cash | HR | - | €1,666.01 | - | €1,666.01 | - | 1 | €1,666.01 | |||||||||||||||||||||
45 | 44 | Visaginas Cup - Third party funds | Tournaments | Third party | Cash | Misc | mixed | €4,691.86 | - | €4,691.86 | - | 1 | €4,691.86 | - | ||||||||||||||||||||
46 | 45 | Visaginas Cup - Rent outside venue | Tournaments | Government | Service | Ground | hour | €46.00 | 20 | €920.00 | - | 1 | 20.00 | €920.00 | cost per unit * units per month | 13 hours first day and 7 hours second day | ||||||||||||||||||
47 | 46 | Visaginas Cup - Cups, medals, etc | Tournaments | Government | Service | Equipment | mixed | €300.00 | - | €300.00 | - | 1 | €300.00 | - | ||||||||||||||||||||
48 | 47 | Visaginas Cup - Indoor/outdoor venue utility bills | Tournaments | Third party | Service | Ground | hour | €70.00 | 1 | €70.00 | - | 1 | 1.00 | €70.00 | cost per unit * units per month | 70 euros per 2 days on bills. | ||||||||||||||||||
49 | 48 | Rent pitch to FK Utenos Utenis | Stadium services | Government | Service | Ground | hour | €31.00 | 3 | €93.00 | 5 | 15.00 | €465.00 | cost per unit * units per month * times per year | 5 matches where 1 match approx. 3 hours |
1 | Name | SUM of Total cost |
|---|---|---|
2 | €0.00 | |
3 | Evikonas - Cups, medals, prizes | €150.00 |
4 | Evikonas - HR | €150.00 |
5 | Excursion / football match visits | €3,150.00 |
6 | Fire Ball - HR | €336.00 |
7 | Fire Ball - Third party funds | €869.19 |
8 | Long trip to the international tournament | €9,500.00 |
9 | Performance review meetings | €24.00 |
10 | Seminar with City Group - Expenses | €60.00 |
11 | Seminar with City Group - HR | €22.00 |
12 | Seminar with FK Utenos Utenis - Expenses | €75.00 |
13 | Seminar with FK Utenos Utenis - HR | €44.00 |
14 | Short trip to the tournaments inside or nearby country | €2,000.00 |
15 | Summer camp: food & beverages | €1,900.00 |
16 | Summer camp: HR | €600.00 |
17 | Team kit | €600.00 |
18 | Training equipment | €1,260.00 |
19 | Visaginas Cup - HR | €1,666.01 |
20 | Visaginas Cup - Indoor/outdoor venue utility bills | €70.00 |
21 | Visaginas Cup - Third party funds | €4,691.86 |
22 | Grand Total | €27,168.06 |
1 | Government | Third party | Grand Total | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Cash | €33,606.00 | €27,032.06 | €60,638.06 | |||||||
3 | Service | €95,836.00 | €136.00 | €95,972.00 | |||||||
4 | Grand Total | €129,442.00 | €27,168.06 | €156,610.06 | |||||||
5 | |||||||||||
6 | |||||||||||
7 | |||||||||||
8 | |||||||||||
9 | |||||||||||
10 | |||||||||||
11 | |||||||||||
12 | |||||||||||
13 | |||||||||||
14 | |||||||||||
15 | |||||||||||
16 | |||||||||||
17 | |||||||||||
18 | |||||||||||
19 |
1 | Cash | Service | Grand Total | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Government | 59.00% | 100.00% | 85.58% | |||||||
3 | Third party | 41.00% | 14.42% | ||||||||
4 | Grand Total | 100.00% | 100.00% | 100.00% | |||||||
5 | |||||||||||
6 | |||||||||||
7 | |||||||||||
8 | |||||||||||
9 | |||||||||||
10 | |||||||||||
11 | |||||||||||
12 | |||||||||||
13 | |||||||||||
14 | |||||||||||
15 | |||||||||||
16 | |||||||||||
17 | |||||||||||
18 | |||||||||||
19 |
1 | Total | Unit | Value |
|---|---|---|---|
2 | Usage of indoor and outdoor infrastructure | hours | 3,709.00 |
3 | Usage of indoor and outdoor infrastructure | days | 154.5416667 |
4 | Usage of indoor and outdoor infrastructure | months | 4.985215054 |
5 | Usage of outdoor infrastructure | hours | 2,450.00 |
6 | Usage of outdoor infrastructure | days | 102.0833333 |
7 | Usage of outdoor infrastructure | months | 3.293010753 |
1 | Equipment | €3,623.67 | ||||||
|---|---|---|---|---|---|---|---|---|
2 | Ground | €86,056.00 | ||||||
3 | HR | €31,855.66 | ||||||
4 | Misc | €9,068.15 | ||||||
5 | Transport | €11,356.58 | ||||||
6 | Trip | €14,650.00 | ||||||
7 | ||||||||
8 | ||||||||
9 | ||||||||
10 | ||||||||
11 | ||||||||
12 | ||||||||
13 | ||||||||
14 | ||||||||
15 | ||||||||
16 | ||||||||
17 | ||||||||
18 | ||||||||
19 | ||||||||
20 | ||||||||
21 | ||||||||
22 | ||||||||
23 | ||||||||
24 | ||||||||
25 | ||||||||
26 | ||||||||
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 |
1 | Amateur Team | €2,680.00 | |||||||
|---|---|---|---|---|---|---|---|---|---|
2 | Children | €130,167.60 | |||||||
3 | First Team | €8,489.40 | |||||||
4 | Seminars | €225.00 | |||||||
5 | Senior Team | €3,270.00 | |||||||
6 | Stadium services | €465.00 | |||||||
7 | Tournaments | €11,313.06 | |||||||
8 | Grand Total | €156,610.06 | |||||||
9 | |||||||||
10 | |||||||||
11 | |||||||||
12 | |||||||||
13 | |||||||||
14 | |||||||||
15 | |||||||||
16 | |||||||||
17 | |||||||||
18 | |||||||||
19 | |||||||||
20 |
1 | Cash | Service | Grand Total | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Amateur Team | €160.00 | €2,520.00 | €2,680.00 | |||||||||||
3 | Children | €45,787.60 | €84,380.00 | €130,167.60 | |||||||||||
4 | First Team | €5,792.40 | €2,697.00 | €8,489.40 | |||||||||||
5 | Seminars | €135.00 | €90.00 | €225.00 | |||||||||||
6 | Senior Team | €100.00 | €3,170.00 | €3,270.00 | |||||||||||
7 | Stadium services | €465.00 | €465.00 | ||||||||||||
8 | Tournaments | €8,663.06 | €2,650.00 | €11,313.06 | |||||||||||
9 | Grand Total | €60,638.06 | €95,972.00 | €156,610.06 | |||||||||||
10 | |||||||||||||||
11 | |||||||||||||||
12 | |||||||||||||||
13 | |||||||||||||||
14 | |||||||||||||||
15 | |||||||||||||||
16 | |||||||||||||||
17 | |||||||||||||||
18 | |||||||||||||||
19 | |||||||||||||||
20 | |||||||||||||||
21 | |||||||||||||||
22 | |||||||||||||||
23 | |||||||||||||||
24 | |||||||||||||||
25 | |||||||||||||||
26 | |||||||||||||||
27 | |||||||||||||||
28 | |||||||||||||||
29 | |||||||||||||||
30 | |||||||||||||||
31 |
1 | Government | Third party | Grand Total | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2 | Amateur Team | €2,520.00 | €160.00 | €2,680.00 | |||||||||||
3 | Children | €111,393.60 | €18,774.00 | €130,167.60 | |||||||||||
4 | First Team | €8,489.40 | €8,489.40 | ||||||||||||
5 | Seminars | €24.00 | €201.00 | €225.00 | |||||||||||
6 | Senior Team | €3,170.00 | €100.00 | €3,270.00 | |||||||||||
7 | Stadium services | €465.00 | €465.00 | ||||||||||||
8 | Tournaments | €3,380.00 | €7,933.06 | €11,313.06 | |||||||||||
9 | Grand Total | €129,442.00 | €27,168.06 | €156,610.06 | |||||||||||
10 | |||||||||||||||
11 | |||||||||||||||
12 | |||||||||||||||
13 | |||||||||||||||
14 | |||||||||||||||
15 | |||||||||||||||
16 | |||||||||||||||
17 | |||||||||||||||
18 | |||||||||||||||
19 | |||||||||||||||
20 | |||||||||||||||
21 | |||||||||||||||
22 | |||||||||||||||
23 | |||||||||||||||
24 | |||||||||||||||
25 | |||||||||||||||
26 | |||||||||||||||
27 | |||||||||||||||
28 | |||||||||||||||
29 |
1 | Total | Unit | Value |
|---|---|---|---|
2 | Football spends per child | EUR | €929.77 |
1 | |||||
|---|---|---|---|---|---|
2 | |||||
3 | |||||
4 | |||||
5 | |||||
6 | |||||
7 | |||||
8 | |||||
9 | |||||
10 |