revised the data in your worksheet to reflect the results for the subsequent period as shown below:

Required information

$\backslash$table$[[,$A$,,$B$,$C$,$D$,$E$],[1,$Chapter $9$: Applying Excel,,,,,$],[2,,,,,,],[3,$Data,,,,,$],[4,$Revenue,,,,$ $16\mathrm{.}50,$q$],[5,$Cost of ingredients,,,,$ $6\mathrm{.}25,$q$],[6,$Wages and salaries,,$ $10,400,,,],[7,$Utilities,,$ $800,+,$$ $0\mathrm{.}20,$q$],[8,$Rent,,$ $2,200,,,],[9,$Miscellaneous,,$ $600,+,$$ $0\mathrm{.}80,$q$],[10,,,,,,],[11,$Actual results:,,,,,$],[12,$Revenue,,$ $30,235,,,],[13,$Cost of ingredients,,$ $11,075,,,],[14,$Wages and salaries,,$ $10,615,,,],[15,$Utilities,,$ $1,140,,,],[16,$Rent,,$ $2,200,,,],[17,$Miscellaneous,,$ $2,055,,,],[18,,,,,,],[19,$Planning budget activity,,$1,700,$meals served,,$],[20,$Actual activity,,$1,800,$meals served,,$]]$

$1$ of $1$

a$.$ What is the activity variance for revenue?

Note: Indicate the effect of each variance by selecting $"$F$"$ for favorable, $"$U$"$ for unfavorable, and "None" for no effect $($i$.$e$.,$ zero variance$).$

The amount of the activity variance for revenue

b$.$ What is the spending variance for the cost of ingredients?

Note: Indicate the effect of each variance by selecting $"$F$"$ for favorable, $"$U$"$ for unfavorable, and "None" for no effect $($i$.$e$.,$ zero variance$).$

The amount of the spending variance for the cost of ingredients

c$.$ What is spending variance for wages and salaries?

Note: Indicate the effect of each variance by selecting $"$F$"$ for favorable, $"$U$"$ for unfavorable, and "None" for no effect $($i$.$e$.,$ zero variance$).$

The amount of the spending variance for wages and salaries

d$.$ What is spending variance for total expenses?

Note: Indicate the effect of each variance by selecting $"$F$"$ for favorable, $"$U$"$ for unfavorable, and "None" for no effect $($i$.$e$.,$ zero variance$).$

The amount of the spending variance for total expenses

Chapter $9$: Applying ExcelDataRevenueCost of ingredientsWages and salariesUtilitiesRentMiscellaneousActual results:RevenueCost of ingredientsWages and salariesUtilitiesRentMiscellaneousPlanning budget activityActual activityMeals servedRevenueExpenses:Cost of ingredientsWages and salariesUtilitiesRentMiscellaneous$$10,400$$$800$Total expenses$$2,200$$$600$Net operating income$$27,920$Enter a formula into each of the cells marked with a $?$ belowReview Problem: Variance Analysis Using a Flexible Budget$$11,110$Construct a flexible budget performance report$$10,130$$$1,080$$$2,200$$$2,2401,800$ meals served$1\mathrm{.}700$ meals servedActualResults?RevenueandSpendingVariances???$$16\mathrm{.}50$ q$$6\mathrm{.}254$$$0\mathrm{.}20$ qS$0\mathrm{.}804$FlexibleBudget??$2???$ActivityVariances???PlanningBudget?