Help please Show work within excel usinf formulas and calculations - 3.3

CHAPTER 7: SERVICE LINE COSTING AND PRICING Homework Problem 3.3 Assume that a primary care physician practice performs only one type of physical exam, with three different levels, depending upon the depth and complexity of each exam. An RVU analysis determined the required RVUs for each exam as indicated below. The total costs to run the practice as well as the annual projected number of examinations for each level are also listed below. \begin{tabular}{|l|c|} \hline Exam & RVU's \\ \hline Level I & 35 \\ \hline Level II & 40 \\ \hline Level III & 60 \\ \hline Total exams & \\ \hline Total costs & 5700,000 \\ \hline Calculate the total RVUs \\ \hline Level I & \\ \hline Level II & \\ \hline Level III & \\ \hline Total & \\ \hline \end{tabular} b. Using RVU methodology, what is the estimated cost per RVU? Cost per RVU c. What is the estimated cost per type of exam (rounded to two decimals)? \begin{tabular}{|l|l|} \hline Level I & \\ \hline Level II & \\ \hline Level III & \\ \hline \end{tabular} d. Based on the cost per exam, what is the estimated annual cost for each exam and the total cost for all three tests combined? \begin{tabular}{|l|l|} \hline Level I & \\ \hline Level II & \\ \hline Level III & \\ \hline Total costs & \\ \hline \end{tabular}