ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Crop Costing Budget Worksheet
2
for wholesale readiness
3
4
fill in peach cells
5
don't write over grey cells
6
7
Step 1: Fill in your crop, unit of measure, bed length and rows per bed below in the peach cells.
8
9
Crop:
10
Harvest Unit of Measure:
11
Bed length (linear feet)
12
Rows per bed
13
14
Step 2: Consult your records for yield per bed, based on bed length and rows entered above.
15
enter the wholesale price that you are testing with this model.
16
enter a margin goal for this product - at least 20% for wholesale and 40% for retail is recommended.
17
These sheets are meant to be used as general guidelines, and the user should verify their own numbers and assumptions.
18
19
Yield per bed (see row 9)
20
Price per unit
21
Total Sale$0.00
22
Profit margin goal
23
24
Step 3: Enter the number of beds you plan to plant with this crop for wholesale in the peach cell below.
25
Totals:
26
Projected Revenues$0 x number of beds:$0
27
Budgeted Expenses$0 x number of beds:$0
28
Budgeted Profits$0 x number of beds:$0
29
30
Step 4: Enter your cost per hour (or an average cost) for labor. Then enter your rate for taxes and benefits.
31
32
Field Labor: cost per hour
33
Taxes and Fringe Benefits15%
34
Effective labor costs per hour$0
35
36
Step 5: Enter your costs of direct inputs per bed (rememeber your bed length and rows entered in step 1).
37
List your costs of seeds or starts, soil ammendments, or other inputs. Use scratch paper as needed or create a new tab to organize your "other" items.
38
If you don't know your plant start costs in your greenhouse, use the "Transplants" Tab to calculate a cost.
39
40
Seeds or Transplants
41
Soil Ammendments
42
Other 1
43
Other 2
44
SUBTOTAL$0
45
46
Note your labor budget: This is the (projected expenses - direct costs) = your remaining budget for labor
47
Labor Budget per bed$0
48
Labor Budget in Hours, per bed#DIV/0!
49
50
Step 6: Enter your labor plan PER BED, using the same bed size and rows entered in step 1.
51
You are making estimates unless you have already collected data. Over the course of the season, you should refer to your estimates and aim to meet your plan.
52
A "feasible" budget for your wholesale price is less than or equal to your labor budget in hours per bed.
53
54
Activity# of passes per crop (must be at least 1 to calculate)Time (in minutes) per passNotes:
55
Bed preparation
56
Seeding or transplanting
57
Thinning
58
Cultivating
59
Hand Weeding
60
Pruning
61
Trellising/Tying
62
Irrigation
63
Weather protection
64
Fertilizing (side dress or foliar)
65
Pest control (scouting, application)
66
Harvesting to wash shed
67
Clearing/Plowing under
68
Washing/Packing
69
Other
70
Other
71
Other
72
Other
73
SUBTOTAL: LABOR TIME in MINUTES
00
74
LABOR HOURS0.0
75
76
Step 7: Review your crop cost analysis below. Here you can experiment with the projected return on the number of beds.
77
Fill in the peach cell below for # of beds.
78
79
Summary Crop Cost Analysis
80
# of beds in crop plan
81
Projected total yield0
82
Income$0
% of expense budget:
83
Direct Costs$0 #DIV/0!
84
Labor$0.00 #DIV/0!
85
Margin$0.00
86
Margin %#DIV/0!VS. Margin Goal:
87
Cost per unit:#DIV/0!
88
89
Step 8: Use this section to experiment with a variable such as equipment purchase. This shows you a different scenario's outcome.
90
Best practice is to create a new tab and copy this entire sheet - then experiment with the opportunity in a new tab to protect your data.
91
Compare your results between tabs to see if you want to pursue the opportunity!
92
Fill in the peach cell below for the name of the opportunity, and the cost for the growing cycle.
93
Results will show you the effective impact on your margin for the period of time that you incur the cost of the opportunity.
94
Be sure to adjust your labor or input numbers above to show the impact of the purchase.
95
96
Opportunity Assessment Scenario:
97
Other Costs
98
Other Costs
99
Margin$0.00
100
Margin %#DIV/0!