Sales Channel Profit Margin Analysis Worksheet - all channels
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
Comment only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Edit with your own numbers! Make a copy (File > Make a copy or File > Download AS). See comments on cells for my calculations and related thoughts. Send your edits and thoughts back to simon@smallfarmcentral.com. I want to keep improving this! -Simon
2
HarvieTrad CSAFarmers marketRestaurants / Small Scale WholesaleWholesale
3
Labor30.00%30.00%30.00%30.00%25.00%
4
Variable10.00%10.00%10.00%10.00%7.50%
5
Fixed10.00%10.00%10.00%10.00%7.50%
6
Production cost %50.00%50.00%50.00%50.00%40.00%
7
8
Post harvest handling cost %5.00%5.00%5.00%5.00%4.00%
9
Software cost7.00%2.00%0.00%2.00%0.00%
10
CC %3.00%3.00%2.00%1.50%0.00%
11
Shrink %0.00%0.00%10.00%0.00%0.00%
12
Customer Acq %3.76%7.49%0.00%1.00%0.50%
13
Admin Cost %2.00%4.00%1.00%4.00%1.00%
14
Discount over retail %0.00%15.00%0.00%25.00%45.00%
15
16
Average order $ 26.25 $ 25.00 $ 15.00 $ 75.00 $ 500.00
17
Average order - retail value $ 26.25 $ 29.41 $ 15.00 $ 100.00 $ 909.09
18
19
Average order $ 26.25 $ 25.00 $ 15.00 $ 75.00 $ 500.00
20
Post harvest handling per order
$ 1.31 $ 1.47 $ 0.75 $ 5.00 $ 36.36
21
Pack labor per order $ 1.25 $ 1.00 $ - $ 1.50 $ 7.50
22
Label cost per order $ 0.03 $ - $ - $ 0.03 $ -
23
Delivery cost per order $ 1.50 $ 1.50 $ - $ 5.00 $ 25.00
24
Box/bag cost per order $ 0.75 $ 0.75 $ 0.05 $ 3.00 $ 15.00
25
Shrink cost per order $ - $ - $ 1.50 $ - $ -
26
Marketing cost per order $ - $ - $ 3.05 $ - $ -
27
Software cost per order $ 1.84 $ 0.50 $ - $ 1.50 $ -
28
CC % cost per order $ 0.79 $ 0.75 $ 0.30 $ 1.13 $ -
29
Customer Acq cost per order $ 0.99 $ 1.87 $ - $ 0.75 $ 2.50
30
Admin labor per order $ 0.53 $ 1.00 $ - $ 3.00 $ 5.00
31
Total marketing cost per order
$ 8.98 $ 8.84 $ 5.65 $ 20.91 $ 91.36
32
33
Marketing cost per order $ 8.98 $ 8.84 $ 5.65 $ 20.91 $ 91.36
34
Production cost per order $ 13.13 $ 14.71 $ 7.50 $ 50.00 $ 363.64
35
Total cost per order $ 22.11 $ 23.55 $ 13.15 $ 70.91 $ 455.00
36
Average order $ 26.25 $ 25.00 $ 15.00 $ 75.00 $ 500.00
37
38
Profit margin15.79%5.80%12.33%5.46%9.00%
39
40
Gross sales needed for farmer salary
$ 316,695.02 $ 861,440.86 $ 405,405.41 $ 915,750.92 $ 555,555.56
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