A B C D E F G H I 1 Chapter 9: Applying Excel 3 Data 4 Revenue $16.50 q 5 Cost of ingredients $6.25 q 6 Wages and salaries $10,400 Utilities $800 $0.20 7 Rent $2.200 8 $600 $0.80 9 Miscellaneous 10 11 Actual results: 12 Revenue $27,920 $11,110 13 Cost of ingredients 14 Wages and salaries $10,130 $1,080 15 Utilities 16 Rent $2.200 $2,240 17 Miscellaneous 19 Planning budget activity 1,800 meals served 20 Actual activity 1,700 meals served 22 Enter a formula into each of the cells marked with a below 23 Review Problem: Variance Analysis Using a Flexible Budget 24 25 Construct a flexible budget performance report Revenue 26 27 Actual Spending Flexible Activity Planning 28 Budget variances Budget Results Variances 29 30 Meals served 31 Revenue 32 Expenses: ?I 33 Cost of ingredients ?I 34 Wages and salaries 35 Utilities 36 Rent 37 Miscellaneous 38 Total expenses 39 Net operating income 40