1. What is the activity variance for the revenue? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect)  2. What is the spending variance for the cost of ingredients? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effec

Quickbooks Online Accounting
3rd Edition
ISBN:9780357391693
Author:Owen
Publisher:Owen
Chapter4: Operating Activities: Sales And Cash Receipts
Section: Chapter Questions
Problem 1.5C
icon
Related questions
Topic Video
Question

1. What is the activity variance for the revenue? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect) 

2. What is the spending variance for the cost of ingredients? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effec 

!
Required information
11
Actual results:
12 Revenue
$
30,250
13 Cost of ingredients
11,155
14 Wages and salaries
10,325
15 Utilities
1,115
16 Rent
2,200
17 Miscellaneous
$4
2,030
18
19 Planning budget activity
1,700 meals served
20
Actual activity
1,800 meals served
g "EI for fo vorn
%24
%24
%24
%24
%24
%24
Transcribed Image Text:! Required information 11 Actual results: 12 Revenue $ 30,250 13 Cost of ingredients 11,155 14 Wages and salaries 10,325 15 Utilities 1,115 16 Rent 2,200 17 Miscellaneous $4 2,030 18 19 Planning budget activity 1,700 meals served 20 Actual activity 1,800 meals served g "EI for fo vorn %24 %24 %24 %24 %24 %24
ved
Help
Chapter 9: Applying Excel: Exercise (Part 2 of 2) (Algo)
Requirement 2:
Revise the data in your worksheet to reflect the results for the subsequent period as shown below:
A
Chapter 9: Applying Excel
2.
Data
Revenue
16.50 q
Cost of ingredients
6.25 q
6.
6 Wages and salaries
10,400
Utilities
800
0.20 q
8.
Rent
2,200
6.
Miscellaneous
600
0.80 q
10
11
Actual results:
12 Revenue
30.250
< Prev
2.
of 2
Next>
....w. ..
* 事 NN..
%24
%24
%24
%24
%24
%24
%24
%24
%24
1.
3.
4.
Transcribed Image Text:ved Help Chapter 9: Applying Excel: Exercise (Part 2 of 2) (Algo) Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period as shown below: A Chapter 9: Applying Excel 2. Data Revenue 16.50 q Cost of ingredients 6.25 q 6. 6 Wages and salaries 10,400 Utilities 800 0.20 q 8. Rent 2,200 6. Miscellaneous 600 0.80 q 10 11 Actual results: 12 Revenue 30.250 < Prev 2. of 2 Next> ....w. .. * 事 NN.. %24 %24 %24 %24 %24 %24 %24 %24 %24 1. 3. 4.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Performance measurements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Accounting Information Systems
Accounting Information Systems
Finance
ISBN:
9781337552127
Author:
Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:
Cengage Learning
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning