A B C D E F G H K L M N O V W X Inventory Analysis Batch Size 10,000 Batch Size 4,000 Batch Size 20,000 Batch Size Frequency Four Weekly Frequency Fortnightly Frequency Monthly Frequency Week Days On-Time Delivery 98.00% On-Time Delivery 93.50% On-Time Delivery 95.50% On-Time Delivery 99.95% OUIAWN Daily Monthly Fortnightly Daily Taegeuk Nangja FernFuel Nadeshiko Tech Matildas 7 D:- Date Producti- Minimur Minimur - Minimur ~ |Minimy - Delive - Stock ~ |Minimy Delive - Stock -|Minimu ~ Delive - Stock - |Minimy Delive Stock 8 Mon 1-Jan-24 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 20,000 9 Tue 2-Jan-24 50 20,000 20,000 20,000 19,950 19,950 19,950 19,950 10 Wed 3-Jan-24 100 19,950 19,950 19,950 19,850 19,850 19,850 19,850 11 Thu 4-Jan-24 150 19,850 19,850 19,850 19,700 19,700 19,700 19,700 12 Fri 5-Jan-24 200 19,700 19,700 19,700 19,500 19,500 19,500 19,500 13 6-Jan-24 19,500 19,500 19,500 19,500 19,500 19,500 19,500 14 Sun 7-Jan-24 19,500 19,500 19,500 19,500 19,500 19,500 19,500 15 Mon 8-Jan-24 250 19,500 19,500 19,500 19,250 19,250 19,250 19,250 16 Tue 9-Jan-24 300 19,250 19,250 19,250 18,950 18,950 18,950 18,950 17 Wed 10-Jan-24 350 18,950 18,950 18,950 18,600 18,600 18,600 18,600 18 Thu 11-Jan-24 400 18,600 18,600 18,600 18,200 18,200 18,200 18,200 19 Fri 12-Jan-24 450 18,200 18,200 18,200 17,750 17,750 17,750 17,750 20 Sat 13-Jan-24 17,750 17,750 17,750 17,750 17,750 17,750 17,750 21 Sun 14-Jan-24 17,750 17,750 17,750 17,750 17,750 17,750 17,750 22 Mon 15-Jan-24 450 17,750 17,750 17,750 17,300 17,300 17,300 17,300 23 Tue 16-Jan-24 550 17,300 17,300 17,300 16,750 16,750 16,750 16,750 24 Wed 17-Jan-24 650 16,750 16,750 16,750 16,100 16,100 16,100 16, 100 25 Thu 18-Jan-24 750 16,100 16, 100 16, 100 15,350 15,350 15,350 15,350 26 Fri 19-Jan-24 350 15,350 15,350 15,350 14,500 14,500 14,500 14,500 27 Sat 20-Jan-24 14,500 14,500 14,500 14,500 14,500 14,500 14,500 28 Sun 21-Jan-24 14,500 14,500 14,500 14,500 14,500 14,500 14,500 29 Mon 22-Jan-24 900 14,500 14,500 14,500 13,600 13,600 13,600 13,600 30 Tue 23-Jan-24 900 13,600 13,600 13,600 12,700 12,700 12,700 12,700 31 Wed 24-Jan-24 900 12,700 12,700 12,700 11,800 11,800 11,800 11,800 32 Thu 25-Jan-24 900 11,800 11,800 11,800 10,900 10,900 10,900 10,900A B C D E F G H J K L M N O V W X Inventory Analysis Batch Size 10,000 Batch Size 4,000 Batch Size 20,000 Batch Size Frequency Four Weekly Frequency Fortnightly Frequency Monthly Frequency Week Days On-Time Delivery 98.00% On-Time Delivery 93.50% On-Time Delivery 95.50% On-Time Delivery 99.95% OURWN Daily Monthly Fortnightly Daily Taegeuk Nangja FernFuel 7 D: - Date Nadeshiko Tech Producti- Minimur ~ Matildas Minimur Minimur - Minimy ~|Delive - Stock - Minimu- Delive - Stock - Minimu - 32 Thu 25-Jan-24 Delive - Stock - 900 Minimu - 11,800 11,800 Delive - Stock 11,800 10,900 10,900 33 Fri 26-Jan-24 10,900 900 10,900 10,900 10,900 10,900 10,000 10,000 34 Sat 27-Jan-24 10,000 10,000 10,000 10,000 10,000 10,000 10,000 35 Sun 28-Jan-24 10,000 10,000 10,000 10,000 10,000 10,000 10,000 36 Mon 29-Jan-24 10,000 500 18,182 13,636 10,000 10,000 18,553 50,000 59,500 14,584 9,500 37 Tue 30-Jan-24 19,039 9,500 500 10,000 500 18,182 13,636 10,000 10,000 18,553 59,000 14,584 9,000 19,039 38 Wed 31-Jan-24 9,000 500 10,000 13,636 500 18,182 10,000 10,000 18,553 58,500 14,584 8,500 39 19,039 Thu 1-Feb-24 8,500 18,925 10,000 500 1,000 13,636 10,000 10,000 19,311 57,500 14,584 7,500 40 19,817 Fri 2-Feb-24 7,500 10,000 1,000 1,000 19,668 10,000 13,636 10,000 20,069 56,500 14,584 6,500 20,595 41 Sat 3-Feb-24 6,500 10,000 20,411 1,000 12,727 10,000 10,000 20,828 56,500 13,612 5,500 42 Sun 4-Feb-24 21,373 6,500 22,063 10,000 13,636 10,000 10,000 22,514 56,500 14,584 5,500 43 Mon 5-Feb-24 23,103 1,000 23,715 6,500 10,000 13,636 10,000 10,000 24,199 65,500 14,584 5,500 24,833 44 Tue 6-Feb-24 5,500 10,000 1,000 1,000 24,458 12,727 10,000 10,000 24,958 54,500 13,612 4,500 45 Wed 7-Feb-24 25,611 25,202 4,500 1,000 12,727 10,000 1,000 10,000 25,716 10,000 53,500 13,612 3,500 26,389 46 3,500 Thu 8-Feb-24 1,000 10,000 25,945 12,727 1,000 10,000 10,000 26,474 52,500 13,612 2,500 27,167 47 Fri 9-Feb-24 2,500 10,000 1,000 25,036 13,470 1,000 10,000 25,547 10,000 51,500 14,407 1,500 48 Sat 10-Feb-24 26,215 1,500 24,126 14,213 10,000 1,000 10,000 10,000 24,619 51,500 15,202 1,500 25,263 49 Sun 11-Feb-24 1,500 10,000 25,779 15,866 10,000 10,000 26,305 51,500 16,969 1,500 26,993 50 Mon 12-Feb-24 1,500 10,000 1,000 27,431 15,866 10,000 10,000 27,991 50,500 16,969 500 51 500 Tue 13-Feb-24 28,723 10,000 1,000 1,000 28,174 14,957 10,000 10,000 28,749 49,500 15.996 500 52 Wed 14-Feb-24 29,501 500 10,000 1,000 28,917 15,700 1,000 10,000 29,507 10,000 48,500 16,791 1,500 30,280 53 Thu 15-Feb-24 1,500 10,000 1,000 10,000 1,000 29,660 16,443 10,000 30,265 47,500 17,586 2,500 31,058 54 Fri 16-Feb-24 2,500 10,000 1,000 28,751 1,000 17,186 10,000 10,000 29,338 46,500 18,381 55 3,500 Sat 17-Feb-24 30,106 3,500 27,842 10,000 1,000 17,929 28,410 10,000 10,000 46,500 19,175 56 Sun 18-Feb-24 3,500 29,154 3,500 29,494 19,581 10,000 10,000 10,000 30,096 46,500 20,942 3,500 30,884 3,500 10,000 10,000H K Inventory Analysis Batch Size 10,000 Batch Size 4,000 Batch Size 20,000 Batch Size Frequency Four Weekly Frequency Fortnightly Frequency Monthly Frequency Week Days On-Time Delivery 98.00% On-Time Delivery 93.50% On-Time Delivery 95.50% On-Time Delivery 99.95% Daily Monthly Fortnightly Daily Taegeuk Nangja FernFuel Nadeshiko Tech Matildas 7 D: - Date Producti- Minimur Minimur - Minimur ~ Minimu - Delive - Stock Minimu - Delive - Stock - Minimy Delive - Stock - Minimu - Delive - Stock 56 Sun 18-Feb-24 29,494 19,581 10,000 30,096 46,500 20,942 3,500 30,884 3,500 10,000 10,000 57 Mon 19-Feb-24 1,000 31,146 19,581 10,000 31,782 45,500 20,942 4,500 32,614 4,500 10,000 1,000 10,000 Tue 20-Feb-24 1,000 31,889 18,672 10,000 32,540 14,500 19,970 5,500 33,392 5,500 10,000 1,000 10,000 Wed 21-Feb-24 1,000 32,632 19,415 10,000 33,298 43,500 20,765 6,500 34,170 6,500 10,000 1,000 10,000 60 Thu 22-Feb-24 1,000 33,375 20,158 10,000 34,057 42,500 21,559 7,500 34,948 7,500 10,000 1,000 10,000 61 Fri 23-Feb-24 1,000 32,466 20,901 10,000 33,129 41,500 22,354 8,500 33,996 8,500 10,000 1,000 10,000 62 Sat 24-Feb-24 31,557 21,644 10,000 32,201 41,500 23,149 8,500 33,044 8,500 10,000 10,000 63 Sun 25-Feb-24 33,209 23,296 10,000 33,887 41,500 24,916 8,500 34,774 8,500 10,000 10,000 64 Mon 26-Feb-24 1,000 34,862 23,296 10,000 35,573 50,000 90,500 24,916 9,500 36,504 9,500 10,000 1,000 10,000 65 Tue 27-Feb-24 1,000 35,605 22,387 10,000 36,331 89,500 23,944 10,500 37,282 10,500 10,000 1,000 10,000 66 Wed 28-Feb-24 1,000 36,348 23,130 10,000 37,090 88,500 24,738 11,500 38,061 11,500 10,000 1,000 10,000 67 Thu 29-Feb-24 1,000 36,348 23,130 10,000 37,090 87,500 24,738 12,500 38,061 12,500 10,000 1,000 10,000 68 Fri 1-Mar-24 1,000 34,696 23,130 10,000 35,404 86,500 24,738 13,500 36,331 13,500 10,000 1,000 10,000 69 Sa 2-Mar-24 33,043 23,130 10,000 33,718 86,500 24,738 13,500 34,601 13,500 10,000 10,000 70 Sun 3-Mar-24 35,377 24,783 10,000 36,099 86,500 26,505 13,500 37,044 13,500 10,000 10,000 71 Mon 4-Mar-24 1,652 37,710 24,783 10,000 38,480 84,848 26,505 15,152 39,487 15, 152 10,000 1,652 10,000 72 Tue 5-Mar-24 1,652 38,391 23,130 10,000 39,175 83,196 24,738 16,804 40,200 16,804 10,000 1,652 10,000 73 Wed 6-Mar-24 1,652 39,072 23,130 10,000 39,870 81,543 24,738 18,457 40,914 18,457 10,000 1,652 10,000 74 Thu 7-Mar-24 1,652 39,754 23,130 10,000 40,565 79,891 24,738 20,109 41,627 20,109 10,000 1,652 10,000 75 Fri 8-Mar-24 1,652 38, 101 23,130 10,000 38,879 78,239 24,738 21,761 39,897 21,761 10,000 1,652 10,000 76 Sat 9-Mar-24 36,449 23,130 10,000 37,193 78,239 24,738 21,761 38,167 21,761 10,000 10,000 77 Sun 10-Mar-24 38,783 24,783 10,000 39,574 78,239 26,505 21,761 40,610 21,761 10,000 10,000 78 Mon 11-Mar-24 1,652 41,116 24,783 10,000 41,955 76,587 26,505 23,413 43,053 23,413 10,000 1,652 10,000 79 Tue 12-Mar-24 1,652 41,797 23,130 10,000 42,650 74,935 24,738 25,065 43,767 25,065 10,000 1,652 10,000 80 Wed 13-Mar-24 1,652 42,478 23,812 10,000 43,345 73,283 25,467 26,717 44,480 26,717 10,000 1,652 10,000A B C D E F G H K L M N O V W X Inventory Analysis Batch Size 10,000 Batch Size 4,000 Batch Size 20,000 Batch Size No Frequency Four Weekly Frequency Fortnightly Frequency Monthly Frequency Week Days On-Time Delivery 98.00% On-Time Delivery 93.50% On-Time Delivery 95.50% On-Time Delivery 99.95% Daily Monthly Fortnightly Daily Taegeuk Nangja FernFuel Nadeshiko Tech Matildas 7 D: - Date Producti- Minimur ~ Minimur Minimur Minimu - Delive Stock - Minimu - Delive Stock - Minimu~ Delive Stock - Minimu ~ Delive - Stock 78 Mon 11-Mar-24 1,652 41,116 24,783 10,000 41,955 76,587 26,505 23,413 43,053 23,413 10,000 1,652 10,000 79 Tue 12-Mar-24 1,652 41,797 23,130 10,000 42,650 74,935 24,738 25,065 43,767 25,065 10,000 1,652 10,000 80 Wed 13-Mar-24 1,652 42,478 23,812 10,000 43,345 73,283 25,467 26,717 44,480 26,717 10,000 1,652 10,000 81 Thu 14-Mar-24 1,652 43,159 24,493 10,000 44,040 71,630 26,195 28,370 45,193 28,370 10,000 1,652 10,000 82 Fri 15-Mar-24 1,652 41,507 25,174 10,000 42,354 69,978 26,924 30,022 43,463 30,022 10,000 1,652 10,000 83 Sat 16-Mar-24 39,855 25,855 10,000 40,668 69,978 27,652 30,022 41,733 30,022 10,000 10,000 84 Sun 17-Mar-24 42,188 28,188 10,000 43,049 69,978 30,148 30,022 44,176 30,022 10,000 10,000 85 Mon 18-Mar-24 1,652 44,522 28,188 10,000 45,430 68,326 30,148 31,674 46,620 31,674 10,000 1,652 10,000 86 Tue 19-Mar-24 1,652 45,203 26,536 10,000 46,125 66,674 28,381 33,326 47,333 33,326 10,000 1,652 10,000 87 Wed 20-Mar-24 1,652 45,884 27,217 10,000 46,820 65,022 29,110 34,978 48,046 34,978 10,000 1,652 10,000 88 Thu 21-Mar-24 1,652 46,565 27,899 10,000 47,516 63,370 29,838 36,630 48,759 36,630 10,000 1,652 10,000 89 Fri 22-Mar-24 1,652 44,913 28,580 10,000 45,830 61,717 30,567 38,283 47,029 38,283 10,000 1,652 10,000 90 Sat| 23-Mar-24 43,261 29,261 10,000 44,144 61,717 31,295 38,283 45,299 38,283 10,000 10,000 91 Sun 24-Mar-24 45,594 31,594 10,000 46,525 61,717 33,791 38,283 47,743 38,283 10,000 10,000 92 Mon 25-Mar-24 1,652 47,928 31,594 10,000 48,906 50,000 110,065 33,791 39,935 50,186 39,935 10,000 1,652 10,000 93 Tue 26-Mar-24 1,652 48,609 29,942 10,000 49,601 108,413 32,024 41,587 50,899 41,587 10,000 1,652 10,000 94 Wed 27-Mar-24 1,652 49,290 30,623 10,000 50,296 106,761 32,752 43,239 51,612 43,239 10,000 1,652 10,000 95 Thu 28-Mar-24 1,652 49,971 31,304 10,000 50,991 105,109 33,481 44,891 52,326 44,891 10,000 1,652 10,000 96 Fri 29-Mar-24 1,652 48,319 31,986 10,000 49,305 103,457 34,209 46,543 50,596 46,543 10,000 1,652 10,000 97 Sat 30-Mar-24 46,667 32,667 10,000 47,619 103,457 34,938 46,543 48,866 46,543 10,000 10,000 98 Sun 31-Mar-24 49,000 35,000 10,000 50,000 103,457 37,433 46,543 51,309 46,543 10,000 10,000 99 Mon 1-Apr-24 1,652 51,500 35,000 10,000 52,551 101,804 37,433 48, 196 53,927 48, 196 10,000 1,652 10,000 100 Tue 2-Apr-24 2,227 51,667 32,667 10,000 52,721 99,577 34,938 50,423 54,101 50,423 10,000 2,227 10,000 101 Wed 3-Apr-24 2,227 51,833 32,667 10,000 52,891 97,350 34,938 52,650 54,276 52,650 10,000 2,227 10,000 102 Thu 4-Apr-24 2,227 52,000 32,667 10,000 53,061 95,123 34,938 54,877 54,450 54,877 10,000 2,227 10,000This template requires the A team to determine the Inventory Analysis Buch Bure 18,031 Butch Bare 4 010 Baich Birm 34, Due Butch Sire initial view of inventory Fatnightly Du-Time Dilvery Monthly Work Day On-Times Dilkory replenishment. SPARKi requires 20,000 units on - 20 000 20 030 50 20.900 the 1st January 2024, and 19 950 19 950 19 950 50 20 020 19 050 200 19 TOO then replenishment 19 TOO 19 530 500 800 19 800 19 809 19 800 500 depending upon the 750 19 600 17 WE 1050 18 050 supplier delivery schedule 18 18 690 1 450 18 090 19 10 200 10 200 18 200 1 80U in the batch sizes as - 2.260 2 250 17 750 21 17 750 22 MY 17 350 17 750 17 750 2 250 THO 17 750 tendered. The template 1700 17 400 17 400 24 1 17-Im-24 3.250 25 Trul 18 190 16 750 has been set up defining 16 100 16 100 10 190 27 18 450 18 450 5.500 14 890 the minimum safety stock 14800 4 600 14 600 5.500 6 630 14 600 30 Tus requirements for daily, 12 700 7:300 12 TOO 2 mo 12 706 .209 fortnightly and monthly 343 10 909 10 900 10 900 10 090 10 050 10 000 10 010 10 090 10 090 10 000 10 000 10 005 deliveries, adjusted for 10:090 10 0RD 107000 10 030 10 080 10 0D 1060 500 suppliers delivery 10 0 10 090 10 0 2:140-24 1 000 19 817 10 0 performance. The GHOST 10 00 101000 10 090 42 8 4 Fc0-24 101009 22.4.29 10 80 13.580 delivery days have been 1070 20 100 ETOOO 10 090 44 Tur 6 FOO 24 12 327 25 068 54 600 10 0no 151540 26 671 10 020 15 604 10 080 10200 highlighted in green. 12 727 47 6 1 0-24 52 500 17.500 15 70 10 0OP 17 506 10 080 10 580 20 215 1000 51 500] 10 509 10 090 18 500 0 000 24.440 18 506 10 040 100 10.530 10 080 10 600 10 090 1700 Taegeuk Nangja and 61 TUG 13 FC0 24 20 174 9.500 19 500 10 00 10 080 201540 10 0 10 090 41.509 10 00 47 50U 10 020 Matildas have already 29 AM THO 231 509 10 020 been completed by 29 041 19 8451 10 000 28 500 40 800 21085 10 030 23.540 30 81 64 TUG 20 FC0 24 10 40 #07000 10 090 1009 1500 181672 10 005 32.707 34 500 44 600 10 080 another member in your 10 40 10 000 10 02p team. You need to complete for FerFuel and Nadeshike Tech to ensure that at no time do you have less than the minimum level of safety stock (shows in the "Stock" column as red when you are low)