Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Im stuck on this excel problem. is there any chance someone can give me the formulas to enter for the boxes with question marks so

Im stuck on this excel problem. is there any chance someone can give me the formulas to enter for the boxes with question marks so I know how to enter it in excel. thanks!!!
image text in transcribed
image text in transcribed
i uploaded a couple more clear images
image text in transcribed
image text in transcribed
A ven E F G 1 L M N O $0.109 Al Chapter 9: Applying Excel D D 1 Chapter Applying Excel 2 Revenue $10.50 4 Cost of ingredients 5625 5. Wages and salaries $10,400 G Us $600 . 30 20 7 Renk $2.200 Mecellaneous 5000 9 10 Arturo 31 Reverso $27,020 12 Coat of ingredients $11.110 11 Wages and swartes $10,130 14 Uits $1,080 15 Rent 52,200 16 Miscellaneous 52.240 17 18 Parning budget activity 1,800 meals served 15 Acuni activity 1.700 moals served 20 21 32 Enter a forma into each of the cele marked with a below 23 Review Protlen Variance Analysis Using a Flexible Budget 25 Corbruct a budget performance report 26 Revenge and 2 Actual Spending Result Variances 30 Muis served Flexible Activity Budget Wwws Planning Budger 7 Chapter 9 Form + CA Warto tutto E E F G H T K L M N O A11 Revenue 3 D IL Revenue $27.920 12 Costa Ingredients $11,110 13 Wages and salaries $10,130 14 Ulices $1,080 15 Rent $2.200 16 Miscellaneous $2.240 12 18 Planning budget activity 1.800 meals served 19 Actual activity 1.700 meals served 20 21 22 Enter formule into each of the cele marked with a below 2 Review Problem: Variance Analysis Using a Flexible Budget 24 35 Contre fette budget performance report 20 Reverie 27 and 28 Actu Spending 29 Results Vacances 30 Meals served 31 Revenue ? ? 32. Expenses 33 Cont of ingredients ? 2 34 Wages and salaries 2 7 35 ? Uuties ? 36 Rent 7 37 Miscellaneous 38 Total expenses 2 7 2 39 Net Operating income 7 40 41 5 Chapter 9 Form Flexible Activity Budget Viances Planning Bucket ? ? ? 2 ? ? ? ? 2 ? 2 7 ? ? ? ? ? ? 7 7. ? 2 C m E G H + B D 1 Chapter 9: Applying Excel 2 Data 3 Revenue $16.50 a 4 Cost of ingredients $6.259 5 Wages and salaries $10,400 6 Utilities $800 $0.20 9 7 Rent $2,200 8 Miscellaneous $600 $0.80 9 9 10 Actual results: 11 Revenue $27,920 12 Cost of ingredients $11,110 13 Wages and salaries $10,130 14 Utilities $1,080 15 Rent $2,200 16 Miscellaneous $2,240 17 18 Planning budget activity 1.800 meals served 19 Actual activity 1.700 meals served 20 21 22 Enter a formula into each of the colis marked with a ? below 23 Review Problem: Variance Analysis Using a Flexible Budget 24 25 Construct a flexible budget performance report Revenue 27 and 28 Actual Spending 29 Results Variances 30 Meals served 31 Revenue 2 = Chapter 9 Form 26 Flexible Activity Budget Variances 2 ? 2 Planning Budget 2 ? E G H 1 ] . K A B D 13 Wages and salaries 310,130 14 Utilities $1,080 15 Rent $2,200 16 Miscellaneous $2,240 17 18 Planning budget activity 1.800 meals served 19 Actual activity 1,700 meals served 20 21 22 Enter a formula into each of the cells marked with a ? below 23 Review Problem: Variance Analysis Using a Flexible Budget 24 25 Construct a flexible budget performance report 26 Revenue 27 and 28 Actual Spending 29 Results Variances 30 Meals served ? 31 Revenue ? > 32 Expenses 33 Cost of ingredients 2 34 Wages and salaries > 2 35 Utilities 2 2 36 Rent ? 2 37 Miscellaneous 2 2 38 Total expenses 2 2 39 Net operating income 2 ? 40 41 42 Flexible Activity Budget Variances 2 ? 2 Planning Budget ? 2 2 ? ? ? 2 2 2 ? 2 ? ? 2 2 2 2 2 2 2 2 ? . - [

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Fundamentals of Corporate Finance

Authors: Berk, DeMarzo, Harford

2nd edition

978-0132148238

Students also viewed these Accounting questions