Veggie Compass Spreadsheet
The spreadsheet is designed as an intuitive system for data organization for diversified vegetable farms. It is an excel based spreadsheet with three input pages and three output pages. Expenses are entered on the first spreadsheet page, and sales information on another. A third sheet requires growers to allocate detailed expenses to each crop including production labor hours. The spreadsheet uses the data from the input pages to calculate each crop’s cost per pound ($/lb), breakeven price, and gross margin by market channel.
Financial data needed for the tool can come from accounting programs, checkbooks, receipts and invoices. Sales data can be gathered from sales receipts, harvest logs, and from the weekly sales chart available on the Forms page. Labor data will need to be recorded by crop and activity through the growing season, and growers will enter their labor totals into the spreadsheet at the end of the season. Labor forms are also available for download on the Veggie Compass Management Forms page.
To download the Veggie Compass spreadsheet and User Manual click on the links below:
The Veggie Compass project team is in the process of generating default labor values for growers without crop specific labor histories. The data is currently being collected on working farms in the Midwest, and once these values are available, growers will have the option to use default labor approximations for each crop.