Requirement $2$:Requirement $2$:

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

$\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,270,,,,],[13,$Cost of ingredients,$$,11,130,,,,],[14,$Wages and salaries,$$,10,575,,,,],[15,$Utilities,$$,1,150,,,,],[16,$Rent,$$,2,200,,,,],[17,$Miscellaneous,$$,2,000,,,,],[18],[19,$Planning budget activity,,$1,700,$meals served,,,$],[20,$Actual activity,,$1,800,$meals served,,,$]]$

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

$\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,270,,,,],[13,$Cost of ingredients,$$,11,130,,,,],[14,$Wages and salaries,$$,10,575,,,,],[15,$Utilities,$$,1,150,,,,],[16,$Rent,$$,2,200,,,,],[17,$Miscellaneous,$$,2,000,,,,],[18],[19,$Planning budget activity,,$1,700,$meals served,,,$],[20,$Actual activity,,$1,800,$meals served,,,$]]$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 ingredientsc. 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