Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 1 - The Financial Pressure

Authors: Kate Mooney

2nd Edition

0071719237, 9780071719230

More Books

Students also viewed these Accounting questions