| Issue 83: | new cutting cost calculation method | |
| 2 people starred this issue and may be notified of changes. | Back to list |
|
We have decided to optimize our prices of cut belts, therefore some changes are essential at config 3. Among the existing calculation method we would like to implement a new method, where we add 10% surgarge on the cutting with minimum and maximum values. At the same time we would like to be able to determine ourselves at which costumer we apply the "old" and at which we apply the "new" rule. Our idea is to create new columns on the "USERID" worksheet of the excel file like: 'MM'; 'CUT%'; 'CUT MIN'; ’CUT MAX'. Where the 'MM' column data is set to 1, there we apply the "old" rule: " piece price = rib number or mm number + cutCost multiplied with unit price if belt, sleeve price if sleeve was chosen. „on request” if belt and price unit is mm and width <6 mm" Where the "MM" column data is set to 0, the „new” rule should be applied: " piece price = sleeve price if sleeve was chosen, if belt: rib number or mm number multiplied with unit price + added the percentage set in ’CUT%’ but minimum the amount set in ’CUT MIN’ and maximum the amount set in ’CUT MAX’. „on request” if belt and price unit is mm and width <6 mm"
Jan 22, 2014
Project Member
#1
lutz.and...@gmail.com
Jan 23, 2014
Addition: if all the values are set to 0, non of the rules are applied, so in this case: " piece price = rib number or mm number multiplied with unit price if belt, sleeve price if sleeve was chosen. „on request” if belt and price unit is mm and width <6 mm" in case both rules are applied (we set all the values >0), "piece price = sleeve price if sleeve was chosen, if belt: rib number or mm number multiplied with unit price + added the percentage set in ’CUT%’ but minimum the amount set in ’CUT MIN’ and maximum the amount set in ’CUT MAX’ + 'cutcost' multiplied with the unit price. „on request” if belt and price unit is mm and width <6 mm"
Jul 8, 2014
This has been implemented, the description is on wiki
Status:
Fixed
|
||||||||||