$16.50 a $6.25 9 3 Data 4 Revenue 5 Cost of ingredients 6 Wages and salaries 7 Utilities 8 Rent 9 Miscellaneous + $0.20 9 $10,400 $800 $2,200 $600 + $0.80 9 10 11 Actual results: 12 Revenue 13 Cost of ingredients 14 Wages and salaries 15 Utilities 16 Rent 17 Miscellaneous $27,920 $11,110 $10,130 $1,080 $2,200 $2,240 18 19 Planning budget activity 1,800 meals served 20 Actual activity 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 CON 28 29 Flexible Activity Budget Vanances Planning Budget 2 ? ? 2 25 Construct a flexible budget performance report 26 Revenue 27 and Actual Spending Results Variances 30 Meals served ? 31 Revenue ? ? 32 Expenses 33 Cost of ingredients ? ? 34 Wages and salaries ? ? 35 Utilities ? 2 36 Rent ? ? 37 Miscellaneous ? ? 38 Total expenses ? ? 39 Net operating income ? ? 40 41 CON ? ? 2 2 2 ? ? ? ? 2 ? ? ? ? 2 ? 2 2 Isl.3 w lala