invoicing rental car based on daily weekly monthly

[curious99]

Hi all

I checked on prior posts by other members but subject appears not to have been covered in the past.

We run a rent-a-car operation and I'm trying to find a way to bill the customers using our pricing menu. We have daily, weekly (discounted rate compared to the daily rate) and monthly rates (discounted rate compared to the weekly rate). If someone has used the vehicle for 26 days, which calc should I use to get the rate to be 3 weeks and 5 days and get the total amount that is owed to us by the customer?

thanks in advance for your help on this subject

Luc

[Vaughan]

Interesting challenge!

When you say "monthly rate" what exactly do you mean? Let me explain...

I rent a car from 1 Feb to 28 Feb inclusive... do I get the monthly rate? If I book a car from 1 Jan to 28 Jan is that a month? Both are 28 days. Do I also get the monthly rate?

You can see some issues coming up here, and the need to clearly explain to customers what's happening. (And it's got nothing to do with FMP.)

Platform: / Version:

FileMaker Version: