Spreadsheet: 02382df2-f177-464d-ac92-978a387ac4bc
Sheet: Model

 | Effects of Spout and Drop Sanitation Strategy on Sap Yield and Net Profit
 | Hover here for description of Fig. 1. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hover here for description of [NAME]. 3.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOR CALCULATIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drop Assembly Labor Calculations
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay rate/hr | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number drops made/hr | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number drops made/min
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assembly cost per drop
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drop Installation Labor Calculations
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay rate/hr | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number drops installed/hr | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number drops installed/min
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Installation cost per tap
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cleaning Labor Calculations
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay rate/hr | 10
 | Hover here for description of [NAME]. 2. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number drops cleaned/hr | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Number drops cleaned/min
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost per tap
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | <--------------- Materials -------------------------> |  |  | <------- Labor -------> |  |  | Hover here for description. |  | LEGEND
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (use calculators on right)
 |  |  |  |  |  |  |  |  |  | STRATEGY COST/TAP |  | TOTAL COST |  | Tubing | Tee | Spout | Sanitizer | Assemble | Install or Clean |  |  |  | S = replace spouts each year
 |  |  |  |  |  |  |  |  |  | Spout |  |  | = |  |  | 0.18 |  |  |  |  |  |  | CV = use and replace [NAME] spouts each year
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  | = |  |  | 0.36 |  |  |  |  |  |  | D x 1 = replace drops each year
 |  |  |  |  |  |  |  |  |  | Drop & Spout |  |  | = | 0.3 | 0.32 | 0.18 |  |  |  |  |  |  | D x 2 = replace drops every second year
 |  |  |  |  |  |  |  |  |  | Clean Spouts+Drops |  |  | = |  |  |  | 0.1 |  |  |  |  |  | D x 3 = replace drops every third year
 |  |  |  |  |  |  |  |  |  | Clean & Replace |  |  | = |  |  |  | 0.1 |  |  |  |  |  | D x 4 = replace drops every fourth year
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D x 5 = replace drops every fifth year
 |  |  |  |  |  |  |  |  |  | [NAME] (gal) |  | 20 | gal (estimated or actual production of sap first year after re-tubing) |  |  |  |  |  |  |  |  |  | Cln = clean spouts and tubing each year
 |  |  |  |  |  |  |  |  |  | Value of Sap/Gal ($) |  | 0.3 | (price per gallon you value your sap) |  |  |  |  |  |  |  |  |  | [NAME] = clean drops & replace spouts each yr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [EMAIL]