Re: Auto calculation of price based on cost of material and labor.

Posted by Jacopo Cappellato on Jun 26, 2006; 5:38am
URL: http://ofbiz.116.s1.nabble.com/Auto-calculation-of-price-based-on-cost-of-material-and-labor-tp140142p140148.html

Rohit,

as suggested by BJ, you should create a bom (bill of materials) for each
of your finished products (ProductAssoc); then you should set the
materials' cost (CostComponent).Then you can automatically get the cost
of the finished product (CostComponent).

For #1: manufacturing-->bill of materials-->create bom
For #2 and #3: catalog-->product-->costs

There is nothing in place to move the cost generated from the
CostComponent entity to the ProductPrice entity: you'll have to write
some custom code there (pretty simple task).

For an example of how costs are setup, have a look at the demo product
"PROD_COST".

Hope this helps,

Jacopo



Rohit Sureka wrote:

> Hi Daniel,
>
> Thanks for the reply. But this doesn't seem to be permanent solution. i was fairly sure that Ofbiz must have some kind of functionality built in support this, since ofbiz is designed for medium to large to businesses.
>
> I am just curios how do business with thounsands of products maitain there prices. Ofbiz is an ERP system and has a manufacturing module, so should it not autmatically determine a cost of the final output based on the cost of the materials used.
>
> Another example for the case may be that of a travel or hotel reservation agency,  someone using ofbiz for making hotel reservations may have a similar pricing issue. An agency may have different price discount depending on seasonality and therefore may have to adjust prices of its products. It seems at present he has no option but to manually change the price of all products.
>
> My idea is not for ofbiz to autmatically calculate the final price for all products, but to ensure that the prices fixed are atleast equal to the cost of manufacture of the product. The marketing guy can override this price, but i believe the sytem should show the cost when he edits the price.
>
>
> rohit
>