A
Akastan
Hi,
My company has various contracts that contain pricing matrixes. Some of
these matrixes have escalating cost structures based on a specific time
period. For example in the table below every 365 days the monthly cost
increases but escalation periods can differ from contract to contract. The
contracts are for services at individual sites and each site has a different
service start date.
My question is if I have a site that begins service in April 2008 and we
receive an invoice for Feb 2010 how can I reconcile the billed charge with
the correct Cost Per Year from the pricing matrix? Is there a query I can
run to determine the correct Cost Per Year?
Currently I have a form where the user enters a beginning (2/1/2010) and
ending (2/28/2010) date for the service charge period, in this case it is Feb
2010.
Contract # VENDOR NAME COST PER YEAR Service Period
BHN01 ABC COMPANY $877.00 1st year
BHN01 ABC COMPANY $960.00 2nd year
BHN01 ABC COMPANY $1,043.00 3rd Year
BHN01 ABC COMPANY $1,126.00 4th Year
BHN01 ABC COMPANY $1,209.00 5th Year
BHN01 ABC COMPANY $1,220.00 6th Year
BHN01 ABC COMPANY $1,295.00 7th Year
Thanks for your help,
Adam
My company has various contracts that contain pricing matrixes. Some of
these matrixes have escalating cost structures based on a specific time
period. For example in the table below every 365 days the monthly cost
increases but escalation periods can differ from contract to contract. The
contracts are for services at individual sites and each site has a different
service start date.
My question is if I have a site that begins service in April 2008 and we
receive an invoice for Feb 2010 how can I reconcile the billed charge with
the correct Cost Per Year from the pricing matrix? Is there a query I can
run to determine the correct Cost Per Year?
Currently I have a form where the user enters a beginning (2/1/2010) and
ending (2/28/2010) date for the service charge period, in this case it is Feb
2010.
Contract # VENDOR NAME COST PER YEAR Service Period
BHN01 ABC COMPANY $877.00 1st year
BHN01 ABC COMPANY $960.00 2nd year
BHN01 ABC COMPANY $1,043.00 3rd Year
BHN01 ABC COMPANY $1,126.00 4th Year
BHN01 ABC COMPANY $1,209.00 5th Year
BHN01 ABC COMPANY $1,220.00 6th Year
BHN01 ABC COMPANY $1,295.00 7th Year
Thanks for your help,
Adam