My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 87: cutting costs calculation does not work properly
1 person starred this issue and may be notified of changes. Back to list
Status:  Fixed
Owner:  gzoli71
Closed:  Jul 2014


 
Project Member Reported by tam...@gmail.com, May 28, 2014
We have faced an issue at belt cutting calculation, seems that it is not working properly. Exaples:

1. user Biz Plima
item 12 PL 635
MD calc: 36,28 eur correct price should be: 35,28 eur. So it adds one EUR.


2. user M&M 
item 2450 RPP14 DD 85
MD calc: 313,88 eur correct price should be: 334,4 eur so it does not add 10% not even one EUR.



May 28, 2014
Project Member #1 gzoli71
1. I think the difference here comes from the formula. In the example the cut cost for the product is 0, but the min cut cost for the partner is 1 (check the formula), so I add 1. Most probably the formula should be changed in a way that if the cut cost is zero for the product then the min and max values are not used. If I change the formula then I get the correct result 35.28.

2. Here I have corrected the calculation according to 1) but the result is still not the same as your result.
base price=328.185
cut unit based cost=0 (because cut unit is 0 for the partner)
cut precentage based cost=10eur (because max for the partner is 10)
=338.19 eur but yours is 334.4. Please recalculate this again.

If something is not clear speak with Eliza as well. She was helping in this.
Status: Started
Labels: Milestone-3.2
May 29, 2014
Project Member #2 tam...@gmail.com
Zoli, you are right... The formula is not precise 100%, might be missunderstood. I will re-define it and let you know ASAP. 
The price for the 2nd example is correct.
May 29, 2014
Project Member #3 gzoli71
I think the formula should changed to 

total price = (unit_price x width x discount(partner)) + (unit_price x cut_unit x cut_cost x discount(partner)) + min( cut_max(partner)x cut_cost, max(cut_min(partner)x cut_cost, unit_price x width x discount(partner) x cut_percent(partner) x cut_cost))

The change is at cut_max(partner) and cut_min(partner). I multiplied both with cut_cost that is the product dependent cut cost, 0 or 1. This way if cut_cost is 0 then even the min cut cost is not added.


Jul 2, 2014
Project Member #4 tam...@gmail.com
This is correct, so please go ahead with implementing the change. 
The point is, that if unit_price x width x discount(partner) x cut_percent(partner) x cut_cost = 0, than this part has to be 0, if unit_price x width x discount(partner) x cut_percent(partner) x cut_cost >0, than this part should be the vaule, but between the min and max.
Jul 8, 2014
Project Member #5 gzoli71
this is done
Status: Fixed

Powered by Google Project Hosting