QUESTION:

Please fill up the green marked boxes with appropriate amount of delivery amounts for FernFuel and NadeshikoTech. For Taegeuk Nangja and Matildas already done here.

The necessary information are as below:

Suppliers may have differing batch sizes and delivery requirements, ie monthly / fortnightly etc. These impact on the ordering costs, receival costs and total holding costs.

SPARKi (a data projector company) plans to maintain a standard base level of safety stock inventory for the data projectors. Due to varying material pipelines, SPARKi expects to maintain an amount of safety stock as below:

• Monthly. Safety stock equivalent to the next 28 days ie, for a monthly shipment where the following 28 calendar days estimated usage is 60,000, then by the next delivery the stock should be no lower than 60,000 units. Safety stock for each supplier should be increased based on the company's on-time delivery record.
• Fortnightly. Safety stock for equivalent to 21 calendar days stock ie, if lead time is two weeks and the following 21 calendar days production is expected to be 35,000 units, then by the next delivery the stock should be no lower than 35,000 units. Safety stock for each supplier should be increased based on the company's on-time delivery record.
• Daily. Safety stock will be an absolute minimum of 10,000 units safety stock

you have less than the mnmum level ot satety steek(shows in the "Stock" column as red when you are low)