Enter data into cells. Then click on the Output and Sensitivity tabs.

Close

Revenue received per unit to the grower business after broker fees etc.

Close

Only include post-production costs such as freight, point of purchase labels, packaging, if included in sales price and not passed through as separate charge

Close

Percent of units planted that are not successfully sold. May be caused by disease, poor germination, speculation losses, etc

Close

Enter the amount of overhead costs (such as depreciation, interest, repairs, taxes, and insurance, and treating all labor as an overhead) that you allocate to each unit of plant product produced.

Close

Number of container units (such as 1-gallon equivalents) you assign to this container size when allocating overheads. For example, if you use 1-gallon equivalents, and this is a 1-gallon container, enter 1. If this is a 7-gallon equivalent, enter 7 or some value adjusted for its space use and production time.

Close

Only include royalties if included in sales price and not passed through to customer as separate charge

Close

Number of plants per unit

Close

Include pots, carrier trays, and tray or pot labels

Close

Include growing media costs

 

Please enter data to all the cells in the input tab

Direct cost
 
Overhead cost
 
Cost of losses
 
Total cost
 
Profit (Sales - Cost)
 
Profit margin (Profit/Sales)
 
Markup (Sales/Cost - 1)
 

Please enter data to all the cells in the input tab

Select a variable for your sensitivity analysis

 
% of
entered value
 
Profit ($)
per container
Profit
margin (%)
80
 
 
 
90
 
 
 
100
 
 
 
110
 
 
 
120