EOQ Analysis for Multiple Product Categories
📄 Prompt Template
For [CompanyName], calculate the economic order quantity (EOQ) for multiple product categories ([ProductCategory1], [ProductCategory2], and [ProductCategory3]). For each product category, consider:
Annual demand for each category ([AnnualDemandProductCategory1], [AnnualDemandProductCategory2], [AnnualDemandProductCategory3])
Ordering cost ([OrderingCostCategory1], [OrderingCostCategory2], [OrderingCostCategory3])
Holding cost per unit ([HoldingCostCategory1], [HoldingCostCategory2], [HoldingCostCategory3])
Provide a comparative analysis of the EOQ across these categories and make recommendations for optimizing inventory management strategies for each category.