You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by ja...@productive1.com on 2018/04/04 15:33:49 UTC
Price Rule Engine
I noticed that the pricing engine will calculate off a percent off of
list, default, Average costs, and margin but it is always using the List
price as the base price so an example would be Price = Price *(20% of
Average costs)
What if you wanted all of your pricing to be based off of average costs.
So I want 30% margin or 130% of my costs. So everything is based of
average costs and list is not in the equation.
Any insight on how to accomplish?
Thanks,
James
Re: Price Rule Engine
Posted by Arthur Marquez <ar...@gmail.com>.
James,
I'm sure others can help you address this.
However, having done a lot of pricing scenarios, I've discovered some
misunderstanding that often occurs when addressing MARGIN, vs MARK-UP.
30% margin is accomplished by taking COST (whether average, or actual), and
using 1,429 as the multiplier.
Hence, 130% of cost, would achieve only 23% margin, which would *not* reach
your objective if a 30% margin.
I've included a chart to help illustrate this example.
I hope you find this helpful.
Arthur
*Arthur Marquez*
*1-701-872-4471 : Office*
*1-818-919-5452 : Mobile*
*Farmers Union Oil Company of Beach ND*
*Farmers Union Propane, C3H8*
*90 NE 1st St.*
*Beach ND 58621*
*http://www.cenexofbeach.com/ <http://www.cenexofbeach.com/>*
On Wed, Apr 4, 2018 at 9:33 AM, <ja...@productive1.com> wrote:
>
> I noticed that the pricing engine will calculate off a percent off of
> list, default, Average costs, and margin but it is always using the List
> price as the base price so an example would be Price = Price *(20% of
> Average costs)
>
> What if you wanted all of your pricing to be based off of average costs.
> So I want 30% margin or 130% of my costs. So everything is based of
> average costs and list is not in the equation.
>
> Any insight on how to accomplish?
>
> Thanks,
>
> James
>
Re: Price Rule Engine
Posted by Arthur Marquez <ar...@gmail.com>.
Cost (or average cost) x (1.30) = 23% GM (Margin)
30% margin would be (*cost*) x (*1.429*)
*Arthur Marquez*
*1-701-872-4471 : Office*
*1-818-919-5452 : Mobile*
*Farmers Union Oil Company of Beach ND*
*Farmers Union Propane, C3H8*
*90 NE 1st St.*
*Beach ND 58621*
*http://www.cenexofbeach.com/ <http://www.cenexofbeach.com/>*
On Wed, Apr 4, 2018 at 9:33 AM, <ja...@productive1.com> wrote:
>
> I noticed that the pricing engine will calculate off a percent off of
> list, default, Average costs, and margin but it is always using the List
> price as the base price so an example would be Price = Price *(20% of
> Average costs)
>
> What if you wanted all of your pricing to be based off of average costs.
> So I want 30% margin or 130% of my costs. So everything is based of
> average costs and list is not in the equation.
>
> Any insight on how to accomplish?
>
> Thanks,
>
> James
>