Hi,
I need a little help with a equation I am trying to develop, if there is anyone out there willing to help.
I operate a business which exports vehicles around the world.
We purchase a lot of cars and trucks and want to develop an equation which will allow us to save a lot of time evaluating whether we should buy a certain vehicle.
However, we are not math experts.
Here is what we are looking for.
There are 3 variables which we look at when purchasing a vehicle; Age, Mileage and Cost.
So based on those 3 variables we would like to create a equation which would give us a number. That number would help us determine whether that particular vehicle is a good bargain, or if we decide to make an offer, at which price we should buy.
x = profitiablity coeficient
a = age of vehicle
m = mileage of vehicle
c = asking price of said vehicle
We will re-create this equation in Microsoft Excel (i can handle that part) and we will be able to evaluate hundreds of vehicles at once and only focus on the highest profitability vehicles.
If you have questions, don't hesitate to ask.
I need a little help with a equation I am trying to develop, if there is anyone out there willing to help.
I operate a business which exports vehicles around the world.
We purchase a lot of cars and trucks and want to develop an equation which will allow us to save a lot of time evaluating whether we should buy a certain vehicle.
However, we are not math experts.
Here is what we are looking for.
There are 3 variables which we look at when purchasing a vehicle; Age, Mileage and Cost.
So based on those 3 variables we would like to create a equation which would give us a number. That number would help us determine whether that particular vehicle is a good bargain, or if we decide to make an offer, at which price we should buy.
x = profitiablity coeficient
a = age of vehicle
m = mileage of vehicle
c = asking price of said vehicle
We will re-create this equation in Microsoft Excel (i can handle that part) and we will be able to evaluate hundreds of vehicles at once and only focus on the highest profitability vehicles.
If you have questions, don't hesitate to ask.