A pedatric company would like to compare the productivity with 3 different departments making adjustments to the service mix in each division. using the table, What is the adjusted patient visit volume for each department using excel?

Measurements General Pediatrics Hematology Total Worked Hours 14,813 16,442 Patient Visits 12,113 4,319 Reimbursement per Visit 30.87 51.6 Overhead Costs 29,831 9.922 Materials Cost 58,447 45,676 Skill Mix Distribution RN ($28.85/hr) 0.61 0.42 LPN ($17.60/hr) 0.26 0.36 Other ($11.8/hr) 10.13 0.22 What is the adjusted patient visit volume for General Pediatrics? Endocrinology 21,252 9.994 48.88 37,004 98,000 0.42 0.36 0.22 Measurements General Pediatrics Hematology Total Worked Hours 14,813 16,442 Patient Visits 12,113 4,319 Reimbursement per Visit 30.87 51.6 Overhead Costs 29,831 9.922 Materials Cost 58,447 45,676 Skill Mix Distribution RN ($28.85/hr) 0.61 0.42 LPN ($17.60/hr) 0.26 0.36 Other ($11.8/hr) 10.13 0.22 What is the adjusted patient visit volume for General Pediatrics? Endocrinology 21,252 9.994 48.88 37,004 98,000 0.42 0.36 0.22