PLEASE SHOW ME THE EXCEL STEPS .. SO I CAN DO IT IN THE EXCEL FILE .... THANKS IN ADVANCE

F G . 1 + A B D E 1 Chapter 9: Applying Excel 2 3 Data 4 Revenue $16.50 a 5 Cost of ingredients $6.25 a 6 Wages and salaries $10,400 7 Utilities $800 $0.20 a 8 Rent $2,200 9 Miscellaneous $600 $0.80 g 10 11 Actual results: 12 Revenue $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 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 28 Actual Spending Flexible 29 Results Variances Budget 30 Meals served ? ? 31 Revenue ? ? ? 32 Expenses: 33 Cost of ingredients ? ? ? 34 Wages and salaries ? ? ? 35 Utilities ? ? ? 36 Rent ? ? ? 37 Miscellaneous ? ? ? Activity Variances Planning Budget ? ? ? ? ? ? ? ? ? ? ? ? ? 20 Tuale ... D E F G I J A B 17 Miscellaneous $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 24 25 Construct a flexible budget performance report 26 Revenue 27 and 28 Actual Spending 29 Results Variances 30 Meals served ? 31 Revenue ? ? 32 Expenses: 33 Cost of ingredients ? ? 34 Wages and salaries ? ? 35 Utilities ? ? 36 Rent ? ? 37 Miscellaneous ? ? 38 Total expenses ? ? 39 Net operating income ? ? 40 41 Activity Variances Flexible Budget ? ? Planning Budget ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 1