Answered step by step
Verified Expert Solution
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
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
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