n Chapter 9: Applying Excel Data Revenue Cost of ingredients $16.50 $6.25 Wages and salaries $10,400 Utilities $800 + $0.20 Rent $2,200 Miscellaneous $600 + $0.80 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 Results Variances Meals served ? Revenue ? ? Expenses: Cost of ingredients ? Wages and salaries ? 22 ? ? Utilities ? Rent ? 22 ? ? Miscellaneous ? Total expenses ? Net operating income ? 227 ? ? ? Chapter 9 Form +