Csa Planning Part 1
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Csa Planning Part 1 as PDF for free.
More details
- Words: 8,157
- Pages: 12
A
B
2 3 4 5 6
C
D E
G
H
I
J
K
L
M
N
O
P
Q
1. The following table lists available crops and defines the size and price of produce units for the rest of the calculator spreadsheets. 2. These unit prices (with a few adjustments) were 2001 prices paid by CEFS student farm CSA members. 3. For convenience, all unit prices are multiples of $ 0.50
7
Crop
Unit size
Price / unit
8
Arugula
1 pint
$1.00
9
Beets
1 bunch (~ 1 lb)
$1.50
10
Broccoli
1 large head (~ 1 lb)
$2.00
11
Cabbage
1 head (~ 2 lbs)
$1.50
12
Cantaloupe
1 fruit (~ 4 lbs)
$3.00
13
Carrots
1 bunch (~ 8)
$1.50
14
Cauliflower
1 large head (~ 1 lb)
$2.00
15
Collards
1 bunch (~ 1 lb)
$1.00
16
Cucumbers
2 fruits (~ 1 lb)
$0.50
17
Edamame
1 quart bag
$2.00
18
Eggplant
1 medium fruit
$0.50
19
Garlic
3 bulbs
$1.00
20
Green onions
1 bunch (~ 1 lb)
$1.50
21
Kale
1 bag (~ 1 lb)
$1.00
22
Kohlrabi
1 qt bag
$1.00
23
Lettuce
1 head
$1.00
24
Mustard greens
1 quart
$1.00
25
Okra
1 quart
$2.00
26
Pac choi
1 head (~ 2 lbs)
$1.50
27
Parsley
1 bunch (~ 0.25 lbs)
$1.00
28
Peas
1 quart
$2.00
29
Peppers
2 fruits
$1.00
30
Potatoes
1 quart
$1.00
31
Radishes
1 bunch (~ 0.5 lbs)
$1.00
32
Snap beans
1 quart
$2.00
33
Southern peas
1 quart
$2.00
34
Spinach
1 quart
$2.00
35
Storage onions
3 bulbs (~ 1 lb)
$1.00
36
Summer squash
3 fruits (~ 1 lb)
$1.00
37
Sweet corn
1/2 dozen
$2.00
38
Swiss chard
1 bunch (~ 1 lb)
$1.50
39
Tomatoes
2 fruits
$1.00
40
Turnips
1 bunch (~ 1 lb)
$1.00
41
Watermelons
1 fruit (~ 8 lbs)
$4.00
42 43 44
F
Produce Units and Prices
1
**Flowers and trial crops will routinely be available for free** **Produce unit sizes may be downsized if insufficient produce is available**
produceunits
R
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
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
Produce calendar
1 2 3 4 5 6 7
1. 2. 3. 4.
This produce calendar was developed in 2001 for the CEFS student farm in Goldsboro, NC. It is possible to begin harvesting many spring crops before week 19 in Goldsboro, NC. Each farm should develop a harvest calendar that is appropriate for their production conditions and market opportunities, this is only one example. The recommended planting dates contained in "Commercial vegetable recommendations for the Southeast" are useful when developing a harvest calendar Website to find more information: http://ipm.ncsu.edu/vegetables/CommercialVegetables/
8 9
= Weeks when crops are PROJECTED TO BE AVAILABLE = Weeks when crops are *NOT* projected to be available.
10 11 12 13 14
5. The number of weeks each crop is projected to be available can be found at the bottom of each crop column. 6. The number of crops projected to be available each week can be found at the far right of each week row.
32
Peas
Mustard greens
Carrots
Collards
Cabbage
Potatoes
Sweet corn
Summer squash
Cucumbers
Storage onions
Garlic
Snap beans
Okra
Eggplant
Peppers
Tomatoes
Watermelons
Cantaloupes
Southern peas
Edamame
Number of crops
31
Pac choi
30
Cauliflower
29
Broccoli
28
Lettuce
27
Kohlrabi
26
Kale
25
Turnips
24
Beets
23
Arugula
22
Spinach
21
Radishes
20
Green onions
19
Parsley
18
Swiss chard
17
Monday date
16
week of the year
15
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0
1 1 1 1 1 0 0 0 0 0 0 0 0 0 0
1 1 1 1 1 0 0 0 0 0 0 0 0 0 0
0 1 1 1 1 1 1 0 0 0 0 0 0 0 0
0 0 1 1 1 1 1 1 1 0 0 0 0 0 0
0 0 1 1 1 1 1 1 1 0 0 0 0 0 0
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
0 0 0 0 0 0 1 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 0 1 1 1 1 1 1 1
0 0 0 0 0 0 0 0 1 1 1 1 1 1 1
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1
0 0 0 0 0 0 0 0 0 0 1 1 1 1 1
16 17 19 19 19 19 17 21 16 16 17 17 17 17 17
Number of weeks: 15
15
15
9
8
8
8
8
8
8
8
6
6
6
5
5
6
7
7
10
10
10
9
8
8
8
8
8
7
7
6
6
6
5
producecalendar
A
B
C
D
E
F
G
H
1
Calendar for designing CSA "fullshare" composition
2
1. This calendar defines the target composition of a CSA "fullshare".
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
3
= weeks when crops are available
4
= weeks when crops are *NOT* projected to be available
5 6
5. This spreadsheet will automatically calculate totals for each item, each week and a grand total.
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
Carrots
Collards
Cabbage
Potatoes
Sweet corn
Summer squash
Cucumbers
Storage onions
Garlic
Snap beans
Okra
Eggplant
Peppers
Tomatoes
Watermelons
Cantaloupes
Southern peas
Edamame
Week's total
26
Mustard greens
25
Peas
24
Pac choi
23
Cauliflower
22
Broccoli
21
Lettuce
20
Kohlrabi
19
Kale
18
Turnips
17
Beets
16
Arugula
15
Spinach
14
Radishes
13
Green onions
12
19 10-May 20 17-May 21 24-May 22 31-May 23 7-Jun 24 14-Jun 25 21-Jun 26 28-Jun 27 5-Jul 28 12-Jul 29 19-Jul 30 26-Jul 31 2-Aug 32 9-Aug 33 16-Aug Total units: Unit price: Total value:
Parsley
11
Swiss chard
9 10
Monday date
8
Week of the year
7
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15 $1.50 $22.50
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15 $1.00 $15.00
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15 $1.50 $22.50
1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 9 $1.00 $9.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $2.00 $16.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.50 $12.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 6 $2.00 $12.00
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 6 $2.00 $12.00
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 6 $1.50 $9.00
1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 5 $2.00 $10.00
1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 5 $1.00 $5.00
0 1 1 1 1 1 1 0 0 0 0 0 0 0 0 6 $1.50 $9.00
0 0 1 1 1 1 1 1 1 0 0 0 0 0 0 7 $1.00 $7.00
0 0 1 1 1 1 1 1 1 0 0 0 0 0 0 7 $1.50 $10.50
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 10 $1.00 $10.00
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 10 $2.00 $20.00
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 10 $1.00 $10.00
0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 9 $0.50 $4.50
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 $1.00 $8.00
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 $1.00 $8.00
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 $2.00 $16.00
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 $2.00 $16.00
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 $0.50 $4.00
0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 7 $1.00 $7.00
0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 7 $1.00 $7.00
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 6 $4.00 $24.00
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 6 $3.00 $18.00
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 6 $2.00 $12.00
0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 5 $2.00 $10.00
$22.00 $23.50 $26.00 $26.00 $26.00 $27.00 $22.00 $27.00 $20.50 $26.00 $28.00 $28.00 $28.00 $28.00 $28.00
Formulas: Week Total (See answer in column AJ, Row 12, ie. Swiss Chard): C6*C$22+D6*D$22+E6*E$22+F6*F$22+G6*G$22+H6*H$22+I6*I$22+J6*J$22+K6*K$22+L6*L$ 22+M6*M$22+N6*N$22+O6*O$22+P6*P$22+Q6*Q$22+R6*R$22+S6*S$22+T6*T$22+U6*U$22 +V6*V$22+W6*W$22+Y6*Y$22+Z6*Z$22+X6*X$22+AA6*AA$22+AB6*AB$22+AC6*AC$22+AD 6*AD$22+AE6*AE$22+AF6*AF$22+AG6*AG$22+AH6*AH$22+AI6*AI$22 Total Units per crop (ie. Swiss Chard): SUM(C12:C26) Unit Price (ie. Swiss Chard): produceunits!C37 Total Value (ie. Swiss Chard): C27*C28 Grand Total (See answer in column AJ, Row 29): SUM(C29:AI29)
CSAfullshare
Grand total
$386.00
AL
AM
AN
AO
A 1
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
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
Calendar for designing CSA "half share" composition
1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 5 $2.00 $10.00
0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 2 $1.00 $2.00
0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 3 $1.50 $4.50
0 0 1 0 1 0 1 0 1 0 0 0 0 0 0 4 $1.00 $4.00
0 0 0 1 0 1 0 1 0 0 0 0 0 0 0 3 $1.50 $4.50
0 0 0 1 0 1 0 1 0 1 0 1 0 5 $1.00 $5.00
22 23 24 25 26 27
CSAhalfshare
Week total
1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 3 $1.50 $4.50
Edamame
0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 3 $2.00 $6.00
Southern peas
1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 3 $2.00 $6.00
Cantaloupes
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
Watermelons
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $1.00 $0.00
Tomatoes
0 1 0 1 0 1 0 1 0 0 0 0 0 0 0 4 $1.00 $4.00
Bell peppers
0 1 0 1 0 1 0 1 0 0 0 0 0 0 0 4 $1.00 $4.00
Eggplant
1 0 1 0 1 0 1 0 0 0 0 0 0 0 0 4 $1.50 $6.00
Okra
1 0 1 0 1 0 1 0 0 0 0 0 0 0 0 4 $1.00 $4.00
Snap beans
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $2.00 $16.00
Garlic
Potatoes
0 1 0 1 0 1 0 1 0 0 0 0 0 0 0 4 $1.00 $4.00
Storage onions
Cabbage
1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 8 $1.50 $12.00
Cucumbers
Collards
0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 7 $1.00 $7.00
Summer squash
Carrots
1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 8 $1.50 $12.00
Sweet corn
Mustard greens
21
Peas
20
Pac choi
19
Cauliflower
18
Broccoli
17
Lettuce
16
Kohlrabi
15
Kale
14
Turnips
13
Beets
12
Arugula
9
11
Spinach
8
10
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug Total units: Unit price: Total value:
Radishes
7
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
Green onions
6
Parsley
5
Swiss chard
4
Monday date
3
Week of the year
2
0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 5 $2.00 $10.00
0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 5 $1.00 $5.00
0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 4 $0.50 $2.00
0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 4 $1.00 $4.00
0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 4 $1.00 $4.00
0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 4 $2.00 $8.00
0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 4 $2.00 $8.00
0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 4 $0.50 $2.00
0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 4 $1.00 $4.00
0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 4 $1.00 $4.00
0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 3 $4.00 $12.00
0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 3 $3.00 $9.00
0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 3 $2.00 $6.00
0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 3 $2.00 $6.00
$14.00 $13.50 $15.00 $15.00 $15.00 $15.00 $10.50 $16.50 $9.00 $15.00 $13.00 $15.00 $13.00 $15.00 $13.00 Grand total $207.50
AL
AM
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
Potatoes
A 1
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
Calendar for market #1
10 10 10 10 10 10 0 0 0 0 0 0 0 0 0 60 $1.50 $90.00
20 20 20 20 20 0 0 0 0 0 0 0 0 0 0 100 $2.00 $200.00
10 10 10 10 10 0 0 0 0 0 0 0 0 0 0 50 $1.00 $50.00
0 40 40 40 40 40 40 0 0 0 0 0 0 0 0 240 $1.50 $360.00
0 0 20 20 20 20 20 20 20 0 0 0 0 0 0 140 $1.00 $140.00
0 0 10 10 10 10 10 10 10 0 0 0 0 0 0 70 $1.50 $105.00
Total value:
22 23 24 25 26 27
market1
30 30 30 30 30 30 30 30 30 30 300 $1.00 $300.00
Week total
20 20 20 20 20 20 0 0 0 0 0 0 0 0 0 120 $2.00 $240.00
Edamame
40 40 40 40 40 40 0 0 0 0 0 0 0 0 0 240 $2.00 $480.00
Southern peas
30 30 30 30 30 30 30 30 0 0 0 0 0 0 0 240 $1.00 $240.00
Cantaloupes
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 80 $1.00 $80.00
Watermelons
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 80 $1.00 $80.00
Tomatoes
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 80 $1.00 $80.00
Bell peppers
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 80 $1.50 $120.00
Eggplant
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 80 $1.00 $80.00
Okra
30 30 30 30 30 30 30 30 0 0 0 0 0 0 0 240 $2.00 $480.00
Snap beans
10 10 10 10 10 10 10 10 10 0 0 0 0 0 0 90 $1.00 $90.00
Garlic
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 300 $1.50 $450.00
Storage onions
Cabbage
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 150 $1.00 $150.00
Cucumbers
Collards
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 150 $1.50 $225.00
Summer squash
Carrots
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug Total units Unit price:
Sweet corn
Mustard greens
21
Peas
20
Pac choi
19
Cauliflower
18
Broccoli
17
Lettuce
16
Kohlrabi
15
Kale
14
Turnips
13
Beets
12
Arugula
9
11
Spinach
8
10
Radishes
7
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
Green onions
6
Parsley
5
Swiss chard
4
Friday date
3
Week of the year
2
0 0 0 0 0 60 60 60 60 60 60 60 60 60 60 600 $2.00 $1,200.00
0 0 0 0 0 30 30 30 30 30 30 30 30 30 30 300 $1.00 $300.00
0 0 0 0 0 0 30 30 30 30 30 30 30 30 30 270 $0.50 $135.00
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20 160 $1.00 $160.00
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20 160 $1.00 $160.00
0 0 0 0 0 0 0 30 30 30 30 30 30 30 30 240 $2.00 $480.00
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20 160 $2.00 $320.00
0 0 0 0 0 0 0 30 30 30 30 30 30 30 30 240 $0.50 $120.00
0 0 0 0 0 0 0 0 40 40 40 40 40 40 40 280 $1.00 $280.00
0 0 0 0 0 0 0 0 40 40 40 40 40 40 40 280 $1.00 $280.00
0 0 0 0 0 0 0 0 0 20 20 20 20 20 20 120 $4.00 $480.00
0 0 0 0 0 0 0 0 0 20 20 20 20 20 20 120 $3.00 $360.00
0 0 0 0 0 0 0 0 0 10 10 10 10 10 10 60 $2.00 $120.00
0 0 0 0 0 0 0 0 0 0 20 20 20 20 20 100 $2.00 $200.00
$395.00 $455.00 $490.00 $490.00 $490.00 $620.00 $500.00 $595.00 $530.00 $645.00 $685.00 $685.00 $685.00 $685.00 $685.00 Grand total $8,635.00
Q
R
S
T
U
V
W
X
0 0 0 0 0 60 60 60 60 60 60 60 60 60 60
0 0 0 0 0 30 30 30 30 30 30 30 30 30 30
Y
Z
AA
AB
AC
AD
0 0 0 0 0 0 30 30 30 30 30 30 30 30 30
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20
0 0 0 0 0 0 0 30 30 30 30 30 30 30 30
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20
0 0 0 0 0 0 0 30 30 30 30 30 30 30 30
AF
AG
AH
Week total
P
Edamame
O
Southern peas
N
Cantaloupes
M
Watermelons
L
Tomatoes
K
Bell peppers
J
Eggplant
I
Okra
H
Snap beans
G
Garlic
F
Storage onions
E
Cucumbers
D
Summer squash
C
Sweet corn
B
Potatoes
A 1
AE
AI
AJ
AK
0 0 0 0 0 0 0 0 40 40 40 40 40 40 40
0 0 0 0 0 0 0 0 40 40 40 40 40 40 40
0 0 0 0 0 0 0 0 0 20 20 20 20 20 20
0 0 0 0 0 0 0 0 0 20 20 20 20 20 20
0 0 0 0 0 0 0 0 0 10 10 10 10 10 10
0 0 0 0 0 0 0 0 0 0 20 20 20 20 20
$395.00 $455.00 $490.00 $490.00 $490.00 $620.00 $500.00 $595.00 $530.00 $645.00 $685.00 $685.00 $685.00 $685.00 $685.00
Calendar for market #2
Cauliflower
Pac choi
Peas
Mustard greens
Carrots
Collards
Cabbage
18
Broccoli
17
Lettuce
16
Kohlrabi
15
Kale
14
Turnips
13
Beets
12
Arugula
9
11
Spinach
8
10
Radishes
7
Green onions
6
Parsley
5
Swiss chard
4
Monday date
3
Week of the year
2
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
10 10 10 10 10 10 10 10 10 0 0 0 0 0 0
30 30 30 30 30 30 30 30 0 0 0 0 0 0 0
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0
30 30 30 30 30 30 30 30 0 0 0 0 0 0 0
40 40 40 40 40 40 0 0 0 0 0 0 0 0 0
20 20 20 20 20 20 0 0 0 0 0 0 0 0 0
10 10 10 10 10 10 0 0 0 0 0 0 0 0 0
20 20 20 20 20 0 0 0 0 0 0 0 0 0 0
10 10 10 10 10 0 0 0 0 0 0 0 0 0 0
0 40 40 40 40 40 40 0 0 0 0 0 0 0 0
0 0 20 20 20 20 20 20 20 0 0 0 0 0 0
0 0 10 10 10 10 10 10 10 0 0 0 0 0 0
30 30 30 30 30 30 30 30 30 30
19
Total units:
150
150
300
90
240
80
80
80
80
80
240
240
120
60
100
50
240
140
70
300
600
300
270
160
160
240
160
240
280
280
120
120
60
100
20
Unit price: Total value:
$1.50 $225.00
$1.00 $150.00
$1.50 $450.00
$1.00 $90.00
$2.00 $480.00
$1.00 $80.00
$1.50 $120.00
$1.00 $80.00
$1.00 $80.00
$1.00 $80.00
$1.00 $240.00
$2.00 $480.00
$2.00 $240.00
$1.50 $90.00
$2.00 $200.00
$1.00 $50.00
$1.50 $360.00
$1.00 $140.00
$1.50 $105.00
$1.00 $300.00
$2.00 $1,200.00
$1.00 $300.00
$0.50 $135.00
$1.00 $160.00
$1.00 $160.00
$2.00 $480.00
$2.00 $320.00
$0.50 $120.00
$1.00 $280.00
$1.00 $280.00
$4.00 $480.00
$3.00 $360.00
$2.00 $120.00
$2.00 $200.00
21 22 23 24 25 26
market2
Grand total $8,635.00
AL
AM
A 1
B
C
D
This worksheet represents a CSA with:
2
E
F
100
G
"full shares"
H
I
J
50
and
K
L
M
N
O
P
Q
R
"half shares".
Modify the worksheets: CSAfullshare and CSAhalfshare to redefine the half and full share compositions.
3
CHANGE THE NUMBERS IN THE YELLOW BOXES to change the number of half and full share members represented by this worksheet.
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
Mustard greens
22
Peas
21
Pac choi
20
Cauliflower
19
Broccoli
18
Lettuce
17
Kohlrabi
16
Kale
15
Turnips
14
Beets
13
Arugula
12
Spinach
11
Radishes
9 10
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug Total units: Unit price: Total value:
Green onions
8
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
Parsley
7
Swiss chard
6
Monday date
5
Week of the year
4
150 100 150 100 150 100 150 100 150 100 150 100 150 100 150 1900 $1.50 $2,850.00
100 150 100 150 100 150 100 150 100 150 100 150 100 150 100 1850 $1.00 $1,850.00
150 100 150 100 150 100 150 100 150 100 150 100 150 100 150 1900 $1.50 $2,850.00
100 150 100 150 100 150 100 150 100 0 0 0 0 0 0 1100 $1.00 $1,100.00
150 150 150 150 150 150 150 150 0 0 0 0 0 0 0 1200 $2.00 $2,400.00
150 100 150 100 150 100 150 100 0 0 0 0 0 0 0 1000 $1.00 $1,000.00
150 100 150 100 150 100 150 100 0 0 0 0 0 0 0 1000 $1.50 $1,500.00
100 150 100 150 100 150 100 150 0 0 0 0 0 0 0 1000 $1.00 $1,000.00
100 150 100 150 100 150 100 150 0 0 0 0 0 0 0 1000 $1.00 $1,000.00
100 100 100 100 100 100 100 100 0 0 0 0 0 0 0 800 $1.00 $800.00
150 150 150 150 150 150 150 150 0 0 0 0 0 0 0 1200 $1.00 $1,200.00
150 100 150 100 150 100 0 0 0 0 0 0 0 0 0 750 $2.00 $1,500.00
100 150 100 150 100 150 0 0 0 0 0 0 0 0 0 750 $2.00 $1,500.00
150 100 150 100 150 100 0 0 0 0 0 0 0 0 0 750 $1.50 $1,125.00
150 150 150 150 150 0 0 0 0 0 0 0 0 0 0 750 $2.00 $1,500.00
100 150 100 150 100 0 0 0 0 0 0 0 0 0 0 600 $1.00 $600.00
Formulas: Week Total (See answer in column AK, Row 8) C6*C$22+D6*D$22+E6*E$22+F6*F$22+G6*G$22+H6*H$22+I6*I$22+J6*J$22+K6*K$22+L6*L$2 2+M6*M$22+N6*N$22+O6*O$22+P6*P$22+Q6*Q$22+R6*R$22+S6*S$22+T6*T$22+U6*U$22+V 6*V$22+W6*W$22+Y6*Y$22+Z6*Z$22+X6*X$22+AA6*AA$22+AB6*AB$22+AC6*AC$22+AD6*A D$22+AE6*AE$22+AF6*AF$22+AG6*AG$22+AH6*AH$22+AI6*AI$22+AJ6*AJ$22 Swiss Chard harvest total on wk19 : CSAfullshare!C9*$E$1 + CSAhalfshare!C4*$I$1 Total Units per crop (ie. Swiss Chard): SUM(C6:C20) Unit Price (ie. Swiss Chard): produceunits!C37 Total Value (ie. Swiss Chard): C21*C22 Grand Total (See answer in column AK, Row 23: SUM(AK6:AK20)
CSAtotals
S
T
U
V
W
X
Sweet corn
Summer squash
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
1 2 3
16 17 18 19 20 21 22 23
100 150 100 150 100 150 100 150 100 150 1250 $1.00 $1,250.00
Week total
15
150 100 150 100 150 100 150 100 150 100 1250 $2.00 $2,500.00
Edamame
14
150 100 150 100 150 100 150 100 150 100 1250 $1.00 $1,250.00
Southern peas
13
Cantaloupes
12
Watermelons
11
Tomatoes
100 150 100 150 100 150 100 0 0 0 0 0 0 850 $1.50 $1,275.00
Peppers
9 10
Eggplant
8
0 0 0 0 0
Okra
150 100 150 100 150 100 150 0 0 0 0 0 0 900 $1.00 $900.00
0 0 0 0 0
Snap beans
0 0
150 100 150 100 150 100 0 0 0 0 0 0 0 0 750 $1.50 $1,125.00
Garlic
Potatoes
0 0
7
Storage onions
Cabbage
0
6
Cucumbers
Collards
5
Carrots
4
0 0 0 0 0 0 100 150 100 150 100 150 100 150 100 1100 $0.50 $550.00
0 0 0 0 0 0 0 150 100 150 100 150 100 150 100 1000 $1.00 $1,000.00
0 0 0 0 0 0 0 150 100 150 100 150 100 150 100 1000 $1.00 $1,000.00
0 0 0 0 0 0 0 100 150 100 150 100 150 100 150 1000 $2.00 $2,000.00
0 0 0 0 0 0 0 150 100 150 100 150 100 150 100 1000 $2.00 $2,000.00
0 0 0 0 0 0 0 150 100 150 100 150 100 150 100 1000 $0.50 $500.00
0 0 0 0 0 0 0 0 150 100 150 100 150 100 150 900 $1.00 $900.00
0 0 0 0 0 0 0 0 150 100 150 100 150 100 150 900 $1.00 $900.00
0 0 0 0 0 0 0 0 0 150 100 150 100 150 100 750 $4.00 $3,000.00
0 0 0 0 0 0 0 0 0 100 150 100 150 100 150 750 $3.00 $2,250.00
0 0 0 0 0 0 0 0 0 150 100 150 100 150 100 750 $2.00 $1,500.00
0 0 0 0 0 0 0 0 0 0 150 100 150 100 150 650 $2.00 $1,300.00
$2,900.00 $3,025.00 $3,350.00 $3,350.00 $3,350.00 $3,450.00 $2,725.00 $3,525.00 $2,500.00 $3,350.00 $3,450.00 $3,550.00 $3,450.00 $3,550.00 $3,450.00
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
CSAtotals
Grand total $48,975.00
AL
A 1
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
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
Farm totals = CSAfullshares + CSAhalfshares + market1 + market 2 Mustard greens
Carrots
Collards
Cabbage
Potatoes
Sweet corn
Summer squash
Cucumbers
Storage onions
Garlic
Snap beans
Okra
Eggplant
Bell peppers
Tomatoes
Watermelons
Cantaloupes
Southern peas
Edamame
Week total
21
Peas
20
Pac choi
19
Cauliflower
18
Broccoli
17
Lettuce
16
Kohlrabi
15
Kale
14
Turnips
13
Beets
12
Arugula
9 11
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug Total units: Unit price: Total value:
Spinach
8 10
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
Radishes
7
Green onions
6
Parsley
5
Swiss chard
4
Monday date
3
Week of the year
2
170 120 170 120 170 120 170 120 170 120 170 120 170 120 170 2200 $1.50 $3,300.00
120 170 120 170 120 170 120 170 120 170 120 170 120 170 120 2150 $1.00 $2,150.00
190 140 190 140 190 140 190 140 190 140 190 140 190 140 190 2500 $1.50 $3,750.00
120 170 120 170 120 170 120 170 120 0 0 0 0 0 0 1280 $1.00 $1,280.00
210 210 210 210 210 210 210 210 0 0 0 0 0 0 0 1680 $2.00 $3,360.00
170 120 170 120 170 120 170 120 0 0 0 0 0 0 0 1160 $1.00 $1,160.00
170 120 170 120 170 120 170 120 0 0 0 0 0 0 0 1160 $1.50 $1,740.00
120 170 120 170 120 170 120 170 0 0 0 0 0 0 0 1160 $1.00 $1,160.00
120 170 120 170 120 170 120 170 0 0 0 0 0 0 0 1160 $1.00 $1,160.00
120 120 120 120 120 120 120 120 0 0 0 0 0 0 0 960 $1.00 $960.00
210 210 210 210 210 210 210 210 0 0 0 0 0 0 0 1680 $1.00 $1,680.00
230 180 230 180 230 180 0 0 0 0 0 0 0 0 0 1230 $2.00 $2,460.00
140 190 140 190 140 190 0 0 0 0 0 0 0 0 0 990 $2.00 $1,980.00
170 120 170 120 170 120 0 0 0 0 0 0 0 0 0 870 $1.50 $1,305.00
190 190 190 190 190 0 0 0 0 0 0 0 0 0 0 950 $2.00 $1,900.00
120 170 120 170 120 0 0 0 0 0 0 0 0 0 0 700 $1.00 $700.00
0 230 180 230 180 230 180 0 0 0 0 0 0 0 0 1230 $1.50 $1,845.00
0 0 190 140 190 140 190 140 190 0 0 0 0 0 0 1180 $1.00 $1,180.00
0 0 120 170 120 170 120 170 120 0 0 0 0 0 0 990 $1.50 $1,485.00
0 0 0 0 0 210 160 210 160 210 160 210 160 210 160 1850 $1.00 $1,850.00
0 0 0 0 0 270 220 270 220 270 220 270 220 270 220 2450 $2.00 $4,900.00
0 0 0 0 0 160 210 160 210 160 210 160 210 160 210 1850 $1.00 $1,850.00
0 0 0 0 0 0 160 210 160 210 160 210 160 210 160 1640 $0.50 $820.00
0 0 0 0 0 0 0 190 140 190 140 190 140 190 140 1320 $1.00 $1,320.00
0 0 0 0 0 0 0 190 140 190 140 190 140 190 140 1320 $1.00 $1,320.00
0 0 0 0 0 0 0 160 210 160 210 160 210 160 210 1480 $2.00 $2,960.00
0 0 0 0 0 0 0 190 140 190 140 190 140 190 140 1320 $2.00 $2,640.00
0 0 0 0 0 0 0 210 160 210 160 210 160 210 160 1480 $0.50 $740.00
0 0 0 0 0 0 0 0 230 180 230 180 230 180 230 1460 $1.00 $1,460.00
0 0 0 0 0 0 0 0 230 180 230 180 230 180 230 1460 $1.00 $1,460.00
0 0 0 0 0 0 0 0 0 190 140 190 140 190 140 990 $4.00 $3,960.00
0 0 0 0 0 0 0 0 0 140 190 140 190 140 190 990 $3.00 $2,970.00
0 0 0 0 0 0 0 0 0 170 120 170 120 170 120 870 $2.00 $1,740.00
0 0 0 0 0 0 0 0 0 0 190 140 190 140 190 850 $2.00 $1,700.00
$3,690.00 $3,935.00 $4,330.00 $4,330.00 $4,330.00 $4,690.00 $3,725.00 $4,715.00 $3,560.00 $4,640.00 $4,820.00 $4,920.00 $4,820.00 $4,920.00 $4,820.00
farmtotals
Grand total $66,245.00
A 1
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Field Production Information
2 3 4 5
The following table summarizes field production information related to total farm sale goals The current version of this spreadsheet distributes total yield estimates for multiple harvest crops evenly across the harvest season. This is not realistic and should be accounted for in a future version of the spreadsheet.
Edamame
Eggplant
Garlic
Green onions
Kale
Kohlrabi
15
Cucumbers
14
Collards
13
Cauliflower
12
Carrots
11
Cantaloupes
10
Number of plantings: Number of harvests: Total row feet needed: Total amount of seed needed (oz., lbs) Row feet needed per planting Total Nitrogen per planting (lbs) Potassium (K2O) per planting (lbs) total value per crop
Cabbage
9
Broccoli
8
Beets
7
Arugula
6
4 8 1,083 0.89 271 1.24 1.14 $1,160
4 8 1,213 2.27 303 1.39 1.28 $1,740
3 6 2,679 2.23 893 5.13 5.64 $2,460
2 7 986 1.23 493 2.83 3.11 $1,485
3 6 2,300 1.92 767 7.04 9.68 $2,970
1 6 1,236 2.05 1236 4.73 5.20 $1,845
3 6 1,327 0.73 442 2.54 2.79 $1,980
1 7 1,371 6.85 1371 9.44 8.65 $1,180
2 9 714 3.57 357 4.92 4.51 $820
3 5 2,962 14.81 987 0.00 1.70 $1,700
1 8 645 0.13 645 8.88 8.14 $740
1 1 3,450 689.99 3450 19.80 14.52 $1,320
7 15 7,260 5.19 1037 3.97 4.37 $3,750
2 8 674 1.68 337 2.32 2.13 $1,160
4 8 2,091 2.61 523 2.00 2.20 $960
16 17
Total Acreage
18
5.08
acres
19
Gross revenue
20
$66,245
21 22 23 24 25 26 27 28 29 30 31
Calculations: Number of plantings: yielddata!$C12 Number of harvests: yielddata!$D12 Total row feet needed: onesizefitsall!H21*yielddata!$Q12 Total amount of seed needed (oz., lbs) yielddata!$E12*B11/100 row ft per planting B9/B7 N per planting (lbs) yielddata!$F12*(B11/yielddata!$O12) K2O per planting (lbs) yielddata!$G12*(B11/yielddata!$O12) total value per croponesizefitsall!H23
32 33
Total Acreage
34 35 36 37
Total Acreage Calculation B9/yielddata!O12+C9/yielddata!O13+D9/yielddata!O14+E9/yielddata!O15+F9/yielddata!O16+G9/yielddata!O17+H9/yielddata !O18+I9/yielddata!O19+J9/yielddata!O20+K9/yielddata!O21+L9/yielddata!O22+M9/yielddata!O23+N9/yielddata!O24+O9/yiel ddata!O25+P9/yielddata!O26+Q9/yielddata!O27+R9/yielddata!O28+S9/yielddata!O29+T9/yielddata!O30+U9/yielddata!O31+ V9/yielddata!O32+W9/yielddata!O33+X9/yielddata!O34+Y9/yielddata!O35+Z9/yielddata!O36+AA9/yielddata!O37+AB9/yieldd ata!O38+AC9/yielddata!O39+AD9/yielddata!O40+AE9/yielddata!O41+AF9/yielddata!O42+AG9/yielddata!O43+ AH9/yielddata!O44
38 39 40 41
Gross revenue SUM(B14:AH14)
42 43
Arugula
44 45 46 47 48 49 50 51 52
Number of plantings: Number of harvests: Total row feet needed: Total amount of seed needed (oz., lbs) Row feet needed per planting Total Nitrogen per planting (lbs) Potassium (K2O) per planting (lbs) total value per crop
4 8 186.69 0.15 46.67 0.21 0.2 200
Beets 4 8 209.09 0.39 52.27 0.24 0.22 300
Broccoli 3 6 1132.56 0.94 377.52 2.17 2.38 1040
Cabbage 2 7 164.28 0.21 82.14 0.47 0.52 247.5
Cantaloupes Carrots CauliflowerCollards Cucumbers Edamame Eggplant Garlic Green onions Kale Kohlrabi 3 1 3 1 2 3 1 1 7 2 4 6 6 6 7 9 5 8 1 15 8 8 743.42 542.82 348.48 383.33 296.21 749.23 235.22 914.76 2003.76 116.16 435.6 0.62 0.9 0.19 1.92 1.48 3.75 0.05 182.95 1.43 0.29 0.54 247.81 542.82 116.16 383.33 148.1 249.74 235.22 914.76 286.25 58.08 108.9 2.28 2.08 0.67 2.64 2.04 0 3.24 5.25 1.1 0.4 0.42 3.13 2.28 0.73 2.42 1.87 0.43 2.97 3.85 1.2 0.37 0.46 960 810 520 330 340 430 270 350 1035 200 200
FieldProductionInfo
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
1 2 3 4 5
Snap beans
Southern peas
Spinach
Storage onions
Summer squash
Sweet corn
Swiss chard
Tomatoes
Turnips
Watermelons
15
Radishes
14
Potatoes
13
Peppers
12
Peas
11
Parsley
10
Pac choi
9
Okra
8
Mustard greens
7
Lettuce
6
4 8 1,756 0.55 439 1.68 1.85 $1,680
3 5 1,016 0.85 339 2.33 2.14 $700
1 8 1,437 14.37 1437 16.50 18.15 $2,640
3 6 1,347 0.56 449 3.09 2.84 $1,305
2 15 1,756 0.09 878 3.36 3.70 $2,150
1 5 2,759 41.38 2759 7.92 12.67 $1,900
1 7 1,272 0.19 1272 7.30 7.30 $1,460
1 1 1,484 247.72 1484 16.19 10.79 $1,850
5 9 2,788 8.36 558 2.13 2.35 $1,280
4 8 4,298 10.74 1074 3.08 4.93 $2,960
3 6 3,032 15.16 1011 0.00 1.74 $1,740
4 8 2,744 6.86 686 3.15 2.89 $3,360
1 1 986 4.93 986 3.77 4.15 $1,320
3 10 1,612 10.74 537 3.70 3.39 $1,850
5 10 17,582 6.59 3516 36.33 10.09 $4,900
2 15 2,396 3.95 1198 6.60 6.05 $3,300
1 7 636 1.59 636 8.76 7.30 $1,460
4 8 3,790 3.13 947 4.35 3.99 $1,160
3 6 5,088 11.19 1696 15.57 21.41 $3,960
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
Lettuce 4 8 585.45 0.18 146.36 0.56 0.62 560
Mustard greens Okra Pac choi Parsley Peas Peppers Potatoes Radishes Snap beansSouthern peas Spinach Storage onions Summer squash Sweet corn Swiss chard TomatoesTurnips Watermelons 3 1 3 2 1 1 1 5 4 3 4 1 3 5 2 1 4 3 5 8 6 15 5 7 1 9 8 6 8 1 10 10 15 7 8 6 159.72 381.15 201.34 281.78 638.88 574.99 609.84 446.49 1568.16 487.87 914.76 261.36 592.42 7223.04 375.71 287.5 588.06 2299.97 0.13 3.81 0.08 0.01 9.58 0.09 101.77 1.34 3.92 2.44 2.29 1.31 3.95 2.71 0.62 0.72 0.49 5.06 53.24 381.15 67.11 140.89 638.88 574.99 609.84 89.3 392.04 162.62 228.69 261.36 197.47 1444.61 187.85 287.5 147.02 766.66 0.37 4.38 0.46 0.54 1.83 3.3 6.65 0.34 1.13 0 1.05 1 1.36 14.92 1.04 3.96 0.68 7.04 0.34 4.81 0.42 0.59 2.93 3.3 4.43 0.38 1.8 0.28 0.96 1.1 1.25 4.15 0.95 3.3 0.62 9.68 110 700 195 345 440 660 760 205 1080 280 1120 350 680 2720 517.5 660 180 1280
FieldProductionInfo
AJ
A
B
C
D
E
F
G
H
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
Arugula Beets Broccoli Cabbage Cantaloupes Carrots Cauliflower Collards Cucumbers Edamame Eggplant Garlic Green onions Kale Kohlrabi Lettuce Mustard greens Okra Pac choi Parsley Peas Peppers Potatoes Radishes Snap beans Southern peas Spinach Storage onions Summer squash Sweet corn Swiss chard Tomatoes Turnips Watermelons
7,000 25,000 8,000 35,000 15,000 26,000 13,000 15,000 20,000 5,000 20,000 5,000 9,000 30,000 12,000 25,000 12,000 8,000 22,500 8,000 6,000 20,000 30,000 6,000 6,000 5,000 8,000 35,000 20,000 11,000 20,000 20,000 8,000 20,000
27 96 46 201 172 99 75 86 230 29 230 19 34 172 46 96 69 92 129 31 34 115 218 23 34 29 31 134 115 63 92 230 31 230
80 287 92 402 172 298 149 172 230 29 230 57 103 344 138 287 138 92 258 92 34 230 218 69 34 29 92 402 230 63 184 230 92 230
60 60 60 60 60 60 60 60 60 30 60 60 60 60 60 60 60 60 60 60 30 60 38 60 30 30 60 60 60 30 60 60 60 60
3 3 2 2 1 3 2 2 1 1 1 3 3 2 3 3 2 1 2 3 1 2 1 3 1 1 3 3 2 1 2 1 3 1
2 4 18 18 36 2 18 18 12 6 24 6 4 12 60 9 12 18 12 6 2 18 9 2 3 4 2 6 24 12 12 24 4 36
12 12 18 18 60 12 18 18 60 30 60 12 12 18 12 12 18 60 18 12 30 18 38 12 30 30 12 12 18 30 24 60 12 60
26,136 26,136 17,424 17,424 8,712 26,136 17,424 17,424 8,712 17,424 8,712 26,136 26,136 17,424 26,136 26,136 17,424 8,712 17,424 26,136 17,424 17,424 13,756 26,136 17,424 17,424 26,136 26,136 17,424 17,424 21,780 8,712 26,136 8,712
156,816 78,408 11,616 11,616 2,904 156,816 11,616 11,616 8,712 34,848 4,356 52,272 78,408 17,424 5,227 34,848 17,424 5,808 17,424 52,272 104,544 11,616 18,341 156,816 69,696 52,272 156,816 52,272 8,712 17,424 21,780 4,356 78,408 2,904
0.9 1.0 2.2 1.0 2.3 1.0 1.3 1.2 0.4 3.5 0.4 2.6 2.9 0.6 2.2 1.0 1.5 1.1 1.5 0.8 2.9 0.9 0.8 2.2 2.9 3.5 1.6 0.7 0.9 9.5 1.1 0.4 3.3 3.5
1,800 900 133 133 33 1,800 133 133 100 200 50 600 900 200 60 400 200 67 200 600 600 133 133 1,800 400 300 1,800 600 100 100 200 50 900 33
500 500 500 500 500 500 500 500 500 250 500 500 500 500 500 500 500 500 500 500 250 500 317 500 250 250 500 500 500 250 400 500 500 500
38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
Chart Notes: 1. These yield estimates are the low end of the yield ranges listed in the NCSU vegetable production guides http://www.ces.ncsu.edu/depts/hort/hil/veg-index.html with the exception of swiss chard, parsley, green onions, kale, pac choi, garlic and edamame. 2. Higher yields are possible under optimal growing conditions. The crop spacing presented below was used at the CEFS student farm in Goldsboro, NC in 2000 and 2001. 3. The seeding rates are from the 2003 Johnny's Selected Seeds catalog. 4. The N rates are at the high end of the crop specific ranges recommended by NCDA & CS.
56 57 58
S
area per 100' bed
14
R
plants per 100' bed
13
Q
row feet per unit
12
P
plants needed per acre
11
O
row feet per acre
9 10
N
btwn rows spacing (in)
bed spacing (in)
8
M
rows per bed
yield (lbs per 100' bed)
7
L
within row spacing (in)
yield (lbs per 100' row)
8 0.33 120 110 8 0.75 120 110 6 0.25 100 110 7 0.25 100 110 6 0.25 80 110 6 0.17 100 110 6 0.17 100 110 7 0.50 120 110 9 1.00 120 110 5 24.00 0 30 8 0.02 120 110 1 320.00 150 110 15 0.50 100 110 8 0.50 120 110 8 0.50 100 110 8 0.13 100 110 5 0.25 120 110 8 1.00 100 110 6 0.13 120 110 15 0.01 100 110 5 24.00 50 80 7 0.02 100 100 1 267.00 150 100 9 1.50 100 110 8 16.00 50 80 6 24.00 0 30 8 1.00 120 110 1 0.50 100 110 10 2.00 120 110 10 3.00 180 50 15 0.33 120 110 7 0.25 120 100 8 0.33 120 110 6 0.66 80 110
Produce
6
K
yield (lbs per acre)
4 4 3 2 3 1 3 1 2 3 1 1 7 2 4 4 3 1 3 2 1 1 1 5 4 3 4 1 3 5 2 1 4 3
K2O (lb per acre)
# of harvests
0.25 1 1 2 4 1 1 1 1 1 1 0.5 1 1 1 1 1 1 2 0.25 1 1 1.75 0.5 1 1 0.5 1 1 6 1 1 1 8
N (lbs per acre)
# of plantings
seed (oz.) per 100'
Produce unit (lbs)
3
5
J
T
U
V
IMPORTANT: Columns with Bold Italic RED text is a formula, all other columns can be changed.
2
4
I
Yield & Production Data Chart (Please see notes at bottom of chart)
1
5. The K2O rates are the NCDA & CS recommendations for soils with a K index of 50.
59 60 61 62 63 64 65 66
yielddata
yield (lbs per 100' row) H4/O4*100 yield (lbs per 100' bed) I4*L4 row feet per acre 43560*L4/(K4/12)
plants per acre O4*12/M4
row feet per unit B4/(H4/O4)
plants per 100' bed 100*L11*(12/M11)
area per 100' bed R11/P11*43560
W
X
B
2 3 4 5 6
C
D E
G
H
I
J
K
L
M
N
O
P
Q
1. The following table lists available crops and defines the size and price of produce units for the rest of the calculator spreadsheets. 2. These unit prices (with a few adjustments) were 2001 prices paid by CEFS student farm CSA members. 3. For convenience, all unit prices are multiples of $ 0.50
7
Crop
Unit size
Price / unit
8
Arugula
1 pint
$1.00
9
Beets
1 bunch (~ 1 lb)
$1.50
10
Broccoli
1 large head (~ 1 lb)
$2.00
11
Cabbage
1 head (~ 2 lbs)
$1.50
12
Cantaloupe
1 fruit (~ 4 lbs)
$3.00
13
Carrots
1 bunch (~ 8)
$1.50
14
Cauliflower
1 large head (~ 1 lb)
$2.00
15
Collards
1 bunch (~ 1 lb)
$1.00
16
Cucumbers
2 fruits (~ 1 lb)
$0.50
17
Edamame
1 quart bag
$2.00
18
Eggplant
1 medium fruit
$0.50
19
Garlic
3 bulbs
$1.00
20
Green onions
1 bunch (~ 1 lb)
$1.50
21
Kale
1 bag (~ 1 lb)
$1.00
22
Kohlrabi
1 qt bag
$1.00
23
Lettuce
1 head
$1.00
24
Mustard greens
1 quart
$1.00
25
Okra
1 quart
$2.00
26
Pac choi
1 head (~ 2 lbs)
$1.50
27
Parsley
1 bunch (~ 0.25 lbs)
$1.00
28
Peas
1 quart
$2.00
29
Peppers
2 fruits
$1.00
30
Potatoes
1 quart
$1.00
31
Radishes
1 bunch (~ 0.5 lbs)
$1.00
32
Snap beans
1 quart
$2.00
33
Southern peas
1 quart
$2.00
34
Spinach
1 quart
$2.00
35
Storage onions
3 bulbs (~ 1 lb)
$1.00
36
Summer squash
3 fruits (~ 1 lb)
$1.00
37
Sweet corn
1/2 dozen
$2.00
38
Swiss chard
1 bunch (~ 1 lb)
$1.50
39
Tomatoes
2 fruits
$1.00
40
Turnips
1 bunch (~ 1 lb)
$1.00
41
Watermelons
1 fruit (~ 8 lbs)
$4.00
42 43 44
F
Produce Units and Prices
1
**Flowers and trial crops will routinely be available for free** **Produce unit sizes may be downsized if insufficient produce is available**
produceunits
R
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
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
Produce calendar
1 2 3 4 5 6 7
1. 2. 3. 4.
This produce calendar was developed in 2001 for the CEFS student farm in Goldsboro, NC. It is possible to begin harvesting many spring crops before week 19 in Goldsboro, NC. Each farm should develop a harvest calendar that is appropriate for their production conditions and market opportunities, this is only one example. The recommended planting dates contained in "Commercial vegetable recommendations for the Southeast" are useful when developing a harvest calendar Website to find more information: http://ipm.ncsu.edu/vegetables/CommercialVegetables/
8 9
= Weeks when crops are PROJECTED TO BE AVAILABLE = Weeks when crops are *NOT* projected to be available.
10 11 12 13 14
5. The number of weeks each crop is projected to be available can be found at the bottom of each crop column. 6. The number of crops projected to be available each week can be found at the far right of each week row.
32
Peas
Mustard greens
Carrots
Collards
Cabbage
Potatoes
Sweet corn
Summer squash
Cucumbers
Storage onions
Garlic
Snap beans
Okra
Eggplant
Peppers
Tomatoes
Watermelons
Cantaloupes
Southern peas
Edamame
Number of crops
31
Pac choi
30
Cauliflower
29
Broccoli
28
Lettuce
27
Kohlrabi
26
Kale
25
Turnips
24
Beets
23
Arugula
22
Spinach
21
Radishes
20
Green onions
19
Parsley
18
Swiss chard
17
Monday date
16
week of the year
15
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1 1 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0
1 1 1 1 1 0 0 0 0 0 0 0 0 0 0
1 1 1 1 1 0 0 0 0 0 0 0 0 0 0
0 1 1 1 1 1 1 0 0 0 0 0 0 0 0
0 0 1 1 1 1 1 1 1 0 0 0 0 0 0
0 0 1 1 1 1 1 1 1 0 0 0 0 0 0
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1
0 0 0 0 0 0 1 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1
0 0 0 0 0 0 0 0 1 1 1 1 1 1 1
0 0 0 0 0 0 0 0 1 1 1 1 1 1 1
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1
0 0 0 0 0 0 0 0 0 0 1 1 1 1 1
16 17 19 19 19 19 17 21 16 16 17 17 17 17 17
Number of weeks: 15
15
15
9
8
8
8
8
8
8
8
6
6
6
5
5
6
7
7
10
10
10
9
8
8
8
8
8
7
7
6
6
6
5
producecalendar
A
B
C
D
E
F
G
H
1
Calendar for designing CSA "fullshare" composition
2
1. This calendar defines the target composition of a CSA "fullshare".
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
3
= weeks when crops are available
4
= weeks when crops are *NOT* projected to be available
5 6
5. This spreadsheet will automatically calculate totals for each item, each week and a grand total.
27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
Carrots
Collards
Cabbage
Potatoes
Sweet corn
Summer squash
Cucumbers
Storage onions
Garlic
Snap beans
Okra
Eggplant
Peppers
Tomatoes
Watermelons
Cantaloupes
Southern peas
Edamame
Week's total
26
Mustard greens
25
Peas
24
Pac choi
23
Cauliflower
22
Broccoli
21
Lettuce
20
Kohlrabi
19
Kale
18
Turnips
17
Beets
16
Arugula
15
Spinach
14
Radishes
13
Green onions
12
19 10-May 20 17-May 21 24-May 22 31-May 23 7-Jun 24 14-Jun 25 21-Jun 26 28-Jun 27 5-Jul 28 12-Jul 29 19-Jul 30 26-Jul 31 2-Aug 32 9-Aug 33 16-Aug Total units: Unit price: Total value:
Parsley
11
Swiss chard
9 10
Monday date
8
Week of the year
7
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15 $1.50 $22.50
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15 $1.00 $15.00
1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 15 $1.50 $22.50
1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 9 $1.00 $9.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $2.00 $16.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.50 $12.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 6 $2.00 $12.00
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 6 $2.00 $12.00
1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 6 $1.50 $9.00
1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 5 $2.00 $10.00
1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 5 $1.00 $5.00
0 1 1 1 1 1 1 0 0 0 0 0 0 0 0 6 $1.50 $9.00
0 0 1 1 1 1 1 1 1 0 0 0 0 0 0 7 $1.00 $7.00
0 0 1 1 1 1 1 1 1 0 0 0 0 0 0 7 $1.50 $10.50
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 10 $1.00 $10.00
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 10 $2.00 $20.00
0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 10 $1.00 $10.00
0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 9 $0.50 $4.50
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 $1.00 $8.00
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 $1.00 $8.00
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 $2.00 $16.00
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 $2.00 $16.00
0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 8 $0.50 $4.00
0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 7 $1.00 $7.00
0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 7 $1.00 $7.00
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 6 $4.00 $24.00
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 6 $3.00 $18.00
0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 6 $2.00 $12.00
0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 5 $2.00 $10.00
$22.00 $23.50 $26.00 $26.00 $26.00 $27.00 $22.00 $27.00 $20.50 $26.00 $28.00 $28.00 $28.00 $28.00 $28.00
Formulas: Week Total (See answer in column AJ, Row 12, ie. Swiss Chard): C6*C$22+D6*D$22+E6*E$22+F6*F$22+G6*G$22+H6*H$22+I6*I$22+J6*J$22+K6*K$22+L6*L$ 22+M6*M$22+N6*N$22+O6*O$22+P6*P$22+Q6*Q$22+R6*R$22+S6*S$22+T6*T$22+U6*U$22 +V6*V$22+W6*W$22+Y6*Y$22+Z6*Z$22+X6*X$22+AA6*AA$22+AB6*AB$22+AC6*AC$22+AD 6*AD$22+AE6*AE$22+AF6*AF$22+AG6*AG$22+AH6*AH$22+AI6*AI$22 Total Units per crop (ie. Swiss Chard): SUM(C12:C26) Unit Price (ie. Swiss Chard): produceunits!C37 Total Value (ie. Swiss Chard): C27*C28 Grand Total (See answer in column AJ, Row 29): SUM(C29:AI29)
CSAfullshare
Grand total
$386.00
AL
AM
AN
AO
A 1
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
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
Calendar for designing CSA "half share" composition
1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 5 $2.00 $10.00
0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 2 $1.00 $2.00
0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 3 $1.50 $4.50
0 0 1 0 1 0 1 0 1 0 0 0 0 0 0 4 $1.00 $4.00
0 0 0 1 0 1 0 1 0 0 0 0 0 0 0 3 $1.50 $4.50
0 0 0 1 0 1 0 1 0 1 0 1 0 5 $1.00 $5.00
22 23 24 25 26 27
CSAhalfshare
Week total
1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 3 $1.50 $4.50
Edamame
0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 3 $2.00 $6.00
Southern peas
1 0 1 0 1 0 0 0 0 0 0 0 0 0 0 3 $2.00 $6.00
Cantaloupes
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $1.00 $8.00
Watermelons
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $1.00 $0.00
Tomatoes
0 1 0 1 0 1 0 1 0 0 0 0 0 0 0 4 $1.00 $4.00
Bell peppers
0 1 0 1 0 1 0 1 0 0 0 0 0 0 0 4 $1.00 $4.00
Eggplant
1 0 1 0 1 0 1 0 0 0 0 0 0 0 0 4 $1.50 $6.00
Okra
1 0 1 0 1 0 1 0 0 0 0 0 0 0 0 4 $1.00 $4.00
Snap beans
1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 8 $2.00 $16.00
Garlic
Potatoes
0 1 0 1 0 1 0 1 0 0 0 0 0 0 0 4 $1.00 $4.00
Storage onions
Cabbage
1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 8 $1.50 $12.00
Cucumbers
Collards
0 1 0 1 0 1 0 1 0 1 0 1 0 1 0 7 $1.00 $7.00
Summer squash
Carrots
1 0 1 0 1 0 1 0 1 0 1 0 1 0 1 8 $1.50 $12.00
Sweet corn
Mustard greens
21
Peas
20
Pac choi
19
Cauliflower
18
Broccoli
17
Lettuce
16
Kohlrabi
15
Kale
14
Turnips
13
Beets
12
Arugula
9
11
Spinach
8
10
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug Total units: Unit price: Total value:
Radishes
7
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
Green onions
6
Parsley
5
Swiss chard
4
Monday date
3
Week of the year
2
0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 5 $2.00 $10.00
0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 5 $1.00 $5.00
0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 4 $0.50 $2.00
0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 4 $1.00 $4.00
0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 4 $1.00 $4.00
0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 4 $2.00 $8.00
0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 4 $2.00 $8.00
0 0 0 0 0 0 0 1 0 1 0 1 0 1 0 4 $0.50 $2.00
0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 4 $1.00 $4.00
0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 4 $1.00 $4.00
0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 3 $4.00 $12.00
0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 3 $3.00 $9.00
0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 3 $2.00 $6.00
0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 3 $2.00 $6.00
$14.00 $13.50 $15.00 $15.00 $15.00 $15.00 $10.50 $16.50 $9.00 $15.00 $13.00 $15.00 $13.00 $15.00 $13.00 Grand total $207.50
AL
AM
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
Potatoes
A 1
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
Calendar for market #1
10 10 10 10 10 10 0 0 0 0 0 0 0 0 0 60 $1.50 $90.00
20 20 20 20 20 0 0 0 0 0 0 0 0 0 0 100 $2.00 $200.00
10 10 10 10 10 0 0 0 0 0 0 0 0 0 0 50 $1.00 $50.00
0 40 40 40 40 40 40 0 0 0 0 0 0 0 0 240 $1.50 $360.00
0 0 20 20 20 20 20 20 20 0 0 0 0 0 0 140 $1.00 $140.00
0 0 10 10 10 10 10 10 10 0 0 0 0 0 0 70 $1.50 $105.00
Total value:
22 23 24 25 26 27
market1
30 30 30 30 30 30 30 30 30 30 300 $1.00 $300.00
Week total
20 20 20 20 20 20 0 0 0 0 0 0 0 0 0 120 $2.00 $240.00
Edamame
40 40 40 40 40 40 0 0 0 0 0 0 0 0 0 240 $2.00 $480.00
Southern peas
30 30 30 30 30 30 30 30 0 0 0 0 0 0 0 240 $1.00 $240.00
Cantaloupes
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 80 $1.00 $80.00
Watermelons
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 80 $1.00 $80.00
Tomatoes
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 80 $1.00 $80.00
Bell peppers
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 80 $1.50 $120.00
Eggplant
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0 80 $1.00 $80.00
Okra
30 30 30 30 30 30 30 30 0 0 0 0 0 0 0 240 $2.00 $480.00
Snap beans
10 10 10 10 10 10 10 10 10 0 0 0 0 0 0 90 $1.00 $90.00
Garlic
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 300 $1.50 $450.00
Storage onions
Cabbage
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 150 $1.00 $150.00
Cucumbers
Collards
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10 150 $1.50 $225.00
Summer squash
Carrots
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug Total units Unit price:
Sweet corn
Mustard greens
21
Peas
20
Pac choi
19
Cauliflower
18
Broccoli
17
Lettuce
16
Kohlrabi
15
Kale
14
Turnips
13
Beets
12
Arugula
9
11
Spinach
8
10
Radishes
7
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
Green onions
6
Parsley
5
Swiss chard
4
Friday date
3
Week of the year
2
0 0 0 0 0 60 60 60 60 60 60 60 60 60 60 600 $2.00 $1,200.00
0 0 0 0 0 30 30 30 30 30 30 30 30 30 30 300 $1.00 $300.00
0 0 0 0 0 0 30 30 30 30 30 30 30 30 30 270 $0.50 $135.00
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20 160 $1.00 $160.00
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20 160 $1.00 $160.00
0 0 0 0 0 0 0 30 30 30 30 30 30 30 30 240 $2.00 $480.00
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20 160 $2.00 $320.00
0 0 0 0 0 0 0 30 30 30 30 30 30 30 30 240 $0.50 $120.00
0 0 0 0 0 0 0 0 40 40 40 40 40 40 40 280 $1.00 $280.00
0 0 0 0 0 0 0 0 40 40 40 40 40 40 40 280 $1.00 $280.00
0 0 0 0 0 0 0 0 0 20 20 20 20 20 20 120 $4.00 $480.00
0 0 0 0 0 0 0 0 0 20 20 20 20 20 20 120 $3.00 $360.00
0 0 0 0 0 0 0 0 0 10 10 10 10 10 10 60 $2.00 $120.00
0 0 0 0 0 0 0 0 0 0 20 20 20 20 20 100 $2.00 $200.00
$395.00 $455.00 $490.00 $490.00 $490.00 $620.00 $500.00 $595.00 $530.00 $645.00 $685.00 $685.00 $685.00 $685.00 $685.00 Grand total $8,635.00
Q
R
S
T
U
V
W
X
0 0 0 0 0 60 60 60 60 60 60 60 60 60 60
0 0 0 0 0 30 30 30 30 30 30 30 30 30 30
Y
Z
AA
AB
AC
AD
0 0 0 0 0 0 30 30 30 30 30 30 30 30 30
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20
0 0 0 0 0 0 0 30 30 30 30 30 30 30 30
0 0 0 0 0 0 0 20 20 20 20 20 20 20 20
0 0 0 0 0 0 0 30 30 30 30 30 30 30 30
AF
AG
AH
Week total
P
Edamame
O
Southern peas
N
Cantaloupes
M
Watermelons
L
Tomatoes
K
Bell peppers
J
Eggplant
I
Okra
H
Snap beans
G
Garlic
F
Storage onions
E
Cucumbers
D
Summer squash
C
Sweet corn
B
Potatoes
A 1
AE
AI
AJ
AK
0 0 0 0 0 0 0 0 40 40 40 40 40 40 40
0 0 0 0 0 0 0 0 40 40 40 40 40 40 40
0 0 0 0 0 0 0 0 0 20 20 20 20 20 20
0 0 0 0 0 0 0 0 0 20 20 20 20 20 20
0 0 0 0 0 0 0 0 0 10 10 10 10 10 10
0 0 0 0 0 0 0 0 0 0 20 20 20 20 20
$395.00 $455.00 $490.00 $490.00 $490.00 $620.00 $500.00 $595.00 $530.00 $645.00 $685.00 $685.00 $685.00 $685.00 $685.00
Calendar for market #2
Cauliflower
Pac choi
Peas
Mustard greens
Carrots
Collards
Cabbage
18
Broccoli
17
Lettuce
16
Kohlrabi
15
Kale
14
Turnips
13
Beets
12
Arugula
9
11
Spinach
8
10
Radishes
7
Green onions
6
Parsley
5
Swiss chard
4
Monday date
3
Week of the year
2
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
10 10 10 10 10 10 10 10 10 10 10 10 10 10 10
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
10 10 10 10 10 10 10 10 10 0 0 0 0 0 0
30 30 30 30 30 30 30 30 0 0 0 0 0 0 0
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0
10 10 10 10 10 10 10 10 0 0 0 0 0 0 0
30 30 30 30 30 30 30 30 0 0 0 0 0 0 0
40 40 40 40 40 40 0 0 0 0 0 0 0 0 0
20 20 20 20 20 20 0 0 0 0 0 0 0 0 0
10 10 10 10 10 10 0 0 0 0 0 0 0 0 0
20 20 20 20 20 0 0 0 0 0 0 0 0 0 0
10 10 10 10 10 0 0 0 0 0 0 0 0 0 0
0 40 40 40 40 40 40 0 0 0 0 0 0 0 0
0 0 20 20 20 20 20 20 20 0 0 0 0 0 0
0 0 10 10 10 10 10 10 10 0 0 0 0 0 0
30 30 30 30 30 30 30 30 30 30
19
Total units:
150
150
300
90
240
80
80
80
80
80
240
240
120
60
100
50
240
140
70
300
600
300
270
160
160
240
160
240
280
280
120
120
60
100
20
Unit price: Total value:
$1.50 $225.00
$1.00 $150.00
$1.50 $450.00
$1.00 $90.00
$2.00 $480.00
$1.00 $80.00
$1.50 $120.00
$1.00 $80.00
$1.00 $80.00
$1.00 $80.00
$1.00 $240.00
$2.00 $480.00
$2.00 $240.00
$1.50 $90.00
$2.00 $200.00
$1.00 $50.00
$1.50 $360.00
$1.00 $140.00
$1.50 $105.00
$1.00 $300.00
$2.00 $1,200.00
$1.00 $300.00
$0.50 $135.00
$1.00 $160.00
$1.00 $160.00
$2.00 $480.00
$2.00 $320.00
$0.50 $120.00
$1.00 $280.00
$1.00 $280.00
$4.00 $480.00
$3.00 $360.00
$2.00 $120.00
$2.00 $200.00
21 22 23 24 25 26
market2
Grand total $8,635.00
AL
AM
A 1
B
C
D
This worksheet represents a CSA with:
2
E
F
100
G
"full shares"
H
I
J
50
and
K
L
M
N
O
P
Q
R
"half shares".
Modify the worksheets: CSAfullshare and CSAhalfshare to redefine the half and full share compositions.
3
CHANGE THE NUMBERS IN THE YELLOW BOXES to change the number of half and full share members represented by this worksheet.
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
Mustard greens
22
Peas
21
Pac choi
20
Cauliflower
19
Broccoli
18
Lettuce
17
Kohlrabi
16
Kale
15
Turnips
14
Beets
13
Arugula
12
Spinach
11
Radishes
9 10
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug Total units: Unit price: Total value:
Green onions
8
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
Parsley
7
Swiss chard
6
Monday date
5
Week of the year
4
150 100 150 100 150 100 150 100 150 100 150 100 150 100 150 1900 $1.50 $2,850.00
100 150 100 150 100 150 100 150 100 150 100 150 100 150 100 1850 $1.00 $1,850.00
150 100 150 100 150 100 150 100 150 100 150 100 150 100 150 1900 $1.50 $2,850.00
100 150 100 150 100 150 100 150 100 0 0 0 0 0 0 1100 $1.00 $1,100.00
150 150 150 150 150 150 150 150 0 0 0 0 0 0 0 1200 $2.00 $2,400.00
150 100 150 100 150 100 150 100 0 0 0 0 0 0 0 1000 $1.00 $1,000.00
150 100 150 100 150 100 150 100 0 0 0 0 0 0 0 1000 $1.50 $1,500.00
100 150 100 150 100 150 100 150 0 0 0 0 0 0 0 1000 $1.00 $1,000.00
100 150 100 150 100 150 100 150 0 0 0 0 0 0 0 1000 $1.00 $1,000.00
100 100 100 100 100 100 100 100 0 0 0 0 0 0 0 800 $1.00 $800.00
150 150 150 150 150 150 150 150 0 0 0 0 0 0 0 1200 $1.00 $1,200.00
150 100 150 100 150 100 0 0 0 0 0 0 0 0 0 750 $2.00 $1,500.00
100 150 100 150 100 150 0 0 0 0 0 0 0 0 0 750 $2.00 $1,500.00
150 100 150 100 150 100 0 0 0 0 0 0 0 0 0 750 $1.50 $1,125.00
150 150 150 150 150 0 0 0 0 0 0 0 0 0 0 750 $2.00 $1,500.00
100 150 100 150 100 0 0 0 0 0 0 0 0 0 0 600 $1.00 $600.00
Formulas: Week Total (See answer in column AK, Row 8) C6*C$22+D6*D$22+E6*E$22+F6*F$22+G6*G$22+H6*H$22+I6*I$22+J6*J$22+K6*K$22+L6*L$2 2+M6*M$22+N6*N$22+O6*O$22+P6*P$22+Q6*Q$22+R6*R$22+S6*S$22+T6*T$22+U6*U$22+V 6*V$22+W6*W$22+Y6*Y$22+Z6*Z$22+X6*X$22+AA6*AA$22+AB6*AB$22+AC6*AC$22+AD6*A D$22+AE6*AE$22+AF6*AF$22+AG6*AG$22+AH6*AH$22+AI6*AI$22+AJ6*AJ$22 Swiss Chard harvest total on wk19 : CSAfullshare!C9*$E$1 + CSAhalfshare!C4*$I$1 Total Units per crop (ie. Swiss Chard): SUM(C6:C20) Unit Price (ie. Swiss Chard): produceunits!C37 Total Value (ie. Swiss Chard): C21*C22 Grand Total (See answer in column AK, Row 23: SUM(AK6:AK20)
CSAtotals
S
T
U
V
W
X
Sweet corn
Summer squash
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
1 2 3
16 17 18 19 20 21 22 23
100 150 100 150 100 150 100 150 100 150 1250 $1.00 $1,250.00
Week total
15
150 100 150 100 150 100 150 100 150 100 1250 $2.00 $2,500.00
Edamame
14
150 100 150 100 150 100 150 100 150 100 1250 $1.00 $1,250.00
Southern peas
13
Cantaloupes
12
Watermelons
11
Tomatoes
100 150 100 150 100 150 100 0 0 0 0 0 0 850 $1.50 $1,275.00
Peppers
9 10
Eggplant
8
0 0 0 0 0
Okra
150 100 150 100 150 100 150 0 0 0 0 0 0 900 $1.00 $900.00
0 0 0 0 0
Snap beans
0 0
150 100 150 100 150 100 0 0 0 0 0 0 0 0 750 $1.50 $1,125.00
Garlic
Potatoes
0 0
7
Storage onions
Cabbage
0
6
Cucumbers
Collards
5
Carrots
4
0 0 0 0 0 0 100 150 100 150 100 150 100 150 100 1100 $0.50 $550.00
0 0 0 0 0 0 0 150 100 150 100 150 100 150 100 1000 $1.00 $1,000.00
0 0 0 0 0 0 0 150 100 150 100 150 100 150 100 1000 $1.00 $1,000.00
0 0 0 0 0 0 0 100 150 100 150 100 150 100 150 1000 $2.00 $2,000.00
0 0 0 0 0 0 0 150 100 150 100 150 100 150 100 1000 $2.00 $2,000.00
0 0 0 0 0 0 0 150 100 150 100 150 100 150 100 1000 $0.50 $500.00
0 0 0 0 0 0 0 0 150 100 150 100 150 100 150 900 $1.00 $900.00
0 0 0 0 0 0 0 0 150 100 150 100 150 100 150 900 $1.00 $900.00
0 0 0 0 0 0 0 0 0 150 100 150 100 150 100 750 $4.00 $3,000.00
0 0 0 0 0 0 0 0 0 100 150 100 150 100 150 750 $3.00 $2,250.00
0 0 0 0 0 0 0 0 0 150 100 150 100 150 100 750 $2.00 $1,500.00
0 0 0 0 0 0 0 0 0 0 150 100 150 100 150 650 $2.00 $1,300.00
$2,900.00 $3,025.00 $3,350.00 $3,350.00 $3,350.00 $3,450.00 $2,725.00 $3,525.00 $2,500.00 $3,350.00 $3,450.00 $3,550.00 $3,450.00 $3,550.00 $3,450.00
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
CSAtotals
Grand total $48,975.00
AL
A 1
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
AA
AB
AC
AD
AE
AF
AG
AH
AI
AJ
AK
Farm totals = CSAfullshares + CSAhalfshares + market1 + market 2 Mustard greens
Carrots
Collards
Cabbage
Potatoes
Sweet corn
Summer squash
Cucumbers
Storage onions
Garlic
Snap beans
Okra
Eggplant
Bell peppers
Tomatoes
Watermelons
Cantaloupes
Southern peas
Edamame
Week total
21
Peas
20
Pac choi
19
Cauliflower
18
Broccoli
17
Lettuce
16
Kohlrabi
15
Kale
14
Turnips
13
Beets
12
Arugula
9 11
10-May 17-May 24-May 31-May 7-Jun 14-Jun 21-Jun 28-Jun 5-Jul 12-Jul 19-Jul 26-Jul 2-Aug 9-Aug 16-Aug Total units: Unit price: Total value:
Spinach
8 10
19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
Radishes
7
Green onions
6
Parsley
5
Swiss chard
4
Monday date
3
Week of the year
2
170 120 170 120 170 120 170 120 170 120 170 120 170 120 170 2200 $1.50 $3,300.00
120 170 120 170 120 170 120 170 120 170 120 170 120 170 120 2150 $1.00 $2,150.00
190 140 190 140 190 140 190 140 190 140 190 140 190 140 190 2500 $1.50 $3,750.00
120 170 120 170 120 170 120 170 120 0 0 0 0 0 0 1280 $1.00 $1,280.00
210 210 210 210 210 210 210 210 0 0 0 0 0 0 0 1680 $2.00 $3,360.00
170 120 170 120 170 120 170 120 0 0 0 0 0 0 0 1160 $1.00 $1,160.00
170 120 170 120 170 120 170 120 0 0 0 0 0 0 0 1160 $1.50 $1,740.00
120 170 120 170 120 170 120 170 0 0 0 0 0 0 0 1160 $1.00 $1,160.00
120 170 120 170 120 170 120 170 0 0 0 0 0 0 0 1160 $1.00 $1,160.00
120 120 120 120 120 120 120 120 0 0 0 0 0 0 0 960 $1.00 $960.00
210 210 210 210 210 210 210 210 0 0 0 0 0 0 0 1680 $1.00 $1,680.00
230 180 230 180 230 180 0 0 0 0 0 0 0 0 0 1230 $2.00 $2,460.00
140 190 140 190 140 190 0 0 0 0 0 0 0 0 0 990 $2.00 $1,980.00
170 120 170 120 170 120 0 0 0 0 0 0 0 0 0 870 $1.50 $1,305.00
190 190 190 190 190 0 0 0 0 0 0 0 0 0 0 950 $2.00 $1,900.00
120 170 120 170 120 0 0 0 0 0 0 0 0 0 0 700 $1.00 $700.00
0 230 180 230 180 230 180 0 0 0 0 0 0 0 0 1230 $1.50 $1,845.00
0 0 190 140 190 140 190 140 190 0 0 0 0 0 0 1180 $1.00 $1,180.00
0 0 120 170 120 170 120 170 120 0 0 0 0 0 0 990 $1.50 $1,485.00
0 0 0 0 0 210 160 210 160 210 160 210 160 210 160 1850 $1.00 $1,850.00
0 0 0 0 0 270 220 270 220 270 220 270 220 270 220 2450 $2.00 $4,900.00
0 0 0 0 0 160 210 160 210 160 210 160 210 160 210 1850 $1.00 $1,850.00
0 0 0 0 0 0 160 210 160 210 160 210 160 210 160 1640 $0.50 $820.00
0 0 0 0 0 0 0 190 140 190 140 190 140 190 140 1320 $1.00 $1,320.00
0 0 0 0 0 0 0 190 140 190 140 190 140 190 140 1320 $1.00 $1,320.00
0 0 0 0 0 0 0 160 210 160 210 160 210 160 210 1480 $2.00 $2,960.00
0 0 0 0 0 0 0 190 140 190 140 190 140 190 140 1320 $2.00 $2,640.00
0 0 0 0 0 0 0 210 160 210 160 210 160 210 160 1480 $0.50 $740.00
0 0 0 0 0 0 0 0 230 180 230 180 230 180 230 1460 $1.00 $1,460.00
0 0 0 0 0 0 0 0 230 180 230 180 230 180 230 1460 $1.00 $1,460.00
0 0 0 0 0 0 0 0 0 190 140 190 140 190 140 990 $4.00 $3,960.00
0 0 0 0 0 0 0 0 0 140 190 140 190 140 190 990 $3.00 $2,970.00
0 0 0 0 0 0 0 0 0 170 120 170 120 170 120 870 $2.00 $1,740.00
0 0 0 0 0 0 0 0 0 0 190 140 190 140 190 850 $2.00 $1,700.00
$3,690.00 $3,935.00 $4,330.00 $4,330.00 $4,330.00 $4,690.00 $3,725.00 $4,715.00 $3,560.00 $4,640.00 $4,820.00 $4,920.00 $4,820.00 $4,920.00 $4,820.00
farmtotals
Grand total $66,245.00
A 1
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Field Production Information
2 3 4 5
The following table summarizes field production information related to total farm sale goals The current version of this spreadsheet distributes total yield estimates for multiple harvest crops evenly across the harvest season. This is not realistic and should be accounted for in a future version of the spreadsheet.
Edamame
Eggplant
Garlic
Green onions
Kale
Kohlrabi
15
Cucumbers
14
Collards
13
Cauliflower
12
Carrots
11
Cantaloupes
10
Number of plantings: Number of harvests: Total row feet needed: Total amount of seed needed (oz., lbs) Row feet needed per planting Total Nitrogen per planting (lbs) Potassium (K2O) per planting (lbs) total value per crop
Cabbage
9
Broccoli
8
Beets
7
Arugula
6
4 8 1,083 0.89 271 1.24 1.14 $1,160
4 8 1,213 2.27 303 1.39 1.28 $1,740
3 6 2,679 2.23 893 5.13 5.64 $2,460
2 7 986 1.23 493 2.83 3.11 $1,485
3 6 2,300 1.92 767 7.04 9.68 $2,970
1 6 1,236 2.05 1236 4.73 5.20 $1,845
3 6 1,327 0.73 442 2.54 2.79 $1,980
1 7 1,371 6.85 1371 9.44 8.65 $1,180
2 9 714 3.57 357 4.92 4.51 $820
3 5 2,962 14.81 987 0.00 1.70 $1,700
1 8 645 0.13 645 8.88 8.14 $740
1 1 3,450 689.99 3450 19.80 14.52 $1,320
7 15 7,260 5.19 1037 3.97 4.37 $3,750
2 8 674 1.68 337 2.32 2.13 $1,160
4 8 2,091 2.61 523 2.00 2.20 $960
16 17
Total Acreage
18
5.08
acres
19
Gross revenue
20
$66,245
21 22 23 24 25 26 27 28 29 30 31
Calculations: Number of plantings: yielddata!$C12 Number of harvests: yielddata!$D12 Total row feet needed: onesizefitsall!H21*yielddata!$Q12 Total amount of seed needed (oz., lbs) yielddata!$E12*B11/100 row ft per planting B9/B7 N per planting (lbs) yielddata!$F12*(B11/yielddata!$O12) K2O per planting (lbs) yielddata!$G12*(B11/yielddata!$O12) total value per croponesizefitsall!H23
32 33
Total Acreage
34 35 36 37
Total Acreage Calculation B9/yielddata!O12+C9/yielddata!O13+D9/yielddata!O14+E9/yielddata!O15+F9/yielddata!O16+G9/yielddata!O17+H9/yielddata !O18+I9/yielddata!O19+J9/yielddata!O20+K9/yielddata!O21+L9/yielddata!O22+M9/yielddata!O23+N9/yielddata!O24+O9/yiel ddata!O25+P9/yielddata!O26+Q9/yielddata!O27+R9/yielddata!O28+S9/yielddata!O29+T9/yielddata!O30+U9/yielddata!O31+ V9/yielddata!O32+W9/yielddata!O33+X9/yielddata!O34+Y9/yielddata!O35+Z9/yielddata!O36+AA9/yielddata!O37+AB9/yieldd ata!O38+AC9/yielddata!O39+AD9/yielddata!O40+AE9/yielddata!O41+AF9/yielddata!O42+AG9/yielddata!O43+ AH9/yielddata!O44
38 39 40 41
Gross revenue SUM(B14:AH14)
42 43
Arugula
44 45 46 47 48 49 50 51 52
Number of plantings: Number of harvests: Total row feet needed: Total amount of seed needed (oz., lbs) Row feet needed per planting Total Nitrogen per planting (lbs) Potassium (K2O) per planting (lbs) total value per crop
4 8 186.69 0.15 46.67 0.21 0.2 200
Beets 4 8 209.09 0.39 52.27 0.24 0.22 300
Broccoli 3 6 1132.56 0.94 377.52 2.17 2.38 1040
Cabbage 2 7 164.28 0.21 82.14 0.47 0.52 247.5
Cantaloupes Carrots CauliflowerCollards Cucumbers Edamame Eggplant Garlic Green onions Kale Kohlrabi 3 1 3 1 2 3 1 1 7 2 4 6 6 6 7 9 5 8 1 15 8 8 743.42 542.82 348.48 383.33 296.21 749.23 235.22 914.76 2003.76 116.16 435.6 0.62 0.9 0.19 1.92 1.48 3.75 0.05 182.95 1.43 0.29 0.54 247.81 542.82 116.16 383.33 148.1 249.74 235.22 914.76 286.25 58.08 108.9 2.28 2.08 0.67 2.64 2.04 0 3.24 5.25 1.1 0.4 0.42 3.13 2.28 0.73 2.42 1.87 0.43 2.97 3.85 1.2 0.37 0.46 960 810 520 330 340 430 270 350 1035 200 200
FieldProductionInfo
Q
R
S
T
U
V
W
X
Y
Z
AA
AB
AC
AD
AE
AF
AG
AH
AI
1 2 3 4 5
Snap beans
Southern peas
Spinach
Storage onions
Summer squash
Sweet corn
Swiss chard
Tomatoes
Turnips
Watermelons
15
Radishes
14
Potatoes
13
Peppers
12
Peas
11
Parsley
10
Pac choi
9
Okra
8
Mustard greens
7
Lettuce
6
4 8 1,756 0.55 439 1.68 1.85 $1,680
3 5 1,016 0.85 339 2.33 2.14 $700
1 8 1,437 14.37 1437 16.50 18.15 $2,640
3 6 1,347 0.56 449 3.09 2.84 $1,305
2 15 1,756 0.09 878 3.36 3.70 $2,150
1 5 2,759 41.38 2759 7.92 12.67 $1,900
1 7 1,272 0.19 1272 7.30 7.30 $1,460
1 1 1,484 247.72 1484 16.19 10.79 $1,850
5 9 2,788 8.36 558 2.13 2.35 $1,280
4 8 4,298 10.74 1074 3.08 4.93 $2,960
3 6 3,032 15.16 1011 0.00 1.74 $1,740
4 8 2,744 6.86 686 3.15 2.89 $3,360
1 1 986 4.93 986 3.77 4.15 $1,320
3 10 1,612 10.74 537 3.70 3.39 $1,850
5 10 17,582 6.59 3516 36.33 10.09 $4,900
2 15 2,396 3.95 1198 6.60 6.05 $3,300
1 7 636 1.59 636 8.76 7.30 $1,460
4 8 3,790 3.13 947 4.35 3.99 $1,160
3 6 5,088 11.19 1696 15.57 21.41 $3,960
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
Lettuce 4 8 585.45 0.18 146.36 0.56 0.62 560
Mustard greens Okra Pac choi Parsley Peas Peppers Potatoes Radishes Snap beansSouthern peas Spinach Storage onions Summer squash Sweet corn Swiss chard TomatoesTurnips Watermelons 3 1 3 2 1 1 1 5 4 3 4 1 3 5 2 1 4 3 5 8 6 15 5 7 1 9 8 6 8 1 10 10 15 7 8 6 159.72 381.15 201.34 281.78 638.88 574.99 609.84 446.49 1568.16 487.87 914.76 261.36 592.42 7223.04 375.71 287.5 588.06 2299.97 0.13 3.81 0.08 0.01 9.58 0.09 101.77 1.34 3.92 2.44 2.29 1.31 3.95 2.71 0.62 0.72 0.49 5.06 53.24 381.15 67.11 140.89 638.88 574.99 609.84 89.3 392.04 162.62 228.69 261.36 197.47 1444.61 187.85 287.5 147.02 766.66 0.37 4.38 0.46 0.54 1.83 3.3 6.65 0.34 1.13 0 1.05 1 1.36 14.92 1.04 3.96 0.68 7.04 0.34 4.81 0.42 0.59 2.93 3.3 4.43 0.38 1.8 0.28 0.96 1.1 1.25 4.15 0.95 3.3 0.62 9.68 110 700 195 345 440 660 760 205 1080 280 1120 350 680 2720 517.5 660 180 1280
FieldProductionInfo
AJ
A
B
C
D
E
F
G
H
15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
Arugula Beets Broccoli Cabbage Cantaloupes Carrots Cauliflower Collards Cucumbers Edamame Eggplant Garlic Green onions Kale Kohlrabi Lettuce Mustard greens Okra Pac choi Parsley Peas Peppers Potatoes Radishes Snap beans Southern peas Spinach Storage onions Summer squash Sweet corn Swiss chard Tomatoes Turnips Watermelons
7,000 25,000 8,000 35,000 15,000 26,000 13,000 15,000 20,000 5,000 20,000 5,000 9,000 30,000 12,000 25,000 12,000 8,000 22,500 8,000 6,000 20,000 30,000 6,000 6,000 5,000 8,000 35,000 20,000 11,000 20,000 20,000 8,000 20,000
27 96 46 201 172 99 75 86 230 29 230 19 34 172 46 96 69 92 129 31 34 115 218 23 34 29 31 134 115 63 92 230 31 230
80 287 92 402 172 298 149 172 230 29 230 57 103 344 138 287 138 92 258 92 34 230 218 69 34 29 92 402 230 63 184 230 92 230
60 60 60 60 60 60 60 60 60 30 60 60 60 60 60 60 60 60 60 60 30 60 38 60 30 30 60 60 60 30 60 60 60 60
3 3 2 2 1 3 2 2 1 1 1 3 3 2 3 3 2 1 2 3 1 2 1 3 1 1 3 3 2 1 2 1 3 1
2 4 18 18 36 2 18 18 12 6 24 6 4 12 60 9 12 18 12 6 2 18 9 2 3 4 2 6 24 12 12 24 4 36
12 12 18 18 60 12 18 18 60 30 60 12 12 18 12 12 18 60 18 12 30 18 38 12 30 30 12 12 18 30 24 60 12 60
26,136 26,136 17,424 17,424 8,712 26,136 17,424 17,424 8,712 17,424 8,712 26,136 26,136 17,424 26,136 26,136 17,424 8,712 17,424 26,136 17,424 17,424 13,756 26,136 17,424 17,424 26,136 26,136 17,424 17,424 21,780 8,712 26,136 8,712
156,816 78,408 11,616 11,616 2,904 156,816 11,616 11,616 8,712 34,848 4,356 52,272 78,408 17,424 5,227 34,848 17,424 5,808 17,424 52,272 104,544 11,616 18,341 156,816 69,696 52,272 156,816 52,272 8,712 17,424 21,780 4,356 78,408 2,904
0.9 1.0 2.2 1.0 2.3 1.0 1.3 1.2 0.4 3.5 0.4 2.6 2.9 0.6 2.2 1.0 1.5 1.1 1.5 0.8 2.9 0.9 0.8 2.2 2.9 3.5 1.6 0.7 0.9 9.5 1.1 0.4 3.3 3.5
1,800 900 133 133 33 1,800 133 133 100 200 50 600 900 200 60 400 200 67 200 600 600 133 133 1,800 400 300 1,800 600 100 100 200 50 900 33
500 500 500 500 500 500 500 500 500 250 500 500 500 500 500 500 500 500 500 500 250 500 317 500 250 250 500 500 500 250 400 500 500 500
38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55
Chart Notes: 1. These yield estimates are the low end of the yield ranges listed in the NCSU vegetable production guides http://www.ces.ncsu.edu/depts/hort/hil/veg-index.html with the exception of swiss chard, parsley, green onions, kale, pac choi, garlic and edamame. 2. Higher yields are possible under optimal growing conditions. The crop spacing presented below was used at the CEFS student farm in Goldsboro, NC in 2000 and 2001. 3. The seeding rates are from the 2003 Johnny's Selected Seeds catalog. 4. The N rates are at the high end of the crop specific ranges recommended by NCDA & CS.
56 57 58
S
area per 100' bed
14
R
plants per 100' bed
13
Q
row feet per unit
12
P
plants needed per acre
11
O
row feet per acre
9 10
N
btwn rows spacing (in)
bed spacing (in)
8
M
rows per bed
yield (lbs per 100' bed)
7
L
within row spacing (in)
yield (lbs per 100' row)
8 0.33 120 110 8 0.75 120 110 6 0.25 100 110 7 0.25 100 110 6 0.25 80 110 6 0.17 100 110 6 0.17 100 110 7 0.50 120 110 9 1.00 120 110 5 24.00 0 30 8 0.02 120 110 1 320.00 150 110 15 0.50 100 110 8 0.50 120 110 8 0.50 100 110 8 0.13 100 110 5 0.25 120 110 8 1.00 100 110 6 0.13 120 110 15 0.01 100 110 5 24.00 50 80 7 0.02 100 100 1 267.00 150 100 9 1.50 100 110 8 16.00 50 80 6 24.00 0 30 8 1.00 120 110 1 0.50 100 110 10 2.00 120 110 10 3.00 180 50 15 0.33 120 110 7 0.25 120 100 8 0.33 120 110 6 0.66 80 110
Produce
6
K
yield (lbs per acre)
4 4 3 2 3 1 3 1 2 3 1 1 7 2 4 4 3 1 3 2 1 1 1 5 4 3 4 1 3 5 2 1 4 3
K2O (lb per acre)
# of harvests
0.25 1 1 2 4 1 1 1 1 1 1 0.5 1 1 1 1 1 1 2 0.25 1 1 1.75 0.5 1 1 0.5 1 1 6 1 1 1 8
N (lbs per acre)
# of plantings
seed (oz.) per 100'
Produce unit (lbs)
3
5
J
T
U
V
IMPORTANT: Columns with Bold Italic RED text is a formula, all other columns can be changed.
2
4
I
Yield & Production Data Chart (Please see notes at bottom of chart)
1
5. The K2O rates are the NCDA & CS recommendations for soils with a K index of 50.
59 60 61 62 63 64 65 66
yielddata
yield (lbs per 100' row) H4/O4*100 yield (lbs per 100' bed) I4*L4 row feet per acre 43560*L4/(K4/12)
plants per acre O4*12/M4
row feet per unit B4/(H4/O4)
plants per 100' bed 100*L11*(12/M11)
area per 100' bed R11/P11*43560
W
X
Related Documents
Csa Planning Part 1
June 2020 3
Csa Planning Part 2
June 2020 8
Blank Csa Planning Template Tables
June 2020 5
Csa
June 2020 19
Csa
July 2020 18
Csa-q_bank-sohrt (1)
May 2020 3More Documents from ""
The Community Land Trust
June 2020 12
4.3 Csa Outreach
June 2020 10
Csa Setting Up Organic Buying Group
June 2020 7
4.4 Csa Administration
June 2020 8
Csa Planning Part 1
June 2020 3