1 Chapter 10: Applying Excel 3 Data 4 Revenue 16.50 q 5 Cost of ingredients 6 Wages and salanies 7 Utilities 8 Rent 9 Miscellaneous 10 11 Actual results 12 Revenue 13 Cost of ingredients 14 Wages and salaries 15 Utilities 16 Rent 17 Miscellaneous 18 56.25q 50.20 50.80 $10,400 5800t 52.200 5600 + $27,920 $11,110 $10,130 51,080 52,240 1,800 meals served 1,700 meals served 19 Planning budget actvity 20 Actual activity 21 22 Enter a formula into each of the cells marked wth a? below 23 Review Problem: Variance Analysis Using a Flexible Budget 24 25 Construct a flexible budget performance report 26 27 28 29 30 Meals served 31 Revenue 32 Exoenses 33 Cost of ingredients 4 Wages and salaries 35 Utilities 36 Rent 37 Miscellaneous 38 Total expenses 39 Net operating income 40 Revenue Planning Activity Budget Vaniances Flexible Spending Budget Variances Actual Filed in Chenter 10 Fnrm Chapter 10