Question

Review the attached benchmarking report. First calculate the Upper Quartile, 75% to 100%, Mid Quartile, 25% to 75%, and the Low Quartile, 0% to 25% for each line item. Then rank the 10 hospitals, from 1 to 10, based on each of the following, each line may have the hospitals ranked differently:

1. How many beds the hospitals have
2. Productivity-Unit of Service, UOS/Hours worked
3. Total Costs-Dollars/UOS
4. Salary Costs-Dollars/UOS
5. Supply Costs-Dollars/UOS
6. Revenue-Dollars/UOS

					Hosp  #1	Hosp  #2	Hosp  #3	Hosp  #4	Hosp  #5	Hosp  #6	Hosp  #7	Hosp  #8	Hosp  #9	Hosp #10	Total	Upper Quartile	Mid Quartile	Low Quartile
Number of Hospital Beds					500	250	150	550	425	350	300	200	400	575
Number of Beds Rank
UOS					140,000	95,000	75,000	175,000	135,000	125,000	130,000	80,000	140,000	150,000
Total Revenue					$23,000,000	$15,000,000	$13,000,000	$27,000,000	$23,500,000	$20,000,000	$22,000,000	$13,500,000	$24,500,000	$24,000,000
Revenue per UOS					$164.29	$157.89	$173.33	$154.29	$174.07	$160.00	$169.23	$168.75	$175.00	$160.00
Revenue per UOS Rank
Total Hours Worked					147,000	123,500	116,250	176,750	189,000	137,500	132,600	84,000	161,000	187,500
Productivity-Hours Worked per UOS					1.05	1.30	1.55	1.01	1.40	1.10	1.02	1.05	1.15	1.25
Productivity Rank
Total Costs					$7,140,000	$9,547,500	$7,912,500	$8,487,500	$13,770,000	$6,312,500	$6,467,500	$3,856,000	$7,805,000	$14,775,000
Total Costs per UOS					$51.00	$100.50	$105.50	$48.50	$102.00	$50.50	$49.75	$48.20	$55.75	$98.50
Total Cost/UOS-Rank
Total Salary Costs					$5,712,000	$6,205,875	$6,330,000	$6,365,625	$11,016,000	$4,734,375	$4,855,000	$2,699,200	$5,073,250	$11,524,500
Salary Costs per UOS					$40.80	$65.33	$84.40	$36.38	$81.60	$37.88	$37.35	$33.74	$36.24	$76.83
Salary Costs per UOS Rank
Total Supply Costs					$1,428,000	$3,341,625	$1,582,500	$2,121,875	$2,754,000	$1,578,125	$1,612,500	$1,156,800	$2,731,750	$3,250,500
Supply Costs per UOS					$10.20	$35.18	$21.10	$12.13	$20.40	$12.63	$12.40	$14.46	$19.51	$21.67
Supply Costs per UOS  Rank

Answer 1

			Hosp  #1	Hosp  #2	Hosp  #3	Hosp  #4	Hosp  #5	Hosp  #6	Hosp  #7	Hosp  #8	Hosp  #9	Hosp #10	Total	Upper Quartile	Mid Quartile	Low Quartile
Number of Hospital Beds			500	250	150	550	425	350	300	200	400	575	3700	500	375	250
Number of Beds Rank			3	8	10	2	4	6	7	9	5	1
UOS			140,000	95,000	75,000	175,000	135,000	125,000	130,000	80,000	140,000	150,000	1,245,000
Total Revenue			$23,000,000	$15,000,000	$13,000,000	$27,000,000	$23,500,000	$20,000,000	$22,000,000	$13,500,000	$24,500,000	$24,000,000	$205,500,000
Revenue per UOS			$164.29	$157.89	$173.33	$154.29	$174.07	$160.00	$169.23	$168.75	$175.00	$160.00		$173.33	$166.52	$160.00
Revenue per UOS Rank			6	9	3	10	2	7	4	5	1	8
Total Hours Worked			147,000	123,500	116,250	176,750	189,000	137,500	132,600	84,000	161,000	187,500	1,455,100
Productivity-Hours Worked per UOS			1.05	1.3	1.55	1.01	1.4	1.1	1.02	1.05	1.15	1.25		1.3	1.125	1.05
Productivity Rank			7	3	1	10	2	6	9	8	5	4
Total Costs			$7,140,000	$9,547,500	$7,912,500	$8,487,500	$13,770,000	$6,312,500	$6,467,500	$3,856,000	$7,805,000	$14,775,000	$86,073,500
Total Costs per UOS			$51.00	$100.50	$105.50	$48.50	$102.00	$50.50	$49.75	$48.20	$55.75	$98.50		$49.75	53.375	$100.50
Total Cost/UOS-Rank			5	8	10	2	9	4	3	1	6	7
Total Salary Costs			$5,712,000	$6,205,875	$6,330,000	$6,365,625	$11,016,000	$4,734,375	$4,855,000	$2,699,200	$5,073,250	$11,524,500	$64,515,825
Salary Costs per UOS			$40.80	$65.33	$84.40	$36.38	$81.60	$37.88	$37.35	$33.74	$36.24	$76.83		$36.38	39.34	$76.83
Salary Costs per UOS Rank			6	7	10	3	9	5	4	1	2	8
Total Supply Costs			$1,428,000	$3,341,625	$1,582,500	$2,121,875	$2,754,000	$1,578,125	$1,612,500	$1,156,800	$2,731,750	$3,250,500	$21,557,675
Supply Costs per UOS			$10.20	$35.18	$21.10	$12.13	$20.40	$12.63	$12.40	$14.46	$19.51	$21.67		$12.40	$16.99	$21.10
Supply Costs per UOS rank			1	10	8	2	7	4	3	5	6	9