Spreadsheet: 65095d1265840159-generate-sheet-by-number-of-hours-on-shift-hb-work-load-plan
Sheet: Daily plan

Date | 2010-02-10 00:00:00
Hour | Unload | Vol | Receive | Vol | Putaway | Vol | Replen R | Vol | Replen P | Vol | Housekeeping | Picking | Vol | Nil stock | Packing | Vol | CEVA | QC | [NAME] | OLS | Box | Batch | Despatch | Vol | CAGE
6am to 7am | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 | 0.2050178571428571 | 2.255196428571429 | 0.179390625 | 2.87025 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
7am to 8am | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 | 0.2050178571428571 | 2.255196428571429 | 0.179390625 | 2.87025 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
8am to 9am | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
9am to 10am | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
10am to 11am | 0.06962084673097535 | 64.95625 | 0.3608680555555556 | 64.95625 | 0.3093154761904762 | 64.95625 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
11am to 12am | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
12am to 1pm | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
1pm to 2pm | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 | 0.2050178571428571 | 2.255196428571429 | 0.179390625 | 2.87025 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
2pm to 3pm | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
3pm to 4pm | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
4pm to 5pm | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
5pm to 6pm | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 | 0.2050178571428571 | 2.255196428571429 | 0.179390625 | 2.87025 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
6pm to 7pm | 0.06962084673097535 | 64.95625 | 0.3608680555555556 | 64.95625 | 0.3093154761904762 | 64.95625 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 | 0.89 | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
7pm to 8pm | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 | 1 | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
8pm to 9pm | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
9pm to 10pm | 0.1392416934619507 | 129.9125 | 0.7217361111111111 | 129.9125 | 0.6186309523809523 | 129.9125 |  | 0 |  | 0 | 0.2255196428571429 | 2.255196428571429 | 126.291 | 0.4510392857142858 | 3.006928571428571 | 126.291 |  | 1.002309523809524 | 0.3006928571428572 | 0.6013857142857143 | 0.6013857142857143 | 0.5011547619047619 | 0.6013857142857143 | 137.1159428571429 | 0.3758660714285715
Total | 2.08862540192926 | 1948.687499999999 | 10.82604166666667 | 1948.687499999999 | 9.279464285714285 | 1948.687499999999 | 0.8200714285714286 | 9.020785714285715 | 0.7175625 | 11.481 | 3.608314285714286 | 36.08314285714287 | 2020.656 | 7.216628571428572 | 48.11085714285715 | 2020.655999999999 | 1.89 | 16.03695238095238 | 4.811085714285714 | 9.622171428571429 | 9.622171428571429 | 8.018476190476191 | 9.622171428571429 | 2193.855085714286 | 6.013857142857145
 | 933 |  | 180 |  | 210 |  | 11 |  | 16 |  |  | 56 |  |  | 42 |  |  |  |  |  |  |  | 228
Earlies Full time heads | 20 |  |  |  |  |  |  |  |  | Shift | Picked | Packed | Replen R | Replen P
Lates Full time heads | 21 |  |  |  |  |  |  |  |  | Earlies | 1010.328 | 1010.328 | 6.765589285714286 | 8.61075
Hour | Heads needed per hour | Short | Part timers | Returns heads | [NAME] |  |  |  |  | Lates | 1010.328 | 1010.328 | 2.255196428571429 | 2.87025
6am to 7am | 10.78457200100163 | 9.215427998998369 |  |  | 9.215427998998369 |  |  |  |  | Total | 2020.656 | 2020.655999999999 | 9.020785714285715 | 11.481
7am to 8am | 10.78457200100163 | 9.215427998998369 |  |  | 9.215427998998369
8am to 9am | 10.40016351885878 | 9.599836481141224 |  |  | 9.599836481141224 |  |  |  |  | Volume | Kpi | Heads Required | Hours in the plan | Var +/-
9am to 10am | 10.40016351885878 | 9.599836481141224 | 7 |  | 16.59983648114122 |  |  |  | Goods in | 0
10am to 11am | 9.660359140381768 | 10.33964085961823 | 7 |  | 17.33964085961823 |  |  |  | Tipping | 2078.6 | 933 | 2.227867095391211 | 2.08862540192926 | -0.1392416934619507
11am to 12am | 10.40016351885878 | 9.599836481141224 | 7 |  | 16.59983648114122 |  |  |  | Processing | 2078.6 | 180 | 11.54777777777778 | 10.82604166666667 | -0.7217361111111096
12am to 1pm | 10.40016351885878 | 9.599836481141224 | 7 |  | 16.59983648114122 |  |  |  | Putaway | 2078.6 | 210 | 9.898095238095237 | 9.279464285714285 | -0.6186309523809523
1pm to 2pm | 10.78457200100163 | 9.215427998998369 | 7 |  | 16.21542799899837 |  |  |  | [NAME] R | 22.962 | 28 | 0.8200714285714286 | 0.8200714285714286 | 0
2pm to 3pm | 10.40016351885878 | 10.59983648114122 | 3 |  | 13.59983648114122 |  |  |  | Replens P | 22.962 | 32 | 0.7175625 | 0.7175625 | 0
3pm to 4pm | 10.40016351885878 | 10.59983648114122 | 3 |  | 13.59983648114122 |  |  |  | Goods Out |  |  |  |  |  | Orders
4pm to 5pm | 10.40016351885878 | 10.59983648114122 | 3 |  | 13.59983648114122 |  |  |  | Picking | 1262.91 | 56 | 22.55196428571429 | 36.08314285714287 | 13.53117857142859 | #N/A
5pm to 6pm | 10.78457200100163 | 10.21542799899837 | 3 |  | 13.21542799899837 |  |  |  | Packing | 1262.91 | 42 | 30.06928571428572 | 48.11085714285715 | 18.04157142857143 | #N/A
6pm to 7pm | 10.55035914038177 | 10.44964085961823 | 5 |  | 15.44964085961823 |  |  |  | Despatch | 705.8793418526138 | 140 | 5.041995298947242 | 9.622171428571429 | 4.580176129624187
7pm to 8pm | 11.40016351885878 | 9.599836481141224 | 5 |  | 14.59983648114122 |  |  |  | Ceva | 21.37507430561868 | 15 | 1.425004953707912 | 1.89 | 0.464995046292088
8pm to 9pm | 10.40016351885878 | 10.59983648114122 | 5 |  | 15.59983648114122 |  |  |  |  | 0
9pm to 10pm | 10.40016351885878 | 10.59983648114122 | 5 |  | 15.59983648114122 |  |  |  |  | Items | Orders | Items per order
 |  |  |  |  |  |  |  |  | Buffer | 757.7459999999994 | #N/A | 0
 |  |  |  |  | Hours for SLA |  |  |  | 10
 |  |  |  |  | Hours Goods in is open |  |  |  | 16