Question: just need the excel forumals Review Problem: Variance Analysis Using a Flexible Budget Flexible Budget Performance Report For the Month Ended April 30 Revenue and

Review Problem: Variance Analysis Using a Flexible Budget Flexible Budget Performance Report For the Month Ended April 30 Revenue and (1) Spending (2) Activity (3) Actual Variances Flexible Variances Planning Results (1) (2) Budget (2) (3) Budget \begin{tabular}{|c|c|c|c|c|c|} \hline MealsservedRevenue($16.50q) & 1.700$27,920 & $130U & 1,700$28.050 & $1.650U & 1.800$29.700 \\ \hline \multicolumn{6}{|l|}{ Expenses: } \\ \hline Cost of ingredients ( $6.25q ) & 11.110 & 485U & 10.625 & 625F & 11.250 \\ \hline Wages and salaries ($10,400) & 10.130 & 270F & 10,400 & 0 & 10.400 \\ \hline Utilities ($800+$0.20q) & 1.080 & 60F & 1.140 & 20F & 1.160 \\ \hline Rent ($2.200) & 2.200 & 0 & 2.200 & 0 & 2.200 \\ \hline Miscellaneous ($600+$0.80q) & 2.240 & 280U & 1.960 & 80F & 2.040 \\ \hline Total expense & 26,760 & 435U & 26,325 & 725F & 27.050 \\ \hline Net operating income & $1.160 & $565U & $1.725 & S 925U & $2.650 \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
