Need the formulas

which provides birthday parties at th eir facility, and has provided the actual and planning budget results for the month of June. The Controlle you prepare the Birthday Party cluded in the Excel Simulation and the Excel functio . Cell Reference: Al ou to re fer to data from another cell eet. From the Excel Simulation bel entered, the formula would output the result from cell E11, or 80 in this example Basic Math functions: Allows you to use the ba ic math symbols to perform mathematical funct ons. You can use t ard slash to divide). From the Excel Simulation bel . lank cell -E13-F13" was entered, the formula using the other math symbols the result would output an appropriate answer for its function. would add the values from those cells a SUM function: Allows you to refer to multip You can add individual cell references or ranges to u k cell "-SUM(E16,E17,E18)" was ntered, the formula would output the result of a nd the result would be 13,300 in this example ABS function: Allows you to return t absolute value of a number or calculation. You can reference any cell to display ith the ABS function, to return the final result alue. From the Excel Simulation below, you can round another formula w in cell H18 that the ABS function is being used Then, the ABS portion of the formula returns t you to test a condition and return a Excel thinks, find cell E13 and determine if the value is gre than 30,000. Once Excel determines if the res dition is TRUE or FALSE, it will return the value it Preparing a Performance Report Excel HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri PasteB IUA Alignment Number Conditional Format as Cll Cels Editing Clipboard A1 Formatting TableStyles- Font X f Perfect Parties, Inc. has several divisions. One division provides birthday parties e bookkeeper has prepared a report comparing actual results for the month of June to budgeted results Perfect Parties Birthday Party Division Analysis of Revenues and Costs For the Month Ended June 30 Planning Budget Actual Results Variances 10 11 Number of parties 12 13 Revenue 14 Expenses: 15 Food costs 16 Party supplies 17 Party worker wages 18 Administrative salaries 19 Equipment depreciation 20 Rent 21 Total expense 22 Net operating income 23 Food costs, party supplies and party worker wages are variable costs. 24 Administrative salaries, equipment depreciation and rent are fixed costs 25 80 92 36,000 39,560 3,560 F 7,200 3,200 6,400 3,700 1,200 5,000 26,700 9,300 8,648 3,404 7,728 3,500 1,200 5,000 29,480 10,080 1,448 U 204 U 1,328 U 200 F . None None 2,780 U .Sheet 1 - + 100% Attempt(s) 29 30 31 32 Perfect Parties Birthday Party Division Flexible Budget Performance Report For the Month Ended June 30 Planning Budget Flexible Actual Revenue and Budget Spending Variances Results Activity Variances 34 Number of parties 35 36 Revenues 37 Expenses 38 Food costs 80 92 92 36,000 7,200 3,200 6,400 3,700 1,200 5,000 26,700 9 Party supplies 40 Party worker wages 1 Administrative salaries 42 Equipment depreciation 43 Rent 44 Total expense 45 Net operating income 46 47 48 49