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