Pricing Matrix
From: ytmatrix <rickw_at_parones.com>
Date: Thu, 27 Oct 2005 12:29:07 -0400
Message-ID: <4fc545236446e518fb7ee17a6f57d23f_at_localhost.talkaboutdatabases.com>
I need to create a four varible pricing matrix for my sales reps. The following variables will affect the price.
Date: Thu, 27 Oct 2005 12:29:07 -0400
Message-ID: <4fc545236446e518fb7ee17a6f57d23f_at_localhost.talkaboutdatabases.com>
I need to create a four varible pricing matrix for my sales reps. The following variables will affect the price.
if distance increases, then price decreases if reward increases, then price increases if attempts increase, then price increases if skill level increases, then price increases
there is a minimum distance of 150, below which pricing is not allowed and a maximum distance of 200, above which pricing is not effected.
there are 3 skill levels, 0=novice
1=intermediate
2=skilled
How do I create the formula or matrix or spreadsheet???
Any suggestions or assistance will be greatly appreciated!!! Received on Thu Oct 27 2005 - 18:29:07 CEST