How do i industry sign banking oregon word fast
good morning everyone this is brief of with the Oregon wine board we are here this morning to present the second in the series of Oregon wine profit planner webinars this webinar is going to focus on our winery cost of goods workbook and calculator we'll start with some housekeeping we're going to keep all attendees on mute here you're able to ask questions throughout the entirety of the webinar so to do so just type a question into the chat bar on your toolbar and the task bar and we will answer any questions as they come up but there will also be time at the end of the seminar for Q&A with Tim hen I and myself the webinar in slideshow and a recording of this presentation will be available to view or share on our website at industries Oregon wine org we will also be sending out a follow-up email with a survey which we urge you to please respond to with your thoughts and comments on not only the lecture and the effectiveness of the webinar but also the tool itself and we will have links to other resource documents also available in that follow-up email we should have the webinar recording up and available on the site if not by the end of the day within 24 hours just to cover the agenda for today we are going to go into our second webinar of this suite of workbooks the Oregon wine profit planner cost of goods workbook tutorial which Tim will be showing you how to develop and save your workbook and we'll be offering a case study of a small Oregon wine brand so that you can see how he accesses the plug-and-play nature of this very easy to use tool in closing we'll do a quick summary again of how to access the calculator tool and also the available resources please feel free to share of this information with your colleagues or any wine industry friends also this profit planner tool is available to all in the Oregon wine industry free of charge and all they need to do is apply for access which can be done through our website ours online profit planner an overview just from a historical perspective when I began in my role as education manager here at the Oregon wine board in early 2017 we conducted a needs assessment in conjunction with the Education Committee and there was a great response to having greater understanding for producers of their cost of goods in production in the vineyard and also in the tasting room and as our direct-to-consumer channels develop this tasting room focus is increasing we have in response to this needs assessment worked with Tim Hanna master of wine one of the first master of wines in the u.s. to develop four unique workbooks specifically focused on the Oregon wine industry so we have the vineyard profit and loss and cash flow workbook the winery cost of goods workbook which we will be going through today with Tim and the tasting room profitability and the marketing sales and portfolio management workbook please tune in for all of these or share these with your colleagues at the winery or vineyard or whatever relates best to your business practices these workbooks can be accessed by all of your workmates by anyone in the Oregon wine industry free of charge this is an Oregon wine board funded research and tool development so please spread the word if you find this tool useful the main benefits that we were seeking to produce for through this tool is to enable vineyards wineries and the sales channel planning to stimulate financial success across the whole business empower small Oregon Vineyards and Winery teams to make better informed business decisions like I said you can access this through each management channel in your business this tool will engage the entire team and it gives an ability to increase profitability through financial responsibility and management by leaking business decisions to the bottom line in your business again a reminder this tool is free and easily accessible to all members of the Oregon wine industry please just apply for access from the Oregon industry website is a quote from memory of a lavage consulting project M and nasty woman whine as to how she found using this tool and the benefits that it brings to her business and I would also like to touch on one of the reasons that we first developed this tool which began as a cost of goods tool and we recognized that understanding production costs is crucial to managing your businesses for profitability for wineries it's even more crucial due to the amount of capital that even a small winery must tie up in inventory Oregon wineries can often spend between 50 to $100 per case for their finished wine with the average between 70 to 80 dollars per case knowing how much your wine costs you makes it much more easier to make the important decisions necessary to manage your operations knowing the cost of goods allows you to not only manage your costs better but it also allows you to properly price your wines decide production levels and the best sales channel for each varietal and label to increase profitability all of these decisions and more are not possible without the proper understanding of your cost of goods with that here's a quick review of how to access the calculator if you're having anyone just sign in at the moment request access to the profit planner we are still approving access right now as we speak so you can jump on at the last minute and join in the webinar we're going to review the profit planner workbook with Tim and he'll show you how to create a workbook saver workbook enter your cost pricing and other program elements share see how the inputs affect your profit and then you can save and share as this PDF with your managers and accountants all of this makes you more equipped to make the financial decisions that you need to to make better business profitability on that note Kim Hana master of wine who is a business educator for many years who has been working with Cornell University Sonoma State University and a number of other institutions working with these workbooks and continuing to develop these workbooks specifically for the Oregon industry through our census data that we collect through our research that we often ask you to send out fill out surveys all of the data that you provide us is being converted into the plug-and-play materials in these calculators and we will continue to develop these workbooks as best we can based off of the information that you provide us with that I will pass it over to Tim you all right I've just been unmuted hi everybody thanks for joining us what we're going to do is go through this program and a little bit of a preference how this all came about is as many years ago I started using sort of a supply chain approach to teaching about wine so that people could better understand step by step from the ground up to the glass what goes into a bottle of wine the decisions to be made and then over time we started to add these financial workbooks and calculators to enable people to see that if you make a decision over here here's the impact on your bottom line it also introduces a unique element of critical thinking because you're looking at both the financial decisions against the quality and value decisions that are made through the suppliant value chain so that's the approach we've taken and now I'm also excited to share that we've just finished up our first intercollegiate wine business Invitational with six universities using these workbooks to create business plans and in the the project that was selected as best of show was from Linfield College in Oregon yay go were again so so what we what we've got fundamentally is I'm going to start at the Oregon wine org page and if I just mouse over education I'm going to see the wine profit planner link and when I select that it's going to get me to either the login page or a link so that you can request access to get your login information once you sign up you'll be sent a username which will be your email address that you use to sign up for the gram and you'll get an automatic reply with a password that you'll use for logging in so basically I put in my username and password and sign in and then this is what you'll first encounter in the program so this is something called the auto filter list and you'll see that there's a drop-down here that contains all of the the various workbooks and then what we're going to do is select the form that we want to work with in this case it's the cost of goods workbook and then when you select that you're going to want to select new and that will open up a new workbook now we're in tension with this is we jokingly like to say it's a graphics deficient version of farmville you can create workbooks you can save your workbooks you can go back and work on them again you can also as I'll show you print and clone the workbooks the first thing to know is that the information in these workbooks is saved on the server not on your computer so to access the workbooks you'll need to be able to get online and it's going to actually save your project at a unique URL that I've highlighted up here and so one of the first things you'll want to do is bookmark this page so that if it's something that you want to to save and recall and to do that all I have to do is hit ctrl D and if you're using a Mac you'll want to use ctrl or command D and it's going to depending on which kind of browser you're using it'll it'll set this up now as you'll see in my favorites bar up here my bookmark bar I've got a special folder for all of my workbooks and so I can select that I want this in my Oregon wine board workbooks and what I'm going to call this is Pinot Noir owb demo and I'm also going to put the date on here 11:28 18 this is important especially if you're going to use this tool for a lot of different projects so that you you can clearly identify the projects and when I when I'm done all I do is hit done and that now shows up here when I want to go back to the project all I need to do is go to this click on this link and it will reopen my project and then I can have as many projects in there as I need if you plan to work on your project on different computers you will need to find a way to create an email to yourself or put a note in here that that for this URL because when you go to a different computer you'll need to go to this URL to be able to to access the book so if you if you do this at work and then want to work on their dead hole where you've got a laptop that you want to while you're traveling that kind of stuff okay so that's how you open and save your work now there's a space in here that I can I can I call this whatever I need this is the owb demo gonna put in my name and if for any reason you're trying to work on this project and it's not accepting anything up in this corner is the save function now I'm going to hit save and then notice that I can't access these until I go back to the edit function alright so it gives me the the circle with the line through it that I can't do this so make sure when you're working on your project it says save up here that means you're in the edit mode okay alright so at the beginning of working on these projects there's going to be a lot of quote-unquote educated guesses or a lot of data that you're going to need to find the good news is if this is where learning and putting structure behind understanding the finances and then working with anybody in production or in your barrel room or with your accountant or finance person where do you go to get these numbers is a common question and also understand that the entire program is preloaded with numbers to operate sort of as benchmarks as you're going through and learning this so if I if I want to call this Pinot Noir 2017 and this is Tim's chateau and one of the other things that this is these programs are all really great for it is also for forecasting establishing if I wanted to be working on a certain wine and so I could actually name the file that is my forecast forecast costs okay I'll put in the date and it's just a drop down here and we're on the 28th and then I'm pretty good to go another quick note for anybody who's interested there's an end users agreement in terms of service and privacy statements that you just simply lick linked to and then up at the top here there's a complete set of instructions resources and FAQ s that is especially as you're using this for the first couple times you can just click it and leave it open and then you can see that there's dropdowns for information on instructions and whatever for each of the workbooks okay so the fields that are in this light tan color are fields that can be input by the user this is kind of a dashboard if you will that's showing me as I go through each of the tabs it'll update the fo B price of the wine how much revenue my cost of goods my margin it's going to give me an important number which is my gross margin percentage and then I'll also have calculations for the retail selling price and I'll explain this a little bit this retail selling price here is a guideline that's auto-generated and at the very end of this I'm going to go quickly through our new pricing calculator so you can do more detailed pricing workups this program is also going to tell me how many tons of grapes are going to be required for this wine the cost of the grapes and then finally it's going to let me know my gross margin for this product the gross margin becomes your bank or if you will your budget then to understand that between the FOV price set for the wine and your actual cost of goods of the wine this is how much money bec that can be used for overhead for operating expenses for equipment and supplies for labor and all those kind of things so it's a very very important number okay so we can go in and change this let's say that that we're going to be making five thousand cases or five hundred cases so I can input this and when you input a number here it will then automatically update all my numbers and then the other thing is that I can use this is called a stepper where you see the pluses and minuses on this part of the page I can also see what would happen to the estimated retail selling price to my bottom line etc by stepping up the prices and as I go up to a hundred and $40 fo B you see that gets me up to about a twenty-six dollar bottle of wine but it's had a very positive effect obviously on my gross margin so these things can be used once you have the numbers in them to fiddle around and play with the other thing that's that's a very valuable thing to know let's say that I've worked on the 27 2017 Pinot Noir and now I want to do the 2018 so I want to create a new project I can actually save this workbook right once I hit save you'll notice that now I have a save as PDF so if I want to download and print or email or share a copy in any way all you have to do is hit edit and save as PDF and it'll you can then save it in your downloads or on your desktop or file wherever you want another really cool function is the clone if I hit clone it's going to make a copy of this and give me a new URL that I'll need to save in the same fashion as I did originally by using the ctrl D or command D function and then save the new copy for the to end and then I can go in and make make changes to the new workbook so again if I may be doing something as a forecasting and then want to do the final workbook separately and save the forecast so that I can compare the two now the other thing is when you want to access a new workbook you need to be in this same place so that I can go back to the auto filter if I want to go in and save a new workbook in this in this program ok alright so again if I want to go back to my original workbook I go up here to my favorites and it'll take a second to populate and it'll be saved in that area ok it should be saved in that area all right we'll figure out why it's not doing that so anyways these are the the various elements of the program and that's how to save clone and print your results as you go through each tab then what you're going to see is that we're now on sheet 2 which is the great costs and there's a link here to the current Oregon great prices for as a resource and then you're given the ability to use up to eight varieties or eight single vineyards in a blend that you're creating or in a
single variety so if I know that I'm making Pinot Noir basically we've got a preset to that I'm going to use a hundred percent of of this of this and my my wine when you select something from the pulldown it will also give you where it's available the Oregon benchmark pricing the Oregon average low and high and then this is information pulled from the Oregon great prices report it'll give what the Rogue Valley pricing that these are all that were reported in the 2017 great prices report okay so if I want to remove that I just go back to select pull down but let's say that we wanted to make a blend and that we wanted to use a combination of Syrah I can go down and select that and that my class per ton is eighteen hundred dollars and then when I change the pricing in here in on every page you'll get a running tab of your cost of goods your margin and your gross margin so when I enter that in and then click off of it to go in notice that it it updates my margin cost of goods and so forth if I want to do a blend that I could say well I want to do 50% of Syrah and then for the for the next I want to add let's say some Petite Sirah just or Zinfandel or whatever and then I put in whatever price I'm paying for that and the percentage that's going to be of the blend and as soon as I enter that what it's going to do is going to give me my total cost as an average and the allocated cost per time as the percent of blend okay if there's a variety that's not in our pulldown you can add two and then also you can make any notes about your grape sources so let's say that we were doing Pinot Noir from four different vineyards at four different prices I could put which vineyard or which block etc or if there's any kind of note that I wanted to make that's easy to do okay all right once we've got our grapes entered in here then we go to the production worksheet and this is where especially early on it's going to take a little work and a little coordination with production with perhaps your accountant and so on to find some some information we have the you you have the capability of doing a 100% full production line or you can also enter a percentage of bulk line up to a hundred percent so if you're using any bulk or it could it doesn't necessarily to be I need to be purchase ball-playing it could be some you know material that you have in inventory but what you need to do is go to line 19 and you'll see that it's set adds a default of thirty five dollars a gallon and so if I wanted to step this up you can see what that effect has on my so if I've got 10% bulk line now if I want to change the the price of the cost of my bulk wine I can move it up or down in this in this field so this is Finnish cost per gallon of material and then that'll all operate that way okay the next area is going to be the calculation of tonnage and the estimate from the crusher how how many cases of finished wine are you projecting per ton of grapes that ranges anywhere from 50 to 65 or a bit more depending on the type of press and the amount of pressure for for specialty wines like ice wines and Petridis lines it could be well below that but you get to control and you also get to see if we were to squeeze a couple more cases outward $126,000 gross margin and so it's looking like it's about 15 $1,600 contribution to our bottom line per case or if we wanted to to really you know do this gently or so on this would be the the impact now it's also doing estimates of your great tonnage how many tons are needed you'll see that that as we squeeze more we need less grapes obviously and that's going into these calculations you got your total cost of grapes and then as a reference what your cost of grapes is contribution to the case of finished wine the the main number then in processing and production that you're going to look at is in line 12 and this is winemaking fermentation and production per ton if you're working with a custom crush facility they will they'll give you those numbers if you're working internally you'll need to work with your finance or look at last year's why making costs typically excluding labor also this is just to get what goes in and remember that your labour budget is going to come from from the aggregate gross margin of all your products right so you can say okay well you know we've got a quote or it looks like our processing is running about six hundred and seventy-five dollars a tonne and then that's going to give us what that would be total for the number of cases and then it would also make any changes in our bottom line okay if you have any additional pre fermentation cost supplies or equipment they would be input into this field and this is this is as a total for the processing of this line if there are exceptional production costs that are not included there's a second field so you can break this out maybe you're doing cold soaking or must chilling or something like that you can account for those in these fields and then you can put additional any lab work and analysis again this might be just broken down by last year's total for lab and an analysis and you put that allocated figure then in into this field if the the lab work and everything is already included in your fermentation you would just zero this out okay like that all right some people also might prefer to look at their lab work or analysis on a per ton process and so you've got a choice of a lump sum total or as a per ton all right so little flexibility this is your plus and minus for the bulk line if you're using bulk line I'm going to go ahead and just zero that out and then if this is zero this this has no effect in on anything okay and then finally state and federal excise taxes we've added a quick link here to the TTB site so then it'll come up with all the different very variables in that and then we move on to the barrel costs the barrel costs allow you to have any single or up to four different barrel programs that you can put in and manage we've got it preset for program one let's say that this is a new oak and you can put the type of oak or supplier or anything that you need in into this we're going to do fifty percent of our production for six months our lady in cost of the barrels are thirteen hundred and then what are you where is the where are the barrels going from here and in this case what we're going to do is we're going to transfer our barrels into a six year program so we're going to assign a barrel cost whatever our laid in cost is and then we're going to use a transfer cost to put into our used barrel program or if you're selling the program or selling the barrels after use you can put in the the resale price it accommodates a number of different barrel capacities and even up to large capacity for uprights and so forth and then it's going to give you a net cost of barrels for this program or I'm sorry for the life of use in this case there is a $400 different-- now understand in this price you work these barrels we're going to be using for six years so it's a higher total cost but that would be divided by six okay it'll give you then your barrel cost per month of use it'll give you the net cost of the barrels the allocated net cost of barrels per model of this wine and then something very important that a lot of people don't even consider which is the evaporative loss in in the worst of conditions it can be as high as 10% 3% tends to be the average you also put in the cost of your topping line per gallon and then it runs all of your numbers and we're really excited about this because this is also a great learning tool you can sit down with somebody and go through this and show them what these costs are and this is this is a part of the the collaborative nature of these workbooks and also the learning curve that's involved and if we decided okay that we we wanted to zero out this and do all new French oak we just do that and and then it'll revise all our numbers accordingly and as we increase or decrease the number if we wanted to do our Pinot Noir and 12 months of new French oak you can see the prices going up and down okay all right hang on just one second all right we've got a couple of questions so let me go ahead and address these the great price inputs is it possible to enter great pipe price by clone or block and so let me go back to that tab so if I wanted to do let's let's let's go back to doing a Pinot Noir Jack and if I wanted to do by clone or block I can again put as many different iterations in here and let's say I'm going to call this clone xxx so like I can make a note to ensure I know what I'm doing here this could be block 14 this could be a Fred's Vineyard that I purchased from etc and then if I know that clone X access is lower yield I talked to vineyard or I know the value of this then I can put then the relative value of this is let's say twenty two hundred dollars a ton block fourteen is eighteen hundred dollars a ton and Fred selling me his fruit I bought it from him Spock market it was just awesome and I'm gonna put that in and now I need to then adjust what percentage of each is this going to be and our clone X's are biggie so let's leave that at fifty percent and then we have twenty five percent here and then we had twenty five percent of this so in these numbers can obviously be anything you need them to be okay so that's how to handle those kind of things and there's no place to put farming costs in the cost of goods but on Friday we are going to demonstrate the complete profit planner for the vineyard operations and achieving the cost of grapes okay so because farm if you put in firming costs and what about equipment and what if you know all these other other things so this is just simply you know the cost per ton and you input it and manage it here okay and let us know if that does not answer the questions you have okay all right so then I'm going to go back to my barrel costs I get a breakdown down here I can use up to you know this could be American oak or this this could all be new oak from difference different barrels with different costs and so on so a lot of flexibility for working up your barrel program and then again when you're if you're using this for for one vintage you can clone it and from the next vintage you might be changing this up or you might clone it so that you can run new scenarios for the 2018 because the you know if you're optimizing quality at the same time you're looking closely closely at your bottom line and and that's what we think makes this so valuable seller and storage there are a number of inputs here that are separate from the basic program if you're using any upright large uprights you can do in the barrel or you can assign a cost per case number of months this can also if you're using eggs or stainless feel or whatever so this is this is then also oak alternatives not that anybody ever uses those but just in case somebody did you could put your treatment costs in here and then just sort of an open field if there's anything you need to add for aging related costs if you have any additional seller treatment that were not included in that primary field for your fermentation and winemaking costs you can add those here as necessary and then needing to account for your case goods before you release your line so after the line is bottled and while it's being held on how much does it cost a month you can change that field and let's say that that it's 50% since and then you can change how many months you're adding it and it will immediately be reflected in your margins in your bottom line one of the other things that comes up it's it's often not too much but for small small lines and so on if you're using a site that's bonded licensed warehouse facility they may charge in-and-out fees and sometimes those can be a real shock any time you need a sample or need to go in and and move things in and out and then finally is the case good storage after this is usually you can zero this out this could be a marketing cost or it can be simply that after release you know from the the period of time that you release it till it's depleted might be a year so average at six months whatever the nominal monthly per case cost is okay so that gets us there packaging and bottling is pretty straightforward with a note that you can put in a stiff you know the cost of your packaging all in just put the case costs there if you want to do it on sort of the ala carte basis what are your bottles corks screw cap whatever closure capsules labels boxes etc than any additional design or packaging expenses for you know printing boxes getting your certificate of label approval those kind of things if you're working with a mobile bottler or sending it off-site this is your per case if you're doing it with your own bottling then it's really good to see if you can separate the bottling line operations equipment of repairs maintenance and whatever and come up with a paper case that it costs you to run your own bottling line any additional setups or change overs any anything else you might think of in voila we've now got our cost finished cost of goods so finished costs of goods are the wine the bottle the labels the closures the boxes and everything all in and once we get there we can go to our cost of our final breakdown and it's a cost of grapes production bulk wine barrel aging etc it gives us our margins and then this is when when we talked about on the first plate page that we're running a quick pricing scenario kind of as a as a benchmark this is this is what goes in into that formula just very quickly and again this is only for a reference so if we're saying 133 dollar fo be a distributor or selling price given a couple basic inputs of freight and so forth to the distributor then a distributor markup then we do an estimated retail shelf price at a twenty five percent margin which is a thirty three percent markup that the store would apply to that okay so again I'll go over in just a minute our new calculator the we've got for a full pricing workup but that's how it works all right questions or anything I might need to to review on that and I'll do a quick overview of the pricing calculator breve you guys have anything at your end or should I just mosey on over to the the pricing calculator I'd go ahead through the pricing calculator Tim great so what I'm going to do is is again save the work you can also set up to keep this in the edit mode in it and it will once you once you leave the program it will automatically save your work also but when I go into my auto filter then we've got a new workbook which is an actual calculator and I'll just show you this real quickly it's brand new and it's actually not even on the list but it's something that's really great again you name name the the wine in the vintage your name you would save this as a separate URL so you would bookmark this and save your work in the same way put it in the date I'm not sure how I got to okay some reason that's but I you can just manually put in the date and we'll get that fix that should be a pull down okay now what's really cool about this is if I want to look at different scenarios for pricing and what this is going to do this is this is primarily for three tier four account direct and for export sales okay and so the tabs are for working up the US distribution price pricing are there any broker fees that that that you anticipate if you're going for national distribution you'll need to have a couple percent in there to pay a broker as Commission for certain states that require brokers your freight insurance consolidation and so forth you can average for us based on the kind of quantities that you're doing are there any additional cost taxes or duties that are paid by the wholesaler okay and then any local tax rates in addition to what we're paid for your product and this is a tax rate by state PDF that will open up and give you what the tax rates are on a state-by-state basis versus the TTB site which is for for tax paid from production you can then look at various scenarios remembering that that the distributor markup is an important part of the value proposition you're offering to a distributor you may be as high as fifty percent but as you increase you know their potential markup the dis
ributor controls this not you and but you again can run the kind of scenarios that if we want to hit that $29.99 price point you know we're going to need to to either have them look at this or the other way that we can change this is go back in and lower our fo B all right so if we move that down to 170 then we can go back up and have a more compelling value proposition for the distributor to sell our line okay so you put in these elements there's the separate page for export that has additional duties and of course consolidate or consolidation Freight insurance is higher and those kind of things but but very similar to the u.s. distribution and then the final part of this is running scenarios looking at a does your distributor offer any additional discounting or deals and you could you could inflate them and this as many states do this if I'm doing business in the state of Georgia and let's say that I'm just that this project pricing is for the state of Georgia all right now when I go into my retail pricing I've got a a front-line price that's going to be heavily discounted because that's how the distributor's work there so I can see if I give a 10% discount then we're we're kind of back too far typical margins for a retail markup or as low as 15 percent or so margin for Costco up to 50 percent or even sometimes doubling it for obscure items hard to get highly allocated that kind of stuff and then this will give you your estimate of domestic retail price and then for struck pricing again you can step this up or down and see what various scenarios would be and and there you go you've got your distributor pricing so there we are and I'll be glad to answer any questions that anybody has or run through any any elements of either book tip that don't seem clear and once again if you want to if you want to say if you want to share this if I take this project and I want to show this to somebody else I hit the Save button I go to save as a PDF it'll ask me where do I want to save this and and so forth and when I hit OK it will then save this as a PDF that I can save as and put it in whatever folder I would like and so forth so it would be just like saving any other document from there you can also email a PDF by by just emailing a copy from here but it's usually best to just save it and use your own email system to do that fantastic thank you so much Tim I think that was a really comprehensive and easy to understand run-through of the profit planner from a cost of good scenario and for the winemakers out there it makes it very easy with this wine pricing calculator to understand how if a distributor wants your sob price to hit a glass pour what you need to do to work back through the cost of goods planner to hit that price point for your distributor and and work out what volumes and where you can really tweak and and push and pull your profit scenarios there to maximize your relationships with your distributors or your tasting rooms for that matter so thank you so much Tim for that and just in summary a quick reminder this is how you request access to the site's head to the industry Oregon wine org site there's a drop down tab labeled education once you click on that there will a list appear which will have Oregon wine symposium the profit planner in there and other resources click on the profit planner and then you'll be taken to the login or request access screen you will then be taken through to the user which is your email address that you've signed up for with and then you'll drop drop down through into the profit planner workbook depending on which drop-down menu you choose from the order filter there all of these tutorials all of the webinars will be housed on the Oregon wine profit planner site where you log in and request access from the for workbooks can be found here and we have a little summary of what the workbook covers the tutorials and then any related resources which we will continue to build out as we develop more workshops more webinars aimed at utilizing these tools to the most effective ability of the tool one more question coming in here after information has been entered who can see the data is it kept confidential or secure so it is kept confidential and secure there is now a privacy policy and Terms of Service Tim will also explain who can see the data so the the all the data is held on our server it is private we have a zero tolerance for accessing any of the books or for sharing any of the information that you input on your books great thanks to him and we have now included a privacy policy in terms of service on that request for access page and on the workbooks themselves we have another question here is there a place to account for samples in the cost of goods calculator for samples that are with withdrawn during production or for samples for sales purposes probably either the cost of goods calculator would be I guess production purposes reduction you can use one of the additional fields to simply put in on the appropriate page let me see that would be hang on just one second but it would be on your production page you could account for that to put a budget and amount for samples in there at Angie whatever amount you would would like to budget and in the tasting room profit calculator profit planner there is a knowledge tab as well for that and there are also additional tabs that you can personalize for your business as well exactly these are the open fields that you get to determine what we do what you would like in there what's next for the profit planners so coming this week tomorrow morning we have the marketing sales and portfolio management workbook followed on Friday by the vineyard P&L workbook so I forget also that the Oregon wine symposium has changed dates for February 2019 it is prior to the Presidents Day weekend this year and early bird pricing and registration is still available for those tickets so jump online as soon as you can and purchase those tickets the early bird pricing is severely discounted pricing that is available until the 15th of January there will be specific seminars to guide you through the use of the tool the bottom line how understanding cogs can increase your profitability is one of those and the wise academies DC metrics that matter will leverage 2018 data to drive 20 1960s and just to take advantage of having all of our producers in the one place for February 12 and 13 we've offered wise Academy direct-to-consumer workshops prior and post the symposium dates the Oregon wine board is sponsoring these workshops and you can attend for severely discounted rate if you jump on and register now for those seminars tasting room management training this is an advanced tasting room management training course which will run for the entire day on February 11th tickets are just $55 for producers anyone is open to attend these these seminars or workshops that wise Academy hosts are normally $800 so with the Oregon wine board sponsorship we are offering those for $55 spaces are limited so I would recommend that you book in for those as soon as possible is also the DDC metrics intensive on February 14th as well again limited spaces for this and it's a 50 five-dollar cost to you and the regular cost is $800 I'll also be spending sending through a survey link in a follow-up email to this webinar please take the time to fill it out we'd really appreciate that and we'll also send through the video webinar upload as well for you to share with your staff or to touch back on as well I will address that message Thank You Rebecca I'll get onto that with Tim thank you very much I thanks everyone for attending the webinar today please tune in for the final two webinars for the profit planner in the rest of the week and please feel free to reach out and share any of your experiences or questions you have with us thank you again and have a great day thank you all
