# ULU ORCHARD COST OF PRODUCTION SPREADSHEET INSTRUCTIONS

WELCOME TO THE ULU (BREADFRUIT) ORCHARD COST OF PRODUCTION SPREADSHEET! THIS TOOL IS DESIGNED TO ASSIST YOU IN CALCULATING AND ANALYZING THE PRODUCTION COSTS ASSOCIATED WITH ESTABLISHING AND MAINTAINING AN ULU ORCHARD. FOLLOW THESE INSTRUCTIONS FOR ACCURATE RESULTS.

## GETTING STARTED:

1. **CHANGING RED BOX CELLS:**

- LOCATE THE CELLS HIGHLIGHTED IN RED BOXES; THESE ARE THE EDITABLE CELLS WHERE YOU CAN INPUT YOUR SPECIFIC INFORMATION.

2. **RESULTS IN BLUE BOXES:**

- THE BLUE BOXES DISPLAY THE CALCULATED RESULTS BASED ON THE INFORMATION YOU INPUT. DO NOT MODIFY THESE CELLS, AS THEY ARE AUTOMATICALLY CALCULATED.

## PLANTING INFORMATION:

3. **PLANTING DETAILS:**

- SPECIFY INFORMATION SUCH AS ROW LENGTH, BED CENTER TO CENTER, TREE SPACING, TREES PER ROW, AND PLANTING TO HARVEST YEARS.

- THE SPREADSHEET WILL CALCULATE TREES PER ACRE, CALCULATED ACRE, AND ACRE MULTIPLIER BASED ON THIS INFORMATION.

## ESTABLISHMENT COSTS (NON-BEARING YEARS):

4. **NURSERY COSTS:**

- INPUT QUANTITIES AND COSTS FOR TRAYS/POTS, SEEDLINGS, AND MEDIA FOR THE NON-BEARING YEARS.

- THE SPREADSHEET WILL CALCULATE THE COST PER 100FT ROW AND COST PER ACRE FOR NURSERY-RELATED ITEMS DURING NON-BEARING YEARS.

5. **PLANTING COSTS:**

- ENTER QUANTITIES AND COSTS FOR MULCH/WEEDMAT, POLY TUBING WITH EMITTER, IRRIGATION DRIP TAPE, AND ANY OTHER COSTS DURING NON-BEARING YEARS.

- THE SPREADSHEET WILL CALCULATE THE COST PER 100FT ROW AND COST PER ACRE FOR PLANTING-RELATED ITEMS DURING NON-BEARING YEARS.

6. **FERTILIZER (NON-BEARING YEARS):**

- INPUT FERTILIZER AMOUNTS PER TREE FOR VARIOUS YEARS, ALONG WITH THE COST OF MATERIAL AND UNIT, SPECIFICALLY FOR THE NON-BEARING YEARS.

- THE SPREADSHEET WILL CALCULATE THE COST PER 100FT ROW AND COST PER ACRE FOR EACH FERTILIZER APPLICATION DURING NON-BEARING YEARS.

7. **PESTICIDE APPLICATIONS (NON-BEARING YEARS):**

- ENTER CHEMICAL USAGE PER 100FT ROW FOR EACH YEAR, ALONG WITH THE COST OF MATERIAL AND UNIT, SPECIFICALLY FOR THE NON-BEARING YEARS.

- THE SPREADSHEET WILL CALCULATE THE COST PER 100FT ROW AND COST PER ACRE FOR EACH PESTICIDE APPLICATION DURING NON-BEARING YEARS.

## LABOR INPUTS:

8. **HOURLY RATE:**

- SPECIFY THE HOURLY RATE FOR LABOR.

9. **LABOR HOURS:**

- ENTER HOURS PER 100FT ROW FOR VARIOUS LABOR TASKS FOR EACH YEAR (FIELD PREP/AMENDING/INSTALL, PROPAGATION/NURSERY WORK, PLANTING, FERTILIZER AND PESTICIDE APPLICATIONS, OTHER WORK).

- THE SPREADSHEET WILL CALCULATE THE COST PER 100FT ROW, COST PER ACRE, AND HOURS PER ACRE FOR EACH LABOR TASK.

## HARVEST INFORMATION AND ANNUAL PRODUCTION COSTS:

10. **HARVEST INFORMATION AND ANNUAL PRODUCTION COSTS (STARTING YEAR 5):**

- SPECIFY THE AVERAGE POUNDS PER TREE PER HARVEST AND THE CROP LOSS PERCENTAGE.

- **NOTE:** ANNUAL PRODUCTION COSTS BEGIN IN YEAR 5 WHEN THE TREES START BEARING CROPS.

## MARKET INFORMATION:

11. **AVG SALES PRICE:**

- INPUT THE AVERAGE SALES PRICE OF THE PRODUCT PER POUND.

## 10-YEAR ECONOMIC ANALYSIS AND INFLATION CONSIDERATION:

12. **PROFIT CALCULATIONS (OVER 10 YEARS):**

- THE SPREADSHEET PROVIDES A COMPREHENSIVE 10-YEAR ECONOMIC ANALYSIS, INCLUDING COSTS, REVENUE, AND PROFIT PER YEAR FOR BOTH 100FT ROW AND ACRE.

- **NOTE:** THE MODEL ASSUMES NO INFLATOR FOR FUTURE YEARS. CONSIDER THE POTENTIAL IMPACT OF INFLATION ON FUTURE COSTS AND REVENUE WHEN REVIEWING THE ECONOMIC PROJECTIONS.

## EXCLUSIONS AND CONSIDERATIONS:

**COST EXCLUSIONS:**

- **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.

- **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.