C D E F G H K 1 Chapter 9: Applying Excel + Data Revenue $16.509 5 Cost of ingredients $6.259 6 Wages and salaries $10,400 7 Utilities $800 $0.20 8 Rent $2,200 9 Miscellaneous $600 50.80 10 11 Actual results 12 Rovenue $27.920 13 Cost of ingredients $11,110 14 Wages and salaries $10.130 15 Utilities $1.080 16 Rent $2,200 17 Miscellaneous $2,240 18 19 Planning budget activity 1,800 meals served 20 Actual activity 1.700 meals served 21 22 Enfera formula into each of the colls 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 28 Actual Spending Flexible 29 Rosults Vartances Budget 30 Meals served 7 2 31 Revenue ? 7 2 32 Expenses 33 Cost of ingredients ? ? 7 34 Wagou and salaries 2 2 ? 35 Utilo 2 ? 2 36 Rent 7 2 2 37 Miscellaneous 2 ? ? 38 Total expenses 2 ? 2 39 Not operating Income 2 40 Activity Varianco Planning Budget 2 2 2 2 2 2 2 2 2 7 ? 3 2 ? 2