Stock value & wastage

how does breww value stock & what are the options for configuring wastage surely my stock's value is the same as what it cost me to produce? sometimes yes, but not always essentially, there is a difference between the "cost to produce" and the "value", and this can cause confusion, so it's important to understand the options and why the batch cost report and margin reports show you the "cost to produce", which may be different from the stock’s "value" which is shown in the "stock valuation" report breww will track the per litre cost of the beer for valuation purposes and use this on the stock valuation report this is slightly different to the costings used for margin reports in breww this is further explained here batch costings & wip value docid\ dphf5ba4pbf7ykxfxktzf the main issue with valuing your stock at its production cost is best illustrated with an example if you spent £1,000 producing 1,000l of beer and then packaged it into a single 500ml bottle before the rest of the batch was lost for some reason (let's pretend the valve got stock open the rest was dumped on the floor) if the bottle was valued at the cost to produce, it would be valued at £1,000 which is clearly not a fair valuation for a single bottle of beer with the per litre valuation method, the bottle is instead valued at a much more realistic £0 50, which is why breww uses this method as the starting point for calculating the initial value wastage options breww allows you to customise how you'd like wastage (loss volumes) to affect your valuation of beer stock this effectively allows you to choose to value your stock at the "cost to produce", a straight per litre value, or a sensible middle ground where an expected wastage is used to choose an option, simply head to reporting > production & inventory reports > stock valuations > valuation settings no expected wastage this option will assume all wastage is unexpected, and any wastage will reduce the valuation of the goods use recipe expected wastage (recommended) this will look at the expected wastage set on the batch's recipe and use it to calculate whether you lost more or less than expected if you lose more than expected, the valuation will be reduced proportionally, and if you lose less than expected, it will increase proportionally ignore wastage this will completely ignore wastage so that any waste won't affect the valuation of the goods the value of the goods will be the same as the cost it took to make the goods why is wastage important in valuing my stock? as with most things, we find the best way to explain is with an example! say you had a 1,000 l batch, which cost you £1,000 to make you expect to package 900 l , which would be a waste rate of 10% if everything goes to plan, and you package the expected 900 l , it is fair to say that the value of that stock is the same as what you put in, i e £1,000 however, if something goes wrong in the process and you only end up with a single 440 ml can, it is tricky to say that the can is worth £1,000, even though that's what it costs you to make it adjusting the calculation based on an expected wastage helps us settle on an appropriate base value this is why we recommend the recipe expected wastage method however, with breww, you're free to choose an option that suits you and how you work best resulting stock values to help you choose the best option for you, we will show you the stock valuation figures that each option would result in using the example above to recap, you had a 1,000 l batch, which cost you £1,000 to make you expected to package 900 l , which would have a wastage rate of 10% you end up successfully packaging 800 l , so less than expected no expected wastage as we're not expecting any loss, we simply carry through the per litre value of the batch the batch costs £1,000 / 1,000 l = £1 per litre , so the final value of our stock is £800 use recipe expected wastage (recommended) this method accounts for some wastage but not a limitless amount so if there is a large amount of wastage, or we're much more efficient than expected, this will affect the final value of our batch's stock in this example, a 100 l loss was expected, but 200 l was actually lost breww first calculates the per litre value based on the expected packaged volume of 900 l , to get £1,000 / 900 l = £1 1111 per litre this is used to give us a final stock value of £1 1111 x 800 l = £888 89 if we had actually hit our expected packaging volume of 900 l , then the stock would be worth £1 1111 x 900 l = £1,000 , i e the total amount the batch cost us if we were amazingly efficient and successfully packaged 1,000 l , the stock would be worth £1 1111 x 1,000 l = £1,111 11 , as we would have more to sell than expected ignore wastage this method ignores wastage entirely it is the same as valuing your stock at cost, so the 900 l of stock will be worth the £1,000 that the batch cost the table below shows the different values generated for different packaging options using the same example of a 1,000 l batch, with £1,000 of costs and an expected wastage of 10% method packaged 300 l packaged 800 l packaged 900 l packaged 950 l no expected wastage £300 £800 £900 £950 use recipe expected wastage £333 33 £888 89 £1,000 £1,055 56 ignore wastage £1,000 £1,000 £1,000 £1,000