Excel Sample Sheet 40723 | Final Urban Farm Business Plan Worksheets

Partial file snippet.

Sheet 1: Introduction

	
	
		Partnership for Sustainable Communities
	
	
		

	
	
		

	
	
		

	
	
		

	
	
		

	
	
		Urban Farm Business Plan
	
	
		Worksheets
	
	
		Please use in conjunction with the Urban Farm Business Plan Handbook
	
	
		

	
	
		

	
	
		

	
	
		

	
	
		

	
	
		

	
	
		

	
	
		EPA-905-K-11-002
	
	
		July 2011
	
	
		

	
	
		Prepared for:
	
	
		U.S. Environmental Protection Agency
	
	
		Region 5 
	
	
		Chicago, IL 60604
	



Sheet 2: Worksheet #17 Planning

	
	
	
	
	
	
	
	
	
	
	
	
	
		Business Name
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Hoop House
		

		

		

		User can change the values in these cells to optimize outputs.
		

		

		

		

		

		

	
	
		Total Length
		90
		ft
		

		

		

		

		

		

		

	
	
		Total Width
		30
		ft
		

		Pre-set formula's that will be calculated by Excel
		

		

		

		

		

		

	
	
		Width of Row
		1.5
		ft
		

		

		

		

		

		

		

	
	
		Footpath Area
		30%
		percent
		

		

		

		

		

		

		

		

		

		

	
	
		Tool Storage Area
		25
		ft2
		

		

		

		

		

		

		

		

		

		

	
	
		Composting Area
		25
		ft2
		

		

		

		

		

		

		

		

		

		

	
	
		Other
		50
		ft2
		

		

		

		

		

		

		

		

		

		

	
	
		TOTAL GROWING AREA
		1790
		ft2
		

		

		

		

		

		

		

		

		

		

	
	
		TOTAL BED LENGTH
		1193
		ft
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Growing Medium
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Depth
		18
		inches
		

		

		

		

		

		

		

		

		

		

	
	
		TOTAL SOIL VOLUME
		895
		yards
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Data Entry and Calculations
		
	
		Crop
		Percent of Total Growing Area
		Crops
		

		Inputs
		
	
		Distance Between Plants (ft)
		Time to Maturity (from seed) (days)
		Yield (per plant)  (pounds)
		Yield (per foot of row) (pounds)
		Market Price (per pound) ($)
		

		Seed/ Starter ($/plant)
		Nutrients ($/ft2/day)
		Pest Control ($/ft2/day)
		Water ($/ft2/day)
		TOTAL COST OF INPUTS ($/ft2/day)
	
	
		Tomatoes
		25%
		1.5
		130
		5
		3.3
		 $2.00 
		

		 $0.010 
		 $0.001 
		 $0.001 
		 $0.001 
		 $0.003 
	
	
		Strawberries
		10%
		0.75
		90
		3
		4.0
		 $1.50 
		

		 $0.010 
		 $0.001 
		 $0.001 
		 $0.001 
		 $0.003 
	
	
		Salad Greens
		25%
		0.25
		45
		0.2
		0.8
		 $3.00 
		

		 $0.010 
		 $0.001 
		 $0.001 
		 $0.001 
		 $0.004 
	
	
		Collards
		25%
		1
		90
		1.5
		1.5
		 $1.00 
		

		 $0.010 
		 $0.001 
		 $0.001 
		 $0.001 
		 $0.003 
	
	
		Beets
		15%
		0.33
		120
		3
		9.0
		 $1.00 
		

		 $0.010 
		 $0.001 
		 $0.001 
		 $0.001 
		 $0.003 
	
	
		

		0%
		0
		0
		0
		0.0
		 $-   
		

		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
	
	
		

		0%
		0
		0
		0
		0.0
		 $-   
		

		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
	
	
		

		0%
		0
		0
		0
		0.0
		 $-   
		

		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
	
	
		

		0%
		0
		0
		0
		0.0
		 $-   
		

		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
	
	
		

		0%
		0
		0
		0
		0.0
		 $-   
		

		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
	
	
		

		0%
		0
		0
		0
		0.0
		 $-   
		

		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
	
	
		

		0%
		0
		0
		0
		0.0
		 $-   
		

		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
	
	
		

		0%
		0
		0
		0
		0.0
		 $-   
		

		 $-   
		 $-   
		 $-   
		 $-   
		 $-   
	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Crop Yield
		

		

		

		

	
	
		Business Name
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		Crop
		Percent of Total Growing Area
		Total Length of Row (ft)
		Expected Annual Yield
		Value of Annual Yield
		Annual Cost of Inputs
		

		

		

		

	
	
		3 Season (lbs)
		4 Season (lbs)
		3 Season
		4 Season
		3 Season
		4 Season
		

		

		

		

	
	
		Tomatoes
		25%
		298
		2094
		2792
		 $4,188 
		 $5,584 
		 $374 
		 $498 
		

		

		

		

	
	
		Strawberries
		10%
		119
		1452
		1936
		 $2,904 
		 $2,904 
		 $154 
		 $206 
		

		

		

		

	
	
		Salad Greens
		25%
		298
		1452
		1936
		 $2,904 
		 $5,808 
		 $476 
		 $635 
		

		

		

		

	
	
		Collards
		25%
		298
		1361
		1815
		 $2,722 
		 $1,815 
		 $381 
		 $508 
		

		

		

		

	
	
		Beets
		15%
		179
		3675
		4900
		 $7,350 
		 $4,900 
		 $239 
		 $319 
		

		

		

		

	
	
		0
		0%
		0
		0
		0
		 $-   
		 $-   
		 $-   
		 $-   
		

		

		

		

	
	
		0
		0%
		0
		0
		0
		 $-   
		 $-   
		 $-   
		 $-   
		

		

		

		

	
	
		0
		0%
		0
		0
		0
		 $-   
		 $-   
		 $-   
		 $-   
		

		

		

		

	
	
		0
		0%
		0
		0
		0
		 $-   
		 $-   
		 $-   
		 $-   
		

		

		

		

	
	
		0
		0%
		0
		0
		0
		 $-   
		 $-   
		 $-   
		 $-   
		

		

		

		

	
	
		0
		0%
		0
		0
		0
		 $-   
		 $-   
		 $-   
		 $-   
		

		

		

		

	
	
		0
		0%
		0
		0
		0
		 $-   
		 $-   
		 $-   
		 $-   
		

		

		

		

	
	
		0
		0%
		0
		0
		0
		 $-   
		 $-   
		 $-   
		 $-   
		

		

		

		

	
	
		

		100%
		1193
		

		

		 $20,068 
		 $21,011 
		 $1,624 
		 $2,166 
		

		

		

		

	



Sheet 3: Worksheet # 23 Expenses

	
	
	
	
	
	
	
	
		Detailed Expenses
		

		

		

		

		 Year 1 
		 Year 2 
		 Year 3 
		 Year 4 
		 Year 5 
		 Assumptions 
	
	
		

		

		

		

		

		

		

		

		

		

		Assumption for annual adjustment for inflation   %
	
	
		Direct Farm Operating Costs
		

		

		

		

		

		

		

		

		

		Identify any additional assumptions used to develop the expense estimates
	
	
		

		Annual setup and removal
		

		

		

		

		

		

		

		

		

	
	
		

		

		Hoop house-temporary
		

		

		

		

		

		

		

		

	
	
		

		

		Vertical garden
		

		

		

		

		

		

		

		

	
	
		

		

		Other
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total annual setup and removal
		 -   
		 -   
		 -   
		 -   
		 -   
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Repairs and Maintenance
		

		

		

		

		

		

		

		

		

	
	
		

		

		Repairs and Maintenance
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total repairs and maintenance
		 -   
		 -   
		 -   
		 -   
		 -   
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Equipment and Tools
		

		

		

		

		

		

		

		

		

	
	
		

		

		Fuel
		

		

		

		

		

		

		

		

	
	
		

		

		Equipment leases (long-term)
		

		

		

		

		

		

		

		

	
	
		

		

		Rentals (short-term or daily)
		

		

		

		

		

		

		

		

	
	
		

		

		Processing equipment
		

		

		

		

		

		

		

		

	
	
		

		

		Tools
		

		

		

		

		

		

		

		

	
	
		

		

		Tractor
		

		

		

		

		

		

		

		

	
	
		

		

		Truck
		

		

		

		

		

		

		

		

	
	
		

		

		Other
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total equipment
		 -   
		 -   
		 -   
		 -   
		 -   
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Seed & Soil Materials
		

		

		

		

		

		

		

		

		

	
	
		

		

		Fertilizers and pesticides
		

		

		

		

		

		

		

		

	
	
		

		

		Seed/seedlings
		

		

		

		

		

		

		

		

	
	
		

		

		Soil preparation
		

		

		

		

		

		

		

		

	
	
		

		

		Supplies
		

		

		

		

		

		

		

		

	
	
		

		

		Other
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total materials
		 -   
		 -   
		 -   
		 -   
		 -   
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Human Resources & Personnel 
		

		

		

		

		

		

		

		

		

	
	
		

		

		Direct Farm Payroll
		

		

		

		

		

		

		

		

	
	
		

		

		

		Manager salaries
		

		

		

		

		

		

		

	
	
		

		

		

		Hourly payroll
		

		

		

		

		

		

		

	
	
		

		

		

		Temporary workers
		

		

		

		

		

		

		

	
	
		

		

		

		Benefits
		

		

		

		

		

		

		

	
	
		

		

		

		Workers compensation insurance
		

		

		

		

		

		

		

	
	
		

		

		

		Payroll taxes
		

		

		

		

		

		

		

	
	
		

		

		

		Payroll service fees
		

		

		

		

		

		

		

	
	
		

		

		Volunteer expenses
		

		

		

		

		

		

		

		

	
	
		

		

		Administrative payroll
		

		

		

		

		

		

		

		

	
	
		

		

		Training and professional development
		

		

		

		

		

		

		

		

	
	
		

		

		Professional
		

		

		

		

		

		

		

		

	
	
		

		

		

		Accounting
		

		

		

		

		

		

		

	
	
		

		

		

		Consulting
		

		

		

		

		

		

		

	
	
		

		

		

		Contractors
		

		

		

		

		

		

		

	
	
		

		

		

		Legal
		

		

		

		

		

		

		

	
	
		

		

		

		Other
		

		

		

		

		

		

		

	
	
		

		

		

		

		Total human resources
		 -   
		 -   
		 -   
		 -   
		 -   
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Sales and Distribution
		

		

		

		

		

		

		

		

		

	
	
		

		

		Delivery 
		

		

		

		

		

		

		

		

	
	
		

		

		Fuel, travel & vehicles
		

		

		

		

		

		

		

		

	
	
		

		

		Packaging materials (crates, bags)
		

		

		

		

		

		

		

		

	
	
		

		

		Storage
		

		

		

		

		

		

		

		

	
	
		

		

		Rent
		

		

		

		

		

		

		

		

	
	
		

		

		Other
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total sales and distribution
		 -   
		 -   
		 -   
		 -   
		 -   
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Marketing and Advertising
		

		

		

		

		

		

		

		

		

	
	
		

		

		Advertising
		

		

		

		

		

		

		

		

	
	
		

		

		Direct marketing
		

		

		

		

		

		

		

		

	
	
		

		

		Mailing and advertising supplies
		

		

		

		

		

		

		

		

	
	
		

		

		Postage
		

		

		

		

		

		

		

		

	
	
		

		

		Public and press  relations
		

		

		

		

		

		

		

		

	
	
		

		

		Signs
		

		

		

		

		

		

		

		

	
	
		

		

		Web site and web advertising
		

		

		

		

		

		

		

		

	
	
		

		

		Licensing
		

		

		

		

		

		

		

		

	
	
		

		

		Other
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total marketing and advertising
		 -   
		 -   
		 -   
		 -   
		 -   
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		Utilities
		

		

		

		

		

		

		

		

		

	
	
		

		

		Electric
		

		

		

		

		

		

		

		

	
	
		

		

		Telephone
		

		

		

		

		

		

		

		

	
	
		

		

		Water
		

		

		

		

		

		

		

		

	
	
		

		

		Sewer
		

		

		

		

		

		

		

		

	
	
		

		

		Heat (oil, gas)
		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total utilities
		 -   
		 -   
		 -   
		 -   
		 -   
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		General and Administrative
		

		

		

		

		

		

		

		

		

		

	
	
		

		Bank Charges
		

		

		

		

		

		

		

		

		

	
	
		

		Computers
		

		

		

		

		

		

		

		

		

	
	
		

		Insurance
		

		

		

		

		

		

		

		

		

	
	
		

		

		Liability
		

		

		

		

		

		

		

		

	
	
		

		

		Property & Casualty
		

		

		

		

		

		

		

		

	
	
		

		Licenses, permits, and fees
		

		

		

		

		

		

		

		

		

	
	
		

		Miscellaneous
		

		

		

		

		

		

		

		

		

	
	
		

		Office equipment
		

		

		

		

		

		

		

		

		

	
	
		

		Postage
		

		

		

		

		

		

		

		

		

	
	
		

		Rent and leases
		

		

		

		

		

		

		

		

		

	
	
		

		Supplies
		

		

		

		

		

		

		

		

		

	
	
		

		Taxes - entity or corporation
		

		

		

		

		

		

		

		

		

	
	
		

		Taxes - property
		

		

		

		

		

		

		

		

		

	
	
		

		Other
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total general and administrative
		 -   
		 -   
		 -   
		 -   
		 -   
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		One-Time or Start-up Costs
		

		

		

		

		

		

		

		

		

		

	
	
		

		Deposits with public utilities
		

		

		

		

		

		

		

		

		

	
	
		

		Promotion for opening
		

		

		

		

		

		

		

		

		

	
	
		

		Signs
		

		

		

		

		

		

		

		

		

	
	
		

		Web ordering system
		

		

		

		

		

		

		

		

		

	
	
		

		Other
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total start-up costs
		 -   
		 -   
		 -   
		 -   
		 -   
		

	
	
		

		

		

		

		

		

		

		

		

		

		

	
	
		Non-cash expenses
		

		

		

		

		

		

		

		

		

		

	
	
		

		Depreciation
		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		Total non-cash expenses
		 -   
		 -   
		 -   
		 -   
		 -

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet introduction partnership for sustainable communities urban farm business plan worksheets please use in conjunction with the handbook epak july prepared us environmental protection agency region chicago il worksheet planning name hoop house user can change values these cells to optimize outputs total length ft width preset formula s that will be calculated by excel of row footpath area percent tool storage composting other growing bed medium depth inches soil volume yards data entry and calculations crop crops inputs distance between plants time maturity from seed days yield per plant pounds foot market price pound starter nutrients ftday pest control water cost tomatoes strawberries salad greens collards beets expected annual value season lbs expenses detailed year assumptions assumption adjustment inflation direct operating costs identify any additional used develop expense estimates setup removal housetemporary vertical garden repairs maintenance equipment tools fuel leases lon...

Related files

Share

Help

*Business Name*
Hoop House				User can change the values in these cells to optimize outputs.
Total Length	90	ft
Total Width	30	ft		Pre-set formula's that will be calculated by Excel
Width of Row	1.5	ft		Pre-set formula's that will be calculated by Excel
Footpath Area	30%	percent
Tool Storage Area	25	ft2
Composting Area	25	ft2
Other	50	ft2
TOTAL GROWING AREA	1790	ft2
TOTAL BED LENGTH	1193	ft

Growing Medium
Depth	18	inches
TOTAL SOIL VOLUME	895	yards

Data Entry and Calculations
Crop	Percent of Total Growing Area	Crops						Inputs
Crop	Percent of Total Growing Area	Distance Between Plants (ft)	Time to Maturity (from seed) (days)	Yield (per plant) (pounds)	Yield (per foot of row) (pounds)	Market Price (per pound) ($)		Seed/ Starter ($/plant)	Nutrients ($/ft2/day)	Pest Control ($/ft2/day)	Water ($/ft2/day)	TOTAL COST OF INPUTS ($/ft2/day)
Tomatoes	25%	1.5	130	5	3.3	$2.00		$0.010	$0.001	$0.001	$0.001	$0.003
Strawberries	10%	0.75	90	3	4.0	$1.50		$0.010	$0.001	$0.001	$0.001	$0.003
Salad Greens	25%	0.25	45	0.2	0.8	$3.00		$0.010	$0.001	$0.001	$0.001	$0.004
Collards	25%	1	90	1.5	1.5	$1.00		$0.010	$0.001	$0.001	$0.001	$0.003
Beets	15%	0.33	120	3	9.0	$1.00		$0.010	$0.001	$0.001	$0.001	$0.003
	0%	0	0	0	0.0	$-		$-	$-	$-	$-	$-
	0%	0	0	0	0.0	$-		$-	$-	$-	$-	$-
	0%	0	0	0	0.0	$-		$-	$-	$-	$-	$-
	0%	0	0	0	0.0	$-		$-	$-	$-	$-	$-
	0%	0	0	0	0.0	$-		$-	$-	$-	$-	$-
	0%	0	0	0	0.0	$-		$-	$-	$-	$-	$-
	0%	0	0	0	0.0	$-		$-	$-	$-	$-	$-
	0%	0	0	0	0.0	$-		$-	$-	$-	$-	$-


Crop Yield
*Business Name*
Crop	Percent of Total Growing Area	Total Length of Row (ft)	Expected Annual Yield		Value of Annual Yield		Annual Cost of Inputs
Crop	Percent of Total Growing Area	Total Length of Row (ft)	3 Season (lbs)	4 Season (lbs)	3 Season	4 Season	3 Season	4 Season
Tomatoes	25%	298	2094	2792	$4,188	$5,584	$374	$498
Strawberries	10%	119	1452	1936	$2,904	$2,904	$154	$206
Salad Greens	25%	298	1452	1936	$2,904	$5,808	$476	$635
Collards	25%	298	1361	1815	$2,722	$1,815	$381	$508
Beets	15%	179	3675	4900	$7,350	$4,900	$239	$319
0	0%	0	0	0	$-	$-	$-	$-
0	0%	0	0	0	$-	$-	$-	$-
0	0%	0	0	0	$-	$-	$-	$-
0	0%	0	0	0	$-	$-	$-	$-
0	0%	0	0	0	$-	$-	$-	$-
0	0%	0	0	0	$-	$-	$-	$-
0	0%	0	0	0	$-	$-	$-	$-
0	0%	0	0	0	$-	$-	$-	$-
	100%	1193			$20,068	$21,011	$1,624	$2,166

Detailed Expenses					Year 1	Year 2	Year 3	Year 4	Year 5	Assumptions
										Assumption for annual adjustment for inflation %
Direct Farm Operating Costs										Identify any additional assumptions used to develop the expense estimates
	Annual setup and removal
		Hoop house-temporary
		Vertical garden
		Other
				Total annual setup and removal	-	-	-	-	-

	Repairs and Maintenance
		Repairs and Maintenance
				Total repairs and maintenance	-	-	-	-	-

	Equipment and Tools
		Fuel
		Equipment leases (long-term)
		Rentals (short-term or daily)
		Processing equipment
		Tools
		Tractor
		Truck
		Other
				Total equipment	-	-	-	-	-

	Seed & Soil Materials
		Fertilizers and pesticides
		Seed/seedlings
		Soil preparation
		Supplies
		Other
				Total materials	-	-	-	-	-

	Human Resources & Personnel
		Direct Farm Payroll
			Manager salaries
			Hourly payroll
			Temporary workers
			Benefits
			Workers compensation insurance
			Payroll taxes
			Payroll service fees
		Volunteer expenses
		Administrative payroll
		Training and professional development
		Professional
			Accounting
			Consulting
			Contractors
			Legal
			Other
				Total human resources	-	-	-	-	-

	Sales and Distribution
		Delivery
		Fuel, travel & vehicles
		Packaging materials (crates, bags)
		Storage
		Rent
		Other
				Total sales and distribution	-	-	-	-	-

	Marketing and Advertising
		Advertising
		Direct marketing
		Mailing and advertising supplies
		Postage
		Public and press relations
		Signs
		Web site and web advertising
		Licensing
		Other
				Total marketing and advertising	-	-	-	-	-

	Utilities
		Electric
		Telephone
		Water
		Sewer
		Heat (oil, gas)
				Total utilities	-	-	-	-	-

General and Administrative
	Bank Charges
	Computers
	Insurance
		Liability
		Property & Casualty
	Licenses, permits, and fees
	Miscellaneous
	Office equipment
	Postage
	Rent and leases
	Supplies
	Taxes - entity or corporation
	Taxes - property
	Other
				Total general and administrative	-	-	-	-	-

One-Time or Start-up Costs
	Deposits with public utilities
	Promotion for opening
	Signs
	Web ordering system
	Other
				Total start-up costs	-	-	-	-	-

Non-cash expenses
	Depreciation
				Total non-cash expenses	-	-	-	-	-

Related files

Share

Share to social media

Help

Login Area