Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Forecasted Transient 14-Apr 15-Apr 16-Apr Total Forecasted Transient Rooms 0 Forecasted Transient Rate #DIV/0! Forecasted Transient Revenue (Rooms x Rate) $ - $ - $
Forecasted Transient | ||||
14-Apr | 15-Apr | 16-Apr | Total | |
Forecasted Transient Rooms | 0 | |||
Forecasted Transient Rate | #DIV/0! | |||
Forecasted Transient Revenue (Rooms x Rate) | $ - | $ - | $ - | #DIV/0! |
Variable cost per occupied room | $ 20.00 | $ 20.00 | $ 20.00 | $ 20.00 |
Franchise Fee per occupied room (rate *.08) | $ - | $ - | $ - | #DIV/0! |
Cost per occupied room (variable cost + franchise fee) | $ 20.00 | $ 20.00 | $ 20.00 | #DIV/0! |
Projected Transient Rooms Revenue (Revenue - costs) | $ - | $ - | $ - | #DIV/0! |
Forecasted Food & Beverage Revenue | ||||
Forecasted Breakfast (forecasted rooms * 70% * $8.40) | $ - | $ - | $ - | $ - |
Forecasted Lunch (forecasted rooms * 25% * 16.25) | $ - | $ - | $ - | $ - |
Forecasted Dinner (forecasted rooms * 40% * $30.60) | $ - | $ - | $ - | $ - |
Forecasted Revenue | $ - | $ - | $ - | $ - |
Total Projected Revenue | $ - | $ - | $ - | $ - |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started