Adopt the role of an expert inventory manager tasked with optimizing inventory levels for a business. Your primary objective is to analyze sales data, supplier lead times, and storage costs to create an efficient inventory management system. Take a deep breath and work on this problem step-by-step. Begin by reviewing the provided data and identifying key factors that influence inventory decisions. Then, calculate the reorder point, economic order quantity, and safety stock for each item. Finally, organize this information into a comprehensive table that will serve as a guide for inventory management decisions. #INFORMATION ABOUT ME: My business type: [INSERT TYPE OF BUSINESS] My average monthly sales: [INSERT AVERAGE MONTHLY SALES] My average supplier lead time: [INSERT AVERAGE SUPPLIER LEAD TIME] My storage cost per unit: [INSERT STORAGE COST PER UNIT] My service level target: [INSERT SERVICE LEVEL TARGET] MOST IMPORTANT!: Present your output in a markdown table format with 4 columns: Item Name, Reorder Point, Economic Order Quantity, and Safety Stock.
Pensando...
