Get documents about "produceunits
Shared by: f2gfdPJ4
-
Stats
- views:
- 8
- posted:
- 11/24/2011
- language:
- English
- pages:
- 12
Document Sample
A B C E F G H I J K L M N O P Q R
1 Produce Units and Prices
2
3 1. The following table lists available crops and defines the size and price of produce units for the rest of the calculator spreadsheets.
4 2. These unit prices (with a few adjustments) were 2001 prices paid by CEFS student farm CSA members.
5 3. For convenience, all unit prices are multiples of $ 0.50
6
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 **Flowers and trial crops will routinely be available for free**
44 **Produce unit sizes may be downsized if insufficient produce is available**
produceunits
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
1 Produce calendar
2
3 1. This produce calendar was developed in 2001 for the CEFS student farm in Goldsboro, NC.
4 2. It is possible to begin harvesting many spring crops before week 19 in Goldsboro, NC.
5 3. Each farm should develop a harvest calendar that is appropriate for their production conditions and market opportunities, this is only one example.
6 4. The recommended planting dates contained in "Commercial vegetable recommendations for the Southeast" are useful when developing a harvest calendar
7 Website to find more information: http://ipm.ncsu.edu/vegetables/CommercialVegetables/
8
9
10 = Weeks when crops are PROJECTED TO BE AVAILABLE
11 = Weeks when crops are *NOT* projected to be available.
12
13 5. The number of weeks each crop is projected to be available can be found at the bottom of each crop column.
14 6. The number of crops projected to be available each week can be found at the far right of each week row.
15
Number of crops
week of the year
Summer squash
Mustard greens
Storage onions
Southern peas
Green onions
Watermelons
Monday date
Cantaloupes
Swiss chard
Snap beans
Cucumbers
Cauliflower
Sweet corn
Tomatoes
Edamame
Radishes
Eggplant
Cabbage
Potatoes
Pac choi
Kohlrabi
Collards
Broccoli
Peppers
Spinach
Arugula
Turnips
Parsley
Lettuce
Carrots
Garlic
Beets
Peas
Okra
Kale
16
17 19 10-May 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16
18 20 17-May 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17
19 21 24-May 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 0 0 0 0 0 0 0 0 0 19
20 22 31-May 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 0 0 0 0 0 0 0 0 0 19
21 23 7-Jun 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 0 0 0 0 0 0 0 0 0 19
22 24 14-Jun 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 19
23 25 21-Jun 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 17
24 26 28-Jun 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 1 1 1 0 0 0 0 0 0 21
25 27 5-Jul 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 16
26 28 12-Jul 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 16
27 29 19-Jul 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 17
28 30 26-Jul 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 17
29 31 2-Aug 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 17
30 32 9-Aug 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 17
31 33 16-Aug 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 17
32
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 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
1 Calendar for designing CSA "fullshare" composition
2 1. This calendar defines the target composition of a CSA "fullshare".
3
4 = weeks when crops are available = 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.
7
Week of the year
Summer squash
Mustard greens
Storage onions
Southern peas
Green onions
Watermelons
Monday date
Cantaloupes
Swiss chard
Snap beans
Cucumbers
Cauliflower
Sweet corn
Week's total
Tomatoes
Edamame
Radishes
Eggplant
Potatoes
Cabbage
Pac choi
Kohlrabi
Broccoli
Collards
Peppers
Spinach
Arugula
Turnips
Parsley
Lettuce
Carrots
Garlic
Beets
Peas
Okra
Kale
8
9 19 10-May 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $22.00
10 20 17-May 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $23.50
11 21 24-May 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 0 0 0 0 0 0 0 0 0 $26.00
12 22 31-May 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 0 0 0 0 0 0 0 0 0 $26.00
13 23 7-Jun 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 0 0 0 0 0 0 0 0 0 $26.00
14 24 14-Jun 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 $27.00
15 25 21-Jun 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 0 1 1 1 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 $22.00
16 26 28-Jun 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 1 1 1 0 0 0 0 0 0 $27.00
17 27 5-Jul 1 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 0 0 $20.50
18 28 12-Jul 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 $26.00
19 29 19-Jul 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 $28.00
20 30 26-Jul 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 $28.00
21 31 2-Aug 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 $28.00
22 32 9-Aug 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 $28.00
23 33 16-Aug 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 $28.00
24 Total units: 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
25 Unit price: $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $1.50 $1.00 $1.00 $1.00 $1.00 $2.00 $2.00 $1.50 $2.00 $1.00 $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $0.50 $1.00 $1.00 $2.00 $2.00 $0.50 $1.00 $1.00 $4.00 $3.00 $2.00 $2.00 Grand total
26 Total value: $22.50 $15.00 $22.50 $9.00 $16.00 $8.00 $12.00 $8.00 $8.00 $8.00 $8.00 $12.00 $12.00 $9.00 $10.00 $5.00 $9.00 $7.00 $10.50 $10.00 $20.00 $10.00 $4.50 $8.00 $8.00 $16.00 $16.00 $4.00 $7.00 $7.00 $24.00 $18.00 $12.00 $10.00 $386.00
27
CSAfullshare
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
1 Calendar for designing CSA "half share" composition
2
Week of the year
Summer squash
Mustard greens
Storage onions
Southern peas
Green onions
Watermelons
Monday date
Bell peppers
Cantaloupes
Swiss chard
Snap beans
Cucumbers
Sweet corn
Cauliflower
Week total
Edamame
Tomatoes
Radishes
Eggplant
Cabbage
Potatoes
Pac choi
Kohlrabi
Broccoli
Collards
Spinach
Arugula
Parsley
Turnips
Carrots
Lettuce
Beets
Garlic
Peas
Okra
Kale
3
4 19 10-May 1 0 1 0 1 1 1 0 0 0 1 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $14.00
5 20 17-May 0 1 0 1 1 0 0 1 1 0 1 0 1 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $13.50
6 21 24-May 1 0 1 0 1 1 1 0 0 0 1 1 0 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $15.00
7 22 31-May 0 1 0 1 1 0 0 1 1 0 1 0 1 0 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $15.00
8 23 7-Jun 1 0 1 0 1 1 1 0 0 0 1 1 0 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $15.00
9 24 14-Jun 0 1 0 1 1 0 0 1 1 0 1 0 1 0 0 0 1 0 1 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 $15.00
10 25 21-Jun 1 0 1 0 1 1 1 0 0 0 1 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 $10.50
11 26 28-Jun 0 1 0 1 1 0 0 1 1 0 1 0 0 0 0 0 0 0 1 1 1 0 1 1 1 0 1 1 0 0 0 0 0 0 $16.50
12 27 5-Jul 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 1 0 0 1 1 0 0 0 0 $9.00
13 28 12-Jul 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 1 0 1 1 0 0 1 0 1 0 $15.00
14 29 19-Jul 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 1 0 1 0 1 $13.00
15 30 26-Jul 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 1 0 1 1 0 0 1 0 1 0 $15.00
16 31 2-Aug 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 1 0 1 0 1 $13.00
17 32 9-Aug 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 1 1 1 0 1 1 0 0 1 0 1 0 $15.00
18 33 16-Aug 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 1 1 0 1 0 1 $13.00
19 Total units: 8 7 8 4 8 4 4 4 4 0 8 3 3 3 5 2 3 4 3 5 5 5 4 4 4 4 4 4 4 4 3 3 3 3
20 Unit price: $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $1.50 $1.00 $1.00 $1.00 $1.00 $2.00 $2.00 $1.50 $2.00 $1.00 $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $0.50 $1.00 $1.00 $2.00 $2.00 $0.50 $1.00 $1.00 $4.00 $3.00 $2.00 $2.00 Grand total
21 Total value: $12.00 $7.00 $12.00 $4.00 $16.00 $4.00 $6.00 $4.00 $4.00 $0.00 $8.00 $6.00 $6.00 $4.50 $10.00 $2.00 $4.50 $4.00 $4.50 $5.00 $10.00 $5.00 $2.00 $4.00 $4.00 $8.00 $8.00 $2.00 $4.00 $4.00 $12.00 $9.00 $6.00 $6.00 $207.50
22
23
24
25
26
27
28
29
30
31
32
33
34
35
CSAhalfshare
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
1 Calendar for market #1
2
Week of the year
Summer squash
Mustard greens
Storage onions
Southern peas
Green onions
Watermelons
Cantaloupes
Bell peppers
Swiss chard
Snap beans
Cucumbers
Friday date
Sweet corn
Cauliflower
Week total
Tomatoes
Edamame
Radishes
Eggplant
Cabbage
Potatoes
Pac choi
Kohlrabi
Broccoli
Collards
Spinach
Arugula
Turnips
Lettuce
Parsley
Carrots
Beets
Garlic
Peas
Okra
Kale
3
4 19 10-May 10 10 20 10 30 10 10 10 10 10 30 40 20 10 20 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $395.00
5 20 17-May 10 10 20 10 30 10 10 10 10 10 30 40 20 10 20 10 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $455.00
6 21 24-May 10 10 20 10 30 10 10 10 10 10 30 40 20 10 20 10 40 20 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $490.00
7 22 31-May 10 10 20 10 30 10 10 10 10 10 30 40 20 10 20 10 40 20 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $490.00
8 23 7-Jun 10 10 20 10 30 10 10 10 10 10 30 40 20 10 20 10 40 20 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $490.00
9 24 14-Jun 10 10 20 10 30 10 10 10 10 10 30 40 20 10 0 0 40 20 10 30 60 30 0 0 0 0 0 0 0 0 0 0 0 0 $620.00
10 25 21-Jun 10 10 20 10 30 10 10 10 10 10 30 0 0 0 0 0 40 20 10 30 60 30 30 0 0 0 0 0 0 0 0 0 0 0 $500.00
11 26 28-Jun 10 10 20 10 30 10 10 10 10 10 30 0 0 0 0 0 0 20 10 30 60 30 30 20 20 30 20 30 0 0 0 0 0 0 $595.00
12 27 5-Jul 10 10 20 10 0 0 0 0 0 0 0 0 0 0 0 0 0 20 10 30 60 30 30 20 20 30 20 30 40 40 0 0 0 0 $530.00
13 28 12-Jul 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 0 $645.00
14 29 19-Jul 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 20 $685.00
15 30 26-Jul 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 20 $685.00
16 31 2-Aug 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 20 $685.00
17 32 9-Aug 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 20 $685.00
18 33 16-Aug 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 20 $685.00
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: $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $1.50 $1.00 $1.00 $1.00 $1.00 $2.00 $2.00 $1.50 $2.00 $1.00 $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $0.50 $1.00 $1.00 $2.00 $2.00 $0.50 $1.00 $1.00 $4.00 $3.00 $2.00 $2.00 Grand total
21 Total value: $225.00 $150.00 $450.00 $90.00 $480.00 $80.00 $120.00 $80.00 $80.00 $80.00 $240.00 $480.00 $240.00 $90.00 $200.00 $50.00 $360.00 $140.00 $105.00 $300.00 $1,200.00 $300.00 $135.00 $160.00 $160.00 $480.00 $320.00 $120.00 $280.00 $280.00 $480.00 $360.00 $120.00 $200.00 $8,635.00
22
23
24
25
26
27
market1
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 AL AM
1 Calendar for market #2
2
Week of the year
Summer squash
Mustard greens
Storage onions
Southern peas
Green onions
Watermelons
Monday date
Bell peppers
Cantaloupes
Swiss chard
Snap beans
Cucumbers
Cauliflower
Sweet corn
Week total
Tomatoes
Edamame
Radishes
Eggplant
Cabbage
Potatoes
Pac choi
Broccoli
Kohlrabi
Collards
Spinach
Arugula
Turnips
Lettuce
Carrots
Parsley
Garlic
Beets
Peas
Okra
Kale
3
4 19 10-May 10 10 20 10 30 10 10 10 10 10 30 40 20 10 20 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $395.00
5 20 17-May 10 10 20 10 30 10 10 10 10 10 30 40 20 10 20 10 40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $455.00
6 21 24-May 10 10 20 10 30 10 10 10 10 10 30 40 20 10 20 10 40 20 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $490.00
7 22 31-May 10 10 20 10 30 10 10 10 10 10 30 40 20 10 20 10 40 20 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $490.00
8 23 7-Jun 10 10 20 10 30 10 10 10 10 10 30 40 20 10 20 10 40 20 10 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $490.00
9 24 14-Jun 10 10 20 10 30 10 10 10 10 10 30 40 20 10 0 0 40 20 10 30 60 30 0 0 0 0 0 0 0 0 0 0 0 0 $620.00
10 25 21-Jun 10 10 20 10 30 10 10 10 10 10 30 0 0 0 0 0 40 20 10 30 60 30 30 0 0 0 0 0 0 0 0 0 0 0 $500.00
11 26 28-Jun 10 10 20 10 30 10 10 10 10 10 30 0 0 0 0 0 0 20 10 30 60 30 30 20 20 30 20 30 0 0 0 0 0 0 $595.00
12 27 5-Jul 10 10 20 10 0 0 0 0 0 0 0 0 0 0 0 0 0 20 10 30 60 30 30 20 20 30 20 30 40 40 0 0 0 0 $530.00
13 28 12-Jul 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 0 $645.00
14 29 19-Jul 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 20 $685.00
15 30 26-Jul 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 20 $685.00
16 31 2-Aug 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 20 $685.00
17 32 9-Aug 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 20 $685.00
18 33 16-Aug 10 10 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 30 60 30 30 20 20 30 20 30 40 40 20 20 10 20 $685.00
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: $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $1.50 $1.00 $1.00 $1.00 $1.00 $2.00 $2.00 $1.50 $2.00 $1.00 $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $0.50 $1.00 $1.00 $2.00 $2.00 $0.50 $1.00 $1.00 $4.00 $3.00 $2.00 $2.00 Grand total
21 Total value: $225.00 $150.00 $450.00 $90.00 $480.00 $80.00 $120.00 $80.00 $80.00 $80.00 $240.00 $480.00 $240.00 $90.00 $200.00 $50.00 $360.00 $140.00 $105.00 $300.00 $1,200.00 $300.00 $135.00 $160.00 $160.00 $480.00 $320.00 $120.00 $280.00 $280.00 $480.00 $360.00 $120.00 $200.00 $8,635.00
22
23
24
25
26
market2
A B C D E F G H I J K L M N O P Q R S T
1 This worksheet represents a CSA with: 100 "full shares" and 50 "half shares".
2 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.
4
Week of the year
Mustard greens
Green onions
Monday date
Swiss chard
Cauliflower
Radishes
Pac choi
Kohlrabi
Broccoli
Collards
Spinach
Arugula
Turnips
Carrots
Parsley
Lettuce
Beets
Peas
Kale
5
6 19 10-May 150 100 150 100 150 150 150 100 100 100 150 150 100 150 150 100 0 0
7 20 17-May 100 150 100 150 150 100 100 150 150 100 150 100 150 100 150 150 150 0
8 21 24-May 150 100 150 100 150 150 150 100 100 100 150 150 100 150 150 100 100 150
9 22 31-May 100 150 100 150 150 100 100 150 150 100 150 100 150 100 150 150 150 100
10 23 7-Jun 150 100 150 100 150 150 150 100 100 100 150 150 100 150 150 100 100 150
11 24 14-Jun 100 150 100 150 150 100 100 150 150 100 150 100 150 100 0 0 150 100
12 25 21-Jun 150 100 150 100 150 150 150 100 100 100 150 0 0 0 0 0 100 150
13 26 28-Jun 100 150 100 150 150 100 100 150 150 100 150 0 0 0 0 0 0 100
14 27 5-Jul 150 100 150 100 0 0 0 0 0 0 0 0 0 0 0 0 0 150
15 28 12-Jul 100 150 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
16 29 19-Jul 150 100 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
17 30 26-Jul 100 150 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
18 31 2-Aug 150 100 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
19 32 9-Aug 100 150 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
20 33 16-Aug 150 100 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 Total units: 1900 1850 1900 1100 1200 1000 1000 1000 1000 800 1200 750 750 750 750 600 750 900
22 Unit price: $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $1.50 $1.00 $1.00 $1.00 $1.00 $2.00 $2.00 $1.50 $2.00 $1.00 $1.50 $1.00
23 Total value: $2,850.00 $1,850.00 $2,850.00 $1,100.00 $2,400.00 $1,000.00 $1,500.00 $1,000.00 $1,000.00 $800.00 $1,200.00 $1,500.00 $1,500.00 $1,125.00 $1,500.00 $600.00 $1,125.00 $900.00
CSAtotals
A B U V W X Y Z AA AB AC AD AE AF AG AH AI AJ AK
1 This worksheet represents a CSA with:
2
3
4
Week of the year
Summer squash
Storage onions
Southern peas
Watermelons
Monday date
Cantaloupes
Snap beans
Cucumbers
Sweet corn
Week total
Edamame
Tomatoes
Eggplant
Cabbage
Potatoes
Peppers
Garlic
Okra
5
6 19 10-May 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $2,900.00
7 20 17-May 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $3,025.00
8 21 24-May 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $3,350.00
9 22 31-May 150 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $3,350.00
10 23 7-Jun 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $3,350.00
11 24 14-Jun 150 150 150 100 0 0 0 0 0 0 0 0 0 0 0 0 $3,450.00
12 25 21-Jun 100 100 100 150 100 0 0 0 0 0 0 0 0 0 0 0 $2,725.00
13 26 28-Jun 150 150 150 100 150 150 150 100 150 150 0 0 0 0 0 0 $3,525.00
14 27 5-Jul 100 100 100 150 100 100 100 150 100 100 150 150 0 0 0 0 $2,500.00
15 28 12-Jul 0 150 150 100 150 150 150 100 150 150 100 100 150 100 150 0 $3,350.00
16 29 19-Jul 0 100 100 150 100 100 100 150 100 100 150 150 100 150 100 150 $3,450.00
17 30 26-Jul 0 150 150 100 150 150 150 100 150 150 100 100 150 100 150 100 $3,550.00
18 31 2-Aug 0 100 100 150 100 100 100 150 100 100 150 150 100 150 100 150 $3,450.00
19 32 9-Aug 0 150 150 100 150 150 150 100 150 150 100 100 150 100 150 100 $3,550.00
20 33 16-Aug 0 100 100 150 100 100 100 150 100 100 150 150 100 150 100 150 $3,450.00
21 Total units: 850 1250 1250 1250 1100 1000 1000 1000 1000 1000 900 900 750 750 750 650
22 Unit price: $1.50 $1.00 $2.00 $1.00 $0.50 $1.00 $1.00 $2.00 $2.00 $0.50 $1.00 $1.00 $4.00 $3.00 $2.00 $2.00 Grand total
23 Total value: $1,275.00 $1,250.00 $2,500.00 $1,250.00 $550.00 $1,000.00 $1,000.00 $2,000.00 $2,000.00 $500.00 $900.00 $900.00 $3,000.00 $2,250.00 $1,500.00 $1,300.00 $48,975.00
CSAtotals
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
1 Farm totals = CSAfullshares + CSAhalfshares + market1 + market 2
2
Week of the year
Summer squash
Mustard greens
Storage onions
Southern peas
Green onions
Watermelons
Monday date
Cantaloupes
Bell peppers
Swiss chard
Snap beans
Cucumbers
Sweet corn
Cauliflower
Week total
Tomatoes
Edamame
Radishes
Eggplant
Cabbage
Potatoes
Kohlrabi
Pac choi
Collards
Broccoli
Spinach
Arugula
Turnips
Lettuce
Carrots
Parsley
Beets
Garlic
Peas
Okra
Kale
3
4 19 10-May 170 120 190 120 210 170 170 120 120 120 210 230 140 170 190 120 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $3,690.00
5 20 17-May 120 170 140 170 210 120 120 170 170 120 210 180 190 120 190 170 230 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $3,935.00
6 21 24-May 170 120 190 120 210 170 170 120 120 120 210 230 140 170 190 120 180 190 120 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $4,330.00
7 22 31-May 120 170 140 170 210 120 120 170 170 120 210 180 190 120 190 170 230 140 170 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $4,330.00
8 23 7-Jun 170 120 190 120 210 170 170 120 120 120 210 230 140 170 190 120 180 190 120 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 $4,330.00
9 24 14-Jun 120 170 140 170 210 120 120 170 170 120 210 180 190 120 0 0 230 140 170 210 270 160 0 0 0 0 0 0 0 0 0 0 0 0 $4,690.00
10 25 21-Jun 170 120 190 120 210 170 170 120 120 120 210 0 0 0 0 0 180 190 120 160 220 210 160 0 0 0 0 0 0 0 0 0 0 0 $3,725.00
11 26 28-Jun 120 170 140 170 210 120 120 170 170 120 210 0 0 0 0 0 0 140 170 210 270 160 210 190 190 160 190 210 0 0 0 0 0 0 $4,715.00
12 27 5-Jul 170 120 190 120 0 0 0 0 0 0 0 0 0 0 0 0 0 190 120 160 220 210 160 140 140 210 140 160 230 230 0 0 0 0 $3,560.00
13 28 12-Jul 120 170 140 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 210 270 160 210 190 190 160 190 210 180 180 190 140 170 0 $4,640.00
14 29 19-Jul 170 120 190 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 220 210 160 140 140 210 140 160 230 230 140 190 120 190 $4,820.00
15 30 26-Jul 120 170 140 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 210 270 160 210 190 190 160 190 210 180 180 190 140 170 140 $4,920.00
16 31 2-Aug 170 120 190 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 220 210 160 140 140 210 140 160 230 230 140 190 120 190 $4,820.00
17 32 9-Aug 120 170 140 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 210 270 160 210 190 190 160 190 210 180 180 190 140 170 140 $4,920.00
18 33 16-Aug 170 120 190 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 160 220 210 160 140 140 210 140 160 230 230 140 190 120 190 $4,820.00
19 Total units: 2200 2150 2500 1280 1680 1160 1160 1160 1160 960 1680 1230 990 870 950 700 1230 1180 990 1850 2450 1850 1640 1320 1320 1480 1320 1480 1460 1460 990 990 870 850
20 Unit price: $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $1.50 $1.00 $1.00 $1.00 $1.00 $2.00 $2.00 $1.50 $2.00 $1.00 $1.50 $1.00 $1.50 $1.00 $2.00 $1.00 $0.50 $1.00 $1.00 $2.00 $2.00 $0.50 $1.00 $1.00 $4.00 $3.00 $2.00 $2.00 Grand total
21 Total value: $3,300.00 $2,150.00 $3,750.00 $1,280.00 $3,360.00 $1,160.00 $1,740.00 $1,160.00 $1,160.00 $960.00 $1,680.00 $2,460.00 $1,980.00 $1,305.00 $1,900.00 $700.00 $1,845.00 $1,180.00 $1,485.00 $1,850.00 $4,900.00 $1,850.00 $820.00 $1,320.00 $1,320.00 $2,960.00 $2,640.00 $740.00 $1,460.00 $1,460.00 $3,960.00 $2,970.00 $1,740.00 $1,700.00 $66,245.00
farmtotals
A B C D E F G H I J K L M N O P Q R S T
1 Field Production Information
2
3 The following table summarizes field production information related to total farm sale goals
4 The current version of this spreadsheet distributes total yield estimates for multiple harvest crops evenly across the harvest season.
5 This is not realistic and should be accounted for in a future version of the spreadsheet.
6
Green onions
Cantaloupes
Cucumbers
Cauliflower
Edamame
Eggplant
Cabbage
Pac choi
Kohlrabi
Collards
Broccoli
Mustard
Arugula
Carrots
Lettuce
greens
Garlic
Beets
Okra
Kale
7
8 Number of plantings: 4 4 3 2 3 1 3 1 2 3 1 1 7 2 4 4 3 1 3
9 Number of harvests: 8 8 6 7 6 6 6 7 9 5 8 1 15 8 8 8 5 8 6
10 Total row feet needed: 1,083 1,213 2,679 986 2,300 1,236 1,327 1,371 714 2,962 645 3,450 7,260 674 2,091 1,756 1,016 1,437 1,347
11 Total amount of seed needed (oz., lbs) 0.89 2.27 2.23 1.23 1.92 2.05 0.73 6.85 3.57 14.81 0.13 689.99 5.19 1.68 2.61 0.55 0.85 14.37 0.56
12 Row feet needed per planting 271 303 893 493 767 1236 442 1371 357 987 645 3450 1037 337 523 439 339 1437 449
13 Total Nitrogen per planting (lbs) 1.24 1.39 5.13 2.83 7.04 4.73 2.54 9.44 4.92 0.00 8.88 19.80 3.97 2.32 2.00 1.68 2.33 16.50 3.09
14 Potassium (K2O) per planting (lbs) 1.14 1.28 5.64 3.11 9.68 5.20 2.79 8.65 4.51 1.70 8.14 14.52 4.37 2.13 2.20 1.85 2.14 18.15 2.84
15 total value per crop $1,160 $1,740 $2,460 $1,485 $2,970 $1,845 $1,980 $1,180 $820 $1,700 $740 $1,320 $3,750 $1,160 $960 $1,680 $700 $2,640 $1,305
16
17
18 Total Acreage 5.08 acres
19
20 Gross revenue $66,245
21
FieldProductionInfo
A U V W X Y Z AA AB AC AD AE AF AG AH AI
1 Field Production Information
2
3 The following table summarizes field production information related to total farm sale goals
4 The current version of this spreadsheet distributes total yield estimates for multiple harvest crops evenly across the harvest season.
5 This is not realistic and should be accounted for in a future version of the spreadsheet.
6
Storage onions
Southern peas
Watermelons
Swiss chard
Snap beans
Sweet corn
Tomatoes
Radishes
Potatoes
Summer
Peppers
Spinach
Turnips
Parsley
squash
Peas
7
8 Number of plantings: 2 1 1 1 5 4 3 4 1 3 5 2 1 4 3
9 Number of harvests: 15 5 7 1 9 8 6 8 1 10 10 15 7 8 6
10 Total row feet needed: 1,756 2,759 1,272 1,484 2,788 4,298 3,032 2,744 986 1,612 17,582 2,396 636 3,790 5,088
11 Total amount of seed needed (oz., lbs) 0.09 41.38 0.19 247.72 8.36 10.74 15.16 6.86 4.93 10.74 6.59 3.95 1.59 3.13 11.19
12 Row feet needed per planting 878 2759 1272 1484 558 1074 1011 686 986 537 3516 1198 636 947 1696
13 Total Nitrogen per planting (lbs) 3.36 7.92 7.30 16.19 2.13 3.08 0.00 3.15 3.77 3.70 36.33 6.60 8.76 4.35 15.57
14 Potassium (K2O) per planting (lbs) 3.70 12.67 7.30 10.79 2.35 4.93 1.74 2.89 4.15 3.39 10.09 6.05 7.30 3.99 21.41
15 total value per crop $2,150 $1,900 $1,460 $1,850 $1,280 $2,960 $1,740 $3,360 $1,320 $1,850 $4,900 $3,300 $1,460 $1,160 $3,960
16
17
18 Total Acreage
19
20 Gross revenue
21
FieldProductionInfo
A B C D E F G H I J K L M N O P Q R S
1 Yield & Production Data Chart (Please see notes at bottom of chart)
IMPORTANT: Columns with Bold Italic RED text is a formula, all other columns can be changed.
2
plants needed per acre
within row spacing (in)
btwn rows spacing (in)
yield (lbs per 100' bed)
yield (lbs per 100' row)
plants per 100' bed
yield (lbs per acre)
seed (oz.) per 100'
Produce unit (lbs)
row feet per acre
area per 100' bed
K2O (lb per acre)
bed spacing (in)
row feet per unit
N (lbs per acre)
# of plantings
rows per bed
# of harvests
3 Produce
4 Arugula 0.25 4 8 0.33 120 110 7,000 27 80 60 3 2 12 26,136 156,816 0.9 1,800 500
5 Beets 1 4 8 0.75 120 110 25,000 96 287 60 3 4 12 26,136 78,408 1.0 900 500
6 Broccoli 1 3 6 0.25 100 110 8,000 46 92 60 2 18 18 17,424 11,616 2.2 133 500
7 Cabbage 2 2 7 0.25 100 110 35,000 201 402 60 2 18 18 17,424 11,616 1.0 133 500
8 Cantaloupes 4 3 6 0.25 80 110 15,000 172 172 60 1 36 60 8,712 2,904 2.3 33 500
9 Carrots 1 1 6 0.17 100 110 26,000 99 298 60 3 2 12 26,136 156,816 1.0 1,800 500
10 Cauliflower 1 3 6 0.17 100 110 13,000 75 149 60 2 18 18 17,424 11,616 1.3 133 500
11 Collards 1 1 7 0.50 120 110 15,000 86 172 60 2 18 18 17,424 11,616 1.2 133 500
12 Cucumbers 1 2 9 1.00 120 110 20,000 230 230 60 1 12 60 8,712 8,712 0.4 100 500
13 Edamame 1 3 5 24.00 0 30 5,000 29 29 30 1 6 30 17,424 34,848 3.5 200 250
14 Eggplant 1 1 8 0.02 120 110 20,000 230 230 60 1 24 60 8,712 4,356 0.4 50 500
15 Garlic 0.5 1 1 320.00 150 110 5,000 19 57 60 3 6 12 26,136 52,272 2.6 600 500
16 Green onions 1 7 15 0.50 100 110 9,000 34 103 60 3 4 12 26,136 78,408 2.9 900 500
17 Kale 1 2 8 0.50 120 110 30,000 172 344 60 2 12 18 17,424 17,424 0.6 200 500
18 Kohlrabi 1 4 8 0.50 100 110 12,000 46 138 60 3 60 12 26,136 5,227 2.2 60 500
19 Lettuce 1 4 8 0.13 100 110 25,000 96 287 60 3 9 12 26,136 34,848 1.0 400 500
20 Mustard greens 1 3 5 0.25 120 110 12,000 69 138 60 2 12 18 17,424 17,424 1.5 200 500
21 Okra 1 1 8 1.00 100 110 8,000 92 92 60 1 18 60 8,712 5,808 1.1 67 500
22 Pac choi 2 3 6 0.13 120 110 22,500 129 258 60 2 12 18 17,424 17,424 1.5 200 500
23 Parsley 0.25 2 15 0.01 100 110 8,000 31 92 60 3 6 12 26,136 52,272 0.8 600 500
24 Peas 1 1 5 24.00 50 80 6,000 34 34 30 1 2 30 17,424 104,544 2.9 600 250
25 Peppers 1 1 7 0.02 100 100 20,000 115 230 60 2 18 18 17,424 11,616 0.9 133 500
26 Potatoes 1.75 1 1 267.00 150 100 30,000 218 218 38 1 9 38 13,756 18,341 0.8 133 317
27 Radishes 0.5 5 9 1.50 100 110 6,000 23 69 60 3 2 12 26,136 156,816 2.2 1,800 500
28 Snap beans 1 4 8 16.00 50 80 6,000 34 34 30 1 3 30 17,424 69,696 2.9 400 250
29 Southern peas 1 3 6 24.00 0 30 5,000 29 29 30 1 4 30 17,424 52,272 3.5 300 250
30 Spinach 0.5 4 8 1.00 120 110 8,000 31 92 60 3 2 12 26,136 156,816 1.6 1,800 500
31 Storage onions 1 1 1 0.50 100 110 35,000 134 402 60 3 6 12 26,136 52,272 0.7 600 500
32 Summer squash 1 3 10 2.00 120 110 20,000 115 230 60 2 24 18 17,424 8,712 0.9 100 500
33 Sweet corn 6 5 10 3.00 180 50 11,000 63 63 30 1 12 30 17,424 17,424 9.5 100 250
34 Swiss chard 1 2 15 0.33 120 110 20,000 92 184 60 2 12 24 21,780 21,780 1.1 200 400
35 Tomatoes 1 1 7 0.25 120 100 20,000 230 230 60 1 24 60 8,712 4,356 0.4 50 500
36 Turnips 1 4 8 0.33 120 110 8,000 31 92 60 3 4 12 26,136 78,408 3.3 900 500
37 Watermelons 8 3 6 0.66 80 110 20,000 230 230 60 1 36 60 8,712 2,904 3.5 33 500
38
39
40 Chart Notes:
41
42 1. These yield estimates are the low end of the yield ranges listed in the NCSU
43 vegetable production guides http://www.ces.ncsu.edu/depts/hort/hil/veg-index.html
44 with the exception of swiss chard, parsley, green onions, kale, pac choi, garlic and
45 edamame.
46
47 2. Higher yields are possible under optimal growing conditions. The crop spacing
48
presented below was used at the CEFS student farm in Goldsboro, NC in 2000 and
49
2001.
50
51
3. The seeding rates are from the 2003 Johnny's Selected Seeds catalog.
52
53
4. The N rates are at the high end of the crop specific ranges recommended by
54
NCDA & CS.
55
56
5. The K2O rates are the NCDA & CS recommendations for soils with a K index of
57
50.
58
59
60
61
62
63
64
65
66
yielddata
