Chapter 9: Applying Excel Data Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous Actual results: Revenue Cost of ingredients Wages and salaries Utilities Rent Meals served Revenue Expenses: Cost of ingredients Wages and salaries Utilities Rent $10,400 $800 $2,200 $600 Miscellaneous Planning budget activity Actual activity Enter a formula into each of the cells marked with a ? below Review Problem: Variance Analysis Using a Flexible Budget Construct a flexible budget performance report Miscellaneous Total expenses Net operating income $27,920 $11,110 $10,130 $1,080 $2,200 $2,240 1,800 meals served 1,700 meals served Actual Results ? ? ? ? ? ? ? ? ? Revenue and Spending Variances ? ? ? ? ? ? ? ? $16.50 q $6.25 q $0.20 q $0.80 q Flexible Activity Budget Variances ? ? ? ? ? ? ? ? ?| ? ? ? ? ? ? ? Planning Budget ? ? ? ? ? ? ?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
Filling in the blanks where “?” Is
Chapter 9: Applying Excel
Data
Revenue
Cost of ingredients
Wages and salaries
Utilities
Rent
Miscellaneous
Actual results:
Revenue
Cost of ingredients
Wages and salaries
Utilities
Rent
Meals served
Revenue
Expenses:
Cost of ingredients
Miscellaneous
Planning budget activity
Actual activity
Enter a formula into each of the cells marked with a ? below
Review Problem: Variance Analysis Using a Flexible Budget
Construct a flexible budget performance report
Wages and salaries
Utilities
Rent
$10,400
$800
$2,200
$600
Miscellaneous
Total expenses
Net operating income
$27,920
$11,110
$10,130
$1,080
$2,200
$2,240
1,800 meals served
1,700 meals served
Actual
Results
?
?|
?
?
?
?
? |
?
Revenue
and
Spending
Variances
?
?
?
?
?
?
?
?
$16.50 q
$6.25 q
$0.20 q
$0.80 q
Flexible Activity
Budget
Variances
?
?|
?
?
?
?
?
?
?
?
?
?
?
?
?
Planning
Budget
?
?
?
?
?
?
?
Transcribed Image Text:Chapter 9: Applying Excel Data Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous Actual results: Revenue Cost of ingredients Wages and salaries Utilities Rent Meals served Revenue Expenses: Cost of ingredients Miscellaneous Planning budget activity Actual activity Enter a formula into each of the cells marked with a ? below Review Problem: Variance Analysis Using a Flexible Budget Construct a flexible budget performance report Wages and salaries Utilities Rent $10,400 $800 $2,200 $600 Miscellaneous Total expenses Net operating income $27,920 $11,110 $10,130 $1,080 $2,200 $2,240 1,800 meals served 1,700 meals served Actual Results ? ?| ? ? ? ? ? | ? Revenue and Spending Variances ? ? ? ? ? ? ? ? $16.50 q $6.25 q $0.20 q $0.80 q Flexible Activity Budget Variances ? ?| ? ? ? ? ? ? ? ? ? ? ? ? ? Planning Budget ? ? ? ? ? ? ?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
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.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education