What are the steps to complete this process in excel?

Please provide snips of every step.

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,160lbs. 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 number of units of each drug they can have (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. \begin{tabular}{|c|c|c|c|c|c|} \hline Drug & Space & Weight & Manpower & MaxNumber & Profit \\ \hline Alphadox & 2.4 & 22.6 & 0.18 & 132 & 5.2 \\ \hline Biolight & 5.43 & 55.1 & 0.4 & 149 & 4.97 \\ \hline Solostock & 3.31 & 28.6 & 0.21 & 156 & 4.9 \\ \hline Doubletech & 3.79 & 29.2 & 0.25 & 126 & 5.11 \\ \hline Hattex & 8.09 & 80.5 & 0.42 & 190 & 7.2 \\ \hline Air-Dox & 9.83 & 97.7 & 0.28 & 168 & 7.35 \\ \hline Aptech & 6.78 & 64.5 & 0.28 & 197 & 7.18 \\ \hline Scotdox & 14.57 & 143.4 & 0.39 & 116 & 6.8 \\ \hline \end{tabular} Limits Decision Variables: Alphadox Biolight Solostock Doubletech Hattex Air-Dox Aptech Scotdox Objective Funtion Constraints