Home Page › Forums › IV & QB – Cost Accounting Made Easy › Barrel tags
This topic contains 2 replies, has 2 voices, and was last updated by Val Nelson 1 month, 1 week ago.
-
AuthorPosts
-
March 19, 2024 at 1:36 PM #58463
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,
valMarch 20, 2024 at 2:26 PM #58467Hi 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!
JeanetteMarch 20, 2024 at 5:18 PM #58468Hi 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 -
AuthorPosts
You must be logged in to reply to this topic.