Pareto Chart
Instructions
The use of statistical process control tools helps address organizational performance in many industries, including Healthcare Information Management. A Pareto chart is a type of analysis tool that helps with ranking causes from most significant to least significant. For this activity, you will create a Pareto chart using the data provided. This data can also be found with the student resources of your textbook (Ross, 2014). As you complete this activity, consider whether these tools could help identify and solve your organizational problem for your final project.
While you are viewing the data, note that you will need only the information on the first tab, titled “States,” for this assignment.
How to create Pareto chart in Excel
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowFor additional details, please refer to the Module Five Activity Guidelines and Rubric document.
Ross, T. K. (2014). Health care quality management: Tools and applications. San Francisco: Jossey-Bass.
States
| Chapter 4 – Process Analysis Tools | Ross, T. K. (2014). Health care quality management: Tools and applications. San Francisco: Jossey-Bass. | |||||||
| Problems 4.1 and 4.3 | ||||||||
| Number | Staffed | Total | Patient | Gross Patient | ||||
| State | Hospitals | Beds | Discharges | Days | Revenue ($000) | LOS | ||
| AK – Alaska | 12 | 998 | 34,421 | 219,344 | $1,538,741 | 6.37 | ||
| AL – Alabama | 99 | 15,859 | 653,176 | 3,532,253 | $24,307,131 | 5.41 | ||
| AR – Arkansas | 57 | 8,137 | 325,221 | 1,736,664 | $9,950,236 | 5.34 | ||
| AZ – Arizona | 64 | 11,394 | 664,559 | 2,843,523 | $23,717,971 | 4.28 | ||
| CA – California | 351 | 75,854 | 3,156,632 | 18,647,141 | $174,565,816 | 5.91 | ||
| CO – Colorado | 45 | 8,082 | 375,654 | 1,930,955 | $16,965,279 | 5.14 | ||
| CT – Connecticut | 32 | 7,966 | 377,905 | 2,289,142 | $13,733,179 | 6.06 | ||
| DE – Delaware | 6 | 2,070 | 96,563 | 585,331 | $2,580,914 | 6.06 | ||
| FL – Florida | 175 | 52,773 | 2,267,578 | 12,215,719 | $98,979,587 | 5.39 | ||
| GA – Georgia | 109 | 23,140 | 891,250 | 5,914,639 | $32,451,158 | 6.64 | ||
| HI – Hawaii | 17 | 2,918 | 95,417 | 791,991 | $3,458,738 | 8.30 | ||
| IA – Iowa | 44 | 7,869 | 286,034 | 1,703,829 | $8,529,520 | 5.96 | ||
| ID – Idaho | 16 | 2,425 | 99,720 | 500,164 | $2,845,249 | 5.02 | ||
| IL – Illinois | 141 | 32,815 | 1,453,444 | 7,900,032 | $57,062,840 | 5.44 | ||
| IN – Indiana | 87 | 17,254 | 693,741 | 3,781,941 | $23,156,372 | 5.45 | ||
| KS – Kansas | 56 | 6,754 | 283,031 | 1,457,913 | $10,513,845 | 5.15 | ||
| KY – Kentucky | 71 | 13,842 | 562,712 | 3,180,976 | $18,772,381 | 5.65 | ||
| LA – Louisiana | 108 | 15,967 | 562,050 | 3,318,793 | $20,203,715 | 5.90 | ||
| MA – Massachusetts | 67 | 15,401 | 757,916 | 4,180,428 | $30,849,792 | 5.52 | ||
| MD – Maryland | 47 | 11,470 | 702,481 | 3,290,955 | $11,243,922 | 4.68 | ||
| ME – Maine | 24 | 3,276 | 129,906 | 760,624 | $4,497,946 | 5.86 | ||
| MI – Michigan | 113 | 24,202 | 1,093,710 | 5,978,419 | $41,863,279 | 5.47 | ||
| MN – Minnesota | 64 | 11,550 | 525,184 | 2,947,089 | $18,333,649 | 5.61 | ||
| MO – Missouri | 88 | 19,284 | 725,433 | 4,267,698 | $28,765,864 | 5.88 | ||
| MS – Mississippi | 74 | 11,766 | 376,368 | 2,429,873 | $12,680,803 | 6.46 | ||
| MT – Montana | 19 | 2,670 | 82,996 | 656,832 | $2,524,508 | 7.91 | ||
| NC – North Carolina | 99 | 23,392 | 928,894 | 5,896,242 | $26,199,109 | 6.35 | ||
| ND – North Dakota | 14 | 2,250 | 64,722 | 534,923 | $2,339,404 | 8.26 | ||
| NE – Nebraska | 27 | 4,516 | 177,817 | 1,114,833 | $6,552,433 | 6.27 | ||
| NH – New Hampshire | 14 | 2,198 | 96,554 | 523,305 | $4,399,165 | 5.42 | ||
| NJ – New Jersey | 75 | 22,301 | 1,053,635 | 6,067,494 | $60,798,268 | 5.76 | ||
| NM – New Mexico | 35 | 3,716 | 161,836 | 794,549 | $6,083,838 | 4.91 | ||
| NV – Nevada | 23 | 4,781 | 247,738 | 1,270,605 | $11,310,014 | 5.13 | ||
| NY – New York | 186 | 63,363 | 2,173,516 | 18,484,358 | $87,747,679 | 8.50 | ||
| OH – Ohio | 139 | 30,550 | 1,333,974 | 7,288,632 | $52,893,718 | 5.46 | ||
| OK – Oklahoma | 93 | 10,705 | 430,490 | 2,359,551 | $13,659,598 | 5.48 | ||
| OR – Oregon | 34 | 5,659 | 307,663 | 1,398,592 | $9,944,238 | 4.55 | ||
| PA – Pennsylvania | 166 | 38,290 | 1,707,901 | 9,834,645 | $89,092,136 | 5.76 | ||
| RI – Rhode Island | 11 | 2,566 | 129,882 | 715,096 | $5,082,759 | 5.51 | ||
| SC – South Carolina | 54 | 11,350 | 506,392 | 3,065,675 | $19,824,701 | 6.05 | ||
| SD – South Dakota | 27 | 2,793 | 83,542 | 680,351 | $2,726,227 | 8.14 | ||
| TN – Tennessee | 113 | 20,447 | 789,359 | 4,544,512 | $28,829,509 | 5.76 | ||
| TX – Texas | 324 | 53,189 | 2,459,345 | 12,462,942 | $94,638,845 | 5.07 | ||
| UT – Utah | 35 | 4,106 | 189,831 | 977,317 | $5,430,364 | 5.15 | ||
| VA – Virginia | 79 | 19,449 | 736,358 | 4,886,474 | $26,401,936 | 6.64 | ||
| VT – Vermont | 8 | 960 | 41,941 | 222,706 | $1,783,631 | 5.31 | ||
| WA – Washington | 51 | 9,332 | 493,731 | 2,244,821 | $18,686,823 | 4.55 | ||
| WI – Wisconsin | 71 | 11,963 | 511,240 | 2,701,680 | $18,484,512 | 5.28 | ||
| WV – West Virginia | 37 | 6,523 | 251,559 | 1,512,623 | $6,938,818 | 6.01 | ||
| WY – Wyoming | 12 | 1,247 | 38,716 | 245,976 | $1,052,014 | 6.35 | ||
| Totals | 3,772 | 772,181 | 32,710,762 | 189,961,449 | $1,303,466,007 | |||
| http://www.ahd.com/states |
AK – Alaska
AL – Alabama
AR – Arkansas
AZ – Arizona
CA – California
CO – Colorado
CT – Connecticut
DE – Delaware
FL – Florida
GA – Georgia
HI – Hawaii
IA – Iowa
ID – Idaho
IL – Illinois
IN – Indiana
KS – Kansas
KY – Kentucky
LA – Louisiana
MA – Massachusetts
MD – Maryland
ME – Maine
MI – Michigan
MN – Minnesota
MO – Missouri
MS – Mississippi
MT – Montana
NC – North Carolina
ND – North Dakota
NE – Nebraska
NH – New Hampshire
NJ – New Jersey
NM – New Mexico
NV – Nevada
NY – New York
OH – Ohio
OK – Oklahoma
OR – Oregon
PA – Pennsylvania
RI – Rhode Island
SC – South Carolina
SD – South Dakota
TN – Tennessee
TX – Texas
UT – Utah
VA – Virginia
VT – Vermont
WA – Washington
WI – Wisconsin
WV – West Virginia
WY – Wyoming
http://www.ahd.com/states
DRG143
| Chapter 4 – Process Analysis Tools | |||
| Problems 4.2 and 4.4 | |||
| DRG 143: Chest Pain 2005 | |||
| Length | Average | ||
| Hospital Name | Cases | of Stay | Charge |
| Abington Memorial | 1293 | 1.5 | $23,308 |
| Albert Einstein | 845 | 1.5 | $20,960 |
| Aliquippa Community | 31 | 1.9 | $7,700 |
| Allegheny General | 237 | 1.6 | $11,481 |
| Alle-Kiski | 242 | 1.7 | $10,276 |
| Altoona Regional | 147 | 1.7 | $8,943 |
| Armstrong County Memorial | 42 | 1.7 | $3,967 |
| Ashland Regional | 23 | 1.4 | $5,369 |
| Barnes Kasson County | 52 | 1.7 | $3,475 |
| Berwick | 92 | 2.1 | $9,430 |
| Bon Secours | 115 | 1.7 | $4,969 |
| Bradford Regional | 35 | 1.7 | $4,828 |
| Brandywine | 319 | 1.6 | $29,045 |
| Brookville | 34 | 2.1 | $4,168 |
| Butler Memorial | 102 | 1.6 | $7,010 |
| Canonsburg General | 88 | 2.2 | $11,914 |
| Carlisle Regional | 170 | 1.7 | $11,108 |
| Central Montgomery | 183 | 1.5 | $18,349 |
| Chambersburg | 274 | 1.8 | $10,151 |
| Charles Cole Memorial | 45 | 2 | $5,884 |
| Chester County | 434 | 1.7 | $9,195 |
| Clarion | 61 | 1.3 | $4,110 |
| Clearfield | 35 | 2.3 | $6,337 |
| Community/Scranton | 661 | 1.5 | $9,945 |
| Conemaugh Valley Memorial | 328 | 1.9 | $8,051 |
| Corry Memorial | 27 | 1.4 | $3,452 |
| Crozer-Chester | 647 | 1.5 | $26,164 |
| Delaware County Memorial | 578 | 1.9 | $29,423 |
| Doylestown | 317 | 1.4 | $13,732 |
| DuBois Regional | 37 | 1.3 | $7,624 |
| Easton | 518 | 1.5 | $12,392 |
| Elk Regional | 59 | 1.5 | $6,957 |
| Ellwood City | 33 | 2.2 | $4,535 |
| Ephrata Community | 136 | 1.9 | $7,659 |
| Evangelical Community | 154 | 1.3 | $4,583 |
| Frankford | 1717 | 2.1 | $14,417 |
| Frick | 128 | 1.8 | $6,678 |
| Fulton County | 57 | 1.9 | $5,205 |
| Geisinger Wyoming Valley | 110 | 1.6 | $12,786 |
| Geisinger/Danville | 86 | 1.2 | $11,327 |
| Gettysburg | 94 | 1.5 | $6,598 |
| Gnaden Huetten Memorial | 61 | 1.5 | $4,151 |
| Good Samaritan Regional | 177 | 1.9 | $5,362 |
| Good Samaritan/Lebanon | 223 | 1.6 | $7,703 |
| Graduate | 251 | 1.3 | $24,129 |
| Grand View | 384 | 1.7 | $18,579 |
| Hahnemann University | 476 | 2 | $35,185 |
| Hamot | 349 | 1.6 | $10,772 |
| Hanover | 41 | 2.2 | $7,692 |
| Hazleton General | 80 | 2 | $10,661 |
| Heart of Lancaster | 59 | 1.5 | $9,855 |
| Highlands | 33 | 1.6 | $4,299 |
| Holy Redeemer | 407 | 1.3 | $23,159 |
| Holy Spirit | 312 | 1.7 | $10,138 |
| Hospital Fox Chase Cancer | 5 | 1.5 | $5,175 |
| Hospital University PA | 750 | 1.3 | $15,813 |
| Indiana Regional | 164 | 2 | $7,803 |
| J C Blair Memorial | 70 | 1.9 | $5,157 |
| Jameson Memorial | 269 | 1.4 | $5,496 |
| Jeanes | 415 | 1.7 | $30,362 |
| Jefferson Regional | 186 | 1.9 | $6,311 |
| Jennersville Regional | 264 | 1.7 | $17,917 |
| Jersey Shore | 34 | 1.6 | $4,761 |
| Kane Community | 31 | 1.7 | $4,117 |
| Lancaster General | 541 | 1.8 | $8,994 |
| Lancaster Regional | 193 | 1.7 | $10,898 |
| Latrobe Area | 227 | 1.5 | $6,368 |
| Lehigh Valley | 995 | 1.6 | $12,827 |
| Lehigh Valley/Muhlenberg | 398 | 1.6 | $14,430 |
| Lewistown | 348 | 1.8 | $5,964 |
| Main Line Bryn Mawr | 474 | 1.7 | $18,635 |
| Main Line Lankenau | 818 | 1.5 | $16,053 |
| Main Line Paoli | 304 | 1.3 | $16,627 |
| Marian Community | 141 | 1.9 | $6,157 |
| Meadville | 111 | 1.6 | $5,633 |
| Medical Center Beaver | 286 | 1.9 | $6,849 |
| Memorial York | 133 | 1.7 | $8,039 |
| Memorial/Towanda | 40 | 1.6 | $6,060 |
| Mercy Fitzgerald | 728 | 1.4 | $20,029 |
| Mercy Jeannette | 70 | 1.8 | $8,584 |
| Mercy Philadelphia | 647 | 1.4 | $15,712 |
| Mercy Pittsburgh | 386 | 1.6 | $11,259 |
| Mercy Suburban | 389 | 1.6 | $18,742 |
| Mercy/Scranton | 445 | 1.6 | $9,975 |
| Methodist Division/TJUH | 616 | 2 | $17,326 |
| Mid-Valley | 11 | 1.2 | $6,624 |
| Millcreek Community | 26 | 2.1 | $7,988 |
| Milton S Hershey | 57 | 1.3 | $7,618 |
| Miners | 9 | 1.6 | $8,107 |
| Monongahela Valley | 107 | 2.4 | $8,859 |
| Montgomery | 483 | 1.8 | $10,779 |
| Montrose General | 45 | 1.7 | $2,611 |
| Moses Taylor | 165 | 1.6 | $9,310 |
| Mount Nittany | 168 | 1.7 | $6,474 |
| Muncy Valley | 17 | 1.4 | $3,126 |
| Nason | 56 | 1.6 | $3,360 |
| Nazareth | 558 | 1.9 | $25,577 |
| Ohio Valley General | 163 | 1.6 | $6,722 |
| Palmerton | 39 | 1.8 | $5,648 |
| Pennsylvania | 290 | 1.6 | $18,237 |
| Phoenixville | 282 | 1.3 | $10,422 |
| Pinnacle Health | 466 | 1.7 | $10,191 |
| Pocono | 656 | 1.4 | $10,899 |
| Pottstown Memorial | 281 | 1.4 | $10,935 |
| Pottsville Warne Clinic | 197 | 1.7 | $4,188 |
| Punxsutawney Area | 44 | 1.6 | $3,480 |
| Reading | 132 | 1.8 | $6,995 |
| Riddle Memorial | 484 | 1.4 | $19,821 |
| Robert Packer | 150 | 1.5 | $7,528 |
| Roxborough Memorial | 292 | 1.7 | $8,646 |
| Sacred Heart/Allentown | 90 | 1.6 | $8,485 |
| Saint Vincent Health | 235 | 1.6 | $18,413 |
| Sewickley Valley | 113 | 2 | $7,482 |
| Shamokin Area Community | 68 | 1.7 | $3,542 |
| Sharon Regional | 331 | 1.7 | $8,391 |
| Soldiers & Sailors | 7 | 2 | $6,769 |
| Somerset Center Health | 64 | 2.3 | $6,668 |
| Southwest Regional MC | 25 | 1.4 | $3,993 |
| Springfield | 158 | 1.5 | $26,364 |
| St Clair Memorial | 182 | 1.9 | $8,207 |
| St Joseph/Reading | 97 | 1.3 | $8,216 |
| St Joseph’s/Philadelphia | 142 | 2.3 | $9,574 |
| St Luke’s Miners | 107 | 2.1 | $6,671 |
| St Luke’s Quakertown | 50 | 1.7 | $9,739 |
| St Luke’s/Bethlehem | 1219 | 1.6 | $7,349 |
| St Mary | 1169 | 1.6 | $12,035 |
| Sunbury Community | 154 | 1.6 | $6,603 |
| Taylor | 395 | 1.6 | $30,295 |
| Temple East | 694 | 1.9 | $16,049 |
| Temple Lower Bucks | 355 | 1.8 | $24,255 |
| Temple University | 1302 | 1.4 | $33,569 |
| Thomas Jefferson Univ | 680 | 1.6 | $19,559 |
| Titusville Area | 20 | 1.4 | $4,648 |
| Troy Community | 6 | 1.5 | $2,956 |
| Tyler Memorial | 62 | 1.7 | $5,832 |
| Tyrone | 47 | 1.7 | $3,374 |
| Uniontown | 297 | 1.7 | $4,372 |
| United Community | 16 | 1.2 | $8,887 |
| Univ PA/Presbyterian | 279 | 1.3 | $13,526 |
| UPMC Bedford | 51 | 1.5 | $5,428 |
| UPMC Braddock | 71 | 1.7 | $8,816 |
| UPMC Horizon | 53 | 1.7 | $6,747 |
| UPMC McKeesport | 282 | 1.7 | $9,286 |
| UPMC Northwest | 242 | 1.6 | $4,600 |
| UPMC Passavant | 187 | 1.7 | $11,164 |
| UPMC Presby Shadyside | 342 | 2 | $16,114 |
| UPMC South Side | 42 | 2.2 | $13,054 |
| UPMC St Margaret | 131 | 1.6 | $11,229 |
| Warren General | 26 | 1.9 | $6,914 |
| Washington | 320 | 1.8 | $7,499 |
| Wayne Memorial | 50 | 1.6 | $6,193 |
| Waynesboro | 22 | 1.7 | $9,862 |
| Western PA Hosp/Forbes | 257 | 1.7 | $9,026 |
| Western Pennsylvania | 192 | 2 | $13,599 |
| Westmoreland Regional | 207 | 1.4 | $6,823 |
| Williamsport | 139 | 1.6 | $7,790 |
| Windber | 19 | 1.5 | $9,275 |
| WVHCS | 224 | 1.6 | $7,981 |
| York | 312 | 1.4 | $6,009 |
Patient Falls
| Chapter 4 – Process Analysis Tools | ||||||
| Problems 4.5 and 4.7 | ||||||
| Day | Week | Date | Patient Age | Medication | Location | Shift |
| 1 | 1 | Thursday, January 01, 2009 | 59 | Heavy | 2N-Med | 1 |
| 1 | 1 | Thursday, January 01, 2009 | 102 | Heavy | 2N-Med | 2 |
| 1 | 1 | Thursday, January 01, 2009 | 37 | Heavy | 3S-Surg | 2 |
| 2 | 1 | Friday, January 02, 2009 | 68 | Moderate | 3N-Surg | 3 |
| 2 | 1 | Friday, January 02, 2009 | 83 | Light | 2S-Med | 1 |
| 3 | 1 | Saturday, January 03, 2009 | 56 | Heavy | Clinic | 1 |
| 3 | 1 | Saturday, January 03, 2009 | 20 | Heavy | 3N-Surg | 2 |
| 4 | 1 | Sunday, January 04, 2009 | 104 | Moderate | ER | 3 |
| 4 | 1 | Sunday, January 04, 2009 | 49 | Moderate | 2N-Med | 1 |
| 4 | 1 | Sunday, January 04, 2009 | 24 | Light | Clinic | 2 |
| 4 | 1 | Sunday, January 04, 2009 | 83 | Heavy | 2N-Med | 2 |
| 5 | 1 | Monday, January 05, 2009 | 40 | Heavy | 2N-Med | 3 |
| 5 | 1 | Monday, January 05, 2009 | 69 | Moderate | 3S-Surg | 1 |
| 5 | 1 | Monday, January 05, 2009 | 77 | Moderate | 3N-Surg | 2 |
| 6 | 1 | Tuesday, January 06, 2009 | 88 | Light | 2S-Med | 2 |
| 6 | 1 | Tuesday, January 06, 2009 | 71 | Heavy | 2N-Med | 3 |
| 7 | 1 | Wednesday, January 07, 2009 | 101 | Heavy | 2N-Med | 1 |
| 8 | 2 | Thursday, January 08, 2009 | 62 | Moderate | 3S-Surg | 2 |
| 8 | 2 | Thursday, January 08, 2009 | 72 | Moderate | 3N-Surg | 2 |
| 9 | 2 | Friday, January 09, 2009 | 24 | Light | 2N-Med | 3 |
| 9 | 2 | Friday, January 09, 2009 | 85 | Heavy | 2N-Med | 1 |
| 9 | 2 | Friday, January 09, 2009 | 56 | Heavy | 3S-Surg | 1 |
| 9 | 2 | Friday, January 09, 2009 | 41 | Heavy | 3N-Surg | 2 |
| 10 | 2 | Saturday, January 10, 2009 | 80 | Moderate | 2S-Med | 3 |
| 10 | 2 | Saturday, January 10, 2009 | 60 | Light | Clinic | 1 |
| 11 | 2 | Sunday, January 11, 2009 | 45 | Heavy | 3N-Surg | 2 |
| 12 | 2 | Monday, January 12, 2009 | 14 | Heavy | Peds | 2 |
| 14 | 2 | Wednesday, January 14, 2009 | 66 | Moderate | 2S-Med | 3 |
| 14 | 2 | Wednesday, January 14, 2009 | 32 | Moderate | 2N-Med | 1 |
| 15 | 3 | Thursday, January 15, 2009 | 64 | Light | Clinic | 2 |
| 15 | 3 | Thursday, January 15, 2009 | 75 | Heavy | 3S-Surg | 2 |
| 15 | 3 | Thursday, January 15, 2009 | 13 | Heavy | Peds | 3 |
| 15 | 3 | Thursday, January 15, 2009 | 104 | Moderate | 2N-Med | 1 |
| 16 | 3 | Friday, January 16, 2009 | 69 | Moderate | 2N-Med | 2 |
| 16 | 3 | Friday, January 16, 2009 | 79 | Light | 3S-Surg | 2 |
| 18 | 3 | Sunday, January 18, 2009 | 106 | Heavy | 3N-Surg | 3 |
| 19 | 3 | Monday, January 19, 2009 | 57 | Heavy | 2S-Med | 2 |
| 19 | 3 | Monday, January 19, 2009 | 80 | Moderate | 2N-Med | 1 |
| 19 | 3 | Monday, January 19, 2009 | 16 | Moderate | 2N-Med | 2 |
| 20 | 3 | Tuesday, January 20, 2009 | 81 | Light | 3S-Surg | 3 |
| 20 | 3 | Tuesday, January 20, 2009 | 59 | Heavy | 3N-Surg | 1 |
| 21 | 3 | Wednesday, January 21, 2009 | 52 | Heavy | 2S-Med | 2 |
| 21 | 3 | Wednesday, January 21, 2009 | 96 | Heavy | 2N-Med | 2 |
| 21 | 3 | Wednesday, January 21, 2009 | 81 | Moderate | 3S-Surg | 3 |
| 22 | 4 | Thursday, January 22, 2009 | 103 | Light | 3N-Surg | 1 |
| 23 | 4 | Friday, January 23, 2009 | 75 | Heavy | 2S-Med | 2 |
| 24 | 4 | Saturday, January 24, 2009 | 49 | Heavy | 2N-Med | 2 |
| 26 | 4 | Monday, January 26, 2009 | 100 | Moderate | 2N-Med | 3 |
| 27 | 4 | Tuesday, January 27, 2009 | 19 | Moderate | 3S-Surg | 1 |
| 27 | 4 | Tuesday, January 27, 2009 | 83 | Light | 3N-Surg | 2 |
| 28 | 4 | Wednesday, January 28, 2009 | 58 | Heavy | 2S-Med | 2 |
| 28 | 4 | Wednesday, January 28, 2009 | 51 | Heavy | 2N-Med | 3 |
| 29 | 5 | Thursday, January 29, 2009 | 59 | Moderate | 3S-Surg | 1 |
| 30 | 5 | Friday, January 30, 2009 | 89 | Moderate | 3N-Surg | 1 |
| 30 | 5 | Friday, January 30, 2009 | 30 | Light | 2S-Med | 2 |
| 30 | 5 | Friday, January 30, 2009 | 19 | Heavy | 2N-Med | 3 |
| 31 | 5 | Saturday, January 31, 2009 | 49 | Heavy | 2N-Med | 1 |
| 32 | 5 | Sunday, February 01, 2009 | 34 | Moderate | 3S-Surg | 2 |
| 32 | 5 | Sunday, February 01, 2009 | 96 | Moderate | 3N-Surg | 2 |
| 33 | 5 | Monday, February 02, 2009 | 28 | Light | 2S-Med | 3 |
| 34 | 5 | Tuesday, February 03, 2009 | 77 | Heavy | 3N-Surg | 1 |
| 35 | 5 | Wednesday, February 04, 2009 | 47 | Heavy | 3S-Surg | 2 |
| 36 | 6 | Thursday, February 05, 2009 | 24 | Heavy | 2N-Med | 2 |
| 37 | 6 | Friday, February 06, 2009 | 69 | Moderate | 2N-Med | 3 |
| 38 | 6 | Saturday, February 07, 2009 | 16 | Light | Peds | 1 |
| 40 | 6 | Monday, February 09, 2009 | 29 | Heavy | 2S-Med | 2 |
| 41 | 6 | Tuesday, February 10, 2009 | 100 | Heavy | 2S-Med | 2 |
| 41 | 6 | Tuesday, February 10, 2009 | 78 | Moderate | 3N-Surg | 3 |
| 42 | 6 | Wednesday, February 11, 2009 | 43 | Moderate | 2N-Med | 1 |
| 43 | 7 | Thursday, February 12, 2009 | 65 | Light | Clinic | 1 |
| 44 | 7 | Friday, February 13, 2009 | 54 | Moderate | 2N-Med | 2 |
| 44 | 7 | Friday, February 13, 2009 | 97 | Heavy | 3S-Surg | 3 |
| 44 | 7 | Friday, February 13, 2009 | 27 | Moderate | 3N-Surg | 1 |
| 45 | 7 | Saturday, February 14, 2009 | 62 | Moderate | 2S-Med | 2 |
| 45 | 7 | Saturday, February 14, 2009 | 25 | Light | 2N-Med | 2 |
| 46 | 7 | Sunday, February 15, 2009 | 76 | Heavy | 2N-Med | 3 |
| 46 | 7 | Sunday, February 15, 2009 | 84 | Heavy | 3S-Surg | 1 |
| 47 | 7 | Monday, February 16, 2009 | 67 | Moderate | 3N-Surg | 2 |
| 48 | 7 | Tuesday, February 17, 2009 | 55 | Moderate | 2S-Med | 2 |
| 49 | 7 | Wednesday, February 18, 2009 | 48 | Light | 3S-Surg | 3 |
| 52 | 8 | Saturday, February 21, 2009 | 103 | Moderate | 3N-Surg | 1 |
| 53 | 8 | Sunday, February 22, 2009 | 101 | Moderate | 2N-Med | 2 |
| 54 | 8 | Monday, February 23, 2009 | 29 | Light | 3S-Surg | 2 |
| 55 | 8 | Tuesday, February 24, 2009 | 28 | Heavy | 3N-Surg | 3 |
| 55 | 8 | Tuesday, February 24, 2009 | 63 | Heavy | 2S-Med | 1 |
| 56 | 8 | Wednesday, February 25, 2009 | 27 | Heavy | 2N-Med | 1 |
| 57 | 9 | Thursday, February 26, 2009 | 50 | Moderate | 2N-Med | 2 |
| 58 | 9 | Friday, February 27, 2009 | 37 | Light | 3S-Surg | 3 |
| 60 | 9 | Sunday, March 01, 2009 | 97 | Heavy | 3N-Surg | 1 |
| 61 | 9 | Monday, March 02, 2009 | 20 | Heavy | 2S-Med | 2 |
| 62 | 9 | Tuesday, March 03, 2009 | 16 | Moderate | 2N-Med | 2 |
| 63 | 9 | Wednesday, March 04, 2009 | 79 | Moderate | 2S-Med | 3 |
| 63 | 9 | Wednesday, March 04, 2009 | 31 | Light | Clinic | 1 |
| 64 | 10 | Thursday, March 05, 2009 | 74 | Moderate | 2N-Med | 2 |
| 66 | 10 | Saturday, March 07, 2009 | 16 | Heavy | Peds | 2 |
| 67 | 10 | Sunday, March 08, 2009 | 38 | Moderate | 2N-Med | 3 |
| 69 | 10 | Tuesday, March 10, 2009 | 83 | Moderate | 3S-Surg | 1 |
| 70 | 10 | Wednesday, March 11, 2009 | 77 | Light | 3N-Surg | 2 |
| 71 | 11 | Thursday, March 12, 2009 | 77 | Heavy | 2S-Med | 2 |
| 72 | 11 | Friday, March 13, 2009 | 87 | Heavy | 2N-Med | 3 |
| 72 | 11 | Friday, March 13, 2009 | 74 | Moderate | 2N-Med | 2 |
| 73 | 11 | Saturday, March 14, 2009 | 92 | Moderate | 3S-Surg | 1 |
| 75 | 11 | Monday, March 16, 2009 | 39 | Light | 3N-Surg | 2 |
| 76 | 11 | Tuesday, March 17, 2009 | 64 | Moderate | 2S-Med | 3 |
| 77 | 11 | Wednesday, March 18, 2009 | 94 | Moderate | 2N-Med | 1 |
| 78 | 12 | Thursday, March 19, 2009 | 49 | Light | 3S-Surg | 2 |
| 79 | 12 | Friday, March 20, 2009 | 22 | Heavy | 3N-Surg | 2 |
| 81 | 12 | Sunday, March 22, 2009 | 42 | Heavy | 2S-Med | 3 |
| 82 | 12 | Monday, March 23, 2009 | 104 | Heavy | 2N-Med | 1 |
| 83 | 12 | Tuesday, March 24, 2009 | 23 | Moderate | 2N-Med | 2 |
| 84 | 12 | Wednesday, March 25, 2009 | 73 | Light | 3S-Surg | 2 |
| 84 | 12 | Wednesday, March 25, 2009 | 89 | Heavy | 3N-Surg | 3 |
| 85 | 13 | Thursday, March 26, 2009 | 76 | Heavy | 2S-Med | 1 |
| 86 | 13 | Friday, March 27, 2009 | 89 | Moderate | 2S-Med | 2 |
| 87 | 13 | Saturday, March 28, 2009 | 18 | Moderate | 2N-Med | 2 |
| 88 | 13 | Sunday, March 29, 2009 | 14 | Light | Peds | 3 |
| 89 | 13 | Monday, March 30, 2009 | 25 | Moderate | 3N-Surg | 1 |
| 90 | 13 | Tuesday, March 31, 2009 | 65 | Heavy | 3S-Surg | 1 |
Transport Log
| Chapter 4 – Process Analysis Tools | |||||
| Problem 4.6 | |||||
| Patient | Appt Time | Arrival Time | Transporter | Unit | Day |
| 1 | 8:15 | 8:25 | A | Med 2S | M |
| 2 | 10:00 | 10:00 | A | Psych | M |
| 3 | 4:30 | 4:45 | B | Surg 3N | M |
| 4 | 11:00 | 11:10 | B | Med 2N | M |
| 5 | 8:45 | 8:45 | C | OB | M |
| 6 | 8:15 | 8:15 | C | Med 2S | M |
| 7 | 10:00 | 10:00 | D | Psych | M |
| 8 | 4:30 | 4:30 | D | Surg 3N | M |
| 9 | 1:45 | 1:45 | E | Peds | M |
| 10 | 2:15 | 2:15 | E | Surg 3S | M |
| 11 | 9:00 | 9:00 | A | Med 2N | T |
| 12 | 11:55 | 11:55 | A | OB | T |
| 13 | 8:00 | 8:00 | B | Peds | T |
| 14 | 1:45 | 1:50 | B | Surg 3S | T |
| 15 | 2:15 | 2:20 | C | Med 2S | T |
| 16 | 9:00 | 9:00 | C | Med 2N | T |
| 17 | 11:55 | 11:55 | D | OB | T |
| 18 | 8:00 | 8:15 | D | OB | T |
| 19 | 10:30 | 10:35 | E | Psych | T |
| 20 | 3:00 | 3:00 | E | Psych | T |
| 21 | 8:00 | 8:00 | A | Surg 3S | W |
| 22 | 1:15 | 1:15 | A | Med 2S | W |
| 23 | 2:15 | 2:30 | B | Psych | W |
| 24 | 10:30 | 10:30 | B | Surg 3N | W |
| 25 | 3:00 | 3:00 | C | Med 2N | W |
| 26 | 8:00 | 8:00 | C | Surg 3S | W |
| 27 | 1:15 | 1:15 | D | Med 2S | W |
| 28 | 2:15 | 2:30 | D | Med 2S | W |
| 29 | 11:45 | 11:45 | E | OB | W |
| 30 | 4:30 | 4:30 | E | OB | W |
| 31 | 8:30 | 8:30 | A | Surg 3N | Th |
| 32 | 3:00 | 3:00 | A | Med 2N | Th |
| 33 | 2:45 | 3:00 | B | OB | Th |
| 34 | 11:45 | 11:45 | B | Peds | Th |
| 35 | 4:30 | 4:30 | C | Surg 3S | Th |
| 36 | 8:30 | 8:30 | C | Surg 3N | Th |
| 37 | 3:00 | 3:05 | D | Med 2N | Th |
| 38 | 2:45 | 2:45 | D | Med 2N | Th |
| 39 | 8:00 | 8:00 | E | Med 2S | Th |
| 40 | 11:00 | 11:00 | E | Med 2S | Th |
| 41 | 9:15 | 9:15 | A | Peds | F |
| 42 | 2:30 | 2:30 | A | Surg 3S | F |
| 43 | 3:30 | 3:30 | B | Med 2S | F |
| 44 | 8:00 | 8:00 | B | Psych | F |
| 45 | 11:00 | 11:10 | C | Surg 3N | F |
| 46 | 9:15 | 9:15 | C | Peds | F |
| 47 | 2:30 | 2:30 | D | Surg 3S | F |
| 48 | 3:30 | 3:30 | D | Surg 3S | F |
| 49 | 11:00 | 11:00 | E | Surg 3N | F |
| 50 | 8:45 | 8:45 | E | Med 2N | F |
