How much of each panel type should be ordered and what is the profit? How many of each type of coffee (regular. premium latte and premium mocha) can be sold and what is the revenue? Note: The warehouse has a limited storage capacity of 50000 cubic meters (m3). How much of each product should be ordered and what is the total cost? 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