Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Must be solved in terms of formulas. PLZ help The Excel worksheet form that appears below is to be used to recreate the Review Problem
Must be solved in terms of formulas. PLZ help
The Excel worksheet form that appears below is to be used to recreate the Review Problem to Harrald's Fish House. Download the workbook containing this form from Connect, where 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 th a What is the activity variance for revenue? Explain this variance b. What is the spending variance for the cost of ingredients? Explain this variance 1 Chapter Applying Excel $16.50 5625 3 Data 4 Revenue 5 Cost of ingredients 6 Wages and salarios 7 Vice 8 Rent 9 Miscellaneous $10.400 $800 $2 200 5600 $0 204 50.800 11 Actus uts 12 Revenue 13 Cost of ingredients 14 Wages and salaries 15 Votes 16 Rent 17 Miscellaneous $27.920 $11,110 $10,130 $1.000 $2200 $2 240 13 Planning budget activity 20 Actual activity 1.800 meals served 1.700 meals served 22 Enter a formule into each of the calls moked with a do 23 Review Problem: Variance Analysis Using a Flexible Budget NANO Construct a fodble budget performance report e Act Actus Res Sending Ver 30 Meals served 31 Rweve 32 Expenses 33 Cost of ingredients 34 Wages and sales 35 Uits 36 Rent 37 Miscellaneous 08 Total expenses 39 Net Operating income Chapter Term i ne Store Chapter Fort 2. Revise the data in your worksheet to reflect the results for the following yearStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started