How do you solve this using excel solver?

Question 1 (Adapted from Exercise 7.7 in DMD, 50 points): The Jordan Alloy Corporation produces alloys for aircraft construction. They manufacture four different alloys, denoted W,X, Y, and Z, from three basic metals, namely aluminum, copper, and magnesium. The contribution to earnings of these alloys are $35,$47,$60, and $140 per ton, respectively, for each of the four alloys W,X,Y, and Z. The monthly supplies of aluminum, copper, and magnesium are 600 , 400 , and 800 tons per month, respectively. The proportion of the metals in the alloys are shown in the following table. For example, one ton of alloy W consists of 0.30 tons of aluminum, 0.30 tons of copper, and 0.40 tons of magnesium. Note that the numbers in each column sum to one. The company believes that they can sell all of the alloys that they produce. The objective is to maximize the contribution to earnings. Answer the following 5 questions. a) (10 points) Define all the decision variables that you will use in your linear program. Enter your answer in Excel template file in the corresponding cells for part a). b) (10 points) Write the formula for the objective function in terms of the decision variables that you have defined in part a). Enter your answer in Excel template file in the corresponding cells for part b). NOTE: This should NOT be an Excel formula. It should be written in English using the variables that you have defined. For example, if you use the decisions AW,AX,AY, and AZ to denote the amount of each alloy that the company produces in part a), your objective would be "Maximize (35XAW)+(47xAX)+(60xAW)+ (140xAZ). c) (10 points) Write all the constraints of the linear program in terms of the decision variables that you have defined in part a). Enter your answer in Excel template file in the corresponding cells for part c). d) (10 points) Enter the decision variables, objective function, and constraints into your Solver. e) (10 points) What is the optimal production quantity of each alloy? What is the optimal contribution to earnings