Spreadsheet: 0c741696-8d79-4b59-b27a-6357e197ae04
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | Assumptions: |  |  |  |  |  |  | Blue cells are the variables to modify, black numbers are calculated automatically. | Scenario | A | : 100% Forastero Wet Bean
 |  | Tree variety mix: |  |  |  | % of orchard planted in variety: | Ave. $/lb. | Yield / tree |  |  | Tree density calculator:
 | 1 |  | Forastero wet beans |  |  | 1 | 1.8 | 5.6 | [NAME] |  | 1. Enter spacing (in feet):
 | 2 |  | Criollo wet beans | @~ | 0.9 | 0 | 2 | 5.04 | [NAME] |  | 6 | x | 7
 |  |  |  |  |  | Weighted ave. price ($/lb.) and ave. mature yield/tree = | 1.8 | 5.6 | [NAME] |  | 2. Enter % of total land area required for
 |  | Age of trees: |  |  |  | % of mature yield | Number of trees | Yield / orchard |  |  | roads, packing house, etc. : |  |  | 0.036
 | 3 |  | Number non-bearing trees @ |  |  | 0 | 10 | 0 | [NAME] |  | 3. Enter total number of acres: |  |  | 1
 | 4 |  | Number partially bearing trees @ |  |  | 0.3 | 20 | 33.6 | [NAME] |  |  | Trees per acre = | 999.8057142857142 | trees
 | 5 |  | Number partially bearing trees @ |  |  | 0.7 | 20 | 78.39999999999999 | [NAME] |  |  | Total trees = | 999.8057142857142 | trees
 | 6 |  | Number of mature trees @ |  |  | 1 | 950 | 5320 | [NAME]
 | 7 |  | Total trees & ave mkt. yield wet beans/orchard (lbs) = |  |  |  | 1000 | 5432 | Yield wet beans/ average tree  = |  |  |  | 5.432 | lbs.
 | 8 |  | Total acreage of orchard (ac.) = |  |  |  | 1 |  | 13 |  | Ave. # pods/ mature tree = |  |  | 23.1
 | 9 |  | Trees /acre = |  |  |  | 1000 |  | 14 |  | Ave. [NAME]. of mature pod (lbs) = |  |  | 0.954
 | 10 |  | Wage rate hand labor  ($/hr.) = |  |  |  | 12 |  | 15 |  | Pod => wet-bean conversion ƒ = |  |  | 0.255
 | 11 |  | Benefits (FICA, etc.) (%) = |  |  | 0.33 |  |  | 16 |  | Wet => dry conversion ƒ = |  |  | 0.35
I.  ANNUAL GROSS REVENUE: |  |  |  |  | % | Total units | $/unit: | ¢/lb wet beans | $ /tree: |  | $ /acre: |  | $ /orchard: | % of gross
 | A. | Wet beans (lbs. @ $/lb.) |  | @ | 1 | 5432 | 1.8 | 180 | 9.7776 |  | 9777.6 |  | 9777.6 | 1
 | B. | Pods (no. pods @ $/pod) |  | @ | 0 | 0 | 0.1 | 0 | 0 |  | 0 |  | 0 | 0
 | C. | Dry beans (lbs. @ $/lb.) |  | @ | 0 | 0 | 1.6 | 0 | 0 |  | 0 |  | 0 | 0
 | D. | Other cacao-related sales (enter annual total for enterprise) |  |  |  |  |  | 0 | 0 |  | 0 |  | 0 | 0
 |  |  |  | Price of "wet bean equivalent" => | 1.8 |  | I. TOTAL REVENUE = | 180 | 9.7776 |  | 9777.6 |  | 9777.6 | 1
II.  ANNUAL OPERATING COSTS:
 | A. | Annual Growing costs (w/ units): |  |  |  | units | $/unit: | ¢/lb wet beans | $ /tree: |  | $ /acre: |  | $ /orchard: | % of gross
 | 1 |  | Fertilization |  |  |  | Fertilization sub-totals => | 33.06332842415316 | 1.796 |  | 1796 |  | 1796 | 0.183685157911962
 |  |  | Fertilizer (lbs./tree) |  |  | 1.4 | 0.76 | 19.58762886597938 | 1.064 |  | 1064 |  | 1064 | 0.1088201603665521
 |  |  | Machinery (hours/orchard) |  |  | 8 | 25 | 3.681885125184094 | 0.2 |  | 200 |  | 200 | 0.02045491736213386
 |  |  | Hand labor (min./tree) |  |  | 2 | 15.96 | 9.79381443298969 | 0.532 |  | 532 |  | 532 | 0.05441008018327606
 | 2 |  | Irrigation: |  |  |  | Irrigation sub-totals => | 16.3659793814433 | 0.889 |  | 889 |  | 889 | 0.09092210767468499
 |  |  | Water (1,000 gals./ orchard) |  |  | 245 | 2 | 9.02061855670103 | 0.49 |  | 490 |  | 490 | 0.05011454753722795
 |  |  | Pumping (hours/ orchard) |  |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Labor (hours/ orchard) |  |  | 25 | 15.96 | 7.345360824742269 | 0.399 |  | 399 |  | 399 | 0.04080756013745705
 | 3 |  | Pest control: |  |  |  | Pest control sub-totals => | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Chemicals (gals./ orchard) |  |  | 0 | 10 | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Machinery (hours/ orchard) |  |  | 0 | 10 | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Hand labor (min./ tree) |  |  | 0 | 15.96 | 0 | 0 |  | 0 |  | 0 | 0
 | 4 |  | Weed control: |  |  |  | Weed control sub-totals => | 6.369661266568483 | 0.346 |  | 346 |  | 346 | 0.03538700703649157
 |  |  | Chemicals (gals./ orchard) |  |  | 0 | 2 | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Machinery (hours/ orchard) |  |  | 8 | 10 | 1.472754050073638 | 0.08 |  | 80 |  | 80 | 0.008181966944853543
 |  |  | Hand labor (min./ tree) |  |  | 1 | 15.96 | 4.896907216494845 | 0.266 |  | 266 |  | 266 | 0.02720504009163803
 | 5 |  | Pruning: |  |  |  | Pruning sub-totals => | 10.28350515463918 | 0.5586000000000001 |  | 558.6000000000001 |  | 558.6000000000001 | 0.05713058419243987
 |  |  | Machinery (hours/ orchard) |  |  | 0 | 5 | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Hand labor (min./ tree) |  |  | 2.1 | 15.96 | 10.28350515463918 | 0.5586000000000001 |  | 558.6000000000001 |  | 558.6000000000001 | 0.05713058419243987
 | A. | Annual Growing costs: (continued): |  |  |  | units | $/unit: | ¢/lb wet beans | $ /tree: |  | $ /acre: |  | $ /orchard: | % of gross
 | 6 |  | Periodic disease control |  |  |  | Diseae control sub-totals => | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Chemicals (gals./ orchard) |  |  | 0 | 3 | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Machinery (hours/ orchard) |  |  | 0 | 10 | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Hand labor (min./ tree) |  |  | 0 | 15.96 | 0 | 0 |  | 0 |  | 0 | 0
 | 7 |  | Other cost |  |  |  | Other cost sub-totals => | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Materials (amt./ orchard) |  |  | 0 | 0 | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Machinery (hours/ orchard) |  |  | 0 | 10 | 0 | 0 |  | 0 |  | 0 | 0
 |  |  | Hand labor (min./ tree) |  |  | 0 | 15.96 | 0 | 0 |  | 0 |  | 0 | 0
 | 8 |  | Costs associated w/ other income |  |  | Enter the annual orchard cost => |  | 0 | 0 |  | 0 |  | 0 | 0
 |  |  |  |  |  |  | Total growing costs/ year = | 66.08247422680412 | 3.5896 |  | 3589.6 |  | 3589.6 | 0.3671248568155784
 | B. | Annual Harvesting Costs: |  |  |  | ¢ / | unit: | ¢/lb wet beans | $ /tree: |  | $ /acre: |  | $ /orchard: | % of gross
 | 1 |  | Harvesting (¢ /pod) |  |  | 12 | ¢ / pod | 47.05882352941176 | 2.772 |  | 2772 |  | 2772 | 0.2835051546391753
 | 2 |  | Extraction  (¢ /lb. of wet bean) |  |  | 16 | ¢/lb.wet bean | 16 | 0.8691200000000001 |  | 869.1200000000001 |  | 869.1200000000001 | 0.08888888888888889
 | 3 |  | Fermentation & drying |  |  | 10 | ¢/lb.wet bean | n.a. | n.a. |  | n.a. |  | n.a. | 0
 |  |  |  |  |  |  | Total harvesting costs/ year = | 63.05882352941176 | 3.64112 |  | 3641.120000000001 |  | 3641.120000000001 | 0.3723940435280642
 |  |  |  |  |  |  | II. TOTAL OPERATING COSTS  = | 129.1412977562159 | 7.23072 |  | 7230.720000000001 |  | 7230.720000000001 | 0.7395189003436426
 |  |  |  |  |  |  | III.  ANNUAL GROSS MARGIN = | 50.85870224378408 | 2.54688 |  | 2546.879999999999 |  | 2546.879999999999 | 0.2604810996563573
IV.  ANNUAL OWNERSHIP COSTS: |  |  |  |  |  |  |  | ¢/lb wet beans | $ /tree: |  | $ /acre: |  | $ /orchard: | % of gross
 | A. | Land charge: (mortgage or lease rent & property taxes) |  |  |  |  | sub-totals => | 3.405743740795287 | 0.185 |  | 185 |  | 185 | 0.01892079855997382
 | B. | Delivery to processor |  |  | 0 | ¢/lb.wet bean | sub-totals => | 0 | 0 |  | 0 |  | 0 | 0
 | C | Risk management |  |  |  |  | Risk Management sub-totals => | 3.6 | 0.195552 |  | 195.552 |  | 195.552 | 0.02
 | 1 |  | Revenue insurance | @ | 0.02 | of gross income |  | 3.6 | 0.195552 |  | 195.552 |  | 195.552 | 0.02
 | 2 |  | Liability insurance | @ | 0 | of gross income |  | 0 | 0 |  | 0 |  | 0 | 0
 | D | Management overhead |  |  |  |  | Overhead sub-totals => | 5.522827687776141 | 0.3 |  | 300 |  | 300 | 0.03068237604320078
 | 1 |  | Office expense |  |  |  | Enter the total annual orchard cost => | 1.840942562592047 | 0.1 |  | 100 |  | 100 | 0.01022745868106693
 | 2 |  | Professional services |  |  |  | Enter the total annual orchard cost => | 3.681885125184094 | 0.2 |  | 200 |  | 200 | 0.02045491736213386
 | E | Orchard establishment |  |  |  |  | Orchard establishment sub-totals => | 0.2835051546391753 | 0.0154 |  | 15.4 |  | 15.4 | 0.001575028636884307
 | 1 |  | Establishment cost | @ | 35 | /tree amort. @ | 25 | 0.02577319587628865 | 0.0014 |  | 1.4 |  | 1.4 | 0.000143184421534937
 | 2 |  | Annual replacement rate @ |  |  | 0.01 | of orchard | 0.2577319587628866 | 0.014 |  | 14 |  | 14 | 0.00143184421534937
 |  |  |  |  |  |  | IV. TOTAL OWNERSHIP COSTS = | 12.8120765832106 | 0.6959520000000001 |  | 695.952 |  | 695.952 | 0.07117820324005891
 |  |  |  |  |  |  | V. TOTAL COST OF PRODUCTION (EXCEPT M&II) = | 141.9533743394265 | 7.926672 |  | 7926.672000000001 |  | 7926.672000000001 | 0.8106971035837016
 |  |  |  |  |  |  | VI. MANAGEMENT & INVESTMENT INCOME (M&II) = | 38.04662566057348 | 1.850928 |  | 1850.927999999999 |  | 1850.927999999999 | 0.1893028964162984
 | Simple break-even analysis: |  |  |  |  |  |  |  |  |  |  |  | NOTE:  Enter "T" to cover TOTAL production costs; enter "O" to only cover operating costs: | T
 |  |  |  |  | Given the weighted average price of | 1.8 | $/lb. of wet beans, the yield req'd. to cover TOTAL production costs = |  |  |  |  |  |  | 4.403706666666667
 |  |  |  |  | Given the actual marketable yield of | 5.432 | lbs. of wet beans/tree, wt'd. ave. price req. to cover TOTAL costs = |  |  |  |  |  |  | 1.459254786450663