Hi Ted
Thanks for the notification and sorry for the VERY long delay.
I am in the parking industry and I am trying to create the right formula
that predicts overall revenue earned at the end of the day per space (I rent
5000 spaces from the municipality) which has peaks and troughs as shops open
and close. Here in Saudi Arabia the shops are open 8-12, close 12-4 and open
again 6-11; not like Europe or the States.
So what am I trying to do? If one space is paid for 2 hours then $2 paid -
straight forward. But most spaces turnover unevenly. So, paid for 2 hours
left after 90 minutes, new parker and pays for 1 hour. So in 2 hours
predicted income $2 but actual = $3 due to OCCUPANCY or TURNOVER of spaces.
The model I am trying to achieve will allow me to alter the occupancy rate
as a % against 100% + or -, AND show as an integer the number of 'parking
movements' per hour per space.
As I said there are 3 constants: number of spaces, tariff per hour (set by
the municipality) and the 10 operating hours in the day.
I hope that this is enough for you to help. I hope you get this reply!
Thanks
--
Dan
Ted M H said:
I for one don't get the idea. I'd be willing to try to help you if you'd
take a minute and explain more clearly what the problem is. Assume I know
nothing about your particular industry.
Sandy Dan said:
I have 2 variables occupancy and turnover; I have 3 'absolutes' tariff ,
spaces and 10 operating hours per day.
The tariff is set at$1,1,2,2,1,1,2,2,2,2 for each operating hour in the day.
I need a formula to manipulate the data to show revenue generated per space
during the day. So:
09:00-10:00. $1. 95%(occ). 0%(t/o) Revenue = 95c
10:00-11:00. $1. 95% . 45%. Revenue = $2.35 [progressive]
The math is wrong but you get the idea
Thanks