Help with pricing equation please

[wildkiwi]

Hi,

I am after help creating a dynamic formula to calculate my sell price on an item. I have the following variables
Market Rate (M) eg $100
Min Sell Rate (L) eg $90
Max Sell Rate (H) eg $110
Occupancy rate (O) can range from 1 to 100 as percentages
Target Occupancy Rate (T) eg 75%
Actual Sell Rate (A)

The theory goes that at T (75% occupancy) I will be charging market rate. If it drops then I will lower my price according to the percentage occupied and conversely increase my price above (T).

The issue I am having is that this is not a straight line calculation. I am guessing that this either uses parabolic, cubic or quadratic equations but I am truly not sure.

Some sample numbers using the above are
O A
0 90 (L)
75 (T) 100 (M)
100 110 (H)

I would love any help available please.

Thanks.

 

[stapel]

To create a modelling formula, one would need data points and modelling assumptions. A context would probably be helpful, too.

Please reply with the full and exact text of the exercise, the complete instructions, all provided data and underlying background information, and a listing of whatever methods have been recently covered in class. When you reply, please include a clear statement of all of your efforts and reasoning so far. Thank you!