FreshBox Scalable PnL
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQAR
1
Subscribers
Revenue - monthly
Costs - monthly
Fixed Costs
Variable costs
Customer produce costs
Donated produce costs
Total costs
Profit - monthly
Social Impact - monthly
Number of kg donated
Number of children fed
OtherProfit per kg
Profit per subscriber
2
Subscribers01121502505000R4,000.00R29,708.17R130.00R0.00R0.00R29,838.17-R25,838.170300#DIV/0!#DIV/0!
3
112R51,534.74R29,708.17R36,829.05R20,576.55R8,230.62R66,537.22-R15,002.482057.65504400-R3.65-R133.95
4
Revenue - monthlyR4,000.00R51,534.74R67,662.60R110,104.34R216,208.68150R67,662.60R29,708.17R49,178.72R27,557.88R11,023.15R78,886.90-R11,224.292755.788500-R2.04-R74.83
5
250R110,104.34R29,708.17R81,677.87R45,929.80R18,371.92R111,386.04-R1,281.714592.98700-R0.14-R5.13
6
Costs - monthly500R216,208.68R29,708.17R162,925.74R91,859.60R36,743.84R192,633.92R23,574.769185.96800R1.28R47.15
7
Fixed CostsR29,708.17R29,708.17R29,708.17R29,708.17R29,708.17
8
Variable costsR130.00R36,829.05R49,178.72R81,677.87R162,925.74
9
10
Customer produce costs
R0.00R20,576.55R27,557.88R45,929.80R91,859.60
11
Donated produce costs
R0.00R8,230.62R11,023.15R18,371.92R36,743.84
12
13
14
Total costsR29,838.17R66,537.22R78,886.90R111,386.04R192,633.92
15
16
Profit - monthly-R25,838.17-R15,002.48-R11,224.29-R1,281.71R23,574.76
17
18
Social Impact - monthly
19
Number of kg donated
02057.655042755.7884592.989185.96
20
Number of children fed
300400500700800
21
22
Other
23
Profit per kg#DIV/0!-R3.65-R2.04-R0.14R1.28
24
Profit per subscriber#DIV/0!-R133.95-R74.83-R5.13R47.15
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
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
Loading...
Main menu