| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Costs and revenue of a community-based publisher for 5 years | |||||||||||||||||||||||||
2 | Instructions: fill in all white cells below with sensible values following your best guesses. Do not touch the grey cells. The current values of the white cells are not realistic. Do not assume they are. | |||||||||||||||||||||||||
3 | Assumptions | 1 | 2 | 3 | 4 | 5 | ||||||||||||||||||||
4 | Series | 5 | 7 | 9 | 11 | 13 | ||||||||||||||||||||
5 | New books per series per year | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||||
6 | Total books this year | 5 | 7 | 9 | 11 | 13 | ||||||||||||||||||||
7 | ||||||||||||||||||||||||||
8 | ||||||||||||||||||||||||||
9 | Basis of calculation | Year | Scientist | Clerk | Assistant | |||||||||||||||||||||
10 | Total annual cost of employee | 1 | 65,920.00 € | 56,920.00 € | 6,500.00 € | |||||||||||||||||||||
11 | 2 | 67,897.60 € | 58,627.60 € | 6,695.00 € | ||||||||||||||||||||||
12 | 3 | 69,934.53 € | 60,386.43 € | 6,895.85 € | ||||||||||||||||||||||
13 | 4 | 72,032.56 € | 62,198.02 € | 7,102.73 € | ||||||||||||||||||||||
14 | 5 | 74,193.54 € | 64,063.96 € | 7,315.81 € | ||||||||||||||||||||||
15 | avg days worked/year | all years | 200 | 200 | 50 | |||||||||||||||||||||
16 | hourly wage | 1 | 41.20 € | 35.58 € | 16.25 € | |||||||||||||||||||||
17 | 2 | 42.44 € | 36.64 € | 16.74 € | ||||||||||||||||||||||
18 | 3 | 43.71 € | 37.74 € | 17.24 € | ||||||||||||||||||||||
19 | 4 | 45.02 € | 38.87 € | 17.76 € | ||||||||||||||||||||||
20 | 5 | 46.37 € | 40.04 € | 18.29 € | ||||||||||||||||||||||
21 | daily wage | 1 | 329.60 € | 284.60 € | 130.00 € | |||||||||||||||||||||
22 | 2 | 339.49 € | 293.14 € | 133.90 € | ||||||||||||||||||||||
23 | 3 | 349.67 € | 301.93 € | 137.92 € | ||||||||||||||||||||||
24 | 4 | 360.16 € | 310.99 € | 142.05 € | ||||||||||||||||||||||
25 | 5 | 370.97 € | 320.32 € | 146.32 € | ||||||||||||||||||||||
26 | Projected increase in wages | 3.00% | 3.00% | 3.00% | ||||||||||||||||||||||
27 | ||||||||||||||||||||||||||
28 | ||||||||||||||||||||||||||
29 | Revenue | Base Y1 | Base Y2 | Base Y3 | Base Y4 | Base Y5 | ||||||||||||||||||||
30 | Print sales | 5,000.00 € | 7,000.00 € | 9,000.00 € | 11,000.00 € | 13,000.00 € | 12.35% | |||||||||||||||||||
31 | Sold copies per new book | 100 | 100 | 100 | 100 | 100 | ||||||||||||||||||||
32 | Margin | 10.00 € | 10.00 € | 10.00 € | 10.00 € | 10.00 € | ||||||||||||||||||||
33 | Book processing charges | 13,125.00 € | 18,375.00 € | 23,625.00 € | 28,875.00 € | 34,125.00 € | 32.42% | |||||||||||||||||||
34 | Nominal BPCs per book | 3,500.00 € | 3,500.00 € | 3,500.00 € | 3,500.00 € | 3,500.00 € | ||||||||||||||||||||
35 | Books which pay BPCs (not waived) | 75% | 75% | 75% | 75% | 75% | ||||||||||||||||||||
36 | Institutional members (IM) | 17,500.00 € | 24,500.00 € | 31,500.00 € | 38,500.00 € | 45,500.00 € | 43.22% | |||||||||||||||||||
37 | avg membership fee | 3,500.00 € | 3,500.00 € | 3,500.00 € | 3,500.00 € | 3,500.00 € | ||||||||||||||||||||
38 | new IMs per new series | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||||
39 | new IMs per series this year | 5 | 2 | 2 | 2 | 2 | ||||||||||||||||||||
40 | total IMs | 5 | 7 | 9 | 11 | 13 | ||||||||||||||||||||
41 | Individual members | 10,140.00 € | 10,350.00 € | 10,620.00 € | 10,950.00 € | 11,340.00 € | 10.77% | |||||||||||||||||||
42 | Supporters | 999 | 999 | 999 | 999 | 999 | ||||||||||||||||||||
43 | Conversion supporters->members | 0.33 | 0.33 | 0.33 | 0.33 | 0.33 | ||||||||||||||||||||
44 | New members per book | 1 | 1 | 1 | 1 | 1 | ||||||||||||||||||||
45 | New members this year | 338 | 7 | 9 | 11 | 13 | ||||||||||||||||||||
46 | Total members | 338 | 345 | 354 | 365 | 378 | ||||||||||||||||||||
47 | Average membership fee | 30.00 € | 30.00 € | 30.00 € | 30.00 € | 30.00 € | ||||||||||||||||||||
48 | Donations | 500.00 € | 700.00 € | 900.00 € | 1,100.00 € | 1,300.00 € | 1.23% | |||||||||||||||||||
49 | Downloads per book | 1000 | 1000 | 1000 | 1000 | 1000 | ||||||||||||||||||||
50 | Conversion download->donation | 1.00% | 1.00% | 1.00% | 1.00% | 1.00% | ||||||||||||||||||||
51 | Average donation | 10.00 € | 10.00 € | 10.00 € | 10.00 € | 10.00 € | ||||||||||||||||||||
52 | Donors | 50 | 70 | 90 | 110 | 130 | ||||||||||||||||||||
53 | 46,265.00 € | 60,925.00 € | 75,645.00 € | 90,425.00 € | 105,265.00 € | 100.00% | ||||||||||||||||||||
54 | ||||||||||||||||||||||||||
55 | ||||||||||||||||||||||||||
56 | Costs | Basis Personnel | Basis Stunden / Einheit | Basis days / Y1 | Basis days / Y2 | Basis days / Y3 | Basis days / Y4 | Basis days / Y5 | Basis € / month | Basis € / year | Costs Y1 | Costs Y2 | Costs Y3 | Costs Y4 | Costs Y5 | Forward projection | ||||||||||
57 | Variable costs | 6,026.39 € | 4,393.50 € | 5,139.62 € | 5,941.01 € | 6,800.75 € | ||||||||||||||||||||
58 | Finalization print; marketing (per book) | Scientist | 1.00 h | 0.63 Tage | 0.88 Tage | 1.13 Tage | 1.38 Tage | 1.63 Tage | 206.00 € | 297.05 € | 393.38 € | 495.22 € | 602.82 € | |||||||||||||
59 | Upload PoD (per book) | Assistant | 1.00 h | 0.63 Tage | 0.88 Tage | 1.13 Tage | 1.38 Tage | 1.63 Tage | 81.25 € | 117.16 € | 155.16 € | 195.32 € | 237.76 € | |||||||||||||
60 | Coordination PoD service providers (per year) | Scientist | 1.00 h | 0.13 Tage | 0.13 Tage | 0.13 Tage | 0.13 Tage | 0.13 Tage | 41.20 € | 42.44 € | 43.71 € | 45.02 € | 46.37 € | |||||||||||||
61 | Coordination University library (year) | Scientist | 1.00 h | 0.13 Tage | 0.13 Tage | 0.13 Tage | 0.13 Tage | 0.13 Tage | 41.20 € | 42.44 € | 43.71 € | 45.02 € | 46.37 € | |||||||||||||
62 | Author support (per book) | Scientist | 1.00 h | 0.63 Tage | 0.88 Tage | 1.13 Tage | 1.38 Tage | 1.63 Tage | 206.00 € | 297.05 € | 393.38 € | 495.22 € | 602.82 € | |||||||||||||
63 | Series editor support (per series and year) | Scientist | 1.00 h | 0.63 Tage | 0.88 Tage | 1.13 Tage | 1.38 Tage | 1.63 Tage | 206.00 € | 297.05 € | 393.38 € | 495.22 € | 602.82 € | |||||||||||||
64 | Acquisition of a new institutional member (events, networking) | Scientist | 1.00 h | 0.63 Tage | 0.25 Tage | 0.25 Tage | 0.25 Tage | 0.25 Tage | 206.00 € | 84.87 € | 87.42 € | 90.04 € | 92.74 € | |||||||||||||
65 | Liaising institutional member (per year) | Scientist | 1.00 h | 0.63 Tage | 0.88 Tage | 1.13 Tage | 1.38 Tage | 1.63 Tage | 206.00 € | 297.05 € | 393.38 € | 495.22 € | 602.82 € | |||||||||||||
66 | institutional member admin (per year) | Clerk | 1.00 h | 0.63 Tage | 0.88 Tage | 1.13 Tage | 1.38 Tage | 1.63 Tage | 177.88 € | 256.50 € | 339.67 € | 427.61 € | 520.52 € | |||||||||||||
67 | Acquistionof new individual member | Scientist | 0.02 h | 0.70 Tage | 0.01 Tage | 0.02 Tage | 0.02 Tage | 0.03 Tage | 232.09 € | 4.95 € | 6.56 € | 8.25 € | 10.05 € | |||||||||||||
68 | Admin new individual member | Clerk | 0.17 h | 7.04 Tage | 0.15 Tage | 0.19 Tage | 0.23 Tage | 0.27 Tage | 2,004.06 € | 42.75 € | 56.61 € | 71.27 € | 86.75 € | |||||||||||||
69 | Support individual member (per year) | Scientist | 0.02 h | 0.70 Tage | 0.72 Tage | 0.74 Tage | 0.76 Tage | 0.79 Tage | 232.09 € | 244.01 € | 257.88 € | 273.87 € | 292.14 € | |||||||||||||
70 | Admin individual member (per year) | Clerk | 0.17 h | 7.04 Tage | 7.19 Tage | 7.38 Tage | 7.60 Tage | 7.88 Tage | 2,004.06 € | 2,106.93 € | 2,226.75 € | 2,364.82 € | 2,522.52 € | |||||||||||||
71 | Support donors (per donor) | Scientist | 0.02 h | 0.10 Tage | 0.15 Tage | 0.19 Tage | 0.23 Tage | 0.27 Tage | 34.33 € | 49.51 € | 65.56 € | 82.54 € | 100.47 € | |||||||||||||
72 | Admin donors (per donor) | Clerk | 0.08 h | 0.52 Tage | 0.73 Tage | 0.94 Tage | 1.15 Tage | 1.35 Tage | 148.23 € | 213.75 € | 283.06 € | 356.34 € | 433.77 € | |||||||||||||
73 | Fix personnel costs | 45,244.00 € | 46,601.32 € | 47,999.36 € | 49,439.34 € | 50,922.52 € | ||||||||||||||||||||
74 | Team coordination | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
75 | Liasing with administration at home institution | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
76 | IT coordination and direction for service providers | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
77 | Coordination with advisory board | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
78 | Coordination PR | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
79 | PR | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
80 | Events & conferences | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
81 | Presentations & networking | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
82 | Managerial accounting | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
83 | Financial planning | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
84 | Bookkeeping | Clerk | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 2,846.00 € | 2,931.38 € | 3,019.32 € | 3,109.90 € | 3,203.20 € | ||||||||||||||
85 | Grant proposals | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
86 | General admin | Clerk | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 2,846.00 € | 2,931.38 € | 3,019.32 € | 3,109.90 € | 3,203.20 € | ||||||||||||||
87 | Manuals and guidelines | Scientist | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 10.00 Tage | 3,296.00 € | 3,394.88 € | 3,496.73 € | 3,601.63 € | 3,709.68 € | ||||||||||||||
88 | ||||||||||||||||||||||||||
89 | Fix non-personnel costs | 43,410.77 € | 44,676.17 € | 45,979.53 € | 47,321.99 € | 48,704.73 € | ||||||||||||||||||||
90 | Rent | 1,000.00 € | 12,000.00 € | 12,360.00 € | 12,730.80 € | 13,112.72 € | 13,506.11 € | 3.00% | ||||||||||||||||||
91 | Stationary and telco | 100.00 € | 1,200.00 € | 1,236.00 € | 1,273.08 € | 1,311.27 € | 1,350.61 € | 3.00% | ||||||||||||||||||
92 | Bookkeeping and annual closure | 120.00 € | 600.00 € | 2,040.00 € | 2,101.20 € | 2,164.24 € | 2,229.16 € | 2,296.04 € | 3.00% | |||||||||||||||||
93 | Travel | 10,000.00 € | 10,000.00 € | 10,300.00 € | 10,609.00 € | 10,927.27 € | 11,255.09 € | 3.00% | ||||||||||||||||||
94 | Legal costs | 2,000.00 € | 2,000.00 € | 2,060.00 € | 2,121.80 € | 2,185.45 € | 2,251.02 € | 3.00% | ||||||||||||||||||
95 | Insurance | 500.00 € | 500.00 € | 515.00 € | 530.45 € | 546.36 € | 562.75 € | 3.00% | ||||||||||||||||||
96 | Design and marketing | 3,000.00 € | 3,000.00 € | 3,090.00 € | 3,182.70 € | 3,278.18 € | 3,376.53 € | 3.00% | ||||||||||||||||||
97 | IT infrastructure | 10,000.00 € | 10,000.00 € | 10,300.00 € | 10,609.00 € | 10,927.27 € | 11,255.09 € | 3.00% | ||||||||||||||||||
98 | Hosting | 120.00 € | 1,440.00 € | 1,483.20 € | 1,527.70 € | 1,573.53 € | 1,620.73 € | 3.00% | ||||||||||||||||||
99 | Depreciation of investment | 1,230.77 € | 1,230.77 € | 1,230.77 € | 1,230.77 € | 1,230.77 € | 1,230.77 € | |||||||||||||||||||
100 | Sum | 94,681.16 € | 95,670.99 € | 99,118.51 € | 102,702.34 € | 106,428.00 € | ||||||||||||||||||||