I would like an excel solution to the managerial accounting 15th edition chapter 9:applying excel. Thank you!

!!! Chapter 9. Problem 1AE Bookmark Show all steps: ON The Excel worksheet form that appears on the next page is to be used to recreate the Review Problem on pages 431-432. Download the workbook containing this form from the Online Learning Center at www.mhhe.comoreen3e . On the website you will also receive instructions about how to use this worksheet form. You should proceed to the requirements below only after completing your worksheet. Required: 1. Check your worksheet by changing the revenue in cell 04 to $16.00; the cost of ingredients in cell D5 to $6.50; and the wages and salaries in cell B6 to $10,000. The activity variance for net operating income should now be $850 U and the spending variance for total expenses should be $410 U. If you do not get these answers, find the errors in your worksheet and correct them. a. What is the activity variance for revenue? Explain this variance. 6. What is the spending variance for the cost of ingredients? Explain this variance. F G H 1 + + 50 80 B 1 Chapter 10: Applying Excel 2 3 Data 4 Revenue $16.50 5 Cost of ingredients 5625 6 Wages and salaries $10.400 7 Utilities $800 50 20 8 Rent 52.200 9 Miscellaneous 5600 10 11 Actual results 12 Revenue $27,920 13 Cost of ingredients 511,110 14 Wagos and calanes 510, 130 15 Utilities 51,080 16 Rent 52,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 Probleme Variance Analysis Using a Flexible Budget 24 25 Construct a flexible budget performance report 20 27 28 Planning Activity 29 Budget Variances 30 Meals served ? 31 Revenue ? ? 32 Expenses 33 Cost of ingredients ? 2 34 Wages and salaries ? 7 35 Utilities 7 2 36 Rent 37 Miscellaneous ? ? 38 Total expenses ? 39 Net Operating income ? 40 Chapter 10 Form Tiled incom Com Revenue and Flexible Spending Budget Variances ? ? ? Actual Results ? ? ? 7 ? ? 7 ? ? ? ? 2 ? ? ? ? 7 ? ? 2 ? ? ? JA ? 2