PLEASE SHOW ALL FORMULAS USED TO GET THE DATA IN EACH CELL!!! THANK YOU!

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. Here are some tips for using Excel: - Cell Reference: Allows you to refer to data from another cell in the worksheet. If you entered "=B5" into a blank cell, the formula would output the value from cell B5. - Basic Math Functions: Allow 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 multiply), and / (forward slash to divide). For example, if you entered "=B4+B5" in a blank cell, the formula would add the values from those cells and output the result. - SUM Function: Allows you to refer to multiple cells and adds all the values. You can add individual cell references or ranges. If you entered "=SUM (C4,C5,C6) " into a blank cell, the formula would output the result of adding those three separate cells. Similarly, if you entered "=SUM(C4:C6)", the formula would output the same result of adding those cells. 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline Exce & McGraw Hill Excel Q & Iestion - Savec & ed & & & & & & & & & & & & & arch for tool & help, a & and more (Al & Alt+Q) & & \\ \hline File & Home & Draw & Formulas & Data & View & Help & & & & & & & & & & & & & & & \\ \hlinev & & (Body) & 11A & A & U & ab & 2 & & & ab Wrap & & Merge & General & & $ & \begin{tabular}{ll} .0 & .00 \\ .00 & .0 \end{tabular} & & Conditional & Formatting & gB & Cell Styl \\ \hline \multicolumn{22}{|l|}{ Q31 } \\ \hline & A & B & c & D & E & F & G & H & I & J & K & L & M & N & 0 & P & Q & R & s & T & u \\ \hline 11 & Revenue & =451080 & =C101043 & =ABS(C11F & & & & & & & & & & & & & & & & & \\ \hline 12 & Expenses: & & & & & & & & & & & & & & & & & & & & \\ \hline 13 & Food costs & =90B10 & =94C10 & =ABS(C13C & u & & & & & & & & & & & & & & & & \\ \hline 14 & Party supplies & =40B10 & =37C10 & =ABS(C14L & & & & & & & & & & & & & & & & & \\ \hline 15 & Party worker wages & =80B10 & =84C10 & =ABS(C15C & & & & & & & & & & & & & & & & & \\ \hline 16 & Administrative salaries & 3,700 & 3,500 & =ABS(C16F & & & & & & & & & & & & & & & & & \\ \hline 17 & Equipment depreciation & 1,200 & 1,200 & =ABS(C17N & -None & & & & & & & & & & & & & & & & \\ \hline 18 & Rent & 5,000 & 5,000 & =ABS(C18N & None & & & & & & & & & & & & & & & & \\ \hline 19 & Total expense & =SUM(B13:B) & 81=SUM(C13:C1 & 1=ABS(C19C & & & & & & & & & & & & & & & & & \\ \hline 20 & \multicolumn{5}{|l|}{ Net operating income } & & & & & & & & & & & & & & & & \\ \hline 21 & \multicolumn{21}{|c|}{ Food costs, party supplies, and party worker wages are variable costs. } \\ \hline 22 & \multicolumn{21}{|c|}{ Administrative salaries, equipment depreciation, and rent are fixed costs. } \\ \hline \multicolumn{22}{|c|}{23} \\ \hline 24 & Required: & & & & & & & & & & & & & & & & & & & & \\ \hline 25 & Prepare a new report for Ju & ne using the flex & lexible budget ar & approach. & & & & & & & & & & & & & & & & & \\ \hline 26 & & & & & & & & & & & & & & & & & & & & & \\ \hline 27 & Enter all variances as positiv & e amounts. Lea & eave no cells bla & lank. & & & & & & & & & & & & & & & & & \\ \hline 28 & (Use cells A10 to E20 from t & he given inform & mation, as well & as A34 to H4 & -44 to complete & this question. & & & & & & & & & & & & & & & \\ \hline 29 & & & & & & & & & & & & & & & & & & & & & \\ \hline 30 & & & & erfect Parties & & & & & & & & & & & & & & & & & \\ \hline 31 & & Birthday Pa & Party Division Fl & lexible Budge & get Performanc & e Report & & & & & & & & & & & & & & & \\ \hline 32 & & & For the Mc & lonth Ended & d June 30 & & & & & & & & & & & & & & & & \\ \hline 33 & & \begin{tabular}{l} Planning \\ Budget \end{tabular} & \begin{tabular}{c} Activity \\ Variances \end{tabular} & & \begin{tabular}{l} Flexible \\ Budget \end{tabular} & \begin{tabular}{l} Revenue and \\ Varian \end{tabular} & \begin{tabular}{l} Spending \\ ces \end{tabular} & \begin{tabular}{l} Actual \\ Results \end{tabular} & & & & & & & & & & & & & \\ \hline 34 & Number of parties & =B10 & & & =C10 & & & =C10 & & & & & & & & & & & & & \\ \hline 35 & Revenues & =B11 & =E6B6 & & & & & & =IF(OR(C3) & & & & & & & & & & & & \\ \hline 36 & Expenses: & & & & & & & & & & & & & & & & & & & & \\ \hline 37 & Food costs & & & & & & & & =IF(OR(B3) & & & & & & & & & & & & \\ \hline 38 & Party supplies & & & & & & & & =IF(OR(B3) & & & & & & & & & & & & \\ \hline 39 & Party worker wages & V & & & & & & r & =IF(OR(B3) & & & & & & & & & & & & \\ \hline 40 & Administrative salaries & & & & & & & & =IF(OR(B4) & & & & & & & & & & & & \\ \hline 41 & Equipment depreciation & & & & & & & V & =IF(OR(B4 & & & & & & & & & & & & \\ \hline 42 & Rent & r & P & & & & & & =IF(OR(B4) & & & & & & & & & & & & \\ \hline 43 & Total expense & & & & & & & & =IF(OR(B4) & & & & & & & & & & & & \\ \hline 44 & Net operating income & E & 1 & & 8 & & & & =IF(OR(C4 & & & & & & & & & & & & \\ \hline 45 & & & & & & & & & & & & & & & & & & & & & \\ \hline 46 & & & & & & & & & & & & & & & & & & & & & \\ \hline \end{tabular}