Show work help please, show how to do using formulas and calculations within excel

3.5

\begin{tabular}{l|l|l|l|l} 3.1 & 3.2 & 3.3 & 3.4 & 3.5 \end{tabular} CHAPTER 8: FINANCIAL PLANNING \& BUDGETING Homework Problem 3.5 Calculate each of the following based upon the data below: \begin{tabular}{|l|r|} \hline & Static Budget \\ \hline Total Revenue & $4,700,000 \\ \hline Total Costs & 4,100,000 \\ \hline Projected Profit & 600,000 \\ \hline & \\ \hline Profit variance & \\ \hline Revenue variance \\ \hline Cost variance & \\ \hline \end{tabular} Revenue variances: d. Volume variance e. Price variance Cost variances: f. Volume variance g. Management variance h. What was the biggest factor in the revenue variance? i. What was the biggest factor in the cost variance