This topic contains 2 replies, has 2 voices, and was last updated by 
-
Posts
-
Hi,
I am in the “Enter cellar & barrel ovehead costs” part of the Forecast the Overhead Costs.
Not very many of our lots show barrel tags in IV when I run the report the way you demonstrate. Should I “show archived”? When doing that so many more lots display barrels tags but I am not sure if they should be used?
Thanks,
valHi Val,
The barrel tags need to be added to the new bulk lots. Has that been done?Second, when a blend is made, that new lot might need a barrel tag. Some winemakers make their blends just before bottling. If that is the case, then you won’t need a barrel tag because that bulk lot will only be around for a short period.
Another way to decide the barrel tags is to use the % of both new oak and one-year barrels. We used this formula for a winery with a similar barrel program as yours: 100% of the gallons in new oak plus 50% of the gallons in 1-year-old barrels. Hopefully, this will give a more even distribution of the barrel tags.
The barrel tags should be used consistently. If not, then just a few lots might end up with the allocation of the entire barrel cost. However, for you folks, that barrel cost is quite small.
One more thing: We found that forecasting the barrel gallons is the hardest number to figure out. But we discovered a nice shortcut.
1. Open your Reconciliation workbook from the previous year.
2. Take the grand total of the barrel cost item and divide by that year’s 100% value. This is the number of barrel gallons that you had that year.
3. Compare the beginning gallons the previous year with the beginning gallons the current year. Adjust the barrel gallons by the % difference. For example, if your beginning gallons this year is 50% higher than last year, your barrel gallons will increase 50%.Use this forecasted barrel gallons number to calculate your barrel rate.
Cheers!
JeanetteHi Jeanette,
Thank you for the response.
Yes, our new lots were assigned barrel tags after harvest last year.
I am still wondering if I need to include the barrel tags of the archived lots on my forecasting sheet? I saw on your video that you had “hide archived” when searching for the lots with barrel tags.
Thank you for the tip on froecasting the barrel gallons, I will check it out!
Best,
val
You must be logged in to reply to this topic.