File Home Insert Page Layout Formulas Data Review View Help Share Comments LUI AutoSum Calibri > . > a Wrap Text General DI ITX IT 47 O HH 11 A A a-A- s X Cut X L6 Copy & Format Painter Clipboard == Fill Paste BIU Merge & Center 40 .000 Ideas $ -% Insert Delete Format Sensitivity Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Font Alignment Number Cells Editing Ideas Sensitivity D27 X fa Y A B C D E F G H 1 4 Shift Scheduled worker 5 1 680 62 7 3 Sun Mon Tues Wed Thur Fri Sat 0 0 1 1 1 1 1 3 1 0 0 1 1 1 1 3 1 1 0 0 1 1 1 6 1 1 1 0 0 1 1 0 1 1 1 1 0 0 1 7 1 1 1 1 1 0 0 2 0 1 1 1 1 1 0 12 =SUMPRODUCT(B5:B11,15:111) =SUMPRODUCT(C5:C11,15:111) -SUMPRODUCT(D5:011,15:1: =SUMPRODUCT(E5:E11,1 =SUMPRODUCT(F5:F11 =SUMPRODUCT(G5:G -SUMPRODUCT(H5:H 18 27 22 26 25 21 19 705 705 705 705 84 95 680 655 Total =SUMPRODUCT(15:J11 10 6 11 7 12 Available 13 Required 14 15 16 Best Case (+10%) 17 Worst case (-10%) 18 Realistic(+5%) 19 =ROUNDUP(B13*1.1,0) =ROUNDUP(C13*1.1,0) =ROUNDUP(D13*1.1,0) =ROUNDUP(E13*1.1,0) =ROUNDUP(F13*1.1,0) =ROUNDUP(G13*1.1,1 =ROUNDUP(H13*1.1, 20 21 22 Base Best Case Worest Case Realistic 23 3 5 4 Steps Please consder the following scenarios and provide your solutions by summarizing with a table and or a graph. and explain your solutions as a manager. Scenario (best): the number of parcels increased, so 10% increase of workers are needed. Scenario (worst): the number of parcels decreased, so 10% decrease of workers are needed. Scenario (realistic): the capacity should be increased by 5%. 24 3 1 1 7 6 25 6 26 O 0 0 2717 8 6 28 2 4 3 29 12 9 11 24605 19820 30 22540 31 32 Base Case + Ready + 1009 File Home Insert Page Layout Formulas Data Review View Help Share Comments LUI AutoSum Calibri > . > a Wrap Text General DI ITX IT 47 O HH 11 A A a-A- s X Cut X L6 Copy & Format Painter Clipboard == Fill Paste BIU Merge & Center 40 .000 Ideas $ -% Insert Delete Format Sensitivity Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Font Alignment Number Cells Editing Ideas Sensitivity D27 X fa Y A B C D E F G H 1 4 Shift Scheduled worker 5 1 680 62 7 3 Sun Mon Tues Wed Thur Fri Sat 0 0 1 1 1 1 1 3 1 0 0 1 1 1 1 3 1 1 0 0 1 1 1 6 1 1 1 0 0 1 1 0 1 1 1 1 0 0 1 7 1 1 1 1 1 0 0 2 0 1 1 1 1 1 0 12 =SUMPRODUCT(B5:B11,15:111) =SUMPRODUCT(C5:C11,15:111) -SUMPRODUCT(D5:011,15:1: =SUMPRODUCT(E5:E11,1 =SUMPRODUCT(F5:F11 =SUMPRODUCT(G5:G -SUMPRODUCT(H5:H 18 27 22 26 25 21 19 705 705 705 705 84 95 680 655 Total =SUMPRODUCT(15:J11 10 6 11 7 12 Available 13 Required 14 15 16 Best Case (+10%) 17 Worst case (-10%) 18 Realistic(+5%) 19 =ROUNDUP(B13*1.1,0) =ROUNDUP(C13*1.1,0) =ROUNDUP(D13*1.1,0) =ROUNDUP(E13*1.1,0) =ROUNDUP(F13*1.1,0) =ROUNDUP(G13*1.1,1 =ROUNDUP(H13*1.1, 20 21 22 Base Best Case Worest Case Realistic 23 3 5 4 Steps Please consder the following scenarios and provide your solutions by summarizing with a table and or a graph. and explain your solutions as a manager. Scenario (best): the number of parcels increased, so 10% increase of workers are needed. Scenario (worst): the number of parcels decreased, so 10% decrease of workers are needed. Scenario (realistic): the capacity should be increased by 5%. 24 3 1 1 7 6 25 6 26 O 0 0 2717 8 6 28 2 4 3 29 12 9 11 24605 19820 30 22540 31 32 Base Case + Ready + 1009