Question

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 year

Must be solved in terms of formulas. PLZ help

Answer 1

Revenue and spending variance=Flexible budget-Actual results
For revenue and net operating income
If the answer is positive, variance is unfavorable.Otherwise favorable
For expenses,
If the answer is positive, variance is favorable.Otherwise unfavorable
Activity variance=Planning budget-Flexible budget
For revenue and net operating income
If the answer is positive, variance is unfavorable.Otherwise favorable
For expenses,
If the answer is positive, variance is favorable.Otherwise unfavorable
Activity variance for Revenue=$ 1600 Unfavorable
Planned meals served=1800
Actual meals served=1700
This 100 meals difference caused a decrease in expected revenue of $ 1600
Spending variance for the cost of ingredients=$ 60 U
Actual cost=$ 11110
Cost as per flexible budget=$ 11050
Here,actual cost is more than expected and it cause an unfavorable variance of $ 60