Thread: Reverse Engineering Hotel Industry Ratios

Hello Everyone. This is a problem that has been bothering me for a while and I'm hoping that there is a math instructor out there with a quick answer.

Heres the dilemma,

In the hotel industry there are 3 ratios that are used to measure performance.

Revenue per Available Room (R)
Occupancy (O)
and Average Daily Rate (A)

R = Revenue/Available Rooms
O = Sold Rooms/Available Rooms
A = Revenue/Sold Rooms

If I know all three of these ratios for a property, is there a way to multiply, divide, or tease these ratios out so that I can isolate the components, such as Revenue? I've tried to approach this but with no luck. At this point I'm more interested in IF it can be done and if so how than anything.

History: Me educated up through Calc 3

Originally Posted by Dingus

Hello Everyone. This is a problem that has been bothering me for a while and I'm hoping that there is a math instructor out there with a quick answer.

Heres the dilemma,

In the hotel industry there are 3 ratios that are used to measure performance.

Revenue per Available Room (R)
Occupancy (O)
and Average Daily Rate (A)

R = Revenue/Available Rooms
O = Sold Rooms/Available Rooms
A = Revenue/Sold Rooms

If I know all three of these ratios for a property, is there a way to multiply, divide, or tease these ratios out so that I can isolate the components, such as Revenue? I've tried to approach this but with no luck. At this point I'm more interested in IF it can be done and if so how than anything.

History: Me educated up through Calc 3

You need to know either sold or available rooms to solve for revenue.

Originally Posted by dwsmith

to know either sold or available rooms to solve for revenue.

Thanks DW, I know that much. Looking or a solution that doesn't require any of these pieces of information.

-D.

Originally Posted by Dingus

Thanks DW, I know that much. Looking or a solution that doesn't require any of these pieces of information.

-D.

Unfortunately, you are going to need more information.