If completed must but stuck on the cells 51-57 ... what is the correct equation?

AutoSave OFF A A PC... 3 BSOL 341 WEEK 4 Midterm Project march 2023-1-2 Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments Share H46 + X V fx B C D E F G H I J K L M N GA2:E30ood Patient Clinic Nashville, TN Net Income 6 YOU HAVE JUST BEEN HIRED AS THE MANAGER OF THE GOOD PATIENT CLINIC. You have been asked to make a suggestion about dividing up the profits between the two doctors. 8 (The doctors will take their share of the profits to pay their own nurse's bonus) 9 10 Here are the relevant facts: 11 A. Each doctor makes $175,000 per year. 12 B. Each nurse makes $65,000 per year. 13 C. Medical supplies average $6 per patient visit. 14 Complete the steps below: 16 1. Compute the Average Revenue per patient visit 17 2. Fill in the blanks showing the Contribution margin for each physician 18 3.. Divide the total expenses into Fixed and Variable 19 4. Determine the Variable medical supply cost per visit. 20 5. Determine the Contribution Margin per patient visit for each physician 21 6. Determine the Fixed Cost per patient visit 22 7. Allocate the Fixed cost per patient visit to each physian based on their volume 23 24 FINAL QUESTION: HOW WOULD YOU ALLOCATE THE $168,000 PROFIT TO EACH PHYSICIAN? 25 EXPLAIN YOUR ANSWER 26 27 28 Revenue $ 1,100,000 Fixed Cost Variable Cost 29 30 Office Salaries 150,000 150,000 31 Office Supplies 22,500 22,500 32 Clinic Rent 120,000 120,000 33 Property Taxes 8,000 8,000 34 Insurance 4,500 4,500 35 Utilities 15,000 15,000 36 Physician Salaries 350,000 350,000 37 Nurse Salaries 130,000 130,000 8 Medical Supplies 132,000 132,000 39 Total Expenses 932,000 320,000 s 612,000 40 Sheet1 + Ready fox Accessibility: Investigate + 100%AutoSave O OFF A ABC ... BSOL 341 WEEK 4 Midterm Project march 2023-1-2 Home Insert Draw Page Layout Formulas Data Review View Automate Tell me Comments Share N35 4 X V fx D F G H J K L M N 23 24 FINAL QUESTION: HOW WOULD YOU ALLOCATE THE $168,000 PROFIT TO EACH PHYSICIAN? 25 EXPLAIN YOUR ANSWER 26 27 18 Revenue $ 1,100,000 Fixed Cost Variable Cost 29 30 Office Salaries 150,000 150,000 31 Office Supplies 22,500 22,500 32 Clinic Rent 120,000 120,000 33 Property Taxes 8,000 8,000 34 Insurance 4,500 4,500 35 Utilities 15,000 15,000 36 Physician Salaries 350,000 350,000 37 Nurse Salaries 130,000 130,000 38 Medical Supplies 132,000 132,000 39 Total Expenses 932,000 S 320,000 612,000 40 1 Net Income S 168,000 42 43 . Revenue per Patient visit $50.00 45 Average medical supply cost per patient visit S 6.00 46 Dr Welby Dr Zeuss TOTAL VISITS 47 PATIENT VISITS 13,000 9,000 22,000 48 50 Dr Welby Dr Zeuss TOTAL REVENUE 51 PATIENT REVENUE S S Physician Salary 3 Nurses Salary 54 Medical Supplies 78,000 54,000 132,000 TOTAL EXPENSES $ 78,000 $ 54,000 56 57 2. CONTRIBUTION MARGIN $ 58 3. CONTRIBUTION MARGIN PER VISIT 44.00 $ 44.00 9 Fixed cost per patient visit 189,091 $ 130,909 $ 14.55 60 61 Sheet1 + Ready fox Accessibility: Investigate + 100%