D Bu Chapter_9_Applying_Excel_Student_For... Qu Search Sheet Home + Share Insert Formulas Page Layout X A. % Data Review View Conditional Formatting Format as Table Cells Cell Styles Paste Font Alignment Number Editing 16 & fx B D E F G H 1 J Chapter 9: Applying Excel $16.00 $6.50 9 $0.20 9 + $0.80 9 Data Revenue Cost of ingredients Wages and salaries $10,000 Utilities $800 + Rent $2,200 Miscellaneous $600 0 1 Actual results 2 Revenue $27,920 3 Cost of ingredients $11,110 4 Wages and salaries $10,130 5 Uuties $1,080 6 Rent $2,200 7 Miscellaneous $2,240 B 9 Planning budget activity 1,800 meals served 0 Actual activity 1,700 meals served 21 22 Enter a formule into each of the cells marked with a ? below 23 Review Problem: Variance Analysis Using a Flexible Budget Revenue and Spending Variances Flexible Budget 2 ? Actity Variances Planning Budget 7 7 ? 7. 25 Construct a flexible budget performance report 26 27 28 Actual 29 Results ? 30 Meals served 31 Revenue ? 32 Expenses: Cost of ingredients ? 34 Wages and salaries 2 35 Utilities ? 36 Rent 2 37 Miscellaneous ? 38 Total expenses ? 39 Net operating income ? 40 41 42 ? ? ? ? ? ? ? ? ? ? 2 2 7 ? ? ? ? ? ? 7 7 2 2 ? 2 7 ? 7 45 46 47 49 50 51 Chapter 9 Form + + 100% Ready