Question: PLEASE HELP! Also, please include formulas with it if possible X E5 A B 1 Chapter 9: Applying Excel 2 3 Data 4 Revenue 5

X E5 A B 1 Chapter 9: Applying Excel 2 3 Data 4 Revenue 5 Cost of ingredients $10,400 6 Wages and salaries 7 Utilities $800 8 Rent $2,200 $600 9 Miscellaneous 10 11 Actual results: 12 Revenue $27,920 13 Cost of ingredients $11,110 14 Wages and salaries 15 Utilities $10,130 $1,080 16 Rent $2,200 17 Miscellaneous $2,240 18 19 Planning budget activity 20 Actual activity 1,800 meals served 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 SE fix q C + + D $16.50 q $6.25 q $0.20 q $0.80 q LU E A B C 9 Planning budget activity 1,800 meals served 1,700 meals served 0 Actual activity 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 and 27 28 Spending Actual Results Variances 29 30 Meals served 1,700 31 Revenue $27,920 $ 130 U 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 COPEC ? ? ? ? ? D E F Flexible Activity Budget Variances 1,700 $28,050 $1,650 U ? ? 77777777 ? ? ? ? ? LL ? 2222 ? ? ? ? ? ? G H Planning Budget 1,800 $29,700
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
