Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. applying excel data revenue 16.50 q cost of ingre

Applying Excel Data Revenue 16.50 q Cost of ingredients 6.25 q Wages and salaries...

80.2K

Verified Solution

Question

Accounting

Applying Excel

Data

Revenue 16.50 q Cost of ingredients 6.25 q Wages and salaries 10,400 Utilities 800 + 0.20 q Rent 2,200 Miscellaneous 600 + 0.80 q Actual results: Revenue 30,125 Cost of ingredients 11,215 Wages and salaries 10,495 Utilities 1,140 Rent 2,200 Miscellaneous 2,065 Planning budget activity 1,700 meals served Actual activity 1,800 meals served

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

b. 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 effect (i.e., zero variance)).

c. What is spending variance for wages and salaries? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

d. What is spending variance for total expenses? (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance)).

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Physics
1.2K views

My question is would this lab procedure be a valid method of calculating the coefficient of...

Electrical Engineering
1.2K views

Describe the conditions under which an op-amp circuit will oscillate. Provide a technique to avoid undesirable oscillation. Explain...

Electrical Engineering
1.2K views

A train runs between San Diego, and Kansas City, which is 4 km apart and maintains...

Physics
1.2K views

Three blocks A B and C are kept in a straight line on a frictionless...

Physics
1.2K views

0 A mass of 3 kg is placed on the massless piston of area 10...

Calculus
1.2K views

Question 2 of 10 1 point 2 3 Refer to the graph of the functic...

Accounting
1.2K views

Compute the following ratios for 2022. (Round asset turnover to 2...

Accounting
1.2K views

Consider the following statement: Unearned Revenue is a liability account. Do you agree or disagree...

Accounting
1.2K views

Almost all current liabilities affect the operating category of the statement of cash flows, but...

Accounting
1.2K views

Question 5 1 pts Which of the following steps should you take to replace a...

Finance
1.2K views

A 50- year project has a cost of $500,000 and has annual cash flows of...

Accounting
1.2K views

1. Classify each cost and its amount as (a) either variable or fixed and (b)...