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