Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please fill out the yellow cells based on the data begin{tabular}{|c|c|c|c|c|c|c|c|c|} hline multirow{5}{*}{begin{tabular}{l} Hotel Capacity: Group Name: Arrival: Day of Week

image text in transcribed

please fill out the yellow cells based on the data

\begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline \multirow{5}{*}{\begin{tabular}{l} Hotel Capacity: \\ Group Name: \\ Arrival: \\ Day of Week \\ Date \end{tabular}} & \multicolumn{5}{|c|}{400} & \multirow{5}{*}{\begin{tabular}{c} FRI \\ 5/13/21 \\ \end{tabular}} & \multirow{5}{*}{\begin{tabular}{c} SAT \\ 5/14/21 \end{tabular}} & \\ \hline & \multicolumn{5}{|c|}{ "New Group" } & & & \\ \hline & 5/9/21 & & & & & & & \\ \hline & SUN & MON & TUE & WED & THU & & & \\ \hline & 5/8/21 & 5/9/21 & 5/10/21 & 5/11/21 & 5/12/21 & & & \\ \hline Forecasted Transient Demand & 150 & 325 & 325 & 325 & 250 & 280 & 350 & \\ \hline \begin{tabular}{l} Forecasted Group Definites \\ (or including already confirmed in the books) \end{tabular} & 50 & 75 & 75 & 75 & 50 & 50 & 50 & \\ \hline Total Demand & 200 & 400 & 400 & 400 & 300 & 330 & 400 & \\ \hline New Group Opportunity Room Nights & & & & & & & & 0 \\ \hline Total Demand considering the new Group & 200 & 400 & 400 & 400 & 300 & 330 & 400 & \\ \hline Estimated Room night Displacement & & & & & & & & 0 \\ \hline New Catering Revenue with the new Group & & & & & & & & $0 \\ \hline Summary: & Rooms & ADR & Revenue & Profit \% & Profit & & & \\ \hline New Group: & 0 & & $0 & 75% & $0 & & & \\ \hline Displaced Transient & 0 & & $0 & 75% & $0 & & & \\ \hline Rooms Profit & & & & & $ & & & \\ \hline Ancillary Revenue & Rooms & \begin{tabular}{l} Revenue \\ p/room \end{tabular} & Revenue & & & & & \\ \hline Transients Average Ancillary Revenue & & & $ & & & & & \\ \hline New Group F\&B & & & $0 & & $0 & & & \\ \hline Meeting Room Rental & & & & 90% & & & & \\ \hline Total Group Profit & & & & & $ & & & \\ \hline \end{tabular}

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

Forensic And Investigative Accounting

Authors: D. Larry Crumbley, Lester E. Heitger, G. Stevenson Smith

7th Edition

0808040731, 9780808040736

More Books

Students also viewed these Accounting questions

Question

Define self-esteem and discuss its impact on your life.

Answered: 1 week ago

Question

Discuss how selfesteem is developed.

Answered: 1 week ago