Chapter $9$: Applying Excel

Data

Revenue $$16\mathrm{.}50$ q

Cost of ingredients $$6\mathrm{.}25$ q

Wages and salaries $$10,400$

Utilities $$800+$ $$0\mathrm{.}20$ q

Rent $$2,200$

Miscellaneous $$600+$ $$0\mathrm{.}80$ q

Actual results:

Revenue $$27,920$

Cost of ingredients $$11,110$

Wages and salaries $$10,130$

Utilities $$1,080$

Rent $$2,200$

Miscellaneous $$2,240$

Planning budget activity $1,800$ meals served

Actual activity $1,700$ meals served

Enter a formula into each of the cells marked with a $?$ below

Review Problem: Variance Analysis Using a Flexible Budget

Construct a flexible budget performance report

Revenue

and

Actual Spending Flexible Activity Planning

Results Variances Budget Variances Budget

Meals served $???$

Revenue $?????$

Expenses:

Cost of ingredients $?????$

Wages and salaries $?????$

Utilities $?????$

Rent $?????$

Miscellaneous $?????$

Total expenses $?????$

Net operating income $?????$