Question $6(10$ points$)$ USING EXCEL

Provide a budget variance analysis for three scenarios: $($a$)$ Static Budget; b$)$ Flexible Budget for Actual Volume but Static Price, and c$)$ Actual Volume and Actual Price with the information below.

$\backslash$table$[[,$Static,Actual$],[$Volume $($# of surgeries$)$:$,120,160],[$Revenue per surgery:,$$1,800,$$$1,800$