Question: EX 1 2 - 3 0 ( Algo ) Performance Report; Hotel ( LO 1 2 - 3 ) The following data pertain to the

EX 12-30(Algo) Performance Report; Hotel (LO 12-3)
The following data pertain to the Waikiki Sands Hotel for the month of March.
Flexible Budget March (in thousands)*Footnote asteriskActual Results March (in thousands)*Footnote asteriskBanquets and Catering$ 750$ 778Restaurants2,0001,974Kitchen staff wages(125)(126)Food(790)(810)Paper products(185)(182)Variable overhead(115)(118)Fixed overhead(130)(153)
*Footnote asteriskNumbers without parentheses denote profit; numbers with parentheses denote expenses.
Required:
Based on Exhibit 124, prepare a March performance report. For the year-to-date columns in your report, use the data given in Exhibit 124. You will need to update those figures using the March data given above.
Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable. Select "None" and enter "0" for no effect (i.e., zero variance). Enter your answers in thousands. EX 12-30(Algo) Performance Report; Hotel (LO 12-3)
The following data pertain to the Waikiki Sands Hotel for the month of March.
\begin{tabular}{lcc}
& \begin{tabular}{c}
Flexible Budget March (in \\
thousands)*
\end{tabular} & \begin{tabular}{c}
Actual Results March \\
(in thousands)\(*\)
\end{tabular}\\
Banquets and Catering & \(\$ 750\) & \(\$ 778\)\\
Restaurants & 2,000 & 1,974\\
Kitchen staff wages & \((125)\) & \((126)\)\\
Food & \((790)\) & \((810)\)\\
Paper products & \((185)\) & \((182)\)\\
Variable overhead & \((115)\) & \((118)\)\\
Fixed overhead & \((130)\) & \((153)\)
\end{tabular}
*Numbers without parentheses denote profit; numbers with parentheses denote expenses.
Required:
Based on Exhibit 12-4, prepare a March performance report. For the year-to-date columns in your report, use the data given in Exhibit \(12-4\). You will need to update those figures using the March data given above.
Note: Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable. Select "None" and enter "O" for no effect (i.e., zero variance). Enter your answers in thousands.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|}
\hline \multicolumn{12}{|c|}{WAIKIKI SANDS HOTEL}\\
\hline \multicolumn{12}{|c|}{Performance Reports for March}\\
\hline \multicolumn{12}{|c|}{(In Thousands)}\\
\hline & \multicolumn{3}{|r|}{Flexible Budget} & \multicolumn{3}{|c|}{Actual Results} & & \multicolumn{4}{|c|}{Variance}\\
\hline & & & Year to Date & & & Year to Date & & March & & Year to & Date \\
\hline Food and Beverage Department & & & & & & & & & & & \\
\hline Banquets \& Catering & \$ & 750 & & \$ & 778 & & & & & & \\
\hline Restaurants & & & & & & & & & & & \\
\hline Kitchen & & & & & & & & & - & & \\
\hline Total profit & & & & & & & & & & & \\
\hline Kitchen & & & & & & & & & & & \\
\hline Kitchen staff wages & & & & & & & & & & & \\
\hline Food & & & & & & & & ( & & & \\
\hline Paper products & & & & & & & & & & & \\
\hline Variable overhead & & & & & & & & & & & \\
\hline Fixed overhead & & & & & & & & & & & \\
\hline Total expense & & & & & & & & , & & & \\
\hline
\end{tabular}
EX 1 2 - 3 0 ( Algo ) Performance Report; Hotel (

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!