# Thread: Have Problem - Need Formula

1. ## Have Problem - Need Formula

I am not sure who to ask or where to go with this, but if this is the wrong place, please tell me where to go (politely please ) OR better yet, if you know of someone who can do this for me on my web site, please refer me to them or them to me. I am happy to pay someone to accomplish what I need.

I need to create a formula to decide how much it will cost my customers to display my painted logos/signs on company car doors (for example). There are several criteria and each one depends on other criteria. It gets complicated and is beyond my grade 12 math skills of many years ago so I need some help. I also need to change this into computer code so that the client can calculate their cost online in real time depending on the criteria they enter.

There is an UN-CALCULATED BASE RATE (let's say $0.25 per mile), but this will need to be adjusted from time to time. The CALCULATED BASE RATE will depend on the following: 1) Type of route on which the art work travels. a) Urban (higher cost per mile — base rate x 1.5) b) Rural (lower cost per mile — base rate x 0. c) Freeway (lowest cost per mile — base rate x .6) d) Mix (determined by the percentage mix of all of the above = CALCULATED BASE RATE 1 2) The length of time when the artwork is being displayed during specific times of the day a) rush hour travel (7 AM – 10 AM and 4 PM – 7PM) will cost more per mile = base rate x 2 b) Daylight hours other than rush hours = base rate x 1.5 c) Night hours other than rush hours = base rate x 1 1) x 2) = CALCULATED BASE RATE 2 (not sure if this should be 'X" or "+" ) 3) The distance the artwork travels. distance x above CALCULATED BASE RATE 2 So, for example if a client's sign travels 100 miles (10 miles urban, 30 miles rural, 60 miles freeway) for 7 hours (3 rush hours, 3 daylight hours and 1 night hour) what will the rate per mile be? How much will it cost in total? Please feel free to ask any questions or comments. Thank you for your help in advance. 2. [QUOTE=Boballoo;473987]I am not sure who to ask or where to go with this, but if this is the wrong place, please tell me where to go (politely please ) OR better yet, if you know of someone who can do this for me on my web site, please refer me to them or them to me. I am happy to pay someone to accomplish what I need. I need to create a formula to decide how much it will cost my customers to display my painted logos/signs on company car doors (for example). There are several criteria and each one depends on other criteria. It gets complicated and is beyond my grade 12 math skills of many years ago so I need some help. I also need to change this into computer code so that the client can calculate their cost online in real time depending on the criteria they enter. There is an UN-CALCULATED BASE RATE (let's say$0.25 per mile), but this will need to be adjusted from time to time. The CALCULATED BASE RATE will depend on the following:

1) Type of route on which the art work travels.
a) Urban (higher cost per mile — base rate x 1.5)
b) Rural (lower cost per mile — base rate x 0.
There's something missing here. At first I though you were saying that there was no cost for for rural driving but then you say that Freeway driving is lowest. Was this 1.0 times your base rate?

c) Freeway (lowest cost per mile — base rate x .6)
d) Mix (determined by the percentage mix of all of the above

= CALCULATED BASE RATE 1

2) The length of time when the artwork is being displayed during specific times of the day
a) rush hour travel (7 AM – 10 AM and 4 PM – 7PM) will cost more per mile = base rate x 2
b) Daylight hours other than rush hours = base rate x 1.5
c) Night hours other than rush hours = base rate x 1

1) x 2) = CALCULATED BASE RATE 2 (not sure if this should be 'X" or "+" )

3) The distance the artwork travels.

distance x above CALCULATED BASE RATE 2

So, for example if a client's sign travels 100 miles (10 miles urban, 30 miles rural, 60 miles freeway) for 7 hours (3 rush hours, 3 daylight hours and 1 night hour) what will the rate per mile be? How much will it cost in total?

It's really just a matter of doing carefully what you wrote above. The base rate is .25/mile. Urban rate is "base rate x 1.5" so the urban rate is (.25)(1.5)= .375/mile. Rural rate is R*.25, whatever the missing rural rate, R, is. Freeway rate is .25(0.6)= 0.15. If the sign is driven x miles urban, y miles rural, z miles freeway, then the milage cost is .375x+ .25Ry+ 0.15z.

Assuming the "uncalculated base rate" is still that .25, then for time, the cost is 2(.25)= .5 on rush hour, 1.5(.25)= .375 on daylight, 1(.25)= .25 hour on night. If there are u hours of rush hour, v hours of non-rush hour day, w hours of non-rush hour night, the total for time is .5u+ .375v+ .25w.

Now, for (3) are you saying that the rate calculated on time is then multiplied by the entire length of the trip, x+ y+ z? If so, that charge would be (.5u+ .375v+ .25w)(x+ y+ z)

The total charge (add them, don't multiply- if you multiply you get units of "square dollars" which makes no sense) would be .375x+ .25Ry+ 0.15z+ (.5u+ .375v+ .25w)(x+ y+ z).

3. Originally Posted by HallsofIvy
There's something missing here. At first I though you were saying that there was no cost for for rural driving but then you say that Freeway driving is lowest. Was this 1.0 times your base rate?
That you so much for your help. It should read 0.8 (The 8 beside an end bracket gives us a smiley like this 0.8) )
Originally Posted by HallsofIvy
It's really just a matter of doing carefully what you wrote above. The base rate is .25/mile. Urban rate is "base rate x 1.5" so the urban rate is (.25)(1.5)= .375/mile. Rural rate is R*.25, whatever the missing rural rate, R, is. Freeway rate is .25(0.6)= 0.15. If the sign is driven x miles urban, y miles rural, z miles freeway, then the milage cost is .375x+ .25Ry+ 0.15z.
Okay, so... that will give me the total cost right?
Originally Posted by HallsofIvy
Assuming the "uncalculated base rate" is still that .25, then for time, the cost is 2(.25)= .5 on rush hour, 1.5(.25)= .375 on daylight, 1(.25)= .25 hour on night. If there are u hours of rush hour, v hours of non-rush hour day, w hours of non-rush hour night, the total for time is .5u+ .375v+ .25w.

Now, for (3) are you saying that the rate calculated on time is then multiplied by the entire length of the trip, x+ y+ z? If so, that charge would be (.5u+ .375v+ .25w)(x+ y+ z)

The total charge (add them, don't multiply- if you multiply you get units of "square dollars" which makes no sense) would be .375x+ .25Ry+ 0.15z+ (.5u+ .375v+ .25w)(x+ y+ z).
Well, I can see what you mean here and I probably pointed you in that direction but I was looking for a way to calculate the overall per mile rate. Then the client could easily calculate how much it will cost in total given the number of miles traveled, which is the unknown figure here as the trips will vary. Also, it seems like I am charging the client twice: once for miles traveled on urban streets and once for miles traveled at night etc. etc. I think we need to add the overall increase (or decrease) in the rates to arrive at the average per mile rate that we could then multiply by the number of miles traveled. Does that make sense? Sorry if I was not clear in the original post.

4. I think if we can start with the base rate of \$0.25 per mile, then add (or subtract) the increases (or decreases) in the rate... but then we would have to take into account the multiplication by the miles traveled at certain rates which will change depending on the trip. Here is how I see it (but my logic may be flawed:

x = .25 x 1.5 = rate per urban mile
y = .25 x 0.8 = rate per rural mile
z = .25 x 0.6 = rate per freeway mile

u = .25 x 1 = rate per nighttime mile
v = .25 x 2 rate per rush hour mile
w = .25 x 1.5 rate per daylight hour mile (other than rush hour)

r = miles traveled at x rate
s = miles traveled at y rate
t = miles traveled at z rate

o = miles traveled at u rate
p = miles traveled at v rate
q = miles traveled at w rate

So, for miles traveled on URBAN streets during RUSH hour the per mile rate would be .25(.5 + 1) ??? BUT this is the same as the rate per URBAN mile so there is something wrong with my logic. I am trying to add both rates together but not double the mileage if you know what I mean.

I think we need to somehow integrate the r, s & t values with o, p and q values but not sure how to do this.