Case 4 - Applications in Management Science Exchange Password Required Enter your password for "zaj5" in Internet Accounts. Objective Apply mathematical optimization to product mix and warehouse capacity decisions Overview You are a production manager for different businesses. You are asked to identify the strategies for allocating raw materials to achieve the most sales or profit. Techniques Covered - Linear programming (Excel Solver) - EOQ Workbook Required - InventoryBook.xlsx Tasks/Analysis - Add solver to the workbook - Create constraints and use solver to calculate the answers in each tab in the workbook. - Identify the best production strategy for each tab in the workbook