1 Chapter 9: Applying Excel 2 Data $16.50 q $6.25 q Revenue 4 Cost of ingredients Wages and salaries 5 $10,400 $800 $2,200 $600 6 $0.20 q Utilities 7 Rent $0.80 q 9 Miscellaneous 10 11 Actual results: 12 Revenue 13 Cost of ingredients 14 Wages and salaries $27,920 $11,110 $10,130 $1,080 $2,200 $2,240 15 Utilities 16 Rent 17 Miscellaneous 18 19 Planning budget activity 20 Actual activity 1,800 meals served 1,700 meals served 21 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 26 Revenue 27 and Activity Planning Budget Flexible 28 Actual Spending Results Variances 29 Variances Budget ? 30 Meals served ? 31 Revenue ? ? 32 Expenses: Cost of ingredients Wages and sa laries 33 ? ? ? 34 Utilities ? ? ? 35 36 Rent ? ? Miscellaneous 38 Total expenses 39 Net operating income ? 37 ? ? ? 40