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
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