High Country Community Care has three primary revenue producing departments (Family Medicine, Women's Care, and Behavioral Health) 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 COSTS PER DEPARTMENT Management considered various cost drivers and made the determiniation to use the following as the most relevant for each service department: Square feet Housekeeping Hours Salary Dollars 1,5004,160$1,787,5002,0006,240$2,343,7501,0002,050$1,572,50012,480$500$50 Based upon this information, complete the following, filling in each highlighted cell. Be sure to use formulas to show your work. Using the data provided, allocate the overhead costs to Department Financial Services Facilities Housekeeping Administration \begin{tabular}{|l|l|l|l|} \hline Cost Pool Amount & \multicolumn{1}{|c|}{ Cost Oriver } & Total Utilization & Allocation Rate \\ \hline & Patient visits & & \\ \hline & Square feet & & \\ \hline & Housekeceping hrs & & \\ \hline & Salary dollars & & \\ \hline \end{tabular} Complete the indirect cost allocations to each patient service area. Indirect Cost Allocations Financial Services Facilities Housekeeping General Administration Total Indirect Costs Create a summary of costs for each department and estimate a price per visit assuming a 150% markup over costs Direct Costs Indirect Costs Total Costs Markup Total Revenue Patient Visits Price per visit Assume that all Indirect Costs are FIXED. What is the breakeven volume of visits for each patient service area Family Medicine Women's Care Behavioral Health