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

Posted by Daniel Kunkel on Jun 26, 2006; 1:43am
URL: http://ofbiz.116.s1.nabble.com/Auto-calculation-of-price-based-on-cost-of-material-and-labor-tp140142p140144.html

Hi

One other hack that might work well for this would be to create an excel
xml spreadsheet with the products and a calculation for the price.

When the price changes, you could just re-import the affected products,
and excel would do whatever calculations you wanted. Or you could create
a few dozen xml files for different gold prices, and just import the
appropriate one when the price changes.

I wouldn't normally suggest such a hack normally, but it seems like it
might be appropriate in this situation.

Daniel






On Sat, 2006-06-24 at 03:34 -0700, BJ Freeman wrote:

> I would use the manufacturing module and create BOM, so you have all the
> components of the item.
> from there the price can be determined. currently the pricing used lifo,
>   fifo, averaging. so there many need to be a change in the code for
> following gold prices.
>
>
> Rohit Sureka sent the following on 6/23/06 10:51 PM:
> > hi,
> >
> > i was curious if one could automatically calculate product price based on material and labor cost.
> >
> > To give a better perspective of what i mean, i will brief about our products. We basically sell silverware and gold jewelry items. The price of the product is based on cost Silver and Gold, plus the labor charges to manufacture it which is a percentage of the metal price. Typical pricing method would be Gold price + 30%(just for illustration), this if metal costs are $100, the minimum sale price has to be $130 . Now bullion prices have been very volatile over the past few weeks. From $71 an ounce to $57 approx. This completely changes the pricing and cost structure and a store which has thousands of products, it would be a tiring task to manually update the prices of all products.
> >
> > Therefore is it possible to define a material like gold, which price per ounce can be updated as frequently as needed. The product will have a feature denoting the metal weight, such that it calculates the cost of gold based on the metal weigth in the product and adds to it the labor price to fianlly arrive at the minimum sales price.
> >
> > For e.g.
> >
> > Standard metal rate is $50 per ounce.
> > Product X has 1/2 ounce of gold.
> > Thus the minimum product price is $50/2 * 1.30 = $32.5.
> >
> > I think it is possible to do this in the standard ofbiz download, i.e. without modifying the code, but have not been able to figure out how to do it.
> >
> > Any suggestions or comments will be appreciated.
> >
> > Thank you.
> >
> > rohit
> >
> >  __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com 

--
Daniel

*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-
Have a GREAT Day!

Daniel Kunkel           [hidden email]
BioWaves, LLC           http://www.BioWaves.com
14150 NE 20th St. Suite F1
Bellevue, WA 98007
800-734-3588    425-895-0050
http://www.Apartment-Pets.com  http://www.SatelliteRadioZone.com
http://www.Cards-Visa.com       http://www.ColorGlasses.com
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-