| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
1 | |||||||
2 | |||||||
3 | |||||||
4 | |||||||
5 | |||||||
6 | |||||||
7 | |||||||
8 | Table Key | ||||||
9 | Green boxes are descriptions. | ||||||
10 | Yellow fields counts automatically. | ||||||
11 | Grey fields counts automatically. | ||||||
12 | White field - fill them in. | ||||||
13 | |||||||
14 | MICROGREENS PRODUCTION CALCULATION PER MONTH | ||||||
15 | variety to grow | gram/tray | price/kg | no. of trays per month | seed cost | ||
16 | Pea | 280 | €4,00 | 20 | €22,40 | ||
17 | Radish | 48 | €20,00 | 20 | €19,20 | ||
18 | Sunflower | 150 | €7,00 | 20 | €21,00 | ||
19 | Broccoli | 50 | €25,00 | 20 | €25,00 | ||
20 | total no. of trays | total seed cost | |||||
21 | 80 | €87,60 | |||||
22 | supplies changeable | ||||||
23 | type | quantity | price/1 piece | replacement indicator | total supplies cost | ||
24 | Shallow Growing tray "10x20" | 80 | €3,00 | 0,1 | €24,00 | ||
25 | CocoMat 25x50cm | 80 | €1,10 | 1 | €88,00 | ||
26 | 50g box | 512 | €0,15 | 1 | €76,80 | ||
27 | Transport box | 50 | €1,20 | 1 | €60,00 | ||
28 | total | ||||||
29 | €248,80 | ||||||
30 | fixed costs | ||||||
31 | type | quantity | price/unit | total price | |||
32 | rental commercial | 1 | €0,00 | €0,00 | |||
33 | electricity | 40 | €0,70 | €28,00 | |||
34 | water | 10 | €1,10 | €11,00 | |||
35 | other fees | 1 | €70,00 | €70,00 | |||
36 | fuel | 4 | €1,20 | €4,80 | |||
37 | total | ||||||
38 | €113,80 | ||||||
39 | working time | ||||||
40 | time labour | time each day/hour | days/monthly | time total/hours | |||
41 | sowing time | 2 | 4 | 8 | €120,00 | ||
42 | watering time | 0,3 | 30 | 9 | €135,00 | ||
43 | harvesting + packing | 1,5 | 8 | 12 | €180,00 | ||
44 | delivery | 2 | 8 | 16 | €240,00 | ||
45 | cleaning | 1 | 8 | 8 | €120,00 | ||
46 | total time spent | total cost | |||||
47 | 53 | €795,00 | |||||
48 | |||||||
49 | my salary/hour | €15,00 | total production cost | €1 245,20 | |||
50 | |||||||
51 | |||||||
52 | |||||||