OCCUPANCY and TURNOVER

[Sandy Dan]

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

 

[Ted M H]

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]

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

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.

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

 

[Ted M H]

Hi Sandy Dan,
Sounds like an interesting business in an interesting place! I'm still
unclear on what the problem is. A few questions:
- What's the data you get look like? Is it a list of transactions?
Something like this:
A B C D
1 Space ID Time in Time out Amt Paid
2 0001 09:00 10:00 $ 0.95
3 0001 10:01 11:00 $ 1.00
4 0002 08:00 11:00 $ 4.00
- If not, what's the data look like?
- What do you want as the actual end result? Is it a single number for all
spaces for a day? Or is it for a space or group of spaces? Is it a report
of some sort? If so, what's it look like?
- What does it mean when you say the model will allow you to alter the
occupancy rate as a % against 100 %?
- What data do you have from which you think you could derive the parking
movements per hour? It sounds like you'd be counting something, but what?
- Have you already worked out the model in your head and what you need is
help building the model in Excel, or are you really asking for help to design
the model in the first place? If the former, show us the model in detail.
If the latter, not sure I can help you….

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

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.

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