Front page of the Nursery Cost of Production with space for 25 crops spreadsheet

Nursery Cost of Production Calculator (25 Crops)


March 2, 2009 - Author: Betz, Fernandez and Dudek

This work sheet is designed to assist the manager/owner in developing estimated cost for their nursery business.

Enterprise Cost are determined for:
1. Economic Cost of Production
2. Breakeven Net Worth Change
3. Breakeven Cash Flow
The output includes various sale prices needed to meet management and profitability objectives.
Up to 25 different enterprises can be simultaneously analyzed. Please use the links here if you need additional enterprises over 25:

50 crops

100 crops

Strategies involve using financial information from past records and developing current projected cost.
Cost are separated into variable or "direct cost" and overhead or "in-direct" cost.
"Direct cost" are those cost that change proportionally as the units of production change.
"In-Direct" are cost that tend not to change as units of production change.
"Direct cost" per unit of production are entered directly into the enterprise budgets.
Five worksheets help calculate some of these estimated "direct cost".
Worksheets available are for Fertilizer, Pesticides, Substrate, Over wintering materials, and various direct Labor cost.

"In-Direct cost " or overhead cost are allocated to the unit of production using the concept of "square foot weeks" (SFW).
Square foot weeks is determined by multiplying the average area (in ft) by time (in weeks) that it takes to produce the crop.
In addition a producer derived "weighting factor" can be assigned that gives greater flexibility in the final allocation percentages.
The allocation of overhead is then determined by calculating the percentage of the total SFW that each enterprise
uses (with the weighting factor) by the total "In-Direct" cost or overhead for the farm as a whole.

Total overhead cost are captured from the income statement of the most current completed fiscal year.
Of course, major assumptions are made that the business overhead is relatively the same as that competed business year.
If not, assumptions and adjustments (matching to the future enterprises) should be made to correct to the annualized cost.

If you need additional help with the calculator, please review the instructional video or review the example worksheet. 


Accessibility Questions:

For questions about accessibility and/or if you need additional accommodations for a specific document, please send an email to ANR Communications & Marketing at