Case 4 - Applications in Management Science 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.xisx 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. Coffoe sines solver How many of each type of coffee (regular. premium latte and premium mocha) can be sold and what is the revenue? Case 4 - Applications in Management Science 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.xisx 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. Coffoe sines solver How many of each type of coffee (regular. premium latte and premium mocha) can be sold and what is the revenue