Perfect Parties, Inc. has several divisions, one of which provides birthday parties at their facility, and has provided the actual and planning budget results 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.

All answers must be entered as a formula

Saved 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. \begin{tabular}{|l|l|l|} \hline 4 & The bookkeeper has prepared a report comparing act \\ \hline 5 & Perfect Parties \\ \hline 6 & Bisthday Party Division Antysis of \end{tabular} Birthday Party Division Analysis of Revenues and Costs For the Month Ended June 30 \begin{tabular}{|l|r|} \hline 6 & Birt \\ \hline 7 & \\ \hline 8 & \\ \hline 9 & \\ \hline 10 & \\ \hline 11 & Number of parties \\ \hline 12 & \end{tabular} 13 Revenue \begin{tabular}{llll|lll} $36,000 & $39,560 & $3,560 & F \end{tabular} 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 \begin{tabular}{rrrr} & 26,700 & 29,480 \\ \hline$ & 9,300 & $ & 10,080 \\ \hline \hline \end{tabular} \begin{tabular}{|r|r|r|r|r|} \hline 7,200 & 8,648 & 1,448 & U \\ \hline 3,200 & 3,404 & 204 & U \\ \hline 6,400 & 7,728 & 1,328 & U \\ \hline 3,700 & 3,500 & 200 & F \\ \hline \end{tabular} 23 Food costs. partv supplies and party worker wages are variable costs. \begin{tabular}{rl} & None \\ & None \\ 2,780 & U \\ $780 & F \\ \hline \hline \end{tabular} kboard Learn M Inbox (5,140) - sa... Developing Qualit... Saved