Answered step by step
Verified Expert Solution
Question
1 Approved Answer
begin{tabular}{|c|c|c|c|c|c|c|c|} hline & A & B & C & D & E & G & H hline multicolumn{8}{|l|}{23} hline 24 & Required: &
\begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & G & H \\ \hline \multicolumn{8}{|l|}{23} \\ \hline 24 & Required: & & & & & & \\ \hline 25 & \multicolumn{7}{|c|}{ Prepare a new report for June using the flexible budget approach. } \\ \hline 26 & & & & & & & \\ \hline 27 & \multicolumn{7}{|c|}{ Enter all variances as positive amounts. Leave no cells blank. } \\ \hline 28 & \multirow{2}{*}{\multicolumn{7}{|c|}{ (Use cells A10 to E20 from the given information, as well as A34 to H44 to complete this question.) }} \\ \hline 29 & & & & & & & \\ \hline 30 & \multicolumn{7}{|c|}{ Perfect Parties } \\ \hline 31 & \multicolumn{7}{|c|}{ Birthday Party Division Flexible Budget Performance Report } \\ \hline 32 & \multicolumn{7}{|c|}{ For the Month Ended June 30} \\ \hline 33 & & Planning & Activity & & Flexible & Revenue and Spending & Actual \\ \hline & & Budget & Variances & & Budget & Variances & Results \\ \hline 34 & Number of parties & 80 & & & 92 & & \\ \hline 35 & Revenues & $36,000 & & F & & U & \\ \hline 36 & Expenses: & & & & & & \\ \hline 37 & Food costs & 7,200 & & u & & U & \\ \hline 38 & Party supplies & 3,200 & & U & & F & \\ \hline 39 & Party worker wages & 6,400 & & U & & U & \\ \hline 40 & Administrative salaries & 3,700 & & None & & F & \\ \hline 41 & Equipment depreciation & 1,200 & & None & & None & \\ \hline 42 & Rent & 5,000 & & None & & None & \\ \hline 43 & Total expense & 26,700 & & U & & U & \\ \hline 44 & Net operating income & $9,300 & & F & & U & \\ \hline \end{tabular}
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started