Skip to main content

Cornell Maple Calculators

Calculators and other Tools

 

Mobile Phone Instructions: Scroll to the right and left to view the entire calculator.

Double tap the yellow cells to type in your data. You may need to wait a moment for the calculator to load on your screen.

Scroll all the way to the right to download the spreadsheet to your device.

 

Download Instructions: Select the icon pictured below.

This download button is located at the bottom right corner of each calculator.

 

Jump To the tool you are looking for:

 

 
 

New Grade Blending Calculator

Get the grade you want by entering the light transmittance % of the two syrups you wish to blend.

You will need to know the transmittance % of a 50/50 blend of your two syrups before you begin. Mix thoroughly a small sample of equal parts lighter and darker syrup, wait for the bubbles to dissipate, and check the transmittance with your Hanna Meter.

If you are using mobile phone, double tap the yellow cells to type.

 


 

Welcome to the Maple Products Pricing Guide

These worksheets are brought to you by Michael Farrell and Chelsea Green Publishing as supplementary material for The Sugarmaker’s Companion: An integrated guide to producing syrup from maple, birch, and walnut trees.

This Excel file contains pricing guides for bottling syrup and creating other value-added maple products. Simply click on the worksheet tab for the product you would like to use. Scroll to the right to view more products.

This Excel file accompanies Chapter 11 Where the Money Is: Marketing Your Pure Maple Products

If you havent already read this chapter, doing so will greatly improve your ability to utilize these spreadsheets.

Download the Workbook:

 
 

Maple Syrup Retail Pricing Calculator

 
 

Syrup Retail and Wholesale Calculator

Scroll to the Right to see all of the results of your calculations

 
 

Maple Candy Pricing

 
 

Maple Cream Pricing

 
 

Maple Granulated Sugar Pricing

 
 

Maple Cotton Candy Pricing

 
 

Maple Soda Pricing

 


 

Cost of Maple Tubing Installation – updated 2020 prices

 


 

Costs and Returns with Vacuum Systems

 


 

Welcome to the Cornell Sap Buying Spreadsheets

You may download the entire workbook below, or scroll down to use the calculators directly on this webpage:

This Excel file is intended to help sugarmakers who want to expand their operations by purchasing sap from nearby landowners.
There are several worksheets within the downloadable Excel file. In order to see them all, you need to click through the sheets with the arrows on the bottom left. Otherwise, for use on this website, they are all laid out separately.
A brief description of each worksheet is as follows:

Sap Pricing Table
This is the basic table that displays the price of a gallon of sap. The variables include: sap sugar concentration, bulk syrup prices, and percentage of bulk syrup revenues provided to the sap seller.

Advanced Sap Pricing Table
This is an advanced version of the sap pricing table in which users can adjust the percentage of bulk syrup revenue given to the sap seller according to how eet the sap is. This table is especially useful for smaller-scale sugarmakers who don’t have efficient evaporators and reverse osmosis units.

Simple Hourly Wage Calculator
This is a basic tool to give you a broad overview of if it will be economically feasible for you to purchase sap. It provides a rough estimate of the net profit per hour your sugaring operation could produce by purchasing and processing sap.

Advanced Hourly Wage Calculator
This is a more advanced version of the simple calculator that takes into account other costs such as sap and syrup filtering, sap and syrup storage, and depreciation on your reverse osmosis and evaporator.

Blank Worksheet
This worksheet allows you to keep track of sap payments over the course of a season for each individual that you are buying sap from.

Internal Sap Value Calculator
This worksheet allows you to determine what a gallon of sap is worth to your sugaring operation using many of the same parameters that help you determine the profitability of buying sap.

 
 

Sap Pricing Table

Read first:
The following table presents suggested prices per gallon of sap for a maple producer to purchase sap from someone else. The variables that affect sap prices in this table are sap sugar content, bulk syrup price, and the percentage of bulk syrup price provided to the sap seller. The default value for cell G3 (“Percentage of Bulk Syrup Price Provided to Sap Seller”) is set at 50%, since that is a figure commonly used in the maple industry. However, if the percentage of bulk syrup price provided to the sap seller differs from 50%, users can change that value in the yellow highlighted cell below (mobile phones scroll right) and the sap prices will change accordingly.

Scroll to the right to see the entire spreadsheet.

 
 

Advanced Sap Pricing Table

Read first:
This advanced sap pricing table is designed to allow sugarmakers to pay a higher percentage for sweeter sap and a lower percentage for less sweet sap. This may be advantageous for producers who do not use reverse osmosis or efficient evaporators. Enter in the parameters in cells G3-5 highlighted in yellow in order to customize the revenue distribution. If you would like to see how the distribution changes based on the values entered in G3-5, scroll down to rows 49-80.

Scroll to the right and down to see the entire spreadsheet.

 
 

Hourly Wage Calculator for Processing Sap

Read first:
This simple calculator displays the “hourly wage rate” for processing additional sap purchased from someone else. Simply enter in the values for the cells highlighted in yellow. This is the amount of money a sugaring operation can expect to make per hour by purchasing and processing additional sap.
Note that this is the “simple hourly wage calculator”- it gives you a rough idea of how much money you can earn by buying sap, but it usually overestimates the actual value by about 10%. For a more accurate estimation of the profitability of buying sap, use the “hourly wage calculator advanced” worksheet.

 
 

Advanced Hourly Wage Calculator for Processing Sap

Read first:
This advanced calculator displays the amount of profit per hour for processing additional sap purchased from someone else. This is the amount of money a sugaring operation can expect to make per hour by purchasing and processing additional sap. Simply enter in the values for the cells highlighted in yellow and the spreadsheet will calculate the values in green for you.
For the columns that have superscripts at the end of the title, scroll down to determine the values for each of these items.

 
 

Blank Worksheet

Read first:
Sugarmakers can use this spreadsheet to keep track of sap deliveries and payments throughout the course of the sugaring season.
Users are responsible for entering in values for the cells highlighted in yellow. Once each row has values entered in each cell for columns B-E, the spreadsheet will calculate the values in columns E-J. Columns D and E contain drop down items. In Column D you choose the grade of syrup you are making. In Column E you choose whether the sap is delivered or picked up.
Additional information appears below the chart in reference to the subscripts indicated within the chart.
Be sure to scroll down to the very bottom to read more.

 
 

Internal Sap Value Calculator

Read first:
This calculator displays the value of an additional gallon of sap that you are able to collect from your maple trees. Simply enter in the values for the cells highlighted in yellow and the spreadsheet will calculate the values in green for you. For the columns that have superscripts at the end of the title, scroll down to determine the values for each of these items. Note that if the value of sap that you produce yourself is higher than the price you have to pay for sap that someone else collects, then it makes economic sense to purchase sap.

 


 

Maple Business Income Calculator

Download to Save an Income Statement for your records.

Skip to toolbar