Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show how numbers were computed Chapter 9: Applying Excel Data Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous $16.50 q $10,400 $800

image text in transcribedimage text in transcribedimage text in transcribedplease show how numbers were computed

Chapter 9: Applying Excel Data Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous $16.50 q $10,400 $800 $2,200 $600 $6.25 q $0.20 q $0.80 Actual results Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous $27,920 $11,110 $10,130 $1,080 $2,200 $2,240 Planning budget activity Actual activi 1,800 meals served 1,700 meals served 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 Revenue and Actual Spending Results Variances FlexibleActivity BudgetVariances Planning Budget Meals served Revenue Expenses Cost of ingredients Wages and salaries Utilities Rent Miscellaneous Total expenses Net operating income Chapter 9: Applying Excel Data Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous $16.50 q $10,400 $800 $2,200 $600 $6.25 q $0.20 q $0.80 Actual results Revenue Cost of ingredients Wages and salaries Utilities Rent Miscellaneous $27,920 $11,110 $10,130 $1,080 $2,200 $2,240 Planning budget activity Actual activi 1,800 meals served 1,700 meals served 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 Revenue and Actual Spending Results Variances FlexibleActivity BudgetVariances Planning Budget Meals served Revenue Expenses Cost of ingredients Wages and salaries Utilities Rent Miscellaneous Total expenses Net operating income

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

Aat Management Accounting Budgeting

Authors: BPP Learning Media

1st Edition

1509718400, 978-1509718405

More Books

Students also viewed these Accounting questions