Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 year

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting And Reporting

Authors: Barry Elliott, Jamie Elliott

19th Edition

1292255994, 9781292255996

More Books

Students also viewed these Accounting questions

Question

=+7. Compare Walmarts new and old logos:

Answered: 1 week ago

Question

=+1. Why is it important to view CSR from a strategic context?

Answered: 1 week ago