Results 1 to 1 of 1

Math Help - Expenential Equation

  1. #1
    Dec 2008

    Expenential Equation

    I am really stuck! I believe there is an answer to my problem, it is just beyond me.

    I have vacation rental property. I normally do the price quotes for potential guests by hand. I would like to automate this process with a web-based application, but I can not figure out the formula for the discount that I apply to extended stay. I have a fixed daily rate for various property units, but I need a formula to determine the discount rate applied to the total of the sum of the daily rate.

    These are the factors I need to recognize;
    1) 0 - 5 days stay, there is no discount applied.
    2) 6 day stay, has a fixed discount (currently $200).
    3) 7 - 14 day stay has a $75 per day discount. ( 5 day = $525 OFF)

    Here is where it gets tricky. 14 - 31 days, has a sliding scale discount rate.
    - The more days stay, allow for a greater per day discount.
    - I would indicate a predetermined minimum and maximum rate for the 15 - 31 day stay respectively.
    - The new average daily rate would then exponential decrease. Consequentially, the calculated discount rate would exponential increase daily.
    - This formula should incorporate the prior days discount rate, and increase it by another pre-determined fixed rate (let's call it "Y"). Staying within the Maximum 31 day rate.
    - I am open to the any variable "Y" figure that the discount and/or avg.-daily rate would increase/decrease by. This "Y" figure I would be able to play with to adjust the increasing discount distribution.

    I put together this following webpage to chart the example of what I am looking to accomplish;
    Discount Formula

    Please note that on day 15 and 31, the discount applied to the Sub-Total would reflect the pre-determined the minimum and maximum value. It is the yellow highlighted area in between that I need a formula to calculate.

    Well, I tried to be as descriptive as possible. If I was not clear about something in particular, please feel free to contract me.
    Any assistance would be so greatly appreciated

    Best Regards-

    Last edited by mr fantastic; February 6th 2009 at 08:56 PM. Reason: Deleted link to commercial website
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 1
    Last Post: April 11th 2011, 02:17 AM
  2. Partial differential equation-wave equation - dimensional analysis
    Posted in the Differential Equations Forum
    Replies: 3
    Last Post: August 28th 2009, 12:39 PM
  3. Replies: 2
    Last Post: May 18th 2009, 01:51 PM
  4. Replies: 2
    Last Post: April 28th 2009, 07:42 AM
  5. Replies: 1
    Last Post: October 23rd 2008, 04:39 AM

Search Tags

/mathhelpforum @mathhelpforum