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 83: new cutting cost calculation method
2 people starred this issue and may be notified of changes. Back to list
 
Project Member Reported by tam...@gmail.com, Jan 22, 2014
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
Correction:

THe mm price should be added to the new rule. Therefore if I set the new rule to 0 then only mm price is used. If I set the mm price to 0 then the new rule is used. If I set both >0 then both are used. THis will give us full flexibility.
Jan 23, 2014
Project Member #2 tam...@gmail.com
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"
Jan 23, 2014
Project Member #3 tam...@gmail.com
 Issue 13  has been merged into this issue.
Cc: eliza.jo...@gmail.com tam...@gmail.com
Jul 8, 2014
Project Member #4 gzoli71
This has been implemented, the description is on wiki
Status: Fixed

Powered by Google Project Hosting