(Solved): Using the following data, create a table in Excel that uses Excel formulas to calculate the volume ( ...

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:57 5G 32 Assignment Details HEALTH SERVICES FINANCE 1254_HSM3309_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. \begin{tabular}{|l|l|r|} \hline Expense & \begin{tabular}{l} 2022 \\ Actual \end{tabular} & \begin{tabular}{l} 2022 \\ Budget \end{tabular} \\ \hline \begin{tabular}{l} Salary and \\ Wages \end{tabular} & 202,000 & 169,000 \\ \hline \begin{tabular}{l} Fringe \\ Benefits \end{tabular} & 69,200 & 67,000 \\ \hline Supplies & 129,000 & 124,000 \\ \hline Depreciation & 25,000 & 22,000 \\ \hline Interest & 14,000 & 9,000 \\ \hline Other & 109,300 & 115,000 \\ \hline \begin{tabular}{l} Total \\ Expenses \end{tabular} & 513,100 & 504,000 \\ \hline \begin{tabular}{l} Patient \\ Days \end{tabular} & 47,700 & 47,200 \\ \hline \end{tabular} Submit Assignment - Previous Next Dashboard Calendar To Do Notifications Inbox