Using the following data, create a table in Excel that uses Excel formulas to calculate the volume $($patient days$)$ and cost $($expense$)$ variances for the data presented below.$$ Is the overage due primarily to the volume increase, a cost increase, or both?$$ Explain the rationale for your response. $12$:$575$G $32$ Assignment Details HEALTH SERVICES FINANCE $1254\_$HSM$3309\_$OL $($patient aays$)$ and cost $($expense$)$ variances tor the data presented below. Is the overage due primarily to the volume increase, a cost increase, or both? Explain the rationale for your response. $\backslash$begin$\{$tabular$\}\{|$l$|$l$|$r$|\}\backslash$hline Expense & $\backslash$begin$\{$tabular$\}\{$l$\}2022\backslash \backslash$ Actual $\backslash$end$\{$tabular$\}$ & $\backslash$begin$\{$tabular$\}\{$l$\}2022\backslash \backslash$ Budget $\backslash$end$\{$tabular$\}\backslash \backslash \backslash$hline $\backslash$begin$\{$tabular$\}\{$l$\}$ Salary and $\backslash \backslash$ Wages $\backslash$end$\{$tabular$\}$ & $202,000$ & $169,000\backslash \backslash \backslash$hline $\backslash$begin$\{$tabular$\}\{$l$\}$ Fringe $\backslash \backslash$ Benefits $\backslash$end$\{$tabular$\}$ & $69,200$ & $67,000\backslash \backslash \backslash$hline Supplies & $129,000$ & $124,000\backslash \backslash \backslash$hline Depreciation & $25,000$ & $22,000\backslash \backslash \backslash$hline Interest & $14,000$ & $9,000\backslash \backslash \backslash$hline Other & $109,300$ & $115,000\backslash \backslash \backslash$hline $\backslash$begin$\{$tabular$\}\{$l$\}$ Total $\backslash \backslash$ Expenses $\backslash$end$\{$tabular$\}$ & $513,100$ & $504,000\backslash \backslash \backslash$hline $\backslash$begin$\{$tabular$\}\{$l$\}$ Patient $\backslash \backslash$ Days $\backslash$end$\{$tabular$\}$ & $47,700$ & $47,200\backslash \backslash \backslash$hline $\backslash$end$\{$tabular$\}$ Submit Assignment $-$ Previous Next Dashboard Calendar To Do Notifications Inbox