can you help me figure out sections "Office Rent" to "Other Expenses"?
If you need extra info, just let me know! thanks!
K D H E Total Practice Patients Revenue Per Patient Visit Practice Raven 100.00 25% 5 20,100 $ 170 3,430,224 55,044 143,217 349,001 837,81% $ 174 5 179 $ 183 $ 188 0,756,843 25,601,097 63,964,800 157,353,028 Variable Expende Medical Supplies/Ancillary 0.00 15 16 17 13 19 20 21 22 23 24 25 25 27 28 20 30 31 Labor E Salaries - Physics Salaries. Providers Salaries - Suff Total Sataries Taxes/Fringes Total Labor Expense 2.08 $ 185,000 0.00 $ 00.000 0.0 $ 188,700 S 577,422 $ 785,294 $1,001,250 $1,225,530 $ 90,000 $ 270,000 $360,000 $ 450.X $ 540.000 5 $ $ $ $ 278,700 847.422 1,145,294 1,451,250 1,765,530 109.484 220,050 200.250 353.100 306,570 1,016,000 1,374,353 1,241,500 2,118,630 20.09 27.870 0.095 $ 33 34 25 36 37 30 30 10 41 42 Other Expense Omee Rent Depreciation & Amortion Telephone Untities Cleaning, Repairs & Maint Lepal & Accounting License Fees Ducs Professional Services Recruiting Expenie Other Expenses 0045 000 $ 0.05 0.085 0.03 0.005 5 $ $ S $ $ $ 5 $ $ 5 10.000 0.005 5 $ 14 40,000 Total Expenses Net Income Before Taxes 346,370 105 3.083,654 008 1,010,000 106 8,739,937 DO 1.374,353 50 24 227,004 959 1,741.500 394 62.223.390 979 2,118,636 19 155,234,003 099 46 57 48 3 50 31 52 33 54 55 56 57 58 Coin C is lobation Department of Commerce, 2019). We assume that the growth rate will not rise exponentially in the next five years, therefore we will use the next five years to meet the physician need for Internal Medicine based on the physician to population ratio of Wilkes County. Average # of patients per year was calculated using the following numbers. - Internist take approximately 17-24 minutes per patient. 60 mins / 17 mins = 3.5 so the average physician sees approxiametly 3 patients per hour 3 patients * 7 hours (physycians work 8 hours however you have to take time off for lunch, breaks, charting. 21 * 5 = 105 patients a week - 105 * 48 weeks = 5040 patients a year! D K D H E Total Practice Patients Revenue Per Patient Visit Practice Raven 100.00 25% 5 20,100 $ 170 3,430,224 55,044 143,217 349,001 837,81% $ 174 5 179 $ 183 $ 188 0,756,843 25,601,097 63,964,800 157,353,028 Variable Expende Medical Supplies/Ancillary 0.00 15 16 17 13 19 20 21 22 23 24 25 25 27 28 20 30 31 Labor E Salaries - Physics Salaries. Providers Salaries - Suff Total Sataries Taxes/Fringes Total Labor Expense 2.08 $ 185,000 0.00 $ 00.000 0.0 $ 188,700 S 577,422 $ 785,294 $1,001,250 $1,225,530 $ 90,000 $ 270,000 $360,000 $ 450.X $ 540.000 5 $ $ $ $ 278,700 847.422 1,145,294 1,451,250 1,765,530 109.484 220,050 200.250 353.100 306,570 1,016,000 1,374,353 1,241,500 2,118,630 20.09 27.870 0.095 $ 33 34 25 36 37 30 30 10 41 42 Other Expense Omee Rent Depreciation & Amortion Telephone Untities Cleaning, Repairs & Maint Lepal & Accounting License Fees Ducs Professional Services Recruiting Expenie Other Expenses 0045 000 $ 0.05 0.085 0.03 0.005 5 $ $ S $ $ $ 5 $ $ 5 10.000 0.005 5 $ 14 40,000 Total Expenses Net Income Before Taxes 346,370 105 3.083,654 008 1,010,000 106 8,739,937 DO 1.374,353 50 24 227,004 959 1,741.500 394 62.223.390 979 2,118,636 19 155,234,003 099 46 57 48 3 50 31 52 33 54 55 56 57 58 Coin C is lobation Department of Commerce, 2019). We assume that the growth rate will not rise exponentially in the next five years, therefore we will use the next five years to meet the physician need for Internal Medicine based on the physician to population ratio of Wilkes County. Average # of patients per year was calculated using the following numbers. - Internist take approximately 17-24 minutes per patient. 60 mins / 17 mins = 3.5 so the average physician sees approxiametly 3 patients per hour 3 patients * 7 hours (physycians work 8 hours however you have to take time off for lunch, breaks, charting. 21 * 5 = 105 patients a week - 105 * 48 weeks = 5040 patients a year! D