Please include step by step instructions on how to solve the question using analytical solver add in for excel

missing # for Scotdox size (ft2) is 14.57

Question 1 Excel worksheet W5Q1. Mistwood Pharmaceuticals produces 8 different types of drugs which must be refrigerated at all times. Due to the nature of their demand, Mistwood's demand is very irregular so they must keep a large stockpile of the drugs in their warehouse. These drugs are typically stored in refrigeration units which are unique to each drug and the product must be rotated each day within each unit, so the drugs reach their maximum shelf life. Each of these refrigeration units have a weight and size (measured in ft2) which limit how much of each drug can be stored. At the moment, Mistwood's warehouse has a size of 5,420 ft2 and can have a maximum weight of 52,160 lbs. Also, the current warehousing staffing can spend 250 hours/day rotating the drugs. The following table contains information regarding the size, weight, and manpower requirements for each refrigeration unit along with the maximum storage (i.e. they have no capacity to store more than this amount of each drug), and profit for each refrigeration unit: Mistwood wants to determine how many of each refrigeration unit of drugs should be stored in the warehouse given all of the limitations such that they achieve the maximum possible profit. Since fractional refrigeration units cannot be stored, develop, implement, and solve an integer optimization model in Excel to address Mistwood's needs. Once the model is solved, state the number of drugs stored of each refrigeration unit and the expected profit. Note: When optimizing in Excel, use Standard LP Engine. AutoSave OFF n B Home Insert Draw Page Layout Model D32 1 2 3 Formulas Data Distributions Correlations Results Decision Constraints Objective fx A B D E Drug Size (ft2) Manpower (hour) Max Storage (units) Weight (lb.) 22.6 Alphadox 2.4 0.18 132 Biolight 5.43 55.1 0.4 149 4 Solostock 3.31 28.6 0.21 156 5 Doubletech 3.79 29.2 0.25 126 6 Hattex 8.09 80.5 0.42 190 7 Air-Dox 9.83 97.7 0.28 168 - 8 Aptech 6.78 64.5 0.28 197 9 Scotdox 0.39 116 Constraints 143.4 10 11 Constraints 12 13 Decision Variables: 14 15 16 17 18 19 20 21 22 23 24 Objective Funtion 25 26 27 Constraints 28 L.H. Side Type 29 30 31 32 33 34 35 36 37 38 39 -40 41 42 Ready R.H. Side W5Q1_Pharm A W2Q2 Ranlux HW 3 (2) Review View Tell me Decision Decision Box Tree Table Function F G Profit 5.1 4.87 4.8 5.06 7.18 7.25 7.08 6.9 + Comments Reports Share P (24) Parameters Simulate Optimize Deploy Model Engine Output Tools Analytic Solver Model Platform Sensitivity Optimization Simulation Decision Data Source Input Data Model Diagnosis ModelType Unknown Variables - Functions - Dependencies Vars Fcns Dpns All N/A N/A N/A ALLA Model Type: If Unknown, press the Analyze without Solving button to diagnose the model. B E + 100%