operations management

profileNevaeh
Assignmnet2-Data.xlsx

Air Traffic Data

Year Month Passengers
Year 1 January 13,441,718
Year 1 February 11,942,221
Year 1 March 14,670,996
Year 1 April 14,286,844
Year 1 May 14,537,314
Year 1 June 15,906,101
Year 1 July 17,362,586
Year 1 August 16,969,528
Year 1 September 14,010,920
Year 1 October 13,599,030
Year 1 November 12,919,746
Year 1 December 14,289,105
Year 2 January 13,970,077
Year 2 February 12,230,963
Year 2 March 15,447,435
Year 2 April 14,507,038
Year 2 May 15,516,063
Year 2 June 16,487,702
Year 2 July 17,954,910
Year 2 August 17,786,357
Year 2 September 14,408,817
Year 2 October 14,374,254
Year 2 November 13,258,104
Year 2 December 15,182,616

Emergency Department Data

Shift
Week Day of Week 12 AM - 06 AM 06 AM - 12 PM 12 PM - 06 PM 12 PM - 12 AM
1 Monday 53 74 85 53
1 Tuesday 52 70 86 52
1 Wednesday 46 66 87 56
1 Thursday 52 73 84 52
1 Friday 53 77 82 53
1 Saturday 46 62 70 42
1 Sunday 51 77 77 51
2 Monday 58 81 93 58
2 Tuesday 45 70 80 55
2 Wednesday 44 67 67 44
2 Thursday 48 62 76 44
2 Friday 51 79 96 56
2 Saturday 42 59 68 42
2 Sunday 47 60 69 39
3 Monday 56 78 81 64
3 Tuesday 52 76 84 50
3 Wednesday 46 64 74 46
3 Thursday 46 65 72 58
3 Friday 54 76 87 54
3 Saturday 47 65 74 38
3 Sunday 46 64 73 46