*** Must use EXCEL spreadsheet and show formula*** Northeast Medical Group, a family practice, has the following financial data and operational metric:

Number of physicians : 5

Total revenue : $2,748,360

Total operating costs : $1,557,615

Total procedures per physician : 12,353

Patients per physician : 1,941

Visits per physician : 5,333

If you think you need a number for "discharges" for this assignment, it is okay to use "admissions" You have to make an assumption for eventually all admissions get discharged which is a bit of a "stretch". Just imagine that you see "discharge" where you see "admission" on 7.6.

a. What is the groups revenue per physician? b. What is the groups operating cost per physician? c. What is the groups total operating profit? d. What is the groups profit per physician? Per patient? Per visit? Per procedure? e. Assume that the group plans to reinvest $50,000 of its profits in the practice. (It plans to buy a new EKG [electrocardiogram] machine.) Also, assume that the remainder of profits will be distributed equally to the groups physicians as salary. What compensation will each physician receive?