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, click on the link below. In earlier versions, the Veggie Compass User Manual was a separate file but for ease of use, it is now contained within the spreadsheet file.
Because we continue to update and improve Veggie Compass, we highly recommend that people who download the Veggie Compass spreadsheet sign up to receive email updates when a new version has been posted. You will only receive notices when a new version of Veggie Compass is available and your email address will not be shared with others.
To view an hour-long eOrganic webinar about Veggie Compass, click on the link 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.