Maths aren't my thing...

Curtis71

Diplomatic To A Fault
Joined
Nov 7, 2001
Posts
2,093
So I need to figure out an algorithm.

If I visit two clients in a day, at different distances from my office, how do I best fairly divide up both the mileage and travel time for billing?

Client #1 is 46 miles out Hwy 6, client #2 is an additional 80 miles past client #1 but only 97 miles back to my office...

I charge for mileage and time both directions... Who should pay what?


Oh and since this a Literotica, I'm naked while I drive.
 
So I need to figure out an algorithm.

If I visit two clients in a day, at different distances from my office, how do I best fairly divide up both the mileage and travel time for billing?

Client #1 is 46 miles out Hwy 6, client #2 is an additional 80 miles past client #1 but only 97 miles back to my office...

I charge for mileage and time both directions... Who should pay what?


Oh and since this a Literotica, I'm naked while I drive.

You're a gigolo right?..
 
So I need to figure out an algorithm.

If I visit two clients in a day, at different distances from my office, how do I best fairly divide up both the mileage and travel time for billing?

Client #1 is 46 miles out Hwy 6, client #2 is an additional 80 miles past client #1 but only 97 miles back to my office...

I charge for mileage and time both directions... Who should pay what?


Oh and since this a Literotica, I'm naked while I drive.
Client 1 is charged for 92 miles and client 2 for 194 miles.

If you want to give them a discount because you can multitask their visits, that's up to you.
 
So I need to figure out an algorithm.

If I visit two clients in a day, at different distances from my office, how do I best fairly divide up both the mileage and travel time for billing?

Client #1 is 46 miles out Hwy 6, client #2 is an additional 80 miles past client #1 but only 97 miles back to my office...

I charge for mileage and time both directions... Who should pay what?


Oh and since this a Literotica, I'm naked while I drive.

a triangular equation bro!

Stew
 
Client 1 is charged for 92 miles and client 2 for 194 miles.

If you want to give them a discount because you can multitask their visits, that's up to you.

Yeah, I'm not a lawyer so I thought I'd give them the discount... Thus the "fair" bit. Just not sure how best to break that down....

Trying to charge for 223 miles...
 
Client 1 is charged for 92 miles and client 2 for 194 miles.

If you want to give them a discount because you can multitask their visits, that's up to you.

Yeah, I'm not a lawyer so I thought I'd give them the discount... Thus the "fair" bit. Just not sure how best to break that down....

Trying to charge for 223 miles...

How about this.

Since 92 is 47% of 194.

Multiply 223 by 47%.

Client #1 gets charged for 105 and the remainder goes to client #2
 
Charge Client 1 for the full round trip - 92 miles. You had no choice once you went to his house but to drive that distance.

Charge Client 2 for all additional miles - 131 - that was incurred over what you would have driven.
 
Charge Client 1 for the full round trip - 92 miles. You had no choice once you went to his house but to drive that distance.

Charge Client 2 for all additional miles - 131 - that was incurred over what you would have driven.

That's fair enough I suppose but I really would like to give both clients a break...

Sometimes I go on 3 day, 400- 500 mile road trips and see up to 10 clients... An equation for that would be really helpful...
 
Ok, if you want maths

Client A - billed 46 miles + 25 of shared leg = 71
Client B - billed 97 miles + 55 of Shared leg = 152

Remainder is 80 miles of which 32% was dedicated to Client A and 68% to Client B

46/(46+97) *80 = 25
 
Ok, I got this!

I was on the right track.


92/286= 32% (rounded down)

So 223*.32 = 71 (rounded down)

223-71 = 152

client #1 is charged for 71 miles
client #2 is charged for 152 miles
 
Ok, if you want maths

Client A - billed 46 miles + 25 of shared leg = 71
Client B - billed 97 miles + 55 of Shared leg = 152

Remainder is 80 miles of which 32% was dedicated to Client A and 68% to Client B

46/(46+97) *80 = 25

*high fives*
 
Ok, if you want maths

Client A - billed 46 miles + 25 of shared leg = 71
Client B - billed 97 miles + 55 of Shared leg = 152

Remainder is 80 miles of which 32% was dedicated to Client A and 68% to Client B

46/(46+97) *80 = 25

Ok, I got this!

I was on the right track.


92/286= 32% (rounded down)

So 223*.32 = 71 (rounded down)

223-71 = 152

client #1 is charged for 71 miles
client #2 is charged for 152 miles

*high fives*


Awesome... This is exactly what I was looking for.... Thanks to both of you!!
 
Optionally - you can go with:

(distance required if single client) (46 + 46) and (97 +97)

Minus Distance saved by joint trips (92+194)-223 = 63 miles

Times Percentage due each client (92/92+194)

Which would give you:

Client A pays for: 92 - 20 = 72 Miles
Client B pays for: 194 - 42 = 152 Miles


(which works for any number of clients)
 
Optionally - you can go with:

(distance required if single client) (46 + 46) and (97 +97)

Minus Distance saved by joint trips (92+194)-223 = 63 miles

Times Percentage due each client (92/92+194)

Which would give you:

Client A pays for: 92 - 20 = 72 Miles
Client B pays for: 194 - 42 = 152 Miles


(which works for any number of clients)

Now, if I could just punch all the addresses into Google and have it spit out mileage and time shares....
 
Optionally - you can go with:

(distance required if single client) (46 + 46) and (97 +97)

Minus Distance saved by joint trips (92+194)-223 = 63 miles

Times Percentage due each client (92/92+194)

Which would give you:

Client A pays for: 92 - 20 = 72 Miles
Client B pays for: 194 - 42 = 152 Miles


(which works for any number of clients)

Thank you again, I made an Excel sheet... Works for time as well...
 
Then once Client 2 decides not to use your services, you'll need to explain to Client 1 why his costs went up.

I always let them know that I reduced my charges by sharing travel time/expenses.

When I have a client in a town far away I encourage them to refer other clients to reduce their own expense. It works very well...
 
Back
Top