answers in formulas please !!
ve erfect Parties, Inc. nas several divisions, one of which provides birthday parties at their tacuity, ana nas provided the actual ana planning budget esults for the month of June. The Controller has asked you prepare the Birthday Party Division Budget Performance Report. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another celt in the worksheet From the Excel Simulation below, it in a blank cell-Er was entered the formula would output the result from cell En, of 80 in this example Basic Math functions: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys - plus sign to add). - (minus sign to subtract.asterisk sign to muy and forward ssh to divide). From the Excel Simulation below if in a blank cell **E13-F13" was entered the formula would add the values from those cells and output the result or 75,560 in this example 11 using the other math symbols the result would output an appropriate answer for its function SUM function: Allows you to refer to multiple cells and adds as the values You can ada individual cett references or ranges to utilize this function. From the Excel Simulation below, it in a blank celeSUME16E17013)" was entered the formula would outout the result of adding those three separate cells or 13.300 in this example Simany, it in a blank cellSUME16E18" was entered the formula would output the same result of adding those cells, except they are expressed as a range in the formule, and the result would be 13:300 in this exampre ABS function: Allows you to return the absolute value ot a number or calculation. You can reference any cen to display its absolute value, or murround another formula with the ABS function to return the final result as an absolute value. From the Excel Simulation below you can see inceli H15 that the ABS function is being used,ABS FIS-E18,"winst Calculates the subtraction of F18-E18 that results in 200. Then the ABS portion of the forma returns the absolute volue of the subtraction result which would be 200 in this example . E function Allows you to testa condition and return aspecte va is the result is true and afferent value the result ise. The syntax of the function is stil.conctionnementer and specin considerations need to be made wnering this function The test conation argument is an evaluation of the status of such as the value of a ces greater than estan equal to another nurbet o cell. The vend te argumento return any specific result for each option such as another celt reference a value or text. Throughout the entire equaton text is being used in the test.contona. Leguments then the text itself should be entered in quotations so that Excel recognize the text as a string of text' nitead of anomer function. From me Excel Simulation below. Finance E13-30000 Revenue Revenue tady was entered the formula would outout the result of the aver since the test.com Wood be resultaten this case the text Revenue 0000 Exce processes the function by separating it out into ste is the rest.com-Excel thinkind os 3 and determine the values ante 11 search o Simulation ( Saved 1 Perfect Palties, Inc. has several divisions. One division provides birthday parties at their facility. 2 Each party sold provides entertainment, decorations, food, and party favors for 10 children. 3 The bookkeeper has prepared a report comparing actual results for the month of June to budgeted results. 4 5 6 Perfect Parties Birthday Party Division Analysis of Revenues and costs For the Month Ended June 30 7 8 9 Variances $ 3,560 F Planning Budget Actual Results 10 11 Number of parties 80 92 12 13 Revenue 36,000 $ 39,560 14 Expenses: 15 Food costs 7,200 8,648 16 Party supplies 3,200 3,404 17 Party worker wages 6,400 7,728 18 Administrative salaries 3.700 3,500 19 Equipment depreciation 1,200 1.200 20 Rent 5,000 5,000 21 Total expense 26,700 29.480 22 Net operating income S 9,300 $ 10,080 23 Food costs. part supplies and oarty worker wases are variable costs. 1,448 204 U 1,328. U 200 F - None None 2.780 U 780 F s nulation Saved Saved Administrative salaries, equipment depreciation and rent are fixed costs. Prepare a new report for June using the flexible budget approach. Enterall variances as positive amounts. If there is a variance, write an IF statements to indicate if it is For U (using capital letters). If there is no variance, enter the word None. Perfect Parties Birthday Party Division Flexible Budget Performance Report For the Month Ended June 30 e 2 2 3 Planning Budget Flexible Budget Activity Variances Actual Results Revenue and Spending Variances 4 Number of parties 55 56 Revenues B7 Expenses: 38 Food costs 39 Party Supplies 40 Party worker wages Administrative salaries 42 Equipment depreciation 49 Rent 44 Total expense 44 Total expense 45 Net operating income 45 47 AC
