Spreadsheet: 844296d1696008753-some-excel-tasks-forecast-and-demand-tasks
Sheet: Zad.6

Zad.6 | In the table below, the daily projection of inventory by material index is shown.
a) | Seeing shortages appearing, which indexes and in what number of full pallets would you order(s) if you can only order 10 pallets?
b) | By when will we have our demand covered after ordering 10 such pallets?
Index | Quantity per pallet | 2021-10-05 00:00:00 | 2021-10-06 00:00:00 | 2021-10-07 00:00:00 | 2021-10-08 00:00:00 | 2021-10-09 00:00:00 | 2021-10-10 00:00:00 | 2021-10-11 00:00:00 | 2021-10-12 00:00:00 | 2021-10-13 00:00:00 | 2021-10-14 00:00:00 | 2021-10-15 00:00:00 | 2021-10-16 00:00:00
36150 | 240000 | 78400 | 78400 | 78400 | 22977 | 22977 | 22977 | 22977 | 22977 | 6899.000000000005 | -5088.999999999995 | -5088.999999999995 | -5088.999999999995
36313 | 150000 | 126770 | 126770 | 126770 | 126770 | 125251 | 66079 | 55641.99999999999 | 55641.99999999999 | 55641.99999999999 | 55641.99999999999 | 20041.99999999999 | -39130
36306 | 150000 | 137550 | 137550 | 137550 | 137550 | 137550 | 137550 | -587.9999999999939 | -176832 | -176832 | -580451.9999999999 | -580451.9999999999 | -580451.9999999999
36161 | 105000 | 291317 | 291317 | 291317 | 96025.99999999999 | 96025.99999999999 | 96025.99999999999 | 96025.99999999999 | 96025.99999999999 | 77449.99999999999 | 8371.999999999985 | -100172 | -130397
36163 | 105000 | 64518 | 64518 | 64518 | 64518 | 64518 | 64518 | 27584 | -1363.000000000003 | -1363.000000000003 | -1363.000000000003 | -1363.000000000003 | -1363.000000000003
36164 | 105000 | 171191 | 171191 | 171191 | 309980 | 301667.0000000001 | 254695.0000000001 | 170553.0000000001 | 23485.00000000007 | -4135.999999999928 | -4135.999999999928 | -4135.999999999928 | -4135.999999999928
36171 | 70986 | 179499 | 179499 | 179499 | 179499 | 160244 | 94511 | 28764 | -36969.00000000001 | -36969.00000000001 | -86237 | -86237 | -86237
36317 | 70986 | 353448 | 353448 | 353448 | 320347.9999999999 | 267949.9999999999 | 141186.9999999999 | 104039.9999999999 | 104039.9999999999 | 104039.9999999999 | 104039.9999999999 | 59948.99999999993 | -5784.00000000007
36174 | 70986 | 75945 | 75945 | 75945 | 6875 | 6875 | 6875 | 6875 | 6875 | -12295 | -37003 | -37003 | -37003
36183 | 42000 | 3584 | 3584 | 3584 | 3584 | 3584 | 3584 | 3584 | 3584 | 3584 | 3584 | 3584 | -18189
36185 | 93000 | 43250 | 43250 | 43250 | 43250 | 43250 | 43250 | 43250 | -154225 | -154225 | -324326 | -324326 | -324326
36294 | 96000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -48537
36347 | 70990 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -45782 | -92614 | -92614
42394 | 105000 | 60400 | 60400 | 60400 | 60400 | 60400 | 60400 | 60400 | 60400 | 60400 | 17581 | -36550.00000000001 | -36550.00000000001
42395 | 105000 | 59650 | 59650 | 59650 | 59650 | 59650 | 59650 | 59650 | 59650 | 38453.99999999999 | -35067.00000000001 | -35067.00000000001 | -35067.00000000001
42396 | 105000 | 37430 | 37430 | 37430 | 37430 | 37430 | 37430 | 37430 | 37430 | 37430 | 37430 | -61622.00000000001 | -92518
42397 | 105000 | 65950 | 65950 | 65950 | 65950 | 65950 | 65950 | 65950 | 65950 | 65950 | 65950 | 32678 | -593.9999999999941
42398 | 105000 | 22480 | 22480 | 22480 | 22480 | 22480 | 22480 | 22480 | 22480 | 22480 | 22480 | -54101.99999999999 | -54101.99999999999
42399 | 68108 | 52530 | 52530 | 52530 | 52530 | 52530 | 52530 | 52530 | 52530 | 32546 | -35968.00000000001 | -66419.00000000001 | -66419.00000000001
42400 | 68108 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | 6600 | -18617 | -46262.00000000001 | -46262.00000000001
42401 | 68108 | 39610 | 39610 | 39610 | 39610 | 39610 | 39610 | 39610 | 39610 | 15893 | -27404 | -27404 | -27404
36401 | 93000 | 57198 | 57198 | 57198 | 57198 | 57198 | 57198 | 57198 | 57198 | 57198 | -46369.00000000001 | -198466 | -198466
36413 | 93000 | 0 | 0 | 0 | 373916 | 373916 | 373916 | 373916 | 373916 | 300552 | 147818 | -17164.99999999996 | -28794.99999999997
36395 | 70986 | 2302 | 2302 | 2302 | 2302 | 2302 | 2302 | 2302 | 2302 | 2302 | 2302 | 2302 | -19609
36396 | 150000 | 35012 | 35012 | 35012 | -8453.999999999993 | -8453.999999999993 | -8453.999999999993 | -8453.999999999993 | -8453.999999999993 | -8453.999999999993 | -8453.999999999993 | -8453.999999999993 | -8453.999999999993
36397 | 150000 | 233217 | 233217 | 233217 | 108854 | 108854 | 108854 | 108854 | 108854 | 103912 | -5612.000000000024 | -42049.00000000002 | -42049.00000000002
36373 | 93000 | 5900 | 5900 | 5900 | -60764 | -60764 | -60764 | -60764 | -60764 | -60764 | -60764 | -60764 | -60764
36364 | 105000 | 4450 | 4450 | 4450 | -47354 | -47354 | -47354 | -47354 | -47354 | -47354 | -47354 | -47354 | -47354
36375 | 96000 | 57460 | 57460 | 57460 | 133.0000000000027 | -15031 | -15031 | -15031 | -15031 | -15031 | -180371.9999999999 | -180371.9999999999 | -180371.9999999999
36403 | 105000 | 107298 | 107298 | 107298 | 63505 | 63505 | 63505 | 63505 | 63505 | 63505 | 63505 | 51321.00000000001 | -2354.999999999997