Geocortex Essentials Sites Directory

Home > Aquaculture > Search Tables > screenFields

Execute Search Table Search: screenFields (ID: screenFields)

Records: 339

Screen	Show	Field	FieldLabel	FieldCalVar	Section	UiType	FieldCategory	FieldClass	Unit	Default	Min	Max	Increment	Decimal	Formula	Description	Notes	ChartConfig
Start Here	All				startOverview	radiobutton										Text for the system selection!
Select System	All	SystemSelector		sysSelect	ssSystemSelect	radiobutton										Text for the system selection!
Summary	All	SummaryTable		sumTbl	sumTable
Summary	All	ANNUAL expense	ANNUAL expense	_annualExpense	sumOverview	calculated	InputCalculated	InputCalcExpense	$	0.1				0	annualExpenseWithOperatingLoan	The total annual sum of all operating expenses
Summary	All	ANNUAL revenue	ANNUAL revenue	_annualRevenue	sumOverview	calculated	InputCalculated	InputCalcRevenue	$	1500000				0	annualRevenue	The total annual revenue generated by the operation based on the annual production volume and the selected product price
Summary	All	ANNUAL Net Gain/Loss without Loan Financing	ANNUAL Net Gain/Loss without Loan Financing	_annualNetGainLoss	sumOverview	calculated	InputCalculated	InputCalcRevenue	$	1499999.9				0	annualNetGainLoss	The annual operating net gain or loss assuming there are no operating loans used to finance the operation
Summary	All	Gross Profit Margin Ratio (Profitability %)	Gross Profit Margin Ratio (Profitability %)	_grossProfitMarginRatio	sumOverview	calculated	InputCalculated	InputCalcRevenue	%	0.999999933333333				2	grossProfitMarginRatio	This is your profitability margin expressed in %. 0% means you are at breakeven. Negative numbers here are indications that the enterprise is not generating an operating profit.
Location	All	Map		map	locationMap	map
Transportation	All	Miles to market	Miles to market	marketDistanceOpts	transportationInputsCalc	dropdownLocations	Input		miles	10	0	1000		0	marketDistance	The distance from the production facility to the market of processing facility
Transportation	All	Miles to feed supply	Miles to feed supply	feedDistanceOpts	transportationInputsCalc	dropdownLocations	Input		miles	500	0	3000		0	feedDistance	The distance from the production facility to the feed mill that sources the feed supply
Production	Tilapia in RAS	Market size (lb)	Market size (lb)	marketSizeLbs	productionSection	dropdown	LookupTable		lbs	1	0	5	0.1	1	[lut:growthRate>Market Weight]	Select the size of your whole fish product at which you will sell it to the market
Production	Tilapia in RAS	Pounds/year	Target annual production	lbsYear	productionSection	slider	Input		lbs	500000	500	2000000	500	0		Select the size of your annual harvest
Production	Tilapia in RAS	Space required	Space required	spaceRequired	productionRequired	calculated	RequiredResource		sq ft	14803.932962963				0	systemWaterVolume0.133681/avgTankDepthspaceSizeRatio	The calculated space required for the RAS equipment based on the average tank depth, the surface area of the tanks based on the system water volume, and the space size ratio.
Production	Tilapia in RAS	Building required	Building required	buildingRequired	productionRequired	calculated	RequiredResource		sq ft	23316.1944166667				0	systemWaterVolume0.133681/3spaceSizeRatio*buildingSizeRatio	The calculated size of the building needed to house the system based on the production level
Production	Tilapia in RAS	Land required	Land required	landRequired	productionRequired	calculated	RequiredResource		acres	0.56075503647587				3	systemWaterVolume0.133681/3spaceSizeRatio*landSizeRatio/43560	The calculated amount of land required for the building used to house the system based on the production level
Production	Tilapia in RAS	New water required	New water required	dailyWaterRequired	productionRequired	calculated	RequiredResource		gal/minute	27				0	(systemWaterVolumereplacementWater)/(2460)	The calculated amount of water needed per day to replenish the system based on the system water volume and the assumed replacement water percentage
Production	Tilapia in RAS	Flow rate required	Flow rate required	flowRateRequired	productionRequired	calculated	RequiredResource		gal/minute	53.2407407407407				0	(systemWaterVolume/(refillTime*24))/60	The calculated amount of water needed to refill the system in an emergency situation based on the system water volume and the assumed refill time
Production	Tilapia in RAS	Total system water volume	Total system water volume	systemWaterVolume	productionRequired	calculated	RequiredResource		gallons	383333.333333333				0	productionWaterVolume*sysProdRatio	The calcuated volume of water in the system based on the production level and the assumed carrying capacity
Production	Tilapia in RAS	Harvests per year	Harvests per year	harvestsPerYear	productionRequired	calculated	RequiredResource		#	2				2	12/monthsToHarvest	The calculated number of harvests per year based on the selected market size of the product and the assumed growth rate
Production	Tilapia in RAS	Space available	Space available	spaceAvailable	productionRequired	slider	ExistingResource		sq ft		0	300000	100	0	[validate:spaceRequired]	Space available for the equipment in this production scenario
Production	Tilapia in RAS	Building available	Building available	buildingAvailable	productionRequired	slider	ExistingResource		sq ft		0	350000	100	0	[validate:buildingRequired]	Select the size of the building in which you will house the system
Production	Tilapia in RAS	Land available	Land available	landAvailable	productionRequired	slider	ExistingResource		acres		0	20	0.01	2	[validate:landRequired]	Select the amount of land you have available for the building housing the system
Production	Tilapia in RAS	New water available	New water available	dailyWaterAvailable	productionRequired	slider	ExistingResource		gal/minute		0	100	1	0	[validate:dailyWaterRequired]	Select the amount of water you have available to replenish the system water daily due to effluent and evaporation losses
Production	Tilapia in RAS	Max flow available	Max flow available	maxFlowAvailable	productionRequired	slider	ExistingResource		gal/minute		0	500	1	0	[validate:flowRateRequired]	Select the amount of water flow you have available for emergency refilling of the system due to a problem with water quality
Production	Tilapia in RAS	Average tank depth	Average tank depth	avgTankDepth	productionRequired	slider	ExistingResource		ft	4.5	1	10	0.5	1	1	Select the average tank depth you have available. Most RAS systems have an average grow-out tank depth of 4.5 ft.
Production	Tilapia in RAS	Months to harvest	Average months to harvest	monthsToHarvest	productionCalculations	calculated	Parameter		mos	6	0	12	0.1	1	[From DropDown for Market Weigth]	The assumed months required to grow the fish to the selected market size
Production	Tilapia in RAS	Harvest weight	Harvest weight	harvestWeight	productionCalculations	calculated	Parameter		lbs	250000				0	lbsYear/harvestsPerYear	The annual harvest divided by the number of harvests per year.
Production	Tilapia in RAS	Carrying capacity	Carrying capacity	carryingCapacity	productionCalculations	calculated	Parameter		lbs/gallon	0.75				2		The assumed ratio of the maximum amount of pounds of fish per gallon of water in the production grow-out tanks
Production	Tilapia in RAS	Production water volume	Production water volume	productionWaterVolume	productionCalculations	calculated	Parameter		gallons	333333.333333333				0	harvestWeight/carryingCapacity	The assumed volume of water in the grow-out tanks based on the system water volume and the assumed system/production ratio
Production	Tilapia in RAS	System / production ratio	System / production ratio	sysProdRatio	productionCalculations	calculated	Parameter		ratio	1.15				2		The ratio of total water in the system to the volume of water in the production grow-out tanks
Production	Tilapia in RAS	Replacement water	Replacement water	replacementWater	productionCalculations	calculated	Parameter		%	0.1				2		The percentage of system water volume per day that is discharged as effluent vs. treated and recirculated
Production	Tilapia in RAS	Refill time	Refill time	refillTime	productionCalculations	calculated	Parameter		days	5				0		The assumed time needed to refill the total system water volume in an emergency situation
Production	Tilapia in RAS	System water surface area	System water surface area	systemWaterSurfaceArea	productionCalculations	calculated	Parameter		sq ft	11387.6407407407				0	systemWaterVolume*0.133681/avgTankDepth	The total system water surface area is calculated as the system volume multiplied by 0.1333681 divided by the average tank depth
Production	Tilapia in RAS	Space size ratio	Space size ratio	spaceSizeRatio	productionCalculations	calculated	Parameter		ratio	1.3				1		The assumed ratio of the size of the footprint of all of the system equipment to the footprint of the water tanks based calculated from the system water volume with an assumed 4 foot tank depth
Production	Tilapia in RAS	Building size ratio	Building size ratio	buildingSizeRatio	productionCalculations	calculated	Parameter		ratio	1.05				2		The assumed ratio of the size of the building needed to house the system footprint to the system footprint to account for extra space for ancillary functions such as storage and ingress/egress
Production	Tilapia in RAS	Land size ratio	Land size ratio	landSizeRatio	productionCalculations	calculated	Parameter		ratio	1.1				4		The assumed ratio of the size of the parcel of land needed to accomodate the production building to the size of the production building to accomodate parking and zoning considerations
Startup	Tilapia in RAS	Cost of land per acre	Cost of land per acre	landCostAcre	startupSection	slider	Input		$	2500	0	50000	500	0		Estimated land cost per acre if needing to purchase land
Startup	Tilapia in RAS	Building cost	Building cost	buildingCost	startupSection	slider	Input		$	100000	0	2000000	1000	0		Building cost if you are buying your building
Startup	Tilapia in RAS	Water supply cost	Water supply cost	waterSupplyCost	startupSection	slider	Input		$	20000	0	100000	1000	0		Costs of construction related to bringing a water supply to the production buidling (e.g. digging a well and piping)
Startup	Tilapia in RAS	One-time startup permitting cost	One-time startup permitting cost	permittingCost	startupSection	slider	Input		$	25000	0	100000	1000	0		Permitting cost for construction, environmental prior to start of operations.
Startup	Tilapia in RAS	Additional startup costs	Additional startup costs	miscCost	startupSection	slider	Input		$	0	0	20000	100	0		Special startup costs unique to your location (e.g. building a storage shed, unusual infrastructure costs)
Startup	Tilapia in RAS	Equipment cost ratio	Equipment cost ratio	equipmentCostRatio	startupCalculations	calculated	Parameter		$/lb	1.5				1		The assumed cost ratio of system equipment (tanks, pumps, filtration, etc.) as a function of the annual production weight
Startup	Tilapia in RAS	Engineering / construction cost ratio	Engineering / construction cost ratio	engineeringCostRatio	startupCalculations	calculated	Parameter		$/lb	0.84				2		The assumed cost of engineering and construction to build the production facility as a function of the selected annual production weight
Startup	Tilapia in RAS	Other startup cost ratio	Other startup cost ratio	otherStartupCostRatio	startupCalculations	calculated	Parameter		$/lb	0.25				2		The assumed startup costs (e.g. pre-launch labor, training, system testing, pre-launch marketing, supply chain selection) to get the operation up and running
Startup	Tilapia in RAS	Land cost	Land cost	landCost	startupSection	calculated	InputCalculated		$	1401.88759118967	0	2000000	1000	0	landRequired*landCostAcre	Land cost if you are buying your land
Startup	Tilapia in RAS	Equipment cost	Equipment cost	equipmentCost	startupSection	calculated	InputCalculated		$	750000				0	lbsYear*equipmentCostRatio	The calculated equipment cost based on the selected production level and the assumed equipment cost ratio
Startup	Tilapia in RAS	Engineering / construction cost	Engineering / construction cost	engineeringCost	startupSection	calculated	InputCalculated		$	420000				0	lbsYear*engineeringCostRatio	The calculated engineering/construction cost based on the selected production level and the assumed engineering/construction cost ratio
Startup	Tilapia in RAS	Other startup costs	Other startup costs	otherStartupCost	startupSection	calculated	InputCalculated		$	125000				0	lbsYear*otherStartupCostRatio	Other types of start up production costs which may be proportional to facility size and production levels could include public relations, pre-launch marketing, additional required labor, learning costs, and initial crop failures.
Startup	Tilapia in RAS	TOTAL startup cost	TOTAL startup cost	totalStartupCost	startupSection	calculated	InputCalculated	InputCalcTotal	$	1441401.88759119				0	landCost+buildingCost+waterSupplyCost+miscCost+equipmentCost+engineeringCost+otherStartupCost+permittingCost	The sum of all startup costs to get the operation ready to begin growing the first harvest
Operating	Tilapia in RAS	Product price	Product price	productPrice	operatingSection	slider	Input		$	3	0	10	0.25	2		The planned price per pound at which you will sell your product
Operating	Tilapia in RAS	Lease	Lease	leaseMonth	operatingSection	slider	Input		$/month	1000	0	10000	100	0		Rent or lease per month if you do not own the land and building
Operating	Tilapia in RAS	Feed price	Feed price	feedPrice	operatingSection	slider	Input		$/lb	0.5	0	5	0.25	2		Price per pound of fish feed
Operating	Tilapia in RAS	Seed price	Seed price	seedPrice	operatingSection	slider	Input		$/unit	0.35	0	5	0.05	2		Price of seedlings or fingerlings per unit.
Operating	Tilapia in RAS	Water treatment cost	Water treatment cost	waterTreatmentCost	operatingSection	slider	Input		$/gal/day	0.05	0	1	0.01	2		Cost per gallon per day to treat effluent.
Operating	Tilapia in RAS	Water price	Water price	waterPrice	operatingSection	slider	Input		$/acre-foot	70	0	200	1	0		Price of water per gallon
Operating	Tilapia in RAS	Contingency	Contingency	contingencyCost	operatingSection	slider	Input		%	0.1	0	50	0.01	2		Contingency expense as a % of all other monthly expenses.
Operating	Tilapia in RAS	Overhead expense per month	Overhead expense per month	overheadExpenseMonth	operatingSection	calculated	InputCalculated		$	4166.66666666667				0	overheadRatio*lbsYear/monthsToHarvest	The calculated overhead (management, adminstration, marketing etc.) expense per month based on the selected production level
Operating	Tilapia in RAS	Labor expense per month	Labor expense per month	laborExpenseMonth	operatingSection	calculated	InputCalculated		$	12083.3333333333				0	laborExpenseHarvest/monthsToHarvest	The calculated labor costs for production based on the selected production level and the assumed labor cost per pound of production
Operating	Tilapia in RAS	Feed expense per month	Feed expense per month	feedExpenseMonth	operatingSection	calculated	InputCalculated		$	27083.3333333333				0	feedPricefeedConversionRatioharvestWeight/monthsToHarvest	The calculated monthly cost of feed based on the annual production, the assumed feed conversion ratio, and the selected feed price
Operating	Tilapia in RAS	Seed expense per month	Seed expense per month	seedExpenseMonth	operatingSection	calculated	InputCalculated		$	16041.6666666667				0	harvestWeight/marketSizeLbs(1+mortalityRate)seedPrice/monthsToHarvest	The calculated monthly cost of seed based on the annual production, the assumed mortality rate, and the selected seed price
Operating	Tilapia in RAS	Water expense per month	Water expense per month	waterExpenseMonth	operatingSection	calculated	InputCalculated		$	251				0	dailyWaterRequired602430/325821waterPrice	The calculated cost of water per month based on the new water required per day x 30 days per month x the water price.
Operating	Tilapia in RAS	Water treatment expense per month	Water treatment expense per month	waterTreatmentExpenseMonth	operatingSection	calculated	InputCalculated		$	57500				0	systemWaterVolumereplacementWaterwaterTreatmentCost*30	Monthly expense for water treatment based on system water volume, replacement water %, and cost per gallon per day.
Operating	Tilapia in RAS	Oxygenation expense per month	Oxygenation expense per month	oxygenationExpenseMonth	operatingSection	calculated	InputCalculated		$	2083.33333333333				0	lbsYear*oxygenationExpenseRatio/12	Expense per month for oxygenation.
Operating	Tilapia in RAS	Energy expense per month	Energy expense per month	energyExpenseMonth	operatingSection	calculated	InputCalculated		$	14605.7103356417				0	(((12.338buildingRequired)+4439)/12)0.6	Energy expense per month based on an energy model for this type of facility in the Oregon climate and maintaining the operating temperature that is optimal for this species.
Operating	Tilapia in RAS	Supplies/Misc expense per month	Supplies/Misc expense per month	suppliesMiscExpenseMonth	operatingSection	calculated	InputCalculated		$	8333.33333333333				0	suppliesMiscRatio*lbsYear/monthsToHarvest	The calculated monthly expenses for supplies and miscellaneous cost based on the production level and assumed supplies/misc ratio
Operating	Tilapia in RAS	Transportation expense per month	Transportation expense per month	transportationExpenseMonth	operatingSection	calculated	InputCalculated		$	740				0	totTransportCost/12	The calcuated monthlly transportation costs for sourcing feed and shipping fish to market
Operating	Tilapia in RAS	Contingency expense per month	Contingency expense per month	contingencyExpenseMonth	operatingSection	calculated	InputCalculated		$	14388.8377002308					monthlyExpense*contingencyCost	The monthly expense contingency.
Operating	Tilapia in RAS	Total MONTHLY expense without contingency	Total MONTHLY expense without contingency	monthlyExpense	operatingSection	calculated	InputCalculated		$	143888.377002308				0	leaseMonth+laborExpenseMonth+feedExpenseMonth+seedExpenseMonth+waterExpenseMonth+waterTreatmentExpenseMonth+energyExpenseMonth+suppliesMiscExpenseMonth+overheadExpenseMonth+transportationExpenseMonth+oxygenationExpenseMonth+transportationExpenseMonth	The sum of all monthly operating expenses except the Contingency and Operating loan expenses.
Operating	Tilapia in RAS	ANNUAL expense prior to operating loan	ANNUAL expense prior to operating loan	annualExpenseNoOperatingLoan	operatingSection	calculated	InputCalculated	InputCalcExpense	$	1899326.57643047				0	(monthlyExpense12)+(contingencyExpenseMonth12)	The annual operting expenses prior to calculating operating loan expenses.
Operating	Tilapia in RAS	Operating loan interest rate	Operating loan interest rate	operatingLoanRate	operatingSection	slider	Input		%	0.06	0	0.15	0.001	3		The interest rate on the annual operating loan.
Operating	Tilapia in RAS	Operating loan annual expense	Operating loan annual expense	operatingLoanAnnualExpense	operatingSection	calculated	InputCalculated		$	91167.6756686625				0	annualExpenseNoOperatingLoanoperatingLoanRate.8	The annual loan expense based on an operating loan for 80% of annual expenses.
Operating	Tilapia in RAS	ANNUAL expense including operating loan	ANNUAL expense including operating loan	annualExpenseWithOperatingLoan	operatingSection	calculated	InputCalculated	InputCalcExpense	$	1990494.25209913				0	annualExpenseNoOperatingLoan+operatingLoanAnnualExpense	The annual expenses for all operating expenses including the interest expense on the Operating Loan.
Operating	Tilapia in RAS	ANNUAL revenue	ANNUAL revenue	annualRevenue	operatingSection	calculated	InputCalculated	InputCalcRevenue	$	1500000				0	productPrice*lbsYear	The annual revenue based on the selected annual harvest size and the selected price per pound of the fish being sold
Operating	Tilapia in RAS	ANNUAL Net Gain/Loss without Startup Loan Financing	ANNUAL Net Gain/Loss without Startup Loan Financing	annualNetGainLoss	operatingSection	calculated	InputCalculated	InputCalcRevenue	$	-490494.252099132				0	annualRevenue-annualExpenseWithOperatingLoan	The operating gain or loss after subtracting annual expenses from annual revenue
Operating	Tilapia in RAS	Gross Profit Margin Ratio (Profitability %)	Gross Profit Margin Ratio (Profitability %)	grossProfitMarginRatio	operatingSection	calculated	InputCalculated	InputCalcRevenue	%	-0.326996168066088				2	annualNetGainLoss/annualRevenue	This figure REPRESENTS AVERAGE ANNUAL PROFITABILITY compared to revenue. 0% means THE OPERATOR IS at breakeven. Negative numbers indicate the operation is LOSING MONEY.
Operating	Tilapia in RAS	Labor expense per pound	Labor expense per pound	laborExpenseLb	operatingCalculations	calculated	Parameter		$	0.29				2	(-0.092)*Math.log(lbsYear)+1.4939	The assumed labor expense per pound of fish produced based on a logarithmic formula that approximates the economies of scale that result as annual production levels increase
Operating	Tilapia in RAS	Labor expense per harvest	Labor expense per harvest	laborExpenseHarvest	operatingCalculations	calculated	Parameter		$	72500				0	harvestWeight*laborExpenseLb	The assumed labor expense for a given harvest size
Operating	Tilapia in RAS	Feed conversion ratio (FCR)	Feed conversion ratio (FCR)	feedConversionRatio	operatingCalculations	calculated	Parameter		ratio	1.3				1		The assumed ratio of of pounds of feed required to produce one pound of fish
Operating	Tilapia in RAS	Oxygenation expense ratio	Oxygenation expense ratio	oxygenationExpenseRatio	operatingCalculations	calculated	Parameter		ratio	0.05				2		Cost per pound of harvested fish for oxygenation.
Operating	Tilapia in RAS	Mortality rate	Mortality rate	mortalityRate	operatingCalculations	calculated	Parameter		%	0.1				2		The assumed percentage of initially stocked juveniles that do not live to be harvested
Operating	Tilapia in RAS	Supplies/Misc ratio	Supplies/Misc ratio	suppliesMiscRatio	operatingCalculations	calculated	Parameter		$/lb	0.1				2		The assumed expense of supplies and miscellaneous materials per pound of fish produced
Operating	Tilapia in RAS	Overhead ratio	Overhead ratio	overheadRatio	operatingCalculations	calculated	Parameter		$/lb	0.05				2		The assumed expense of overhead expenses per pound of fish produced
Transportation	Tilapia in RAS	OTHER Transportation cost	OTHER Transportation cost	otherTransportCost	transportationInputsCalc	slider	Input		$	0	0	50000	500	0		Other costs incurred for transportation (e.g. seed transporation, hired driver, rental truck, additional mileage costs)
Transportation	Tilapia in RAS	Distance to market	Miles to market	marketDistance	transportationInputsCalc	none	InputCalculated		miles	10	0	10000	1	1		The distance from the production facility to the market of processing facility
Transportation	Tilapia in RAS	Distance to feed	Distance to feed	feedDistance	transportationInputsCalc	none	InputCalculated		miles	20	0	10000	1	1		The distance from the production facility to the feed mill that sources the feed supply
Transportation	Tilapia in RAS	Product pounds	Product pounds	productPounds	transportationInputsCalc	calculated	InputCalculated		lbs	500000				0	lbsYear	The selected annual production
Transportation	Tilapia in RAS	Product pounds plus ice	Product pounds plus ice	productPoundsIce	transportationInputsCalc	calculated	InputCalculated		lbs	750000				0	productPounds*1.5	The weight of the selected annual production plus 50% of that weight to account for the weight of ice during shipment of product to market
Transportation	Tilapia in RAS	Feed Pounds	Feed pounds	feedPounds	transportationInputsCalc	calculated	InputCalculated		lbs	650000	0	100000	500	0	feedConversionRatio*lbsYear	The calculated annual weight of feed based on the selected annual production and the assumed feed conversion ratio
Transportation	Tilapia in RAS	Total feed product shipping cost	Total feed product shipping cost	feedTransportCost	transportationInputsCalc	calculated	InputCalculated		$	6110				0	feedLbTransportCostfeedPounds/2000feedDistance	The calculated annual cost of transportation for shipping from the feed mill to the production facility
Transportation	Tilapia in RAS	Product to market transportation cost	Total product shipping cost	marketTransportCost	transportationInputsCalc	calculated	InputCalculated		$	2775				0	marketLbTransportCostproductPoundsIce/2000marketDistance	The calculated annual cost of transportation for shipping product from the production facility to market
Transportation	Tilapia in RAS	Total Transportation cost	Total Transportation cost	totTransportCost	transportationInputsCalc	calculated	InputCalculated	InputCalcTotal	$	8885				0	feedTransportCost+marketTransportCost+otherTransportCost	The sum of all annual transportation costs
Transportation	Tilapia in RAS	Feed shipping cost per ton mile	Feed shipping cost per ton mile	feedLbTransportCost	transportationParams	calculated	Parameter Fixed		$/ton-mile	0.94				2		The calculated cost to ship a ton of feed a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.
Transportation	Tilapia in RAS	Product shipping cost per ton mile	Product shipping cost per ton mile	marketLbTransportCost	transportationParams	calculated	Parameter Fixed		$/ton-mile	0.74				2		The calculated cost to ship a ton of product a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.
Financing	Tilapia in RAS	Input: % funded with debt	Loan %	percFundedDebt	financingSection	slider	Input		%	0.8	0	1	0.01	2	1-percFundedEquity	The percentage of startup costs expected to be funded by loans
Financing	Tilapia in RAS	Input: % funded with equity	Equity %	percFundedEquity	financingSection	slider	Input		%	0.2	0	1	0.01	2	1-percFundedDebt	The percentage of startup costs expected to be funded by the owner or investor equity
Financing	Tilapia in RAS	Input: Loan Interest rate	Loan Interest rate	loanIntRate	financingSection	slider	Input		%	0.06	0	0.2	0.0025	4		Loan interest rate expected on any loan to cover startup costs
Financing	Tilapia in RAS	Input: Term of loan	Term of loan in years	termOfLoan	financingSection	slider	Input		years	10	0	30	1	0		Expected term of any loan to cover startup costs
Financing	Tilapia in RAS	Total start up cost	Total start up cost	totStartupCosts2	financingSection	calculated	InputCalculated		$	1441401.88759119				0	totalStartupCost	The sum of all startup costs to get the operation ready to begin growing the first harvest
Financing	Tilapia in RAS	% funded with equity	% funded with equity	_percFundedEquity	financingSection	calculated	InputCalculated		%	0.9				2	percFundedEquity	The percentage of startup costs expected to be funded by the owner or investor equity
Financing	Tilapia in RAS	% funded with debt	% funded with debt	_percFundedDebt	financingSection	calculated	InputCalculated		%	0.1				2	percFundedDebt	The percentage of startup costs expected to be funded by loans
Financing	Tilapia in RAS	Equity investment required	Equity investment required	equityInvestReq	financingSection	calculated	InputCalculated		$	288280.377518238				0	totalStartupCost*percFundedEquity	The amount of equity investment required based on the total startup costs and the selected percentage of the project funded with equity
Financing	Tilapia in RAS	Loan amount required	Loan amount required	loanAmountReq	financingSection	calculated	InputCalculated		$	1153121.51007295				0	totalStartupCost-equityInvestReq	The amount of the loan required based on the total startup costs and the selected percentage of the project funded with debt
Financing	Tilapia in RAS	Loan Interest rate	Loan Interest rate	_loanIntRate	financingSection	calculated	InputCalculated		%	0.06				4	loanIntRate	Loan interest rate expected on any loan to cover startup costs
Financing	Tilapia in RAS	Term of loan	Term of loan	_termOfLoan	financingSection	calculated	InputCalculated		years	10				0	termOfLoan	Expected term of any loan to cover startup costs
Financing	Tilapia in RAS	Monthly loan payment	MONTHLY loan payment	monthlyLoanPayment	financingSection	calculated	InputCalculated	InputCalcTotal	$					0	annualLoanPayment/12	The calculated monthly loan payment to retire the startup loan based on the size, term, and interest rate of the loan
Financing	Tilapia in RAS	Annual loan payments	ANNUAL loan expense	annualLoanPayment	financingSection	calculated	InputCalculated	InputCalculated	$					0		The calculated annual debt service to retire the startup loan based on the size, term, and interest rate of the loan
Financing	Tilapia in RAS	ANNUAL Net Gain/Loss with Loan Financing	ANNUAL Net Gain/Loss with Loan Financing	annualNetGainLossLoan	financingSection	calculated	InputCalculated	InputCalcRevenue	$	-490494.252099132				0	annualNetGainLoss-annualLoanPayment	The operating gain or loss after subtracting annual expenses, including debt service for the startup loan, from annual revenue
Financing	All				financingAmortization	calculated
Financial Summary	Tilapia in RAS	Feed	Feed	feedExpense	annualOperatingExpenses	calculated	Input		$	325000				0	feedExpenseMonth*12
Financial Summary	Tilapia in RAS	Seed	Seed	seedExpense	annualOperatingExpenses	calculated	Input		$	192500				0	seedExpenseMonth*12
Financial Summary	Tilapia in RAS	Water	Water	waterExpense	annualOperatingExpenses	calculated	Input		$	3012				0	waterExpenseMonth*12
Financial Summary	Tilapia in RAS	Water Treatment	Water Treatment	waterTreatmentExpense	annualOperatingExpenses	calculated	Input		$	690000				0	waterTreatmentExpenseMonth*12
Financial Summary	Tilapia in RAS	Oxygenation	Oxygenation	oxygenationExpense	annualOperatingExpenses	calculated	Input		$	25000				0	oxygenationExpenseMonth*12
Financial Summary	Tilapia in RAS	Energy	Energy	energyExpense	annualOperatingExpenses	calculated	Input		$	175268.5240277				0	energyExpenseMonth*12
Financial Summary	Tilapia in RAS	Labor	Labor	laborExpense	annualOperatingExpenses	calculated	Input		$	145000				0	laborExpenseMonth*12
Financial Summary	Tilapia in RAS	Supplies & Misc	Supplies & Misc	suppliesMiscExpense	annualOperatingExpenses	calculated	Input		$	100000				0	suppliesMiscExpenseMonth*12
Financial Summary	Tilapia in RAS	Transportation	Transportation	transportationExpense	annualOperatingExpenses	calculated	Input		$	8885				0	totTransportCost
Financial Summary	Tilapia in RAS	Overhead	Overhead	overheadExpense	annualOperatingExpenses	calculated	Input		$	50000				0	overheadExpenseMonth*12
Financial Summary	Tilapia in RAS	Contingency	Contingency	contingencyExpense	annualOperatingExpenses	calculated	Input		$	172666.05240277				0	contingencyExpenseMonth*12
Financial Summary	Tilapia in RAS	Operating Loan	Operating Loan	operatingLoanExpense	annualOperatingExpenses	calculated	Input		$	91167.6756686625				0	operatingLoanAnnualExpense
Financial Summary	Tilapia in RAS	Startup Loan	Startup Loan	loanExpense	annualOperatingExpenses	calculated	Input		$	0.2				0	annualLoanPayment
Financial Summary	Tilapia in RAS	CHART: Annual Operating Expenses Without Startup Loan	CHART: Annual Operating Expenses Without Startup Loan	chartAnnualOperExp	annualOperatingExpensesChart	chart	Chart											yrOperExpChart
Financial Summary	Tilapia in RAS	CHART: Annual Operating Expenses With Startup Loan	CHART: Annual Operating Expenses With Startup Loan	chartAnnualOperExpWLoan	annualOperatingExpensesChartWLoan	chart	Chart											yrOperExpWLoanChart
Financial Summary	Tilapia in RAS	CHART: Start up costs	CHART: Start up costs	chartStartupCosts	startupCostsChart	chart	Chart											startUpCosts
Production	Sturgeon in RAS	Market size (lb)	Market size (lb)	marketSizeLbs	productionSection	dropdown	LookupTable		lbs	6	0	12	0.1	1	[lut:growthRate>Market Weight]	Select the size of your whole fish product at which you will sell it to the market
Production	Sturgeon in RAS	Pounds/year	Target annual production	lbsYear	productionSection	slider	Input		lbs	500000	500	5000000	500	0		Select the size of your annual harvest
Production	Sturgeon in RAS	Space required	Space required	spaceRequired	productionRequired	calculated	RequiredResource		sq ft	74019.6648148148				0	systemWaterVolume0.133681/avgTankDepthspaceSizeRatio	The calculated space required for the RAS equipment based on the average tank depth, the surface area of the tanks based on the system water volume, and the space size ratio.
Production	Sturgeon in RAS	Building required	Building required	buildingRequired	productionRequired	calculated	RequiredResource		sq ft	116580.972083333				0	systemWaterVolume0.133681/3spaceSizeRatio*buildingSizeRatio	The calculated size of the building needed to house the system based on the production level
Production	Sturgeon in RAS	Land required	Land required	landRequired	productionRequired	calculated	RequiredResource		acres	2.80377518237935				3	systemWaterVolume0.133681/3spaceSizeRatio*landSizeRatio/43560	The calculated amount of land required for the building used to house the system based on the production level
Production	Sturgeon in RAS	New water required	New water required	dailyWaterRequired	productionRequired	calculated	RequiredResource		gal/minute	39.9305555555556				0	(systemWaterVolumereplacementWater)/(2460)	The calculated amount of required new water per minute based on the replacement water % and the system water volume.
Production	Sturgeon in RAS	Flow rate required	Flow rate required	flowRateRequired	productionRequired	calculated	RequiredResource		gal/minute	665.509259259259				0	systemWaterVolume/refillTime	The calculated amount of water needed to refill the system in an emergency situation based on the system water volume and the assumed refill time
Production	Sturgeon in RAS	Total system water volume	Total system water volume	systemWaterVolume	productionRequired	calculated	RequiredResource		gallons	1916666.66666667				0	productionWaterVolume*sysProdRatio	The calcuated volume of water in the system based on the production level and the assumed carrying capacity
Production	Sturgeon in RAS	Harvests per year	Harvests per year	harvestsPerYear	productionRequired	calculated	RequiredResource		#	0.6				2	12/monthsToHarvest	The calculated number of harvests per year based on the selected market size of the product and the assumed growth rate
Production	Sturgeon in RAS	Space available	Space available	spaceAvailable	productionRequired	slider	ExistingResource		sq ft		0	1500000	1000	0	[validate:spaceRequired]	Space available for the equipment in this production scenario
Production	Sturgeon in RAS	Building available	Building available	buildingAvailable	productionRequired	slider	ExistingResource		sq ft		0	1500000	1000	0	[validate:buildingRequired]	Select the size of the building in which you will house the system
Production	Sturgeon in RAS	Land available	Land available	landAvailable	productionRequired	slider	ExistingResource		acres		0	50	0.1	2	[validate:landRequired]	Select the amount of land you have available for the building housing the system
Production	Sturgeon in RAS	New water available	New water available	dailyWaterAvailable	productionRequired	slider	ExistingResource		gal/minute		0	100	1	0	[validate:dailyWaterRequired]	Select the amount of water you have available to replenish the system water daily due to effluent and evaporation losses
Production	Sturgeon in RAS	Max flow available	Max flow available	maxFlowAvailable	productionRequired	slider	ExistingResource		gal/minute		0	500	1	0	[validate:flowRateRequired]	Select the amount of water flow you have available for emergency refilling of the system due to a problem with water quality
Production	Sturgeon in RAS	Average tank depth	Average tank depth	avgTankDepth	productionRequired	slider	ExistingResource		ft	4.5	1	10	0.5	1	1	Select the average tank depth you have available. Most RAS systems have an average grow-out tank depth of 4.5 ft.
Production	Sturgeon in RAS	Months to harvest	Average months to harvest	monthsToHarvest	productionCalculations	calculated	Parameter		mos	20	0	27	1	0	[From DropDown for Market Weigth]	The assumed months required to grow the fish to the selected market size
Production	Sturgeon in RAS	Harvest weight	Harvest weight	harvestWeight	productionCalculations	calculated	Parameter		lbs	833333.333333333				0	lbsYear/harvestsPerYear	The annual harvest divided by the number of harvests per year.
Production	Sturgeon in RAS	Carrying capacity	Carrying capacity	carryingCapacity	productionCalculations	calculated	Parameter		lbs/gallon	0.5				2		The assumed ratio of the maximum amount of pounds of fish per gallon of water in the production grow-out tanks
Production	Sturgeon in RAS	Production water volume	Production water volume	productionWaterVolume	productionCalculations	calculated	Parameter		gallons	1666666.66666667				0	harvestWeight/carryingCapacity	The assumed volume of water in the grow-out tanks based on the system water volume and the assumed system/production ratio
Production	Sturgeon in RAS	System / production ratio	System / production ratio	sysProdRatio	productionCalculations	calculated	Parameter		ratio	1.15				2		The ratio of total water in the system to the volume of water in the production grow-out tanks
Production	Sturgeon in RAS	Replacement water	Replacement water	replacementWater	productionCalculations	calculated	Parameter		%	0.03				2		The percentage of system water volume per day that is discharged as effluent vs. treated and recirculated
Production	Sturgeon in RAS	Refill time	Refill time	refillTime	productionCalculations	calculated	Parameter		days	2				0		The expert assumption for the time required to refill the system in the event of an emergency water quality problem.
Production	Sturgeon in RAS	System water surface area	System water surface area	systemWaterSurfaceArea	productionCalculations	calculated	Parameter		sq ft	56938.2037037037				0	systemWaterVolume*0.133681/avgTankDepth	The total system water surface area is calculated as the system volume multiplied by 0.1333681 divided by the average tank depth
Production	Sturgeon in RAS	Space size ratio	Space size ratio	spaceSizeRatio	productionCalculations	calculated	Parameter		ratio	1.3				1		The assumed ratio of the size of the footprint of all of the system equipment to the footprint of the water tanks based calculated from the system water volume with an assumed 4 foot tank depth
Production	Sturgeon in RAS	Building size ratio	Building size ratio	buildingSizeRatio	productionCalculations	calculated	Parameter		ratio	1.05				2		The assumed ratio of the size of the building needed to house the system footprint to the system footprint to account for extra space for ancillary functions such as storage and ingress/egress
Production	Sturgeon in RAS	Land size ratio	Land size ratio	landSizeRatio	productionCalculations	calculated	Parameter		ratio	1.1				4		The assumed ratio of the size of the parcel of land needed to accomodate the production building to the size of the production building to accomodate parking and zoning considerations
Startup	Sturgeon in RAS	Cost of land per acre	Cost of land per acre	landCostAcre	startupSection	slider	Input		$	2500	0	50000	500	0		Estimated land cost per acre if needing to purchase land
Startup	Sturgeon in RAS	Building cost	Building cost	buildingCost	startupSection	slider	Input		$	100000	0	2000000	1000	0		Building cost if you are buying your building
Startup	Sturgeon in RAS	Water supply cost	Water supply cost	waterSupplyCost	startupSection	slider	Input		$	20000	0	100000	1000	0		Costs of construction related to bringing a water supply to the production buidling (e.g. digging a well and piping)
Startup	Sturgeon in RAS	One-time startup permitting cost	One-time startup permitting cost	permittingCost	startupSection	slider	Input		$	25000	0	100000	1000	0		Permitting cost for construction, environmental prior to start of operations.
Startup	Sturgeon in RAS	Additional startup costs	Additional startup costs	miscCost	startupSection	slider	Input		$	0	0	20000	100	0		Special startup costs unique to your location (e.g. building a storage shed, unusual infrastructure costs)
Startup	Sturgeon in RAS	Equipment cost ratio	Equipment cost ratio	equipmentCostRatio	startupCalculations	calculated	Parameter		$/lb	1.5				1		The assumed cost ratio of system equipment (tanks, pumps, filtration, etc.) as a function of the annual production weight
Startup	Sturgeon in RAS	Engineering / construction cost ratio	Engineering / construction cost ratio	engineeringCostRatio	startupCalculations	calculated	Parameter		$/lb	0.84				2		The assumed cost of engineering and construction to build the production facility as a function of the selected annual production weight
Startup	Sturgeon in RAS	Other startup cost ratio	Other startup cost ratio	otherStartupCostRatio	startupCalculations	calculated	Parameter		$/lb	0.25				2		The assumed startup costs (e.g. pre-launch labor, training, system testing, pre-launch marketing, supply chain selection) to get the operation up and running
Startup	Sturgeon in RAS	Land cost	Land cost	landCost	startupSection	calculated	InputCalculated		$	7009.43795594837	0	2000000	1000	0	landRequired*landCostAcre	Land cost if you are buying your land
Startup	Sturgeon in RAS	Equipment cost	Equipment cost	equipmentCost	startupSection	calculated	InputCalculated		$	750000				0	lbsYear*equipmentCostRatio	The calculated equipment cost based on the selected production level and the assumed equipment cost ratio
Startup	Sturgeon in RAS	Engineering / construction cost	Engineering / construction cost	engineeringCost	startupSection	calculated	InputCalculated		$	420000				0	lbsYear*engineeringCostRatio	The calculated engineering/construction cost based on the selected production level and the assumed engineering/construction cost ratio
Startup	Sturgeon in RAS	Other startup costs	Other startup costs	otherStartupCost	startupSection	calculated	InputCalculated		$	125000				0	lbsYear*otherStartupCostRatio	Other types of start up production costs which may be proportional to facility size and production levels could include public relations, pre-launch marketing, additional required labor, learning costs, and initial crop failures.
Startup	Sturgeon in RAS	TOTAL startup cost	TOTAL startup cost	totalStartupCost	startupSection	calculated	InputCalculated	InputCalcTotal	$	1447009.43795595				0	landCost+buildingCost+waterSupplyCost+miscCost+equipmentCost+engineeringCost+otherStartupCost+permittingCost	The sum of all startup costs to get the operation ready to begin growing the first harvest
Operating	Sturgeon in RAS	Product price	Product price	productPrice	operatingSection	slider	Input		$	6	0	35	0.25	2		The planned price per pound at which you will sell your product
Operating	Sturgeon in RAS	Lease	Lease	leaseMonth	operatingSection	slider	Input		$/month	1000	0	10000	100	0		Rent or lease per month if you do not own the land and building
Operating	Sturgeon in RAS	Feed price	Feed price	feedPrice	operatingSection	slider	Input		$/lb	0.55	0	5	0.25	2		Price per pound of fish feed
Operating	Sturgeon in RAS	Seed price	Seed price	seedPrice	operatingSection	slider	Input		$/unit	0.75	0	5	0.05	2		Price of seedlings or fingerlings per unit.
Operating	Sturgeon in RAS	Water treatment cost	Water treatment cost	waterTreatmentCost	operatingSection	slider	Input		$/gal/day	0.05	0	1	0.01	2		Cost per gallon per day to treat effluent.
Operating	Sturgeon in RAS	Water price	Water price	waterPrice	operatingSection	slider	Input		$/acre-foot	70	0	200	1	0		Price of water per gallon
Operating	Sturgeon in RAS	Contingency	Contingency	contingencyCost	operatingSection	slider	Input		%	0.1	0	50	0.01	2		Contingency expense as a % of all other monthly expenses.
Operating	Sturgeon in RAS	Overhead expense per month	Overhead expense per month	overheadExpenseMonth	operatingSection	calculated	InputCalculated		$	1250				0	overheadRatio*lbsYear/monthsToHarvest	The calculated overhead (management, adminstration, marketing etc.) expense per month based on the selected production level
Operating	Sturgeon in RAS	Labor expense per month	Labor expense per month	laborExpenseMonth	operatingSection	calculated	InputCalculated		$	11943.4403866167				0	laborExpenseHarvest/monthsToHarvest	The calculated labor costs for production based on the selected production level and the assumed labor cost per pound of production
Operating	Sturgeon in RAS	Feed expense per month	Feed expense per month	feedExpenseMonth	operatingSection	calculated	InputCalculated		$	41250				0	feedPricefeedConversionRatioharvestWeight/monthsToHarvest	The calculated monthly cost of feed based on the annual production, the assumed feed conversion ratio, and the selected feed price
Operating	Sturgeon in RAS	Seed expense per month	Seed expense per month	seedExpenseMonth	operatingSection	calculated	InputCalculated		$	6510.41666666667				0	harvestWeight/marketSizeLbs(1+mortalityRate)seedPrice/monthsToHarvest	The calculated monthly cost of seed based on the annual production, the assumed mortality rate, and the selected seed price
Operating	Sturgeon in RAS	Water expense per month	Water expense per month	waterExpenseMonth	operatingSection	calculated	InputCalculated		$	370.602263205871				0	dailyWaterRequired602430/325821waterPrice	The calculated cost of water per month based on the new water required per day x 30 days per month x the water price.
Operating	Sturgeon in RAS	Water treatment expense per month	Water treatment expense per month	waterTreatmentExpenseMonth	operatingSection	calculated	InputCalculated		$	86250				0	systemWaterVolumereplacementWaterwaterTreatmentCost*30	Monthly expense for water treatment based on system water volume, replacement water %, and cost per gallon per day.
Operating	Sturgeon in RAS	Oxygenation expense per month	Oxygenation expense per month	oxygenationExpenseMonth	operatingSection	calculated	InputCalculated		$	2083.33333333333				0	lbsYear*oxygenationExpenseRatio/12	Expense per month for oxygenation.
Operating	Sturgeon in RAS	Energy expense per month	Energy expense per month	energyExpenseMonth	operatingSection	calculated	InputCalculated		$	72140.7516782083				0	(((12.338buildingRequired)+4439)/12)0.6	Energy expense per month based on an energy model for this type of facility in the Oregon climate and maintaining the operating temperature that is optimal for this species.
Operating	Sturgeon in RAS	Supplies/Misc expense per month	Supplies/Misc expense per month	suppliesMiscExpenseMonth	operatingSection	calculated	InputCalculated		$	2500				0	suppliesMiscRatio*lbsYear/monthsToHarvest	The calculated monthly expenses for supplies and miscellaneous cost based on the production level and assumed supplies/misc ratio
Operating	Sturgeon in RAS	Transportation expense per month	Transportation expense per month	transportationExpenseMonth	operatingSection	calculated	InputCalculated		$	17512.5				0	totTransportCost/12	The calcuated monthlly transportation costs for sourcing feed and shipping fish to market
Operating	Sturgeon in RAS	Contingency expense per month	Contingency expense per month	contingencyExpenseMonth	operatingSection	calculated	InputCalculated		$	24281.1044328031					monthlyExpense*contingencyCost	The monthly expense contingency.
Operating	Sturgeon in RAS	Total MONTHLY expense without contingency	Total MONTHLY expense without contingency	monthlyExpense	operatingSection	calculated	InputCalculated		$	242811.044328031				0	leaseMonth+laborExpenseMonth+feedExpenseMonth+seedExpenseMonth+waterExpenseMonth+waterTreatmentExpenseMonth+energyExpenseMonth+suppliesMiscExpenseMonth+overheadExpenseMonth+transportationExpenseMonth+oxygenationExpenseMonth+transportationExpenseMonth	The sum of all monthly operating expenses except the Contingency and Operating loan expenses.
Operating	Sturgeon in RAS	ANNUAL expense prior to operating loan	ANNUAL expense prior to operating loan	annualExpenseNoOperatingLoan	operatingSection	calculated	InputCalculated	InputCalcExpense	$	3205105.78513001				0	(monthlyExpense12)+(contingencyExpenseMonth12)	The annual operting expenses prior to calculating operating loan expenses.
Operating	Sturgeon in RAS	Operating loan interest rate	Operating loan interest rate	operatingLoanRate	operatingSection	slider	Input		%	0.06	0	0.15	0.001	3		The interest rate on the annual operating loan.
Operating	Sturgeon in RAS	Operating loan annual expense	Operating loan annual expense	operatingLoanAnnualExpense	operatingSection	calculated	InputCalculated		$	153845.07768624				0	annualExpenseNoOperatingLoanoperatingLoanRate.8	The annual loan expense based on an operating loan for 80% of annual expenses.
Operating	Sturgeon in RAS	ANNUAL expense including operating loan	ANNUAL expense including operating loan	annualExpenseWithOperatingLoan	operatingSection	calculated	InputCalculated	InputCalcExpense	$	3358950.86281625				0	annualExpenseNoOperatingLoan+operatingLoanAnnualExpense	The annual expenses for all operating expenses including the interest expense on the Operating Loan.
Operating	Sturgeon in RAS	ANNUAL revenue	ANNUAL revenue	annualRevenue	operatingSection	calculated	InputCalculated	InputCalcRevenue	$	3000000				0	productPrice*lbsYear	The annual revenue based on the selected annual harvest size and the selected price per pound of the fish being sold
Operating	Sturgeon in RAS	ANNUAL Net Gain/Loss without Startup Loan Financing	ANNUAL Net Gain/Loss without Loan Financing	annualNetGainLoss	operatingSection	calculated	InputCalculated	InputCalcRevenue	$	-358950.862816249				0	annualRevenue-annualExpenseWithOperatingLoan	The operating gain or loss after subtracting annual expenses from annual revenue
Operating	Sturgeon in RAS	Gross Profit Margin Ratio (Profitability %)	Gross Profit Margin Ratio (Profitability %)	grossProfitMarginRatio	operatingSection	calculated	InputCalculated	InputCalcRevenue	%	-0.119650287605416				2	annualNetGainLoss/annualRevenue	This figure REPRESENTS AVERAGE ANNUAL PROFITABILITY compared to revenue. 0% means THE OPERATOR IS at breakeven. Negative numbers indicate the operation is LOSING MONEY.
Operating	Sturgeon in RAS	Labor expense per pound	Labor expense per pound	laborExpenseLb	operatingCalculations	calculated	Parameter		$	0.286642569278802				2	(-0.092)*Math.log(lbsYear)+1.4939	The assumed labor expense per pound of fish produced based on a logarithmic formula that approximates the economies of scale that result as annual production levels increase
Operating	Sturgeon in RAS	Labor expense per harvest	Labor expense per harvest	laborExpenseHarvest	operatingCalculations	calculated	Parameter		$	238868.807732335				0	harvestWeight*laborExpenseLb	The assumed labor expense for a given harvest size
Operating	Sturgeon in RAS	Feed conversion ratio (FCR)	Feed conversion ratio (FCR)	feedConversionRatio	operatingCalculations	calculated	Parameter		ratio	1.8				1		The assumed ratio of of pounds of feed required to produce one pound of fish
Operating	Sturgeon in RAS	Oxygenation expense ratio	Oxygenation expense ratio	oxygenationExpenseRatio	operatingCalculations	calculated	Parameter		ratio	0.05				2		Cost per pound of harvested fish for oxygenation.
Operating	Sturgeon in RAS	Mortality rate	Mortality rate	mortalityRate	operatingCalculations	calculated	Parameter		%	0.25				2		The assumed percentage of initially stocked juveniles that do not live to be harvested
Operating	Sturgeon in RAS	Supplies/Misc ratio	Supplies/Misc ratio	suppliesMiscRatio	operatingCalculations	calculated	Parameter		$/lb	0.1				2		The assumed expense of supplies and miscellaneous materials per pound of fish produced
Operating	Sturgeon in RAS	Overhead ratio	Overhead ratio	overheadRatio	operatingCalculations	calculated	Parameter		$/lb	0.05				2		The assumed expense of overhead expenses per pound of fish produced
Transportation	Sturgeon in RAS	OTHER Transportation cost	OTHER Transportation cost	otherTransportCost	transportationInputsCalc	slider	Input		$	0	0	50000	500	0		Other costs incurred for transportation (e.g. seed transporation, hired driver, rental truck, additional mileage costs)
Transportation	Sturgeon in RAS	Distance to market	Miles to market	marketDistance	transportationInputsCalc	none	InputCalculated		miles	300	0	10000	1	1		The distance from the production facility to the market of processing facility
Transportation	Sturgeon in RAS	Distance to feed	Distance to feed	feedDistance	transportationInputsCalc	none	InputCalculated		miles	300	0	10000	1	1		The distance from the production facility to the feed mill that sources the feed supply
Transportation	Sturgeon in RAS	Product pounds	Product pounds	productPounds	transportationInputsCalc	calculated	InputCalculated		lbs	500000				0	lbsYear	The selected annual production
Transportation	Sturgeon in RAS	Product pounds plus ice	Product pounds plus ice	productPoundsIce	transportationInputsCalc	calculated	InputCalculated		lbs	750000				0	productPounds*1.5	The weight of the selected annual production plus 50% of that weight to account for the weight of ice during shipment of product to market
Transportation	Sturgeon in RAS	Feed Pounds	Feed pounds	feedPounds	transportationInputsCalc	calculated	InputCalculated		lbs	900000	0	100000	500	0	feedConversionRatio*lbsYear	The calculated annual weight of feed based on the selected annual production and the assumed feed conversion ratio
Transportation	Sturgeon in RAS	Total feed product shipping cost	Total feed product shipping cost	feedTransportCost	transportationInputsCalc	calculated	InputCalculated		$	126900				0	feedLbTransportCostfeedPounds/2000feedDistance	The calculated annual cost of transportation for shipping from the feed mill to the production facility
Transportation	Sturgeon in RAS	Product to market transportation cost	Total product shipping cost	marketTransportCost	transportationInputsCalc	calculated	InputCalculated		$	83250				0	marketLbTransportCostproductPoundsIce/2000marketDistance	The calculated annual cost of transportation for shipping product from the production facility to market
Transportation	Sturgeon in RAS	Total Transportation cost	Total Transportation cost	totTransportCost	transportationInputsCalc	calculated	InputCalculated	InputCalcTotal	$	210150				0	feedTransportCost+marketTransportCost+otherTransportCost	The sum of all annual transportation costs
Transportation	Sturgeon in RAS	Feed shipping cost per ton mile	Feed shipping cost per ton mile	feedLbTransportCost	transportationParams	calculated	Parameter Fixed		$/ton-mile	0.94				2		The calculated cost to ship a ton of feed a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.
Transportation	Sturgeon in RAS	Product shipping cost per ton mile	Product shipping cost per ton mile	marketLbTransportCost	transportationParams	calculated	Parameter Fixed		$/ton-mile	0.74				2		The calculated cost to ship a ton of product a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.
Financing	Sturgeon in RAS	Input: % funded with debt	Loan %	percFundedDebt	financingSection	slider	Input		%	0.8	0	1	0.01	2	1-percFundedEquity	The percentage of startup costs expected to be funded by loans
Financing	Sturgeon in RAS	Input: % funded with equity	Equity %	percFundedEquity	financingSection	slider	Input		%	0.2	0	1	0.01	2	1-percFundedDebt	The percentage of startup costs expected to be funded by the owner or investor equity
Financing	Sturgeon in RAS	Input: Loan Interest rate	Loan Interest rate	loanIntRate	financingSection	slider	Input		%	0.06	0	0.2	0.0025	4		Loan interest rate expected on any loan to cover startup costs
Financing	Sturgeon in RAS	Input: Term of loan	Term of loan in years	termOfLoan	financingSection	slider	Input		years	10	0	30	1	0		Expected term of any loan to cover startup costs
Financing	Sturgeon in RAS	Total start up cost	Total start up cost	totStartupCosts2	financingSection	calculated	InputCalculated		$	1447009.43795595				0	totalStartupCost	The sum of all startup costs to get the operation ready to begin growing the first harvest
Financing	Sturgeon in RAS	% funded with equity	% funded with equity	_percFundedEquity	financingSection	calculated	InputCalculated		%	0.9				2	percFundedEquity	The percentage of startup costs expected to be funded by the owner or investor equity
Financing	Sturgeon in RAS	% funded with debt	% funded with debt	_percFundedDebt	financingSection	calculated	InputCalculated		%	0.1				2	percFundedDebt	The percentage of startup costs expected to be funded by loans
Financing	Sturgeon in RAS	Equity investment required	Equity investment required	equityInvestReq	financingSection	calculated	InputCalculated		$	289401.88759119				0	totalStartupCost*percFundedEquity	The amount of equity investment required based on the total startup costs and the selected percentage of the project funded with equity
Financing	Sturgeon in RAS	Loan amount required	Loan amount required	loanAmountReq	financingSection	calculated	InputCalculated		$	1157607.55036476				0	totalStartupCost-equityInvestReq	The amount of the loan required based on the total startup costs and the selected percentage of the project funded with debt
Financing	Sturgeon in RAS	Loan Interest rate	Loan Interest rate	_loanIntRate	financingSection	calculated	InputCalculated		%	0.06				4	loanIntRate	Loan interest rate expected on any loan to cover startup costs
Financing	Sturgeon in RAS	Term of loan	Term of loan	_termOfLoan	financingSection	calculated	InputCalculated		years	10				0	termOfLoan	Expected term of any loan to cover startup costs
Financing	Sturgeon in RAS	Monthly loan payment	MONTHLY loan payment	monthlyLoanPayment	financingSection	calculated	InputCalculated	InputCalcTotal	$					0	annualLoanPayment/12	The calculated monthly loan payment to retire the startup loan based on the size, term, and interest rate of the loan
Financing	Sturgeon in RAS	Annual loan payments	ANNUAL loan expense	annualLoanPayment	financingSection	calculated	InputCalculated	InputCalculated	$					0		The calculated annual debt service to retire the startup loan based on the size, term, and interest rate of the loan
Financing	Sturgeon in RAS	ANNUAL Net Gain/Loss with Loan Financing	ANNUAL Net Gain/Loss with Loan Financing	annualNetGainLossLoan	financingSection	calculated	InputCalculated	InputCalcRevenue	$	-358950.862816249				0	annualNetGainLoss-annualLoanPayment	The operating gain or loss after subtracting annual expenses, including debt service for the startup loan, from annual revenue
Financial Summary	Sturgeon in RAS	Feed	Feed	feedExpense	annualOperatingExpenses	calculated	Input		$	495000				0	feedExpenseMonth*12
Financial Summary	Sturgeon in RAS	Seed	Seed	seedExpense	annualOperatingExpenses	calculated	Input		$	78125				0	seedExpenseMonth*12
Financial Summary	Sturgeon in RAS	Water	Water	waterExpense	annualOperatingExpenses	calculated	Input		$	4447.22715847045				0	waterExpenseMonth*12
Financial Summary	Sturgeon in RAS	Water Treatment	Water Treatment	waterTreatmentExpense	annualOperatingExpenses	calculated	Input		$	1035000				0	waterTreatmentExpenseMonth*12
Financial Summary	Sturgeon in RAS	Oxygenation	Oxygenation	oxygenationExpense	annualOperatingExpenses	calculated	Input		$	25000				0	oxygenationExpenseMonth*12
Financial Summary	Sturgeon in RAS	Energy	Energy	energyExpense	annualOperatingExpenses	calculated	Input		$	865689.0201385				0	energyExpenseMonth*12
Financial Summary	Sturgeon in RAS	Labor	Labor	laborExpense	annualOperatingExpenses	calculated	Input		$	143321.284639401				0	laborExpenseMonth*12
Financial Summary	Sturgeon in RAS	Supplies & Misc	Supplies & Misc	suppliesMiscExpense	annualOperatingExpenses	calculated	Input		$	30000				0	suppliesMiscExpenseMonth*12
Financial Summary	Sturgeon in RAS	Transportation	Transportation	transportationExpense	annualOperatingExpenses	calculated	Input		$	750000				0	totTransportCost
Financial Summary	Sturgeon in RAS	Overhead	Overhead	overheadExpense	annualOperatingExpenses	calculated	Input		$	15000				0	overheadExpenseMonth*12
Financial Summary	Sturgeon in RAS	Contingency	Contingency	contingencyExpense	annualOperatingExpenses	calculated	Input		$	210150				0	contingencyExpenseMonth*12
Financial Summary	Sturgeon in RAS	Operating Loan	Operating Loan	operatingLoanExpense	annualOperatingExpenses	calculated	Input		$	153845.07768624				0	operatingLoanAnnualExpense
Financial Summary	Sturgeon in RAS	Startup Loan	Startup Loan	loanExpense	annualOperatingExpenses	calculated	Input		$	0				0	annualLoanPayment
Financial Summary	Sturgeon in RAS	CHART: Annual Operating Expenses Without Startup Loan	CHART: Annual Operating Expenses Without Startup Loan	chartAnnualOperExp	annualOperatingExpensesChart	chart	Chart											yrOperExpChart
Financial Summary	Sturgeon in RAS	CHART: Annual Operating Expenses With Startup Loan	CHART: Annual Operating Expenses With Startup Loan	chartAnnualOperExpWLoan	annualOperatingExpensesChartWLoan	chart	Chart											yrOperExpWLoanChart
Financial Summary	Sturgeon in RAS	CHART: Start up costs	CHART: Start up costs	chartStartupCosts	startupCostsChart	chart	Chart											startUpCosts
Production	Hybrid Striped Bass in Pond	Market size (lb)	Market size (lb)	marketSizeLbs	productionSection	dropdown	LookupTable		lbs	1.5	0	5	0.1	1	[lut:growthRate>Market Weight]	Select the size of your whole fish product at which you will sell it to the market
Production	Hybrid Striped Bass in Pond	Pounds/year	Target annual production	lbsYear	productionSection	slider	Input		lbs	25000	500	5000000	500	0		Select the size of your annual harvest
Production	Hybrid Striped Bass in Pond	Land required	Land required	landRequired	productionRequired	calculated	RequiredResource		acres	9.33333333333333				3	acresProductionSurfaceArea*landSizeRatio	The calculated amount of land required based on the production surface area and the land size ratio. Note that this does not account for collection ponds or effluent ponds.
Production	Hybrid Striped Bass in Pond	New water required	New water required	dailyWaterRequired	productionRequired	calculated	RequiredResource		gal/minute	475.230525				0	systemWaterVolume/replacementWater/24/60	The calculated amount of required new water per day based on the Water replacement interval and the system water volume.
Production	Hybrid Striped Bass in Pond	Flow rate required	Flow rate required	flowRateRequired	productionRequired	calculated	RequiredResource		gal/minute	316.82035				2	systemWaterVolume/refillTime/24/60	The calculated required flow rate from the water source needed to refill the system in the event of an emergency water quality problem.
Production	Hybrid Striped Bass in Pond	System water volume	System water volume	systemWaterVolume	productionRequired	calculated	RequiredResource		gallons	13686639.12				0	productionWaterVolume*sysProdRatio	The total water in the system derived from the production water volume and the system/production ratio.
Production	Hybrid Striped Bass in Pond	Harvests per year	Harvests per year	harvestsPerYear	productionRequired	calculated	RequiredResource		#	0.75				2	12/monthsToHarvest	The calculated number of harvests per year based on the selected market size of the product and the assumed growth rate
Production	Hybrid Striped Bass in Pond	Land available	Land available	landAvailable	productionRequired	slider	ExistingResource		acres		0	3000	1	2	[validate:landRequired]	Select the amount of land you have available for the ponds and equipment
Production	Hybrid Striped Bass in Pond	Daily water available	Daily water available	dailyWaterAvailable	productionRequired	slider	ExistingResource		gal/day		0	200000000	10000	0	[validate:dailyWaterRequired]	Select the amount of water you have available to replenish the system daily due to effluent and evaporation losses
Production	Hybrid Striped Bass in Pond	Max flow available	Max flow available	maxFlowAvailable	productionRequired	slider	ExistingResource		gal/day		0	2500000000	100000	0	[validate:flowRateRequired]	Select the amount of water you have available for emergency refilling of the system due to a problem with water quality
Production	Hybrid Striped Bass in Pond	Average pond depth	Average pond depth	avgPondDepth	productionRequired	slider	ExistingResource		ft	4.5	1	20	0.1	1		The average depth of the growout ponds.
Production	Hybrid Striped Bass in Pond	Months to harvest	Average months to harvest	monthsToHarvest	productionCalculations	calculated	Parameter		mos	16	0	24	1	0	[From DropDown for Market Weigth]	The assumed months required to grow the fish to the selected market size
Production	Hybrid Striped Bass in Pond	Harvest weight	Harvest weight	harvestWeight	productionCalculations	calculated	Parameter		lbs	33333.3333333333				0	lbsYear/harvestsPerYear	The annual harvest divided by the number of harvests per year.
Production	Hybrid Striped Bass in Pond	Carrying capacity	Carrying capacity	carryingCapacity	productionCalculations	calculated	Parameter		lb/acre	5000				0		The expert assumption for the maximum weight of biomass at harvest per acre of surface area in the growout ponds.
Production	Hybrid Striped Bass in Pond	Acres of production surface area	Acres of production surface area	acresProductionSurfaceArea	productionCalculations	calculated	Parameter		acres	6.66666666666667				2	harvestWeight/carryingCapacity	The calculated acres of surface area in the production ponds based on the harvest pounds and the carrying capacity.
Production	Hybrid Striped Bass in Pond	Production water volume	Production water volume	productionWaterVolume	productionCalculations	calculated	Parameter		gallons	9776170.8				0	acresProductionSurfaceArea43560avgPondDepth*7.481	The assumed volume of water in the grow-out ponds based on the system water volume and the assumed system/production ratio
Production	Hybrid Striped Bass in Pond	System / production ratio	System / production ratio	sysProdRatio	productionCalculations	calculated	Parameter		ratio	1.4				2		The expert assumption for the ratio of the water used in the growout ponds to the total water in the system for other uses including nursery ponds.
Production	Hybrid Striped Bass in Pond	Water replacement interval	Water replacement interval	replacementWater	productionCalculations	calculated	Parameter		days	20				2		The expert assumption for the number of days to fully replace the water due to seepage, evaporation, and effluent.
Production	Hybrid Striped Bass in Pond	Refill time	Refill time	refillTime	productionCalculations	calculated	Parameter		days	30				0		The expert assumption for the time required to refill the system in the event of an emergency water quality problem.
Production	Hybrid Striped Bass in Pond	Land size ratio	Land size ratio	landSizeRatio	productionCalculations	calculated	Parameter		ratio	1.4				2		The expert assumption for the amount of land required as a function of the surface area of the ponds.
Startup	Hybrid Striped Bass in Pond	Cost of land per acre	Cost of land per acre	landCostAcre	startupSection	slider	Input		$	2500	0	50000	500	0		Estimated land cost per acre if needing to purchase land
Startup	Hybrid Striped Bass in Pond	Structure cost	Structure cost	buildingCost	startupSection	slider	Input		$	0	0	2000000	1000	0		Building cost if you are buying your building
Startup	Hybrid Striped Bass in Pond	Water supply cost	Water supply cost	waterSupplyCost	startupSection	slider	Input		$	20000	0	100000	1000	0		Costs of construction related to bringing a water supply to the production buidling (e.g. digging a well and piping)
Startup	Hybrid Striped Bass in Pond	One-time startup permitting cost	One-time startup permitting cost	permittingCost	startupSection	slider	Input		$	25000	0	100000	1000	0		Permitting cost for construction, environmental prior to start of operations.
Startup	Hybrid Striped Bass in Pond	Additional startup costs	Additional startup costs	miscCost	startupSection	slider	Input		$	0	0	500000	1000	0		This is additional startup costs you are anticipating (eg. Storage shed, construction of collection ponds or effluent ponds).
Startup	Hybrid Striped Bass in Pond	Equipment cost ratio	Equipment cost ratio	equipmentCostRatio	startupCalculations	calculated	Parameter		$/lb	1.14				1		The assumed cost ratio of system equipment (tanks, pumps, filtration, etc.) as a function of the annual production weight
Startup	Hybrid Striped Bass in Pond	Engineering / construction cost ratio	Engineering / construction cost ratio	engineeringCostRatio	startupCalculations	calculated	Parameter		$/acre	2000				0		The expert assumption of the ratio of the engineering and construction cost to build a pond facility required to grow a given annual harvest.
Startup	Hybrid Striped Bass in Pond	Other startup cost ratio	Other startup cost ratio	otherStartupCostRatio	startupCalculations	calculated	Parameter		$/lb	0.82				2		The expert assumption of other cost to build a facility required to grow a given annual harvest.
Startup	Hybrid Striped Bass in Pond	Land cost	Land cost	landCost	startupSection	calculated	InputCalculated		$	23333.3333333333				0	landRequired*landCostAcre	Land cost if you are buying your land
Startup	Hybrid Striped Bass in Pond	Equipment cost	Equipment cost	equipmentCost	startupSection	calculated	InputCalculated		$	28500				0	lbsYear*equipmentCostRatio	The calculated equipment cost based on the annual harvest and the equipment cost ratio.
Startup	Hybrid Striped Bass in Pond	Engineering / construction cost	Engineering / construction cost	engineeringCost	startupSection	calculated	InputCalculated		$	18666.6666666667				0	landRequired*engineeringCostRatio	The calculated engineering/construction cost based on the acres required and the cost-per-acre engineering/construction cost ratio.
Startup	Hybrid Striped Bass in Pond	Other startup costs	Other startup costs	otherStartupCost	startupSection	calculated	InputCalculated		$	20500				0	lbsYear*otherStartupCostRatio	The calculated other startup cost based on the annual harvest and the other startup cost ratio. This could include pre-launch marketing, labor during the startup year prior to beginning the initial crop, initial crop failures etc.
Startup	Hybrid Striped Bass in Pond	TOTAL startup cost	TOTAL startup cost	totalStartupCost	startupSection	calculated	InputCalculated	InputCalcTotal	$	136000				0	landCost+buildingCost+waterSupplyCost+miscCost+equipmentCost+engineeringCost+otherStartupCost+permittingCost	The sum of all startup costs to get the operation ready to begin growing the first harvest
Operating	Hybrid Striped Bass in Pond	Product price	Product price	productPrice	operatingSection	slider	Input		$	2.4	0	10	0.25	2		The planned price per pound at which you will sell your product
Operating	Hybrid Striped Bass in Pond	Lease	Lease	leaseMonth	operatingSection	slider	Input		$/month	0	0	10000	100	0		Rent or lease per month if you do not own the land and building
Operating	Hybrid Striped Bass in Pond	Feed price	Feed price	feedPrice	operatingSection	slider	Input		$/lb	0.5	0	5	0.25	2		Price per pound of fish feed
Operating	Hybrid Striped Bass in Pond	Seed price	Seed price	seedPrice	operatingSection	slider	Input		$/unit	0.35	0	5	0.05	2		Price per unit of seedlings or fingerlings
Operating	Hybrid Striped Bass in Pond	Water price	Water price	waterPrice	operatingSection	slider	Input		$/acre-foot	70	0	200	1	0		Price of water per gallon. Note that this cost is sensitive to the replacement water required. If high volumes of replacement water are required and there is a non-diminimus cost of water, the profitability of the venture will be challenged.
Operating	Hybrid Striped Bass in Pond	Contingency	Contingency	contingencyCost	operatingSection	slider	Input		%	0.1	0	50	0.01	2		Contingency expense as a % of all other monthly expenses.
Operating	Hybrid Striped Bass in Pond	Overhead expense per month	Overhead expense per month	overheadExpenseMonth	operatingSection	calculated	InputCalculated		$	78.125				0	overheadRatio*lbsYear/monthsToHarvest	The caluclated overhead expense based on the harvest size, months to harvest, and overhead ratio.
Operating	Hybrid Striped Bass in Pond	Labor expense per month	Labor expense per month	laborExpenseMonth	operatingSection	calculated	InputCalculated		$	1171.35403842869				0	laborExpenseHarvest/monthsToHarvest	The labor expense per month based on the labor expense per harvest and the number of months to reach the harvest.
Operating	Hybrid Striped Bass in Pond	Feed expense per month	Feed expense per month	feedExpenseMonth	operatingSection	calculated	InputCalculated		$	2395.83333333333				0	feedPricefeedConversionRatioharvestWeight/monthsToHarvest	The cost of feed per month calculated from the harvest size, months to harvest, feed conversion ratio, and feed price.
Operating	Hybrid Striped Bass in Pond	Seed expense per month	Seed expense per month	seedExpenseMonth	operatingSection	calculated	InputCalculated		$	656.25				0	harvestWeight/marketSizeLbs(1+mortalityRate)seedPrice/monthsToHarvest	The calculated cost of seed per month based on the number of fish in the harvest, the number of months to harvest, and the price of seed.
Operating	Hybrid Striped Bass in Pond	Water expense per month	Water expense per month	waterExpenseMonth	operatingSection	calculated	InputCalculated		$	4410.2890818196				0	dailyWaterRequired602430/325851waterPrice	The calculated cost of water per month based on the new water required per day (expressed in acre-feet) x 30 days per month x the water price.
Operating	Hybrid Striped Bass in Pond	Energy expense per month	Energy expense per month	energyExpenseMonth	operatingSection	calculated	InputCalculated		$	258.333333333333				0	lbsYear*operatingEnergyRatio/12	The calculated energy expense based on the harvest size and the Opertating Energy Ratio.
Operating	Hybrid Striped Bass in Pond	Supplies/Misc expense per month	Supplies/Misc expense per month	suppliesMiscExpenseMonth	operatingSection	calculated	InputCalculated		$	156.25				0	suppliesMiscRatio*lbsYear/monthsToHarvest	The caluculated supplies/misc expense per month based on the harvest size, months to harvest, and supplies/misc ratio.
Operating	Hybrid Striped Bass in Pond	Transportation expense per month	Transportation expense per month	transportationExpenseMonth	operatingSection	calculated	InputCalculated		$	1022.5				0	totTransportCost/12	The calcuated monthlly transportation costs for sourcing feed and shipping fish to market
Operating	Hybrid Striped Bass in Pond	Contingency expense per month	Contingency expense per month	contingencyExpenseMonth	operatingSection	calculated	InputCalculated		$	912.643478691496					monthlyExpense*contingencyCost	The monthly expense contingency.
Operating	Hybrid Striped Bass in Pond	Total MONTHLY expense without contingency	Total MONTHLY expense without contingency	monthlyExpense	operatingSection	calculated	InputCalculated		$	9126.43478691496				0	leaseMonth+laborExpenseMonth+feedExpenseMonth+seedExpenseMonth+waterExpenseMonth+energyExpenseMonth+suppliesMiscExpenseMonth+overheadExpenseMonth+transportationExpenseMonth	The sum of all monthly operating expenses before the contingency.
Operating	Hybrid Striped Bass in Pond	ANNUAL expense prior to operating loan	ANNUAL expense prior to operating loan	annualExpenseNoOperatingLoan	operatingSection	calculated	InputCalculated	InputCalcExpense	$	120468.939187277				0	(monthlyExpense12)+(contingencyExpenseMonth12)	The annual operting expenses prior to calculating operating loan expenses.
Operating	Hybrid Striped Bass in Pond	Operating loan interest rate	Operating loan interest rate	operatingLoanRate	operatingSection	slider	Input		%	0.06	0	0.150	0.001	3		The interest rate on the annual operating loan.
Operating	Hybrid Striped Bass in Pond	Operating loan annual expense	Operating loan annual expense	operatingLoanAnnualExpense	operatingSection	calculated	InputCalculated		$	5782.50908098932				0	annualExpenseNoOperatingLoanoperatingLoanRate.8	Interest expense assuming 80% of the annual expenses are financed by the Operating Loan.
Operating	Hybrid Striped Bass in Pond	ANNUAL expense including operating loan	ANNUAL expense including operating loan	annualExpenseWithOperatingLoan	operatingSection	calculated	InputCalculated	InputCalcExpense	$	126251.448268267				0	annualExpenseNoOperatingLoan+operatingLoanAnnualExpense	Annual expenses including the operating loan interest.
Operating	Hybrid Striped Bass in Pond	ANNUAL revenue	ANNUAL revenue	annualRevenue	operatingSection	calculated	InputCalculated	InputCalcRevenue	$	60000				0	productPrice*lbsYear	The annual revenue based on the annual harvest weight and the market price per pound.
Operating	Hybrid Striped Bass in Pond	ANNUAL Net Gain/Loss without Startup Loan Financing	ANNUAL Net Gain/Loss without Startup Loan Financing	annualNetGainLoss	operatingSection	calculated	InputCalculated	InputCalcRevenue	$	-66251.4482682668				0	annualRevenue-annualExpenseWithOperatingLoan	The annual operating profit or loss calculated by subtracting the annual expenses from the annual revenue.
Operating	Hybrid Striped Bass in Pond	Gross Profit Margin Ratio (Profitability %)	Gross Profit Margin Ratio (Profitability %)	grossProfitMarginRatio	operatingSection	calculated	InputCalculated	InputCalcRevenue	%	-1.10419080447111				2	annualNetGainLoss/annualRevenue	This is a figure of merit indicating the magnitude of the profit as compared to the revenue. 0% means you are at breakeven. Negative numbers indicate the operation is not making money but are otherwise arbitrary.
Operating	Hybrid Striped Bass in Pond	Labor expense per pound	Labor expense per pound	laborExpenseLb	operatingCalculations	calculated	Parameter		$	0.562249938445769				2	(-0.092)*Math.log(lbsYear)+1.4939	The expert assumption of the labor expense as a function of the harvest weight.
Operating	Hybrid Striped Bass in Pond	Labor expense per harvest	Labor expense per harvest	laborExpenseHarvest	operatingCalculations	calculated	Parameter		$	18741.664614859				0	harvestWeight*laborExpenseLb	The labor expense for a given harvest based on the harvest weight and the labor expense per pound expert assumption.
Operating	Hybrid Striped Bass in Pond	Feed conversion ratio (FCR)	Feed conversion ratio (FCR)	feedConversionRatio	operatingCalculations	calculated	Parameter		ratio	2.3				1		The expert assumption of the feed conversion ratio for this species.
Operating	Hybrid Striped Bass in Pond	Mortality rate	Mortality rate	mortalityRate	operatingCalculations	calculated	Parameter		%	0.35				2		The assumed percentage of initially stocked juveniles that do not live to be harvested
Operating	Hybrid Striped Bass in Pond	Operating energy ratio	Operating energy ratio	operatingEnergyRatio	operatingCalculations	calculated	Parameter		$/lb	0.124				3		The expert assumption of the cost of the energy required as a function of the harvest weight
Operating	Hybrid Striped Bass in Pond	Supplies/Misc ratio	Supplies/Misc ratio	suppliesMiscRatio	operatingCalculations	calculated	Parameter		$/lb	0.1				2		The expert assumption for ratio of supplies (e.g. chemicals) per pound of fish at harvest
Operating	Hybrid Striped Bass in Pond	Overhead ratio	Overhead ratio	overheadRatio	operatingCalculations	calculated	Parameter		$/lb	0.05				2		The expert assumption for the ratio of overhead expense per pound of fish at harvest . This accounts for the costs of management, accounting, marketing, insurance and other administrative expenses.
Transportation	Hybrid Striped Bass in Pond	OTHER Transportation cost	OTHER Transportation cost	otherTransportCost	transportationInputsCalc	slider	Input		$	0	0	50000	500	0		Other costs incurred for transportation (e.g. seed transporation, hired driver, rental truck, additional mileage costs)
Transportation	Hybrid Striped Bass in Pond	Distance to market	Miles to market	marketDistance	transportationInputsCalc	none	InputCalculated		miles	300	0	10000	1	1		The distance from the production facility to the market of processing facility
Transportation	Hybrid Striped Bass in Pond	Distance to feed	Distance to feed	feedDistance	transportationInputsCalc	none	InputCalculated		miles	300	0	10000	1	1		The distance from the production facility to the feed mill that sources the feed supply
Transportation	Hybrid Striped Bass in Pond	Product pounds	Product pounds	productPounds	transportationInputsCalc	calculated	InputCalculated		lbs	25000				0	lbsYear	The selected annual production
Transportation	Hybrid Striped Bass in Pond	Product pounds plus ice	Product pounds plus ice	productPoundsIce	transportationInputsCalc	calculated	InputCalculated		lbs	37500				0	productPounds*1.5	The weight of the selected annual production plus 50% of that weight to account for the weight of ice during shipment of product to market
Transportation	Hybrid Striped Bass in Pond	Feed Pounds	Feed pounds	feedPounds	transportationInputsCalc	calculated	InputCalculated		lbs	57500	0	100000	500	0	feedConversionRatio*lbsYear	The calculated annual weight of feed based on the selected annual production and the assumed feed conversion ratio
Transportation	Hybrid Striped Bass in Pond	Total feed product shipping cost	Total feed product shipping cost	feedTransportCost	transportationInputsCalc	calculated	InputCalculated		$	8107.5				0	feedLbTransportCostfeedPounds/2000feedDistance	The calculated annual cost of transportation for shipping from the feed mill to the production facility
Transportation	Hybrid Striped Bass in Pond	Product to market transportation cost	Total product shipping cost	marketTransportCost	transportationInputsCalc	calculated	InputCalculated		$	4162.5				0	marketLbTransportCostproductPoundsIce/2000marketDistance	The calculated annual cost of transportation for shipping product from the production facility to market
Transportation	Hybrid Striped Bass in Pond	Total Transportation cost	Total Transportation cost	totTransportCost	transportationInputsCalc	calculated	InputCalculated	InputCalcTotal	$	12270				0	feedTransportCost+marketTransportCost+otherTransportCost	The sum of all annual transportation costs
Transportation	Hybrid Striped Bass in Pond	Feed shipping cost per ton mile	Feed shipping cost per ton mile	feedLbTransportCost	transportationParams	calculated	Parameter Fixed		$/ton-mile	0.94				2		The calculated cost to ship a ton of feed a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.
Transportation	Hybrid Striped Bass in Pond	Product shipping cost per ton mile	Product shipping cost per ton mile	marketLbTransportCost	transportationParams	calculated	Parameter Fixed		$/ton-mile	0.74				2		The calculated cost to ship a ton of product a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.
Financing	Hybrid Striped Bass in Pond	Input: % funded with debt	Loan %	percFundedDebt	financingSection	slider	Input		%	0.2	0	1	0.01	2	1-percFundedEquity	The percentage of cost to build the facility and cover the initial year of startup cost prior to beginning your first crop that will be financed with loans.
Financing	Hybrid Striped Bass in Pond	Input: % funded with equity	Equity %	percFundedEquity	financingSection	slider	Input		%	0.8	0	1	0.01	2	1-percFundedDebt	The percentage of cost to build the facility and cover the initial year of startup cost prior to beginning your first crop that will be financed with equity from the owner or investors.
Financing	Hybrid Striped Bass in Pond	Input: Loan Interest rate	Loan Interest rate	loanIntRate	financingSection	slider	Input		%	0.06	0	0.2	0.0025	4		Loan interest rate expected on any loan to cover startup costs
Financing	Hybrid Striped Bass in Pond	Input: Term of loan	Term of loan in years	termOfLoan	financingSection	slider	Input		years	10	0	30	1	0		Expected term of any loan to cover startup costs
Financing	Hybrid Striped Bass in Pond	Total start up cost	Total start up cost	totStartupCosts2	financingSection	calculated	InputCalculated		$	136000				0	totalStartupCost	The sum of all startup costs to get the operation ready to begin growing the first harvest
Financing	Hybrid Striped Bass in Pond	% funded with equity	% funded with equity	_percFundedEquity	financingSection	calculated	InputCalculated		%	0.8				2	percFundedEquity	The percentage of startup costs expected to be funded by the owner or investor equity
Financing	Hybrid Striped Bass in Pond	% funded with debt	% funded with debt	_percFundedDebt	financingSection	calculated	InputCalculated		%	0.2				2	percFundedDebt	The percentage of startup costs expected to be funded by loans
Financing	Hybrid Striped Bass in Pond	Equity investment required	Equity investment required	equityInvestReq	financingSection	calculated	InputCalculated		$	108800				0	totalStartupCost*percFundedEquity	The amount of equity investment required based on the total startup costs and the selected percentage of the project funded with equity
Financing	Hybrid Striped Bass in Pond	Loan amount required	Loan amount required	loanAmountReq	financingSection	calculated	InputCalculated		$	27200				0	totalStartupCost-equityInvestReq	The amount of the loan required based on the total startup costs and the selected percentage of the project funded with debt
Financing	Hybrid Striped Bass in Pond	Loan Interest rate	Loan Interest rate	_loanIntRate	financingSection	calculated	InputCalculated		%	0.06				4	loanIntRate	Loan interest rate expected on any loan to cover startup costs
Financing	Hybrid Striped Bass in Pond	Term of loan	Term of loan	_termOfLoan	financingSection	calculated	InputCalculated		years	10				0	termOfLoan	Expected term of any loan to cover startup costs
Financing	Hybrid Striped Bass in Pond	Monthly loan payment	Monthly loan payment	monthlyLoanPayment	financingSection	calculated	InputCalculated	InputCalcTotal	$					0	annualLoanPayment/12	The calculated monthly loan payment to retire the startup loan based on the size, term, and interest rate of the loan
Financing	Hybrid Striped Bass in Pond	Annual loan payments	Annual loan expense	annualLoanPayment	financingSection	calculated	InputCalculated	InputCalculated	$					0		The calculated annual debt service to retire the startup loan based on the size, term, and interest rate of the loan
Financing	Hybrid Striped Bass in Pond	ANNUAL Net Gain/Loss with Loan Financing	ANNUAL Net Gain/Loss with Loan Financing	annualNetGainLossLoan	financingSection	calculated	InputCalculated	InputCalcRevenue	$	126251.448268267				0	annualNetGainLoss-annualLoanPayment	The annual operating profit or loss calculated by subtracting the annual expenses plus the loan interest cost from the annual revenue
Financial Summary	Hybrid Striped Bass in Pond	Feed	Feed	feedExpense	annualOperatingExpenses	calculated	Input		$	28750				0	feedExpenseMonth*12
Financial Summary	Hybrid Striped Bass in Pond	Seed	Seed	seedExpense	annualOperatingExpenses	calculated	Input		$	7875				0	seedExpenseMonth*12
Financial Summary	Hybrid Striped Bass in Pond	Water	Water	waterExpense	annualOperatingExpenses	calculated	Input		$	52923.4689818353				0	waterExpenseMonth*12
Financial Summary	Hybrid Striped Bass in Pond	Electricity	Electricity	energyExpense	annualOperatingExpenses	calculated	Input		$	3100				0	energyExpenseMonth*12
Financial Summary	Hybrid Striped Bass in Pond	Labor	Labor	laborExpense	annualOperatingExpenses	calculated	Input		$	14056.2484611442				0	laborExpenseMonth*12
Financial Summary	Hybrid Striped Bass in Pond	Supplies & Misc	Supplies & Misc	suppliesMiscExpense	annualOperatingExpenses	calculated	Input		$	1875				0	suppliesMiscExpenseMonth*12
Financial Summary	Hybrid Striped Bass in Pond	Transportation	Transportation	transportationExpense	annualOperatingExpenses	calculated	Input		$	12270				0	totTransportCost
Financial Summary	Hybrid Striped Bass in Pond	Overhead	Overhead	overheadExpense	annualOperatingExpenses	calculated	Input		$	937.5				0	overheadExpenseMonth*12
Financial Summary	Hybrid Striped Bass in Pond	Contingency	Contingency	contingencyExpense	annualOperatingExpenses	calculated	Input		$	109517.21744298				0	contingencyExpenseMonth*12
Financial Summary	Hybrid Striped Bass in Pond	Operating Loan	Operating Loan	operatingLoanExpense	annualOperatingExpenses	calculated	Input		$	5782.50908098932				0	operatingLoanAnnualExpense
Financial Summary	Hybrid Striped Bass in Pond	Startup Loan	Startup Loan	loanExpense	annualOperatingExpenses	calculated	Input		$	0				0	annualLoanPayment
Financial Summary	Hybrid Striped Bass in Pond	CHART: Annual Operating Expenses Without Startup Loan	CHART: Annual Operating Expenses Without Startup Loan	chartAnnualOperExp	annualOperatingExpensesChart	chart	Chart											yrOperExpChartPond
Financial Summary	Hybrid Striped Bass in Pond	CHART: Annual Operating Expenses With Startup Loan	CHART: Annual Operating Expenses With Startup Loan	chartAnnualOperExpWLoan	annualOperatingExpensesChartWLoan	chart	Chart											yrOperExpWLoanChartPond
Financial Summary	Hybrid Striped Bass in Pond	CHART: Start up costs	CHART: Start up costs	chartStartupCosts	startupCostsChart	chart	Chart											startUpCostsPond

Screen

Show

Field

FieldLabel

FieldCalVar

Section

UiType

FieldCategory

FieldClass

Unit

Default

Min

Max

Increment

Decimal

Formula

Description

Notes

ChartConfig

Start Here

All

startOverview

radiobutton

Text for the system selection!

Select System

All

SystemSelector

sysSelect

ssSystemSelect

radiobutton

Text for the system selection!

Summary

All

SummaryTable

sumTbl

sumTable

Summary

All

ANNUAL expense

_annualExpense

sumOverview

calculated

InputCalculated

InputCalcExpense

0.1

annualExpenseWithOperatingLoan

The total annual sum of all operating expenses

Summary

All

ANNUAL revenue

_annualRevenue

sumOverview

calculated

InputCalculated

InputCalcRevenue

1500000

annualRevenue

The total annual revenue generated by the operation based on the annual production volume and the selected product price

Summary

All

ANNUAL Net Gain/Loss without Loan Financing

_annualNetGainLoss

sumOverview

calculated

InputCalculated

InputCalcRevenue

1499999.9

annualNetGainLoss

The annual operating net gain or loss assuming there are no operating loans used to finance the operation

Summary

All

Gross Profit Margin Ratio (Profitability %)

_grossProfitMarginRatio

sumOverview

calculated

InputCalculated

InputCalcRevenue

0.999999933333333

grossProfitMarginRatio

This is your profitability margin expressed in %. 0% means you are at breakeven. Negative numbers here are indications that the enterprise is not generating an operating profit.

Location

All

Map

map

locationMap

map

Transportation

All

Miles to market

marketDistanceOpts

transportationInputsCalc

dropdownLocations

Input

miles

1000

marketDistance

The distance from the production facility to the market of processing facility

Transportation

All

Miles to feed supply

feedDistanceOpts

transportationInputsCalc

dropdownLocations

Input

miles

500

3000

feedDistance

The distance from the production facility to the feed mill that sources the feed supply

Production

Tilapia in RAS

Market size (lb)

marketSizeLbs

productionSection

dropdown

LookupTable

lbs

0.1

[lut:growthRate>Market Weight]

Select the size of your whole fish product at which you will sell it to the market

Production

Tilapia in RAS

Pounds/year

Target annual production

lbsYear

productionSection

slider

Input

lbs

500000

500

2000000

500

Select the size of your annual harvest

Production

Tilapia in RAS

Space required

spaceRequired

productionRequired

calculated

RequiredResource

sq ft

14803.932962963

systemWaterVolume*0.133681/avgTankDepth*spaceSizeRatio

The calculated space required for the RAS equipment based on the average tank depth, the surface area of the tanks based on the system water volume, and the space size ratio.

Production

Tilapia in RAS

Building required

buildingRequired

productionRequired

calculated

RequiredResource

sq ft

23316.1944166667

systemWaterVolume*0.133681/3*spaceSizeRatio*buildingSizeRatio

The calculated size of the building needed to house the system based on the production level

Production

Tilapia in RAS

Land required

landRequired

productionRequired

calculated

RequiredResource

acres

0.56075503647587

systemWaterVolume*0.133681/3*spaceSizeRatio*landSizeRatio/43560

The calculated amount of land required for the building used to house the system based on the production level

Production

Tilapia in RAS

New water required

dailyWaterRequired

productionRequired

calculated

RequiredResource

gal/minute

(systemWaterVolume*replacementWater)/(24*60)

The calculated amount of water needed per day to replenish the system based on the system water volume and the assumed replacement water percentage

Production

Tilapia in RAS

Flow rate required

flowRateRequired

productionRequired

calculated

RequiredResource

gal/minute

53.2407407407407

(systemWaterVolume/(refillTime*24))/60

The calculated amount of water needed to refill the system in an emergency situation based on the system water volume and the assumed refill time

Production

Tilapia in RAS

Total system water volume

systemWaterVolume

productionRequired

calculated

RequiredResource

gallons

383333.333333333

productionWaterVolume*sysProdRatio

The calcuated volume of water in the system based on the production level and the assumed carrying capacity

Production

Tilapia in RAS

Harvests per year

harvestsPerYear

productionRequired

calculated

RequiredResource

12/monthsToHarvest

The calculated number of harvests per year based on the selected market size of the product and the assumed growth rate

Production

Tilapia in RAS

Space available

spaceAvailable

productionRequired

slider

ExistingResource

sq ft

300000

100

[validate:spaceRequired]

Space available for the equipment in this production scenario

Production

Tilapia in RAS

Building available

buildingAvailable

productionRequired

slider

ExistingResource

sq ft

350000

100

[validate:buildingRequired]

Select the size of the building in which you will house the system

Production

Tilapia in RAS

Land available

landAvailable

productionRequired

slider

ExistingResource

acres

0.01

[validate:landRequired]

Select the amount of land you have available for the building housing the system

Production

Tilapia in RAS

New water available

dailyWaterAvailable

productionRequired

slider

ExistingResource

gal/minute

100

[validate:dailyWaterRequired]

Select the amount of water you have available to replenish the system water daily due to effluent and evaporation losses

Production

Tilapia in RAS

Max flow available

maxFlowAvailable

productionRequired

slider

ExistingResource

gal/minute

500

[validate:flowRateRequired]

Select the amount of water flow you have available for emergency refilling of the system due to a problem with water quality

Production

Tilapia in RAS

Average tank depth

avgTankDepth

productionRequired

slider

ExistingResource

4.5

0.5

Select the average tank depth you have available. Most RAS systems have an average grow-out tank depth of 4.5 ft.

Production

Tilapia in RAS

Months to harvest

Average months to harvest

monthsToHarvest

productionCalculations

calculated

Parameter

mos

0.1

[From DropDown for Market Weigth]

The assumed months required to grow the fish to the selected market size

Production

Tilapia in RAS

Harvest weight

harvestWeight

productionCalculations

calculated

Parameter

lbs

250000

lbsYear/harvestsPerYear

The annual harvest divided by the number of harvests per year.

Production

Tilapia in RAS

Carrying capacity

carryingCapacity

productionCalculations

calculated

Parameter

lbs/gallon

0.75

The assumed ratio of the maximum amount of pounds of fish per gallon of water in the production grow-out tanks

Production

Tilapia in RAS

Production water volume

productionWaterVolume

productionCalculations

calculated

Parameter

gallons

333333.333333333

harvestWeight/carryingCapacity

The assumed volume of water in the grow-out tanks based on the system water volume and the assumed system/production ratio

Production

Tilapia in RAS

System / production ratio

sysProdRatio

productionCalculations

calculated

Parameter

ratio

1.15

The ratio of total water in the system to the volume of water in the production grow-out tanks

Production

Tilapia in RAS

Replacement water

replacementWater

productionCalculations

calculated

Parameter

0.1

The percentage of system water volume per day that is discharged as effluent vs. treated and recirculated

Production

Tilapia in RAS

Refill time

refillTime

productionCalculations

calculated

Parameter

days

The assumed time needed to refill the total system water volume in an emergency situation

Production

Tilapia in RAS

System water surface area

systemWaterSurfaceArea

productionCalculations

calculated

Parameter

sq ft

11387.6407407407

systemWaterVolume*0.133681/avgTankDepth

The total system water surface area is calculated as the system volume multiplied by 0.1333681 divided by the average tank depth

Production

Tilapia in RAS

Space size ratio

spaceSizeRatio

productionCalculations

calculated

Parameter

ratio

1.3

The assumed ratio of the size of the footprint of all of the system equipment to the footprint of the water tanks based calculated from the system water volume with an assumed 4 foot tank depth

Production

Tilapia in RAS

Building size ratio

buildingSizeRatio

productionCalculations

calculated

Parameter

ratio

1.05

The assumed ratio of the size of the building needed to house the system footprint to the system footprint to account for extra space for ancillary functions such as storage and ingress/egress

Production

Tilapia in RAS

Land size ratio

landSizeRatio

productionCalculations

calculated

Parameter

ratio

1.1

The assumed ratio of the size of the parcel of land needed to accomodate the production building to the size of the production building to accomodate parking and zoning considerations

Startup

Tilapia in RAS

Cost of land per acre

landCostAcre

startupSection

slider

Input

2500

50000

500

Estimated land cost per acre if needing to purchase land

Startup

Tilapia in RAS

Building cost

buildingCost

startupSection

slider

Input

100000

2000000

1000

Building cost if you are buying your building

Startup

Tilapia in RAS

Water supply cost

waterSupplyCost

startupSection

slider

Input

20000

100000

1000

Costs of construction related to bringing a water supply to the production buidling (e.g. digging a well and piping)

Startup

Tilapia in RAS

One-time startup permitting cost

permittingCost

startupSection

slider

Input

25000

100000

1000

Permitting cost for construction, environmental prior to start of operations.

Startup

Tilapia in RAS

Additional startup costs

miscCost

startupSection

slider

Input

20000

100

Special startup costs unique to your location (e.g. building a storage shed, unusual infrastructure costs)

Startup

Tilapia in RAS

Equipment cost ratio

equipmentCostRatio

startupCalculations

calculated

Parameter

$/lb

1.5

The assumed cost ratio of system equipment (tanks, pumps, filtration, etc.) as a function of the annual production weight

Startup

Tilapia in RAS

Engineering / construction cost ratio

engineeringCostRatio

startupCalculations

calculated

Parameter

$/lb

0.84

The assumed cost of engineering and construction to build the production facility as a function of the selected annual production weight

Startup

Tilapia in RAS

Other startup cost ratio

otherStartupCostRatio

startupCalculations

calculated

Parameter

$/lb

0.25

The assumed startup costs (e.g. pre-launch labor, training, system testing, pre-launch marketing, supply chain selection) to get the operation up and running

Startup

Tilapia in RAS

Land cost

landCost

startupSection

calculated

InputCalculated

1401.88759118967

2000000

1000

landRequired*landCostAcre

Land cost if you are buying your land

Startup

Tilapia in RAS

Equipment cost

equipmentCost

startupSection

calculated

InputCalculated

750000

lbsYear*equipmentCostRatio

The calculated equipment cost based on the selected production level and the assumed equipment cost ratio

Startup

Tilapia in RAS

Engineering / construction cost

engineeringCost

startupSection

calculated

InputCalculated

420000

lbsYear*engineeringCostRatio

The calculated engineering/construction cost based on the selected production level and the assumed engineering/construction cost ratio

Startup

Tilapia in RAS

Other startup costs

otherStartupCost

startupSection

calculated

InputCalculated

125000

lbsYear*otherStartupCostRatio

Other types of start up production costs which may be proportional to facility size and production levels could include public relations, pre-launch marketing, additional required labor, learning costs, and initial crop failures.

Startup

Tilapia in RAS

TOTAL startup cost

totalStartupCost

startupSection

calculated

InputCalculated

InputCalcTotal

1441401.88759119

landCost+buildingCost+waterSupplyCost+miscCost+equipmentCost+engineeringCost+otherStartupCost+permittingCost

The sum of all startup costs to get the operation ready to begin growing the first harvest

Operating

Tilapia in RAS

Product price

productPrice

operatingSection

slider

Input

0.25

The planned price per pound at which you will sell your product

Operating

Tilapia in RAS

Lease

leaseMonth

operatingSection

slider

Input

$/month

1000

10000

100

Rent or lease per month if you do not own the land and building

Operating

Tilapia in RAS

Feed price

feedPrice

operatingSection

slider

Input

$/lb

0.5

0.25

Price per pound of fish feed

Operating

Tilapia in RAS

Seed price

seedPrice

operatingSection

slider

Input

$/unit

0.35

0.05

Price of seedlings or fingerlings per unit.

Operating

Tilapia in RAS

Water treatment cost

waterTreatmentCost

operatingSection

slider

Input

$/gal/day

0.05

0.01

Cost per gallon per day to treat effluent.

Operating

Tilapia in RAS

Water price

waterPrice

operatingSection

slider

Input

$/acre-foot

200

Price of water per gallon

Operating

Tilapia in RAS

Contingency

contingencyCost

operatingSection

slider

Input

0.1

0.01

Contingency expense as a % of all other monthly expenses.

Operating

Tilapia in RAS

Overhead expense per month

overheadExpenseMonth

operatingSection

calculated

InputCalculated

4166.66666666667

overheadRatio*lbsYear/monthsToHarvest

The calculated overhead (management, adminstration, marketing etc.) expense per month based on the selected production level

Operating

Tilapia in RAS

Labor expense per month

laborExpenseMonth

operatingSection

calculated

InputCalculated

12083.3333333333

laborExpenseHarvest/monthsToHarvest

The calculated labor costs for production based on the selected production level and the assumed labor cost per pound of production

Operating

Tilapia in RAS

Feed expense per month

feedExpenseMonth

operatingSection

calculated

InputCalculated

27083.3333333333

feedPrice*feedConversionRatio*harvestWeight/monthsToHarvest

The calculated monthly cost of feed based on the annual production, the assumed feed conversion ratio, and the selected feed price

Operating

Tilapia in RAS

Seed expense per month

seedExpenseMonth

operatingSection

calculated

InputCalculated

16041.6666666667

harvestWeight/marketSizeLbs*(1+mortalityRate)*seedPrice/monthsToHarvest

The calculated monthly cost of seed based on the annual production, the assumed mortality rate, and the selected seed price

Operating

Tilapia in RAS

Water expense per month

waterExpenseMonth

operatingSection

calculated

InputCalculated

251

dailyWaterRequired*60*24*30/325821*waterPrice

The calculated cost of water per month based on the new water required per day x 30 days per month x the water price.

Operating

Tilapia in RAS

Water treatment expense per month

waterTreatmentExpenseMonth

operatingSection

calculated

InputCalculated

57500

systemWaterVolume*replacementWater*waterTreatmentCost*30

Monthly expense for water treatment based on system water volume, replacement water %, and cost per gallon per day.

Operating

Tilapia in RAS

Oxygenation expense per month

oxygenationExpenseMonth

operatingSection

calculated

InputCalculated

2083.33333333333

lbsYear*oxygenationExpenseRatio/12

Expense per month for oxygenation.

Operating

Tilapia in RAS

Energy expense per month

energyExpenseMonth

operatingSection

calculated

InputCalculated

14605.7103356417

(((12.338*buildingRequired)+4439)/12)*0.6

Energy expense per month based on an energy model for this type of facility in the Oregon climate and maintaining the operating temperature that is optimal for this species.

Operating

Tilapia in RAS

Supplies/Misc expense per month

suppliesMiscExpenseMonth

operatingSection

calculated

InputCalculated

8333.33333333333

suppliesMiscRatio*lbsYear/monthsToHarvest

The calculated monthly expenses for supplies and miscellaneous cost based on the production level and assumed supplies/misc ratio

Operating

Tilapia in RAS

Transportation expense per month

transportationExpenseMonth

operatingSection

calculated

InputCalculated

740

totTransportCost/12

The calcuated monthlly transportation costs for sourcing feed and shipping fish to market

Operating

Tilapia in RAS

Contingency expense per month

contingencyExpenseMonth

operatingSection

calculated

InputCalculated

14388.8377002308

monthlyExpense*contingencyCost

The monthly expense contingency.

Operating

Tilapia in RAS

Total MONTHLY expense without contingency

monthlyExpense

operatingSection

calculated

InputCalculated

143888.377002308

leaseMonth+laborExpenseMonth+feedExpenseMonth+seedExpenseMonth+waterExpenseMonth+waterTreatmentExpenseMonth+energyExpenseMonth+suppliesMiscExpenseMonth+overheadExpenseMonth+transportationExpenseMonth+oxygenationExpenseMonth+transportationExpenseMonth

The sum of all monthly operating expenses except the Contingency and Operating loan expenses.

Operating

Tilapia in RAS

ANNUAL expense prior to operating loan

annualExpenseNoOperatingLoan

operatingSection

calculated

InputCalculated

InputCalcExpense

1899326.57643047

(monthlyExpense*12)+(contingencyExpenseMonth*12)

The annual operting expenses prior to calculating operating loan expenses.

Operating

Tilapia in RAS

Operating loan interest rate

operatingLoanRate

operatingSection

slider

Input

0.06

0.15

0.001

The interest rate on the annual operating loan.

Operating

Tilapia in RAS

Operating loan annual expense

operatingLoanAnnualExpense

operatingSection

calculated

InputCalculated

91167.6756686625

annualExpenseNoOperatingLoan*operatingLoanRate*.8

The annual loan expense based on an operating loan for 80% of annual expenses.

Operating

Tilapia in RAS

ANNUAL expense including operating loan

annualExpenseWithOperatingLoan

operatingSection

calculated

InputCalculated

InputCalcExpense

1990494.25209913

annualExpenseNoOperatingLoan+operatingLoanAnnualExpense

The annual expenses for all operating expenses including the interest expense on the Operating Loan.

Operating

Tilapia in RAS

ANNUAL revenue

annualRevenue

operatingSection

calculated

InputCalculated

InputCalcRevenue

1500000

productPrice*lbsYear

The annual revenue based on the selected annual harvest size and the selected price per pound of the fish being sold

Operating

Tilapia in RAS

ANNUAL Net Gain/Loss without Startup Loan Financing

annualNetGainLoss

operatingSection

calculated

InputCalculated

InputCalcRevenue

-490494.252099132

annualRevenue-annualExpenseWithOperatingLoan

The operating gain or loss after subtracting annual expenses from annual revenue

Operating

Tilapia in RAS

Gross Profit Margin Ratio (Profitability %)

grossProfitMarginRatio

operatingSection

calculated

InputCalculated

InputCalcRevenue

-0.326996168066088

annualNetGainLoss/annualRevenue

This figure REPRESENTS AVERAGE ANNUAL PROFITABILITY compared to revenue. 0% means THE OPERATOR IS at breakeven. Negative numbers indicate the operation is LOSING MONEY.

Operating

Tilapia in RAS

Labor expense per pound

laborExpenseLb

operatingCalculations

calculated

Parameter

0.29

(-0.092)*Math.log(lbsYear)+1.4939

The assumed labor expense per pound of fish produced based on a logarithmic formula that approximates the economies of scale that result as annual production levels increase

Operating

Tilapia in RAS

Labor expense per harvest

laborExpenseHarvest

operatingCalculations

calculated

Parameter

72500

harvestWeight*laborExpenseLb

The assumed labor expense for a given harvest size

Operating

Tilapia in RAS

Feed conversion ratio (FCR)

feedConversionRatio

operatingCalculations

calculated

Parameter

ratio

1.3

The assumed ratio of of pounds of feed required to produce one pound of fish

Operating

Tilapia in RAS

Oxygenation expense ratio

oxygenationExpenseRatio

operatingCalculations

calculated

Parameter

ratio

0.05

Cost per pound of harvested fish for oxygenation.

Operating

Tilapia in RAS

Mortality rate

mortalityRate

operatingCalculations

calculated

Parameter

0.1

The assumed percentage of initially stocked juveniles that do not live to be harvested

Operating

Tilapia in RAS

Supplies/Misc ratio

suppliesMiscRatio

operatingCalculations

calculated

Parameter

$/lb

0.1

The assumed expense of supplies and miscellaneous materials per pound of fish produced

Operating

Tilapia in RAS

Overhead ratio

overheadRatio

operatingCalculations

calculated

Parameter

$/lb

0.05

The assumed expense of overhead expenses per pound of fish produced

Transportation

Tilapia in RAS

OTHER Transportation cost

otherTransportCost

transportationInputsCalc

slider

Input

50000

500

Other costs incurred for transportation (e.g. seed transporation, hired driver, rental truck, additional mileage costs)

Transportation

Tilapia in RAS

Distance to market

Miles to market

marketDistance

transportationInputsCalc

none

InputCalculated

miles

10000

The distance from the production facility to the market of processing facility

Transportation

Tilapia in RAS

Distance to feed

feedDistance

transportationInputsCalc

none

InputCalculated

miles

10000

The distance from the production facility to the feed mill that sources the feed supply

Transportation

Tilapia in RAS

Product pounds

productPounds

transportationInputsCalc

calculated

InputCalculated

lbs

500000

lbsYear

The selected annual production

Transportation

Tilapia in RAS

Product pounds plus ice

productPoundsIce

transportationInputsCalc

calculated

InputCalculated

lbs

750000

productPounds*1.5

The weight of the selected annual production plus 50% of that weight to account for the weight of ice during shipment of product to market

Transportation

Tilapia in RAS

Feed Pounds

Feed pounds

feedPounds

transportationInputsCalc

calculated

InputCalculated

lbs

650000

100000

500

feedConversionRatio*lbsYear

The calculated annual weight of feed based on the selected annual production and the assumed feed conversion ratio

Transportation

Tilapia in RAS

Total feed product shipping cost

feedTransportCost

transportationInputsCalc

calculated

InputCalculated

6110

feedLbTransportCost*feedPounds/2000*feedDistance

The calculated annual cost of transportation for shipping from the feed mill to the production facility

Transportation

Tilapia in RAS

Product to market transportation cost

Total product shipping cost

marketTransportCost

transportationInputsCalc

calculated

InputCalculated

2775

marketLbTransportCost*productPoundsIce/2000*marketDistance

The calculated annual cost of transportation for shipping product from the production facility to market

Transportation

Tilapia in RAS

Total Transportation cost

totTransportCost

transportationInputsCalc

calculated

InputCalculated

InputCalcTotal

8885

feedTransportCost+marketTransportCost+otherTransportCost

The sum of all annual transportation costs

Transportation

Tilapia in RAS

Feed shipping cost per ton mile

feedLbTransportCost

transportationParams

calculated

Parameter Fixed

$/ton-mile

0.94

The calculated cost to ship a ton of feed a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.

Transportation

Tilapia in RAS

Product shipping cost per ton mile

marketLbTransportCost

transportationParams

calculated

Parameter Fixed

$/ton-mile

0.74

The calculated cost to ship a ton of product a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.

Financing

Tilapia in RAS

Input: % funded with debt

Loan %

percFundedDebt

financingSection

slider

Input

0.8

0.01

1-percFundedEquity

The percentage of startup costs expected to be funded by loans

Financing

Tilapia in RAS

Input: % funded with equity

Equity %

percFundedEquity

financingSection

slider

Input

0.2

0.01

1-percFundedDebt

The percentage of startup costs expected to be funded by the owner or investor equity

Financing

Tilapia in RAS

Input: Loan Interest rate

Loan Interest rate

loanIntRate

financingSection

slider

Input

0.06

0.2

0.0025

Loan interest rate expected on any loan to cover startup costs

Financing

Tilapia in RAS

Input: Term of loan

Term of loan in years

termOfLoan

financingSection

slider

Input

years

Expected term of any loan to cover startup costs

Financing

Tilapia in RAS

Total start up cost

totStartupCosts2

financingSection

calculated

InputCalculated

1441401.88759119

totalStartupCost

The sum of all startup costs to get the operation ready to begin growing the first harvest

Financing

Tilapia in RAS

% funded with equity

_percFundedEquity

financingSection

calculated

InputCalculated

0.9

percFundedEquity

The percentage of startup costs expected to be funded by the owner or investor equity

Financing

Tilapia in RAS

% funded with debt

_percFundedDebt

financingSection

calculated

InputCalculated

0.1

percFundedDebt

The percentage of startup costs expected to be funded by loans

Financing

Tilapia in RAS

Equity investment required

equityInvestReq

financingSection

calculated

InputCalculated

288280.377518238

totalStartupCost*percFundedEquity

The amount of equity investment required based on the total startup costs and the selected percentage of the project funded with equity

Financing

Tilapia in RAS

Loan amount required

loanAmountReq

financingSection

calculated

InputCalculated

1153121.51007295

totalStartupCost-equityInvestReq

The amount of the loan required based on the total startup costs and the selected percentage of the project funded with debt

Financing

Tilapia in RAS

Loan Interest rate

_loanIntRate

financingSection

calculated

InputCalculated

0.06

loanIntRate

Loan interest rate expected on any loan to cover startup costs

Financing

Tilapia in RAS

Term of loan

_termOfLoan

financingSection

calculated

InputCalculated

years

termOfLoan

Expected term of any loan to cover startup costs

Financing

Tilapia in RAS

Monthly loan payment

MONTHLY loan payment

monthlyLoanPayment

financingSection

calculated

InputCalculated

InputCalcTotal

annualLoanPayment/12

The calculated monthly loan payment to retire the startup loan based on the size, term, and interest rate of the loan

Financing

Tilapia in RAS

Annual loan payments

ANNUAL loan expense

annualLoanPayment

financingSection

calculated

InputCalculated

The calculated annual debt service to retire the startup loan based on the size, term, and interest rate of the loan

Financing

Tilapia in RAS

ANNUAL Net Gain/Loss with Loan Financing

annualNetGainLossLoan

financingSection

calculated

InputCalculated

InputCalcRevenue

-490494.252099132

annualNetGainLoss-annualLoanPayment

The operating gain or loss after subtracting annual expenses, including debt service for the startup loan, from annual revenue

Financing

All

financingAmortization

calculated

Financial Summary

Tilapia in RAS

Feed

feedExpense

annualOperatingExpenses

calculated

Input

325000

feedExpenseMonth*12

Financial Summary

Tilapia in RAS

Seed

seedExpense

annualOperatingExpenses

calculated

Input

192500

seedExpenseMonth*12

Financial Summary

Tilapia in RAS

Water

waterExpense

annualOperatingExpenses

calculated

Input

3012

waterExpenseMonth*12

Financial Summary

Tilapia in RAS

Water Treatment

waterTreatmentExpense

annualOperatingExpenses

calculated

Input

690000

waterTreatmentExpenseMonth*12

Financial Summary

Tilapia in RAS

Oxygenation

oxygenationExpense

annualOperatingExpenses

calculated

Input

25000

oxygenationExpenseMonth*12

Financial Summary

Tilapia in RAS

Energy

energyExpense

annualOperatingExpenses

calculated

Input

175268.5240277

energyExpenseMonth*12

Financial Summary

Tilapia in RAS

Labor

laborExpense

annualOperatingExpenses

calculated

Input

145000

laborExpenseMonth*12

Financial Summary

Tilapia in RAS

Supplies & Misc

suppliesMiscExpense

annualOperatingExpenses

calculated

Input

100000

suppliesMiscExpenseMonth*12

Financial Summary

Tilapia in RAS

Transportation

transportationExpense

annualOperatingExpenses

calculated

Input

8885

totTransportCost

Financial Summary

Tilapia in RAS

Overhead

overheadExpense

annualOperatingExpenses

calculated

Input

50000

overheadExpenseMonth*12

Financial Summary

Tilapia in RAS

Contingency

contingencyExpense

annualOperatingExpenses

calculated

Input

172666.05240277

contingencyExpenseMonth*12

Financial Summary

Tilapia in RAS

Operating Loan

operatingLoanExpense

annualOperatingExpenses

calculated

Input

91167.6756686625

operatingLoanAnnualExpense

Financial Summary

Tilapia in RAS

Startup Loan

loanExpense

annualOperatingExpenses

calculated

Input

0.2

annualLoanPayment

Financial Summary

Tilapia in RAS

CHART: Annual Operating Expenses Without Startup Loan

chartAnnualOperExp

annualOperatingExpensesChart

chart

Chart

yrOperExpChart

Financial Summary

Tilapia in RAS

CHART: Annual Operating Expenses With Startup Loan

chartAnnualOperExpWLoan

annualOperatingExpensesChartWLoan

chart

Chart

yrOperExpWLoanChart

Financial Summary

Tilapia in RAS

CHART: Start up costs

chartStartupCosts

startupCostsChart

chart

Chart

startUpCosts

Production

Sturgeon in RAS

Market size (lb)

marketSizeLbs

productionSection

dropdown

LookupTable

lbs

0.1

[lut:growthRate>Market Weight]

Select the size of your whole fish product at which you will sell it to the market

Production

Sturgeon in RAS

Pounds/year

Target annual production

lbsYear

productionSection

slider

Input

lbs

500000

500

5000000

500

Select the size of your annual harvest

Production

Sturgeon in RAS

Space required

spaceRequired

productionRequired

calculated

RequiredResource

sq ft

74019.6648148148

systemWaterVolume*0.133681/avgTankDepth*spaceSizeRatio

The calculated space required for the RAS equipment based on the average tank depth, the surface area of the tanks based on the system water volume, and the space size ratio.

Production

Sturgeon in RAS

Building required

buildingRequired

productionRequired

calculated

RequiredResource

sq ft

116580.972083333

systemWaterVolume*0.133681/3*spaceSizeRatio*buildingSizeRatio

The calculated size of the building needed to house the system based on the production level

Production

Sturgeon in RAS

Land required

landRequired

productionRequired

calculated

RequiredResource

acres

2.80377518237935

systemWaterVolume*0.133681/3*spaceSizeRatio*landSizeRatio/43560

The calculated amount of land required for the building used to house the system based on the production level

Production

Sturgeon in RAS

New water required

dailyWaterRequired

productionRequired

calculated

RequiredResource

gal/minute

39.9305555555556

(systemWaterVolume*replacementWater)/(24*60)

The calculated amount of required new water per minute based on the replacement water % and the system water volume.

Production

Sturgeon in RAS

Flow rate required

flowRateRequired

productionRequired

calculated

RequiredResource

gal/minute

665.509259259259

systemWaterVolume/refillTime

The calculated amount of water needed to refill the system in an emergency situation based on the system water volume and the assumed refill time

Production

Sturgeon in RAS

Total system water volume

systemWaterVolume

productionRequired

calculated

RequiredResource

gallons

1916666.66666667

productionWaterVolume*sysProdRatio

The calcuated volume of water in the system based on the production level and the assumed carrying capacity

Production

Sturgeon in RAS

Harvests per year

harvestsPerYear

productionRequired

calculated

RequiredResource

0.6

12/monthsToHarvest

The calculated number of harvests per year based on the selected market size of the product and the assumed growth rate

Production

Sturgeon in RAS

Space available

spaceAvailable

productionRequired

slider

ExistingResource

sq ft

1500000

1000

[validate:spaceRequired]

Space available for the equipment in this production scenario

Production

Sturgeon in RAS

Building available

buildingAvailable

productionRequired

slider

ExistingResource

sq ft

1500000

1000

[validate:buildingRequired]

Select the size of the building in which you will house the system

Production

Sturgeon in RAS

Land available

landAvailable

productionRequired

slider

ExistingResource

acres

0.1

[validate:landRequired]

Select the amount of land you have available for the building housing the system

Production

Sturgeon in RAS

New water available

dailyWaterAvailable

productionRequired

slider

ExistingResource

gal/minute

100

[validate:dailyWaterRequired]

Select the amount of water you have available to replenish the system water daily due to effluent and evaporation losses

Production

Sturgeon in RAS

Max flow available

maxFlowAvailable

productionRequired

slider

ExistingResource

gal/minute

500

[validate:flowRateRequired]

Select the amount of water flow you have available for emergency refilling of the system due to a problem with water quality

Production

Sturgeon in RAS

Average tank depth

avgTankDepth

productionRequired

slider

ExistingResource

4.5

0.5

Select the average tank depth you have available. Most RAS systems have an average grow-out tank depth of 4.5 ft.

Production

Sturgeon in RAS

Months to harvest

Average months to harvest

monthsToHarvest

productionCalculations

calculated

Parameter

mos

[From DropDown for Market Weigth]

The assumed months required to grow the fish to the selected market size

Production

Sturgeon in RAS

Harvest weight

harvestWeight

productionCalculations

calculated

Parameter

lbs

833333.333333333

lbsYear/harvestsPerYear

The annual harvest divided by the number of harvests per year.

Production

Sturgeon in RAS

Carrying capacity

carryingCapacity

productionCalculations

calculated

Parameter

lbs/gallon

0.5

The assumed ratio of the maximum amount of pounds of fish per gallon of water in the production grow-out tanks

Production

Sturgeon in RAS

Production water volume

productionWaterVolume

productionCalculations

calculated

Parameter

gallons

1666666.66666667

harvestWeight/carryingCapacity

The assumed volume of water in the grow-out tanks based on the system water volume and the assumed system/production ratio

Production

Sturgeon in RAS

System / production ratio

sysProdRatio

productionCalculations

calculated

Parameter

ratio

1.15

The ratio of total water in the system to the volume of water in the production grow-out tanks

Production

Sturgeon in RAS

Replacement water

replacementWater

productionCalculations

calculated

Parameter

0.03

The percentage of system water volume per day that is discharged as effluent vs. treated and recirculated

Production

Sturgeon in RAS

Refill time

refillTime

productionCalculations

calculated

Parameter

days

The expert assumption for the time required to refill the system in the event of an emergency water quality problem.

Production

Sturgeon in RAS

System water surface area

systemWaterSurfaceArea

productionCalculations

calculated

Parameter

sq ft

56938.2037037037

systemWaterVolume*0.133681/avgTankDepth

The total system water surface area is calculated as the system volume multiplied by 0.1333681 divided by the average tank depth

Production

Sturgeon in RAS

Space size ratio

spaceSizeRatio

productionCalculations

calculated

Parameter

ratio

1.3

The assumed ratio of the size of the footprint of all of the system equipment to the footprint of the water tanks based calculated from the system water volume with an assumed 4 foot tank depth

Production

Sturgeon in RAS

Building size ratio

buildingSizeRatio

productionCalculations

calculated

Parameter

ratio

1.05

The assumed ratio of the size of the building needed to house the system footprint to the system footprint to account for extra space for ancillary functions such as storage and ingress/egress

Production

Sturgeon in RAS

Land size ratio

landSizeRatio

productionCalculations

calculated

Parameter

ratio

1.1

The assumed ratio of the size of the parcel of land needed to accomodate the production building to the size of the production building to accomodate parking and zoning considerations

Startup

Sturgeon in RAS

Cost of land per acre

landCostAcre

startupSection

slider

Input

2500

50000

500

Estimated land cost per acre if needing to purchase land

Startup

Sturgeon in RAS

Building cost

buildingCost

startupSection

slider

Input

100000

2000000

1000

Building cost if you are buying your building

Startup

Sturgeon in RAS

Water supply cost

waterSupplyCost

startupSection

slider

Input

20000

100000

1000

Costs of construction related to bringing a water supply to the production buidling (e.g. digging a well and piping)

Startup

Sturgeon in RAS

One-time startup permitting cost

permittingCost

startupSection

slider

Input

25000

100000

1000

Permitting cost for construction, environmental prior to start of operations.

Startup

Sturgeon in RAS

Additional startup costs

miscCost

startupSection

slider

Input

20000

100

Special startup costs unique to your location (e.g. building a storage shed, unusual infrastructure costs)

Startup

Sturgeon in RAS

Equipment cost ratio

equipmentCostRatio

startupCalculations

calculated

Parameter

$/lb

1.5

The assumed cost ratio of system equipment (tanks, pumps, filtration, etc.) as a function of the annual production weight

Startup

Sturgeon in RAS

Engineering / construction cost ratio

engineeringCostRatio

startupCalculations

calculated

Parameter

$/lb

0.84

The assumed cost of engineering and construction to build the production facility as a function of the selected annual production weight

Startup

Sturgeon in RAS

Other startup cost ratio

otherStartupCostRatio

startupCalculations

calculated

Parameter

$/lb

0.25

The assumed startup costs (e.g. pre-launch labor, training, system testing, pre-launch marketing, supply chain selection) to get the operation up and running

Startup

Sturgeon in RAS

Land cost

landCost

startupSection

calculated

InputCalculated

7009.43795594837

2000000

1000

landRequired*landCostAcre

Land cost if you are buying your land

Startup

Sturgeon in RAS

Equipment cost

equipmentCost

startupSection

calculated

InputCalculated

750000

lbsYear*equipmentCostRatio

The calculated equipment cost based on the selected production level and the assumed equipment cost ratio

Startup

Sturgeon in RAS

Engineering / construction cost

engineeringCost

startupSection

calculated

InputCalculated

420000

lbsYear*engineeringCostRatio

The calculated engineering/construction cost based on the selected production level and the assumed engineering/construction cost ratio

Startup

Sturgeon in RAS

Other startup costs

otherStartupCost

startupSection

calculated

InputCalculated

125000

lbsYear*otherStartupCostRatio

Startup

Sturgeon in RAS

TOTAL startup cost

totalStartupCost

startupSection

calculated

InputCalculated

InputCalcTotal

1447009.43795595

landCost+buildingCost+waterSupplyCost+miscCost+equipmentCost+engineeringCost+otherStartupCost+permittingCost

The sum of all startup costs to get the operation ready to begin growing the first harvest

Operating

Sturgeon in RAS

Product price

productPrice

operatingSection

slider

Input

0.25

The planned price per pound at which you will sell your product

Operating

Sturgeon in RAS

Lease

leaseMonth

operatingSection

slider

Input

$/month

1000

10000

100

Rent or lease per month if you do not own the land and building

Operating

Sturgeon in RAS

Feed price

feedPrice

operatingSection

slider

Input

$/lb

0.55

0.25

Price per pound of fish feed

Operating

Sturgeon in RAS

Seed price

seedPrice

operatingSection

slider

Input

$/unit

0.75

0.05

Price of seedlings or fingerlings per unit.

Operating

Sturgeon in RAS

Water treatment cost

waterTreatmentCost

operatingSection

slider

Input

$/gal/day

0.05

0.01

Cost per gallon per day to treat effluent.

Operating

Sturgeon in RAS

Water price

waterPrice

operatingSection

slider

Input

$/acre-foot

200

Price of water per gallon

Operating

Sturgeon in RAS

Contingency

contingencyCost

operatingSection

slider

Input

0.1

0.01

Contingency expense as a % of all other monthly expenses.

Operating

Sturgeon in RAS

Overhead expense per month

overheadExpenseMonth

operatingSection

calculated

InputCalculated

1250

overheadRatio*lbsYear/monthsToHarvest

The calculated overhead (management, adminstration, marketing etc.) expense per month based on the selected production level

Operating

Sturgeon in RAS

Labor expense per month

laborExpenseMonth

operatingSection

calculated

InputCalculated

11943.4403866167

laborExpenseHarvest/monthsToHarvest

The calculated labor costs for production based on the selected production level and the assumed labor cost per pound of production

Operating

Sturgeon in RAS

Feed expense per month

feedExpenseMonth

operatingSection

calculated

InputCalculated

41250

feedPrice*feedConversionRatio*harvestWeight/monthsToHarvest

The calculated monthly cost of feed based on the annual production, the assumed feed conversion ratio, and the selected feed price

Operating

Sturgeon in RAS

Seed expense per month

seedExpenseMonth

operatingSection

calculated

InputCalculated

6510.41666666667

harvestWeight/marketSizeLbs*(1+mortalityRate)*seedPrice/monthsToHarvest

The calculated monthly cost of seed based on the annual production, the assumed mortality rate, and the selected seed price

Operating

Sturgeon in RAS

Water expense per month

waterExpenseMonth

operatingSection

calculated

InputCalculated

370.602263205871

dailyWaterRequired*60*24*30/325821*waterPrice

The calculated cost of water per month based on the new water required per day x 30 days per month x the water price.

Operating

Sturgeon in RAS

Water treatment expense per month

waterTreatmentExpenseMonth

operatingSection

calculated

InputCalculated

86250

systemWaterVolume*replacementWater*waterTreatmentCost*30

Monthly expense for water treatment based on system water volume, replacement water %, and cost per gallon per day.

Operating

Sturgeon in RAS

Oxygenation expense per month

oxygenationExpenseMonth

operatingSection

calculated

InputCalculated

2083.33333333333

lbsYear*oxygenationExpenseRatio/12

Expense per month for oxygenation.

Operating

Sturgeon in RAS

Energy expense per month

energyExpenseMonth

operatingSection

calculated

InputCalculated

72140.7516782083

(((12.338*buildingRequired)+4439)/12)*0.6

Energy expense per month based on an energy model for this type of facility in the Oregon climate and maintaining the operating temperature that is optimal for this species.

Operating

Sturgeon in RAS

Supplies/Misc expense per month

suppliesMiscExpenseMonth

operatingSection

calculated

InputCalculated

2500

suppliesMiscRatio*lbsYear/monthsToHarvest

The calculated monthly expenses for supplies and miscellaneous cost based on the production level and assumed supplies/misc ratio

Operating

Sturgeon in RAS

Transportation expense per month

transportationExpenseMonth

operatingSection

calculated

InputCalculated

17512.5

totTransportCost/12

The calcuated monthlly transportation costs for sourcing feed and shipping fish to market

Operating

Sturgeon in RAS

Contingency expense per month

contingencyExpenseMonth

operatingSection

calculated

InputCalculated

24281.1044328031

monthlyExpense*contingencyCost

The monthly expense contingency.

Operating

Sturgeon in RAS

Total MONTHLY expense without contingency

monthlyExpense

operatingSection

calculated

InputCalculated

242811.044328031

The sum of all monthly operating expenses except the Contingency and Operating loan expenses.

Operating

Sturgeon in RAS

ANNUAL expense prior to operating loan

annualExpenseNoOperatingLoan

operatingSection

calculated

InputCalculated

InputCalcExpense

3205105.78513001

(monthlyExpense*12)+(contingencyExpenseMonth*12)

The annual operting expenses prior to calculating operating loan expenses.

Operating

Sturgeon in RAS

Operating loan interest rate

operatingLoanRate

operatingSection

slider

Input

0.06

0.15

0.001

The interest rate on the annual operating loan.

Operating

Sturgeon in RAS

Operating loan annual expense

operatingLoanAnnualExpense

operatingSection

calculated

InputCalculated

153845.07768624

annualExpenseNoOperatingLoan*operatingLoanRate*.8

The annual loan expense based on an operating loan for 80% of annual expenses.

Operating

Sturgeon in RAS

ANNUAL expense including operating loan

annualExpenseWithOperatingLoan

operatingSection

calculated

InputCalculated

InputCalcExpense

3358950.86281625

annualExpenseNoOperatingLoan+operatingLoanAnnualExpense

The annual expenses for all operating expenses including the interest expense on the Operating Loan.

Operating

Sturgeon in RAS

ANNUAL revenue

annualRevenue

operatingSection

calculated

InputCalculated

InputCalcRevenue

3000000

productPrice*lbsYear

The annual revenue based on the selected annual harvest size and the selected price per pound of the fish being sold

Operating

Sturgeon in RAS

ANNUAL Net Gain/Loss without Startup Loan Financing

ANNUAL Net Gain/Loss without Loan Financing

annualNetGainLoss

operatingSection

calculated

InputCalculated

InputCalcRevenue

-358950.862816249

annualRevenue-annualExpenseWithOperatingLoan

The operating gain or loss after subtracting annual expenses from annual revenue

Operating

Sturgeon in RAS

Gross Profit Margin Ratio (Profitability %)

grossProfitMarginRatio

operatingSection

calculated

InputCalculated

InputCalcRevenue

-0.119650287605416

annualNetGainLoss/annualRevenue

This figure REPRESENTS AVERAGE ANNUAL PROFITABILITY compared to revenue. 0% means THE OPERATOR IS at breakeven. Negative numbers indicate the operation is LOSING MONEY.

Operating

Sturgeon in RAS

Labor expense per pound

laborExpenseLb

operatingCalculations

calculated

Parameter

0.286642569278802

(-0.092)*Math.log(lbsYear)+1.4939

The assumed labor expense per pound of fish produced based on a logarithmic formula that approximates the economies of scale that result as annual production levels increase

Operating

Sturgeon in RAS

Labor expense per harvest

laborExpenseHarvest

operatingCalculations

calculated

Parameter

238868.807732335

harvestWeight*laborExpenseLb

The assumed labor expense for a given harvest size

Operating

Sturgeon in RAS

Feed conversion ratio (FCR)

feedConversionRatio

operatingCalculations

calculated

Parameter

ratio

1.8

The assumed ratio of of pounds of feed required to produce one pound of fish

Operating

Sturgeon in RAS

Oxygenation expense ratio

oxygenationExpenseRatio

operatingCalculations

calculated

Parameter

ratio

0.05

Cost per pound of harvested fish for oxygenation.

Operating

Sturgeon in RAS

Mortality rate

mortalityRate

operatingCalculations

calculated

Parameter

0.25

The assumed percentage of initially stocked juveniles that do not live to be harvested

Operating

Sturgeon in RAS

Supplies/Misc ratio

suppliesMiscRatio

operatingCalculations

calculated

Parameter

$/lb

0.1

The assumed expense of supplies and miscellaneous materials per pound of fish produced

Operating

Sturgeon in RAS

Overhead ratio

overheadRatio

operatingCalculations

calculated

Parameter

$/lb

0.05

The assumed expense of overhead expenses per pound of fish produced

Transportation

Sturgeon in RAS

OTHER Transportation cost

otherTransportCost

transportationInputsCalc

slider

Input

50000

500

Other costs incurred for transportation (e.g. seed transporation, hired driver, rental truck, additional mileage costs)

Transportation

Sturgeon in RAS

Distance to market

Miles to market

marketDistance

transportationInputsCalc

none

InputCalculated

miles

300

10000

The distance from the production facility to the market of processing facility

Transportation

Sturgeon in RAS

Distance to feed

feedDistance

transportationInputsCalc

none

InputCalculated

miles

300

10000

The distance from the production facility to the feed mill that sources the feed supply

Transportation

Sturgeon in RAS

Product pounds

productPounds

transportationInputsCalc

calculated

InputCalculated

lbs

500000

lbsYear

The selected annual production

Transportation

Sturgeon in RAS

Product pounds plus ice

productPoundsIce

transportationInputsCalc

calculated

InputCalculated

lbs

750000

productPounds*1.5

The weight of the selected annual production plus 50% of that weight to account for the weight of ice during shipment of product to market

Transportation

Sturgeon in RAS

Feed Pounds

Feed pounds

feedPounds

transportationInputsCalc

calculated

InputCalculated

lbs

900000

100000

500

feedConversionRatio*lbsYear

The calculated annual weight of feed based on the selected annual production and the assumed feed conversion ratio

Transportation

Sturgeon in RAS

Total feed product shipping cost

feedTransportCost

transportationInputsCalc

calculated

InputCalculated

126900

feedLbTransportCost*feedPounds/2000*feedDistance

The calculated annual cost of transportation for shipping from the feed mill to the production facility

Transportation

Sturgeon in RAS

Product to market transportation cost

Total product shipping cost

marketTransportCost

transportationInputsCalc

calculated

InputCalculated

83250

marketLbTransportCost*productPoundsIce/2000*marketDistance

The calculated annual cost of transportation for shipping product from the production facility to market

Transportation

Sturgeon in RAS

Total Transportation cost

totTransportCost

transportationInputsCalc

calculated

InputCalculated

InputCalcTotal

210150

feedTransportCost+marketTransportCost+otherTransportCost

The sum of all annual transportation costs

Transportation

Sturgeon in RAS

Feed shipping cost per ton mile

feedLbTransportCost

transportationParams

calculated

Parameter Fixed

$/ton-mile

0.94

The calculated cost to ship a ton of feed a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.

Transportation

Sturgeon in RAS

Product shipping cost per ton mile

marketLbTransportCost

transportationParams

calculated

Parameter Fixed

$/ton-mile

0.74

The calculated cost to ship a ton of product a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.

Financing

Sturgeon in RAS

Input: % funded with debt

Loan %

percFundedDebt

financingSection

slider

Input

0.8

0.01

1-percFundedEquity

The percentage of startup costs expected to be funded by loans

Financing

Sturgeon in RAS

Input: % funded with equity

Equity %

percFundedEquity

financingSection

slider

Input

0.2

0.01

1-percFundedDebt

The percentage of startup costs expected to be funded by the owner or investor equity

Financing

Sturgeon in RAS

Input: Loan Interest rate

Loan Interest rate

loanIntRate

financingSection

slider

Input

0.06

0.2

0.0025

Loan interest rate expected on any loan to cover startup costs

Financing

Sturgeon in RAS

Input: Term of loan

Term of loan in years

termOfLoan

financingSection

slider

Input

years

Expected term of any loan to cover startup costs

Financing

Sturgeon in RAS

Total start up cost

totStartupCosts2

financingSection

calculated

InputCalculated

1447009.43795595

totalStartupCost

The sum of all startup costs to get the operation ready to begin growing the first harvest

Financing

Sturgeon in RAS

% funded with equity

_percFundedEquity

financingSection

calculated

InputCalculated

0.9

percFundedEquity

The percentage of startup costs expected to be funded by the owner or investor equity

Financing

Sturgeon in RAS

% funded with debt

_percFundedDebt

financingSection

calculated

InputCalculated

0.1

percFundedDebt

The percentage of startup costs expected to be funded by loans

Financing

Sturgeon in RAS

Equity investment required

equityInvestReq

financingSection

calculated

InputCalculated

289401.88759119

totalStartupCost*percFundedEquity

The amount of equity investment required based on the total startup costs and the selected percentage of the project funded with equity

Financing

Sturgeon in RAS

Loan amount required

loanAmountReq

financingSection

calculated

InputCalculated

1157607.55036476

totalStartupCost-equityInvestReq

The amount of the loan required based on the total startup costs and the selected percentage of the project funded with debt

Financing

Sturgeon in RAS

Loan Interest rate

_loanIntRate

financingSection

calculated

InputCalculated

0.06

loanIntRate

Loan interest rate expected on any loan to cover startup costs

Financing

Sturgeon in RAS

Term of loan

_termOfLoan

financingSection

calculated

InputCalculated

years

termOfLoan

Expected term of any loan to cover startup costs

Financing

Sturgeon in RAS

Monthly loan payment

MONTHLY loan payment

monthlyLoanPayment

financingSection

calculated

InputCalculated

InputCalcTotal

annualLoanPayment/12

The calculated monthly loan payment to retire the startup loan based on the size, term, and interest rate of the loan

Financing

Sturgeon in RAS

Annual loan payments

ANNUAL loan expense

annualLoanPayment

financingSection

calculated

InputCalculated

The calculated annual debt service to retire the startup loan based on the size, term, and interest rate of the loan

Financing

Sturgeon in RAS

ANNUAL Net Gain/Loss with Loan Financing

annualNetGainLossLoan

financingSection

calculated

InputCalculated

InputCalcRevenue

-358950.862816249

annualNetGainLoss-annualLoanPayment

The operating gain or loss after subtracting annual expenses, including debt service for the startup loan, from annual revenue

Financial Summary

Sturgeon in RAS

Feed

feedExpense

annualOperatingExpenses

calculated

Input

495000

feedExpenseMonth*12

Financial Summary

Sturgeon in RAS

Seed

seedExpense

annualOperatingExpenses

calculated

Input

78125

seedExpenseMonth*12

Financial Summary

Sturgeon in RAS

Water

waterExpense

annualOperatingExpenses

calculated

Input

4447.22715847045

waterExpenseMonth*12

Financial Summary

Sturgeon in RAS

Water Treatment

waterTreatmentExpense

annualOperatingExpenses

calculated

Input

1035000

waterTreatmentExpenseMonth*12

Financial Summary

Sturgeon in RAS

Oxygenation

oxygenationExpense

annualOperatingExpenses

calculated

Input

25000

oxygenationExpenseMonth*12

Financial Summary

Sturgeon in RAS

Energy

energyExpense

annualOperatingExpenses

calculated

Input

865689.0201385

energyExpenseMonth*12

Financial Summary

Sturgeon in RAS

Labor

laborExpense

annualOperatingExpenses

calculated

Input

143321.284639401

laborExpenseMonth*12

Financial Summary

Sturgeon in RAS

Supplies & Misc

suppliesMiscExpense

annualOperatingExpenses

calculated

Input

30000

suppliesMiscExpenseMonth*12

Financial Summary

Sturgeon in RAS

Transportation

transportationExpense

annualOperatingExpenses

calculated

Input

750000

totTransportCost

Financial Summary

Sturgeon in RAS

Overhead

overheadExpense

annualOperatingExpenses

calculated

Input

15000

overheadExpenseMonth*12

Financial Summary

Sturgeon in RAS

Contingency

contingencyExpense

annualOperatingExpenses

calculated

Input

210150

contingencyExpenseMonth*12

Financial Summary

Sturgeon in RAS

Operating Loan

operatingLoanExpense

annualOperatingExpenses

calculated

Input

153845.07768624

operatingLoanAnnualExpense

Financial Summary

Sturgeon in RAS

Startup Loan

loanExpense

annualOperatingExpenses

calculated

Input

annualLoanPayment

Financial Summary

Sturgeon in RAS

CHART: Annual Operating Expenses Without Startup Loan

chartAnnualOperExp

annualOperatingExpensesChart

chart

Chart

yrOperExpChart

Financial Summary

Sturgeon in RAS

CHART: Annual Operating Expenses With Startup Loan

chartAnnualOperExpWLoan

annualOperatingExpensesChartWLoan

chart

Chart

yrOperExpWLoanChart

Financial Summary

Sturgeon in RAS

CHART: Start up costs

chartStartupCosts

startupCostsChart

chart

Chart

startUpCosts

Production

Hybrid Striped Bass in Pond

Market size (lb)

marketSizeLbs

productionSection

dropdown

LookupTable

lbs

1.5

0.1

[lut:growthRate>Market Weight]

Select the size of your whole fish product at which you will sell it to the market

Production

Hybrid Striped Bass in Pond

Pounds/year

Target annual production

lbsYear

productionSection

slider

Input

lbs

25000

500

5000000

500

Select the size of your annual harvest

Production

Hybrid Striped Bass in Pond

Land required

landRequired

productionRequired

calculated

RequiredResource

acres

9.33333333333333

acresProductionSurfaceArea*landSizeRatio

The calculated amount of land required based on the production surface area and the land size ratio. Note that this does not account for collection ponds or effluent ponds.

Production

Hybrid Striped Bass in Pond

New water required

dailyWaterRequired

productionRequired

calculated

RequiredResource

gal/minute

475.230525

systemWaterVolume/replacementWater/24/60

The calculated amount of required new water per day based on the Water replacement interval and the system water volume.

Production

Hybrid Striped Bass in Pond

Flow rate required

flowRateRequired

productionRequired

calculated

RequiredResource

gal/minute

316.82035

systemWaterVolume/refillTime/24/60

The calculated required flow rate from the water source needed to refill the system in the event of an emergency water quality problem.

Production

Hybrid Striped Bass in Pond

System water volume

systemWaterVolume

productionRequired

calculated

RequiredResource

gallons

13686639.12

productionWaterVolume*sysProdRatio

The total water in the system derived from the production water volume and the system/production ratio.

Production

Hybrid Striped Bass in Pond

Harvests per year

harvestsPerYear

productionRequired

calculated

RequiredResource

0.75

12/monthsToHarvest

The calculated number of harvests per year based on the selected market size of the product and the assumed growth rate

Production

Hybrid Striped Bass in Pond

Land available

landAvailable

productionRequired

slider

ExistingResource

acres

3000

[validate:landRequired]

Select the amount of land you have available for the ponds and equipment

Production

Hybrid Striped Bass in Pond

Daily water available

dailyWaterAvailable

productionRequired

slider

ExistingResource

gal/day

200000000

10000

[validate:dailyWaterRequired]

Select the amount of water you have available to replenish the system daily due to effluent and evaporation losses

Production

Hybrid Striped Bass in Pond

Max flow available

maxFlowAvailable

productionRequired

slider

ExistingResource

gal/day

2500000000

100000

[validate:flowRateRequired]

Select the amount of water you have available for emergency refilling of the system due to a problem with water quality

Production

Hybrid Striped Bass in Pond

Average pond depth

avgPondDepth

productionRequired

slider

ExistingResource

4.5

0.1

The average depth of the growout ponds.

Production

Hybrid Striped Bass in Pond

Months to harvest

Average months to harvest

monthsToHarvest

productionCalculations

calculated

Parameter

mos

[From DropDown for Market Weigth]

The assumed months required to grow the fish to the selected market size

Production

Hybrid Striped Bass in Pond

Harvest weight

harvestWeight

productionCalculations

calculated

Parameter

lbs

33333.3333333333

lbsYear/harvestsPerYear

The annual harvest divided by the number of harvests per year.

Production

Hybrid Striped Bass in Pond

Carrying capacity

carryingCapacity

productionCalculations

calculated

Parameter

lb/acre

5000

The expert assumption for the maximum weight of biomass at harvest per acre of surface area in the growout ponds.

Production

Hybrid Striped Bass in Pond

Acres of production surface area

acresProductionSurfaceArea

productionCalculations

calculated

Parameter

acres

6.66666666666667

harvestWeight/carryingCapacity

The calculated acres of surface area in the production ponds based on the harvest pounds and the carrying capacity.

Production

Hybrid Striped Bass in Pond

Production water volume

productionWaterVolume

productionCalculations

calculated

Parameter

gallons

9776170.8

acresProductionSurfaceArea*43560*avgPondDepth*7.481

The assumed volume of water in the grow-out ponds based on the system water volume and the assumed system/production ratio

Production

Hybrid Striped Bass in Pond

System / production ratio

sysProdRatio

productionCalculations

calculated

Parameter

ratio

1.4

The expert assumption for the ratio of the water used in the growout ponds to the total water in the system for other uses including nursery ponds.

Production

Hybrid Striped Bass in Pond

Water replacement interval

replacementWater

productionCalculations

calculated

Parameter

days

The expert assumption for the number of days to fully replace the water due to seepage, evaporation, and effluent.

Production

Hybrid Striped Bass in Pond

Refill time

refillTime

productionCalculations

calculated

Parameter

days

The expert assumption for the time required to refill the system in the event of an emergency water quality problem.

Production

Hybrid Striped Bass in Pond

Land size ratio

landSizeRatio

productionCalculations

calculated

Parameter

ratio

1.4

The expert assumption for the amount of land required as a function of the surface area of the ponds.

Startup

Hybrid Striped Bass in Pond

Cost of land per acre

landCostAcre

startupSection

slider

Input

2500

50000

500

Estimated land cost per acre if needing to purchase land

Startup

Hybrid Striped Bass in Pond

Structure cost

buildingCost

startupSection

slider

Input

2000000

1000

Building cost if you are buying your building

Startup

Hybrid Striped Bass in Pond

Water supply cost

waterSupplyCost

startupSection

slider

Input

20000

100000

1000

Costs of construction related to bringing a water supply to the production buidling (e.g. digging a well and piping)

Startup

Hybrid Striped Bass in Pond

One-time startup permitting cost

permittingCost

startupSection

slider

Input

25000

100000

1000

Permitting cost for construction, environmental prior to start of operations.

Startup

Hybrid Striped Bass in Pond

Additional startup costs

miscCost

startupSection

slider

Input

500000

1000

This is additional startup costs you are anticipating (eg. Storage shed, construction of collection ponds or effluent ponds).

Startup

Hybrid Striped Bass in Pond

Equipment cost ratio

equipmentCostRatio

startupCalculations

calculated

Parameter

$/lb

1.14

The assumed cost ratio of system equipment (tanks, pumps, filtration, etc.) as a function of the annual production weight

Startup

Hybrid Striped Bass in Pond

Engineering / construction cost ratio

engineeringCostRatio

startupCalculations

calculated

Parameter

$/acre

2000

The expert assumption of the ratio of the engineering and construction cost to build a pond facility required to grow a given annual harvest.

Startup

Hybrid Striped Bass in Pond

Other startup cost ratio

otherStartupCostRatio

startupCalculations

calculated

Parameter

$/lb

0.82

The expert assumption of other cost to build a facility required to grow a given annual harvest.

Startup

Hybrid Striped Bass in Pond

Land cost

landCost

startupSection

calculated

InputCalculated

23333.3333333333

landRequired*landCostAcre

Land cost if you are buying your land

Startup

Hybrid Striped Bass in Pond

Equipment cost

equipmentCost

startupSection

calculated

InputCalculated

28500

lbsYear*equipmentCostRatio

The calculated equipment cost based on the annual harvest and the equipment cost ratio.

Startup

Hybrid Striped Bass in Pond

Engineering / construction cost

engineeringCost

startupSection

calculated

InputCalculated

18666.6666666667

landRequired*engineeringCostRatio

The calculated engineering/construction cost based on the acres required and the cost-per-acre engineering/construction cost ratio.

Startup

Hybrid Striped Bass in Pond

Other startup costs

otherStartupCost

startupSection

calculated

InputCalculated

20500

lbsYear*otherStartupCostRatio

The calculated other startup cost based on the annual harvest and the other startup cost ratio. This could include pre-launch marketing, labor during the startup year prior to beginning the initial crop, initial crop failures etc.

Startup

Hybrid Striped Bass in Pond

TOTAL startup cost

totalStartupCost

startupSection

calculated

InputCalculated

InputCalcTotal

136000

landCost+buildingCost+waterSupplyCost+miscCost+equipmentCost+engineeringCost+otherStartupCost+permittingCost

The sum of all startup costs to get the operation ready to begin growing the first harvest

Operating

Hybrid Striped Bass in Pond

Product price

productPrice

operatingSection

slider

Input

2.4

0.25

The planned price per pound at which you will sell your product

Operating

Hybrid Striped Bass in Pond

Lease

leaseMonth

operatingSection

slider

Input

$/month

10000

100

Rent or lease per month if you do not own the land and building

Operating

Hybrid Striped Bass in Pond

Feed price

feedPrice

operatingSection

slider

Input

$/lb

0.5

0.25

Price per pound of fish feed

Operating

Hybrid Striped Bass in Pond

Seed price

seedPrice

operatingSection

slider

Input

$/unit

0.35

0.05

Price per unit of seedlings or fingerlings

Operating

Hybrid Striped Bass in Pond

Water price

waterPrice

operatingSection

slider

Input

$/acre-foot

200

Price of water per gallon. Note that this cost is sensitive to the replacement water required. If high volumes of replacement water are required and there is a non-diminimus cost of water, the profitability of the venture will be challenged.

Operating

Hybrid Striped Bass in Pond

Contingency

contingencyCost

operatingSection

slider

Input

0.1

0.01

Contingency expense as a % of all other monthly expenses.

Operating

Hybrid Striped Bass in Pond

Overhead expense per month

overheadExpenseMonth

operatingSection

calculated

InputCalculated

78.125

overheadRatio*lbsYear/monthsToHarvest

The caluclated overhead expense based on the harvest size, months to harvest, and overhead ratio.

Operating

Hybrid Striped Bass in Pond

Labor expense per month

laborExpenseMonth

operatingSection

calculated

InputCalculated

1171.35403842869

laborExpenseHarvest/monthsToHarvest

The labor expense per month based on the labor expense per harvest and the number of months to reach the harvest.

Operating

Hybrid Striped Bass in Pond

Feed expense per month

feedExpenseMonth

operatingSection

calculated

InputCalculated

2395.83333333333

feedPrice*feedConversionRatio*harvestWeight/monthsToHarvest

The cost of feed per month calculated from the harvest size, months to harvest, feed conversion ratio, and feed price.

Operating

Hybrid Striped Bass in Pond

Seed expense per month

seedExpenseMonth

operatingSection

calculated

InputCalculated

656.25

harvestWeight/marketSizeLbs*(1+mortalityRate)*seedPrice/monthsToHarvest

The calculated cost of seed per month based on the number of fish in the harvest, the number of months to harvest, and the price of seed.

Operating

Hybrid Striped Bass in Pond

Water expense per month

waterExpenseMonth

operatingSection

calculated

InputCalculated

4410.2890818196

dailyWaterRequired*60*24*30/325851*waterPrice

The calculated cost of water per month based on the new water required per day (expressed in acre-feet) x 30 days per month x the water price.

Operating

Hybrid Striped Bass in Pond

Energy expense per month

energyExpenseMonth

operatingSection

calculated

InputCalculated

258.333333333333

lbsYear*operatingEnergyRatio/12

The calculated energy expense based on the harvest size and the Opertating Energy Ratio.

Operating

Hybrid Striped Bass in Pond

Supplies/Misc expense per month

suppliesMiscExpenseMonth

operatingSection

calculated

InputCalculated

156.25

suppliesMiscRatio*lbsYear/monthsToHarvest

The caluculated supplies/misc expense per month based on the harvest size, months to harvest, and supplies/misc ratio.

Operating

Hybrid Striped Bass in Pond

Transportation expense per month

transportationExpenseMonth

operatingSection

calculated

InputCalculated

1022.5

totTransportCost/12

The calcuated monthlly transportation costs for sourcing feed and shipping fish to market

Operating

Hybrid Striped Bass in Pond

Contingency expense per month

contingencyExpenseMonth

operatingSection

calculated

InputCalculated

912.643478691496

monthlyExpense*contingencyCost

The monthly expense contingency.

Operating

Hybrid Striped Bass in Pond

Total MONTHLY expense without contingency

monthlyExpense

operatingSection

calculated

InputCalculated

9126.43478691496

leaseMonth+laborExpenseMonth+feedExpenseMonth+seedExpenseMonth+waterExpenseMonth+energyExpenseMonth+suppliesMiscExpenseMonth+overheadExpenseMonth+transportationExpenseMonth

The sum of all monthly operating expenses before the contingency.

Operating

Hybrid Striped Bass in Pond

ANNUAL expense prior to operating loan

annualExpenseNoOperatingLoan

operatingSection

calculated

InputCalculated

InputCalcExpense

120468.939187277

(monthlyExpense*12)+(contingencyExpenseMonth*12)

The annual operting expenses prior to calculating operating loan expenses.

Operating

Hybrid Striped Bass in Pond

Operating loan interest rate

operatingLoanRate

operatingSection

slider

Input

0.06

0.150

0.001

The interest rate on the annual operating loan.

Operating

Hybrid Striped Bass in Pond

Operating loan annual expense

operatingLoanAnnualExpense

operatingSection

calculated

InputCalculated

5782.50908098932

annualExpenseNoOperatingLoan*operatingLoanRate*.8

Interest expense assuming 80% of the annual expenses are financed by the Operating Loan.

Operating

Hybrid Striped Bass in Pond

ANNUAL expense including operating loan

annualExpenseWithOperatingLoan

operatingSection

calculated

InputCalculated

InputCalcExpense

126251.448268267

annualExpenseNoOperatingLoan+operatingLoanAnnualExpense

Annual expenses including the operating loan interest.

Operating

Hybrid Striped Bass in Pond

ANNUAL revenue

annualRevenue

operatingSection

calculated

InputCalculated

InputCalcRevenue

60000

productPrice*lbsYear

The annual revenue based on the annual harvest weight and the market price per pound.

Operating

Hybrid Striped Bass in Pond

ANNUAL Net Gain/Loss without Startup Loan Financing

annualNetGainLoss

operatingSection

calculated

InputCalculated

InputCalcRevenue

-66251.4482682668

annualRevenue-annualExpenseWithOperatingLoan

The annual operating profit or loss calculated by subtracting the annual expenses from the annual revenue.

Operating

Hybrid Striped Bass in Pond

Gross Profit Margin Ratio (Profitability %)

grossProfitMarginRatio

operatingSection

calculated

InputCalculated

InputCalcRevenue

-1.10419080447111

annualNetGainLoss/annualRevenue

This is a figure of merit indicating the magnitude of the profit as compared to the revenue. 0% means you are at breakeven. Negative numbers indicate the operation is not making money but are otherwise arbitrary.

Operating

Hybrid Striped Bass in Pond

Labor expense per pound

laborExpenseLb

operatingCalculations

calculated

Parameter

0.562249938445769

(-0.092)*Math.log(lbsYear)+1.4939

The expert assumption of the labor expense as a function of the harvest weight.

Operating

Hybrid Striped Bass in Pond

Labor expense per harvest

laborExpenseHarvest

operatingCalculations

calculated

Parameter

18741.664614859

harvestWeight*laborExpenseLb

The labor expense for a given harvest based on the harvest weight and the labor expense per pound expert assumption.

Operating

Hybrid Striped Bass in Pond

Feed conversion ratio (FCR)

feedConversionRatio

operatingCalculations

calculated

Parameter

ratio

2.3

The expert assumption of the feed conversion ratio for this species.

Operating

Hybrid Striped Bass in Pond

Mortality rate

mortalityRate

operatingCalculations

calculated

Parameter

0.35

The assumed percentage of initially stocked juveniles that do not live to be harvested

Operating

Hybrid Striped Bass in Pond

Operating energy ratio

operatingEnergyRatio

operatingCalculations

calculated

Parameter

$/lb

0.124

The expert assumption of the cost of the energy required as a function of the harvest weight

Operating

Hybrid Striped Bass in Pond

Supplies/Misc ratio

suppliesMiscRatio

operatingCalculations

calculated

Parameter

$/lb

0.1

The expert assumption for ratio of supplies (e.g. chemicals) per pound of fish at harvest

Operating

Hybrid Striped Bass in Pond

Overhead ratio

overheadRatio

operatingCalculations

calculated

Parameter

$/lb

0.05

The expert assumption for the ratio of overhead expense per pound of fish at harvest . This accounts for the costs of management, accounting, marketing, insurance and other administrative expenses.

Transportation

Hybrid Striped Bass in Pond

OTHER Transportation cost

otherTransportCost

transportationInputsCalc

slider

Input

50000

500

Other costs incurred for transportation (e.g. seed transporation, hired driver, rental truck, additional mileage costs)

Transportation

Hybrid Striped Bass in Pond

Distance to market

Miles to market

marketDistance

transportationInputsCalc

none

InputCalculated

miles

300

10000

The distance from the production facility to the market of processing facility

Transportation

Hybrid Striped Bass in Pond

Distance to feed

feedDistance

transportationInputsCalc

none

InputCalculated

miles

300

10000

The distance from the production facility to the feed mill that sources the feed supply

Transportation

Hybrid Striped Bass in Pond

Product pounds

productPounds

transportationInputsCalc

calculated

InputCalculated

lbs

25000

lbsYear

The selected annual production

Transportation

Hybrid Striped Bass in Pond

Product pounds plus ice

productPoundsIce

transportationInputsCalc

calculated

InputCalculated

lbs

37500

productPounds*1.5

The weight of the selected annual production plus 50% of that weight to account for the weight of ice during shipment of product to market

Transportation

Hybrid Striped Bass in Pond

Feed Pounds

Feed pounds

feedPounds

transportationInputsCalc

calculated

InputCalculated

lbs

57500

100000

500

feedConversionRatio*lbsYear

The calculated annual weight of feed based on the selected annual production and the assumed feed conversion ratio

Transportation

Hybrid Striped Bass in Pond

Total feed product shipping cost

feedTransportCost

transportationInputsCalc

calculated

InputCalculated

8107.5

feedLbTransportCost*feedPounds/2000*feedDistance

The calculated annual cost of transportation for shipping from the feed mill to the production facility

Transportation

Hybrid Striped Bass in Pond

Product to market transportation cost

Total product shipping cost

marketTransportCost

transportationInputsCalc

calculated

InputCalculated

4162.5

marketLbTransportCost*productPoundsIce/2000*marketDistance

The calculated annual cost of transportation for shipping product from the production facility to market

Transportation

Hybrid Striped Bass in Pond

Total Transportation cost

totTransportCost

transportationInputsCalc

calculated

InputCalculated

InputCalcTotal

12270

feedTransportCost+marketTransportCost+otherTransportCost

The sum of all annual transportation costs

Transportation

Hybrid Striped Bass in Pond

Feed shipping cost per ton mile

feedLbTransportCost

transportationParams

calculated

Parameter Fixed

$/ton-mile

0.94

The calculated cost to ship a ton of feed a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.

Transportation

Hybrid Striped Bass in Pond

Product shipping cost per ton mile

marketLbTransportCost

transportationParams

calculated

Parameter Fixed

$/ton-mile

0.74

The calculated cost to ship a ton of product a distance of one mile base on transportation tables in the tables_calculations tab derived from quotations from shipping companies.

Financing

Hybrid Striped Bass in Pond

Input: % funded with debt

Loan %

percFundedDebt

financingSection

slider

Input

0.2

0.01

1-percFundedEquity

The percentage of cost to build the facility and cover the initial year of startup cost prior to beginning your first crop that will be financed with loans.

Financing

Hybrid Striped Bass in Pond

Input: % funded with equity

Equity %

percFundedEquity

financingSection

slider

Input

0.8

0.01

1-percFundedDebt

The percentage of cost to build the facility and cover the initial year of startup cost prior to beginning your first crop that will be financed with equity from the owner or investors.

Financing

Hybrid Striped Bass in Pond

Input: Loan Interest rate

Loan Interest rate

loanIntRate

financingSection

slider

Input

0.06

0.2

0.0025

Loan interest rate expected on any loan to cover startup costs

Financing

Hybrid Striped Bass in Pond

Input: Term of loan

Term of loan in years

termOfLoan

financingSection

slider

Input

years

Expected term of any loan to cover startup costs

Financing

Hybrid Striped Bass in Pond

Total start up cost

totStartupCosts2

financingSection

calculated

InputCalculated

136000

totalStartupCost

The sum of all startup costs to get the operation ready to begin growing the first harvest

Financing

Hybrid Striped Bass in Pond

% funded with equity

_percFundedEquity

financingSection

calculated

InputCalculated

0.8

percFundedEquity

The percentage of startup costs expected to be funded by the owner or investor equity

Financing

Hybrid Striped Bass in Pond

% funded with debt

_percFundedDebt

financingSection

calculated

InputCalculated

0.2

percFundedDebt

The percentage of startup costs expected to be funded by loans

Financing

Hybrid Striped Bass in Pond

Equity investment required

equityInvestReq

financingSection

calculated

InputCalculated

108800

totalStartupCost*percFundedEquity

The amount of equity investment required based on the total startup costs and the selected percentage of the project funded with equity

Financing

Hybrid Striped Bass in Pond

Loan amount required

loanAmountReq

financingSection

calculated

InputCalculated

27200

totalStartupCost-equityInvestReq

The amount of the loan required based on the total startup costs and the selected percentage of the project funded with debt

Financing

Hybrid Striped Bass in Pond

Loan Interest rate

_loanIntRate

financingSection

calculated

InputCalculated

0.06

loanIntRate

Loan interest rate expected on any loan to cover startup costs

Financing

Hybrid Striped Bass in Pond

Term of loan

_termOfLoan

financingSection

calculated

InputCalculated

years

termOfLoan

Expected term of any loan to cover startup costs

Financing

Hybrid Striped Bass in Pond

Monthly loan payment

monthlyLoanPayment

financingSection

calculated

InputCalculated

InputCalcTotal

annualLoanPayment/12

The calculated monthly loan payment to retire the startup loan based on the size, term, and interest rate of the loan

Financing

Hybrid Striped Bass in Pond

Annual loan payments

Annual loan expense

annualLoanPayment

financingSection

calculated

InputCalculated

The calculated annual debt service to retire the startup loan based on the size, term, and interest rate of the loan

Financing

Hybrid Striped Bass in Pond

ANNUAL Net Gain/Loss with Loan Financing

annualNetGainLossLoan

financingSection

calculated

InputCalculated

InputCalcRevenue

126251.448268267

annualNetGainLoss-annualLoanPayment

The annual operating profit or loss calculated by subtracting the annual expenses plus the loan interest cost from the annual revenue

Financial Summary

Hybrid Striped Bass in Pond

Feed

feedExpense

annualOperatingExpenses

calculated

Input

28750

feedExpenseMonth*12

Financial Summary

Hybrid Striped Bass in Pond

Seed

seedExpense

annualOperatingExpenses

calculated

Input

7875

seedExpenseMonth*12

Financial Summary

Hybrid Striped Bass in Pond

Water

waterExpense

annualOperatingExpenses

calculated

Input

52923.4689818353

waterExpenseMonth*12

Financial Summary

Hybrid Striped Bass in Pond

Electricity

energyExpense

annualOperatingExpenses

calculated

Input

3100

energyExpenseMonth*12

Financial Summary

Hybrid Striped Bass in Pond

Labor

laborExpense

annualOperatingExpenses

calculated

Input

14056.2484611442

laborExpenseMonth*12

Financial Summary

Hybrid Striped Bass in Pond

Supplies & Misc

suppliesMiscExpense

annualOperatingExpenses

calculated

Input

1875

suppliesMiscExpenseMonth*12

Financial Summary

Hybrid Striped Bass in Pond

Transportation

transportationExpense

annualOperatingExpenses

calculated

Input

12270

totTransportCost

Financial Summary

Hybrid Striped Bass in Pond

Overhead

overheadExpense

annualOperatingExpenses

calculated

Input

937.5

overheadExpenseMonth*12

Financial Summary

Hybrid Striped Bass in Pond

Contingency

contingencyExpense

annualOperatingExpenses

calculated

Input

109517.21744298

contingencyExpenseMonth*12

Financial Summary

Hybrid Striped Bass in Pond

Operating Loan

operatingLoanExpense

annualOperatingExpenses

calculated

Input

5782.50908098932

operatingLoanAnnualExpense

Financial Summary

Hybrid Striped Bass in Pond

Startup Loan

loanExpense

annualOperatingExpenses

calculated

Input

annualLoanPayment

Financial Summary

Hybrid Striped Bass in Pond

CHART: Annual Operating Expenses Without Startup Loan

chartAnnualOperExp

annualOperatingExpensesChart

chart

Chart

yrOperExpChartPond

Financial Summary

Hybrid Striped Bass in Pond

CHART: Annual Operating Expenses With Startup Loan

chartAnnualOperExpWLoan

annualOperatingExpensesChartWLoan

chart

Chart

yrOperExpWLoanChartPond

Financial Summary

Hybrid Striped Bass in Pond

CHART: Start up costs

chartStartupCosts

startupCostsChart

chart

Chart

startUpCostsPond

Supported Interfaces: REST


Format: