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

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

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

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!