\begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline 4 & \multicolumn{6}{|c|}{ Calculate each of the following based upon the data below: } \\ \hline \\ \hline 6 & & & Static Budget & \begin{tabular}{l} Flexible \\ Budget \end{tabular} & Actual Results & \\ \hline 7 & & Total Revenue & $1,980,000 & $2,060,000 & $2,050,000 & \\ \hline 8 & & Total Costs & 1,350,000 & 1,675,000 & 1,790,000 & \\ \hline 9 & & Projected Profit & 630,000 & 385,000 & 260,000 & \\ \hline \multicolumn{7}{|l|}{10} \\ \hline \multicolumn{7}{|l|}{11} \\ \hline \multicolumn{7}{|l|}{12} \\ \hline 13 & a. & Profit variance & $125,000 & \multirow{3}{*}{\multicolumn{3}{|c|}{\begin{tabular}{l} Actual profit-projected project \\ Actual Revenue-Flexible budget revenue \\ Actual cost- Fixed budget cost \end{tabular}}} \\ \hline 14 & b. & Revenue variance & $10,000 & & & \\ \hline 15 & c. & Cost variance & $115,000 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & & & & & & & & \\ \hline A & B & c & D & E & F & G & H & 1 \\ \hline c. & Cost varlance & $115,000 & Actual cos & & & & & \\ \hline & & & & & & & & \\ \hline & Revenue voriances: & & & & & & & \\ \hline d. & Volume variance & & Actual Qu & ole bu & & & get pr & \\ \hline e. & Price variance & & Actual pric & budg & & & & \\ \hline & & & & & & & & \\ \hline & Cost variances: & & & & & & & \\ \hline f. & Volume variance & & & & & exible & get c & unit \\ \hline g. & Management variance & & Flexible B & & & & & \\ \hline \end{tabular}