File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum Calibri 11 AA == > a Wrap Text General TIX AY o X Cut LB Copy Format Painter Fill Paste BIU A += = 40 .00 Ideas Merge & Center Insert Delete Format Sensitivity Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity J12 =SUMPRODUCT(J5:J11,$1$5:$I$11) A B D E F G H K 1 2 3 workers Scheduled Wages per worker 4 Shift 5 1 680 705 6 2 73 705 Air-Express Days on=1, Days off=0 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,1: =SUMPRODUCT(D5:011 =SUMPRODUCT(E5:E11,1 =SUMPRODUCT(F5:F11 =SUMPRODUCT(G5:G ESUMPRODUCT(H5:H 18 27 22 26 25 21 19 705 1705 680 8 4 9 5 5 10 6 11 7 12 Available 13 Required 14 655 =SUMPRODUCT(15:11 Total 15 16 17 18 19 20 Steps Plase consderi the following scenario 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%. 21 22 23 24 25 26 27 28 29 Sheet1 + Ready + 100% File Home Insert Page Layout Formulas Data Review View Help Share Comments AutoSum Calibri 11 AA == > a Wrap Text General TIX AY o X Cut LB Copy Format Painter Fill Paste BIU A += = 40 .00 Ideas Merge & Center Insert Delete Format Sensitivity Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity J12 =SUMPRODUCT(J5:J11,$1$5:$I$11) A B D E F G H K 1 2 3 workers Scheduled Wages per worker 4 Shift 5 1 680 705 6 2 73 705 Air-Express Days on=1, Days off=0 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,1: =SUMPRODUCT(D5:011 =SUMPRODUCT(E5:E11,1 =SUMPRODUCT(F5:F11 =SUMPRODUCT(G5:G ESUMPRODUCT(H5:H 18 27 22 26 25 21 19 705 1705 680 8 4 9 5 5 10 6 11 7 12 Available 13 Required 14 655 =SUMPRODUCT(15:11 Total 15 16 17 18 19 20 Steps Plase consderi the following scenario 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%. 21 22 23 24 25 26 27 28 29 Sheet1 + Ready + 100%