{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Current Cost","PC","5Year","Sheet2","Instructions","Video"],"not_rendered":{"charts":9,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Current Cost","index":0,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Current Cost (MONTHLY)"]
["Fixed","Cost/Month","Variable","Cost/Month",null,"Expenses","Total Cost "]
["Land",500,"Fertilizer and Seed",100,null,{"$f":"A3","v":"Land"},{"$f":"B3","v":500}]
["Electricity ",300,"Labor",200,null,{"$f":"A4","v":"Electricity "},{"$f":"D8","v":600}]
["Equipment and Maintenance (Milking)",200,"Pharmaceuticals",200,null,"Equipment and Maintenance (Milking)",{"$f":"B4","v":300}]
["Equipment and Maintenance (Land)",600,"Hauling Cost ",100,null,"Equipment and Maintenance (Land)",200]
["Taxes",800,"Artificial Insemination (AI)",300,null,"Taxes",600]
["Regulations",900,"Feed ",600,null,"Regulations",800]
["Gas",1000,null,null,null,"Gas",900]
[null,null,null,null,null,{"$f":"C3","v":"Fertilizer and Seed"},1000]
[null,null,null,null,null,"Labor",{"$f":"D3","v":100}]
[null,null,null,null,null,"Pharmaceuticals",{"$f":"D4","v":200}]
[null,null,null,null,null,"Hauling Cost ",200]
[null,null,null,null,null,"Artificial Insemination (AI)",100]
[null,null,null,null,null,"Feed ",300]
["Totals Rows",{"$f":"SUM(B3:B15)","v":4300},null,{"$f":"SUM(D3:D15)","v":1500}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"TOTAL/MONTH",{"$f":"SUM(G3:G28)","v":5800}]
[null,null,null,null,null,"TOTAL/YEAR",{"$f":"G29*12","v":69600}]
[]
[]
[]
[]
[null,"Current Milking Herd Size",50]
[null,"Average Gallons/Cow",3.65]
[null,"Gallons of milk/Day",{"$f":"C35*C36","v":182.5}]

{"sheet":"PC","index":1,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,1],[43,0,43,1],[0,0,0,3],[40,0,40,1],[42,0,42,1],[41,0,41,1]]}
["PROJECTED COST (MONTHLY)"]
["Fixed","Fixed Cost ($)","Variable","Cost/Month",null,null,"Expenses","Budget","Expenses"]
["Land",{"$f":"'Current Cost'!B3","v":500},"Fertilizer and Seed",273.97260273972603,null,null,{"$f":"A3","v":"Land"},400,{"$f":"B3","v":500}]
["Electricity ",{"$f":"'Current Cost'!B4","v":300},"Labor",547.94520547945206,null,null,"Electricity ",100,{"$f":"B4","v":300}]
["Equipment and Maintenance (Milking)",{"$f":"'Current Cost'!B5","v":200},"Pharmaceuticals",547.94520547945206,null,null,"Equipment and Maintenance (Milking)",200,200]
["Equipment and Maintenance (Land)",{"$f":"'Current Cost'!B6","v":600},"Hauling Cost ",273.97260273972603,null,null,"Equipment and Maintenance (Land)",435,600]
["Taxes",{"$f":"'Current Cost'!B7","v":800},"Artificial Insemination (AI)",821.91780821917814,null,null,"Taxes",800,800]
["Regulations",{"$f":"'Current Cost'!B8","v":900},"Feed ",1643.8356164383563,null,null,"Regulations",900,900]
["Gas",{"$f":"'Current Cost'!B9","v":1000},null,null,null,null,"Gas",1000,1000]
[null,null,null,null,null,null,{"$f":"C3","v":"Fertilizer and Seed"},272,{"$f":"D3","v":273.97260273972603}]
[null,null,null,null,null,null,"Labor",547.95000000000005,{"$f":"D4","v":547.94520547945206}]
[null,null,null,null,null,null,"Pharmaceuticals",547.95000000000005,547.94520547945206]
[null,null,null,null,null,null,"Hauling Cost ",274,273.97260273972603]
[null,null,null,null,null,null,"Artificial Insemination (AI)",820,821.91780821917814]
[null,null,null,null,null,null,"Feed ",1643.84,1643.8356164383563]
["Totals Rows",{"$f":"SUM(B3:B15)","v":4300},null,{"$f":"SUM(D3:D7)","v":2465.7534246575342}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"TOTAL/Month",null,{"$f":"SUM(I3:I28)","v":8409.5890410958909}]
[null,null,null,null,null,null,"Total/Year",null,{"$f":"I29*12","v":100915.0684931507}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Gallons Needed for dairy Operations",null,500]
["Additional gallons needed for new dairy operation",null,{"$f":"C41-'Current Cost'!C37","v":317.5}]
["Additional Cows Needed",null,{"$f":"C42/'Current Cost'!C36","v":86.986301369863014}]
["New Desired Herd Size",null,{"$f":"'Current Cost'!C35+C43","v":136.98630136986301}]
["Cost Per Cow/Month",null,{"$f":"'Current Cost'!G29/'Current Cost'!C35","v":116}]

{"sheet":"5Year","index":2,"n_rows":75,"n_cols":12,"rows_kept":75,"cut":false,"hidden":false,"merged":[[61,0,61,4],[7,6,7,7],[20,6,20,7],[30,6,30,7],[0,0,0,9],[6,0,6,4],[20,0,20,4],[33,0,33,4],[47,0,47,4]]}
["Equipment"]
["Equipment",null,"BOTTLE FILLER/CAPPER ",null,"BOTTLE WASHER  ",null,"WALK-IN COOLER ",null,"REFRIGERATED TRUCK/TRAILER ",null,"Total Equipment Cost ",{"$f":"SUM(B5,D5,F5,H5,J5)","v":0}]
["Specifications",null,"Specifications",null,"Specifications",null,"Specifications",null,"Specifications"]
["Contact Info",null,"Contact Info",null,"Contact Info",null,"Contact Info",null,"Contact Info"]
["Price",null,"Price",null,"Price",null,"Price",null,"Price"]
[]
["Year 1"]
["gal/day",{"$f":"B14*B15","v":229.95},null,"Operating Cost/yr  ",{"$f":"((('Current Cost'!G30)/B12)*B14)+C20+C19","v":201414.1},null,"Yearly Revenue"]
["half gal/day",{"$f":"B8*2","v":459.9},null,"Start Up Cost ",{"$f":"(B5+D5+F5+H5+J3)+B17","v":20000},null,"Year 1",{"$f":"D19","v":131099.24999999991}]
["Price Farm is Paid/half gal",3,null,"Total cost including start up",{"$f":"E8+E9","v":221414.1},null,"Year 2",{"$f":"D31","v":245711.6}]
["Daily Revenue for milk ",{"$f":"B9*B10","v":1379.6999999999998},null,null,null,null,"Year 3",{"$f":"D44","v":361107.05}]
["Herd Size at Begingin of Year ",{"$f":"'Current Cost'!C35","v":50},null,"# Days Milking",{"$f":"E10/B11","v":160.47988693194176},null,"Year 4",{"$f":"D58","v":415751.90000000014}]
["Additional Cows Purchased this Year ",13,null,"Out of Total Days of Year ",365,null,"Year 5",{"$f":"D72","v":470396.75}]
["New Herd Size",{"$f":"B12+B13","v":63}]
["Gallons/day per Cow",{"$f":"'Current Cost'!C36","v":3.65},null,"Percentage of Time Working at Max Capacity in order to Breakeven ",{"$f":"E12/E13","v":0.43967092310121031}]
["Annual Cost Per Cow",{"$f":"PC!C45*12","v":1392}]
["Building Renovation ",20000,null,{"$f":"(B11*0.7)*E13","v":352513.34999999992},"Potential Revenue Per Year "]
["Bottle Cost",0.6,null,{"$f":"D17-E8","v":151099.24999999991},"Revenue Minus Operating Cost"]
["Bottle Cost/Day",{"$f":"B18*B9","v":275.94},{"$f":"B19*365","v":100718.1},{"$f":"D17-E10","v":131099.24999999991},"Revenue Minus Operating and Start-Up Cost "]
["Price per Cow",1000,{"$f":"B20*B13","v":13000},{"$f":"IF(D19<0, D19, 0)","v":0},"Loss Incurred"]
["Year 2",null,null,null,null,null,"Breakeven Operation Percentage"]
["gal/day",{"$f":"B28*B29","v":277.39999999999998},null,"Operating Cost/yr  ",{"$f":"((('Current Cost'!G30)/B12)*B28)+C32+C33","v":240293.19999999998},null,"Year 1",{"$f":"E15","v":0.43967092310121031}]
["half gal/day",{"$f":"B22*2","v":554.79999999999995},null,null,null,null,"Year 2",{"$f":"E29","v":0.39554045556751705}]
["Price Farm is Paid/half gal",3,null,null,null,null,"Year 3",{"$f":"E42","v":0.39241476396201125}]
["Daily Revenue for milk ",{"$f":"B23*B24","v":1664.3999999999999},null,null,null,null,"Year 4",{"$f":"E56","v":0.39008581727555602}]
["Herd Size at Begingin of Year ",{"$f":"B14","v":63},null,"# Days Milking",{"$f":"E22/B25","v":144.37226628214373},null,"Year 5",{"$f":"E70","v":0.38828341505734282}]
["Additional Cows Purchased thie Year ",13,null,"Out of Total Days of Year ",365]
["New Herd Size",{"$f":"B26+B27","v":76}]
["Gallons/day per Cow",{"$f":"'Current Cost'!C36","v":3.65},null,"Percentage of Time Working at Max Capacity in order to Breakeven ",{"$f":"E26/E27","v":0.39554045556751705}]
["Annual Cost Per Cow",{"$f":"PC!C45*12","v":1392},null,{"$f":"(B25*0.8)*E27","v":486004.8},"Potential Revenue Per Year "]
["Bottle Cost",0.6,null,{"$f":"D30-E22","v":245711.6},"Revenue Minus Operating Cost",null,"Herd Size Growth"]
["Bottle Cost/Day",{"$f":"B31*B23","v":332.87999999999994},{"$f":"B32*365","v":121501.19999999998},{"$f":"IF(D31<0, D31, 0)","v":0},"Loss Incurred",null,"Year 1",{"$f":"B14","v":63}]
["Price per Cow",1000,{"$f":"B33*B27","v":13000},{"$f":"D31+D20","v":245711.6},"Revenue-Loss Incured Year to date  "]
["Year 3",null,null,null,null,null,"Year 2",{"$f":"B28","v":76}]
["gal/day",{"$f":"B41*B42","v":324.84999999999997},null,"Operating Cost/yr  ",{"$f":"((('Current Cost'!G30)/B12)*B41)+C45+C46","v":279172.3},null,"Year 3",{"$f":"B41","v":89}]
["half gal/day",{"$f":"B35*2","v":649.69999999999993},null,null,null,null,"Year 4",{"$f":"B55","v":102}]
["Price Farm is Paid/half gal",3,null,null,null,null,"Year 5",{"$f":"B69","v":115}]
["Daily Revenue for milk ",{"$f":"B36*B37","v":1949.1}]
["Herd Size at Begingin of Year ",{"$f":"B28","v":76},null,"# Days Milking",{"$f":"E35/B38","v":143.23138884613411}]
["Additional Cows Purchased thie Year ",13,null,"Out of Total Days of Year ",365]
["New Herd Size",{"$f":"B39+B40","v":89}]
["Gallons/day per Cow",{"$f":"'Current Cost'!C36","v":3.65},null,"Percentage of Time Working at Max Capacity in order to Breakeven ",{"$f":"E39/E40","v":0.39241476396201125}]
["Annual Cost Per Cow",{"$f":"12*PC!C45","v":1392},null,{"$f":"(B38*0.9)*E40","v":640279.35},"Potential Revenue Per Year "]
["Bottle Cost",0.6,null,{"$f":"D43-E35","v":361107.05},"Revenue Minus Operating Cost"]
["Bottle Cost/Day",{"$f":"B44*B36","v":389.81999999999994},{"$f":"B45*365","v":142284.29999999999}]
["Price per Cow",1000,{"$f":"B46*B40","v":13000},{"$f":"IF(D45<0, D45, 0)","v":0},"Loss Incured"]
[null,null,null,{"$f":"D44+D32+D20","v":361107.05},"Revenue-Loss Incured Year to date  "]
["Year 4"]
["gal/day",{"$f":"B55*B56","v":372.3},null,"Operating Cost/yr  ",{"$f":"((('Current Cost'!G30)/B12)*B55)+C59+C60","v":318051.40000000002}]
["half gal/day",{"$f":"B49*2","v":744.6}]
["Price Farm is Paid/half gal",3]
["Daily Revenue for milk ",{"$f":"B50*B51","v":2233.8000000000002}]
["Herd Size at Begingin of Year ",{"$f":"B41","v":89},null,"# Days Milking",{"$f":"E49/B52","v":142.38132330557795}]
["Additional Cows Purchased thie Year ",13,null,"Out of Total Days of Year ",365]
["New Herd Size",{"$f":"B53+B54","v":102}]
["Gallons/day per Cow",{"$f":"'Current Cost'!C36","v":3.65},null,"Percentage of Time Working at Max Capacity in order to Breakeven ",{"$f":"E53/E54","v":0.39008581727555602}]
["Annual Cost Per Cow",{"$f":"12*PC!C45","v":1392},null,{"$f":"(B52*0.9)*E54","v":733803.30000000016},"Potential Revenue Per Year "]
["Bottle Cost",0.6,null,{"$f":"D57-E49","v":415751.90000000014},"Revenue Minus Operating Cost"]
["Bottle Cost/Day",{"$f":"B58*B50","v":446.76},{"$f":"B59*365","v":163067.4}]
["Price per Cow",1000,{"$f":"B60*B54","v":13000},{"$f":"IF(D59<0, D59, 0)","v":0},"Loss Incured"]
[null,null,null,{"$f":"D58+D60+D46+D32+D20","v":415751.90000000014},"Revenue-Loss Incured Year to date  "]
["Year 5"]
["gal/day",{"$f":"B69*B70","v":419.75},null,"Operating Cost/yr  ",{"$f":"((('Current Cost'!G30)/B12)*B69)+C73+C74","v":356930.5}]
["half gal/day",{"$f":"B63*2","v":839.5}]
["Price Farm is Paid/half gal",3]
["Daily Revenue for milk ",{"$f":"B64*B65","v":2518.5}]
["Herd Size at Begingin of Year ",{"$f":"B55","v":102},null,"# Days Milking",{"$f":"E63/B66","v":141.72344649593012}]
["Additional Cows Purchased thie Year ",13,null,"Out of Total Days of Year ",365]
["New Herd Size",{"$f":"B67+B68","v":115}]
["Gallons/day per Cow",{"$f":"'Current Cost'!C36","v":3.65},null,"Percentage of Time Working at Max Capacity in order to Breakeven ",{"$f":"E67/E68","v":0.38828341505734282}]
["Annual Cost Per Cow",{"$f":"12*PC!C45","v":1392},null,{"$f":"(B66*E68)*0.9","v":827327.25},"Potential Revenue Per Year "]
["Bottle Cost",0.6,null,{"$f":"D71-E63","v":470396.75},"Revenue Minus Operating Cost"]
["Bottle Cost/Day",{"$f":"B72*B64","v":503.7},{"$f":"B73*365","v":183850.5}]
["Price per Cow",1000,{"$f":"B74*B68","v":13000},{"$f":"IF(D73<0, D73, 0)","v":0},"Loss Incured"]
[null,null,null,{"$f":"D72+D74+D60+D46+D32+D20","v":470396.75},"Revenue-Loss Incured Year to date  "]

{"sheet":"Sheet2","index":3,"n_rows":58,"n_cols":5,"rows_kept":58,"cut":false,"hidden":true,"merged":[]}
["Equipment ","Maker","Specs ","Contact Information","Price"]
[]
["PASTEURIZER "]
[" 15 Gallon Vat Pasteurizer (Bob-White Systems)","Bob-White Systems ","Precision temperature control. Easy to clean. Everything you need is included. ","802-763-2777",15995]
["30 Gallon Vat Pasteurizer (Bob-White Systems)","Bob-White Systems ","Precision temperature control. Easy to clean. Everything you need is included. ","802-763-2777",21699]
["15 Gallon Vat Pasteurizer (Bob-White Systems)","Jaybee Precision","Everything you need is included. 7 gallon minimum. ","800-236-3956, sales@northwesterntools.com",13999]
["30 Gallon Vat Pasteurizer (Jaybee Precisions)","Jaybee Precision","Everything you need is included. 17 gallon minimum. ","800-236-3956, sales@northwesterntools.com",16999]
["50 Gallon Pasteurizer (kleenFlo)","KleenFlo","Call for further information. ","765-874-1292, ron@kleenflo.us",19500]
["75 Gallon Pasteurizer (KleenFlo)","KleenFlo","Call for further information. ","765-874-1292, ron@kleenflo.us",20000]
["100 Gallon Pasteurizer (KleenFlo)","KleenFlo","Call for further information. ","765-874-1292, ron@kleenflo.us",20500]
["200 Gallon Batch Pasteurizer (Anco)","Anco","Includes Chart Recorder & Thermometers for Airspace & Product Temperature, electric Air Space Heater, and Leak Detect Valve","(920)569-3530, info@ancoequipment.com",22000]
["45 Gallon Vat Pasteurizer (MicroDairy Designs)","MicroDairy Designs ","includes heater, airspace heater, agitator, Digital Indicating Thermometers with Two-Pen Chart Recorder","(301) 824-3689",13400]
["99 Gallon Vat Pasteurizer (MicroDairy Designs)","MicroDairy Designs ","includes heater, airspace heater, agitator, Digital Indicating Thermometers with Two-Pen Chart Recorder","(301) 824-3689",18600]
["200 Gallon Batch Pasteurizer (MicroDairy Designs)","Schier Company","Includes recorders, thermometer, and electric air space heater ","kindra@schiercompany.com",{"$f":"16300+5500","v":21800}]
[]
[null,null,null,"Pasteurizer Average Cost ",{"$f":"(AVERAGE(E4:E14))","v":18590.18181818182}]
[null,null,null,"Pasteurizer Standard Deviation",{"$f":"STDEV(E4:E14)","v":3087.7365113682145}]
[null,null,null,"Pasteurizer Cost Upper Limit",{"$f":"E16+E17","v":21677.918329550033}]
[null,null,null,"Pasteurizer Cost Lower Limit",{"$f":"E16-E17","v":15502.445306813606}]
[]
["BOTTLE FILLER/CAPPER "]
["Filler/Capper (Schier Company)","Schier Company","High-technology 6 valve filler with capper for gallons. Industrial use. ","kindra@schiercompany.com",29500]
["Automatic Filler/Capper (Bob-White Systems)","Bob-White Systems ","Fills glass or plastic bottles. Removable template to accommodate different size bottles. Manual foot pedal. ","802-763-2777",7900]
["Filler/Capper (Agri-Service LLC through Dairy Heritage)","Agri-Service LLC through Dairy Heritage ","Single valve for half gallon bottles; Detailed quote available","Anthony Ambrosio-(301)223-6877",{"$f":"8800+4600","v":13400}]
[]
[null,null,null,"Filler/Capper Average Cost",{"$f":"AVERAGE(E23:E24)","v":10650}]
[null,null,null,"Filler/Capper Standard Deviation",{"$f":"STDEV(E23:E24)","v":3889.0872965260114}]
[null,null,null,"Filler/Capper Cost Upper Limit ",{"$f":"E26+E27","v":14539.087296526011}]
[null,null,null,"Filler/Capper Cost Lower Limit",{"$f":"E26-E27","v":6760.9127034739886}]
[]
["BOTTLE WASHER  "]
["Bottle Washer and Racks ","Agri-Service LLC through Dairy Heritage ","Detailed quote available","Anthony Ambrosio-(301)223-6877",{"$f":"14745+1775","v":16520}]
[]
[null,null,null,"Bottle Washer Average Cost",{"$f":"E32","v":16520}]
[]
["WALK-IN COOLER "]
["Walk-in cooler (Bush)","Bush","5 ft 11 x 9 ft 9 x 7 ft 11; with floor, light fixture, and digital thermometer ","bushrefrigeration.com",{"$f":"3800+750","v":4550}]
["Walk-in cooler (Elite Rest. Equip Leader)","Elite Restaurant Equipment Leader WIC88","8 ft x 8ft ","eliterestaurantequipment.com",4497.8999999999996]
["Walk-in cooler (Kolpak)","Kolpak","6 ft x 12 ft x 7 ft 6 ","webstaurantstore.com",5959]
[]
[null,null,null,"Walk-in Cooler Average Cost",{"$f":"AVERAGE(E37:E39)","v":5002.3}]
[null,null,null,"Walk-in Cooler Standard Deviaton",{"$f":"STDEV(E37:E39)","v":828.93592635378241}]
[null,null,null,"Walk-in Cooler Cost Upper Limit",{"$f":"E41+E42","v":5831.2359263537828}]
[null,null,null,"Walk-in Cooler Cost Lower Limit",{"$f":"E41-E42","v":4173.3640736462175}]
[]
["REFRIGERATED TRUCK/TRAILER "]
[]
["2016 Chevy ",43500]
["2016 Ford ",46570]
["2016 Ford Transit ",49999]
["Polar Temp Trailer Transport ",3849]
["Polar Temp for truck bed ",5829]
["Polar Temp Trailer Transport ",7639]
[null,null,null,"TOTAL COST INCLUDING PASTEURIZER, FILLER/CAPPER, AND COOLER ",{"$f":"SUM(E41,E26,E16)","v":34242.481818181819}]
[null,null,null,"TOTAL COST INCLUDING ALL INPUTS' AVERAGE COST  "]
[null,null,null,"ESTIMATED MAX COST",{"$f":"SUM(E43,E28,E18)","v":42048.241552429827}]
[null,null,null,"TOTAL COST INCLUDING TRUCK ",{"$f":"E54+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"TOTAL COST INCLUDING TRAILER ",{"$f":"E54+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Instructions","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[7,4,8,6]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"INSTRUCTIONS"]

{"sheet":"Video","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}