Hi experts
Below is the requirement.
Every support contract in the given scenario is valid only till 1yr. 1week before contract expiry, renewal contract is created for next period of 1yr.This is a continuous process.
But the support fee, upon every renewal, is incremented by certain % for each support type and its applied across each item. Example.
Existing contract:10001--
Contract Start date: May 30 2008--
Contract End date: May 30 2009
Items--
description
qty--
price
item 001--
car service-BMW
1--
1000
item 010--
car service-GMC
1--
2000
item277--
truck service-engine---- 2----
5000(2500 each)
item211--
truck service-full
1--
10000
When the contract is renewed and new contract is created, say on May 31 2009, company will have fixed renewal fee for the car service - 10% and truck services - 5%, so new contract should have below price.
Existing contract:10101--
Contract Start date: May 31 2009--
Contract End date: May 31 2010
Items -
description -
qty -
price
item 001--
car service-BMW--
1 -
1100[1000+100->10% increase]
item 010--
car service-GMC--
1 -
2200[2000+200->10% increase]
item277--
truck service-engine-----2 -
5250[5000+125*2 ->5% increase each]
item211--
truck service-full--
1 -
10500[10000+500->5% increase]
How can the above be achieved for every year renewal of contracts, while the % increase of renewal fee is fixed for an year and is subject to change year affter year.
Pls enlighten with your expert comments.
Thanks for earliest reponses
Banu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.