Is there a way to generate a Sales Quotation from a BOM, by summing up the material cost + ((estimated time) x (workcenter cost))?
We often receive drawings of the product from the potential customer, and we must quote on manufacturing this product (there is no pricelist, and no fixed cost for us to markup). These products are typically one-offs (prototypes), so we haven't built it before and don't know how much it will cost.
A customer asks me to quote on a product for him (a chair), he provides me with a set of drawings, for me to manufacture and assemble. He will buy the finished chair from me. He includes drawings for: a chair leg, a seat, a chair back, and a finished chair assembly.
I create 4 products, each with their own BOM and Routings:
(1) I create a product including BOM and Routing for a leg.
(2) I create a product including BOM and Routing for a seat.
(3) I create a product including BOM and Routing for a back.
(4) I create a product including BOM (consisting of 4 legs, 1 seat, and 1 back), and Routing directing my staff how to assemble the chair.
I do not wish to manufacture the product yet. I just want a cost buildup.
I want to run a report (preferably include the finished chair as a line in the quotation) which produces the estimated cost based on the products I have defined and the work I expect it would take. It would need to be recursive because it would need to dig into each subproduct and examine if it contains any other manufactured parts and dig in to those if need be. Ideally it would also calculate the lead times for any material I need to purchase.
I have read through the Streamline your Manufacturing Process with OpenERP book, and could not find anything that explained how to get this estimated cost buildup.
Compute product cost price by recursively summing parts cost prices according to product BOM. It takes into account the BoM costing (cost per cycle and so...).
Providing you do everything you have written above correctly, this will produce a BoM Cost amount on the product, so when you create a quote for it you can use it as the basis for a sales price.
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 11/3/13, 11:20 PM|
|Seen: 2580 times|
|Last updated: 3/16/15, 8:10 AM|