Calculating BOM product costs

[Daniel Kunkel]

Hi

Is there a way to have OFBiz calculate the cost of a manufactured
product from the bom and not a production run?

Thanks

--
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
*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-.,,.-*"*-

[Jacopo Cappellato]

Daniel,

do you mean the standard costs?
Yes, you can: go to catalog->product (edit product)-> costs
There you can set the standard cost for each of the raw materials (the
products at the bottom of the bom): select the type of "Estimated
Standard Cost", a cost amount and a currency
Then go to the costs tab of the finished product (one level above in the
bom) and run the form at the bottom of the screen ("calculate costs",
always selecting "estimated std costs"): the cost will automatically be
computed and appear in the screen.
You can see the cost (computed in this way) also in the bom simulation
screen (manufacturing application) if you select a currency in the top form.

Jacopo

Daniel Kunkel wrote:
> Hi
>
> Is there a way to have OFBiz calculate the cost of a manufactured
> product from the bom and not a production run?
>
> Thanks
>

[Daniel Kunkel]

Thanks Jacopo

On Thu, 2006-08-10 at 07:27 +0200, Jacopo Cappellato wrote:

> Daniel,
>
> do you mean the standard costs?
> Yes, you can: go to catalog->product (edit product)-> costs
> There you can set the standard cost for each of the raw materials (the
> products at the bottom of the bom): select the type of "Estimated
> Standard Cost", a cost amount and a currency
> Then go to the costs tab of the finished product (one level above in the
> bom) and run the form at the bottom of the screen ("calculate costs",
> always selecting "estimated std costs"): the cost will automatically be
> computed and appear in the screen.
> You can see the cost (computed in this way) also in the bom simulation
> screen (manufacturing application) if you select a currency in the top form.
>
> Jacopo
>
> Daniel Kunkel wrote:
> > Hi
> >
> > Is there a way to have OFBiz calculate the cost of a manufactured
> > product from the bom and not a production run?
> >
> > Thanks
> >
>

[Midhat]

I have modded the BOM a bit to include this info. but i am not following the
svn so i will clean up the code and send it some time l8r on

On 8/10/06, Daniel Kunkel <[hidden email]> wrote:

>
> Thanks Jacopo
>
> On Thu, 2006-08-10 at 07:27 +0200, Jacopo Cappellato wrote:
> > Daniel,
> >
> > do you mean the standard costs?
> > Yes, you can: go to catalog->product (edit product)-> costs
> > There you can set the standard cost for each of the raw materials (the
> > products at the bottom of the bom): select the type of "Estimated
> > Standard Cost", a cost amount and a currency
> > Then go to the costs tab of the finished product (one level above in the
> > bom) and run the form at the bottom of the screen ("calculate costs",
> > always selecting "estimated std costs"): the cost will automatically be
> > computed and appear in the screen.
> > You can see the cost (computed in this way) also in the bom simulation
> > screen (manufacturing application) if you select a currency in the top
> form.
> >
> > Jacopo
> >
> > Daniel Kunkel wrote:
> > > Hi
> > >
> > > Is there a way to have OFBiz calculate the cost of a manufactured
> > > product from the bom and not a production run?
> > >
> > > Thanks
> > >
> >
>
>

[Jacopo Cappellato]

Midhat,

thanks for this...
but before going too far with your work, maybe it's a good idea if you
have a look at the way I've implemented it in standard svn... if it's
what you need you will not need to maintain custom code; if it's not
exactly what you need, we can integrate the existing code in svn; but
please, have a look at what (and how) is implemented
(manufacturing->bill of materials->bom simulation)

Thanks,

Jacopo


Midhat Ali wrote:

> I have modded the BOM a bit to include this info. but i am not following
> the
> svn so i will clean up the code and send it some time l8r on
>
> On 8/10/06, Daniel Kunkel <[hidden email]> wrote:
>>
>> Thanks Jacopo
>>
>> On Thu, 2006-08-10 at 07:27 +0200, Jacopo Cappellato wrote:
>> > Daniel,
>> >
>> > do you mean the standard costs?
>> > Yes, you can: go to catalog->product (edit product)-> costs
>> > There you can set the standard cost for each of the raw materials (the
>> > products at the bottom of the bom): select the type of "Estimated
>> > Standard Cost", a cost amount and a currency
>> > Then go to the costs tab of the finished product (one level above in
>> the
>> > bom) and run the form at the bottom of the screen ("calculate costs",
>> > always selecting "estimated std costs"): the cost will automatically be
>> > computed and appear in the screen.
>> > You can see the cost (computed in this way) also in the bom simulation
>> > screen (manufacturing application) if you select a currency in the top
>> form.
>> >
>> > Jacopo
>> >
>> > Daniel Kunkel wrote:
>> > > Hi
>> > >
>> > > Is there a way to have OFBiz calculate the cost of a manufactured
>> > > product from the bom and not a production run?
>> > >
>> > > Thanks
>> > >
>> >
>>
>>
>

[Daniel Kunkel]

Hi

The product cost system worked well, however I couldn't get the bom
simulation to work. Is that a new feature, as I'm running a month old
svn and didn't see anyplace to specify the  currency?

--

Did you consider adding a mode to grab the component costs directly from
the product supplier table, as the way it is now I'm manually copying
the costs across, and it seems like an unnecessary duplication of data?

Thanks

Daniel

On Thu, 2006-08-10 at 07:27 +0200, Jacopo Cappellato wrote:

> Daniel,
>
> do you mean the standard costs?
> Yes, you can: go to catalog->product (edit product)-> costs
> There you can set the standard cost for each of the raw materials (the
> products at the bottom of the bom): select the type of "Estimated
> Standard Cost", a cost amount and a currency
> Then go to the costs tab of the finished product (one level above in the
> bom) and run the form at the bottom of the screen ("calculate costs",
> always selecting "estimated std costs"): the cost will automatically be
> computed and appear in the screen.
> You can see the cost (computed in this way) also in the bom simulation
> screen (manufacturing application) if you select a currency in the top form.
>
> Jacopo
>
> Daniel Kunkel wrote:
> > Hi
> >
> > Is there a way to have OFBiz calculate the cost of a manufactured
> > product from the bom and not a production run?
> >
> > Thanks
> >
>

[Jacopo Cappellato]

Yes,

implemented last week.

Jacopo

Daniel Kunkel wrote:

> Hi
>
> The product cost system worked well, however I couldn't get the bom
> simulation to work. Is that a new feature, as I'm running a month old
> svn and didn't see anyplace to specify the  currency?
>
> --
>
> Did you consider adding a mode to grab the component costs directly from
> the product supplier table, as the way it is now I'm manually copying
> the costs across, and it seems like an unnecessary duplication of data?
>
> Thanks
>
> Daniel
>
> On Thu, 2006-08-10 at 07:27 +0200, Jacopo Cappellato wrote:
>> Daniel,
>>
>> do you mean the standard costs?
>> Yes, you can: go to catalog->product (edit product)-> costs
>> There you can set the standard cost for each of the raw materials (the
>> products at the bottom of the bom): select the type of "Estimated
>> Standard Cost", a cost amount and a currency
>> Then go to the costs tab of the finished product (one level above in the
>> bom) and run the form at the bottom of the screen ("calculate costs",
>> always selecting "estimated std costs"): the cost will automatically be
>> computed and appear in the screen.
>> You can see the cost (computed in this way) also in the bom simulation
>> screen (manufacturing application) if you select a currency in the top form.
>>
>> Jacopo
>>
>> Daniel Kunkel wrote:
>>> Hi
>>>
>>> Is there a way to have OFBiz calculate the cost of a manufactured
>>> product from the bom and not a production run?
>>>
>>> Thanks
>>>

[Jacopo Cappellato]

Daniel,

sorry, I've missed your second question:

automating the process to create the costs of the raw materials is
something we have considered (but it is not in my short term todo
list)... however it could be a bit more complex that what you describe
here: we should probably consider the ProductAverageCost, the average
from history of purchase orders, the avarage of
SupplierProduct.lastPrice (more than one supplier could sell the same
product) etc...

Jacopo

Daniel Kunkel wrote:

> Hi
>
> The product cost system worked well, however I couldn't get the bom
> simulation to work. Is that a new feature, as I'm running a month old
> svn and didn't see anyplace to specify the  currency?
>
> --
>
> Did you consider adding a mode to grab the component costs directly from
> the product supplier table, as the way it is now I'm manually copying
> the costs across, and it seems like an unnecessary duplication of data?
>
> Thanks
>
> Daniel
>
> On Thu, 2006-08-10 at 07:27 +0200, Jacopo Cappellato wrote:
>> Daniel,
>>
>> do you mean the standard costs?
>> Yes, you can: go to catalog->product (edit product)-> costs
>> There you can set the standard cost for each of the raw materials (the
>> products at the bottom of the bom): select the type of "Estimated
>> Standard Cost", a cost amount and a currency
>> Then go to the costs tab of the finished product (one level above in the
>> bom) and run the form at the bottom of the screen ("calculate costs",
>> always selecting "estimated std costs"): the cost will automatically be
>> computed and appear in the screen.
>> You can see the cost (computed in this way) also in the bom simulation
>> screen (manufacturing application) if you select a currency in the top form.
>>
>> Jacopo
>>
>> Daniel Kunkel wrote:
>>> Hi
>>>
>>> Is there a way to have OFBiz calculate the cost of a manufactured
>>> product from the bom and not a production run?
>>>
>>> Thanks
>>>

[Daniel Kunkel]

Hi

Just brainstorming for a minute...

I wonder if the supplier cost table and the cost_estimate table should
be combined...  It seems they already have a lot of fields overlapping,
but the cost estimator is much more complete.

With some work, the cost of the product could return a range based on
the lowest and highest costs of each component and possibly even
including the total parts cost based on minimum quantity requirements to
reach each price point.

Eventually reports could also be generated to help track the current
cost to produce a product based on the current cost of the components
verses the average cost which is based on the historic price actually
paid for the components to help businesses judge when they need to
adjust their retail price.

Finally, at the really-high-end, there is the possibility of adding a
statistical dynamic pricing system that automatically adjusts the retail
price to maximize profit... hmmm.

Thanks



On Thu, 2006-08-10 at 09:12 +0200, Jacopo Cappellato wrote:

> Daniel,
>
> sorry, I've missed your second question:
>
> automating the process to create the costs of the raw materials is
> something we have considered (but it is not in my short term todo
> list)... however it could be a bit more complex that what you describe
> here: we should probably consider the ProductAverageCost, the average
> from history of purchase orders, the avarage of
> SupplierProduct.lastPrice (more than one supplier could sell the same
> product) etc...
>
> Jacopo
>
> Daniel Kunkel wrote:
> > Hi
> >
> > The product cost system worked well, however I couldn't get the bom
> > simulation to work. Is that a new feature, as I'm running a month old
> > svn and didn't see anyplace to specify the  currency?
> >
> > --
> >
> > Did you consider adding a mode to grab the component costs directly from
> > the product supplier table, as the way it is now I'm manually copying
> > the costs across, and it seems like an unnecessary duplication of data?
> >
> > Thanks
> >
> > Daniel
> >
> > On Thu, 2006-08-10 at 07:27 +0200, Jacopo Cappellato wrote:
> >> Daniel,
> >>
> >> do you mean the standard costs?
> >> Yes, you can: go to catalog->product (edit product)-> costs
> >> There you can set the standard cost for each of the raw materials (the
> >> products at the bottom of the bom): select the type of "Estimated
> >> Standard Cost", a cost amount and a currency
> >> Then go to the costs tab of the finished product (one level above in the
> >> bom) and run the form at the bottom of the screen ("calculate costs",
> >> always selecting "estimated std costs"): the cost will automatically be
> >> computed and appear in the screen.
> >> You can see the cost (computed in this way) also in the bom simulation
> >> screen (manufacturing application) if you select a currency in the top form.
> >>
> >> Jacopo
> >>
> >> Daniel Kunkel wrote:
> >>> Hi
> >>>
> >>> Is there a way to have OFBiz calculate the cost of a manufactured
> >>> product from the bom and not a production run?
> >>>
> >>> Thanks
> >>>