Please show formulas used in excel for each answer please.
5t. Benedict Hospital has three primary revenue producing departments (inpatient, Outpatient, Clinic) with the following revenue and cost projections. In order to better determine the departments' overall true cost and profit margin, management wants to allocate service department costs as overhead allocations to these departments. PROJECTED REVENUES AND COSTS PER DEPARTMENT \begin{tabular}{|l|c|c|} \hline Revenues & & \\ \hline Inpatient Services & $ & 19,250,000 \\ \hline Outpatient Services & & 28,500,000 \\ \hline Clinic Services & & 11,500,000 \\ \hline Total revenues & $ & 59,250,000 \\ \hline & & \\ \hline Direct Costs & & \\ \hline Inpatient Services & $ & 11,250,000 \\ \hline Outpatient Services & & 14,250,000 \\ \hline Clinic Services & & 4,500,000 \\ \hline Total costs & $ & 30,000,000 \\ \hline \end{tabular} Management considered various cost drivers and made the determiniation to use the following as the most relevant for each service department: Eased upon this information, complete the following filling in each highlighted cell, Be sure to use formulas to show your work. Based upan this information, complete the following, filling in each highlichted cell. Be sure to use formulas to show yeur work, St. Benedict Hespltal has three primary revenue producing departments (inpatient, Outpatient, Clinic) with the following revensie and cost projections. In order to bettet determine the departments' overall true cost and profit margin, management wants to allocate service department costs as overhe ad allocations to these departiments. Manage ment considered various cost dffeen and made the determiniation to use the following as the most relevant for each senice department: 5t. Benedict Hospital has three primary revenue producing departments (inpatient, Outpatient, Clinic) with the following revenue and cost projections. In order to better determine the departments' overall true cost and profit margin, management wants to allocate service department costs as overhead allocations to these departments. PROJECTED REVENUES AND COSTS PER DEPARTMENT \begin{tabular}{|l|c|c|} \hline Revenues & & \\ \hline Inpatient Services & $ & 19,250,000 \\ \hline Outpatient Services & & 28,500,000 \\ \hline Clinic Services & & 11,500,000 \\ \hline Total revenues & $ & 59,250,000 \\ \hline & & \\ \hline Direct Costs & & \\ \hline Inpatient Services & $ & 11,250,000 \\ \hline Outpatient Services & & 14,250,000 \\ \hline Clinic Services & & 4,500,000 \\ \hline Total costs & $ & 30,000,000 \\ \hline \end{tabular} Management considered various cost drivers and made the determiniation to use the following as the most relevant for each service department: Eased upon this information, complete the following filling in each highlighted cell, Be sure to use formulas to show your work. Based upan this information, complete the following, filling in each highlichted cell. Be sure to use formulas to show yeur work, St. Benedict Hespltal has three primary revenue producing departments (inpatient, Outpatient, Clinic) with the following revensie and cost projections. In order to bettet determine the departments' overall true cost and profit margin, management wants to allocate service department costs as overhe ad allocations to these departiments. Manage ment considered various cost dffeen and made the determiniation to use the following as the most relevant for each senice department
