Spreadsheet For Tracking Business Expenses 40717 | Eco Microgreens Budgeting Tool

Partial file snippet.

Sheet 1: Costs Detail

	
	
	
	
	
	
	
	
	
	
	
	
		

		MICROGREENS COST TRACKING
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		Cost per pound of micros
		

	
	
		Fixed cost?
		
		ECO City Farms:
These costs items are for example
		EXPENSES  (EXCLUDING CAPITAL INVESTMENT)
		

		Hours/Units
		Rate
		Weekly
		Yearly
		Variety #1
		Variety #2
		Variety #3
		Variety #4
		Assumptions:
	
	
		

		STAFF COSTS
		

		

		

		$34.00 
		$1,768.00 
		Averages -
Based on per pound
		

	
	
		Yes
		Staff Costs - farmer
		

		0
		$20.00 
		$0.00 
		$0.00 
		

		

		

		

		ALL based on weekly pounds sold  x 52 weeks/yr.  = ### pounds
	
	
		

		Cost per batch
		

		

		

		

		

		$40.00 
		$40.00 
		$40.00 
		0
		

	
	
		

		Hours spent per batch
		

		

		

		

		

		2
		2
		2
		0
		

	
	
		

		Avg pounds per batch
		

		

		

		

		

		12.00
		15
		15
		0
		

	
	
		

		Cost per pound
		

		

		

		

		

		$3.33 
		$2.67 
		$2.67 
		#DIV/0!
		

	
	
		Yes
		Business management time: customer communication/ billing, etc.
		

		2
		$17.00 
		$34.00 
		$1,768.00
		$2.27 
		$2.27 
		$2.27 
		$2.27
		averaged across week - more of a fixed cost
	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		SEED COSTS
		

		

		

		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		

	
	
		

		Quantity of Seeds in lbs
		

		

		

		

		

		$0.00
		$0.00
		$0.00
		$0.00
		

	
	
		

		Cost of seeds in pounds
		

		

		

		

		

		$0.00
		$0.00
		$0.00
		$0.00
		

	
	
		No
		Costs of Seeds per produced pound
		

		

		

		$0.00 
		$0.00 
		

		

		

		

		

	
	
		No
		SOIL SUPPLIES
		

		

		

		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		

	
	
		

		Amendments
		

		

		

		$0.00 
		$0.00 
		$0.00
		$0.00
		$0.00
		$0.00
		

	
	
		

		Etc.
		

		

		

		$0.00 
		

		$0.00
		$0.00
		$0.00
		$0.00
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		No
		PACKAGING
		

		

		

		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		

	
	
		

		Individual boxes
		

		

		$0.35 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		Actual  unit cost
	
	
		

		Bags
		

		

		$0.04 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		Actual  unit cost
	
	
		

		Labels
		

		

		$0.03 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		Assumes you have a printer to print them on
	
	
		

		OTHER
		

		

		

		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		

	
	
		Yes
		Tools and Equipment
		

		

		

		

		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		

	
	
		No
		Electricity  & Water
		

		

		

		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		Guesstimate annual cost divided by weekly packages sold = 780
	
	
		

		Pest Control
		

		

		

		

		$0.00 
		$0.00 
		$0.00 
		$0.00 
		$0.00 
		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		TOTAL
		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		$34.00 
		$0.00 
		$0.00 
		$2.27 
		

		

		Cost per pound
	
	
		

		

		

		

		

		cost to produce ## pounds
		

		$0.00 
		$1.13 
		

		

		Cost per 8 oz package
	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		
		Amanda West:
Divide capital costs by to either amortize across years or within first year.
		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		TOTAL EXPENSES:
		

		

		

		

		$1,768.00 
		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		INCOME
		

		UNIT SIZE
		# SOLD
		PRICE/ UNIT
		WEEKLY TOTAL
		

		

		

		

		Income per 8 oz package
	
	
		

		

		

		

		

		

		

		

		 $-   
		

		

		Income per 30 packages sold
	
	
		

		Client/ Outlet #1
		

		

		0
		$0.00 
		$0.00 
		

		 $-   
		

		

		Income per 30 8 oz packages x 1 month
	
	
		

		Client/ Outlet #2
		

		

		

		

		

		$0.00 
		($1.13)
		

		

		Profit per 8 oz package
	
	
		

		Client/ Outlet #3
		

		

		

		

		

		

		($2.27)
		

		

		Profit per pound
	
	
		

		

		

		

		

		

		

		$0.00 
		($34.00)
		

		

		Profit per 30 packages sold
	
	
		

		

		

		

		

		

		

		

		($136.00)
		

		

		Profit 30 per week x 1 month
	
	
		

		TOTAL INCOME:
		

		

		

		

		

		#DIV/0!
		#DIV/0!
		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		

		

		

		

		

		

		

		

		

		

		

	
	
		

		
		ECO City Farms:
These are sample capital expenses which may need needed for growing microgreens.
		Initial Capital Investment in Microgreens Operation
		

		YEAR 1
		

		

		Annual Profit
		

		

		

		

		

	
	
		

		Nursery Benches
		

		$13,500.00 
		

		

		Percentage of profit
		

		

		

		

		

	
	
		

		Heating System
		

		$4,000.00 
		

		

		

		

		

		

		

		

	
	
		

		Fans
		

		$300.00 
		

		

		

		

		

		

		

		

	
	
		

		Harvesting and Packing Equipment
		

		$300.00 
		

		

		

		

		

		

		

		

	
	
		

		Total Initial Investments
		

		$18,100.00

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

...Sheet costs detail microgreens cost tracking per pound of micros fixed eco city farms these items are for example expenses excluding capital investment hoursunits rate weekly yearly variety assumptions staff averages based on yes farmer all pounds sold x weeksyr batch hours spent avg div business management time customer communication billing etc averaged across week more a seed quantity seeds in lbs no produced soil supplies amendments packaging individual boxes actual unit bags labels assumes you have printer to print them other tools and equipment electricity amp water guesstimate annual divided by packages pest control total produce oz package amanda west divide either amortize years or within first year income size price client outlet month profit sample which may need needed growing initial operation nursery benches percentage heating system fans harvesting packing investments...

Related files

Share

Help

	MICROGREENS COST TRACKING
						Cost per pound of micros
Fixed cost?	ECO City Farms: These costs items are for example EXPENSES (EXCLUDING CAPITAL INVESTMENT)	Hours/Units	Rate	Weekly	Yearly	Variety #1	Variety #2	Variety #3	Variety #4	Assumptions:
	STAFF COSTS			$34.00	$1,768.00	Averages - Based on per pound
Yes	Staff Costs - farmer	0	$20.00	$0.00	$0.00					ALL based on weekly pounds sold x 52 weeks/yr. = ### pounds
	Cost per batch					$40.00	$40.00	$40.00	0
	Hours spent per batch					2	2	2	0
	Avg pounds per batch					12.00	15	15	0
	Cost per pound					$3.33	$2.67	$2.67	#DIV/0!
Yes	Business management time: customer communication/ billing, etc.	2	$17.00	$34.00	$1,768.00	$2.27	$2.27	$2.27	$2.27	averaged across week - more of a fixed cost

	SEED COSTS			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
	Quantity of Seeds in lbs					$0.00	$0.00	$0.00	$0.00
	Cost of seeds in pounds					$0.00	$0.00	$0.00	$0.00
No	Costs of Seeds per produced pound			$0.00	$0.00
No	SOIL SUPPLIES			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
	Amendments			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
	Etc.			$0.00		$0.00	$0.00	$0.00	$0.00

No	PACKAGING			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
	Individual boxes		$0.35	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Actual unit cost
	Bags		$0.04	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Actual unit cost
	Labels		$0.03	$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Assumes you have a printer to print them on
	OTHER			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00
Yes	Tools and Equipment				$0.00	$0.00	$0.00	$0.00	$0.00
No	Electricity & Water			$0.00	$0.00	$0.00	$0.00	$0.00	$0.00	Guesstimate annual cost divided by weekly packages sold = 780
	Pest Control				$0.00	$0.00	$0.00	$0.00	$0.00


	TOTAL
				$34.00	$0.00	$0.00	$2.27			Cost per pound
				cost to produce ## pounds		$0.00	$1.13			Cost per 8 oz package


	Amanda West: Divide capital costs by to either amortize across years or within first year.

	*TOTAL EXPENSES:*				$1,768.00


	INCOME	UNIT SIZE	# SOLD	PRICE/ UNIT	WEEKLY TOTAL					Income per 8 oz package
							$-			Income per 30 packages sold
	Client/ Outlet #1		0	$0.00	$0.00		$-			Income per 30 8 oz packages x 1 month
	Client/ Outlet #2					$0.00	($1.13)			Profit per 8 oz package
	Client/ Outlet #3						($2.27)			Profit per pound
						$0.00	($34.00)			Profit per 30 packages sold
							($136.00)			Profit 30 per week x 1 month
	*TOTAL INCOME:*					#DIV/0!	#DIV/0!


	ECO City Farms: These are sample capital expenses which may need needed for growing microgreens. Initial Capital Investment in Microgreens Operation	YEAR 1			Annual Profit
	Nursery Benches	$13,500.00			Percentage of profit
	Heating System	$4,000.00
	Fans	$300.00
	Harvesting and Packing Equipment	$300.00
	Total Initial Investments	$18,100.00

Related files

Share

Share to social media

Help

Login Area