Question: need formulas for exact locations in the excel worksheet D G H $6.25 a + A B E F 1 Chapter 9: Applying Excel 2

need formulas for exact locations in the excel worksheet  need formulas for exact locations in the excel worksheet D G
H $6.25 a + A B E F 1 Chapter 9: Applying

D G H $6.25 a + A B E F 1 Chapter 9: Applying Excel 2 3 Data 4 Revenue $16.50 9 5 Cost of ingredients 6. Wages and salaries $10,400 7 Utilities $800 $0.20 9 8 Rent $2,200 9 Miscellaneous $600 + $0.80 9 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 2 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 Activity 29 Results Variances Budget Variances 30 Meals served 2 ? 2 2 2 2 31 Revenue 32 Evnenca Planning Budget 2 2 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 ? 2 34 Wages and salaries ? ? 35 Utilities ? ? 36 Rent ? ? 37 Miscellaneous 2 ? 38 Total expenses ? ? 7 ? 39 Net operating income 40 Flexible Activity Budget Variances ? ? 2 Planning Budget 2 2 2 ? ? 2 2 2 ? 2 2 ? 2 ? ? ? ? 2 2 ? 2 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!