As someone testing ERPNext, I can’t find out how to estimate the cost of making an order. In my BOM I have entered the costs for making 1 item. So how do I get an estimate of the cost to make 100, for example, without creating a new BOM? The only solution that I can find online is to create a new BOM. Surely there must be a simple method of scaling up/down according to volume and the BOM? It would be useful to have this information when making a quotation to make sure your not selling at less than cost.
Thanks for your input but this doesn’t really address the issue. I don’t want to have to make a draft BOM each time. The BOM should be setup in such a way as to allow you to scale up the costs quite easily. So variable costs should scale with the number of units made (eg raw materials, labour etc) whilst fixed costs well remain the same (eg setup costs, clean down costs etc).
I can’t believe this functionality doesn’t already exist in the system. Anyone else know how to do this?
I have the same question as you and I am also surprised at the lack of this function.
We are often asked to quote for a quantity of 1, 2 ,5, 10 or 100 of an item so that our customers can choose the optimum quantity to order for their stock requirements.
Please let me know if you get any answers !
Hi @jaliya. Thanks for your input but in my opinion there should be only one BOM per product. If I follow your suggestion, then there will be multiple BOMs relating to the same product but different quantities. I can see that becoming unmanageable in situations where you make different variants of one product according to customer requirements.
I cant see why, if you have a BOM set-up with all the fixed and variable costs, that it can’t be used to calculate sales costs and prices for different quantities. Ideally I’d expect to see one BOM for a product, a quantity required and a calculation of costs/sales price.
Sorry for the direct message guys but you seem to know most about the manufacturing module and I can’t find anyone else who can answer my question.
In short my question is if I have a BOM for 1 unit, can I use this to scale up costs for 100 units or am I obliged to recreate a new BOM for 100 units? We manufacture to order so being able to do this would be a priority for us.
I thought the BOM was a manufacturing tool not a quoting tool. Although it would be nice, I can see and understand why it will not do what you want it to. It is outside the scope of what it was designed for.
We also manufacture to order. The BOM is set up as the material requirements to manufacture 1 u-bolt.
We estimate costs for manufactring different quantities of the u-bolt, and different products externally
The BOM tool is not currently very good for quoting. Not only is the quantity a problem (especially when you have pricing rules based on volume discounts), but the prices of BOMs don’t update when you have many sub levels.
I started working on a tool that would categorize BOM costs better, but it’s a definite work in progress. The code is here for anyone who wants to use it / work on it:
Once I have a change to get it functional, I’ll integrate it with the core code so everyone can have a good tool for estimating the BOM costs with full price breakdowns, etc.
Wouldn’t a BOM report with last purchase rate and stock valuation report that lists the exploded BOM the quantities and the total rates serve your requirements? While I can understand the need to get the costing of the products you manufacture, the Cost of Goods Sold can also serve this very same purpose?
COGS would directly work for products you have made and shipped, while the BOM report would work for products you are conceptualizing as long as you have bought the raw materials and components before.
I mean, let’s say you pass a manufacturing entry for Product A, the Valuation of Product A will be the sum of valuations of the components of the BOM and the Opearational costs (assuming that you are tracking operational costs).
Now when you invoice Product A, the valuation of this stock gets transfered from your Balance Sheet (it was in your Current Assets - Stock Assets head) to an expense account - usually Cost of Goods Sold.
So, if you go to your general ledger and look for the Delivery Notes (or Invoices) where you have invoices Product A, and choose Cost of Goods Sold (or the appropriate expense account to which you have booked this expense), you will get the cost of making Product A.
Of course where you have multiple products being invoiced together, the COGS for that invoice will be the sum total of the COGS for all the products you are invoicing.
In such cases, you go to the stock ledger report and figure out the valuation of the Product A on the day it got invoiced. That will be the COGS for Product A, specific to the BOM you used to manufacture that product.
I know this is an old thread… according to the documentation, ERPNext 13 does offer BOM costing, including an “Update BOM Cost Automatically” option. Does that mean that the functionality requested in this thread is now available, or is there still a gap to close here?