excel problems

profilejonas502166
case_11.2_3.xlsx
Home>Mathematics homework help>excel problems

Sunday Shift

Time Base Demand Sunday Demand Variation Adjusted Demand
Shift 1
0000 11 -9% 10.01
0100 8 -9% 7.28
0200 8 -9% 7.28
0300 3 -9% 2.73 Max Hourly Number Of Operations Recommended ATC Workers For Shift 1
0400 3 -9% 2.73 18.2 2
0500 13 -9% 11.83
0600 13 -9% 11.83
0700 20 -9% 18.2
Shift 2
0800 29 -9% 26.39
0900 34 -9% 30.94
1000 44 -9% 40.04
1100 47 -9% 42.77 Max Hourly Number Of Operations Recommended ATC Workers For Shift 2 Total ATC Workers For Sunday
1200 34 -9% 30.94 42.77 3 9
1300 38 -9% 34.58
1400 44 -9% 40.04
1500 43 -9% 39.13
Shift 3
1600 42 -9% 38.22
1700 51 -9% 46.41
1800 57 -9% 51.87
1900 65 -9% 59.15 Max Hourly Number of Operations Recommended ATC Workers For Shift 2
2000 35 -9% 31.85 59.15 4
2100 26 -9% 23.66
2200 19 -9% 17.29
2300 19 -9% 17.29

Monday Shift

Time Base Demand Monday Demand Variation Adjusted Demand
Shift 1
0000 11 -2% 10.78
0100 8 -2% 7.84
0200 8 -2% 7.84
0300 3 -2% 2.94 Max Hourly Number Of Operations Recommended ATC Workers For Shift 1
0400 3 -2% 2.94 19.6 2
0500 13 -2% 12.74
0600 13 -2% 12.74
0700 20 -2% 19.6
Shift 2
0800 29 -2% 28.42
0900 34 -2% 33.32
1000 44 -2% 43.12
1100 47 -2% 46.06 Max Hourly Number Of Operations Recommended ATC Workers For Shift 2 Total ATC Workers For Monday
1200 34 -2% 33.32 46.06 3 9
1300 38 -2% 37.24
1400 44 -2% 43.12
1500 43 -2% 42.14
Shift 3
1600 42 -2% 41.16
1700 51 -2% 49.98
1800 57 -2% 55.86
1900 65 -2% 63.7 Max Hourly Number Of Operations Recommended ATC Workers For Shift 3
2000 35 -2% 34.3 63.7 4
2100 26 -2% 25.48
2200 19 -2% 18.62
2300 19 -2% 18.62

Tuesday Shift

Time Base Demand Tuesday Demand Variation Adjusted Demand
Shift 1
0000 11 4% 11.44
0100 8 4% 8.32
0200 8 4% 8.32
0300 3 4% 3.12 Max Hourly Number Of Operations Recommended ATC Workers For Shift 1
0400 3 4% 3.12 20.8 2
0500 13 4% 13.52
0600 13 4% 13.52
0700 20 4% 20.8
Shift 2
0800 29 4% 30.16
0900 34 4% 35.36
1000 44 4% 45.76
1100 47 4% 48.88 Max Hourly Number Of Operations Recommended ATC Workers For Shift 2 Total ATC Workers For Tuesday
1200 34 4% 35.36 48.88 4 11
1300 38 4% 39.52
1400 44 4% 45.76
1500 43 4% 44.72
Shift 3
1600 42 4% 43.68
1700 51 4% 53.04
1800 57 4% 59.28
1900 65 4% 67.6 Max Houtly Number Of Operations Recommended ATC Workers For Shift 3
2000 35 4% 36.4 67.6 5
2100 26 4% 27.04
2200 19 4% 19.76
2300 19 4% 19.76

Wednesday Shift

Time Base Demand Wednesday Demand Variation Adjusted Demand
Shift 1
0000 11 -17% 9.13
0100 8 -17% 6.64
0200 8 -17% 6.64
0300 3 -17% 2.49 Max Hourly Number Of Operations Recommended ATC Workers For Shift 1
0400 3 -17% 2.49 16.6 2
0500 13 -17% 10.79
0600 13 -17% 10.79
0700 20 -17% 16.6
Shift 2
0800 29 -17% 24.07
0900 34 -17% 28.22
1000 44 -17% 36.52
1100 47 -17% 39.01 Max Hourly Number Of Operations Recommended ATC Workers For Shift 2 Total ATC Workers For Wednesday
1200 34 -17% 28.22 39.01 3 9
1300 38 -17% 31.54
1400 44 -17% 36.52
1500 43 -17% 35.69
Shift 3
1600 42 -17% 34.86
1700 51 -17% 42.33
1800 57 -17% 47.31
1900 65 -17% 53.95 Max Hourly Number Of Operations Recommended ATC Workers For Shift 3
2000 35 -17% 29.05 53.95 4
2100 26 -17% 21.58
2200 19 -17% 15.77
2300 19 -17% 15.77

Thursday Shift

Time Base Demand Thursday Demand Variation Adjusted Demand
Shift 1
0000 11 -11% 9.79
0100 8 -11% 7.12
0200 8 -11% 7.12
0300 3 -11% 2.67 Max Hourly Number Of Operations Recommended ATC Workers For Shift 1
0400 3 -11% 2.67 17.8 2
0500 13 -11% 11.57
0600 13 -11% 11.57
0700 20 -11% 17.8
Shift 2
0800 29 -11% 25.81
0900 34 -11% 30.26
1000 44 -11% 39.16
1100 47 -11% 41.83 Max Hourly Number Of Operations Recommended ATC Workers For Shift 2 Total ATC Workers For Thursday
1200 34 -11% 30.26 41.83 3 9
1300 38 -11% 33.82
1400 44 -11% 39.16
1500 43 -11% 38.27
Shift 3
1600 42 -11% 37.38
1700 51 -11% 45.39
1800 57 -11% 50.73
1900 65 -11% 57.85 Max Hourly Number Of Operations Recommended ATC Workers For Shift 3
2000 35 -11% 31.15 57.85 4
2100 26 -11% 23.14
2200 19 -11% 16.91
2300 19 -11% 16.91

Friday Shift

Time Base Demand Friday Demand Variation Adjusted Demand
Shift 1
0000 11 -17% 9.13
0100 8 -17% 6.64
0200 8 -17% 6.64
0300 3 -17% 2.49 Max Hourly Number Of Operations Recommended ATC Workers For Shift 1
0400 3 -17% 2.49 16.6 2
0500 13 -17% 10.79
0600 13 -17% 10.79
0700 20 -17% 16.6
Shift 2
0800 29 -17% 24.07
0900 34 -17% 28.22
1000 44 -17% 36.52
1100 47 -17% 39.01 Max Hourly Number Of Operations Recommended ATC Workers For Shift 2 Total ATC Workers For Friday
1200 34 -17% 28.22 39.01 3 9
1300 38 -17% 31.54
1400 44 -17% 36.52
1500 43 -17% 35.69
Shift 3
1600 42 -17% 34.86
1700 51 -17% 42.33
1800 57 -17% 47.31
1900 65 -17% 53.95 Max Hourly Number Of Operations Recommended ATC Workers For Shift 3
2000 35 -17% 29.05 53.95 4
2100 26 -17% 21.58
2200 19 -17% 15.77
2300 19 -17% 15.77

Saturday Shift

Time Base Demand Saturday Demand Variation Adjusted Demand
Shift 1
0000 11 -6% 10.34
0100 8 -6% 7.52
0200 8 -6% 7.52
0300 3 -6% 2.82 Max Number Of Operations Recommended ATC Wokers For Shift 1
0400 3 -6% 2.82 18.8 2
0500 13 -6% 12.22
0600 13 -6% 12.22
0700 20 -6% 18.8
Shift 2
0800 29 -6% 27.26
0900 34 -6% 31.96
1000 44 -6% 41.36
1100 47 -6% 44.18 Max Number Of Operations Recommended ATC Workers For Shift 2 Total ATC Workers For Saturday
1200 34 -6% 31.96 44.18 3 9
1300 38 -6% 35.72
1400 44 -6% 41.36
1500 43 -6% 40.42
Shift 3
1600 42 -6% 39.48
1700 51 -6% 47.94
1800 57 -6% 53.58
1900 65 -6% 61.1 Max Number Of Operations Recommended ATC Workers For Shift 3
2000 35 -6% 32.9 61.1 4
2100 26 -6% 24.44
2200 19 -6% 17.86
2300 19 -6% 17.86

Weekly Schedule

Shift (0000-07000) ATC Assigned To This Shift Day Of Week ATC Workers Required Actual Number Of ATC Scheduled
Sunday To Thursday 2 Sunday 10 10
Monday To Friday 2 Monday 10 10
Tuesday To Saturday 2 Tuesday 10 10
Wednesday To Sunday 2 Wednesday 10 10
Thursday To Monday 2 Thursday 10 10
Friday To Tuesday 2 Friday 10 10
Saturday To Wednesday 2 Saturday 10 10
Total ATC Assigned 14
Shift (0800-1500) ATC Assigned To This Shift Day Of Week ATC Workers Required Actual Number Of ATC Scheduled
Sunday To Thursday 3 Sunday 16 16
Monday To Friday 3 Monday 16 16
Tuesday To Saturday 3 Tuesday 16 16
Wednesday To Sunday 3 Wednesday 15 15
Thursday To Monday 3 Thursday 15 15
Friday To Tuesday 4 Friday 16 16
Saturday To Wednesday 3 Saturday 16 16
Total ATC Assigned 22
Shift (1600-2300) ATC Assigned To This Shift Day Of Week ATC Workers Required Actual Number Of ATC Scheduled
Sunday To Thursday 4 Sunday 21 21
Monday To Friday 4 Monday 21 21
Tuesday To Saturday 4 Tuesday 21 21
Wednesday To Sunday 4 Wednesday 20 20
Thursday To Monday 4 Thursday 20 20
Friday To Tuesday 5 Friday 21 21
Saturday To Wednesday 4 Saturday 21 21
Total ATC Assigned 29