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,,,$5,,.,,],[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,11,,,,],[9,$Miscellaneous,$$,600,+,$$$,0\mathrm{.}80,$q$,],[10],[11,$Actual results:,,,,,,,s$],[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,,,,$]]$

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 wagas and salarics

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 amaunt of the spanding variance far total expenses

Note: Indicate the effect of each variate:

variance$).$

The amount of the activity variance for reverue

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 ameurit of the spending variance far the cost af ingredients