\begin{tabular}{|l|l|l|l|l|l|l|l|} \hline \multicolumn{5}{|c|}{ Company X } \\ \hline & Actual & FlexibleBudgetVariance & Flexible Budget & SalesVolumeVariance & Static Budget \\ \hline Units & & & & & \\ \hline Revenue & & & & & \\ \hline Operating Costs & & & & & \\ \hline Supplies & & & & & \\ \hline Electricity & & & & & \\ \hline Wages and Salaries & & & & & \\ \hline Maintenance & & & & & \\ \hline Depreciation & & & & & \\ \hline Insurance & & & & & \\ \hline Rent & & & & & & \\ \hline Administrative Expenses & & & & & \\ \hline Total Operating Costs & & & & & \\ \hline Net Operating Income & & & & & \\ \hline \end{tabular} \begin{tabular}{|l|rr|rr|} \hline \multicolumn{5}{|c|}{ Company X Cost Structure } \\ \hline & \multicolumn{1}{|c|}{ Fixed Cost } & \multicolumn{2}{|c|}{ Variable Cost } \\ \hline Supplies & & & S & 3.80 \\ \hline Electricity & S & 790,000 & S & 9.00 \\ \hline Wages and Salaries & S & 870,000 & S & 16.50 \\ \hline Maintenance & S & 400,000 & S & 0.30 \\ \hline Depreciation & S & 780,000 & & \\ \hline Insurance & S & 640,000 & \\ \hline Rent & S & 370,000 & \\ \hline Administrative Expenses & S & 1,090,000 & \\ \hline \end{tabular} \begin{tabular}{|l|rr|} \hline \multicolumn{2}{|c|}{ Company X } \\ \hline \multicolumn{2}{|c|}{ Additional Information } \\ \hline Budgeted Price & S & 40 \\ \hline Budgeted Units Sold & 380,000 \\ \hline Actual Price & S & 42 \\ \hline Actual Units Sold & & 396,200 \\ \hline \end{tabular} 1. Using the information provided within the Excel Template, please reconstruct the static budget, prepare a flexible budget, and perform a variance analysis including Sales Volume Variance and Flexible Budget Variance