Please show your work in excel (showing the formula), I that way I will understand where the solution come from.

JL.61 A producer of refrigerator compressors wants to implement a just-in-time production line to support demand from a neighboring appliance manufacturer. Demand from the appliance manufacturer is for 200 compressors a day. The production lead time is 1 days and the producer wants to have a 8% safety stock factor. This producer has also cut setup costs such that the optimal production quantity is 92 units. How many kanbans does this producer of compressors require? (Display your answer to the most appropriate whole number.) Nmero JL.62 Durabright wants to establish kanbans to feed a newly installed work cell for its line of LED traffic signal lamps. The daily production (demand) rate for this new family of products is 110 units. The supplier lead time for the bulb housing, used by all products in this product family, is 12 days. They want to keep 2.25 days of safety stock of this housing on hand (the safety stock factor). The kanban size for the bulb housing components is 73 units. How many kanbans do they require? (Display your answer to the most appropriate whole number.) Nmero