Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

By looking one table and other table I am looking dor excel formula in inside the yellow box. I don't need number just excel formula

By looking one table and other table I am looking dor excel formula in inside the yellow box. I don't need number just excel formula

image text in transcribedimage text in transcribed
10:47 Today 10:38 PM Edit A . Alignment Number | Conditional Format as Cell Formatting . Table . Styles Cells | Editing Clipboard Font Styles H36 X V fx B D UT G H Perfect Parties Birthday Party Division Analysis of Revenues and Costs For the Month Ended June 30 8 9 Planning Budget Actual Results Variances 10 11 Number of parties 80 92 12 13 Revenue $ 36,000 $ 39,560 3,560 F 14 Expenses: 15 Food costs 7,200 8,648 1,448 U 16 Party supplies 3,200 3,404 204 U 17 Party worker wages 6,400 7,728 1,328 U 18 Administrative salaries 3,700 3,500 200 F 19 Equipment depreciation 1,200 1,200 None 20 Rent 5,000 5,000 None 21 Total expense 26,700 29,480 2,780 U 22 Net operating income 9,300 $ 10,080 780 F 23 Food costs, party supplies and party worker wages are variable costs. 24 Administrative salaries, equipment depreciation and rent are fixed costs. 25 26 Prepare a new report for June using the flexible budget approach. Enter all variances as nositive amounts. If there is a variance write an IF statements to indicate if it is F or Ulusing capital Sheet 1 ... (+)10:47 Today 10:38 PM Edit Paste I U. . A - Alignment Number| Conditional Format as Cell Formatting Table Styles Cells Editing Clipboard Font Styles H36 B C D 27 Enter all variances as positive amounts. If there is a variance, write an IF statements to indicate if it is F or U (using capital letters). 28 if there is no variance, enter the word None. 29 Perfect Parties 30 Birthday Party Division Flexible Budget Performance Report 31 For the Month Ended June 30 32 33 Planning Flexible Revenue and Actual Budget Activity Variances Budget Spending Variances Results 34 Number of parties 80 92 97 35 Revenues 36,000 37 Expenses: 38 Food costs 7,200 39 Party supplies 3,200 40 Party worker wages 6,400 41 Administrative salaries 3,700 42 Equipment depreciation 1,200 43 Rent 5,000 44 Total expense 26,700 45 Net operating income 46 47 Sheet 1 -. + O

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

Foundations Of Finance

Authors: Arthur Keown, John Martin, J. Petty

10th Edition

0136102654, 9780136102656

More Books

Students also viewed these Accounting questions

Question

The feeling of boredom.

Answered: 1 week ago