Scribd Logo
Upload

Welcome to Scribd!

  • 12 views

    Sheetforexcercise

    Uploaded by

    sameer231u
    The document shows tables with the number of beds in hospitals along the top row and the corresponding number of employees required in different hospital roles down the left column. As the number of beds increases from 100 to 3000, the number of nurses, doctors, and other staff such as assistants, support staff, and cleaning staff increases proportionally.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Sheetforexcercise

    Uploaded by

    sameer231u
    12 views4 pages
    The document shows tables with the number of beds in hospitals along the top row and the corresponding number of employees required in different hospital roles down the left column. As the number of beds increases from 100 to 3000, the number of nurses, doctors, and other staff such as assistants, support staff, and cleaning staff increases proportionally.

    Original Title

    sheetforexcercise(1)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document shows tables with the number of beds in hospitals along the top row and the corresponding number of employees required in different hospital roles down the left column. As the number of beds increases from 100 to 3000, the number of nurses, doctors, and other staff such as assistants, support staff, and cleaning staff increases proportionally.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    12 views4 pages

    Sheetforexcercise

    Uploaded by

    sameer231u
    The document shows tables with the number of beds in hospitals along the top row and the corresponding number of employees required in different hospital roles down the left column. As the number of beds increases from 100 to 3000, the number of nurses, doctors, and other staff such as assistants, support staff, and cleaning staff increases proportionally.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 4

    Number of Employees R

    Shift), Shifts
    No of
    Beds
    Nurse Docto
    in
    s rs
    Hospit
    al
    100 125 5
    200 250 10
    300 375 15
    400 500 20
    500 625 25
    600 750 30
    700 875 35
    800 1000 40
    900 1125 45
    1000 1250 50
    1100 1375 55
    1200 1500 60
    1300 1625 65
    1400 1750 70
    1500 1875 75
    1600 2000 80
    1700 2125 85
    1800 2250 90
    1900 2375 95
    2000 2500 100
    2100 2625 105
    2200 2750 110
    2300 2875 115
    2400 3000 120
    2500 3125 125
    2600 3250 130
    2700 3375 135
    2800 3500 140
    2900 3625 145
    3000 3750 150
    mber of Employees Required (Per
    FTEs Required
    Shift), Shifts = 3

    Assist Assist
    Suppo Cleani Suppo Cleani
    ant Recep Nurse Docto ant Recep
    rt ng rt ng
    Docto tion s rs Docto tion
    Staff Staff Staff Staff
    rs rs
    12 456 25 6 375 15 36 1368 75 18
    24 912 50 12 750 30 72 2736 150 36
    36 1368 75 18 1125 45 108 4104 225 54
    48 1824 100 24 1500 60 144 5472 300 72
    60 2280 125 30 1875 75 180 6840 375 90
    72 2736 150 36 2250 90 216 8208 450 108
    84 3192 175 42 2625 105 252 9576 525 126
    96 3648 200 48 3000 120 288 10944 600 144
    108 4104 225 54 3375 135 324 12312 675 162
    120 4560 250 60 3750 150 360 13680 750 180
    132 5016 275 66 4125 165 396 15048 825 198
    144 5472 300 72 4500 180 432 16416 900 216
    156 5928 325 78 4875 Chart 195 Title 468 17784 975 234
    168 6384 350 84 5250 210 504 19152 1050 252
    12000
    180 6840 375 6000 90 5625 225 540 20520 1125 270
    192 7296 400 0 96 6000 240 576 21888 1200 288
    l
    i ta 200 400 600 800 000 200 400 600 800 000 200 400 600 800 00
    204 7752 425 sp102 6375 1 2551 1 6121 1 2232562 2 1275
    2 2 30 306
    Ho
    216 8208 450 ds in 108 6750 270 648 24624 1350 324
    B e
    228 8664 475of 114 7125 285 684 25992 1425 342
    No
    240 9120 500 120 7500 300 720 27360 1500 360
    Number of Employees Required (Per Shift), Shifts = 3
    252 9576 525 126 7875 315 756 28728 1575 378
    Column J
    264 10032 550 132 Column 8250
    K 330 792 30096 1650 396
    276 10488 575 138 Column 8625
    L 345 828 31464 1725 414
    Column M
    288 10944 600 144 Column 9000
    N
    360 864 32832 1800 432
    300 11400 625 150 9375 375 900 34200 1875 450
    312 11856 650 156 9750 390 936 35568 1950 468
    324 12312 675 162 10125 405 972 36936 2025 486
    336 12768 700 168 10500 420 1008 38304 2100 504
    348 13224 725 174 10875 435 1044 39672 2175 522
    360 13680 750 180 11250 450 1080 41040 2250 540

    You might also like