Chapter 9: Applying Excel Data $16.50 q Revenue q $6.25 Cost of ingredients $10,400 Wages and salaries Utilities $800 $0.20 q Rent $2.2000 $600 $0.80 q Miscellaneous Actual results: $27,920 Revenue $11,110 Cost of ingredients $10,130 Wages and salaries Utilities $1,080 Rent $2.2000 $2.240 Miscellaneous 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 Budget variances Results Variances Meals served Revenue Expenses: Cost of ingredients Wages and salaries Utilities Rent Miscellaneous Total expenses Net operating income Plannin Budget