ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
COST OF PRODUCTION SPREADSHEET INSTRUCTIONS
2
3
## OVERVIEW:
4
5
WELCOME TO THE GOFARM HAWAII COST OF PRODUCTION SPREADSHEET! THIS TOOL IS DESIGNED TO ASSIST YOU IN CALCULATING AND ANALYZING THE PRODUCTION COSTS ASSOCIATED WITH GROWING YOUR CROP. FOLLOW THESE INSTRUCTIONS FOR ACCURATE RESULTS.
6
7
## GETTING STARTED:
8
9
1. **CHANGING RED BOX CELLS:**
10
11
- LOCATE THE CELLS HIGHLIGHTED IN RED BOXES; THESE ARE THE EDITABLE CELLS WHERE YOU CAN INPUT YOUR SPECIFIC INFORMATION.
12
13
2. **RESULTS IN BLUE BOXES:**
14
15
- THE BLUE BOXES DISPLAY THE CALCULATED RESULTS BASED ON THE INFORMATION YOU INPUT. DO NOT MODIFY THESE CELLS, AS THEY ARE AUTOMATICALLY CALCULATED.
16
17
## CROP INPUTS:
18
19
3. **PLANTING/LAYOUT INFORMATION:**
20
21
- ENTER VALUES SUCH AS ROW LENGTH, BED CENTER TO CENTER, PLANT SPACING, AND PLANTING TO HARVEST DAYS.
22
23
4. **PLANTING INPUTS:**
24
25
- ENTER THE AMOUNT USED PER 100FT ROW, COST OF MATERIAL, AND QUANTITY PURCHASED FOR ITEMS LIKE MULCH/WEEDMAT, IRRIGATION HOSE, SEED COSTS, ETC.
26
27
- THE SPREADSHEET WILL CALCULATE THE COST PER 100FT ROW, COST PER ACRE, AND THE PERCENTAGE OF TOTAL COST FOR EACH INPUT.
28
29
5. **FERTILIZER:**
30
31
- INPUT THE AMOUNT USED PER 100FT ROW, COST OF MATERIAL, AND UNIT FOR VARIOUS FERTILIZERS. IF YOU APPLIED LESS FERTILIZER APPLICATIONS THAN THE SPREADSHEET LISTS, THEN PUT A ZERO.
32
33
- THE SPREADSHEET WILL CALCULATE THE COST PER 100FT ROW, COST PER ACRE, AND THE PERCENTAGE OF TOTAL COST FOR EACH FERTILIZER.
34
35
6. **PESTICIDE APPLICATIONS:**
36
37
- ENTER THE AMOUNT USED PER 100FT ROW AND THE COST OF MATERIAL FOR EACH PESTICIDE APPLICATION. IF YOU DO NOT APPLY PESTICIDES OR LESS APPLICATIONS THEN LISTED, THEN PUT A ZERO
38
39
- THE SPREADSHEET WILL CALCULATE THE COST PER 100FT ROW, COST PER ACRE, AND THE PERCENTAGE OF TOTAL COST FOR EACH APPLICATION.
40
41
## LABOR INPUTS:
42
43
8. **HOURLY RATE:**
44
45
- SPECIFY THE HOURLY RATE FOR LABOR. THIS IS THE RATE YOU SHOULD PAY YOURSELF OR AN EMPLOYEE
46
47
9. **ACTUAL LABOR HOURS:**
48
49
- TO ACCURATELY CALCULATE LABOR COSTS, CONSIDER TRACKING ACTUAL TIME SPENT ON THE FARM FOR EACH TASK. USE A STOPWATCH OR A TIME-TRACKING TOOL.
50
51
- REGULARLY UPDATE THE SPREADSHEET WITH THE ACTUAL HOURS SPENT ON BEDDING/AMENDING, SEED COLLECTION/PLANTING, HARVESTING/WASHING, PESTICIDE/FERTILIZER APPLICATIONS, AND OTHER TASKS.
52
53
## HARVEST INFORMATION:
54
55
10. ** YIELD:**
56
57
- SPECIFY THE AVERAGE # OF LEAVES HARVESTED PER PLANT AND NUMBER OF HARVESTS DONE PER WEEK.
58
59
- THE SPREADSHEET WILL CALCULATE THE TOTAL COST PER CROP, REVENUE FROM SALES, AND THE OVERALL PROFIT PER 100FT ROW AND PER ACRE.
60
61
11. **MARKET INFORMATION:**
62
63
- INPUT THE AVERAGE SALES PRICE OF LEAF
64
65
12. **PROFIT:**
66
67
- THE SPREADSHEET WILL CALCULATE THE PROFIT PER 100FT ROW AND PER ACRE BASED ON THE ENTERED SALES PRICE.
68
69
## SCALING CONSIDERATIONS:
70
71
13. **SCALING UP TO 1 ACRE:**
72
73
- BE CAUTIOUS WHEN USING THE CALCULATED ACRE MULTIPLIER. WHILE IT PROVIDES A CONVENIENT WAY TO SCALE UP FROM 100FT ROWS TO 1 ACRE, CONSIDER THE FOLLOWING:
74
75
- CERTAIN COSTS MAY NOT SCALE LINEARLY (E.G., LABOR MAY HAVE EFFICIENCIES AT A LARGER SCALE).
76
77
- EXTERNAL FACTORS LIKE CLIMATE, SOIL CONDITIONS, OR PEST PRESSURES MAY AFFECT THE ACCURACY OF THE MULTIPLIER.
78
79
## EXCLUSIONS AND CONSIDERATIONS:
80
81
4. **COST EXCLUSIONS:**
82
83
- **OVERHEAD COSTS:** THIS SPREADSHEET DOES NOT INCLUDE OVERHEAD COSTS, WHICH ARE INDIRECT COSTS SUCH AS RENT, UTILITIES, AND ADMINISTRATIVE EXPENSES. BE SURE TO ACCOUNT FOR THESE SEPARATELY IN YOUR OVERALL FARM BUDGET.
84
85
- **SOME NON-VARIABLE COSTS:** CERTAIN FIXED OR NON-VARIABLE COSTS MAY NOT BE INCLUDED IN THIS ANALYSIS. ADJUST THE SPREADSHEET OR SUPPLEMENT IT WITH ADDITIONAL INFORMATION AS NEEDED.
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100